Ravi Sir's Cards › Excel
CAGR Calculator in Excel (card 2 of 2)
Revision card 2 for CAGR Calculator in Excel: Same money in FD: =C7*(1+$B$4)^E7 gives ₹1,40,255; Beat FD?: =IF(D7>I7,"Yes","No") gives Yes; Best CAGR: =INDEX(A7:A11,MATCH(MAX(G7:G11),G7:G11,0)) gives Gold.
Read card text
What this card says
2 for CAGR Calculator in Excel: Same money in FD: =C7*(1+$B$4)^E7 gives ₹1,40,255
Beat FD?: =IF(D7>I7,"Yes","No") gives Yes
Best CAGR: =INDEX(A7:A11,MATCH(MAX(G7:G11),G7:G11,0)) gives Gold.
Learn this in the lesson: CAGR Calculator in Excel: Compare Investment Returns with a Formula and the RRI Function