• 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.

Description
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

Discuss

## Reviews

• (last updated: 24/03/2021 16:33)
• (last updated: 12/01/2019 15:28)
• (last updated: 25/06/2018 17:13)
• (last updated: 14/06/2018 06:26)

## Any questions on Real Rate Of Return Excel Template?

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