Excel Project 4 Knight Company is considering the purchase of new automated manufacturing equipment that would cost $150,000. The equipment would save $42,500 in labor costs per year over its six- year life. At the end of the fourth year, the equipment would require an overhaul that would cost $25,000. The equipment would have a $7,500 salvage value at the end of its life. Knight's cost of capital is 12 percent. Required Prepare a spreadsheet similar to the one following to calculate net present value, the profitability index, and the internal rate of return. The numbers should be formatted as they are below