Part A: Your client is 50 years old and currently has $400,000 in their savings account. What constant amount per year must they save in order to begin withdrawing $90,000 when they are 60 and have nothing left over at the end of their 85th year? Assume that their savings account earns 5% per year.
To solve this problem, create a table with the following columns: Age, Beg. of Year Balance, Deposit/Withdrawal, Interest Earned, End of Year Balance.
please use excel for this