Depreciation Methods
Wendy's boss wants to use straight-line depreciation for the new expansion project because he said it will give higher net income in earlier years and give him a larger bonus. The project will last 4 years and requires $1,800,000 of equipment. The company could use either straight-line or the 3-year MACRS accelerated method. Under straight-line depreciation, the cost of the equipment would be depreciated evenly over its 4-year life. (Ignore the half-year convention for the straight-line method.) The applicable MACRS depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%. The project cost of capital is 8%, and its tax rate is 25%.
What would the depreciation expense be each year under each method? Enter your answers as positive values. Do not round intermediate calculations. Round your answers to the nearest dollar.
Year |
Scenario 1 (Straight Line) |
Scenario 2 (MACRS) |
1 | $ | $ |
2 | $ | $ |
3 | $ | $ |
4 | $ | $ |
Which depreciation method would produce the higher NPV, and how much higher would it be? Do not round intermediate calculations. Round your answer to the nearest cent.
The NPV under _______will be higher by $ .
Formulas Used:-
a. | Year | MACRS | Straight line |
1 | =1800000*33.33% | =1800000/4 | |
2 | =1800000*44.45% | =1800000/4 | |
3 | =1800000*14.81% | =1800000/4 | |
4 | =1800000*7.41% | =1800000/4 | |
b. | Year | Tax saving (Macrs) | Tax Savings(Strigh line) |
1 | =C4*25% | =D4*25% | |
2 | =C5*25% | =D5*25% | |
3 | =C6*25% | =D6*25% | |
4 | =C7*25% | =D7*25% | |
NPV | =NPV(8%,C10:C13) | =NPV(8%,D10:D13) | |
Diif. | =C15-D15 |
Hence MACRS depriciation method Have Higher NPV as compred to straightline method.
The NPV under MACRSwill be higher by $ 15,164.45.
Get Answers For Free
Most questions answered within 1 hours.