Free Cash Flow Build Up

Facebook Inc (FB)
$274.5
1.63 (+0.60%)
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 | 2024 Projected |
Revenue | 7,872.00 | 12,466.00 | 17,928.00 | 27,638.00 | 40,653.00 | 55,838.00 | 70,697.00 | 102,203.07 | 147,749.80 | 213,594.40 | 308,782.59 | 446,391.35 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
EBITDA | 3,835.00 | 6,263.00 | 8,228.00 | 14,946.00 | 23,631.00 | 29,898.00 | 30,678.00 | 51,685.03 | 74,718.43 | 108,016.64 | 156,154.18 | 225,744.19 |
EBIT | 2,824.00 | 5,020.00 | 6,283.00 | 12,604.00 | 20,606.00 | 25,583.00 | 24,937.00 | 42,132.51 | 60,908.84 | 88,052.82 | 127,293.51 | 184,021.77 |
Tax Rate | 45.53% | 40.12% | 40.46% | 18.38% | 22.63% | 12.81% | 25.50% | 29.35% | 29.35% | 29.35% | 29.35% | 29.35% |
EBIAT | 1,538.13 | 3,005.87 | 3,740.99 | 10,287.19 | 15,943.28 | 22,305.56 | 18,578.13 | 29,767.54 | 43,033.43 | 62,211.24 | 89,935.64 | 130,015.40 |
Depreciation | 1,011.00 | 1,243.00 | 1,945.00 | 2,342.00 | 3,025.00 | 4,315.00 | 5,741.00 | 9,552.51 | 13,809.58 | 19,963.82 | 28,860.68 | 41,722.42 |
Accounts Receivable | - | -518.00 | -881.00 | -1,434.00 | -1,839.00 | -1,755.00 | -1,931.00 | -4,836.28 | -6,396.98 | -9,247.79 | -13,369.05 | -19,326.96 |
Inventories | - | - | - | - | - | - | - | - | - | - | - | - |
Accounts Payable | - | 89.00 | 20.00 | 106.00 | 78.00 | 440.00 | 543.00 | -43.97 | 587.83 | 849.79 | 1,228.50 | 1,775.98 |
Capital Expenditure | -1,362.00 | -1,831.00 | -2,523.00 | -4,491.00 | -6,733.00 | -13,915.00 | -15,102.00 | -18,273.34 | -26,416.85 | -38,189.49 | -55,208.62 | -79,812.30 |
UFCF | 1,187.13 | 1,988.87 | 2,301.99 | 6,810.19 | 10,474.28 | 11,390.56 | 7,829.13 | 16,166.46 | 24,617.01 | 35,587.57 | 51,447.14 | 74,374.53 |
WACC | ||||||||||||
PV UFCF | 14,374.02 | 19,460.86 | 25,014.29 | 32,152.48 | 41,327.65 | |||||||
SUM PV UFCF | 132,329.31 |