Reference no: EM13197531
Pro forma statement without finance
Your company is considering making an investment in an apartment building. You will not use any debt (i.e. a mortgage) to buy the building (i.e. it will be all equity).
The building has 40 two-bed room apartments and 15 three-bed room apartments. You assume that the monthly rent for two-bed room units is $1,875 and the rent for three-bed room apartments is $2,250.
The building has 110 parking spaces. The charge for each of them is $125 per month. The projected information about the investment is as follows. Please construct the pro forma statement (round to dollars):
Annual inflation of rents and parking charge 3%
Vacancy and collection loss as of PGI 7%
Parking Vacancy Allowance 6%
Purchase Price / Current Assessed Value $6,050,000
Land value as % of the total value 24%
Annual growth of assessed value in each of Years 2-5 3%
Property tax mill rate 23
Other Operating Expenses (% of EGI) 42%
Planned holding period 4 years
Terminal cap rate (applied to 5th year's NOI) 7.25%
Selling cost as a % of Gross Sales Price 4.0%
# of Years for calculating Depreciation 27.5
Capital gains tax rate 15%
Depreciation Recapture tax rate 25%
Income tax rate 35%
Your after tax discount rate (After tax required rate of return) 8.75%
Pro Forma Statement
Yearly Cash Flows from Operations
|
|
Year 1
|
Year 2
|
Year 3
|
Year 4
|
Year 5
|
|
Potential Gross Income
|
|
|
|
|
|
|
(Less Vacancy & Coll.)
|
|
|
|
|
|
|
Potential Other Income
|
|
|
|
|
|
|
(Less Other Income Vacancy)
|
|
|
|
|
|
|
Effective Gross Income
|
|
|
|
|
|
|
Memo: Assessed Property Value
|
|
|
|
|
|
|
(Less Property Taxes)
|
|
|
|
|
|
|
(Less Other Operating Expenses)
|
|
|
|
|
|
|
Net Operating Income
|
|
|
|
|
|
|
(Less Depreciation)
|
|
|
|
|
|
|
Taxable Income
|
|
|
|
|
|
|
Income Taxes
|
|
|
|
|
|
|
Before Tax Cash Flows
|
|
|
|
|
|
|
(Less Income Taxes)
|
|
|
|
|
|
|
After Tax Cash Flows
|
|
|
|
|
|
Reversion Cash Flow
|
Gross Sales Price
|
|
|
(Less Selling Cost)
|
|
|
Net Sales Price
|
|
|
Net Sales Price
|
|
|
(Less Original Purchase Price)
|
|
|
Capital Gain from Appreciation
|
|
|
Capital Gain Tax on Appreciation
|
|
|
|
|
|
Total Accumulated Depreciation (Recapture)
|
|
|
Recapture Tax
|
|
|
|
|
|
Total Capital Gain Tax
|
|
|
|
|
|
ATCF from Reversion
|
|
Total Cash Flows
|
|
Time 0
|
Year 1
|
Year 2
|
Year 3
|
Year 4
|
|
Total After Tax Cash Flows
|
|
|
|
|
|
Net Present Value (NPV) __________
Internal Rate of Return (IRR) __________
(1) Should you invest in this property under the terms and assumptions outlined? (Hint: you need to look at your answers for NPV and IRR.) Why or why not?
(2) If the after tax required rate of return was 11.0%, would your answer to Question #1 change? Why or why not?
(3) If Congress changed the depreciation period for apartment buildings from 27.5 years to 15 years, would the annual After Tax Cash Flows from operations increase or decrease?
(4) Would the after tax cash flow from reversion increase or decrease if the depreciation period was decreased to 15 years?
(5) List at least 2 questionable assumptions from the proforma and explain how they might be improved.
|
To estimate the coefficients mean
: You have been hired by a local used car dealer to help in their pricing of used cars. then what the estimated coefficients mean for each of these regressions.
|
|
Examples of inefficiencies arising from wasted resources
: Suppose the U.S government decides that the incomes of dairy farmers should be maintained at a level then how much surplus milk will be produced as a result of this policy.
|
|
The most obvious benefit of specialization is
: The most obvious benefit of specialization and trade is that they allow us to work more hours per week than we otherwise would be able to work or else.
|
|
An economy''s production possibilities are
: An economy's production possibilities frontier is also its consumption possibilities frontier. under all circumstances,under no circumstances or else.
|
|
Pro forma statement without finance
: Would the after tax cash flow from reversion increase or decrease if the depreciation period was decreased to 15 years and questionable assumptions from the proforma and explain how they might be improved.
|
|
Explain how the concept can apply to chosen profession
: On slides or pages 3 and 4, describe how the concept can apply to you chosen profession. You will not need to "do the math"; simply describe how you would use it and provide examples of situations in which you would use the concept you have chosen..
|
|
What is the approximate area
: a rectangle is 357 miles long and 274 miles wide. round each dimension to the nearest ten. using the rounded numbers, what is the approximate area.
|
|
What is additional gain or loss due to leasing the asset
: The market interest rate is 5.0% and the short rebate rate is 3.0%. What is your additional gain or loss due to leasing the asset?A. $96.00 gain
|
|
State decision making or representation of information
: Inclusion based research which has occurred within the last 6 years paper has to include presentation of both sides of the argument, research supporting both sides, your past experiences positive and negative
|