ANSWER IN EXCEL

The following table tracks the main components of working capital over the life of a four-year project. 2019 2020 2021 2022 2023 Accounts receivable 0 152,000 227,000 192,000 0 Inventory 76,000 131,000 131,000 96,000 0 Accounts payable 25,500 50,500 51,000 35,500 0 Assume the total net working capital at the end of 2018 is zero. Calculate net working capital and the cash inflows and outflows due to investment in working capital.