Your client is currently 40 years old (Year 0). They plan to retire when they are 60 (Year 20) and wish to withdraw $120,000 a year from their savings account for 30 years (through Year 59). This withdrawal will occur at the beginning of each year. However, they also wish to leave a $25,000 gift to their children (in Year 59). They currently have $200,000 saved. Ignoring taxes and other complications, how much must they save before retirement in order to meet their goals? Create a table below that shows their age, beginning of the year account balance, the payment at the beginning of the year, the withdrawal at the beginning of the year, and the total at the end of the year. Assume that they can borrow and lend at 10% and that all savings are deposited at the beginning of the year. (HINT: USE GOAL SEEK)

SHOW EXCEL FORMULAS / WORK