Sarasota Pix currently uses a six-year-old molding machine to manufacture silver picture frames. The company paid $109,000 for the machine, which was state of the art at the time of purchase. Although the machine will likely last another ten years, it will need a $8,000 overhaul in four years. More important, it does not provide enough capacity to meet customer demand. The company currently produces and sells 15,000 frames per year, generating a total contribution margin of $106,500. Martson Molders currently sells a molding machine that will allow Sarasota Pix to increase production and sales to 20,000 frames per year. The machine, which has a ten-year life, sells for $144,000 and would cost $14,000 per year to operate. Sarasota Pixs current machine costs only $8,000 per year to operate. If Sarasota Pix purchases the new machine, the old machine could be sold at its book value of $5,000. The new machine is expected to have a salvage value of $20,000 at the end of its ten-year life. Sarasota Pix uses straight-line depreciation.

Use Excel or a similar spreadsheet application to calculate the new machines internal rate of return.