Chapter 13 Applying Excel (B) Saved Help Save & Exit Submit Check my work Required information 10 points 1 Chapter 13: Applying Excel 3 Data 4 Example E 5 Cost of equipment needed 6 Working capital needed 7 Overhaul of equipment in four years eBook S 160,000 S 40,000 10,000 S 35,000 Print References 8 Salvage value of the equipment in five years 9 Annual revenues and costs: Sales revenues 11 Cost of goods sold 10 S 370,000 S 260,000 S 70,000 12 Out-of-pocket operating costs 13 Discount rate 11 % 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.) ent value Chapter 13 Applying Excel (B) Help Save & Exlt Submit Check my work Required information 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.) 10 points t value eBook Print References C. The internal rate of return is between what two whole discount rates (e.g., between 10% and 11%, between 11% and 12%, between 12% and 13%, between 13% and 14%, etc.)? internal rate of retum is between % | and d. Reset the discount rate to 11%. Suppose the salvage value is uncertain How arge would the salvage value have to be to relit in a positive net present value? rate a positive p inimum salvage value required to g t value