2021 Sales Cost of goods sold Accounts receivable $ 282,880 128,200 18,100 2020 $ 270,800 122,080 17,300 2019 $ 252,600 115,280 16,400 2018 $ 234,560 106,440 15,200 2017 $ 150,000 67,000 9,000 Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable. 2021: 2020: 2019: 2018: 2017: Trend Percent for Net Sales: Numerator: Denominator: 1 = Trend percent 1 = % = % 1 Is the trend percent for Net Sales favorable or unfavorable? Trend Percent for Cost of Goods Sold: Numerator: Denominator: = % = % Trend percent = % = % 2021: 2020: 2019: 1 1 = 2018: = 2017: = Is the trend percent for Cost of Goods Sold favorable or unfavorable? 2021: 2020: 2019: 2018: 2017: Numerator: Trend Percent for Accounts Receivable: 1 Denominator: = Trend percent % = % = % Is the trend percent for Accounts Receivable favorable or unfavorable? =

2021 Sales Cost of goods sold Accounts receivable $ 282,880 128,200 18,100 2020 $ 270,800 122,080 17,300 2019 $ 252,600 115,280 16,400 2018 $ 234,560 106,440 15,200 2017 $ 150,000 67,000 9,000 Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable. 2021: 2020: 2019: 2018: 2017: Trend Percent for Net Sales: Numerator: Denominator: 1 = Trend percent 1 = % = % 1 Is the trend percent for Net Sales favorable or unfavorable? Trend Percent for Cost of Goods Sold: Numerator: Denominator: = % = % Trend percent = % = % 2021: 2020: 2019: 1 1 = 2018: = 2017: = Is the trend percent for Cost of Goods Sold favorable or unfavorable? 2021: 2020: 2019: 2018: 2017: Numerator: Trend Percent for Accounts Receivable: 1 Denominator: = Trend percent % = % = % Is the trend percent for Accounts Receivable favorable or unfavorable? =

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter8: Current And Contingent Liabilities

Section: Chapter Questions

Problem 61E: Recording Various Liabilities Glenview Hardware had the following transactions that produced...

See similar textbooks

Similar questions

Recording Various Liabilities Glenview Hardware had the following transactions that produced liabilities during 2020: a. Purchased merchandise on credit for $30,000. ( Note: Assume a periodic inventory system.) b. Year-end wages of $10,000 were incurred, but not paid. Related federal income taxes of $1,200, Social Security of $620 (employee portion), and Medicare taxes of $145 were with-held from employees. c. Year-end estimated income taxes payable, but unpaid, for the year were $42,850. d. Sold merchandise on account for $1,262, including state sales taxes of S48. ( Note: Assume a periodic inventory system.) e. Employers share of Social Security and Medicare taxes for the period were $620 and $145, respectively. f. Borrowed cash under a 90-day, 9%, $25,000 note. Required: Prepare the entry to record each of these transactions (treat each transaction independently).
Income Statement for Year Ended December 31, 2018 (Millions of Dollars) Net sales 795.0 Cost of goods sold 660.0 Gross profit 135.0 Selling expenses 73.5 EBITDA 61.5 Depreciation expenses 12.0 Earnings before interest and taxes (EBIT) 49.5 Interest expenses 4.5 Earnings before taxes (EBT) 45.0 Taxes (40%) 18.0 Net income 27.0 a. Calculate the ratios you think would be useful in this analysis. b. Construct a DuPont equation, and compare the companys ratios to the industry average ratios. c. Do the balance-sheet accounts or the income statement figures seem to be primarily responsible for the low profits? d. Which specific accounts seem to be most out of line relative to other firms in the industry? e. If the firm had a pronounced seasonal sales pattern or if it grew rapidly during the year, how might that affect the validity of your ratio analysis? How might you correct for such potential problems?
2021 2020 2019 2018 2017 Sales $ 489,967 $ 322,347 $ 256,850 $ 180,880 $ 136,000 Cost of goods sold 252,383 166,097 134,444 94,199 69,360 Accounts receivable 23,763 18,857 17,594 10,600 9,302 Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable.
Computing and analyzing trend percents LO P1 2021 2020 2019 2018 2017 Sales $ 446,122 $ 293,501 $ 242,563 $ 173,880 $ 128,800 Cost of goods sold 221,100 145,365 122,206 87,101 63,112 Accounts receivable 21,592 17,140 16,664 10,137 8,784 Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable.
Compute trend percent for the following accounts using 2018 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percent appears to be favorable or unfavorable. 2022 2021 2020 2019 2018 Sales $282,880 $270,800 $252,600 $234,560 $150,000 Cost of goods sold 128,200 122,080 115,280 106,440 67,000 Accounts receivable 18,100 17,300 16,400 15,200 9,000
Net Sales Cost of goods sold Average accounts receivable for the year Accounts receivable at year-end Average inventory for the year Inventory at year-end $1,095,000 657,000 44,250 18,000 226,000 158,400 Required: a. Calculate the inventory turnover for 2019.
Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable. Sales $ 666,761 $ 432,962 $ 344,990 $ 249,090 $ 180,500 Cost of goods sold 329,263 213,901 172,445 124,054 88,445 Accounts receivable 32,138 25,242 23,632 14,547 12,328
Bond Company reported the following inventory data:Year Inventory (in millions)2016201720182019$2,500$2,350$2,600$2,170Use 2016 as the base year. The trend percentage in 2019 is closest toa. 83%.b. 87%.c. 92%.d. 115%.
The following information is available for Grace Company for 2020: Disbursements for purchases P1,050,000; Increase in trade accounts payable 75,000; Decrease in merchandise inventory 30,000; Costs of goods sold for 2010 was P1,155,000. P1,095,000. P945,000.
Days Sales in Inventory Accounts Receivable Turnover Calcute each ratio from the data for 2019 and 2020
Assume the following cost of goods sold data for a company: 2023 $1295360 2022 1209000 2021 1012000 If 2021 is the base year, what is the percentage increase in cost of goods sold from 2021 to 2023?
Kincaid Company reported the following data (in millions) for the past two years:2019 2018$$$$$2801501304090$$$$$2501401103575Net revenues........................................Cost of goods sold...............................Gross profit..........................................Operating expenses..............................Operating income................................In a vertical analysis of 2019, the operating expenses percentage is closest toa. 225%.b. 69%.c. 14%.d. 32%.