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: ...