In: Accounting
(Estimated time allowance: 40-50 minutes) Easy-Chair Corp. is considering replacing its existing equipment that is used to produce comfort recline chairs. This existing equipment was purchase 2 years ago at a base price of $100,000. Installation costs at the time for this old equipment were $5,000. The existing equipment is considered a 5-year class for MACRS. The existing equipment can be sold today for $40,000 and for $0 in 3 years. The new equipment has a purchase price of $200,000 and is also considered a 5-year class for MACRS. Installation costs for the new equipment are $10,000. It is estimated that this equipment can be sold in 3 years (end of project) for $70,000. This new equipment is more efficient than the existing one and thus savings before taxes using the new machine are $20,000 a year. This new equipment will also require additional working capital today of $12,000; this investment will be recovered at the end of the project in year 3. The company's marginal tax rate is 20% and the cost of capital is 10%.
What is the NPV of this replacement project? The following 6 questions reach the value for the answer.
MACRS Fixed Annual Expense Percentages by Recovery Class |
|||||
Year |
3-Year |
5-Year |
7-Year |
10-Year |
15-Year |
1 |
33.33% |
20.00% |
14.29% |
10.00% |
5.00% |
2 |
44.45% |
32.00% |
24.49% |
18.00% |
9.50% |
3 |
14.81% |
19.20% |
17.49% |
14.40% |
8.55% |
4 |
7.41% |
11.52% |
12.49% |
11.52% |
7.70% |
5 |
11.52% |
8.93% |
9.22% |
6.93% |
|
6 |
5.76% |
8.93% |
7.37% |
6.23% |
|
7 |
8.93% |
6.55% |
5.90% |
||
8 |
4.45% |
6.55% |
5.90% |
||
9 |
6.56% |
5.91% |
|||
10 |
6.55% |
5.90% |
|||
11 |
3.28% |
5.91% |
|||
12 |
5.90% |
||||
13 |
5.91% |
||||
14 |
5.90% |
||||
15 |
5.91% |
||||
16 |
2.95% |
For your answer, round to the nearest dollar, do not enter the $ sign, use commas to separate thousands, use a negative sign in front of first number is the cash flow is negative (do not use parenthesis to indicate negative cash flows). For example, if your answer is $3,005.87 then enter 3,006; if your answer is -$1,200.25 then enter -1,200
1. What is the initial outlay (I0) for this project - the project cash flows at time = 0?
2. What is the free cash flow (FCF) for year 1 of this replacement project?
3. What is the free cash flow (FCF) for year 2 of this replacement project?
4. What is the net operating profit plus incremental depreciation for year 3 of this replacement project?
5. What is the free cash flow (FCF) for year 3 of this replacement project?
6. What is the NPV of this replacement project?
0 | 1 | 2 | 3 | ||||
Annual savings for taxes | $ 20,000 | $ 20,000 | $ 20,000 | ||||
Incremental depreciation: | Accu: Depn: | Book Value | |||||
Depreciation of new equipment [on $210,000] | $ 42,000 | $ 67,200 | $ 40,320 | $ 149,520 | $ 60,480 | ||
Depreciation of old equipment [on $105,000] | $ 20,160 | $ 12,096 | $ 12,096 | $ 98,952 | $ 6,048 | ||
-Incremental depreciation: | $ 21,840 | $ 55,104 | $ 28,224 | ||||
=Incremental NOI | $ (1,840) | $ (35,104) | $ (8,224) | ||||
-Tax at 20% | $ (368) | $ (7,021) | $ (1,645) | ||||
=Incremental NOPAT | $ (1,472) | $ (28,083) | $ (6,579) | ||||
+Incremental depreciation | $ 21,840 | $ 55,104 | $ 28,224 | ||||
=Incremental OCF | $ 20,368 | $ 27,021 | $ 21,645 | ||||
-Capital expenditure-Cost of new equipment | $ 210,000 | ||||||
+After tax salvage value of old equipment [see workings given below] | $ 42,080 | ||||||
+After tax salvage value of new equipment = 70000-(70000-60480)*20% = | $ 68,096 | ||||||
-Loss of tax shield on loss on scrapping of old equipment (6048*20%) | $ 1,210 | ||||||
-Change in NWC | $ 12,000 | $ (12,000) | |||||
=FCF | $ (179,920) | $ 20,368 | $ 27,021 | $ 100,531 | |||
PVIF at 10% | 1 | 0.90909 | 0.82645 | 0.75131 | |||
PV of FCF | $ (179,920) | $ 18,516 | $ 22,331 | $ 75,531 | |||
NPV of the replacement | $ (63,542) | ||||||
ANSWERS: | |||||||
1] | Initial outlay = 210000-42080+12000 = | $ 179,920 | |||||
2] | FCF for year 1 | $ 20,368 | |||||
3] | FCF for year 2 | $ 27,021 | |||||
4] | OCF for year 3 | $ 21,645 | |||||
5] | FCF for year 3 | $ 100,531 | |||||
WORKINGS: | |||||||
1] | After tax salvage value of old equipment: | ||||||
Salvage value | $ 40,000 | ||||||
Book value = 105000*(19.2%+11.52%+11.52%+5.76%) = | $ 50,400 | ||||||
Loss on sale | $ 10,400 | ||||||
Tax shield on loss at 20% | $ 2,080 | ||||||
After tax salvage value of old equipment: | $ 42,080 |