Indianapolis Deal Analysis

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

Typical Indianapolis, Indiana Nomad™ Property with 10% Higher Rents
Purchase Inputs
Percents Dollars/#
ARV $198,160
Purchase Price $198,160
Seller Concessions $0
Down Payment 5.000% $9,908
Closing Costs 1.000% $1,982
Rent Ready Costs $0
Cumulative Negative Cash Flow $0
Total Invested $11,890
Mortgage
Mortgage Amount $188,252
Mortgage Interest Rate 6.500%
Loan Term 360
Private Mortgage Insurance 0.850% $133.35
Drop PMI LTV 80.000%
Income
Monthly Rent $2,801 $2800.88
Other Income $0
Annual Expenses
Vacancy Rate 3.000% $1,008
Property Taxes 1.074% $2,128
Property Insurance 1.123% $2,225
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% $29,724
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 $204,105 $210,228 $216,535 $223,031 $229,722
Appreciation Rate 3.000% 3.000% 3.000% 3.000% 3.000%
Appreciation Dollar $5,945 $6,123 $6,307 $6,496 $6,691
Monthly Income 1 2 3 4 5
Rent Appreciation Rate 3.000% 3.000% 3.000% 3.000%
Monthly Rent $2,801 $2,885 $2,971 $3,061 $3,152
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,801 $2,885 $2,971 $3,061 $3,152
Vacancy Percent 3.000% 3.000% 3.000% 3.000% 3.000%
Monthly Vacancy Dollar $84 $87 $89 $92 $95
Monthly Gross Operating Income $2,717 $2,798 $2,882 $2,969 $3,058
Annual Income 1 2 3 4 5
Annual Rent $33,611 $34,619 $35,657 $36,727 $37,829
Annual Other Income $0 $0 $0 $0 $0
Annual Gross Potential Income $33,611 $34,619 $35,657 $36,727 $37,829
Annual Vacancy Dollar $1,008 $1,039 $1,070 $1,102 $1,135
Annual Gross Operating Income $32,602 $33,580 $34,588 $35,625 $36,694
Annual Expenses 1 2 3 4 5
Property Taxes Percent 1.074% 1.074% 1.074% 1.074% 1.074%
Property Taxes Dollar $2,128 $2,192 $2,258 $2,326 $2,395
Insurance Percent 1.123% 1.123% 1.123% 1.123% 1.123%
Insurance Dollar $2,225 $2,292 $2,361 $2,432 $2,505
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,260 $3,358 $3,459 $3,563 $3,669
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,614 $7,842 $8,077 $8,320 $8,569
Net Operating Income 1 2 3 4 5
Net Operating Income (NOI) $24,988 $25,738 $26,510 $27,306 $28,125
Mortgage 1 2 3 4 5
Total Annual P&I Payments $14,279 $14,279 $14,279 $14,279 $14,279
Principal $2,104 $2,245 $2,395 $2,556 $2,727
Interest $12,174 $12,034 $11,883 $11,723 $11,552
Loan Balance at End of Year $186,148 $183,903 $181,507 $178,952 $176,225
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,600 $1,600 $1,600 $1,600 $0
Equity 1 2 3 4 5
ARV - Loan Balance at End of Year $17,957 $26,325 $35,027 $44,079 $53,497
Cash Flow 1 2 3 4 5
Annual Cash Flow $9,110 $9,859 $10,632 $11,427 $13,846
Monhtly Cash Flow $759 $822 $886 $952 $1,154
Cash on Cash Return on Investment 0.766% 0.829% 0.894% 0.961% 1.165%
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