Project Overview
This project is a full-scope financial analysis and business intelligence dashboard built entirely in Power BI, using eight years of real financial statement data from AECOM (NYSE: ACM), a global infrastructure and engineering services company and constituent of the S&P MidCap 400 index.
The dashboard spans three interconnected pages — an Executive Overview, a Capital and Balance Sheet analysis, and a Profitability and Cost Analysis — and is designed to answer the questions a financial analyst, investor, or senior executive would actually ask when evaluating a company's long-term performance trajectory.
What makes this project different: Most financial dashboards display data. This one is engineered to surface the story inside the data — including custom metrics like Capital Allocation ROI by deployment channel, a Financial Resilience Score, a Scaling Efficiency index, and a Dividend Capacity calculation that goes beyond standard reporting.
All data was sourced from AECOM's publicly filed financial statements (10-K filings, 2018 to 2025). The data model, DAX measures, and dashboard design were built entirely from scratch in Power BI Desktop.
About AECOM (NYSE: ACM)
AECOM is one of the world's leading infrastructure consulting firms, providing design, engineering, construction management, advisory, and program management services across transportation, water, environment, facilities, and energy markets. The company operates in over 150 countries with approximately 51,000 employees and reported $16.1 billion in revenue for fiscal year 2025.
AECOM is listed on the New York Stock Exchange under the ticker ACM and is a constituent of the S&P MidCap 400 index. Over the eight-year period covered by this analysis (2018 to 2025), the company underwent significant strategic transformation — exiting its construction services segment, sharpening its focus on higher-margin professional services, and accelerating a capital return programme that returned over $0.5 billion to shareholders in 2025 alone.
Why AECOM? AECOM presents an analytically rich case study — a company that simultaneously navigated a revenue trough, executed a major strategic pivot, compressed its cost structure, and rebuilt profitability margins. Eight years of that journey produces a dataset that tests every dimension of financial analysis.
Methodology
The project followed a structured analytical workflow from raw financial statement data to a published interactive report:
Data Collection and Structuring
Income statement, balance sheet, and cash flow data was extracted from AECOM's annual 10-K filings for fiscal years 2018 through 2025. Data was structured into normalised tables — one per financial statement type — to support a clean star schema model in Power BI.
Power Query Data Transformation
Power Query was used to clean, reshape, and append the annual data into a unified fact table. Date tables were built programmatically to enable time intelligence. Calculated columns were added for year-over-year comparisons, rolling averages, and period-over-period percentage changes.
DAX Measure Development
Over 40 custom DAX measures were written to produce the metrics visible in the dashboard. These include standard financial KPIs (EBITDA margin, free cash flow, current ratio, debt-to-equity) and custom analytics measures (Capital Allocation ROI by channel, Financial Resilience Score, Scaling Efficiency index, Dividend Capacity, FCF Sustainability ratio, and a composite Solvency Buffer calculation).
Dashboard Design and Storytelling
Each of the three report pages was designed with a specific analytical question in mind. The Executive Overview answers: how has the business performed over eight years and what is its current trajectory? The Capital and Balance Sheet page answers: is the company financially resilient and how is capital being deployed? The Profitability and Cost Analysis page answers: is the cost structure improving, and is earnings quality getting better or worse?
Live Interactive Dashboard
Explore the full Power BI report below. The dashboard contains three pages — use the navigation arrows at the bottom of the embedded report to move between the Executive Overview, Capital and Balance Sheet, and Profitability and Cost Analysis pages.
Executive Overview: Key Findings
The Executive Overview page surfaces the top-line performance story across the full eight-year period, anchored by four composite KPIs:
Revenue Historical Peak (2019)
Revenue hit its eight-year high in 2019, representing a 53% increase above the historical low recorded in 2022 — the trough of AECOM's strategic restructuring period.
EBITDA Growth (Trough to Peak)
EBITDA reached its eight-year high of $1.2B in 2025, growing 320% from its 2019 low — a direct result of the shift from construction-heavy revenue to higher-margin professional services.
Operating Income Growth (YoY)
Revenue grew just 0.2% year over year in 2025, yet operating income grew 24.1% — a signal of improving operational leverage and cost absorption as revenue scales.
Shareholder Returns (2025)
AECOM returned $0.5B to shareholders through share repurchases and dividends in fiscal 2025, with dividends increasing 16% year over year — funded entirely by free cash flow of $0.7B.
Strategic Shifts Visible in the Data
The most analytically interesting signal in the Executive Overview is the divergence between revenue and EBITDA trends. Revenue declined from its 2019 peak and has grown only modestly since 2022. EBITDA, however, has grown consistently and rapidly across the same period. This divergence is the financial signature of AECOM's strategic pivot away from lower-margin construction services and toward higher-margin professional services — a decision that compressed revenue in the short term but dramatically improved the quality and durability of earnings.
EBITDA margin reached 7.5% in 2025, expanding by 120 basis points year over year. This margin expansion, while still below the 10%+ target AECOM's management has guided toward, represents consistent progress over the full eight-year observation window.
Capital Deployment in 2025
AECOM deployed 29% of total capital ($213M) toward business acquisitions during the year, alongside $0.5B in shareholder returns. Free cash flow of $0.7B funded both activities — demonstrating that the capital return programme is being sustained by operating performance rather than by borrowing or asset sales.
Capital & Balance Sheet: Solvency and Allocation
The Capital and Balance Sheet page addresses the fundamental question every investor and creditor asks: is this company financially resilient, and is it deploying capital effectively?
Solvency Trajectory
Current liabilities of $5.9B fell 7.0% year over year in 2025, reducing short-term pressure on the balance sheet. The debt maturity profile is conservative — 2% short-term and 98% long-term — which means the company faces minimal refinancing risk in the near term. Interest coverage of 5.6x comfortably services the existing debt load.
FCF Sustainability
With operating cash flow of $822M and maintenance capex of $176M, the FCF retention rate is 79% — meaning the business retains 79 cents of every operating dollar after maintaining its asset base. Dividend capacity of $646M sits well above actual dividend payments, providing a significant safety buffer for the capital return programme.
Capital Allocation ROI by Channel
The most provocative finding on the Capital and Balance Sheet page is the capital allocation ROI breakdown:
Organic growth capital generates 751.1% ROI — dwarfing the returns from share buybacks (3.6%) and M&A integration (0.3%). This finding has direct strategic implications: given the ROI differential, every dollar reallocated from acquisitions toward organic growth initiatives would generate dramatically higher returns on invested capital. This is the kind of actionable insight that justifies building a financial dashboard at this level of depth.
Profitability & Cost Analysis
The Profitability and Cost Analysis page examines whether the improving EBITDA story is backed by genuine cost discipline or is masking structural inefficiencies in the cost base.
Cost Structure: 98% Variable
AECOM's cost base is 98% variable — almost entirely composed of delivery costs, with corporate overhead at 1.0% and transformation OPEX at 0.8%. This cost structure means the business has very limited operating leverage in the traditional sense: costs scale proportionally with revenue. However, it also means the business is highly resilient in a revenue downturn — the cost base contracts with revenue, protecting cash flow.
Scaling Efficiency and Earnings Quality
The Scaling Efficiency index of +4,839% measures how much faster operating income has grown relative to the cost base over the full eight-year period. This extraordinary figure reflects the cumulative effect of multiple years of cost discipline — particularly in corporate overhead and transformation OPEX — combined with a shift toward higher-margin revenue. Revenue vs Operating Cost charts confirm that the gap between revenue and cost has widened meaningfully since 2022.
Earnings quality — measured by the relationship between net income and operating cash flow — shows healthy alignment, with operating cash flow consistently exceeding net income in recent years. This indicates that reported earnings are backed by actual cash generation rather than accounting accruals, which is a key quality signal for investors and analysts.
Return on Invested Capital Trajectory
ROIC has grown from 0.01 in 2018 to 0.55 in 2025 — a 50-fold improvement over the observation window. This is the single most compelling number in the entire dataset. A ROIC of 0.55 means that for every dollar of invested capital, AECOM is generating 55 cents in operating return — an exceptional figure for a professional services business of this scale. The trajectory confirms that the strategic pivot has not just improved margins but has fundamentally changed the capital efficiency of the entire business model.
Tools & Technologies
This project was built using the Microsoft BI stack throughout, making it reproducible and maintainable for any organisation already using Microsoft 365.