80% of 2 Lakhs = Rs 1,60,000
Calculate three different Future Values as follows
=FV(6%,10,0,-160000)=Rs. 2,86,535.63. This number becomes PV for the next 15 years
=FV(7%,15,0,-286535.63)=Rs. 7,90,560.84. This number becomes PV for the next 5 years
=FV(5%,5,0,-790560.84)=Rs. 10,08,978.22