Question

In: Finance

Cash Conversion Cycle & Ratios Target Sales = 74,433,000,000 Cost of goods sold = 53,299,000,000 Inventory...

  1. Cash Conversion Cycle & Ratios

Target

Sales = 74,433,000,000

Cost of goods sold = 53,299,000,000

Inventory = 9,497,000,000

Accounts receivable = 468,000,000

Accounts payable = 1,127,000,000

Inventory conversion period = 65.04

Average collection period = 2.29

Payables deferral period = 7.72

CCC = 59.61

Nike

Sales = 36,397,000,000

Cost of goods sold = 20,441,000,000

Inventory = 5,261,000,000

Accounts receivable = 3,498,000,000

Accounts payable = 2,279,000,000

Inventory conversion period = 93.94

Average collection period = 35.08

Payables deferral period = 40.69

CCC = 88.33

McDonalds

Sales = 21,025,000,000

Cost of goods sold = 2,200,000,000

Inventory = 51,100,000

Accounts receivable = 2,441,500,000

Accounts payable = 1,207,900,000

Inventory conversion period = 8.48

Average collection period = 42.39

Payables deferral period = 2.00

CCC = 48.87

Best Buy

Sales = 42,151,000,000

Cost of goods sold = 32,275,000,000

Inventory = 5,209,000,000

Accounts receivable = 1,049,000,000

Accounts payable = 4,873,000,000

Inventory conversion period = 58.91

Average collection period = 9.08

Payables deferral period = 55.11

CCC = 12.88

Amazon

Sales = 232,887,000,000

Cost of goods sold = 139,156,000,000

Inventory = 17,174,000,000

Accounts receivable = 16,677,000,000

Accounts payable = 38,192,000,000

Inventory conversion period = 45.05

Average collection period = 26.14

Payables deferral period = 100.18

CCC = -28.99



*Compare and analyze thoroughly the CCC for the five companies

1. Analyze the CCC for the five companies. How does the CCC compare across the different companies?

2. Analyze the relationship between CCC and the company’s profitability for all five companies

3. Analyze the relationship between CCC and the size of the company (measured by total assets) for all five companies









Solutions

Expert Solution

Compare and analyze thoroughly the CCC for the five companies

Cash Conversion Cycle depicts time it takes for a firm to convert the inventory into cash from the sales. So, if we assume there are 360 days in a year and there are two companies with CCC of 60 and 180 respectively. Using the same amount of investment first company can run 6 cycles(360/6) of inventory to cash from sales, where as 2nd company can have only 2 cycles (360/180).

Hence, it depicts efficiency of operating cycle of the company.

1. Analyze the CCC for the five companies. How does the CCC compare across the different companies?

Of the companies given above, Nike has the highest CCC where as Amazon has lowest CCC. It means Nike takes 88.33 days to convert its investments in the inventory into cash from the sales. Similarly BestBuy takes only 12.88 days for the same. Negative CCC for Amazon means that Payable period for it is very high, it means Amazon is actually working on a negative capital and actually does not need to invest cash in its own operation, cash needed for its operations are actually funded by its accounts payables.

2. Analyze the relationship between CCC and the company’s profitability for all five companies

Although it is expected that company with lower CCC will be more profitable, but that is not actually true. CCC only depicts operational efficiency, a company with very low CCC might still be a loss making company.

For example profitability of BestBuy = 1 - (COGS/Sales) = 23%
for McDonalds profitability = 90%

Hence although CCC for McD is 48.87 as compared to 12.88 for BestBuy, still McDonalds is more profitable.

3. Analyze the relationship between CCC and the size of the company (measured by total assets) for all five companies

CCC is also not correlated with the size of the company. CCC only takes into account two assets, i.e. Inventory and accounts receivable, but size of the company also takes into account other assets like Fixed Assets etc. So we can not construe a direct relationship bewteen CCC and size of the company.


Related Solutions

