Problem solved in Excel only! Rating will be given.

B D E F G . I J K L M N 0 Q R S T U V O 1 Ch 6 Q5 2 DEPRECIATION SCHEDULE 0 1 3,000 2 3,000 3 3,000 4 4 2,500 5 2,500 6 2,500 7 2,500 5. (Depreciation) You are considering the following investment: A B C D E F G H 3 Year 0 1 2 3 4 5 6 7 4 Earnings before depreciation and taxes 3,000 3,000 3,000 2,500 2,500 2,500 2,500 5 Depreciation 6 Earnings before taxes 7 Tax (34%) Net operating profit after tax 9 Capital investment (no salvage value) -10,500 0 10 Add back depreciation 11 Free cash flow 12 13 Discount rate 11% 14 NPV -10,500 0 11% 3 Section a. straight line depreciation 4 Year 5 Earnings before depreciation and taxes 6 Depreciation 7 Earnings before taxes 8 Tax (34%) 9 Net operating profit after tax 10 Capital investment (no salvage value) 11 Add back depreciation 12 Free cash flow 13 14 Discount rate 15 NPV 16 17 Section b. MACRS depreciation 18 Year 19 MACRS depreciation 20 Earnings before depreciation and taxes 21 Depreciation 22 Earnings before taxes 23 Tax (34%) 24 Net operating profit after tax 25 Capital investment (no salvage value) 26 Add back depreciation 27 Free cash flow 28 29 Discount rate 30 NPV 31 a. 0 1 14.29% 3,000 2 24.49% 3,000 3 17.49% 3,000 4 12.49% 2,500 5 8.93% 2,500 6 8.93% 2,500 7 8.93% 2,500 8 4.45% 0 Assuming that the investment can be depreciated using 7-year straight-line depreciation with no salvage value, calculate the project NPV. b. What will be the company's gain in present value if it uses a 7-year modified accelerated depreciation (MACRS) schedule, given below: -10,500 0 A 17 Year 18 MACRS depreciation B 0 F G 1 2 3 4 5 14.29% 24.49% 17.49% 12.49% 8.93% O H 6 8.93% 7 8.93% J 8 4.45% 11%