4. The present value payback period in years of the proposed investment under the assumption that cash inflows occur evenly throughout the year. (Note: because of this assumption, the present value calculations will be approximate, not exact) To calculate present value amounts, use the appropriate factors from Arpendix C Table 1. (Do not round Intermediate calculations. Round your final answer to 1 decimal place.) 5. The internal rate of return (IRR) (Do not round Intermediate calculations. Round your final answer to 1 decimal place.) 6. The modified internal rate of return (MIRR) (Do not round Intermediate calculations. Round your final answer to 1 decimal place.) (in conjunction with this requirement, you might want to consult either of the following two references: MIRR Function and/or Rin Excel) Egg is considering the purchase of a new distributed network computer system to help handle its warehouse inventories. The system costs $55,000 to purchase and install and $35,000 to operate each year. The system is estimated to be useful for 4 years Management expects the new system to reduce the cost of managing inventories by $63,500 per year. The firm's cost of capital (discount rate) is 12% Required: 1. What is the net present Value (NPV) of the proposed investment under each of the following independent situations? (Use the appropriate present value factors from Appendix C. TABLE 1 and Arpendix C TABLE 2.) 1a. The firm is not yet profitable and therefore pays no income taxes 16. The firm is in the 27% Income tax bracket and uses straight-line (SLN) depreciation with no salvage value. Assume MACRS rules do not apply. 1c The firm is in the 27% Income tax bracket and uses double-declining balance (DDB) depreciation with no salvage value. Given a four-year life, the DDB depreciation rate is 50% (.e., 2 25%).In year four, record depreciation expense as the net book value (NBV) of the asset at the start of the year. 2. What is the internal rate of return (IRR) of the proposed Investment for situations in requirement 1, parts (a) through (c)? Use the IRR bullit-in function in Excel to compute the IRR