FINANCIAL ACCOUNTING W/ACCESS >CI<
2nd Edition
ISBN: 9781259999024
Author: SPICELAND
Publisher: MCG CUSTOM
expand_more
expand_more
format_list_bulleted
Question
Chapter 12, Problem 12.3BE
To determine
To report: Increase / Decrease in the income before tax as a percentage of sales.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The income statements of Cullumber Corporation show the following amounts:
2020
2019
2018
Net sales
$740
$710
$660
Cost of goods sold
540
509
449
Gross profit
200
201
211
Selling, general, and administrative expenses
190
150
110
Profit before tax
10
51
101
Using vertical (common-size) analysis, analyze Cullumber Corporation’s declining profit before tax. (Round answers to 0 decimal places, e.g. 52%.)
2020
2019
2018
Net sales
%
%
%
Cost of goods sold
%
%
%
Gross profit
%
%
%
Selling, general, and administrative expenses
%
%
%
Profit before tax
%
%
%
Athletic World reports the following vertical analysis percentages. 2021 2020Sales 100% 100%Cost of goods sold 48% 56%Operating expenses 35% 30%Did Athletic World’s income before tax as a percentage of sales increase, decrease, or stay the same? If net income as a percentage of sales increases, does that mean net income also increases? Explain.
Vertical analysis (common-size) percentages for Baker Company’s sales revenue, cost of goods sold, and expenses are as follows. Did Baker’s net income as a percent of sales increase, decrease, or remain unchanged over the 3-year period? Provide numerical support for your answer.
Vertical Analysis
2018
2017
2016
Sales revenue
100.0%
100.0%
100.0%
Cost of goods sold
60.0
63.9
65.0
Expenses
26.0
26.6
27.5
Chapter 12 Solutions
FINANCIAL ACCOUNTING W/ACCESS >CI<
Ch. 12 - Prob. 1RQCh. 12 - Prob. 2RQCh. 12 - Prob. 3RQCh. 12 - Prob. 4RQCh. 12 - 5.In performing horizontal analysis, why is it...Ch. 12 - Prob. 6RQCh. 12 - Prob. 7RQCh. 12 - Prob. 8RQCh. 12 - Prob. 9RQCh. 12 - Prob. 10RQ
Ch. 12 - Prob. 11RQCh. 12 - Prob. 12RQCh. 12 - Prob. 13RQCh. 12 - Prob. 14RQCh. 12 - Prob. 15RQCh. 12 - Prob. 16RQCh. 12 - Prob. 17RQCh. 12 - Prob. 18RQCh. 12 - Prob. 19RQCh. 12 - Prob. 20RQCh. 12 - Prob. 12.1BECh. 12 - Prob. 12.2BECh. 12 - Prob. 12.3BECh. 12 - Prob. 12.4BECh. 12 - Prob. 12.5BECh. 12 - Universal Sports Supply began the year with an...Ch. 12 - Prob. 12.7BECh. 12 - Prob. 12.8BECh. 12 - Prob. 12.9BECh. 12 - Prob. 12.10BECh. 12 - Prob. 12.11BECh. 12 - Prob. 12.12BECh. 12 - Prob. 12.13BECh. 12 - Classify each of the following accounting...Ch. 12 - Classify each of the following accepted accounting...Ch. 12 - Prob. 12.1ECh. 12 - Prob. 12.2ECh. 12 - Prob. 12.3ECh. 12 - Prob. 12.4ECh. 12 - Prob. 12.5ECh. 12 - Refer to the information for Adrian Express in...Ch. 12 - Prob. 12.7ECh. 12 - Calculate profitability ratios (LO124) Refer to...Ch. 12 - Prob. 12.9ECh. 12 - The income statement for Stretch-Tape Corporation...Ch. 12 - Prob. 12.11ECh. 12 - LeBrons Bookstores has two divisions, books and...Ch. 12 - Prob. 12.13ECh. 12 - Prob. 12.14ECh. 12 - Distinguish between conservative and aggressive...Ch. 12 - Prob. 12.1APCh. 12 - Prob. 12.2APCh. 12 - Prob. 12.3APCh. 12 - Prob. 12.4APCh. 12 - Prob. 12.5APCh. 12 - Prob. 12.6APCh. 12 - Game-On Sports operates in two distinct segments:...Ch. 12 - Prob. 12.2BPCh. 12 - Prob. 12.3BPCh. 12 - Prob. 12.4BPCh. 12 - Prob. 12.5BPCh. 12 - Prob. 12.6BPCh. 12 - Prob. 12.1APCPCh. 12 - Prob. 12.2APFACh. 12 - Prob. 12.3APFACh. 12 - Prob. 12.4APCACh. 12 - Prob. 12.5APECh. 12 - Prob. 12.7APWCCh. 12 - Prob. 12.8APEM
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Hello, can you help me in this problem of doing the horizontal analysis. below are the data. Horizontal analysis using: 2016 2017 2018 Sales 227,279 251,589 286,378 Less: Cost of Sales 152,108 168,460 194,236 Gross Profit 75,171 83,129 92,142 Less: Selling and Administrative Expenses 38,128 40,728 46,192 Operating Income 37,043 42,401 45,950 Other income and expenses 268 118 409 Net Income Before Finance Charges and Tax 37,311 42,519 46,359 Less: Finance charges 3,212 2,658 2,998 Net Income Before Tax 34,099 39,861 43,361 Less: Income Tax Expense 10,097 11,635 12,828 Net Income After Tax 24,002 28,226 30,533 using the index numbers: Horizontal Anaysis using index numbers 2016 2017 2018 Sales Less: Cost of Sales Gross Profit Less: Selling and Administrative Expenses Operating Income and the increase/decrease method: horizontal using Increase/decrease method 2016 2017 2018 Operating Income…arrow_forwardGIVE THE COMPARATIVE INCOME STATEMENT VERTICAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW JOLLIBEE INCOME STATEMENT ITEM 2016 2017 2018 2019 2020 Sales/Revenue 113.81B 133.61B 161.17B 179.63B 129.31B Sales Growth - 17.40% 20.62% 11.45% -28.01% Cost of Goods Sold (COGS) incl. D&A - - 132.96B 150.88B 115.39B COGS Growth - - - 13.47% -23.52% COGS excluding D&A 89.27B 105.39B 121.08B 137.38B 100.82B Depreciation & Amortization Expense 4B 4.75B 11.89B 13.5B 14.57B Depreciation 3.93B 4.66B 11.73B 13.34B 14.32B Amortization of Intangibles 68.99M 78.95M 151.82M 145.42M 245.23M Gross Income 20.54B 23.48B 28.21B 28.75B 13.92B Gross Income Growth - 14.30% 20.12% 1.93% -51.57% Gross Profit Margin - - - - 10.77% SG&A Expense - - 17.64B 20.21B 20.42B SGA Growth - - - 14.57% 1.02%…arrow_forwardIn the income statement below, ABC Trade Inc. wants to find the resulting net income for the year 2018 (in million). What is the right amount? Income Statement ($ Million) Year End 2015 2016 2017 2018 Sales 1,234.90 1,251.70 1,300.40 1,334.40 Cost of Sales (679.10) (659.00) (681.30) (667.00) Gross Operating Income Selling & Administration (339.70) (348.60) (351.20) (373.30) Depreciation (47.50) (52.00) (55.90) (75.20) Other Income/Expenses 11.80 7.60 7.00 8.20 Earnings Before Interest and Taxes Interest Income 1.30 1.40 1.70 2.00 Interest Expense (16.20) (15.10) (20.50) (23.70) Pre Tax Income Income Taxes (56.80) (64.20) (67.50) (72.60) Net Income Dividends (38.30) (38.70) (39.80) (40.10) Addition to Retained Earnings Group of answer choices 121.8 108.7 132.7 132.8 No choice givenarrow_forward
- GIVE THE COMPARATIVE INCOME STATEMENT HORIZONTAL AND VERTICAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW JOLLIBEE INCOME STATEMENT ITEM 2016 2017 2018 2019 2020 Sales/Revenue 113.81B 133.61B 161.17B 179.63B 129.31B Sales Growth - 17.40% 20.62% 11.45% -28.01% Cost of Goods Sold (COGS) incl. D&A - - 132.96B 150.88B 115.39B COGS Growth - - - 13.47% -23.52% COGS excluding D&A 89.27B 105.39B 121.08B 137.38B 100.82B Depreciation & Amortization Expense 4B 4.75B 11.89B 13.5B 14.57B Depreciation 3.93B 4.66B 11.73B 13.34B 14.32B Amortization of Intangibles 68.99M 78.95M 151.82M 145.42M 245.23M Gross Income 20.54B 23.48B 28.21B 28.75B 13.92B Gross Income Growth - 14.30% 20.12% 1.93% -51.57% Gross Profit Margin - - - - 10.77% SG&A Expense - - 17.64B 20.21B 20.42B SGA Growth - - -…arrow_forwardIn 2O2O Coca Cola reported net operating revenues of P18.2 billion and cost of goods sold for P0.8 billion. Their gross profit percentage for 2020 was ____.arrow_forwardGIVE THE COMPARATIVE INCOME STATEMENT HORIZONTAL ANALYSIS FROM THE FOLLOWING INCOME STATEMENT BELOW JOLLIBEE INCOME STATEMENT ITEM 2016 2017 2018 2019 2020 Sales/Revenue 113.81B 133.61B 161.17B 179.63B 129.31B Sales Growth - 17.40% 20.62% 11.45% -28.01% Cost of Goods Sold (COGS) incl. D&A - - 132.96B 150.88B 115.39B COGS Growth - - - 13.47% -23.52% COGS excluding D&A 89.27B 105.39B 121.08B 137.38B 100.82B Depreciation & Amortization Expense 4B 4.75B 11.89B 13.5B 14.57B Depreciation 3.93B 4.66B 11.73B 13.34B 14.32B Amortization of Intangibles 68.99M 78.95M 151.82M 145.42M 245.23M Gross Income 20.54B 23.48B 28.21B 28.75B 13.92B Gross Income Growth - 14.30% 20.12% 1.93% -51.57% Gross Profit Margin - - - - 10.77% SG&A Expense - - 17.64B 20.21B 20.42B SGA Growth - - - 14.57% 1.02%…arrow_forward
- Given the income statement below, Mega Trade Inc. wants to find the resulting net income for the year 2016 (in million). What is the right amount? Income Statement ($ Million) YEAR END YEAR END YEAR END YEAR END 2015 2016 2017 2018 Sales 1,234.90 1,251.70 1,300.40 1,334.40 Cost Sales -679.1 -659 -681.3 -667 Gross Operating Income Selling & Administration -339.7 -348.6 -351.2 -373.3 Depreciation -47.5 -52 -55.9 -75.2 Other Income/Expenses 11.8 7.6 7 8.2 Earnings Before Interest and Taxes Interest Income 1.3 1.4 1.7 2 Interest Expense -16.2 -15.1 -20.5 -23.7 Pre Tax Income Income Taxes -56.8 -64.2 -67.5 -72.6 Net Income Dividends -38.3 -38.7 -39.8 -40.1arrow_forwardSave Mivatin Products Ltd. reported the following on its 2011 comparative income statement: (In millions) 2011 2010 2009 Net sales $148.5 $139.0 $149.5 Cost of sales 129.5 108.0 114.0 Perform a horizontal analysis of net sales, cost of sales, and gross margin, both in dollar amounts and in percentages, for 2011 and 2010. (Round the percentages to one decimal place, X.X%. Use a minus sign or parentheses to indicate a decrease.) Mivatin Products Ltd. Income Statement - (Adapted) For the Year Ended December 31, 2011 and 2010 Increase/(Decrease) (amounts in millions) 2011 2010 2011 2010 2009 Amt. % Amt % Net sales $148.5 $139.0 $149.5 Cost of sales 129.5 108.0 114.0 Gross marginarrow_forwardUse the following Income Statement and Balance Sheet Information for 2018 to answer the question below. This is a Retail Company. All numbers are in Millions. Income Statement Total Sales213.8 Cost of Sales151.3 Gross Profit213.8-151.3 Selling and Administrative Expenses22.3 Research and Development 7.7 Depreciation and Amortization4.5 Other Income2.4 EBIT213.8-151.3-22.3-7.7-4.5+2.4 Interest Expense5.8 Pretax Income213.8-151.3-22.3-7.7-4.5+2.4-5.8 Taxes( 213.8-151.3-22.3-7.7-4.5+2.4-5.8 )*0.30 Net Income( 213.8-151.3-22.3-7.7-4.5+2.4-5.8 )*0.70 Balance Sheet Assets Liabilities Cash65.8Accounts Payable43.3Accounts Receivable54.4Notes Payable/Short term debt1.6Inventories4.4 Total Current Assets65.8+54.4+4.4Total Current Liabilities43.3+1.6 Net property, plant and equipment103.4Long-term debt80.0Total long-term assets103.4Total long-term debt liabilities80.0 Total Liabilities43.3+1.6+80.0 Stockholders' Equity (Total Equity)65.8+ 54.4+4.4+103.4-43.3-1.6-80.0Total…arrow_forward
- Calculate return on assets and profit margin.LO9 The following information is available for Ware Ltd for 2018: sales revenue $7 840 000; cost of sales $3 528 000; profit $1 176 000; total equity $2 233 300; average total assets $5 113 000. Calculate the return on assets and profit margin for Ware Ltd for 2018.arrow_forwardFor 2021, Hamilton Company had Sales of $5,700,000 and Cost of Goods Sold of $3,600,000. For 2020, Hamilton Company had Sales of $4,800,000 and Cost of Goods Sold of $2,900,000. a. What was the Cost of Goods Sold as a percent of Sales for 2021? b. What was the Cost of Goods Sold as a percent of Sales for 2020? c. Did Hamilton show improvement from 2020 to 2021? d. Is this an example of horizontal or vertical analysis?arrow_forwardLOGIC COMPANY Comparative Income Statement For Years Ended December 31, 2017 and 2018 2018 2017 Gross sales $ 19,000 $ 15,000 Sales returns and allowances 1,000 100 Net sales $ 18,000 $ 14,900 Cost of merchandise (goods) sold 12,000 9,000 Gross profit $ 6,000 $ 5,900 Operating expenses: Depreciation $ 700 $ 600 Selling and administrative 2,200 2,000 Research 550 500 Miscellaneous 360 300 Total operating expenses $ 3,810 $ 3,400 Income before interest and taxes $ 2,190 $ 2,500 Interest expense 560 500 Income before taxes $ 1,630 $ 2,000 Provision for taxes 640 800 Net income $ 990 $ 1,200 LOGIC COMPANY Comparative Balance Sheet December 31, 2017 and 2018 2018 2017 Assets Current assets: Cash $ 12,000 $…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
How To Analyze an Income Statement; Author: Daniel Pronk;https://www.youtube.com/watch?v=uVHGgSXtQmE;License: Standard Youtube License