Question: how to calculate a rate of return in excel?
Answer: Rate of Return = (10 * 1000 – 5 * 1000) * 100 / 5 *1000. Rate of Return = (10,000 – 5,000) * 100 / 5,000. Rate of Return = 5,000 * 100 / 5,000. Rate of Return = 100%