Real Estate Investment

MUST BE 100% CORRECT AND DUE AT 4AM (CST)

*MUST SHOW ALL WORK

 1.The following assumptions are made:

• The purchase price is$1,100,000.
• Potential gross income (PGI) for the first year of operations is projected to be$171,000.
• PGI is expected to increase at 4 percent peryear.
• No vacancies areexpected.
• Operating expenses are estimated at 35 % of effective gross income. Ignore capital expenditures.
• The market value of the investment is expected to increase 4 percent peryear.
• Selling expenses will be 4 percent.
• The holding period is 4 years.
•The appropriate unlevered rate of return to discount projected NOIs and the projected NSP is 12 percent
• There are no prepaymentpenalties.

a.  Calculate net operating income (NOI) for each of the four years.
b.         Calculate the net sale proceeds from the sale of the property.
c.         Calculate the net present value of this investment, assuming no mortgage debt.  Should you purchase?  Why?
d.         Calculate the internal rate of return of this investment, assuming no debt.  Should you purchase?  Why?

2.  For a $700,000 loan for 25 years at 8%, with monthly payments
a.  Calculate the loan balance at the end of 15 years?
b.  Calculate the amount of total principal reduction achieved over the 25?
c.  Calculate the total interest paid over the 15 years?
d.  When is the loan 60% paid off?

3.  Calculate the mortgage payment for a $240,000 level payment mortgage loan amortized for 25 years at 8% interest, if the payments are made annually
a. How much of the first year’s payment would be principal and how much would be interest?
b. If the mortgage is for 25 years with MONTHLY amortizing, what are the MONTHLY payments?
c. If the payments are monthly, what is the total annual debt service?
d. How much of the first month’s payment is principal prepayment and how much is interest?

4.  For a $240,000 loan with monthly payments, at 8% interest for 25 years, the borrower had to pay 2 points in origination fees at the time the loan was made. If that loan is paid off in 5 years what is the effective yield of the loan, including the origination fees?
5.   (using info from question 4) Now presume that in addition to the points at the origination above, the borrower also has to pay 1 point in prepayment penalty at the time the loan is paid off. What is the EFFECTIVE yield including the origination fees and the prepayment penalty?