Requirements: Complete all parts of the problem below in Excel using financial functions. (In other words, do not input the numbers to calculate the answers.) You may want to complete the problem on paper first, then input and re-calculate in Excel. Note that Excel has a built-in financial calculator so PV, PMT, FV, etc. all work to calculate the amount. (A two-point deduction will be made if Excel functions are not used to calculate the answers.)

Problem:

Your friend is celebrating her 35^th birthday today and wants to start saving for her anticipated retirement at age 65. She wants to be able to withdraw $125,000 from her savings account on each birthday for 20 years following her retirement; the first withdrawal will be on her 66^th birthday. Your friend intends to invest her money in the local credit union, which offers 6 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.

1. If she starts making these deposits on her 36^th birthday and continues to make deposits until she is 65 (the last deposit will be on her 65^th birthday; use 30 years), what amount must she deposit annually to be able to make the desired withdrawals at retirement?

2. 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 35^th birthday to cover her retirement needs. What amount does she have to deposit?

3. Suppose your friends employer will contribute $6,000 to the account every year as part of the companys profit-sharing plan. In addition, your friend expects a $200,000 distribution from a family trust on her 55^th birthday, which she will also put into the retirement account. What amount must she deposit annually now to be able to make the desired withdrawals at retirement?