Free Cash Flow Build Up
Alphabet Inc. (GOOG)
$ 2836.53
17.76 0.63%
Year A/P | 2016 Actual | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Projected | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected |
| Revenue | 90,272 | 110,855 | 136,819 | 161,857 | 182,527 | 217,797.29 | 259,882.96 | 310,100.99 | 370,022.82 | 441,523.53 |
|---|---|---|---|---|---|---|---|---|---|---|
| EBITDA | 30,418 | 24,393 | 44,062 | 51,506 | 61,914 | 66,927.94 | 79,860.65 | 95,292.38 | 113,706.04 | 135,677.82 |
| EBIT | 24,274 | 17,478 | 35,027 | 39,725 | 48,217 | 51,930.28 | 61,964.93 | 73,938.62 | 88,226.02 | 105,274.22 |
| Tax Rate | 19.35% | 53.44% | 11.96% | 13.33% | 16.25% | 22.87% | 22.87% | 22.87% | 22.87% | 22.87% |
| EBIAT | 19,578.01 | 8,138.36 | 30,836.36 | 34,429.67 | 40,382.06 | 40,056.35 | 47,796.57 | 57,032.46 | 68,053.03 | 81,203.14 |
| Depreciation | 6,144 | 6,915 | 9,035 | 11,781 | 13,697 | 14,997.67 | 17,895.71 | 21,353.76 | 25,480.02 | 30,403.61 |
| Accounts Receivable | - | -4,473 | -2,488 | -6,299 | -3,892 | -4,469.10 | -6,928.01 | -8,266.73 | -9,864.14 | -11,770.22 |
| Inventories | - | -481 | -358 | 108 | 271 | -490.66 | -235.49 | -280.99 | -335.29 | -400.07 |
| Accounts Payable | - | 1,096 | 1,241 | 1,183 | 28 | 852.74 | 1,244.76 | 1,485.29 | 1,772.29 | 2,114.76 |
| Capital Expenditure | -10,212 | -13,184 | -25,139 | -23,548 | -22,281 | -29,766.36 | -35,518.21 | -42,381.51 | -50,571.02 | -60,343.02 |
| UFCF | 15,510.01 | -1,988.64 | 13,127.36 | 17,654.67 | 28,205.06 | 21,180.64 | 24,255.34 | 28,942.28 | 34,534.89 | 41,208.18 |
| WACC | ||||||||||
| PV UFCF | 23,383.42 | 24,255.34 | 26,215.83 | 28,334.79 | 30,625.01 | |||||
| SUM PV UFCF | 108,970.01 |