Financial statement analysis and common stock valuation

Common-Size Balance Sheet: Assets

Assets components shown as percentage of total assets.

Enterprise Value (EV)

Enterprise value is total company value (the market value of common equity, debt, and preferred equity) minus the value of cash and short-term investments.

• Current EV
• Historical EV

Common Stock Valuation Ratios
Quarterly Data

Relative valuation technique determine the value of Procter & Gamble Co. by comparing it to similar entities (like industry or sector) on the basis of several relative ratios that compare its stock price to relevant variables that affect the stock value, such as earnings, book value, and sales.

• Historical Valuation Ratios (Summary)
• Price to Earnings (P/E)
• Price to Operating Profit (P/OP)
• Price to Sales (P/S)
• Price to Book Value (P/BV)

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

An approach to decomposing Procter & Gamble Co. 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

Capital Asset Pricing Model (CAPM)

CAPM is a theory concentrated with deriving the expected rates of return on risky assets based on the assets’ systematic risk levels. Systematic risk is the variability of returns that is due to macroeconomic factors that affect all risky assets. It cannot be eliminated by diversification.

• Rates of Return
• Variance and Covariance
• Systematic Risk (β) Estimation
• Expected Rate of Return

Common-Size Balance Sheet: Liabilities and Stockholders’ Equity

Liabilities and stockholders’ equity components shown as percentage of total liabilities and stockholders’ equity.

Balance Sheet: Liabilities and Stockholders’ Equity
Quarterly Data

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 Short-term (Operating) Activity Ratios

Evaluates revenues and output generated by the Procter & Gamble Co. assets. Operating performance ratios describe the relationship between the Procter & Gamble Co. level of operations and the assets needed to sustain operating activities.

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

Present Value of Free Cash Flow to Equity (FCFE)

The FCFE valuation approach estimates the value of equity as the present value of future FCFE discounted at the required rate of return on equity.

• Intrinsic Stock Value (Valuation Summary)
• Required Rate of Return (r)
• FCFE Growth Rate (g)

Analysis of Geographic Areas

Procter & Gamble Co. operates in 2 regions: United States and International.

• Area Asset Turnover
• Net sales
• Long-lived assets