Financial statement analysis and common stock valuation

Common-Size Income Statement

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

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

Common-Size Balance Sheet: Assets
Quarterly Data

Assets components shown as percentage of total assets.

Balance Sheet: Assets

The assets reports major classes and amounts of resources owned or controlled by Palo Alto Networks Inc..

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

An approach to decomposing Palo Alto Networks 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

Dividend Discount Model (DDM)

The dividend discount model (DDM) is a technique for estimating the value of a share of Palo Alto Networks 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-Size Income Statement
Quarterly Data

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

Aggregate Accruals

Financial reporting quality relates to the accuracy with which Palo Alto Networks Inc. reported financial statements reflect its operating performance and to their usefulness for forecasting future cash flows.
Aggregate accruals deriving measures of the accrual component of Palo Alto Networks Inc. earnings.

• Balance-Sheet-Based Accruals Ratio
• Cash-Flow-Statement-Based Accruals Ratio

Analysis of Solvency Ratios
Quarterly Data

Examines Palo Alto Networks 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

Common Stock Valuation Ratios
Quarterly Data

Relative valuation technique determine the value of Palo Alto Networks 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 Palo Alto Networks 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

Analysis of Short-term (Operating) Activity Ratios

Evaluates revenues and output generated by the Palo Alto Networks Inc. assets. Operating performance ratios describe the relationship between the Palo Alto Networks 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