Financial statement analysis and common stock valuation

Analysis of Reportable Segments

Intel Corp. operates in 3 segments: Client Computing Group (CCG); Data Center and AI (DCAI); and Intel Foundry.

• Segment Profit Margin
• Net revenue
• Operating income (loss)

Enterprise Value to FCFF (EV/FCFF)

Free cash flow to the firm is the cash flow available to the Intel 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

Common Stock Valuation Ratios
Quarterly Data

Relative valuation technique determine the value of Intel Corp. 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)

Common-Size Income Statement
Quarterly Data

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

Enterprise Value to EBITDA (EV/EBITDA)

To calculate EBITDA analysts start with net earnings. To that earnings number, interest, taxes, depreciation, and amortization are added. EBITDA as a pre-interest number is a flow to all providers of capital.

• Earnings before Interest, Tax, Depreciation and Amortization (EBITDA)
• EV to EBITDA Ratio, Current
• EV to EBITDA Ratio, Historical

Analysis of Geographic Areas

Intel Corp. operates in 2 regions: United States and Other countries.

• Area Asset Turnover
• Net revenue
• Property, plant, and equipment, net

Analysis of Short-term (Operating) Activity Ratios

Evaluates revenues and output generated by the Intel Corp. assets. Operating performance ratios describe the relationship between the Intel Corp. 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

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.

Dividend Discount Model (DDM)

The dividend discount model (DDM) is a technique for estimating the value of a share of Intel Corp. common stock issue as the present value of all future dividends.

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

Analysis of Solvency Ratios

Examines Intel 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 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

Analysis of Liquidity Ratios
Quarterly Data

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

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

Common-Size Balance Sheet: Liabilities and Stockholders’ Equity

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