Question: Year 1 Year 2 Year 3 Year 4 Year 5 A Potential gross rent 316,566.00 323,689.00 330,972.00 338,419.00 346,033.00 B Other income 7,669.00 7,842.00 8,018.00
|
|
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| A | Potential gross rent | 316,566.00 | 323,689.00 | 330,972.00 | 338,419.00 | 346,033.00 |
| B | Other income | 7,669.00 | 7,842.00 | 8,018.00 | 8,198.00 | 8,382.00 |
| C | Vacancies | 21,672.00 | 21,672.00 | 21,672.00 | 21,672.00 | 21,672.00 |
| D | EG Total income (a+b-c) | 302,563.00 | 309,859.00 | 317,318.00 | 324,945.00 | 332,743.00 |
| E | Operating expenses |
|
|
|
|
|
|
| Resident Manager | 20,777.00 | 21,244.00 | 21722.00 | 22,211.00 | 22,711.00 |
|
| Utilities | 1,166.00 | 1,192.00 | 1,219.00 | 1,246.00 | 1,274.00 |
|
| Property Insurance | 11,963.00 | 12,232.00 | 12,507.00 | 12,788.00 | 13,076.00 |
|
| Workers comp | 143.00 | 146.00 | 149.00 | 152.00 | 155.00 |
|
| Supplies and misc. | 765.00 | 782.00 | 800.00 | 818.00 | 836.00 |
|
| Landscaping/grounds | 3,374.00 | 3450.00 | 3,528.00 | 3,607.00 | 3,688.00 |
|
| Maint, & Repairs | 7,976.00 | 7,976.00 | 7,976.00 | 7,976.00 | 7,976.00 |
| F | Management Fees | 15,128.00 | 15,493.00 | 15866.00 | 16,247.00 | 16,637.00 |
| G | Prop taxes | 76,374.00 | 76,374.00 | 80,048.00 | 80,048.00 | 80,048.00 |
| H | Total Operating | 137,666.00 | 138,889.00 | 143,815.00 | 145,093.00 | 146,401.00 |
| I | Net Operating | 164,897.00 | 170,970.00 | 173,503.00 | 179,852.00 | 186,342.00 |
| Year | Loan | Principal | 8.5% Interest | Loan outstanding in the end |
| 1 | $1,500,000 | 75,000 | 127,500 | 1,425,000 |
| 2 | 1,425,000 | 75,000 | 121,125 | 1,350,000 |
| 3 | 1,350,000 | 75,000 | 114,750 | 1,275,000 |
| 4 | 1,275,000 | 75,000 | 108,375 | 1,200,000 |
| 5 | 1,200,000 | 75,000 | 102,000 | 1,125,000 |
|
|
|
|
|
|
- With information from the tables above, calculate the BTCFs for each of the 5 year holding period.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts