Loading...
HomeMy WebLinkAbout08-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 Cash Balances - Enterprise Funds 6 Cash Balances - Redevelopment Funds 7 Cash Balances - Civil City Funds CAFR Information: 8 Cash Balances and Outstanding Debt - Total Funds (2006 to 2015) 8 Cash Balances and Outstanding Debt - Enterprise Funds (2006 to 2015) 8 Cash Balances and Outstanding Debt - Civil City and Redevelopment Funds (2006 to 2015) 9 Ratio of Outstanding Debt By Type (2003 to 2015) Distribution Mayor Pete Buttigieg Chief of Staff James Mueller Deputy Chief of Staff Suzanna Fritzberg City Controller John Murphy Deputy City Controller Jennifer Hockenhull City Finance Director Rahman Johnson Sr. Budget Analyst Amy O'Connor August 31, 2016 Controller Cash Trends Summary 9/15/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 9/15/2016 2 $259,848,269 6/30/2013 $122,056,198 5/31/2007 $199,572,969-- $223,965,592-- Enterprise Redevelopment Civil City Enterprise Redevelopment Civil City Date Total Cash Funds Funds Funds Date Total Cash Funds Funds Funds 01/01/07 153,934,542.58 28,657,187.47 40,101,775.51 85,175,579.60 03/31/11 204,406,098.50 46,555,428.08 52,439,712.97 105,410,957.45 01/31/07 140,751,745.07 30,058,091.08 37,204,941.29 73,488,712.70 04/30/11 196,890,904.95 46,284,639.10 51,775,206.12 98,831,059.73 02/28/07 134,780,141.52 30,099,578.04 42,400,991.27 62,279,572.21 05/31/11 187,084,917.40 45,692,919.82 45,543,075.85 95,848,921.73 03/31/07 130,695,124.81 30,984,947.93 36,322,464.80 63,387,712.08 06/30/11 230,633,979.38 46,029,921.56 57,605,720.29 126,998,337.53 04/30/07 123,592,524.20 29,218,887.63 36,374,308.24 57,999,328.33 07/31/11 215,737,687.08 45,556,018.39 51,845,520.23 118,336,148.46 05/31/07 122,056,197.59 32,424,086.65 36,579,224.31 53,052,886.63 08/31/11 208,031,597.26 45,688,053.72 49,085,008.00 113,258,535.54 06/30/07 153,755,514.81 48,699,567.31 35,914,061.41 69,141,886.09 09/30/11 203,800,576.60 46,330,287.44 47,073,543.39 110,396,745.77 07/31/07 137,115,793.85 48,096,309.22 33,046,039.94 55,973,444.69 10/31/11 218,059,539.64 67,040,484.39 44,750,523.17 106,268,532.08 08/31/07 135,817,993.03 47,662,427.04 31,416,991.60 56,738,574.39 11/30/11 207,257,743.68 61,691,017.04 41,844,406.42 103,722,320.22 09/30/07 130,647,671.00 45,360,303.16 30,955,278.22 54,332,089.62 12/31/11 231,757,444.75 58,173,399.01 51,201,636.39 122,382,409.35 10/31/07 139,006,258.42 46,717,357.10 29,953,285.20 62,335,616.12 01/31/12 216,528,714.30 59,207,692.55 44,464,972.65 112,856,049.10 11/30/07 149,006,468.44 41,716,114.28 29,049,190.99 78,241,163.17 02/29/12 210,660,777.01 59,272,665.18 43,124,396.97 108,263,714.86 12/31/07 191,315,373.73 55,204,053.77 43,118,912.28 92,992,407.68 03/31/12 204,985,024.71 59,768,182.49 40,875,506.16 104,341,336.06 01/31/08 178,454,459.92 56,114,335.03 41,405,052.40 80,935,072.49 04/30/12 202,396,668.08 60,202,795.65 39,972,677.94 102,221,194.49 02/29/08 175,025,158.07 54,575,012.50 40,635,068.99 79,815,076.58 05/31/12 194,807,225.14 59,123,171.41 37,283,464.71 98,400,589.02 03/31/08 170,888,981.29 54,575,272.95 40,558,124.18 75,755,584.16 06/30/12 244,718,879.49 67,140,754.63 48,308,618.33 129,269,506.53 04/30/08 165,390,558.53 54,929,047.02 40,290,091.29 70,171,420.22 07/31/12 230,268,324.98 67,955,663.74 43,597,429.86 118,715,231.38 05/31/08 156,964,559.54 53,052,472.03 40,210,711.69 63,701,375.82 08/31/12 223,526,459.82 67,464,201.30 41,355,817.62 114,706,440.90 06/30/08 167,363,776.09 53,204,418.10 39,857,987.53 74,301,370.46 09/30/12 223,261,928.97 65,732,654.52 40,654,565.67 116,874,708.78 07/31/08 171,036,661.63 54,533,563.28 39,145,712.40 77,357,385.95 10/31/12 214,815,908.26 66,270,486.67 38,605,222.83 109,940,198.76 08/31/08 163,938,453.44 54,251,216.99 36,074,455.00 73,612,781.45 11/30/12 203,844,116.85 59,658,568.60 37,090,958.24 107,094,590.01 09/30/08 160,071,575.14 53,272,451.68 35,928,266.53 70,870,856.93 12/31/12 255,285,203.18 82,506,887.41 47,393,846.15 125,384,469.62 10/31/08 164,801,788.81 68,706,036.43 34,674,631.21 61,421,121.17 01/31/13 247,853,896.56 83,296,821.86 45,144,294.34 119,412,780.36 11/30/08 148,390,201.07 54,077,562.73 33,382,904.90 60,929,733.44 02/28/13 237,222,593.71 82,484,393.54 41,364,435.41 113,373,764.76 12/31/08 140,621,861.88 44,639,804.67 28,608,922.65 67,373,134.56 03/31/13 232,080,046.72 82,950,715.18 41,430,811.51 107,698,520.03 01/31/09 129,082,048.94 45,793,529.09 26,731,148.85 56,557,371.00 04/30/13 226,442,650.85 80,568,512.43 42,438,979.52 103,435,158.90 02/28/09 136,587,197.92 46,941,062.25 28,199,966.51 61,446,169.16 05/31/13 220,102,647.01 79,672,318.05 42,077,874.12 98,352,454.84 03/31/09 150,350,125.92 47,265,006.09 27,482,787.81 75,602,332.02 06/30/13 259,848,268.81 79,520,360.08 55,157,971.58 125,169,937.15 04/30/09 156,355,774.87 48,061,985.20 38,905,572.01 69,388,217.66 07/31/13 252,445,699.79 79,867,774.82 51,147,079.40 121,430,845.57 05/31/09 154,015,638.43 46,623,111.00 38,656,758.39 68,735,769.04 08/31/13 242,038,208.31 79,782,901.50 48,231,381.91 114,023,924.90 06/30/09 145,255,362.21 46,662,615.02 36,003,705.47 62,589,041.72 09/30/13 242,325,305.67 79,940,103.15 47,344,717.04 115,040,485.48 07/31/09 151,028,950.92 45,609,990.75 39,288,192.08 66,130,768.09 10/31/13 235,335,719.18 79,663,547.72 45,849,747.51 109,822,423.95 08/31/09 154,754,067.65 44,700,623.82 38,981,480.90 71,071,962.93 11/30/13 222,610,337.19 72,524,668.50 45,831,055.40 104,254,613.29 09/30/09 153,379,153.77 44,771,129.93 38,365,267.66 70,242,756.18 12/31/13 247,349,777.30 67,716,137.82 55,315,510.06 124,318,129.42 10/31/09 150,364,096.50 44,855,908.07 36,749,933.72 68,758,254.71 01/31/14 232,044,399.72 66,889,990.77 50,898,242.66 114,256,166.29 11/30/09 144,010,184.05 44,458,186.54 35,847,660.55 63,704,336.96 02/28/14 227,156,115.52 67,566,543.96 49,986,290.38 109,603,281.18 12/31/09 188,453,001.03 36,891,179.40 34,358,243.89 117,203,577.74 03/31/14 222,046,327.82 68,633,684.73 49,028,261.04 104,384,382.05 01/31/10 196,099,529.93 37,726,300.40 53,534,937.83 104,838,291.70 04/30/14 214,783,605.41 68,960,383.93 47,281,387.13 98,541,834.35 02/28/10 194,663,355.99 36,982,623.93 52,816,628.95 104,864,103.11 05/31/14 209,324,809.29 67,425,749.33 46,795,213.96 95,103,846.00 03/31/10 197,907,655.27 41,475,717.35 52,577,148.25 103,854,789.67 06/30/14 251,700,644.00 67,697,981.00 61,118,881.00 122,883,782.00 04/30/10 190,430,003.35 40,478,357.60 51,768,568.42 98,183,077.33 07/31/14 238,781,403.03 68,611,865.99 56,842,280.86 113,327,256.18 05/31/10 201,229,420.61 38,739,522.56 50,881,687.36 111,608,210.69 08/31/14 234,086,687.41 68,747,483.87 55,735,447.17 109,603,756.37 06/30/10 230,557,975.59 39,738,881.62 62,539,377.78 128,279,716.19 09/30/14 233,595,370.44 69,430,344.98 54,889,194.46 109,275,831.00 07/31/10 217,064,522.90 42,020,069.17 55,401,804.58 119,642,649.15 10/31/14 225,913,486.47 70,431,027.92 54,196,891.83 101,285,566.72 08/31/10 210,387,480.23 40,331,826.60 53,423,401.23 116,632,252.40 11/30/14 216,583,420.38 64,909,392.12 54,554,819.33 97,119,208.93 09/30/10 211,494,373.45 40,245,656.32 52,832,007.68 118,416,709.45 12/31/14 239,808,095.03 61,623,499.90 65,903,128.76 112,281,466.37 10/31/10 204,642,650.38 39,984,803.80 51,745,774.22 112,912,072.36 01/31/15 225,471,264.56 61,585,040.94 60,387,162.56 103,499,061.06 11/30/10 198,782,418.22 35,695,100.47 49,573,730.89 113,513,586.86 02/28/15 221,854,105.82 63,269,776.69 58,990,110.88 99,594,218.25 12/31/10 227,739,252.18 41,300,042.16 65,164,721.07 121,274,488.95 03/31/15 215,278,052.12 64,288,370.38 58,654,868.03 92,334,813.71 01/31/11 214,107,834.98 42,918,366.28 57,392,911.65 113,796,557.05 04/30/15 213,330,317.66 65,430,174.18 57,972,838.77 89,927,304.71 02/28/11 208,263,626.92 44,793,554.36 53,822,791.88 109,647,280.68 05/31/15 209,379,494.75 65,714,228.05 57,630,884.95 86,034,381.75 City of South Bend Cash Balances - Total Funds January 1, 2007 - August 31, 2016 Note: Property tax collections are in June and December. Maximum Total Cash Minimum Total Cash Average Cash Average - last 12 months $0 $50,000,000 $100,000,000 $150,000,000 $200,000,000 $250,000,000 $300,000,000 Cash Trends Summary 9/15/2016 3 City of South Bend Cash Balances - Total Funds January 1, 2007 - August 31, 2016 Enterprise Redevelopment Civil City Date Total Cash Funds Funds Funds 06/30/15 249,603,497.41 68,746,632.56 70,642,566.10 110,214,298.75 07/31/15 236,381,857.01 70,884,051.33 65,048,413.67 100,449,392.01 08/31/15 228,483,356.31 72,023,119.13 61,042,169.83 95,418,067.35 09/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 01/31/16 217,346,607.43 65,062,377.54 55,690,681.11 96,593,548.78 02/29/16 213,873,714.80 67,564,110.56 53,548,676.30 92,760,927.94 03/31/16 211,205,005.30 69,211,164.87 53,434,486.66 88,559,353.77 04/30/16 207,587,385.26 69,616,174.97 51,317,725.09 86,653,485.20 05/31/16 206,530,605.82 69,399,868.04 50,296,085.76 86,834,652.02 06/30/16 249,745,397.89 68,720,691.90 64,433,239.06 116,591,466.93 07/31/16 236,139,560.82 69,227,392.30 58,518,600.58 121,999,405.01 08/31/16 229,469,472.57 67,673,880.42 55,966,718.35 105,828,873.80 Cash Trends Summary 9/15/2016 4 $83,296,822 1/31/2013 $28,657,187 1/1/2007 $57,175,643-- $69,954,293-- Date Cash Date Cash Date Cash 01/01/07 28,657,187.47 03/31/11 46,555,428.08 06/30/15 68,746,632.56 01/31/07 30,058,091.08 04/30/11 46,284,639.10 07/31/15 70,884,051.33 02/28/07 30,099,578.04 05/31/11 45,692,919.82 08/31/15 72,023,119.13 03/31/07 30,984,947.93 06/30/11 46,029,921.56 09/30/15 75,617,268.98 04/30/07 29,218,887.63 07/31/11 45,556,018.39 10/31/15 77,155,814.42 05/31/07 32,424,086.65 08/31/11 45,688,053.72 11/30/15 75,987,100.36 06/30/07 48,699,567.31 09/30/11 46,330,287.44 12/31/15 64,215,673.59 07/31/07 48,096,309.22 10/31/11 67,040,484.39 01/31/16 65,062,377.54 08/31/07 47,662,427.04 11/30/11 61,691,017.04 02/29/16 67,564,110.56 09/30/07 45,360,303.16 12/31/11 58,173,399.01 03/31/16 69,211,164.87 10/31/07 46,717,357.10 01/31/12 59,207,692.55 04/30/16 69,616,174.97 11/30/07 41,716,114.28 02/29/12 59,272,665.18 05/31/16 69,399,868.04 12/31/07 55,204,053.77 03/31/12 59,768,182.49 06/30/16 68,720,691.90 01/31/08 56,114,335.03 04/30/12 60,202,795.65 07/31/16 69,227,392.30 02/29/08 54,575,012.50 05/31/12 59,123,171.41 08/31/16 67,673,880.42 03/31/08 54,575,272.95 06/30/12 67,140,754.63 04/30/08 54,929,047.02 07/31/12 67,955,663.74 05/31/08 53,052,472.03 08/31/12 67,464,201.30 06/30/08 53,204,418.10 09/30/12 65,732,654.52 07/31/08 54,533,563.28 10/31/12 66,270,486.67 08/31/08 54,251,216.99 11/30/12 59,658,568.60 09/30/08 53,272,451.68 12/31/12 82,506,887.41 10/31/08 68,706,036.43 01/31/13 83,296,821.86 11/30/08 54,077,562.73 02/28/13 82,484,393.54 12/31/08 44,639,804.67 03/31/13 82,950,715.18 01/31/09 45,793,529.09 04/30/13 80,568,512.43 02/28/09 46,941,062.25 05/31/13 79,672,318.05 03/31/09 47,265,006.09 06/30/13 79,520,360.08 04/30/09 48,061,985.20 07/31/13 79,867,774.82 05/31/09 46,623,111.00 08/31/13 79,782,901.50 06/30/09 46,662,615.02 09/30/13 79,940,103.15 07/31/09 45,609,990.75 10/31/13 79,663,547.72 08/31/09 44,700,623.82 11/30/13 72,524,668.50 09/30/09 44,771,129.93 12/31/13 67,716,137.82 10/31/09 44,855,908.07 01/31/14 66,889,990.77 11/30/09 44,458,186.54 02/28/14 67,566,543.96 12/31/09 36,891,179.40 03/31/14 68,633,684.73 01/31/10 37,726,300.40 04/30/14 68,960,383.93 02/28/10 36,982,623.93 05/31/14 67,425,749.33 03/31/10 41,475,717.35 06/30/14 67,697,981.00 04/30/10 40,478,357.60 07/31/14 68,611,865.99 05/31/10 38,739,522.56 08/31/14 68,747,483.87 06/30/10 39,738,881.62 09/30/14 69,430,344.98 07/31/10 42,020,069.17 10/31/14 70,431,027.92 08/31/10 40,331,826.60 11/30/14 64,909,392.12 09/30/10 40,245,656.32 12/31/14 61,623,499.90 10/31/10 39,984,803.80 01/31/15 61,585,040.94 11/30/10 35,695,100.47 02/28/15 63,269,776.69 12/31/10 41,300,042.16 03/31/15 64,288,370.38 01/31/11 42,918,366.28 04/30/15 65,430,174.18 02/28/11 44,793,554.36 05/31/15 65,714,228.05 Note: Property tax collections are in June and December. City of South Bend Cash Balances - Enterprise Funds January 1, 2007 - August 31, 2016 Maximum Total Cash Minimum Total Cash Average Cash Average - last 12 months $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 Cash Trends Summary 9/15/2016 5 $70,642,566 6/30/2015 $26,731,149 1/31/2009 $46,721,987-- $56,282,681-- Date Cash Date Cash Date Cash 01/01/07 40,101,775.51 03/31/11 52,439,712.97 06/30/15 70,642,566.10 01/31/07 37,204,941.29 04/30/11 51,775,206.12 07/31/15 65,048,413.67 02/28/07 42,400,991.27 05/31/11 45,543,075.85 08/31/15 61,042,169.83 03/31/07 36,322,464.80 06/30/11 57,605,720.29 09/30/15 59,936,471.64 04/30/07 36,374,308.24 07/31/11 51,845,520.23 10/31/15 56,339,743.69 05/31/07 36,579,224.31 08/31/11 49,085,008.00 11/30/15 54,715,027.81 06/30/07 35,914,061.41 09/30/11 47,073,543.39 12/31/15 61,194,710.47 07/31/07 33,046,039.94 10/31/11 44,750,523.17 01/31/16 55,690,681.11 08/31/07 31,416,991.60 11/30/11 41,844,406.42 02/29/16 53,548,676.30 09/30/07 30,955,278.22 12/31/11 51,201,636.39 03/31/16 53,434,486.66 10/31/07 29,953,285.20 01/31/12 44,464,972.65 04/30/16 51,317,725.09 11/30/07 29,049,190.99 02/29/12 43,124,396.97 05/31/16 50,296,085.76 12/31/07 43,118,912.28 03/31/12 40,875,506.16 06/30/16 64,433,239.06 01/31/08 41,405,052.40 04/30/12 39,972,677.94 07/31/16 58,518,600.58 02/29/08 40,635,068.99 05/31/12 37,283,464.71 08/31/16 55,966,718.35 03/31/08 40,558,124.18 06/30/12 48,308,618.33 04/30/08 40,290,091.29 07/31/12 43,597,429.86 05/31/08 40,210,711.69 08/31/12 41,355,817.62 06/30/08 39,857,987.53 09/30/12 40,654,565.67 07/31/08 39,145,712.40 10/31/12 38,605,222.83 08/31/08 36,074,455.00 11/30/12 37,090,958.24 09/30/08 35,928,266.53 12/31/12 47,393,846.15 10/31/08 34,674,631.21 01/31/13 45,144,294.34 11/30/08 33,382,904.90 02/28/13 41,364,435.41 12/31/08 28,608,922.65 03/31/13 41,430,811.51 01/31/09 26,731,148.85 04/30/13 42,438,979.52 02/28/09 28,199,966.51 05/31/13 42,077,874.12 03/31/09 27,482,787.81 06/30/13 55,157,971.58 04/30/09 38,905,572.01 07/31/13 51,147,079.40 05/31/09 38,656,758.39 08/31/13 48,231,381.91 06/30/09 36,003,705.47 09/30/13 47,344,717.04 07/31/09 39,288,192.08 10/31/13 45,849,747.51 08/31/09 38,981,480.90 11/30/13 45,831,055.40 09/30/09 38,365,267.66 12/31/13 55,315,510.06 10/31/09 36,749,933.72 01/31/14 50,898,242.66 11/30/09 35,847,660.55 02/28/14 49,986,290.38 12/31/09 34,358,243.89 03/31/14 49,028,261.04 01/31/10 53,534,937.83 04/30/14 47,281,387.13 02/28/10 52,816,628.95 05/31/14 46,795,213.96 03/31/10 52,577,148.25 06/30/14 61,118,881.00 04/30/10 51,768,568.42 07/31/14 56,842,280.86 05/31/10 50,881,687.36 08/31/14 55,735,447.17 06/30/10 62,539,377.78 09/30/14 54,889,194.46 07/31/10 55,401,804.58 10/31/14 54,196,891.83 08/31/10 53,423,401.23 11/30/14 54,554,819.33 09/30/10 52,832,007.68 12/31/14 65,903,128.76 10/31/10 51,745,774.22 01/31/15 60,387,162.56 11/30/10 49,573,730.89 02/28/15 58,990,110.88 12/31/10 65,164,721.07 03/31/15 58,654,868.03 01/31/11 57,392,911.65 04/30/15 57,972,838.77 02/28/11 53,822,791.88 05/31/15 57,630,884.95 Note: Property tax collections are in June and December. City of South Bend Cash Balances - Redevelopment Funds January 1, 2007 - August 31, 2016 Maximum Total Cash Minimum Total Cash Average Cash Average - last 12 months $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 Cash Trends Summary 9/15/2016 6 $129,269,507 6/30/2012 $53,052,887 5/31/2007 $95,791,628-- $98,862,438-- Date Cash Date Cash Date Cash 01/01/07 85,175,579.60 03/31/11 105,410,957.45 06/30/15 110,214,298.75 01/31/07 73,488,712.70 04/30/11 98,831,059.73 07/31/15 100,449,392.01 02/28/07 62,279,572.21 05/31/11 95,848,921.73 08/31/15 95,418,067.35 03/31/07 63,387,712.08 06/30/11 126,998,337.53 09/30/15 98,961,223.68 04/30/07 57,999,328.33 07/31/11 118,336,148.46 10/31/15 96,618,498.09 05/31/07 53,052,886.63 08/31/11 113,258,535.54 11/30/15 91,575,694.83 06/30/07 69,141,886.09 09/30/11 110,396,745.77 12/31/15 103,372,121.18 07/31/07 55,973,444.69 10/31/11 106,268,532.08 01/31/16 96,593,548.78 08/31/07 56,738,574.39 11/30/11 103,722,320.22 02/29/16 92,760,927.94 09/30/07 54,332,089.62 12/31/11 122,382,409.35 03/31/16 88,559,353.77 10/31/07 62,335,616.12 01/31/12 112,856,049.10 04/30/16 86,653,485.20 11/30/07 78,241,163.17 02/29/12 108,263,714.86 05/31/16 86,834,652.02 12/31/07 92,992,407.68 03/31/12 104,341,336.06 06/30/16 116,591,466.93 01/31/08 80,935,072.49 04/30/12 102,221,194.49 07/31/16 121,999,405.01 02/29/08 79,815,076.58 05/31/12 98,400,589.02 08/31/16 105,828,873.80 03/31/08 75,755,584.16 06/30/12 129,269,506.53 04/30/08 70,171,420.22 07/31/12 118,715,231.38 05/31/08 63,701,375.82 08/31/12 114,706,440.90 06/30/08 74,301,370.46 09/30/12 116,874,708.78 07/31/08 77,357,385.95 10/31/12 109,940,198.76 08/31/08 73,612,781.45 11/30/12 107,094,590.01 09/30/08 70,870,856.93 12/31/12 125,384,469.62 10/31/08 61,421,121.17 01/31/13 119,412,780.36 11/30/08 60,929,733.44 02/28/13 113,373,764.76 12/31/08 67,373,134.56 03/31/13 107,698,520.03 01/31/09 56,557,371.00 04/30/13 103,435,158.90 02/28/09 61,446,169.16 05/31/13 98,352,454.84 03/31/09 75,602,332.02 06/30/13 125,169,937.15 04/30/09 69,388,217.66 07/31/13 121,430,845.57 05/31/09 68,735,769.04 08/31/13 114,023,924.90 06/30/09 62,589,041.72 09/30/13 115,040,485.48 07/31/09 66,130,768.09 10/31/13 109,822,423.95 08/31/09 71,071,962.93 11/30/13 104,254,613.29 09/30/09 70,242,756.18 12/31/13 124,318,129.42 10/31/09 68,758,254.71 01/31/14 114,256,166.29 11/30/09 63,704,336.96 02/28/14 109,603,281.18 12/31/09 117,203,577.74 03/31/14 104,384,382.05 01/31/10 104,838,291.70 04/30/14 98,541,834.35 02/28/10 104,864,103.11 05/31/14 95,103,846.00 03/31/10 103,854,789.67 06/30/14 122,883,782.00 04/30/10 98,183,077.33 07/31/14 113,327,256.18 05/31/10 111,608,210.69 08/31/14 109,603,756.37 06/30/10 128,279,716.19 09/30/14 109,275,831.00 07/31/10 119,642,649.15 10/31/14 101,285,566.72 08/31/10 116,632,252.40 11/30/14 97,119,208.93 09/30/10 118,416,709.45 12/31/14 112,281,466.37 10/31/10 112,912,072.36 01/31/15 103,499,061.06 11/30/10 113,513,586.86 02/28/15 99,594,218.25 12/31/10 121,274,488.95 03/31/15 92,334,813.71 01/31/11 113,796,557.05 04/30/15 89,927,304.71 02/28/11 109,647,280.68 05/31/15 86,034,381.75 Note: Property tax collections are in June and December. City of South Bend Cash Balances - Civil City Funds January 1, 2007 - August 31, 2016 Maximum Total Cash Minimum Total Cash Average Cash Average - last 12 months $0 $20,000,000 $40,000,000 $60,000,000 $80,000,000 $100,000,000 $120,000,000 $140,000,000 Cash Trends Summary 9/15/2016 7 Year End Dec 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 Year End Dec 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 Year End Dec 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 2015 164,566,831.65 135,044,022.00 Cash Balances and Outstanding Debt Fiscal Year December 31, 2006-2015 Enterprise Funds Total Funds Civil City & Redevelopment Funds $- $50,000,000 $100,000,000 $150,000,000 $200,000,000 $250,000,000 $300,000,000 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 Cash Debt $- $20,000,000 $40,000,000 $60,000,000 $80,000,000 $100,000,000 $120,000,000 $140,000,000 $160,000,000 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 Cash Debt $- $20,000,000 $40,000,000 $60,000,000 $80,000,000 $100,000,000 $120,000,000 $140,000,000 $160,000,000 $180,000,000 $200,000,000 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 Cash Debt Cash Trends Summary 9/15/2016 8 South BendSouth BendTotalDebtEstimatedDebt FiscalRevenueMortgageNotes/LoansCapital RevenueMortgageNotes/LoansCapitalPrimaryEstimatedPerPersonalPercent ofYearBondsBondsPayableLeasesBondsBondsPayableLeasesGovernmentPopulationCapitaIncomeIncome2006 82,445,00027,337,12411,758,5523,533,18744,345,000972,31519,258,4331,523,594191,173,205104,4571,8303,450,632,5385.54% 2007 78,570,00025,957,8397,900,6587,695,48773,145,000926,80518,380,4911,127,394213,703,674104,0692,0533,511,183,9916.09% 2008 115,240,00024,534,4649,543,7907,388,44367,535,000878,83517,031,649628,427242,780,608104,9052,3143,709,126,0856.55% 2009 113,975,00023,061,1488,470,3086,214,20668,225,000829,02016,145,358893,233237,813,273106,1922,2393,679,658,9926.46% 2010 111,510,00021,117,2956,323,1995,299,34172,655,000717,70516,755,369799,402235,177,311101,1682,3253,505,572,3686.71% 2011 101,472,43119,724,4904,431,8717,510,74988,655,000660,51015,542,3721,077,642239,075,065101,1682,3633,371,120,0967.09% 2012 96,410,00017,883,5304,953,6398,336,120117,650,000601,47013,848,9013,641,362263,325,022101,1682,6033,371,120,0967.81% 2013 90,172,82623,079,7813,030,5548,777,238118,121,963546,9734,121,0103,831,933251,682,278101,1682,4883,371,120,0967.47% 2014 84,862,51221,331,5481,617,4918,481,375111,209,874480,6043,794,6643,307,802235,085,870101,1682,3243,371,120,0966.97% 2015 107,815,89013,904,9734,831,7528,491,407102,871,9215,851,5653,458,8994,411,042251,637,449101,1682,4874,037,513,7126.23%% of Total42.85%5.53% 1.92% 3.37% 40.88% 2.33% 1.37% 1.75%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) City of South Bend, Indiana Ratios of Outstanding Debt by Type Last Ten Fiscal YearsGovernmental ActivitiesBusiness-Type Activities 0%10%20%30%40%50%60%70%80%90%100% 2006200720082009201020112012201320142015Governmental Activities Debt Capital LeasesNotes/Loans PayableMortgage BondsRevenue Bonds 0% 10%20%30%40%50%60%70%80%90%100% 2006200720082009201020112012201320142015Business Type Activities Debt Capital LeasesNotes/Loans PayableMortgage BondsRevenue Bonds Cash Trends Summary 9/15/2016 9