Mesquite Deal Analysis
Let's look at deal analysis for Mesquite, TX and for 
06 Buy 10 Nomads™ with 10% Discounts.
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 Mesquite, Texas Nomad™ Property with 10% Discount
|
Typical Mesquite, Texas Nomad™ Property with 10% Discount
|
||
| Purchase Inputs | ||
| Percents | Dollars/# | |
| ARV | $242,901 | |
| Purchase Price | $218,611 | |
| Seller Concessions | — | $0 |
| Down Payment | 5.000% | $10,931 |
| Closing Costs | 1.000% | $2,186 |
| Rent Ready Costs | $0 | |
| Cumulative Negative Cash Flow | $15,327 | |
| Total Invested | $28,443 | |
| Mortgage | ||
| Mortgage Amount | $207,680.45 | |
| Mortgage Interest Rate | 6.500% | |
| Loan Term | 360 | |
| Private Mortgage Insurance | 0.850% | $147.11 |
| Drop PMI LTV | 80.000% | |
| Income | ||
| Monthly Rent | $1,997 $1997.10 | |
| Other Income | $0 | |
| Annual Expenses | ||
| Vacancy Rate | 3.000% | $719 |
| Property Taxes | 1.953% | $4,744 |
| Property Insurance | 1.419% | $3,447 |
| 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% | $32,792 |
| 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 | $250,188 | $257,694 | $265,424 | $273,387 | $281,589 |
| Appreciation Rate | 3.000% | 3.000% | 3.000% | 3.000% | 3.000% |
| Appreciation Dollar | $7,287 | $7,506 | $7,731 | $7,963 | $8,202 |
| Monthly Income | 1 | 2 | 3 | 4 | 5 |
| Rent Appreciation Rate | 3.000% | 3.000% | 3.000% | 3.000% | |
| Monthly Rent | $1,997 | $2,057 | $2,119 | $2,182 | $2,248 |
| 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,997 | $2,057 | $2,119 | $2,182 | $2,248 |
| Vacancy Percent | 3.000% | 3.000% | 3.000% | 3.000% | 3.000% |
| Monthly Vacancy Dollar | $60 | $62 | $64 | $65 | $67 |
| Monthly Gross Operating Income | $1,937 | $1,995 | $2,055 | $2,117 | $2,180 |
| Annual Income | 1 | 2 | 3 | 4 | 5 |
| Annual Rent | $23,965 | $24,684 | $25,425 | $26,187 | $26,973 |
| Annual Other Income | $0 | $0 | $0 | $0 | $0 |
| Annual Gross Potential Income | $23,965 | $24,684 | $25,425 | $26,187 | $26,973 |
| Annual Vacancy Dollar | $719 | $741 | $763 | $786 | $809 |
| Annual Gross Operating Income | $23,246 | $23,944 | $24,662 | $25,402 | $26,164 |
| Annual Expenses | 1 | 2 | 3 | 4 | 5 |
| Property Taxes Percent | 1.953% | 1.953% | 1.953% | 1.953% | 1.953% |
| Property Taxes Dollar | $4,744 | $4,886 | $5,033 | $5,184 | $5,339 |
| Insurance Percent | 1.419% | 1.419% | 1.419% | 1.419% | 1.419% |
| Insurance Dollar | $3,447 | $3,550 | $3,657 | $3,766 | $3,879 |
| 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,325 | $2,394 | $2,466 | $2,540 | $2,616 |
| 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 | $10,515 | $10,831 | $11,156 | $11,490 | $11,835 |
| Net Operating Income | 1 | 2 | 3 | 4 | 5 |
| Net Operating Income (NOI) | $12,731 | $13,113 | $13,506 | $13,912 | $14,329 |
| Mortgage | 1 | 2 | 3 | 4 | 5 |
| Total Annual P&I Payments | $15,752 | $15,752 | $15,752 | $15,752 | $15,752 |
| Principal | $2,321 | $2,477 | $2,643 | $2,820 | $3,008 |
| Interest | $13,431 | $13,275 | $13,110 | $12,933 | $12,744 |
| Loan Balance at End of Year | $205,359 | $202,882 | $200,240 | $197,420 | $194,412 |
| Loan-To-Value | 82.082% | 78.730% | 75.441% | 72.213% | 69.041% |
| Private Mortgage Insurance (PMI) Rate | 0.850% | ||||
| Private Mortgage Insurance Dollar | $1,765 | $0 | $0 | $0 | $0 |
| Equity | 1 | 2 | 3 | 4 | 5 |
| ARV - Loan Balance at End of Year | $44,829 | $54,811 | $65,185 | $75,967 | $87,177 |
| Cash Flow | 1 | 2 | 3 | 4 | 5 |
| Annual Cash Flow | -$4,786 | -$2,639 | -$2,246 | -$1,841 | -$1,423 |
| Monhtly Cash Flow | -$399 | -$220 | -$187 | -$153 | -$119 |
| Cash on Cash Return on Investment | -0.168% | -0.093% | -0.079% | -0.065% | -0.050% |
| 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 |
| Organic Appreciation | $7,834 | |||
| + | Forced Appreciation | + | $0 | |
| Total Appreciation | = | $7,834 |
Let's walk through calculating Appreciation for Typical 25% Down Payment Gainesville, Florida Rental Property.
First, there's organic appreciation and forced appreciation.
Organic Appreciation
Organic appreciation is the tendency that properties become more expensive over time. Some would argue that, at least part of it, is from inflation.
Ultimately, to calculate the organic appreciation we will need the current value of the property and Appreciation Rate.
Both the current value of a property and the appreciation rate are easy since they both are primary inputs that do not require any real calculation.
Organic Appreciation
| Property Value | $261,142 | |||
| × | Appreciation Rate | × | 3% | |
| Appreciation | = | $7,834 |
That means that we're estimating Typical 25% Down Payment Gainesville, Florida Rental Property will naturally and organically appreciate $7,834.26 over a full year.
Forced Appreciation
Forced appreciation from buying a property at a discount and/or improving the property to add value.
To calculate forced appreciation—especially on a new purchase—we will take the difference between the Purchase Price and the After Repair Value of the property.
Forced Appreciation
| After Repair Value | $261,142 | |||
| - | Purchase Price | - | $261,142 | |
| Forced Appreciation | = | $0 |
That means that we're estimating Typical 25% Down Payment Gainesville, Florida Rental Property was forced to appreciate $0 by buying at a discount and/or improving the property in the next year.
It is not uncommon to have zero or even negative forced appreciation on a property when acquiring it. In fact, sometimes we deliberately trade the short-term benefit of buying a property at a discount to select a property that is likely to see better than average organic appreciation in the long-term. Think of this as: selecting a high quality, in-demand property that is likely to continue to increase in demand in the future and grow faster than inflation and other properties in different areas or with different characteristics.
Total Appreciation
The total appreciation is the sum of the estimated organic appreciation and the estimated forced appreciation over the next year.
Total Appreciation
| Organic Appreciation | $7,834 | |||
| + | Forced Appreciation | + | $0 | |
| Total Appreciation | = | $7,834 |
For Typical 25% Down Payment Gainesville, Florida Rental Property we're estimating the organic appreciation of $7,834.26 plus the forced appreciation of $0 gives us an estimated total appreciation of $7,834.26 in the next year.