• The fourth tab in your Financial Statement Analysis Template must be labeled Historical Ratios
  • Group and Compute the following ratios for each of the three historical years:
  • Liquidity Ratios
  • Current Ratio
  • Quick Ratio
  • Leverage Ratios
  • Debt to Total Assets Ratio
  • Debt Equity Ratio
  • Long-Term Debt to Equity
  • Times Interest Earned Ratio
  • Activity Ratios
  • Inventory Turnover
  • Fixed Assets Turnover
  • Total Assets Turnover
  • Accounts Receivable Turnover
  • Average Collection Period
  • Profitability Ratios
  • Gross Profit Margin
  • Operating Profit Margin
  • Net Profit Margin
  • Return on Total Assets (ROA)
  • Return on Stockholders? Equity (ROE)
  • Earnings Per Share (EPS)
  • Price Earnings Ratio
  • Remember to link information from the financial statements rather than inputting the information into the formulas.

ACCT 370 EXCEL PROJECT: PART II INSTRUCTIONS Ratio Analysis The fourth tab in your Financial Statement Analysis Template must be labeled Historical Ratios o Group and Compute the following ratios for each of the three historical years: Liquidity Ratios Current Ratio Quick Ratio Leverage Ratios Debt to Total Assets Ratio Debt Equity Ratio Long-Term Debt to Equity Times Interest Earned Ratio Activity Ratios Inventory Turnover Fixed Assets Turnover Total Assets Turnover Accounts Receivable Turnover Average Collection Period Profitability Ratios Gross Profit Margin Operating Profit Margin Net Profit Margin Return on Total Assets (ROA) Return on Stockholders' Equity (ROE) Earnings Per Share (EPS) Price Earnings Ratio o Remember to link information from the financial statements rather than inputting the information into the formulas. This assignment is due by 11:59 p.m. (ET) on Monday of Module/Week 2. Company name tinker symbol industy services Major competitors PepsiCo Inc PEP beverage concentrates and syrups and, in some cases, the sale of finished beverages Coca Cola Company, Dr. Pepper Snapple Group, Inc. and Mondelez Internatonal, Inc. ez Internatonal, Inc. PepsiCo Inc. & Subsidiaries Consolidated Income Statements (Amount in millions dollars) Period Ending 31/12/15 Net Revenue Cost Of Goods Gross Profit $ $ $ 63,056 28,384 34,672 Less: Expenses Selling, General and Adminstratve expenses Venezuela impairment charges Amortzaton of intangibe assets Operating Profit Interest expenses Interest Income & Other Income before Income taxes Provision for income taxes Net Income $ $ $ $ $ $ $ $ $ 24,885 1,359 75 8,353 (970) 59 7,442 1,941 5,501 Less: Net Income attributable to noncontrolling interests Net Income Attributable to PepsiCo $ $ 49 5,452 $ $ 3.71 3.67 Net Income Attributable to PepsiCo per common share Basic Diliuted Weighted Average common shares outstanding Basic Diliuted Cash Dividends declared per Common Share 1469 1485 $ 2.7625 diaries tements ollars) 31/12/2014 31/12/2013 $ $ $ 66,683 $ 30,884 $ 35,799 $ 66,415 31,243 35,172 $ $ $ $ $ $ $ $ $ 26,126 92 9,581 (909) 85 8,757 2,199 6,558 $ $ $ $ $ $ $ 25,357 ### 110 9,705 (911) 97 8,891 2,104 6,787 $ $ 45 $ 6,513 $ 47 6,740 $ $ 4.32 $ 4.27 $ 4.37 4.32 1509 1527 1541 1560 2.5325 $ 2.24 $ $ PepsiCo Inc. & Subsidiaries Consolidated Balance Sheet (Amount in millions dollars) Period Ending 31/12/15 ASSETS Current Assets Cash & Cash Equivalents Short Term Investments Accounts & Notes Receivables, net Inventories Prepaid expenses and other currents assets Total Current Assets Property, Plant & Equipment, net Amortizable Intangible Assets, net $ $ $ $ $ $ $ $ 9,096 2,913 6,437 2,720 1,865 23,031 16,317 1,270 Goodwill Other non-amortizable intangible assets Non-Amortizable Intangible Assets Investments in Non-controlled Affiliates Other Assets Total Assets $ $ $ $ $ $ 14,177 11,811 25,988 2,311 750 69,667 $ $ $ $ $ $ $ 4,071 13,507 17,578 29,213 5,887 4,959 57,637 $ $ 41 (186) $ $ $ $ $ $ $ $ 24 4,076 50,472 (13,319) (29,185) 12,068 107 12,030 $ 69,667 LIABILITIES AND EQUITY Current Liabilities Short term obligations Accounts payable and other current liabilities Total Current Liabilities Long term Debt Obligations Other Liabilities Deferred Income taxes Total Liabilities Preferred Stock, no par value Repurchased Preferred stock Shareholders' Equity Common Stock, par value Capital in excess of par value Retained Earnings Accumulated other comprehensive loss Repurchased Common Stock, in excess of par Total PepsiCo's Common Shareholders' Equity Non-controlling Interest Total Equity Total Liabilities and Equity ubsidiaries ce Sheet s dollars) 31/12/2014 31/12/2013 $ $ $ $ $ $ $ $ 6,134 2,592 6,651 3,143 2,143 20,663 17,244 1,449 $ $ $ $ $ $ $ $ 9,375 303 6,954 3,409 2,162 22,203 18,575 1,638 $ $ $ $ $ $ 14,965 12,639 27,604 2,689 860 70,509 $ $ $ $ $ $ 16,613 14,401 31,014 2,623 1,425 77,478 $ $ $ $ $ $ $ 5,076 13,016 18,092 23,821 5,744 5,304 52,961 $ $ $ $ $ $ $ 5,306 12,533 17,839 24,333 4,931 5,986 53,089 41 (181) $ ### (171) $ $ $ $ $ $ $ $ $ $ $ 25 4,115 49,092 (10,669) (24,985) 17,578 110 17,548 $ ### 4,095 46,420 (5,127) (21,004) 24,409 ### 24,389 70,509 $ 77,478 $ $ $ $ $