Calculation guide
Discount end-of-year flows to the measurement date.
plcr = Σ(CF_t/(1+rate/100)^t)/debt
Inputs
Debt outstanding today
Example entry 100000.0 (in the selected currency). Minimum 1e-12.
Annual discount rate (%)
Example entry 10.0 %. Allowed range 0 to 100.
Cash available for debt service
Example entry 55000.0 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Debt outstanding today | 100,000 |
| Annual discount rate (%) | 10% |
Remaining project years
| Cash available for debt service |
|---|
| 55,000 |
| 60,500 |
| 66,550 |
| Result | Value |
|---|---|
| Project life coverage ratio | 1.5 |
Interpreting the result
Compare this ratio with loan-life coverage to see how much support comes after loan maturity.
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 |
|---|---|---|---|---|---|
| Debt outstanding today | 100,000 | 110,000 | Project life coverage ratio | 1.5 | 1.363636 |
| Annual discount rate (%) | 10% | 11% | Project life coverage ratio | 1.5 | 1.473135 |
| Cash available for debt service (row 1) | 55,000 | 60,500 | Project life coverage ratio | 1.5 | 1.55 |
