Selected assumptions for 2018 Sales growth rate 9 % Cost of goods sold/Sales 62 % Dividends/Net income 40 % Income Statement Balance Sheet Actual Forecast Actual 2017 2018 2017 2018 Sales $ 1,000 Cash $ 100 Cost of goods sold 600 Accounts receivable 200 Operating expense 200 Inventory 500 Depreciation expense 100 Total Current Assets 800 EBIT 100 Net PP&E 1,000 Interest expense 35 Total Assets 1,800 Pre-tax income 65 Accounts payable 300 Tax 26 Bank loan 100 Net Income $39 Total Current Liabilities 400 Long-Term Debt 400 Shareholders' Equity 1,000 Total Liabilities & Equity $ 1,800 Please refer to the spreadsheet above. Selected assumptions are given for preparing pro forma financial statements for 2018. Which of the following formulas would correctly give the forecast for sales in cell C8? Forecast

Selected assumptions for 2018 Sales growth rate 9 % Cost of goods sold/Sales 62 % Dividends/Net income 40 % Income Statement Balance Sheet Actual Forecast Actual 2017 2018 2017 2018 Sales $ 1,000 Cash $ 100 Cost of goods sold 600 Accounts receivable 200 Operating expense 200 Inventory 500 Depreciation expense 100 Total Current Assets 800 EBIT 100 Net PP&E 1,000 Interest expense 35 Total Assets 1,800 Pre-tax income 65 Accounts payable 300 Tax 26 Bank loan 100 Net Income $39 Total Current Liabilities 400 Long-Term Debt 400 Shareholders' Equity 1,000 Total Liabilities & Equity $ 1,800 Please refer to the spreadsheet above. Selected assumptions are given for preparing pro forma financial statements for 2018. Which of the following formulas would correctly give the forecast for sales in cell C8? Forecast

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

Find return on financial leverage and return of financial leverage ratio for years 2017, 2018, and 2019
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.
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…
2021 2020 2019 2018 2017 $ 394,032 199,466 19,071 $ 262,688 132,894 15,394 $ 205,225 $ 150,348 76,774 8,780 $ 112,200 56,100 Sales Cost of goods sold Accounts receivable 106,013 14,058 7,708 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: Numerator: Denominator: Trend percent 2021: % 2020: % 2019: % %3D 2018: % = 2017: % Is the trend percent for Net Sales favorable or unfavorable? Trend Percent for Cost of Goods Sold: Numerator: Denominator: Trend percent %3D 2021: % 2020: % 2019: % %3D 2018: % = 2017: %3D Is the trend percent for Cost of Goods Sold favorable or unfavorable? Trend Percent for Accounts Receivable: Numerator: Denominator: Trend percent %3D 2021: % 2020: % %3D 2019: % = 2018: % 2017: % %3D Is the trend percent for Accounts Receivable favorable or unfavorable? II II IL || II
What does this say about the company?
Calculate Return on Assets for 2021 using the following information: Net Income Net Sales Total Assets 53% 64% 20% 24% 2020 $2,500,000 $5,000,000 $10,000,000 2021 $3,000,000 $8,000,000 $15,000,000
Using Financial Statements for 2020, current ratio for the year 2020 is 1.62.
Suppose the 2022 financial statements of 3M Company report net sales of $23.1 billion. Accounts receivable (net) are $3.2 billion at the beginning of the year and $3.25 billion at the end of the year. Compute 3M’s accounts receivable turnover. - Accounts Recievable turnover ratio=? (times) Compute 3M’s average collection period for accounts receivable in days - Average collection period =? (days)
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 = % % % = % %
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.
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.
2020 Revenue $432,000 Returns, allowances, discounts ($21,600) Cost of goods sold ($280,800) Operating expenses ($45,000) Net Income $84,600 Use the above information to calculated the gross margin/profit ratio.