Calculation guide
Inputs
Annual earmarked revenue
Example entry 900000.0 (in the selected currency).
Prior claims on revenue
Example entry 150000.0 (in the selected currency).
Annual principal due
Example entry 500000.0 (in the selected currency).
Annual interest due
Example entry 100000.0 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Annual earmarked revenue | 900,000 |
| Prior claims on revenue | 150,000 |
| Annual principal due | 500,000 |
| Annual interest due | 100,000 |
| Result | Value |
|---|---|
| Revenue debt-service coverage | 1.25 |
| Revenue after debt service | 150,000 |
Calculation steps
Revenue debt-service coverage = ((Annual earmarked revenue − Prior claims on revenue) ÷ (Annual principal due + Annual interest due))
((900,000 − 150,000) ÷ (500,000 + 100,000)) = 1.25
Revenue after debt service = (((Annual earmarked revenue − Prior claims on revenue) − Annual principal due) − Annual interest due)
(((900,000 − 150,000) − 500,000) − 100,000) = 150,000
Interpreting the result
Below 1, earmarked revenues after prior claims cannot cover annual principal and interest.
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 |
|---|---|---|---|---|---|
| Annual earmarked revenue | 900,000 | 990,000 | Revenue debt-service coverage | 1.25 | 1.4 |
| Prior claims on revenue | 150,000 | 165,000 | Revenue debt-service coverage | 1.25 | 1.225 |
| Annual principal due | 500,000 | 550,000 | Revenue debt-service coverage | 1.25 | 1.153846 |
| Annual interest due | 100,000 | 110,000 | Revenue debt-service coverage | 1.25 | 1.229508 |
