Free Cash Flow Build Up

Alphabet Inc. (GOOG)

$ 2356.74
2.49 (+0.11%)
Year
A/P
2013
Actual
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Actual
2020
Actual
2021
Projected
2022
Projected
2023
Projected
2024
Projected
2025
Projected
Revenue 59,82566,00174,98990,272110,855136,819161,857182,527214,238.47251,459.35295,146.84346,424.40406,610.71
EBITDA 17,90521,47524,42329,86033,09336,55946,01254,92165,129.2976,444.5789,725.73105,314.30123,611.16
EBIT 13,96616,49619,36023,71626,17827,52434,23141,22450,317.3759,059.3069,320.0181,363.3895,499.10
Tax Rate 10.87%16.31%16.81%19.35%53.44%11.96%13.33%16.25%19.79%19.79%19.79%19.79%19.79%
EBIAT 12,447.6213,805.4516,105.9119,127.9612,189.3824,231.0229,668.0234,525.3840,359.8047,371.7455,601.9165,261.9576,600.28
Depreciation 3,9394,9795,0636,1446,9159,03511,78113,69714,811.9217,385.2820,405.7223,950.9228,112.06
Accounts Receivable --2,166-2,353-323-4,473-2,488-6,299-3,892-4,517.30-6,237.34-7,320.99-8,592.91-10,085.80
Inventories --43.98-64-108.83-146.57-184.88-178.29-147.19-225.81-265.04-311.09-365.14-428.57
Accounts Payable --7382161101,0961,2411,18328854.801,119.521,314.021,542.311,810.27
Capital Expenditure -7,358-10,959-9,915-10,212-13,184-25,139-23,548-22,281-29,581.10-34,720.39-40,752.56-47,832.74-56,143
UFCF 9,028.624,877.479,052.9114,738.132,396.816,695.1412,606.7321,930.1921,702.3124,653.7628,93733,964.4039,865.23
WACC
PV UFCF 17,844.8318,382.0119,564.4020,822.8522,162.24
SUM PV UFCF 108,930.54