C12-40. NPV and Project Reevaluation with Taxes, Straight-Line Depreciation LO2, 5, 6 In 2015, the Bayside Chemical Company prepared the following analysis of an investment proposal for a new manufacturing facility: Predicted 12% Cash Year(s) Present Present Inflows of Cash Value Value of (outflows) Flows Factor Cash Flows (A) (B) (C) (A) X (C) Initial investment Fixed assets . .. $(810,000) 1.00000 $ (810,000) Working capital . . . .. (100,000) 0 1.00000 (100,000) Operations Annual taxable income without depreciation . . . 310,000 1-5 3.60478 1,117,482 Taxes on income ($310,000 X 0.40) . . . . . (124,000) 1-5 3.60478 (446,993) Depreciation tax shield . . . . . . 64,800* 1-5 3.60478 233,590 Disinvestment Site restoration . . . . . 80,000 0.56743 (45,394) Tax shield of restoration ($80,000 X 0.40) . . 32,000 0.56743 18,158 Working capital . . . .. .. 100,000 0.56743 56,743 Net present value of all cash flows. . $ 23,586 *Computation of depreciation tax shield: Annual straight-line depreciation ($810,000 + 5) . . .. . ... . . . . . $162,000 Tax rate .. .. X 0.40 Depreciation tax shield . $ 64,800Because the proposal had a positive net present value when discounted at Bayside's cost of capi- tal of 12 percent, the project was approved; all investments were made at the end of 2016. Shortly after production began in January 2017, a government agency notied Bayside of required additional expenditures totaling $200,000 to bring the plant into compliance with new federal emission regu- lations. Bayside has the option either to comply with the regulations by December 31, 2017, or to sell the entire operation (xed assets and working capital) for $250,000 on December 31, 2017. The improvements will be depreciated over the remaining four-year life of the plant using straight-line depreciation. The cost of site restoration will not be affected by the improvements. If Bayside elects to sell the plant, any book loss can be treated as an offset against taxable income on other operations. This tax reduction is an additional cash benefit of selling. Required a. Should Bayside sell the plant or comply with the new federal regulations? To simplify calculations, assume that any additional improvements are paid for on December 31, 2017. Present Value of Selling Plant at 12/31/2017 Cash from sale of plant 250,000 Tax shield of loss on sale: Selling Price Book Value Loss on sale Tax shield Proceeds from selling plant 250,000 Present Value of Additional Investment Predicted Cash Year(s) of Cash 12% Present Present Value of Inflows (outflows) Flows Value Factor Cash Flows (A) (B) (C) (A) x (C) Initial investment Fixed assets 200,000 0 Operations Annual taxable income w/o depreciation Taxes on income ($310,000 x 0.40) Depreciation tax shield - original Depreciation tax shield - additional Disinvestment Site restoration Tax shield of restoration ($80,0000 x 0.40) Working capital Net present value of all cash flows $ 6 ***With the exception of Year(s) of Cash Flows and 12% Present Value Factor, you should enter formulas with cell references - NO HARD-KEYED NUMBERS