Excel please!

CHAPTER 6 Capital Budgeting: Valuing Business Cash Flows 213 5. (Depreciation) You are considering the following investment: 3 Year 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 Tax (34%) 8 Net operating profit after tax 9Capital investment (no salvage value) -10,500 10 Add back depreciation 11 Free cash flow 0 3 11% 13 Discount rate 14 NPV a. Assuming that the investment can be depreciated using 7-year straight-line depreciation with no salvage value, calculate the project NPV ghr-line depreiationha t usi What will be the company's gain in present value if it uses a 7-year modified accelerated depreciation (MACRS) schedule, given below: b. 17 Year 18 MACRS depreciation | 8.93% | 8,93% 14.29% 24.49%|17.49% | 12.49%) 8.93% | 4.45%