# Question

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.

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?

e. Calculate the monthly mortgage payment. What is the total per year?

f. Calculate the loan balance at the end of years 1, 2, 3, and 4.

g. Calculate the amount of principal reduction achieved during each of the four years.

h. Calculate the total interest paid during each of the four years.

i. Calculate the levered required initial equity investment.

j. Calculate the before-tax cash flow (BTCF) for each of the four years.

k. Calculate the before-tax equity reversion (BTER) from the sale of the property.

l. Calculate the levered net present value of this investment. Should you purchase? Why?

m. Calculate the levered internal rate of return of this investment (assuming no debt and no taxes). Should you purchase? Why?

n. Calculate, for the first year of operations, the:

(1) Overall (cap) rate of return,

(2) Equity dividend rate,

(3) Gross income multiplier,

(4) Debt coverage ratio.

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.

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?

e. Calculate the monthly mortgage payment. What is the total per year?

f. Calculate the loan balance at the end of years 1, 2, 3, and 4.

g. Calculate the amount of principal reduction achieved during each of the four years.

h. Calculate the total interest paid during each of the four years.

i. Calculate the levered required initial equity investment.

j. Calculate the before-tax cash flow (BTCF) for each of the four years.

k. Calculate the before-tax equity reversion (BTER) from the sale of the property.

l. Calculate the levered net present value of this investment. Should you purchase? Why?

m. Calculate the levered internal rate of return of this investment (assuming no debt and no taxes). Should you purchase? Why?

n. Calculate, for the first year of operations, the:

(1) Overall (cap) rate of return,

(2) Equity dividend rate,

(3) Gross income multiplier,

(4) Debt coverage ratio.

## Answer to relevant Questions

List three important ways in which DCF valuation models differ from direct capitalization models.If consumption increases by $12 billion when real disposable income increases by $15 billion, what is the value of the MPC? What is the relationship between the MPC and the MPS? If the MPC rises, what must happen to the MPS? ...Use the following cash flows for the next 6 questions. (All answers should show up to 2 decimal points.)1. What is the NPV? (Use 10% as a discount rate and calculator) 2. Compute the PI (Profitability index). (Use 10% as a ...What is ERP system? Give a brief history of ERP system. How did ERP system bring Career Opportunities?Multi-base Company Limited is a diversified business group with interests in fabric and yarn manufacturing, paper and pulp, and cement. Its manufacturing units are located across the country and number eight- one for fabric, ...Post your question

0