1. Mary has just completed her undergraduate degree from Northwestern University and is already planning on entering an MBA program four years from today. The tuition will be $20,000 per year for two years, paid at the beginning of each year. In addition, Mary would like to retire 15 years from today and receive a pension of $60,000 every year for 20 years and receive the first payment 15 years from today. Mary can borrow and lend as much as she likes at a rate of 7%, compounded annually. In order to fund her expenditures, Mary will save money at the end of years 1-3 and at the end of years 6-14.

Calculate the constant annual dollar amount that Mary must save at the end of each of these years to cover all of her expenditures (tuition and retirement)? (Answer: $38254.77)

PLEASE SHOW THE ANSWER IN EXCEL WITH EXCEL FORMULA