Financial Modeling (AAPL)

Revenue

365,817.0394,328.0383,285.0388,377.9412,833.9433,371.0433,371.0433,371.0

Revenue % Chg.

33.3%7.8%-2.8%

EBIT

108,949.0119,437.0114,301.0120,218.4127,746.5135,390.9135,390.9135,390.9

EBIT Margin

29.8%30.3%29.8%

Tax Rate

13.3%16.2%14.7%

NOPAT

94,456.4100,083.097,476.9101,140.7107,458.0114,709.9114,709.9114,709.9

NOPAT Margin

25.8%25.4%25.4%26.0%26.0%26.5%26.5%26.5%

D&A

11,284.011,104.011,519.011,469.012,024.513,328.013,328.013,328.0

D&A / Revenue

3.1%2.8%3.0%

Capex

-11,085.0-10,708.0-10,959.0-10,422.0-11,121.4-10,922.9-10,922.9-10,922.9

Capex / Revenue

-3.0%-2.7%-2.9%

Chg. NWC

-4,911.01,200.0-6,577.0-3,565.5-3,790.0-3,978.5-3,978.5-3,978.5

Chg. NWC / Revenue

-1.3%0.3%-1.7%

Unlevered FCF (UFCF)

89,744.4101,679.091,459.998,622.2104,571.2113,136.5113,136.5113,136.5

UFCF % Chg.

35.6%13.3%-10.1%7.8%6.0%8.2%-0.0%

PV of UFCF

89,471.886,066.784,476.876,638.869,528.1

Sum of PV of UFCF

89,471.8175,538.5260,015.2336,654.1406,182.2
Cost of Debt
Tax Rate
After Tax Cost of Debt2.6%
Risk Free Rate
Market Risk Premium
Beta1.3
Cost of Equity10.6%
Total Debt123,930.0
Market Cap2,818,452.1
Total Capital2,942,382.1
Debt Weighting4.2%
Equity Weighting95.8%
WACC10.2%
Exit Multiple EV/FCF
Terminal Value2,753,917.1
PV of Terminal Value1,535,394.9
Cumulative PV of UFCF406,182.2
Net Debt-64,535.0
Equity Value2,006,112.1
Shares Outstanding15,441.9
Implied Share Price129.9
Current Share Price182.5
Implied Upside / (Downside)-28.8%