| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
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
| ||
| ||
|
[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 |