Team project
Decide the location and the specific real estate property you would like to buy (e.g., a
single-family house or a condo). provide justification why the property is chosen,
e.g., affordability, the potential of price appreciation. Use some data to justify your
selection, e.g., the housing price growth rate in the region. You could use the resource like zillow.com, etc.
2) Find out the mortgage rates for different properties and choose between 30 or 15-year
fixed-rate mortgage (FRM). You could use bankrate.com, etc. You must justify your
decision.
3) Calculate the monthly mortgage payment given the down payment (20% of the price) you
will make. This will be a fixed 80% payment mortgage loan with 20% down payment. It
means you will pay 20% down payment at the purchase and finance 80% with the
mortgage. show your calculations of monthly mortgage payments in the report.
4) In the meantime, predict the amount of monthly rental you will be able to collect when
you lease the property out (zillow.com also provides rental price information). The rental
period is the same as your mortgage period. In other words, you will pay off your mortgage
and end the rental in the same year. Justify your rental income projection.
5) Project the resale value of the property at the end of the mortgage payment period. You
need to use some statistics to back up your numbers.
6) Once you have
a. the projected monthly mortgage payment
b. the monthly rental income
c. the resale value of the property at the end of the mortgage payment period
You could calculate the net present value (NPV) of the cash flow in a, b, and c,
respectively. The present value could be calculated in Excel or using a financial
calculator. The discount rate is the mortgage rate. The return on your investment
property is calculated as return = (Sum of NPV in a, b, and c/ the down payment) – 1.
Show your calculation in the report.
7) Next, assume you don’t purchase an investment property. Instead, you invest the same
amount of money as your total investment in the house in stocks (for example, investing
in the S&P500 index or other indexes). You could use the average of 15 or 30 years of
historical data of the S&P500 index to calculate the index return, a.k.a. use the yearly
S&P 500 before the current year to calculate the yearly returns and average them. The
period of the expected index return is the same as your mortgage period, but the index
data is backward. For example, if the mortgage period is 30 years, use the last 30 years of
the index data to calculate the average stock return. Ignore all the expected dividends in
the calculation. S&P500 index could be found in Yahoo Finance, wsj.com, or other
financial resources.
8) Then assume you buy long-term treasury bonds with the same amount of money as your
investment in the house. The period of the expected bond return is the same as your
mortgage period. (e.g., if the mortgage is a 30-year mortgage, buy a 30-year Treasury
bond). Find the YTM of the Treasury bond. YTM is yield to maturity which is the annual
return to the bonds. You could use the resource like wsj.com, etc. If there is no yield of
the 15-year bond, use the yield of the 30-year bond and 10-year bond to extrapolate it.
9) Compare the return of the investment on your investment property, stock index, and
Treasury bond. Explain the under-or out-performance of your real estate investment
compared to the other two investments. Justify your conclusion
