Operating Data
Microsoft Corporation (MSFT)
Technology
Year A/P | 2013 Actual | 2014 Actual | 2015 Actual | 2016 Actual | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Projected | 2021 Projected | 2022 Projected | 2023 Projected |
| Revenue | 77,849.00 | 86,832.77 | 93,579.68 | 85,316.60 | 89,949.29 | 110,358.78 | 125,842.12 | 136,878.47 | 148,882.71 | 161,939.73 | 176,141.84 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Revenue (%) | |||||||||||
| EBITDA | 30,516.81 | 32,970.40 | 24,115.48 | 26,806.47 | 31,104.46 | 45,324.35 | 54,640.65 | 49,550.01 | 53,895.54 | 58,622.18 | 63,763.35 |
| EBITDA (%) | |||||||||||
| EBIT | 26,764.49 | 27,760.44 | 18,154.46 | 20,185.91 | 22,325.41 | 35,060.98 | 42,962.50 | 39,133.55 | 42,565.57 | 46,298.57 | 50,358.95 |
| EBIT (%) | |||||||||||
| Depreciation | 3,752.32 | 5,209.97 | 5,961.03 | 6,620.57 | 8,779.05 | 10,263.37 | 11,678.15 | 10,416.45 | 11,329.97 | 12,323.61 | 13,404.39 |
| Depreciation (%) |
EBIT (Operating profit)(Operating income)(Operating earning) = GROSS MARGIN (REVENUE - COGS) - OPERATING EXPENSES (R&D, RENT)
EBIT = (1*) (2*) -> operating process (leverage -> interest -> EBT -> tax -> net Income)
EBITDA = GROSS MARGIN (REVENUE - COGS) - OPERATING EXPENSES (R&D, RENT) + Depreciation + amortization
EBITA = (1*) (2*) (3*) (4*) company's CURRENT operating profitability (i.e., how much profit it makes with its present assets and its operations on the products it produces and sells, as well as providing a proxy for cash flow) -> performance of a company
(1*) discounting the effects of interest payments from different forms of financing (by ignoring interest payments),
(2*) political jurisdictions (by ignoring tax), collections of assets (by ignoring depreciation of assets), and different takeover histories (by ignoring amortization often stemming from goodwill)
(3*) collections of assets (by ignoring depreciation of assets)
(4*) different takeover histories (by ignoring amortization often stemming from goodwill)