Question

In: Finance

Part 1 You are considering the purchase of a 120-unit apartment complex. The 50 one-bedroom units...

Part 1

You are considering the purchase of a 120-unit apartment complex. The 50 one-bedroom units rent for $650 per month and the remaining 70 two-bedroom units rent for $800 per month. Vacancy and credit losses are 10% in this market. There is miscellaneous income of $20,000 per year. Operating expenses for this property are 35% of gross operating income. Market cap rates for this type of investment are 7.75%. You can get a loan equal to 75% of the purchase price at 7.00% interest with a 30-year amortization term. The minimum debt coverage ratio is 1.25.

  1. What is the NOI?
  2. What is the Purchase Price (do not round)?
  3. How much is the loan amount?
  4. How much is the annual debt service?
  5. What is the cash on cash?
  6. Calculate the debt coverage ratio?

Now assume a different scenario: this is a value-add opportunity and you plan to hold the property for 3 years. You are considering using an interest only loan at 6.825% fixed for 5 years with an 75% loan to value. You can become more efficient with the operations and bring those down immediately in the first year by 2.5% by getting your management team in there. In addition, you expect that you can reduce the vacancy and credit loss to 7.5% in the second year and 5% in the third year. You also assume that rents increase at a modest 2.0% annually, beginning immediately, and that the miscellaneous income remains flat. When you sell the property at the end of Year 3, you expect cap rates to be a little higher at 8.0%. Commissions and closing costs are 4.5% and 0.5%, respectively.

1. How much equity is required?

2. What is the DCR in each year?

3. What is the Cash On Cash in each year?

4. What is the total investment IRR?

5. What is the total profit from the investment?

Solutions

Expert Solution

NOI is $641,720

Purchase Price is $8,274,451.6129

Loan Amount is $6,205,838.71

Annual Debt Service is $500,162.22

Cash on Cash return is 6.82%

Debt Coverage Ratio is 1.2823

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

You are considering buying an apartment complex with 50 units. The units rent for $1000 per...
You are considering buying an apartment complex with 50 units. The units rent for $1000 per month each. Usually, there is a 10% vacancy. You want a 7.5% percent total annual after-tax return on the funds you invest. You do not expect any appreciation of the property value. You also expect the property to not have any economic or real depreciation in value, since the maintenance expenses will keep the property in equal condition year after year. When fully occupied,...
You are considering the purchase of an apartment complex. The following assumptions are made: • The...
You are considering the purchase of an apartment complex. The following assumptions are made: • The purchase price is $1,150,000. • Potential gross income (PGI) for the first year of operations is projected to be $195,000. • PGI is expected to increase at 4 percent per year. • 3% vacancies are expected. • Operating expenses are estimated at 30 percent of effective gross income. Capital expenditures are estimated at 10 percent of effective gross income. • The market value of...
You are considering the purchase of an apartment complex. The following assumptions are made: •           The...
You are considering the purchase of an apartment complex. The following assumptions are made: •           The purchase price is $1,250,000. •           Potential gross income (PGI) for the first year of operations is projected to be $191,000. •           PGI is expected to increase at 4.5 percent per year. •           5% vacancies are expected. •           Operating expenses are estimated at 35 percent of effective gross income. Capital expenditures are estimated at 15 percent of effective gross income. •           The market value of...
You are considering the purchase of an apartment complex. Purchase price: $775,000 BTCF: Year NOI 1...
You are considering the purchase of an apartment complex. Purchase price: $775,000 BTCF: Year NOI 1 $103,085 2 $108,361 3 $113,875 4 $119,636 5 $125,651 Holding period is four years Cap rate is expected to be 7% in year 4 Selling expenses will be 5% of the sale price The 4-year Treasury bill rate is 3% and your risk premium for this project is 8% a) Calculate the NPV of this project assuming that you do not take any mortgages...
In an apartment complex, two bedroom apartments rent for more than one bedroom apartments. I conducted...
In an apartment complex, two bedroom apartments rent for more than one bedroom apartments. I conducted a study of 9 apartment complexes, and found the following rental rates at the respective complexes: (show work) 1-bedroom 780 485 450 530 620 520 845 1000 700 2-bedroom 1220 900 740 955 1055 875 1455 1720 1200 The correlation coefficient for this problem is _______________ There is/ is not   evidence of significant correlation at the 5% significance level The regression equation is  ____________________ The best...
You are considering a creative financing arrangement for the purchase of a small apartment complex. The...
You are considering a creative financing arrangement for the purchase of a small apartment complex. The property is selling for $2,600,000. Both lenders have agreed to allow the arrangement to proceed, if you decide to pursue it. The first mortgage will be for 65% LTV over 25 years with monthly payments at 9%. The first mortgage charges a 0.5% origination fee and no points. The second mortgage will be for 20% LTV over 10 years with monthly payments at 15%....
As manager of Precision Properties, you are considering the purchase of an apartment complex. The following...
As manager of Precision Properties, you are considering the purchase of an apartment complex. The following assumptions are made: • The purchase price is $2,000,000. • Potential gross income (PGI) for the first year of operations is projected to be $320,000. • PGI is expected to increase at 4 percent per year. • No vacancies are expected. • Operating expenses are estimated at 38 percent of effective gross income. Ignore capital expenditures. • The market value of the investment is...
You are considering the purchase of a 35,000-square-foot apartment complex located in the Inland Empire. The...
You are considering the purchase of a 35,000-square-foot apartment complex located in the Inland Empire. The building is about 50 years old. It has obviously depreciated, but it has been well-maintained with the owner spending approximately 7% of NOI each year in capital improvements. The building has 48 apartments. The owner has presented you with the following rental information: 10 studio apartments @ $1,200 each 30 1-bedroom apartments @ $1,450 each 8 2-bedroom apartments @ $1,650 each Your research shows...
1. Apartment rental rates: You want to rent an unfurnished one-bedroom apartment for next semester. The...
1. Apartment rental rates: You want to rent an unfurnished one-bedroom apartment for next semester. The mean monthly rent for a random sample of 10 apartments advertised in the local newspaper is $960. Assume that the population standard deviation is $80. a. Find a 95% confidence interval for the mean monthly rent for unfurnished one-bedroom apartments available for rent in this community. Interpret your result. b. Find and compare the margin of error for intervals with 90, 95, and 99%...
Lynbrook West, an apartment complex, has 100 two-bedroom units. The monthly profit (in dollars) realized from...
Lynbrook West, an apartment complex, has 100 two-bedroom units. The monthly profit (in dollars) realized from renting out x apartments is given by the following function. 1.) To maximize the monthly rental profit, how many units should be rented out? ______ units 2.) What is the maximum monthly profit realizable?   $ _______ P(x) = x^3 + 3x^2 +3 on [-3,2]
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT