Coca Cola Financial Ratio Analysis

Abstract

This paper is intended to conduct financial management analysis, evaluation and comment on Coca-Cola Company's financial reports in comparison with its competitor PepsiCo Inc. Its scope is limited to provide financial information to investor and other users by applying theories, concepts, calculation and principles of financial management. The method used for financial management analysis includes vertical analysis of selected income statement items (operating revenue, EBITDA, EBIT, EBT and net income.)by assigning revenue as base and vertical analysis of selected balance sheet accounts (total asset, current asset, plant asset, total liability and stock holders equity, current liability, long term liability and common stock holders equity.)by assigning total asset as a base for asset items (CA and PA)and by assigning total liability and stock holders' equity as a base for liability and equity items(current liability, long term liability and stock holders equity),financial ratio analysis (profitability ratio),beta coefficient, bond rating and WACC.

For this purpose, a three year (2009-20011) Coca-Cola company and PepsiCo Inc's annual financial report are used. These companies are competitive because both have been operating their business in soft drink production for many years. Additionally, certain information out of the company's annual financial reports are taken from yahoo finance and other references that are listed in the reference section.

Vertical analysis

In order to compare Coca-Cola company with pepsico inc a three year, annual relative percentage change, of five selected income statements elements are computed in an excel spreadsheet using the companies 2009-20011 annual financial statement reports.

To perform the relative percentage change of these selected income statement items we have made operating revenue as a base. So all the figures presented below are computed in relative terms. By using this vertical analysis we can compare each selected item of income statement with each other, trough time and across company. For example net income in relative with revenue is calculated by dividing net income to operating revenue, which is 8572/46542=18.42% for 2011.

Vertical, relative percentage change analysis

(Coca-Cola company from 2009-2011)

2009 2010 2011

Amount percentage amount percentage amount percentage

R 30990 100% 35119 100% 46542 100%

EBITDA