Debt Sculpting
The debt a cash flow can support at a target coverage ratio, and the repayment profile that keeps coverage flat. Sculpting takes cash exactly down to the covenant each year instead of using a level annuity.
| Year | Opening balance | Interest | Principal |
|---|---|---|---|
| 1 | $226,464,217 | $13,587,853 | $17,181,378 |
| 2 | $209,282,839 | $12,556,970 | $18,212,260 |
| 3 | $191,070,579 | $11,464,235 | $19,304,996 |
| 4 | $171,765,583 | $10,305,935 | $20,463,296 |
| 5 | $151,302,287 | $9,078,137 | $21,691,094 |
| 6 | $129,611,193 | $7,776,672 | $22,992,559 |
PV = DS·(1 − (1+i)^−n)/i · Annuity at the maximum service.
CFADS / DS ≥ covenant · The binding constraint.
A clear path from inputs to results.
The debt a cash flow can support at a target coverage ratio, and the repayment profile that keeps coverage flat. Sculpting takes cash exactly down to the covenant each year instead of using a level annuity.
How to use
- Set annual cfads ($m).
- Set target dscr (×).
- Set interest rate (%).
- Set tenor (years).
- Read the headline metrics, then check the table for the detail.
The formula
Reference: Debt capacity as the present value of the maximum annual service (Brealey, Myers & Allen, Principles of Corporate Finance).
Worked example
At the default inputs
- Annual CFADS ($M): 40; Target DSCR (×): 1.3; Interest rate (%): 6; Tenor (years): 10
- 1
Debt capacity: $226,464,217 · Maximum annual service: $30,769,231 · Coverage: 1.30× · Interest in year 1: $13,587,853
Debt capacity: $226,464,217 · Maximum annual service: $30,769,231 · Coverage: 1.30×
Interpreting the result
At 1.30× cover and 6.00%, $40,000,000 of CFADS supports $226,464,217 of debt.
Assumptions & limitations
- Flat CFADS.
- Interest rate fixed for the tenor.
Frequently asked questions
What is sculpting?
Taking cash exactly down to the covenant each period rather than paying a level annuity.
Why does capacity grow with tenor?
Because the present value of a longer annuity is larger, at a declining rate.
Methodology last reviewed 2026-10-22. Results are informational and not financial or engineering advice — see our disclaimer.