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,825 | 66,001 | 74,989 | 90,272 | 110,855 | 136,819 | 161,857 | 182,527 | 214,238.47 | 251,459.35 | 295,146.84 | 346,424.40 | 406,610.71 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EBITDA | 17,905 | 21,475 | 24,423 | 29,860 | 33,093 | 36,559 | 46,012 | 54,921 | 65,129.29 | 76,444.57 | 89,725.73 | 105,314.30 | 123,611.16 |
| EBIT | 13,966 | 16,496 | 19,360 | 23,716 | 26,178 | 27,524 | 34,231 | 41,224 | 50,317.37 | 59,059.30 | 69,320.01 | 81,363.38 | 95,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.62 | 13,805.45 | 16,105.91 | 19,127.96 | 12,189.38 | 24,231.02 | 29,668.02 | 34,525.38 | 40,359.80 | 47,371.74 | 55,601.91 | 65,261.95 | 76,600.28 |
| Depreciation | 3,939 | 4,979 | 5,063 | 6,144 | 6,915 | 9,035 | 11,781 | 13,697 | 14,811.92 | 17,385.28 | 20,405.72 | 23,950.92 | 28,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 | - | -738 | 216 | 110 | 1,096 | 1,241 | 1,183 | 28 | 854.80 | 1,119.52 | 1,314.02 | 1,542.31 | 1,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.62 | 4,877.47 | 9,052.91 | 14,738.13 | 2,396.81 | 6,695.14 | 12,606.73 | 21,930.19 | 21,702.31 | 24,653.76 | 28,937 | 33,964.40 | 39,865.23 |
| WACC | |||||||||||||
| PV UFCF | 17,844.83 | 18,382.01 | 19,564.40 | 20,822.85 | 22,162.24 | ||||||||
| SUM PV UFCF | 108,930.54 |