Please solve all parts... 6-41Module 6 Inventories, Accounts Payable, and Long-Term AssetsSales.Cost of sales.Gross profit.Inventory..Total assetsCarrefour Group in€ millions2018€76,00060,85015,1506,13547,3782017€78,31562,31116,0046,69047,813Ⓒ Cambridge Business PublishersTesco PLC in£ millions20182017£57,491 €55,91754,14153,0153,3502,9022,26344,862Requireda. Calculate gross profit margin for each year for both companies.b. Determine the common-size inventory for each year for both companies.2,30145,853c. Compute inventory turnover and days average inventory outstanding for 2018.d. Based on the metrics in parts a, b, and c, how do we assess the two companies' inventorymanagement?

The financial statement analysis refers to the process of assessing the financial statements of a…

41 Module 6 Inventories, Accounts Payable, and Long-Term Assets Sales. Cost of sales. Gross profit.. Inventory.. Total assets Carrefour Group in € millions 2018 €76,000 60,850 15,150 6,135 47,378 2017 €78,315 62,311 16,004 6,690 47,813 Ⓒ Cambridge Business Publishers Tesco PLC in £ millions 2018 £57,491 54,141 3,350 2,263 44,862 2017 €55,917 53,015 2,902 2,301 45,853 Required a. Calculate gross profit margin for each year for both companies. b. Determine the common-size inventory for each year for both companies. c. Compute inventory turnover and days average inventory outstanding for 2018. d. Based on the metrics in parts a, b, and c, how do we assess the two companies' inventory

41 Module 6 Inventories, Accounts Payable, and Long-Term Assets Sales. Cost of sales. Gross profit.. Inventory.. Total assets Carrefour Group in € millions 2018 €76,000 60,850 15,150 6,135 47,378 2017 €78,315 62,311 16,004 6,690 47,813 Ⓒ Cambridge Business Publishers Tesco PLC in £ millions 2018 £57,491 54,141 3,350 2,263 44,862 2017 €55,917 53,015 2,902 2,301 45,853 Required a. Calculate gross profit margin for each year for both companies. b. Determine the common-size inventory for each year for both companies. c. Compute inventory turnover and days average inventory outstanding for 2018. d. Based on the metrics in parts a, b, and c, how do we assess the two companies' inventory

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter1: The Role Of Accounting In Business

Section: Chapter Questions

Problem 1.4.2MBA: Return on assets The following data (in millions) were adapted from recent financial statements of...

See similar textbooks

Similar questions

