Can you do it on excel and explain it

Yeatman Co. is considering an investment that will have the following sales, variable costs, and fixed operating costs: Year 1 Year 2 Year 3 Year 4 Unit sales 4,800 5,100 5,000 5,120 Sales price $22.33 $23.45 $23.85 $24.45 Variable cost per unit $9.45 $10.85 $11.95 $12.00 $32,500 $33,450 $34,950 $34,875 Fixed operating costs except depreciation Accelerated depreciation rate 33% 45% 15% 7% This project will require an investment of $15,000 in new equipment. The equipment will have no salvage value at the end of the project's four-year life. Yeatman pays a constant tax rate of 40%, and it has a weighted average cost of capital (WACC) of 11%. Determine what the project's net present value (NPV) would be when using accelerated depreciation. Determine what the project's net present value (NPV) would be when using accelerated depreciation. (Note: Round your intermediate calculations to the nearest whole number.) O $34,355 O $49,386 0 $42,944 O $51,533 Now determine what the project's NPV would be when using straight-line depreciation. Using the depreciation method will result in the highest NPV for the project. No other firm would take on this project if Yeatman turns it down. How much should Yeatman reduce the NPV of this project if it discovered that this project would reduce one of its division's net after-tax cash flows by $500 for each year of the four-year project? O $1,318 O $931 O $1,551 0 $1,706