CAGR Formula in Excel

Compound ROI Calculator or Compound Growth Rate

Compound ROI Calculator or compound growth rate is the rate of return or Return On Investment at the end of the time period used in compounding calculation.

Simply said, Compound ROI, Compound annual growth rate is the compounding percentage used in Forex compound calculator to get an ending balance.

ROI(CAGR) = ((Ev / Bv)^1/n  – 1)*100

Ev – ending value

Bv – beginning value

n  – number of time periods

CAGR is also called compound annual growth rate which represents annual return on Forex compounding plan.

That means CAGR watch the annual return, but if you want to check other time periods return you can do that.

Here is how to do it.

If we use an example from above where we have $1000 invested and compounded 10% on each day through 10 days.

The result from the graph is below. You could make

10% return – $17.449,40

But when you calculate ROI or CAGR you get this:

ROI(CAGR) = (Ev / Bv)^1/n  – 1*100

Ev = $17.449,40

Bv = $1000

n  = 30

ROI(CAGR) = (17.449,40 / $1000)^1/30  – 1*100

ROI(CAGR) = (17,4494)^0,033  – 1*100

ROI(CAGR) = (17,4494)^0,033  – 1*100

ROI(CAGR) = (1,099  – 1)*100

ROI(CAGR) = 9,99%

You see, the CAGR or compounding ROI is the percentage used at the start in compounding calculation to get the result.

CAGR is the reverse compounding process which gives you insight how the Forex trading investment has grown over a time period.

CAGR Formula in Excel

If you want to use CAGR in excel then the formula for CAGR in excel is equal to:

CAGR = ((End_balance / Start_Balance)^(1/time period) – 1)*100

Maybe this is not easy to understand if you are beginner in Forex trading, but here is an example in Excel directly so it is easier to understand the formula.

I will use the same example as above where I have:

Initial investment or start balance = $1000

End balance = $17.449,40

Time period = 30

How to Use CAGR Formula in Excel

There are two ways you can get CAGR in excel and that by using excel RRI function or directly entering CAGR formula in the excel.

Let me show the first way and that is to use the RRI function.

RRI function in excel looks like this:

=RRI(nper; pv; fv)

nper = time period

pv = start balance

fv = end balance

Here you would get the result in decimal point and to get the result in percentage % you would need to multiply the result with 100.

Here is the result in the excel when you type the RRI formula to get the CAGR in excel.

When I select all three variables for the RRI function you would get this in the excel.

When you confirm all the data in the RRI formula to get a CAGR in the excel you would get 10% as a result.

10% is the percentage I have used in the compounding calculation to get the 30 day result.

Here is what you get in excel.

Example of CAGR Formula in Excel

Now I will show you the real CAGR formula in the excel which same formula I have used above when I have calculated the CAGR for the 30 day time period.

I will enter all the data from the CAGR formula:

CAGR = ((End_balance / Start_Balance)^(1/time period) – 1)*100

I have added column letters so it is easier to understand the formula used in excel to get CAGR.

You see that the CAGR formula in excel is the same as the formula here. The data used from the table in the excel gives us final CAGR = 10% which was the percentage used in the compounding calculation on $1000 starting balance.