Filkins Fabric Company is considering the replacement of its old, fully depreciated knitting machine. Two new models are available: Machine 190-3, which has a cost of $190,000, a 3-year expected life, and after-tax cash flows (labor savings and depreciation) of $87,000 per year; and Machine 360-6, which has a cost of $360,000, a 6-year life, and after-tax cash flows of $98,300 per year. Knitting machine prices are not expected to rise, because inflation will be offset by cheaper components (microprocessors) used in the machines. Assume that Filkins’s cost of capital is 14%. Should the firm replace its old knitting machine? If so, which new machine should it use? By how much would the value of the company increase if it accepted the better machine? What is the equivalent annual annuity for each machine?
Please explain how answer was found & if using Excel, please show formulas used.