Requlred: 1. Assume that the equipment will be depreclated over a 4-year perlod using the straight-line method. What effects will the new equipment have on after-tax operating income in each of the 4 years? 2. What effect will the new equipment have on after-tax cash Inflows in each of the 4 years? 3. Compute the proposed Investment's payback perlod (In years) under the assumption that after-tax cash inflows occur evenly throughout the year. (Round your answer to 2 decimal places.) 4. Compute the accounting (book) rate of return (ARR) based on the average Investment. (Round your answer to 2 decimal places (l.e. 0.1234=12.34%) 5. Compute the net present value (NPV) of the proposed investment. (Use elther the bullt-in function In Excel (NPV) or the tables presented in AgpendixC to determine the present value of the after-tax cash flows.) (Round your answer to nearest whole clollar amount.) 6. Compute the Internal rate of return (IRR) of the proposed Investment using the bullt-in IRR function in Excel. (Round your answer to 2 declmal places (l.e. 0.1234=12.34%).) 7. Compute the modified Internal rate of return (MIRR) of the proposed Investment using the built-in MIRR function in Excel. In responding to this requirement, you might find the following sources to be helpful: MIRR Function and/or IRR In Excel). (Round your answer to 2 declmal places (l.e. 0.1234=12.34%).) 8. Management has decided to Invest in the new equipment but is unsure of the rellability of some of the estimates and as such has asked some "what-If" questions. Treat each of the following two cases independently. a. By how much can the unit varlable cost for units produced by the new equipment increase and still justlfy the purchase of the equipment (I.e., have the Investment generate an after-tax IRR of exactly 14%, Its cost of capltal)? (Do not round Intermedlate calculations. Round your final answer to 2 decimal places.) (Hint. the present value annulty factor from Appendix C Table 2 for 4 years, 20.00% is 2.589. b. The company is anticipating an increase in competition. Management belleves that, In response, It will have to reduce the selling price of the product. By how much can the firm decrease the per-unit selling price (for all units sold) and still be able to justify the purchase of the new equipment? What percentage decrease in selling price does this represent? (Round your answers to 2 decimal places (l.e. 0.1234=12.34% ).)