Working Papers, Chapters 1-17 for Warren/Reeve/Duchac's Accounting, 26th and Financial Accounting, 14th
26th Edition
ISBN: 9781305392373
Author: Carl Warren, Jim Reeve, Jonathan Duchac
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 17, Problem 17.3CP
Vertical analysis
The condensed income statements through income from operations for Dell Inc. and Apple Inc. for recent fiscal years follow (numbers in millions of dollars):
Prepare comparative common-sized statements, rounding percents to one decimal place. Interpret the analyses.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. Round percentages to one decimal place.
B. What conclusions can be drawn from the horizontal analysis? Round the answers to one decimal place.
Prepare a comparative common-size income statement for Jubilee Corporation. To an investor, how does the current year compare with the prior year? Explain your reasoning.
E (Click the icon to view the comparative income statement.)
Data table
Start by calculating the percentages. (Round the percentages to two decimal places, X.XX.)
Jubilee Corporation
Comparative Common-Size Income Statement
A
C
For the Years Ended December 31
1
Jubilee Corporation
Current
2
Income Statement
year
Prior year
3
For the Years Ended December 31
Sales revenues
100.00 %
100.00 %
4
(amounts in thousands)
Less: Cost of goods sold
%
%
Current
Gross profit
%
%
year
Prior year
Less: Operating expenses
%
6 Sales revenues
$
494,208 $
429,000
%
Operating income
%
7 Less: Cost of goods sold
172,640
160,000
Less: Interest expense
8 Gross profit
2$
321,568 $
269,000
0%
Income before income taxes
%
%
9 Less: Operating expenses
143,370
135,000
Less: Income tax expense
10 Operating income
2$
178,198 $
134,000
%
%
11 Less:…
The condensed income statements through income from operations for Amazon.com, Inc., Best Buy, Inc., and Wal-Mart Stores, Inc. for a recent fiscal year follow (in millions):
Please see the attachment for details:
1. Prepare comparative common-sized income statements for each company. Round percentages to one decimal place.2. Use the common-sized analysis to compare the financial performance ofthe three companies.
Chapter 17 Solutions
Working Papers, Chapters 1-17 for Warren/Reeve/Duchac's Accounting, 26th and Financial Accounting, 14th
Ch. 17 - Prob. 1DQCh. 17 - Prob. 2DQCh. 17 - Prob. 3DQCh. 17 - How would the current and quick ratios of a...Ch. 17 - a. Why is it advantageous to have a high inventory...Ch. 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 - Horizontal analysis The comparative temporary...Ch. 17 - Prob. 17.1BPECh. 17 - Vertical analysis Income statement information for...Ch. 17 - Vertical analysis Income statement information for...Ch. 17 - Prob. 17.3APECh. 17 - Prob. 17.3BPECh. 17 - Accounts receivable analysis A company reports the...Ch. 17 - Accounts receivable analysis A company reports the...Ch. 17 - Inventory analysis A company reports the...Ch. 17 - Inventory analysis A company reports the...Ch. 17 - Prob. 17.6APECh. 17 - Prob. 17.6BPECh. 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 - Return on total assets A company reports the...Ch. 17 - Return on total assets A company reports the...Ch. 17 - Common stockholders profitability analysis A...Ch. 17 - Common stockholders profitability analysis A...Ch. 17 - Prob. 17.11APECh. 17 - Prob. 17.11BPECh. 17 - Prob. 17.1EXCh. 17 - Vertical analysis of income statement The...Ch. 17 - Common-sized income statement Revenue and expense...Ch. 17 - Vertical analysis of balance sheet Balance sheet...Ch. 17 - Prob. 17.5EXCh. 17 - Prob. 17.6EXCh. 17 - Prob. 17.7EXCh. 17 - Prob. 17.8EXCh. 17 - Accounts receivable analysis The following data...Ch. 17 - Accounts receivable analysis Xavier Scores Company...Ch. 17 - Inventory analysis The following data were...Ch. 17 - Prob. 17.12EXCh. 17 - Ratio of liabilities to stockholders equity and...Ch. 17 - Ratio of liabilities to stockholders equity and...Ch. 17 - Ratio of liabilities to stockholders equity and...Ch. 17 - Prob. 17.16EXCh. 17 - Profitability ratios The following selected data...Ch. 17 - Profitability ratios Ralph Lauren Corporation...Ch. 17 - Six measures of solvency or profitability The...Ch. 17 - Six measures of solvency or profitability The...Ch. 17 - Prob. 17.21EXCh. 17 - Prob. 17.22EXCh. 17 - Earnings per share, discontinued operations The...Ch. 17 - Prob. 17.24EXCh. 17 - Prob. 17.25EXCh. 17 - Prob. 17.26EXCh. 17 - Horizontal analysis of income statement For 2016,...Ch. 17 - Prob. 17.2APRCh. 17 - Prob. 17.3APRCh. 17 - Nineteen measures of solvency and profitability...Ch. 17 - Prob. 17.5APRCh. 17 - Prob. 17.1BPRCh. 17 - Prob. 17.2BPRCh. 17 - Effect of transactions on current position...Ch. 17 - Nineteen measures of solvency and profitability...Ch. 17 - Solvency and profitability trend analysis Crosby...Ch. 17 - Nike, Inc., Problem Financial Statement Analysis...Ch. 17 - Prob. 17.1CPCh. 17 - Prob. 17.2CPCh. 17 - Vertical analysis The condensed income statements...Ch. 17 - Prob. 17.4CPCh. 17 - Comprehensive profitability and solvency analysis...
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
- The following data (in millions) are taken from recent financial statements of Nike Inc.: a. Determine the amount of change (in millions) and percent of change in net income for Year 2. Round to one decimal place. b. Determine the percentage relationship between net income and net sales (net income divided by net sales) for Year 2 and Year 1. Round to one decimal place. c. What conclusions can you draw from your analysis?arrow_forwardJuroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Required: 1. Calculate the return on sales. (Note: Round the percent to two decimal places.) 2. CONCEPTUAL CONNECTION Briefly explain the meaning of the return on sales ratio, and comment on whether Juroes return on sales ratio appears appropriate.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
- Cuneo 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 2 by expressing each line item for Year 2 as a percentage of that same line item from Year 1. (Note: Round percentages to the nearest tenth of a percent.) 2. Prepare a common-size income statement for Year 3 by expressing each line item for Year 3 as a percentage of that same line item from Year 1. (Note: Round percentages to the nearest tenth of a percent.)arrow_forwardThe following data (in millions) were taken from the financial statements of Costco Wholesale Corporation: a. For Costco, determine the amount of change in millions and the percent of change (round to one decimal place) from the prior year to the recent year for: 1. Revenue 2. Operating expenses 3. Operating income b. Comment on the results of your horizontal analysis in part (a). c. Based upon Exercise 2-23, compare and comment on the operating results of Target and Costco for the recent year.arrow_forwardRevenue and expense data for Gresham Inc. for two recent years are as follows: a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. Round to one decimal place. b. Comment on the significant changes disclosed by the comparative income statement.arrow_forward
- Sundahl 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_forwardSundahl Companys income statements for the past 2 years are as follows: Refer to the information for Sundahl Company above. Required: Prepare a common-size income statement for Year 2 by expressing each line item for Year 2 as a percentage of that same line item from Year 1. (Note: Round percentages to the nearest tenth of a percent.)arrow_forwardSome recent financial statements for Smolira Golf Corporation follow. Find the following financial ratios for Smolira Golf Corporation (use year-end figures rather than average values where appropriate): (Enter the profitability ratio answers as a percent rounded to 2 decimal places, e.g., 32.16. Round the remaining answers to 2 decimal places, e.g., 32.16.) a. Profitability Ratios Profit margin % Return on Assets % Return on Equity % b. Asset utilization ratios: Total asset turnover times Inventory turnover times Receivables turnover timesarrow_forward
- Calculate the profitability ratios of Dernham Inc. in the following table. Convert all calculations to a percentage rounded to two decimal places. Ratio Operating margin Value Year 2 Year 1 61.54% Profit margin 44.39% Return on total assets 17.09% Return on common equity 32.13% Basic earning power 22.22% Decision makers and analysts look deeply into profitability ratios to identify trends in a company's profitability. Profitability ratios give insights into both the survivability of a company and the benefits that shareholders receive. Identify which of the following statements are true about profitability ratios. Check all that apply. A higher operating margin than the industry average indicates either lower operating costs, higher product pricing, or both. If a company's operating margin increases but its profit margin decreases, it could mean that the company paid more in interest or taxes. An increase in the return on assets ratio implies an increase in the assets a firm owns. If a…arrow_forwardIdentify any favorable and unfavorable trends in the following income statements by preparing a vertical analysis. Write a paragraph explaining what you find. (Round percentages to two decimal places.) Becker Corporation Income Statements For the Years Ended December 31 Year 2 Revenues Operating expenses: Wages expense Rent expense Utilities expense Interest expense Total operating expenses Net income Year 1 $394,000 $212,500 $ 79,000 $ 65,000 19,000 21,000 7,500 18,000 14,200 7,800 $126,500 $105,000 $267,500 $107,500arrow_forwardPrepare a multi-step vertical analysis income statement for Brea Corporation as of December 31, 2020using column 2 for detail, column 3 for nets, sub-totals, & totals, and column 4 for the vertical analysispercentages to the nearest tenth on the 4-column accounting paper provided online. place the units, tens, hundreds, thousands, etc. in the proper mini column, and leave the pennies blankexcept for earnings per share. Dollar signs are used at the top of the column and after a total line. Double underlining should only beused for net income.Each section starts all the way to the far left of the description column with a header row, then theitems following with an indentation, and then a net or total row with an additional indentation. If thesection is a single item like income tax expense, no header or net total / rows are necessary. Skip a rowbetween each section. Use column 1 as an overflow from the description column. Abbreviations shouldbe avoided on financial statements.Some…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
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
How To Analyze an Income Statement; Author: Daniel Pronk;https://www.youtube.com/watch?v=uVHGgSXtQmE;License: Standard Youtube License