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

Please answer required 1,2,3
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…
can you fill out the second image based on the first
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 = % % % = % %
Question: Calculate and interpret liquidity ratios Calculate the inventory turnover, days in inventory, Accounts receivable turnover and the Average Collection period for the years ending June 30, 2020, and 2019 for the Green Construction Supplies Company. Assuming that they have a 60-day credit policy, evaluate their accounts receivable management and recommend ways to improve it. Evaluate their inventory management and suggest ways to improve it. Selected information ($) 2020 2019 2018 Net Sales (80% on credit) 430,000 720,000 640,000 Cost of Goods Sold 250000 350000 320000 Accounts Receivable 220,000 110,000 76,000 Allowance for doubtful accounts 35000 18000 14000 Bad debt expense 30000 12000 9000 Inventory 150000 100000 80000
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.