Financial statement analysis and common stock valuation

Analysis of Solvency Ratios
Quarterly Data

Examines Microsoft Corp. 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

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.

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)

Analysis of Profitability Ratios

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)

Analysis of Geographic Areas

Microsoft Corp. operates in 2 regions: United States and Other countries.

• Area Asset Turnover
• Revenue
• Long-lived assets

Analysis of Reportable Segments

Microsoft Corp. operates in 3 segments: Productivity and Business Processes; Intelligent Cloud; and More Personal Computing.

• Segment Profit Margin
• Revenue
• Operating income

Analysis of Liquidity Ratios

Measures the adequacy of Microsoft Corp. cash resources to meet its near-term cash obligations.

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

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

Income Statement
Quarterly Data

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

Common-Size Balance Sheet: Assets

Assets components shown as percentage of total assets.

Common-Size Balance Sheet: Assets
Quarterly Data

Assets components shown as percentage of total assets.

Analysis of Long-term (Investment) Activity Ratios

Measures how efficiently Microsoft Corp. 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