Toll Road Model
Infrastructure Financial Model (Free Excel Download)
Model traffic, toll escalation, operating costs, maintenance capex, concession terms, debt sculpting, and equity returns for a toll-road project.
professionals from Deloitte
Used by professionals from
About this model
Model a 40-year toll road concession with traffic-driven revenue, toll rate escalation, construction phasing, and non-recourse project finance debt. The model projects annual traffic volumes for light and heavy vehicles separately (growing at 1.5% p.a.), applies tiered toll rates ($2.50 light, 3.0x heavy multiplier), and accounts for collection inefficiency (96% collection efficiency). Revenue compounds as toll rates escalate at CPI (2.5% p.a.).
Operating expenses include routine O&M ($150k/km/yr), toll collection costs (4% of revenue), insurance (3% of revenue), and lifecycle capex (resurfacing every 12 years at $750k/lane-km). EBITDA margins are exceptionally high (70–85%) due to minimal marginal costs. Debt is structured as a 25-year amortizing term loan at 5.5% (base rate 4% + 150 bps margin), sized to maintain minimum 1.30x DSCR. Equity distributions are gated by a lock-up covenant: distributions are withheld if DSCR falls below 1.15x.
Key metrics: project IRR (9–12% unlevered), equity IRR (15–25% levered at 75% Debt/Capital), and payback period (8–12 years). Traffic risk dominates sensitivity analysis; 10% lower traffic reduces equity IRR by 300+ basis points. Comparable concessions (Transurban, Vinci Autoroutes, Ferrovial Cintra) trade at 12–15x EV/EBITDA due to predictable, inflation-linked cash flows and essential infrastructure status.
What every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the Toll Road Model
- Annual average daily traffic (AADT) forecast by vehicle category
- Toll rate sensitivity and price elasticity modelling
- Routine O&M and periodic major maintenance lifecycle schedules
- Debt sculpting based on target DSCR
- Concession period logic with hand-back condition modelling
- Traffic volume projections by vehicle class and season
- Toll rates by vehicle type with annual escalation and congestion pricing
- Operating and maintenance cost assumptions and inflation
How a Toll Road Model Works: Traffic, Costs and Debt
A toll road model projects concession cash flows from traffic volume, toll tariffs, operating costs, maintenance cycles and non-recourse debt. This template spans a full build-operate-transfer term, so readers can see how a light and heavy vehicle forecast, a sculpted debt schedule and reserve accounts combine to test whether a concession stands up to investment or lending criteria.
Traffic and toll revenue formation
Revenue begins with average daily traffic split between light and heavy vehicles. Each class has its own base volume, ramp-up factor for the opening years and long-term growth rate, converting daily counts into annual trips.
- Toll rates start from a per-trip base, with heavy vehicles commonly paying a multiple because of greater road wear and value of time. Tariffs escalate with inflation, and collection efficiency reduces billed traffic to cash actually collected.
- The model therefore keeps traffic growth and toll escalation as separate drivers, letting you test how a change in either affects gross revenue.
Operating costs and lifecycle maintenance
Operating costs are split into six separately driven lines: routine maintenance per kilometre, tolling system costs as a share of revenue, traffic management per kilometre, an annual SPV administration charge, insurance as a percentage of revenue and toll collection fees.
- Lifecycle capex is modelled separately as lumpy resurfacing every twelve operating years, phased over three years, rather than a smooth annual allowance.
- The final resurfacing cycle is intentionally truncated before concession end, reflecting the hand-back of the asset to the grantor.
- This separation keeps routine opex in the income statement while heavy maintenance is capitalised into the concession asset.
Debt, reserves and cash flow waterfall
The debt schedule sizes senior gearing on total project cost and sculpts principal repayments to a target debt service coverage ratio using cash flow available for debt service. Interest is calculated on the prior-period balance, which avoids circularity.
- A debt service reserve account is funded forward-looking, typically covering six months of debt service, and is capped at cash remaining after debt service. The waterfall then prioritises debt service and reserve funding before equity distributions, which are allowed only when the lock-up coverage test is passed.
- Coverage ratios such as LLCR and PLCR help lenders assess long-term resilience.
Outputs and practical use
Outputs include the income statement, balance sheet, cash flow statement, project and equity IRRs, NPV, equity multiple, DSCR profile and loan life and project life coverage ratios.
- Validation checks confirm the balance sheet balances, debt is repaid by maturity, the concession asset reaches zero at hand-back, DSCR stays above one, and sources equal uses during construction.
- The model is aimed at infrastructure funds, pension funds, project finance lenders and developers evaluating a greenfield or brownfield concession.
- The public download is a values-only preview; it shows the structure and relationships rather than live formulas.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
What is a toll road financial model?+
It is a project finance model that forecasts traffic, toll revenue, operating costs, debt service, and investor returns over a long-term concession period.
Who uses toll road models?+
Infrastructure investors, project finance bankers, PPP consultants, and government transport authorities use them for bidding, underwriting, and asset management.
What should a toll road model include?+
It should include traffic forecasting by vehicle class, toll escalation, O&M and lifecycle maintenance costs, debt sculpting, and DSCR/LLCR tracking.
How does debt sculpting work in a toll road model?+
Debt sculpting calculates principal repayments to maintain a target debt service coverage ratio, optimising leverage based on the predictable but fluctuating cash flows of the asset.
Does it account for traffic ramp-up periods?+
Yes. The model includes ramp-up adjustment factors for the first years of operation, reflecting the time it takes for traffic to stabilise on a new road.
Have more financial modelling questions? Contact us
Related templates
Railway Concession and Operations Model
Passenger and freight revenue, operating costs, capital investment, and concessionaire returns for railway projects.
Public-Private Partnership Availability Model
Revenue availability model, unitary payments, debt service coverage, and equity IRR for PPP infrastructure projects.
Infrastructure Concession and Toll Road Model
Concession agreement model for toll roads, airports, and ports including traffic/volume forecasts, tariff escalation, and equity returns.
Fibre Network Deployment Model
Capital and financial model for fiber optic network buildout with capex, subscribers, and ARPU.
