Question

In: Finance

your company is planing to cut inventory levels to reduce working capital to $250000 for next...

your company is planing to cut inventory levels to reduce working capital to $250000 for next year.you are developing a sensitivity analysis for next year's budget and have arrived at the following scenarios

Year 1 2 3 4 5 6

Cash 125'000 349,000 421,000 300,000 250,000 725,000

Accounts Receivable 245,000 211,000 153,000 200,000 146,000 600,000

Inventory 310,000 222,000 245,000 130,000 300,000 300,000

Account Payable 350,000 320,000 343,000 289,000 280,000 1,200,000

Required

a. Calculate the inventory reduction required to reduce working capital to $250,000 for each scenario.

b. For which scenarios does it not seem feasible to cut inventory by the amounts suggested in part (a)?  

Solutions

Expert Solution

Answer a
Calculate the inventory reduction required to reduce working capital to $250,000 for each scenario.
Year 1 2 3 4 5 6
Current Assets
- Cash $125,000.00 $349,000.00 $421,000.00 $300,000.00 $250,000.00 $725,000.00
- Accounts Receivables $245,000.00 $211,000.00 $153,000.00 $200,000.00 $146,000.00 $600,000.00
- Inventory $310,000.00 $222,000.00 $245,000.00 $130,000.00 $300,000.00 $300,000.00
Total Current Assets $680,000.00 $782,000.00 $819,000.00 $630,000.00 $696,000.00 $1,625,000.00
Less : Current Liabilities
- Accounts Payable $350,000.00 $320,000.00 $343,000.00 $289,000.00 $280,000.00 $1,200,000.00
Working Capital $330,000.00 $462,000.00 $476,000.00 $341,000.00 $416,000.00 $425,000.00
Less : Required Working Capital $250,000.00 $250,000.00 $250,000.00 $250,000.00 $250,000.00 $250,000.00
Inventory reduction required $80,000.00 $212,000.00 $226,000.00 $91,000.00 $166,000.00 $175,000.00
Answer b
I do not find such scenarios where it not seem feasible to cut inventory by the amounts suggested in Part a.

Related Solutions

The following table includes quarterly working capital levels for your firm for the next year. Quarters...
The following table includes quarterly working capital levels for your firm for the next year. Quarters ?($000)???????? 1 2 3 4 Cash 104 104 104 104 Accounts Receivable 198 97 106 610 Inventory 205 504 908 53 Accounts Payable 110 103 99 105 If you choose to enter the year with $397,000 total in cash and maintain a minimum cash balance of $104,000?, what is your maximum?short-term borrowing? This is the answer but I need someone to show me how...
If a company has had net working capital levels of approximately 12% of sales over the...
If a company has had net working capital levels of approximately 12% of sales over the past five years, it can be reasonably estimated that the company will continue to require that level of working capital to support future sales. Therefore, it may be appropriate to add any working capital amount in excess of 12% of sales as of the valuation date to the determined company value as excess working capital (essentially a non-operating asset). A related adjustment may be...
Select a company of your choice and research the working capital of that company (i.e. GE...
Select a company of your choice and research the working capital of that company (i.e. GE Capital, Wal-Mart, Apple, Google, Yahoo, IBM, Boeing, Target ...etc) and explain their working capital strategy based on your findings.
Describe public health policies to reduce smoking levels in the community in terms of social capital....
Describe public health policies to reduce smoking levels in the community in terms of social capital. What, is anything, would you choose?
In your opinion, should the government cut its spending levels, and if so, what specific area...
In your opinion, should the government cut its spending levels, and if so, what specific area should be cut first? Explain your reasoning. What could be the possible unintended consequences of such a cut?
In your opinion, should the government cut its spending levels, and if so, what specific area...
In your opinion, should the government cut its spending levels, and if so, what specific area should be cut first? Explain your reasoning. What could be the possible unintended consequences of such a cut? This discussion covers 3 skills. Describe government spending at federal, state, and local levels. Describe how federal deficits and the national debt relate to the economy. Describe how automatic stabilizers respond to economic events.
in your opinion, should the government cut its spending levels, and if so, what specific area...
in your opinion, should the government cut its spending levels, and if so, what specific area should be cut first? Explain your reasoning. What could be the possible unintended consequences of such a cut? Attachments Skills Describe government spending at federal, state, and local levels. Describe how federal deficits and the national debt relate to the economy. Describe how automatic stabilizers respond to economic events.
A company is trying to reduce inventory by installing a kanban system for compressors on one...
A company is trying to reduce inventory by installing a kanban system for compressors on one of its assembly lines. The setup cost = $10, Annual holding cost per compressor is $100, Daily production is 200 compressors, Annual usage is 20000, The lead time is 3 days, safety stock is 12 day’s production of compressors. Determine the size of the kanban and the number of kanbans (containers) needed.
Working capital assets are comprised of cash, accounts receivables, and inventory. Is one more important to...
Working capital assets are comprised of cash, accounts receivables, and inventory. Is one more important to manage than another? Why? Why not? Which of these are the most difficult to manage? How does the accounting basis (cash vs. accrual) an organization chooses change your response, especially in regards to accounts receivables?
Determine the change in net working capital that appears warranted for the following proposed project: Inventory...
Determine the change in net working capital that appears warranted for the following proposed project: Inventory levels will increase 20% from their current value of 500,000; machinery will increase by $75,000; accounts receivable because of a new collection system will increase by only $15,000; accounts payable will increase by $45,000. What happens to net working capital at the end of the projects life?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT