You are considering a purchase of a 4-plex, which is located in a desirable neighborhood. The cost of the property is $500,000. Effective rents are expected to average $1500 per month. Every resident receives one free parking space but has to pay an additional $50 per month for a one car garage located adjacent to the 4-plex (Note: There are only four garages on the property). Annual vacancy expenses for the units are expected to average 5% (assume the garage rentals will coincide with the unit rentals so will also incur a 5% vacancy loss per year). The average unit is 1500 sq. ft.

Financing information:

• Amount financed: $350,000 (70% of purchase price)
• Amortization period: 30 years, compounded monthly
• Interest rate: 7.5%

Calculate the following:

1. 1.Average unit cost (1 pts.)
2. 2.Gross Rent Multiplier (GRM) year one only … leave one decimal place in answer (2 pts.)
3. 3.Break-even Ratio (BER) year one only … leave one decimal place in answer (2 pts.)
4. 4.Operating Ratio (OR) year one only … leave one decimal place in answer (2 pts.)
5. 5.Owner’s equity at purchase (1 pts.)
6. 6.Annual payment (1 pts.)
7. 7.Debt Service Coverage Ratio (DSCR) year one only --- leave one decimal place in answer (2 pts.)
8. 8.Complete a 5-year Pro Forma analysis using the excel worksheet in the assignment and the following information (4.5 pts.):

• Rental increase projections: 4% per year for years 2 and 3 and 4.5 % for years 4 and 5. No increase in garage fees.
• Operating expense increase projections: 2.5% per year for years 2 and 3 and 2% for years 4 and 5.
• Assume a 35% tax rate for the investor.
• Depreciation is calculated on the ‘building’ only using the straight-line method (27.5 years for residential properties and 39 years for commercial properties). For the purpose of this project, the breakdown of the building and land is as follows:
• Tptal operating expense 36,360
  • Land = $100,000
  • Building = $400,000 --- to calculate the depreciation, take this figure and divide by 27.5 to arrive at the annual deduction (note: there is actually a convention known as ‘mid-year’ that should be used but the number will be very close to this one and it can get a little confusing --- that’s what accountants are for:-).
• You will need to know the total annual payment for the loan and also be able to break the payment into its principal and interest components each year
  • The interest amount only is entered on the ‘Interest on Loan’ line item and the principal amount only on the ‘Plus Principal Reduction’ line item; In order to find each amount you will need to do an amortization to calculate the interest and principal for each of the 5 years as the amount of interest will go down slightly and the amount of principal payment up slightly each year throughout the term of the loan. DON’T put the same amounts on each of the five years as this will be incorrect.
  • The ‘Debt Service’ line item is the total annual payment including both interest and principal so basically, the total of the line items noted in #1 above.

9. 9. Using a cap rate of 8.0%, calculate the value at the end of years 1, 2, 3, 4, & 5 (5 pts.).

10. 10. Calculate the following for each of the five years (7.5 pts.):

• Net Income Return on Investment (NI - ROI)
• Cash ROI
• Total ROI

11. 11. Assuming the property were sold at the end of year 3 using a 9% cap rate, calculate the following:

• Sale price (1 pts.)
• Annualized IRR … must leave one decimal place for percentages (4 pts.)

12. 12. Assuming the property were sold at the end of year 3 using an 7% cap rate, calculate the following:

• Sale price (1 pts.)
• Annualized IRR … must leave one decimal place for percentages (4 pts.)