Financial statement analysis and common stock valuation

Analysis of Revenues

• Revenues as Reported

Balance Sheet: Assets

The assets reports major classes and amounts of resources owned or controlled by Microsoft Corp..

Balance Sheet: Assets
Quarterly Data

The assets reports major classes and amounts of resources owned or controlled by Microsoft Corp..

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

Statement of Comprehensive Income

Comprehensive income is the change in equity (net assets) of Microsoft Corp. during a period from transactions and other events and circumstances from non-owners sources. It includes all changes in equity during a period except those resulting from investments by owners and distributions to owners.

Common-Size Balance Sheet: Assets

Assets components shown as percentage of total assets.

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

An approach to decomposing Microsoft Corp. 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
• Two-Component Disaggregation of ROA

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

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

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.

Common-Size Balance Sheet: Assets
Quarterly Data

Assets components shown as percentage of total assets.

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)