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

PWR Stock Annual Balance Sheet. Download in Excel

Quanta Services Inc. logo

Quanta Services Inc.

Sector: Industrials   

Industry: Engineering & Construction

328.41
 
USD
  
5.82
  
(1.80%)
Previous close: 322.59  Open: 319.58  Bid: 311.95  Ask: 343.0
52 week range    
187.27   
   350.19
Mkt Cap: 49,661 M  Avg Vol (90 Days): 868,146
Peers   
EME / 
MTZ / 
DY / 
FLR / 
MYRG / 
IESC / 
Last updated: Sunday 22nd December 2024

Stock Rankings

51
MarketXLS Rank
35
Value
61
Technical
57
Quality
How are these ranks calculated?
Search for a stock

Financials

PWR Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Accounts payable825 M782 M923 M633 M787 M1,490 M1,510 M2,255 M2,153 M3,061 M
Accounts receivable1,801 M1,621 M1,500 M1,985 M2,355 M2,748 M2,716 M3,400 M3,675 M4,411 M
Accrued expenses825 M782 M923 M1,057 M1,315 M1,490 M1,510 M2,255 M2,153 M3,061 M
Accumulated depreciation & depletion-652 M-755 M-863 M-981 M-1,092 M-1,250 M-1,372 M-1,503 M-1,651 M-1,821 M
Additional paid in capital3,593 M3,498 M1,749 M1,889 M1,967 M2,025 M2,170 M2,615 M2,719 M3,003 M
Building & improvements93 M117 M138 M156 M209 M23 M28 M
Cash and equivalents191 M129 M112 M138 M79 M165 M185 M229 M429 M1,290 M
CashCashEquivalentsAndShortTermInvestments191 M129 M112 M138 M79 M165 M185 M229 M429 M1,290 M
CashEquivalents108 M1 M9 M138 M79 M38 M98 M140 M260 M611 M
Common par2000.02000.01000.02000.02000.02000.02000.02000.02000.02000.0
Common stock equity4,514 M3,085 M3,339 M3,792 M3,604 M4,050 M4,344 M5,112 M5,383 M6,272 M
CommonStock2000.02000.03,339 M2000.02000.02000.02000.02000.02000.02000.0
Construction in progress38 M44 M73 M
Cost in excess1,597 M1,553 M1,603 M1,869 M1,900 M2,023 M2,121 M3,529 M3,587 M4,046 M
CurrentCapitalLeaseObligation1 M5 M4 M2 M125 M92 M85 M78 M74 M78 M
CurrentDeferredRevenue13 M8 M16 M433 M426 M606 M529 M803 M1,142 M1,539 M
CurrentDeferredTaxesAssets155 M175 M190 M139 M109 M178 M285 M307 M315 M401 M
CurrentDeferredTaxesLiabilities-368 M-357 M-373 M153 M202 M-380 M-434 M-481 M-530 M-643 M
Deferred revenues433 M426 M606 M529 M803 M1,142 M1,539 M
DeferredFinancingCosts8 M11 M11 M17 M
Float term debt72 M475 M354 M671 M1,041 M1,489 M1,353 M3,895 M3,864 M3,851 M
GoodwillAndOtherIntangibleAssets1,840 M1,758 M1,790 M2,132 M2,180 M2,436 M2,557 M5,330 M5,045 M5,408 M
Gross fixed assets (Plant Property & Equipment)1,751 M1,857 M2,037 M2,270 M2,368 M2,921 M3,190 M3,664 M3,911 M4,408 M
IncomeTaxPayable21 M4 M41 M20 M13 M58 M32 M
Intangibles244 M205 M187 M263 M280 M414 M436 M1,801 M1,459 M1,362 M
Inventories39 M75 M89 M81 M108 M56 M50 M85 M103 M176 M
Invested capital4,659 M4,036 M4,047 M4,464 M4,646 M6,831 M6,872 M12,732 M12,940 M13,786 M
Land & improvements41 M41 M46 M49 M61 M
Leases1 M2 M2 M3 M36 M
LineOfCredit69 M467 M351 M668 M1,070 M1,346 M149 M1,200 M787 M867 M
LongTermCapitalLeaseObligation197 M179 M170 M172 M187 M
LongTermDebtAndCapitalLeaseObligation72 M475 M354 M671 M1,041 M1,489 M1,353 M3,895 M3,864 M3,851 M
LongTermProvisions170 M209 M-543000.087000.07 M11 M4 M35 M350000.06 M
Machinery furniture & equipment1,459 M1,518 M1,635 M1,835 M1,866 M
Minority interest11 M2 M3 M4 M1 M4 M5 M5 M15 M11 M
Net fixed assets (net PP&E)1,100 M1,102 M1,174 M1,289 M1,276 M1,671 M1,818 M2,160 M2,260 M2,586 M
Non-current deferred income taxes216 M186 M193 M179 M219 M215 M166 M191 M228 M254 M
NonCurrentAccountsReceivable26 M12 M13 M
NonCurrentDeferredLiabilities216 M186 M193 M179 M219 M215 M166 M191 M228 M254 M
NonCurrentDeferredRevenue48 M
NonCurrentDeferredTaxesAssets168 M191 M205 M158 M176 M282 M328 M349 M373 M441 M
Other current assets14 M55 M35 M301 M337 M46 M57 M74 M64 M83 M
Other equity adjustments-123 M-295 M-272 M-203 M-286 M-242 M-233 M
Other fixed assets1,100 M1,102 M1,174 M1,671 M1,818 M2,160 M2,260 M2,586 M
Other non-current assets818 M76 M101 M190 M294 M393 M436 M632 M623 M566 M
Other non-current liabilities228 M260 M260 M342 M405 M311 M391 M487 M568 M636 M
Other receivable290 M318 M473 M9,466 M11,171 M12,112 M11,203 M12,980 M17,074 M20,882 M
OtherCurrentBorrowings9 M7 M8 M1 M66 M75 M15 M29 M37 M535 M
OtherCurrentLiabilities272 M415 M275 M8 M10 M316 M378 M547 M469 M526 M
OtherInventories39 M75 M89 M56 M50 M85 M103 M176 M
OtherPayable877 M782 M923 M1,057 M1,315 M1,490 M1,510 M
Payables825 M782 M923 M1,057 M1,315 M1,490 M1,510 M2,255 M2,153 M3,061 M
Prepaid expenses161 M135 M115 M168 M208 M261 M183 M215 M250 M387 M
RecievablesAdjustmentsAllowances-6 M-5 M-3 M-4 M-6 M-9 M-17 M-50 M-16 M-14 M
Restricted cash170 M187 M232 M433 M1,295 M
Retained earnings1,244 M1,383 M1,604 M2,191 M2,477 M2,612 M3,032 M3,477 M3,853 M4,575 M
SecuritySoldNotYetRepurchased93 M1,606 M50 M443 M20 M247 M67 M-128 M-350000.0
Short term debt9 M7 M8 M1 M66 M75 M15 M29 M37 M535 M
Total assets6,254 M5,214 M5,354 M6,480 M7,076 M8,332 M8,398 M12,855 M13,464 M16,237 M
Total current assets2,496 M2,278 M2,289 M2,870 M3,326 M3,831 M3,588 M4,733 M5,536 M7,677 M
Total current liabilities1,106 M1,204 M1,205 M1,492 M1,806 M2,263 M2,139 M3,165 M3,406 M5,213 M
Total equity4,514 M3,085 M3,339 M3,792 M3,604 M4,050 M4,344 M5,112 M5,383 M6,272 M
Total liabilities1,728 M2,126 M2,011 M2,685 M3,470 M4,278 M4,049 M7,738 M8,066 M9,954 M
Total non-current assets3,758 M2,936 M3,065 M3,610 M3,750 M4,501 M4,810 M8,123 M7,928 M8,560 M
Total non-current liabilities622 M922 M806 M1,192 M1,664 M2,015 M1,911 M4,573 M4,659 M4,741 M
TotalEquityGrossMinority4,526 M3,088 M3,343 M3,796 M3,605 M4,054 M4,349 M5,117 M5,399 M6,283 M
TotalEquityGrossMinorityInterest4,526 M3,088 M3,343 M3,796 M3,605 M4,054 M4,349 M5,117 M5,399 M6,283 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest6,254 M5,214 M5,354 M6,480 M7,076 M8,332 M8,398 M12,855 M13,464 M16,237 M
TotalNonCurrentLiabilitiesNetMinorityInteres622 M922 M806 M1,192 M1,664 M2,015 M1,911 M4,573 M4,659 M4,741 M
Treasury stock-322 M-1,795 M-14 M-85 M-554 M-587 M-858 M-980 M-1,188 M-1,306 M
UnearnedIncome1,387 M
UnearnedPremiums-29 M-26 M-23 M
Working capital1,389 M1,074 M1,084 M1,378 M1,520 M1,568 M1,450 M1,568 M2,130 M2,464 M
debtc9 M7 M8 M1 M66 M167 M100 M107 M112 M613 M
ltinv45 M45 M231 M211 M178 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