SalesCost of goods soldAccounts receivable2021$ 611,353302,06329,4672020$ 399,577197,54323,3752019$ 313,394156,76321,4992018$ 213,921105,87112,5572017$ 153,90075,41110,511Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether thesituation as revealed by the trend percents appears to be favorable or unfavorable. Numerator:Numerator:Trend Percent for Net Sales:2021:2020:2019:2018:2017:Is the trend percent for Net Sales favorable or unfavorable?1111111Numerator:Denominator:Trend Percent for Cost of Goods Sold:IDenominator:1111112021:2020:2019:2018:2017:Is the trend percent for Cost of Goods Sold favorable or unfavorable?Trend Percent for Accounts Receivable:Denominator:I111112021:2020:2019:2018:2017:Is the trend percent for Accounts Receivable favorable or unfavorable?||=||=11IIII=||=111111IITrend percentTrend percentTrend percent%%%%%%se88%%%

Introduction: Trend analysis is a tool used by the management to evaluate performance of the company…

Sales Cost of goods sold Accounts receivable 2021 $ 611,353 302,063 29,467 2020 $ 399,577 197,543 23,375 2019 $ 313,394 156,763 21,499 2018 $ 213,921 105,871 12,557 2017 $ 153,900 75,411 10,511 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 Cost of goods sold Accounts receivable 2021 $ 611,353 302,063 29,467 2020 $ 399,577 197,543 23,375 2019 $ 313,394 156,763 21,499 2018 $ 213,921 105,871 12,557 2017 $ 153,900 75,411 10,511 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.

College Accounting, Chapters 1-27

23rd Edition

ISBN:9781337794756

Author:HEINTZ, James A.

Publisher:HEINTZ, James A.

Chapter15: Financial Statements And Year-end Accounting For A Merchandising Business

Section: Chapter Questions

Problem 5MC

See similar textbooks

Similar questions

