After graduating from the University of Texas with a degree in Finance, Stan Morgan took a position as a stockbroker with Morgan Stanley in Austin. Although he had several college loans to make payments on, his goal was to set aside funds for the next eight years in order to make a down payment on a house. After considering the various suburbs of Austin, Stan chose Round Rock as his desired future residency. Based on median house price data, he learned that a three-bedroom, two-bath house currently costs $275,000. To avoid paying Private Mortgage Insurance (PMI), Stan wanted to make a down payment of 20%. Because it will be eight years before Stan buys a house, the $275,000 price will surely not be the same in the future. To estimate the rate at which the median house price will increase, he considered the historical price appreciation in Round Rock. In the past, homes appreciated by 4% per year. Stan was satisfied with this estimation. Morgan Stanley offers several opportunities for Stan to invest the funds that will be devoted to the purchase of his future home. He feels that a balanced account of stocks, bonds, and government securities would realistically achieve an annual rate of return of 8%. Questions: 1. Taking into consideration that the $275,000 home price will grow at 4% per year, what will be the future median home selling price in Round Rock in eight years? 2. Based on your answer from number 1, what amount will Stan Morgan have to accumulate as a down payment if he does decide to buy a house in Round Rock? 3. Based on your answer from number 2, how much will have to be deposited into the Morgan Stanley account (which earns 8% per year) at the end of each month to accumulate the required down payment? 4. If Stan decides to make end-of-the-year deposits into the Morgan Stanley account, how much would these deposits be? 5. Take your answer from number 3 and multiply it by 12 to determine Stans total deposits per year when making 12 monthly deposits. Compare that to your end-of-year deposit answer from number 4. Explain why Stans total deposits per year (when making 12 monthly deposits) is less than when making one annual deposit per year. 6. If homes in Round Rock appreciate by 6% per year over the next eight years instead of the assumed 4%, how much would Stan have to deposit at the end of each month to make the down payment? 7. If homes in Round Rock appreciate by only 2% per year over the next eight years instead of the assumed 4%, how much would Stan have to deposit at the end of each month to make the down payment? 8. If Stan decided to deposit his down payment funds in less risky low-growth investments earning only 4%, how much would he have to deposit at the end of each month to make the down payment? Use the down payment needed from number 2 for this calculation. 9. If Stan decides to make end-of-the-year deposits into the Morgan Stanley account, how much would these deposits be? 10. If Stan decided to deposit his down payment funds in riskier high-growth investments that have an expected return of 12%, how much would he have to deposit at the end of each month the make the down payment? Use the down payment needed from number 2 for this calculation. 11. If Stan decides to make end-of-the-year deposits into the Morgan Stanley account, how much would these deposits be? 12. Based on your calculations, should Stan make end of month or end of year deposits? Why? Do you recommend he deposit his funds in the balanced account with 8% expected return, the low growth investments with 4% expected return, or the high growth investments with 12% expected return? Why?

I am looking for help with questions 9-12.... thank you! In both excel and financial calculator values.