a)
Horizontal Analysis: Horizontal analysis is prepared to make comparison between the financial statements to determine the changes in the financial statements for the previous year to the current year. The changes of the company are measured in dollars as well as in percentage.
Formula:
Vertical Analysis: Vertical analysis is prepared to analyze the relationship among various financial statements with a particular base amount. Use the following formula to calculate vertical analysis percentage:
Formula:
To prepare: Horizontal analysis of the income statement for Corporation D for the year 2017.
b)
To prepare: Vertical analysis for the income statement for Corporation D for 2017 and 2016.
Want to see the full answer?
Check out a sample textbook solutionChapter 13 Solutions
Financial Accounting: Tools for Business Decision Making, 8th Edition
- The 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_forwardThe following data (in millions) are taken from the financial statements of Target Corporation: a. For Target Corporation, 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. What conclusions can you draw from your analysis of the revenue and the total operating expenses?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 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_forward
- Suppose the following historical data is from the consolidated income statements filed by a media corporation. *chart attached* A): Prepare a horizontal analysis of the net income comparing 2012 and 2013. (Round percentages to one decimal place.) (how to answer chart is attached)arrow_forwardA.Perform horizontal analysisand vertical analysis (for 2020only)on the income statement. In your answer please remember to indicate if it is an INCREASE or (DECREASE) and round your findings to ONE decimal place [e.g. -32.996% is - 33.0% or minus 33.0% or (33.0%). B. Comment on the significant changes disclosed by the comparative statement of comprehensive income. What has caused the changes to occur? C. Prepare a statement of retained earnings for the year ended June 30, 2020. (Retained earnings at July 1, 2019 were $58,000, dividends declared and paid during the financial year were $37,000. D. Explain how profits for the year ended June 30, 2019 were $126,700 yet Retained Earnings at July 1, 2019 were only $58,000.arrow_forwardFor fiscal year 2018, Walmart Inc. (WMT) had total revenues of $500.34 billion, net income of $9.86 billion, total assets of $204.52 billion, and total shareholders' equity of $77.87 billion. a. Calculate Walmart's ROE directly, and using the DuPont Identity. b. Comparing with the data for Costco, use the DuPont Identity to understand the difference between the two firms' ROES. Data table For fiscal year 2018, Costco Wholesale Corporation (COST) had a net profit margin of 2.08%, asset turnover of 3.55, and a book equity multiplier of 3.37. Costco's ROE (DuPont) is 24.88%.arrow_forward
- The following data were taken from the financial statements of Gates Inc. for the current fiscal year. Please see the attachment for details: Assuming that total assets were $7,000,000 at the beginning of the current fiscal year, determine the following: (a) ratio of fixed assets to long-term liabilities, (b) ratio of liabilities to stockholders’ equity, (c) asset turnover, (d) return on total assets, (e) return on stockholders’ equity, and (f) return on common stockholders’ equity. Round ratios and percentages to one decimal place as appropriate.arrow_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_forwardApplying horizontal analysis, show the percentage change from 2019 to 2020 with 2019 as the base year. Comparative data for Why Is Everything Chrome's corporation for the two-year period 2019-2020 are given as follows: Income Statement Data 2019 2020 P 1,400,000.00 840,000.00 560,000.00 P 800,000.00 440,000.00 360,000.00 130,000.00 30.000.00 P 200,000.00 80.000.00 P 120,000.00 Net sales Cost of goods sold Gross profit Selling, general, and other expenses Income tax expense Net income 400,000.00 40,000.00 P 120,000.00 80,000.00 P 40.000.00 Dividends paid Net increase in retained earnings Balance Sheet Data 2019 2020 Assets P 540,000.00 800.000.00 P1.340.000.00 P 440,000.00 720.000.00 P1.160,000.00 Current assets Land, buildings, and equipments Total assets Liabilities and stockholder's equity Current liabilities 300,000.00 320,000.00 480,000.00 240.000.00 P1,340,000.000 240,000.00 320,000.00 400,000.00 200,000.00 P 1,160,000.00 P P Bonds payable (8%) Common stock (P5 par) Retained…arrow_forward
- Consider the comparative balance sheet and income statement for Starbucks provided in the shown Figures . Based on these financial statements, determine the following for the year September 30, 2018: Solve, a. Return on assets employed. b. Return on owner’s equity. c. Current ratio.arrow_forward1. Answer the following. • 2023 summary statement of financial position (compare to 2022 year) of Wilcon Depot Inc. • 2023 current assets and non-current assets of Wilcon Depot Inc. (did it increased or decreased)? • 2023 current liabilities and non-current iabilities assets of Wilcon Depot Inc. (did it increased or decreased)? • 2023 summary statements of comprehensive incomes of Wilcon Depot Inc. • 2023 summary statements of cash flow of Wilcon Depot Inc. • 2023 summary of revenue, EBITDA and net income of Wilcon Depot Inc. Refer to: https://investor.wilcon.com.ph/contents/uploads/2024/07/WLCON-2023-Annual-Report-Final.pdfarrow_forwardPrepare the income statement for 2023, beginning with the line "income before income taxes.arrow_forward
- Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning