Financial statement analysis and common stock valuation

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

Analysis of Debt

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

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 Long-term (Investment) Activity Ratios

Measures how efficiently Alphabet 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

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

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
• Five-Component Disaggregation of ROE
• Two-Component Disaggregation of ROA
• Four-Component Disaggregation of ROA
• Disaggregation of Net Profit Margin

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

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

Price to FCFE (P/FCFE)

Free cash flow to equity is the cash flow available to Alphabet Inc. equity holders after all operating expenses, interest, and principal payments have been paid and necessary investments in working and fixed capital have been made.

• Free Cash Flow to Equity (FCFE)
• P to FCFE Ratio, Current
• P to FCFE Ratio, Historical

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 Geographic Areas

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

• Area Asset Turnover
• Revenues
• Long-lived assets