A time line will help in solving it. Your friend is celebrating her 29th birthday today and wants to start saving for her anticipated retirement at age 65. She wants to be able to withdraw $100,000 from her savings account on each birthday for 15 years following her retirement; the first withdrawal will be on her 66th birthday. Your friend intends to invest her money in the local credit union, which offers 10 percent interest per year. She wants to make equal annual payments on each birthday into the account established at the credit union for her retirement fund. (Do not include the dollar signs ($). Round your answers to 2 decimal places. (e.g., 32.16))
A) if she starts making these deposits on her 30th birthday and continues to make deposits until she is 65 (the last deposit will be on her 65th birthday), she must deposit $ _______ annually to be able to make the desired withdrawals at retirement.
B)Suppose your friend has just inherited a large sum of money. Rather than making equal annual payments, she has decided to make one lump sum payment on her 29th birthday to cover her retirement needs. This deposit will have to be in the amount of $_______
C)Suppose your friend’s employer will contribute $800 to the account every year as part of the company’s profit-sharing plan. In addition, your friend expects a $38,000 distribution from a family trust fund on her 55th birthday, which she will also put into the retirement account. She must deposit $__________ annually now to be able to make the desired withdrawals at retirement.
First step is to google:
Schwab and Fidelity have good ones.
Sorry, this is going to take all day to figure out, and I’m not getting paid for it.
Hope you use an Exell spreadsheet.
My guess is she will need about 2.5 million at retirement age.