Premium Essay

Pepsi Financial Analysis

In:

Submitted By rjtisone
Words 1202
Pages 5
TABLE OF CONTENTS

Income Statement
Income Statement Analysis
Balance Sheet
Statement of Cash Flows
Cash Flow Analysis
Financial Ratios

Income statement

Income Statement Common size

PepsiCo Inc., Common-Size Consolidated Income Statement | | | | | | | Dec 31, 2011 | Dec 25, 2010 | Dec 26,2009 | Gross profit | 52.49% | 54.05% | 53.51% | Operating profit margin | 13.28% | 14.23% | 18.69% | Net profit margin | 9.69% | 10.93% | 13.75% |

Net Sale Change 2011-2010 2010-2009 14.98% 33.79%

S & A Margin 2011 2010 2009 37.81% 39.44% 34.76%

ANAYLIS
Pepsi Co Gross Profit Margin increased from 2009 to 2010 but had deterioration in 2011.
Pepsi Co had deteriorating numbers from 2009 to 2011 in operating profit margin.
Pepsi Co had deterioration from 2009 to 20011 in Net profit margin.
Pepsi Co Net sale change is from 2011-2010 is 14.98% and from 2010-2009 33.79%.

-CFO is positive all three years. CFO also increased in years 2009, 2010 and 2011.
-Pepsi Co is profitable each year. Pepsi Co net income increased in years 209, 2010 and 2011.
-Account receivables decreased in 2009, 2010 and 2011.
-Net earnings increased all three years from 2009-2011
-Inventories increased from 2009 to 2010 but decreased from 2010 to 2011
-NOTE In 2010 and in 2009 Pepsi Co invested money into pension and retirement funds

-CFI activities were negative in all 3 years.
-Pepsi Co is investing in property, plant and equipment all three years at a decreasing rate.
-NOTE In 2010 Pepsi Co purchased and acquired PBG and PAS which they now own 100%

-FCF was positive all three years.

-CFF

Times Interest Earned Income before Tax + Interest Expense/ Interest Expense
2011 Times Interest Earned = 8,834 + 856/856= 11.320
2010 Times Interest Earned = 8,232 + 903/903= 10.1163
2009 Times

Similar Documents

Premium Essay

Coke or Pepsi, Financial Analysis

...Coke or Pepsi, what would you choose? xxxxxx XACC/280 xxxxxx teacher name Everyone in the civilized world recognizes two companies as kings of the soda pop, Pepsi-Cola and Coca-Cola. These two companies have battled for over one hundred years to be top dog in the beverage business. In 2005, Coca-Cola (Coke) led the race by just over 7% in net income over Pepsi-Co (Pepsi). This essay will compare these two beverage giants side by side and analyze the financial statements of both as well as making suggestions about ways the each company may be able to improve their earnings. Pepsi-Cola was born in North Carolina, in 1898, as the invention of a pharmacist named Caleb Bradham. He put together various combinations of juices, syrups, and spices to try to come up with a new drink to serve to his customers at the soda fountain in his pharmacy. His drink, originally called “Brad’s drink” was soon renamed Pepsi-Cola (using a combination of the names of two of the ingredients Pepsin and Kola nuts). The drink was incredibly successful and soon took off beyond Bradham’s wildest expectations. In 1902, the Pepsi-Cola company was officially formed and the brand was patented. The beverage quickly moved from a soda fountain product to a bottled beverage (PepsiCo, Inc, 2010). The second half of this duo is Coca-Cola. Coca-Cola was invented in 1886, twelve years before Pepsi. It was created by Doctor John Pemberton, also a pharmacist...

Words: 2602 - Pages: 11

Premium Essay

Financial Analysis of Pepsi and Coke

