Financial statement analysis and common stock valuation

Cash Flow Statement

The cash flow statement provides information about Microsoft Corp. 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 Microsoft Corp. balance sheet.

Analysis of Short-term (Operating) Activity Ratios

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

Common-Size Balance Sheet: Assets
Quarterly Data

Assets components shown as percentage of total assets.

Common-Size Balance Sheet: Assets

Assets components shown as percentage of total assets.

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Measures how efficiently Microsoft Corp. generates revenues from its investments in fixed or total assets.

• Long-term Activity Ratios (Summary)
• Net Fixed Asset Turnover
• Total Asset Turnover
• Equity Turnover

Dividend Discount Model (DDM)

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

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 Profitability Ratios
Quarterly Data

Measures the income of Microsoft Corp. 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)

Income Statement
Quarterly Data

The income statement (statement of earnings) reports on the performance of Microsoft Corp., the result of its operating activities.

Balance Sheet: Liabilities and Stockholders’ Equity
Quarterly Data

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.