Financial & Managerial Accounting
13th Edition
ISBN: 9781285866307
Author: Carl Warren, James M. Reeve, Jonathan Duchac
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 15, Problem 15.2APR
Requirement 1:
To determine
To prepare: Comparative income statement for the two-year period.
Given info: Income statement for the two year period.
Requirement 2:
To determine
To comment: Significant relationships revealed by the horizontal analysis.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Solve the Following
Requirements:
(a) Compute for the percentage of sales for 2016
(b) Make a projected income statement for 2016
Forecasting an Income StatementAutoZone Inc. reports the following income statements.
Consolidated Statement of Income ($ in Thousands)
12 Months EndedAug. 27, 2016
Net sales
$10,635,676
Cost of sales, including warehouse and delivery expenses
5,026,940
Gross profit
5,608,736
Operating, selling, general and administrative expenses
3,548,341
Operating profit
2,060,395
Interest expense, net
147,681
Income before income taxes
1,912,714
Income tax expense
671,707
Net income
$1,241,007
Forecast AutoZone's 2017 income statement assuming the following income statement relations ($ in thousands). All percentages, (other than sales growth and provision for income taxes) are based on percent of net sales.
Net sales growth
6%
Cost of sales, including warehouse and delivery expenses
47.3%
Operating, selling, general and administrative expenses
33.4%
Interest expense, net
$145,000
Income tax expense (% pretax income)
35%
Round your…
Chapter 15 Solutions
Financial & Managerial Accounting
Ch. 15 - Prob. 1DQCh. 15 - What is the advantage of using comparative...Ch. 15 - A companys current year net income (after income...Ch. 15 - Prob. 4DQCh. 15 - Prob. 5DQCh. 15 - Prob. 6DQCh. 15 - Prob. 7DQCh. 15 - Prob. 8DQCh. 15 - Prob. 9DQCh. 15 - Prob. 10DQ
Ch. 15 - Prob. 15.1APECh. 15 - Prob. 15.1BPECh. 15 - Prob. 15.2APECh. 15 - Vertical analysis Income statement information for...Ch. 15 - Prob. 15.3APECh. 15 - Prob. 15.3BPECh. 15 - Accounts receivable analysis A company reports the...Ch. 15 - Accounts receivable analysis A company reports the...Ch. 15 - Prob. 15.5APECh. 15 - Inventory analysis A company reports the...Ch. 15 - Prob. 15.6APECh. 15 - Long-term solvency analysis The following...Ch. 15 - Prob. 15.7APECh. 15 - Times interest earned A company reports the...Ch. 15 - Prob. 15.8APECh. 15 - Prob. 15.8BPECh. 15 - Prob. 15.9APECh. 15 - Prob. 15.9BPECh. 15 - Prob. 15.10APECh. 15 - Common stockholders' profitability analysis A...Ch. 15 - Prob. 15.11APECh. 15 - Earnings per share and price-earnings ratio A...Ch. 15 - Prob. 15.1EXCh. 15 - Vertical analysis of income statement The...Ch. 15 - Common-sized income statement Revenue and expense...Ch. 15 - Vertical analysis of balance sheet Balance sheet...Ch. 15 - Prob. 15.5EXCh. 15 - Current position analysis The following data were...Ch. 15 - Prob. 15.7EXCh. 15 - Prob. 15.8EXCh. 15 - Prob. 15.9EXCh. 15 - Prob. 15.10EXCh. 15 - Inventory analysis The following data were...Ch. 15 - Inventory analysis Dell Inc. and Hewlett-Packard...Ch. 15 - Prob. 15.13EXCh. 15 - Prob. 15.14EXCh. 15 - Prob. 15.15EXCh. 15 - Prob. 15.16EXCh. 15 - Profitability ratios The following selected data...Ch. 15 - Profitability ratios Ralph Lauren Corporation...Ch. 15 - Six measures of solvency or profitability The...Ch. 15 - Five measures of solvency or profitability The...Ch. 15 - Prob. 15.21EXCh. 15 - Prob. 15.22EXCh. 15 - Prob. 15.23EXCh. 15 - Prob. 15.24EXCh. 15 - Prob. 15.25EXCh. 15 - Prob. 15.26EXCh. 15 - Horizontal analysis of income statement For 2016,...Ch. 15 - Prob. 15.2APRCh. 15 - Prob. 15.3APRCh. 15 - Nineteen measures of solvency and profitability...Ch. 15 - Solvency and profitability trend analysis Addai...Ch. 15 - Prob. 15.1BPRCh. 15 - Prob. 15.2BPRCh. 15 - Effect of transactions on current position...Ch. 15 - Nineteen measures of solvency and profitability...Ch. 15 - Prob. 15.5BPRCh. 15 - Financial Statement Analysis The financial...Ch. 15 - Prob. 15.1CPCh. 15 - Prob. 15.2CPCh. 15 - Prob. 15.3CPCh. 15 - Prob. 15.4CPCh. 15 - Prob. 15.5CP
Knowledge Booster
Similar questions
- Vertical Analysis of Income Statement For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included the expenditure of an additional $21,000 for advertising. At the end of the year, Lumi Neer, the president, is presented with the following condensed comparative income statement: Tri-Comic CompanyComparative Income StatementFor the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $741,000 $637,000 Cost of merchandise sold 348,270 337,610 Gross profit $392,730 $299,390 Selling expenses $148,200 $121,030 Administrative expenses 74,100 76,440 Total operating expenses $222,300 $197,470 Income from operations $170,430 $101,920 Other revenue 29,640 31,850 Income before income tax expense $200,070 $133,770 Income tax expense 81,510 50,960 Net income $118,560 $82,810 Required: Question Content Area 1. Prepare a comparative income statement for the two-year period, presenting an analysis of each item in…arrow_forwardBOARD ACTIVITY Instructions: Horizontal Vertical Make a Horizontal Analysis and Vertical Analysis for 2014 2015 Analysis Analysis Revenue 1,939,500 1,674,675 1. the given SCI. Cost of Goods Sold 900,000 843,975 2. 8. Gross Profit 1,039,500 830,700 10. Selling and General Expenses 445,500 409,725 ur Other Expenses 37,575 30,825 giv 5. 11. Net Income 556,425 390,150 12.arrow_forwardThe balance sheet of ATLF, Inc. reports total assets of $1,950,000 and $2,050,000 at the beginning and end of the year, respectively. Net income and sales for the year are $150,000 and $1,000,000, respectively. What is ATLF's profit margin? Select one: a. 10% Ob. 8% O c. 7.5% O d. 15% e. 12%arrow_forward
- 9 Operating data for Taylor Corporation are presented below. Using the Excel spreadsheet provided, prepare a schedule showing a vertical analysis for 2018 and 2017. 2018 2017 Sales revenue $800,000 $600,000 Cost of goods sold 520,000 408,000 Selling expenses 120,000 72,000 Administrative expenses 60,000 48,000 Income tax expense 30,000 24,000 Net income 70,000 48,000 (CGS percent. = CGS ÷ Sales rev.)arrow_forwardSelected financial statement data for Schmitzer Inc. is shown below: 2016 2015 Balance sheet: Inventories 60,000 48,000 Ratios: Gross profit ratio for 2016 Inventory turnover ratio for 2016 40% What was the amount of net sales for 2016?arrow_forwardVertical analysis of income statement For 20Y2, Tri-Comic Company initiated a sales promotion campaign that included the expenditure of an additional $50,000 for advertising. At the end of the year, Lumi Neer, the president, is presented with the following condensed comparative income statement: Tri-Comic Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $ 1,500,000 $ 1,250,000 Cost of goods sold (510,000) (475,000) Gross profit $ 990,000 $ 775,000 Selling expenses $ (270,000) $ (200,000) Administrative expenses (180,000) (156,250) Total operating expenses $ (450,000) $ (356,250) Operating income $ 540,000 $ 418,750 Other revenue 60,000 50,000 Income before income tax expense $ 600,000 $ 468,750 Income tax expense (450,000) (375,000) Net income $ 150,000 $ 93,750 1. Prepare a comparative income statement for the two-year period, presenting an analysis of each item in relationship to sales for…arrow_forward
- I. Complete the horizontal analysis below. Use the name of the company you belong to in your iLS Activity. Round off your answers to the nearest hundredths. Name: Income Statement for the years ending December 31, 201X and December 31, 201Y 2015 2016 Annual Percentage Growth 2015-2016 Sales 475,000 500,000 1. Cost of Goods Sold 265,000 269,000 2. Gross Profit 210,000 231,000 3. Wages 154,000 163,000 4. Repairs 5,800 4,150 5. Rent 13,000 12,000 6. Taxes 16,940 17,930 7. Office Expenses 1,023 587 8. Total Expenses 190,763 197,667 9. Net Income 19,237 33,333 10. II. Analyze the following ratios (Good/Not good, Undervalued/Overvalued, or just OK) based on the given industry averages. Write the answers in the spaces provided. Ratios Annual Data Industry Average Interpretation Current 5.7 4 Days Sales Outstanding 37 days 42 days Total Debt to Total Capital 47.80% 32.60% Times-Interest Earned 2.2 6 Profit Margin 6.10% 6.00% Return on Invested Capital 10.03% 10.00% Enterprise Value to EBITDA…arrow_forwardneed help please provide correct answer as per requirementarrow_forwardVertical 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.5arrow_forward
- 4. The following common size income statement are available for Gaea Corporation for the two years ended December 2019, and 2018 2019 2018 Sales 100% 100% Cost of sales 55% 70% Gross profit on sales 45% 30% Operating (including income tax expense) expenses 20% 18% 25% 12% Net income The trend percentages for sales are as follows: 2017 130% 100% 2016 What should be the trend percentage for gross profit on sales for 2019 A. 58.5% В. 130% С. 150% D. 195% Answer:arrow_forwardConduct a trend analysis (horizontal) for the company over current and last two years based on Comparative SFP. (note: see the second picture as example of horizontal analysis. The first photo is the given)arrow_forwardGIVE 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_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College