Turning One Time Gain Into Compound Annual Return

  • Thread starter Thread starter Will
  • Start date Start date
W

Will

If you will receive 100 + X% of an investment in Y months, what is the best
way to calculate the annual compound return represented by that?
 
If you will receive 100 + X% of an investment in Y months, what is the best
way to calculate the annual compound return represented by that?
Click to expand...

Two equivalent ways are:

=(1+x%)^(12/y) - 1

=(1 + rate(5,0,-1,1+x%))^12 - 1

PS: I assume you mean that you invested 100 and you will receive
100*(1+x%) in Y months. That is, your investment will grow by x% in Y
months.
 
Back
Top