Calculate potential gross income, Business Economics

Assignment Help:

(a)  Assume that Purchase Price is equal to initial Market Value

(b) Your Market Rent starts at the indicated level and increases by this factor for all of Year 2 and for each year thereafter

(c) Your Occupancy starts at the indicated level; this amount is added to Occupancy for all of Year 2 and for each year thereafter until it reaches the Stabilized Occupancy level

(d) Capital Expenditures are this amount per unit per year.

Purchase Price                  (a) $5,100,000.00

Units                                80

Market Rent                      $850.00

Annual Adjustment            (b) $50.00

Current Occupancy            65.00%

Annual Adjustment            (c) 5.00%

Stabilized Occupancy         90.00%

Operating Expenses           35.00%

Capital Expenditures          (d) $200.00

Holding Period (years)        10

Going Out Cap Rate           9.50%

Selling Expenses                6.00%

Unlevered Discount Rate    13.00%

LTV                                  80.00%

Loan Rate                         7.00%

Amortization (years)          30

Finance Costs                   5.00%

Levered Discount Rate       16.00%

  • You must show your work carried out to two decimal places to receive any credit (partial or full) for your answers.
  • Interest rate adjustments from annual to monthly should be performed by direct entry of theformula rather than rounded. For example, a 7.00% interest rate should be entered by

            dividing 7.00% by 12 months and directly entering the result as the monthly rate.

  • Debt service calculations are to be performed on a MONTHLY basis and then converted toannual as appropriate.

You are considering the purchase of a property pursuant to the assumptions given to you by your

instructor. You MUST show the steps used in addressing the following:

a. Calculate potential gross income for each year starting with the base year rent and escalations given. Your grid should have three lines: number of units, monthly market rent per unit, and annual PGI for each year.

b. Calculate vacancy using the current occupancy and absorption projections given. Note that the vacancy percentage is 100% minus the occupancy percentage.

c. Calculate the fixed annual capital expenditures (does not change each year).

d. Construct a standard pro forma grid with the appropriate line items  and calculate net operating income (NOI) for each year of the holding period.

e. Calculate the net sale proceeds from the sale of the property showing each step in a grid. Sales price is determined by using the appropriate NOI and the cap rate given.

f. Calculate the unlevered net present value. Should you purchase and why?

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

h. Calculate the loan balance at the end of each year in the holding period.

i. Calculate the amount of principal reduction achieved during each year in the holding period.

j. Calculate the total interest paid during each year in the holding period.

k. Calculate the levered required initial equity investment.

l. Calculate the before-tax cash flow (BTCF) for each year in the holding period.

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

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


Related Discussions:- Calculate potential gross income

Why is not aid improving development, Why is not Aid improving development?...

Why is not Aid improving development? Aid not improves development because: • Aid is spent on current consumption • It is spent on unsuitable capital as opposed to suitab

Define balance of payments in international capital flows, Define the balan...

Define the balance of payments problem in international capital flows. Balance of payments (BoP): It inflows capital as like: • Foreign direct investment (FDI) into machiner

Exel, Can you help me with my assingment exael

Can you help me with my assingment exael

What is absolute poverty and relative poverty, What is absolute poverty and...

What is absolute poverty and relative poverty? Absolute poverty: It is an income level below that essential to meet fundamental requirements. The UN measure of absolute

Curse embodied, a)      What is the curse embodied in the standard producti...

a)      What is the curse embodied in the standard production function? How does technological advance permit  an economy to avoid this curse? b )    In what significant way doe

What is conditionality, What is Conditionality? Conditionality is the ...

What is Conditionality? Conditionality is the needs imposed onto countries as pre-conditions for loans. Into crisis situations member countries seek assist from the IMF for

What is meant by the term exception reporting, What is meant by the term ex...

What is meant by the term exception reporting? What are the advantages and the drawbacks of this type of reporting? Exception reports concentrate onto what has not gone as per

Explanation of the instruments of monetary policy, Problem 1 Discuss ho...

Problem 1 Discuss how Monetary policy regulates the money supply in an economy through various instruments. A) Explanation of the instruments of monetary policy Problem

Scarcity, explain the role scarcity of resources plays in economic decision...

explain the role scarcity of resources plays in economic decision making

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd