HomeMy WebLinkAbout05-2014 Cash Trends ChartPEACE ,
x
Page Numbers
2
3 -4
5 -6
7 -8
9 -10
11
12
13
14
Distribution
a
Period Ending
Issued BY:
City of South Bend
May 2014
Controller
Cash Trends Summary - 2007 to 2014
Contents
Purpose of Report and Narrative
Cash Balances - Total Funds
Cash Balances - Enterprise Funds
Cash Balances - Redevelopment Funds
Cash Balances - Civil City Funds
CAFR Information:
Cash Balances and Outstanding Debt - Total Funds (2006 to 2013)
Cash Balances and Outstanding Debt - Enterprise Funds (2006 to 2013)
Cash Balances and Outstanding Debt - Civil City and Redevelopment Funds (2006 to 2013)
Ratio of Outstanding Debt By Type (2003 to 2013)
Mayor
Deputy Mayor
Chief of Staff
Deputy Chief of Staff
City Controller
Deputy City Controller
City Finance Director
Financial Officer
Pete Buttigieg
Mark Neal
Kathryn Roos
Brian Pawlowski
John Murphy
Jennifer Hockenhull
Rahman Johnson
Cecil Eastman
Cash Trends Summary 6/11/2014 1
Purpose of Report and Narrative
The purpose of the Cash Trends Summary Report is to track trends in cash balances for the City of South Bend over
an extended period of time, from January 1, 2007 through the present date. Charts and graphs for the cash balances
are provided in four areas - -total cash, enterprise fund cash, redevelopment fund cash and civil city fund cash.
The pupose of this information is to provide a quick overview of the overall liquidity and cash position of the City of
South Bend.
Property taxes are received in June and December of each year and this will cause the cash balances to fluctuate for
total cash, redevelopment fund cash and civil city fund cash. Enterprise fund cash balances will fluctuate based on the
receipt of bond proceeds and the spending down of cash on capital projects. Redevelopment fund cash accounts will
vary based on capital spending on projects in tax increment financing (TIF) funds.
In addition, charts and graphs are provided in the report comparing outstanding debt balances as compared to cash
on hand. This information is based on the City of South Bend's Comprehensive Annual Financial Report (CAFR). The
purpose of this information is provide a comparison of cash on hand vs outstanding debt to provide a quick assessment
of the strength of the City's financial position.
If you should have additional questions, please contact John H. Murphy, City Controller at 574 - 235 -7678, email
address jmurphy @southbendin.gov or Jennifer Hockenhull, Deputy City Controller at 574 - 235 -9822, email
ihockenh cDsouthbendin.gov.
Cash Trends Summary 6/11/2014
City of South Send Cash Balances - Total Funds
January 1, 2007 - May 31, 2014
$300,000,000
$250,000,000
$200,000,000
$150,000,000
$100,000,000
$50,000,000
$0
NNNNco000ornrnrno00 NNNmmm-It
0 0 0 0 0 0 0 0 0 0 r r r r r r
CD Ko> M M M M M m M M M M M M M M m M M m M M M
N t W Nzt Go N-til Go Nzt W Nzt 0000 N It 000 N 000 N
Maximum $259,848,268.81 6/30/13 Property tax collections are in June and December.
Minimum $122,056,197.59 5131107
Mean $191,357,769.06
Mean - last 12 months $232.877.786.23
Date Total Enterprise Redevelopment Civil City
1/01/07
153,934,542.58
28,657,187.47
40,101,775.51
85,175,579.60
1/31/07
140,751,745.07
30,058,091.08
37,204,941.29
73,488,712.70
2/28/07
134,780,141.52
30,099,578.04
42,400,991.27
62,279,572.21
3/31/07
130,695,124.81
30,984,947.93
36,322,464.80
63,387,712.08
4/30/07
123,592,524.20
29,218,887.63
36,374,308.24
57,999,328.33
5/31/07
122,056,197.59
32,424,086.65
36,579,224.31
53,052,886.63
6/30/07
153,755,514.81
48,699,567.31
35,914,061.41
69,141,886.09
7/31/07
137,115,793.85
48,096,309.22
33,046,039.94
55,973,444.69
8/31/07
135,817,993.03
47,662,427.04
31,416,991.60
56,738,574.39
9/30/07
130,647,671.00
45,360,303.16
30,955,278.22
54,332,089.62
10/31/07
139,006,258.42
46,717,357.10
29,953,285.20
62,335,616.12
11/30/07
149,006,468.44
41,716,114.28
29,049,190.99
78,241,163.17
12/31/07
191,315,373.73
55,204,053.77
43,118,912.28
92,992,407.68
1/31/08
178,454,459.92
56,114,335.03
41,405,052.40
80,935,072.49
2/29/08
175,025,158.07
54,575,012.50
40,635,068.99
79,815,076.58
3/31/08
170,888,981.29
54,575,272.95
40,558,124.18
75,755,584.16
4/30/08
165,390,558.53
54,929,047.02
40,290,091.29
70,171,420.22
5/31/08
156,964,559.54
53,052,472.03
40,210,711.69
63,701,375.82
6/30/08
167,363,776.09
53,204,418.10
39,857,987.53
74,301,370.46
7/31/08
171,036,661.63
54,533,563.28
39,145,712.40
77,357,385.95
8/31/08
163,938,453.44
54,251,216.99
36,074,455.00
73,612,781.45
9/30/08
160,071,575.14
53,272,451.68
35,928,266.53
70,870,856.93
10/31/08
164,801,788.81
68,706,036.43
34,674,631.21
61,421,121.17
11/30/08
148,390,201.07
54,077,562.73
33,382,904.90
60,929,733.44
12/31/08
140,621,861.88
44,639,804.67
28,608,922.65
67,373,134.56
1/31/09
129,082,048.94
45,793,529.09
26,731,148.85
56,557,371.00
2/28/09
136,587,197.92
46,941,062.25
28,199,966.51
61,446,169.16
3/31/09
150,350,125.92
47,265,006.09
27,482,787.81
75,602,332.02
4/30/09
156,355,774.87
48,061,985.20
38,905,572.01
69,388,217.66
5/31/09
154,015,638.43
46,623,111.00
38,656,758.39
68,735,769.04
6/30/09
145,255,362.21
46,662,615.02
36,003,705.47
62,589,041.72
7/31/09
151,028,950.92
45,609,990.75
39,288,192.08
66,130,768.09
8/31/09
154,754,067.65
44,700,623.82
38,981,480.90
71,071,962.93
Cash Trends Summary 6/11/2014
Date
Total
Enterprise
Redevelopment
Civil City
9/30/09
153,379,153.77
44,771,129.93
38,365,267.66
70,242,756.18
10/31/09
150,364,096.50
44,855,908.07
36,749,933.72
68,758,254.71
11/30/09
144,010,184.05
44,458,186.54
35,847,660.55
63,704,336.96
12/31/09
188,453,001.03
36,891,179.40
34,358,243.89
117,203,577.74
1/31/10
196,099,529.93
37,726,300.40
53,534,937.83
104,838,291.70
2/28/10
194,663,355.99
36,982,623.93
52,816,628.95
104,864,103.11
3/31/10
197,907,655.27
41,475,717.35
52,577,148.25
103,854,789.67
4/30/10
190,430,003.35
40,478,357.60
51,768,568.42
98,183,077.33
5/31/10
201,229,420.61
38,739,522.56
50,881,687.36
111,608,210.69
6/30/10
230,557,975.59
39,738,881.62
62,539,377.78
128,279,716.19
7/31/10
217,064,522.90
42,020,069.17
55,401,804.58
119,642,649.15
8/31/10
210,387,480.23
40,331,826.60
53,423,401.23
116,632,252.40
9/30/10
211,494,373.45
40,245,656.32
52,832,007.68
118,416,709.45
10/31/10
204,642,650.38
39,984,803.80
51,745,774.22
112,912,072.36
11/30/10
198,782,418.22
35,695,100.47
49,573,730.89
113,513,586.86
12/31/10
227,739,252.18
41,300,042.16
65,164,721.07
121,274,488.95
1/31/11
214,107,834.98
42,918,366.28
57,392,911.65
113,796,557.05
2/28/11
208,263,626.92
44,793,554.36
53,822,791.88
109,647,280.68
3/31/11
204,406,098.50
46,555,428.08
52,439,712.97
105,410,957.45
4/30/11
196,890,904.95
46,284,639.10
51,775,206.12
98,831,059.73
5/31/11
187,084,917.40
45,692,919.82
45,543,075.85
95,848,921.73
6/30/11
230,633,979.38
46,029,921.56
57,605,720.29
126,998,337.53
7/31/11
215,737,687.08
45,556,018.39
51,845,520.23
118,336,148.46
8/31/11
208,031,597.26
45,688,053.72
49,085,008.00
113,258,535.54
9/30/11
203,800,576.60
46,330,287.44
47,073,543.39
110,396,745.77
10/31/11
218,059,539.64
67,040,484.39
44,750,523.17
106,268,532.08
11/30/11
207,257,743.68
61,691,017.04
41,844,406.42
103,722,320.22
12/31/11
231,757,444.75
58,173,399.01
51,201,636.39
122,382,409.35
1/31/12
216,528,714.30
59,207,692.55
44,464,972.65
112,856,049.10
2/29/12
210,660,777.01
59,272,665.18
43,124,396.97
108,263,714.86
3/31/12
204,985,024.71
59,768,182.49
40,875,506.16
104,341,336.06
4/30/12
202,396,668.08
60,202,795.65
39,972,677.94
102,221,194.49
5/31/12
194,807,225.14
59,123,171.41
37,283,464.71
98,400,589.02
6/30/12
244,718,879.49
67,140,754.63
48,308,618.33
129,269,506.53
7/31/12
230,268,324.98
67,955,663.74
43,597,429.86
118,715,231.38
8/31/12
223,526,459.82
67,464,201.30
41,355,817.62
114,706,440.90
9/30/12
223,261,928.97
65,732,654.52
40,654,565.67
116,874,708.78
10/31/12
214,815,908.26
66,270,486.67
38,605,222.83
109,940,198.76
11/30/12
203,844,116.85
59,658,568.60
37,090,958.24
107,094,590.01
12/31/12
255,285,203.18
82,506,887.41
47,393,846.15
125,384,469.62
1/31/13
247,853,896.56
83,296,821.86
45,144,294.34
119,412,780.36
2/28/13
237,222,593.71
82,484,393.54
41,364,435.41
113,373,764.76
3/31/13
232,080,046.72
82,950,715.18
41,430,811.51
107,698,520.03
4/30/13
226,442,650.85
80,568,512.43
42,438,979.52
103,435,158.90
5/31/13
220,102,647.01
79,672,318.05
42,077,874.12
98,352,454.84
6/30/13
259,848,268.81
79,520,360.08
55,157,971.58
125,169,937.15
7/31/13
252,445,699.79
79,867,774.82
51,147,079.40
121,430,845.57
8/31/13
242,038,208.31
79,782,901.50
48,231,381.91
114,023,924.90
9/30/13
242,325,305.67
79,940,103.15
47,344,717.04
115,040,485.48
10/31/13
235,335,719.18
79,663,547.72
45,849,747.51
109,822,423.95
11/30/13
222,610,337.19
72,524,668.50
45,831,055.40
104,254,613.29
12/31/13
247,349,777.30
67,716,137.82
55,315,510.06
124,318,129.42
1/31/14
232,044,399.72
66,889,990.77
50,898,242.66
114,256,166.29
2/28/14
227,156,115.52
67,566,543.96
49,986,290.38
109,603,281.18
3/31/14
222,046,327.82
68,633,684.73
49,028,261.04
104,384,382.05
4/30/14
214,783,605.41
68,960,383.93
47,281,387.13
98,541,834.35
5/31/14
209,324,809.29
67,425,749.33
46,795,213.96
95,103,846.00
Cash Trends Summary 6/11/2014
City of South Bend Cash Balances - Enterprise Funds
January 1, 2007 - May 31, 2014
$90,000,000
$80,000,000
$70,000,000
$60,000,000
$50,000,000
$40,000,000
$30,000,000
$20,000,000
$10,000,000
$0
4
N N N N W W W0� T T O O O N N N N N N M M M
O O O O O O O O O O
\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \
O M M t� m m t� m M M M M M M m t� m m t� m M M M
N 0\0 N 000 N 0\0 N zt 0\0 N zt 000 N 000 N 0\0 N zt
N N N N N N N
Maximum
$83,296,821.86 1/31/13
Minimum
$28,657,187.47 1101107
Mean
$53,852,286.15
Mean - last 12 months
$73,704,935.72
Date Enterprise
1/01/07
28,657,187.47
1/31/07
30,058,091.08
2/28/07
30,099,578.04
3/31/07
30,984,947.93
4/30/07
29,218,887.63
5/31/07
32,424,086.65
6/30/07
48,699,567.31
7/31/07
48,096,309.22
8/31/07
47,662,427.04
9/30/07
45,360,303.16
10/31/07
46,717,357.10
11/30/07
41,716,114.28
12/31/07
55,204,053.77
1/31/08
56,114,335.03
2/29/08
54,575,012.50
3/31/08
54,575,272.95
4/30/08
54,929,047.02
5/31/08
53,052,472.03
6/30/08
53,204,418.10
7/31/08
54,533,563.28
8/31/08
54,251,216.99
9/30/08
53,272,451.68
10/31/08
68,706,036.43
11/30/08
54,077,562.73
12/31/08
44,639,804.67
1/31/09
45,793,529.09
2/28/09
46,941,062.25
3/31/09
47,265,006.09
4/30/09
48,061,985.20
5/31/09
46,623,111.00
6/30/09
46,662,615.02
7/31/09
45,609,990.75
8/31/09
44,700,623.82
Cash Trends Summary 6/11/2014
Date
Enterprise
9/30/09
44,771,129.93
10/31/09
44,855,908.07
11/30/09
44,458,186.54
12/31/09
36,891,179.40
1/31/10
37,726,300.40
2/28/10
36,982,623.93
3/31/10
41,475,717.35
4/30/10
40,478,357.60
5/31/10
38,739,522.56
6/30/10
39,738,881.62
7/31/10
42,020,069.17
8/31/10
40,331,826.60
9/30/10
40,245,656.32
10/31/10
39,984,803.80
11/30/10
35,695,100.47
12/31/10
41,300,042.16
1/31/11
42, 918, 366.28
2/28/11
44, 793, 554.36
3/31/11
46, 555,428.08
4/30/11
46,284, 639.10
5/31/11
45,692,919.82
6/30/11
46, 029, 921.56
7/31/11
45,556,018.39
8/31/11
45,688, 053.72
9/30/11
46, 330, 287.44
10/31/11
67, 040,484.39
11/30/11
61,691,017.04
12/31/11
58,173,399.01
1/31/12
59,207,692.55
2/29/12
59,272,665.18
3/31/12
59,768,182.49
4/30/12
60,202,795.65
5/31/12
59,123,171.41
6/30/12
67,140,754.63
7/31/12
67,955,663.74
8/31/12
67,464,201.30
9/30/12
65,732,654.52
10/31/12
66,270,486.67
11/30/12
59,658,568.60
12/31/12
82,506,887.41
1/31/13
83,296,821.86
2/28/13
82,484,393.54
3/31/13
82,950,715.18
4/30/13
80,568,512.43
5/31/13
79,672,318.05
6/30/13
79,520,360.08
7/31/13
79,867,774.82
8/31/13
79,782,901.50
9/30/13
79,940,103.15
10/31/13
79,663,547.72
11/30/13
72,524,668.50
12/31/13
67,716,137.82
1/31/14
66,889,990.77
2/28/14
67,566,543.96
3/31/14
68,633,684.73
4/30/14
68,960,383.93
5/31/14
67,425,749.33
Cash Trends Summary 6/11/2014
City of South Bend Cash Balances - Redevelopment Funds
January 1, 2007 - May 31, 2014
$70,000,000
$60,000,000
$50,000,000
$40,000,000
$30,000,000
$20,000,000
$10,000,000
$0
LI L� L� L� M M M 01 01 rn o 0 o r r r N N N M M M d
0 0 0 0 0 0 0 0 0 0�� ,� � � �
CD o ,O r o ,O r o M M o M r o ,O r o ,n M o M M o
CD CO CO CO CO CO CO cn cn cn cn cn cn CO CO CO CO cm cn cn cn cn cn
ti 00 N" 00 N� CO C N� CO C N" 00 N" 00 N� 0000 N�
Maximum $65,164,721.07 12/31/10 Property tax collections are in June and December.
Minimum $26,731,148.85 1131109
Mean $43,305,229.85
Mean - last 12 months $48.841.902.48
Date Redevelopment
1/01/07
40,101,775.51
1/31/07
37,204,941.29
2/28/07
42,400,991.27
3/31/07
36,322,464.80
4/30/07
36,374,308.24
5/31/07
36,579,224.31
6/30/07
35,914,061.41
7/31/07
33,046,039.94
8/31/07
31,416,991.60
9/30/07
30,955,278.22
10/31/07
29,953,285.20
11/30/07
29,049,190.99
12/31/07
43,118,912.28
1/31/08
41,405,052.40
2/29/08
40,635,068.99
3/31/08
40,558,124.18
4/30/08
40,290,091.29
5/31/08
40,210,711.69
6/30/08
39,857,987.53
7/31/08
39,145,712.40
8/31/08
36,074,455.00
9/30/08
35,928,266.53
10/31/08
34,674,631.21
11/30/08
33,382,904.90
12/31/08
28,608,922.65
1/31/09
26,731,148.85
2/28/09
28,199,966.51
3/31/09
27,482,787.81
4/30/09
38,905,572.01
5/31/09
38,656,758.39
6/30/09
36,003,705.47
7/31/09
39,288,192.08
8/31/09
38,981,480.90
Cash Trends Summary 6/11/2014 7
Date
Redevelopment
9/30/09
38,365,267.66
10/31/09
36,749,933.72
11/30/09
35,847,660.55
12/31/09
34,358,243.89
1/31/10
53,534,937.83
2/28/10
52,816,628.95
3/31/10
52,577,148.25
4/30/10
51,768,568.42
5/31/10
50,881,687.36
6/30/10
62,539,377.78
7/31/10
55,401,804.58
8/31/10
53,423,401.23
9/30/10
52,832,007.68
10/31/10
51,745,774.22
11/30/10
49,573,730.89
12/31/10
65,164,721.07
1/31/11
57, 392, 911.65
2/28/11
53, 822, 791.88
3/31/11
52,439, 712.97
4/30/11
51,775,206.12
5/31/11
45, 543, 075.85
6/30/11
57,605, 720.29
7/31/11
51,845,520.23
8/31/11
49, 085, 008.00
9/30/11
47, 073, 543.39
10/31/11
44, 750, 523.17
11/30/11
41,844,406.42
12/31/11
51,201,636.39
1/31/12
44,464,972.65
2/29/12
43,124,396.97
3/31/12
40,875,506.16
4/30/12
39,972,677.94
5/31/12
37,283,464.71
6/30/12
48,308,618.33
7/31/12
43,597,429.86
8/31/12
41,355,817.62
9/30/12
40,654,565.67
10/31/12
38,605,222.83
11/30/12
37,090,958.24
12/31/12
47,393,846.15
1/31/13
45,144,294.34
2/28/13
41,364,435.41
3/31/13
41,430,811.51
4/30/13
42,438,979.52
5/31/13
42,077,874.12
6/30/13
55,157,971.58
7/31/13
51,147,079.40
8/31/13
48,231,381.91
9/30/13
47,344,717.04
10/31/13
45,849,747.51
11/30/13
45,831,055.40
12/31/13
55,315,510.06
1/31/14
50,898,242.66
2/28/14
49,986,290.38
3/31/14
49,028,261.04
4/30/14
47,281,387.13
5/31/14
46,795,213.96
Cash Trends Summary 6/11/2014
City of South Bend Cash Balances - Civil City Funds
January 1, 2007 - May 31, 2014
$140,000,000
$120,000,000
$100,000,000
$80,000,000
$60,000,000
$40,000,000
$20,000,000
$0
N N N N X X 00 01 01
O O O O O O O O O O N N N N N N N N N N N N N
\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \
N O N N O N N O N N O N N O N N O N N O N N O
O M M M n7 M c+] M M M M M M M M c+] M M c+] M M M M
\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \
cy N N N N N N
Maximum $129,269,506.53
Minimum $53,052,886.63
Mean $94,200,253.06
Mean - last 12 months $110.330.948.04
Date Civil City
1/01/07
85,175, 579.60
1/31/07
73,488,712.70
2/28/07
62,279,572.21
3/31/07
63,387,712.08
4/30/07
57,999,328.33
5/31/07
53,052,886.63
6/30/07
69,141,886.09
7/31/07
55,973,444.69
8/31/07
56,738,574.39
9/30/07
54,332,089.62
10/31/07
62,335,616.12
11/30/07
78,241,163.17
12/31/07
92,992,407.68
1/31/08
80,935,072.49
2/29/08
79,815,076.58
3/31/08
75,755,584.16
4/30/08
70,171,420.22
5/31 /08
63,701,375.82
6/30/08
74,301,370.46
7/31/08
77,357,385.95
8/31/08
73,612,781.45
9/30/08
70,870,856.93
10/31/08
61,421,121.17
11/30/08
60,929,733.44
12/31/08
67,373,134.56
1/31/09
56,557,371.00
2/28/09
61,446,169.16
3/31/09
75,602,332.02
4/30/09
69,388,217.66
5/31 /09
68,735,769.04
6/30/09
62,589,041.72
7/31/09
66,130,768.09
8/31/09
71,071,962.93
6/30/12 Property tax collections are in June and December.
5/31 /07
Cash Trends Summary 6/11/2014 9
Date
Civil City
9/30/09
70,242,756.18
10/31/09
68,758,254.71
11/30/09
63,704,336.96
12/31/09
117, 203, 577.74
1/31/10
104, 838, 291.70
2/28/10
104,864,103.11
3/31/10
103, 854, 789.67
4/30/10
98,183,077.33
5/31/10
111,608,210.69
6/30/10
128,279, 716.19
7/31/10
119, 642 , 649.15
8/31/10
116,632, 252.40
9/30/10
118,416, 709.45
10/31/10
112, 912, 072.36
11/30/10
113, 513, 586.86
12/31/10
121,274,488.95
1/31/11
113, 796, 557.05
2/28/11
109,647, 280.68
3/31/11
105, 410 , 957.45
4/30/11
98,831,059.73
5/31/11
95, 848, 921.73
6/30/11
126, 998, 337.53
7/31/11
118,336,148.46
8/31/11
113,258, 535.54
9/30/11
110, 396, 745.77
10/31/11
106,268, 532.08
11/30/11
103, 722, 320.22
12/31/11
122, 382,409.35
1/31/12
112, 856, 049.10
2/29/12
108,263, 714.86
3/31/12
104,341,336.06
4/30/12
102,221,194.49
5/31/12
98,400,589.02
6/30/12
129,269, 506.53
7/31/12
118, 715, 231.38
8/31/12
114, 706,440.90
9/30/12
116, 874, 708.78
10/31/12
109,940,198.76
11/30/12
107,094,590.01
12/31/12
125, 384 , 469.62
1/31/13
119,412, 780.36
2/28/13
113, 373, 764.76
3/31/13
107,698, 520.03
4/30/13
103,435,158.90
5/31/13
98,352,454.84
6/30/13
125,169,937.15
7/31/13
121,430,845.57
8/31/13
114, 023, 924.90
9/30/13
115, 040,485.48
10/31/13
109, 822 , 423.95
11/30/13
104,254, 613.29
12/31/13
124,318,129.42
1/31/14
114,256,166.29
2/28/14
109,603, 281.18
3/31/14
104, 384, 382.05
4/30/14
98,541,834.35
5/31/14
95,103,846.00
Cash Trends Summary 6/11/2014 10
$300,000,000.00
$250,000,000.00
$200,000,000.00
$150,000,000.00
$100,000,000.00
$50,000,000.00
$0.00
Cash Balances and Outstanding Debt - Total Funds
Fiscal Year December 31, 2006 -2013
Year End
12/31/2006
12/31/2007
12/31/2008
12/31/2009
12/31/2010
12/31/2011
12/31/2012
12/31/2013
12131/2006 12/3112007 12131/2008 12131/2009 12/3112010 12131/2011 12/3112012 12/3112013
Cash
$153,934,542.58
$191,315,373.73
$140,621,861.88
$188,453,001.03
$227,739,252.18
$231,757,444.75
$255,285,203.18
$247,349,777.30
Cash Balance Outstanding Debt
Debt
$191,173,205.00
$213,703,674.00
$242,780,608.00
$237,813,273.00
$235,117,311.00
$239,075,065.00
$263,325,022.00
$245,831,789.00
Cash Trends Summary 6/11/2014 11
$160,000,000.00
$140,000,000.00
$120,000,000.00
$100,000,000.00
$80,000,000.00
$60,000,000.00
$40,000,000.00
$20,000,000.00
$0.00
Cash Balances and Outstanding Debt - Enterprise Funds
Fiscal Year December 31, 2006 - 2013
12131/2006 12/3112007 12131/2008 12131/2009 12/3112010 12131/2011 12/3112012 12/3112013
Cash Balance Outstanding Debt
Year End
Cash
Debt
12/31/2006
$28,657,187.47
$66,099,342.00
12/31/2007
$55,204,053.77
$93,579,690.00
12/31/2008
$44,639,804.67
$86,073,911.00
12/31/2009
$36,891,179.40
$86,092,611.00
12/31/2010
$41,300,042.16
$90,927,476.00
12/31/2011
$58,173,399.01
$105,935,524.00
12/31/2012
$82,506,887.41
$135,741,733.00
12/31/2013
$67,716,137.82
$123,438,353.00
Cash Trends Summary 6/11/2014 12
Cash Balances and Outstanding Debt - Governmental Funds
Civil City & Redevelopment
$200,000,000.00 Fiscal Year December 31 2006 - 2013
$180,000,000.00
$160,000,000.00
$140,000,000.00
$120,000,000.00
$100,000,000.00
$80,000,000.00
$60,000,000.00
$40,000,000.00
$20,000,000.00
$0.00
12/31/2006 12J31/2007 12/31/2008 12/31/2009 12J31/2010 12/31/2011 12J31/2012 12J31/2013
Cash Balance Outstanding Debt
Year End
Cash
Debt
12/31/2006
$125,277,355.11
$125,073,863.00
12/31/2007
$136,111,319.96
$120,123,984.00
12/31/2008
$95,982,057.21
$156,706,697.00
12/31/2009
$151,561,821.63
$151,720,662.00
12/31/2010
$186,439,210.02
$144,249,835.00
12/31/2011
$173,584,045.74
$133,139,541.00
12/31/2012
$172,778,315.77
$127,583,289.00
12/31/2013
$179,633,639.48
$122,393,436.00
Cash Trends Summary 6/11/2014 13
City of South Bend, Indiana
Ratios of Outstanding Debt by Type
Last Ten Fiscal Years
100%
90%
80%
70%
60%
50%
40%
30%
20%
10%
0%
2004 2005 2006 2007 2008 2009 2010 2011 2012 2013
ClCapital Leases
■ Notes/Loans Payable
■ Mortgage Bonds
■ Revenue Bonds
Ll General Obligation Bonds
r
. r ' •
�i
1
Governmental Activities
■
0
■
0
Business -Type Activities
1
0
Ninon
1
0
South Bend
South Bend
1
General
0
0
0
0
0
0
0 ■
■
Total
1
Debt
Estimated
Debt
Fiscal
Obligation
Revenue
Mortgage
Notes /Loans
Capital
Revenue
Mortgage
Notes /Loans
Capital
Primary
Estimated
Per
Personal
Percent of
Year
Bonds
Bonds
Bonds
Payable
Leases
Bonds
Bonds
Payable
Leases
Government
Population
Capita
Income
Income
2004
935,000
82,135,000
29,525,289
7,948,868
2,971,007
39,815,000
1,058,415
21,730,271
520,389
186,639,239
105,206
1,774
3,297,156,040
5.66%
2005
320,000
84,225,000
28,994,057
9,539,771
3,454,627
35,990,000
1,015,980
20,659,864
1,710,033
185,909,332
105,743
1,758
3,418,459,704
5.44%
2006
0
82,445,000
27,337,124
11,758,552
3,533,187
44,345,000
972,315
19,258,433
1,523,594
191,173,205
104,457
1,830
3,450,632,538
5.54%
2007
0
78,570,000
25,957,839
7,900,658
7,695,487
73,145,000
926,805
18,380,491
1,127,394
213,703,674
104,069
2,053
3,511,183,991
6.09%
2008
0
115,240,000
24,534,464
9,543,790
7,388,443
67,535,000
878,835
17,031,649
628,427
242,780,608
104,905
2,314
3,709,126,085
6.55%
2009
0
113,975,000
23,061,148
8,470,308
6,214,206
68,225,000
829,020
16,145,358
893,233
237,813,273
106,192
2,239
3,679,658,992
6.46%
2010
0
111,510,000
21,117,295
6,323,199
5,299,341
72,655,000
717,705
16,755,369
799,402
235,177,311
101,168
2,325
3,505,572,368
6.71%
2011
0
101,472,431
19,724,490
4,431,871
7,510,749
88,655,000
660,510
15,542,372
1,077,642
239,075,065
101,168
2,363
3,371,120,096
7.09%
2012
0
96,410,000
17,883,530
4,953,639
8,336,120
117,650,000
601,470
13,848,901
3,641,362
263,325,022
101,168
2,603
3,371,120,096
7.81%
2013
0
88,795,000
21,790,645
3,030,553
8,777,238
117,810,000
539,355
3,830,728
1,258,270
245,831,789
101,168
2,430
3,371,120,096
7.29%
Percent of Total Debt
0.00%
36.12%
8.86%
1.23%
3.57%
47.92%
0.22%
1.56%
0.51%
100.00%
Sources: City of South Bend Comprehensive Annual Financial Reports
Population statistics
obtained from
the U.S. Census Bureau.
City of South Bend
estimated personal income is
computed as estimated City population x 2012
South Bend Metro
Area Per Capita
Income (see Demographic
Statistics)
Governmental Activities
Debt
Business -Type Activities Debt
100%
90%
80%
70%
60%
50%
40%
30%
20%
10%
0%
2004 2005 2006 2007 2008 2009 2010 2011 2012 2013
ClCapital Leases
■ Notes/Loans Payable
■ Mortgage Bonds
■ Revenue Bonds
Ll General Obligation Bonds
r
. r ' •
�i
1
■
0
■
0
■
0
Olson
0
1
0
Ninon
1
0
1 ■
1
0
0
0
0
0
0
0
0 ■
■
. r ' •
1
0
0
1
0
0
0
0
0
0 ■
1
0
0
0
0
1
0
1
0
0 ■
r
�i■■■■■■■■■
r•,
rr- 2005 2006 2007 2008 2009 2010 2011 2012 r
o Capital Leases
■NOtesL—s Payable
■Mortgage Bontls
■ Revenue Bontls
Cash Trends Summary 6/11/2014 14