Question

Question 5-8 help please....?

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. 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?

6. 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?

7. If Stan decided to deposit his down payment funds in less risky certificates of deposit (CDs) 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.

8. If Stan decided to deposit his down payment funds in a riskier investment of growth stocks 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.

Can someone help me with questions 5-8? Please?....

Answer 1

1. Taking into consideration the fact that the home price will grow at 4%p.a., the future median home selling price in 8 years would be $275,000*(1+4%)^8= $376,356.49
2. Assuming that the down payment is 20%, Stan will have to accumulate $75,271.30 over the next 8 years. This is calculated as $376,356.49*20%
3. In order to calculate month end investment at 8% p.a. over the 8 years to generate $75,271.30, use excel function: =-PMT(8%/12,8*12,,75271.30). The amount would be $562.28
4. If Stan decides to make end-of-the-year deposits into the Morgan Stanley account, he needs to make deposits of $7,076.61 at the end of each year over the next 8 years to accumulate $75,271.30. This is arrived at by using following Excel function: =-PMT(8%,8,,75271.30)
5. If home price appreciation is at 6% p.a. over next 8 years, then the price of the home would be $275,000*(1+6%)^8=$438,308.22. Hence Stan’s down payment would be $87,661.64. In order to generate this much over the next 8 years, his monthly investment needs to be $654.83. This is arrived by using following Excel function: =-PMT(8%/12,8*12,,87661.64)
6. If home price appreciation is at 2% p.a. over next 8 years, then the price of the home would be $275,000*(1+2%)^8=$322,206.33. Hence Stan’s down payment would be $64,441.27. In order to generate this much over the next 8 years, his monthly investment needs to be $481.38. This is arrived by using following Excel function: =-PMT(8%/12,8*12,,64441.27)
7. If Stan decided to deposit his down payment funds in less risky certificates of deposit (CDs) earning only 4% p.a., he would have to deposit $666.60 at the end of each month to make the down payment of $75,271.30. This is arrived by using following Excel function: =-PMT(4%/12,8*12,,75271.30)
8. If Stan pursued a more risky investment of growth stocks that have an expected return of 12%p.a., he would have to deposit $470.66 at the end of each month to make the down payment of $75,271.30. This is arrived by using following Excel function: =-PMT(12%/12,8*12,,75271.30)

Happy Learning!