The Complete Guide to Project Finance Modelling: Templates, DSCR, IRR & Infrastructure Models

Project finance is one of the most technically demanding disciplines in corporate finance. Whether you are modelling a solar farm, a toll road, a port, or a mining operation, the financial model is the backbone of every investment decision, debt sizing exercise, and bankability assessment. This guide covers everything you need to build a robust project finance model — including DSCR calculation, infrastructure financial modelling best practices, and where to find a free project IRR model download.

What Is a Project Finance Model?

A project finance model is a time-series financial model that forecasts the cash flows of a discrete, asset-backed project over its entire life — typically 20 to 30 years. Unlike a corporate model, it is structured around the project's ability to service debt from its own cash flows, with no recourse (or limited recourse) to the sponsor's balance sheet.

A well-structured project finance model includes:

• Revenue projections — price × volume, escalation, offtake agreements
• Operating expenditure (OPEX) — fixed, variable, and percent-of-revenue items
• Capital expenditure (CAPEX) — construction schedule, sustaining CAPEX, decommissioning
• Debt service — senior debt, mezzanine, sculpted repayment profiles
• Tax modelling — corporate tax, withholding tax, interest tax deductions
• Working capital — receivables, payables, inventory cycles
• Key metrics — DSCR, LLCR, PLCR, project IRR, equity IRR, NPV, payback period

Project Finance Model Template: What to Look For

When searching for a project finance model template, most analysts default to Excel. While Excel is flexible, it has serious limitations for complex infrastructure deals:

• No built-in scenario management
• Manual recalculation errors
• No audit trail for assumption changes
• Circular references in debt sculpting and DSRA modelling
• No Monte Carlo simulation capability

A good project finance model template — whether in Excel or dedicated software — should cover the following structure:

1. Inputs & Assumptions Sheet All assumptions in one place: production plan, price deck, OPEX drivers, CAPEX schedule, financing structure, tax rates, and discount rates.
2. Construction Period Monthly or quarterly draw schedule, IDC (interest during construction), equity injection timing, and first drawdown conditions.
3. Operating Period Income Statement Revenue → Gross Profit → EBITDA → Depreciation → EBIT → Interest → EBT → Tax → Net Income.
4. Cash Flow Waterfall EBITDA → Tax → ΔNWC → Sustaining CAPEX → CFADS → Debt Service → DSRA movement → Distributions to equity.
5. Balance Sheet Opening and closing balances for fixed assets, debt, DSRA, deferred tax, and equity.
6. Debt Schedule Drawdown profile, principal repayment (straight-line, annuity, or sculpted), interest calculation, and DSRA mechanics.
7. KPI Dashboard DSCR, LLCR, PLCR, project IRR, equity IRR, NPV, payback period — all in one view.

DSCR Calculation: The Most Critical Project Finance Metric

The Debt Service Coverage Ratio (DSCR) is the single most important metric in project finance. Lenders use it to assess whether the project generates sufficient cash flow to service its debt obligations.

DSCR Formula

DSCR = CFADS / Debt Service

Where:
  CFADS        = EBITDA – Taxes Paid – ΔWorking Capital – Sustaining CAPEX
  Debt Service = Principal Repayment + Interest Payment

What Is a Good DSCR?

A DSCR below 1.0x means the project cannot cover its debt service — a default trigger in most loan agreements.

DSCR Calculation in Excel: Common Mistakes

Many analysts make the following errors when building DSCR calculation in Excel:

1. Using net income instead of CFADS Net income includes non-cash items and ignores working capital movements.
2. Forgetting DSRA releases DSRA withdrawals effectively reduce debt service in stress years.
3. Mixing construction and operating CAPEX Sustaining CAPEX reduces CFADS; construction CAPEX does not.
4. Circular references Cash sweep models and DSRA top-ups create circular dependencies that Excel handles poorly.
5. Ignoring tax timing Actual cash tax paid differs from the income statement tax charge.

A dedicated project finance modelling tool handles all of these automatically, eliminating the risk of manual errors in high-stakes transactions.

