Financial statement analysis and common stock valuation

Analysis of Solvency Ratios

Examines Dell Technologies 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

Analysis of Reportable Segments

Dell Technologies Inc. operates in 2 segments: Infrastructure Solutions Group (ISG) and Client Solutions Group (CSG).

• Segment Profit Margin
• Net revenue
• Operating income

Common-Size Income Statement
Quarterly Data

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

Enterprise Value to FCFF (EV/FCFF)

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

Common Stock Valuation Ratios
Quarterly Data

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

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

Measures how efficiently Dell Technologies 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

Cash Flow Statement
Quarterly Data

The cash flow statement provides information about Dell Technologies 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 Dell Technologies Inc. balance sheet.

Dividend Discount Model (DDM)

The dividend discount model (DDM) is a technique for estimating the value of a share of Dell Technologies Inc. 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)

Common Stock Valuation Ratios

Relative valuation technique determine the value of Dell Technologies 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)

Income Statement

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

Price to FCFE (P/FCFE)

Free cash flow to equity is the cash flow available to Dell Technologies 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 Revenues

• Revenues as Reported