Free Cash Flow Build Up
Facebook Inc (FB)
$ 311.54
-0.92 (-0.29%)
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 | 7,872 | 12,466 | 17,928 | 27,638 | 40,653 | 55,838 | 70,697 | 85,965 | 121,454.54 | 171,595.49 | 242,436.47 | 342,523.25 | 483,929.56 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EBITDA | 3,815 | 6,237 | 8,170 | 14,769 | 23,228 | 29,228 | 29,727 | 39,533 | 59,971.33 | 84,729.72 | 119,709.30 | 169,129.74 | 238,952.78 |
| EBIT | 2,804 | 4,994 | 6,225 | 12,427 | 20,203 | 24,913 | 23,986 | 32,671 | 48,826.58 | 68,984.01 | 97,463.17 | 137,699.58 | 194,547.08 |
| Tax Rate | 45.53% | 40.12% | 40.46% | 18.38% | 22.63% | 12.81% | 25.50% | 12.16% | 27.20% | 27.20% | 27.20% | 27.20% | 27.20% |
| EBIAT | 1,527.23 | 2,990.30 | 3,706.46 | 10,142.73 | 15,631.48 | 21,721.39 | 17,869.63 | 28,698.88 | 35,546.20 | 50,220.99 | 70,954.08 | 100,246.56 | 141,632.06 |
| Depreciation | 1,011 | 1,243 | 1,945 | 2,342 | 3,025 | 4,315 | 5,741 | 6,862 | 11,144.75 | 15,745.72 | 22,246.13 | 31,430.16 | 44,405.70 |
| Accounts Receivable | - | -518 | -881 | -1,434 | -1,839 | -1,755 | -1,931 | -1,817 | -5,592.68 | -6,988.37 | -9,873.43 | -13,949.55 | -19,708.45 |
| Inventories | - | - | - | - | - | - | - | - | - | - | - | - | - |
| Accounts Payable | - | 89 | 20 | 106 | 78 | 440 | 543 | -32 | 275.62 | 663.27 | 937.09 | 1,323.96 | 1,870.54 |
| Capital Expenditure | -1,362 | -1,831 | -2,523 | -4,491 | -6,733 | -13,915 | -15,102 | -15,115 | -21,670.35 | -30,616.68 | -43,256.38 | -61,114.22 | -86,344.44 |
| UFCF | 1,176.23 | 1,973.30 | 2,267.46 | 6,665.73 | 10,162.48 | 10,806.39 | 7,120.63 | 18,596.88 | 19,703.54 | 29,024.93 | 41,007.49 | 57,936.91 | 81,855.42 |
| WACC | |||||||||||||
| PV UFCF | 15,571 | 20,390.57 | 25,609.88 | 32,165.16 | 40,398.38 | ||||||||
| SUM PV UFCF | 150,888.45 |