How To Calculate The Real Interest Rate
Calculate the real rate of interest when you are dealing with periodic interest capitalization. Otherwise, the actual rate and the nominal rate – is given by the bank – are the same.
Real Interest Rate calculations using Effect Function
Using the Effect function, you can calculate the real interest rate depending on the number of compounding periods per year.
To calculate the real interest rate you need to know the nominal interest rate and the number of compounding periods per year. In this example you will use one of the financial Effect function to calculate the real interest rate, the nominal rate of 5% and quarterly capitalization.
Go to the Formulas tab. Select the Function Library section and click Financial button.
Select an Effect function.
Dialog box appears. Type:
- Nominal_rate – nominal interest rate, be sure to type the symbol % as a fraction or decimal, such as 7% or 0.07,
- Npery – the number of compounding periods. It will always be an integer, for example, the monthly cap – type 12, the quarterly cap – type 4
So the calculated interest rate, simply multiply the amount invested to calculate how much your savings will grow over the year.
Formula in this example is: =EFFECT(“0.07”,4)
Result equals 0.071859. It is the same such 7.1859%
Real Interest Rate calculations based on Inflation Rate
You can also calculate Real Interest Rate the other way. Knowing the inflation rate you are able to calculate that using below formula:
Real Interest Rate = Nominal Interest Rate – Inflation Rate
Nominal interest rates = 5.75%
(Expected) Inflation rate = 2.25%
The task is to calculate real interest rate based on given data.
Real interest rate = 5.75% – 2.25% = 3.5%
The formula used is just =B2-B3.
Example – which investment is better?
The Bank offers two investments: a monthly interest rate of 15% per annum and 15.8% annual interest rate. Find out which place is more favorable.
If you choose an investment with the year capitalization, after one year the deposit will increase by 15.8%.
If you choose an investment with monthly capitalization, after one year the deposit will increase by =EFFECT(“0.15”,12). (the interest rate is 15% and the number of interest periods is equal to 12).
Result is 16,0755%. As you can see monthly deposit is favorable.
Template
Further reading: Basic concepts Getting started with Excel Cell References
