Ravi Sir's Cards › Excel
CAGR Calculator in Excel (card 1 of 2)
Revision card 1 for CAGR Calculator in Excel: Years held: =YEARFRAC(B7,$B$3) gives 5.00; Total return: =D7/C7-1 gives 76.0%; CAGR: =(D7/C7)^(1/E7)-1 gives 11.97%. Includes an example data table.
Read card text
What this card says
1 for CAGR Calculator in Excel: Years held: =YEARFRAC(B7,$B$3) gives 5.00
Total return: =D7/C7-1 gives 76.0%
CAGR: =(D7/C7)^(1/E7)-1 gives 11.97%. Includes an
Example
data table
Learn this in the lesson: CAGR Calculator in Excel: Compare Investment Returns with a Formula and the RRI Function