Project Finance & Financial ModellingCash-flow waterfalls, debt sizing and coverage ratios · Lesson 11 of 20
The cash-flow waterfall and reserve accounts
Video lecture
The cash-flow waterfall and reserve accounts
The narrated lecture is in production
Every chapter is scripted and ready. Browse the chapters and read the full transcript now — the video will appear here when it’s published.
Chapters
Transcript of the narration, chapter by chapter.
0:00 Equity is always last
Here's something that surprises people new to project finance. A project can be earning healthy profits, and the sponsors can still receive nothing for a year or more. Not because anything's broken, but because the loan agreement says cash must flow through a strict order first, and a test along the way has failed. That order is the cash-flow waterfall, sometimes called the cascade. In this lecture you'll learn the typical order of payments in an operating period, what the debt service and maintenance reserve accounts do, how distribution lock-up tests work, what a cash sweep is, and how to model all of it so reviewers can follow it. By the end, you'll be able to run a period of cash through a waterfall by hand and explain exactly why equity did or didn't get paid.
0:59 Why it matters
Why does this matter? For lenders, the waterfall is protection: it keeps cash in the project precisely when it's most needed. For sponsors, it decides when they actually get paid, which drives equity IRR as much as the project's performance does. Lock-ups, sweeps and reserve funding can defer distributions significantly, so sponsors negotiate these terms hard and model them precisely. And for modellers, getting the order wrong isn't a small error. A model that pays equity before topping up a reserve will overstate returns and understate risk, and a model auditor will find it.
1:40 The concept: a typical operating waterfall
Here's a typical order in the operating period, though the exact sequence varies by deal. Revenue lands in the proceeds account. First, operating costs and taxes. Then senior lenders' fees and expenses. Then senior interest, along with any hedging payments. Then senior principal. Next, top up the debt service reserve account if it's below its required balance. Then the maintenance reserve account. Then any mezzanine or subordinated debt service. Then a cash sweep, if one has been triggered. And finally the lock-up test: if it passes, the remaining cash can be distributed to equity; if it fails, it's trapped in the project. Think of it like a set of champagne glasses stacked in a pyramid. You pour into the top, and the bottom glasses only fill once every glass above them is full. Equity is always the bottom glass.
2:40 Reserves, lock-ups and sweeps
The debt service reserve account covers debt service if CFADS temporarily falls short. It's often sized at the next six months of senior debt service, and can be funded in cash at financial close, as part of the uses, or with a bank letter of credit, which improves equity returns but costs fees. The maintenance reserve account smooths lumpy lifecycle costs. Distributions are usually permitted only if the historic, and sometimes projected, DSCR is above a lock-up level, perhaps one point one to one point two times depending on the deal, reserves are fully funded, and no default is continuing. If performance falls further, to a default level, lenders gain remedies. And a cash sweep uses some or all of the excess cash to prepay debt, either when triggered by poor performance or specific events, or to keep debt on a target profile.
3:42 Worked example one: a Dubai water SPV
Let's run one period, from the lesson, with illustrative numbers in millions of dollars. A fictional water treatment SPV in Dubai, semi-annual period. Revenue received: twelve. Operating costs and tax: four and a half. So CFADS is seven and a half. Senior interest: two point four. Senior principal: three point six. Total debt service: six. DSCR is seven and a half over six: one point two five times. The DSRA is already full, so nothing there. The MRA contribution is nought point four. Cash available after reserves: one point one. Now the lock-up test. The lock-up is one point one five times, and DSCR is one point two five. Pass. So one point one million goes to equity. Now change one number. If CFADS had been six point six, DSCR would be one point one times, below the lock-up. The nought point two left after the MRA would be trapped in the project, not distributed.
4:49 Worked example two: two periods, pass and fail
Now let's follow three periods, illustratively. Period one passes, as we just saw, and equity receives its distribution. In period two, a plant outage cuts revenue. CFADS falls, DSCR comes in at one point nought eight times, below the one point one five lock-up. Whatever cash remains after reserves isn't lost; it's held in the project's accounts. In period three, performance recovers, DSCR is back above the lock-up, reserves are full and there's no default. Depending on the loan agreement's terms, the trapped cash can then be released along with the current period's surplus. Two lessons. First, trapped cash is usually delayed, not destroyed, subject to the terms. Second, the timing still hurts equity returns, and if the loan agreement includes a sweep of trapped cash after a certain number of periods, it may go to lenders instead.
5:49 Watch me do it: a waterfall that reviewers can follow
Let me show you how I build the waterfall so anyone can follow it. Each payment line takes the lower of the cash available and the amount due, using MIN. Directly beneath it, a 'cash available after this item' row. So: CFADS, seven and a half. Interest paid: MIN of seven and a half and two point four. Cash after interest: five point one. Principal paid: MIN of five point one and three point six. Cash after principal: one point five. DSRA top-up: MIN of cash available and the shortfall to the required balance. And so on down to the lock-up test, which uses the DSCR, reserve balances and a default flag. If the test passes, distributions equal the cash available; otherwise, they're zero and the cash goes to a trapped-cash balance carried forward. Then checks: no line pays more than was available, and every dollar is accounted for.
6:54 Accounts, sponsors and common mistakes
In practice, lenders control a set of project accounts held with an account bank: proceeds, operating, debt service, reserves, distribution and compensation accounts. Transfers follow the waterfall, and that control is part of the lenders' security. The common mistakes: modelling distributions without lock-up tests; forgetting the initial DSRA funding in the uses at financial close; mis-ordering the waterfall compared with the loan agreement; and assuming trapped cash is lost, when it's usually released once tests are passed again, subject to terms. The discipline that prevents most of these is simple: build the waterfall line by line from the loan agreement's own wording, and cite the clause next to each row.
7:42 Recap and try this now
Let's recap. The cash-flow waterfall is the order in which project cash is applied, set out in the loan and accounts agreements: operating costs and taxes, senior debt service, reserve top-ups, subordinated debt, any sweep, and only then distributions, subject to a lock-up test. Reserves smooth shortfalls and lumpy costs; lock-ups keep cash in the project when cover is thin. Model it line by line with MIN and 'cash available after' rows, and add checks. Trace one period by hand: if you can't explain every line in plain language, neither can the model auditor. Your try-this-now: draw the waterfall for a real or hypothetical project, and run two periods through it: one that passes the lock-up test and one that fails.
What the waterfall does
In project finance, cash does not flow freely to shareholders. The loan agreement and accounts agreement define a strict cash-flow waterfall (cascade): the order in which project cash is applied each period. Senior obligations are paid first; equity receives cash only after every higher-priority item is satisfied and certain tests are met.
A typical operating-period waterfall
1. Revenue received into the proceeds account
2. Operating costs and taxes
3. Senior lenders' fees and expenses
4. Senior interest (and hedging payments)
5. Senior principal repayment
6. Top-up of debt service reserve account (DSRA)
7. Top-up of maintenance reserve account (MRA)
8. Mezzanine / subordinated debt service (if any)
9. Cash sweep (mandatory prepayment), if triggered
10. Distribution lock-up test → if passed, distributions to equity
→ if failed, cash trapped in the projectExact ordering varies by deal, but the principle is universal: equity is last.
Reserve accounts
| Reserve | Purpose | Typical sizing (illustrative) |
|---|---|---|
| Debt service reserve account (DSRA) | Covers debt service if CFADS temporarily falls short | Often the next 6 months of senior debt service |
| Maintenance reserve account (MRA) | Smooths lumpy lifecycle costs | Based on forecast major maintenance over a forward period |
| Other reserves | Specific risks (e.g., decommissioning, tax, change in law) | Deal-specific |
The DSRA can be funded in cash at financial close (part of the uses) or through a bank letter of credit instead, which improves equity returns but adds fees.
Distribution tests (lock-up)
Equity distributions are usually permitted only if:
- The historic (and sometimes projected) DSCR is above a lock-up level (e.g., 1.10x–1.20x, deal-specific).
- Reserve accounts are fully funded.
- No default is continuing.
If the test fails, cash is trapped. If performance deteriorates further to a lower default level (e.g., 1.05x), lenders gain remedies. These thresholds protect lenders by keeping cash in the project when it is most needed.
Cash sweeps
A cash sweep uses a portion of excess cash to prepay debt. It can be:
- Mandatory, triggered by poor performance or specific events (e.g., merchant tail, refinancing risk).
- Target repayment profile, sweeping cash to keep debt on a target balance.
Sweeps reduce lenders' risk but defer equity returns.
Worked example: one period through the waterfall
Illustrative. A fictional water treatment SPV in Dubai, semi-annual period, values in USD M:
Revenue received 12.0
Operating costs and tax (4.5)
CFADS 7.5
Senior interest (2.4)
Senior principal (3.6)
Total senior debt service (6.0) → DSCR = 7.5 / 6.0 = 1.25x
DSRA top-up (already full) 0.0
MRA contribution (0.4)
Cash available after reserves 1.1
Lock-up test: DSCR 1.25x ≥ 1.15x lock-up → PASS
Distribution to equity 1.1If CFADS had been 6.6 instead, DSCR would be 1.10x, below the lock-up threshold. The 0.2 remaining after the MRA contribution would be trapped in the project rather than distributed.
Accounts structure
Lenders usually control a set of project accounts held with an account bank: proceeds, operating, debt service, reserves, distribution and compensation accounts. Transfers follow the waterfall. This control is part of the lenders' security package.
Why sponsors care
Equity returns depend not just on the project's performance but on when cash can leave the SPV. Lock-ups, sweeps and reserve funding can significantly delay distributions. Sponsors negotiate these terms carefully and model them precisely.
Common mistakes
- Modelling distributions without lock-up tests.
- Forgetting the DSRA initial funding in the uses at financial close.
- Mis-ordering the waterfall compared with the loan agreement.
- Assuming trapped cash is lost (it is usually released once tests are passed again, subject to terms).
Modelling the waterfall
In the model, build the waterfall as a sequence of rows where each line takes the lower of the cash available and the amount due, and passes the remainder to the next line. Include a "cash available after this item" row after each step so reviewers can follow the flow. Add checks that no line pays more than the cash available and that trapped cash is carried forward correctly. Then test the logic with a deliberately weak period to make sure lock-up and reserve top-ups behave as the loan agreement requires.
Quick self-check
Trace one period by hand from revenue to distributions. If you cannot explain every line in plain language, neither can the lenders' model auditor.
Hands-on: waterfall rows in Excel
CFADS =Revenue-Opex-Tax
Senior fees paid =MIN(CFADS, Fees_due) Cash_1 =CFADS-Senior_fees_paid
Senior interest paid =MIN(Cash_1, Interest_due) Cash_2 =Cash_1-Interest_paid
Senior principal paid =MIN(Cash_2, Principal_due) Cash_3 =Cash_2-Principal_paid
DSRA target =Next_6m_debt_service
DSRA top-up =MIN(Cash_3, MAX(0, DSRA_target-DSRA_opening)) Cash_4 =Cash_3-DSRA_top_up
MRA contribution =MIN(Cash_4, MRA_due) Cash_5 =Cash_4-MRA_contribution
DSCR (period) =CFADS/(Interest_due+Principal_due)
Lock-up pass =AND(DSCR>=Lockup, DSRA_closing>=DSRA_target, Default_flag=0)
Distribution =IF(Lock_up_pass, Cash_5+Trapped_opening, 0)
Trapped closing =IF(Lock_up_pass, 0, Trapped_opening+Cash_5)
Check (no overpayment) =--(MIN(Cash_1,Cash_2,Cash_3,Cash_4,Cash_5)<-0.001) must be 0Whether trapped cash is released with the next passing period, swept to lenders after a number of failed tests, or used for specific purposes depends on the loan agreement; model the actual clause.
Hands-on: the Dubai example in Python
def run_period(cfads, interest, principal, dsra_gap, mra, lockup, trapped=0.0):
cash = cfads
paid = {}
for item, due in [("interest", interest), ("principal", principal), ("dsra", dsra_gap), ("mra", mra)]:
paid[item] = min(cash, due)
cash -= paid[item]
dscr = cfads / (interest + principal)
passed = dscr >= lockup and paid["dsra"] >= dsra_gap
dist = cash + trapped if passed else 0.0
return round(dscr, 2), passed, round(dist, 2), round(0.0 if passed else trapped + cash, 2)
print(run_period(7.5, 2.4, 3.6, 0.0, 0.4, 1.15)) # (1.25, True, 1.1, 0.0)
print(run_period(6.6, 2.4, 3.6, 0.0, 0.4, 1.15)) # (1.1, False, 0.0, 0.2)How to measure success
- Every waterfall row cites the loan agreement clause it implements.
- The no-overpayment check is zero in every period and scenario.
- Distributions, trapped cash and reserve balances reconcile to cash flow each period.
Key takeaways
- The waterfall applies cash in strict priority: opex and tax, senior debt, reserves, junior debt, then equity.
- DSRA and MRA protect debt service against temporary shortfalls and lumpy maintenance.
- Lock-up tests trap cash when DSCR falls below agreed levels; default levels trigger lender remedies.
- Model the waterfall exactly as the loan agreement defines it.
Check your understanding
Quick questions to lock in the lesson. They don’t count towards your certificate.
Put it into practice
Draw the waterfall for a project you know or a hypothetical one, and run two periods through it: one passing and one failing the lock-up test.
Enrol for free to save your progress
Reading is always free. Enrol to keep your place, take the final assessment and earn a verifiable certificate.