Airport Operator Financial Model – Excel XLSX

BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT

1. Airport Operator Financial Model presents the business case of an already operating airport (with planned refurbishments) and an investment in a new terminal in the same airport.
2. The model generates the three financial statements as well as the cash flows and calculates the relevant metrics (Discounted cash flows, Net Present Value, Internal Rate of Return, payback period, cash on cash multiple, enterprise value, etc…).
3. The financing options for the project include a standard long term loan as well as an overdraft facility and of course equity funding from investors.

AIRLINE INDUSTRY EXCEL DESCRIPTION

Editor Summary Airport Operator Financial Model is an XLSX financial model that generates the 3 financial statements, cash flows, and valuation outputs for an operating airport with planned refurbishments and a new terminal. Read more It calculates DCF metrics (NPV, IRR), payback period, cash-on-cash multiple, enterprise value, and banking ratios (DSCR, LLCR), and models financing via long-term loan, overdraft, and equity. Created by a Financial Modeling consultant with 15+ years at Ernst & Young and corporate finance certifications; sold as a digital download on Flevy.

Use this model when assessing the financial viability of an operating airport undergoing refurbishment and a new terminal investment, preparing investor memoranda, or assembling lender packages.
  Project finance analysts building a DCF, debt amortization schedule, and sensitivity analysis to calculate NPV, IRR, and payback for a terminal investment.
  Airport CFOs quantifying how refurbishment capex and fixed versus variable operating cost splits affect profit and cash flow.
  Infrastructure equity investors comparing cash-on-cash multiples and equity IRR under different financing mixes (long-term loan, overdraft, equity).
  Commercial bankers assessing lending capacity using DSCR and LLCR from projected cash flows.
The model follows standard project finance steps—terminal-level revenue forecasts, cost and working-capital schedules, debt servicing, and valuation via free cash flows to the firm.

Airport Operator Financial Model presents the business case of an already operating airport (with planned refurbishments) and an investment in a new terminal in the same airport. The model generates the three financial statements as well as the cash flows and calculates the relevant metrics (Discounted cash flows, Net Present Value, Internal Rate of Return, payback period, cash on cash multiple, enterprise value, etc…). The financing options for the project include a standard long term loan as well as an overdraft facility and of course equity funding from investors.

So a quick overview of the model, in the contents tab you can see the structure of the model and by clicking on any of the headlines to be redirected to the relevant worksheet.

On the manual tab, you are able to feed the general information for the model such as: project title, responsible, the timeline of the model and date and currency conventions.

Additionally, there is a description of the color-coding of the model in the same tab. Inputs are always depicted with a yellow fill and blue letters, call up (that is direct links from other cells) are filled in light blue with blue letters while calculations are depicted with white fill and black characters.

There is also a color coding for the various tabs of the model. Yellow tabs are mostly assumptions tabs, grey tabs are calculations tabs, blue tabs are outputs tabs (that is effectively results or graphs) and finally, light blue tabs are admin tabs (for example: the cover page, contents, and checks).

Guide Tab: This tab helps you to gain a grasp of the main value drivers and critical issues of the business.

Moving on to the Inputs (You have two sets of assumptions one for the existing terminal and for the new one…): detailed inputs for revenues (aeronautical charges, cargo & mail revenues, commercial revenues – nonaeronautical), costs splits between fixed (maintenance, material – utilities, marketing & advertisement, insurance, rescue fire fighting) and variable (Operator personnel, Airline support cost, purchased services, other), working capital (receivables, payables, and inventory), fixed assets and capex (split into existing terminal refurbishments and new terminal investment), equity financing as well as valuation assumptions (such as discount rates used in the weighted average cost of capital).

In the summary tab, you are able to see a high-level report with the main metrics and value drivers of the model. It can be readily printed on one page for your convenience.

Calculations: This is where all calculations are performed. The revenues for each terminal are calculated based on the passenger and cargo traffic and various yields used in the assumptions and deducting the operating costs adjusted for inflation the operating profit is resulting. Based on the assets financed and the gearing of the financing the interest and depreciation are occurring. By using the working capital assumptions the impact of the business cycle is presented. Finally depending on the level of the investment considered the relevant debt financing is calculated (Long term debt and overdraft).

