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

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 can provide a written solution that would be helpful too but Excel is easier to follow up! thanks and I'm waiting for your answer! please solve C, D, E, and F using Excel which will be

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!