Ravi Sir's Cards › Excel
SIP Calculator in Excel (card 1 of 2)
Revision card 1 for SIP Calculator in Excel: Monthly rate from the yearly return: =(1+B5)^(1/12)-1 gives 0.9489%; Number of monthly instalments: =B6*12 gives 180; Value at the end of a flat SIP: =FV(B10,B11,-B4,0,IF(B8="Start of month",1,0)) gives ₹23,79,657.
Read card text
What this card says
1 for SIP Calculator in Excel: Monthly rate from the yearly return: =(1+B5)^(1/12)-1 gives 0.9489%
Number of monthly instalments: =B6*12 gives 180
Value at the end of a flat SIP: =FV(B10,B11,-B4,0,IF(B8="Start of month",1,0)) gives ₹23,79,657.
Learn this in the lesson: SIP Calculator in Excel: Future Value of a Monthly SIP with the FV Function (and a Yearly Step-Up)