Question: can someone help me ?? Chapter 12: Applying Excel: Exercise (Part 2 of 2) (Algo) 2. The company is considering a project involving the purchase

can someone help me ??
can someone help me ?? Chapter 12: Applying Excel: Exercise (Part 2
of 2) (Algo) 2. The company is considering a project involving the
purchase of new equipment. Change the data area of your worksheet to

Chapter 12: Applying Excel: Exercise (Part 2 of 2) (Algo) 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 128-1 and Exhibit 128-2 (Use appropriate factor(s) from the tables provided.) A B C 1 Chapter 12: Applying Excel 2 Data Example E 5 Cost of equipment needed 300,000 6 Working capital needed 55,000 7 Overhaul of equipment in four years 35.000 8 20,000 9 Annual revenues and costs 10 Sales revenues 370,000 11 Cost of goods sold 230,000 12 Out-of-pocket operating costs 50,000 13 Discount rate 4. U 3 4 to search Salvage value of the equipment in five years 14 66F 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.) Net present value c. The internal rate of return is between what two whole discount rates (eg, between 10% and 11%, between 11% and 12%, between 12% and 13%, between 13% and 14%, etc.)? The internal rate of retum us between % and % BD 2 Next > 2:40 P 66F to search a D

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!