How much money do you need for your future goals: Here’s how to calculate – How much money should you need for your child’s education?​How much money should you invest in a mutual fund to build a corpus for your child’s higher education after 15 years?​

Rate this post

Let us assume that you need Rs 5 lakh for your child’s higher education today and the inflation rate will be 7 per cent. Now using MS Excel, you could calculate your future expense.w using MS Excel, you could calculate your future expense.

You need to open the worksheet and click on ‘fx’ from the status bar at the top of the sheet and choose ‘financial;’ as the category. In the list that appears, you should scroll to ‘FV’ or future value. If you click on it, it will open a dialogue box. The acronym ‘Nper’ means the number of periods, which is 15 in this case, ‘Rate’ is the inflation rate (that is 7 per cent or 0.07), ‘PMT’ can be skipped, and ‘PV’ is the current cost of highest education (5,00,000). The result will be Rs 13,79,516 that you will need after 15 years.

Leave a Comment

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

Please consider supporting us by disabling your ad blocker on our website