In this lesson you will learn 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.
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%
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.