how to calculate Deposit, Account Balance, Pv of Total Tuition and Annual Deposit Amount? please with formulas. I appreciated

Henry Spencer is interested in saving money to put his son, Shawn, through college. Shawn is turning 4 years old today, and Henry wants to be able to deposit an equal amount into a savings account each birthday until shawn turns 21. He wants the deposits to be just large enough to pay for all 4 years of Shawn's education, and he plans to make the first deposit in one year. You can assume that tuition payments will be made on Shawn's 18th through 21st birthdays. You can also assume that the current cost of tuition is $12,500 a year, and that the cost will increase by 5.5% per year. If Henry is able to earn 2.5% a year in his account, how much should he deposit in the acount each year? Deposit Account Balance PV of Total Tuition Annual Deposit Amount X Rate of Return Tuition Cost This Year Tuition Inflation Rate 2.5% 12,500.00 5.5% y Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Shawn's Age 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Tuition 12,500.00 13,187.50 13,912.81 14,678.02 15,485.31 16,337.00 17,235.54 18,183.49 19,183.58 20,238.68 21,351.81 22,526.16 23,765.09 25,072.17 26,451.14 27,905.96 29,440.78 31,060.03 X X X Y Y