Compound Interest: Mortgages and Investments (Part II) Now it's time to start investing for retirement. Certain financial experts suggest that you should spend a total of approximately one third of your net income (take-home pay) on both housing and investments. You would like to have enough money to retire in 30 years, and decide to make a plan for retirement investing. You will pay your mortgage payment from the suggested third of your income, and then invest the remainder each month in an annuity. You decide to compare the two mortgage options described in Part I again by applying your investment plan to each. You will calculate the predicted value of your investments in each case at 5-year intervals, then graph your results, and finally report on your findings. 5. Suppose your household annual net income is $54,000. According to the above information, how much should you spend each month on housing and investments? 6. The handout Dow Jones Historical Data gives information on index prices and annual percentage change of the Dow Jones Industrial Average from 1992 to 2012. Use this data to determine the average annual percentage change of the Dow Jones Industrial Average over this time period. (To do this, simply find the average of the given percentage changes.) This number will be your estimate for the annual rate of return you may expect from your retirement investments. For questions 7 and 8, refer to the Calculating Investment Income slideshow, which details the computations involved with investments of the type we consider in this assignment. 7. Suppose you choose the 30-year mortgage described in question 1 of Part I. (a) Use your answers from 1(b) and question 5 above to determine how much you would have availabe to invest each month, while paying off your mortgage. (b) Assuming you start investing and paying off your mortgage loan today, what would be the value of your investments in (1)5 years? (2)10 years? (3)15 years? Continuing this process gives the following results: (4)After 20 years, the investments' value is $362,931.96. (5)After 25 years, the investments' value is $595,774.22. (6)After 30 years, the investments' value is $950,160.54.8. Now, suppose you choose the 15-year mortgage described in question 2 of Part I. (Note that, per your investment plan, once you finish paying off your mortgage, you will begin investing the entire one third of your income for the remainder of the 30 year period. Since this requires slightly more complicated calculations, the answers for years 20, 25, and 30 are given below.) (a) Use your answers from 2(b) and question 5 above to determine how much you would have availabe to invest each month, while paying off your mortgage. (b) Assuming you start investing and paying off your mortgage loan today, what would be the value of your investments in (1) 5 years? (2) 10 years? (3) 15 years? At the end of 15 years, you have paid off your mortgage, and then invest the full one-third of your income each month for the remaining 15 years. Here are the results obtained: (4) After 20 years, the investments' value is $180,166.59. (5) After 25 years, the investments' value is $385,673.30. (6) After 30 years, the investments' value is $698,454.86. 9. OMIT 10. Will you end up with a bigger nest egg if you have a lower mortgage payment and invest more now, or if you finish paying off your mortgage sooner, freeing up that money for investing? Under this investment plan, would you choose the 30-year mortgage or the 15-year loan? Why? Defend your results in a well-written, 3-5 sentence paragraph, citing relevant numerical results from previous questions in the assignment.Dow Jones Industrial Average Historical Data for 1992-2012 Year Closing Price on First Business Day of December Percentage Change from Previous Year 199 2 3301.11 199 3 3754.09 13.72% 199 4 3834.44 2.14% 199 5 5117.12 33.45% 199 6 6448.27 26.01% 199 7 7908.30 22.64% 199 8 9181.43 16.10% 199 9 11497.12 25.22% 200 0 10787.99 -6.17% 200 1 10021.50 -7.11% 200 2 8341.63 -16.76% 200 3 10453.92 25.32% 200 4 10783.01 3.15% 200 5 10717.5 -0.61% 200 6 12463.15 16.29% 200 7 13264.82 6.43%