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
| Input | Value |
|---|---|
| Opening sinking fund | 100,000 |
| Annual year-end deposit | 20,000 |
| Years to maturity | 5 |
| Annual fund yield (%) | 0% |
| Redemption amount due | 220,000 |
| Result | Value |
|---|---|
| Funding shortfall at maturity | 20,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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Opening sinking fund | 100,000 | 110,000 | Funding shortfall at maturity | 20,000 | 10,000 |
| Annual year-end deposit | 20,000 | 22,000 | Funding shortfall at maturity | 20,000 | 10,000 |
| Years to maturity | 5 | 6 | Funding shortfall at maturity | 20,000 | 0 |
| Annual fund yield (%) | 0% | 1% | Funding shortfall at maturity | 20,000 | 12,878.89479 |
| Redemption amount due | 220,000 | 242,000 | Funding shortfall at maturity | 20,000 | 42,000 |
