Loading...

Free Cash Flow Build Up

Alphabet Inc.

Alphabet Inc. (GOOG)

Technology

Year
A/P
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
Revenue 66,001.0074,990.3490,273.37110,855.69136,818.10164,263.81197,215.13236,776.48284,273.85341,299.18
EBITDA 22,341.3424,814.3030,422.1234,221.1544,055.4353,779.9764,568.2377,520.6293,071.26111,741.35
EBIT 17,364.8619,752.4524,274.5127,303.7635,025.4342,626.4651,177.3361,443.5073,769.0688,567.14
Tax Rate 16.31%16.81%19.35%53.44%11.96%23.57%23.57%23.57%23.57%23.57%
EBIAT 14,532.6016,432.4019,578.4212,713.5730,834.9832,578.1339,113.3046,959.4356,379.4967,689.21
Depreciation 4,976.485,061.856,147.626,917.409,029.9911,153.5113,390.9116,077.1219,302.1923,174.21
Accounts Receivable --2,170.67-2,580.80-4,198.72-2,501.86-4,475.66-5,077.80-6,096.40-7,319.34-8,787.60
Inventories ----483.00-354.41139.07-194.41-233.41-280.23-336.45
Accounts Payable -211.23112.931,097.041,240.9640.52886.391,064.201,277.681,533.98
Capital Expenditure --5,693.151,040.212,275.0713,155.83166.635,374.366,452.467,746.829,300.83
UFCF 19,509.0713,841.6624,298.3718,321.3551,405.5039,602.2053,492.7564,223.3977,106.6092,574.19
WACC
PV UFCF 39,602.2053,492.7564,223.3977,106.6092,574.19
SUM PV UFCF -