Exercise 13-3 (Algo) Computing and analyzing trend percents LO P1 Sales Cost of goods sold. Accounts receivable 2021 $ 424,322 214,661 20,580 Numerator: 2020 $ 279,159 141, 180 16,303 2019 $ 218,948 112,924 15,042 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. Trend Percent for Net Sales: 2021: 2020: 2019: 2018: 2017: Is the trend percent for Net Sales favorable or unfavorable? 2018 $ 153,648 78,724 8,973 Denominator: 2017 $ 116,400 58,200 7,973 11 Trend percent % % ge % % %
! Required information Use the following information to determine the prior year and current year trend percents for net sales using the prior year as the base year. ($ thousands) Net sales Cost of goods sold Current Year Prior Year $ 802,971 394,306 $ 454,365 135,325 Current Year: Prior Year: Determine the Prior Year and Current Year common-size percents for cost of goods sold using net sales as the base. (Enter the answers in thousands of dollars.) Common-Size Percent for Cost of Goods Sold using Net Sales as the base: Denominator: Numerator: Analysis period cost of goods sold $ $ Check my work 394,306 / 135,325 / $ 454,365 Common-size percents 0 % 29.78 %
Sales Cost of goods sold Accounts receivable 2021: 2020: 2018: 2018: 2021: 20:20: Compute trend percents for the above accounts, using 2017 as the bese year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable. Numerator: 2021: 2020: 2018: 2018: 2821 $ 553,453 284, 861 26,808 Numerator: Numerator: T 2017: Is the trend parcent for Net Sales favorable or unfavorable? I Trend Perent for Net Bales: I } J 2828 J I 184,986 21,060 2018: 2018: 2017: Is the trend percent for Cost of Goods Sold favorable or unfavorable? Trend Percent for Cost of Goods Bold: Denominator: 2019 $ 295,790 154,003 20,232 T " I Denominator: Trend Perent for Accounts Receivable: Denominator: 2018 $ 283,903 185,586 11,893 2017: Is the trend percent for Accounts Receivable favorable or unfavorable? 11 11 "H |||||| 11 11 11 2817 $ 148,000 75,939 10,170 11 Trend percent Trend parcant Trend percent aan | 20
Common-size and trend percents for Rustynail Company's sales, cost of goods sold, and expenses follow. Sales Cost of goods sold Total expenses Current Yr 100.0% 63.6 Common-Size Percents 1 Yr Ago 100.0% 61.4 13.9 2 Yrs Ago 100.0% 57.6 14.2 Current Yr 104.9% 115.8 106.5 Trend Percents 1 Yr Ago 103. 74 2 Yrs Ago 100.0% 100.0 100.0 110.5 101.5 14.4 Determine the net income for the following years. Did the net income increase, decrease, or remain unchanged in this three-year period? Complete this question by entering your answers in the tabs below. Change in Net Income Net Income Determine the net income for the following years. (Enter all amounts as positive values.) Current Yr 1 Yr Ago 2 Yrs Ago Sales 100,000 Cost of Goods Sold 57,600 14,200 Total Expenses Net Income %24 28,200 Hat Change in Net Income> Did the net income increase, decrease, or remain unchanged in this three-year period? Did the net income increase, decrease, or remain unchanged in this three-year period? Net income…
Use the following selected Information from Letterman Corporation to determine the Year 1 and Year 2 common size percentages for cost of goods sold using Net sale Year Year Net sales Cost of goods sold 2$ 538,600 $4 436,200 223,900 135,830 Operating expenses Net earnings 81,640 78,680 41,260 29,260 Multiple Choice 123.5% for Year 2 and 100.0% for Year 1. 7.7% for Year 2 and 6.7% for Year 1. 56.7% for Year 2 and 49.2% for Year 1. 176.3% for Year 2 and 203.3% for Year 1. 41.6% for Year 2 and 31.1% for Year 1.
Cost of goods sold Average inventory 2020 2021 2022 $923,550 $980,640 126,290 Inventory Turnover 7.3 2021 6.3 5.3 156,510 2022 (a) Do a trend analysis of the inventory turnover for each year. Also calculate the days to sell invento (Round inventory turnover to 2 decimal places, e.g. 18.42 and number of days to 1 decimal place, e.g. 13.6., $1,149,910 $1,329,510 208,410 Number of Days 2023 321,820 days days days 2024 $1,408,530 451,860
Common-size and trend percents for Roxi Company's sales, cost of goods sold, and expenses follow. P nt 7 erences SC Sales Cost of goods sold Operating expenses Fn Change in Net Income Type here to search Sales Cost of Goods Sold Operating Expenses Net Income Net Income F1 Determine the net income for the following years. Did the net income increase, decrease, or remain unchanged in this three-y period? Complete this question by entering your answers in the tabs below. X Common-Size Percents 1 Year Ago Current Year 100.0% 63.4 14.3 F2 A Determine the net income for the following years. Assuming sales were $100,000 2 yrs ago, what is net income in each year? (Enter all amounts as positive values.) Current Year 100.0% 61.2 13.8 F3 E F6 2 Years Ago 100.0% 100.0 100.0 A + DELL F7 F8 F9 0 F
Required information ($ thousands) Net sales Cost of goods sold Current Year $ 885,182 396,513 Current Year: Prior Year: Determine the Prior Year and Current Year trend percents for net sales using the Prior Year as the base year. (Enter the answers in thousands of dollars.) Prior Year $ 456,779 137,643 Numerator: Trend Percent for Net Sales: Denominator: Trend Percent 0% 0%
Consider the following financial statement information: Item Beginning Year Ending Inventory € 9.780 € 11.380 € 4.108 € 4.938 € 7.636 € 7.927 Accounts Receivable Accounts Payable Credit Sales Cost of Goods Sold € 89.804 € 56.384 Calculate the operating and cash cycles. How do you interpret your answer?
Calculate a base-weighted and current- weighted index. Years 1 is base and year 2 is current. Number of units bought Price paid per unit ($) Item 7. Year 1Year 2Year 1Year 2 A 121 141 $9 $10 B 149 163 $21 $23 C 173 182 $26 $27 D 194 103 $31 $33
How do you calculate net sales? Also... Do you only look at current year data or do you factor previous year data and current year? Thx
Common-size and trend percents for Roxi Company's sales, cost of goods sold, and expenses follow. Common Size Percents Trend Percents 1 Year Ago: Current Year 100.0% 63.7 1 Year Ago 100.0% 61.5 2 Years Ago 100.0% 56.8 14.1 Current Year 104.4% 117.1 Sales: 2 Years Ago 100.0% 100.0 Cost of goods sold 103.2% 111.7 Operating expenses 14.3 13.8 105.9 101.0 100.0 Determine the net income for the following years. Did the net income increase, decrease, or remain unchanged in this three-year period? Complete this question by entering your answers in the tabs below. Change in Net Net Income Income Determine the net income for the following years. Assuming sales were $100,000 2 yrs ago, what is net income in each year? (Enter all amounts as positive values.) Current Year 1 Year Ago 2 Years Ago Sales S Cost of Goods Sold Operating Expenses Not Income < Change in Net Income $ 100,000 56,800 14,100 29,100