Financial statement analysis and common stock valuation

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

Price to FCFE (P/FCFE)

Free cash flow to equity is the cash flow available to Microsoft Corp. equity holders after all operating expenses, interest, and principal payments have been paid and necessary investments in working and fixed capital have been made.

• Free Cash Flow to Equity (FCFE)
• P to FCFE Ratio, Current
• P to FCFE Ratio, Historical

Enterprise Value to FCFF (EV/FCFF)

Free cash flow to the firm is the cash flow available to the Microsoft Corp. suppliers of capital after all operating expenses have been paid and necessary investments in working and fixed capital have been made.

• Free Cash Flow to The Firm (FCFF)
• Interest Paid, Net of Tax
• EV to FCFF Ratio, Current
• EV to FCFF Ratio, Historical

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

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

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

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

Assets components shown as percentage of total assets.

Cash Flow Statement
Quarterly Data

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 Geographic Areas

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

• Area Asset Turnover
• Revenue
• Long-lived assets

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)