Best Practices in Preparing Cash Flow in Project Finance

Financial documents featuring cash flows and pens, ideal for business themes and analysis.

Why project finance cash flow is different

In project finance, lenders look almost entirely at one thing, the cash the project itself will generate. The project is usually a standalone special purpose vehicle (SPV), debt is limited recourse and repayment depends on the asset performing for 15 to 30 years.

That changes what the cash flow model is for. It is not a forecasting exercise that ends in an NPV. It is the document on which lenders size debt, sponsors decide whether to commit equity and the SPV is later monitored for covenant compliance. A weak cash flow model can lead to over-geared structures and mispriced risk.

At ValArc Consulting we build business cases, financial feasibility studies and three-statement models for greenfield and brownfield investments, JVs and strategic projects across industrial, technology, consumer and infrastructure-linked sectors. This article distils the practices we consider non-negotiable when preparing project finance cash flows.

1. Start with the business decision

Before a single cell is built, agree what the model must answer. Typical questions are:

How much debt can the project support at an acceptable coverage ratio?
What equity IRR and payback do sponsors earn in the base case and in a downside?
How much headroom exists before covenants are breached or distributions are locked up?
What happens if construction is delayed, costs overrun or volumes and prices underperform?

A model designed around these questions stays focused. A model built to “capture everything” becomes slow, opaque and hard to audit. As a rule, the best model is not the most complicated one, but the one that clearly shows what drives cash flow and how much debt it can carry.

2. Forecast operating cash flow from physical and commercial drivers

Operating cash flow should be built bottom-up from drivers, not top-down from growth percentages.

Physical performance. For assets such as solar plants, factories and toll roads, cash flow projections should reflect actual operating performance including capacity, utilisation, availability, degradation, downtime etc. Where uncertainty is significant, assess different scenarios such as P50, P90 and a stress case to understand the potential impact on project cash flow.

Commercial terms. Link revenue to the actual contract offtake or concession price, indexation, penalties and bonuses. Model indexation with its real lag and cap not a flat escalator.

Operating costs. Separate fixed and variable costs and treat contractual costs (O&M agreements, land leases, insurance, management fees) according to their own escalation clauses. Include major maintenance as lumpy items not a smooth annual average i.e major maintenance costs should be recorded in the specific years when the work is expected to occur, rather than spreading the cost evenly across every year.

Working capital. Include receivable days, payable days and inventory based on contract terms. Ignoring working capital is a common reason why modelled cash differs from actual cash in the first operating year.

3. Define CFADS precisely and consistently

Cash Flow Available for Debt Service (CFADS) is the anchor of the entire model. Lenders size debt and test covenants against it, so its definition must match the financing documents, not a generic template.

A common definition is:

CFADS = Revenue − Operating costs − Maintenance capex − Change in working capital − Cash taxes

Write the definition on the model’s cover or assumptions sheet and reference the relevant clause in the term sheet. Disagreements over what counts as CFADS are among the most frequent disputes in model audits.

4. Get construction period cash flows right

Many models are strong in operations and weak in construction, yet this is the phase with the most risk to returns and where debt is drawn.

Phase capex realistically. Use milestone-based payment schedules, retention, advance payments and tax or duty payable on imports.
Include contingency and escalation as explicit lines, with a view on owner’s and contractor’s risk.
Calculate IDC and financing fees on a circularity-free basis. Interest and fees capitalised during construction increase the funding requirement, which increases interest. Resolve this with a closed-form solution, a copy-paste macro or an iterative calculation with a circuit breaker, and document the method.
Apply the funding order specified by lenders. Equity is often injected first or pro rata with debt. Model the actual drawdown conditions and any gearing cap during construction.
Stress delay. A six-month COD delay is often more damaging than a modest capex overrun because it defers revenue while IDC continues to accrue.

5. Size debt from cash flow

Debt capacity should be driven by cash flow, not just a target gearing ratio. Two approaches are standard:

