Infrastructure Bond Valuation ModelFree Financial Model Download
Value infrastructure bonds by forecasting project cash flows, calculating debt service coverage ratios, and stress-testing covenant compliance. Model refinancing risk, subordinated equity returns, and credit spread sensitivity under base and downside scenarios.
Free download. No sign-up required.
About this model
This project finance model values infrastructure bonds (toll road concession) by forecasting toll revenue, calculating debt service coverage ratio (DSCR) and loan life coverage ratio (LLCR), and computing project and equity IRR over a 28-year projection (3-year construction + 25-year operations). Answer: can the project sustain 1.50× DSCR in all operating years and generate 10–14% equity IRR with traffic volume and tariff risks?
The workbook projects toll revenue from two streams: light vehicles (55,000 daily AADT × £2.80 toll × 365 × occupancy ramp 70%→100% Years 1–3, then 1.5% annual growth, 98% collection efficiency) and heavy vehicles (6,000 AADT × £8.40 = 3× light rate × 2% annual growth). Operating costs: toll collection 4% of revenue, routine O&M £160k/km (total £6.4M for 40km corridor), SPV management £2.8M, insurance £1.2M. All opex escalates at 2.5% CPI annually. Lifecycle capex: £30M major resurfacing (Years 12, 24), £4M tolling refresh (Years 8, 20). Senior debt: £381M drawn across construction, interest during construction (IDC) capitalised, repayment sculpted to hit 1.50× DSCR target.
Used by infrastructure funds, concession sponsors bidding on toll roads and ports, project lenders sizing non-recourse debt, and public authorities evaluating PPP vs. public delivery. The model reveals extreme traffic ramp sensitivity: 1% miss in traffic volume erodes Year 1 DSCR by ~50–100 bps. Toll escalation mechanics (CPI 2.5% p.a.) typically lag inflation (2.5%+), making real tariff decline a long-term headwind. Lifecycle capex lumpy nature requires careful DSRA/MMRA reserve sizing. Benchmarks: Transurban (TCL.AX), Ferrovial (FER.MC), Abertis—all operating toll roads at 70–85% EBITDA margins with 1.3–1.8× steady-state DSCR.
Recolor to your brand.
Formatted to IB standards.
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with blue inputs, black formulas, and green cross-sheet links.
- Brand-ready
- Institutional grade
- Fully auditable
What's included
- Project revenue forecasts including tolls, concession fees, and user charges
- Operating expense and maintenance cost schedules
- Debt service schedule with interest and principal repayment
- Debt service coverage ratio and leverage covenants
- Subordinated equity returns and distribution waterfall
Debt service coverage analysis
Calculate annual and average DSCR to assess covenant compliance and identify periods of stress or default risk across the project life.
Covenant monitoring and trigger scenarios
Model DSCR and leverage thresholds, identify technical default scenarios, and show recovery value in a restructuring context.
Refinancing and maturity profile
Model refinancing needs at maturity, assess refinancing risk given market interest rate assumptions, and calculate terminal value.
Frequently asked
What DSCR levels correspond to different credit ratings?+
AAA/AA typically requires DSCR above 2.0x, A requires 1.5-2.0x, BBB requires 1.25-1.5x, and below-investment-grade implies coverage below 1.25x. Thresholds vary by project risk and sponsor strength.
How do I model refinancing risk?+
Assume refinancing at maturity using then-current interest rates. Run a base case with flat rates and a stress scenario with rates 100-200bps higher, then assess whether DSCR remains sufficient.
What is an appropriate traffic or revenue growth assumption?+
Use conservative near-term growth of 1-3% annually for mature projects and 5-10% for growing markets, with growth flattening in later years. Incorporate stochastic traffic scenarios for downside analysis.
Who uses infrastructure bond models?+
Fixed income investors, project finance teams, rating agencies, and infrastructure funds use these models for credit analysis, investment decisions, and deal structuring.
How does subordination affect bond returns?+
Senior bonds receive payment before subordinated debt and equity. Higher subordination provides a thicker loss buffer, enabling lower coupon rates and stronger credit ratings for senior tranches.
Alex Tapio
Founder of Finamodel • Professional Financial Modeller • Ex-Deloitte
Related templates
Toll Road Concession Model
Model toll road cash flows, traffic demand, toll rate escalation, and debt service with concession life assumptions.
Infrastructure Concession and Toll Road Model
Concession agreement model for toll roads, airports, and ports including traffic/volume forecasts, tariff escalation, and equity returns.
Bond Trading Model
Fixed income trading desk P&L and risk analytics.
Fibre Network Deployment Model
Capital and financial model for fiber optic network buildout with capex, subscribers, and ARPU.