Port Operator Financial Model – Excel XLSX

BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT

1. The model generates the three financial statements as well as the cash flows.
2. 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.

SHIPPING INDUSTRY EXCEL DESCRIPTION

Editor Summary Port Operator Financial Model is an XLSX financial model (spreadsheet) that builds the business case for an operating port terminal with planned refurbishments and a new terminal investment, producing 3 financial statements, cash flows and valuation metrics (DCF, NPV, IRR, payback, cash-on-cash multiple, enterprise value). Read more Includes separate inputs for existing and new terminals, working capital, capex split, financing options (long-term loan, overdraft, equity), summary and graphs across roughly 10 worksheets. Created by a financial modeling consultant with 15+ years at Ernst & Young, Toyota, Viohalco and Upstream; certified by CFI and FMI; sold as a digital download on Flevy.

Use this model when you need to build or stress-test a project finance business case for a port terminal investment—whether assessing refurbishments, adding capacity, or pitching to lenders and investors.

  Project finance analysts stress-testing cash flows, debt sizing, and covenant ratios using DSCR and LLCR calculations.
  Infrastructure investors comparing NPV, IRR, payback, and cash-on-cash returns across financing scenarios.
  Port operations managers projecting revenues from transshipment and domestic traffic by adjusting tariffs and traffic assumptions.
  Corporate finance consultants preparing a one-page executive summary and valuation outputs for investor presentations.

The model’s three-statement linkage, DCF valuation and debt-service metrics align with project finance modeling practices used at Ernst & Young.

Port Operator Financial Model presents the business case of an already operating port terminal (with planned refurbishments) and an investment in a new terminal in the same port. 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 (transshipment and domestic traffic, handing and storage tariffs), costs (maintenance costs, labor costs, admin costs, fuel and electricity expenses, rent). Some of these costs are fixed and others are variable ), 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: these were all calculations are performed. The revenues for each terminal are calculated based on the traffic and tariff 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 per terminal (existing and new) 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 essential components of a port operator financial model?

A port operator financial model typically includes linked profit & loss, balance sheet and cash flow statements, revenue drivers (transshipment and domestic traffic, handling and storage tariffs), operating costs, working capital, capex, financing structure and valuation outputs such as DCF, NPV and IRR, with summarized outputs on a single page.

How should I model revenue separately for an existing terminal and a new terminal?

Use 2 sets of assumptions—one for the existing terminal and one for the new terminal—capturing traffic volumes and tariff schedules for each. Calculate revenues per terminal, deduct operating costs, and consolidate results into the aggregated outputs worksheets using the 2 sets of assumptions.

Which valuation and investment metrics are standard for terminal project finance?

Standard investment metrics include discounted cash flows, Net Present Value, Internal Rate of Return, payback period, cash-on-cash multiple and enterprise value. Project finance models also typically present banking ratios used for lending decisions, such as Debt Service Coverage Ratio and Loan Life Coverage Ratio.

What financing options should I include when modeling a port investment?

Typical financing options to model are equity funding from investors, a standard long-term loan to refinance capex, and a working-capital overdraft facility; the model should calculate interest, amortization, and their effects on cash flow and leverage under each option.

What features should I look for when buying a port operator financial model template?

Look for a template that delivers linked 3 financial statements, separate inputs for existing and new terminals, clear color-coded input and calculation cells, valuation outputs (DCF, NPV, IRR), banking ratios (DSCR, LLCR), printable executive summary and a Checks worksheet for integrity control.

How can I demonstrate value to lenders and investors with a port model?

Provide a concise, printable summary that highlights project cash flows, debt service capacity and valuation metrics—showing NPV, IRR, payback and coverage ratios—to support lending covenants and investment decisions, and include DSCR and LLCR to address creditor concerns.

I need to evaluate refurbishing an existing terminal and building a new one—what should the model capture?

Capture capex split between existing-terminal refurbishments and the new-terminal investment, terminal-specific revenues (traffic and tariffs), operating and maintenance costs, working capital movements, and financing structure to produce consolidated financial statements and valuation via free cash flow to the firm.

How do DSCR and LLCR affect debt sizing in a port project model?

DSCR and LLCR measure a project’s ability to meet debt service and overall loan coverage; modeling these ratios across forecast periods helps determine acceptable loan amounts and amortization profiles for lenders, with explicit DSCR and LLCR outputs informing debt-sizing decisions.

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