Chapter 14: Applying Excel B 1 2 5 $ 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 Out-of-pocket operating costs 13 Discount rate $ $ $ $ 290.000 50,000 20.000 30,000 $ $ $ 420,000 245,000 90,000 14% 12 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.) 5 (2.885) c. The internal rate of return is between what two whole discount rates leg, between 10% and 1% between 11% and 12% between 125 and 13%, between 13 and 14% etc.)? Theme frame be 11 and 121 d. Reset the discount rate to 14%. Suppose the salvage value is uncertain. How large would the salvage value have to be to result in a positive net present value? Alinimum age was lequel gende positive present value 5 85,556 Required information w What is the nel 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) $ 12.886) The internal rate of return is between what two whole discount rates (eg, between 10 and 11%, between it and 12% between 12% and 13%, between 13% and 14%, etc.)? Tale of our betoon 11 % 121 dReset the discount rate to 14% Suppose the salvage value is uncertain How large would the salvage value have to be to result in a positive net present value? Musugo al required to generate a poplive presente $ 85 556