Free Cash Flow Build Up
Facebook Inc. (FB)
$156.79
-6.55 (-4.01%)
Year A/P | 2013 Actual | 2014 Actual | 2015 Actual | 2016 Actual | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Projected | 2021 Projected | 2022 Projected | 2023 Projected |
| Revenue | 7,872.00 | 12,466.10 | 17,928.74 | 27,638.95 | 40,654.13 | 55,838.45 | 70,697.07 | 102,199.68 | 147,739.85 | 213,572.73 | 308,740.74 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| EBITDA | 3,814.77 | 6,236.79 | 8,170.13 | 14,770.26 | 23,229.77 | 29,225.85 | 29,728.12 | 50,956.76 | 73,663.09 | 106,487.36 | 153,938.13 |
| EBIT | 2,804.01 | 4,993.92 | 6,224.86 | 12,429.24 | 20,205.10 | 24,909.53 | 23,987.51 | 41,401.09 | 59,849.41 | 86,518.31 | 125,070.87 |
| Tax Rate | 45.53% | 40.12% | 40.46% | 18.38% | 22.63% | 12.81% | 25.50% | 29.35% | 29.35% | 29.35% | 29.35% |
| EBIAT | 1,527.24 | 2,990.25 | 3,706.37 | 10,144.55 | 15,633.10 | 21,718.37 | 17,870.76 | 29,250.77 | 42,284.92 | 61,127.08 | 88,365.30 |
| Depreciation | 1,010.76 | 1,242.87 | 1,945.27 | 2,341.02 | 3,024.67 | 4,316.31 | 5,740.60 | 9,555.67 | 13,813.68 | 19,969.05 | 28,867.26 |
| Accounts Receivable | - | -568.77 | -880.49 | -1,435.40 | -1,840.04 | -1,754.58 | -1,927.38 | -4,741.03 | -6,352.85 | -9,183.69 | -13,275.94 |
| Inventories | - | - | - | - | - | - | - | - | - | - | - |
| Accounts Payable | - | 88.39 | 19.65 | 105.84 | 76.82 | 442.74 | 543.63 | -46.08 | 587.47 | 849.24 | 1,227.67 |
| Capital Expenditure | - | -469.41 | -691.30 | -1,968.76 | -2,240.99 | -7,182.62 | -1,185.95 | -3,172.41 | -8,142.58 | -11,770.92 | -17,016.04 |
| UFCF | 2,538.00 | 3,283.33 | 4,099.50 | 9,187.26 | 14,653.56 | 17,540.23 | 21,041.66 | 30,846.93 | 42,190.62 | 60,990.77 | 88,168.25 |
| WACC | |||||||||||
| PV UFCF | 30,846.93 | 42,190.62 | 60,990.77 | 88,168.25 | |||||||
| SUM PV UFCF | 294,540.09 |