Question

In: Accounting

You are a financial analyst and are comparing financial ratios of two competing companies in the...

  1. You are a financial analyst and are comparing financial ratios of two competing companies in the consumer packaged goods sector: Kellogg’s company and General Mills. The 2018 turnover ratios for the two companies are summarized in the following table:

                  K

                G

Days sales outstanding

37.24

36.11

Days inventory outstanding

52.72

55.32

Days payable outstanding

97.16

86.11

By comparison, which company has better cash conversion cycle? What conclusions do you get regarding the two companies’ management in accounts receivable, inventory and accounts payable? What suggestions you would make to improve their management in these three aspects respectively?

Solutions

Expert Solution

Cash conversion cycle: -

The cash conversion cycle is a tool that expresses the time [measured in days] it takes for a company to convert its investments in inventory and other resources into cash flows from sales.

In the given case, when comparing the ratios of Kelloggs and General Mills; -

The following observations/conclusions are: -

Kelloggs receivable and inventory is 37.24 and 52.72 and while General is 36.11 and 55,32 which means kelloggs is able to sale more because it has higher receivable than General. Moreover, Kelloggs inventory level is 52.72 as compared to General (55.32) which indicates kelloggs purchasing and ordering inventory is as per their needs and have studied the market demand while General inventory level is 55.33 slighty higher in comparison to Kelloggs and more gap would be found if we see the sale levels as well. kelloggs planning must have led to lower working capital requirement as compared to General. Hence, interest cost is saved in Kelloggs while General had to pay more interest as they a have not planned well.

However, Kelloggs Payable is way higher in comparison to General's payable. General operating cash flow must be higher than Kelloggs as General has lower cash outflows.

Suggestions:-

Hence, Kelloggs have to ascertain and analyse their payables and decide if any avoidable payables are their or not and correct it accordingly, so that payables ratio improve.

General should increase their sales as they have more inventory by spending on advertisement or buy as per market demand only so that working capital does't get blocked and use that saved working capital for other purpose or paying off any loan.


Related Solutions

QUESTION 11 A financial analyst is comparing two companies using a top-down approach. Which of the...
QUESTION 11 A financial analyst is comparing two companies using a top-down approach. Which of the following would cause the biggest problem in the evaluation process? One company's financial year-end is 31 October, while the other company's financial year-end is 31 December. The companies operate in different industries. One company has been in business significantly longer than the other company. Inflation has been low for several years QUESTION 9 Selected data from the financial statements of Ned Kelly (NK) are...
Comparing Profitability and Turnover Ratios for Retail Companies Selected financial statement data for Best Buy Co.,...
Comparing Profitability and Turnover Ratios for Retail Companies Selected financial statement data for Best Buy Co., Inc., The Kroger Co., Nordstrom, Inc., Staples, Inc., and Walgreen Co. is presented in the following table: ($ millions) Best Buy Kroger Nordstrom Staples Walgreen Sales revenue $40,339 $108,465 $13,506 $22,492 $76,392 Cost of sales 31,292 85,512 8,406 16,691 54,823 Interest expense 90 488 138 49 156 Net income 1,233 1,728 720 135 1,932 Average receivables 1,294 1,191 2,489 1,883 2,925 Average inventories 5,275...
As you retrieve this information, consider companies’ financial ratios, including activity ratios, debt ratios, and profitability...
As you retrieve this information, consider companies’ financial ratios, including activity ratios, debt ratios, and profitability and market ratios. Also, consider what you, as a financial manager, would have done differently or suggested as improvements. Background: Describe both of the firms and their management, including their strategic objectives. Provide sufficient detail to support the rest of your analysis. III. Evaluation of the Firms A. Analyze companies’ cash flow management practices for the last three fiscal years, including cash, accounts receivables,...
Summary information from the financial statements of two companies competing in the same industry follows.   ...
Summary information from the financial statements of two companies competing in the same industry follows.    Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 770,000 $ 880,200 Cash $ 19,500 $ 34,000 Cost of goods sold 585,100 632,500 Accounts receivable, net 46,500 64,600 Interest expense 7,900 13,000 Merchandise inventory 84,440 132,500 Income tax expense 14,800 24,300 Prepaid expenses 5,000 6,950 Net income 162,200...
Presented below are condensed financial statements adapted from those of two actual companies competing in the...
Presented below are condensed financial statements adapted from those of two actual companies competing in the pharmaceutical industry—Benatar and Jett, Inc. ($ in millions, except per share amounts). Balance Sheets ($ in millions, except per share data) Benatar Jett Assets: Cash $ 18,143 $ 12,398 Short-term investments 6,390 12,646 Accounts receivable (net) 9,184 11,385 Inventory 6,016 10,135 Other current assets 6,100 5,965 Current assets 45,833 52,529 Property, plant, and equipment (net) 16,254 24,695 Intangibles and other assets 20,030 73,355 Total...
Summary information from the financial statements of two companies competing in the same industry follows. Barco...
Summary information from the financial statements of two companies competing in the same industry follows. Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 810,000 $ 923,200 Cash $ 20,000 $ 35,000 Cost of goods sold 589,100 636,500 Accounts receivable, net 35,400 51,400 Interest expense 9,300 11,000 Current notes receivable (trade) 9,000 8,400 Income tax expense 15,569 25,487 Merchandise inventory 84,940 140,500 Net income...
Summary information from the financial statements of two companies competing in the same industry follows. Barco...
Summary information from the financial statements of two companies competing in the same industry follows. Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 790,000 $ 927,200 Cash $ 18,500 $ 37,000 Cost of goods sold 588,100 642,500 Accounts receivable, net 36,400 59,400 Interest expense 8,200 16,000 Current notes receivable (trade) 10,000 7,800 Income tax expense 15,185 25,597 Merchandise inventory 84,340 140,500 Net income...
Summary information from the financial statements of two companies competing in the same industry follows. Barco...
Summary information from the financial statements of two companies competing in the same industry follows. Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 800,000 $ 926,200 Cash $ 18,500 $ 34,000 Cost of goods sold 594,100 642,500 Accounts receivable, net 39,400 53,400 Interest expense 8,400 15,000 Current notes receivable (trade) 9,700 7,400 Income tax expense 15,377 25,570 Merchandise inventory 84,540 134,500 Net income...
Summary information from the financial statements of two companies competing in the same industry follows. Barco...
Summary information from the financial statements of two companies competing in the same industry follows. Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 780,000 $ 919,200 Cash $ 21,000 $ 37,000 Cost of goods sold 588,100 642,500 Accounts receivable, net 39,400 54,400 Interest expense 8,100 19,000 Current notes receivable (trade) 9,200 7,200 Income tax expense 14,992 25,376 Merchandise inventory 84,340 132,500 Net income...
Presented below are condensed financial statements adapted from those of two actual companies competing in the...
Presented below are condensed financial statements adapted from those of two actual companies competing in the pharmaceutical industry—Johnson and Johnson (J&J) and Pfizer, Inc. ($ in millions, except per share amounts). Balance Sheets ($ in millions, except per share data) J&J Pfizer Assets: Cash $ 5,377 $ 1,520 Short-term investments 4,146 10,432 Accounts receivable (net) 6,574 8,775 Inventories 3,588 5,837 Other current assets 3,310 3,177 Current assets 22,995 29,741 Property, plant, and equipment (net) 9,846 18,287 Intangibles and other assets...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT