Preview

Pepsi Rate

Good Essays
Open Document
Open Document
1061 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Pepsi Rate
PepsiCo’s financial statements are presented in Appendix A. Financial statements of The Coca-Cola Company are presented in Appendix B.
This is from the appendixes in the 7th edition of financial accounting by Weygandt, kimmel, and kieso. Instructions;
(a) Based on the information contained in these financial statements, determine each of the following for each company. Please show all numerical equations including numerator and denominator, not just a final number. Present your work in a comparative format using a table as illustrated:
1) Gross profit for 2008 PepsiCo Coca-Cola and Gross profit rate for 2008. 2) Percent change in operating income from 2007 to 2008.
3) Accounts receivable turnover for 2008.
4) Days sales in receivable for 2008.
5) Inventory turnover for 2008.
6) Days inventory on hand for 2008.
7) Increase (decrease) in cash and cash equivalents from 2007 to 2008.
8) Asset turnover ratio for 2008.
9) Working capital at the end of 2008.
10) Current ratio at the end of 2008.
11) Debt (excluding “deferred income taxes”) to total assets at the end of 2008.
12) Book value per share at the end of 2008.
(Hint: Use the value reported for “common shareholders’ equity” as the numerator for PepsiCo.)
13) Compare the market value per share for each company to the book value per share at the end of 2008. Assume that the market value of Coca-Cola’s stock was $45.27
14) Why are book value and market value per share different?
15) Return on common stockholders’ equity at the end of 2008.

