Free Cash Flow Build Up
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.00 | 74,990.34 | 90,273.37 | 110,855.69 | 136,818.10 | 164,263.81 | 197,215.13 | 236,776.48 | 284,273.85 | 341,299.18 |
|---|---|---|---|---|---|---|---|---|---|---|
| EBITDA | 22,341.34 | 24,424.35 | 29,862.43 | 33,057.17 | 35,353.80 | 50,971.06 | 61,195.85 | 73,471.74 | 88,210.17 | 105,905.14 |
| EBIT | 17,364.86 | 19,362.50 | 23,714.81 | 26,139.77 | 26,323.80 | 39,817.55 | 47,804.95 | 57,394.62 | 68,907.98 | 82,730.92 |
| 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.60 | 16,108.00 | 19,127.00 | 12,171.58 | 23,174.42 | 30,431.36 | 36,535.89 | 43,864.99 | 52,664.31 | 63,228.77 |
| Depreciation | 4,976.48 | 5,061.85 | 6,147.62 | 6,917.40 | 9,029.99 | 11,153.51 | 13,390.91 | 16,077.12 | 19,302.19 | 23,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.41 | 139.07 | -194.41 | -233.41 | -280.23 | -336.45 |
| Accounts Payable | - | 211.23 | 112.93 | 1,097.04 | 1,240.96 | 40.52 | 886.39 | 1,064.20 | 1,277.68 | 1,533.98 |
| Capital Expenditure | - | -25,760.56 | -296.20 | -2,970.82 | -11,952.74 | 15,014.83 | -2,029.80 | -2,436.98 | -2,925.84 | -3,512.76 |
| UFCF | 19,509.07 | -6,550.16 | 22,510.55 | 12,533.47 | 18,636.36 | 52,303.64 | 43,511.18 | 52,239.52 | 62,718.76 | 75,300.15 |
| WACC | ||||||||||
| PV UFCF | 52,303.64 | 43,511.18 | 52,239.52 | 62,718.76 | 75,300.15 | |||||
| SUM PV UFCF | - |