Loading...
HomeMy WebLinkAbout02-2018 Cash Trends SummaryPeriod Ending: Issued by: 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 2016) 8 Cash Balances and Outstanding Debt - Enterprise Funds (2006 to 2016) 8 Cash Balances and Outstanding Debt - Civil City and Redevelopment Funds (2006 to 2016) 9 Ratio of Outstanding Debt By Type (2007 to 2016) Distribution Mayor Pete Buttigieg Chief of Staff Laura O'Sullivan Deputy Chief of Staff Suzanna Fritzberg Department of Admin & Finance February 28, 2018 Controller City of South Bend Cash Trends Summary - 2007 to 2018 Cash Trends Summary 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 the Department of Administration & Finance by calling 311. Cash Trends Summary 2 January 1, 2007 - February 28, 2018 $291,289,923 12/31/2017 $122,056,198 5/31/2007 $206,231,537 -- $256,428,828 -- 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 Note: Property tax distributions are received in June and December. City of South Bend Cash Balances - Total Funds 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 $350,000,000 Cash Trends Summary 3 January 1, 2007 - February 28, 2018 City of South Bend Cash Balances - Total Funds 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 09/30/16 231,252,737.44 69,398,336.63 55,065,472.04 106,788,928.77 10/31/16 224,757,043.80 68,809,369.21 52,059,580.89 103,888,093.70 11/30/16 210,677,437.29 61,451,803.84 51,222,578.99 98,003,054.46 12/31/16 234,529,325.24 58,486,210.11 60,406,691.98 115,636,423.15 01/31/17 237,205,923.15 58,517,537.99 54,709,591.50 123,978,793.66 02/28/17 242,890,155.89 60,687,347.41 60,693,512.64 121,509,295.84 03/31/17 233,258,187.04 62,502,426.31 54,200,785.07 116,554,975.66 04/30/17 227,611,544.94 63,062,862.44 53,618,489.08 110,930,193.42 05/31/17 222,671,842.56 62,923,609.40 50,870,962.23 108,877,270.93 06/30/17 264,329,452.56 62,218,464.08 64,818,554.92 137,292,433.56 07/31/17 254,200,729.74 63,518,960.13 59,955,849.53 130,725,920.08 08/31/17 252,059,534.11 64,818,240.75 60,726,084.24 126,515,209.12 09/30/17 277,635,581.14 66,236,471.94 57,532,562.70 153,866,546.50 10/31/17 269,348,596.25 66,667,885.35 55,546,746.25 147,133,964.65 11/30/17 258,560,219.00 59,754,036.10 55,251,426.66 143,554,756.24 12/31/17 291,289,923.15 57,620,088.62 65,818,514.83 167,851,319.70 01/31/18 282,785,943.66 59,858,871.62 60,435,599.30 162,491,472.74 02/28/18 276,155,955.04 58,423,954.94 58,919,560.09 158,812,440.01 Cash Trends Summary 4 $83,296,822 1/31/2013 $28,657,187 1/1/2007 $57,885,235 -- $61,915,054 -- 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 09/30/16 69,398,336.63 04/30/08 54,929,047.02 07/31/12 67,955,663.74 10/31/16 68,809,369.21 05/31/08 53,052,472.03 08/31/12 67,464,201.30 11/30/16 61,451,803.84 06/30/08 53,204,418.10 09/30/12 65,732,654.52 12/31/16 58,486,210.11 07/31/08 54,533,563.28 10/31/12 66,270,486.67 01/31/17 58,517,537.99 08/31/08 54,251,216.99 11/30/12 59,658,568.60 02/28/17 60,687,347.41 09/30/08 53,272,451.68 12/31/12 82,506,887.41 03/31/17 62,502,426.31 10/31/08 68,706,036.43 01/31/13 83,296,821.86 04/30/17 63,062,862.44 11/30/08 54,077,562.73 02/28/13 82,484,393.54 05/31/17 62,923,609.40 12/31/08 44,639,804.67 03/31/13 82,950,715.18 06/30/17 62,218,464.08 01/31/09 45,793,529.09 04/30/13 80,568,512.43 07/31/17 63,518,960.13 02/28/09 46,941,062.25 05/31/13 79,672,318.05 08/31/17 64,818,240.75 03/31/09 47,265,006.09 06/30/13 79,520,360.08 09/30/17 66,236,471.94 04/30/09 48,061,985.20 07/31/13 79,867,774.82 10/31/17 66,667,885.35 05/31/09 46,623,111.00 08/31/13 79,782,901.50 11/30/17 59,754,036.10 06/30/09 46,662,615.02 09/30/13 79,940,103.15 12/31/17 57,620,088.62 07/31/09 45,609,990.75 10/31/13 79,663,547.72 01/31/18 59,858,871.62 08/31/09 44,700,623.82 11/30/13 72,524,668.50 02/28/18 58,423,954.94 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: Cash goes down in June and at year-end due to the timing of debt service payments. Debt service payments for Wastewater are paid out twice a year: interest in June and principal and interest in November. Debt service payments for Water Works are paid out twice a year: interest in June and principal and interest in December. The total cash has been declining as bond funds are spent down. Also, Water Works expected to be able to increase the water rate, but the rate case is still under review and rates have remained the same. Average - last 12 months City of South Bend Cash Balances - Enterprise Funds January 1, 2007 - February 28, 2018 Maximum Total Cash Minimum Total Cash Average Cash $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 5 $70,642,566 6/30/2015 $26,731,149 1/31/2009 $48,135,741 -- $58,078,446 -- 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 09/30/16 55,065,472.04 04/30/08 40,290,091.29 07/31/12 43,597,429.86 10/31/16 52,059,580.89 05/31/08 40,210,711.69 08/31/12 41,355,817.62 11/30/16 51,222,578.99 06/30/08 39,857,987.53 09/30/12 40,654,565.67 12/31/16 60,406,691.98 07/31/08 39,145,712.40 10/31/12 38,605,222.83 01/31/17 54,709,591.50 08/31/08 36,074,455.00 11/30/12 37,090,958.24 02/28/17 60,693,512.64 09/30/08 35,928,266.53 12/31/12 47,393,846.15 03/31/17 54,200,785.07 10/31/08 34,674,631.21 01/31/13 45,144,294.34 04/30/17 53,618,489.08 11/30/08 33,382,904.90 02/28/13 41,364,435.41 05/31/17 50,870,962.23 12/31/08 28,608,922.65 03/31/13 41,430,811.51 06/30/17 64,818,554.92 01/31/09 26,731,148.85 04/30/13 42,438,979.52 07/31/17 59,955,849.53 02/28/09 28,199,966.51 05/31/13 42,077,874.12 08/31/17 60,726,084.24 03/31/09 27,482,787.81 06/30/13 55,157,971.58 09/30/17 57,532,562.70 04/30/09 38,905,572.01 07/31/13 51,147,079.40 10/31/17 55,546,746.25 05/31/09 38,656,758.39 08/31/13 48,231,381.91 11/30/17 55,251,426.66 06/30/09 36,003,705.47 09/30/13 47,344,717.04 12/31/17 65,818,514.83 07/31/09 39,288,192.08 10/31/13 45,849,747.51 01/31/18 60,435,599.30 08/31/09 38,981,480.90 11/30/13 45,831,055.40 02/28/18 58,919,560.09 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 Average - last 12 months Note: TIF property tax distributions are received in June and December. Cash goes down in May and November due to the timing of debt service payments. City of South Bend Cash Balances - Redevelopment Funds January 1, 2007 - February 28, 2018 Maximum Total Cash Minimum Total Cash Average Cash $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 6 $167,851,320 12/31/2017 $53,052,887 5/31/2007 $100,311,345 -- $136,435,328 -- 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 09/30/16 106,788,928.77 04/30/08 70,171,420.22 07/31/12 118,715,231.38 10/31/16 103,888,093.70 05/31/08 63,701,375.82 08/31/12 114,706,440.90 11/30/16 98,003,054.46 06/30/08 74,301,370.46 09/30/12 116,874,708.78 12/31/16 115,636,423.15 07/31/08 77,357,385.95 10/31/12 109,940,198.76 01/31/17 123,978,793.66 08/31/08 73,612,781.45 11/30/12 107,094,590.01 02/28/17 121,509,295.84 09/30/08 70,870,856.93 12/31/12 125,384,469.62 03/31/17 116,554,975.66 10/31/08 61,421,121.17 01/31/13 119,412,780.36 04/30/17 110,930,193.42 11/30/08 60,929,733.44 02/28/13 113,373,764.76 05/31/17 108,877,270.93 12/31/08 67,373,134.56 03/31/13 107,698,520.03 06/30/17 137,292,433.56 01/31/09 56,557,371.00 04/30/13 103,435,158.90 07/31/17 130,725,920.08 02/28/09 61,446,169.16 05/31/13 98,352,454.84 08/31/17 126,515,209.12 03/31/09 75,602,332.02 06/30/13 125,169,937.15 09/30/17 153,866,546.50 04/30/09 69,388,217.66 07/31/13 121,430,845.57 10/31/17 147,133,964.65 05/31/09 68,735,769.04 08/31/13 114,023,924.90 11/30/17 143,554,756.24 06/30/09 62,589,041.72 09/30/13 115,040,485.48 12/31/17 167,851,319.70 07/31/09 66,130,768.09 10/31/13 109,822,423.95 01/31/18 162,491,472.74 08/31/09 71,071,962.93 11/30/13 104,254,613.29 02/28/18 158,812,440.01 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 Average - last 12 months Note: Property tax collections are received in June and December. Effective January 1, 2017, a total of eight (8) funds with trustee cash balances were included in the City's formal accounting system, signficantly increasing Civil City cash. Also, bond proceeds received during 2017, totaling $43.4 million, increased cash. City of South Bend Cash Balances - Civil City Funds January 1, 2007 - February 28, 2018 Maximum Total Cash Minimum Total Cash Average Cash $0 $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 Cash Trends Summary 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 2016 234,529,325.24 236,909,378.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 2016* 58,486,210.11 110,201,248.00 * Approximately $98 million of debt is for water and wastewater infrastructure 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 2016 176,043,115.13 126,708,130.00 Cash Balances and Outstanding Debt Fiscal Year December 31, 2006 - 2016 Total Funds Enterprise 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 2016 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 2016* 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 2016 Cash Debt Cash Trends Summary 8 South Bend South BendTotal Debt Estimated DebtFiscal Revenue Mortgage Notes/Loans Capital Revenue Mortgage Notes/Loans Capital PrimaryEstimated PerPersonal Percent ofYearBonds Bonds Payable Leases Bonds Bonds Payable Leases Government Population Capita Income Income200778,570,000 25,957,839 7,900,658 7,695,487 73,145,000 926,805 18,380,491 1,127,394 213,703,674 104,069 2,053 3,511,183,991 6.09%2008115,240,000 24,534,464 9,543,790 7,388,443 67,535,000 878,835 17,031,649 628,427 242,780,608 104,905 2,314 3,709,126,085 6.55%2009113,975,000 23,061,148 8,470,308 6,214,206 68,225,000 829,020 16,145,358 893,233 237,813,273 106,192 2,239 3,679,658,992 6.46%2010111,510,000 21,117,295 6,323,199 5,299,341 72,655,000 717,705 16,755,369 799,402 235,177,311 101,168 2,325 3,505,572,368 6.71%2011101,472,431 19,724,490 4,431,871 7,510,749 88,655,000 660,510 15,542,372 1,077,642 239,075,065 101,168 2,363 3,371,120,096 7.09%201296,410,000 17,883,530 4,953,639 8,336,120 117,650,000 601,470 13,848,901 3,641,362 263,325,022 101,168 2,603 3,371,120,096 7.81%201390,172,826 23,079,781 3,030,554 8,777,238 118,121,963 546,973 4,121,010 3,831,933 251,682,278 101,168 2,488 3,371,120,096 7.47%201484,862,512 21,331,548 1,617,491 8,481,375 111,209,874 480,604 3,794,664 3,307,802 235,085,870 101,168 2,324 3,371,120,096 6.97%2015107,815,890 13,904,973 4,831,752 8,491,407 102,871,921 5,851,565 3,458,899 4,411,042 251,637,449 101,168 2,487 4,037,513,712 6.23%201699,040,132 12,091,550 4,647,381 10,929,075 95,477,047 5,556,865 2,582,205 6,585,123 236,909,378 101,168 2,342 4,037,513,712 5.87%% of Total 41.81% 5.10% 1.96% 4.61% 40.30% 2.35% 1.09% 2.78% 100.00%Sources: City of South Bend Comprehensive Annual Financial Reports Population statistics obtained from the U.S. Census Bureau. City of South Bend estimated personal income is computed as estimated City population x 2012 South Bend Metro Area Per Capita Income (see Demographic Statistics)Governmental Activities Debt Business Type Activities DebtCity of South Bend, IndianaRatios of Outstanding Debt by TypeLast Ten Fiscal YearsGovernmental Activities Business-Type Activities0%10%20%30%40%50%60%70%80%90%100%2007 2008 2009 2010 2011 2012 2013 2014 2015 2016Capital LeasesNotes/LoansPayableMortgageBondsRevenue Bonds0%10%20%30%40%50%60%70%80%90%100%2007 2008 2009 2010 2011 2012 2013 2014 2015 2016Capital LeasesNotes/LoansPayableMortgageBondsRevenue BondsCash Trends Summary9