Question

You are considering the purchase of an apartment complex. The following assumptions are made: The purchase...

You are considering the purchase of an apartment complex. The following assumptions are made:

  • The purchase price is $1,000,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 per year.
  • No vacancies are expected.
  • Operating expenses are estimated at 35 percent of effective gross income. Ignore capital expenditures.
  • The market value of the investment is expected to increase 4 percent per year.
  • 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.
  • The required levered rate of return is 14 percent.
  • 70 percent of the acquisition price can be borrowed with a 30-year, monthly payment mortgage.
  • The annual interest rate on the mortgage will be 8.0 percent.
  • Financing costs will equal 2 percent of the loan amount.
  • There are no prepayment penalties.
  • What is the DCR?

Group of answer choices 1.9, 1.8, 2.0, or 1.6?

Homework Answers

Answer #1

Computation of DCR:

Debt Coverage ratio = Net Operating Income / Annual Mortgage payment\

Net Operating income = Potential Gross Income * (1 - Operating Expenses)

Net Operating income = $171000 * (1 - 0.35)

Net Operating income = $111150

Annual Mortgage Payment = Monthly Mortgage payment * 12

Annual Mortgage Payment = [Loan/PVAF(0.08/12,360)] * 12

Annual Mortgage Payment = [700000 / 136.2835] * 12

Annual Mortgage Payment = $61636.22

Debt Coverage ratio = Net Operating Income / Annual Mortgage payment\

Debt Coverage ratio = $111150 / $61636.22

Debt Coverage ratio = 1.80

Please upvote

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You are considering the purchase of an apartment complex. • Purchase price: $775,000 •BTCF: Year NOI...
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...
Given the following information regarding an income producing property, determine the internal rate of return (IRR)...
Given the following information regarding an income producing property, determine the internal rate of return (IRR) using levered cash flows. Expected Holding Period: 5 years; 1st year Expected PGI: $91,000; 2nd year Expected PGI: $91,000; 3rd year Expected PGI: $91,000; 4th year Expected PGI: $91,000; 5th year Expected PGI: $91,000; Vacancy 3% annually; Other Income $10,000 annually; Operating Expenses 40% of EGI annually. Debt Service in each of the next five years: $30,000; Purchase Price: $875,000; Required equity investment: $225,000;...
Given the following information regarding an income producing property, determine the internal rate of return (IRR)...
Given the following information regarding an income producing property, determine the internal rate of return (IRR) using unlevered cash flows. Expected Holding Period: 5 years; 1st year Expected PGI: $95,000; 2nd year Expected PGI: $95,000; 3rd year Expected PGI: $95,000; 4th year Expected PGI: $95,000; 5th year Expected PGI: $95,000; Vacancy at 5% annually. Operating Expenses 40% of EGI annually. Debt Service in each of the next five years: $20,000; Current Market Value: $897,000; Required equity investment: $200,000; Gross Sales...
You are considering the purchase of an apartment building with the following information:             Purchase price             &nbsp
You are considering the purchase of an apartment building with the following information:             Purchase price                                     $12,500,000             Expected year 1 NOI                          $1,000,000             Expected annual NOI growth             4%             Expected Exit Cap Rate                      8.5%             Holding Period                                    3 years             Solve for each of the following:             Initial (going in) cap rate      __________                                                                                          NOI for Year 4                                                            ____________ Expected sales price end of year 3           ______________                                                      Net Present Value at 9% Discount...
You are considering the purchase of an apartment building with the following information:             Purchase price...
You are considering the purchase of an apartment building with the following information:             Purchase price $12,500,000             Expected year 1 NOI $1,000,000             Expected annual NOI growth 4%             Expected Exit Cap Rate 8.5%             Holding Period 3 years             Solve for each of the following:   Initial (going in) cap rate                                                          NOI for Year 4 Expected sales price end of year 3 Net Present Value at 9% Discount Rate                             IRR    Would you buy this...
ONLY COMPLETE USING EXCEL SHOWING WORK - THANK YOU! You are considering the purchase of a...
ONLY COMPLETE USING EXCEL SHOWING WORK - THANK YOU! You are considering the purchase of a quadruplex apartment building. Effective gross income during the first year of operations is expected to be $33,600 ($700 per month per unit). First-year operating expenses are expected to be $13,440 (at 40 percent of EGI). Ignore capital expenditures. The purchase price of the quadruplex is $200,000. The acquisition will be financed with $60,000 in equity and a $140,000 standard fixed-rate mortgage. The interest rate...
Solve using excel: A. Suppose you are considering the purchase of an apartment building that has...
Solve using excel: A. Suppose you are considering the purchase of an apartment building that has 12 units that can be rented out at $1,050 per month. You have estimated operating expenses and expected vacancy and collection losses for the first year to be $35,700 and $30,240, respectively. You also have estimated that you will be able to generate an additional $3,840 in the first year from garage rentals on the property. If the expected purchase price of the property...
Allen Benedict is thinking of buying an apartment complex that is offered for sale by the...
Allen Benedict is thinking of buying an apartment complex that is offered for sale by the firm of Getz and Fowler. The price, $2.25 million, equals the property's market value. The following statement of income and expense is presented for Benedict's consideration: The St. George Apartments Prior Year's Operating Results, Presented by Gertz and Fowler, Brokers 30units, all 2-bedroom apartments, $975/month $351,000 water & dryer rentals 10,000 gross annual income $361,000 Less operating expenses: Manager's salary $10,000 Maintenance staff (1...
You are considering the purchase of an apartment building that has 25 units that can be...
You are considering the purchase of an apartment building that has 25 units that can be rented out at $1,500 per month. You have estimated operating expenses and expected vacancy and collection losses for the first year to be $55,000 and $50,000, respectively. You also have estimated that you will be able to generate an additional $7,500 in the first year from garage rentals on the property. If the expected purchase price of the property is $3,250,000 and you are...
You are considering the purchase of an apartment building that has 25 units that can be...
You are considering the purchase of an apartment building that has 25 units that can be rented out at $1,500 per month. You have estimated operating expenses and expected vacancy and collection losses for the first year to be $55,000 and $50,000, respectively. You also have estimated that you will be able to generate an additional $7,500 in the first year from garage rentals on the property. If the expected purchase price of the property is $3,250,000 and you are...