Your firm is considering the purchase of a new piece of equipment for $20,000.

The equipment will be straight line depreciated over four years. The salvage value (final book value) is $5,000. The equipment will increase the earnings before interest, tax and depreciation by $8000 for each of the four years the equipment is used. The tax rate is 21 percent and the required rate of return is 10 percent.

Should the equipment be purchased?

NPV = 3448.62

NPV = 5944.89

NPV = 5227.72

I am struggling to understand how to get the correct answer using excel spreadsheet?