Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

PNC Stock Annual Balance Sheet. Download in Excel

PNC Financial Services Group Inc. (The) logo

PNC Financial Services Group Inc. (The)

Sector: Financial Services   

Industry: Banks - Regional - US

205.75
 
USD
  
1.80
  
(0.88%)
Previous close: 203.95  Open: 203.95  Bid: 200.42  Ask: 207.98
52 week range    
127.15   
   214.19
Mkt Cap: 81,285 M  Avg Vol (90 Days): 1,782,475
Peers   
RF / 
WFC / 
KEY / 
FITB / 
JPM / 
Last updated: Friday 22nd November 2024

Stock Rankings

84
Technical
55
Quality
How are these ranks calculated?
Ad slot not ready
Search for a stock

Financials

PNC Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Accounts receivable-2,742 M-5,361 M
Accrued expenses5,187 M8,718 M9,355 M8,745 M9,002 M11,831 M9,514 M12,741 M15,762 M15,621 M
Accumulated depreciation & depletion-3,773 M-4,349 M-4,888 M-5,503 M-6,137 M-6,953 M-7,156 M-8,058 M-9,015 M-9,841 M
Additional paid in capital12,627 M16,197 M16,651 M16,374 M16,277 M16,369 M15,884 M17,457 M18,376 M19,020 M
AdvanceFromFederalHomeLoanBanks20,005 M20,108 M17,549 M21,037 M21,501 M16,341 M3,500 M32,075 M38,000 M
AllowanceForDoubtfulAccountsReceivable-2,742 M-5,361 M
AllowanceForLoansAndLeaseLosses3,331 M2,727 M2,589 M2,611 M2,629 M2,742 M5,361 M4,868 M4,741 M4,791 M
AssetsHeldForSale2,262 M1,540 M2,504 M2,655 M994 M1,083 M1,597 M2,231 M1,010 M734 M
AssetsOfDiscontinuedOperations8,558 M
AvailableForSaleSecurities55,823 M55,760 M60,104 M57,618 M126,778 M69,163 M87,358 M131,536 M44,159 M41,785 M
Cash and equivalents4,360 M4,065 M30,590 M33,844 M16,501 M28,474 M92,190 M82,254 M34,363 M50,725 M
CashEquivalents31,779 M30,546 M25,711 M28,595 M10,893 M23,413 M
CommercialPaper4,995 M14 M
Common par6,651 M2,708 M2,709 M2,710 M2,711 M2,712 M2,713 M2,713 M2,714 M2,716 M
Common stock equity44,551 M44,710 M45,699 M47,513 M47,728 M49,314 M54,010 M55,695 M45,774 M51,105 M
CommonStock2,705 M2,708 M2,709 M2,710 M2,711 M2,712 M2,713 M2,713 M2,714 M2,716 M
Cost in excess9,103 M9,103 M9,103 M9,173 M9,218 M9,233 M9,233 M10,916 M10,987 M10,932 M
CurrentAccruedExpenses5,187 M8,718 M9,355 M8,745 M9,002 M11,831 M9,514 M12,741 M15,762 M15,621 M
CurrentDeferredTaxesLiabilities5,607 M5,446 M5,339 M3,677 M3,768 M2,985 M3,512 M2,956 M3,095 M2,932 M
DeferredTaxAssets3,670 M3,284 M2,973 M1,703 M1,829 M2,124 M2,711 M2,753 M5,747 M5,061 M
Deposits232,234 M249,002 M257,164 M265,053 M267,839 M288,540 M365,345 M457,278 M436,282 M421,418 M
DerivativeAssets5,234 M4,941 M4,616 M2,874 M2,081 M3,502 M6,533 M5,152 M3,768 M3,429 M
DerivativeProductLiabilities4,027 M3,802 M3,839 M2,856 M2,290 M2,019 M2,756 M3,570 M7,618 M5,899 M
DividendsPayable-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-2,461 M
FederalFundsPurchasedAndSecuritiesSoldUnderAgreementToRepurchase3,510 M1,777 M
FederalFundsSoldAndSecuritiesPurchaseUnderAgreementsToResell1,852 M1,369 M
FederalHomeLoanBankStock84,900 M73,800 M26,900 M43,300 M
FinancialInstrumentsSoldUnderAgreementsToRepurchase3,406 M1,767 M
Float term debt48,263 M54,532 M52,706 M59,088 M57,419 M60,263 M37,195 M30,784 M42,056 M45,901 M
ForeclosedAssets19 M20 M
GoodwillAndOtherIntangibleAssets9,596 M9,103 M9,103 M9,173 M9,218 M9,233 M9,233 M10,916 M10,987 M10,932 M
Gross fixed assets (Plant Property & Equipment)3,773 M4,349 M4,888 M5,503 M6,137 M6,953 M7,156 M8,058 M9,015 M9,841 M
GrossLoan204,817 M206,696 M210,833 M220,458 M226,245 M239,843 M
GrossNotesReceivable239,843 M241,928 M
HeldToMaturitySecurities14,768 M15,843 M18,513 M19,312 M17,661 M1,441 M1,426 M95,175 M90,784 M
Intangibles493 M379 M
InterestBearingDepositsAssets31,779 M30,546 M25,711 M28,595 M10,893 M23,413 M85,173 M74,250 M27,320 M43,804 M
InterestBearingDepositsLiabilities158,755 M169,567 M176,934 M185,189 M193,879 M215,761 M252,708 M302,103 M311,796 M320,133 M
Invested capital121,072 M133,666 M133,562 M144,652 M141,065 M153,499 M124,900 M117,263 M97,811 M104,907 M
Leases2,000 M1,000 M900 M800 M400 M
LineOfCredit318 M584 M662 M694 M663 M
LoansReceivable204,817 M206,696 M210,833 M220,458 M226,245 M1,719 M
LongTermCapitalLeaseObligation2,170 M2,097 M2,220 M2,160 M1,998 M
LongTermDebtAndCapitalLeaseObligation48,263 M54,532 M52,706 M59,088 M57,419 M60,263 M37,195 M30,784 M42,056 M45,901 M
Minority interest1,523 M1,270 M1,155 M72 M42 M29 M31 M31 M38 M36 M
MoneyMarketInvestments1,852 M1,369 M
MortgageLoan800 M600 M400 M
Net fixed assets (net PP&E)5,643 M5,908 M5,522 M5,436 M5,727 M7,728 M
Net loans201,486 M203,969 M208,244 M217,847 M223,616 M237,101 M-5,361 M-4,868 M-4,741 M-4,791 M
NonInterestBearingDeposits73,479 M79,435 M80,230 M79,864 M73,960 M72,779 M112,637 M155,175 M124,486 M101,285 M
Notes payable16,657 M26,836 M
Other equity adjustments503 M130 M-265 M-148 M-725 M799 M
Other receivable239,843 M241,928 M288,372 M326,025 M321,508 M
OtherAssets35,561 M38,742 M40,034 M41,118 M49,302 M38,978 M38,251 M45,306 M50,262 M49,917 M
OtherCurrentBorrowings3,357 M2,779 M8,778 M
OtherLiabilities4,809 M261 M301 M297 M285 M318 M584 M662 M694 M
OtherRealEstateOwned370 M299 M230 M170 M114 M
Preferred securities of subsidiary trust3,946 M
PreferredStock3,946 M
RestrictedCashAndCashEquivalents5,061 M7,017 M8,004 M7,043 M6,921 M
Retained earnings26,703 M29,173 M31,405 M35,333 M38,194 M43,014 M49,618 M50,637 M43,400 M48,578 M
SecuritiesAndInvestments58,176 M70,528 M75,947 M76,131 M146,090 M86,824 M88,799 M132,962 M139,334 M132,569 M
SecurityAgreeToBeResell1,646 M1,082 M
SecuritySoldNotYetRepurchased3,406 M1,767 M
Short term debt4,995 M14 M17,351 M27,499 M
TimeDepositsPlaced8,800 M
Total assets345,072 M358,493 M366,422 M380,768 M445,721 M410,251 M466,679 M557,191 M557,263 M561,580 M
Total equity44,551 M44,710 M45,699 M47,513 M47,728 M49,314 M54,010 M55,695 M45,774 M51,105 M
Total liabilities298,998 M312,513 M319,526 M333,183 M334,545 M360,952 M412,638 M501,465 M511,451 M510,439 M
TotalEquityGrossMinority46,074 M45,980 M46,854 M47,585 M47,770 M49,343 M54,041 M55,726 M45,812 M51,141 M
TotalEquityGrossMinorityInterest46,074 M45,980 M46,854 M47,585 M47,770 M49,343 M54,041 M55,726 M45,812 M51,141 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest345,072 M358,493 M366,380 M380,768 M382,315 M410,251 M466,679 M557,191 M557,263 M561,580 M
TradingSecurities2,353 M1,726 M
Treasury stock-1,430 M-3,368 M-5,066 M-6,904 M-9,454 M-12,781 M-14,205 M-15,112 M-18,716 M-19,209 M
debtc4,995 M14 M17,351 M27,499 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