EBK ACCOUNTING, CHAPTERS 1-13
27th Edition
ISBN: 9781337514088
Author: WARREN
Publisher: CENGAGE LEARNING - CONSIGNMENT
expand_more
expand_more
format_list_bulleted
Question
Chapter 3, Problem 3.28EX
(a)
To determine
Vertical analysis:
Vertical analysis is the method of financial statement analysis, and it is useful to evaluating a company’s performance and financial condition. Vertical analysis is helpful for analyzing the changes in the financial statements over the time, and comparing the each item on a financial statement with a total amount from the same statement. In the vertical analysis, the financial statements are analyzed in the following manner:
- In vertical analysis of a balance sheet, each asset item is stated as a percent of the total asset, and each liability and owner’s equity item is stated as a percent of total liabilities and owner’s equity.
- In vertical analysis of an income statement, each item of revenue and expense is stated as a percent of total revenues of the business.
To prepare: The vertical analysis of A Incorporation’s operating income statement.
(b)
To determine
To explain: The decrease in income from operations.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Vertical analysis
Amazon.com, Inc. is the largest Internet retailer in the United States. Amazon’s income statements through income from operations for two recent years are as follows (in millions):
Amazon.com, Inc.
Operating Income Statements
For the Years Ended December 31
(in millions)
Year 2
Year 1
Product sales
$70,080
$60,903
Service sales
18,908
13,549
Total sales
$88,988
$74,452
Cost of sales
$62,752
$54,181
Fulfillment
10,766
8,585
Marketing
4,332
3,133
Technology and content
9,275
6,565
General and administrative
1,552
1,129
Other operating expense (income), net
133
114
Total operating expenses
$88,810
$73,707
Income from operations
$178
$745
Required:
a. Prepare a vertical analysis of the two operating income statements. Round percentages to one decimal place.
Amazon.com, Inc.
Operating Income Statements
For the Years Ended December 31 (in millions)
Year 2
Year 1
Amount
Percent
Amount
Percent
Product sales…
Analyze and compare Amazon.com, Best Buy, and Walmart
The condensed income statements through operating income for Amazon.com, Inc. (AMZN), Best Buy Co., Inc. (BBY), and Walmart Inc. (WMT) for a recent fiscal year follow (in millions):
Line Item Description
Amazon
Best Buy
Walmart
Sales
$280,522
$43,638
$523,964
Cost of sales
(165,536)
(33,590)
(394,605)
Gross profit
$114,986
$10,048
$129,359
Selling, general, and administrative expenses
(100,244)
(7,998)
(108,791)
Operating expenses
(201)
(41)
0
Operating income
$14,541
$2,009
$20,568
Question Content Area
1. Prepare comparative common-sized income statements for each company. Round percentages to one decimal place. If percentages is zero, enter "0". For those boxes in which you must enter subtractive or negative numbers use a minus sign. (Example: -300)
Comparative Income statements
Line Item Description
Amazon
Best Buy
Walmart
Sales
Sales%
Sales%
Sales%
Cost of sales
Cost of sales%
Cost of…
Vertical analysis
Amazon.com, Inc.is the largest Internet retailer in the United States. Amazon's income statements through income from operations for two recent years are as follows (in mH!ions):
Amazon.com,Inc.
Operating Income Statements
For the Years Ended December 31 (in millions)
Year 2
Year 1
Product sales
$70,080
$60,903
Service sales
18,908
13,549
Total sales
$88,988
$74,452
Cost of sales
$62,752
$54,181
Fulfillment
10,766
8,585
Marketing
4,332
3,133
Technology and content
9,275
6,565
General and administrative
1,552
1,129
Other operating expense (income), net
133
114
Total operating expenses
$88,810
$73,707
Income from operations
$ 178
$ 745
1.Prepare a vertical analysis of the two operating income statements.Round percentages to one decimal pl
2.Use the vertical analysis to explain the decrease in income from operations.
Chapter 3 Solutions
EBK ACCOUNTING, CHAPTERS 1-13
Ch. 3 - How are revenues and expenses reported on the...Ch. 3 - Is the matching concept related to (a) the cash...Ch. 3 - Why are adjusting entries needed at the end of an...Ch. 3 - What is the difference between adjusting entries...Ch. 3 - Identify the four different categories of...Ch. 3 - If the effect of the debit portion of an adjusting...Ch. 3 - If the effect of the credit portion of an...Ch. 3 - Does every adjusting entry affect net income for...Ch. 3 - Prob. 9DQCh. 3 - (a) Explain the purpose of the two accounts:...
Ch. 3 - Accounts requiring adjustment Indicate with a Yes...Ch. 3 - Accounts requiring adjustment Indicate with a Yes...Ch. 3 - Prob. 3.2APECh. 3 - Type of adjustment Classify the following items as...Ch. 3 - Adjustment for accrued revenues At the end of the...Ch. 3 - Adjustment for accrued expense Prospect Realty Co....Ch. 3 - Adjustment for accrued expense We-Sell Realty Co....Ch. 3 - Adjustment for unearned revenue On June 1, 2019,...Ch. 3 - Adjustment for unearned revenue The balance in the...Ch. 3 - Adjustment for prepaid expense The prepaid...Ch. 3 - Adjustment for prepaid expense The supplies...Ch. 3 - Adjustment for depreciation The estimated amount...Ch. 3 - Adjustment for depreciation The estimated amount...Ch. 3 - Effect of omitting adjustments For the year ending...Ch. 3 - Effect of omitting adjustments For the year ending...Ch. 3 - Effect of errors on adjusted trial balance For...Ch. 3 - Effect of errors on adjusted trial balance For...Ch. 3 - Vertical analysis Two income statements for...Ch. 3 - Vertical analysis Two income statements for Cornea...Ch. 3 - Classifying types of adjustments Classify the...Ch. 3 - Classifying adjusting entries The following...Ch. 3 - Adjusting entry for accrued fees At the end of the...Ch. 3 - Effect of omitting adjusting entry The adjusting...Ch. 3 - Adjusting entries for accrued salaries Garcia...Ch. 3 - Determining wages paid The wages payable and wages...Ch. 3 - Effect of omitting adjusting entry Accrued...Ch. 3 - Effect of omitting adjusting entry When preparing...Ch. 3 - Adjusting entries for unearned fees The balance in...Ch. 3 - Effect of omitting adjusting entry At the end of...Ch. 3 - Adjusting entry for supplies The balance in the...Ch. 3 - Determining supplies purchased The supplies and...Ch. 3 - Effect of omitting adjusting entry At August 31,...Ch. 3 - Adjusting entries for prepaid insurance The...Ch. 3 - Adjusting entries for prepaid insurance The...Ch. 3 - Adjusting entries for unearned and accrued fees...Ch. 3 - Adjusting entries for prepaid and accrued taxes...Ch. 3 - Adjustment for depreciation The estimated amount...Ch. 3 - Determining fixed asset's book value The balance...Ch. 3 - Book value of fixed assets In a recent balance...Ch. 3 - Effects of errors on financial statements For a...Ch. 3 - Effects of errors on financial statements For a...Ch. 3 - Effects of errors on financial statements The...Ch. 3 - Effects of errors on financial statements If the...Ch. 3 - Adjusting entries for depreciation; effect of...Ch. 3 - Adjusting entries from trial balances The...Ch. 3 - Adjusting entries from trial balances The...Ch. 3 - Prob. 3.28EXCh. 3 - Prob. 3.29EXCh. 3 - Prob. 3.30EXCh. 3 - Adjusting entries On December 31, the following...Ch. 3 - Prob. 3.2APRCh. 3 - Adjusting entries Milbank Repairs Service, an...Ch. 3 - Adjusting entries Good Note Company specializes in...Ch. 3 - Adjusting entries and adjusted trial balances...Ch. 3 - Adjusting entries and errors At the end of April,...Ch. 3 - Adjusting entries On May 31, the following data...Ch. 3 - Prob. 3.2BPRCh. 3 - Adjusting entries Crazy Mountain Outfitters Co.,...Ch. 3 - Adjusting entries The Signage Company specializes...Ch. 3 - Adjusting entries and adjusted trial balances...Ch. 3 - Prob. 3.6BPRCh. 3 - The unadjusted trial balance that you prepared for...Ch. 3 - Prob. 3.1CPCh. 3 - Ethics in Action Daryl Kirby opened Squid Realty...Ch. 3 - Prob. 3.4CPCh. 3 - Prob. 3.5CP
Knowledge Booster
Similar questions
- Horizontal analysis of income statement 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 comparitive income statement: McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $910, 000 $700,000 Cost of goods sold 441,000 350,000 Gross Profit $469,000 350,000 Selling expenses $139,150 $115,000 Administrative expenses 99,450 85,000 Total operating expenses $238,600 $200,000 Income from operations $230,400 $150,000 Other income 65,000 50,000 Income before income tax $295,400 $200,000 Income tax expense 65,000 50,000 Net income $230,400 $150,000 Instructions 1. Prepare a comparitive 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…arrow_forwardCommon-Sized Income Statement Revenue and expense data for the current calendar year for Sorenson Electronics Company and for the electronics industry are as follows. Sorenson Electronics Company data are expressed in dollars. The electronics industry averages are expressed in percentages. SorensonElectronicsCompany ElectronicsIndustryAverage Sales $1,940,000 100 % Cost of goods sold (1,358,000) (76) Gross profit $582,000 24 % Selling expenses $(329,800) (9) % Administrative expenses (116,400) (9) Total operating expenses $(446,200) (18) % Operating income $135,800 6 % Other revenue and expense: Other revenue 38,800 4 Other expense (19,400) (3) Income before income tax $155,200 7 % Income tax expense (58,200) (5) Net income $97,000 2 % a. Prepare a common-sized income statement comparing the results of operations for Sorenson Electronics Company with the industry average. If…arrow_forwardCommon-Sized Income Statement Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. Tannenhill’s data are expressed in dollars. The electronics industry averages are expressed in percentages. TannenhillCompany ElectronicsIndustryAverage Sales $2,740,000 100 % Cost of goods sold 1,753,600 69 Gross profit $986,400 31 % Selling expenses $602,800 18 % Administrative expenses 219,200 7 Total operating expenses $822,000 25 % Operating income $164,400 6 % Other revenue 54,800 2 $219,200 8 % Other expense 27,400 1 Income before income tax $191,800 7 % Income tax expense 82,200 5 Net income $109,600 2 % a. Prepare a common-sized income statement comparing the results of operations for Tannenhill Company with the industry average. If required, round percentages to one decimal place. Enter all amounts as positive…arrow_forward
- Assume the following sales data for a company: Line Item Description Amount Current year $891,303 Preceding year 515,759 What is the percentage increase in sales from the preceding year to the current year?arrow_forwardCommon-Sized Income Statement Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. Tannenhill's data are expressed in dollars. The electronics industry averages are expressed in percentages. Electronics Tannenhill Industry Company Average Sales $1,540,000 100 % Cost of goods sold 1,016,400 72 Gross profit $523,600 28 % Selling expenses $308,000 15 % Administrative expenses 123,200 7 Total operating expenses $431,200 22 % Operating income $92,400 6 % Other revenue 30,800 2 $123,200 8 % Other expense 15,400 1 Income before income tax $107,800 7 % Income tax expense 46,200 4 Net income $61,600 3 % a. Prepare a common-sized income statement comparing the results of operations for Tannenhill Company with the industry average. If required, round percentages to one decimal place. Enter all amounts as positive numbers. Tannenhill Company Common-Sized Income Statement For the Year Ended December 31 Tannenhill Tannenhill…arrow_forwardAssume the following sales data for a company: Line Item Description Amount Current year $883,993 Preceding year 542,076 What is the percentage increase in sales from the preceding year to the current year? a. 63.08% b. 61.32% c. 163.08% d. 38.68%arrow_forward
- Preparing Income Statements by Using Net Sales as the Base: Vertical Analysis Scherer Company provided the following income statements for its first 3 years of operation: Scherer CompanyIncome StatementsYears of Operation Year 1 Year 2 Year 3 Net sales $1,000,000 $1,100,000 $1,300,000 Less: Cost of goods sold (300,000) (315,000) (369,000) Gross margin $700,000 $785,000 $931,000 Less: Operating expenses (431,000) (488,000) (600,500) Income taxes (111,000) (123,000) (135,800) Net income $158,000 $174,000 $194,700 Required: Prepare common-size income statements by using net sales as the base. (Note: Enter all amounts as positive numbers, except for a net loss. Enter net loss as a negative number, if applicable. Round answers to the nearest whole percentage. Percentages may not calculate down.) Scherer Company Common-Size Income Statements Years of Operation Year 1 Year 1 Year 2 Year 2 Year 3 Year 3 Dollars Percentage Dollars Percentage…arrow_forwardCommon-Sized Income Statement Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. Tannenhill's data are expressed in dollars. The electronics industry averages are expressed in percentages. TannenhillCompany ElectronicsIndustryAverage Sales $4,000,000 100.0 % Cost of goods sold (2,120,000) (60.0) Gross profit $1,880,000 40.0 % Selling expenses $(1,080,000) (24.0) % Administrative expenses (640,000) (14.0) Total operating expenses $(1,720,000) (38.0) % Operating income $160,000 2.0 % Other revenue and expense: Other revenue 120,000 3.0 Other expense (80,000) (2.0) Income before income tax expense $200,000 3.0 % Income tax expense (80,000) (2.0) Net income $120,000 1.0 % a. Prepare a common-sized income statement comparing the results of operations for Tannenhill Company with the…arrow_forwardRevenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous Year Sales $493,000 $419,000 Cost of goods sold 281,010 213,690 83,810 Selling expenses 83,800 Administrative expenses 93,670 71,230 Income tax expense 14,790 20,950 a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amour nounts as positive numbers. Innovation Quarter Inc Comparative Income Statement For the Years Ended December 31 Current year Amount Current year Percent Previous year Amount Previous year Percent Sales $493,000 $419,000 281,010 213,690 Cost of goods sold Selling expenses 83,810 83,800 96 96 93,670 71,230 Administrative expensesarrow_forward
- Common-Sized Income Statement Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. Tannenhill's data are expressed in dollars. The electronics industry averages are expressed in percentages. Electronics Tannenhill Industry Company Average $1,390,000 100 % Sales 736,700 59 Cost of merchandise sold $653,300 41 % Gross profit $417,000 25 % Selling expenses Administrative expenses 152,900 10 Total operating expenses $569,900 35 % Income from operations $83,400 6 % Other revenue and expense: Other revenue 27,800 2 Other expense (13,900) 1 Income before income tax expense $97,300 7 % Income tax expense 41,700 Net income $55,600 2 % a. Prepare a common-sized income statement comparing the results of operations for Tannenhill Company with the industry average. If required, round percentages to one decimal place. econ.docx Show all Type here to search 6:05 AM 59 F 局 10/30/2021 12 prt sc 00 5.arrow_forwardb. The vertical analysis indicates that the cost of goods sold as a percent of sales by 8 percentage points, while selling expenses - by 4 percentage points, and administrative expenses by 1 percentage points. Thus, net income as a percent of sales by 3 percentage points.arrow_forwardVertical Analysis of Income Statement Revenue and expense data for Innovation Quarter Inc. for two recent years are as follows: Current Year Previous Year Sales $457,000 $407,000 Cost of goods sold 283,340 231,990 Selling expenses 68,550 69,190 Administrative expenses 77,690 65,120 Income tax expense 9,140 16,280 a. Prepare an income statement in comparative form, stating each item for both years as a percent of sales. If required, round percentages to one decimal place. Enter all amounts as positive numbers. Innovation Quarter Inc. Comparative Income Statement For the Years Ended December 31 Current year Amount Current year Percent Previous year Amount Previous year Percent Sales $457,000 % $407,000 % Cost of goods sold 283,340 231,990 % % % Selling expenses 68,550 % 69,190 Administrative expenses 77,690 % 65,120 % % % % % Income tax expense 9,140 % 16,280 % % % b. The vertical analysis indicates that the cost of goods sold as a percent of sales by 5 percentage points, while selling…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education