In: Finance
Below are financials for XYX Corporation (in million $):
Sales |
$350 |
Cash |
$ 5 |
Accounts Payable |
$ 63 |
||
COGS |
270 |
Accounts Receivable |
74 |
Long term debt |
125 |
||
SG&A |
10 |
Inventory |
40 |
Common stock |
50 |
||
EBIT |
70 |
Net fixed assets |
239 |
Retained earnings |
120 |
||
Interest |
10 |
Total assets |
$358 |
Total Equity & Liab. |
$358 |
||
EBT |
60 |
||||||
Tax |
18 |
||||||
Net Income |
$ 48 |
The firm's inventory conversion period is 54 days. Its new CFO wants to decrease the cash conversion cycle by 8 days, based on a 365-day year. He believes he can reduce average receivables by $3.2 million without upsetting customers.
a. By how much must the firm increase its average payable to
meet its goal of a 8-day reduction in its cash conversion cycle?
(6 points)
b. If XYZ Corporation does decrease its cash conversion cycle by 8 days by increasing average payables and reducing average receivables, what will be the change in its net operating working capital? The company's inventory remains constant. (2 points)
here given,
a)
Days Inventory Outstanding = 54 days
Cash Conversion Cycle = Days Inventory Outstanding + Days sales
Outstanding - Days Payable outstanding
= 54 + (Accounts Receivable*365/Net Credit sales) - (Accounts
Payable*365/COGS)
= 54 + (74*365/ 350) - (63*365/270)
= 54 + 77 - 85
= 46 days
Now, Target Cash conversion cycle = 46-8 = 38 days
Therefore, 38= 54 + 77 - say X
or, X = 54+77-38 = 93
Therefore, average payable must be increased by 63 -(93*270/365 ) =
$6 million to reduce cash conversion cycle by 8 days.
b)
Inventory Conversion period = (Inventory*365)/ COGS
or, 54 = (Inventory*365)/ 270
Therefore, Inventory = $40
Now, cash conversion cycle = 38 days
Accounts payable = $69
Accounts Receivable = 74 -3.2= $70.8
Cash = $5
Total Current Assets = 40+70.8+5= 115.8
Total Current Liabilities = 69 (Accounts Payable)
Net Working Capital = Total Current Assets - Total Current
Liabilities
= 115.8- 69 = $46.8 million
Earlier Working Capital = (5+74+40)- 63 = $56 million
Change in Net working Capital = $46.8 - $56
= $9.2 million (Decline in Net operating working capital)