Open calculator ↗

Municipal sinking fund adequacy · Calculation guide

Grow the opening balance and equal year-end deposits to maturity using annual compounding.

Calculation guide

Compare with the lump-sum redemption requirement.

gap = max(0,due − future fund) · coverage = 100 × future fund/due

Inputs

Opening sinking fund

Example entry 100000.0 (in the selected currency).

Annual year-end deposit

Example entry 20000.0 (in the selected currency).

Years to maturity

Example entry 5.0. Minimum 1. Use whole numbers.

Annual fund yield (%)

Example entry 0.0 %. Allowed range 0 to 100.

Redemption amount due

Example entry 220000.0 (in the selected currency). Minimum 1e-12.

Worked example

InputValue
Opening sinking fund100,000
Annual year-end deposit20,000
Years to maturity5
Annual fund yield (%)0%
Redemption amount due220,000
ResultValue
Funding shortfall at maturity20,000
Redemption coverage (%)90.909091%

Interpreting the result

Coverage below 100% leaves a redemption shortfall; coverage above 100% indicates a projected surplus.

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Opening sinking fund100,000110,000Funding shortfall at maturity20,00010,000
Annual year-end deposit20,00022,000Funding shortfall at maturity20,00010,000
Years to maturity56Funding shortfall at maturity20,0000
Annual fund yield (%)0%1%Funding shortfall at maturity20,00012,878.89479
Redemption amount due220,000242,000Funding shortfall at maturity20,00042,000
Municipal sinking fund adequacy →

Sources