Loading...
HomeMy WebLinkAbout06-2016 Cash Trends SummaryPeriod Ending: Issued BY: City of South Bend Cash Trends Summary - 2007 to 2016 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 2015) 12 Cash Balances and Outstanding Debt - Enterprise Funds (2006 to 2015) 13 Cash Balances and Outstanding Debt - Civil City and Redevelopment Funds (2006 to 2015) 14 Ratio of Outstanding Debt By Type (2003 to 2015) Distribution Mayor Pete Buttigieg Chief of Staff James Mueller City Controller John Murphy Deputy City Controller Jennifer Hockenhull City Finance Director Rahman Johnson Sr. Budget Analyst Amy O'Connor June 30, 2016 Controller Cash Trends Summary 8/27/2016 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 8/27/2016 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$198,995,028.98-- Mean - last 12 months$223,903,606.55-- 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/152/29/16 City of South Bend Cash Balances -Total Funds January 1, 2007 -June 30, 2016 Cash Trends Summary 8/27/2016 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 12/31/15 228,782,505.24 64,215,673.59 61,194,710.47 103,372,121.18 1/31/16 217,346,607.43 65,062,377.54 55,690,681.11 96,593,548.78 2/29/16 213,873,714.80 67,564,110.56 53,548,676.30 92,760,927.94 3/31/16 211,205,005.30 69,211,164.87 53,434,486.66 88,559,353.77 4/30/16 207,587,385.26 69,616,174.97 51,317,725.09 86,653,485.20 5/31/16 206,530,605.82 69,399,868.04 50,296,085.76 86,834,652.02 6/30/16 249,745,397.89 68,720,691.90 64,433,239.06 116,591,466.93 Cash Trends Summary 8/27/2016 4 Maximum$83,296,821.86 1/31/13 Minimum$28,657,187.47 1/01/07 Mean$56,979,556.42-- Mean - last 12 months$70,454,784.64-- 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/152/29/16 City of South Bend Cash Balances -Enterprise Funds January 1, 2007 -June 30, 2016 Cash Trends Summary 8/27/2016 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 12/31/15 64,215,673.59 1/31/16 65,062,377.54 2/29/16 67,564,110.56 3/31/16 69,211,164.87 4/30/16 69,616,174.97 5/31/16 69,399,868.04 6/30/16 68,720,691.90 Cash Trends Summary 8/27/2016 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$46,539,019.06-- Mean - last 12 months$57,249,785.92-- 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/0710/31/073/31/088/31/081/31/096/30/0911/30/094/30/109/30/102/28/117/31/1112/31/115/31/1210/31/123/31/138/31/131/31/146/30/1411/30/144/30/159/30/152/29/16 City of South Bend Cash Balances -Redevelopment Funds January 1, 2007 -June 30, 2016 Cash Trends Summary 8/27/2016 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 12/31/15 61,194,710.47 1/31/16 55,690,681.11 2/29/16 53,548,676.30 3/31/16 53,434,486.66 4/30/16 51,317,725.09 5/31/16 50,296,085.76 6/30/16 64,433,239.06 Cash Trends Summary 8/27/2016 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,476,453.50-- Mean - last 12 months$96,199,035.98-- 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/152/29/16 City of South Bend Cash Balances -Civil City Funds January 1, 2007 -June 30, 2016 Cash Trends Summary 8/27/2016 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 12/31/15 103,372,121.18 1/31/16 96,593,548.78 2/29/16 92,760,927.94 3/31/16 88,559,353.77 4/30/16 86,653,485.20 5/31/16 86,834,652.02 6/30/16 116,591,466.93 Cash Trends Summary 8/27/2016 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 2015$228,782,505.24$251,637,449.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 2015 Cash Balances and Outstanding Debt -Total Funds Fiscal Year December 31, 2006-2015 Cash Debt Cash Trends Summary 8/27/2016 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 2015$64,215,673.59$116,593,427.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 2015 Cash Balances and Outstanding Debt -Enterprise Funds Fiscal Year December 31, 2006 -2015 Cash Debt Cash Trends Summary 8/27/2016 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 2015 Cash Balances and Outstanding Debt -Governmental Funds Civil City & Redevelopment Fiscal Year December 31, 2006 -2015 Cash Debt Cash Trends Summary 8/27/2016 13 South Be nd South Bend General To tal D ebt Estimated De bt Fis ca l Ob ligatio n R ev enu e Mortga ge No te s/Loans Ca pita l Revenue M ortgage Notes/Loa ns C apit al Primary Estimated Per Pe rso nal Pe rcent of Year Bonds Bonds Bonds P ay able Le as es B onds Bon ds Payable Leases Government Popu lation Capita In come Income 2006 0 82,445,00 0 2 7,337,1 24 11,758,552 3,533,187 44,345,000 972,31 5 1 9,258,4 33 1,523,59 4 191,17 3,205 10 4,457 1,830 3,450,632,538 5.54% 2007 0 78,570,00 0 2 5,957,8 39 7,900,658 7,695,487 73,145,000 926,80 5 1 8,380,4 91 1,127,39 4 213,70 3,674 10 4,069 2,053 3,511,183,991 6.09% 2008 0 1 15,240,00 0 2 4,534,4 64 9,543,790 7,388,443 67,535,000 878,83 5 1 7,031,6 49 628,42 7 242,78 0,608 10 4,905 2,314 3,709,126,085 6.55% 2009 0 1 13,975,00 0 2 3,061,1 48 8,470,308 6,214,206 68,225,000 829,02 0 1 6,145,3 58 893,23 3 237,81 3,273 10 6,192 2,239 3,679,658,992 6.46% 2010 0 1 11,510,00 0 2 1,117,2 95 6,323,199 5,299,341 72,655,000 717,70 5 1 6,755,3 69 799,40 2 235,17 7,311 10 1,168 2,325 3,505,572,368 6.71% 2011 0 1 01,472,43 1 1 9,724,4 90 4,431,871 7,510,749 88,655,000 660,51 0 1 5,542,3 72 1,077,64 2 239,07 5,065 10 1,168 2,363 3,371,120,096 7.09% 2012 0 96,410,00 0 1 7,883,5 30 4,953,639 8,336,120 117,650,000 601,47 0 1 3,848,9 01 3,641,36 2 263,32 5,022 10 1,168 2,603 3,371,120,096 7.81% 2013 0 90,172,82 6 2 3,079,7 81 3,030,554 8,777,238 118,121,963 546,97 3 4,121,0 10 3,831,93 3 251,68 2,278 10 1,168 2,488 3,371,120,096 7.47% 2014 0 84,862,51 2 2 1,331,5 48 1,617,491 8,481,375 111,209,874 480,60 4 3,794,6 64 3,307,80 2 235,08 5,870 10 1,168 2,324 3,371,120,096 6.97% 2015 0 1 07,815,89 0 1 3,904,9 73 4,831,752 8,491,407 102,871,921 5,851,56 5 3,458,8 99 4,411,04 2 251,63 7,449 10 1,168 2,487 4,037,513,712 6.23% Percent of Total 0.00%42.8 5%5.53% 1.92% 3.37% 40.88% 2.33% 1.37% 1.7 5%1 00.00% S ou rc es: Ci ty of So uth Bend Comp re hensive Annual F inancial R epor ts Po pul atio n statistics obtained fr om the U.S. Census Bur eau. Cit y o f South Be nd est i ma ted pe rs ona l inc ome is comp ute d a s estim ated City populat i on x 20 12 South B end Me tr o Ar ea Per Capita I ncom e (se e Demo gr ap hic Statistics) City of South Bend, Indiana Ratios of Outstanding Debt by Type Last T en Fiscal Years Governmental Ac tivities Business-Ty pe Activit ies 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% 2 0 06 2007 2008 2009 2010 2011 2012 2 0 1 3 2 014 Governm ental Act ivities Deb t Capita l Leas es N o t es/Loans Payable Mortgage Bo n ds Reve nue Bonds G enera l Obliga tio n Bon ds 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% 2 0 0 6 2007 2008 2 0 0 9 2010 2011 2 0 1 2 2013 2014 B usin e ss-Type Activities Debt Ca pital Lea se s Note s/Loan s Pa y able M o rtg age Bonds Re venu e Bo nds Page 14