Financial statement analysis and common stock valuation

Common-Size Income Statement

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

Analysis of Revenues

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

An approach to decomposing Cisco Systems 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

Enterprise Value to FCFF (EV/FCFF)

Free cash flow to the firm is the cash flow available to the Cisco Systems 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 Profitability Ratios
Quarterly Data

Measures the income of Cisco Systems Inc. relative to its revenues and invested capital.

• Profitability Ratios (Summary)
• Gross Profit Margin
• Operating Profit Margin
• Net Profit Margin
• Return on Equity (ROE)
• Return on Assets (ROA)

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 Cisco Systems Inc. assets. Operating performance ratios describe the relationship between the Cisco Systems Inc. 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

Income Statement
Quarterly Data

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

Income Statement

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

Analysis of Reportable Segments

Cisco Systems Inc. operates in 3 segments: Americas; Europe, Middle East, and Africa (EMEA); and Asia Pacific, Japan, and China (APJC).

• Segment Profit Margin
• Revenue
• Gross margin