Castle View Games would like to invest in a division to develop software for video games....

Transcribed Image Text:

Castle View Games would like to invest in a division to develop software for video games. To evaluate this decision, the firm first attempts to project the working capital needs for this operation. Its chief financia has developed the following estimates (in millions of dollars) (Click on the following icon in order to copy its contents into a spreadsheet) Cash Accounts Receivable Inventory Accounts Payable Year 1 7 22 6 17 Year 2 10 22 8 19 Year 3 14 24 12 25 Year 4 14 24 13 29 Year 5 15 25 15 30 Assuming that Castle View currently does not have any working capital invested in this division, calculate the cash flows associated with changes in working capital for the first five years of this investment Note Enter decreases as negative numbers. The change in working capital for year 1 is $million (Round to the nearest integer) The net working capital in year 2 is $ million (Round to the nearest integer) The change in working capital for year 2 is $ million (Round to the nearest integer) The net working capital in year 3 is $ The change in working capital for year 3 is $ The net working capital in year 4 is $ million (Round to the nearest integer) million (Round to the nearest integer) million (Round to the nearest integer) The change in working capital for year 4 is $ million (Round to the nearest integer) The net working capital in year 5 is $ million (Round to the nearest integer) Castle View Games would like to invest in a division to develop software for video games. To evaluate this decision, the firm first attempts to project the working capital needs for this operation. Its chief financia has developed the following estimates (in millions of dollars) (Click on the following icon in order to copy its contents into a spreadsheet) Cash Accounts Receivable Inventory Accounts Payable Year 1 7 22 6 17 Year 2 10 22 8 19 Year 3 14 24 12 25 Year 4 14 24 13 29 Year 5 15 25 15 30 Assuming that Castle View currently does not have any working capital invested in this division, calculate the cash flows associated with changes in working capital for the first five years of this investment Note Enter decreases as negative numbers. The change in working capital for year 1 is $million (Round to the nearest integer) The net working capital in year 2 is $ million (Round to the nearest integer) The change in working capital for year 2 is $ million (Round to the nearest integer) The net working capital in year 3 is $ The change in working capital for year 3 is $ The net working capital in year 4 is $ million (Round to the nearest integer) million (Round to the nearest integer) million (Round to the nearest integer) The change in working capital for year 4 is $ million (Round to the nearest integer) The net working capital in year 5 is $ million (Round to the nearest integer)