Answer: | PepsiCo | Coca-Cola | | 2008 | 2008 | 1) Gross profit rate for 2008. (Gross Profit / Sales) | 52.9% | 64.4% | 2) Percent change in operating income from 2007 to 2008. | -3.10% | 16.46% | 3) Accounts receivable turnover for 2008. (sales / Average accounts receivable) | 9.54 | 9.97 | 4) Days sales in receivable for 2008. (365 / Accounts receivable turnover) | 38 | 37 | 5) Inventory turnover for 2008. (Cost of goods

You May Also Find These Documents Helpful

  • Powerful Essays

    Case1

    • 6497 Words
    • 26 Pages

    Refer to the Dow Chemical financial statements for 2008 in answering the following: 1. Who are Dow’s external auditors? Describe the two opinion letters that Dow received for 2008. In your own words, explain what these opinions mean. Why are the opinions dated several weeks after Dow’s year end? 2. Use a spreadsheet to construct common-size income statements for 2008 and 2007. (Note: common-size income statements are constructed by dividing each income statement item by net sales). a. Was the company profitable during 2008? During 2007? What does the term “profitable” mean? b. Compute the percentage change in net sales and in net income from 2007 to 2008. c. What are Dow’s major categories of expenses? Do you detect any significant changes in the structure of costs in 2008 compared to 2007? d. Dow shows separate lines on the income statement for goodwill impairment losses, restructuring charges, purchased in-process research and development charges, acquisition-related expenses and asbestos-related credits. Why do you think the company chose not to just include all of the amounts within the line item for “Selling, general and administrative expenses.” e. How would the percentages you computed in part 2b change if the items in part 2d were excluded in measuring net income. (Caution: the items listed in part 2d are shown before tax, while net income is shown after tax. Be sure to adjust your answer accordingly, using the statutory tax rate of 35%.) f. In a single sentence, explain why Dow’s profitability changed from 2007 to 2008. 3. Refer to the statement of cash flows. a. Compare…

    • 6497 Words
    • 26 Pages
    Powerful Essays
  • Satisfactory Essays

    Use the financial statements from the most recent year to fill in the table below.…

    • 572 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    • Examine PepsiCo, Inc.’s Consolidated Balance Sheet on p. A6 in Appendix A of Financial Accounting, especially its Current Assets, Current Liabilities, and Total Assets for years 2005 and 2004.…

    • 746 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Weygandt, J. J., Kieso, D. E., &Kell, W. G. (1996). Accounting Principles (4th ed.). Wiley & Sons, Inc.…

    • 1657 Words
    • 7 Pages
    Powerful Essays
  • Better Essays

    Xacc280 Financial Analysis

    • 1828 Words
    • 8 Pages

    The Coca-Cola company has been in business since its inventor began selling it in drug stores in 1886 (The Coca-Cola Company, 2009). Pepsi-Cola was invented a short time later in 1898, but at the time it was called “Brad’s drink.” It was later renamed Pepsi-Cola in 1902 (Butler, 2006). Since those early days when the sodas were invented, Coca-Cola and Pepsi have been in competition with each other for the domination of the world’s soda market. Over the course of more than a century, sales have continued to rise for both companies, and they both consistently earn a profit. Both companies have expanded into new product markets in more recent years. They have chosen to invest their earnings in new ventures like bottled water, snack foods, and iced tea, and they each strive to continue increasing their profits in many ways. In order to maintain this continued growth in the coming years, these companies are both in need of investors who will fund their efforts.…

    • 1828 Words
    • 8 Pages
    Better Essays
  • Satisfactory Essays

    ACC/291 March 25,2012 Liquidity Ratios Current Ratio: Current Assets/Current Liabilities 2005 $14,555,092/ $6,974,752= 2.09:1 2004 $14,643,456/ $6,029,696=2.43:1 Acid Test Ratio: Cash+ Short-Term Investments + Receivables (Net)/ Current Liabilities 2005 $305,563 + $283,583 +$6,133,663/ $6,974,752= .96:1 2004 $357,216 + $133,504 + $5,775,104/ $6,029,696=1.04:1 Receivables Turnover: Net Credit Sales/ Average Net Receivables 2005 $50,823,685/ ($6,133,663 + 5,775,104/2) $50,823,685/ $5,954,384= 8.54 times 2004 $46,044,288/($5,775,104+6,569,344/2) $46,044,288/ $6,172,224=7,46 times Inventory Turnover: Cost of Goods Sold/ Average Inventory 2005 $42,037,624/ ($7,850,970+$7,854,112/2) $42,037,624/$7,852,541=5.35 times 2004 $37,480,050/ ($7,854,112+8,074,880/2) $37,480,050/ $7,964,496=4.71 times Profitability Ratios Current Assets 2004 2005…

    • 1563 Words
    • 7 Pages
    Satisfactory Essays
  • Better Essays

    Keeping good records is a key in any good business and it helps companies find key areas where they feel they can improve. Coke and Pepsi are two large named soda distributers that have been along for many years and are constantly being compared. Before obtaining both companies financial statements, I was kind of clueless in who was more financially set but knew both were respectable companies. In this essay, I am going to compare the two companies giving you a complete analysis of each regarding the health and future of the company, along with possible improvements that could be made to improve the company. I am going to compare these companies by taking the financial record sheets and using them to do different ratios and analysis that will help support my decisions. At the end of the essay I feel you will understand why I feel the way I do and why I feel which company will have the most long term success.…

    • 1340 Words
    • 6 Pages
    Better Essays
  • Satisfactory Essays

    Review the annual reports for PepsiCo, Inc. and The Coca-Cola Company in Appendixes A B of Financial Accounting . Selecteither PepsiCo, Inc. or The Coca-Cola Company. In your estimation, the company you chose may be financially healthier or weaker.…

    • 452 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Homework 2

    • 811 Words
    • 4 Pages

    4. Consider the equity portion of the TTT balance sheet for December 31, 2012 and 2013…

    • 811 Words
    • 4 Pages
    Satisfactory Essays
  • Powerful Essays

    Week 6 Problem Set

    • 655 Words
    • 3 Pages

    References: Kieso, D. E., Weygandt, J. J., & Warfield, T. D. (2010). Intermediate accounting (13th ed.)…

    • 655 Words
    • 3 Pages
    Powerful Essays
  • Satisfactory Essays

    Xacc Checkpoint Wk 7

    • 278 Words
    • 2 Pages

    · Examine PepsiCo, Inc.’s Consolidated Balance Sheet on p. A6 in Appendix A of Financial Accounting, especially its Current Assets, Current Liabilities, and Total Assets for years 2005 and 2004.…

    • 278 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Hsbr Ibm Case

    • 1876 Words
    • 8 Pages

    In the seven years (since 1994), that Lou Gerstner has reigned over IBM, the company’s earnings per share have increased an average of 27% per year. This remarkable increase in earnings, has not gone unnoticed by the securities markets. Indeed, the company’s market value has grown from less than $30 billion to over $200 billion during this period. Use the following financial statement data to: 1. Decompose IBM’s ROE and discuss the factors (and trends) that contribute to Big Blue’s profitability 2. Evaluate IBM’s Revenue growth, Receivables, and Gross margins and over the period (be sure to control for seasonality in your evaluation) 3. Evaluate IBM’s Earnings per Share (basic), and Identify the factors most responsible for the increase in IBM’s earnings Write your answers in standard English. Be specific in your references, provide details of your computations, and be thorough in your explanations – I cannot read your mind.…

    • 1876 Words
    • 8 Pages
    Good Essays
  • Powerful Essays

    Final Financial Analysis

    • 1870 Words
    • 8 Pages

    Financial Analysis is very important to the inner workings of a business. Keep track of financial statements, taxes, audits, and various other areas of financials will show how well a company has done, is doing, and how well it will do in the future. Seeing how well a company is doing into the future is important so they can see any mistakes and try to fix them before they become an issue and hinder the growth of the company. In this essay I will compare financial statements in two companies, PepsiCo. and Coca Cola Company. I will describe what vertical and horizontal analysis is then I will go over the vertical analysis of both companies, comparing one to the other. I will go over the horizontal analysis of both companies, comparing them as well. I will describe ratio analysis and I will show the ratio analysis of both companies, including the testing of a liquidity ration, a solvency ratio, and a profitability ratio. I will explain in my own opinion which company is more financial stable and why, using comparisons of the data from the data stated. I will finally include three recommendations to improve each company’s financial health for the future.…

    • 1870 Words
    • 8 Pages
    Powerful Essays
  • Better Essays

    Schroeder, R. G., Clark, M. W., & Cathey, J. M. (2011). Financial accounting theory and analysis (Tenth ed.). Hoboken, NJ: John Wiley & Sons, Inc.…

    • 1115 Words
    • 5 Pages
    Better Essays
  • Satisfactory Essays

    Capital Expenditures

    • 411 Words
    • 2 Pages

    References: * Weygandt, J.J., Kimmel, P.D., & Kieso, D.E. (2010). Financial accounting (7th ed.). Hoboken, NJ: John Wiley & Sons.…

    • 411 Words
    • 2 Pages
    Satisfactory Essays