When calculating CAGR, first add the periods and the values for each period. To do this, you need one column for Years and another for Amount. If you are still unsure, the information below explains ...