2. The company is considering a project involving the purchase of new equipment Change the data area of your worksheet t

[answerhappygod]

2 The Company Is Considering A Project Involving The Purchase Of New Equipment Change The Data Area Of Your Worksheet T 1 (34.96 KiB) Viewed 26 times

2 The Company Is Considering A Project Involving The Purchase Of New Equipment Change The Data Area Of Your Worksheet T 2 (26.11 KiB) Viewed 26 times

2 The Company Is Considering A Project Involving The Purchase Of New Equipment Change The Data Area Of Your Worksheet T 3 (29.48 KiB) Viewed 26 times

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 148-1 and Exhibit 148-2 (Use appropriate factor(s) from the tables provided.) B C $ $ A 1 Chapter 14: Applying Excel 2 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 250,000 45,000 15.000 40.000 $ $ $ $ $ 385,000 230,000 80,000 17%
Return to Gestion Required information 5 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 Answer is not complete Net presenta c. The internal rate of return is between what two whole discount ratesleg, between 10% and 11%, between 11 and 12 between 12% and 13%, between 13% and 14%, etc.)? Answer is complete but not entirely correct. The manorum an c w Prev Next > 23 ty
Return to ton 1 Required information C. The internal rate or return is between what two whole discount rates (eg., between 10% and it between 11 and 12 between 12 and 13%, between 13% and 14%, etc.)? 15 points Answer is complete but not entirely correct. The internal rate ofrecum in between 10 % und 11 d. Reset the discount rate to 17%. Suppose the salvage value is uncertain How large would the salvage value have to be to result in a positive net present value? Answer is complete but not entirely correct. Minimum salvage value required to generate a posve present value 138.244 Mc Gran Prev 1 of 1 !!! Next