Concept Introduction:
Vertical Analysis:
Vertical Analysis is used to analyses the % of items in statement for a particular period as the % of total amount. Vertical Analysis is done for particular period for different items. For example analysis of % of assets as % of Total assets for a particular year is done using the Vertical analysis.
Requirement-a:
To Prepare:
A comparative income statement using Vertical analysis
Answer to Problem 9.1E
A comparative income statement using Vertical analysis is as follows:
Comparative income statement using Vertical analysis | ||||
20Y8 | 20Y8 | |||
$ | Common Size % | $ | Common Size % | |
Sales | $ 900,000 | 100.0% | $ 725,000 | 100.0% |
Cost of Goods sold | $(558,000) | -62.0% | $(435,000) | -60.0% |
Gross Profit | $ 342,000 | 38.0% | $ 290,000 | 40.0% |
Selling expenses | $(117,000) | -13.0% | $(116,000) | -16.0% |
Administrative expenses | $ (63,000) | -7.0% | $ (63,250) | -8.7% |
Income Tax Expense | $ (76,500) | -8.5% | $ (58,000) | -8.0% |
Net Income | $ 85,500 | 9.5% | $ 52,750 | 7.3% |
Explanation of Solution
A comparative income statement using Vertical analysis is prepared as follows:
Comparative income statement using Vertical analysis | ||||
20Y8 | 20Y8 | |||
$ | Common Size % | $ | Common Size % | |
A | B = A / Sales | C | D = C / Sales | |
Sales | $ 900,000 | 100.0% | $ 725,000 | 100.0% |
Cost of Goods sold | $(558,000) | -62.0% | $(435,000) | -60.0% |
Gross Profit | $ 342,000 | 38.0% | $ 290,000 | 40.0% |
Selling expenses | $(117,000) | -13.0% | $(116,000) | -16.0% |
Administrative expenses | $ (63,000) | -7.0% | $ (63,250) | -8.7% |
Income Tax Expense | $ (76,500) | -8.5% | $ (58,000) | -8.0% |
Net Income | $ 85,500 | 9.5% | $ 52,750 | 7.3% |
Concept Introduction:
Vertical Analysis:
Vertical Analysis is used to analyses the % of items in statement for a particular period as the % of total amount. Vertical Analysis is done for particular period for different items. For example analysis of % of assets as % of Total assets for a particular year is done using the Vertical analysis.
Requirement-a:
To Indicate:
Significant changes shown by the comparative income statement
Answer to Problem 9.1E
Significant changes shown by the comparative income statement are as follows:
- Cost of goods sold % has increased in the year 20Y8 as compared with the year 20Y7
- Selling expenses % has reduced in the year 20Y8 as compared with the year 20Y7
- Income Tax Expense % has increased in the year 20Y8 as compared with the year 20Y7
Explanation of Solution
A comparative income statement using Vertical analysis is prepared as follows:
Comparative income statement using Vertical analysis | ||||
20Y8 | 20Y8 | |||
$ | Common Size % | $ | Common Size % | |
A | B = A / Sales | C | D = C / Sales | |
Sales | $ 900,000 | 100.0% | $ 725,000 | 100.0% |
Cost of Goods sold | $(558,000) | -62.0% | $(435,000) | -60.0% |
Gross Profit | $ 342,000 | 38.0% | $ 290,000 | 40.0% |
Selling Expense | $(117,000) | -13.0% | $(116,000) | -16.0% |
Administrative expenses | $ (63,000) | -7.0% | $ (63,250) | -8.7% |
Income Tax Expense | $ (76,500) | -8.5% | $ (58,000) | -8.0% |
Net Income | $ 85,500 | 9.5% | $ 52,750 | 7.3% |
Significant changes shown by the comparative income statement are as follows:
- Cost of goods sold % has increased in the year 20Y8 as compared with the year 20Y7
- Selling expenses % has reduced in the year 20Y8 as compared with the year 20Y7
- Income Tax Expense % has increased in the year 20Y8 as compared with the year 20Y7
Want to see more full solutions like this?
Chapter 9 Solutions
Survey of Accounting - With CengageNOW 1Term
- Which of the following accounts would be reported under operating expenses on a multi-step income statement? A. sales B. advertising expense C. sales returns and allowances D. interest expensearrow_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_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_forward
- Which of the following statements are true?A) Common-size balance sheet shows relative value of the various items.B) In the common size income statement, each product is represented as a percentage of the net sales figure.C) Common size income statements represent the various elements as a percentage of the gross profit. Select one: a. A, B, C b. Both A and C c. Both A and B d. Both B and Carrow_forwardWhen performing vertical analysis of an income statement, the base amount is ________. A sales revenue B total expenses C gross profit D net incomearrow_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
- VII. Direction: Compute and interpret. The following comparative financial statements are provided by Avatar Industries. You were asked to compute the different financial ratios and provide your interpretations with regards to profitability, efficiency, liquidity and solvency of the company. Use the Answer Sheet template below to input your answer and solution. AVATAR INDUSTRIES AVATAR INDUSTRIES Comparative Statement of Financial Position For the years 2019 and 2018 Comparative Income Statement For the years 2019 and 2018 2019 2018 2019 2018 ASSETS Current Assets: Sales P200,000 P210,000 Cash & Cash Equivalent P65,000 P70,000 Sales Returns and Allowances 40,000 25,000 Accounts Receivable 40,000 35,000 Net Sales 160,000 185,000 Marketable Secuities 40,000 35,000 Cost of Goods Sold 100,000 115,625 Inventory 100,000 80,000 Gross Profit 60,000 69,375 Total Current Assets 220,000 200,000 160,000 P445,000 P380,000 245,000 Operating Expenses: Fixed Assets Selling Expenses 22,000 25,000 Total…arrow_forwardVII. Direction: Compute and interpret. The following comparative financial statements are provided by Avatar Industries. You were asked to compute the different financial ratios and provide your interpretations with regards to profitability, efficiency, liquidity and solvency of the company. Use the Answer Sheet template below to input your answer and solution. AVATAR INDUSTRIES AVATAR INDUSTRIES Comparative Statement of Financial Position For the years 2019 and 2018 Comparative Income Statement For the years 2019 and 2018 2019 2018 2019 2018 ASSETS Current Assets: Sales P200,000 P210,000 Cash & Cash Equivalent P65,000 P70,000 Sales Returns and Allowances 40,000 25,000 Accounts Receivable 40,000 35,000 Net Sales 160,000 185,000 Marketable Securities 40,000 35,000 Cost of Goods Sold 100,000 115,625 Inventory 100,000 80,000 Gross Profit 60,000 69,375 Total Current Assets 245,000 220,000 Operating Expenses: Fixed Assets 200,000 160,000 Selling Expenses 22,000 25,000 Total Assets P445,000…arrow_forwardFrom the given Statement of Financial Position and Income statement, solve for the following: 1) Compute the FINANCIAL ratios that measure: c) Operating Activity -Days Sales in Receivable -Days in Inventory d) Profitability -Earnings per Share -Return on Asset -Return on Equity -Operating Profit Margin -Net Profit Margin 2) Analyze, interpret, and draw conclusions based on the results of your computations.arrow_forward
- Below are the two basic financial statements of Chiz Trading Company. You are tasked to prepare an analysis using Horizontal and Vertical Analysis of their two-dated financial statements. In addition to this you have been tasked to prepare financial ratios measuring the company’s: Liquidity Status Current Ratios Quick Asset Ratios Efficiency Status Asset Turnover Fixed Asset Turnover Inventory Turnover Days in Inventory Accounts Receivable Turnover Days in Receivable Profitability Status: Gross Profit margin Ratio Operating Income Ratio Net Profit Ratio Return on Assets Return on Equityarrow_forward3. Using the data provided in Table 1, prepare common size income statements using revenues and cost-of-goods-sold in the original S-1 and amended S-1. Analyze trends of expenses as a percentage of revenue for 2009 and 2010. Compare and contrast the following ratios: a. Gross Margin Percentage; b. Asset Turnover Ratio.arrow_forwardFrom the given Statement of Financial Position and Income statement, solve for the following: 1) Compute the FINANCIAL ratios that measure: c) Operating Activity -Accounts Receivable Turnover -Days Sales in Receivable -Inventory Turnover -Days in Inventory d) Profitability -Earnings per Share -Return on Asset -Return on Equity -Operating Profit Margin -Net Profit Margin 2) Analyze, interpret, and draw conclusions based on the results of your computations.arrow_forward
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage LearningCentury 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning