please help with #20, using excel and the template attached

U, JU) TUU,UL! 78 79 80 81 (75,068) (183,821) (298,012) (417,913) (543,808) (675,999) (814,799) TUUUUU) (100,000) (100,000) (100,000) (100,000) (100,000) (100,000) (14,191) (19,901) (25,896) (32,190) (38,800) (45,740) (298,012) (417,913) (543,808) (675,999) (814,799) (960,539) 82 83 84 20. (Financial planning, finding pmt) Solve the previous problem using tions PV and PMT and the template below: A SAVING FOR THE FUTURE 2 Pension savings today Annual desired pension payout 4 Number of years until retirement 5 Number of payout years after retirement 6 Interest rate 500,000 100,000 10 20 5% 7 18 Present value today of all future retirement payments 9 Annual payment until retirement 21. (Financial planning) Today is your 40th birthday. You expect to retire 65, and actuarial tables suggest that you will live to be 100. You U, JU) TUU,UL! 78 79 80 81 (75,068) (183,821) (298,012) (417,913) (543,808) (675,999) (814,799) TUUUUU) (100,000) (100,000) (100,000) (100,000) (100,000) (100,000) (14,191) (19,901) (25,896) (32,190) (38,800) (45,740) (298,012) (417,913) (543,808) (675,999) (814,799) (960,539) 82 83 84 20. (Financial planning, finding pmt) Solve the previous problem using tions PV and PMT and the template below: A SAVING FOR THE FUTURE 2 Pension savings today Annual desired pension payout 4 Number of years until retirement 5 Number of payout years after retirement 6 Interest rate 500,000 100,000 10 20 5% 7 18 Present value today of all future retirement payments 9 Annual payment until retirement 21. (Financial planning) Today is your 40th birthday. You expect to retire 65, and actuarial tables suggest that you will live to be 100. You