Lincoln Deal Analysis
Let's look at deal analysis for Lincoln, NE and for 
15 Buy 10 Nomads™ with 10% Higher Rents.
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 Lincoln, Nebraska Nomad™ Property with 10% Higher Rents
|
Typical Lincoln, Nebraska Nomad™ Property with 10% Higher Rents
|
||
| Purchase Inputs | ||
| Percents | Dollars/# | |
| ARV | $225,000 | |
| Purchase Price | $225,000 | |
| Seller Concessions | — | $0 |
| Down Payment | 5.000% | $11,250 |
| Closing Costs | 1.000% | $2,250 |
| Rent Ready Costs | $0 | |
| Cumulative Negative Cash Flow | $11,932 | |
| Total Invested | $25,432 | |
| Mortgage | ||
| Mortgage Amount | $213,750 | |
| Mortgage Interest Rate | 6.500% | |
| Loan Term | 360 | |
| Private Mortgage Insurance | 0.850% | $151.41 |
| Drop PMI LTV | 80.000% | |
| Income | ||
| Monthly Rent | $2,137 $2136.75 | |
| Other Income | $0 | |
| Annual Expenses | ||
| Vacancy Rate | 3.000% | $769 |
| Property Taxes | 1.837% | $4,133 |
| Property Insurance | 1.744% | $3,924 |
| 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% | $33,750 |
| 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 | $231,750 | $238,703 | $245,864 | $253,239 | $260,837 |
| Appreciation Rate | 3.000% | 3.000% | 3.000% | 3.000% | 3.000% |
| Appreciation Dollar | $6,750 | $6,953 | $7,161 | $7,376 | $7,597 |
| Monthly Income | 1 | 2 | 3 | 4 | 5 |
| Rent Appreciation Rate | 3.000% | 3.000% | 3.000% | 3.000% | |
| Monthly Rent | $2,137 | $2,201 | $2,267 | $2,335 | $2,405 |
| 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,137 | $2,201 | $2,267 | $2,335 | $2,405 |
| Vacancy Percent | 3.000% | 3.000% | 3.000% | 3.000% | 3.000% |
| Monthly Vacancy Dollar | $64 | $66 | $68 | $70 | $72 |
| Monthly Gross Operating Income | $2,073 | $2,135 | $2,199 | $2,265 | $2,333 |
| Annual Income | 1 | 2 | 3 | 4 | 5 |
| Annual Rent | $25,641 | $26,410 | $27,203 | $28,019 | $28,859 |
| Annual Other Income | $0 | $0 | $0 | $0 | $0 |
| Annual Gross Potential Income | $25,641 | $26,410 | $27,203 | $28,019 | $28,859 |
| Annual Vacancy Dollar | $769 | $792 | $816 | $841 | $866 |
| Annual Gross Operating Income | $24,872 | $25,618 | $26,386 | $27,178 | $27,993 |
| Annual Expenses | 1 | 2 | 3 | 4 | 5 |
| Property Taxes Percent | 1.837% | 1.837% | 1.837% | 1.837% | 1.837% |
| Property Taxes Dollar | $4,133 | $4,257 | $4,385 | $4,517 | $4,652 |
| Insurance Percent | 1.744% | 1.744% | 1.744% | 1.744% | 1.744% |
| Insurance Dollar | $3,924 | $4,042 | $4,163 | $4,288 | $4,416 |
| 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,487 | $2,562 | $2,639 | $2,718 | $2,799 |
| 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,544 | $10,861 | $11,187 | $11,522 | $11,868 |
| Net Operating Income | 1 | 2 | 3 | 4 | 5 |
| Net Operating Income (NOI) | $14,327 | $14,757 | $15,200 | $15,656 | $16,126 |
| Mortgage | 1 | 2 | 3 | 4 | 5 |
| Total Annual P&I Payments | $16,213 | $16,213 | $16,213 | $16,213 | $16,213 |
| Principal | $2,389 | $2,549 | $2,720 | $2,902 | $3,096 |
| Interest | $13,823 | $13,663 | $13,493 | $13,311 | $13,116 |
| Loan Balance at End of Year | $211,361 | $208,812 | $206,092 | $203,190 | $200,093 |
| 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,817 | $1,817 | $1,817 | $1,817 | $0 |
| Equity | 1 | 2 | 3 | 4 | 5 |
| ARV - Loan Balance at End of Year | $20,389 | $29,891 | $39,772 | $50,050 | $60,744 |
| Cash Flow | 1 | 2 | 3 | 4 | 5 |
| Annual Cash Flow | -$3,702 | -$3,272 | -$2,830 | -$2,374 | -$87 |
| Monhtly Cash Flow | -$309 | -$273 | -$236 | -$198 | -$7 |
| Cash on Cash Return on Investment | -0.146% | -0.129% | -0.111% | -0.093% | -0.003% |
| 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 |