Question: how to calculate annual rate of return in excel?
Answer: Annualized Rate of Return = (45 * 100 / 15 * 100)(1 /5 ) – 1. Annualized Rate of Return = (4500 / 1500)0.2 – 1. Annualized Rate of Return = 0.25.