! Required information The Chapter 14 Form worksheet is to be used to create your own worksheet version of Example E and Exhibit 14-8 in the text. 2. The company is considering a project involving the purchase of new equipment. Change the data area of your worksheet to match the following: Use Exhibit 14B-1 and Exhibit 14B-2. (Use appropriate factor(s) from the tables provided.) B 1 Chapter 14: Applying Excel 2 $ 70,000 $ $ 3 Data 4 Example E 5 Cost of equipment needed 6 Working capital needed 7 Overhaul of equipment in four years 8 Salvage value of the equipment in five years 9 Annual revenues and costs: 10 Sales revenues 11 Cost of goods sold 12 Out-of-pocket operating costs 13 Discount rate 60,000 10,000 30,000 $ $ $ 385,000 270,000 90,000 18 % $ a. What is the net present value of the project? (Negative amount should be indicated by a minus sign. Round your present value factor to 3 decimals and round all other intermediate calculations to nearest whole dollar.) Net present value b. If the net present value is (negative), would the company pursue this project? (Click to select) c. Using your Excel spreadsheet, adjust the discount rate in the data assumption area until the calculated Net present value is close to zero. The internal rate of return (IRR) is the discount rate needed for the present value of cash outflows to equal the present value of cash inflows. Our excel spreadsheet is not sophisticated enough to determine the exact discount rate. Therefore, enter your IRR answer as between two whole number discount rates (e.g., between 10% and 11%, between 13% and 14%, etc.)? The internal rate of return is between % and %