Exercise 13-3 (Algo) Computing and analyzing trend percents LO P1 2021 2020 2018 $ $ $ 2019 $ 357,357 261,800 330,822 220,581 178,305 129,482 670,044 446,696 32,296 26,042 24,372 15, 289 Sales Cost of goods sold Accounts receivable 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: I Denominator: 1 1 1 1 I Numerator: 2021: 2020: 2019: 2018: 2017: Is the trend percent for Net Sales favorable or unfavorable? Trend Percent for Cost of Goods Sold: Numerator: Denominator: I 1 2021: 2020: 2019: 2018: 2017: Is the trend percent for Cost of Goods Sold favorable or unfavorable? / T / 1 Trend Percent for Accounts Receivable: Numerator: I Denominator: / 1 / 1 1 2021: 2020: 2019: 2018: 2017: Is the trend percent for Accounts Receivable favorable or unfavorable? E = = = = = = = = 2017 $ 192,500 94, 325 13, 148 = Trend percent % % % % % Trend percent % % % % % Trend percent % % % % %

Exercise 13-3 (Algo) Computing and analyzing trend percents LO P1 2021 2020 2018 $ $ $ 2019 $ 357,357 261,800 330,822 220,581 178,305 129,482 670,044 446,696 32,296 26,042 24,372 15, 289 Sales Cost of goods sold Accounts receivable 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: I Denominator: 1 1 1 1 I Numerator: 2021: 2020: 2019: 2018: 2017: Is the trend percent for Net Sales favorable or unfavorable? Trend Percent for Cost of Goods Sold: Numerator: Denominator: I 1 2021: 2020: 2019: 2018: 2017: Is the trend percent for Cost of Goods Sold favorable or unfavorable? / T / 1 Trend Percent for Accounts Receivable: Numerator: I Denominator: / 1 / 1 1 2021: 2020: 2019: 2018: 2017: Is the trend percent for Accounts Receivable favorable or unfavorable? E = = = = = = = = 2017 $ 192,500 94, 325 13, 148 = Trend percent % % % % % Trend percent % % % % % Trend percent % % % % %

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Pls answer without plagiarism
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.
Calculate 1. Return on equity 2. Inventory Turnover 3. Accounts Receivable Turnover
1 Condensed financial statements for Games Galore are summarized below: 2 3 Balance Sheet 4 Cash 5 Accounts Receivable, Net 6 Inventory 7 Prepaid Insurance 8 Total Current Assets 9 Property and Equipment, Net 10 Total Assets 11 12 Current Liabilities 13 Long-term Liabilities 14 Total Liabilities 15 Contributed Capital 16 Retained Earnings 17 Total Stockholders' Equity 18 Total Liabilities and Stockholders' Equity 19 20 Income Statement 21 Net Sales (all on account) 22 Cost of Goods Sold 23 Gross Profit 24 Operating Expenses 25 Income from Operations 26 Interest Expense 27 Income before Income Tax Expense 28 Income Tax Expense 29 Net Income 30 READY Attempt(s) Sheet1 $ $ $ $ B $ 2016 185,000 $ 80,000 104,000 11,900 380,900 514,500 895,400 $ 85,300 284,000 369,300 299,000 227,100 526,100 895,400 $ $ 3,031,000 1,949,000 1,082,000 891,400 $ 190,600 14,500 176,100 47,000 129,100 4 C 2015 143,000 59,000 134,000 5,880 341,880 407,000 748,880 96,800 224,000 320,800 299,000 129,080 428,080…
What does this say about the company?
Estimating Share Value Using the DCF Model Following are forecasts of sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of December 31, 2018, for Humana. Note: Complete the entire question in Excel and format each answer to two decimal places. Then enter the answers into the provided spaces below with two decimal places. Reported Forecast Horizon Period Terminal $ millions Sales NOPAT NOA 2021 2022 2020 2018 2019 $57,472 $58,326 $59,192 $60,072 $60,964 3,179 3,218 3,140 3,052 3,102 4,844 4,657 4,718 4,781 4,592 Period $61,568 3,244 4,887 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate 1% Discount rate (WACC) 7.8% Common shares outstanding 135.60 million Net nonoperating obligations (NNO) $(5,569) million Noncontrolling interest $0 million NNO is negative because Humana's nonoperating assets exceed its nonoperating liabilities. (a) Estimate the value of a share of Humana's common stock using the…
2021 2020 2019 2018 2017 Sales Cost of goods sold Accounts receivable $ 479,191 246,837 23,289 $ 315,257 $ 247,260 $ 167,634 $ 120,600 162,481 18,379 129,153 16,888 87,443 9,807 61,506 8,249 Compute trend percents for the above accounts, using 2017 as the base year. For each of the three acco situation as revealed by the trend percents appears to be favorable or unfavorable. 2021: 2020: 2019: 2018: 2017: Trend Percent for Net Sales: Numerator: 1 Denominator: 1 1 Is the trend percent for Net Sales favorable or unfavorable? 2021: 2020: 2019: 2018: 2017: Trend Percent for Cost of Goods Sold: Numerator: Denominator: 1 1 1 Is the trend percent for Cost of Goods Sold favorable or unfavorable? 2021: 2020: 2019: 2018: 2017: Trend Percent for Accounts Receivable: Numerator: Denominator: Is the trend percent for Accounts Receivable favorable or unfavorable? = Trend percent % 9900 = % = % = % % Trend percent % % % % % 11 Trend percent = % % % = % %
PE.17-03B Current Position Analysis The following items are reported on a company's balance sheet: Cash Marketable securities Accounts receivable (net) Inventory Accounts payable Determine (a) the current ratio and (b) the quick ratio. Round your answers to one decimal place. a. Current ratio $210,000 120,000 110,000 160,000 200,000 b. Quick ratio
Inventory Turnover Calculate the company's inventory turnover for 2020 and compare the result to the industry average.
2021 2020 2019 2018 2017 Sales $703,787 $ 463,018 $370,414 $256,342 $191,300 Cost of goods sold 361,331 237,839 192,311 132,684 97,563 Accounts receivable 33,993 27,133 25,299 14,996 13,066 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.
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
Sales Cost of goods sold Accounts receivable Numerator: 2021 $ 446,762 225,881 21,623 Numerator: 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. Numerator: 1 1 1 1 1 1 1 2021: 2020: 2019: 2018: 2017: Is the trend percent for Net Sales favorable or unfavorable? 2020 $ 290,105 146,803 16,913 Trend Percent for Net Sales: 2019 $ 232,084 119,092 15,828 2021: 2020: 2019: 2018: 2017: Is the trend percent for Cost of Goods Sold favorable or unfavorable? Trend Percent for Cost of Goods Sold: 1 Denominator: 7 1 1 1 1 1 I 1 Denominator: Trend Percent for Accounts Receivable: Denominator: 1 1 1 1 2021: 2020: 2019: 2018: 2017: Is the trend percent for Accounts Receivable favorable or unfavorable? 2018 $ 167,570 84,885 9,820 = = = = = = = = = = 2017 $ 128,900 64,450 8,804 = Trend percent Trend percent Trend percent % % % % % % % % % % % % %…