Question: how do you calculate the rate of return on an investment in excel?
Answer: Rate of Return = (Current Value – Original Value) * 100 / Original Value.
Rate of Return Apple = (1200 – 1000) * 100 / 1000.
Rate of Return Apple = 200 * 100 / 1000.
Rate of Return Apple = 20%