eEgg is considering the purchase of a new distributed network computer system to help handle its warehouse inventories. The system costs $39,000 to purchase and install and $26,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 $46,000 per year. The firm's cost of capital (discount rate) is 7%. 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 Appendix C. TABLE 2.) 1a. The firm is not yet profitable and therefore pays no income taxes. 1b. The firm is in the 24% 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 24% 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% (i.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 built-in function in Excel to compute the IRR. Complete this question by entering your answers in the tabs below. Reg 1A Req 18 Reg 1C Reg 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 builit-in function in Excel to compute the IRR. (Round "Estimated IRR" to 1 decimal place.) Estimated IRR a. % b. % C. % Chec 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 Appendix C. TABLE 2.) 1a. The firm is not yet profitable and therefore pays no income taxes. 1b. The firm is in the 24% 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 24% 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 x 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 builit-in function in Excel to compute the IRR. Complete this question by entering your answers in the tabs below. Req 1A Req 1B Req 1C Req 2 The firm is in the 24% 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% (i.e., 2 x 25%). In year four, record depreciation expense as the net book value (NBV) of the asset at the start of the year. (Negative amounts should be indicated by a minus sign. Round discount factor to 3 decimal places and other answers to the nearest whole dollar amount.) Show less A Year Pre-Tax Cash Inflows DDB Depreciation Expense Taxable Income Income Taxes After-tax Net Cash Inflow Discount Factor Present Values 0 $ $ (39,000) 20,000 1 500 120 19,500 9,750 (39,000) 18,588 15,312 2 20,000 10.250 2,460 $ (39,000) 1.000 19,880 0.935 17,540 0.873 16,370 0.816 16,370 0.763 Net present value (NPV) = 3 20,000 3,630 13,358 4,875 4,875 15,125 15,125 4 20,000 3,630 12,490 20,748 $ eEgg is considering the purchase of a new distributed network computer system to help handle its warehouse inventories. The system costs $39,000 to purchase and install and $26,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 $46,000 per year. The firm's cost of capital (discount rate) is 7%. 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 Appendix C, TABLE 2.) 1a. The firm is not yet profitable and therefore pays no income taxes. 1b. The firm is in the 24% 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 24% 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% (i e., 2 x 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 built-in function in Excel to compute the IRR. es Complete this question by entering your answers in the tabs below. Req 1A Ref 1B Req 1C Req 2 The firm is in the 24% income tax bracket and uses straight-line (SLN) depreciation with no salvage value. Assume MACRS rules do not apply. (Round your answer to nearest whole dollar amount.) Net present value eEgg is considering the purchase of a new distributed network computer system to help handle its warehouse inventories. The system costs $39,000 to purchase and install and $26,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 $46,000 per year. The firm's cost of capital (discount rate) is 7%. 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. 1b. The firm is in the 24% 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 24% 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 x 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 built-in function in Excel to compute the IRR. S Complete this question by entering your answers in the tabs below. Req 1A Req 1B Reg 10 Reg 2 The firm is not yet profitable and therefore pays no Income taxes. (Round your answer to nearest whole dollar amount.) Net present value $ 28,740