
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
| Purchase price: | $1,000,000 | |
| NOI in Year 1: | $120,000 | |
| NOI growth rate: | 3% per year | |
| Depreciation: | $30,000 per year | |
| Initial down payment: | 25% of purchase price | |
| Loan terms: | 30 year fixed at 4.375%, monthly compounding | |
| Interest payable in Year 1: | $32,596 | |
| Interest payable in Year 2: | $32,014 | |
| Interest payable in Year 3: | $31,437 | |
| Interest payable in Year 4: | $30,836 | |
| Investor's marginal tax rate: | 34% | |
| Investor's capital gains tax rate: | 20% | |
| Recaptured depreciation tax rate: | 35% | |
| Required return on equity capital (after tax): | 14% | |
| Investment horizon: | 4 years | |
| Market value at the end of 4th year: | 922,368 | |
| Costs of sale: | 8% of sales price | |
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
| Computation of Income Taxes Payable for Boat Club Luxury Apartments | ||||
| Year 1 | Year 2 | Year 3 | Year 4 | |
| NOI (growth rate = 3%) | $120,000 | $123,600 | $127,308 | $131,127 |
| Less: Depreciation | ($30,000) | ($30,000) | ($30,000) | ($30,000) |
| Less: Interest | ($32,596) | ($32,014) | ($31,437) | ($30,836) |
| Taxable income | $57,404 | $61,586 | $65,871 | $70,291 |
| × Income tax rate | 0.34 | 0.34 | 0.34 | 0.34 |
| Income taxes payable | $19,517 | $20,939 | $22,396 | $23,899 |
| ||
| ||
|
| ||
| ||
|
| Cash Flow After Taxes (CFAT) Computation for Boat Club Luxury Apartments | ||||
| Year 1 | Year 2 | Year 3 | Year 4 | |
| NOI | $120,000 | $123,600 | $127,308 | $131,127 |
| Less: Debt service | ($44,940) | ($44,940) | ($44,940) | ($44,940) |
| Pre-tax cash flow | $75,060 | $78,660 | $82,368 | $86,187 |
| Less: Taxes payable | ($19,517) | ($20,939) | ($22,396) | ($23,899) |
| CFAT | $55,543 | $57,721 | $59,972 | $62,288 |
| ||
| ||
|
| ||
| ||
|
[CF] [2nd] [CLR WORK]
600,000 [+/–] [ENTER] [↓]
70,000 [ENTER] [↓] [↓]
50,000 [ENTER] [↓] [↓]
565,000 [ENTER] [↓[↓] (note: CF3 = 65,000 + 500,000)
[IRR] [CPT] = 5.0056 percent
| ||
| ||
|
NPV = -600,000 + 64,814.81 + 42,866.94 + 51,599.09 + 238,149.67[CF] [2nd] [CLR WORK]
600,000 [+/–] [ENTER] [↓ ]
70,000 [ENTER] [↓] [↓]
50,000 [ENTER] [↓] [↓]
365,000 [ENTER] [↓[↓] (note: CF3 = 65,000 + 300,000)
[NPV] {8} [ENTER] [↓]
[CPT] = -CAD202,569.48
| NPV | IRR |
| ||||
| ||||
|
[CF] [2nd] [CLR WORK]
-200,000 [+/–] [ENTER] [↓]
90,000 [ENTER] [↓] [↓]
55,000 [ENTER] [↓] [↓]
35,000 [ENTER] [↓] [↓]
125,000 (note: CF3 = 25,000 + 100,000)
[NPV] {8.5} [ENTER] [↓]
[CPT] = GBP 47,267.91
[IRR] [CPT] = 18.39%
| ||
| ||
|
Net selling price = sales price – cost of sale= $850,000 - 65,000 = $785,000
Adjusted basis = cost - accumulated depreciation = $550,000 - 120,000 = $430,000
= capital gains tax rate × (total gain - recaptured depreciation) = 0.20 × (355,000 – 120,000) = 0.20 × 235,000 = $47,000
= tax on recaptured depreciation + tax on long-term capital gains = $33,600 + $47,000 = $80,600
| ||
| ||
|
| Taxes Payable Computation: | ||||
| Year-1 | Year-2 | Year-3 | Year-4 | |
| NOI (g = 5%) | $75,000 | $78,750 | $82,688 | $86,822 |
| Less depreciation | (10,000) | (10,000) | (10,000) | (10,000) |
| Less interest | (9,000) | (9,000) | (9,000) | (9,000) |
| Taxable income | $56,000 | $59,750 | $63,688 | $67,822 |
| times tax rate | ´0.36 | ´0.36 | ´0.36 | ´0.36 |
| Income taxes payable | $20,160 | $21,510 | $22,928 | $24,416 |
| CFATt Computation: | ||||
| Year-1 | Year-2 | Year-3 | Year-3 | |
| NOI (g = 5%) | $75,000 | $78,750 | $82,688 | $86,822 |
| Less debt service | (12,000) | (12,000) | (12,000) | (12,000) |
| Before tax cash flow | $63,000 | $66,750 | $70,688 | $74,822 |
| Less taxes payable | (20,160) | (21,510) | (22,928) | (24,416) |
| CFAT | $42,840 | $45,240 | $47,760 | $50,406 |
| Purchase Price | Cash Flow 1 | Cash Flow 2 |
| |||||
| |||||
|
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
| 欢迎光临 CFA论坛 (http://forum.theanalystspace.com/) | Powered by Discuz! 7.2 |