(a)
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 Company D’s income statement.
(b)
To prepare: The vertical analysis of Company H’s income statement.
(c)
To compare: The vertical analysis of two companies’ income statement.
Want to see the full answer?
Check out a sample textbook solutionChapter 3 Solutions
Working Papers, Chapters 1-17 for Warren/Reeve/Duchac's Accounting, 26th and Financial Accounting, 14th
- 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_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_forwardThe 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_forward
- The average liabilities, average stockholders' equity, and average total assets are as follows: 1. Determine the following ratios for both companies, rounding ratios and percentagesto one decimal place: a. Return on total assets b. Return on stockholders' equity c. Times interest earned d. Ratio of total liabilities to stockholders' equity 2. Based on the information in (1), analyze and compare the two companies'solvency and profitability. Comprehensive profitability and solvency analysis Marriott International, Inc., and Hyatt Hotels Corporation are two major owners and managers of lodging and resort properties in the United States. Abstracted income statement information for the two companies is as follows for a recent year (in millions): Balance sheet information is as follows:arrow_forwardPerforming horizontal analysis—income statement Data for Mulberry Designs, Inc. follow: Requirements Prepare a horizontal analysis of the comparative income statement of Mulberry Designs, Inc. Round percentage changes to one decimal place. Why did 2018 net income increase by a higher percentage than net sales revenue?arrow_forwardThe 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.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 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_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 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_forwardRequirements: a. Prepare horizontal analysis based on the above statements presented (for percent: round of your answers to 2 decimal places) Music Lover, Inc.xlsx b. Evaluate the company's financial position and results of operation using the comparative statement analysis i. Short-term solvency analysis ii. Long-term financial position analysis iii. Operating efficiency and profitability analysisarrow_forward
- Required Prepare a vertical analysis of both the balance sheets and income statements for Year 4 and Year 3. Complete this question by entering your answers in the tabs below. Analysis Bal Sheet Analysis 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).) ALLENDALE COMPANY Vertical Analysis of Income Statements Year 4 Year 3 Amount % Total Amount % Total Revenues Sales (net) $ 230,000 100.00 % $ 210,000 100.00 % Other revenues 8,000 5,000 Total revenues 238,000 215,000 Expenses Cost of goods sold 120,000 103,000 Selling, general, and administrative expense 55,000 50,000 Interest expense 8,000 7,200 Income tax expense 23,000 22,000 Total expenses 206,000 182,200 Net income $ 32,000 % $ 32,800 %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_forwardPrepare a horizontal analysis of both the balance sheet and income statement. Complete this question by entering your answers in the tabs below. Analysis Bal Analysis Inc Sheet Stmt Prepare a horizontal analysis of the income statement. (Negative answers should be indicated by a minus sign. Round your answers to 1 decimal place. (i.e., .234 should be entered as 23.4).) ALLENDALE COMPANY Horizontal Analysis of Income Statements Year 4 Year 3 % Change Revenues Sales (net) $ 230,000 $ 210,000 % Other revenues 8,000 5,000 Total revenues 238,000 215,000 Expenses Cost of goods sold 120,000 103,000 Selling, general, and administrative expenses 55,000 50,000 Interest expense 8,000 7,200 Income tax expense 23,000 22,000 Total expenses 206,000 182,200 Net income (loss) $ 32,000 $ 32,800 %arrow_forward
- Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning