QUANTA SERVICES, INC. (PWR)

Import this data to Google Sheets with:

=jivedata("PWR","financials")

Full statements spill as a table. For one cell: =jivedata("PWR","Revenue") or =jivedata("PWR","Revenue","TTM"). Install the Jive Data add-on, then paste into a cell.

QUANTA SERVICES, INC.

PWR • CIK 0001050915

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Revenue from Contract with Customer, Excluding Assessed Tax	$20,882,206	$23,672,795	$28,479,697	$32,905,140
Cost of Goods and Services Sold	$17,945,120	$20,162,034	$24,204,616	$27,819,163
Gross Profit	$2,937,086	$3,510,761	$4,275,081	$5,085,977
Selling, General and Administrative Expense	$1,555,137	$1,824,754	$2,189,209	$2,486,104
Amortization of Intangible Assets	$289,014	$382,959	$498,795	$585,393
Business Combination, Contingent Consideration Arrangements, Change in Amount of Contingent Consideration, Liability	$6,568	$7,064	$31,203	$33,042
Operating Income (Loss)	$1,127,976	$1,346,468	$1,611,509	$2,035,759
InterestExpenseNonoperating	—	$202,687	$261,445	$294,369
Investment Income, Interest	$10,830	$32,404	$15,702	$14,294
Other Nonoperating Income (Expense)	$18,063	$35,845	$23,739	$-132
Income (Loss) from Continuing Operations before Income Taxes, Noncontrolling Interest	$969,956	$1,212,030	$1,389,505	$1,755,552
Income Tax Expense (Benefit)	$219,267	$284,747	$347,588	$405,117
Net Income (Loss), Including Portion Attributable to Noncontrolling Interest	$750,689	$927,283	$1,041,917	$1,350,435
Net Income (Loss) Attributable to Noncontrolling Interest	$6,000	$22,459	$13,539	$23,559
Net Income (Loss) Attributable to Parent	$744,689	$904,824	$1,028,378	$1,326,876
Weighted Average Number of Shares Outstanding, Basic	145,222,000	146,929,000	148,790,000	150,424,000
Weighted Average Number of Shares Outstanding, Diluted	148,823,000	150,056,000	151,291,000	152,643,000
Incremental Common Shares Attributable to Dilutive Effect of Share-based Payment Arrangements	3,601,000	3,127,000	2,501,000	2,219,000

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Cash and Cash Equivalents, at Carrying Value	$1,290,248	$741,960	$439,508	$506,431
Accounts Receivable, after Allowance for Credit Loss, Current	$4,410,829	$5,170,935	$6,847,091	$8,532,311
Property, Plant, and Equipment and Finance Lease Right-of-Use Asset, after Accumulated Depreciation and Amortization	$2,336,943	$2,700,277	$3,455,204	$3,697,411
Contract with Customer, Asset, after Allowance for Credit Loss, Current	$1,413,057	$1,208,619	$1,522,186	$1,534,265
Operating Lease, Right-of-Use Asset	$249,443	$299,895	$400,814	$467,652
Inventory, Net	$175,658	$260,181	$370,372	$469,865
Other Assets, Noncurrent	$565,625	$655,709	$944,050	$1,182,033
Prepaid Expense and Other Assets, Current	$387,105	$469,338	$724,260	$816,882
Intangible Assets, Net (Excluding Goodwill)	$1,362,412	$1,860,537	$2,906,188	$3,216,084
Assets, Current	$7,676,897	$7,851,033	$9,903,417	$11,859,754
Goodwill	$4,045,905	$5,316,443	$7,317,228	$7,868,886
Assets	$16,237,225	$18,683,894	$24,926,901	$28,291,820
Long-term Debt and Lease Obligation	$3,663,504	$4,099,756	$5,231,008	$5,421,862
Operating Lease, Liability, Noncurrent	$186,996	$222,359	$309,671	$372,875
Deferred Income Tax Liabilities, Net	$254,004	$353,268	$502,626	$513,921
Other Liabilities, Noncurrent	$636,250	$650,281	$1,139,524	$1,442,762
Liabilities	$9,953,870	$11,354,177	$15,899,027	$18,549,877
Debt, Current	$535,202	$62,680	$763,898	$683,022
Operating Lease, Liability, Current	$77,995	$94,162	$114,377	$125,376
Accounts Payable and Accrued Liabilities, Current	$3,061,242	$3,722,343	$4,579,458	$5,748,126
Contract with Customer, Liability, Current	$1,538,677	$2,149,328	$3,258,465	$4,241,933
Liabilities, Current	$5,213,116	$6,028,513	$8,716,198	$10,798,457
Common Stock, Value, Issued	$2	$2	$2	$2
Additional Paid in Capital, Common Stock	$3,002,652	$3,444,108	$4,278,741	$4,527,538
Retained Earnings (Accumulated Deficit)	$4,858,066	$5,707,286	$6,673,990	$7,312,393
Accumulated Other Comprehensive Income (Loss), Net of Tax	$-282,945	$-372,708	$-307,211	$-341,150
Treasury Stock, Common, Value	$1,305,534	$1,460,957	$1,707,273	$1,860,841
Stockholders' Equity Attributable to Parent	$6,272,241	$7,317,731	$8,938,249	$9,637,942
Stockholders' Equity Attributable to Noncontrolling Interest	$11,114	$11,986	$89,625	$104,001
Stockholders' Equity, Including Portion Attributable to Noncontrolling Interest	$6,283,355	$7,329,717	$9,027,874	$9,741,943
Common Stock, Shares Authorized	600,000,000	600,000,000	600,000,000	600,000,000
Common Stock, Shares, Issued	173,949,011	176,718,480	179,534,355	180,502,506
Common Stock, Shares, Outstanding	145,508,549	147,678,512	149,577,564	150,273,799
Treasury Stock, Common, Shares	28,440,462	29,039,968	29,956,791	30,228,707
Revenue, Remaining Performance Obligation, Amount	$13,890,000	$16,760,000	$23,760,000	$33,550,000
Contract with Customer, Liability, Revenue Recognized	$1,040,000	$1,420,000	$1,980,000	$2,530,000
Contract with Customer, Receivable, after Allowance for Credit Loss, Current	$610,000	$666,500	$994,100	$1,190,000
Contract with Customer, Receivable, after Allowance for Credit Loss, Noncurrent	$78,700	$143,600	$228,700	$312,700
Unbilled Contracts Receivable	$743,600	$859,900	$1,100,000	$1,390,000
Revenue from Contract with Customer, Excluding Assessed Tax	$20,882,206	$23,672,795	$28,479,697	$17,431,784
Accounts Receivable, Allowance for Credit Loss	$13,962	$15,185	$15,706	$12,156
Accounts Receivable, Credit Loss Expense (Reversal)	$5,927	$4,279	$3,717	$-2,990
Finance Lease, Right-of-Use Asset, after Accumulated Amortization	$35,770	$43,018	$87,242	$87,242
Finance Lease, Liability, Current	$7,767	$11,641	$69,608	$69,608
Finance Lease, Liability, Noncurrent	$31,810	$36,352	$23,447	$23,447

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Net Income (Loss), Including Portion Attributable to Noncontrolling Interest	$750,689	$927,283	$1,041,917	$1,350,435
Net Cash Provided by (Used in) Operating Activities	$1,575,952	$2,081,196	$2,229,970	$3,178,249
Effect of Exchange Rate on Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Including Disposal Group and Discontinued Operations	$7,025	$-30,272	$22,833	$7,016
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect	$861,827	$-549,031	$-303,187	$-689
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$1,295,041	$746,010	$442,823	$289,426
Depreciation	$324,786	$359,363	$411,538	$445,131
Payments to Acquire Property, Plant, and Equipment	$434,803	$604,078	$609,154	$787,091
Amortization of Intangible Assets	$289,014	$382,959	$498,795	$585,393
Share-based Payment Arrangement, Noncash Expense	$126,762	$150,526	$181,947	$225,738
Payments to Acquire Other Productive Assets	—	—	$103,370	$103,370
Other Operating Activities, Cash Flow Statement	$-8,344	$20,977	$79,795	$90,803
Payments to Acquire Businesses, Net of Cash Acquired	$651,623	$1,745,735	$3,052,116	$3,396,325
Payments to Acquire Investments	$7,537	$81,871	$148,900	$27,222
Proceeds from Sale, Maturity and Collection of Investments	$42,277	$29,239	$17,012	$17,012
Payments for (Proceeds from) Other Investing Activities	$7,311	$-30,483	$-13,638	$-23,982
Net Cash Provided by (Used in) Investing Activities	$-989,650	$-2,294,319	$-3,830,974	$-4,209,240
Proceeds from Long-term Lines of Credit	$18,178,910	$19,884,184	$53,033,943	$72,083,486
Repayments of Long-term Lines of Credit	$17,770,246	$20,714,993	$52,778,666	$72,261,716
Proceeds from Notes Payable	—	$1,238,741	$1,488,995	$1,488,995
Repayments of Senior Debt	—	$500,000	$0	$0
Payment for Contingent Consideration Liability, Financing Activities	—	—	$102,558	$7,246
Payment, Tax Withholding, Share-based Payment Arrangement	$119,793	$155,550	$112,299	$192,662
Payments of Ordinary Dividends, Common Stock	$47,752	$54,196	$60,416	$63,793
Payments for Repurchase of Common Stock	$350	$0	$134,555	$0
Proceeds from (Payments for) Other Financing Activities	$27,731	$-3,822	$-59,460	$-32,488
Net Cash Provided by (Used in) Financing Activities	$268,500	$-305,636	$1,274,984	$1,023,286
Increase (Decrease) in Accounts and Notes Receivable	$615,668	$428,127	$853,835	$1,911,514
Increase (Decrease) in Contract with Customer, Asset	$303,064	$-255,744	$217,627	$404,877
Increase (Decrease) in Inventories	—	$39,517	$121,743	$195,936
Increase (Decrease) in Prepaid Expense and Other Assets	$90,329	$-40,356	$240,515	$-7,106
Increase (Decrease) in Other Accounts Payable and Accrued Liabilities	$771,854	$52,421	$654,961	$1,474,398
Increase (Decrease) in Contract with Customer, Liability	$293,106	$373,622	$824,454	$1,557,462
Increase (Decrease) in Other Operating Assets and Liabilities, Net	$-6,718	$8,333	$29,717	$55,722

Loading financial statements…

Import this data to Google Sheets with:

=jivedata("PWR","financials")

Full statements spill as a table. For one cell: =jivedata("PWR","Revenue") or =jivedata("PWR","Revenue","TTM"). Install the Jive Data add-on, then paste into a cell.