Infrastructure Financial Model: Key Differences from Corporate Models

An infrastructure financial model differs from a standard DCF or LBO model in several important ways.

Long Time Horizons

Infrastructure assets operate for 20–40 years. The model must project cash flows over the full concession or asset life, with careful attention to long-term assumptions — inflation, degradation curves, major maintenance cycles.

Project-Level Ring-Fencing

The project is legally separated from the sponsor. The model must reflect this — there is no parent company guarantee, and all debt must be serviced from project cash flows alone.

Construction Risk

Unlike operational assets, infrastructure models must model the construction period explicitly — EPC contracts, draw schedules, cost overruns, contingency, and IDC (interest during construction).

Regulatory & Offtake Risk

Many infrastructure projects have regulated tariffs or long-term offtake agreements (PPAs, concession agreements). These must be modelled explicitly, including step-down tariffs, capacity payments, and take-or-pay provisions.

Coverage Ratios as Debt Sizing Tools

In infrastructure finance, the debt quantum is sized to achieve target coverage ratios — not simply based on a leverage multiple. DSCR, LLCR (Loan Life Coverage Ratio), and PLCR (Project Life Coverage Ratio) are all used by lenders to determine how much debt the project can support.

Project IRR vs Equity IRR: Understanding the Difference

One of the most common sources of confusion in project finance is the difference between project IRR and equity IRR.

Project IRR (Unlevered IRR)

The project IRR measures the return on the total capital invested in the project, regardless of how it is financed. It is calculated from the project free cash flow (before financing):

Project FCF = EBITDA + Tax + ΔNWC + Total CAPEX
            (construction + sustaining + decommissioning)

The project IRR is used to assess whether the project creates value on a standalone basis and to compare across different financing structures.

Equity IRR (Levered IRR)

The equity IRR measures the return to equity investors only, after debt service. It is calculated from the equity cash flow:

Equity CF = CFADS – Debt Service – DSRA Movement + Equity Drawdowns

Because leverage amplifies returns, the equity IRR is typically higher than the project IRR — but comes with higher risk.

Project IRR Model Free Download

Most analysts spend days building project IRR models from scratch in Excel. A faster, more reliable approach is to use purpose-built software that handles the full model structure automatically.

Horizon by Intellifields is a free desktop application that generates a complete project finance model — including project IRR, equity IRR, DSCR, LLCR, PLCR, NPV, and payback — in minutes. No formulas to build, no circular references to debug.

Why Desktop Software Beats Excel for Project Finance

Getting Started with Horizon

Horizon is a professional-grade project finance modelling tool built for analysts, advisors, and developers working on infrastructure, energy, mining, and real estate transactions.

The free Explorer tier includes:

• Core three-statement model (IS, BS, CF)
• IRR, NPV & payback calculations
• DSCR / LLCR / PLCR ratios
• Watermarked Excel & PDF export
• Community email support

For full advanced analytics, multi-scenario modelling, and unwatermarked export, explore our pricing plans.

Conclusion

Building a rigorous project finance model requires more than a generic spreadsheet template. From DSCR calculation and debt sculpting to infrastructure-specific cash flow waterfalls and Monte Carlo stress testing, the complexity demands purpose-built tools.

Whether you are evaluating a greenfield renewable energy project, advising on a PPP transaction, or sizing debt for a mining development, Horizon gives you a professional-grade model in a fraction of the time — free to download, with no data leaving your machine.

Published by Intellifields • support@intellifields.com

Related Resources

Deepen your project finance knowledge with these specialist guides:

• Infrastructure Financial Model: Structure, Key Metrics & Best Practices — toll roads, PPP, ports, power, and PPP availability models in detail.
• DSCR Calculation in Excel: Free Template, Formula & Common Mistakes — step-by-step CFADS build, sculpting mechanics, and the 7 most expensive errors.
• Renewable Energy Financial Model: Solar, Wind & Battery Storage — P50/P90 yield curves, CfD and PPA revenue structures, BESS degradation modelling.