Question: Please show formulas and please use EXCEL E1) The Harris Company is evaluating the proposed acquisition of a spectrometer for the firm's R&D department. The

Please show formulas and please use EXCEL E1) The Harris Company isPlease show formulas and please use EXCEL

E1) The Harris Company is evaluating the proposed acquisition of a spectrometer for the firm's R&D department. The equipment's base price is $140,000, and it would cost another $30,000 to modify it for special use by the firm. The spectrometer, which falls into the MACRS 3-year class, would be sold after 3 years for $60,000. Use of the equipment would require a one-time increase in net operating working capital of $8,000 prior to the start of the project. The spectrometer would have no effect on revenues, but it is expected to save the firm $50,000 per year in before-tax operating costs, mainly labor. The firm's tax rate is 40%. a) What is the net cost of the spectrometer? (i.e., what is the Year 0 net cash flow?) b) What are the net annual operating cash flows in Years 1, 2, and 3? c) What is the additional (non-operating) termination cash flow in Year 3? d) If the firm's cost of capital is 12%, should the spectrometer be purchased

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!