Ravi Sir's Cards › Excel
SIP Calculator in Excel (card 2 of 2)
Revision card 2 for SIP Calculator in Excel: Total money put in: =B4*B11 gives ₹9,00,000; Estimated gain: =B12-B13 gives ₹14,79,657; The rate/12 version, only to compare: =FV(B5/12,B11,-B4,0,1) gives ₹25,22,880.
Read card text
What this card says
2 for SIP Calculator in Excel: Total money put in: =B4*B11 gives ₹9,00,000
Estimated gain: =B12-B13 gives ₹14,79,657
The rate/12 version, only to compare: =FV(B5/12,B11,-B4,0,1) gives ₹25,22,880.
Learn this in the lesson: SIP Calculator in Excel: Future Value of a Monthly SIP with the FV Function (and a Yearly Step-Up)