FINANCIAL+MANG.-W/ACCESS PRACTICE SET
13th Edition
ISBN: 9781337575614
Author: WARREN
Publisher: CENGAGE L
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 solutionStudents have asked these similar questions
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…
Vertical Analysis of Income Statement
For 20Y2, Fielder Industries Inc. initiated a sales promotion campaign that included the expenditure of an additional $40,000 for advertising. At the end of the year, Leif Grando, the president, is presented with the following condensed comparative income statement:
Fielder Industries Inc.Comparative Income StatementFor the Years Ended December 31, 20Y2 and 20Y1
20Y2
20Y1
Sales
$1,300,000
$1,180,000
Cost of goods sold
(682,500)
(613,600)
Gross profit
$617,500
$566,400
Selling expenses
$(260,000)
$(188,800)
Administrative expenses
(169,000)
(177,000)
Total operating expenses
$(429,000)
$(365,800)
Operating income
$188,500
$200,600
Other revenue
78,000
70,800
Income before income tax expense
$266,500
$271,400
Income tax expense
(117,000)
(106,200)
Net income
$149,500
$165,200
Required:
Question Content Area
1. Prepare a comparative income statement for the two-year period,…
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…
Chapter 15 Solutions
FINANCIAL+MANG.-W/ACCESS PRACTICE SET
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
- The 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_forwardVertical Analysis of Income StatementFor 20Y2, Fielder Industries Inc. initiated a sales promotion campaign that included the expenditure of an additional $40,000 for advertising. At the end of theyear, Leif Grando, the president, is presented with the following condensed comparative income statement:3. PR.14-05BFielder Industries Inc.Comparative Income StatementFor the Years Ended December 31, 20Y2 and 20Y120Y2 20Y1Sales $1,300,000 $1,180,000Cost of goods sold 682,500 613,600Gross profit $617,500 $566,400Selling expenses $260,000 $188,800Administrative expenses 169,000 177,000Total operating expenses $429,000 $365,800Income from operations $188,500 $200,600Other income 78,000 70,800Income before income tax $266,500 $271,400Income tax expense 117,000 106,200Net income $149,500 $165,200Required:1. Prepare a comparative income statement for the two-year period, presenting an analysis of each item in relationship to sales for each of the years. Round toone decimal place. Enter all amounts…arrow_forward9 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_forward
- Selected 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_forwardFanning Corporation's balance sheet indicates that the company has $550,000 invested in operating assets. During 2018, Fanning earned operating income of $60,500 on $1,100,000 of sales. Required a. Compute Fanning's profit margin for 2018. b. Compute Fanning's turnover for 2018. c. Compute Fanning's return on investment for 2018arrow_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_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_forward4. 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_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_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_forwardGiven the historical income statement of Mega Trade Inc., how much would be added to the company's retained earning for the year 2016 (in millions)? Income Statement ( $ Million) Year End 2015 2016 2017 2019 Sales 1, 234.90 1,251.70 1,300.40 1,334.40 Cost of 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_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
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub