Discounted Cash Flow (DCF) Analysis Unlevered
Apple Inc (AAPL)
$117.51
1.53 (+1.32%)
Operating Data
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 | 170,910.00 | 182,795.00 | 233,715.00 | 215,639.00 | 229,234.00 | 265,595.00 | 260,174.00 | 280,641.66 | 302,719.50 | 326,534.19 | 352,222.35 | 379,931.38 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Revenue (%) | ||||||||||||
| EBITDA | 57,048.00 | 61,813.00 | 84,505.00 | 73,333.00 | 76,569.00 | 85,546.00 | 81,860.00 | 93,988.46 | 101,382.45 | 109,358.12 | 117,961.23 | 127,241.13 |
| EBITDA (%) | ||||||||||||
| EBIT | 50,291.00 | 53,867.00 | 73,248.00 | 62,828.00 | 66,412.00 | 74,643.00 | 69,313.00 | 81,420.88 | 87,826.19 | 94,735.40 | 102,188.15 | 110,227.20 |
| EBIT (%) | ||||||||||||
| Depreciation | 6,757.00 | 7,946.00 | 11,257.00 | 10,505.00 | 10,157.00 | 10,903.00 | 12,547.00 | 12,567.58 | 13,556.26 | 14,622.72 | 15,773.08 | 17,013.93 |
| Depreciation (%) |
Balance Sheet Data
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 |
| Total Cash | 40,546.00 | 25,077.00 | 41,601.00 | 67,155.00 | 74,181.00 | 66,301.00 | 100,557.00 | 73,110.34 | 78,861.86 | 85,065.86 | 91,757.92 | 98,976.43 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Total Cash (%) | ||||||||||||
| Account Receivables | 20,641.00 | 27,219.00 | 30,343.00 | 29,299.00 | 35,673.00 | 48,995.00 | 45,804.00 | 42,157.09 | 45,473.55 | 49,050.92 | 52,909.71 | 57,072.08 |
| Account Receivables (%) | ||||||||||||
| Inventories | 1,764.00 | 2,111.00 | 2,349.00 | 2,132.00 | 4,855.00 | 3,956.00 | 4,106.00 | 3,755.11 | 4,050.52 | 4,369.17 | 4,712.89 | 5,083.65 |
| Inventories (%) | ||||||||||||
| Accounts Payable | 22,367.00 | 30,196.00 | 35,490.00 | 37,294.00 | 44,242.00 | 55,888.00 | 46,236.00 | 48,190.00 | 51,981.06 | 56,070.37 | 60,481.38 | 65,239.40 |
| Accounts Payable (%) | ||||||||||||
| Capital Expenditure | -9,076.00 | -9,813.00 | -11,488.00 | -12,734.00 | -12,451.00 | -13,313.00 | -10,495.00 | -14,423.88 | -15,558.60 | -16,782.58 | -18,102.85 | -19,526.99 |
| Capital Expenditure (%) |
Weighted Average Cost Of Capital
| Share price | $ 117.51 |
|---|---|
| Beta | 1.339 |
| Diluted Shares Outstanding | 18,595.65 |
| Cost of Debt | |
| Tax Rate | 15.94 |
| After-tax Cost of Debt | 4.20% |
| Risk-Free Rate | |
| Market Risk Premium | |
| Cost of Equity | 13.120 |
| Total Debt | 108,047.00 |
| Total Equity | 2,185,175.07 |
| Total Capital | 2,293,222.07 |
| Debt Weighting | 4.71 |
| Equity Weighting | 95.29 |
| Wacc |
Build Up Free Cash
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 | 170,910.00 | 182,795.00 | 233,715.00 | 215,639.00 | 229,234.00 | 265,595.00 | 260,174.00 | 280,641.66 | 302,719.50 | 326,534.19 | 352,222.35 | 379,931.38 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EBITDA | 57,048.00 | 61,813.00 | 84,505.00 | 73,333.00 | 76,569.00 | 85,546.00 | 81,860.00 | 93,988.46 | 101,382.45 | 109,358.12 | 117,961.23 | 127,241.13 |
| EBIT | 50,291.00 | 53,867.00 | 73,248.00 | 62,828.00 | 66,412.00 | 74,643.00 | 69,313.00 | 81,420.88 | 87,826.19 | 94,735.40 | 102,188.15 | 110,227.20 |
| Tax Rate | 26.15% | 26.13% | 26.37% | 25.56% | 24.56% | 18.34% | 15.94% | 23.29% | 23.29% | 23.29% | 23.29% | 23.29% |
| EBIAT | 37,137.43 | 39,793.68 | 53,933.72 | 46,770.89 | 50,103.55 | 60,951.85 | 58,261.85 | 62,455.74 | 67,369.08 | 72,668.94 | 78,385.75 | 84,552.29 |
| Depreciation | 6,757.00 | 7,946.00 | 11,257.00 | 10,505.00 | 10,157.00 | 10,903.00 | 12,547.00 | 12,567.58 | 13,556.26 | 14,622.72 | 15,773.08 | 17,013.93 |
| Accounts Receivable | - | -6,578.00 | -3,124.00 | 1,044.00 | -6,374.00 | -13,322.00 | 3,191.00 | 3,646.91 | -3,316.46 | -3,577.37 | -3,858.79 | -4,162.36 |
| Inventories | - | -347.00 | -238.00 | 217.00 | -2,723.00 | 899.00 | -150.00 | 350.89 | -295.41 | -318.65 | -343.72 | -370.76 |
| Accounts Payable | - | 7,829.00 | 5,294.00 | 1,804.00 | 6,948.00 | 11,646.00 | -9,652.00 | 1,954.00 | 3,791.07 | 4,089.31 | 4,411.01 | 4,758.02 |
| Capital Expenditure | -9,076.00 | -9,813.00 | -11,488.00 | -12,734.00 | -12,451.00 | -13,313.00 | -10,495.00 | -14,423.88 | -15,558.60 | -16,782.58 | -18,102.85 | -19,526.99 |
| UFCF | 34,818.43 | 38,830.67 | 55,634.72 | 47,606.89 | 45,660.55 | 57,764.85 | 53,702.85 | 66,551.23 | 65,545.93 | 70,702.37 | 76,264.47 | 82,264.13 |
| WACC | ||||||||||||
| PV UFCF | 59,051.67 | 51,605.73 | 49,392.64 | 47,274.46 | 45,247.12 | |||||||
| SUM PV UFCF | 252,571.61 |
Terminal Value
| Growth in perpetuity method: | |
|---|---|
| Long-term growth rate | |
| WACC (%) | 12.70 |
| Free cash flow (t + 1) | 85,554.69 |
| Terminal Value | 983,387.26 |
| Present Value of Terminal Value | 540,885.07 |
Intrinsic Value
| Enterprise Value | 793,456.68 |
|---|---|
| Net Debt | 59,203.00 |
| Equity Value | 734,253.68 |
| Shares Outstanding | 18,595.65 |
| Equity Value Per Share | 39.49 |