Problem:
XYZ Co. is considering the purchase of a new machine. The machine will cost $250,000 and requires installation costs of $25,000. The existing machine can be sold currently for $25,070. It was purchased three years ago for $83,000 and depreciated using MACRS (you can find the table in the D.Sharing) for five years. It can be operated for another four years. Its market value at that time, if sold, would be $14,000. The new machine has expected life of five years and expected to provide operating cash savings of $88,000 a year for 2 years and $50,000 a year for the next two years before depreciation and taxes (EBD&T). After four years the new machine can be sold for $12,750. To support the increased business resulting from the purchase of new machine, A/R will increase by $12,000; inventory will increase by $25,000 and current liabilities by $41,000. (for the sake of the simplicity the increase will be only at the beginning of the project) The cost of capital is 17% and the tax rate is 40%.
1) Determine the II (Initial Investment)
2) Determine the PP (Payback Period)
3) Determine the NPV, IRR and MIRR
4) Make a recommendation to accept or reject the new investment.