Financial statement analysis and common stock valuation

Common Stock Valuation Ratios

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.

• 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)

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

Common-Size Income Statement
Quarterly Data

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

Analysis of Liquidity Ratios
Quarterly Data

Measures the adequacy of a Palo Alto Networks Inc. cash resources to meet its near-term cash obligations.

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

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

Common-Size Balance Sheet: Liabilities and Stockholders’ Equity

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

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 Liquidity Ratios

Measures the adequacy of Palo Alto Networks Inc. cash resources to meet its near-term cash obligations.

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

Common-Size Balance Sheet: Assets

Assets components shown as percentage of total assets.

Balance Sheet: Assets
Quarterly Data

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

Analysis of Short-term (Operating) Activity Ratios
Quarterly Data

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

Income Statement

The income statement (statement of earnings) reports on the performance of Palo Alto Networks Inc., the result of its operating activities.