Financial statement analysis and common stock valuation

Analysis of Short-term (Operating) Activity Ratios

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

• Short-term Activity Ratios (Summary)
• Receivables Turnover
• Payables Turnover
• Working Capital Turnover
• Average Receivable Collection Period
• Average Payables Payment Period

Enterprise Value to FCFF (EV/FCFF)

Free cash flow to the firm is the cash flow available to the Alphabet Inc. suppliers of capital after all operating expenses have been paid and necessary investments in working and fixed capital have been made.

• Free Cash Flow to The Firm (FCFF)
• Interest Paid, Net of Tax
• EV to FCFF Ratio, Current
• EV to FCFF Ratio, Historical

Analysis of Solvency Ratios
Quarterly Data

Examines Alphabet 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 Equity (including Operating Lease Liability)
• Debt to Capital
• Debt to Capital (including Operating Lease Liability)
• Debt to Assets
• Debt to Assets (including Operating Lease Liability)
• Financial Leverage

Common-Size Balance Sheet: Liabilities and Stockholders’ Equity
Quarterly Data

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

Analysis of Debt

• Total Debt (Carrying Amount)
• Total Debt (Fair Value)
• Weighted-average Interest Rate on Debt
• Interest Costs Incurred
• Adjusted Interest Coverage Ratio

Common Stock Valuation Ratios

Relative valuation technique determine the value of Alphabet Inc. 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.

• Current Valuation Ratios
• 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)

Analysis of Geographic Areas

Alphabet Inc. operates in 2 regions: United States and International.

• Area Asset Turnover
• Revenues
• Long-lived assets

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

An approach to decomposing Alphabet 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

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.

Common-Size Balance Sheet: Assets
Quarterly Data

Assets components shown as percentage of total assets.

Analysis of Solvency Ratios

Examines Alphabet 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 Equity (including Operating Lease Liability)
• Debt to Capital
• Debt to Capital (including Operating Lease Liability)
• Debt to Assets
• Debt to Assets (including Operating Lease Liability)
• Financial Leverage
• Interest Coverage
• Fixed Charge Coverage

Income Statement

The income statement (statement of earnings) reports on the performance of Alphabet Inc., the result of its operating activities.