Risk Management Basics
- Derivatives Basics
- Put-Call Parity
- Forwards vs Futures
- Spot Rate
- Forward Rate Formula
- Cash Settlement vs Physical Settlement
- Backwardation vs Contango
- Residual Risk
- Best Futures Books
- Futures vs Options
- What are Options in Finance?
- Exercise Price (Strike Price)
- In the Money
- Options Trading Strategies
- Call Options vs Put Options
- Options vs Warrants
- Writing Call Options
- Writing Put Options
- Gamma of an Option
- Options Trading Books
- International Option Exchanges
- Interest Rate Derivatives
- Interest Rate Swap
- Swap Rate
- Random vs Systematic ErrorÂ
- Equity Strategies
- Swaps in Finance
- Embedded Derivatives
- Commodity Derivatives
- Commodity Risk Management
- Managed Futures Strategy
- Top 7 Best Books on Derivatives
- Structured Finance Jobs
- Commodities Trading Books
- Best Commodities Books
- Fixed Income
- Equity Research vs Credit Research - Know the difference!
- Credit Analysis | What Credit Analyst Look for? 5 C's | Ratios
- Yield Curve Slope, Theory, Charts, Analysis (Complete Guide)
- Bond Pricing
- Coupon Bond
- Coupon Bond Formula
- Zero Coupon Bond
- Duration Formula
- Coupon Rate Formula
- Carrying Value of Bond
- Sinking Fund Formula
- Coupon Rate of a Bond
- Convertible Securities
- What are Treasury Bills?
- Repurchase Agreement
- Treasury Bills vs Bonds
- Coupon vs Yield
- Coupon Rate vs Interest Rate
- Credit Rating Process | A Complete Beginner's Guide
- Asset Backed Securities (RMBS, CMBS, CDOs)
- Loss Given Default - LGD | Examples, Formula, Calculation
- Top 7 Best Fixed Income Books
- ABS and MBS Index | Complete Beginner's Guide
- Top 10 Best Treasury Management Book
- Top 10 Best Credit Research Books
- Convexity of a Bond | Formula | Duration | Calculation
- Payment in Kind Bond | PIK Definition | Interest | Example
- Subordination Debt | Meaning | Example | Types | Risks
- Top 10 Best Books - Bonds Market, Bond Trading, Bond Investing
- Bonds vs Debentures
- Secured vs Unsecured Loan
- Bills of Exchange vs Promissory Note
- Bills of Exchange | Meaning | Examples | Top Features
- Promissory Notes
- Secured Loans
- Unsecured Loans
- Subordinated Debt
- Fallen Angel
- Bond Equivalent Yield Formula
- Junior Tranche
- Credit Analyst Interview Questions and Answers
- Debt Covenants | Bond Covenant Examples | Positive & Negative
- Credit Analyst Career
- Negative Covenants (Restrictive)
- Sinking Fund
- Bond Sinking Fund
- Negotiable Instruments
- Credit Spread
- Bond Pricing Formula
- Risk Management Careers
- Complete Beginner's Guide to CRM Exam
- How to Become a Quantitative Financial Analyst
- Risk Management Certifications and Salary
- Financial Engineering Career Guide: Program, Jobs, Salary
- Quantitative Analyst Salary | Skills | Trends | Top Employers
- Certificate in Quantitative Finance (CQF) Exam Guide
- Relative Risk Reduction Formula
Formula of Sinking Fund (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
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 –