ABCDEFGHIJK
1
2
3
#NAME?#NAME?
4
Weighted Average Cost of Capital#NAME?
5
NasdaqGS:AAPL5/11/2026
6
7
Model Summary
8
9
RangeSelected WACC
10
LowHighConclusion#VALUE!
11
12
Cost of Equity
13
Selected Beta#VALUE!#VALUE!#VALUE!#NAME?
14
Market Risk Premium5.5%6.0%5.8%
15
Risk-free Rate 2.5%3.0%2.8%
16
Additional Risk Adjustments#NAME?#NAME?#NAME?
17
 Implied Cost of Equity#VALUE!#VALUE!#VALUE!
18
19
Cost of Debt Inputs
20
Pre-tax Cost of Debt4.0%5.0%4.5%
21
Tax Rate26.0%26.0%26.0%
22
Debt % of Capital#VALUE!#VALUE!#VALUE!
23
 Implied Cost of Debt3.0%3.7%3.3%
24
25
WACC Range#VALUE!#VALUE!#VALUE!
26
27
28
Estimate Cost of Equity
29
30
Cost of EquityLowHighNotes
31
Selected Beta#VALUE!#VALUE!See Re-levered Beta Section
32
(x) Market Risk Premium5.5%6.0%Source Link
33
Adjusted Market Risk Premium#VALUE!#VALUE!
34
35
(+) Risk-free Rate 2.5%3.0%Source Link
36
(+) Additional Risk Adjustments#NAME?#NAME?
37
38
Cost of Equity#VALUE!#VALUE!
39
40
41
Select A Tax Rate
42
43
#NAME?Fiscal Year Ending
44
#NAME?#NAME?#NAME?#NAME?#NAME?
45
FY-4FY-3FY-2FY-1FY
46
47
Pre-tax Incomeebt#NAME?#NAME?#NAME?#NAME?#NAME?
48
Provision for Taxesinc_tax#NAME?#NAME?#NAME?#NAME?#NAME?
49
Net Income (Continuing Ops)#NAME?#NAME?#NAME?#NAME?#NAME?
50
51
Effective Tax RateNANANANANA
52
5-Year AverageNA
53
54
Selected Tax Rate26.0%
55
56
57
Estimate Cost of Debt
58
59
Cost of Debt BenchmarksNotes
60
61
5 Year Avg Effective Interest ExpNASee "Effective Interest Rate"
62
Synthetic Interest Rate Estimate3.3%See "Synthetic Interest Rate"
63
64
65
Cost of DebtLowHigh
66
Selected Long-term Debt4.0%5.0%
67
Tax Rate26.0%26.0%See Tax Rate Section
68
69
After-tax Cost of Debt3.0%3.7%
70
71
72
Select Debt & Equity Weights
73
74
Comparable CompaniesDebtMarket CapDebt / Total Capital
75
#NAME?#NAME?#NAME?NANA
76
#NAME?#NAME?#NAME?NANA
77
#NAME?#NAME?#NAME?NANA
78
#NAME?#NAME?#NAME?NANA
79
#NAME?#NAME?#NAME?NANA
80
#NAME?
NasdaqGS:AAPL
#NAME?NANA
81
82
AverageNA
83
84
85
LowHigh
86
Weights
87
Debt % of Capital#VALUE!#VALUE!
88
Equity % of Capital#VALUE!#VALUE!
89
90
91
Calculate a Weighted Average Range
92
93
Cost Estimates
94
Cost of Equity#VALUE!#VALUE!
95
After-tax Cost of Debt3.0%3.7%
96
97
Weights
98
Equity % of Capital#VALUE!#VALUE!
99
Debt % of Capital#VALUE!#VALUE!
100