Financial statement analysis and common stock valuation

Analysis of Profitability Ratios
Quarterly Data

Measures the income of PepsiCo Inc. relative to its revenues and invested capital.

• Profitability Ratios (Summary)
• Gross Profit Margin
• Operating Profit Margin
• Net Profit Margin
• Return on Equity (ROE)
• Return on Assets (ROA)

Balance Sheet: Assets

The assets reports major classes and amounts of resources owned or controlled by PepsiCo Inc..

Balance Sheet: Liabilities and Stockholders’ Equity

The liabilities and stockholders’ equity reports major classes and amounts of external claims on assets and owners’ capital contributions, and other internally generated sources of capital.

Analysis of Revenues

• Revenues as Reported

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin

An approach to decomposing PepsiCo Inc. return on equity, return on assets, and net profit margin ratio as the product of other financial ratios.

• Two-Component Disaggregation of ROE
• Three-Component Disaggregation of ROE
• Five-Component Disaggregation of ROE
• Two-Component Disaggregation of ROA
• Four-Component Disaggregation of ROA
• Disaggregation of Net Profit Margin

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin
Quarterly Data

An approach to decomposing PepsiCo Inc. return on equity, return on assets, and net profit margin ratio as the product of other financial ratios.

• Two-Component Disaggregation of ROE
• Three-Component Disaggregation of ROE
• Two-Component Disaggregation of ROA

Analysis of Short-term (Operating) Activity Ratios
Quarterly Data

Evaluates revenues and output generated by the PepsiCo Inc. assets. Operating performance ratios describe the relationship between the PepsiCo Inc. level of operations and the assets needed to sustain operating activities.

• Short-term Activity Ratios (Summary)
• Inventory Turnover
• Receivables Turnover
• Working Capital Turnover
• Average Inventory Processing Period
• Average Receivable Collection Period
• Operating Cycle

Common-Size Balance Sheet: Assets

Assets components shown as percentage of total assets.

Balance Sheet: Assets
Quarterly Data

The assets reports major classes and amounts of resources owned or controlled by PepsiCo Inc..

Analysis of Long-term (Investment) Activity Ratios

Measures how efficiently PepsiCo Inc. generates revenues from its investments in fixed or total assets.

• Long-term Activity Ratios (Summary)
• Net Fixed Asset Turnover
• Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)
• Total Asset Turnover
• Equity Turnover

Analysis of Reportable Segments

PepsiCo Inc. operates in 6 segments: PepsiCo Foods North America (PFNA); PepsiCo Beverages North America (PBNA); International Beverages Franchise (IB Franchise); Europe, Middle East and Africa (EMEA); Latin America Foods (LatAm Foods); and Asia Pacific Foods.

• Segment Profit Margin
• Segment Capital Expenditures to Depreciation
• Net revenue
• Segment operating profit
• Capital spending
• Depreciation and amortization

Analysis of Solvency Ratios
Quarterly Data

Examines PepsiCo Inc. capital structure in terms of the mix of its financing sources and the ability of the firm to satisfy its longer-term debt and investment obligations.

• Solvency Ratios (Summary)
• Debt to Equity
• Debt to Capital
• Debt to Assets
• Financial Leverage