Solve all problems in the Excel file provided

Problem 2

You have been asked by the president of the Farr Construction Company to evaluate the proposed acquisition of a new earth mover. The mover's basic price is $220,000, and it would cost another $30,000 to modify it for special use. Assume that the mover falls into the MACRS 5-year class, it would be sold after 4 years for $60,000, and it would require an increase in net operating working capital (spare parts inventory) of $10,000. The earth mover would have no effect on revenues, but it is expected to save the firm $52,000 per year in before-tax operating costs, mainly labor. The firm's marginal federal-plus-state tax rate is 22 percent and the project's cost of capital is 8 percent. Evaluate the project using the NPV rule and the IRR rule.

Problem 2 - Evaluating a Cost Saving Project