Debt sizing by DSCR: the maximum debt is the present value of CFADS divided by the target DSCR, discounted at the all-in cost of debt.
Sculpted repayment: debt service in each period is set as CFADS divided by the target DSCR, so repayment follows the project’s cash profile, instead of using a level annuity or equal principal repayments.

Check the result against multiple constraints at once like maximum gearing, minimum DSCR, loan life cover ratio (LLCR), tenor limits and the debt service reserve requirement. Take the lowest of these as the binding constraint and show which one it is.

6. Prepare cash flow using the direct method

Project finance cash flows should be prepared using the direct method. The model lists actual cash receipts and cash payments by category, instead of starting from net profit and adjusting for non-cash items.

Why the direct method is used in project finance

It produces CFADS directly. CFADS is a cash concept. Building it from actual receipts and payments avoids reverse-engineering it from profit and keeps DSCR, LLCR and lock-up tests consistent with the finance documents.
It matches the order of payments. The common terms agreement ranks each use of cash. Direct method lines can be placed in that order without regrouping.
It shows liquidity risk in each period. Quarterly or semi-annual shortfalls, caused by timing of receivables, major maintenance or tax payments are visible. Profit-based adjustments can mask them.
It is easier for lenders and their advisers to audit. Each line can be traced to a contract, an invoice cycle or a payment date, which shortens model review.
It supports reserve account and bank account mechanics. Operating, debt service reserve and maintenance reserve accounts hold real cash balances, which the direct method tracks line by line.
It separates operating cash from financing cash cleanly. Interest and principal sit in the waterfall, not buried in a net cash figure.

7. Handle tax, depreciation and accounting properly

Tax is based on accounting profit, so project finance cash flows need an income statement and balance sheet alongside the waterfall. Key points:

Calculate tax depreciation and book depreciation separately where rules differ, and model deferred tax if relevant.
Include loss carry-forward limits, minimum alternate tax, interest deductibility caps and tax holidays that apply in the jurisdiction.
Account for indirect taxes (such as GST or VAT) on capex and opex, including timing of refunds..

8. Test the cash flow with scenarios and sensitivities

A model that produces one answer is not enough. Lenders will insist on a base case and downside cases, and sponsors need to know where the project breaks.

Scenarios: a base case, a lender’s case (typically P90 volumes and higher costs), and a stress case. Use a live scenario selector with all cases running through one set of formulas.
Sensitivities: vary one driver at a time (volume, price, opex, capex, delay, interest rate, FX) and display the impact on minimum DSCR, LLCR and equity IRR.
Breakeven analysis: show how far a variable can move before DSCR falls below 1.0x, or before lock-up is triggered.
Reverse stress tests: find the combination of changes that triggers default.

9. Build in integrity checks and governance

Model review is not an afterthought. It is part of the build.

Balance checks: the balance sheet balances, cash ties to the waterfall, and sources equal uses in every period.
Sanity checks: debt fully repaid by maturity, no negative reserve balances, drawdowns within commitments.
Error flags: a master check on the cover sheet that turns red if anything fails.
Version control: log changes, date-stamp versions and lock approved versions.
Independent review: where lenders require it, a model audit by a third party. Even when not required, an internal second-person review catches most errors.
Documentation: a short model guide that explains structure, logic, conventions and known limitations.

Conclusion

A project finance cash flow model succeeds when it earns the trust of everyone who relies on it: lenders sizing debt, sponsors committing capital, and management monitoring performance. That trust comes from clear structure, a precise definition of CFADS, a waterfall that mirrors the legal documents, honest downside testing and rigorous checks.

The discipline is straightforward to describe and demanding to execute. Done well, it turns a long-dated, uncertain stream of cash into a decision the board and lenders can commit to with confidence.

ValArc Consulting is a strategy and corporate finance advisory firm helping businesses make informed growth, investment and transaction decisions. Our services span growth strategy, capital investment, mergers and acquisitions, joint ventures, and capital advisory, supported by rigorous business cases, financial feasibility assessments, integrated three-statement financial models and independent research.

This article is for general information and does not constitute financial, legal or tax advice. Project finance terms vary by transaction; always refer to the specific financing documents.