...Pepsi & Coke Analysis Financial Analysis of Pepsi and Coke Abstract In this report the analysis for the year 2005 and 2004 of financial position of Pepsi Inc and Coca Cola have been stated below. Techniques which are used for the analysis are ratios, horizontal and vertical analysis. How the company can improve its financial position and better its performance is given in this analysis. .Analysis of PEPSI |Ratio Analysis |27-Jun |  |26-Jun |  | |Current Ratio |1.11 |  |1.28 |x | |Quick Ratio |0.87 |  |0.95 |x | |Net profit Margin |12.52% |  |14.39% |  | |Return on Assets |12.85% |  |15.05% |  | |Account Receivable Turnover |9.99 |  |9.76 |x | |Inventory turnover |8.37 |  |8.22 |x | |Total assets turnover |1.03 |  |1.05 |x | |Interest times earned ratio |23.13 |  |31.49 |x | |Debt to Equity ratio |1.23 |  |1.07 |x | |Debt to total assets ratio ...

Words: 2124 - Pages: 9

Premium Essay

Coke Versus Pepsi Financial Analysis

...ROE of 35% is higher than Coke's ROE of 28%. The number of shares outstanding for coke is higher than pepsi. The asset turnover for Pepsi is roughly 1.6 times that of Coke. The asset turnover of Coke is lower than pepsi resulting in a lower ROE. Coke has to increase their sales or sell assets. The impact of this is reflecting in the higher ROE. The impact of this also is reflecting in the higher ROE. The operating costs are also high in the case of Coke. In regard to the valuations of Coke and Pepsi, Pepsi is undervalued as compared to Coke as the P/E ratio is 15.6; if we consider Coke P/E ratio of 18.4 the expected market price of Pepsi should be ~$70. The acquisition of CCE requires Coke to assume more debt resulting in higher leverage for Coke and higher operating expenses from a bottling company will result in a lower EPS. It will increase interest expense and affect the ROE adversely. Estimating the rate of interest using the interest expense paid in 2009's for the long term debt on the books, the ROE is expected to reduce to 25%. The acquisition of the bottling company will require that Coke shows the consolidated figures of the bottling company in its financials. The assets of Coke will increase however, there is not enough information for us to evaluate. We believe that after the acquisition of the bottling company the comparison between Coke and Pepsi will be worse. -----------------------...

Words: 300 - Pages: 2

Premium Essay

Pepsi and Coca Cola Financial Statement Analysis

...Introduction The purpose of this financial analysis paper will evaluate the results of PepsiCo, Inc. and The Coca-Cola Company. The paper will access the balance sheets of the two from 2004 and 2005 through horizontal and vertical analysis. The paper will also address recommendations of how to improve the financial status of both companies. Vertical analysis for PepsiCo, Inc. 2005 2004 |Total Assets | $ 31,272 | | $ 27,987 | | | |Amount |Percent |Amount |Percent | |Assets | | | | | | Current Assets | | | | | |Cash and cash equivalents | $ 1,716 |5.5% | $ 1,280 |4.6% | |Short-term investments | 3,166 |10.1% | 2,165 |7.7% | | | 4,882 |15.6% | 3,445 |12.3% | |Accounts and...

Words: 1241 - Pages: 5

Premium Essay

What Is Financial Accounting

...What is financial accounting? Financial accounting is regarded as a professional in modern society. Most of the firms, especially the large ones, need it and have a particular department or team called accounting. In universities, financial accounting becomes a compulsory subject which BBA students must study. It is so well known that almost all people have heard of it. What actually is financial accounting? More specifically, what the main objectives or roles financial accounting has so that firms need it at a critical manner? Generally speaking, the purpose of accounting is to give relevant data or information that is necessary to make sound decision for the firms. And the main objective of financial accounting is to prepare financial statements such as statement of financial position, income statement, statement of owner’s equity and statement of cash flow. The preparation must be guided by generally accepted accounting principles, “GAAP” in short, of the physical location. The statements are then used to tell the external users the performance of the firm (Eisen, 2003). And the primary need for financial accounting, or sometimes called financial accountancy, is to minimize the principal-agent problems in organizations. This is to be done by evaluating and monitoring agents’ (manager) production and presenting the performance to people who interest in. In addition, financial accounting serves a lot of important objectives. It aims to understand the operation of the business...

