All templates
Infrastructure

Airport Financial ModelFree Financial Model Download

Forecast airport revenues from landing fees, retail uplift, parking, and lounges, with realistic capex spending, concession economics, and debt service coverage analysis under a long-tenor concession.

Free download. No sign-up required.

Loading...

About this model

An airport project finance model forecasts aero and non-aero revenue (landing fees, retail, F&B, parking, lounges) driven by passenger volume growth, with realistic capex spending across construction and operating phases, to determine whether the airport can service non-recourse senior debt at a target minimum DSCR of 1.30x and deliver target equity IRR (typically 11–14%) over a 40-year concession period. The model answers the central project finance question: does the cash flow generation support the debt tenor, and what is the equity return profile?

Revenue streams include aeronautical revenue (landing fees, passenger facility charges, parking, allocated per passenger) and commercial revenue (retail, F&B, concession guarantees) which grows faster than aeronautical revenue due to penetration improvement. Costs are modelled as fixed cost categories (staff, utilities, maintenance, security, insurance) escalated by CPI, plus a variable per-passenger overlay and a concession fee to the government (typically 5% of total revenue). The balance sheet is project-finance specific: gross PP&E rolls forward with construction capex, IDC capitalisation in Year 4, and maintenance capex additions, while a DSRA (debt service reserve account) is funded at financial close and released at debt maturity. Debt is structured as a 25-year annuity (constant annual debt service) with a DSRA target equal to 6 months of forward debt service.

Infrastructure investors, lenders, and governments use airport models to assess project viability, stress traffic downside scenarios, confirm that DSCR floors don't breach lender covenants, and compare projected equity returns to the cost of capital (WACC target 10–12%).

income_statement.xlsx
Income statement, brown brand palette
income_statement.xlsx
Income statement, green brand palette
income_statement.xlsx
Income statement, red brand palette

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

  • Passengers by airline and route with growth assumptions
  • Landing fee revenue by aircraft type and MTOW
  • Retail, F&B, parking, and lounge revenue per passenger
  • Concessionaire rent escalation and revenue-sharing terms
  • Terminal capex, maintenance, and DSRA mechanics

Built for airport project finance

Use this model when DSCR coverage, concession period economics, and passenger-linked revenue growth drive the financing decision.

Separates aero from non-aero revenue

A useful airport model tracks aeronautical revenue (landing fees, PFCs) separately from commercial revenue (retail, F&B), with their distinct growth and margin profiles.

Capacity and capex aware

This maps terminal expansion to passenger thresholds so capex spend, debt sizing, and revenue uplift are explicitly linked.

Frequently asked

What is an airport financial model?+

It is a project finance model that forecasts aero and non-aero revenue, operating costs, capex, and debt service across a long-tenor airport concession.

How do I forecast retail uplift?+

Retail and F&B revenue is typically modelled as $8–15 per passenger; adjust for airport tier and traveller demographics.

What passenger growth should I assume?+

Mature airports grow 1–3% annually; emerging-market airports can grow 5–15%. Use historical trends and regional GDP growth as anchors.

How do landing fees scale with aircraft?+

Landing fees are charged per movement and typically vary by maximum takeoff weight (MTOW) or noise category.

Does it support DSCR analysis?+

Yes. The model includes a debt schedule with DSRA funding, target DSCR floor, and stress scenarios for traffic downside.

Alex Tapio, founder of Finamodel and ex-Deloitte financial modelling expert

Alex Tapio

Founder of Finamodel • Professional Financial Modeller • Ex-Deloitte