Free Cash Flow Build Up
Alphabet Inc. (GOOG)
$2036.86
5.5 (+0.27%)
Year A/P | 2015 Actual | 2016 Actual | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Projected | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected |
Revenue | 74,989.00 | 90,272.00 | 110,855.00 | 136,819.00 | 161,857.00 | 182,527.00 | 218,183.15 | 260,804.62 | 311,752.08 | 372,651.99 | 445,448.53 |
---|---|---|---|---|---|---|---|---|---|---|---|
EBITDA | 24,818.00 | 30,418.00 | 24,393.00 | 44,062.00 | 51,506.00 | 54,129.00 | 66,355.94 | 79,318.39 | 94,813.02 | 113,334.48 | 135,474.06 |
EBIT | 19,755.00 | 24,274.00 | 17,478.00 | 35,027.00 | 39,725.00 | 41,224.00 | 51,538.37 | 61,606.25 | 73,640.86 | 88,026.39 | 105,222.11 |
Tax Rate | 16.81% | 19.35% | 53.44% | 11.96% | 13.33% | 16.25% | 21.86% | 21.86% | 21.86% | 21.86% | 21.86% |
EBIAT | 16,434.52 | 19,578.01 | 8,138.36 | 30,836.36 | 34,429.67 | 34,525.38 | 40,274.32 | 48,141.80 | 57,546.16 | 68,787.65 | 82,225.13 |
Depreciation | 5,063.00 | 6,144.00 | 6,915.00 | 9,035.00 | 11,781.00 | 12,905.00 | 14,817.57 | 17,712.15 | 21,172.17 | 25,308.09 | 30,251.96 |
Accounts Receivable | - | -323.00 | -4,473.00 | -2,488.00 | -6,299.00 | -3,438.00 | -5,654.86 | -7,146.75 | -8,542.85 | -10,211.67 | -12,206.49 |
Inventories | - | - | -481.00 | -358.00 | 108.00 | 271.00 | -492.82 | -238.48 | -285.07 | -340.76 | -407.33 |
Accounts Payable | - | 110.00 | 1,096.00 | 1,241.00 | 1,183.00 | 28.00 | 725.01 | 1,233.42 | 1,474.37 | 1,762.38 | 2,106.66 |
Capital Expenditure | -9,915.00 | -10,212.00 | -13,184.00 | -25,139.00 | -23,548.00 | -22,281.00 | -29,657.25 | -35,450.71 | -42,375.91 | -50,653.93 | -60,549.03 |
UFCF | 11,582.52 | 15,297.01 | -1,988.64 | 13,127.36 | 17,654.67 | 22,010.38 | 20,011.98 | 24,251.42 | 28,988.87 | 34,651.77 | 41,420.89 |
WACC | |||||||||||
PV UFCF | 20,011.98 | 21,950.96 | 23,750.02 | 25,696.52 | 27,802.56 | ||||||
SUM PV UFCF | 107,903.73 |