Ravi Sir's Cards › Excel
Savings Goal Calculator in Excel (card 2 of 2)
Revision card 2 for Savings Goal Calculator in Excel: Value at the deadline with the plan: =FV(E5/12,D5,-H5,-C5) gives ₹1,49,703; Saving needed for all goals: =SUM(F5:F8) gives ₹25,183; Overall progress: =C10/B10 gives 26%.
Read card text
What this card says
2 for Savings Goal Calculator in Excel: Value at the deadline with the plan: =FV(E5/12,D5,-H5,-C5) gives ₹1,49,703
Saving needed for all goals: =SUM(F5:F8) gives ₹25,183
Overall progress: =C10/B10 gives 26%.
Learn this in the lesson: Savings Goal Calculator in Excel: How Much to Save Each Month (PMT, NPER and Goal Seek)