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.
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%).



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 • Professional Financial Modeller • Ex-Deloitte
Related templates
Port Authority and Terminal Model
Container throughput, terminal operations, revenue, and profitability for port and container terminal operators.
Toll Road Concession Model
Model toll road cash flows, traffic demand, toll rate escalation, and debt service with concession life assumptions.
Railway Concession and Operations Model
Passenger and freight revenue, operating costs, capital investment, and concessionaire returns for railway projects.
Fibre Network Deployment Model
Capital and financial model for fiber optic network buildout with capex, subscribers, and ARPU.