Loading...

Major Indexes

Free Cash Flow Build Up

Microsoft Corporation

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.0086,832.7793,579.6885,316.6089,949.29110,358.78125,842.12136,878.47148,882.71161,939.73176,141.84
EBITDA 30,516.8132,970.4024,115.4826,806.4731,104.4645,324.3554,640.6549,550.0153,895.5458,622.1863,763.35
EBIT 26,764.4927,760.4418,154.4620,185.9122,325.4135,060.9842,962.5039,133.5542,565.5746,298.5750,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.3585,980.6230,063.47-1,043,331.871,045,006.7450,403.02106,706.0239,536.8643,004.2446,775.7150,877.94
Depreciation 3,752.325,209.975,961.036,620.578,779.0510,263.3711,678.1510,416.4511,329.9712,323.6113,404.39
Accounts Receivable --2,061.171,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.89648.6175.59-482.87595.84-1,412.90-304.91-331.65-360.73
Accounts Payable -2,606.25-844.88314.10491.721,225.19768.801,042.32914.72994.941,082.20
Capital Expenditure --1,229.49-454.48-2,401.65212.55-3,500.40-2,298.912,473.99-1,004.76-1,092.87-1,188.72
UFCF 91,428.6789,787.5336,116.16-1,038,513.901,053,051.6251,211.03114,413.4551,274.3951,281.5455,778.9360,670.74
WACC
PV UFCF 51,274.3951,281.5455,778.9360,670.74
SUM PV UFCF 616,500.16