In the Outputs tab: everything is aggregated here into the relevant statements: profit and loss, balance sheet and cash flow.

Moving to the Investment Metrics tab, a valuation is performed by using the free cash flows to the firm and then a series of investment metrics are presented (Net Present Value, Internal Rate of Return, Payback Period, Cash on Cash multiple). Additionally, the Debt Service Coverage Ratio and the Loan Life Coverage Ratio are presented.

In the Graphs tab: Various graphs present the investment and operating costs, the revenues, and the banking ratios (DSCR and LLCR). Then multiple charts present the performance of the project from revenues to bottom line along with debt, assets, working capital and cash flows which result in valuation on a project basis as well as on an equity basis together with the internal rate of return of the project and payback period metrics.

Checks: A dedicated worksheet that makes sure that everything is working as it should!

Important Notice: Yellow indicates inputs and assumptions that the user is able to change, blue cells are used for called up cells, and white cells with black characters indicates calculation cells.

TOPIC FAQ

What are the core financial statements and valuation metrics used in airport project finance?

Airport project finance relies on the profit & loss, balance sheet, and cash flow statements plus valuation from discounted cash flows. Common investment metrics include Net Present Value, Internal Rate of Return, payback period, cash-on-cash multiple, enterprise value, and lending ratios such as Debt Service Coverage Ratio and Loan Life Coverage Ratio.

How do you model revenues for an airport operator?

Airport revenues are typically modeled by terminal and revenue stream: aeronautical charges, cargo & mail, and non-aeronautical commercial revenue. Passenger and cargo traffic forecasts are multiplied by respective yields to derive revenues, with separate assumptions for existing and new terminals based on traffic and yield inputs.

What debt metrics should lenders prioritize when evaluating a terminal project?

Lenders focus on coverage and life metrics that indicate debt-service safety: Debt Service Coverage Ratio and Loan Life Coverage Ratio. Models also need clear debt schedules distinguishing long-term loan amortization and any short-term overdraft exposure to assess serviceability over the project life.

How do working capital assumptions change cash flow projections for an airport?

Changes in receivables, payables, and inventory timing affect cash conversion and free cash flow volatility across the business cycle. Properly modeling receivables, payables, and inventory turns translates operating profit into projected cash inflows and outflows that drive valuation and debt servicing.

What should I look for when choosing a financial model template for an airport investment?

Choose a template that produces the 3 financial statements, cash flows, valuation metrics (NPV, IRR, payback), clear debt options (long-term loan, overdraft, equity), and internal controls such as a Guide tab, color-coded inputs, and a dedicated Checks worksheet — as found in Flevy's Airport Operator Financial Model.

What level of expertise is needed to adapt a prebuilt airport financial model?

Prebuilt models reduce setup effort by using color-coded inputs, a Manual tab for conventions, and a Guide tab describing value drivers; however, users still need familiarity with revenue drivers, capex scheduling, working-capital mechanics, and debt servicing to ensure assumptions are appropriate for the project and model structure.

Which modeling steps are essential when evaluating refurbishments plus a new terminal?

Essential steps include defining separate assumptions for the existing terminal and the new terminal, forecasting passenger and cargo revenues by terminal, splitting operating costs into fixed and variable, inputting capex by asset (refurbishment vs new build), building debt schedules, aggregating outputs into the 3 statements, and valuing via free cash flows to the firm.

How do prebuilt templates compare to building a model from scratch for project finance?

Prebuilt templates provide a structured contents tab, consistent color-coding for inputs and calculations, prebuilt checks, and ready-to-print summary outputs, which reduce modeling errors and speed review cycles; look for a template that includes a printable one-page Summary tab for stakeholder presentations.

Source: Best Practices in Airline Industry, Integrated Financial Model Excel: Airport Operator Financial Model Excel (XLSX) Spreadsheet, Big4WallStreet