Question

In: Finance

Below are financials for XYX Corporation (in millions $): Sales $350 Cash $ 5 Accounts Payable...

Below are financials for XYX Corporation (in millions $):


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 7 days, based on a 365-day year. He believes he can reduce average receivables by $2.9 million without upsetting customers.

By how much must the firm increase its average payable to meet its goal of a 7-day reduction in its cash conversion cycle? (6 points)

If XYZ Corporation does decrease its cash conversion cycle by 7 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)

Expert Solution

a.

Current days of payables = 365 x Accounts payable / cost of goods sold = 365 x 63 / 270 = 85.17

Current days of receivables = 365 x accounts receivables / sales = 365 x 74 / 350 = 77.17

New days of receivables after reducing receivables by 2.9 million = 365 x (74 - 2.9) / 350 = 74.15

Let A be the new days of payables

Cash conversion cycle = days of inventory + days of receivables - days of payables

Current cash conversion cycle = 54 + 77.1 - 85.17 = 45.93

New cash conversion cycle = current cash conversion cycle - 7 = 45.93 - 7 = 38.93 = 54 + 74.15 - A

A = 54 + 74.15 - 38.93 = 89.22

365 x new accounts payable / 270 = 89.22

New Accounts payable = 89.22 x 270 / 365 = 66

Change in accounts payable = 66 - 63 = 3

The firm must increase accounts payable by $3 million

b.

Operating working capital = net operating current assets - net operating current liabilities

Current operating working capital = (Inventories + accounts receivables + cash) - accounts payable = (40 + 74 + 5) - 63 = $56

New operating working capital = (40 + 71.1 + 5) - 66 = $50.1

Change in operating working capital = 56 - 50.1 = $5.9 million

jeff jeffy answered 2 years ago

Below are financials for XYX Corporation (in million $): Sales $350 Cash $ 5 Accounts Payable...

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...

Below are financials for XYX Corporation (in million $): Sales $330 Cash $ 6 Accounts Payable...

Below are financials for XYX Corporation (in million $): Sales $330 Cash $ 6 Accounts Payable $ 64 COGS 260 Accounts Receivable 72 Long term debt 119 SG&A 12 Inventory 40 Common stock 50 EBIT 58 Net fixed assets 241 Retained earnings 126 Interest 11 Total assets $359 Total Equity & Liab. $359 EBT 47 Tax 14 Net Income $ 33 The firm's inventory conversion period is 56 days. Its new CFO wants to decrease the cash conversion cycle by...

Balance Sheet (in $ millions) Assets Liabilities and Stockholders' Equity Cash ...................................... $ 7 Accounts payable ............$20 Accounts...

Balance Sheet (in $ millions) Assets Liabilities and Stockholders' Equity Cash ...................................... $ 7 Accounts payable ............$20 Accounts receivable ............ 25 Accrued wages .................7 Inventory .............................. 28 Accrued taxes .................. 13 Current assets ................... $80 Current liabilities .......... $40 Fixed assets ......................... 25 Notes payable ..................15 Common stock .................20 Retained earnings ............ 30 Total Assets ...........................$105 Total liabilities and stockholders’ equity .......$105 If the firm’s sales for last year were $100 million, and the balance sheet at year-end is similar in percentage of sales to that of...

(Cash conversion cycle) Historical data for the firm's sales, accounts receivable, inventories, and accounts payable for...

(Cash conversion cycle) Historical data for the firm's sales, accounts receivable, inventories, and accounts payable for the Crimson Mfg. Company follow: a. Calculate Crimson's days of sales outstanding, days of payables outstanding, and days of sales in inventory for each of the 5 years. (Assume a 365-day year. Hint: Assume that the firm's cost of goods sold equals 70% of sales.) What has Crimson accomplished in its atempts to better manage its investments in account receivable and inventory? b. Calculate...

Cash conversion cycle) Historical data for the firm's sales, accounts receivable, inventories, and accounts payable for...

Cash conversion cycle) Historical data for the firm's sales, accounts receivable, inventories, and accounts payable for the Crimson Mfg. Company follow: LOADING.... a. Calculate Crimson's days of sales outstanding, days of payables outstanding, and days of sales in inventory for each of the 5 years. (Assume a 365-day year. Hint: Assume that the firm's cost of goods sold equals 70% of sales.) What has Crimson accomplished in its atempts to better manage its investments in account receivable and inventory? b....

Shown below in T-account format are the beginning and ending balances ($ in millions) of both inventory and accounts payable.

Shown below in T-account format are the beginning and ending balances ($ in millions) of both inventory and accounts payable. Required: 1. Use a T-account analysis to determine the amount of cash paid to suppliers of merchandise during the reporting period if cost of goods sold was $300 million. 2. Prepare a summary entry that represents the net effect of merchandise purchases during the reporting period.

cash collections of accounts receivable will increase and decrease _ 1) accounts payable , accounts...

cash collections of accounts receivable will increase ____ and decrease _____ 1) accounts payable , accounts receivable 2) accounts receivable, accounts payable 3) cash, accounts receivable 4) cast, accounts payable when developring cost functions , which of the following is false 1) the cost funtion must be believable 2) the cost function does not have to be reliable 3) personal observations of cost and activities provide the best evidence of a plausible relationship between a cost and its cost driver...

Exercise 6 Rao Corporation has the following balance sheet. Cash $ 10 Accounts payable $...

Exercise 6 Rao Corporation has the following balance sheet. Cash $ 10 Accounts payable $ 20 Short-term investments Accruals 20 Accounts receivable 50 Notes payable 50 Inventory 40 Current liabilities $ 90 Current assets $130 Long-term debt 0 Net fixed assets 100 Common equity 30 Retained earnings 50 Total assets $230 Total liab. & equity $230 Required: How much net operating working capital does the firm have? How does net working capital affect...

Cash $ 80 Accounts Payable $ 26 Accounts Receivable 12 Wages and Other Expenses Payable 111...

Cash $ 80 Accounts Payable $ 26 Accounts Receivable 12 Wages and Other Expenses Payable 111 Inventories 188 Long-Term Debt 203 Other Current Assets 26 Other Long-Term Liabilities 44 Property, Plant, and Equipment 355 Contributed Capital 356 Other Assets 99 Retained Earnings 20 Assume that the following events occurred in the quarter ended December 31 (amounts provided are in whole dollars): Paid $2,000,000 cash for an additional “other asset”. Issued additional shares for $2,000,000 in cash. Purchased property, plant, and...

In 20X8 ABC Corporation had sales of $3,482 (in millions), EBIT of $638 (in millions), and...

In 20X8 ABC Corporation had sales of $3,482 (in millions), EBIT of $638 (in millions), and net income of $189 (in millions). Its DOL, DFL, and DCL are 5.46, 3.38 and 18.42, respectively. If the EBIT decreases to $600 (in millions) in 20X9, what is the net income of ABC in 20X9?