Free Cash Flow Build Up

Alphabet Inc

Alphabet Inc (GOOGL)

$1458.66
19.6 (+1.36%)
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
2024
Projected
Revenue 55,519.0066,001.0074,989.0090,272.00110,855.00136,819.00161,857.00193,527.31231,394.51276,671.12330,806.94395,535.43
EBITDA 19,716.0023,339.0024,818.0030,418.0024,393.0044,062.0051,506.0061,844.7373,945.8088,414.66105,714.62126,399.64
EBIT 15,777.0018,360.0019,755.0024,274.0017,478.0035,027.0039,725.0048,486.7657,974.0969,317.8082,881.1099,098.32
Tax Rate 19.91%18.09%16.81%19.35%53.44%11.96%13.33%21.84%21.84%21.84%21.84%21.84%
EBIAT 12,635.2915,037.7716,434.5219,578.018,138.3630,836.3634,429.6737,896.3745,311.5054,177.5364,778.3777,453.45
Depreciation 3,939.004,979.005,063.006,144.006,915.009,035.0011,781.0013,357.9715,971.7119,096.8622,833.5227,301.32
Accounts Receivable --1,459.00-3,060.00-323.00-4,473.00-2,488.00-6,299.00-4,858.32-6,329.94-7,568.51-9,049.43-10,820.11
Inventories ------------
Accounts Payable --738.00216.00110.001,096.001,241.001,183.00332.781,153.231,378.881,648.681,971.28
Capital Expenditure -7,358.00-11,014.00-9,950.00-10,212.00-13,184.00-25,139.00-23,548.00-27,463.57-32,837.33-39,262.56-46,945.00-56,130.66
UFCF 9,216.296,805.778,703.5215,297.01-1,507.6413,485.3617,546.6719,265.2323,269.1627,822.2133,266.1439,775.27
WACC
PV UFCF 17,317.0618,800.9920,206.5221,717.1223,340.65
SUM PV UFCF 101,382.35