Loading...

Free Cash Flow Build Up

Alphabet Inc.

Alphabet Inc. (GOOGL)

Technology

Year
A/P
2013
Actual
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
Revenue 55,519.0066,000.9974,990.3290,273.35110,855.67136,818.07163,935.41196,427.41235,359.33282,007.54337,901.44
EBITDA 19,409.4422,757.1424,716.8130,295.7434,110.2943,945.9654,328.2065,096.0477,998.0893,457.30111,980.54
EBIT 15,473.1517,780.6719,654.9624,148.1227,192.9034,915.9743,115.0151,660.4161,899.5074,167.9888,868.08
Tax Rate 17.70%20.47%16.81%19.35%53.44%11.96%23.29%23.29%23.29%23.29%23.29%
EBIAT 12,733.9414,140.5116,351.3019,476.4812,661.9530,738.6233,074.2339,629.5547,484.1256,895.4868,172.16
Depreciation 3,936.304,976.475,061.856,147.626,917.399,029.9911,213.1813,435.6316,098.5819,289.3223,112.46
Accounts Receivable --1,273.58-1,749.40-2,130.86-4,198.72-2,501.86-5,162.76-5,153.23-6,174.60-7,398.41-8,864.77
Inventories ---216.62-483.00-354.41108.22-198.20-237.48-284.55-340.95
Accounts Payable -669.41-137.73-2,316.761,097.041,240.963,212.031,504.381,802.552,159.812,587.89
Capital Expenditure -2,150.85-1,042.4461.483,105.7611,956.74-1,316.254,701.595,633.456,750.008,087.85
UFCF 16,670.2420,663.6618,483.5721,454.5919,100.4350,110.0441,128.6553,919.7264,606.6177,411.6492,754.63
WACC
PV UFCF 41,128.6553,919.7264,606.6177,411.6492,754.63
SUM PV UFCF 476,303.78