Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
PNC Financial Services Group Inc. (The) logo

PNC Financial Services Group Inc. (The)

Sector: Financial Services   

Industry: Banks - Regional - US

158.06
 
USD
  
0.45
  
(0.29%)
Optionable: Yes  Market Cap: 62,699 M  90-day average vol: 2,098,533

Previous close: 157.61  Open: 156.17  Bid: 157.25  Ask: 158.06
52 week range    
109.40   
   162.24
Peers   
RF / 
WFC / 
KEY / 
FITB / 
JPM / 
Last updated: Thursday 25th April 2024
63
MarketXLS Rank
75
Value
61
Technical
55
Quality

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Financials

PNC Cash Flow

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
(Increase) Decrease in other current assets3,405 M344 M2,164 M-2,746 M-196 M850 M-351 M-342 M-263 M597 M
(Increase) Decrease in other working capital-206 M-511 M-439 M100 M340 M32 M-341 M684 M-194 M831 M
Acquisitions-1,342 M75 M-10,511 M
AmortizationOfFinancingCostsAndDiscounts-372 M305 M105 M53 M323 M
Cash at beginning of period5,220 M4,043 M4,360 M4,065 M4,879 M5,249 M5,608 M5,061 M7,017 M8,004 M
Cash at end of period4,043 M4,360 M4,065 M4,879 M5,249 M5,608 M4,215 M7,017 M8,991 M6,082 M
Cash flow5,555 M5,557 M5,525 M3,635 M5,579 M505 M-8,446 M1,283 M23,817 M-33,613 M
CashFlowFromContinuingInvestingActivities-18,935 M-24,893 M-16,260 M-7,442 M-14,895 M3,366 M-10,027 M-47,746 M-18,411 M28,307 M
CashFlowFromDiscontinuedOperation299 M11,542 M
ChangeInAccruedExpense-3,990 M169 M-1,788 M652 M-704 M295 M132 M-254 M753 M599 M
ChangeInFederalFundsAndSecuritiesSoldForRepurchase965 M-778 M-1,733 M-915 M8,843 M-3,560 M-2,276 M-17,889 M-7,969 M29,568 M
ChangeInInterestPayable-3,990 M169 M-1,788 M652 M-704 M295 M132 M-254 M753 M599 M
ChangeInLoans-7,335 M-14,963 M-3,376 M15,616 M-41,735 M
ChangeInPayablesAndAccruedExpense-3,990 M169 M-1,788 M652 M-704 M295 M132 M-254 M753 M599 M
ChangeInWorkingCapital-791 M2 M-63 M-1,994 M-560 M-6,158 M-15,523 M-3,288 M15,912 M-39,708 M
CommonStockDividendPaid-911 M-1,000 M-1,038 M-1,061 M-1,266 M-1,601 M-1,895 M-1,980 M-2,056 M-2,391 M
CommonStockPayments-24 M-1,176 M-2,152 M-2,062 M-2,447 M-2,877 M-3,578 M-1,624 M-1,079 M-3,731 M
Current deferred income taxes1,196 M255 M404 M326 M-403 M133 M303 M-2,239 M178 M351 M
Deferred income taxes1,196 M255 M404 M326 M-403 M133 M303 M-2,239 M178 M351 M
Depreciation1,146 M988 M1,088 M1,193 M1,117 M1,129 M1,315 M1,497 M1,773 M651 M
Depreciation unreconciled1,146 M988 M1,088 M1,193 M1,117 M1,129 M1,315 M1,497 M1,773 M651 M
DepreciationAndAmortization1,146 M988 M1,088 M1,193 M1,117 M1,129 M1,315 M1,497 M1,773 M651 M
EarningsLossesFromEquityInvestments-373 M-441 M-407 M-361 M-727 M-525 M-531 M
ExcessTaxBenefitFromStockBasedCompensation-23 M-28 M-29 M
FinancingCashFlow12,203 M19,653 M10,440 M4,621 M9,686 M-3,512 M17,080 M48,419 M-3,432 M3,384 M
Free cash flow5,555 M5,557 M5,525 M3,635 M5,579 M505 M-8,446 M1,283 M23,817 M-33,613 M
GainLossOnInvestmentSecurities-83 M-4 M-43 M-305 M-64 M7 M
GainLossOnSaleOfBusiness-5,740 M
IncomeTaxPaidSupplementalData234 M1,102 M919 M658 M72 M372 M430 M3,410 M675 M197 M
InterestPaidSupplementalData891 M863 M1,005 M1,317 M1,743 M2,835 M3,742 M1,292 M582 M2,172 M
Issuance of debt2,372 M331 M-4,834 M258 M459 M20 M-495 M123 M44 M636 M
IssuanceOfDebt3,627 M1,133 M-5,358 M-230 M-2,199 M2,088 M4,349 M-6,177 M44 M483 M
Net cash from financing activities12,203 M19,653 M10,440 M4,621 M9,686 M-3,512 M17,080 M48,419 M-3,432 M3,384 M
Net cash from investing activities-18,935 M-24,893 M-16,260 M-7,442 M-14,895 M3,366 M-10,027 M-47,746 M-18,411 M28,307 M
Net cash from operating activities5,555 M5,557 M5,525 M3,635 M5,579 M505 M-8,446 M1,283 M23,817 M-33,613 M
Net change in cash & cash equivalents-1,177 M317 M-295 M814 M370 M359 M-1,393 M1,956 M1,974 M-1,922 M
Net income from continuing operations4,212 M4,207 M4,143 M3,985 M5,711 M5,518 M5,459 M11,358 M6,018 M5,086 M
NetBusinessPurchaseAndSale-1,342 M75 M14,225 M-10,511 M
NetCommonStockIssuance-24 M-1,176 M-2,152 M-2,062 M-2,447 M-2,877 M-3,578 M-1,624 M-1,079 M-3,731 M
NetInvestmentPropertiesPurchaseAndSale-8,199 M-14,997 M-14,061 M-2,191 M-3,985 M8,570 M-15,638 M-63,621 M-7,828 M25,456 M
NetInvestmentPurchaseAndSale-8,199 M-14,997 M-14,061 M-2,191 M-3,985 M8,570 M-15,638 M-63,621 M-7,828 M25,456 M
NetIssuancePaymentsOfDebt3,627 M1,133 M-5,358 M-230 M-2,199 M2,088 M4,349 M-6,177 M44 M483 M
NetLongTermDebtIssuance1,255 M802 M-524 M-488 M-2,758 M2,168 M4,844 M-6,300 M-153 M
NetPreferredStockIssuance346 M-500 M519 M1,484 M2,225 M
NetProceedsPaymentForLoan-10,206 M-10,027 M-2,680 M-5,377 M-9,323 M633 M637 M-88 M-48 M3,569 M
Operating (gains) losses-456 M-445 M-407 M-361 M-727 M-525 M-531 M-6,045 M-64 M7 M
Other financing charges net8,437 M21,706 M21,440 M8,579 M6,991 M2,674 M20,716 M76,318 M6,377 M-22,469 M
Other investing changes net1,646 M-12,927 M8,447 M14,944 M6,630 M25,406 M-1,251 M-32,123 M51,295 M57,209 M
Other non-cash items248 M550 M360 M486 M441 M408 M773 M
Payment of cash dividends1,148 M1,232 M1,257 M1,270 M1,502 M1,837 M2,131 M2,209 M2,289 M2,692 M
PaymentForLoans-12,765 M-12,897 M-4,720 M-7,274 M-11,324 M-690 M-1,027 M-1,982 M-1,891 M-2,074 M
PreferredStockDividendPaid-237 M-232 M-219 M-209 M-236 M-236 M-236 M-229 M-233 M-301 M
PreferredStockIssuance496 M519 M1,484 M2,225 M
PreferredStockPayments-150 M-500 M
ProceedsFromLoans2,559 M2,870 M2,040 M1,897 M2,001 M1,323 M1,664 M1,894 M1,843 M5,643 M
ProceedsPaymentFederalFundsSoldAndSecuritiesPurchasedUnderAgreementToResell-530 M131 M481 M126 M-245 M-5,837 M4,899 M1,738 M-24 M-718 M
Purchase of short term investments1,986 M745 M2,743 M5,544 M847 M
PurchaseOfFixedMaturitySecurities-1,883 M-500 M-4,896 M-4,305 M-19,210 M-26,788 M-25,490 M-45,409 M-85,583 M-41,005 M
PurchaseOfInvestment-20,302 M-8,489 M-31,263 M-23,800 M-19,210 M-26,788 M-25,490 M-45,409 M-85,583 M-41,005 M
Repayment of debt-731 M57 M-524 M-488 M-2,758 M-575 M-700 M-6,300 M-1,000 M
RepaymentOfDebt-11,175 M-8,630 M-6,743 M-502 M-2,758 M-575 M-700 M-6,300 M-1,000 M
Repurchase of capital stock-24 M-1,176 M-2,152 M-2,062 M-2,447 M-2,877 M-3,578 M-1,624 M-1,079 M-3,731 M
SaleOfBusiness14,225 M
SaleOfInvestment10,457 M6,419 M8,755 M6,665 M8,595 M9,952 M11,103 M13,911 M26,460 M9,252 M
SalesOfFixedMaturitySecurities2,483 M1,987 M2,032 M3,209 M8,595 M9,952 M11,103 M13,911 M26,460 M9,252 M
ShortTermDebtIssuance12,816 M9,018 M1,385 M272 M459 M20 M-495 M123 M44 M636 M
ShortTermDebtPayments-10,444 M-8,687 M-6,219 M-14 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University