Free Cash Flow Build Up
Facebook Inc (FB)
$281.61
13.94 (+5.21%)
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,821.00 | 6,176.00 | 8,162.00 | 14,870.00 | 23,625.00 | 29,685.00 | 30,573.00 | 51,383.73 | 74,282.86 | 107,386.96 | 155,243.89 | 224,428.22 |
| EBIT | 2,810.00 | 4,933.00 | 6,217.00 | 12,528.00 | 20,600.00 | 25,370.00 | 24,832.00 | 41,831.22 | 60,473.27 | 87,423.15 | 126,383.21 | 182,705.80 |
| 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,530.50 | 2,953.77 | 3,701.69 | 10,225.16 | 15,938.64 | 22,119.85 | 18,499.90 | 29,554.67 | 42,725.69 | 61,766.36 | 89,292.50 | 129,085.64 |
| 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 | - | -569.00 | -881.00 | -1,434.00 | -1,839.00 | -1,755.00 | -1,931.00 | -4,741.69 | -6,354.82 | -9,186.84 | -13,280.96 | -19,199.61 |
| Inventories | - | - | - | - | - | - | - | - | - | - | - | - |
| Accounts Payable | - | 110.00 | 35.00 | 169.00 | 188.00 | 591.00 | 888.00 | 431.47 | 1,194.55 | 1,726.90 | 2,496.49 | 3,609.05 |
| 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,179.50 | 1,906.77 | 2,277.69 | 6,811.16 | 10,579.64 | 11,355.85 | 8,095.90 | 16,523.62 | 24,958.15 | 36,080.74 | 52,160.09 | 75,405.20 |
| WACC | ||||||||||||
| PV UFCF | 14,677.22 | 19,692.01 | 25,286.67 | 32,470.83 | 41,696.07 | |||||||
| SUM PV UFCF | 133,822.80 |