Problem 5-36 Suppose that you were to receive a $30,000 gift upon graduation from your master's degree program, when you turn 31 years old. At the end of each working year for 34 years, you put an additional $5,000 into an IRA a. Assuming you earn an annual compounded rate of 7.5 percent on the Rift and the IRA investments, how much would be available when you retire at age 65? b. If you hope to draw money out of that investment at the end of every month for 30 years following retirement, how much could you withdraw each month? Assume that during the years you are retired, the money earns an annual rate of 6 percent compounded monthly You realize that if you draw out that amount each month there will be nothing left for your two children. You decide that you want to leave $250,000 to each of your children 30 years after you retire. How much would you have to invest at your retirement to fund your children's Inheritance? Assume that you will earn 7.5 percent compounded annually on the money invested for your children d. If you set aside the money for your children, how much could you draw out each month during your retirement if you can earn 6 percent per annum compounded monthly on the portion that is not set aside for the children? MacBook Air Clear B a bel = = Paste L fx E36 C lo 1 EXERCISE 5-36 Template / INMONDO / / / LLLLLL (Retirement Analysis) INPUT DATA Part A. 9 Value of Gift - PV 10 IRA Investment Annuity - PMT 11 Years Working - nper 1 12 Annual Return While Working - rate 1 13 Part B. 14 Years Retired 15 Months Retired - nper 2 16 Annual Return While Retired 17 Monthly Return While Retired - rate 2 Part C. 19 Number of Children 20. Amount per child 21 Total Inheritance - FV TTTTTT III CANNN SOLUTIONS Part A - Amount Available for Retirement =FV[rate,nper.pmt,pv, type) 26 Retirement Funds - FV = Part B - Monthly Retirement Income =PMTrate,nper, PV.lv lype) 29 Monthly Retirement Income - PMT 30 Part C - Amount for Children's Inheritance 31 EPV(rate,nper,pmt,fv, type) 32 Amount Set Aside at Retirement - PV 33 Part D - Retirement Income After Inheritance 34 Original Retirement Funds 35 Less: Amount for Children 36 Net Retirement Funds - PV =PMT(rate, npor.PV.Iv.type) 38 Revised Monthly Income - PMT 39 Monthly drop in Retirement Income 40 BAR
