Brand New SF Duplex in Edmond
Oklahoma
3bd • 2.5ba • Built: 2025
| Projected Income | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 |
|---|
| Projected Rent | $45,600 | $46,968 | $48,377 | $49,828 | $51,323 | $52,863 | $54,449 | $56,082 | $57,765 | $59,498 |
| Vacancy Losses | ($3,648) | ($3,757) | ($3,870) | ($3,986) | ($4,106) | ($4,229) | ($4,356) | ($4,487) | ($4,621) | ($4,760) |
| Operating Income | $41,952 | $43,211 | $44,507 | $45,842 | $47,217 | $48,634 | $50,093 | $51,596 | $53,144 | $54,738 |
| Estimated Expenses | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 |
|---|
| Property Taxes | ($6,930) | ($7,173) | ($7,424) | ($7,683) | ($7,952) | ($8,231) | ($8,519) | ($8,817) | ($9,125) | ($9,445) |
| Insurance | ($1,980) | ($2,049) | ($2,121) | ($2,195) | ($2,272) | ($2,352) | ($2,434) | ($2,519) | ($2,607) | ($2,699) |
| Management Fees | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Leasing/Advertising Fees | ($600) | ($621) | ($643) | ($665) | ($689) | ($713) | ($738) | ($763) | ($790) | ($818) |
| Association Fees | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Maintenance | ($912) | ($944) | ($977) | ($1,011) | ($1,047) | ($1,083) | ($1,121) | ($1,160) | ($1,201) | ($1,243) |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Operating Expenses | ($10,422) | ($10,787) | ($11,164) | ($11,555) | ($11,959) | ($12,378) | ($12,811) | ($13,260) | ($13,724) | ($14,204) |
| Income Analysis | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 |
|---|
| Net Operating Income | $31,530 | $32,424 | $33,343 | $34,287 | $35,258 | $36,256 | $37,282 | $38,336 | $39,420 | $40,534 |
| - Mortgage Payments | ($27,116) | ($27,116) | ($27,116) | ($27,116) | ($27,116) | ($27,116) | ($27,116) | ($27,116) | ($27,116) | ($27,116) |
| = Cash Flow | $4,414 | $5,308 | $6,227 | $7,171 | $8,142 | $9,140 | $10,166 | $11,220 | $12,304 | $13,418 |
| + Principal Reduction | $3,996 | $4,263 | $4,549 | $4,854 | $5,179 | $5,526 | $5,896 | $6,290 | $6,712 | $7,161 |
| + Appreciation | $33,000 | $34,980 | $37,079 | $39,304 | $41,662 | $44,161 | $46,811 | $49,620 | $52,597 | $55,753 |
| = Gross Equity Income | $41,410 | $44,552 | $47,855 | $51,328 | $54,983 | $58,827 | $62,873 | $67,130 | $71,613 | $76,332 |
| Capitalization Rate | 5.4% | 5.2% | 5.1% | 4.9% | 4.8% | 4.6% | 4.5% | 4.4% | 4.2% | 4.1% |
| Cash on Cash Return | 2.0% | 2.4% | 2.8% | 3.3% | 3.7% | 4.2% | 4.6% | 5.1% | 5.6% | 6.1% |
| Return on Equity | 18.0% | 16.6% | 15.4% | 14.5% | 13.7% | 13.0% | 12.5% | 12.0% | 11.6% | 11.2% |
| Loan Analysis | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 |
|---|
| Market Value | $583,000 | $617,980 | $655,059 | $694,362 | $736,024 | $780,186 | $826,997 | $876,616 | $929,213 | $984,966 |
| - Loan Balance | ($353,504) | ($349,241) | ($344,692) | ($339,838) | ($334,659) | ($329,134) | ($323,238) | ($316,948) | ($310,236) | ($303,075) |
| = Equity | $229,496 | $268,739 | $310,367 | $354,524 | $401,365 | $451,052 | $503,758 | $559,668 | $618,977 | $681,891 |
| Loan-to-Value Ratio | 60.6% | 56.5% | 52.6% | 48.9% | 45.5% | 42.2% | 39.1% | 36.2% | 33.4% | 30.8% |
| Potential Cash-Out Refi | $83,746 | $114,244 | $146,602 | $180,934 | $217,359 | $256,005 | $297,009 | $340,514 | $386,674 | $435,649 |
| Sale Analysis | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 |
|---|
| Equity | $229,496 | $268,739 | $310,367 | $354,524 | $401,365 | $451,052 | $503,758 | $559,668 | $618,977 | $681,891 |
| - Closing Costs | ($40,810) | ($43,259) | ($45,854) | ($48,605) | ($51,522) | ($54,613) | ($57,890) | ($61,363) | ($65,045) | ($68,948) |
| = Proceeds After Sale | $188,686 | $225,481 | $264,513 | $305,919 | $349,843 | $396,439 | $445,868 | $498,305 | $553,932 | $612,943 |
| + Cumulative Cash Flow | $4,414 | $9,722 | $15,949 | $23,121 | $31,263 | $40,403 | $50,569 | $61,789 | $74,093 | $87,511 |
| - Approximate Cash Invested | ($220,000) | ($220,000) | ($220,000) | ($220,000) | ($220,000) | ($220,000) | ($220,000) | ($220,000) | ($220,000) | ($220,000) |
| = Net Profit | ($26,900) | $15,203 | $60,462 | $109,039 | $161,106 | $216,842 | $276,437 | $340,094 | $408,025 | $480,455 |
| Internal Rate of Return | -12.2% | 3.4% | 8.6% | 10.9% | 12.0% | 12.6% | 13.0% | 13.1% | 13.2% | 13.2% |
| Return on Investment | -12.2% | 6.9% | 27.5% | 49.6% | 73.2% | 98.6% | 125.7% | 154.6% | 185.5% | 218.4% |
*Information is not guaranteed and investors should do their own research, get professional advice and conduct due diligence prior to investing.