(Financial planning) Mary has just completed her undergraduate degree from Northwestern University and is already planning to enter an MBA program 4 years from today. The MBA tuition will be $50,000 per year for 2 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, with the first pension payment paid out 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 0–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). (It might be helpful to use Goal Seek.)

Note: Just to remove all doubts, here are the cash flows:

Transcribed Image Text:

A 1 E F Year 2 Balance at beginning of year before withdrawal beginning of year Mary's Financial Planning Withdrawal Net balance beginning of year 3 0 0.00 4 1 5 2 6 3 Savings at Account end of year end of year SX SX SX SX 7 4 -50,000.00 8 5 -50,000.00 9 6 SX 10 7 SX 11 8 SX 12 9 SX 13 10 SX 14 11 SX 15 12 SX 16 13 SX 17 14 SX 18 15 -60,000.00 19 16 -60,000.00 20 17 -60,000.00 21 18 -60,000.00 22 19 -60,000.00 23 20 -60,000.00 24 21 -60,000.00 25 22 -60,000.00 26 23 -60,000.00 27 24 -60,000.00 28 25 -60,000.00 29 26 -60,000.00 30 27 -60,000.00 31 28 -60,000.00 32 29 -60,000.00 33 30 -60,000.00 34 31 -60,000.00 35 32 -60,000.00 36 33 -60,000.00 37 34 -60,000.00 0