Corporation.Gross income $25,240,000Total sales 24,324,000Total credit sales 18,785,000Net income 2,975,000Cost of goods sold 12,600,000Total assets 10,550,000Average inventory 2,875,000Average receivables 3,445,000a. Compute the receivable turnover ratio.b. Compute the inventory turnover ratio.c. Compute the asset turnover ratio.
Case 2 Company ABC Assets turnover Gross Sales Sales Discounts Gross Profit Operating Profit Permanent Capital Financial Leverage 2% 1.050.000 35000 18% 9% 345.000,00 35% Acid Test ratio 1,5% Fixed assets turnover 4 Liquid assets 10% Tangible fixed assets/ Shareholders Equity 30% Requirement: Prepare the Balance Sheet and Income Statement of Company ABC
Worksheet chapter 9 Assets 2,980,000 Liabilities 1,250,000 Inventory 1,410,000 Sales 5,000,000 Avg Inventory 1,500,000 Accounts Receivable 1,320,000 Debt 1,000,000 Given the data above, provide the following calculations: Debt ratio Total asset turnover Receivables turnover Inventory turnover Quick ratio Current ratio Given the above data, construct a balance sheet
Data needed: SFP Asset section 1. Cash 16.3% 2. AR 6.3% 3. Short term investment 0.2% 4. Inventory 2.2% 5. Prepaid expenses 0.4% 6. PPE 74.7% Data needed: SFP Liabilities and OE section. 1. Current liab 16% 2. Non-current liab 34.2% 3. OE 49.9% Data needed: SCI 1. COGS 38.6% 2. Selling and admin exp 6.8% 3. Interest exp 0.1% 4. Income tax exp 0.5% 5. Net income 54%
Question 1 The following information represent Mooncake Corporation Details Sales Cash Inventory Current liabilities Asset turnover Current ratio Debt to asset ratio Receivables turnover Calculate the following items: a. Accounts receivables b. Fixed asset c. Long Term Debt d. Debt to Asset Ratio RM 3,549,000 179,000 911,000 788,000 1.40 2.95 times 40% 7 times
16. Quick assets P208,000 Acid test ratio 2.6 to 1 Current ratio 3.5 to 1 Net sales for the year P1,800,000 Cost of sales for the year P990,000 Average total assets P1,200,000 The company’s inventory balances at December 31 is? The company’s asset turnover ratio for the year is?
The comparative statements of Waterway Company are presented here. Waterway CompanyIncome StatementsFor the Years Ended December 3120222021Net sales$1,813,300 $1,753,100 Cost of goods sold1,008,900 983,000 Gross profit804,400 770,100 Selling and administrative expenses516,800 477,800 Income from operations287,600 292,300 Other expenses and losses Interest expense18,900 14,800 Income before income taxes268,700 277,500 Income tax expense78,224 77,700 Net income$ 190,476 $ 199,800 Waterway CompanyBalance SheetsDecember 31Assets20222021Current assets Cash$60,200 $64,500 Debt investments (short-term)70,600 49,200 Accounts receivable (net)117,800 102,700 Inventory123,600 114,700 Total current assets372,200 331,100 Plant assets (net)602,200 517,900 Total…
The comparative statements of Waterway Company are presented here. Waterway CompanyIncome StatementsFor the Years Ended December 3120222021Net sales$1,813,300 $1,753,100 Cost of goods sold1,008,900 983,000 Gross profit804,400 770,100 Selling and administrative expenses516,800 477,800 Income from operations287,600 292,300 Other expenses and losses Interest expense18,900 14,800 Income before income taxes268,700 277,500 Income tax expense78,224 77,700 Net income$ 190,476 $ 199,800 Waterway CompanyBalance SheetsDecember 31Assets20222021Current assets Cash$60,200 $64,500 Debt investments (short-term)70,600 49,200 Accounts receivable (net)117,800 102,700 Inventory123,600 114,700 Total current assets372,200 331,100 Plant assets (net)602,200 517,900 Total…
Accounts receivable (gross) Inventory Total current assets Total current liabilities Credit sales Cost of goods sold Current ratio Receivables turnover Inventory turnover 2021 1.000.000 $850,000 $750,000 $650,000 1.020,000 980,000 840,000 2,100,000 2,000,000 1,700,000 1.100.000 1,250,000 6.420.000 6.240,000 5.430.000 4,540,000 4,550,000 3,950,000 (b) Based on (1) current ratio, (2) receivables turnover ratio, and (3) inventory turnover ratio, what conclusion(s) can be drawn about the company's liquidity? 2021 21:1 2020 8.0 times 4.5 times 2020 2019 18:1 8.9 times 5.0 times.
Twenty metrics of liquidity, solvency, and profitability The comparative financial statements of Automotive Solutions Inc. are as follows. The market price of Automotive Solutions Inc. common stock was $119.70 on December 31, 20Y8 Instructions Return on total assets
Sales transactions Using transactions listed in P4-2, indicate the effects of each transaction on the liquidity metric working capital and profitability metric gross profit percent. Indicate the gross profit percent for each sale (rounding to one decimal place) in parentheses next to the effect of the sale on the company’s ability to attain an overall gross profit percent of 30%.
Twenty metrics of liquidity, solvency, and profitability The comparative financial statements of Automotive Solutions Inc. are as follows. The market price of Automotive Solutions Inc. common stock was $119.70 on December 31, 20Y8 Instructions Ratio of fixed assets to long-term liabilities