Words: 1054 - Pages: 5

Premium Essay

Financial Analysis Tools

...Financial Analysis Tools Nicola Maclin American Military University Managers should have the ability to assess performance of decisions they have made or intend to make, through structured and robust financial analysis. Managers need tools to forecast or predict as they struggle to make decisions on a daily basis to execute business strategy for the company. Financial analysis tools can drive projections and predictions in many areas of the business, from planning for production and distribution to decisions on a product or service. Managers can use these tools to both assess and improve business performance. Performance evaluation is an important component of managing a business. Managers need feedback to evaluate how well they have accomplished business strategy and managed key business process. Managers need to be able to link strategy with profitability. Financial analysis tools can help provide that much needed feedback. Financial data can be used to compute ratios analysis. These financial ratios gives managers the first look at the company’s vital signs and is used to assess a complete financial health and identify operational problems. Ratio analysis allows management to quickly and efficiently address concerns like: return on capital investment and the company’s profit margin. Ratio analysis can be an effective and useful management tool if ratios are calculated on items that are meaningful and where practical steps can be taken to make improvements in...

Words: 415 - Pages: 2

Premium Essay

1111

...Business Analysis and Valuation Report Prepared By: Version # Updated on ------------------------------------------------- Acknowledgments ------------------------------------------------- If applicable, include acknowledgement to contributing individuals: ------------------------------------------------- ------------------------------------------------- Analyst’s Name | Number | E-Mail Address | | | | Document Name | | Date Created | | Milestone 1 date submitted | | Milestone 2 date submitted | | Milestone 3 date submitted | | Finalization date | | | | | | | | REPORT VERSION RECORD The Business Analysis and Valuation Report is a managed document with tracking of versions, changes, and release dates for each of the three milestones. Version Name | Version Number | Date | Author(s) Name(s) | Change Description | | | | | Document created | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Milestone versions of the report are issued including the complete document with the sections completed to date to reflect the work to date by the analyst team. The milestone versions of the document are authorized for release only after the analyst’s signature has been obtained. Milestone 1 PREPARED: DATE:___/___/___ (for acceptance) (, signature) POSITION: ___ Milestone 2 PREPARED: DATE:___/___/___ ...

Words: 2600 - Pages: 11

Premium Essay

Week Two Acc 300 Dq

...What types of financial ratios are used to analyze financial performance? Financial ratios are categorized corresponding to the data they provide. The following terms are types of ratios used: 1. Liquidity ratios 2. Asset turnover ratios 3. Financial leverage ratios 4. Profitability ratios 5. Dividend policy ratios Are some more important than others? Why? Financial ratios give insight into an organization’s way of management and its financial state. Most ratios defined above can be evaluated from data made available by compiled financial statements. Which ratios are important to creditors, investors, and managers? Why? The importance of these rations allows a firm to analyze the market place and to measure the firm's financial data against those of other companies to steer away from unwanted financial problems- shutting down of operations. What is the purpose of financial statement analysis? According to (Robinson, Henry and Pirie, 2012), the purpose of a financial statement analysis is comprised of: • Evaluation of equity/debt investment/credit rating • Transfer of information • To use an analysis to develop a given financial statement inquiry. Robinson, T. A., Henry, E., & Pirie, W. L. (2012). International Financial Statement Analysis (2nd ed.). Hoboken, NJ: John Wiley and Sons, Inc.. What are some tools we might use to analyze financial performance? Readyratios.com (2014) informs that analysis of financial performance can be: • SWOT (strength...

Words: 332 - Pages: 2

Premium Essay

Financial Reporting

