The current assets for OPAL, Inc. were: 2019: Cash $10,000; Accounts Receivable $24,000 and Inventory $36,000 for 2020: Cash $14,000; Accounts Receivable $26,000 and Inventory $44,000. The top part of the income statement for OPAL in 2020 was: Sales Revenue $400,000; Cost of Goods Sold $240,000 and Gross Profit Margin $160,000. Compute the following financial ratios: calculating turnover ratios to the nearest 0.1 times per year and percentage ratios to the nearest 0.1%. For blank one: calculate Accounts Receivable Turnover; for blank two, calculate Inventory Turnover; for blank three, calculate Gross Profit Margin. Blank # 1 Blank # 2 Blank # 3

The current assets for OPAL, Inc. were: 2019: Cash $10,000; Accounts Receivable $24,000 and Inventory $36,000 for 2020: Cash $14,000; Accounts Receivable $26,000 and Inventory $44,000. The top part of the income statement for OPAL in 2020 was: Sales Revenue $400,000; Cost of Goods Sold $240,000 and Gross Profit Margin $160,000. Compute the following financial ratios: calculating turnover ratios to the nearest 0.1 times per year and percentage ratios to the nearest 0.1%. For blank one: calculate Accounts Receivable Turnover; for blank two, calculate Inventory Turnover; for blank three, calculate Gross Profit Margin. Blank # 1 Blank # 2 Blank # 3

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter15: Financial Statement Analysis

Section: Chapter Questions

Problem 56P: The following selected information is taken from the financial statements of Arnn Company for its...

See similar textbooks

Similar questions

