Worked example two: the maximum loan at a target ratio
Same company, but the owner wants to know the largest loan the cash flow supports at a lender's 1.25× minimum and, for comparison, at a conservative 1.50×.
- Maximum total service at 1.25× = $210,000 ÷ 1.25 = $168,000. Less existing $48,000 = $120,000 of new annual capacity, or $10,000 a month.
- Principal that a $10,000 monthly payment supports at 9.5% over 120 months = $10,000 × (1 − 1.007917^−120) ÷ 0.007917 ≈ $772,800.
- At 1.50×: $210,000 ÷ 1.5 = $140,000; less $48,000 = $92,000 a year, $7,667 a month, supporting about $592,500.
Effect of the coverage target on the maximum loan ($210,000 cash flow, $48,000 existing service, 9.5%, 10 years)| Target DSCR | New annual capacity | Maximum loan |
|---|
| 1.15× | $134,609 | $866,900 |
|---|
| 1.25× | $120,000 | $772,800 |
|---|
| 1.35× | $107,556 | $692,700 |
|---|
| 1.50× | $92,000 | $592,500 |
|---|
A smaller business shows how term matters. With $95,000 of cash flow, $30,000 of existing service and a proposed $250,000 at 11%, a five-year term costs $65,227 a year and produces DSCR of about 1.00×, a decline. The same loan over ten years costs $41,325 a year and yields 1.33×, an approval. Nothing about the business changed; the term did. This is why lenders offer longer amortization on collateralized loans and why you should ask for it when coverage is tight.