1)
Age expenses Influation
35 20000 6%
PV -20000
R 6%
nper 25
FV ₹ 89,299.40
Pmt
2)
Influation 6%
Return 8%
Real rate
of return 1.89%
3)
PV
R 6%
nper 20
FV ₹ 41,466,274.59
Pmt -89299.4
4)
PV ₹ -272,466.02
R 5% 9%
nper 15 15
FV ₹ 566,437.29 566437.29
Pmt -25000
5)
PV
R 5% Influation(Q4)
nper 15
FV ₹ 424,827.97
Pmt -18750 75% of current expenses(Q4)
6)
PV -27500 Standard of living increase by 10%
R 5%
nper 26 =Retirement age - current age
FV ₹ 97,781.00
Pmt
PV
R 5%
nper 20 =expected to live - retirement age
FV ₹ 3,394,883.16
Pmt -97781