Loading...
HomeMy WebLinkAbout02-2014 Cash Trends Charto4S013TIl8�� � v W PEACE a it A 1865 Period Ending: Issued BY: February 2014 City of South Bend Controller CashTrends Summary - 2007 to 2014 Page Numbers Contents 2 Purpose of Report and Narrative 3 -4 Cash Balances - Total Funds 5 -6 Cash Balances - Enterprise Funds 7 -8 Cash Balances - Redevelopment Funds 9 -10 Cash Balances - Civil City Funds CAFR Information: 11 Cash Balances and Outstanding Debt - Total Funds (2006 to 2012) 12 Cash Balances and Outstanding Debt - Enterprise Funds (2006 to 2012) 13 Cash Balances and Outstanding Debt - Civil City and Redevelopment Funds (2006 to 2012) 14 Ratio of Outstanding Debt By Type (2003 to 2012) Distribution Mayor Deputy Mayor Chief of Staff Deputy Chief of Staff City Controller City Finance Director Financial Officer Pete Buttigieg Mark Neal Kathryn Roos Brian Pawleski John Murphy Rahman Johnson Cecil Eastman Cash Trends Summary 3/26/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 or email address jmurphy @southbendin.gov. Cash Trends Summary 3/26/2014 City of South Bend Cash Balances - Total Funds January 1, 2007 - February 28, 2014 $300,000,000 $250,000,000 $200,000,000 $150,000,000 $100,000,000 $50,000,000 $0 t" t\ N N X X X rn rn rn o 0 0 . N N N m m m 0 0 0 0 0 0 0 0 0 0 o m m o co m co o m m o o co CO m m m m co - - - ,--i W N It 00 N 00 N GO N 00 N 00 N GO N I- Maximum $259,848,268.81 6/30/13 Property tax collections are Minimum $122,056,197.59 5/31/07 Mean $190,529,246.82 -- Mean - last 12 months $236,648,264.67 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 9/30/09 153,379,153.77 44,771,129.93 38,365,267.66 70,242,756.18 Cash Trends Summary 3/26/2014 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 Cash Trends Summary 3/26/2014 City of South Bend Cash Balances - Enterprise Funds January 1, 2007 - February 28, 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 W W w OrI 0� M O O O 0 0 0 0 0 0 0 0 0 N O N N O N N O H ti O N N O N N O N ti O N N O M M M M M m M M m m M M M M m M M m m M M Maximum $83,296,821.86 1/31/13 Minimum $28,657,187.47 1/01/07 Mean $53,352,711.91 -- Mean - last 12 months $76,388,631.17 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 9/30/09 44,771,129.93 Cash Trends Summary 3/26/2014 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 Cash Trends Summary 3/26/2014 City of South Bend Cash Balances - Redevelopment Funds January 1, 2007 - February 28, 2014 $70,000,000 $60,000,000 $50,000,000 $40,000,000 $30,000,000 $20,000,000 $10,000,000 $0 1, N N N M M W O, 61 a, O O O �--i � , N N N M M M 0 0 0 0 0 0 0 0 0 0 \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ c-a O O N N O O O c-a eti O O N N O M M M M M M M M M M M M M M M M M M M M M \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ 00 N � 00 GO N N � 00 N 00 GO N Maximum $65,164,721.07 Minimum $26,731,148.85 Mean $43,153,630.16 Mean - last 12 months $47,975,805.09 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 9/30/09 38,365,267.66 12/31/10 Property tax 1/31/09 ons are In June ana uecem Cash Trends Summary 3/26/2014 7 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 Cash Trends Summary 3/26/2014 City of South Bend Cash Balances - Civil City Funds )nn7 r.,,, ,«„ )u r)nl n $140,000,000 $120,000,000 $100,000,000 $80,000,000 $60,000,000 $40,000,000 $20,000,000 $0 L� L" L, t, X M M a, a, am o 0 0 N N N m m M 0 0 0 0 0 0 0 0 0 o r N r \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ Maximum $129,269,506.53 6/30/12 Minimum $53,052,886.63 5/31/07 Mean $94,022,904.75 -- Mean - last 12 months $112,283,828.42 Date Civil 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 9/30/09 70,242,756.18 tax collections are Cash Trends Summary 3/26/2014 9 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/31110 116,632,252.40 9/30/10 118,416, 709.45 10/31110 112,912,072.36 11/30/10 113,513, 586.86 12/31110 121,274,488.95 1/31/11 113,796, 557.05 2/28111 109, 647, 280.68 3/31/11 105,410,957.45 4/30111 98,831,059.73 5/31/11 95,848,921.73 6/30111 126, 998, 337.53 7/31/11 118,336,148.46 8/31111 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 Cash Trends Summary 3/26/2014 10 Cash Balances and Outstanding Debt - Total Funds Fiscal Year December 31, 2006 -2012 $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 1/01//2007 12/31 /2007 12/31/2008 12131/2009 12/31/2010 12131/2011 12131/2012 Cash Balance Outstanding Debt Year End Cash Debt 1/01//2007 $153,934,542.58 $191,173,205.00 12/31/2007 $191,315,373.73 $213,703,674.00 12/31/2008 $140,621,861.88 $242,780,608.00 12/31/2009 $188,453,001.03 $237,813,273.00 12/31/2010 $227,739,252.18 $235,117,311.00 12/31/2011 $231,757,444.75 $239,075,065.00 12/31/2012 $255,285,203.18 $263,325,022.00 Cash Trends Summary 3/26/2014 11 Cash Balances and Outstanding Debt - Enterprise Funds Fiscal Year December 31, 2006 - 2012 $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 1/01//2007 12/31 /2007 12/31/2008 12131/2009 12/31/2010 12131/2011 12131/2012 Cash Balance Outstanding Debt Year End Cash Debt 1/01//2007 $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 Cash Trends Summary 3/26/2014 12 Cash Balances and Outstanding Debt - Governmental Funds Civil City & Redevelopment $200,000,000.00 Fmgral Year December 31, 2006 - 2012 $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 1/01112007 12/31 /2007 12/3112008 12131/2009 12/31/2010 1213112011 12/31/2012 Cash Balance Outstanding Debt Year End Cash Debt 1/01//2007 $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 Cash Trends Summary 3/26/2014 13 City of South Bend, Indiana Ratios of Outstanding Debt by Type Last Ten Fiscal Years Governmental Activities Debt tt tt tt rt. tt tr: tt. tt t t Estimated Population 105,540 105,206 105,743 104,457 104,069 104,905 106,192 101,168 101,168 101,168 Insiol■I■i■■I ■■■■■■■1 .I �i■ "■■■■■■■■1 ' II■■■■■■■■ ■t ' �i■■■■■■■■■1 ' II ■ ■ ■0 0 0 0 0 1 1 ' 0000011 of tt tt• tt tt tt tt: tt t t t t Debt Per 1,737 1,774 1,758 1,830 2,053 2,314 2,239 2,325 2,363 2,603 South Bend Estimated Personal Income 3,143,825,520 3,297,156,040 3,418,459,704 3,450,632,538 3,511,183,991 3,709,126,085 3,679,658,992 3,505,572,368 3,371,120,096 3,371,120,096 South Bend Debt Percent of Income Cash Trends Summary 3/26/2014 14 5.83% 5.66% 5.44% 5.54% 6.09% 6.55% 6.46% 6.71% 7.09% 7.81% Governmental Activities Business -Type Activities General Total Fiscal Obligation Revenue Mortgage Notes /Loans Capital Revenue Mortgage Notes /Loans Capital Primary Year Bonds Bonds Bonds Payable Leases Bonds Bonds Payable Leases Government 2003 1,525,000 85,070,000 30,112,808 8,131,984 3,659,322 31,625,000 1,099,005 21,338,647 794,885 183,356,651 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 Percent of Total Debt 0.00% 36.61% 6.79% 1.88% 3.17% 44.68% 0.23% 5.26% 1.38% 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 tt tt tt rt. tt tr: tt. tt t t Estimated Population 105,540 105,206 105,743 104,457 104,069 104,905 106,192 101,168 101,168 101,168 Insiol■I■i■■I ■■■■■■■1 .I �i■ "■■■■■■■■1 ' II■■■■■■■■ ■t ' �i■■■■■■■■■1 ' II ■ ■ ■0 0 0 0 0 1 1 ' 0000011 of tt tt• tt tt tt tt: tt t t t t Debt Per 1,737 1,774 1,758 1,830 2,053 2,314 2,239 2,325 2,363 2,603 South Bend Estimated Personal Income 3,143,825,520 3,297,156,040 3,418,459,704 3,450,632,538 3,511,183,991 3,709,126,085 3,679,658,992 3,505,572,368 3,371,120,096 3,371,120,096 South Bend Debt Percent of Income Cash Trends Summary 3/26/2014 14 5.83% 5.66% 5.44% 5.54% 6.09% 6.55% 6.46% 6.71% 7.09% 7.81%