| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | NYCERS | 2013 | 2012 | 2011 | 2010 | 2009 | 2008 | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 | 2001 | 2000 | 1999 | 1998 | 1997 | ||
2 | (Income Statement) | NYCERS | NYCERS | NYCERS | NYCERS | NYCERS | ||||||||||||||
3 | (in millions) | |||||||||||||||||||
4 | employee contributions | $437.80 | $403.6 | $413.7 | $399.0 | $382.4 | $366.1 | $351.1 | $341.6 | $310.8 | $298.3 | $309.8 | $326.4 | $324.2 | $316.4 | |||||
5 | employer contributions | $3,046.80 | $3,017.0 | $2,387.2 | $2,197.7 | $2,150.5 | $1,874.2 | $1,471.0 | $1,024.4 | $822.8 | $310.6 | $108.0 | $105.7 | $100.0 | $68.6 | |||||
6 | other contributions | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | |||||||||||||
7 | interest | $624.70 | $528.0 | $492.2 | $572.7 | $690.3 | $693.2 | $709.2 | $647.3 | $585.6 | $620.0 | $637.4 | $782.7 | $1,245.6 | $1,162.5 | |||||
8 | dividends | $696.70 | $637.1 | $619.9 | $490.1 | $491.2 | $600.2 | $1,181.5 | $335.8 | $416.8 | $359.4 | $317.7 | $328.3 | $279.1 | $314.3 | |||||
9 | SI income | $27.80 | $25.0 | $23.4 | $22.7 | $46.8 | $49.3 | $20.1 | $19.0 | $24.4 | $13.2 | ($18.6) | $24.7 | * | nr | |||||
10 | other | $5.10 | $4.8 | $4.7 | $4.7 | $3.7 | $3.1 | $3.0 | $2.9 | $33.3 | $10.2 | $7.3 | $2.8 | $3.3 | $0.7 | |||||
11 | Cash-in | $4,838.9 | $4,615.5 | $3,941.1 | $3,686.9 | $3,764.9 | $3,586.1 | $3,735.9 | $2,371.0 | $2,193.7 | $1,611.7 | $1,361.6 | $1,570.6 | $1,952.2 | $1,862.5 | |||||
12 | ||||||||||||||||||||
13 | Benefits | $3,868.80 | $3,706.6 | $3,585.5 | $3,390.1 | $3,265.0 | $3,110.3 | $3,228.1 | $2,972.5 | $2,858.3 | $2,742.5 | $2,809.2 | $2,529.4 | $2,437.1 | $2,218.4 | |||||
14 | Investment expenses | $183.30 | $129.5 | $145.1 | $175.3 | $138.2 | $115.3 | $98.1 | $69.4 | $53.9 | $35.1 | $29.3 | $37.6 | $41.3 | $32.5 | |||||
15 | Admin expenses | $48.70 | $51.4 | $46.4 | $49.7 | $48.8 | $47.0 | $41.7 | $40.3 | $37.3 | $35.6 | $34.1 | $31.5 | $31.6 | $23.3 | |||||
16 | Cash-out | $4,100.8 | $3,887.5 | $3,777.0 | $3,615.1 | $3,452.0 | $3,272.6 | $3,367.9 | $3,082.2 | $2,949.5 | $2,813.2 | $2,872.6 | $2,598.5 | $2,510.0 | $2,274.2 | |||||
17 | ||||||||||||||||||||
18 | Net Cash | $738.1 | $728.0 | $164.1 | $71.8 | $312.9 | $313.5 | $368.0 | ($711.2) | ($755.8) | ($1,201.5) | ($1,511.0) | ($1,027.9) | ($557.8) | ($411.7) | ($324.51) | ||||
19 | ||||||||||||||||||||
20 | Opening Balance | $42,655.30 | $42,409.1 | $35,383.8 | $31,903.4 | $39,716.8 | $42,514.3 | $37,288.2 | $35,526.3 | $34,178.2 | $31,524.7 | $32,842.0 | $38,113.6 | $42,824.0 | $41,930.2 | |||||
21 | (a) Close Balance | $47,194.60 | $42,655.3 | $42,409.1 | $35,383.8 | $31,903.4 | $39,716.8 | $42,514.3 | $37,288.2 | $35,526.3 | $34,178.2 | $31,524.7 | $32,842.0 | $37,251.8 | $42,824.0 | |||||
22 | 0.581% | 19.855% | 10.909% | -19.673% | -6.580% | 14.015% | 4.959% | 3.944% | 8.417% | -4.011% | -13.831% | -13.012% | 2.132% | 0.593% | ||||||
23 | ||||||||||||||||||||
24 | (b) -- Change in Closing Balance | $4,539.30 | $246.20 | $7,025.30 | $3,480.40 | ($7,813.40) | ($2,797.50) | $5,226.10 | $1,761.90 | $1,348.10 | $2,653.50 | ($1,317.30) | ($5,271.60) | ($5,572.20) | $893.80 | ($10.52) | ||||
25 | Total Change Over 14 Years | $4,402.60 | ||||||||||||||||||
26 | ||||||||||||||||||||
27 | Actual vs Index/Core | |||||||||||||||||||
28 | Opening Balance | $42,655.30 | $42,409.10 | $35,383.8 | $31,903.4 | $39,716.8 | $42,514.3 | $37,288.2 | $35,526.3 | $34,178.2 | $31,524.7 | $32,842.0 | $38,113.6 | $42,824.0 | $41,930.2 | |||||
29 | Net Cash - negative | $0.00 | $0.00 | 0 | 0 | 0 | 0 | $0.00 | ($711.2) | ($755.8) | ($1,201.5) | ($1,511.0) | ($1,027.9) | ($557.8) | ($411.7) | |||||
30 | (c) -- Adj Balance | $42,655.3 | $42,409.1 | $35,383.8 | $31,903.4 | $39,716.8 | $42,514.3 | $37,288.2 | $34,815.1 | $33,422.4 | $30,323.2 | $31,331.0 | $37,085.7 | $42,266.2 | $41,518.5 | |||||
31 | Blendedn Market % | 12.26% | 5.01% | 20.94% | 11.63% | -17.50% | -8.10% | 14.75% | 4.23% | 5.56% | 12.08% | 2.36% | -10.82% | -7.58% | 5.52% | |||||
32 | Adj. Bal Market Incr | $5,229.6 | $2,122.9 | $7,407.7 | $3,709.9 | ($6,952.3) | ($3,443.1) | $5,499.2 | $1,471.4 | $1,857.6 | $3,662.3 | $738.7 | ($4,010.9) | ($3,205.4) | $2,290.5 | |||||
33 | Net Cash - positive | $738.1 | $728.0 | $164.1 | $71.8 | $312.9 | $313.5 | $368.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | |||||
34 | (d) -- Expected Change in Closing Bal | $5,967.67 | $2,850.89 | $7,571.84 | $3,781.72 | ($6,639.40) | ($3,129.64) | $5,867.18 | $1,471.37 | $1,857.61 | $3,662.28 | $738.65 | ($4,010.90) | ($3,205.44) | $2,290.53 | |||||
35 | ||||||||||||||||||||
36 | Actual Closing Bal. | $47,194.6 | $42,655.3 | $42,409.1 | $35,383.8 | $31,903.4 | $39,716.8 | $42,514.3 | $37,288.2 | $35,526.3 | $34,178.2 | $31,524.7 | $32,842.0 | $37,251.8 | $42,824.0 | |||||
37 | (c)+(d) -- Expected Closing Bal. | $48,623.0 | $45,260.0 | $42,955.6 | $35,685.1 | $33,077.4 | $39,384.7 | $43,155.4 | $36,286.5 | $35,280.0 | $33,985.5 | $32,069.7 | $33,074.8 | $39,060.8 | $43,809.0 | |||||
38 | ||||||||||||||||||||
39 | Actual Profit/(Loss) vs S&P 500 Stock Index/Core Bond Index | ($1,428.37) | ($2,604.69) | ($546.54) | ($301.32) | ($1,174.00) | $332.14 | ($641.08) | $290.53 | ($509.51) | ($1,008.78) | ($2,055.95) | ($1,260.70) | ($2,366.76) | ($1,396.73) | ($13,243.4) | ||||
40 | loss | loss | loss | up | loss | up | up | up | up | up | up | up | loss | loss | ||||||
41 | Diff:Actual return vs inde/core return | -3.027% | -6.106% | -1.289% | -0.852% | -3.680% | 0.836% | -1.508% | 0.779% | -1.434% | -2.952% | -6.522% | -3.839% | -6.353% | -3.262% | |||||
42 | Average Difference | -2.800% | ||||||||||||||||||
43 | ||||||||||||||||||||
44 | Index/Core Portfolio Simulated | |||||||||||||||||||
45 | Open Balance | $50,984.5 | $47,766.0 | $39,266.2 | $34,981.3 | $41,893.5 | $45,151.4 | $38,968.4 | $38,061.6 | $36,790.7 | $34,023.1 | $34,751.1 | $39,984.7 | $43,811.5 | $41,930.2 | |||||
46 | Net Cash - negative | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ($711.20) | ($755.80) | ($1,201.50) | ($1,511.00) | ($1,027.90) | ($557.80) | ($411.70) | |||||
47 | Adj Balance | $50,984.5 | $47,766.0 | $39,266.2 | $34,981.3 | $41,893.5 | $45,151.4 | $38,968.4 | $37,350.4 | $36,034.9 | $32,821.6 | $33,240.1 | $38,956.8 | $43,253.7 | $41,518.5 | |||||
48 | Blendedn Market % | 0.1226 | 0.0501 | 0.2094 | 0.1163 | -0.1750 | -0.0810 | 0.1475 | 0.0423 | 0.0556 | 0.1208 | 0.0236 | -0.1082 | -0.0758 | 0.0552 | |||||
49 | Adj. Bal Market Incr | $6,250.7 | $2,391.0 | $8,220.5 | $4,067.8 | ($7,333.3) | ($3,656.7) | $5,747.0 | $1,578.5 | $2,002.8 | $3,964.0 | $783.7 | ($4,213.3) | ($3,280.3) | $2,290.5 | |||||
50 | Net Cash - positive | $738.10 | $728.00 | $164.10 | $71.80 | $312.90 | $313.50 | $368.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
51 | Invst Expense Adj | $153.3 | $99.5 | $115.1 | $145.3 | $108.2 | $85.3 | $68.1 | $39.4 | $23.9 | $5.1 | -$0.70 | $7.6 | $11.3 | $2.5 | |||||
52 | (b) Expected Change in Closing Bal | $7,142.1 | $3,218.5 | $8,499.7 | $4,284.9 | ($6,912.2) | ($3,257.9) | $6,183.1 | $1,617.9 | $2,026.7 | $3,969.1 | $783.0 | ($4,205.7) | ($3,269.0) | $2,293.0 | |||||
53 | Closing Balance | $58,126.6 | $50,984.5 | $47,766.0 | $39,266.2 | $34,981.3 | $41,893.5 | $45,151.4 | $38,968.4 | $38,061.6 | $36,790.7 | $34,023.1 | $34,751.1 | $39,984.7 | $43,811.5 | |||||
54 | ||||||||||||||||||||
55 | S&P 500 Index June 30 | 1606.28 | 1362.16 | 1320.64 | 1030.71 | 919.32 | 1280 | 1503.35 | 1270.2 | 1191.33 | 1140.84 | 974.5 | 989.82 | 1224.38 | 1454.6 | 1372.71 | ||||
56 | Change for Year | 1.1792 | 1.0314 | 1.2813 | 1.1212 | 0.7182 | 0.8514 | 1.1836 | 1.0662 | 1.0443 | 1.1707 | 0.9845 | 0.8084 | 0.8417 | 1.0597 | |||||
57 | 17.9% | 3.1% | 28.1% | 12.1% | -28.2% | -14.9% | 18.4% | 6.6% | 4.4% | 17.1% | -1.5% | -19.2% | -15.8% | 6.0% | ||||||
58 | Equity Allocation | 0.7000 | 0.7000 | 0.7000 | 0.7000 | 0.7000 | 0.7000 | 0.7000 | 0.7000 | 0.7000 | 0.7000 | 0.7000 | 0.7000 | 0.7000 | 0.7000 | |||||
59 | Equity % of Change | 0.1255 | 0.0220 | 0.1969 | 0.0848 | -0.1972 | -0.1040 | 0.1285 | 0.0463 | 0.0310 | 0.1195 | -0.0108 | -0.1341 | -0.1108 | 0.0418 | |||||
60 | NYC - Bond Core + Five % | -0.95% | 9.35% | 4.15% | 10.49% | 7.40% | 7.67% | 6.33% | -1.36% | 8.20% | 0.43% | 11.47% | 8.65% | 11.65% | 4.47% | |||||
61 | Fixed Income Allocation | 0.3000 | 0.3000 | 0.3000 | 0.3000 | 0.3000 | 0.3000 | 0.3000 | 0.3000 | 0.3000 | 0.3000 | 0.3000 | 0.3000 | 0.3000 | 0.3000 | |||||
62 | Bond % of Change | -0.0029 | 0.0281 | 0.0125 | 0.0315 | 0.0222 | 0.0230 | 0.0190 | -0.0041 | 0.0246 | 0.0013 | 0.0344 | 0.0260 | 0.0350 | 0.0134 | |||||
63 | Blended % Change | 0.1226 | 0.0501 | 0.2094 | 0.1163 | -0.1750 | -0.0810 | 0.1475 | 0.0423 | 0.0556 | 0.1208 | 0.0236 | -0.1082 | -0.0758 | 0.0552 | |||||
64 | Avg. Index/Core return | 3.594% | ||||||||||||||||||
65 |