Project 1: Stan Morgan Basic Concepts: The Time Value of Money 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 $375,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 $375,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: I need answer to question 5. please

1. Taking into consideration that the $375,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. PLease only answer question 5.