Free Cash Flow Build Up
Apple Inc (AAPL)
$ 131.24
-1.755 (-1.32%)
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 | 170,910 | 182,795 | 233,715 | 215,639 | 229,234 | 265,595 | 260,174 | 274,515 | 295,187.38 | 317,416.49 | 341,319.57 | 367,022.68 | 394,661.36 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
EBITDA | 55,756 | 60,449 | 82,487 | 70,529 | 71,501 | 81,801 | 76,477 | 77,344 | 93,446.32 | 100,483.30 | 108,050.21 | 116,186.94 | 124,936.41 |
EBIT | 48,999 | 52,503 | 71,230 | 60,024 | 61,344 | 70,898 | 63,930 | 66,288 | 80,393.65 | 86,447.71 | 92,957.66 | 99,957.84 | 107,485.18 |
Tax Rate | 26.15% | 26.13% | 26.37% | 25.56% | 24.56% | 18.34% | 15.94% | 14.43% | 22.18% | 22.18% | 22.18% | 22.18% | 22.18% |
EBIAT | 36,183.35 | 38,786.03 | 52,447.83 | 44,683.51 | 46,280.07 | 57,893.76 | 53,737.10 | 56,723.86 | 62,558.60 | 67,269.58 | 72,335.32 | 77,782.54 | 83,639.96 |
Depreciation | 6,757 | 7,946 | 11,257 | 10,505 | 10,157 | 10,903 | 12,547 | 11,056 | 13,052.66 | 14,035.60 | 15,092.55 | 16,229.09 | 17,451.23 |
Accounts Receivable | - | -4,358 | 611 | 1,095 | -19,919 | -13,322 | 3,191 | 8,359 | 1,658.22 | -2,694.93 | -2,897.87 | -3,116.09 | -3,350.75 |
Inventories | - | -347 | -238 | 217 | -2,723 | 899 | -150 | 45 | 59.13 | -301.36 | -324.06 | -348.46 | -374.70 |
Accounts Payable | - | 7,829 | 5,294 | 1,804 | 11,755 | 6,839 | -9,652 | -3,940 | 8,514.63 | 3,826.30 | 4,114.44 | 4,424.28 | 4,757.45 |
Capital Expenditure | -8,165 | -9,571 | -11,247 | -12,734 | -12,795 | -13,313 | -10,495 | -7,309 | -14,029.26 | -15,085.74 | -16,221.77 | -17,443.35 | -18,756.92 |
UFCF | 34,775.35 | 40,285.03 | 58,124.84 | 45,570.51 | 32,755.07 | 49,899.76 | 49,178.10 | 64,934.86 | 71,813.97 | 67,049.45 | 72,098.62 | 77,528.01 | 83,366.27 |
WACC | |||||||||||||
PV UFCF | 56,540.69 | 46,840.71 | 44,692.15 | 42,642.15 | 40,686.17 | ||||||||
SUM PV UFCF | 260,789.91 |