Can I get help with the formula to calculate the bottom portion, please? I have all of it, except for the last portion. I tried doing the PV Factor, but the answer was incorrect. Please help. Thanks.

eBook Charlene is evaluating a capital budgeting project that should last for 4 years. The project requires $275,000 of equipment and is eligible for 100% bonus depreciation. She is unsure whether immediately expensing the equipment or using straight-line depreciation is better for the analysis. 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 company's WACC is 8%, and its tax rate is 25%. a. What would the depreciation expense be each year under each method? Enter your answers as positive values. Round your answers to the nearest dollar. Year Scenario 1 (Straight-Line) Scenario 2 (Bonus Depreciation) 275,000 0 0 1 $ $ $ $ $ $ 68,750 68,750 2 3 $ 0 68,750 68,750 4 $ 0 b. Which depreciation method would produce the higher NPV? Bonus Depreciation How much higher would the NPV be under the preferred method? Do not round intermediate calculations. Round your answer to the nearest dollar. A B C D E 1 WACC 0.08 2 Depreciation 275,000! 3 Year Life 4 5 SLM Depreciation 68750 6 Bonus Depreciation 275,000 7 8 Straight Line Scenerio 2 (Bonsu 9 Year Scenerio 1 (Straight Line) Depreciation) 10 0 275,000 11 1 68750 2 68750 13 3 68750 14 4 68750 15 5 68750 16 17 Bonus Depreciation Scenerio 1 (Straight Line) 18 Year Scenerio 1 (Straight Line) Tax Rate @ 25% PVF @8% PV of Tax Savings 19 0 0 0 1 0 20 1 68750 17187.5 21 2 68750 17187.5 22 3 68750 17187.5 23 4 68750 17187.5 24 NPV WN 25 26 27 Year Bonus Depreciation Scenerio B ( Bonus Depreciation) Scenerio 1 (Straight Line) Tax Rate @ 25% PVF @8% PV of Tax Savings 0 275,000 68750 1 68750 1 28 29 0 30 0 Nim 31 0 32 4 0 33 NPV 68750