Question

Company A's for 2018 had $47,643.45M in Sales, $34,739.99M Costs of Goods Sold. The Inventory and...

Company A's for 2018 had $47,643.45M in Sales, $34,739.99M Costs of Goods Sold. The Inventory and Accounts Payable were $2,618.35M and $13,959.68M respectively. What should be the value for Accounts Receivables in order to have a Cash Conversion Cycle of 18 days?

Homework Answers

Answer #1

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

Hope it will help, please do comment if you need any further explanation. Your feedback would be highly appreciated.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Question 4: During 2016, XYZ Ltd. had the inventory period of 25 days, the accounts receivable...
Question 4: During 2016, XYZ Ltd. had the inventory period of 25 days, the accounts receivable period of 30 days and the accounts payable period of 20 days. Assume that XYZ Ltd. has the credit sales of $365 million in 2016 and the cost of goods sold of $255.5million. It had beginning of the year inventories, receivables and payables of $15 million, $28 million and $12 million respectively: i) Calculate the operating cycle and the cash conversion cycle of XYZ...
Blackberry, Inc. had sales for the past year of $38,250 and cost of goods sold of...
Blackberry, Inc. had sales for the past year of $38,250 and cost of goods sold of $21,038. In addition, the statement of financial position accounts was as shown in the table below. Blackberry uses average account values and a 365-day year where applicable in all of its computations. Account Beginning Ending Accounts receivable $1,800 $1,650 Inventory $2,450 $2,500 Accounts payable $1,950 $1,850 What is the cash cycle for Blackberry, Inc.? Multiple Choice 48.33 days 37.55 days 42.87 days 26.43 days...
The following company has sales of $30 million and a cost of goods sold of $18...
The following company has sales of $30 million and a cost of goods sold of $18 million. The balance sheet for period ending 31 December 2019 for this company appears below: Assets                                                     $000 Liabilities and Shareholder Equity      $000 Cash                                                        2500    Accounts Payable                                    1600 Accounts Receivable                             4400 Other Payables                                           900 Inventory                                                1500 Accruals                                                     1100 Total Current Assets                            8400 Total Current Liabilities                         3600 Property Plant and Equipment         10500 Long Term Debt                                        2500 Total Assets                                         18900 Total Liabilities                                         6100 Issued Equity                                          12800 Total Liability & Shareholder Equity  18900 a. Calculate the company’s net working capital in 2019.                                      b. Calculate...
The simplified balance of the Greek Connection is shown below. It had sales and a cost...
The simplified balance of the Greek Connection is shown below. It had sales and a cost of goods sold as shown in last rows of the Table. THE GREEK CONNECTION Balance Sheet As of December 31, 2015 (thousands of dollars) Assets Liabilities and Equity Cash 2200 Accounts payable 1500 Accounts receivable 3950 Notes payable 1000 Inventory 1300 Accruals 1220 Total current assets 7450 Total current liabilities 3720 Net plant, property Long-term debt 3200 and equipment 8500 Total liabilities 6820 Total...
A company has inventory balance of $26,169, accounts receivable of $10,432, and accounts payable of $15,226....
A company has inventory balance of $26,169, accounts receivable of $10,432, and accounts payable of $15,226. If the credit sales are $194,874 and cost of goods sold are $139,527, what is the company's cash (conversion) cycle in number of days? (Use ending balances and assume 365 days in a year.) Options: 36.84 37.84 38.84 39.83 40.83
Home and Beyond company has sales of $2850, costs of goods sold of $2190, and accounts...
Home and Beyond company has sales of $2850, costs of goods sold of $2190, and accounts receivable of $433. If it takes 73 days on average to sell the inventory, what is the company’s average inventory
A company has inventory balance of $22,467, accounts receivable of $8,842, and accounts payable of $13,504....
A company has inventory balance of $22,467, accounts receivable of $8,842, and accounts payable of $13,504. If the credit sales are $171,186 and cost of goods sold are $118,377, what is the company's cash (conversion) cycle in number of days? (Use ending balances and assume 365 days in a year.) a) 41.64 b)40.60 c) 44.76 d) 42.68 e)43.72
Sales (all credit): $6,000,000; Cost of Goods Sold: 80% of Sales; Accounts receivable: $350,000; Inventory: $600,000;...
Sales (all credit): $6,000,000; Cost of Goods Sold: 80% of Sales; Accounts receivable: $350,000; Inventory: $600,000; Accounts payable: $150,000 What is the expected working capital financing requirement based on the working capital cycle? Use 1 year = 365 days $736,438 $756,164 $604,932 $920,548
Chastains Corporation is trying to determine the effect of its inventory turnover ratio and days sales...
Chastains Corporation is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash conversion cycle. Chastains 2016 sale (all on credit) were $121000; its cost of goods sold is 80% of sale; and it earned a net profit of 2%, or 2420. It turned over its inventory 6 times during the year, and its DSO was 36 days. The firm had fixed assets totaling $30000. Chastains payable deferral period is 35 days....
Edison Inc. has annual sales of $49,000,000 on a 365-day basis. The firm's cost of goods...
Edison Inc. has annual sales of $49,000,000 on a 365-day basis. The firm's cost of goods sold are 75% of sales. On average, the company has $9,000,000 in inventory and $8,000,000 in accounts receivable. The firm is looking for ways to shorten its cash conversion cycle. Its CFO has proposed new policies that would result in a 20% reduction in both average inventories and accounts receivable. She also anticipates that these policies would reduce sales by 10%, while the payables...