PIU K G H A D B 1 Q.32) Ram is planning to retire in 10 years. He has a saved Rs. 5 lacs to date, and he estimates his savings and investments to grow at 9% per year. He further planns to invest 10,000 every month. 2 3 i) Use MS Excel financial functions to calculate his final retirement corpus? (2) 4 Savings (PV) -666,667 5 Nominal Int/Yr 6 Period 10 Years 7 PMT Per Month 8 9 Retirement Corpus 10 11 ii) Use Data Table to claculate Retirement Corpus for combinations of Interest Rate and Years. (3) 12. 13 Nominal Int/Yr 9.5% 11.0% 10.5% 10.0% 9.0% 8.5% 8.0% 14 8 15 9 Years 10 16 17 18 19 11 20 21