In: Accounting
A firm purchased some office equipment for a total cost of $300000. The equipment generated net income of $100000 per year. The firm’s marginal tax rate is 20%. The equipment was sold at the end of the 4th year for a total of $75000. Assume that MARR is 12%/year. Calculate the net present worth (NPW)
8. If the firm used the MACRS depreciation, NPW =
A firm purchased some office equipment for a total cost of $300000. The equipment generated net income of $100000 per year. The firm’s marginal tax rate is 20%. The equipment was sold at the end of the 4th year for a total of $75000. Assume that MARR is 12%/year.
Calculate the net present worth (NPW)
If the firm used the MACRS depreciation, NPW = $ 29386
NPW = PV of Cash inflow - PV of cash outflow
>Initial investment = 300000
Cash flow statements
Years |
0 |
1 |
2 |
3 |
4 |
Initial investment |
(300000) |
||||
Annual net income |
100000 |
100000 |
100000 |
100000 |
|
-Tax exp@20% |
20000 |
20000 |
20000 |
20000 |
|
=Annual net income ( net of tax) |
80000 |
80000 |
80000 |
80000 |
|
+ Depreciation tax shield (calculation is below) |
19998 |
26670 |
8886 |
4446 |
|
= Operating cash flow |
99998 |
106670 |
88886 |
84446 |
|
Net salvage value (calculation is below) |
60000 |
||||
Net cash flow |
(300000) |
99998 |
106670 |
88886 |
144446 |
PV of $1 factor @12% rate |
1 |
0.893 |
0.7972 |
0.712 |
0.6355 |
PV of CF |
(300000) |
89283.91 |
85036.26 |
63,267.30 |
91798.32 |
NPW |
$ 29386 |
Depreciation tax shield
Depreciation schedule under MACRS (assume 3 years class property )
Years and MACRS rate |
1 = 33.33% |
2 = 44.45% |
3 = 14.81% |
4 = 7.41% |
Depreciation exp =cost * MACRS rate |
99990 |
133350 |
44430 |
22230 |
Depreciation tax shield =depre. Exp. * tax rate |
19998 |
26670 |
8886 |
4446 |
Net salvage value
Salvage value at end of 4 years = 75000 (inflow)
Book value at end of 4 years = 0 (fully depreciated)
Taxable gain = 75000
Tax expenses on gain = 75000 * 20% = 15000 (outflow)
Net salvage value = 75000 - 15000 = 60000