The following information is available for Cooke Company for the current year: The gross margin is 40% of net sales. What is the cost of goods available for sale? a. 5840,000 b. 960,000 c. 1,200,000 d. 1,220,000
The following selected information is taken from the financial statements of Arnn Company for its most recent year of operations: During the year, Arnn had net sales of 2.45 million. The cost of goods sold was 1.3 million. Required: Note: Round all answers to two decimal places. 1. Compute the current ratio. 2. Compute the quick or acid-test ratio. 3. Compute the accounts receivable turnover ratio. 4. Compute the accounts receivable turnover in days. 5. Compute the inventory turnover ratio. 6. Compute the inventory turnover in days.
Refer to RE22-2. Assume Heller Company had sales revenue of 510,000 in 2019 and 650,000 in 2020. Prepare Hellers partial income statements (through gross profit) for 2019 and 2020. RE22-2 Heller Company began operations in 2019 and used the LIFO method to compute its 300,000 cost of goods sold for that year. At the beginning of 2020, Heller changed to the FIFO method. Heller determined that its cost of goods sold under FIFO would have been 250,000 in 2019. For 2020, Hellers cost of goods sold under FIFO was 360,000, while it would have been 410,000 under LIFO. Heller is subject to a 21% income tax rate. Compute the cumulative effect of the retrospective adjustment on prior years income (net of taxes) that Heller would report on its retained earnings statement for 2020.
The 2021 income statement of Adrian Express reports sales of $14,097,000, cost of goods sold of $8,154,000, and net income of $1,540,000. Balance sheet information is provided in the following table. ADRIAN EXPRESSBalance SheetsDecember 31, 2021 and 2020 2021 2020 Assets Current assets: Cash $ 540,000 $ 700,000 Accounts receivable 1,280,000 940,000 Inventory 1,680,000 1,340,000 Long-term assets 4,740,000 4,180,000 Total assets $ 8,240,000 $ 7,160,000 Liabilities and Stockholders' Equity Current liabilities $ 1,960,000 $ 1,600,000 Long-term liabilities 2,240,000 2,340,000 Common stock 1,880,000 1,880,000 Retained earnings 2,160,000 1,340,000 Total liabilities and stockholders' equity $ 8,240,000 $ 7,160,000 Industry averages for the following four risk ratios are as follows:…
Ayayai Ltd. had the following 2020 income statement data: Sales $205,600 Cost of goods sold 119,400 Gross profit 86,200 Operating expenses (includes depreciation of $22,400) 48,300 Income before income taxes 37,900 Income taxes 15,000 Net income $22,900 The following accounts increased during 2020 by the amounts shown: Accounts Receivable, $16,000; Inventory, $10,500; Accounts Payable (relating to inventory), $14,000; Taxes Payable, $2,000; and Mortgage Payable, $40,200.
The 2021 income statement of Adrian Express reports sales of $15,960,000, cost of goods sold of $9,600,000, and net income of $1,600,000. Balance sheet information is provided in the following table. ADRIAN EXPRESS Balance Sheets December 31, 2021 and 2020 2021 2020 Assets Current assets: Cash Accounts receivable $ 600,000 $ 760,000 1,400,000 1,800,000 4,800,000 $8,600,000 1,000,000 1,400,000 4,240,000 $7,400,000 Inventory Long-term assets Total assets Liabilities and Stockholders' Equity Current liabilities $2,020,000 2,300,000 2,000,000 2,280,000 $8,600,000 $1,660,000 2,400,000 2,000,000 1,340,000 $7,400,000 Long-term liabilities Common stock Retained earnings Total liabilities and stockholders' equity Industry averages for the following four risk ratios are as follows: Average collection period Average days in inventory Current ratio 25 days 60 days 2 to 1 50% Debt to equity ratio
The 2021 income statement of Adrian Express reports sales of $22,710,000, cost of goods sold of $13,100,000, and net income of $2,380,000. Balance sheet information is provided in the following table. ADRIAN EXPRESSBalance SheetsDecember 31, 2021 and 2020 2021 2020 Assets Current assets: Cash $ 1,040,000 $ 1,030,000 Accounts receivable 2,025,000 1,355,000 Inventory 2,595,000 1,925,000 Long-term assets 5,240,000 4,510,000 Total assets $ 10,900,000 $ 8,820,000 Liabilities and Stockholders' Equity Current liabilities $ 2,294,000 $ 1,964,000 Long-term liabilities 2,706,000 2,704,000 Common stock 2,325,000 2,155,000 Retained earnings 3,575,000 1,997,000 Total liabilities and stockholders' equity $ 10,900,000 $ 8,820,000 Industry averages for the following profitability ratios are as follows:…
The 2021 income statement of Adrian Express reports sales of $22,710,000, cost of goods sold of $13,100,000, and net income of $2,380,000. Balance sheet information is provided in the following table. ADRIAN EXPRESSBalance SheetsDecember 31, 2021 and 2020 2021 2020 Assets Current assets: Cash $ 1,040,000 $ 1,030,000 Accounts receivable 2,025,000 1,355,000 Inventory 2,595,000 1,925,000 Long-term assets 5,240,000 4,510,000 Total assets $ 10,900,000 $ 8,820,000 Liabilities and Stockholders' Equity Current liabilities $ 2,294,000 $ 1,964,000 Long-term liabilities 2,706,000 2,704,000 Common stock 2,325,000 2,155,000 Retained earnings 3,575,000 1,997,000 Total liabilities and stockholders' equity $ 10,900,000 $ 8,820,000 Industry averages for the following profitability ratios are as follows:…
The 2021 Income statement of Adrian Express reports sales of $16,932,000, cost of goods sold of $10,363,500, and net income of $1,630,000. Balance sheet information is provided in the following table. ADRIAN EXPRESS Balance Sheets December 31, 2021 and 2020 2021 2020 Assets Current assets: $ 630,000 $ 790,000 Cash Accounts receivable Inventory 1,460,000 1,860,000 4,830,000 $8,780,000 $7,520,000 1,030,000 1,430,000 4, 270,000 Long-term assets Total assets Liabilities and Stockholders' Equity Current liabilities Long-term liabilities $1,990,000 $1,690,000 2,330,000 1,970,000 2,490,000 2,430,000 1,970, 000 1,430,000 Common stock Retained earnings Total liabilities and stockholders' equity $8,780,000 $7,520,000 Industry averages for the following four risk ratios are as follows: Average collection period Average days in inventory Current ratio Debt to equity ratio 25 days 60 days 2 to 1 50% Requlred: 1. Calculate the four risk ratios listed above for Adrian Express in 2021. (Use 365 days…
The 2021 income statement of Adrian Express reports sales of $19,710,000, cost of goods sold of $12,350,000, and net income of $1,780,000. Balance sheet information is provided in the following table. Assets Current assets: Cash ADRIAN EXPRESS Balance Sheets December 31, 2021 and 2020 Accounts receivable Inventory Long-term assets Total assets Liabilities and Stockholders' Equity Current liabilities Long-term liabilities Common stock Retained earnings Total liabilities and stockholders' equity Gross profit ratio Return on assets Profit margin Asset turnover Return on equity 45% 25% 15% 2021 Industry averages for the following profitability ratios are as follows: 3.5 times 35% 2020 $ 740,000 $ 880,000 1,650,000 1,130,000 2,070,000 1,550,000 4,940,000 4,360,000 $9,400,000 $7,920,000 $1,964,000 $1,784,000 2,436,000 2,524,000 1,950,000 1,930,000 3,050,000 1,682,000 $9,400,000 $7,920,000
Data taken from the records of XYZ Co. revealed the following for 2020: Inventory - January 1 :P2,000,000; Net purchases : P7,000,000; Inventory - December 31 : P2,800,000; Sales Returns and allowances: P750,000. Gross profit based on net sales is 20%. How much is the gross sales for 2020? A. P7,000,000 B. P7,750,000 C. P8,500,000 D. P9,125,000 E. answer not given
The following information is shown in the accounting records of ToDas Company for the current year 2020. Balances as of Jan 1 Cash 620,000; Accounts receivable 670,000; Inventory 860,000; Accounts Payable 530,000. Balances as of Dec 31 Accounts receivable 900,000; Inventory 780,000; Accounts Payable 480,000. The total sales and cost of goods sold were P7,980,000 and P5,830,000, respectively. All sales and all merchandise purchases were made on credit. Various expenses of P1,070,000 were paid on cash. Assume that there were no other pertinent transactions. The cash balance on December 31, 2020