FLASH SALE! - "FINANCIAL MODELING COURSE BUNDLE AT 60% OFF" Enroll Now

Forward Rate Formula

Updated on May 7, 2024
Article byWallstreetmojo Team
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

Formula to Calculate Forward Rate

The forward rate formula helps in deciphering the yield curve which is a graphical representation of yields on different bonds having different maturity periods. It can be calculated based on spot rate on the further future date and a closer future date and the number of years until the further future date and closer future date.

Forward Rate Formula

You are free to use this image on your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Forward Rate Formula (wallstreetmojo.com)

Forward Rate = [(1 + S1)n1 / (1 + S2)n2]1/(n1-n2) – 1

where S1 = Spot rate until a further future date,

  • S2 = Spot rate until a closer future date, n1 = No. of years until a further future date,
  • n2 = No. of years until a closer future date

The notation for the formula is typically represented as F(2,1), which means a one-year rate two years from now.

Key Takeaways

  • The forward rate formula calculates the expected future interest rate based on prevailing spot rates and the period involved.
  • This formula estimates the interest rate expected to prevail in the future, enabling market participants to make informed decisions and manage interest rate risk.
  • The forward rate formula is derived from the concept of the term structure of interest rates, which reflects the relationship between different maturities and their associated interest rates.
  • The formula assumes that future spot rates align with market expectations and that no arbitrage opportunities exist.

Forward Rate Calculation (Step by Step)

It can be derived by using the following steps:

  1. Firstly, determine the spot rate until the further future date for buying or selling the security, and it is denoted by S1. Also, compute the no. of the year till the further future date, and it is denoted by n1.

  2. Next, determine the spot rate until the closer future date for selling or buying the same security, and it is denoted by S2. Then, compute the no. of the year till the closer future date, and it is denoted by n2.

  3. Finally, the calculation of forward rate for (n1 – n2) no. of years after n2 no. of years is shown below. Forward rate = [(1 + S1)n1 / (1 + S2)n2]1/(n1-n2) – 1

Basic and Advanced Derivatives Course

–>> p.s. – If you want to hone your knowledge of Derivatives, then you may consider our ​​“Basics and Advanced Derivatives Bundle Course”​​ (12+ hours of video tutorials). This course covers all the crucial topics to improve your knowledge and understanding of basics to advance derivatives along with awareness as to how derivative instruments work and benefit you.

Examples

You can download this Forward Rate Formula Excel Template here – Forward Rate Formula Excel Template

Example #1

Let us take the example of a company PQR Ltd, which has issued bonds recently to raise money for its upcoming project to be completed in the next two years. The bonds issued with one-year maturity have offered a 6.5% return on investment, while the bonds with two years maturity have offered a 7.5% return on investment. Based on the given data, calculate the one-year rate one year from now.

Given,

  • The spot rate for two years, S1 = 7.5%
  • The spot rate for one year, S2 = 6.5%
  • No. years for 2nd bonds, n1 = 2 years
  • No. years for 1st bonds, n2 = 1 year
Forward Rate Formula eg1

As per the above-given data, we will calculate a one-year rate from now of company POR ltd.

Therefore, the calculation of the one-year forward rate one year from now will be,

Forward Rate Formula eg1.2png

F(1,1) = [(1 + S1)n1 / (1 + S2)n2]1/(n1-n2) – 1

= [(1 + 7.5%)2 / (1 + 6.5%)1]1/(2-1) – 1

Forward Rate Formula eg1.3png

One year FOR one year from now= 8.51%

Example #2

 Let us take the example of a brokerage firm that has been in the business for more than a decade. The firm has provided the following information. The table gives a snapshot of the detailed calculation of the forward rate.

  • Spot rate for one year, S1 = 5.00%
  • F(1,1) = 6.50%
  • F(1,2) = 6.00%

Based on the given data, calculate the spot rateCalculate The Spot RateSpot Rate' is the cash rate at which an immediate transaction and/or settlement takes place between the buyer and seller parties. This rate can be considered for any and all types of products prevalent in the market ranging from consumer products to real estate to capital markets. It gives the immediate value of the product being transacted.read more for two years and three years. Then calculate the one-year forward rate two years from now.

  • Given, S1 = 5.00%
  • F(1,1) = 6.50%
  • F(1,2) = 6.00%
Forward Rate Formula eg2

Therefore, the spot rate for two years can be calculated as,

S2 = [(1 + S1) * (1 + F(1,1))]1/2 – 1

= [(1 + 5.00%) * (1 + 6.50%)]1/2 – 1

Forward Rate Formula eg2.1png

Spot Rate for Two Years = 5.75%

Therefore, calculation of spot rate for three years will be,

S3 = [(1 + S1) * (1 + F(1,2))2]1/3 – 1

= [(1 + 5.00%) * (1 + 6.00%)2]1/3 – 1

Example 2.2

Spot Rate for Three Years= 5.67%

Therefore, the calculation of one-year forward rate two years from now will be,

Example 2.3

F(2,1) = [(1 + S3)3 / (1 + S2)2]1/(3-2) – 1

= [(1 + 5.67%)3 / (1 + 5.75%)2] – 1

Example 2.4png

Relevance and Uses

The forward rate refers to the rate that is used to discount a payment from a distant future date to a closer future date. It can also be seen as the bridging relationship between two future spot rates, i.e., further spot rate and closer spot rate. It is an assessment of what the market believes will be the interest rates in the future for varying maturities.

For instance, let us assume that Jack has received money today, and he wants to save the money to buy a real estate one year from today. Now, he can invest the money in government securities to keep it safe and liquid for the next year. However, in that case, Jack has two choices: He can either buy a government bond that will mature in one year, or he can opt to buy another government bondGovernment BondA government bond is an investment vehicle that allows investors to lend money to the government in return for a steady interest income.read more that will mature in six months, and then roll over the money for another six-month government bond when the first one matures.

In case both the options generate the same return on investment, then Jack will be indifferent and go with either of the two options. But what if the interest offered is higher for a six-month bond than the one-year bond. In that case, he will make more money by buying the six-month bond now and rolling it over for another six months. Now, It comes into play to calculate the return of the six-month bond six months from now. In this way, it can help Jack to take advantage of such a time-based variation in yield.

Frequently Asked Questions (FAQs)

1. What are the benefits of using the forward rate formula?

The forward rate formula provides benefits such as estimating future interest rates, assisting in the valuation of forward contracts, and facilitating pricing in various financial markets. It enables investors to make informed decisions about borrowing, lending, and investing based on expected future interest rates.

2. What limitations or factors should be considered when using the forward rate formula?

Limitations and factors to consider when using the forward rate formula include assumptions of constant interest rate expectations, the absence of market frictions, and the need for accurate forecasting. Market conditions, economic factors, and external events can affect interest rate movements, making accurate predictions challenging.

3. What is the forward rate formula vs. the cap rate formula?

The forward rate formula calculates expected future interest rates based on the current term structure of interest rates. In contrast, the cap rate formula estimates the capitalization rate used in real estate valuation. The forward rate formula focuses on interest rates, while the cap rate formula is specific to real estate and considers rental income and property values.

Recommended Articles

This has been a guide to Forward Rate Formula. Here we discuss how to calculate forward rate from spot rate along with the practical examples and downloadable excel sheet. You can learn more about accounting from the following articles –

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *