Part-1 | ||||
Calculation of ratios: | ||||
Particulars | Formula | Kroger Co | Whole foods market | |
1 | Current ratio | Current ratio= Current assets/Current
liabilities Kroger= 8911/11408=2.08 Whole foods= 1544/1252= 2.78 |
0.78 | 1.23 |
2 | Average days to sell inventory | Average collection period=(Average
Inventory*365)/Revenue Average inventory: Kroger= (6933+6801)/2=6867 Whole Foods= (500+441)/2=471 Average collection: Kroger= 6867*365/108665=23.06 Whole foods=471*365/15389=11.17 |
23.06 | 11.17 |
3 | Debt to asset | Formula: Total debt/ Total assets Kroger= 25114/30356=0.83 Whole foods=1972/5741=0.34 |
0.83 | 0.34 |
4 | Reurn on investment | Earnings*100/ Investment Kroger=2649/5442=48% Whole foods=878/3769=23% |
48% | 23% |
5 | Gross margin percentage | Gross profit*100/Revenue Kroger= 22953*100/108665=21.12% Whole foods= 5416*100/15389=35.19% |
21.12% | 35.19% |
6 | Asset turnover | Sales/ Total assets Kroger= 108665/30356=3.58 Whole foods= 15389/5741=2.68 |
3.58 | 2.68 |
7 | Return on sales | Earnings from contiuing
operations/Revenue Kroger= 2649*100/108665=24.38% Whole Foods= 878*100/15389=5.71% |
24.38% | 5.71% |
8 | Plant assets to long term debt | Plant-: Kroger=17912 Whole foods=3163 Ratio=: Kroger=17912/13711=1.31 Whole foods=3163/65=48.66 |
1.31 | 48.66 |
Part-2
Written Analysis:
1) Current ratio. 2) Average days to sell inventory. (Use average inventory.) 4] Return on 5)...
f-Adobe Acrobat Reader DC Help Survey of Account x D 7101228 Analyze, Think, Communicate ATC 9-1 Business Applications Case Analyzing Kroger and Whole Foods El The following information relates to The Kroger Company for its 2015 and 2014 fiscal years, and Whole Foods Market, Inc. for its 2014 and 2013 fiscal years. THE KROGER COMPANY Selected Faancial Informaticn amounts n miion, except per share January 31, 015 s 8830 Propety and 710 / 1228 +) 200% 冏 THE KROGER COMPANY...
The following information relates to The Kroger Company for its 2015 and 2014 fiscal years, and Whole Foods Market, Inc. for its 2014 and 2013 fiscal years. THE KROGER COMPANY Selected Financial Information (amounts in millions, except per share amounts) January 31, 2015 February 1, 2014 Total current assets $ 8,911 $ 8,830 Merchandise inventory 8,178 7,951 Property and equipment, net of depreciation 17,912 16,893 Total assets 30,556 29,281 Total current liabilities 11,403 10,705 Total long-term liabilities 13,711 13,181 Total...
The following accounting information pertains to Boardwalk Taffy and Beach Sweets. The only difference between the two companies is that Boardwalk Taffy uses FIFO, while Beach Sweets uses LIFO. Cash Accounts receivable Merchandise inventory Accounts payable Cost of goods sold Building Sales Boardwalk Taffy $ 85,000 330,000 240,000 245,000 1,224,000 300,000 2,100,000 Beach Sweets $ 35,000 330,000 178,000 245,000 1, 228, 200 300,000 2,100,000 Required a-1. Compute the gross margin percentage for each company. a-2. Identify the company that appears...
The following accounting Information pertalns to Boardwalk Taffy and Beach Sweets. The only difference between the two companies Is that Boardwalk Taffy uses FIFO, whlle Beach Sweets uses LIFO. Cash Accounts receivable Merchandise inventory Accounts payable Cost of goods sold Building Sales $75,8ee 348,888 25e,888 285,888 1,35e,8ee 58e,888 2,8ee,8e8 $75,8ee 348,888 19e,888 285,8e8 1,254,0ee 58e,888 2,8ee,8e8 Required a-1. Compute the gross margin percentage for each company. a-2. Identify the company that appears to be charging the higher prices In relation...
prepare the following ratios for the current year. current ratio acid test ratio inventory turnover Days sales in average receivables. - Х Requirements Virginia's Crafts has provided the following data: (Click the icon to view the financial information.) Read the requirements Compute the following ratios for the current year for Virginia's Crafts: a. Current ratio b. Acid-test ratio c. Inventory turnover d. Days' sales in average receivables (assume all sales are on credit) a. Current ratio Enter the formula on...
Current ratio Return on assets Return on equity Inventory turnover AR turnover Debt to equity Profit margin Gross profit 2012 RATIOS Coke Dr. Pepper 1.33 1.11 3.9% 7.9% 15.3% 27.6% 14.8 12.7 12.3 8.5 11 1.7% 10.6% 40.5% 58.3% The ratios for Coke and Dr. Pepper for 2012 are shown above. Which ratios show signs of poor financial health for DR PEPPER? Current ratio Return on Assets II Return on Equity Debt to Equity
Ratio (1) Current ratio (2) Accounts receivable turnover (3) Average collection period (4) Inventory turnover (5) Days in inventory (6) Profit margin (7) Asset turnover (8) Return on assets (9) Return on common stockholders' equity (10) Debt to assets ratio (11) Times interest earned (12) Free cash flow Target 1.63 :1 8.6 times 42.0 days 6.6 times 55.3 days 3.8 % 1.5 times 5.6 % 17.1 % 66 % 6.5 times $3,656 Wal-Mart 0.87 :1 101.4 times 3.6 days 9.0...
More Info X Х a. Current ratio b. Cash ratio c. Acid-test ratio d. Inventory turnover e. Days' sales in inventory f. Days' sales in receivables g. Gross profit percentage Print Done und intermediary calculations to two decimal places X XX and round your final answer to a. Compute the current ratio for the current year. (Abbreviations used: STI = Short-term investments. Round your answer to two decimal places, X.XX.) Current ratio b. Compute the ca: 365 days / Accounts...
Instructions For 2017 and 2018, calculate current ratio, quick (acid-test) ratio, inventory turnover and days' inventory outstanding (DIO), accounts receivable turnover, days' sales in average receivables or days' sales outstanding (DSO), accounts payable turnover, days' payable outstanding (DPO), and cash conversion cycle (in days). a. Use the cost of goods sold in the formula for accounts payable turnover. b. Use a 365-day year for calculations as needed. c. Use cell references from prior calculations, if applicable. (Always use cell references...
Instructions For 2017 and 2018, calculate current ratio, quick (acid-test) ratio, inventory turnover and days' inventory outstanding (DIO), accounts receivable turnover, days' sales in average receivables or days' sales outstanding (DSO), accounts payable turnover, days' payable outstanding (DPO), and cash conversion cycle (in days). a. Use the cost of goods sold in the formula for accounts payable turnover. b. Use a 365-day year for calculations as needed. c. Use cell references from prior calculations, if applicable. (Always use cell references...