ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABB
1
2
Dashboard
3
1
4
Key Inputs1
5
Units ($ in millions)
6
Company nameIntel Corporation
7
TickerINTC
8
Circuit breakerNo
9
Valuation date10/7/2024
10
Stub period23.1%
11
Latest shares of outstanding4,228,000,000
12
Md-year conventionNo
13
Fiscal year end12/30/2023
14
First fiscal year end12/30/2024
15
Date of latest 10K filing12/30/1899
16
Date of latest 10Q filing-
17
18
WACC Information
19
After tax cost of debt3.90%
20
Cost of equity9.02%
21
Weighted average cost of capital
8.05%
22
23
First year multiples
24
EV/EBITDA19.91 X
25
EV/EBIT2075.12 X
26
EV/Sales3.56 X
27
28
Other assumptions
29
Effective tax rate of Intel Corporation as of the latest filing
(119.8%)
30
Use growth or margins?Margins
31
32
33
Background and operations of Intel Corporation:
34
Intel is an industry leader, maybe not so now, and a catalyst for technology innovation and products that revolutionize
35
the way people live. The company is committed to harnessing the breadth and scale of its research to have a positive
36
impact on its consumers and partners. The company is currently trading at 95x earnings and reports revenues for
37
CCG, DCAI, NEX, Mobileye, and Intel Foundry Services. For its latest FY, the company reported $54BB in revenues, and
38
gross margins of 40%, as well as operating margins of 0.17% and net margins of 3%.
39
40
41
42
43
44
45
46
47
Case Manager
48
49
Active CaseBase Case
50
51
52
Output:
53
Share price as of the analysis $ 22.38
54
DCF value $ 38.84
55
Analysis Undervalued
56
Additional notes:
57
Hard inputs
58
Calculated values
59
Link to another sheet
60
Link in the same sheet
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100