Im not confident enough on pay back periods and npv

Heaps Company produces jewelry that requires electroplating with gold, silver, and other valuable metals. Electroplating uses large amounts of water and chemicals, producing wastewater with a number of toxic residuals. Currently, Heaps uses settlement tanks to remove waste; unfortunately, the approach is inefficient, and much of the toxic residue is left in the water that is discharged into a local river. The amount of toxic discharge exceeds the legal, allowable amounts, and the company is faced with substantial, ongoing environmental fines. The environmental violations are also drawing unfavorable public reaction, and sales are being affected. A lawsuit is also impending, which could prove to be quite costly. Management is now considering the installation of a zero-discharge, closed-loop system to treat the wastewater. The proposed closed-loop system would not only purify the wastewater, but also produce cleaner water than that currently being used, increasing plating quality. The closed-loop system would produce only four pounds of sludge, and the sludge would be virtually pure metal, with significant market value. The system requires an investment of $629,300 and will cost $45,530 in increased annual operation plus an annual purchase of $7,660 of filtration medium. However, management projects the following savings: Water usage $ 67,330 Chemical usage 42,050 Sludge disposal 90,430 Recovered metal sales 45,070 Sampling of discharge 120,460 Total $365,340 The equipment qualifies as a seven-year MACRS asset. Management has decided to use straight-line depreciation for tax purposes, using the required half-year convention. The tax rate is 40 percent. The projected life of the system is 10 years. The hurdle rate is 16 percent for all capital budgeting projects, although the company's cost of capital is 12 percent. The present value tables provided in Exhibit 19B.1 and Exhibit 198.2 must be used to solve the following problems. Required: 1. Based on the financial data provided, prepare a schedule of expected cash flows. Enter cash outflows as negative amounts and cash inflows as positive amounts. Heaps Company Schedule of Expected Cash Flow Year o Year 1: Operating costs Savings Depreciation shield Total Years 2-7: Operating costs Savings Depreciation shield Total Year 8: Operating costs O Savings Depreciation shield Total Years 9-10: Operating costs Savings Total 2. What is the payback period? Round your answer to two decimal places. years 3. Calculate the NPV of the closed-loop system. Round intermediate calculations and the final answer to the nearest dollar. Should the company invest in the system? 4. The calculation in Requirement 3 ignored several factors that could affect the project's viability: savings from avoiding the annual fines, positive effect on sales due to favorable environmental publicity, increased plating quality from the new system, and the avoidance of the lawsuit. Can these factors be quantified? If so, should they have been included in the analysis? Suppose, for example, that the annual fines being incurred are $75,120, the sales effect is $60,230 per year, the quality effect is not estimable, and cancellation of the lawsuit because of the new system would avoid an expected settlement at the end of Year 3 (including legal fees) of $308,000. Assuming these are all after-tax amounts, what effect would their inclusion have on the payback period? On the NPV? Round payback to two decimal places and round NPV calculation and final answer to the nearest dollar. Payback by years $ NPV by Heaps Company produces jewelry that requires electroplating with gold, silver, and other valuable metals. Electroplating uses large amounts of water and chemicals, producing wastewater with a number of toxic residuals. Currently, Heaps uses settlement tanks to remove waste; unfortunately, the approach is inefficient, and much of the toxic residue is left in the water that is discharged into a local river. The amount of toxic discharge exceeds the legal, allowable amounts, and the company is faced with substantial, ongoing environmental fines. The environmental violations are also drawing unfavorable public reaction, and sales are being affected. A lawsuit is also impending, which could prove to be quite costly. Management is now considering the installation of a zero-discharge, closed-loop system to treat the wastewater. The proposed closed-loop system would not only purify the wastewater, but also produce cleaner water than that currently being used, increasing plating quality. The closed-loop system would produce only four pounds of sludge, and the sludge would be virtually pure metal, with significant market value. The system requires an investment of $629,300 and will cost $45,530 in increased annual operation plus an annual purchase of $7,660 of filtration medium. However, management projects the following savings: Water usage $ 67,330 Chemical usage 42,050 Sludge disposal 90,430 Recovered metal sales 45,070 Sampling of discharge 120,460 Total $365,340 The equipment qualifies as a seven-year MACRS asset. Management has decided to use straight-line depreciation for tax purposes, using the required half-year convention. The tax rate is 40 percent. The projected life of the system is 10 years. The hurdle rate is 16 percent for all capital budgeting projects, although the company's cost of capital is 12 percent. The present value tables provided in Exhibit 19B.1 and Exhibit 198.2 must be used to solve the following problems. Required: 1. Based on the financial data provided, prepare a schedule of expected cash flows. Enter cash outflows as negative amounts and cash inflows as positive amounts. Heaps Company Schedule of Expected Cash Flow Year o Year 1: Operating costs Savings Depreciation shield Total Years 2-7: Operating costs Savings Depreciation shield Total Year 8: Operating costs O Savings Depreciation shield Total Years 9-10: Operating costs Savings Total 2. What is the payback period? Round your answer to two decimal places. years 3. Calculate the NPV of the closed-loop system. Round intermediate calculations and the final answer to the nearest dollar. Should the company invest in the system? 4. The calculation in Requirement 3 ignored several factors that could affect the project's viability: savings from avoiding the annual fines, positive effect on sales due to favorable environmental publicity, increased plating quality from the new system, and the avoidance of the lawsuit. Can these factors be quantified? If so, should they have been included in the analysis? Suppose, for example, that the annual fines being incurred are $75,120, the sales effect is $60,230 per year, the quality effect is not estimable, and cancellation of the lawsuit because of the new system would avoid an expected settlement at the end of Year 3 (including legal fees) of $308,000. Assuming these are all after-tax amounts, what effect would their inclusion have on the payback period? On the NPV? Round payback to two decimal places and round NPV calculation and final answer to the nearest dollar. Payback by years $ NPV by