ps3_excel2

ps3_excel2 - Hanosh Commons 5 Year Operating Projection...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Josh Hanosh ARE 144 Hanosh Commons 5 Year Operating Projection Assumptions Income Escalator Year 1 Year 2 Year 3 Year 4 Year 5 Purchase Price $2,340,000.00 Closing Costs 1% Rent Number of Units 24 5% $0.00 $0.00 $0.00 $0.00 $0.00 Rent Per Unit 1bed/1bath 5% $172,800.00 $181,440.00 $190,512.00 $200,037.60 $210,039.48 2bed/1bath 6% $230,400.00 $244,224.00 $258,877.44 $274,410.09 $290,874.69 1bed/1bath $1,200.00 2bed/1bath $1,600.00 Appreciation 4% Expenses Vacancy Rate 4.00% Leverage 75.00% Advertsing 3% ($600.00) ($618.00) ($636.54) ($655.64) ($675.31) Interest Rate 6.60% Cleaning and Maintenance 3% ($360.00) ($370.80) ($381.92) ($393.38) ($405.18) Term of Mortgage (In Mo.'s) 360 Contigency 3% ($1,200.00) ($1,236.00) ($1,273.08) ($1,311.27) ($1,350.61) Mortage Expense (Per Mo.) ($11,208.46) First year improvements 3% ($1,200.00) ($1,236.00) ($1,273.08) ($1,311.27) ($1,350.61) Expense Ratio 14.93% Insurance 3% ($2,160.00) ($2,224.80) ($2,291.54) ($2,360.29) ($2,431.10) Marginal Tax 35.00%
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Ask a homework question - tutors are online