ACCOUNTING,CHAP.1-13
26th Edition
ISBN: 9781305088412
Author: WARREN
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
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.
The amount and percentage of change in the net income from year 1 to year 2.
(b)
To determine
The percentage relationship between net income and sales of year 2 and year 1.
(c)
To determine
To explain: The conclusion drawn from the analysis.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Income statements for Campbell Company for Year 3 and Year 4 follow:
CAMPBELL COMPANY
Income Statements
Year 4
Year 3
$180,800
120,400
19,900
14,500
Sales
$200,800
Cost of goods sold
Selling expenses
Administrative expenses
Interest expense
Total expenses
142,400
21,900
12,500
3,900
$180,700
5,900
$160,700
20,100
3,700
Income before taxes
20,100
Income taxes expense
6,500
Net income
$ 13,600
$ 16,400
Required
a. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4.
b. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year.
Complete this question by entering your answers in the tabs below.
Required A
Required B
Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year
4. (Negative answers should be indicated by a minus sign. Round your percentage answers to 1 decimal place. (i.e., 0.234
should be entered…
Income statements for Walton Company for Year 3 and Year 4 follow:
WALTON COMPANY
Income Statements.
Sales
Cost of goods sold.
Selling expenses
Administrative expenses
Interest expense
Total expenses
Income before taxes
Income taxes expense
Net income
Required A Required B
Year 4
$200, 300
143,300
20,900
12,900
3,200
Required
a. Perform a horizontal analysis, showing the percentage change in each income statement component between Year 3 and Year 4.
b. Perform a vertical analysis, showing each income statement component as a percentage of sales for each year.
Sales
Cost of goods sold
Selling expenses
Administrative expenses
Interest expense
Total expenses
Income before taxes
Income taxes expense
Net income
$180,300
$160,300
20,000
20,000
3,300
5,600
$ 14,400 $ 16,700
Complete this question by entering your answers in the tabs below.
Year 3
$180,300
X Answer is complete but not entirely correct.
Perform a vertical analysis, showing each income statement component as a percentage of…
Solve and perform the different financial ratios using the financial statements of XYZ Company for the year 2021.
1. Current Ratio
2. Quick Ratio
3. Receivables Turnover
4. Inventory Turnover
5. Debt Ratio
6. Equity Ratio
7. Times Interest Earned
8. Gross Profit Margin
9. Operating Profit Margin
10. Net Profit Margin
Chapter 3 Solutions
ACCOUNTING,CHAP.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 - Type of adjustment Classify the following items as...Ch. 3 - Prob. 3.2BPECh. 3 - Prob. 3.3APECh. 3 - Adjustment for prepaid expense The prepaid...Ch. 3 - Prob. 3.4APECh. 3 - Prob. 3.4BPECh. 3 - Adjustment for accrued revenues At the end of the...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 - Prob. 3.8APECh. 3 - Prob. 3.8BPECh. 3 - Effect of errors on adjusted trial balance For...Ch. 3 - Effect of errors on adjusted trial balance For...Ch. 3 - Prob. 3.10APECh. 3 - Prob. 3.10BPECh. 3 - Prob. 3.1EXCh. 3 - Prob. 3.2EXCh. 3 - Prob. 3.3EXCh. 3 - Prob. 3.4EXCh. 3 - Prob. 3.5EXCh. 3 - Prob. 3.6EXCh. 3 - Adjusting entries for prepaid insurance The...Ch. 3 - Prob. 3.8EXCh. 3 - Prob. 3.9EXCh. 3 - Prob. 3.10EXCh. 3 - Adjusting entries for unearned and accrued fees...Ch. 3 - Prob. 3.12EXCh. 3 - Prob. 3.13EXCh. 3 - Prob. 3.14EXCh. 3 - Prob. 3.15EXCh. 3 - Prob. 3.16EXCh. 3 - Prob. 3.17EXCh. 3 - Prob. 3.18EXCh. 3 - Determining fixed assets book value The balance in...Ch. 3 - Prob. 3.20EXCh. 3 - Prob. 3.21EXCh. 3 - Prob. 3.22EXCh. 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 - Prob. 3.26EXCh. 3 - Adjusting entries from trial balances The...Ch. 3 - Prob. 3.28EXCh. 3 - Prob. 3.29EXCh. 3 - Prob. 3.1APRCh. 3 - Prob. 3.2APRCh. 3 - Prob. 3.3APRCh. 3 - Adjusting entries Good Note Company specializes in...Ch. 3 - Prob. 3.5APRCh. 3 - Adjusting entries and errors At the end of April,...Ch. 3 - Prob. 3.1BPRCh. 3 - Prob. 3.2BPRCh. 3 - Prob. 3.3BPRCh. 3 - Prob. 3.4BPRCh. 3 - Prob. 3.5BPRCh. 3 - Prob. 3.6BPRCh. 3 - The unadjusted trial balance that you prepared for...Ch. 3 - Ethics and professional conduct in business Daryl...Ch. 3 - Accrued revenue The following is an excerpt from a...Ch. 3 - Prob. 3.3CP
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_forwardANALY SIS OF PROFITABILITY Based on the financial statement data in Exercise 24-1A, compute the following profitability measures for 20-2 (round all calculations to two decimal places): (a) Profit margin ratio (b) Return on assets (c) Return on common stockholders equity (d) Earnings per share of common stockarrow_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_forward
- 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.arrow_forwardThe following select account data is taken from the records of Reese Industries for 2019. A. Use the data provided to compute net sales for 2019. B. Prepare a simple income statement for the year ended December 31, 2019. C. Compute the gross margin for 2019. D. Prepare a multi-step income statement for the year ended December 31, 2019.arrow_forwardComparative Income Statement Use the following comparative income statement form to enter amounts you identify from the computations on the Liquidity and Solvency Measures part and on the Profitability Measures part. Compute any missing amounts and complete the horizontal analysis columns. Enter percentages as decimal amounts, rounded to one decimal place. When rounding, look only at the figure to the right of one decimal place. If 5, round up. For example, for 32.048% enter 32.0%. For 32.058% enter 32.1%. Sales Cost of goods sold Gross profit Selling expenses Administrative expenses Total operating expenses Operating income Other expense (interest) Income before income tax expense Income tax expense Net income Comparative Income Statement For the Years Ended December 31, 20Y6 and 20Y5 $ 20Y6 8,250,000 X (1,242,000) 20Y5 $7,287,000 (3,444,000) $3,843,000 $(1,457,600) (1,106,000) $(2,563,600) $1,279,400 (120,600) $1,158,800 (181,980) $976,820 $ $ $ Increase/(Decrease) Amount 823,000 X…arrow_forward
- Which of the following is a technique for reviewing relationships on an income statement by assigning net sales as 100%? A. Ratio analysis. B. Current ratio. C. Horizontal analysis. D. Vertical analysis.arrow_forwardUse for financial statements for Yellow Hammer to answer problems 1-3 1. Assess Yellow Hammer's income statement by calculating the sales growth, EBITDA profitability (EBITDA/Sales) and coverage ratios using EBIT and EBITDA for each year. 2. Assess Yellow Hammer's balance sheet by calculating the leverage ratios using of Debt/Capitalization and Debt/EBITDA. 3. Using the table below and the ratios that you've calculated, insert the EBIT interest coverage, EBITDA interest coverage, Debt/EBITDA and Debt to Capitalization and then provide an assessment of Yellow Hammer's credit quality. Oper. income (bef. D&A)/revenues (%) Return on capital (%) EBIT interest coverage (x) EBITDA interest coverage (x) FFO/debt (%) Free oper. cash flow/debt (%) Disc. cash flow/debt (%) Debt/EBITDA (x) Debt/debt plus equity (%) AA 32.1 19.7 13.1 17.9 72.3 43.9 18.3 1.0 21.0 A 19.1 16.8 8.1 11.6 53.0 28.4 10.6 1.4 32.1 BBB 17.1 12.0 4.5 7.1 34.5 15.5 6.9 2.1 42.2 BB 20.4 9.5 3.0 4.9 24.0 9.0 3.9 2.9 47.4 B 15.3…arrow_forward= The current year financial statements for Blue Water Company and Prime Fish Company are presented below. Prime Fish Balance sheet Cash Accounts receivable (net) Inventory Property & equipment (net) Other assets Total assets Current liabilities Long-term debt (interest rate: 15%) Capital stock ($10 par value) Additional paid-in capital Retained earnings Total liabilities and stockholders' equity Income statement Sales revenue (1/2 on credit) Cost of goods sold Operating expenses Net income Other data Per share stock price at end of current year Blue Water $ 42,300 44,500 92,500 159,500 85,300 $ 424,100 $ 92,500 74,100 157,100 30,300 70,100 $ 424,100 $ 427,500 (234,500) (163,600) $ 29,400 $ 23.3 45% $ 19,700 34,900 47,800 416,600 318,000 $ 34,300 $ 837,000 $ 68,500 62,600 525,000 107,300 73,600 $ 837,000 $ 789,000 (401,300) (312,300) $ 75,400 $28 45% Average income tax rate Dividends declared and paid in current year Both companies are in the fish catching and manufacturing business.…arrow_forward
- Complete this question by entering your answers in the tabs below. Analysis Analysis Bal Sheet Inc Stmt Prepare a vertical analysis of an income statements for Year 4 and Year 3. (Percentages may not add exactly due to rounding. Round your answers to 2 decimal places. (i.e., .2345 should be entered as 23.45).) Revenues Sales (net) Other revenues Total revenues Expenses Cost of goods sold FANNING COMPANY Vertical Analysis of Income Statements Year 4 Selling, general, and administrative expense Interest expense Income tax expense Total expenses Net income Amount $ 231,900 9,300 241,200 118,800 54,200 6,800 22,800 202,600 $ 38,600 Percentage of Total Analysis Bal Sheet % % Year 3 Amount $ 211,200 6,400 217,600 102,100 49,100 6,000 21,800 179,000 $ Percentage of Total % % 38,600 Analysis Inc Stmt > Show lessarrow_forwardWhich of the following is used to determine how the sales revenue of a company has changed from one year to the next? A horizontal analysis of the income statement B vertical analysis of the income statement C vertical analysis of the balance sheet D horizontal analysis of the balance sheetarrow_forwardPrepare 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:…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
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
The KEY to Understanding Financial Statements; Author: Accounting Stuff;https://www.youtube.com/watch?v=_F6a0ddbjtI;License: Standard Youtube License