Cost Accounting: Please help with all requirements $($use excel if needed$)$

Dublin Chips is a manufacturer of prototype chips based in Dublin, Ireland. Next year, in 2021 , Dublin Chips expects to deliver 615 prototype chips at an average price of $95,000. Dublin Chips' marketing vice president forecasts growth of 65 prototype chips per year through 2027. That is, demand will be 615 in 2021 , 680 in 2022, 745 in 2023, and so o O (Click the icon to view additional information.) The following data on the two options are available: (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 Read the requirements. More info Future Value of Annuity of $1 table The plant cannot produce more than 585 prototype chips annually. To meet future demand, Dublin Chips must either modernize the plant or replace it. The old equipment is fully depreciated and can be sold for $4,200,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 modernized plant. The old equipment is Requirement 1. Calculate the cash inflows and outflows of the "modernize" and "replace" alternatives over the 20 First, determine the cash inflows and outflows of the "modernize" alternative over the 2021 to 2027 period. (Use a field empty, do not enter a zero.) Proceeds from sale of equipment retained as part of the "modernize" alternative. Data table Initial investment in 2021 Terminal disposal value in 2027 Useful life Total annual cash operating cost per prototype chip $ Modernize 7 years 78,500 $ Replace 7 years 66,000 s Units Year sold Jan 1, 2021 Dec 31, 2021 Dec 31, 2022 Dec 31, 2023 Dec 31, 2024 Dec 31, 2025 Dec 31, 2026 Dec 31, 2027 Get more help A Net cash contributions Initial investments Dublin 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 2021 , and all transactions thereafter occur on the last day of the year. Dublin Chips' required rate of return is 14%. There is no difference between the "modernize" and "replace" alternatives in terms of required working capital. Dublin Chips has a special waiver on income taxes until 2027. Requirements 1. 2. 3. 4. Calculate the cash inflows and outflows of the "modernize" and "replace" alternatives over the 2021 - 2027 period. Calculate payback period for the "modernize" and "replace" alternatives. Calculate net present value of the "modernize" and "replace" alternatives. What factors should Dublin Chips consider in choosing between the alternatives?