How do you calculate Annual net cash inflows and Net present Value?
The Sweetwater Candy Company would like to buy a new machine that would automatically "dip" chocolates. The dipping operation is currently done largely by hand. The machine the company is considering costs $76,000. The manufacturer estimates that the machine would be usable for five years but would require the replacement of several key parts at the end of the sixth year. These parts would cost $7,000, including installation. After five years, the machine could be sold for $6,300.
The company estimates that the cost to operate the machine will be $12,500 per year. The present method of dipping chocolates costs $40,000 per year. In addition to reducing costs, the new machine will increase production by 5,000 boxes of chocolates per year. The company realizes a contribution margin of $0.7 per box. A 9% rate of return is required on all investments. (Ignore income taxes.)
Go to www.score.org/template_gallery.html... and download the Excel templates for cash flow and present value3 years ago