Project Finance Modeling: DSCR & Long-Life Assets

How a project finance model works — CFADS, DSCR and LLCR coverage ratios, debt sculpting, and modelling long-life infrastructure assets over 25 years.

A project finance model values and structures a single long-life asset — a power plant, toll road, data center or property development — funded largely by debt that is repaid from the project's own cash flows. It is a distinct discipline from corporate modelling: the lenders, not the sponsor's balance sheet, carry the risk, so the model revolves around the cash available for debt service and the coverage ratios over a 20-to-25-year life.

What makes project finance different

In corporate finance, debt is secured against the whole company; in project finance, it is secured only against the project's cash flows and assets (non-recourse). That changes everything: lenders advance a share of the project's capacity to service debt, so the entire model is built to demonstrate that cash flow covers debt payments comfortably in every period, including downside cases.

Cash flow available for debt service (CFADS)

CFADS is the heart of the model: operating cash flow, less tax, less the working-capital movement, less maintenance CAPEX — the cash genuinely available to pay lenders before any distribution to equity. Every coverage ratio is built from CFADS, and getting it right over a long horizon, with operations-and-maintenance (O&M) contract escalations and periodic overhauls, is the core modelling task.

Coverage ratios: DSCR and LLCR

The debt service coverage ratio (DSCR) is CFADS divided by debt service in each period; lenders require a minimum, often 1.2x–1.4x, throughout the loan life. The loan life coverage ratio (LLCR) compares the present value of CFADS over the remaining loan to the debt outstanding, giving a whole-of-life view. Both must stay above covenant, and the model tests them in a downside case.

Debt sculpting

Because a project's cash flow is uneven — ramp-up, contract expiries, major maintenance — project finance often 'sculpts' the repayment to match CFADS, sizing each period's principal so DSCR stays roughly constant rather than repaying a flat amount. This maximises the debt the project can support while keeping coverage safe, and it is a defining feature of a proper project-finance model.

Long-life and asset-specific mechanics

Over 20–25 years — often modelled in quarters, up to 80 periods — the model must handle O&M escalations and expiries, major-maintenance reserves, asset degradation (a solar plant's output falls each year), and the terminal or residual value at the end of the concession. These are the details generic templates skip and lenders scrutinise.

Build a long-horizon model

EasyFinancialModels generates fully linked models out to 25 years, annual or quarterly, with a full debt schedule, coverage view and DCF — suited to infrastructure, energy, real estate and data-center projects. Build your project model free for up to 3 years, or extend to the full asset life, keeping every coverage ratio and cash-flow figure formula-linked.

→ Build your cash flow forecasting model free with the Cashflow Forecasting tool

More Cash Flow Forecasting guides

How to Build a Cash Flow Forecast in Excel (Free Template + Steps) · 13-Week Cash Flow Forecast: A Practical Guide for Tight Cash · Direct vs Indirect Cash Flow Forecasting: Which Method to Use · Cash Flow Forecasting for Startups: Runway, Burn Rate & When to Raise · Working Capital Days Explained: DSO, DIO & DPO and Why They Drive Cash

About the author

Every model is built and reviewed by the project's Financial Advisor — a Fellow Chartered Accountant (FCA), Chartered Global Management Accountant (CGMA) and Associate Chartered Management Accountant (ACMA) with around two decades of corporate finance, audit and accounting experience, designing investor-grade financial models across industries. Full credentials and background are available on LinkedIn. More about the author →

← All guides · WACC calculator · DCF calculator · IRR calculator · Inside the 15-sheet model