Financial statement analysis and common stock valuation

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

Common-Size Income Statement

Income statement components (revenues and expenses) shown as percentage of total sales.

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

Analysis of Liquidity Ratios

Measures the adequacy of Alphabet Inc. cash resources to meet its near-term cash obligations.

• Liquidity Ratios (Summary)
• Current Ratio
• Quick Ratio
• Cash Ratio

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: Assets
Quarterly Data

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

Common-Size Balance Sheet: Liabilities and Stockholders’ Equity

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

Cash Flow Statement
Quarterly Data

The cash flow statement provides information about Alphabet Inc. cash receipts and cash payments during an accounting period, showing how these cash flows link the ending cash balance to the beginning balance shown on Alphabet Inc. balance sheet.

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

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

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

• Long-term Activity Ratios (Summary)
• Net Fixed Asset Turnover
• Total Asset Turnover
• Equity Turnover

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