Question: Please answer the questions that are on the attachments. 2. The company' is considering a project involving the purchase of new equipment. Change the data

Please answer the questions that are on the attachments.


2. The company' is considering a project involving the purchase of new equipment. Change the data area ofyour woricsheetto match the following: 1 Chapter 8: Applylng Excel 2 3 Data 4 Example E 5 Cost of equipment needed $410,000 a Worldng capital needed $20,000 1 Overhaul of equlprnent in four years $45,000 8 Salvage value ofthe equipment In $20,000 9 Annual revenues and mate: 10 Sales revenues $435,000 11 Cost of goods sold $260.03.] 12 Outwoproottet operating mote $65,000 13 Dismunt rate 11% 14 e. What is the net present value ofthe project? (Negative amount should be Indicated by a mlnue elgn. Round all other Intermedlate oalculatlone to nearest Iwhole dollar.) c. Reset the discount rate to 11%. Suppose the salvage value is uncertain. How large would the salvage value have to be to result in a positive present value
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
