Loading...
HomeMy WebLinkAbout06-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 June 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 7/17/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 7/17/2014 City of South Send Cash Balances - Total Funds $300,000,000 $250,000,000 $200,000,000 $150,000,000 $100,000,000 $50,000,000 $0 January 1, 2007 - June 30, 2014 NNNNXmcocrnrncrn000� ��NNNmmm� 0 0 0 0 0 0 0 0 0 o r r r r r r r 0 om M M M M M M M M °m M M M M M °m M M °m M M M N N N N N N N Maximum $259,848,268.81 6/30/13 Property tax collections are in June and December. Minimum $122,056,197.59 5131107 Mean $192,020,877.58 Mean - last 12 months $233.263.412.43 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 7/17/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 Cash Trends Summary 7/17/2014 City of South Bend Cash Balances - Enterprise Funds January 1, 2007 - June 30, 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 m X m 0� rn 0� o 0 0 N N N m M m 0 0 0 0 0 0 0 0 0 o r r r r r r 0 om M M m M m M m M m M m M M m M m M m M m M N W N W N W 000 N W Nzt W Nzt 000 N 0000 Nzt N N N N N N N Maximum $83,296,821.86 1/31/13 Minimum $28,657,187.47 1101107 Mean $54,004,436.65 Mean - last 12 months $72,222,455.60 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 7/17/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 Cash Trends Summary 7/17/2014 City of South Bend Cash Balances - Redevelopment Funds T.....,......, 1 gnn7 T..-- In 'fnI A $70,000,000 $60,000,000 $50,000,000 $40,000,000 $30,000,000 $20,000,000 $10,000,000 $0 L�r`L�r`XXX01 rno\00or rNNNmmm ,D o N M o M r o N M o N M o M r o N M o N M o CD m CO m CO m m m m m m m m m m m m m m CO CO m CO N W N N W N W N N W N W 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,500,984.26 Mean - last 12 months $49.902.313.96 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 7/17/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 Cash Trends Summary 7/17/2014 City of South Bend Cash Balances - Civil City Funds $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 M 00 a, 01 O O O O O O O O O O N N N N N N N N N N N N N \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ O M M M M M M M M M M M M M M M M M M M M M M \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ Maximum $129,269,506.53 Minimum $53,052,886.63 Mean $94,515,456.67 Mean - last 12 months $111.138.642.87 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 7/17/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 Cash Trends Summary 7/17/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 7/17/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 7/17/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 7/17/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 7/17/2014 14