Tuesday, 10 December 2019

Tit Bit 44 (E) – Learn Spread sheet (Excel/Google sheet) Series

Amount required for future plans /Goals
Use Excel / Google sheets for simple financial planning calculations

Problem:
Radha thinks he can buy a house in 10 years. Current price is  40  lakhs. Expected Inflation is 7%. Then how much money should he have after  ten years to buy that house?

Solution:
FV - Calculating the required amount:
We can calculate this easily using Excel / Google sheets FV function.




Previous tidbits :

To learn more about using excel function click here to find more articles and templates in excel
https://radhaconsultancy.blogspot.com/2016/05/a-gateway-to-mutual-funds.html

No comments:

Post a Comment