ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
4
INVESTMENT MANAGEMENT ACADEMY
5
#NAME?
6
7
8
November 7, 2026
9
10
Analyst Team
11
John Bezaitis | jackb8@illinois.edu
12
Sophie Hahn | shahn7@illinois.edu
13
14
Input Ticker Below
15
#VALUE!#NAME?
16
17
Guidelines
18
1. Use Notes (Alt + R + T + N)
(Alt + R + T + E to edit / read notes)
19
2. Add y/y, 2y stack, margins, q/q, moving average growth rates to analyze
20
3. Add lines for consensus / notes for guidance to help benchmark
21
4. For historicals, pull data where you can, hardcode where you can't. All presented data should be on the model. Factset is good for pulling adjusted reconciliations, CapIQ / bloomberg for the rest
22
5. When company prints, add section to the variance analysis
23
6. Enable Iterative Calculations
24
25
Formatting / Colors
26
BlueActual / Hardcoded
27
GreenLinked
28
BlackFormula
29
RedConsensus
30
Input / Assumption / Driver
31
(10%)Growth Rates Italicized, negatives ()
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
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