This is a static proforma, easily create your own dynamic proformas for FREE at www.PropertyTracker.com.
Co-living - Currently Tenanted
Mesa, AZ 85201
7 bedrooms 2 bathrooms 1962 year built
Washer/Dryer and All furniture included!
| Projected Income | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 |
|---|---|---|---|---|---|---|---|---|---|---|
| Projected Rent | $61,200 | $63,036 | $64,927 | $66,875 | $68,881 | $70,948 | $73,076 | $75,268 | $77,526 | $79,852 |
| Vacancy Losses | ($4,896) | ($5,043) | ($5,194) | ($5,350) | ($5,510) | ($5,676) | ($5,846) | ($6,021) | ($6,202) | ($6,388) |
| Operating Income | $56,304 | $57,993 | $59,733 | $61,525 | $63,371 | $65,272 | $67,230 | $69,247 | $71,324 | $73,464 |
| Estimated Expenses | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 |
|---|---|---|---|---|---|---|---|---|---|---|
| Property Taxes | ($1,896) | ($1,953) | ($2,011) | ($2,072) | ($2,134) | ($2,198) | ($2,264) | ($2,332) | ($2,402) | ($2,474) |
| Insurance | ($1,896) | ($1,953) | ($2,011) | ($2,072) | ($2,134) | ($2,198) | ($2,264) | ($2,332) | ($2,402) | ($2,474) |
| Management Fees | ($9,009) | ($9,279) | ($9,557) | ($9,844) | ($10,139) | ($10,443) | ($10,757) | ($11,079) | ($11,412) | ($11,754) |
| Leasing/Advertising Fees | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Association Fees | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Maintenance | ($1,836) | ($1,891) | ($1,948) | ($2,006) | ($2,066) | ($2,128) | ($2,192) | ($2,258) | ($2,326) | ($2,396) |
| Other | ($9,600) | ($9,888) | ($10,185) | ($10,490) | ($10,805) | ($11,129) | ($11,463) | ($11,807) | ($12,161) | ($12,526) |
| Operating Expenses | ($24,237) | ($24,964) | ($25,713) | ($26,484) | ($27,279) | ($28,097) | ($28,940) | ($29,808) | ($30,702) | ($31,623) |
| 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 | $32,067 | $33,029 | $34,020 | $35,041 | $36,092 | $37,175 | $38,290 | $39,439 | $40,622 | $41,841 |
| - Mortgage Payments | ($26,614) | ($26,614) | ($26,614) | ($26,614) | ($26,614) | ($26,614) | ($26,614) | ($26,614) | ($26,614) | ($26,614) |
| = Cash Flow | $5,453 | $6,415 | $7,406 | $8,427 | $9,478 | $10,561 | $11,676 | $12,824 | $14,008 | $15,226 |
| + Principal Reduction | $4,069 | $4,336 | $4,620 | $4,924 | $5,247 | $5,591 | $5,958 | $6,350 | $6,766 | $7,211 |
| + Appreciation | $28,440 | $30,146 | $31,955 | $33,872 | $35,905 | $38,059 | $40,343 | $42,763 | $45,329 | $48,049 |
| = Gross Equity Income | $37,962 | $40,897 | $43,982 | $47,223 | $50,630 | $54,211 | $57,977 | $61,937 | $66,103 | $70,486 |
| Capitalization Rate | 6.4% | 6.2% | 6.0% | 5.9% | 5.7% | 5.5% | 5.4% | 5.2% | 5.1% | 4.9% |
| Cash on Cash Return | 4.0% | 4.7% | 5.4% | 6.1% | 6.9% | 7.7% | 8.5% | 9.3% | 10.2% | 11.1% |
| Return on Equity | 25.1% | 22.0% | 19.8% | 18.1% | 16.8% | 15.7% | 14.8% | 14.0% | 13.4% | 12.9% |
| Loan Analysis | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 |
|---|---|---|---|---|---|---|---|---|---|---|
| Market Value | $502,440 | $532,586 | $564,542 | $598,414 | $634,319 | $672,378 | $712,721 | $755,484 | $800,813 | $848,862 |
| - Loan Balance | ($351,431) | ($347,095) | ($342,475) | ($337,551) | ($332,304) | ($326,713) | ($320,754) | ($314,405) | ($307,638) | ($300,428) |
| = Equity | $151,009 | $185,491 | $222,067 | $260,863 | $302,015 | $345,665 | $391,966 | $441,079 | $493,175 | $548,434 |
| Loan-to-Value Ratio | 69.9% | 65.2% | 60.7% | 56.4% | 52.4% | 48.6% | 45.0% | 41.6% | 38.4% | 35.4% |
| Potential Cash-Out Refi | $100,765 | $132,232 | $165,612 | $201,021 | $238,583 | $278,427 | $320,694 | $365,531 | $413,093 | $463,548 |
| Sale Analysis | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 |
|---|---|---|---|---|---|---|---|---|---|---|
| Equity | $151,009 | $185,491 | $222,067 | $260,863 | $302,015 | $345,665 | $391,966 | $441,079 | $493,175 | $548,434 |
| - Closing Costs | ($35,171) | ($37,281) | ($39,518) | ($41,889) | ($44,402) | ($47,066) | ($49,890) | ($52,884) | ($56,057) | ($59,420) |
| = Proceeds After Sale | $115,838 | $148,210 | $182,549 | $218,974 | $257,612 | $298,599 | $342,076 | $388,195 | $437,118 | $489,014 |
| + Cumulative Cash Flow | $5,453 | $11,868 | $19,274 | $27,701 | $37,178 | $47,739 | $59,415 | $72,239 | $86,247 | $101,473 |
| - Approximate Cash Invested | ($137,164) | ($137,164) | ($137,164) | ($137,164) | ($137,164) | ($137,164) | ($137,164) | ($137,164) | ($137,164) | ($137,164) |
| = Net Profit | ($15,873) | $22,914 | $64,659 | $109,511 | $157,627 | $209,174 | $264,327 | $323,271 | $386,201 | $453,323 |
| Internal Rate of Return | -11.6% | 8.2% | 14.2% | 16.6% | 17.6% | 17.9% | 18.0% | 17.9% | 17.8% | 17.5% |
| Return on Investment | -11.6% | 16.7% | 47.1% | 79.8% | 114.9% | 152.5% | 192.7% | 235.7% | 281.6% | 330.5% |
*Information is not guaranteed and investors should do their own research, get professional advice and conduct due diligence prior to investing.
Learn How to Read a Performa