Financial Accounting
14th Edition
ISBN: 9781305088436
Author: Carl Warren, Jim Reeve, Jonathan Duchac
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 17, Problem 2PB
1.
To determine
Prepare comparative income statement for the two-year period.
2.
To determine
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
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:
Please see the attachment for details:
Instructions1. 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 percentages to one decimal place.2. To the extent the data permit, comment on the significant relationshipsrevealed by the vertical analysis prepared in (1).
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:
Please see the attachment for details:
Instructions1. 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 percentages to one decimal place.2. To the extent the data permit, comment on the significant relationshipsrevealed by the vertical analysis prepared in (1).
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, Willie Green,
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
Sales
Cost of goods sold
Gross profit
Selling expenses
Administrative expenses
Total operating expenses
Income from operations
Other revenue
Income before income tax
Income tax expense
Net income
Required:
2012
$1,500,000
510,000
$990,000
$270,000
180,000
$450,000
$540,000
60,000
$600,000
450,000
$150,000
20Y1
$1,250,000
475,000
$775,000
$200,000
156,250
$356,250
$418,750
50,000
$468,750
375,000
$93,750
Required:
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 to one
decimal place. Enter all amounts as positive numbers.
Chapter 17 Solutions
Financial Accounting
Ch. 17 - Prob. 1DQCh. 17 - What is the advantage of using comparative...Ch. 17 - Prob. 3DQCh. 17 - How would the current and quick ratios of a...Ch. 17 - Prob. 5DQCh. 17 - What do the following data, taken from a...Ch. 17 - a. How does the rate earned on total assets differ...Ch. 17 - Kroger, a grocery store, recently had a...Ch. 17 - Prob. 9DQCh. 17 - Prob. 10DQ
Ch. 17 - Prob. 1PEACh. 17 - Prob. 1PEBCh. 17 - Prob. 2PEACh. 17 - Vertical analysis Income statement information for...Ch. 17 - Prob. 3PEACh. 17 - Prob. 3PEBCh. 17 - Prob. 4PEACh. 17 - Prob. 4PEBCh. 17 - Prob. 5PEACh. 17 - Inventory analysis A company reports the...Ch. 17 - Prob. 6PEACh. 17 - Prob. 6PEBCh. 17 - Times interest earned A company reports the...Ch. 17 - Times interest earned A company reports the...Ch. 17 - Asset turnover A company reports the following:...Ch. 17 - Asset turnover A company reports the following:...Ch. 17 - Prob. 9PEACh. 17 - Prob. 9PEBCh. 17 - Common stockholders' profitability analysis A...Ch. 17 - Common stockholders' profitability analysis A...Ch. 17 - Earnings per share and price-earnings ratio A...Ch. 17 - Earnings per share and price-earnings ratio A...Ch. 17 - Revenue and expense data for Gresham Inc. for two...Ch. 17 - Prob. 2ECh. 17 - Common-sized income statement Revenue and expense...Ch. 17 - Prob. 4ECh. 17 - Prob. 5ECh. 17 - The following data were taken from the balance...Ch. 17 - Prob. 7ECh. 17 - The bond indenture for the 10-year, 9% debenture...Ch. 17 - The following data are taken from the financial...Ch. 17 - Prob. 10ECh. 17 - The following data were extracted from the income...Ch. 17 - Prob. 12ECh. 17 - Ratio of liabilities to stockholders equity and...Ch. 17 - Hasbro and Mattel, Inc., are the two largest toy...Ch. 17 - Ratio of liabilities to stockholders equity and...Ch. 17 - Three major segments of the transportation...Ch. 17 - Prob. 17ECh. 17 - Profitability ratios Ralph Lauren Corporation...Ch. 17 - The following data were taken from the financial...Ch. 17 - The balance sheet for Garcon Inc. at the end of...Ch. 17 - Earnings per share, price-earnings ratio, dividend...Ch. 17 - The table that follows shows the stock price,...Ch. 17 - Earnings per share, discontinued operations The...Ch. 17 - Prob. 24ECh. 17 - Prob. 25ECh. 17 - Unusual items Explain whether Colston Company...Ch. 17 - Prob. 1PACh. 17 - For 2016, Indigo Company initiated a sales...Ch. 17 - Effect of transactions on current position...Ch. 17 - The comparative financial statements of Bettancort...Ch. 17 - Addai Company has provided the following...Ch. 17 - Prob. 1PBCh. 17 - Prob. 2PBCh. 17 - Effect of transactions on current position...Ch. 17 - Prob. 4PBCh. 17 - Crosby Company has provided the following...Ch. 17 - Financial Statement Analysis The financial...Ch. 17 - Prob. 1CPCh. 17 - Prob. 2CPCh. 17 - The condensed income statements through income...Ch. 17 - Prob. 4CPCh. 17 - Marriott International, Inc., and Hyatt Hotels...
Knowledge Booster
Similar questions
- The following revenue data were taken from the December 31, 2017, General Electric annual report (10-K): For each segment and each year, calculate intersegment sales (another name for transfer sales) as a percentage of total sales. Using Microsoft Excel or another spreadsheet application, create a clustered column graph to show the 2016 and 2017 percentages for each division. Comment on your observations of this data. How might a division sales manager use this data?arrow_forwardFor 2014, Kasay Company initiated a sales promotion campaign that included the expenditure of an additional $30,000 for advertising. At the end of the year, Scott Brown, the president, is presented with the following condensed comparative income statement: Instructions1. Prepare a comparative income statement for the two-year period, presenting an analysis of each item in relationship to net sales for each of the years. Round to one decimal place.2. To the extent the data permit, comment on the significant relationships revealed by the vertical analysis prepared in(1).arrow_forwardFollowing are 2017 and 2018 revenue data for Honeywell International's four segments. Use these data to forecast its 2019 revenue. Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Honeywell International Segment Sales and Business-Unit Sales by Segment $ millions 2018 2017 Aerospace sales Commercial aviation original equipment Commercial aviation aftermarket Defense and space Transportation systems Total aerospace sales Honeywell building technologies sales Homes Buildings Total Honeywell building technologies sales Performance materials and technologies sales UOP Russell LLP Process solutions Advanced materials Total performance materials and technologies sales $3,591 $2,475 5,373 5,861 5,423 4,053 2,622 3,906 $17,009 $16,295 $4,686 $4,482 5,370 6,053 $10,056 $10,535 $3,603 $2,753 4,981 5,553 3,606 2,791 $12,190 $11,097 Safety and productivity solutions sales Safety…arrow_forward
- For 20Y2, Macklin Inc. reported a significant increase in net income. At the end of the year, John Mayer, the president, is presented with the following condensed comparative income statement: Please see the attachment for details: Instructions1. Prepare a comparative income statement with horizontal analysis for the two-year period, using 20Y1 as the base year. Round percentages to one decimal place.2. To the extent the data permit, comment on the significant relationships revealed by the horizontal analysis prepared in (1).arrow_forwardFor 2012, Tri-Comic Company initiated a sales promotion campaign that included the expenditure of an additional $16,000 for advertising. At the end of the year, Ahmad Rashad, the president, is presented with the following condensed comparative income statement: Sales Cost of goods sold Gross profit Selling expenses Tri-Comic Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 2012 Administrative expenses Total operating expenses Income from operations Other revenue Income before income tax Income tax expense Net income Required $576,000 264,960 $311,040 $109,440 57,600 $167,040 $144,000 23,040 $167,040 69,120 $97,920 20Y1 $495,000 247,500 $247,500 $89,100 59,400 $148,500 $99,000 24,750 $123,750 49,500 $74,250 Required: 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 to the nearest "whole" percentage. Enter all amounts as positive numbers.arrow_forwardAccess the February 21, 2017, filing of the December 31, 2016, 10-K report of The Hershey Company (ticker: HSY) at SEC.gov and complete the following requirements. Required Compute or identify the following profitability ratios of Hershey for its years ending December 31, 2016, and December 31, 2015. Interpret its profitability using the results obtained for these two years. 1. Profit margin ratio (round the percent to one decimal). 2. Gross profit ratio (round the percent to one decimal). 3. Return on total assets (round the percent to one decimal). (Total assets at year-end 2014 were $5,622,870 in thousands.) 4. Return on common stockholders’ equity (round the percent to one decimal). (Total shareholders’ equity at year-end 2014 was $1,519,530 in thousands.) 5. Basic net income per common share (round to the nearest cent).arrow_forward
- Summary operating data for Custom Wire & Tubing Company during the year ended April 30, 2018, are as follows: cost of goods sold, $510,700; administrative expenses, $63,600; interest expense, $38,000; rent revenue, $127,200; sales, $826,800; and selling expenses, $95,400. Prepare a single-step income statement. Custom Wire & Tubing Company Income Statement For the Year Ended April 30, 2018 Revenues: $ Total revenues $ Expenses: $ Total expenses $arrow_forwardCompleting a comprehensive financial statement analysis In its annual report, XYZ Athletic Supply, Inc. includes the following five-year financial summary: Requirements Analyze the company’s financial summary for the fiscal years 2014-2018 to decide whether to invest in the common stock of XYZ. Include the following sections in your analysis. Trend analysis for net sales revenue and net income (use 2014 as the base year). Profitability analysis. Evaluation of the ability to sell merchandise inventory. Evaluation of the ability to pay debts. Evaluation of dividends. Should you invest in the common stock of XYZ Athletic Supply, Inc.? Fully explain your final decision.arrow_forward) Cecil Inc. operates with three divisions: Naperville, Metropolitan and Urbana. Below areselected results for each division over the last two fiscal years.a. Calculate Return on Assets (ROA) for Cecil Inc. in 2021 and 2020 (report percentages rounded twodecimals).b. Calculate Return on Sales (ROS) for Cecil Inc. in 2021 and 2020 (report percentages rounded twodecimals).c. Industry Averages are 15% for ROA and 10% for ROS in 2021 and 2020. Discuss Cecil Inc.’sperformance trends and results compared to industry averages (discuss performance, do not repeatcalc’s from above).Revenues: 2021 2020 Naperville 22,500,000 19,600,000 Metropolitan 15,300,000 12,500,000 Urbana 9,500,000 8,700,000Operating Income: Naperville 1,900,000 1,800,000 Metropolitan 1,100,000 900,000 Urbana 1,100,000 1,050,000Average Total Assets: Naperville 10,000,000 9,500,000 Metropolitan 8,000,000 6,500,000 Urbana 4,500,000 4,300,000Number of Managers: Naperville 15 5 Metropolitan 9 10 Urbana 12arrow_forward
- The following revenue data were taken from the December 31, 2017, Coca-Cola annual report (10-K): For each segment and each year, calculate intersegment sales (another name for transfer sales) as a percentage of total sales, Using Microsoft Excel or another spreadsheet application, create a clustered column graph to show the 2016 and 2017 percentages for each division. Comment on your observations of this data. How might a division sales manager use this data?arrow_forwardSundahl Companys income statements for the past 2 years are as follows: Refer to the information for Sundahl Company above. Required: 1. Prepare a common-size income statement for Year 1 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) 2. Prepare a common-size income statement for Year 2 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.)arrow_forwardCuneo Companys income statements for the last 3 years are as follows: Refer to the information for Cuneo Company above. Required: 1. Prepare a common-size income statement for Year 1 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) 2. Prepare a common-size income statement for Year 2 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) 3. Prepare a common-size income statement for Year 3 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.)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
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher: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
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College