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

Real Rate of Return Excel Template

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

calculatorinvestinginvestmentreal return of returnreturn on investmentroirror

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 business tool includes
1 Excel Template and 1 Tutorial Video

Dheeraj Vaidya CFA FRM offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Reviews


keyboard_arrow_leftkeyboard_arrow_right

More tools from Dheeraj Vaidya CFA FRM

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Real Rate Of Return Excel Template?

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

please wait...