Las Cruces Deal Analysis

Let's look at deal analysis for Las Cruces, NM 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 Las Cruces, New Mexico Nomad™ Property with 10% Higher Rents

Typical Las Cruces, New Mexico Nomad™ Property with 10% Higher Rents
Purchase Inputs
Percents Dollars/#
ARV $221,565
Purchase Price $221,565
Seller Concessions $0
Down Payment 5.000% $11,078
Closing Costs 1.000% $2,216
Rent Ready Costs $0
Cumulative Negative Cash Flow $0
Total Invested $13,294
Mortgage
Mortgage Amount $210,486.75
Mortgage Interest Rate 6.500%
Loan Term 360
Private Mortgage Insurance 0.850% $149.09
Drop PMI LTV 80.000%
Income
Monthly Rent $2,079 $2079.00
Other Income $0
Annual Expenses
Vacancy Rate 3.000% $748
Property Taxes 0.861% $1,908
Property Insurance 0.748% $1,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% $33,235
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 $228,212 $235,058 $242,110 $249,373 $256,855
Appreciation Rate 3.000% 3.000% 3.000% 3.000% 3.000%
Appreciation Dollar $6,647 $6,846 $7,052 $7,263 $7,481
Monthly Income 1 2 3 4 5
Rent Appreciation Rate 3.000% 3.000% 3.000% 3.000%
Monthly Rent $2,079 $2,141 $2,206 $2,272 $2,340
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 $2,079 $2,141 $2,206 $2,272 $2,340
Vacancy Percent 3.000% 3.000% 3.000% 3.000% 3.000%
Monthly Vacancy Dollar $62 $64 $66 $68 $70
Monthly Gross Operating Income $2,017 $2,077 $2,139 $2,204 $2,270
Annual Income 1 2 3 4 5
Annual Rent $24,948 $25,696 $26,467 $27,261 $28,079
Annual Other Income $0 $0 $0 $0 $0
Annual Gross Potential Income $24,948 $25,696 $26,467 $27,261 $28,079
Annual Vacancy Dollar $748 $771 $794 $818 $842
Annual Gross Operating Income $24,200 $24,926 $25,673 $26,444 $27,237
Annual Expenses 1 2 3 4 5
Property Taxes Percent 0.861% 0.861% 0.861% 0.861% 0.861%
Property Taxes Dollar $1,908 $1,965 $2,024 $2,085 $2,147
Insurance Percent 0.748% 0.748% 0.748% 0.748% 0.748%
Insurance Dollar $1,657 $1,707 $1,758 $1,811 $1,865
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 $2,420 $2,493 $2,567 $2,644 $2,724
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 $5,985 $6,164 $6,349 $6,540 $6,736
Net Operating Income 1 2 3 4 5
Net Operating Income (NOI) $18,215 $18,761 $19,324 $19,904 $20,501
Mortgage 1 2 3 4 5
Total Annual P&I Payments $15,965 $15,965 $15,965 $15,965 $15,965
Principal $2,353 $2,510 $2,678 $2,858 $3,049
Interest $13,612 $13,455 $13,287 $13,107 $12,916
Loan Balance at End of Year $208,134 $205,624 $202,945 $200,088 $197,039
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 $1,789 $1,789 $1,789 $1,789 $0
Equity 1 2 3 4 5
ARV - Loan Balance at End of Year $20,078 $29,434 $39,165 $49,286 $59,816
Cash Flow 1 2 3 4 5
Annual Cash Flow $460 $1,007 $1,570 $2,149 $4,536
Monhtly Cash Flow $38 $84 $131 $179 $378
Cash on Cash Return on Investment 0.035% 0.076% 0.118% 0.162% 0.341%
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