MUST SHOW SOLUTIONS IN EXCEL, PLEASE LEAVE FORMULAS FOR ALL SOLUTIONS

8. The 2020 tuition fee for a popular university is $9520.12. Assume tuition is increasing by 3.0% annually. (a) What is the total tuition to be paid by a student entering the university in 2040 for a four-year degree? (b) With the goal to save this amount for your child, and assuming a 2.5% annual interest rate, what is the monthly payment required. (c) How much money would be saved by the year 2030