Question: 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

Required information The Chapter 14 Form
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. . The company is considering a project involving the purchase of new equipment. Change the data area of your worksheet to match he following: Use Exhibit 148-1 and Exhibit 148-2. (Use appropriate factoris} from the tables provided.) A B C 1 Chapter 14: Applying Excel 2 3 Data 4 Example E 5 Cost of equipment needed $ 1?0.000 6 Working capital needed 35 40.000 7 Overhaul oi equipment in four years 35 10.000 3 Salvage value of the equipment in ve years $ 20.000 9 Annual revenues and posts: 10 Sales revenues $ 360.000 11 Costoi goods sold $ 240.000 12 Outoipocket operating costs $ ?0.000 13 Discount rate 13 % . What is the net present value of the project? [Negative amount should be indicated by a minus sign. Round your present value actor to 3 decimals and round all other intermediate calculations to nearest whole dollar.) _:l . The internal rate of return is between what two whole discount rates {e.g., between 10% and 11%, between 11% and 12%. between 12% nd 13%, between 13% and 14%, etc.)? -I -% . Reset the discount rate to 13%. Suppose the salvage value is uncertain. How large would the salvage value have to be to result in a ositive net present value

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!