How to Build a Project Finance Model Lenders Trust

The central role of the debt service coverage ratio

At the heart of the project finance model sits the debt service coverage ratio (DSCR); it shows how many times the free cash flow generated in a given period covers that period's debt service.

Lenders typically set a minimum DSCR threshold, and the model treats any scenario where it falls below that threshold as constituting a covenant breach.

The necessity of scenario and sensitivity analysis

A single base case is never considered sufficient; the model must separately test adverse scenarios such as delay, cost overrun, price decline, and demand shortfall.

Sensitivity analysis reveals which variable most affects the project's bankability, and where risk mitigation efforts should be focused.

Modeling construction and operations separately

The construction period and the operating period carry entirely different risk profiles; the model must handle both under separate assumption sets, yet within a single integrated structure.

Interest capitalization during construction and the initial drawdown schedule directly affect the debt service calculation once operations begin.

Linking cyclical variables to macro assumptions

Macro variables such as inflation, exchange rate, and interest rate must be reflected consistently across every line of the model; inconsistent assumptions undermine the model's credibility.

In projects with foreign-currency revenue and local-currency costs in particular, how currency risk is reflected in the model is one of the points lenders scrutinize most closely.

The value of an independent model audit

On large-scale projects, lenders typically require the model to be audited by an independent technical advisor before financial close.

Beyond catching formula errors, this audit assesses whether the assumptions themselves are reasonable, and it strengthens the model's defensibility before the credit committee.

Frequently asked questions