WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Investment Banking Tutorials » Economics Tutorials » Real Interest Rate Formula

Real Interest Rate Formula

By Harsh KataraHarsh Katara | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Formula to Calculate Real Interest Rate

Real Interest Rate formula calculates the rate of interest after excluding the impact of inflation and provides a means to measure inflation-adjusted return on investments in financial security or a loan or deposits.

The formula is given below:

Real Interest Rate = Nominal Rate of Interest – Inflation (Actual or Expected)

Real Interest Rate Formula

  • The nominal interest rate is mostly quoted by the banks or any other financial institutions. Hence, the first-rate that is used in the calculation is the nominal rate of interest.
  • The second one is the inflation rate which can be the actual rate of interest or it could be an expected rate of interest.
  • The difference between the two that is a nominal rate of interest and inflation rate will be a real rate of interest.

Examples

You can download this Real Interest Rate Formula Excel Template here – Real Interest Rate Formula Excel Template

Example #1

The nominal rate of interest that has been prevailing for a long time has been around 9% and the rate of inflation has been come out as 3%. You are required to calculate the real rate of interest.

Solution:

Use below given data for calculation of real interest rate.

  • Nominal rate of Interest: 9%
  • Inflation Rate: 3%

Calculation of real interest rate can be done as follows:

 Example 1.1

We are given both figures to calculate the real rate of interest.

Real Interest Rate = 9% – 3%

Real Interest Rate will be –

Real Interest Rate Formula Example 1.2

Real Interest Rate = 6%

Hence, the real rate of interest is 6%.

Example #2

World bank has been in task of completing statistics figures of some of the countries. They are now left with two countries for which the deadline to complete the statistics is by next week. William has joined the team recently which does the calculation of interest rates. William is an economist and has done the master’s in it. He was given a task to complete calculation of the real rate of interest for the remaining two countries X and Y. Below are the details that were collected by the ex-employee for these countries.

Particulars Country X Country Y
Deposit Rate of Interest 11% 10.50%
Value of Basket of Goods in year 2019     123,331,456.43 141,678,331.23
Value of Basket of Goods in year 2018     120,899,345.98 140,993,221.77

Based on the above available information, you are required to calculate the real rate of interest. If someone wants to invest their funds, where should one invest whether in Country X or Country Y?

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course
Solution:

Here, we have to have a nominal rate of interest which is the deposit rate of interest, but we are not given the real rate of interest which we shall calculate for both countries.

Inflation Rate for Country X will be –

Inflation Rate = 123,331,456.43 / 120,899,345.98 – 1 = 2.01%.

Calculation of Real Interest Rate for Country X can be done as follows:

Real Interest Rate Formula Example 2.1

Real Interest Rate = 11% – 2.01%

Real Interest Rate for Country X will be –

Example 2.2

Real Interest Rate = 8.99%

Inflation Rate for Country Y will be –

Inflation Rate = 141,678,331.23 / 140,993,221.77 – 1 = 0.49%

Calculation of Real Interest Rate for Country Y can be done as follows:

Real Interest Rate Formula Example 2.3

Real Interest Rate = 10.50% – 0.49%

Real Interest Rate for Country Y will be –

Example 2.4

Real Interest Rate = 10.01%

Hence, in real terms, it is better to invest in country Y as the country provides a higher rate of interest.

Example #3

XYZ wants to invest in a fixed deposit, and he wants ABC bank. The bank pays a 7% rate of interest irrespective of the duration and amount. The fixed deposit amount is $100,000. He happily invests the amount for a period of 3 years. Later, on a news channel, he learns that the country is facing a high level of inflation, and currently its 8% and further it was expected that after 3 years it will be 8.50%.

Based on the above scenario, you are required to confirm whether XYZ will earn or lose money?

Solution:

Use below given data for calculation of real interest rate.

  • Nominal Rate of Interest: 7.00%
  • Inflation Rate: 8.50%

First, we shall calculate the real rate of interest. Since XYZ is investing for 3 years, and hence while calculating a real rate of interest, we shall use the expected inflation rate of interest which is 8.50% and not 8.00%.

Calculation of real interest rate can be done as follows:

Example 3.1

Real Interest Rate = 7% – 8.50%

Real Interest Rate will be –

Real Interest Rate Formula Example 3.2

Real Interest Rate = -1.50%

Hence, the real rate of interest is -1.50%, which clearly indicates XYZ will lose money in real terms since inflation is greater than the rate of interest offered by the bank.

Relevance and Uses

  • The real rate of interest shall adjust the observed interest rate of the market so as to remove the effects of ongoing or expected inflation.
  • The real rate of interest does reflect the purchasing power value of the interest which is paid on a loan or an investment and which shall represent the rate of interest that will be preferred time of the lender and the borrower.
  • As the rate of inflation does not remain constant, the prospective real rate of interest will rely on the estimates of future inflation that will be expected over the time to maturity of an investment or a loan.
  •  The conclusion is that an investor earns a real rate and not a nominal rate as the other part of the nominal rate is eaten by inflation.

Recommended Articles

This has been a guide to the Real Interest Rate Formula. Here we discuss the calculation of real interest rate with practical examples and downloadable excel template. You can learn more about financing from the following articles –

  • Accrued Interest Calculation
  • Explanation of Money Multiplier Formula
  • Compare – Nominal vs Real Interest Rate
  • Formula of Interest Rate
6 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Download Real Interest Rate Formula Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More