Fayetteville Deal Analysis

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

Typical Fayetteville, North Carolina Nomad™ Property with 10% Higher Rents
Purchase Inputs
Percents Dollars/#
ARV $157,308
Purchase Price $157,308
Seller Concessions $0
Down Payment 5.000% $7,865
Closing Costs 1.000% $1,573
Rent Ready Costs $0
Cumulative Negative Cash Flow $0
Total Invested $9,438
Mortgage
Mortgage Amount $149,442.60
Mortgage Interest Rate 6.500%
Loan Term 360
Private Mortgage Insurance 0.850% $105.86
Drop PMI LTV 80.000%
Income
Monthly Rent $1,984 $1984.29
Other Income $0
Annual Expenses
Vacancy Rate 3.000% $714
Property Taxes 1.295% $2,037
Property Insurance 0.484% $761
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% $23,596
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 $162,027 $166,888 $171,895 $177,052 $182,363
Appreciation Rate 3.000% 3.000% 3.000% 3.000% 3.000%
Appreciation Dollar $4,719 $4,861 $5,007 $5,157 $5,312
Monthly Income 1 2 3 4 5
Rent Appreciation Rate 3.000% 3.000% 3.000% 3.000%
Monthly Rent $1,984 $2,044 $2,105 $2,168 $2,233
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 $1,984 $2,044 $2,105 $2,168 $2,233
Vacancy Percent 3.000% 3.000% 3.000% 3.000% 3.000%
Monthly Vacancy Dollar $60 $61 $63 $65 $67
Monthly Gross Operating Income $1,925 $1,983 $2,042 $2,103 $2,166
Annual Income 1 2 3 4 5
Annual Rent $23,811 $24,526 $25,262 $26,019 $26,800
Annual Other Income $0 $0 $0 $0 $0
Annual Gross Potential Income $23,811 $24,526 $25,262 $26,019 $26,800
Annual Vacancy Dollar $714 $736 $758 $781 $804
Annual Gross Operating Income $23,097 $23,790 $24,504 $25,239 $25,996
Annual Expenses 1 2 3 4 5
Property Taxes Percent 1.295% 1.295% 1.295% 1.295% 1.295%
Property Taxes Dollar $2,037 $2,098 $2,161 $2,226 $2,293
Insurance Percent 0.484% 0.484% 0.484% 0.484% 0.484%
Insurance Dollar $761 $784 $808 $832 $857
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,310 $2,379 $2,450 $2,524 $2,600
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,108 $5,261 $5,419 $5,582 $5,749
Net Operating Income 1 2 3 4 5
Net Operating Income (NOI) $17,989 $18,529 $19,084 $19,657 $20,247
Mortgage 1 2 3 4 5
Total Annual P&I Payments $11,335 $11,335 $11,335 $11,335 $11,335
Principal $1,670 $1,782 $1,902 $2,029 $2,165
Interest $9,665 $9,553 $9,433 $9,306 $9,170
Loan Balance at End of Year $147,772 $145,990 $144,088 $142,059 $139,895
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,270 $1,270 $1,270 $1,270 $0
Equity 1 2 3 4 5
ARV - Loan Balance at End of Year $14,255 $20,898 $27,806 $34,992 $42,468
Cash Flow 1 2 3 4 5
Annual Cash Flow $5,384 $5,923 $6,479 $7,052 $8,912
Monhtly Cash Flow $449 $494 $540 $588 $743
Cash on Cash Return on Investment 0.570% 0.628% 0.686% 0.747% 0.944%
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