Calculation guide
Add eligible opening reserve cash once and discount at the entered financing rate.
llcr = (reserve + Σ CF_t/(1+rate/100)^t)/debt
Inputs
Outstanding loan principal
Example entry 100000.0 (in the selected currency). Minimum 1e-12.
Eligible opening reserve
Example entry 5000.0 (in the selected currency).
Annual discount rate (%)
Example entry 10.0 %. Allowed range 0 to 100.
Cash available for debt service
Example entry 66000.0 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Outstanding loan principal | 100,000 |
| Eligible opening reserve | 5,000 |
| Annual discount rate (%) | 10% |
Loan-life years
| Cash available for debt service |
|---|
| 66,000 |
| 72,600 |
| Result | Value |
|---|---|
| Loan life coverage ratio | 1.25 |
Interpreting the result
A ratio of 1 means discounted loan-life cash and eligible reserves equal outstanding principal.
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 |
|---|---|---|---|---|---|
| Outstanding loan principal | 100,000 | 110,000 | Loan life coverage ratio | 1.25 | 1.136364 |
| Eligible opening reserve | 5,000 | 5,500 | Loan life coverage ratio | 1.25 | 1.255 |
| Annual discount rate (%) | 10% | 11% | Loan life coverage ratio | 1.25 | 1.233832 |
| Cash available for debt service (row 1) | 66,000 | 72,600 | Loan life coverage ratio | 1.25 | 1.31 |
