Financial statement analysis and common stock valuation

Analysis of Liquidity Ratios
Quarterly Data

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

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

Present Value of Free Cash Flow to Equity (FCFE)

The FCFE valuation approach estimates the value of equity as the present value of future FCFE discounted at the required rate of return on equity.

• Intrinsic Stock Value (Valuation Summary)
• Required Rate of Return (r)
• FCFE Growth Rate (g)

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

Common-Size Balance Sheet: Liabilities and Stockholders’ Equity

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

Common Stock Valuation Ratios

Relative valuation technique determine the value of Microsoft Corp. 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)

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)

Common-Size Balance Sheet: Assets
Quarterly Data

Assets components shown as percentage of total assets.

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

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

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

Balance Sheet: Assets
Quarterly Data

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

Common-Size Balance Sheet: Liabilities and Stockholders’ Equity
Quarterly Data

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