Ontario Deal Analysis

Let's look at deal analysis for Ontario, 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 Ontario, California Nomad™ Property with 10% Higher Rents

Typical Ontario, California Nomad™ Property with 10% Higher Rents
Purchase Inputs
Percents Dollars/#
ARV $379,800
Purchase Price $379,800
Seller Concessions $0
Down Payment 5.000% $18,990
Closing Costs 1.000% $3,798
Rent Ready Costs $0
Cumulative Negative Cash Flow $0
Total Invested $22,788
Mortgage
Mortgage Amount $360,810
Mortgage Interest Rate 6.500%
Loan Term 360
Private Mortgage Insurance 0.850% $255.57
Drop PMI LTV 80.000%
Income
Monthly Rent $3,465 $3465.00
Other Income $0
Annual Expenses
Vacancy Rate 3.000% $1,247
Property Taxes 0.719% $2,731
Property Insurance 0.173% $657
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% $56,970
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 $391,194 $402,930 $415,018 $427,468 $440,292
Appreciation Rate 3.000% 3.000% 3.000% 3.000% 3.000%
Appreciation Dollar $11,394 $11,736 $12,088 $12,451 $12,824
Monthly Income 1 2 3 4 5
Rent Appreciation Rate 3.000% 3.000% 3.000% 3.000%
Monthly Rent $3,465 $3,569 $3,676 $3,786 $3,900
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 $3,465 $3,569 $3,676 $3,786 $3,900
Vacancy Percent 3.000% 3.000% 3.000% 3.000% 3.000%
Monthly Vacancy Dollar $104 $107 $110 $114 $117
Monthly Gross Operating Income $3,361 $3,462 $3,566 $3,673 $3,783
Annual Income 1 2 3 4 5
Annual Rent $41,580 $42,827 $44,112 $45,436 $46,799
Annual Other Income $0 $0 $0 $0 $0
Annual Gross Potential Income $41,580 $42,827 $44,112 $45,436 $46,799
Annual Vacancy Dollar $1,247 $1,285 $1,323 $1,363 $1,404
Annual Gross Operating Income $40,333 $41,543 $42,789 $44,073 $45,395
Annual Expenses 1 2 3 4 5
Property Taxes Percent 0.719% 0.719% 0.719% 0.719% 0.719%
Property Taxes Dollar $2,731 $2,813 $2,897 $2,984 $3,073
Insurance Percent 0.173% 0.173% 0.173% 0.173% 0.173%
Insurance Dollar $657 $677 $697 $718 $740
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 $4,033 $4,154 $4,279 $4,407 $4,539
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 $7,421 $7,644 $7,873 $8,109 $8,352
Net Operating Income 1 2 3 4 5
Net Operating Income (NOI) $32,912 $33,899 $34,916 $35,963 $37,042
Mortgage 1 2 3 4 5
Total Annual P&I Payments $27,367 $27,367 $27,367 $27,367 $27,367
Principal $4,033 $4,303 $4,591 $4,899 $5,227
Interest $23,334 $23,064 $22,776 $22,468 $22,140
Loan Balance at End of Year $356,777 $352,474 $347,883 $342,985 $337,758
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 $3,067 $3,067 $3,067 $3,067 $0
Equity 1 2 3 4 5
ARV - Loan Balance at End of Year $34,417 $50,456 $67,134 $84,484 $102,534
Cash Flow 1 2 3 4 5
Annual Cash Flow $2,478 $3,465 $4,482 $5,530 $9,675
Monhtly Cash Flow $206 $289 $374 $461 $806
Cash on Cash Return on Investment 0.109% 0.152% 0.197% 0.243% 0.425%
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