Ravi Sir's Cards › Excel
Savings Goal Calculator in Excel (card 1 of 2)
Revision card 1 for Savings Goal Calculator in Excel: Progress so far: =C5/B5 gives 13%; Monthly saving needed: =-PMT(E5/12,D5,-C5,B5) gives ₹5,012; Months the plan takes: =NPER(E5/12,-H5,-C5,B5) gives 24.1.
Read card text
What this card says
1 for Savings Goal Calculator in Excel: Progress so far: =C5/B5 gives 13%
Monthly saving needed: =-PMT(E5/12,D5,-C5,B5) gives ₹5,012
Months the plan takes: =NPER(E5/12,-H5,-C5,B5) gives 24.1.
Learn this in the lesson: Savings Goal Calculator in Excel: How Much to Save Each Month (PMT, NPER and Goal Seek)