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 | 91,155.97 | 96,570.63 | 110,360.92 | 125,844.55 | 136,528.76 | 148,120.05 | 160,695.44 | 174,338.48 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Revenue (%) | |||||||||||
| EBITDA | 30,804.85 | 33,031.19 | 24,461.73 | 32,260.10 | 38,676.54 | 46,737.85 | 55,371.60 | 51,799.01 | 56,196.75 | 60,967.85 | 66,144.02 |
| EBITDA (%) | |||||||||||
| EBIT | 27,052.53 | 27,821.22 | 18,500.70 | 25,642.17 | 29,898.27 | 36,474.28 | 43,693.23 | 41,627.62 | 45,161.80 | 48,996.04 | 53,155.80 |
| EBIT (%) | |||||||||||
| Depreciation | 3,752.32 | 5,209.97 | 5,961.03 | 6,617.92 | 8,778.27 | 10,263.57 | 11,678.37 | 10,171.39 | 11,034.94 | 11,971.81 | 12,988.22 |
| 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)