...Week 1 Financial reporting and its analysis has an important role in the information intermediaries (auditors, press, financial analysts) and financial intermediaries (banks, insurance companies, mutual funds) functioning. Information intermediaries and financial intermediaries use the information from the financial reports to investigate the investment opportunities and find the “good” ones (Palepu, Healy & Peek, 2013). The “lemons” problem explains the problem in identifying the “good” and “bad” ideas being offered in the market (Holod & Peek, n.d.). The “bad” ideas are valued by investors at an average level, as they know that in the market there are both types of ideas. This approach, unfortunately, leads to less attractive conditions of financing to the owners of “good” ideas; the proportion of “bad” ideas increases. The identification of “good” investments can be performed by following the four steps (Palepu, Healy & Peek, 2013): * Business strategy analysis * Accounting analysis * Financial analysis * Prospective analysis All the above analysis get the information from the financial statements, publically data available, from business application context that consists of credit analysis, debt analysis, general business analysis and other details on corporate business (Palepu, Healy & Peek, 2013). The business strategy analysis is a tool to form the performance expectations using industry data and competitive strategy data. Accounting analysis assess...

Words: 745 - Pages: 3

Premium Essay

Introduction to Financial Ratios and Financial Statement Analysis

...9-193-029 REV: SEPTEMBER 13, 2004 WILLIAM BRUNS Introduction to Financial Ratios and Financial Statement Analysis There is almost always a reason why someone picks up an organization’s financial statements and begins to analyze them. Lenders or creditors may be interested in determining whether they will be repaid money they have lent or may lend to the organization. Investors may be interested in comparing a potential investment in one organization with that of another. Employees may want to compare the current performance or financial status of their employer with earlier periods. Regulatory agencies often need to assess organizational or industry financial health and performance. Financial analysis is always based on a set of questions, and the specific questions requiring answers depend on who the financial statement user is and the reasons for his or her analysis. Financial analyses based on accounting information consistently involve comparisons. Amounts or ratios may be compared with industry norms, the same measurement in a prior period, the same measurement in a competitor’s organization, or with planned and budgeted amounts previously established. Figuring out which comparisons will best answer the questions motivating the analysis is one of the necessary steps in making the best use of accounting information. Financial ratios can help describe the financial condition of an organization, the efficiency of its activities, its comparable profitability...

Words: 951 - Pages: 4

Premium Essay

Term Paper

...Introduction: Financial Statement Analysis is used by interested parties such as inventors, creditors, and management to evaluate the past, current and projected condition and performance of the firm. Its analysis helps user make better desiccations. Ration analysis is the most common form of financial analysis. It provides relative measures of the firm’s conditions and performance. Horizontal analysis and Vertical analysis are also popular forms. Horizontal analysis is used to evaluate the trend in the accounts over the years, while vertical analysis, also called a common size Financial Statement discloses the internal structure of the firm. It indicates the existing relationship between sales and each income statement account. It shows the mix of assets debt that produces income and the mix of the sources of capital, where by current or long-term debt of by equity funding. Financial Statement Analysis prepared for the internal auditors, Many different financial measures are used to analyze financial statements and rank the performance of competing investment opportunities, including growth in sales, return to stockholders, profit margin, and return on equity. These are just four possible measures considered and evaluated by investors and creditors. Financial statements presented in various formats to help facilitate analysis. A classified set of financial statements groups items with similar characteristics together. Groupings include categories such as current assets; property...

Words: 2258 - Pages: 10

Premium Essay

Polymold

