How to calculate return on investment (ROI), the money an investment made relative to its cost, in Microsoft Excel.

You can set this up in Excel to have all the data in one table, then break out the calculations line by line. 1 Let’s derive the compound annual growth rate of a company’s sales over 10 years: ...