Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Quanta Services Inc. logo

Quanta Services Inc.

Sector: Industrials   

Industry: Engineering & Construction

245.56
 
USD
  
2.30
  
(0.95%)
Optionable: Yes  Market Cap: 36,246 M  90-day average vol: 917,182

Previous close: 243.26  Open: 246.03  Bid: 241.98  Ask: 247.23
52 week range    
153.74   
   265.82
Peers   
EME / 
MTZ / 
DY / 
FLR / 
MYRG / 
IESC / 
Last updated: Tuesday 23rd April 2024
44
MarketXLS Rank
20
Value
38
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

PWR Balance Sheet

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
"""debtc"""1 M9 M7 M8 M1 M66 M167 M100 M107 M112 M
Accounts payable802 M825 M782 M923 M633 M787 M799 M798 M1,251 M1,302 M
Accounts receivable1,439 M1,801 M1,621 M1,500 M1,985 M2,355 M2,748 M2,716 M3,400 M3,675 M
Accrued expenses802 M825 M782 M923 M1,057 M1,315 M1,490 M1,510 M2,255 M1,684 M
Accumulated depreciation & depletion-632 M-652 M-755 M-863 M-981 M-1,092 M-1,250 M-1,372 M-1,503 M-1,651 M
Additional paid in capital3,417 M3,593 M3,498 M1,749 M1,889 M1,967 M2,025 M2,170 M2,615 M2,719 M
Building & improvements78 M93 M117 M138 M156 M209 M23 M396 M
Cash and equivalents489 M191 M129 M112 M138 M79 M165 M185 M229 M429 M
CashCashEquivalentsAndShortTermInvestments489 M191 M129 M112 M138 M79 M165 M185 M229 M429 M
CashEquivalents248 M108 M1 M9 M138 M79 M165 M185 M229 M260 M
Common par2000.02000.02000.01000.02000.02000.02000.02000.02000.02000.0
Common stock equity4,234 M4,514 M3,085 M3,339 M3,792 M3,604 M4,050 M4,344 M5,112 M5,383 M
CommonStock2000.02000.02000.03,339 M2000.02000.02000.02000.02000.02000.0
Construction in progress44 M38 M44 M73 M84 M
Cost in excess1,781 M1,597 M1,553 M1,603 M1,869 M1,900 M2,023 M2,121 M3,529 M3,587 M
CurrentAccruedExpenses382 M
CurrentCapitalLeaseObligation2 M1 M5 M4 M2 M125 M92 M85 M78 M74 M
CurrentDeferredRevenue49 M13 M8 M16 M433 M426 M606 M529 M803 M1,142 M
CurrentDeferredTaxesAssets171 M155 M175 M190 M139 M109 M178 M285 M307 M315 M
CurrentDeferredTaxesLiabilities-371 M-368 M-357 M-373 M153 M202 M202 M149 M174 M-530 M
CurrentProvisions3 M
Deferred revenues433 M426 M606 M529 M803 M1,142 M
DeferredFinancingCosts8 M8 M11 M11 M
Float term debt1 M72 M475 M354 M671 M1,041 M1,292 M1,174 M3,724 M3,692 M
GoodwillAndOtherIntangibleAssets1,989 M1,840 M1,758 M1,790 M2,132 M2,180 M2,436 M2,557 M5,330 M5,045 M
Gross fixed assets (Plant Property & Equipment)1,838 M1,751 M1,857 M2,037 M2,270 M2,368 M2,921 M3,190 M3,664 M3,911 M
IncomeTaxPayable74 M21 M4 M41 M20 M13 M58 M32 M
Intangibles208 M244 M205 M187 M263 M280 M414 M436 M1,801 M1,459 M
Inventories32 M39 M75 M89 M81 M108 M56 M50 M85 M103 M
Invested capital4,236 M4,659 M4,036 M4,047 M4,464 M4,646 M5,356 M5,565 M8,902 M12,940 M
Land & improvements31 M41 M41 M46 M49 M61 M91 M
Leases3 M
LineOfCredit1,080 M69 M467 M351 M668 M1,070 M1,346 M149 M1,200 M787 M
LongTermCapitalLeaseObligation197 M179 M170 M172 M
LongTermDebtAndCapitalLeaseObligation1 M72 M475 M354 M671 M1,041 M1,489 M1,353 M3,895 M3,864 M
LongTermProvisions162 M170 M209 M-543000.087000.07 M11 M4 M35 M350000.0
Machinery furniture & equipment1,200 M1,459 M1,518 M1,635 M1,835 M1,866 M3,009 M
Minority interest7 M11 M2 M3 M4 M1 M4 M5 M5 M15 M
Net fixed assets (net PP&E)1,206 M1,100 M1,102 M1,174 M1,289 M1,276 M1,671 M1,818 M2,160 M2,260 M
NetUnrealizedGainLossInvestments113 M
Non-current deferred income taxes244 M216 M186 M193 M179 M219 M215 M166 M191 M228 M
NonCurrentAccountsReceivable26 M12 M13 M
NonCurrentDeferredAssets244 M
NonCurrentDeferredLiabilities244 M216 M186 M193 M179 M219 M215 M166 M191 M228 M
NonCurrentDeferredRevenue40 M48 M
NonCurrentDeferredTaxesAssets187 M168 M191 M205 M158 M176 M282 M328 M349 M373 M
NonCurrentPensionAndOtherPostretirementBenefitPlans163 M
Number of employees47300.047300.047300.047300.047300.047300.047300.047300.047300.047300.0
Other current assets140 M14 M55 M35 M301 M337 M46 M57 M74 M250 M
Other equity adjustments-37 M-123 M-295 M-272 M-203 M-286 M-242 M-233 M-238 M-311 M
Other fixed assets1,206 M1,100 M1,102 M1,174 M331 M
Other non-current assets286 M818 M76 M101 M190 M294 M393 M436 M632 M623 M
Other non-current liabilities264 M228 M260 M260 M342 M405 M311 M391 M487 M568 M
Other receivable213 M290 M318 M473 M9,466 M11,171 M12,112 M11,203 M12,980 M1,080 M
OtherCurrentBorrowings1 M9 M7 M8 M1 M66 M75 M15 M29 M37 M
OtherCurrentLiabilities239 M272 M415 M275 M8 M10 M78 M3 M469 M
OtherInventories32 M39 M75 M89 M103 M
OtherPayable802 M877 M782 M923 M1,057 M1,315 M1,490 M1,510 M2,255 M
Payables802 M825 M782 M923 M1,057 M1,315 M1,490 M1,510 M2,255 M1,302 M
Prepaid expenses161 M135 M115 M168 M208 M261 M183 M215 M250 M
RecievablesAdjustmentsAllowances-5 M-6 M-5 M-3 M-4 M-6 M-9 M-17 M-50 M-16 M
Restricted cash433 M
Retained earnings1,033 M1,244 M1,383 M1,604 M2,191 M2,477 M2,854 M3,265 M3,715 M4,163 M
SecuritySoldNotYetRepurchased93 M1,606 M50 M443 M20 M247 M67 M128 M
Short term debt1 M9 M7 M8 M1 M66 M75 M15 M29 M37 M
Total assets5,793 M6,254 M5,214 M5,354 M6,480 M7,076 M8,332 M8,398 M12,855 M13,464 M
Total current assets2,313 M2,496 M2,278 M2,289 M2,870 M3,326 M3,831 M3,588 M4,733 M5,536 M
Total current liabilities1,042 M1,106 M1,204 M1,205 M1,492 M1,806 M2,263 M2,139 M3,165 M3,406 M
Total equity4,234 M4,514 M3,085 M3,339 M3,792 M3,604 M4,050 M4,344 M5,112 M5,383 M
Total liabilities1,552 M1,728 M2,126 M2,011 M2,685 M3,470 M4,278 M4,049 M7,738 M8,066 M
Total non-current assets3,480 M3,758 M2,936 M3,065 M3,610 M3,750 M4,501 M4,810 M8,123 M7,928 M
Total non-current liabilities509 M622 M922 M806 M1,192 M1,664 M2,015 M1,911 M4,573 M4,659 M
TotalEquityGrossMinority4,241 M4,526 M3,088 M3,343 M3,796 M3,605 M4,054 M4,349 M5,117 M5,399 M
TotalEquityGrossMinorityInterest4,241 M4,526 M3,088 M3,343 M3,796 M3,605 M4,054 M4,349 M5,117 M5,399 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest5,793 M6,254 M5,214 M5,354 M6,480 M7,076 M8,332 M8,398 M12,855 M13,464 M
TotalNonCurrentLiabilitiesNetMinorityInteres509 M622 M922 M806 M1,192 M1,664 M2,015 M1,911 M4,573 M4,659 M
Treasury stock-215 M-322 M-1,795 M-14 M-85 M-554 M-587 M-858 M-980 M-1,188 M
UnearnedIncome1,387 M
UnearnedPremiums-26 M
Working capital1,271 M1,389 M1,074 M1,084 M1,378 M1,520 M1,568 M1,450 M1,568 M2,130 M
ltinv45 M45 M101 M211 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