Financial statement analysis and common stock valuation

Analysis of Geographic Areas

Comcast Corp. operates in 2 regions: United States and Other.

• Area Asset Turnover
• Revenue
• Property and equipment, net

Analysis of Long-term (Investment) Activity Ratios

Measures how efficiently Comcast Corp. 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

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)

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

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.

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

Analysis of Liquidity Ratios
Quarterly Data

Measures the adequacy of a Comcast Corp. cash resources to meet its near-term cash obligations.

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

Enterprise Value to FCFF (EV/FCFF)

Free cash flow to the firm is the cash flow available to the Comcast Corp. 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 Comcast Corp. 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
• Interest Coverage

Common-Size Balance Sheet: Liabilities and Stockholders’ Equity

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

Balance Sheet: Assets
Quarterly Data

The assets reports major classes and amounts of resources owned or controlled by Comcast Corp..

Price to FCFE (P/FCFE)

Free cash flow to equity is the cash flow available to Comcast Corp. 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