are144ps2excel_key

are144ps2excel_key - Josh Hanosh ARE 144 993200920 The...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Josh Hanosh ARE 144 993200920 The Seville 5 Year Operating Projection Assumptions Income Escalator Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Purchase Price $6,500,000.00 Closing Costs 1% Rent Number of Units 20 2bed/1bath 5% $264,000.00 $277,200.00 $291,060.00 $305,613.00 $320,893.65 $336,938.33 Rent Per Unit 2bed/2bath 5% $252,000.00 $264,600.00 $277,830.00 $291,721.50 $306,307.58 $321,622.95 2bed/1bath $1,100.00 3bed/2bath 5% $204,000.00 $214,200.00 $224,910.00 $236,155.50 $247,963.28 $260,361.44 2bed/2bath $1,400.00 Net Rents $720,000.00 $756,000.00 $793,800.00 $833,490.00 $875,164.50 $918,922.73 3bed/2bath $1,700.00 Appreciation 5% Expenses Vacancy Rate 1.50% Leverage 80.00% Advertsing 4% $0.00 $0.00 $0.00 $0.00 $0.00 Interest Rate 7.60% Cleaning and Maintenance 4% $0.00 $0.00 $0.00 $0.00 $0.00 Term of Mortgage (In Mo.'s) 360 Contigency 4% $0.00 $0.00 $0.00 $0.00 $0.00 Mortage Expense (Per Mo.) ($36,715.89) First year improvements 4% $0.00 $0.00 $0.00 $0.00 $0.00 Expense Ratio 32.00% Insurance 4% $0.00 $0.00 $0.00 $0.00 $0.00 Marginal Tax 28.00% Property Management 4% $0.00 $0.00 $0.00 $0.00 $0.00 Capital Gains Rate 15.00% Property Taxes 4% $0.00 $0.00 $0.00 $0.00 $0.00 Property Taxes 1.30% Water, Sewer, Garbage 4% $0.00 $0.00 $0.00 $0.00 $0.00 Inflation 4.00% Total Operating Expenses 4% ($230,400.00) ($239,616.00) ($249,200.64) ($259,168.67) ($269,535.41) ($280,316.83) Net Oeprating Income $489,600.00 $516,384.00 $544,599.36 $574,321.33 $605,629.09 $638,605.90 Return on Asset 7.53% 7.57% 7.60% 7.63% 7.67% 7.70% Return on Equity 35.03% 28.12% 22.84% 18.52% 15.19% 12.08% Purchase Analysis Mortage 0% ($440,590.64) ($440,590.64) ($440,590.64) ($440,590.64) ($440,590.64) ($440,590.64) Purchase Price $6,500,000.00 Cash Flow $49,009.36 $75,793.36 $104,008.72 $133,730.70 $165,038.45 $198,015.26 Closing Costs $65,000.00 . Total Costs $6,565,000.00 Mortage $5,200,000.00 Down Payment $1,365,000.00 Financing Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Loan Balance ($5,102,289.26) ($4,988,592.82) ($4,782,238.82) ($4,422,956.51) ($3,912,854.78) ($3,010,058.22) Equity $1,397,710.74 $1,836,407.18 $2,384,011.18
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 06/29/2009 for the course ARE 144 taught by Professor Johnson,e during the Spring '08 term at UC Davis.

Page1 / 3

are144ps2excel_key - Josh Hanosh ARE 144 993200920 The...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online