Net Present Value and Competing Projects For discount factors use Exhibit 12B.1 and Exhibit 12B.2. Spiro Hospital is investigating the possibility of investing in new dialysis equipment. Two local manufacturers of this equipment are being considered as sources the equipment. After-tax cash inflows for the two competing projects are as follows: Both projects require an initial investment of $560,000. In both cases, assume that the equipment has a life of 5 years with no salvage value. Required: Download Excel spreadsheet Round present value calculations and your final answers to the nearest dollar. 1. Assuming a discount rate of 14%, compute the net present value of each piece of equipment. Puro equioment: Both projects require an initial investment of $560,000. In both cases, assume that the equipment has a life of 5 years with no salvage value. Required: Download Excel spreadsheet Round present value calculations and your final answers to the nearest dollar. 1. Assuming a discount rate of 14%, compute the net present value of each piece of equipment. Puro equipment: $ Briggs equipment: $ Since the NPV of the Briggs equipment is than that of the Puro equipment, Briggs should chosen. The data analytics types are 2. A third option has surfaced for equipment purchased from an out-of-state supplier. The cost is also $560,000, but this equipment will produce even cash flows over its 5-year life. What must the annual cash flow be for this equipment to be selected over the other two? Assume a 14% discount rate. $ per year