Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Penske Automotive Group Inc. logo

Penske Automotive Group Inc.

Sector: Consumer Cyclical   

Industry: Auto & Truck Dealerships

147.94
 
USD
  
0.46
  
(0.31%)
Optionable: Yes  Market Cap: 10,081 M  90-day average vol: 204,647

Previous close: 147.48  Open: 147.44  Bid: 147.05  Ask: 148.55
52 week range    
133.72   
   180.84
Peers   
SAH / 
GPI / 
ABG / 
LAD / 
AN / 
KMX / 
CAR / 
CRMT / 
RUSHA / 
Last updated: Monday 22nd April 2024
49
MarketXLS Rank
65
Value
7
Technical
76
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

PAG Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""37 M28 M48 M73 M92 M103 M88 M82 M75 M210 M
Accounts payable423 M494 M497 M642 M598 M639 M675 M767 M854 M867 M
Accrued expenses739 M872 M857 M1,165 M1,165 M1,341 M1,443 M1,637 M1,642 M1,677 M
Accumulated depreciation & depletion-438 M-500 M-526 M-605 M-618 M-678 M-758 M-832 M-902 M-1,022 M
Additional paid in capital691 M656 M497 M532 M478 M320 M312 M42 M
Cash and equivalents36 M62 M24 M46 M39 M28 M50 M101 M107 M96 M
CashCashEquivalentsAndShortTermInvestments36 M62 M24 M46 M39 M28 M50 M101 M107 M96 M
CashEquivalents36 M62 M24 M46 M39 M
Common stock equity1,653 M1,790 M1,751 M2,395 M2,609 M2,793 M3,303 M4,070 M4,148 M4,726 M
CommonStock240 M240 M240 M240 M3,303 M4,070 M4,148 M
Cost in excess1,270 M1,323 M1,291 M1,661 M1,752 M1,911 M1,928 M2,124 M2,155 M2,235 M
CurrentAccruedExpenses316 M378 M360 M524 M567 M702 M767 M870 M788 M810 M
CurrentCapitalLeaseObligation211 M223 M216 M237 M223 M91 M94 M100 M95 M88 M
CurrentDeferredRevenue303 M270 M263 M263 M297 M292 M280 M
CurrentDeferredTaxesAssets78 M94 M105 M172 M118 M682 M731 M699 M722 M730 M
CurrentDeferredTaxesLiabilities376 M403 M565 M482 M578 M678 M-1,604 M-1,759 M-1,843 M-1,961 M
DividendsPayable1.01.0
Float term debt1,316 M1,247 M1,829 M2,090 M2,125 M2,257 M3,952 M3,766 M3,883 M3,756 M
GoodwillAndOtherIntangibleAssets1,657 M1,731 M1,711 M2,135 M2,238 M2,463 M2,492 M2,766 M2,846 M2,983 M
Gross fixed assets (Plant Property & Equipment)1,769 M2,020 M2,333 M2,713 M5,294 M5,405 M5,579 M5,726 M5,815 M6,193 M
Intangibles387 M408 M420 M474 M486 M552 M563 M642 M691 M748 M
Inventories2,836 M3,464 M3,408 M3,944 M4,040 M4,261 M3,426 M3,129 M3,509 M4,293 M
Invested capital2,969 M3,037 M3,580 M4,486 M4,734 M5,050 M8,857 M9,228 M9,578 M9,901 M
LineOfCredit24 M24 M33 M33 M41 M42 M49 M29 M27 M25 M
LongTermCapitalLeaseObligation2,388 M2,301 M2,350 M2,374 M2,336 M2,336 M
LongTermDebtAndCapitalLeaseObligation1,316 M1,247 M1,829 M2,090 M4,512 M4,558 M3,952 M3,766 M3,883 M3,756 M
Minority interest28 M45 M29 M33 M26 M18 M24 M25 M27 M29 M
Net fixed assets (net PP&E)1,332 M1,520 M1,807 M2,109 M4,676 M4,727 M4,821 M4,894 M4,913 M5,171 M
Non-current deferred income taxes410 M433 M565 M482 M578 M678 M873 M1,060 M1,121 M1,232 M
NonCurrentAccruedExpenses4,900 M5,100 M
NonCurrentDeferredLiabilities410 M433 M565 M482 M578 M678 M873 M1,060 M1,121 M1,232 M
NonCurrentDeferredTaxesAssets97 M112 M123 M209 M158 M728 M796 M766 M785 M788 M
Number of employees26500.026500.026500.026500.026500.026500.026500.026500.026500.026500.0
Other current assets280 M98 M82 M82 M87 M85 M127 M112 M142 M176 M
Other equity adjustments-53 M-122 M-251 M-146 M-234 M-203 M
Other fixed assets4,727 M4,821 M4,894 M4,913 M5,171 M
Other non-current assets27 M19 M28 M14 M16 M20 M25 M42 M55 M63 M
Other non-current liabilities2,937 M212 M1,664 M1,959 M1,948 M2,038 M1,785 M1,679 M1,654 M271 M
Other receivable707 M782 M879 M955 M929 M960 M807 M734 M907 M1,115 M
OtherCurrentLiabilities108 M3,386 M2,091 M2,344 M2,363 M2,413 M1,781 M1,145 M1,566 M3,772 M
OtherInventories3,426 M3,129 M3,509 M4,293 M
OtherPayable355 M157 M141 M450 M309 M327 M
Payables423 M494 M497 M642 M598 M639 M675 M767 M854 M867 M
Preferred securities of subsidiary trust100000.0100000.0100000.0
PreferredStock100000.0100000.0100000.0
RecievablesAdjustmentsAllowances-3 M-4 M-5 M-6 M-5 M-7 M-7 M-7 M
Retained earnings1,015 M1,257 M1,505 M2,009 M2,366 M2,676 M2,991 M4,028 M4,148 M4,726 M
SecuritySoldNotYetRepurchased16 M49 M174 M19 M69 M169 M
Short term debt37 M28 M48 M73 M92 M103 M88 M82 M75 M210 M
Total assets7,228 M8,013 M8,833 M10,541 M10,905 M13,943 M13,247 M13,465 M14,115 M15,672 M
Total current assets3,868 M4,407 M4,394 M5,027 M5,095 M5,334 M4,409 M4,075 M4,664 M5,680 M
Total current liabilities3,630 M4,286 M4,230 M5,000 M5,048 M3,857 M4,675 M4,275 M4,713 M5,658 M
Total equity1,653 M1,790 M1,751 M2,395 M2,609 M2,793 M3,303 M4,070 M4,148 M4,726 M
Total liabilities5,547 M6,179 M7,054 M8,113 M8,270 M11,131 M9,921 M9,370 M9,940 M10,916 M
Total non-current assets3,368 M3,607 M4,440 M5,514 M8,235 M8,609 M8,838 M9,389 M9,450 M9,992 M
Total non-current liabilities4,663 M1,893 M4,057 M4,531 M7,038 M7,274 M6,610 M6,505 M6,657 M5,258 M
TotalEquityGrossMinority1,681 M1,835 M1,780 M2,428 M2,635 M2,812 M3,326 M4,095 M4,175 M4,756 M
TotalEquityGrossMinorityInterest1,681 M1,835 M1,780 M2,428 M2,635 M2,812 M3,326 M4,095 M4,175 M4,756 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest7,228 M8,013 M8,833 M10,541 M10,905 M13,943 M13,247 M13,465 M14,115 M15,672 M
TotalNonCurrentLiabilitiesNetMinorityInteres4,663 M1,893 M4,057 M4,531 M7,038 M7,274 M6,610 M6,505 M6,657 M5,258 M
Working capital237 M121 M164 M26 M47 M1,477 M-266 M-199 M-49 M22 M
ltinv353 M336 M893 M1,257 M1,305 M1,399 M1,500 M1,688 M1,637 M1,775 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