Ratios: Answer the following questions. a. Galaxy Sales has sales of $746,700, cost of goods sold...
Ratios: Answer the following questions. a. Galaxy Sales has sales of $746,700, cost of goods sold of $603,200, and inventory of $94,300. How long on average does it take the firm to sell its inventory? b. Goshen Industrial Sales has sales of $828,900, total equity of $539,200, a profit margin of 4.6 percent and a debt-equity ratio of 0.55. What is the return on assets? c. Freedom Health Centers has total equity of $861,300, sales of $1.48 million, and a...
Calculation of Cost of Goods Sold: Periodic Inventory System Prepare the cost of goods sold section...
Calculation of Cost of Goods Sold: Periodic Inventory System Prepare the cost of goods sold section for Adams Gift Shop. The following amounts are known: Beginning merchandise inventory $27,050 Ending merchandise inventory 22,550 Purchases 77,125 Purchases returns and allowances 4,055 Purchases discounts 5,745 Freight-in 230 Adams Gift Shop Cost of Goods Sold Cost of goods sold: $ $ $ $ $ Cost of goods sold $
In recording the cost of goods sold for cash, based on data available from perpetual inventory...
In recording the cost of goods sold for cash, based on data available from perpetual inventory records, the journal entry is a. debit Inventory; credit Cost of Goods Sold b. debit Accounts Receivable; credit Inventory c. debit Cost of Goods Sold; credit Sales d. debit Cost of Goods Sold; credit Inventory
CASH CONVERSION CYCLE Zane Corporation has an inventory conversion period of 52 days, an average collection...
CASH CONVERSION CYCLE Zane Corporation has an inventory conversion period of 52 days, an average collection period of 37 days, and a payables deferral period of 25 days. Assume 365 days in year for your calculations. What is the length of the cash conversion cycle? Round your answer to two decimal places.   days If Zane's annual sales are $3,427,440 and all sales are on credit, what is the investment in accounts receivable? Do not round intermediate calculations. Round your answer...
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 Working Capital Cycle? Use 1 year = 365 days 11 days. 46 days. 22 days 56 days.
If a company has a cash-conversion cycle of 15 days, an average age of inventory of...
If a company has a cash-conversion cycle of 15 days, an average age of inventory of 40 days and an average payment period of 60 days, calculate the average collection period.
which of the following statements regarding cash conversion cycle are TRUE? A. Cash conversion cycle depicts...
which of the following statements regarding cash conversion cycle are TRUE? A. Cash conversion cycle depicts the amount of days it takes for the firm to receive cash from sales B. Cash conversion cycle is calculated as follows: day sales outstanding + days payable outstanding - days inventory outstanding C. Cash conversion cycle is a measure of liquidity risk D. Cash conversion cycle measure the time it takes for the firm to exhaust its cash in its operations
Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.
Exercise 6-4A Calculate inventory amounts when costs are rising (LO6-3)During the year, TRC Corporation has the following inventory transactions.DateTransactionNumber of UnitsUnit CostTotal CostJan.1Beginning inventory52$44$2,288Apr.7Purchase132466,072Jul.16Purchase202499,898Oct.6Purchase112505,600498$23,858For the entire year, the company sells 432 units of inventory for $62 each.Exercise 6-4A Part 22. Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.
Alamo company has sales, cost of goods sold, and average ending inventory for the current year...
Alamo company has sales, cost of goods sold, and average ending inventory for the current year in the following amounts: $650,000, $500,000,and $128,000,respectively. calculate the amount of the company's inventory turnover for the year. what is the company's average number of days to sell inventory
Sales (all on account) $ 773,000 $ 607,000 Cost of goods sold 462,000 402,000 Average inventory...
Sales (all on account) $ 773,000 $ 607,000 Cost of goods sold 462,000 402,000 Average inventory during the year 130,000 120,000 Average receivables during the year 150,000 100,000 a-1. Compute the gross profit percentage for both years. (Round your percentage answers to the nearest whole number. i.e. 0.1234 as 12%.) a-2. Compute the inventory turnover for both years. (Round your answers to 1 decimal place.) a-3. Compute the accounts receivable turnover for both years. (Round your answers to 1 decimal...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT