ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAG
1
2
3
4
Strategic Investment Fund Notional Accounts Structure
5
20
Years
21
123456789101112131415161718192021222324252627282930
22
 Principal Account Balance$50,000$52,413$54,941$57,592$60,371$63,284$66,338$69,538$72,894$76,411$80,097$83,962$88,013$92,260$96,712$101,378$106,269$111,397$116,772$122,406$128,312$134,503$140,993$147,796$154,927$162,402$170,238$178,452$187,062$196,088
23
Expected Return$3,350$3,512$3,681$3,859$4,045$4,240$4,445$4,659$4,884$5,120$5,367$5,625$5,897$6,181$6,480$6,792$7,120$7,464$7,824$8,201$8,597$9,012$9,447$9,902$10,380$10,881$11,406$11,956$12,533$13,138
24
Operating Cost($100)($105)($110)($115)($121)($127)($133)($139)($146)($153)($160)($168)($176)($185)($193)($203)($213)($223)($234)($245)($257)($269)($282)($296)($310)($325)($340)($357)($374)($392)
25
Contribution to Strategic Account($838)($878)($920)($965)($1,011)($1,060)($1,111)($1,165)($1,221)($1,280)($1,342)($1,406)($1,474)($1,545)($1,620)($1,698)($1,780)($1,866)($1,956)($2,050)($2,149)($2,253)($2,362)($2,476)($2,595)($2,720)($2,851)($2,989)($3,133)($3,284)
26
End-of-year Balance$52,413$54,941$57,592$60,371$63,284$66,338$69,538$72,894$76,411$80,097$83,962$88,013$92,260$96,712$101,378$106,269$111,397$116,772$122,406$128,312$134,503$140,993$147,796$154,927$162,402$170,238$178,452$187,062$196,088$205,549
27
28
Strategic Account Balance$0$854$1,745$2,691$3,696$4,763$5,895$7,094$8,365$9,712$11,137$12,646$14,242$15,930$17,714$19,600$21,592$23,696$25,917$28,262$30,736$33,346$36,099$39,003$42,063$45,289$48,689$52,271$56,044$60,018
29
Strategic Account Contribution$838 $878 $920 $965 $1,011 $1,060 $1,111 $1,165 $1,221 $1,280 $1,342 $1,406 $1,474 $1,545 $1,620 $1,698 $1,780 $1,866 $1,956 $2,050 $2,149 $2,253 $2,362 $2,476 $2,595 $2,720 $2,851 $2,989 $3,133 $3,284
30
Operating Cost$0 ($4)($9)($13)($18)($24)($29)($35)($42)($49)($56)($63)($71)($80)($89)($98)($108)($118)($130)($141)($154)($167)($180)($195)($210)($226)($243)($261)($280)($300)
31
Expected Return$17$17$35$54$74$95$118$142$167$194$223$253$285$319$354$392$432$474$518$565$615$667$722$780$841$906$974$1,045$1,121$1,200
32
End-of-year Balance$854$1,745$2,691$3,696$4,763$5,895$7,094$8,365$9,712$11,137$12,646$14,242$15,930$17,714$19,600$21,592$23,696$25,917$28,262$30,736$33,346$36,099$39,003$42,063$45,289$48,689$52,271$56,044$60,018$64,202
33
Total EOY Fund Balance$53,267$56,686$60,284$64,068$68,047$72,232$76,632$81,259$86,122$91,235$96,608$102,255$108,190$114,426$120,978$127,861$135,093$142,689$150,668$159,048$167,849$177,092$186,798$196,990$207,691$218,927$230,723$243,106$256,106$269,752
34
FTE Total Estimate 50 55 59 64 70 75 81 87 94 101 108 116 124 132 141 150 160 171 182 193 205 218 231 245 260 276 292 309 327 346
35
36
37
38
39
Notes:
1. Ungroup rows 2-7 to toggle assumptions.
40
Princpal Account Balance
2. Try seeding the Principal versus the Strategic account with different amounts.
41
Strategic Account Balance
3. Look at what happens if you change the expected rate of return.
42
4. Think about whether the operating costs should be higher for a government-owned entity.
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
Strategic$854$1,745$2,691$3,696$4,763$5,895$7,094$8,365$9,712$11,137$12,646$14,242$15,930$17,714$19,600$21,592$23,696$25,917$28,262$30,736$33,346$36,099$39,003$42,063$45,289$48,689$52,271$56,044$60,018$64,202
69
Principal$52,413$54,941$57,592$60,371$63,284$66,338$69,538$72,894$76,411$80,097$83,962$88,013$92,260$96,712$101,378$106,269$111,397$116,772$122,406$128,312$134,503$140,993$147,796$154,927$162,402$170,238$178,452$187,062$196,088$205,549
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
101
102
103
104
105
106
107
108
109
110
111
112
113
114