National Chips is a manufacturer of prototype chips based in Dublin, Ireland. Next year, in 2018, National Chips expects to deliver 525 prototype chips at an average price of $100,000. National Chips' marketing vice president forecasts growth of 70 prototype chips per year through 2024. That is, demand will be 525 in 2018, 595 in 2019,665 in 2020, and so on. (Click the icon to view additional information.) Click the icon to view the data on the two options available and additional information.) Present Value of $1 table Present Value of Annuity of $1 table Future Value of $1 table Future Value of Annuity of $1 table Read the fequirements Year Requirement 1. Calculate the cash inflows and outflows of the modernize and replace alternatives over the 2018-2024 period First, dete mine the cash inflows and outflows of the modernize alternative over the 2018 to 2024 period. (Use a minus sign or parentheses for a cash outflows. If a box is not used in the table, leave that box empty, do not enter a zero.) Units Net cash Initial Proceeds from sold contributions investments sale of equipment Jan 1, 2018 Dec 31, 2018 Dec 31, 2019 Dec 31, 2020 Dec 31, 2021 Dec 31, 2022 Dec 31, 2023 Dec 31, 2024 equirements More info 2 Jinu The plant cannot produce more than 495 prototype chips annually. To meet future demand, National Chips must either modernize the plant or replace it. The old equipment is fully depreciated and can be sold for $3,900,000 if the plant is replaced. If the plant is modernized, the costs to modernize it are to be capitalized and depreciated over the useful life of the updated plant. The old equipment is retained as part of the modernize alternative. The following data on the two options are available: -3 3 Print Done C3 c3 TW I Data table Modernize Replace Initial investment in 2018 $ 34,800,000 $ 66,100,000 Terminal disposal value in 2024 $ 7,500,000 $ 17,300,000 Useful life 7 years 7 years Total annual cash operating cost per prototype chip $ 84,000 $ 74,000 National Chips uses straight-line depreciation, assuming zero terminal disposal value. For simplicity, we assume no change in prices or costs in future years. The investment will be made at the beginning of 2018, and all transactions thereafter occur on the last day of the year. National Chips' required rate of return is 10%. There is no difference between the modernize and replace alternatives in terms of required working capital. National Chips has a Print Done Requirements 1. Calculate the cash inflows and outflows of the modernize and replace alternatives over the 2018 - 2024 period. 2. Calculate payback period for the modernize and replace alternatives. 3. Calculate net present value of the modernize and replace alternatives. 4. What factors should National Chips consider in choosing between the alternatives? Print Done