In: Finance
YEAR 0 | YEAR 1 | YEAR 2 | YEAR 3 | |
MACRS | ||||
DEPRECIATION RATE | 33.33% | 44.45% | 14.81% | 7.41% |
A fast-food company invests $2.2 million to buy machines for making Slurpees. These can be depreciated using the MACRS schedule shown above. If the cost of capital is 10%, what is the increase in the net present value (NPV) of the product gained by using MACRS depreciation over straight-line depreciation for three years? A) $28,559 B) $47,599 C) $76,158 D) $190,321
Please help me, I'm not able to use excel in my class so if I could get a step by step that would help me immensely
Under straight line method depreciation for each year is same | |||||||
Depreciation under straight line | $2.2 million/3 | ||||||
Depreciation under straight line | $0.73 | ||||||
Calculation of depreciation under MACRS | |||||||
Year 0 | $0.73 | 2.2*33.33% | |||||
Year 1 | $0.98 | 2.2*44.45% | |||||
Year 2 | $0.33 | 2.2*14.81% | |||||
Year 3 | $0.16 | 2.2*7.41% | |||||
Calculation of incremental depreciation by using MACRS over straight line depreciation | |||||||
Year | MACRS | Straight line | Incremental | Discount factor @ 10% | Present value | ||
0 | $0.73 | $0.00 | $0.73 | 1.00000 | 1/(1.1^0) | $0.7332600 | |
1 | $0.98 | $0.73 | $0.24 | 0.90909 | 1/(1.1^1) | $0.2223333 | |
2 | $0.33 | $0.73 | -$0.41 | 0.82645 | 1/(1.1^2) | -$0.3367879 | |
3 | $0.16 | $0.73 | -$0.57 | 0.75131 | 1/(1.1^3) | -$0.4284848 | |
Net present value | $0.1903206 | ||||||
Net present value (Total) | $190,321 | ||||||
Thus, net present value of product gained is $190,321 | |||||||