Discounted Cash Flow (DCF) Analysis Unlevered

Apple Inc

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.00182,795.00233,715.00215,639.00229,234.00265,595.00260,174.00280,641.66302,719.50326,534.19352,222.35379,931.38
Revenue (%)
EBITDA 57,048.0061,813.0084,505.0073,333.0076,569.0085,546.0081,860.0093,988.46101,382.45109,358.12117,961.23127,241.13
EBITDA (%)
EBIT 50,291.0053,867.0073,248.0062,828.0066,412.0074,643.0069,313.0081,420.8887,826.1994,735.40102,188.15110,227.20
EBIT (%)
Depreciation 6,757.007,946.0011,257.0010,505.0010,157.0010,903.0012,547.0012,567.5813,556.2614,622.7215,773.0817,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.0025,077.0041,601.0067,155.0074,181.0066,301.00100,557.0073,110.3478,861.8685,065.8691,757.9298,976.43
Total Cash (%)
Account Receivables 20,641.0027,219.0030,343.0029,299.0035,673.0048,995.0045,804.0042,157.0945,473.5549,050.9252,909.7157,072.08
Account Receivables (%)
Inventories 1,764.002,111.002,349.002,132.004,855.003,956.004,106.003,755.114,050.524,369.174,712.895,083.65
Inventories (%)
Accounts Payable 22,367.0030,196.0035,490.0037,294.0044,242.0055,888.0046,236.0048,190.0051,981.0656,070.3760,481.3865,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.00182,795.00233,715.00215,639.00229,234.00265,595.00260,174.00280,641.66302,719.50326,534.19352,222.35379,931.38
EBITDA 57,048.0061,813.0084,505.0073,333.0076,569.0085,546.0081,860.0093,988.46101,382.45109,358.12117,961.23127,241.13
EBIT 50,291.0053,867.0073,248.0062,828.0066,412.0074,643.0069,313.0081,420.8887,826.1994,735.40102,188.15110,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.4339,793.6853,933.7246,770.8950,103.5560,951.8558,261.8562,455.7467,369.0872,668.9478,385.7584,552.29
Depreciation 6,757.007,946.0011,257.0010,505.0010,157.0010,903.0012,547.0012,567.5813,556.2614,622.7215,773.0817,013.93
Accounts Receivable --6,578.00-3,124.001,044.00-6,374.00-13,322.003,191.003,646.91-3,316.46-3,577.37-3,858.79-4,162.36
Inventories --347.00-238.00217.00-2,723.00899.00-150.00350.89-295.41-318.65-343.72-370.76
Accounts Payable -7,829.005,294.001,804.006,948.0011,646.00-9,652.001,954.003,791.074,089.314,411.014,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.4338,830.6755,634.7247,606.8945,660.5557,764.8553,702.8566,551.2365,545.9370,702.3776,264.4782,264.13
WACC
PV UFCF 59,051.6751,605.7349,392.6447,274.4645,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