Laredo Deal Analysis

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

Typical Laredo, Texas Nomad™ Property with 10% Higher Rents
Purchase Inputs
Percents Dollars/#
ARV $171,099
Purchase Price $171,099
Seller Concessions $0
Down Payment 5.000% $8,555
Closing Costs 1.000% $1,711
Rent Ready Costs $0
Cumulative Negative Cash Flow $12,009
Total Invested $22,275
Mortgage
Mortgage Amount $162,544.05
Mortgage Interest Rate 6.500%
Loan Term 360
Private Mortgage Insurance 0.850% $115.14
Drop PMI LTV 80.000%
Income
Monthly Rent $1,646 $1645.88
Other Income $0
Annual Expenses
Vacancy Rate 3.000% $593
Property Taxes 2.587% $4,426
Property Insurance 1.419% $2,428
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% $25,665
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 $176,232 $181,519 $186,964 $192,573 $198,351
Appreciation Rate 3.000% 3.000% 3.000% 3.000% 3.000%
Appreciation Dollar $5,133 $5,287 $5,446 $5,609 $5,777
Monthly Income 1 2 3 4 5
Rent Appreciation Rate 3.000% 3.000% 3.000% 3.000%
Monthly Rent $1,646 $1,695 $1,746 $1,798 $1,852
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,646 $1,695 $1,746 $1,798 $1,852
Vacancy Percent 3.000% 3.000% 3.000% 3.000% 3.000%
Monthly Vacancy Dollar $49 $51 $52 $54 $56
Monthly Gross Operating Income $1,597 $1,644 $1,694 $1,745 $1,797
Annual Income 1 2 3 4 5
Annual Rent $19,751 $20,343 $20,953 $21,582 $22,229
Annual Other Income $0 $0 $0 $0 $0
Annual Gross Potential Income $19,751 $20,343 $20,953 $21,582 $22,229
Annual Vacancy Dollar $593 $610 $629 $647 $667
Annual Gross Operating Income $19,158 $19,733 $20,325 $20,935 $21,563
Annual Expenses 1 2 3 4 5
Property Taxes Percent 2.587% 2.587% 2.587% 2.587% 2.587%
Property Taxes Dollar $4,426 $4,559 $4,696 $4,837 $4,982
Insurance Percent 1.419% 1.419% 1.419% 1.419% 1.419%
Insurance Dollar $2,428 $2,501 $2,576 $2,653 $2,733
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 $1,916 $1,973 $2,032 $2,093 $2,156
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,770 $9,033 $9,304 $9,583 $9,871
Net Operating Income 1 2 3 4 5
Net Operating Income (NOI) $10,388 $10,700 $11,021 $11,351 $11,692
Mortgage 1 2 3 4 5
Total Annual P&I Payments $12,329 $12,329 $12,329 $12,329 $12,329
Principal $1,817 $1,938 $2,068 $2,207 $2,355
Interest $10,512 $10,390 $10,260 $10,122 $9,974
Loan Balance at End of Year $160,727 $158,789 $156,720 $154,514 $152,159
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,382 $1,382 $1,382 $1,382 $0
Equity 1 2 3 4 5
ARV - Loan Balance at End of Year $15,505 $22,730 $30,244 $38,060 $46,192
Cash Flow 1 2 3 4 5
Annual Cash Flow -$3,322 -$3,011 -$2,690 -$2,359 -$637
Monhtly Cash Flow -$277 -$251 -$224 -$197 -$53
Cash on Cash Return on Investment -0.149% -0.135% -0.121% -0.106% -0.029%
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