Answer the question at the bottom using the information provided. Thanks. (A,B a
ID: 2745769 • Letter: A
Question
Answer the question at the bottom using the information provided. Thanks. (A,B and C are cumpulsory)
Assume that you are an investment analyst preparing an analysis of an investment opportunity for a client. Your client is considering the acquisition of an apartment complex from a developer at the point in time when the apartments are ready for first occupancy. You have developed the following information.
Number of units = 36
First year market rent per unit = $450 per month
Rent is projected to increase by 8% each year
Annual vacancy rate = 3% of PGI
Annual collection loss = 2% of PGI
Annual operating expense = 35% of EGI
Miscellaneous yearly income (parking and washers/dryers) = $800
Monthly miscellaneous income is expected to remain constant
Purchase price = $2,000,000
Estimated value of land = $500,000
Anticipated mortgage terms:
Loan to value ratio = .80
Interest rate = 6%
Years to maturity = 25
Points charged = 3
Prepayment penalty = 2% of outstanding balance f) Level payment, fully amortized
Fixed interest rate, annual payments
Anticipated holding period = 4 years
Proportion by which property is expected to appreciate during the holding period -- 5% a year
Estimated selling expenses as proportion of future sales price = 5%
Marginal income tax rate for the client = 28%
It is assumed that the property is put into service on January 1st and sold on December 31st
Assume the client is "active" in the property management
It is assumed that the client has an adjusted gross income of $95,000 and has no other passive income not offset by other passive losses (for each year of the anticipated holding period)
Client's minimum required after tax rate of return on equity = 11%
Questions
A. The before-tax and after-tax cash flows for each year of the holding period and the before-tax and after-tax equity reversion.
B. The after-tax net present value and the after-tax internal rate of return.
C. Is this an investment that should be considered? Explain.
D. For the first year of operation the calculate, Equity dividend rate, gross income multiplier, Debt-coverage ratio, overall (cap) rate of return.
Explanation / Answer
Loan Balance (LB Year1 Year 2 Year 3 Year4 a) Item Amount Potential gross income (PGI) (36 units x $450 per month x 12) $194,400 $204,120 $214,326 $225,042.3 Less: Annual vacancy rate = 3% x PGI -$5,832 -$6,123.6 -$6,429.78 -$6,751.27 Annual collection loss = 2% x PGI -$3,888 -$4,082.4 -$4,286.52 -$4,500.85 Effective gross income (EGI) $184,680 $193,914 $203,609.7 $213,790.19 Annual operating expense = 35% x EGI -$64,638 -$67,869.9 -$71,263.4 -$74,826.56 Add: Miscellaneous yearly income (parking and washers/dryers) $800 $800 $800 $800 Net operating income (NOI) $120,842 $126,844.1 $133,146.31 $139,763.62 - Debt service (DS) -$31,290.69 -$31,290.69 -$31,290.69 -$31,290.69 Before-tax cash flow (BTCF) $89,551.31 $95,553.41 $101,855.62 $108,472.93 Tax 28% -$25,074.37 -$26,754.96 -$28,519.57 -$30,372.42 After-tax cash flows for the 1st Year $64,476.95 $68,798.46 $73,336.04 $78,100.51 Working Notes: Debt Service Estimated value of land $500,000 Loan to value ratio 80.00% Loan = $500,000 x 80% $400,000 Interest rate 6.00% Years to maturity 25 Payment = PMT (6%,25,-$400,000) $31,290.69 The before-tax and after-tax equity reversion. Gross Selling Price (GSP) = $500000 x 1.05^5 $638,140.78 Less: expenses of selling the property -$31,907.04 Net Sale Proceeds (NSP) $606,233.74 Loan Balance (LB)$500,000 - $31,209.69 x 4 -$374,837.25 Before tax Equity Reversion $231,396.49 Tax $28% -$64,791.02 After Tax equity Reversion $166,605.47
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.