Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 EBITDA

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Theory And Its Application

Authors: Hanson Arthur Warren, Arthur W. Hanson

1st Edition

ISBN: 1406753351, 978-1406753356

More Books

Students also viewed these Accounting questions

Question

10. Identify the atonement with the father in Pinocchio.

Answered: 1 week ago

Question

Define Administration and Management

Answered: 1 week ago

Question

Define organisational structure

Answered: 1 week ago

Question

Define line and staff authority

Answered: 1 week ago

Question

Define the process of communication

Answered: 1 week ago

Question

Explain the importance of effective communication

Answered: 1 week ago