... Spring 2014 T TH Financial Analysis and Management Dr. Kamal M. Haddad COURSE OBJECTIVES Fin 423 is designed to develop critical thinking at the individual level, and problem solving competencies at both the individual and group levels. Teamwork and group problem solving are stressed. The course provides a thorough overview of financial analysis, including relevant modern theory and practical applications. Topics include financial statement analysis, financial planning, principles of valuation, capital budgeting, capital structure, and issues in financial policy. The course gives students opportunities to apply financial theory to analyze real life situations in an uncertain environment with an incomplete data set. It is integrative in nature, with special attention to the integration of theory and managerial judgment in the process of making financial decisions. BSBA Goals BSBA students will graduate being Effective Communicators, Critical Thinkers, Able to Analyze Ethical Problems, Global in their perspective, and Knowledgeable about the essentials of business. This class contributes to those goals through its student learning outcomes. LEARNING OBJECTIVES * Use Financial Statements to evaluate firm performance. * Project Financial Statements (B/S, I/S, budgets, etc.). * Use Financial Statements to obtain Cash Flows for the...

Words: 5498 - Pages: 22

Premium Essay

Financial Analysis

...2 Graduate Thesis By Teia R. Merring Copenhagen Business School Strategic and financial analysis and valuation of B&O 0 1 Executive Summary................................................................................2 Introduction............................................................................................6 1.1Motivation.................................................................................................................. 6 1.2Problem Specification................................................................................................ 8 1.3Problem Identification................................................................................................ 8 1.4Problem Handling .................................................................................................... 10 1.5Structure and Methodology...................................................................................... 12 1.5.1Introduction and Presentation........................................................................... 12 1.5.2Strategic Analysis............................................................................................. 12 1.5.3Financial Statement Analysis ........................................................................... 13 1.5.4Prognoses and Budgets..................................................................................... 14 1.5.5Valuation.......................................

Words: 60014 - Pages: 241

Premium Essay

Merck's Business Environment

...University of Phoenix November 7, 2011 Kevin Wilhelmsen Merck’s Business Environment There are many factors a business, such as Merck, must have in order to be successful, for example strong financial statements, leading technology, and globalization. With the help of income statements, balance sheets, and cash flow statements, a financial analysis can be applied in a wide variety of situations to give business managers the information they need to make critical decisions (Financial Analysis, 2010). They also provide information in regards to the financial health of a company. Pharmaceutical companies are using technology to conduct clinical trials, which has proven to be beneficial to research, development, and the introduction of new products. Globalization is also important for Merck when it comes to product distribution. Outsourcing was been adopted by Merck in order to produce equal quality vaccines and medications at a cheaper cost. Review of Finances Analyzing a company’s income statement, balance sheet, and cash flow is a prime way in determining their success. A comparison can be made between the competition in the industry and a leader can be established. An analysis can also show which company is spending more on research and development and in turn, producing better products. After review of the income statements, Merck’s worldwide sales were $12 billion for the third quarter this year, an increase of...

Words: 2950 - Pages: 12

Premium Essay

Acct 370 Excel Project

...and Trend Analysis on WALMART Stores Inc. The tenth tab in your Financial Statement Analysis Template must be labeled Common Sized Balance SheetsThe eleventh tab in your Financial Statement Analysis Template must be labeled Common Sized Income StatementsThe twelfth tab in your Financial Statement Analysis Template must be labeled Horizontal Analysis of Balance SheetsThe thirteenth tab in your Financial Statement Analysis Template must be labeled Horizontal Analysis of Income StatementsInclude the latest three years for the common sized (vertical analysis) and horizontal analysis in Tabs 10–13. *PLEASE WORK OFF OF ATTACHED EXCEL SPREADSHEET. When you open the document, you will see that there are already 9 tabs. Follow the instructions above. You will need to add 4 more tabs labeled appropriately with the above titles (see instructions). Please save the work and send it back to me. PART 2: - Use WORD to complete this part COMPARITIVE ANALYSIS REPORT. - WALMART Examine common sized financial statements and ratios for the company you selected for the Excel project and two of its competitors. Write a 1000-word report in current APA format. Include the following in your report: Compare and contrast the selected company, its competitors, and industry averages Identify the selected company’s strengths and weaknesses and examine the implications for financial statement analysis and future projections. Compute ROA and ROCE and examine the selected company’s financial leverage...

Words: 280 - Pages: 2