You have been asked by your parents to advise your younger sister, who is an entering freshman

Fantastic news! We've Found the answer you've been seeking!

Question:

You have been asked by your parents to advise your younger sister, who is an entering freshman at a centrally-isolated university located in New York State, about buying instead of renting for the next four years. She is thinking of buying a three-bedroom house, renting two of the rooms to friends, and selling the house when she graduates During your sister's first week of college, she found a three-bedroom house selling for $240,000 as well as two friends at freshman orientation who are willing to pay $850 a month each for the two rooms. (Since she'll be living in the third bedroom, you may assume she is implicitly paying the same rent for the third bedroom.)

In her second week, she found a local bank that, despite her lack of credit history, is willing to extend a 15 year 70% LTV fixed-rate mortgage at 5% for the purchase. In her third week, utilizing all the tools she acquired in her 26 AP classes, she developed a house price forecast model that predicts house prices will grow by 4% per year for the next four years.

As the older sibling taking real estate classes, your parents, who will be making the down payment, have asked you to evaluate this transaction.

a. What is the mortgage size and your parent's down payment? What is the mortgage payment? (Ignore taxes and insurance in your calculation) Write out the expression you would need to use to solve for the monthly loan payment. What is the mortgage's debt yield? (15 points)

b. Ignoring expenses and maintenance (a common practice in student rental units) create a table which outlines your sister's annual NOI and debt service.

Calculate her DCR. What is the reversion value for the house at the end of year 4? What is the mortgage balance at the time of reversion?

c. What is your parent's equity IRR for this venture? Write out the after-tax cash flow for each of the four years. How would your answer change if her lender can only offer a 50% LTV mortgage?

d. Suppose your parents are willing to buy the house instead of financing it. What is their unleveraged yield?