Lincoln Deal Analysis
Let's look at deal analysis for Lincoln, NE and for 
32 10 20% Down Rental Properties (no Owner-Occupant).
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 20% Down Payment Lincoln, Nebraska Rental Property
|
Typical 20% Down Payment Lincoln, Nebraska Rental Property
|
||
| Purchase Inputs | ||
| Percents | Dollars/# | |
| ARV | $225,000 | |
| Purchase Price | $225,000 | |
| Seller Concessions | — | $0 |
| Down Payment | 20.000% | $45,000 |
| Closing Costs | 1.000% | $2,250 |
| Rent Ready Costs | $0 | |
| Cumulative Negative Cash Flow | $6,537 | |
| Total Invested | $53,787 | |
| Mortgage | ||
| Mortgage Amount | $180,000 | |
| Mortgage Interest Rate | 7.000% | |
| Loan Term | 360 | |
| Private Mortgage Insurance | 0% | $0 |
| Drop PMI LTV | 0.000% | |
| Income | ||
| Monthly Rent | $1,943 $1942.50 | |
| Other Income | $0 | |
| Annual Expenses | ||
| Vacancy Rate | 3.000% | $699 |
| 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 | $1,943 | $2,001 | $2,061 | $2,123 | $2,186 |
| 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,943 | $2,001 | $2,061 | $2,123 | $2,186 |
| Vacancy Percent | 3.000% | 3.000% | 3.000% | 3.000% | 3.000% |
| Monthly Vacancy Dollar | $58 | $60 | $62 | $64 | $66 |
| Monthly Gross Operating Income | $1,884 | $1,941 | $1,999 | $2,059 | $2,121 |
| Annual Income | 1 | 2 | 3 | 4 | 5 |
| Annual Rent | $23,310 | $24,009 | $24,730 | $25,471 | $26,236 |
| Annual Other Income | $0 | $0 | $0 | $0 | $0 |
| Annual Gross Potential Income | $23,310 | $24,009 | $24,730 | $25,471 | $26,236 |
| Annual Vacancy Dollar | $699 | $720 | $742 | $764 | $787 |
| Annual Gross Operating Income | $22,611 | $23,289 | $23,988 | $24,707 | $25,449 |
| 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,261 | $2,329 | $2,399 | $2,471 | $2,545 |
| 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,318 | $10,628 | $10,947 | $11,275 | $11,613 |
| Net Operating Income | 1 | 2 | 3 | 4 | 5 |
| Net Operating Income (NOI) | $12,292 | $12,661 | $13,041 | $13,432 | $13,835 |
| Mortgage | 1 | 2 | 3 | 4 | 5 |
| Total Annual P&I Payments | $14,370 | $14,370 | $14,370 | $14,370 | $14,370 |
| Principal | $1,828 | $1,961 | $2,102 | $2,254 | $2,417 |
| Interest | $12,542 | $12,410 | $12,268 | $12,116 | $11,953 |
| Loan Balance at End of Year | $178,172 | $176,211 | $174,109 | $171,854 | $169,437 |
| Loan-To-Value | 76.881% | 73.820% | 70.815% | 67.862% | 64.959% |
| Private Mortgage Insurance (PMI) Rate | 0.000% | 0.000% | 0.000% | 0.000% | 0.000% |
| Private Mortgage Insurance Dollar | $0 | $0 | $0 | $0 | $0 |
| Equity | 1 | 2 | 3 | 4 | 5 |
| ARV - Loan Balance at End of Year | $53,578 | $62,491 | $71,755 | $81,385 | $91,399 |
| Cash Flow | 1 | 2 | 3 | 4 | 5 |
| Annual Cash Flow | -$2,078 | -$1,709 | -$1,329 | -$938 | -$535 |
| Monhtly Cash Flow | -$173 | -$142 | -$111 | -$78 | -$45 |
| Cash on Cash Return on Investment | -0.039% | -0.032% | -0.025% | -0.017% | -0.010% |
| 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 |