Advanced Finance

The Project Finance Model and Its Cash-flow Waterfall

Build and read the one spreadsheet that twelve parties agree to be bound by — and follow a single dollar of revenue down the priority of payments until it either reaches the sponsor or is trapped one line short.

  • Advanced
  • 14 min total
  • 13 chapters

What decision this helps you make: How much debt the cash flow will carry, on what repayment profile, and exactly which test decides whether the sponsor gets paid this period or the cash stays in the account.

What this topic is

The project finance model is a long-dated cash flow model of a single asset, built to a contractual definition of cash available for debt service, used to size and sculpt the debt, and then frozen at financial close as the base case against which the deal is measured for its whole life. The cash-flow waterfall is the clause in the accounts agreement that tells the account bank the exact order in which money leaves the project accounts on each payment date. The model is the forecast; the waterfall is the law. The model exists to prove the waterfall will be satisfied.

Why it matters

Every number that matters in a project financing comes out of this model: the debt quantum, the repayment profile, the reserve balances, the cover ratios, the equity return. And the waterfall is where a good year and a bad year feel completely different to a sponsor — because a single basis point of cover ratio can be the difference between a distribution and a lock-up, with no default and no negotiation. Practitioners who can read the waterfall know where their cash is before the account bank tells them.

Who should learn it

Financial modellers and analysts in infrastructure and energy, credit officers underwriting single-asset exposures, sponsors and developers whose distributions depend on these tests, and anyone reviewing a base case they did not build.

What you will understand

  • How cash available for debt service is defined contractually, and why that definition is negotiated rather than accounting-derived
  • How to walk a payment date down the priority of payments and see exactly where cash stops
  • What the cover ratios measure, how they relate to each other, and what headroom each one really buys
  • The difference between a cash trap, a lock-up, a cash sweep, and an event of default — four things routinely confused

Prerequisites

Common misconception

"The model forecasts what will happen." It does not, and nobody involved believes it does. A twenty-year deterministic base case with a handful of one-at-a-time sensitivities is not a prediction — it is a shared object that twelve counterparties agree to be measured against. Its real functions are to size the debt, to set the sculpted repayment profile, and to define the tests. Treating it as a forecast leads sponsors to distribute against a P50 line that has roughly even odds of being wrong in either direction, and leads lenders to believe a sensitivity table has covered risks that move together and were only ever tested one at a time.