Ques 1.) Solve given Problem :-

a.Ms. Shruti is 45 years old and plans to retire at 60. Her life expectancy is 80 years. Ms. Suman her Financial Planner, estimates that her client will require Rs.540,000 in the first year after retirement. Inflation rate is 6% p.a. and the rate of return is 10% p.a. What will be the savings per year required in order to meet this?

b.Ms Ananaya wanted to have a retirement corpus of Rs.1.5 Crores. She has 18 years to go for retirement. But now she wants to retire 3 years earlier. What is the additional amount that she needs to invest each year if the rate of return is 8%?

You have to answer in both - Using on Excel & Using handwritten or Typed [ For explanation steps by steps ]