Anaheim Deal Analysis

Let's look at deal analysis for Anaheim, CA and for 15 Buy 10 Nomads™ with 10% Higher Rents.

The World's Greatest Real Estate Deal Analysis Spreadsheet™

The analysis is based on The World's Greatest Real Estate Deal Analysis Spreadsheet™ (shown above)... a free spreadsheet download you can use to analyze your own deals.

Typical Anaheim, California Nomad™ Property with 10% Higher Rents

Typical Anaheim, California Nomad™ Property with 10% Higher Rents
Purchase Inputs
Percents Dollars/#
ARV $818,340
Purchase Price $818,340
Seller Concessions $0
Down Payment 5.000% $40,917
Closing Costs 1.000% $8,183
Rent Ready Costs $0
Cumulative Negative Cash Flow $196,317
Total Invested $245,418
Mortgage
Mortgage Amount $777,423
Mortgage Interest Rate 6.500%
Loan Term 360
Private Mortgage Insurance 0.850% $550.67
Drop PMI LTV 80.000%
Income
Monthly Rent $4,389 $4389.00
Other Income $0
Annual Expenses
Vacancy Rate 3.000% $1,580
Property Taxes 0.766% $6,268
Property Insurance 0.173% $1,416
HOA Dues $0
Utilities $0
Other Expenses 1 $0
Other Expenses 2 $0
Maintenance 10.000%
CapEx $0
Management 0.000%
Depreciation Details
Land Value 15.000% $122,751
Property Type (C or R) R 27.5
Effective Income Tax Rate 15.000%
Property Value 1 2 3 4 5
ARV at End of Year $842,890 $868,177 $894,222 $921,049 $948,680
Appreciation Rate 3.000% 3.000% 3.000% 3.000% 3.000%
Appreciation Dollar $24,550 $25,287 $26,045 $26,827 $27,631
Monthly Income 1 2 3 4 5
Rent Appreciation Rate 3.000% 3.000% 3.000% 3.000%
Monthly Rent $4,389 $4,521 $4,656 $4,796 $4,940
Monthly Other Income Appreciation Rate 3.000% 3.000% 3.000% 3.000%
Monthly Other Income $0 $0 $0 $0 $0
Monthly Gross Potential Income $4,389 $4,521 $4,656 $4,796 $4,940
Vacancy Percent 3.000% 3.000% 3.000% 3.000% 3.000%
Monthly Vacancy Dollar $132 $136 $140 $144 $148
Monthly Gross Operating Income $4,257 $4,385 $4,517 $4,652 $4,792
Annual Income 1 2 3 4 5
Annual Rent $52,668 $54,248 $55,875 $57,552 $59,278
Annual Other Income $0 $0 $0 $0 $0
Annual Gross Potential Income $52,668 $54,248 $55,875 $57,552 $59,278
Annual Vacancy Dollar $1,580 $1,627 $1,676 $1,727 $1,778
Annual Gross Operating Income $51,088 $52,621 $54,199 $55,825 $57,500
Annual Expenses 1 2 3 4 5
Property Taxes Percent 0.766% 0.766% 0.766% 0.766% 0.766%
Property Taxes Dollar $6,268 $6,457 $6,650 $6,850 $7,055
Insurance Percent 0.173% 0.173% 0.173% 0.173% 0.173%
Insurance Dollar $1,416 $1,458 $1,502 $1,547 $1,593
HOA Appreciation Rate 3.000% 3.000% 3.000% 3.000% 3.000%
HOA Dues Dollar $0 $0 $0 $0 $0
Utilities Appreciation Rate 3.000% 3.000% 3.000% 3.000% 3.000%
Utilities Dollar $0 $0 $0 $0 $0
Other Expense 1 Appreciation Rate 3.000% 3.000% 3.000% 3.000% 3.000%
Other Expense 1 Dollar $0 $0 $0 $0 $0
Other Expense 2 Appreciation Rate 3.000% 3.000% 3.000% 3.000% 3.000%
Other Expense 2 Dollar $0 $0 $0 $0 $0
Maintenance Percent 10.000% 10.000% 10.000% 10.000% 10.000%
Maintenance Dollar $5,109 $5,262 $5,420 $5,583 $5,750
CapEx Appreciation Rate 3.000% 3.000% 3.000% 3.000% 3.000%
CapEx Dollar $0 $0 $0 $0 $0
Property Management Percent 0.000% 0.000% 0.000% 0.000% 0.000%
Property Management Dollar $0 $0 $0 $0 $0
Annual Operating Expenses $12,793 $13,177 $13,572 $13,979 $14,399
Net Operating Income 1 2 3 4 5
Net Operating Income (NOI) $38,295 $39,444 $40,627 $41,846 $43,101
Mortgage 1 2 3 4 5
Total Annual P&I Payments $58,966 $58,966 $58,966 $58,966 $58,966
Principal $8,689 $9,271 $9,892 $10,555 $11,262
Interest $50,277 $49,695 $49,074 $48,411 $47,704
Loan Balance at End of Year $768,734 $759,462 $749,570 $739,015 $727,753
Loan-To-Value 91.202% 87.478% 83.824% 80.236% 76.712%
Private Mortgage Insurance (PMI) Rate 0.850% 0.850% 0.850% 0.850%
Private Mortgage Insurance Dollar $6,608 $6,608 $6,608 $6,608 $0
Equity 1 2 3 4 5
ARV - Loan Balance at End of Year $74,157 $108,715 $144,652 $182,034 $220,927
Cash Flow 1 2 3 4 5
Annual Cash Flow -$27,279 -$26,130 -$24,947 -$23,728 -$15,865
Monhtly Cash Flow -$2,273 -$2,178 -$2,079 -$1,977 -$1,322
Cash on Cash Return on Investment -0.111% -0.106% -0.102% -0.097% -0.065%
Cap Rate
DSCR 0.00 0.00 0.00 0.00 0.00
Negative Cash Flow $0 $0 $0 $0 $0
Cumulative Negative Cash Flow $0 $0 $0 $0 $0