Real Rate of Return Excel Template
Originally published: 23/03/2018 14:01
Publication number: ELQ-34059-1
View all versions & Certificate

Real Rate of Return Excel Template

Calculate your exact return when investing a specific amount of money.

Real rate of return helps investors calculate their exact return when they invest a particular sum of money into a project.

The formula is the following:

Real Rate of Return: (1 + Nominal rate)/(1 + Inflation Rate) -1

This formula first considers the nominal rate, then considers the inflation rate. The rate of return offered by the investment or bank us the nominal rate of return. However, we require the consumer price index to calculate the inflation rate. Businesses can use different consumer price indexes to calculate the inflation, or alternatively can take the goods and services into account that are related to their business.

The formula to calculate the rate of inflation is the following:

Rate of Inflation = (CPI x+1 – CPI x) / CPI x

Here, CPI x means initial consumer index.

If you have invested a substantial amount, it is a good idea to use the real rate of return to calculate how much you are actually earning on an investment. However, if you merely want to see how much you are making in a casual sense, simply use this formula: (nominal rate - inflation rate).

This template allows you to calculate real rate of return with ease.

This Best Practice includes
1 Excel Template and 1 Tutorial Video

Dheeraj Vaidya CFA FRM offers you this Best Practice for free!

download for free

Add to bookmarks



  • Rate this Downloadable Best Practice

    Write a review

  • Dr Ron3(last updated: 24/03/2021 16:33)
  • KGreen(last updated: 12/01/2019 15:28)
  • Brandon Brown(last updated: 25/06/2018 17:13)
  • Apollo Rajkumar(last updated: 14/06/2018 06:26)

People using this Best Practice also downloaded


More Best Practices from Dheeraj Vaidya CFA FRM

See all

Any questions on Real Rate Of Return Excel Template?

The user community and author are here to help. Go ahead!

4.0 / 5 (4 votes)

please wait...