Question: please solve C, D, E, and F using Excel which will be easier, and show how you did it on Excel, please!! and if you
ABC Folding Box Company Inc. is considering a project, which is the replacement of the existing gluing machine with the new one, purchasing a new gluing machine. The new gluing machine costs $50,000 and requires installation costs of $2,500. This outlay would be partially offset by the sale of the existing gluer. The existing gluer is four years old, being depreciated using a five-year recovery schedule and can currently be sold for $15,000. Over its five-year life, the new machine will continue to have the same sales figure with the existing one but reduces operating costs by $17,000 per year. Training costs of employees who will operate the new machine will be a one-time cost of $5,000 which should be included in the initial outlay. The new machine will be depreciated using a five-year recovery period. The firm has a 15 percent cost of capital and a 40 percent tax on any income and capital gains. A) Calculate the initial outlay for the project. Initial outlay for the project - machine cost + installation costs + employees operate cost- sales value of old machine Initial outlay for the project - 50000+5000+2500-15000 - 42500 B) What is the tax effect of the sale of the existing asset? Book value of existing asset - 10000 X (11.524576) % - $1728 sale value = 15000 tax effect of the sale of the existing asset = (15000-1728) X 40% - (15000 - 1728) X0.04 -$5308.80 C) Calculate the payback period for the project. D) Calculate the present value of the project's annual cash inflows. E) Calculate the net present value of the project. F) Try to guess the approximate internal rate of return (IRR) for the project. Do not calculate the exact number
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
