Chandler Deal Analysis

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

Typical Chandler, Arizona Nomad™ Property with 10% Higher Rents
Purchase Inputs
Percents Dollars/#
ARV $472,933
Purchase Price $472,933
Seller Concessions $0
Down Payment 5.000% $23,647
Closing Costs 1.000% $4,729
Rent Ready Costs $0
Cumulative Negative Cash Flow $64,665
Total Invested $93,041
Mortgage
Mortgage Amount $449,286.35
Mortgage Interest Rate 6.500%
Loan Term 360
Private Mortgage Insurance 0.850% $318.24
Drop PMI LTV 80.000%
Income
Monthly Rent $2,885 $2885.19
Other Income $0
Annual Expenses
Vacancy Rate 3.000% $1,039
Property Taxes 0.594% $2,809
Property Insurance 0.442% $2,090
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% $70,940
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 $487,121 $501,735 $516,787 $532,290 $548,259
Appreciation Rate 3.000% 3.000% 3.000% 3.000% 3.000%
Appreciation Dollar $14,188 $14,614 $15,052 $15,504 $15,969
Monthly Income 1 2 3 4 5
Rent Appreciation Rate 3.000% 3.000% 3.000% 3.000%
Monthly Rent $2,885 $2,972 $3,061 $3,153 $3,247
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,885 $2,972 $3,061 $3,153 $3,247
Vacancy Percent 3.000% 3.000% 3.000% 3.000% 3.000%
Monthly Vacancy Dollar $87 $89 $92 $95 $97
Monthly Gross Operating Income $2,799 $2,883 $2,969 $3,058 $3,150
Annual Income 1 2 3 4 5
Annual Rent $34,622 $35,661 $36,731 $37,833 $38,968
Annual Other Income $0 $0 $0 $0 $0
Annual Gross Potential Income $34,622 $35,661 $36,731 $37,833 $38,968
Annual Vacancy Dollar $1,039 $1,070 $1,102 $1,135 $1,169
Annual Gross Operating Income $33,584 $34,591 $35,629 $36,698 $37,799
Annual Expenses 1 2 3 4 5
Property Taxes Percent 0.594% 0.594% 0.594% 0.594% 0.594%
Property Taxes Dollar $2,809 $2,893 $2,980 $3,070 $3,162
Insurance Percent 0.442% 0.442% 0.442% 0.442% 0.442%
Insurance Dollar $2,090 $2,153 $2,218 $2,284 $2,353
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 $3,358 $3,459 $3,563 $3,670 $3,780
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 $8,258 $8,506 $8,761 $9,024 $9,294
Net Operating Income 1 2 3 4 5
Net Operating Income (NOI) $25,326 $26,085 $26,868 $27,674 $28,504
Mortgage 1 2 3 4 5
Total Annual P&I Payments $34,078 $34,078 $34,078 $34,078 $34,078
Principal $5,022 $5,358 $5,717 $6,100 $6,508
Interest $29,056 $28,719 $28,361 $27,978 $27,569
Loan Balance at End of Year $444,265 $438,906 $433,189 $427,089 $420,581
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,819 $3,819 $3,819 $3,819 $0
Equity 1 2 3 4 5
ARV - Loan Balance at End of Year $42,856 $62,828 $83,597 $105,201 $127,678
Cash Flow 1 2 3 4 5
Annual Cash Flow -$12,571 -$11,811 -$11,029 -$10,222 -$5,573
Monhtly Cash Flow -$1,048 -$984 -$919 -$852 -$464
Cash on Cash Return on Investment -0.135% -0.127% -0.119% -0.110% -0.060%
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