Loading...
HomeMy WebLinkAbout11-2015 Cash Trends ChartPeriod Ending: Issued BY: City of South Bend Cash Trends Summary - 2007 to 2015 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 2014) 12 Cash Balances and Outstanding Debt - Enterprise Funds (2006 to 2014) 13 Cash Balances and Outstanding Debt - Civil City and Redevelopment Funds (2006 to 2014) 14 Ratio of Outstanding Debt By Type (2003 to 2014) Distribution Mayor Pete Buttigieg Chief of Staff James Mueller Deputy Chief of Staff Brian Pawlowski City Controller John Murphy Deputy City Controller Jennifer Hockenhull City Finance Director Rahman Johnson Financial Officer Cecil Eastman November 2015 Controller Cash Trends Summary 12/14/2015 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 12/14/2015 2 Maximum$259,848,268.81 6/30/13 Property tax collections are in June and December. Minimum$122,056,197.59 5/31/07 Mean$197,679,232.51-- Mean - last 12 months$227,208,073.68-- 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 $0 $50,000,000 $100,000,000 $150,000,000 $200,000,000 $250,000,000 $300,000,000 1/01/075/31/07 10/31/073/31/088/31/081/31/096/30/09 11/30/094/30/109/30/102/28/117/31/11 12/31/115/31/12 10/31/123/31/138/31/131/31/146/30/14 11/30/144/30/159/30/15 City of South Bend Cash Balances -Total Funds January 1, 2007 -November 30, 2015 Cash Trends Summary 12/14/2015 3 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 11/30/14 216,583,420.38 64,909,392.12 54,554,819.33 97,119,208.93 12/31/14 239,808,095.03 61,623,499.90 65,903,128.76 112,281,466.37 1/31/15 225,471,264.56 61,585,040.94 60,387,162.56 103,499,061.06 2/28/15 221,854,105.82 63,269,776.69 58,990,110.88 99,594,218.25 3/31/15 215,278,052.12 64,288,370.38 58,654,868.03 92,334,813.71 4/30/15 213,330,317.66 65,430,174.18 57,972,838.77 89,927,304.71 5/31/15 209,379,494.75 65,714,228.05 57,630,884.95 86,034,381.75 6/30/15 249,603,497.41 68,746,632.56 70,642,566.10 110,214,298.75 7/31/15 236,381,857.01 70,884,051.33 65,048,413.67 100,449,392.01 8/31/15 228,483,356.31 72,023,119.13 61,042,169.83 95,418,067.35 9/30/15 234,514,964.30 75,617,268.98 59,936,471.64 98,961,223.68 10/31/15 230,114,056.20 77,155,814.42 56,339,743.69 96,618,498.09 11/30/15 222,277,823.00 75,987,100.36 54,715,027.81 91,575,694.83 Cash Trends Summary 12/14/2015 4 Maximum$83,296,821.86 1/31/13 Minimum$28,657,187.47 1/01/07 Mean$56,285,730.80-- Mean - last 12 months$68,527,089.74-- 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 $0 $10,000,000 $20,000,000 $30,000,000 $40,000,000 $50,000,000 $60,000,000 $70,000,000 $80,000,000 $90,000,000 1/01/075/31/07 10/31/073/31/088/31/081/31/096/30/09 11/30/094/30/109/30/102/28/117/31/11 12/31/115/31/12 10/31/123/31/138/31/131/31/146/30/14 11/30/144/30/159/30/15 City of South Bend Cash Balances -Enterprise Funds January 1, 2007 -November 30, 2015 Cash Trends Summary 12/14/2015 5 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 11/30/14 64,909,392.12 12/31/14 61,623,499.90 1/31/15 61,585,040.94 2/28/15 63,269,776.69 3/31/15 64,288,370.38 4/30/15 65,430,174.18 5/31/15 65,714,228.05 6/30/15 68,746,632.56 7/31/15 70,884,051.33 8/31/15 72,023,119.13 9/30/15 75,617,268.98 10/31/15 77,155,814.42 11/30/15 75,987,100.36 Cash Trends Summary 12/14/2015 6 Maximum$70,642,566.10 6/30/15 Property tax collections are in June and December. Minimum$26,731,148.85 1/31/09 Mean$45,945,107.29-- Mean - last 12 months$60,605,282.22-- 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 $0 $10,000,000 $20,000,000 $30,000,000 $40,000,000 $50,000,000 $60,000,000 $70,000,000 $80,000,000 1/01/075/31/07 10/31/073/31/088/31/081/31/096/30/09 11/30/094/30/109/30/102/28/117/31/11 12/31/115/31/12 10/31/123/31/138/31/131/31/146/30/14 11/30/144/30/159/30/15 City of South Bend Cash Balances -Redevelopment Funds January 1, 2007 -November 30, 2015 Cash Trends Summary 12/14/2015 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 11/30/14 54,554,819.33 12/31/14 65,903,128.76 1/31/15 60,387,162.56 2/28/15 58,990,110.88 3/31/15 58,654,868.03 4/30/15 57,972,838.77 5/31/15 57,630,884.95 6/30/15 70,642,566.10 7/31/15 65,048,413.67 8/31/15 61,042,169.83 9/30/15 59,936,471.64 10/31/15 56,339,743.69 11/30/15 54,715,027.81 Cash Trends Summary 12/14/2015 8 Maximum$129,269,506.53 6/30/12 Property tax collections are in June and December. Minimum$53,052,886.63 5/31/07 Mean$95,448,394.42-- Mean - last 12 months$98,075,701.71-- 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 $0 $20,000,000 $40,000,000 $60,000,000 $80,000,000 $100,000,000 $120,000,000 $140,000,000 1/01/075/31/0710/31…3/31/088/31/081/31/096/30/0911/30…4/30/109/30/102/28/117/31/1112/31…5/31/1210/31…3/31/138/31/131/31/146/30/1411/30…4/30/159/30/15 City of South Bend Cash Balances -Civil City Funds January 1, 2007 -November 30, 2015 Cash Trends Summary 12/14/2015 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 11/30/14 97,119,208.93 12/31/14 112,281,466.37 1/31/15 103,499,061.06 2/28/15 99,594,218.25 3/31/15 92,334,813.71 4/30/15 89,927,304.71 5/31/15 86,034,381.75 6/30/15 110,214,298.75 7/31/15 100,449,392.01 8/31/15 95,418,067.35 9/30/15 98,961,223.68 10/31/15 96,618,498.09 11/30/15 91,575,694.83 Cash Trends Summary 12/14/2015 10 Year End December 31 Cash Debt 2006$153,934,542.58$191,173,205.00 2007$191,315,373.73$213,703,674.00 2008$140,621,861.88$242,780,608.00 2009$188,453,001.03$237,813,273.00 2010$227,739,252.18$235,117,311.00 2011$231,757,444.75$239,075,065.00 2012$255,285,203.18$263,325,022.00 2013$247,349,777.30$251,682,278.00 2014$239,808,095.03$235,085,870.00 $0.00 $50,000,000.00 $100,000,000.00 $150,000,000.00 $200,000,000.00 $250,000,000.00 $300,000,000.00 2006 2007 2008 2009 2010 2011 2012 2013 2014 Cash Balances and Outstanding Debt -Total Funds Fiscal Year December 31, 2006-2014 Cash Balance Outstanding Debt Cash Trends Summary 12/14/2015 11 Year End December 31 Cash Debt 2006$28,657,187.47$66,099,342.00 2007$55,204,053.77$93,579,690.00 2008$44,639,804.67$86,073,911.00 2009$36,891,179.40$86,092,611.00 2010$41,300,042.16$90,927,476.00 2011$58,173,399.01$105,935,524.00 2012$82,506,887.41$135,741,733.00 2013$67,716,137.82$126,621,879.00 2014$61,623,499.90$118,792,944.00 $0.00 $20,000,000.00 $40,000,000.00 $60,000,000.00 $80,000,000.00 $100,000,000.00 $120,000,000.00 $140,000,000.00 $160,000,000.00 2006 2007 2008 2009 2010 2011 2012 2013 2014 Cash Balances and Outstanding Debt -Enterprise Funds Fiscal Year December 31, 2006 -2014 Cash Balance Outstanding Debt Cash Trends Summary 12/14/2015 12 Year End December 31 Cash Debt 2006$125,277,355.11$125,073,863.00 2007$136,111,319.96$120,123,984.00 2008$95,982,057.21$156,706,697.00 2009$151,561,821.63$151,720,662.00 2010$186,439,210.02$144,249,835.00 2011$173,584,045.74$133,139,541.00 2012$172,778,315.77$127,583,289.00 2013$179,633,639.48$125,060,399.00 2014$178,184,595.13$116,292,926.00 $0.00 $20,000,000.00 $40,000,000.00 $60,000,000.00 $80,000,000.00 $100,000,000.00 $120,000,000.00 $140,000,000.00 $160,000,000.00 $180,000,000.00 $200,000,000.00 2006 2007 2008 2009 2010 2011 2012 2013 2014 Cash Balances and Outstanding Debt -Governmental Funds Civil City & Redevelopment Fiscal Year December 31, 2006 -2014 Cash Balance Outstanding Debt Cash Trends Summary 12/14/2015 13 South Be nd South Bend Genera l To ta l D ebt Estimated De bt Fiscal Obligation Revenue M ortgage Note s/Loans Capital Reven ue Mortgag e Notes/Loans Capital Prima ry Estimated Per Pe rsonal Percent of Year Bonds Bonds Bonds Payable Leases Bonds Bonds Pa yable Le as es Government Popu lation Capita In come Income 2005 3 20,000 84,225,000 28,994,057 9,539,771 3,45 4,627 35,9 90,000 1,01 5,980 20,6 59,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,53 3,187 44,3 45,000 97 2,315 19,2 58,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,69 5,487 73,1 45,000 92 6,805 18,3 80,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,38 8,443 67,5 35,000 87 8,835 17,0 31,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,21 4,206 68,2 25,000 82 9,020 16,1 45,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,29 9,341 72,6 55,000 71 7,705 16,7 55,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,51 0,749 88,6 55,000 66 0,510 15,5 42,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,33 6,120 117,6 50,000 60 1,470 13,8 48,901 3,641,362 263,325,022 101,168 2,603 3,371,120,096 7.81% 2013 0 90,172,826 23,079,781 3,030,554 8,77 7,238 118,1 21,963 54 6,973 4,1 21,010 3,831,933 251,682,278 101,168 2,488 3,371,120,096 7.47% 2014 0 84,862,512 21,331,548 1,617,491 8,48 1,375 111,2 09,874 48 0,604 3,7 94,664 3,307,802 235,085,870 101,168 2,324 3,371,120,096 6.97% Percent o f Total Debt 0.00%36.10%9.07% 0.69% 3.61% 47.31% 0.20% 1.61% 1.41%10 0.00% Sources: City of Sout h Ben d Co mpr ehe nsiv e Ann ual Fina ncia l Rep or ts Population s tat istic s o bta ined fro m t he U.S. Ce nsus Burea u. Ci ty of So uth Bend estim ated p er sonal income is com puted as e stimat ed Ci ty popula tio n x 2012 Sout h Bend M etro Area Per Capita In come (see D em og ra ph ic Statistics) City of South Bend, Indiana Ratios of Outstanding Debt by Type Last Ten Fiscal Years Governmen ta l Activities Bus iness-Type Acti vities 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% 2005 2 0 0 6 2 007 2008 2009 2010 2011 2012 2 0 13 2014 Governmental Activities Debt Cap i tal L eases Notes/L o ans P aya b l e Mortga ge B onds Rev enue Bonds Gene ral Obliga t io n Bo n ds 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% 200 5 2006 2007 2 0 0 8 2009 2010 20 1 1 2012 2013 201 4 Business-Type Activities Debt Capi ta l L e as es Notes/Lo ans P ayabl e Mortgage Bo n ds Revenue Bonds Page 14