| RATIO ANALYSIS SPREADSHEET | | | | | = Pos,Neu,Neg |
| Company | MSFT |
| | | | 2,019 | | 2,018 | | 2,017 | | Industry |
| | | | | | | | | | Average |
| BALANCE SHEET RATIOS: Stability (Staying Power) | | | | | | | | | Access csimarket.com and query by stock symbol |
| 1 | Current | | | | | | | | | Ability to meet current obligations |
| | | Current Assets | 175,552,000 | 2.53 | 169,662,000 | 2.90 | 159,851,000 | 2.48 |
| | | Current Liabilities | 69,420,000 | | 58,488,000 | | 64,527,000 | | 2.03 |
| 2 | Debt-to-Equity | | | | | | | | | Margin of Safety to Creditors |
| | | Total Liabilities | 184,226,000 | 1.80 | 176,130,000 | 2.13 | 168,692,000 | 2.33 |
| | | Equity | 102,330,000 | | 82,718,000 | | 72,394,000 | | 2.58 |
| INCOME STATEMENT RATIOS: Profitability (Earning Power) |
| 3 | Gross Margin | | | | | | | | | Gross Profit expressed as a % of Sales |
| | | Gross Profit | 82,933,000 | 65.9% | 72,007,000 | 65.2% | 55,689,000 | 61.9% |
| | | Sales | 125,843,000 | | 110,360,000 | | 89,950,000 | | 74.1% |
| 4 | Operating Profit Margin | | | | | | | | | Operating Profit expressed as a % of Sales |
| | | Operating Profit | 42,959,000 | | 35,058,000 | | 22,632,000 |
| | | Sales | 125,843,000 | 34.1% | 110,360,000 | 31.8% | 89,950,000 | 25.2% | 21.3% |
| 5 | Net Margin | | | | | | | | | Net Profit expressed as a % of Sales |
| | | Net Income | 39,240,000 | 31.2% | 16,571,000 | 15.0% | 21,204,000 | 23.6% |
| | | Sales | 125,843,000 | | 110,360,000 | | 89,950,000 | | 20.1% |
| ASSET MANAGEMENT RATIOS: Overall Efficiency Ratios |
| 6 | Earnings Quality | | | | | | | | | Measures cash generated from sales; higher % the better |
| | | Cash flow from Operations | 52,185,000 | 133% | 43,884,000 | 265% | 39,507,000 | 186% |
| | | Net Income | 39,240,000 | | 16,571,000 | | 21,204,000 | | n/a |
| 7 | Return on Assets | | | | | | | | | Measures the profitability of using the assets |
| | | Net Income | 39,240,000 | 13.7% | 16,571,000 | 6.4% | 21,204,000 | 8.8% |
| | | Total Assets | 286,556,000 | | 258,848,000 | | 241,086,000 | | 11.2% |
| 8 | Return on Equity | | | | | | | | | Measures the profitability of the stockholders investment |
| | | Net Income | 39,240,000 | 38.3% | 16,571,000 | 20.0% | 21,204,000 | 29.3% |
| | | Equity | 102,330,000 | | 82,718,000 | | 72,394,000 | | 29.9% |
| ASSET MANAGEMENT RATIOS: Working Capital Cycle Ratios |
| 9 | Inventory Turnover | | | | | | | | | Measures the efficiency of moving the inventory |
| | | Cost of Revenue/Goods Sold | 42,910,000 | 21 | 38,253,000 | 14 | 34,261,000 | 16 |
| | | Inventory | 2,063,000 | | 2,662,000 | | 2,181,000 | | 33 |
| 10 | Inventory Turn-Days | | | | | | | | | Average # of days it takes to move inventory |
| | | 360 | 360 | 17.31 | 360 | 25.05 | 360 | 22.92 |
| | | Inventory Turnover | 21 | | 14 | | 16 | | 11.04 |
| 11 | Accounts Receivable Turnover | | | | | | | | | Measures the efficiency of collecting Accounts Receivable |
| | | Sales | 125,843,000 | 4.26 | 110,360,000 | 4.17 | 89,950,000 | 4.54 | 7.50 |
| | | Accounts Receivable | 29,524,000 | | 26,481,000 | | 19,792,000 |
| 12 | Accounts Receivable Turn-Days | | | | | | | | | Average # of days it takes to collect Accounts Receivable |
| | | 360 | 360 | 84 | 360 | 86 | 360 | 79 |
| | | Accts. Rec. Turnover | 4 | | 4 | | 5 | | 48 |
| 13 | Accounts Payable Turnover | | | | | | | | | Measures the efficiency of paying Accounts Payable |
| | | Cost of Revenue/Goods Sold | 42,910,000 | 4.57 | 38,253,000 | 4.44 | 34,261,000 | 4.64 |
| | | Accounts Payable | 9,382,000 | | 8,617,000 | | 7,390,000 | | n/a |
| 14 | Average Payment Period | | | | | | | | | Average # of days it takes to pay Accounts Payable |
| | | 360 | 360 | 79 | 360 | 81 | 360 | 78 |
| | | Accts. Pay. Turnover | 5 | | 4 | | 5 |
A112233A
12.xls
