Table of Contents
What is the Sinking Fund Formula?
Sinking fund refers to a fund that is set up by the particular bond issuer in order to repurchase a definite portion of the bond issue or for replenishment of a major asset or any other similar capital expenditure. As such, the bond issuer is required to contribute a certain amount of money to the sinking fund each period and the formula for the sinking fund is as shown below.
- P = Periodic contribution to the sinking fund,
- r = Annualized rate of interest,
- n = No. of years
- m = No. of payments per year
And the formula for the periodic contribution to the sinking fund can be represented as,
Explanation of the Sinking Fund Formula
The formula for sinking fund can be derived by using the following steps:
Step 1: Firstly, determine the required periodic contribution to be made to the sinking fund as per the company strategy. The periodic contribution is denoted by P.
Step 2: Now, the annualized rate of interest of the fund and the frequency of the periodic payment has to be determined which are denoted by r and m respectively. Then the periodic interest rate is computed by dividing the annualized interest rate by the number of pay per year.
Periodic interest rate = r / m
Step 3: Now, the number of years has to be determined and it is denoted by n. Then the total number of periods is computed by multiplying the number of years and the frequency of payments in a year.
Total number of periods = n * m
Step 4: Finally, the calculation of the sinking fund can be done by using the periodic interest rate (step 2) and the total number of periods (step 3) as shown above.
Examples of Sinking Fund Formula (with Excel Template)
Let’s see some simple to advanced examples of Sinking Fund formula to understand it better.
Sinking Fund Formula – Example #1
Let us take an example of a sinking fund with a monthly periodic contribution of $1,500. The fund will be required to retire a newly taken debt (zero coupon bonds) raised for the ongoing expansion project. Do the calculation of the amount of the sinking fund if the annualized rate of interest is 6% and the debt will be repaid in 5 years.
Use the following data for the calculation of Sinking Fund Formula.
Therefore, the calculation of the amount of the sinking fund is as follows,
- Sinking Fund Formula = ((1+6%/12) ^(5-12) – 1)/(6%/12) * $1,500
Sinking Fund will be –
- Sinking Fund = $104,655.05 ~ $104,655
Therefore, the company will require a sinking fund of $104,655 to retire the entire debt five years from now.
Sinking Fund Formula – Example #2
Let us take an example of a company ABC Ltd which has raised fund in the form of 1,000 zero coupon bonds worth $1,000 each. The company wants to set up a sinking fund for repayment of the bonds which will be after 10 years. Determine the amount of the periodic contribution if the annualized rate of interest is 5% and the contribution will be done half-yearly.
First, do the calculation of Sinking Fund Required for the calculation of Periodic Contribution.
- Given, Sinking fund, A = Par value of bond * No. of bonds
- = $1,000 * 1,000 = $1,000,000
Use the following data for the calculation of Periodic Contribution.
Therefore, the amount of the periodic contribution can be calculated using the above formula as,
- Periodic contribution = (5%/2)/((1+5%/2)^(10*2) -1) * $1,000,000
Periodic contribution will be –
- Periodic contribution = $39,147.13 ~ $39,147
Therefore, the company will be required to contribute a sum $39,147 half-yearly in order to build the sinking fund to retire the zero coupon bonds after 10 years.
Relevance and Uses of Sinking Fund Formula
From the point of view of an investor, a sinking fund can be beneficial in three major ways-
- The interim retirement of debt results in lower principal outstanding that makes the final repayment much more comfortable and likely. This lowers the risk of default.
- In case the rate of interest increase, which lowers the bond prices, an investor gets some downside risk protection because the issuer is required to redeem a certain portion of these bonds. The redemption is executed at the sinking fund call price which is usually fixed at the par value.
- A sinking fund is required to maintain liquidity of the bonds in the secondary market by acting as a buyer. When the interest rates increase leading to a lower value for the bonds, this provision benefits the investors because the issuers have to buy the bonds even if the prices fall.
However, there are several disadvantages too for the investors-
- If the bond prices increase due to a decrease in interest rate, the investor’s upside may end up limited because of the compulsory redemption mandated for the sinking fund of bond. This means that the investors would receive the fixed sinking-fund price for their bonds despite the fact that the bonds are priced higher in the open market.
- Further, the investors might end up reinvesting their money elsewhere at a lower rate due to the sinking fund provisions in a market with a declining interest rate.
For issuers, the sinking fund acts as a credit enhancement and as such enables companies to borrow cheaply. Consequently, bonds with sinking funds often offer lower yields than similar bonds without sinking funds because of lower default risk and downside protection.
You can download this Sinking Fund Formula Excel Template from here – Sinking Fund Formula Excel Template
This has been a guide to Sinking Fund Formula. Here we discuss how to calculate the Sinking Fund along with the practical examples and downloadable excel sheet. You can learn more about accounting from the following articles –