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 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
Get step-by-step solutions from verified subject matter experts
