Question
Castle View Games would like to invest in a division to develop software for a soon-to-be-released video game console. To evaluate this decision, the firm
Castle View Games would like to invest in a division to develop software for a soon-to-be-released video game console. To evaluate this decision, the firm first attempts to project the working capital needs for this operation. Its chief financial officer has developed the following estimates (in millions of dollars):(To copy the table below and use in Excel, click on icon in the upper right corner of table.)
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| ||
1 | Cash | 4 | 10 | 16 | 14 | 16 | |
2 | Accounts receivable | 22 | 23 | 25 | 21 | 25 | |
3 | Inventory | 4 | 7 | 11 | 12 | 15 | |
4 | Accounts payable | 16 | 21 | 23 | 28 | 33 |
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 change in working capital for year 2 is $___ million. (Round to the nearest integer.)
The change in working capital for year 3 is $___ million. (Round to the nearest integer.)
The change in working capital for year 4 is $___ million.(Round to the nearest integer.)
The change in working capital for year 5 is $___ million. (Round to the nearest integer.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started