Earnings in (Millions) |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
$70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 |
|
|
|
|
|
|
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
|
|
|
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Values in days | 2008 | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 | 2001 | 2000 |
|---|---|---|---|---|---|---|---|---|---|
| Cash conversion cycle | -14 | 9 | 9 | -28 | -12 | 3 | 32 | -73 | -80 |
| Days inventory outstanding | 31 | 38 | 71 | 29 | 23 | 39 | 43 | 0 | 0 |
| Days payable outstanding | 127 | 111 | 139 | 123 | 93 | 95 | 77 | 126 | 132 |
| Days sales outstanding | 82 | 81 | 77 | 66 | 58 | 59 | 66 | 53 | 52 |
| Risk ratios | 2008 | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 | 2001 | 2000 |
|---|---|---|---|---|---|---|---|---|---|
| Current ratio | 1.45 | 1.69 | 2.18 | 2.89 | 4.71 | 4.22 | 3.81 | 3.56 | 3.11 |
| Acid test | 0.79 | 0.99 | 1.52 | 2.24 | 4.05 | 3.51 | 3.03 | 2.84 | 2.44 |
| Acid test (liberal) | 1.41 | 1.64 | 2.12 | 2.86 | 4.69 | 4.17 | 3.76 | 3.56 | 3.11 |
| Debt to equity ratio (Adjusted) | 0.00 | 0.03 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.02 | 0.02 |
| Interest coverage ratio (Adjusted) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Fixed charges coverage ratio (Adjusted) | 0.00 | 62.80 | 65.65 | 69.77 | 43.68 | 59.20 | 48.58 | 67.48 | 101.60 |
| Earnings in (Millions) | 2008 | 2007 | 2006 | 2005 |
|---|---|---|---|---|
| Revenue | $60,420 | $51,122 | $44,282 | $39,788 |
| Expenses | $44,061 | $38,634 | $33,473 | $29,601 |
| Net income | $17,681 | $14,065 | $12,599 | $12,254 |
| Earnings before interest and taxes (EBIT) | $23,814 | $20,101 | $18,262 | $16,628 |
| Adjusted EBIT | $25,348 | $20,473 | $18,118 | $15,977 |
| Free cash flow to firm | $27,123 | $10,502 | $12,535 | $12,204 |
| Free cash flow to equity | $20,990 | $11,305 | $12,937 | $13,193 |
| Operating lease expense and debt conversion in (Millions) | 2008 | 2007 | 2006 | 2005 |
|---|---|---|---|---|
| Current year | $326 | $276 | $229 | |
| Year one | $349 | $250 | $230 | |
| Year two | $242 | $193 | $204 | |
| Year three | $202 | $138 | $167 | |
| Year four | $174 | $105 | $122 | |
| Post year four | $374 | $199 | $310 | |
| Total | $1,667 | $1,161 | $1,262 | |
| Debt value | $1,132 | $755 | $867 | |
| Depreciation | $226 | $151 | $173 |
Past growth rates |
|||||||||||||||||||||
24 % 22 % 20 % 18 % 16 % 14 % 12 % 10 % 8 % 6 % 4 % 2 % |
|
|
|
|
|
|
|||||||||||||||
|
|
|
|
|
|
|||||||||||||||||
| all | 4 years | 3 years | 2 years | ||||||||||||||||||
Cashflow in (Millions) |
|||||||||||||||||||||||||||||||||||||||||||||||||||
$30,000 $25,000 $20,000 $15,000 $10,000 $5,000 |
|
|
|
|
|
|
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||
|
|
|
|
|
|
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
| 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | |||||||||||||||||||||||||||||||||||||||||||
| ( values in Millions ) | 2008 | 2007 | 2006 | 2005 |
|---|---|---|---|---|
| + R&D investment | $8,164 | $7,121 | $6,584 | $6,184 |
| + Working capital investment | ($3,309) | $596 | ($1,702) | ($896) |
| + Fixed Capital investment | $2,264 | $1,578 | $812 | |
| + Acquisitions | $1,340 | $689 | ||
| - R&D amortized | $6,630 | $6,849 | $6,853 | $6,891 |
| - Fixed capital depreciation | $1,440 | $903 | $855 | |
| - Operating lease depreciation | $226 | $151 | $173 | |
| = Reinvested | ($1,775) | $2,806 | ($758) | ($1,819) |
| ( values in Millions ) | 2008 | 2007 | 2006 | 2005 |
|---|---|---|---|---|
| Adjusted EBIT | $25,348 | $20,473 | $18,118 | $15,977 |
| Marginal tax rate | 0.00 % | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $25,348 | $13,307 | $11,777 | $10,385 |
| Reinvestment expense (gain) | ($1,775) | $2,806 | ($758) | ($1,819) |
| Free cash flow to firm (FCFF) | $27,123 | $10,502 | $12,535 | $12,204 |
| past reinvestment rates | 2 years | 3 years | 4 years | all |
|---|---|---|---|---|
| Reinvestment | 7.04 % | 2.55 % | -2.47 % | 17.90 % |
| Working capital investment | -4.29 % | -7.68 % | -7.91 % | -5.72 % |
| R&D investment | 42.86 % | 47.21 % | 50.29 % | 57.47 % |
| Acquisitions | 5.03 % | 5.31 % | 3.98 % | 7.17 % |
| Net capital investments | 8.51 % | 10.14 % | 9.56 % | 9.89 % |
| Past growth rates | 2 years | 3 years | 4 years | all |
|---|---|---|---|---|
| EBIT (adjusted) | 21.28 % | 16.96 % | 15.25 % | 5.93 % |
| Profit | 22.78 % | 17.19 % | 12.54 % | 11.50 % |
| Revenue | 16.67 % | 15.53 % | 14.06 % | 11.73 % |
| ( values in Millions ) | 2008 | 2007 | 2006 | 2005 |
|---|---|---|---|---|
| Cash and equivalent | $10,339 | $6,111 | $6,714 | $4,851 |
| Short term investments | $13,323 | $17,300 | $27,447 | $32,900 |
| Accounts receivable | $13,589 | $11,338 | $9,316 | $7,180 |
| Inventory | $985 | $1,127 | $1,478 | $491 |
| Deferred taxes | $2,017 | $1,940 | $1,701 | |
| Prepaid expenses | $1,899 | |||
| Other assets | $2,989 | $2,393 | $2,115 | $1,614 |
| Total assets | $43,242 | $40,168 | $49,010 | $48,737 |
| Accounts payable | $4,034 | $3,247 | $2,909 | $2,086 |
| Debt payments | ||||
| Accrued Expenses | $2,325 | $1,938 | $1,662 | |
| Tax payable | $3,248 | $1,040 | $1,557 | $2,020 |
| Other liabilities | $22,604 | $17,142 | $16,038 | $11,109 |
| Total liabilities | $29,886 | $23,754 | $22,442 | $16,877 |
| Working capital | $13,356 | $16,414 | $26,568 | $31,860 |
| Non cash working capital | ($10,306) | ($6,997) | ($7,593) | ($5,891) |
| Investment in working capital | ($3,309) | $596 | ($1,702) | ($896) |
Microsoft generates revenues by developing, manufacturing, licensing, and supporting a wide range of software products for many computing devices.
In addition to that they provide consulting and product support services, and train and certify computer system integrators and developers.
Microsoft also sells the Xbox 360 video game console and games, the Zune digital music and entertainment device, PC games, and peripherals.
Online offerings and information are delivered through Windows Live, Office Live, and MSN portals and channels. Microsoft also enables the delivery of online advertising through their proprietary adCenter® platform.
| Earnings in (Millions) | 2008 | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 | 2001 | 2000 |
|---|---|---|---|---|---|---|---|---|---|
| Revenue | $60,420 | $51,122 | $44,282 | $39,788 | $36,835 | $32,187 | $28,365 | $25,296 | $22,956 |
| Expenses | $44,061 | $38,634 | $33,473 | $29,601 | $31,854 | $26,233 | $22,705 | $17,914 | $16,873 |
| Net income | $17,681 | $14,065 | $12,599 | $12,254 | $8,168 | $7,531 | $5,355 | $7,346 | $9,421 |
| Earnings before interest and taxes (EBIT) | $23,814 | $20,101 | $18,262 | $16,628 | $12,196 | $11,054 | $7,875 | $11,150 | $14,275 |
| Adjusted EBIT | $25,348 | $20,473 | $18,118 | $15,977 | $14,457 | $12,906 | $12,632 | $14,710 | $18,085 |
| Free cash flow to firm | $27,123 | $10,502 | $12,535 | $12,204 | $8,490 | $6,488 | $3,753 | $5,777 | $6,492 |
| Free cash flow to equity | $20,990 | $11,305 | $12,937 | $13,193 | $9,191 | $7,264 | $5,394 | $6,529 | $7,790 |
| Adjusted debt | $1,132 | $755 | $867 | $457 | $860 | $857 | $922 | $859 | |
| Adjusted equity | $13,572 | $44,397 | $53,672 | $62,390 | $87,079 | $71,497 | $59,579 | $51,064 | $41,368 |
| Adjusted depreciation | $6,630 | $8,515 | $7,907 | $7,919 | $7,035 | $6,400 | $2,886 | $2,948 | $891 |
| Total reinvestment | ($1,775) | $2,806 | ($758) | ($1,819) | $907 | $1,901 | $4,458 | $3,784 | $5,263 |
| Adjusted EBIT | $25,348 | $20,473 | $18,118 | $15,977 | $14,457 | $12,906 | $12,632 | $14,710 | $18,085 |
| Adjusted EBIT(1 - t) | $25,348 | $13,307 | $11,777 | $10,385 | $9,397 | $8,389 | $8,211 | $9,562 | $11,755 |
| FCFF | $27,123 | $10,502 | $12,535 | $12,204 | $8,490 | $6,488 | $3,753 | $5,777 | $6,492 |
| FCFE | $20,990 | $11,305 | $12,937 | $13,193 | $9,191 | $7,264 | $5,394 | $6,529 | $7,790 |
| Cash conversion cycle | -14 | 9 | 9 | -28 | -12 | 3 | 32 | -73 | -80 |
| Days inventory outstanding | 31 | 38 | 71 | 29 | 23 | 39 | 43 | 0 | 0 |
| Days payable outstanding | 127 | 111 | 139 | 123 | 93 | 95 | 77 | 126 | 132 |
| Days sales outstanding | 82 | 81 | 77 | 66 | 58 | 59 | 66 | 53 | 52 |
| Acid test | 0.79 | 0.99 | 1.52 | 2.24 | 4.05 | 3.51 | 3.03 | 2.84 | 2.44 |
| liberal acid test | 1.41 | 1.64 | 2.12 | 2.86 | 4.69 | 4.17 | 3.76 | 3.56 | 3.11 |
| Current ratio | 1.45 | 1.69 | 2.18 | 2.89 | 4.71 | 4.22 | 3.81 | 3.56 | 3.11 |
| Fixed charges coverage ratio | 0.00 | 61.66 | 66.17 | 72.61 | 36.85 | 50.71 | 30.29 | 51.15 | 80.20 |
| Interest coverage ratio | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
|   | |||||||||
| Current Assets | |||||||||
| Cash and equivalent | $10,339 | $6,111 | $6,714 | $4,851 | $15,982 | $6,438 | $3,016 | $3,922 | $4,846 |
| Short term investments | $13,323 | $17,300 | $27,447 | $32,900 | $44,610 | $42,610 | $35,636 | $27,678 | $18,952 |
| Accounts receivable | $13,589 | $11,338 | $9,316 | $7,180 | $5,890 | $5,196 | $5,129 | $3,671 | $3,250 |
| Inventory | $985 | $1,127 | $1,478 | $491 | $421 | $640 | $673 | ||
| Deferred taxes | $2,017 | $1,940 | $1,701 | $2,097 | $2,506 | $2,112 | $1,949 | $1,708 | |
| Prepaid expenses | $1,899 | ||||||||
| Other assets | $2,989 | $2,393 | $2,115 | $1,614 | $1,566 | $1,583 | $2,010 | $2,417 | $1,552 |
| Total assets | $43,242 | $40,168 | $49,010 | $48,737 | $70,566 | $58,973 | $48,576 | $39,637 | $30,308 |
|   | |||||||||
| Current Liabilities | |||||||||
| Accounts payable | $4,034 | $3,247 | $2,909 | $2,086 | $1,717 | $1,573 | $1,208 | $1,188 | $1,083 |
| Debt payments | |||||||||
| Accrued Expenses | $2,325 | $1,938 | $1,662 | $1,339 | $1,416 | $1,145 | $742 | $557 | |
| Tax payable | $3,248 | $1,040 | $1,557 | $2,020 | $3,478 | $2,044 | $2,022 | $1,468 | $585 |
| Other liabilities | $22,604 | $17,142 | $16,038 | $11,109 | $8,435 | $8,941 | $8,369 | $7,734 | $7,530 |
| Total liabilities | $29,886 | $23,754 | $22,442 | $16,877 | $14,969 | $13,974 | $12,744 | $11,132 | $9,755 |
| Working capital | $13,356 | $16,414 | $26,568 | $31,860 | $55,597 | $44,999 | $35,832 | $28,505 | $20,553 |
| Non cash working capital | ($10,306) | ($6,997) | ($7,593) | ($5,891) | ($4,995) | ($4,049) | ($2,820) | ($3,095) | ($3,245) |
| Investment in working capital | ($3,309) | $596 | ($1,702) | ($896) | ($946) | ($1,229) | $275 | $150 | |