Open calculator ↗

Municipal bond debt service from earmarked revenues · Calculation guide

Use annual scheduled principal and coupon interest, alongside earmarked revenues net of prior claims for the same year.

Calculation guide

coverage = (revenue-prior)/(principal+interest) · residual = revenue-prior-principal-interest

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

InputValue
Annual earmarked revenue900,000
Prior claims on revenue150,000
Annual principal due500,000
Annual interest due100,000
ResultValue
Revenue debt-service coverage1.25
Revenue after debt service150,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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Annual earmarked revenue900,000990,000Revenue debt-service coverage1.251.4
Prior claims on revenue150,000165,000Revenue debt-service coverage1.251.225
Annual principal due500,000550,000Revenue debt-service coverage1.251.153846
Annual interest due100,000110,000Revenue debt-service coverage1.251.229508
Municipal bond debt service from earmarked revenues →

Sources