EBK FINANCIAL & MANAGERIAL ACCOUNTING
13th Edition
ISBN: 9780100545052
Author: WARREN
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Question
Chapter 15, Problem 15.2BPR
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
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.1
Given the income statement below, Mega 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.1
-659
-681.3
-667
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
Interest Income
1.3
1.4
1.7
2
Interest Expense
-16.2
-15.1
-20.5
-23.7
Income Taxes
-56.8
-64.2
-67.5
-72.6
Dividends
-38.3
-38.7
-39.8
-40.1
CHOICES:
A. 108.7B. 132.7C. No choice givenD. 132.8E. 121.8
Given the income statement below, Mega 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
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.1
Addition to Retained Earnings
Chapter 15 Solutions
EBK 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
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
- Given 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_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_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
- 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,…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_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
- Computing and Interpreting Financial Statement Ratios Following are selected ratios of Norfolk Southern for 2018 and 2017. Return on Assets (ROA) Component 2018 2017 Profitability (Net income/Sales) 24.3% 52.2% Productivity (Sales/Average assets) 0.328 0.309 a. Was the company profitable in 2018?AnswerYesNo b. Was the company more profitable in 2018 or 2017?Answer20172018 c. Is the change in productivity a positive or negative development?AnswerPositiveNegative d. Compute the company’s ROA for 2018 and for 2017.Note: Round answers to one decimal places (example: 10.4%). ROA 2018 Answer 2017 Answerarrow_forwardForecasting 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…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_forward
- Vertical analysis income statement Revenue expense data for Innovation quarter Inc for two recent years as follows. Sales Cost of goods. Selling expenses Administrative expenses Income tax expense Current year. 4,000,000 2,280,000 600,000 520,000 240,000 Previous year 3,600,000 1,872,000 648,000 360,000 216,000 A. Prepare an income statement in comparative form, stating to each item for both of years as a percent of sales. Round to the nearest whole percentage. Innovation quarter Inc comparative income tax for the years ended December 31st Sales Cost of goods Selling expenses Administrative expenses Income tax expense $ % $ % $ % $ % $ % $ % $ % $ % B. The vertical analysis indicates that the cost of the goods sold as a percent of sales by 5 percentage points, while selling expenses by 3% percentage and administrative expenses by 3% percentage points. Thus net income as…arrow_forwardI. 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 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_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
How To Analyze an Income Statement; Author: Daniel Pronk;https://www.youtube.com/watch?v=uVHGgSXtQmE;License: Standard Youtube License