1. Net Present Value, Internal Rate of Return, and Payback Period Analyses.Sherwin Moore Paint Company would like to further automate its production process by purchasing production equipment for $660,000. The equipment is expected to have a useful life of 8 years, and will be sold at the end of 8 years for $40,000. The equipment requires significant maintenance work at an annual cost of $75,000. Labor and material cost savings, shown in the table, are also expected to be significant.
2. Year 1$160,000Year 2$190,000Year 3$200,000Year 4$240,000Year 5$280,000Year 6$220,000Year 7$180,000Year 8$155,000
3. The company's required rate of return is 11 percent. Assume the company requires all investments to be recovered within five years.
4. Required:
5. Find the net present value of this investment using the format presented in Figure 8.2 "NPV Calculation for Copy Machine Investment by Jackson's Quality Copies". Round to the nearest dollar.
6. Use trial and error to approximate the internal rate of return for this investment proposal.
7. Determine the payback period for this investment using the format shown in Table 8.1 "Calculating the Payback Period for Jackson's Quality Copies".
8. Based on your findings in requirementsa,b, andc, should the company purchase the production equipment? Explain.