Sinking Fund Calculator
Estimate the equal contribution required each compounding period to reach a future funding target.
Funding assumptions
Required funding plan
Projected fund balance
Final projected balance
Contribution schedule
| Period | Beginning balance | Contribution | Interest | Ending balance |
|---|
How to use this sinking fund calculator
What this calculator does
This calculator estimates the equal amount you need to contribute at the end of every compounding period to accumulate a chosen future balance. It is useful for bond redemption reserves, equipment replacement funds, planned capital expenditures, property repairs, and other obligations that are easier to finance through regular deposits than through one final lump sum. The result is a mathematical funding estimate based on a fixed nominal annual interest rate, a fixed contribution frequency, and equal end-of-period deposits. It does not predict investment returns, taxes, fees, missed deposits, or changes in interest rates.
When to use it
Use the calculator when you are setting a periodic reserve for a known maturity amount, comparing monthly and quarterly funding policies, estimating how much interest can reduce your cash deposits, or documenting a reserve schedule for budgeting and treasury planning. Sinking funds are commonly associated with debt repayment, but the same future-value-of-an-annuity mathematics also works for replacement reserves and other planned cash needs.
How to calculate
- The calculator opens with a complete demonstration: a $150,000 target, a 3% annual rate, monthly compounding, and a five-year period. Its results and example Excel workbook are ready immediately.
- Replace Money to accumulate with your required future balance. Enter plain U.S. dollar numbers such as 150000 or 150,000.00.
- Enter the nominal Annual interest rate as a percentage, choose the Rate compounding frequency, and enter the Period in years.
- Read the required periodic contribution first, then review total deposits, interest earned, the balance chart, and the detailed contribution schedule.
- Select Download Excel to export the current assumptions and schedule. Reset clears the demonstration and all results; Excel export remains unavailable until you enter a complete valid set again.
Input guide
Money to accumulate is a required positive dollar amount and represents the balance needed at the end of the horizon. A realistic example is $150,000. Higher targets increase each required contribution in direct proportion. Do not enter a negative amount or confuse the target with the sum of deposits; interest means the two can differ. Annual interest rate is a required nominal percentage between 0% and 100%. Enter 3 for 3%, not 0.03. A higher rate generally lowers the needed contribution because more of the target comes from earnings, but the result assumes the rate remains unchanged. Rate compounding frequency is required and selects both how often interest is credited and how often equal contributions occur. Monthly means 12 contributions per year, while quarterly means four. Do not select a frequency that differs from the actual deposit schedule. Period is a required positive number of years up to 100; decimals are allowed when the selected frequency produces a whole number of contribution periods. Longer periods usually reduce each contribution but increase the number of deposits.
Output guide
Required contribution is the equal end-of-period deposit in dollars. USSF factor is the Uniform Series Sinking Fund factor; multiplying it by the target produces the contribution. Total contributions is the contribution multiplied by the exact number of periods. Interest earned is the target minus total deposits, so a zero-rate plan shows zero interest. Number of contributions is the selected frequency multiplied by the funding period. Periodic rate is the annual nominal rate divided by the compounding frequency. The Projected fund balance chart displays the ending balance after each deposit. In the Contribution schedule, Beginning balance is the prior period's ending balance, Contribution is the fixed deposit, Interest is the amount earned during that period, and Ending balance is the balance after interest and the new deposit.
Worked example
With a $150,000 target, a 3% nominal annual rate, monthly compounding, and five years, the periodic rate is 0.03 ÷ 12 = 0.0025 and the number of deposits is 12 × 5 = 60. The sinking fund factor is 0.0025 ÷ ((1.0025)60 – 1) = approximately 0.0154687. Multiplying $150,000 by that factor gives a required monthly contribution of $2,320.30. Across 60 deposits, total contributions are about $139,218.22, while interest supplies approximately $10,781.78 of the final target.
Formula and planning context
The equation is the inverse of the future value of an ordinary annuity. The U.S. Securities and Exchange Commission's compound interest guidance and calculator explains how rates, time, and compounding interact. For bond planning context, review the SEC's overview of bonds and maturity repayment. For broader cash-management discipline, the U.S. Small Business Administration discusses managing business finances and cash flow.
Interpretation and common mistakes
A low required contribution is not automatically better: it may depend on a long horizon or an optimistic return assumption. Test a lower interest rate as a downside case and compare the increase in required deposits. Keep the contribution timing consistent with the formula; beginning-of-period deposits would accumulate slightly more than the end-of-period deposits modeled here. Also distinguish nominal annual rate from effective annual yield. The calculator divides the nominal annual rate by the selected frequency, which matches the standard periodic-rate convention used in the reference model. Finally, treat the schedule as a planning baseline. Fees, taxes, variable yields, or skipped deposits require additional reserves.