Robert Johnson is 25 years old. He and his wife Jane have two children, Emmitt and Patricia, ages 2 and 4 respectively. Robert wants to retire in 40 years and build boats. He would like a nice retirement home with some land on a peaceful lake in the mountains of Georgia. Robert believes that to purchase a home and lot in 40 years would cost $300,000 in todays prices. In forty years Robert also believes he and Patricia can live comfortably on $50,000 a year in today's dollar terms. Realizing that retirement is only 40 years away, and that he still had two children to raise and put through college, Robert thought he had better start saving for his retirement dreams. Also, Patricia is only 14 years away from college, and before Patricia finishes, Emmitt will be ready for school in 16 years. Currently Robert has $25,000 in an emergency money market account earning 2.0% interest compounded daily. His desire is to never have to use those emergency funds and that they will become a part of his estate. He also owns his own home that has a market value of $225,000 and a mortgage of $150,000. The 5.0% mortgage has 27 years remaining and his monthly payments are $1126 for principal and interest alone. Roberts annual salary is $60,000. His employer puts an additional $3,000 into a 401(k) retirement plan. This retirement amount currently equals $9,000 and it is invested in a stock mutual fund, which has been earning an annual rate of return of 8.0%. With the current level of the federal debt, Robert is not counting on receiving any funds from social security at his retirement. With all of the concern about college tuition increasing over the years, Robert believes that the children will have to go to the local junior college for their first two years and then a state school for their last two years. The cost to attend the local junior college is $5,000 per year today, and the cost to attend a state school is $15,000 per year today. Inflation will have a great impact on Roberts future retirement and college plans for his children. Based on what he has read and heard on the news, Robert believes that inflation will average 3.0% per year for the next 40 years; however, the cost of a college education will increase by 5.0% per year for the junior college and state schools. Also, with the desirability of vacation homes, the house and property in Georgia will probably increase at a rate of 5.0% per year, while his current home will increase in value at a rate of 3.0% per year. Robert hopes that his annual salary will increase by at least 4.0% per year. Note: For each of the computations completed below, answers can be stated to the nearest dollar. 1. If the emergency money market funds are not used, what will be the value of the funds at retirement? 2. Assuming that Roberts employer continues to put $3,000 every year into a 401(k) retirement and the account remains in the stock mutual fund, how much will be in the retirement account in 40 years? 3. Assuming that Robert has no money set aside for his childrens college at this time, approximately how much will he have to save per month for Emmitts education, for Patricias education, if he earns 7.0% on the invested funds and the balance of education funds stays invested through the end of college. (Note that this question is a two-step process for each of Emmitt and Patricias education.) 4. Assuming that at the date Robert retires, he wants enough income for 25 years of retirement and the rate of inflation will remain at 3.0% per year, how much will Robert and Jane need to live on for the 25 years? (Hint: Use $160,000 for your payment variable.) 5. How much will Robert need to save per month to pay for Jane and his retirement income for 25 years assuming that Robert can earn 8.0% per year, compounding monthly, on the invested funds. Assume Robert and Jane stop saving in 40 years when they reach 65, and funds are then held in a savings account earning zero. Further, assume that the 401k is NOT used for income, as it will be needed for a vacation home transition. (Hint: Use $6,000,000 as your total future value variable.)