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 5^th 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.