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