Question

(Please show the formulas you used in excel i cant get the right numbers :// if you could post one with numbers then show the formulas that would be awesome!!)

NOK Plastics is considering the acquisition of a new plastic injection-molding machine to make a line of plastic fittings. The cost of the machine and dies is $125,000. Shipping and installation is another $8,000. NOK estimates it will need a $10,000 investment in net working capital initially, which will be recovered at the end of the life of the equipment. Sales of the new plastic fittings are expected to be $350,000 annually. Cost of goods sold are expected to be 50% of sales. Additional operating expenses are projected to be $115,000 per year over the machine’s expected 5-year useful life. The machine will depreciated using a 5-year MACRS class life. The equipment will be sold at the end of its useful life (5 years) for $35,000. The tax rate is 25% and the relevant discount rate is 15%. Calculate the net present value (NPV), internal rate of return (IRR), payback period (PB), and profitability index (PI) and state whether the project should be accepted.

Answer 1