Loading...
HomeMy WebLinkAbout10-2014 Cash Trends ChartPF:ACF: , W Page Numbers 2 3 -4 5 -6 7 -8 9 -10 11 12 13 14 Distribution Period Ending Issued BY: October 2014 City of South Bend 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 Chief of Staff Deputy Chief of Staff City Controller Deputy City Controller City Finance Director Financial Officer Pete Buttigieg Kathryn Roos Brian Pawlowski John Murphy Jennifer Hockenhull Rahman Johnson Cecil Eastman Cash Trends Summary 11/12/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 purpose 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 jhockenh @southbendin.gov. Cash Trends Summary 11/12/2014 City of South Send Cash Balances - Total Funds January 1, 2007 - October 31, 2014 $300,000,000 $250,000,000 $200,000,000 $150,000,000 $100,000,000 $50,000,000 $0 NNNNXXX00rnrno 00 -It 0 0 0 0 0 0 0 0 0 0 r r r r r CD o�� o r N o r N o M M o r N o M M o N N o N CD m m 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 000 N-til 000 Nzt 0000 N It 000 N.114 000 Nzt W Nzt W Maximum $259,848,268.81 6130113 Property tax collections are in June and December. Minimum $122,056,197.59 5131107 Mean $193,750,282.18 Mean - last 12 months $229.949.413.63 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 11/12/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 6/30/14 251,700,644.00 67,697,981.00 61,118,881.00 122,883,782.00 7/31/14 238,781,403.03 68,611,865.99 56,842,280.86 113,327,256.18 8/31/14 234,086,687.41 68,747,483.87 55,735,447.17 109,603,756.37 9/30/14 233,595,370.44 69,430,344.98 54,889,194.46 109,275,831.00 10/31/14 225,913,486.47 70,431,027.92 54,196,891.83 101,285,566.72 Cash Trends Summary 11/12/2014 City of South Bend Cash Balances - Enterprise Funds January 1, 2007 - October 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 &L- N N N N X X X0� 0� T O O O N N N N N N M M M -It 0 0 0 0 0 0 0 0 0 0 \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ CD O N N O N N O c-) N O Cf) N O c-) N O c-� N O N N O N O M M M M M M M M M M M M M M M M M M M M M M M cc N-zll W N-zll 000 N-zll 000 N 000 N 000 N W N zt W N N N N N N N Maximum $83,296,821.86 1131113 Minimum $28,657,187.47 1101107 Mean $54,648,678.50 Mean - last 12 months $68,719,655.23 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 11/12/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 6/30/14 67,697,981.00 7/31/14 68,611,865.99 8/31/14 68,747,483.87 9/30/14 69,430,344.98 10/31/14 70,431,027.92 Cash Trends Summary 11/12/2014 City of South Bend Cash Balances - Redevelopment Funds January 1, 2007 - October 31, 2014 $70,000,000 $60,000,000 $50,000,000 $40,000,000 $30,000,000 $20,000,000 $10,000,000 $0 n n n n X W X 0� 01 a\ o o O M m m zt d� 00000000 CD CD �� �1�1�� ,D o M r o M r o M M o N M o N M o N M o N r o N CD m m m m m m m m m m m m m m m m m m m m m m m Maximum $65,164,721.07 12/31/10 Property tax collections are in June and December. Minimum $26,731,148.85 1131109 Mean $44,002,667.18 Mean - last 12 months $52.326.554.66 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 11/12/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 6/30/14 61,118,881.00 7/31/14 56,842,280.86 8/31/14 55,735,447.17 9/30/14 54,889,194.46 10/31/14 54,196,891.83 Cash Trends Summary 11/12/2014 City of South Bend Cash Balances - Civil City Funds January 1, 2007 - October 31, 2014 $140,000,000 $120,000,000 $100,000,000 $80,000,000 $60,000,000 $40,000,000 $20,000,000 $0 Maximum $129,269,506.53 Minimum $53,052,886.63 Mean $95,098,936.50 Mean - last 12 months $108.903.203.74 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. 5131107 Cash Trends Summary 11/12/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 6/30/14 122, 883, 782.00 7/31/14 113, 327, 256.18 8/31/14 109,603, 756.37 9/30/14 109,275, 831.00 10/31/14 101,285,566.72 Cash Trends Summary 11/12/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/31/2007 12/31/2008 12/31/2009 12/31/2010 12/31/2011 12/31/2012 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 $251,682,277.00 Cash Trends Summary 11/12/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/31/2007 12/31/2008 12/31/2009 12/31/2010 12/31/2011 12/31/2012 12/3112013 Cash Balance --M—oUt:standin 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 $126,621,879.00 Cash Trends Summary 11/12/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 12/3112007 12/31/2008 12/31/2009 12/3112010 12/31/2011 12/31/2012 12/31/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 $125,060,398.00 Cash Trends Summary 11/12/2014 13 Fiscal Year City of South Bend, Indiana Ratios of Outstanding Debt by Type Last Ten Fiscal Years Governmental Activities Business -Type Activities General Obligation Revenue Mortgage Notes /Loans Capital Revenue Mortgage Notes /Loans Capital Bonds Bonds Bonds Payable Leases Bonds Bonds Payable Leases Total Primary Government 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 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 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 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 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 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 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 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 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 2013 0 90,172,826 23,079,781 3,030,553 8,777,238 118,118,539 551,602 4,121,010 3,830,728 251,682,277 Percent of Total Debt 0.00% 35.83% 9.17% 1.20% 3.49% 46.93% 0.22% 1.64% 1.52% 100.00% Sources: City of South Bend Comprehensive Annual Financial Reports rr- 2005 2006 2007 2008 2009 2010 Population statistics obtained from the U.S. Census Bureau. 2012 r 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) 100% 90% 80% 70% 60% 50% 40% 30% 20% 10% 0% 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 Governmental Activities Debt oCapital Leases ■ Notes /Loans Payable ■ Mortgage Bonds ■ Revenue Bonds E3 General Obligation Bonds Business -Type Activities Debt Estimated Population 105,206 105,743 104,457 104,069 104,905 106,192 101,168 101,168 101,168 101,168 Debt Per ;apita South Bend Estimated Personal Income South Bend Debt Percent of Income 1,774 3,297,156,040 5.66% 1,758 3,418,459,704 5.44% 1,830 3,450,632,538 5.54% 2,053 3,511,183,991 6.09% 2,314 3,709,126,085 6.55% 2,239 3,679,658,992 6.46% 2,325 3,505,572,368 II■■■■■■■■■ ■mill 3,371,120,096 7.09% 2,603 3,371,120,096 ■ 2,488 ■ ■ ' 'I■■■■■■■■■ �■■■■■■■■■ ' �■■■■■■■■■ ' rr- 2005 2006 2007 2008 2009 2010 2011 2012 r Debt Per ;apita South Bend Estimated Personal Income South Bend Debt Percent of Income 1,774 3,297,156,040 5.66% 1,758 3,418,459,704 5.44% 1,830 3,450,632,538 5.54% 2,053 3,511,183,991 6.09% 2,314 3,709,126,085 6.55% 2,239 3,679,658,992 6.46% 2,325 3,505,572,368 6.71% 2,363 3,371,120,096 7.09% 2,603 3,371,120,096 7.81% 2,488 3,371,120,096 7.47% o Capital Leases ■No[eslLOans Payable ■Mortgage Bonds ■Revenue Bontls Cash Trends Summary 11/12/2014 14