Free Cash Flow Build Up
Microsoft Corporation (MSFT)
$149.7
-6.41 (-4.11%)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 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 |
| Tax Rate | -227.58% | -209.72% | -65.60% | 5,268.62% | -4,580.79% | -43.76% | -148.37% | -1.03% | -1.03% | -1.03% | -1.03% |
| EBIAT | 87,676.35 | 85,980.62 | 30,063.47 | -1,043,331.87 | 1,045,006.74 | 50,403.02 | 106,706.02 | 39,536.86 | 43,004.24 | 46,775.71 | 50,877.94 |
| 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 |
| Accounts Receivable | - | -2,061.17 | 1,634.91 | -363.66 | -1,514.03 | -6,697.26 | -3,036.45 | -782.33 | -2,657.74 | -2,890.82 | -3,144.35 |
| Inventories | - | -718.64 | -243.89 | 648.61 | 75.59 | -482.87 | 595.84 | -1,412.90 | -304.91 | -331.65 | -360.73 |
| Accounts Payable | - | 2,606.25 | -844.88 | 314.10 | 491.72 | 1,225.19 | 768.80 | 1,042.32 | 914.72 | 994.94 | 1,082.20 |
| Capital Expenditure | - | -1,229.49 | -454.48 | -2,401.65 | 212.55 | -3,500.40 | -2,298.91 | 2,473.99 | -1,004.76 | -1,092.87 | -1,188.72 |
| UFCF | 91,428.67 | 89,787.53 | 36,116.16 | -1,038,513.90 | 1,053,051.62 | 51,211.03 | 114,413.45 | 51,274.39 | 51,281.54 | 55,778.93 | 60,670.74 |
| WACC | |||||||||||
| PV UFCF | 51,274.39 | 51,281.54 | 55,778.93 | 60,670.74 | |||||||
| SUM PV UFCF | 616,500.16 |