Question
The purpose of this assignment is to prepare a vertical and horizontal common-size analysis. Financial statement analysis requires the analyst to utilize calculation tools, such
The purpose of this assignment is to prepare a vertical and horizontal common-size analysis. Financial statement analysis requires the analyst to utilize calculation tools, such as horizontal, vertical, and ratio analysis. Interpretation of the ratio analysis allows the analyzer to observe changes in revenue over time. For your assignment, locate and review the last 4 years of the annual report of Coca-Cola Financial Statement Analysis Report. This document is located on the company's website under Investor Relations. Prepare a vertical and horizontal analysis in the Balance Sheet and Income Statement tabs of the "Financial Statement Report Excel Spreadsheet" (FSAR Excel Spreadsheet) provided. The spreadsheet will serve as a guideline for completing the assignment, the actual sections or order of reporting from the company's annual report may vary. Complete only the applicable sections based on the information provided in the company's annual report. Complete the horizontal analysis column of the prior 3 years Complete the vertical analysis column for the prior 3 years Address the following questions in the comments section of both the Balance Sheet and Income Statement tabs: Identify which accounts had a large magnitude of change of 10% or more. Identify which accounts changed for the period and explain how this affected the financial analysis calculation. Explain why the account changed during the period, what business decisions may have caused the change, and how these changes impacted company performance.
Income StatementCompany Horizontal AnalysisComments Income StatementCompany Vertical AnalysisComments YearYearYearYearYearYearYear YearYearYearYearYearYear Revenue Revenue Total Revenue / Total Sales Total Revenue / Total Sales Cost of Revenue / Cost of Goods Sold Cost of Revenue / Cost of Goods Sold Gross Profit0.00.00.00.0 Gross Profit0.00.00.0 Selling, General, and Administrative Expenses Selling, General, and Administrative Expenses Research & Development Expenses Research & Development Expenses Depreciation and Amortization Expenses Depreciation and Amortization Expenses Other Operating Expense (Income) Other Operating Expense (Income) Total Operating Expenses0.00.00.00.0 Total Operating Expenses0.00.00.0 Operating Income or Loss0.00.00.00.0 Operating Income or Loss0.00.00.0 Interest Expense (Income) Interest Expense (Income) Restructuring Expenses Restructuring Expenses Acquisition-Related Expenses Acquisition-Related Expenses Other Losses/Impairments (Gains) Other Losses/Impairments (Gains) Earnings Before Taxes0.00.00.00.0 Earnings Before Taxes0.00.00.0 Income Tax Expense Income Tax Expense Net Income From Continuing Ops0.00.00.00.0 Net Income From Continuing Ops0.00.00.0 After-Tax Adjustments After-Tax Adjustments Net Income0.00.00.00.0 Net Income0.00.00.0 Basic Weighted Average Shares Outstanding Basic Weighted Average Shares Outstanding Diluted Weighted Average Shares Outstanding Diluted Weighted Average Shares Outstanding Basic EPS Basic EPS Diluted EPS Diluted EPS EBIT EBIT EBITDA EBITDAStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started