Calculation guide
Reject cash flow insufficient to cover interest at target.
remaining = opening debt − Σprincipal · repaid = Σ min(opening,CF/DSCR − interest)
Inputs
Initial debt
Example entry 100000.0 (in the selected currency).
Annual loan rate (%)
Example entry 5.0 %. Allowed range 0 to 100.
Target debt-service coverage
Example entry 1.2. Minimum 1e-12.
Annual available cash flow
Example entry 36000.0 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Initial debt | 100,000 |
| Annual loan rate (%) | 5% |
| Target debt-service coverage | 1.2 |
Annual cash available for debt service
| Annual available cash flow |
|---|
| 36,000 |
| 37,800 |
| Result | Value |
|---|---|
| Debt remaining after entered years | 47,250 |
| Principal repaid | 52,750 |
Interpreting the result
Remaining principal is the balance that the entered cash flows cannot repay while maintaining target coverage.
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Initial debt | 100,000 | 110,000 | Debt remaining after entered years | 47,250 | 58,275 |
| Annual loan rate (%) | 5% | 6% | Debt remaining after entered years | 47,250 | 49,060 |
| Target debt-service coverage | 1.2 | 2.2 | Debt remaining after entered years | 47,250 | 75,886.363636 |
| Annual available cash flow (row 1) | 36,000 | 39,600 | Debt remaining after entered years | 47,250 | 44,100 |
