103. Mr. X decides to deposit Rs.15,000/- every month in the beginning into an account yielding 14% p.a. for 20 years. What will be the accumulated value in this account after 20 years and how much amount can be withdrawn from this account every month in the beginning for a further period of 20 years if ROI 8% p.a.?
Explanation:
14% annually can be converted into monthly figure as follows [1.14^(1/12)]-1 = 0.010978852
Monthly rate of return = 1.0978%. Hence Future value is calculated as
=FV(1.0978%,20*12,-15000,0,1)
=₹ 1,75,99,623.91
Similarly 8% return annually can be converted into monthly as [1.08^(1/12)]-1
Which is 0.6434%
So Using Rs 1,75,99,623.91 as present value and 0.6434% as rate of return, we can calculate PMT i.e the amount that can be withdrawn for 20 years i.e 240 months
=PMT(1.08^(1/12)-1,240,17599624,0,1)
=Rs 1,43,245.71