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

147.89
 
USD
  
0.64
  
(0.43%)
Optionable: Yes  Market Cap: 58,295 M  90-day average vol: 2,088,200

Previous close: 147.25  Open: 147.36  Bid: 145.0  Ask: 147.9
52 week range    
109.40   
   162.24
Peers   
RF / 
WFC / 
KEY / 
FITB / 
JPM / 
Last updated: Friday 19th April 2024
53
MarketXLS Rank
75
Value
30
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 Balance Sheet

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
"""debtc"""4,997 M4,995 M14 M
Accounts receivable-2,742 M
Accrued expenses4,690 M5,187 M8,718 M9,355 M8,745 M9,002 M11,831 M9,514 M13,998 M15,762 M
Accumulated depreciation & depletion-3,285 M-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
Additional paid in capital12,416 M12,627 M16,197 M16,651 M16,374 M16,277 M16,369 M15,884 M17,457 M18,376 M
AdvanceFromFederalHomeLoanBanks12,912 M20,005 M20,108 M17,549 M21,037 M21,501 M16,341 M3,500 M32,075 M
AllowanceForDoubtfulAccountsReceivable-2,742 M
AllowanceForLoansAndLeaseLosses3,609 M3,331 M2,727 M2,589 M2,611 M2,629 M2,742 M5,361 M-4,778 M-4,631 M
AssetsHeldForSale2,255 M2,262 M1,540 M2,504 M2,655 M994 M1,083 M1,597 M2,231 M1,010 M
AssetsOfDiscontinuedOperations8,558 M
AvailableForSaleSecurities60,294 M55,823 M55,760 M60,104 M57,618 M126,778 M69,163 M87,358 M131,536 M44,159 M
Cash and equivalents16,178 M4,360 M4,065 M30,590 M33,844 M16,501 M28,474 M92,190 M82,254 M34,363 M
CashAndDueFromBanks74,250 M27,320 M
CashEquivalents12,135 M31,779 M30,546 M25,711 M28,595 M10,893 M23,413 M85,173 M74,250 M
CommercialLoan152,933 M164,439 M
CommercialPaper4,997 M4,995 M14 M
Common par6,639 M6,651 M2,708 M2,709 M2,710 M2,711 M2,712 M2,713 M2,713 M2,714 M
Common stock equity42,334 M44,551 M44,710 M45,699 M47,513 M47,728 M49,314 M54,010 M55,695 M45,774 M
CommonStock2,698 M2,705 M2,708 M2,709 M2,710 M2,711 M2,712 M2,713 M2,713 M2,714 M
ConsumerLoan31,521 M29,104 M
Cost in excess9,074 M9,103 M9,103 M9,103 M9,173 M9,218 M9,233 M9,233 M10,916 M10,987 M
CurrentAccruedExpenses4,690 M5,187 M8,718 M9,355 M8,745 M9,002 M11,831 M9,514 M13,998 M15,762 M
CurrentDeferredTaxesLiabilities5,437 M5,607 M5,446 M5,339 M3,677 M3,768 M2,985 M3,512 M2,956 M3,095 M
DeferredTaxAssets3,815 M3,670 M3,284 M2,973 M1,703 M1,829 M2,124 M2,711 M2,753 M5,747 M
Deposits220,931 M232,234 M249,002 M257,164 M265,053 M267,839 M288,540 M365,345 M457,278 M436,282 M
DerivativeAssets4,793 M5,234 M4,941 M4,616 M2,874 M2,081 M3,502 M6,533 M5,152 M3,768 M
DerivativeProductLiabilities3,934 M4,027 M3,802 M3,839 M2,856 M2,290 M2,019 M2,756 M3,570 M7,618 M
DividendsPayable-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
FederalFundsPurchasedAndSecuritiesSoldUnderAgreementToRepurchase4,289 M3,510 M1,777 M
FederalFundsSoldAndSecuritiesPurchaseUnderAgreementsToResell1,986 M1,852 M1,369 M
FederalHomeLoanBankStock84,900 M73,800 M26,900 M
FinancialInstrumentsSoldUnderAgreementsToRepurchase4,183 M3,406 M1,767 M
Float term debt36,819 M48,263 M54,532 M52,706 M59,088 M57,419 M60,263 M37,195 M30,784 M58,713 M
ForeclosedAssets19 M20 M
GoodwillAndOtherIntangibleAssets11,290 M9,596 M9,103 M9,103 M9,173 M9,218 M9,233 M9,233 M12,734 M14,410 M
Gross fixed assets (Plant Property & Equipment)3,285 M3,773 M4,349 M4,888 M5,503 M6,137 M6,953 M7,156 M8,058 M9,015 M
GrossLoan195,613 M204,817 M206,696 M210,833 M220,458 M226,245 M239,843 M241,928 M284,473 M320,521 M
GrossNotesReceivable239,843 M
HeldToMaturitySecurities11,765 M14,768 M15,843 M18,513 M19,312 M17,661 M1,441 M1,426 M95,175 M
Intangibles2,216 M493 M379 M1,818 M3,423 M
InterestBearingDepositsAssets12,135 M31,779 M30,546 M25,711 M28,595 M10,893 M23,413 M85,173 M74,250 M27,320 M
InterestBearingDepositsLiabilities150,625 M158,755 M169,567 M176,934 M185,189 M193,879 M215,761 M252,708 M302,103 M311,796 M
Invested capital103,060 M121,072 M133,666 M133,562 M144,652 M141,065 M153,499 M124,900 M117,263 M131,125 M
Leases2,000 M1,000 M900 M800 M
LineOfCredit318 M584 M662 M694 M
LoansHeldForSale2,231 M1,010 M
LoansReceivable195,613 M204,817 M206,696 M210,833 M220,458 M226,245 M1,719 M
LongTermCapitalLeaseObligation2,170 M2,097 M2,220 M2,160 M
LongTermDebtAndCapitalLeaseObligation36,819 M48,263 M54,532 M52,706 M59,088 M57,419 M60,263 M37,195 M30,784 M58,713 M
LongTermProvisions662 M694 M
Minority interest1,703 M1,523 M1,270 M1,155 M72 M42 M29 M31 M31 M38 M
MoneyMarketInvestments1,986 M1,852 M1,369 M
MortgageLoan800 M600 M400 M97,788 M125,968 M
Net fixed assets (net PP&E)5,618 M5,643 M5,908 M5,522 M5,436 M5,727 M7,728 M7,687 M8,593 M
Net loans192,004 M201,486 M203,969 M208,244 M217,847 M223,616 M237,101 M-5,361 M279,695 M315,890 M
NonInterestBearingDeposits70,306 M73,479 M79,435 M80,230 M79,864 M73,960 M72,779 M112,637 M155,175 M124,486 M
Number of employees59894.059894.059894.059894.059894.059894.059894.059894.059894.059894.0
Other equity adjustments436 M503 M130 M-265 M-148 M-725 M799 M2,770 M409 M-10,172 M
Other receivable239,843 M241,928 M6,040 M6,404 M
OtherAssets33,112 M35,561 M38,742 M40,034 M41,118 M49,302 M38,978 M38,251 M36,583 M38,425 M
OtherCurrentBorrowings12,603 M3,357 M2,779 M8,778 M
OtherLiabilities4,429 M4,809 M261 M301 M297 M285 M318 M584 M662 M694 M
OtherRealEstateOwned369 M370 M299 M230 M170 M114 M
Preferred securities of subsidiary trust3,941 M3,946 M
PreferredStock3,941 M3,946 M
RestrictedCashAndCashEquivalents5,061 M7,017 M8,004 M7,043 M
Retained earnings23,687 M26,703 M29,173 M31,405 M35,333 M38,194 M43,014 M49,618 M50,228 M53,572 M
SecuritiesAndInvestments63,367 M58,176 M70,528 M75,947 M76,131 M146,090 M86,824 M88,799 M132,962 M139,334 M
SecurityAgreeToBeResell1,542 M1,646 M1,082 M
SecuritySoldNotYetRepurchased4,183 M3,406 M1,767 M
Short term debt4,997 M4,995 M14 M
TimeDepositsPlaced9,000 M8,800 M
Total assets320,192 M345,072 M358,493 M366,422 M380,768 M445,721 M410,251 M466,637 M557,173 M557,240 M
Total equity42,334 M44,551 M44,710 M45,699 M47,513 M47,728 M49,314 M54,010 M55,695 M45,774 M
Total liabilities276,155 M298,998 M312,513 M319,526 M333,183 M334,545 M360,952 M412,638 M501,465 M511,451 M
TotalEquityGrossMinority44,037 M46,074 M45,980 M46,854 M47,585 M47,770 M49,343 M54,041 M55,726 M45,812 M
TotalEquityGrossMinorityInterest44,037 M46,074 M45,980 M46,854 M47,585 M47,770 M49,343 M54,041 M55,726 M45,812 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest320,192 M345,072 M358,493 M366,380 M380,768 M382,315 M410,295 M466,679 M557,173 M557,240 M
TradingSecurities3,073 M2,353 M1,726 M
Treasury stock-408 M-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
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