How to Build a Project Finance Model Lenders Trust
From a lender's perspective, a project finance model's job is not merely to show profitability, but to prove that debt can still be repaid even under adverse scenarios.
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.
Project Finance CapabilityWe turn investment projects into structures whose repayment rests on their own cash flow.
Learn moreFrequently asked questions
How is the minimum DSCR level determined?
It varies by sector, offtake contract type, and country risk; a project with a long-term fixed-price offtake agreement, for example, may be accepted with a lower threshold.
How many years should the model project forward?
It typically covers the full loan tenor, often spanning a 15-25 year horizon including the construction period.
Who performs the model audit?
Usually an independent financial model advisor appointed by the lender reviews the sponsor's model line by line and delivers a report.
NART Insights
Growth Metrics for Payments Companies
A payments company's valuation depends as much on how much of its transaction volume growth converts to actual margin revenue as on the growth itself.
Learn moreHow AUM-Based Valuation Works for Asset Managers
Two asset managers can have the same size of assets under management (AUM), but that never means they're worth the same.
Learn moreThe Embedded Value Method in Insurance Valuation
Standard EBITDA multiples don't capture a life insurer's real value; the embedded value method is the industry standard in this sector.
Learn moreStart a mandate discussion
Tell us about your capital requirement, your transaction idea or your structuring problem. The first assessment meeting is free of charge and strictly confidential.