Case study · Development finance & credit · 2026

Sizing the debt to the cash flow

A residential development's planned loan could not be serviced from the project's own cash flow. What the model showed, and what changed. Anonymized.

Back to experience
0.45xDebt service coverageagainst a 1.30x target
$3.4MDebt the cash flow supportsdown from about $9.7M planned
$12.7MEquity requiredroughly double the plan

The situation

The project was a 267-unit, $16.1M phase of a residential development program of more than $60M. The financing plan assumed debt at 60% of cost, about $9.7M, with the rest as equity. The equity sat behind a four-tier waterfall with an 8% preferred return and a 20% IRR hurdle.

What I built

I built a monthly pro forma for the phase. Each month it tracks costs as they are spent, sales as they close, and the loan drawn, charged interest and repaid. At the end, the equity waterfall shows what each tier receives. I then stress-tested it with five scenarios across 10 variables (price, cost, timing and others), each changing the inputs and recording where the equity return breaks.

What the model showed

In the base case the equity earned a 19.6% IRR, which looks healthy. The stress test told a different story. With a 35% price cut, a 30% cost overrun and a 12-month sales delay together, the equity IRR fell to −18.9%.

The bigger finding was the debt. The project's cash flow covered only 0.45x of the debt service on a loan at 60% of cost, against a target of 1.30x. As planned, the loan could not be serviced from the project.

Debt service coverage

Target 1.30x 0.45x Planned debt Required

The capital stack, before and after ($M)

Debt 9.7 Equity 6.4 Debt 3.4 Equity 12.7 Plan (60% loan-to-cost) Resized

What changed

The team cut the debt to $3.4M, the amount the cash flow supports. Required equity rose to $12.7M, roughly double the plan. The project still adds up to $16.1M, but the risk now sits with the equity that is paid to carry it, not with a loan the project could not repay.

What I took from it