Port Authority and Terminal Model
Infrastructure Financial Model (Free Excel Download)
Forecast throughput, tariffs, berth utilisation, operating costs, expansion capex, concession obligations, and project-finance returns for a port asset.
professionals from Deloitte
Used by professionals from
About this model
Model port terminal operations and container handling economics for a mid-tier facility serving a regional shipping corridor. This template projects container throughput in TEUs with capacity constraints, calculates stevedoring revenue per TEU, wharfage fees per vessel call, and demurrage income on delayed containers. Operating costs include direct labor (gang rates), fuel for yard equipment, electricity for cranes, variable concession fees to the port authority, and fixed opex for maintenance, insurance, and terminal management.
The workbook contains a traffic and capacity sheet modeling utilization rates and throughput ramps post-opening, a revenue builder for stevedoring/wharfage/storage/value-added services, an opex schedule with labor productivity assumptions, capex for STS cranes and dredging, and a debt schedule for project finance with DSCR covenant monitoring. The cash flow waterfall allocates revenues through debt service, reserve accounts, and equity distributions. The model handles construction capex during a 3-year build phase with interest during construction, then projects stable-state EBITDA margins of 40–60% and FCF yields of 15–30%.
Target users are infrastructure investors, port authorities evaluating concessionaire bids, project finance lenders, and operators assessing terminal acquisition or expansion on asset values of $500M to $2B+.
What every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the Port Authority and Terminal Model
- Container throughput forecasts by vessel size and route
- Berth utilisation and crane productivity assumptions
- Labor costs, productivity, and staffing model
- Equipment capex and maintenance cost schedules
- Port tariffs, stevedore services, and ancillary revenue
- Terminal EBITDA and return on terminal capex
How the Port Model Evaluates Terminal Operations and Investment Returns
This port model projects the financial performance of a marine terminal concession, from vessel calls and cargo volumes through to investor returns. It is designed for sponsors, infrastructure funds, and lenders assessing whether to bid on, invest in, or finance a seaport or terminal.
The template captures operating drivers, cost structure, capital requirements, debt sizing, and cash flow mechanics.
What Drives Terminal Revenue and Volume
The model builds revenue from four documented streams. Stevedoring depends on total TEUs handled multiplied by the average handling rate per TEU, with growth linked to GDP multipliers and tariffs escalated by inflation.
- Wharfage and berthing fees come from vessel calls multiplied by GRT or length and a published tariff. Storage and demurrage arise when containers exceed free time, calculated as excess TEUs times dwell days times a daily rate; this line is volatile and spikes during disruptions.
- Value-added services such as reefer, weighing, and Ro-Ro are driven by service units times service rates. Seasonality concentrates roughly thirty percent of annual volume in the peak quarter.
How Costs and Margins Are Structured
Variable costs include direct labour, fuel, electricity, and concession royalties paid to the port authority. Labour is the largest component in manual terminals but drops sharply with automation.
- Fixed operating expenses cover the annual concession lease, maintenance and repair, insurance, security, administration, and terminal operating system licensing. The model separates these categories so gross margin, EBITDA margin, operating margin, and net margin can be examined at each level.
- The template also flags a common pitfall: tariffs and costs escalating at different inflation rates, which can quietly compress margins even when revenue grows.
Capital Expenditure and Financing Assumptions
Construction capex is phased over a multi-year build, covering quay walls, dredging, ship-to-shore cranes, and yard equipment. Each asset class is depreciated over its own useful life, from civil works to cranes to yard equipment.
- Debt is sized as a percentage of capitalisation, with non-recourse project finance, amortisation, interest, and a debt service reserve account. The cash flow waterfall sequences revenue through operating expenses, tax, debt service, reserves, and finally equity distributions.
- A documented circularity arises when interest during construction is capitalised; the model breaks this using the opening debt balance.
Outputs, Validation Checks, and Practical Application
Outputs include integrated financial statements, project and equity IRRs, NPV, payback, DSCR, LLCR, and CFADS. Validation checks enforce balance sheet integrity, capacity limits, minimum DSCR, debt repayment matching drawdowns, adequate DSRA, non-negative cash, and no revenue after concession expiry.
- The model also guards against ignoring concession handback, which can eliminate terminal value if renewal is uncertain. For evaluation, the template's default assumptions are illustrative starting points, not market forecasts; users should replace them with deal-specific data.
- The underlying model captures these relationships, while the public download is a values-only preview.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
What is a port financial model?+
A model that forecasts container throughput, tariff revenue, operating costs, and EBITDA for a port terminal, used by operators, infrastructure investors, and port authorities.
What is a standard port tariff?+
Port tariffs are per-container fees for berth use and cargo handling, typically ranging from $50 to $150 per TEU depending on geography and competitive environment.
How do I model berth productivity?+
Berth productivity is measured in vessel moves per day or moves per hour, determined by crane efficiency, labor availability, and vessel size.
Can I model seasonal throughput variation?+
Yes. The model accommodates monthly or quarterly volume patterns and their impact on labor scheduling and equipment utilisation.
How is terminal capex justified in the model?+
Capex for berths, cranes, and IT infrastructure is linked to incremental throughput and margin improvement, showing return on terminal investment over the asset life.
Have more financial modelling questions? Contact us
Related templates
Airport Financial Model
Airport concession and operational revenue forecasting.
Railway Concession and Operations Model
Passenger and freight revenue, operating costs, capital investment, and concessionaire returns for railway projects.
Shipping Company Operating Model
Operating model for shipping companies with vessel utilization, freight rates, bunker costs, and operational efficiency metrics.
Fibre Network Deployment Model
Capital and financial model for fiber optic network buildout with capex, subscribers, and ARPU.
