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. Average unit cost
2. Gross Rent Multiplier (GRM) year one only leave one decimal place in answer (2 pts.)
3. Break-even Ratio (BER) year one only leave one decimal place in answer
4. Operating Ratio (OR) year one only leave one decimal place in answer
5. Owners equity at purchase
6. Annual payment
7. Debt Service Coverage Ratio (DSCR) year one only --- leave one decimal place in answer
8. Complete a 5-year Pro Forma analysis using the excel worksheet in the assignment and the following information

• 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:
  • 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 --- thats 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. DONT 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.

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

2. Calculate the following for each of the five years

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

NOTE: ROI is actually about return on investment and refers to just the return on the 'original' investment adjusted for capital improvements planned at purchase, if there were any (which there aren't on the final project). If I asked you to calculate the ROE (Return on Equity), then you would adjust the equity in the denominator by the amount of other equity items found on a balance sheet but as it stands, only ROI calculations are required for the final project so you DON'T adjust for equity changes that occur in subsequent years.

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

• Sale price
• Annualized IRR must leave one decimal place for percentages

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

• Sale price
• Annualized IRR must leave one decimal place for percentages