Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2019-09 Monthly Cash Report
Period Ending: Issued by: Page Number(s)Contents 2 Narrative 3 - 5 Controller's Cash Report 6 - 7 Cash Reserves Summary by Fund Status 8 - 9 Cash Trends - All Funds 10 Cash Trends - Enterprise Funds 11 Cash Trends - Redevelopment Funds 12 Cash Trends - Civil City Funds Distribution Mayor Pete Buttigieg Chief of Staff Laura O'Sullivan Deputy Chief of Staff Genevieve Miller Common Council Department Heads Fiscal Officers September 30, 2019 Controller City of South Bend Monthly Cash Report 2019-09 Monthly Cash Report 1 Questions If you should have additional questions, please contact the Department of Administration & Finance by calling 311. Narrative Fiscal Responsibility The City’s management team is responsible for establishing and maintaining an internal control structure designed to ensure that the assets of the City are protected from loss, theft, or misuse and to ensure that adequate accounting data is compiled to allow for the preparation of financial statements in conformity with generally accepted accounting principles. Controller's Cash Report (pages 3-5) The Controller’s Cash Report is a monthly summary of cash and investment transactions within the current period by Fund. It summarizes the cash received, interest earned, cash disbursed, and cash transferred between Funds within the City of South Bend as well as any loans between Funds. The report provides a month-end view of the City’s cash balance in the reporting period. Cash Reserves Summary (pages 6-8) The purpose of the Cash Reserves Summary Report is keep track of whether the City's funds are meeting their cash reserve requirement. Cash reserve requirements are set for each fund by the City of South Bend or other governing body (e.g. bond counsel, Century Center Board of Managers). Cash Trends Summary (pages 9-13) The purpose of the Cash Trends Summary 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. Cash Reserve Requirements Cash reserve requirements are typically based on fund type. - Most City funds are assigned a cash reserve requirement of a percentage of the fund's annual expenditures. - The Rainy Day Fund 102 has a reserve requirement of 3% of the City's prior year operational expenditures, excluding one-time capital expenditures. - Some funds have a set dollar amount as the reserve requirement, such as the Police Take Home Vehicle Fund 278 and the Century Center Capital Fund 671. - Capital project funds, grant funds, and bond capital funds do not have reserve requirements as they are spent down to zero. - The IT/Innovation/311 Call Center Fund 279 does not have a reserve requirement because it is an internal service fund, reimbursed by departments within other City funds. Its budgeted revenues are equal to its budgeted expenditures. - Debt service reserve funds are required to hold all reserves until the respective debt has been paid in full. The amount is often defined in bond covenants. Pooled Cash The City utilities pooled cash, the majority of the City's money being held in a single bank account. Although the money is in a single account, each fund retains ownership of its own cash. Any interest earned on the bank account is distributed amongst the funds based on each funds' cash balance. Trustee Cash The City also has cash maintained by trustees or escrow agents at financial institutions and expended upon the provision by the City of a proper claim form and invoice. These funds are typically for debt service payments, debt service reserves, or capital project expenditures. Changes in Cash Balance 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. Negative Cash Balances Due to the timing of revenue and expenditures, certain funds will not meet cash reserve requirements and may even have a negative cash balance at different times throughout the year. Although a fund has a negative cash balance, the City does not have negative cash overall. Pooled cash can cover those funds so necessary expenditures can be made even if revenues have not been received yet. Fund 312, has a negative cash balance. - The 2017 Parks Bond Debt Service Fund 312 receives property tax revenue in June and December, but still has to make a debt payments in January and July. When property tax revenue is received in December, this fund won't be negative. 2019-09 Monthly Cash Report 2 City of South BendController's Cash ReportOpening Interest Transfers Transfers Ending Total Cash & Interfund LoansFund Fund Name Cash Balance Receipts Disbursements Earned In Out Cash Balance Investments Investments (Borrowing)City Controlled FundsGeneral Fund101 GENERAL FUND $36,969,830.53$2,411,875.45$4,566,458.74$74,053.90$120,000.00$152,013.00$34,857,288.14$0.00$34,857,288.14$0.00Special Revenue Funds102 RAINY DAY FUND 10,625,745.85 0.00 0.00 20,797.83 0.00 0.00 10,646,543.68 0.0010,646,543.680.00201 PARKS & RECREATION 4,677,529.24 2,476,929.95 2,451,420.92 9,915.44 100,000.00 0.00 4,812,953.71 0.004,812,953.710.00202 MOTOR VEHICLE HIGHWAY 4,813,177.90 334,101.09 620,395.34 10,010.40 946,937.50 625,000.00 4,858,831.55 0.004,858,831.550.00209 STUDEBAKER/OLIVER REVERTING GRANTS 938,592.46 0.00 0.00 1,788.01 0.00 0.00 940,380.47 0.00940,380.47100,000.00210 DEPT COMMUNITY INVESTMENT STATE GRANTS 101,587.24 0.00 22,884.36 202.54 0.00 0.00 78,905.42 0.0078,905.420.00211 DCI OPERATING FUND 307,242.85 447,657.61 225,573.80 793.34 587,658.25 0.00 1,117,778.25 0.001,117,778.250.00212 DEPARTMENT OF COMMUNITY INVESTMENT 313,569.09 576,831.85 554,069.13 240.56 0.00 0.00 336,572.37 0.00336,572.370.00216 POLICE STATE SEIZURES 235,502.40 50.00 0.00 460.95 0.00 0.00 236,013.35 0.00236,013.350.00217 GIFT, DONATION, BEQUEST 617,506.81 159,566.26 91,159.97 1,091.67 0.00 0.00 687,004.77 69,231.46756,236.230.00218 POLICE CURFEW VIOLATIONS 13,348.25 0.00 0.00 26.11 0.00 0.00 13,374.36 0.0013,374.360.00219 UNSAFE BUILDING 657,732.20 15,270.44 50,158.67 1,326.27 170,372.75 0.00 794,542.99 0.00794,542.990.00220 LAW ENFORCEMENT CONTINUING EDUCATION 390,444.02 18,681.52 21,484.31 773.00 0.00 0.00 388,414.23 0.00388,414.230.00221 LANDLORD REGISTRATION 13,596.03 1,600.00 0.00 25.89 0.00 0.00 15,221.92 0.0015,221.920.00227 LOSS RECOVERY FUND 599,393.71 0.00 0.00 1,173.20 0.00 0.00 600,566.91 0.00600,566.910.00249 PUBLIC SAFETY L.O.I.T. 3,617,120.11 713,379.58 662,094.53 6,717.30 0.00 0.00 3,675,122.46 0.003,675,122.460.00251 LOCAL ROADS & STREETS 5,546,894.25 176,212.78 136,521.87 10,796.87 625,000.00 0.00 6,222,382.03 0.006,222,382.030.00257 LOIT 2016 SPECIAL DISTRIBUTION 312,051.78 0.00 40,930.26 718.19 0.00 0.00 271,839.71 0.00271,839.710.00258 HUMAN RIGHTS - FEDERAL GRANT 410,273.90 249.01 13,793.86 825.52 0.00 0.00 397,554.57 0.00397,554.570.00265 LOCAL ROAD & BRIDGE GRANT 887,705.82 0.00 558,776.42 724.51 0.00 0.00 329,653.91 0.00329,653.910.00266 MVH RESTRICTED 1,309,682.74 286,326.05 292,009.22 2,477.93 0.00 0.00 1,306,477.50 0.001,306,477.500.00273 MORRIS PAC/PALAIS ROYALE MARKETING 67,973.46 1,722.00 0.00 133.04 0.00 0.00 69,828.50 0.0069,828.500.00274 MORRIS PAC SELF-PROMOTION 154,078.57 0.00 0.00 299.55 0.00 0.00 154,378.12 0.00154,378.120.00280 POLICE BLOCK GRANTS 4,053.72 0.00 0.00 7.93 0.00 0.00 4,061.65 0.004,061.650.00289 HAZMAT 28,289.93 0.00 0.00 55.37 0.00 0.00 28,345.30 0.0028,345.300.00291 INDIANA RIVER RESCUE 274,112.10 16,110.00 3,712.57 534.89 0.00 0.00 287,044.42 0.00287,044.420.00292 POLICE GRANTS 26,715.50 0.00 0.00 0.00 0.00 0.00 26,715.50 0.0026,715.500.00294 REGIONAL POLICE ACADEMY 112,927.24 0.00 648.36 221.58 0.00 0.00 112,500.46 0.00112,500.460.00295 COPS MORE GRANT 176,741.48 2,227.48 300.00 316.30 0.00 0.00 178,985.26 0.00178,985.260.00299 POLICE FEDERAL DRUG ENFORCEMENT 112,775.43 0.00 0.00 219.76 0.00 0.00 112,995.19 0.00112,995.190.00404 COUNTY OPTION INCOME TAX 13,455,588.87 1,067,643.83 586,195.60 25,980.88 0.00 1,191,082.25 12,771,935.73 0.0012,771,935.73450,253.20408 ECONOMIC DEVELOPMENT INCOME TAX 18,433,372.15 966,485.50 107,892.09 35,855.47 0.00 1,381,759.27 17,946,061.76 0.0017,946,061.760.00410 URBAN DEVELOPMENT ACTION GRANT (UDAG) 18,237.85 40,026.48 0.00 35.70 0.00 0.00 58,300.03 0.0058,300.03(450,253.20)655 PROJECT RELEAF 587,959.58 37,222.61 3,397.40 1,122.91 0.00 137,500.00 485,407.70 0.00485,407.700.00705 POLICE K-9 UNIT 2,371.19 0.00 0.00 4.64 0.00 0.00 2,375.83 0.002,375.830.00Total Special Revenue Funds69,843,893.727,338,294.046,443,418.68135,673.552,429,968.503,335,341.5269,969,069.61 69,231.4670,038,301.07100,000.00 Debt Service Fund312 2017 PARKS BOND DEBT SERVICE(367,720.19)0.00 0.00 0.00 0.00 0.00(367,720.19)0.00(367,720.19)0.00350 2018 FIRE ST #9 DEBT SERVICE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.000.00755 SB BUILDING CORPORATION 2,006,446.93 0.00 1,195,275.00 2,649.84 0.00 0.00 813,821.77 0.00813,821.770.00757 2015 PARKS BOND DEBT SERVICE 623,658.56 0.00 190,540.63 456.64 31,236.77 0.00 464,811.34 0.00464,811.340.00760 EDDY ST. COMMONS DEBT SERVICE 4,107,658.65 0.00 648,750.00 774.41 0.00 0.00 3,459,683.06 0.003,459,683.060.00Capital Project Funds401 COVELESKI STADIUM CAPITAL 9,357.34 0.00 0.00 18.31 0.00 0.00 9,375.65 0.009,375.650.00406 CUMULATIVE CAPITAL DEVELOPMENT 356,266.16 0.00 0.00 821.99 0.00 0.00 357,088.15 0.00357,088.150.00407 CUMULATIVE CAPITAL IMPROVEMENT 566,530.00 25,000.00 0.00 1,108.88 0.00 0.00 592,638.88 0.00592,638.880.00412 MAJOR MOVES CONSTRUCTION 2,557,473.98 0.00 313,109.20 4,830.90 0.00 0.00 2,249,195.68 0.002,249,195.682,388,902.44416 MORRIS PERFORMING ARTS CENTER CAPITAL 399,824.54 0.00 0.00 782.37 0.00 0.00 400,606.91 0.00400,606.910.00450 PALAIS ROYALE HISTORIC PRESERVATION 101,275.45 1,345.18 0.00 196.72 0.00 0.00 102,817.35 0.00102,817.350.00451 2018 FIRE STATION #9 CAPITAL 595,589.33 2,526.90 78,184.00 1,619.69 0.00 0.00 521,551.92 0.00521,551.920.00452 2018 TIF PARK BOND CAPITAL 7,114,833.95 0.00 1,124,564.67 14,044.59 0.00 0.00 6,004,313.87 0.006,004,313.870.00453 2018 ZOO BOND CAPITAL 941,064.54 0.00 371,377.38 1,181.19 0.00 0.00 570,868.35 0.00570,868.350.00471 2017 PARKS BOND CAPITAL 10,579,248.43 0.00 1,171,164.64 20,800.82 0.00 0.00 9,428,884.61 0.009,428,884.610.00Month of: September 20192019-09 Monthly Cash Report3 City of South BendController's Cash ReportOpening Interest Transfers Transfers Ending Total Cash & Interfund LoansFund Fund Name Cash Balance Receipts Disbursements Earned In Out Cash Balance Investments Investments (Borrowing)Month of: September 2019750 EQUIPMENT / VEHICLE LEASING 1,869,471.45 0.00 534,579.00 998.02 0.00 0.00 1,335,890.47 0.001,335,890.470.00751 2015 PARKS BOND CAPITAL 201,631.82 0.00 0.00 43.43 0.00 0.00 201,675.25 0.00201,675.250.00759 EDDY ST COMMONS CAPITAL 5,078,986.70 0.00 293,158.95 5.47 0.00 0.00 4,785,833.22 0.004,785,833.220.00Total Capital & Debt Service Funds36,741,597.6428,872.085,920,703.4750,333.2731,236.770.00 30,931,336.290.0030,931,336.292,388,902.44Enterprise Funds287 EMS CAPITAL 2,307,131.72 2,831.80 103,249.04 4,761.54 136,423.75 0.00 2,347,899.77 0.002,347,899.770.00288 EMS OPERATING 2,224,607.09 574,565.26 520,157.06 6,591.42 247,234.00 0.00 2,532,840.71 0.002,532,840.710.00600 CONSOLIDATED BUILDING DEPARTMENT 1,827,296.82 132,453.98 319,385.90 3,797.88 632,227.25 39,735.75 2,236,654.28 0.002,236,654.280.00601 PARKING GARAGES 1,118,513.01 90,019.20 31,289.38 2,063.92 0.00 0.00 1,179,306.75 0.001,179,306.750.00610 SOLID WASTE OPERATIONS 342,230.65 460,912.69 339,939.23 817.53 0.00 223,961.00 240,060.64 0.00240,060.640.00611 SOLID WASTE CAPITAL 63,190.59 0.00 22.60 403.51 223,961.00 0.00 287,532.50 0.00287,532.500.00620 WATER WORKS OPERATIONS 3,396,280.22 2,428,619.60 1,342,237.70 5,298.33 10,758.47 498,083.00 4,000,635.92 0.004,000,635.920.00622 WATER WORKS CAPITAL 3,718,720.17 1,282.50 297,537.00 7,312.86 270,083.00 0.00 3,699,861.53 0.003,699,861.530.00624 WATER WORKS CUSTOMER DEPOSIT 1,503,127.69 17,534.61 12,765.14 2,940.74 0.00 2,940.74 1,507,897.16 0.001,507,897.160.00625 WATER WORKS SINKING FUND 1,093,992.27 0.00 0.00 2,143.88 168,000.00 2,143.88 1,261,992.27 0.001,261,992.270.00626 WATER WORKS BOND RESERVE 1,438,528.81 0.00 0.00 2,808.90 0.00 0.00 1,441,337.71 0.001,441,337.710.00629 WATER WORKS RESERVE - O & M 2,895,721.40 0.00 0.00 5,673.85 0.00 5,673.85 2,895,721.40 0.002,895,721.400.00640 SEWER REPAIR INSURANCE 2,104,147.80 54,354.45 48,759.31 4,130.65 0.00 0.00 2,113,873.59 0.002,113,873.590.00641 SEWAGE WORKS OPERATIONS 11,756,904.81 3,506,645.77 2,271,432.68 21,922.92 60,876.20 60,000.00 13,014,917.02 0.0013,014,917.020.00642 SEWAGE WORKS CAPITAL 11,440,657.01 6,183.00 280,970.19 22,738.26 0.00 0.00 11,188,608.08 0.0011,188,608.080.00643 SEWAGE WORKS RESERVE - O & M 5,550,801.29 0.00 0.00 10,876.20 0.00 10,876.20 5,550,801.29 0.005,550,801.290.00649 SEWAGE WORKS BOND SINKING 7,877,673.59 0.00 0.00 15,419.00 0.00 0.00 7,893,092.59 0.007,893,092.590.00653 SEWAGE WORKS DEBT SERVICE RESERVE 4,259,034.03 0.00 0.00 7,492.99 0.00 0.00 4,266,527.02 0.004,266,527.020.00654 SEWAGE WORKS DEPOSIT FUND 79,988.94 47,013.34 7,381.50 120.69 0.00 0.00 119,741.47 0.00119,741.470.00667 STORM SEWER FUND 54,736.78 85,914.72 21,623.08 45.09 0.00 0.00 119,073.51 0.00119,073.510.00670 CENTURY CENTER 1,810,663.10 7,300.50 159,454.82 0.00 0.00 90,752.00 1,567,756.78 0.001,567,756.780.00671 CENTURY CENTER CAPITAL 1,043,829.79 0.00 0.00 1,201.79 0.00 0.00 1,045,031.58 0.001,045,031.580.00672 CENTURY CENTER ENERGY SAVINGS 253,170.38 0.00 0.00 407.45 90,752.00 0.00 344,329.83 0.00344,329.830.00Total Enterprise Funds68,160,947.967,415,631.425,756,204.63128,969.401,840,315.67934,166.4270,855,493.400.0070,855,493.400.00Internal Service Funds222 CENTRAL SERVICES 1,376,930.87 1,148,928.90 1,101,044.19 1,687.89 0.00 0.00 1,426,503.47 0.001,426,503.470.00224 CENTRAL SERVICES CAPITAL 105,575.54 0.00 2,503.99 245.95 0.00 0.00 103,317.50 0.00103,317.500.00226 LIABILITY INSURANCE 4,579,189.22 335,637.50 140,929.41 8,576.55 0.00 0.00 4,782,473.86 0.004,782,473.860.00278 TAKE HOME VEHICLE POLICE 763,055.21 480.00 2,491.37 1,493.09 0.00 0.00 762,536.93 0.00762,536.930.00279 IT / INNOVATION / 311 CALL CENTER 2,811,304.48 669,702.17 707,272.83 4,597.24 0.00 0.00 2,778,331.06 0.002,778,331.060.00711 SELF-FUNDED EMPLOYEE BENEFITS 9,548,780.68 1,075,149.08 1,512,079.78 19,671.26 0.00 0.00 9,131,521.24 0.009,131,521.240.00713 UNEMPLOYMENT COMP FUND 182,776.48 0.00 3,313.65 360.12 0.00 0.00 179,822.95 0.00179,822.950.00714 PARENTAL LEAVE FUND 14,613.61 11,576.28 17,103.42 32.62 0.00 0.00 9,119.09 0.009,119.090.00Total Internal Service Funds19,382,226.093,241,473.933,486,738.6436,664.720.00 0.00 19,173,626.100.0019,173,626.100.00Trust & Agency Funds701 FIREFIGHTERS PENSION (416,402.63)2,231,496.59 357,221.57 0.00 0.00 0.00 1,457,872.39 0.001,457,872.390.00702 POLICE PENSION (358,157.24)3,053,909.06 499,885.42 198.88 0.00 0.00 2,196,065.28 0.002,196,065.280.00709 PAYROLL FUND 0.00 8,184,391.40 8,184,391.40 0.00 0.00 0.00 0.00 0.000.000.00718 STATE TAX DEDUCTION FUND 292,254.62 286,889.37 292,299.62 0.00 0.00 0.00 286,844.37 0.00286,844.370.00725 MORRIS / PALAIS BOX OFFICE 2,268,200.75 263,668.87 0.00 0.00 0.00 0.00 2,531,869.62 0.002,531,869.620.00726 POLICE DISTRIBUTIONS PAYABLE 849,138.66 892.87 0.00 0.00 0.00 0.00 850,031.53 0.00850,031.530.00730 CITY CEMETERY TRUST 29,431.89 0.00 0.00 57.60 0.00 0.00 29,489.49 0.0029,489.490.00731 BOWMAN CEMETERY 462,998.38 0.00 0.00 906.23 0.00 0.00 463,904.61 0.00463,904.610.00Total Trust & Agency Funds3,127,464.4314,021,248.169,333,798.01 1,162.71 0.00 0.00 7,816,077.290.007,816,077.290.00Total City Funds234,225,960.3734,457,395.0835,507,322.17426,857.554,421,520.944,421,520.94233,602,890.8369,231.46233,672,122.292,488,902.442019-09 Monthly Cash Report4 City of South BendController's Cash ReportOpening Interest Transfers Transfers Ending Total Cash & Interfund LoansFund Fund Name Cash Balance Receipts Disbursements Earned In Out Cash Balance Investments Investments (Borrowing)Month of: September 2019Redevelopment Commission Controlled FundsTax Increment Financing Funds324 TIF RIVER WEST 28,368,863.72 1,080.00 1,491,388.47 57,034.75 5,447.03 0.00 26,941,037.03 0.0026,941,037.03(100,000.00)422 TIF DISTRICT - WEST WASHINGTON 1,592,535.45 0.00 62,939.00 3,124.36 0.00 0.00 1,532,720.81 0.001,532,720.810.00429 TIF RIVER EAST DEV (NE) 9,074,302.41 0.00 1,767,170.71 17,943.00 0.00 0.00 7,325,074.70 0.007,325,074.700.00430 TIF SOUTHSIDE DEVELOPMENT AREA #1 9,243,330.93 0.00 15,925.00 18,360.56 0.00 0.00 9,245,766.49 0.009,245,766.490.00435 TIF DOUGLAS ROAD 195,253.64 0.00 0.00 382.17 0.00 0.00 195,635.81 0.00195,635.810.00436 TIF RIVER EAST RES (NE RE) 1,552,461.93 0.00 1,500.00 3,255.24 0.00 0.00 1,554,217.17 0.001,554,217.17(2,388,902.44)Total Tax Increment Financing Funds50,026,748.081,080.003,338,923.18100,100.085,447.030.00 46,794,452.01 0.0046,794,452.01(2,488,902.44)Redevelopment Funds433 REDEVELOPMENT ADMINISTRATION GENERAL 513,362.12 1,182,975.02 9,946.91 1,208.45 0.00 0.00 1,687,598.68 0.001,687,598.680.00439 CERTIFIED TECHNOLOGY PARK 318,141.19 0.00 230,876.49 784.83 0.00 0.00 88,049.53 0.0088,049.530.00454 AIRPORT URBAN ENTERPRISE ZONE 399,697.75 0.00 0.00 782.33 0.00 0.00 400,480.08 0.00400,480.080.00754 INDUSTRIAL REVOLVING FUND 1,782,353.04 6,134.77 7,257.05 25,732.75 0.00 0.00 1,806,963.51 0.001,806,963.510.00Total Redevelopment Funds3,013,554.101,189,109.79248,080.4528,508.360.00 0.00 3,983,091.800.003,983,091.800.00Debt Service Funds 315 AIRPORT 2003 DEBT RESERVE 1,040,462.24 0.00 0.00 2,038.68 0.00 2,038.68 1,040,462.24 0.001,040,462.240.00328 SBCDA 2003 DEBT RESERVE 1,739,494.86 0.00 0.00 3,408.35 0.00 3,408.35 1,739,494.86 0.001,739,494.860.00351 2018 TIF PARK BOND DEBT SERVICE RESERVE 1,008,756.70 0.00 0.00 1,974.45 0.00 0.00 1,010,731.15 0.001,010,731.150.00752 SB REDEVELOPMENT AUTHORITY 1,293,184.43 0.00 1,234,978.13 629.68 0.00 0.00 58,835.98 0.0058,835.980.00756 SMARTS STREETS DEBT SERVICE 2,589,990.43 0.00 856,584.38 508.79 0.00 0.00 1,733,914.84 0.001,733,914.840.00Total Debt Service Funds7,671,888.660.00 2,091,562.51 8,559.950.00 5,447.035,583,439.070.005,583,439.070.00Total Redevelopment Commission Funds60,712,190.84 1,190,189.79 5,678,566.14 137,168.39 5,447.03 5,447.03 56,360,982.88 0.00 56,360,982.88(2,488,902.44)City Operations Total294,938,151.21 35,647,584.8741,185,888.31 564,025.944,426,967.974,426,967.97289,963,873.71 69,231.46290,033,105.170.00Memo ItemPooled Investment AccountOpening Interest Accrued Change in Transfer In Transfer out Investment Total Cash &Balance Net of Fees Income Asset Value from Depository to Depository Balance Investments1st Source Bank Investment Account185,848,441.02235,165.930.00 (94,376.31)0.00 354,860.02185,634,370.62185,634,370.622019-09 Monthly Cash Report5 City of South BendCash Reserves Summary by Fund Status Cash ActualFund Fund NameCash Outstanding Available Reserve % ofBalance Encumb. Cash Requirement Variance Budget Notes Cash Reserve PolicyUnder Reserve Requirement201 Parks & Recreation 4,812,954 1,489,154 3,323,800 6,333,526 (3,009,726) 13% Property tax distribution received in June & Dec25% of Annual expenditures222 Central Services 1,426,503 30,632 1,395,871 2,397,936 (1,002,065) 15% Property tax distribution received in June & Dec25% of Annual expenditures, excluding utility accounting406 Cumulative Capital Development 357,088 332,309 24,779 204,530 (179,751) 3% Encumbrances reflect total annual debt payments25% of Annual expenditures429 River East Dev TIF (Northeast TIF) 7,325,075 4,867,025 2,458,050 3,050,496 (592,446) 20% Encumbrances reflect total annual debt payments25% of Annual expenditures610 Solid Waste Operations 240,061 80,247 159,814 552,998 (393,184) 3% High encumbrances10% of Annual expenditures667 Storm Sewer Fund 119,074 304,303 (185,229) 150,000 (335,229) -31% New fund, storm water fee revenue to begin in June25% of Annual expenditures714 Parental Leave Fund 9,119 - 9,119 38,924 (29,805) 6% Fund created in 2018, still establishing reserves25% of Annual expenditures14,289,873 7,103,670 7,186,204 12,728,410 (5,542,206) Meets or Exceeds Requirement101 General Fund 34,857,288 744,083 34,113,205 23,054,166 11,059,039 52% Property tax distribution received in June & Dec35% of Annual expenditures102 Rainy Day Fund 10,646,544 - 10,646,544 9,142,632 1,503,912 3%3% of total expenditures in previous fiscal year, excluding one-time capital expenditures202 Motor Vehicle Highway 4,858,832 815,757 4,043,074 3,008,482 1,034,592 34%25% of Annual expenditures211 DCI Administration Fund 1,117,778 136,939 980,839 788,167 192,672 31%25% of Annual expenditures216 Police State Seizures 236,013 - 236,013 8,000 228,013 738%25% of Annual expenditures218 Police Curfew Violations 13,374 623 12,751 250 12,501 1275%25% of Annual expenditures219 Unsafe Building 794,543 76,423 718,120 260,859 457,261 69%25% of Annual expenditures220 Law Enforce. Continuing Education 388,414 4,814 383,600 129,387 254,213 74%25% of Annual expenditures226 Liability Insurance 4,782,474 151,883 4,630,591 2,178,828 2,451,763 106%50% of Annual expenditures249 Public Safety L.O.I.T. 3,675,122 - 3,675,122 685,324 2,989,798 43% 8% of Annual expenditures - one month reserve251 Local Roads & Streets 6,222,382 2,379,732 3,842,650 1,789,757 2,052,893 54%25% of Annual expenditures258 Human Rights - Federal Grant 397,555 6,268 391,286 77,870 313,416 126%25% of Annual expenditures273 Morris PAC/Palais Royale Marketing 69,829 3,815 66,014 7,500 58,514 220%25% of Annual expenditures274 Morris PAC/Self-Promotion 154,378 - 154,378 18,750 135,628 206%25% of Annual expenditures278 Take Home Vehicle Police 762,537 - 762,537 750,000 12,537 1525%Set dollar amount of $750,000287 EMS Capital 2,347,900 1,155,623 1,192,277 1,115,569 76,708 27%25% of Annual expenditures288 EMS Operating 2,532,841 115,190 2,417,650 1,607,667 809,983 38%25% of Annual expenditures289 HAZMAT 28,345 - 28,345 2,618 25,727 271%25% of Annual expenditures291 Indiana River Rescue 287,044 4,563 282,481 33,816 248,665 209%25% of Annual expenditures294 Regional Police Academy 112,500 - 112,500 5,625 106,875 500%25% of Annual expenditures299 Police Federal Drug Enforcement 112,995 - 112,995 12,750 100,245 222%25% of Annual expenditures315 Airport 2003 Debt Reserve 1,040,462 - 1,040,462 1,040,462 - 100%100% debt service reserve per bond covenants328 SBCDA 2003 Debt Reserve 1,739,495 - 1,739,495 1,739,495 - 100%100% debt service reserve per bond covenants324 River West TIF (Airport TIF) 26,941,037 9,715,384 17,225,653 10,871,238 6,354,415 40% Property tax distribution received in June & Dec25% of Annual expenditures351 2018 TIF Park Bond Debt Svc Reserve 1,010,731 - 1,010,731 1,010,731 - 100% 100% debt service reserve per bond covenants404 County Option Income Tax 12,771,936 1,598,376 11,173,559 8,510,844 2,662,715 66%50% of Annual expenditures407 Cumulative Capital Improvement 592,639 28,000 564,639 7,000 557,639 2017%25% of Annual expenditures408 Economic Development Income Tax 17,946,062 3,410,813 14,535,249 7,351,601 7,183,648 99%50% of Annual expenditures416 Morris Performing Arts Center Capital 400,607 105,635 294,972 56,366 238,606 131%25% of Annual expenditures422 TIF District - West Washington 1,532,721 770,269 762,452 423,783 338,669 45% Property tax distribution received in June & Dec25% of Annual expenditures430 TIF Southside Development Area #1 9,245,766 243,459 9,002,308 2,588,182 6,414,126 87% Property tax distribution received in June & Dec25% of Annual expenditures433 Redev Administration General 1,687,599 245,038 1,442,561 268,500 1,174,061 134%25% of Annual expenditures435 TIF - Douglas Road 195,636 96,625 99,011 20,800 78,211 48%10% of Annual expenditures436 River East Residential (NE Res TIF) 1,554,217 - 1,554,217 1,068,750 485,467 36% Property tax distribution received in June & Dec25% of Annual expenditures450 Palais Royale Historic Preservation 102,817 - 102,817 27,992 74,825 92%25% of Annual expenditures600 Consolidated Building Department 2,236,654 198,834 2,037,820 1,242,076 795,744 41%25% of Annual expenditures601 Parking Garages 1,179,307 412,207 767,100 476,646 290,454 40%25% of Annual expenditures620 Water Works Operations 4,000,636 1,546,253 2,454,383 1,140,646 1,313,737 11%5% of Annual expenditures624 Water Works Customer Deposit 1,507,897 - 1,507,897 1,507,897 - 100%100% cash reserves for customer deposits625 Water Works Sinking Fund 1,261,992 1,750,922 (488,930) (488,930) - 100% Encumbrances reflect total annual debt payments100% cash reserves per bond covenants626 Water Works Bond Reserve 1,441,338 - 1,441,338 1,441,338 - 100%100% cash reserves per bond covenants and Crowe Horwath629 Water Works Reserve - O & M 2,895,721 - 2,895,721 2,879,222 16,499 17%16.67% of annual operating expenses in Fund 620, net of transfers640 Sewer Repair Insurance 2,113,874 107,108 2,006,765 165,797 1,840,968 303%25% of Annual expenditures641 Sewage Works Operations 13,014,917 5,706,959 7,307,958 2,307,147 5,000,811 16%5% of Annual expenditures643 Sewage Works Reserve - O & M 5,550,801 - 5,550,801 5,510,886 39,915 17% 16.67% of annual operating expenses in Fund 641, net of transfers649 Sewage Works Bond Sinking 7,893,093 6,851,977 1,041,115 1,041,115 - 100% Encumbrances reflect total annual debt payments100% cash reserves per bond covenants653 Sewage Works Debt Service Reserve 4,266,527 - 4,266,527 4,266,527 - 100%100% cash reserves per bond covenants and Crowe Horwath654 Sewage Works Deposit Fund 119,741 - 119,741 119,741 - 100%100% cash reserves for customer depositsSeptember 30, 20192019-09 Monthly Cash Report6 City of South BendCash Reserves Summary by Fund Status Cash ActualFund Fund NameCash Outstanding Available Reserve % ofBalance Encumb. Cash Requirement Variance Budget Notes Cash Reserve PolicySeptember 30, 2019655 Project Releaf 485,408 - 485,408 168,741 316,667 72%25% of Annual expenditures670 Century Center 1,567,757 28,344 1,539,412 1,171,839 367,573 33%25% of Annual expenditures671 Century Center Capital 1,045,032 - 1,045,032 800,000 245,032 1259%$800,000 Minimum per Board of Managers701 Firefighters Pension 1,457,872 - 1,457,872 511,246 946,626 29%10% of Annual expenditures702 Police Pension 2,196,065 - 2,196,065 635,590 1,560,475 35%10% of Annual expenditures705 Police K-9 Unit 2,376 - 2,376 505 1,871 118%25% of Annual expenditures711 Self-Funded Employee Benefits 9,131,521 326,726 8,804,795 4,155,747 4,649,048 53%25% of Annual expenditures713 Unemployment Comp Fund 179,823 - 179,823 17,500 162,323 257%25% of Annual expenditures718 State Tax Withholding Fund 286,844 - 286,844 286,844 - 100%100% cash reserves - trust & agency funds725 Morris / Palais Box Office 2,531,870 - 2,531,870 2,531,870 - 100%100% cash reserves - trust & agency funds726 Police Distributions Payable 850,032 - 850,032 850,032 - 100%100% cash reserves - trust & agency funds730 City Cemetery Trust 29,489 - 29,489 - 29,489 100%25% of Annual expenditures731 Bowman Cemetery 463,905 - 463,905 400,000 63,905 100%$400,000 minimum752 South Bend Redevelopment Authority 58,836 - 58,836 58,836 - 100%100% cash reserves per bond covenants753 Smart Street Bond Capital - - - - - 100%100% cash reserves per bond covenants755 South Bend Building Corporation 813,822 - 813,822 813,822 - 100%100% cash reserves per bond covenants756 Smart Streets Debt Service Fund 1,733,915 - 1,733,915 1,733,915 - 100%100% cash reserves per bond covenants757 2015 Parks Bond Debt Service 464,811 - 464,811 464,811 - 100%100% cash reserves per bond covenants760 Eddy St. Commons Debt Service 3,459,683 - 3,459,683 2,500,000 959,683 266%$2,500,000 minimum225,401,973 38,738,644 186,663,324 118,375,167 68,288,157 No Reserve Requirement209 Studebaker/Oliver Revitalizing Grants 940,380 133,447 806,933 - 806,933 100%No reserve requirement - Grant fund - spend down to zero210 DCI State Grants 78,905 37,487 41,418 - 41,418 100% To be reimbursed by grant receiptsNo reserve requirement - Grant fund - spend down to zero212 DCI Federal Grants 336,572 2,893,055 (2,556,482) - (2,556,482) 100% To be reimbursed by grant receiptsNo reserve requirement - Grant fund - spend down to zero217 Gift, Donation, Bequest756,236 364,591 391,645 - 391,645 100%No reserve requirement221 Landlord Registration 15,222 - 15,222 - 15,222 100%No reserve requirement224 Central Services Capital 103,318 - 103,318 - 103,318 100%No reserve requirement - Capital fund - spend down to zero227 Loss Recovery Fund 600,567 11,406 589,161 - 589,161 100%No reserve requirement257 LOIT 2016 Special Distribution 271,840 271,655 185 - 185 100%No reserve requirement265 Local Road & Bridge Grant 329,654 630,223 (300,569) - (300,569) 100% High encumbrancesNo reserve requirement - Grant fund - spend down to zero266 MVH Restricted 1,306,478 236,337 1,070,140 - 1,070,140 100%New fund - reserve requirement to be determined279 IT / Innovation / 311 Call Center 2,778,331 1,071,330 1,707,001 - 1,707,001 100% Reimbursed through interfund allocationNo reserve requirement280 Police Block Grants 4,062 - 4,062 - 4,062 100%No reserve requirement - Grant fund - spend down to zero292 Police Grants 26,716 - 26,716 - 26,716 100%No reserve requirement - Grant fund - spend down to zero295 COPS MORE Grant 178,985 4,790 174,195 - 174,195 100%No reserve requirement - Grant fund - spend down to zero312 2017 Parks Bond Debt Service(367,720) - (367,720) - (367,720) 100% Property tax distribution received in June & DecNo reserve requirement350 2018 Fire St #9 Debt Service - - - - - 100% Receives transfers from Fund 287 for debt svc pmtsNo reserve requirement401 Coveleski Stadium Capital 9,376 8,300 1,076 - 1,076 100%No reserve requirement - Capital fund - spend down to zero410 Urban Develop Action Grant (UDAG) 58,300 - 58,300 - 58,300 100%No reserve requirement - Grant fund - spend down to zero412 Major Moves Construction 2,249,196 413,444 1,835,751 - 1,835,751 100%No reserve requirement - Capital fund - spend down to zero439 Certified Technology Park 88,050 83,245 4,804 - 4,804 100%No reserve requirement451 2018 Fire St #9 Capital 521,552 214,346 307,206 - 307,206 100%No reserve requirement - Bond capital fund - spend down to zero452 2018 TIF Park Bond Capital 6,004,314 2,361,765 3,642,549 - 3,642,549 100%No reserve requirement - Bond capital fund - spend down to zero453 2018 Zoo Bond Capital 570,868 - 570,868 - 570,868 100%No reserve requirement - Bond capital fund - spend down to zero454 Airport Urban Enterprise Zone 400,480 - 400,480 - 400,480 100%No reserve requirement471 2017 Parks Bond Capital 9,428,885 591,961 8,836,924 - 8,836,924 100%No reserve requirement - Bond capital fund - spend down to zero611 Solid Waste Capital 287,533 147,702 139,831 - 139,831 100% Receives transfers from Fund 610 as neededNo reserve requirement - Capital fund - spend down to zero622 Water Works Capital 3,699,862 672,386 3,027,476 - 3,027,476 100%No reserve requirement - Capital fund - spend down to zero642 Sewage Works Capital 11,188,608 7,528,444 3,660,164 - 3,660,164 100% Receives transfers from Fund 641 as neededNo reserve requirement - Capital fund - spend down to zero672 Century Center Energy Savings 344,330 207,863 136,467 - 136,467 100% Encumbrances reflect total annual debt paymentsNo reserve requirement750 Equipment/Vehicle Leasing 1,335,890 163,543 1,172,348 - 1,172,348 100% No reserve requirement - Capital lease fund - spend down to zero751 2015 Parks Bond Capital 201,675 198,673 3,002 - 3,002 100% No reserve requirement - Bond capital fund - spend down to zero754 Industrial Revolving Fund 1,806,964 - 1,806,964 - 1,806,964 100%No City reserve requirement; there are program requirements759 Eddy St Commons Capital 4,785,833 - 4,785,833 - 4,785,833 100%No reserve requirement - Bond capital fund - spend down to zero50,341,259 18,245,992 32,095,268 - 32,095,268 City Operations Total 290,033,105 64,088,305 225,944,796 131,103,577 94,841,219 Note: Available Cash is a Fund's cash balance minus any outstanding encumbrances2019-09 Monthly Cash Report7 January 1, 2007 - September 30, 2019 $329,782,565 6/30/2018 $122,056,198 5/31/2007 $217,099,510 -- $293,529,692 -- 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 - All 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 2019-09 Monthly Cash Report 8 January 1, 2007 - September 30, 2019 City of South Bend Cash Balances - All Funds Enterprise Redevelopment Civil City Enterprise Redevelopment Civil City Date Total Cash Funds Funds Funds 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 05/31/19 267,228,987.30 65,258,811.69 53,673,044.13 148,297,131.48 07/31/15 236,381,857.01 70,884,051.33 65,048,413.67 100,449,392.01 06/30/19 313,696,930.90 65,359,551.38 68,360,737.05 179,976,642.47 08/31/15 228,483,356.31 72,023,119.13 61,042,169.83 95,418,067.35 07/31/19 297,845,949.69 67,151,539.38 61,596,350.52 169,098,059.79 09/30/15 234,514,964.30 75,617,268.98 59,936,471.64 98,961,223.68 08/31/19 294,938,151.21 68,160,947.96 60,712,190.84 166,065,012.41 10/31/15 230,114,056.20 77,155,814.42 56,339,743.69 96,618,498.09 09/30/19 290,033,105.17 70,855,493.40 56,360,982.88 162,816,628.89 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 03/31/18 274,783,580.98 60,255,912.54 56,967,800.25 157,559,868.19 04/30/18 280,256,559.54 61,537,542.97 70,308,595.71 148,410,420.86 05/31/18 280,820,481.43 62,676,079.74 69,433,440.38 148,710,961.31 06/30/18 329,782,564.72 62,779,584.12 81,992,642.55 185,010,338.05 07/31/18 317,008,229.34 64,079,751.06 78,753,842.27 174,174,636.01 08/31/18 308,391,385.21 65,896,576.77 73,401,834.82 169,092,973.62 09/30/18 306,023,826.98 67,628,081.52 70,934,670.78 167,461,074.68 10/31/18 297,350,750.07 70,191,910.88 58,183,703.49 168,975,135.70 11/30/18 282,111,836.71 62,080,096.93 57,701,465.11 162,330,274.67 12/31/18 309,811,785.05 63,399,519.22 66,695,748.11 179,716,517.72 01/31/19 292,787,503.35 61,984,035.31 59,597,388.81 171,206,079.23 02/28/19 290,154,850.97 62,312,317.89 60,283,680.41 167,558,852.67 03/31/19 282,250,506.35 65,067,673.27 57,633,297.22 159,549,535.86 04/30/19 276,790,123.45 65,875,626.86 55,133,997.10 155,780,499.49 2019-09 Monthly Cash Report 9 $83,296,822 1/31/2013 $28,657,187 1/1/2007 $58,747,129 -- $65,801,584 -- Date Cash Date Cash Date Cash 01/01/07 28,657,187.47 04/30/11 46,284,639.10 08/31/15 72,023,119.13 01/31/07 30,058,091.08 05/31/11 45,692,919.82 09/30/15 75,617,268.98 02/28/07 30,099,578.04 06/30/11 46,029,921.56 10/31/15 77,155,814.42 03/31/07 30,984,947.93 07/31/11 45,556,018.39 11/30/15 75,987,100.36 04/30/07 29,218,887.63 08/31/11 45,688,053.72 12/31/15 64,215,673.59 05/31/07 32,424,086.65 09/30/11 46,330,287.44 01/31/16 65,062,377.54 06/30/07 48,699,567.31 10/31/11 67,040,484.39 02/29/16 67,564,110.56 07/31/07 48,096,309.22 11/30/11 61,691,017.04 03/31/16 69,211,164.87 08/31/07 47,662,427.04 12/31/11 58,173,399.01 04/30/16 69,616,174.97 09/30/07 45,360,303.16 01/31/12 59,207,692.55 05/31/16 69,399,868.04 10/31/07 46,717,357.10 02/29/12 59,272,665.18 06/30/16 68,720,691.90 11/30/07 41,716,114.28 03/31/12 59,768,182.49 07/31/16 69,227,392.30 12/31/07 55,204,053.77 04/30/12 60,202,795.65 08/31/16 67,673,880.42 01/31/08 56,114,335.03 05/31/12 59,123,171.41 09/30/16 69,398,336.63 02/29/08 54,575,012.50 06/30/12 67,140,754.63 10/31/16 68,809,369.21 03/31/08 54,575,272.95 07/31/12 67,955,663.74 11/30/16 61,451,803.84 04/30/08 54,929,047.02 08/31/12 67,464,201.30 12/31/16 58,486,210.11 05/31/08 53,052,472.03 09/30/12 65,732,654.52 01/31/17 58,517,537.99 06/30/08 53,204,418.10 10/31/12 66,270,486.67 02/28/17 60,687,347.41 07/31/08 54,533,563.28 11/30/12 59,658,568.60 03/31/17 62,502,426.31 08/31/08 54,251,216.99 12/31/12 82,506,887.41 04/30/17 63,062,862.44 09/30/08 53,272,451.68 01/31/13 83,296,821.86 05/31/17 62,923,609.40 10/31/08 68,706,036.43 02/28/13 82,484,393.54 06/30/17 62,218,464.08 11/30/08 54,077,562.73 03/31/13 82,950,715.18 07/31/17 63,518,960.13 12/31/08 44,639,804.67 04/30/13 80,568,512.43 08/31/17 64,818,240.75 01/31/09 45,793,529.09 05/31/13 79,672,318.05 09/30/17 66,236,471.94 02/28/09 46,941,062.25 06/30/13 79,520,360.08 10/31/17 66,667,885.35 03/31/09 47,265,006.09 07/31/13 79,867,774.82 11/30/17 59,754,036.10 04/30/09 48,061,985.20 08/31/13 79,782,901.50 12/31/17 57,620,088.62 05/31/09 46,623,111.00 09/30/13 79,940,103.15 01/31/18 59,858,871.62 06/30/09 46,662,615.02 10/31/13 79,663,547.72 02/28/18 58,423,954.94 07/31/09 45,609,990.75 11/30/13 72,524,668.50 03/31/18 60,255,912.54 08/31/09 44,700,623.82 12/31/13 67,716,137.82 04/30/18 61,537,542.97 09/30/09 44,771,129.93 01/31/14 66,889,990.77 05/31/18 62,676,079.74 10/31/09 44,855,908.07 02/28/14 67,566,543.96 06/30/18 62,779,584.12 11/30/09 44,458,186.54 03/31/14 68,633,684.73 07/31/18 64,079,751.06 12/31/09 36,891,179.40 04/30/14 68,960,383.93 08/31/18 65,896,576.77 01/31/10 37,726,300.40 05/31/14 67,425,749.33 09/30/18 67,628,081.52 02/28/10 36,982,623.93 06/30/14 67,697,981.00 10/31/18 70,191,910.88 03/31/10 41,475,717.35 07/31/14 68,611,865.99 11/30/18 62,080,096.93 04/30/10 40,478,357.60 08/31/14 68,747,483.87 12/31/18 63,399,519.22 05/31/10 38,739,522.56 09/30/14 69,430,344.98 01/31/19 61,984,035.31 06/30/10 39,738,881.62 10/31/14 70,431,027.92 02/28/19 62,312,317.89 07/31/10 42,020,069.17 11/30/14 64,909,392.12 03/31/19 65,067,673.27 08/31/10 40,331,826.60 12/31/14 61,623,499.90 04/30/19 65,875,626.86 09/30/10 40,245,656.32 01/31/15 61,585,040.94 05/31/19 65,258,811.69 10/31/10 39,984,803.80 02/28/15 63,269,776.69 06/30/19 65,359,551.38 11/30/10 35,695,100.47 03/31/15 64,288,370.38 07/31/19 67,151,539.38 12/31/10 41,300,042.16 04/30/15 65,430,174.18 08/31/19 68,160,947.96 01/31/11 42,918,366.28 05/31/15 65,714,228.05 09/30/19 70,855,493.40 02/28/11 44,793,554.36 06/30/15 68,746,632.56 03/31/11 46,555,428.08 07/31/15 70,884,051.33 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. In March 2017, the Utility Commission approved a water rate increase in two phases: phase 1 - 22% over 12 months, phase 2 - 22% over 12 months. The increase was added starting with April 2017 billing. Water Works expects to see increase in cash in May 2017, when they begin collecting on April billing. City of South Bend Cash Balances - Enterprise Funds January 1, 2007 - September 30, 2019 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 2019-09 Monthly Cash Report 10 $81,992,643 6/30/2018 $26,731,149 1/31/2009 $50,138,977 -- $61,830,078 -- Date Cash Date Cash Date Cash 01/01/07 40,101,775.51 04/30/11 51,775,206.12 08/31/15 61,042,169.83 01/31/07 37,204,941.29 05/31/11 45,543,075.85 09/30/15 59,936,471.64 02/28/07 42,400,991.27 06/30/11 57,605,720.29 10/31/15 56,339,743.69 03/31/07 36,322,464.80 07/31/11 51,845,520.23 11/30/15 54,715,027.81 04/30/07 36,374,308.24 08/31/11 49,085,008.00 12/31/15 61,194,710.47 05/31/07 36,579,224.31 09/30/11 47,073,543.39 01/31/16 55,690,681.11 06/30/07 35,914,061.41 10/31/11 44,750,523.17 02/29/16 53,548,676.30 07/31/07 33,046,039.94 11/30/11 41,844,406.42 03/31/16 53,434,486.66 08/31/07 31,416,991.60 12/31/11 51,201,636.39 04/30/16 51,317,725.09 09/30/07 30,955,278.22 01/31/12 44,464,972.65 05/31/16 50,296,085.76 10/31/07 29,953,285.20 02/29/12 43,124,396.97 06/30/16 64,433,239.06 11/30/07 29,049,190.99 03/31/12 40,875,506.16 07/31/16 58,518,600.58 12/31/07 43,118,912.28 04/30/12 39,972,677.94 08/31/16 55,966,718.35 01/31/08 41,405,052.40 05/31/12 37,283,464.71 09/30/16 55,065,472.04 02/29/08 40,635,068.99 06/30/12 48,308,618.33 10/31/16 52,059,580.89 03/31/08 40,558,124.18 07/31/12 43,597,429.86 11/30/16 51,222,578.99 04/30/08 40,290,091.29 08/31/12 41,355,817.62 12/31/16 60,406,691.98 05/31/08 40,210,711.69 09/30/12 40,654,565.67 01/31/17 54,709,591.50 06/30/08 39,857,987.53 10/31/12 38,605,222.83 02/28/17 60,693,512.64 07/31/08 39,145,712.40 11/30/12 37,090,958.24 03/31/17 54,200,785.07 08/31/08 36,074,455.00 12/31/12 47,393,846.15 04/30/17 53,618,489.08 09/30/08 35,928,266.53 01/31/13 45,144,294.34 05/31/17 50,870,962.23 10/31/08 34,674,631.21 02/28/13 41,364,435.41 06/30/17 64,818,554.92 11/30/08 33,382,904.90 03/31/13 41,430,811.51 07/31/17 59,955,849.53 12/31/08 28,608,922.65 04/30/13 42,438,979.52 08/31/17 60,726,084.24 01/31/09 26,731,148.85 05/31/13 42,077,874.12 09/30/17 57,532,562.70 02/28/09 28,199,966.51 06/30/13 55,157,971.58 10/31/17 55,546,746.25 03/31/09 27,482,787.81 07/31/13 51,147,079.40 11/30/17 55,251,426.66 04/30/09 38,905,572.01 08/31/13 48,231,381.91 12/31/17 65,818,514.83 05/31/09 38,656,758.39 09/30/13 47,344,717.04 01/31/18 60,435,599.30 06/30/09 36,003,705.47 10/31/13 45,849,747.51 02/28/18 58,919,560.09 07/31/09 39,288,192.08 11/30/13 45,831,055.40 03/31/18 56,967,800.25 08/31/09 38,981,480.90 12/31/13 55,315,510.06 04/30/18 70,308,595.71 09/30/09 38,365,267.66 01/31/14 50,898,242.66 05/31/18 69,433,440.38 10/31/09 36,749,933.72 02/28/14 49,986,290.38 06/30/18 81,992,642.55 11/30/09 35,847,660.55 03/31/14 49,028,261.04 07/31/18 78,753,842.27 12/31/09 34,358,243.89 04/30/14 47,281,387.13 08/31/18 73,401,834.82 01/31/10 53,534,937.83 05/31/14 46,795,213.96 09/30/18 70,934,670.78 02/28/10 52,816,628.95 06/30/14 61,118,881.00 10/31/18 58,183,703.49 03/31/10 52,577,148.25 07/31/14 56,842,280.86 11/30/18 57,701,465.11 04/30/10 51,768,568.42 08/31/14 55,735,447.17 12/31/18 66,695,748.11 05/31/10 50,881,687.36 09/30/14 54,889,194.46 01/31/19 59,597,388.81 06/30/10 62,539,377.78 10/31/14 54,196,891.83 02/28/19 60,283,680.41 07/31/10 55,401,804.58 11/30/14 54,554,819.33 03/31/19 57,633,297.22 08/31/10 53,423,401.23 12/31/14 65,903,128.76 04/30/19 55,133,997.10 09/30/10 52,832,007.68 01/31/15 60,387,162.56 05/31/19 53,673,044.13 10/31/10 51,745,774.22 02/28/15 58,990,110.88 06/30/19 68,360,737.05 11/30/10 49,573,730.89 03/31/15 58,654,868.03 07/31/19 61,596,350.52 12/31/10 65,164,721.07 04/30/15 57,972,838.77 08/31/19 60,712,190.84 01/31/11 57,392,911.65 05/31/15 57,630,884.95 09/30/19 56,360,982.88 02/28/11 53,822,791.88 06/30/15 70,642,566.10 03/31/11 52,439,712.97 07/31/15 65,048,413.67 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. April 2018, Redevelopment District Bonds totaling $11,995,000 were issued for parks improvements to be repaid by TIF Fund 324. City of South Bend Cash Balances - Redevelopment Funds January 1, 2007 - September 30, 2019 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 2019-09 Monthly Cash Report 11 $185,010,338 6/30/2018 $53,052,887 5/31/2007 $108,336,508 -- $166,280,316 -- Date Cash Date Cash Date Cash 01/01/07 85,175,579.60 04/30/11 98,831,059.73 08/31/15 95,418,067.35 01/31/07 73,488,712.70 05/31/11 95,848,921.73 09/30/15 98,961,223.68 02/28/07 62,279,572.21 06/30/11 126,998,337.53 10/31/15 96,618,498.09 03/31/07 63,387,712.08 07/31/11 118,336,148.46 11/30/15 91,575,694.83 04/30/07 57,999,328.33 08/31/11 113,258,535.54 12/31/15 103,372,121.18 05/31/07 53,052,886.63 09/30/11 110,396,745.77 01/31/16 96,593,548.78 06/30/07 69,141,886.09 10/31/11 106,268,532.08 02/29/16 92,760,927.94 07/31/07 55,973,444.69 11/30/11 103,722,320.22 03/31/16 88,559,353.77 08/31/07 56,738,574.39 12/31/11 122,382,409.35 04/30/16 86,653,485.20 09/30/07 54,332,089.62 01/31/12 112,856,049.10 05/31/16 86,834,652.02 10/31/07 62,335,616.12 02/29/12 108,263,714.86 06/30/16 116,591,466.93 11/30/07 78,241,163.17 03/31/12 104,341,336.06 07/31/16 121,999,405.01 12/31/07 92,992,407.68 04/30/12 102,221,194.49 08/31/16 105,828,873.80 01/31/08 80,935,072.49 05/31/12 98,400,589.02 09/30/16 106,788,928.77 02/29/08 79,815,076.58 06/30/12 129,269,506.53 10/31/16 103,888,093.70 03/31/08 75,755,584.16 07/31/12 118,715,231.38 11/30/16 98,003,054.46 04/30/08 70,171,420.22 08/31/12 114,706,440.90 12/31/16 115,636,423.15 05/31/08 63,701,375.82 09/30/12 116,874,708.78 01/31/17 123,978,793.66 06/30/08 74,301,370.46 10/31/12 109,940,198.76 02/28/17 121,509,295.84 07/31/08 77,357,385.95 11/30/12 107,094,590.01 03/31/17 116,554,975.66 08/31/08 73,612,781.45 12/31/12 125,384,469.62 04/30/17 110,930,193.42 09/30/08 70,870,856.93 01/31/13 119,412,780.36 05/31/17 108,877,270.93 10/31/08 61,421,121.17 02/28/13 113,373,764.76 06/30/17 137,292,433.56 11/30/08 60,929,733.44 03/31/13 107,698,520.03 07/31/17 130,725,920.08 12/31/08 67,373,134.56 04/30/13 103,435,158.90 08/31/17 126,515,209.12 01/31/09 56,557,371.00 05/31/13 98,352,454.84 09/30/17 153,866,546.50 02/28/09 61,446,169.16 06/30/13 125,169,937.15 10/31/17 147,133,964.65 03/31/09 75,602,332.02 07/31/13 121,430,845.57 11/30/17 143,554,756.24 04/30/09 69,388,217.66 08/31/13 114,023,924.90 12/31/17 167,851,319.70 05/31/09 68,735,769.04 09/30/13 115,040,485.48 01/31/18 162,491,472.74 06/30/09 62,589,041.72 10/31/13 109,822,423.95 02/28/18 158,812,440.01 07/31/09 66,130,768.09 11/30/13 104,254,613.29 03/31/18 157,559,868.19 08/31/09 71,071,962.93 12/31/13 124,318,129.42 04/30/18 148,410,420.86 09/30/09 70,242,756.18 01/31/14 114,256,166.29 05/31/18 148,710,961.31 10/31/09 68,758,254.71 02/28/14 109,603,281.18 06/30/18 185,010,338.05 11/30/09 63,704,336.96 03/31/14 104,384,382.05 07/31/18 174,174,636.01 12/31/09 117,203,577.74 04/30/14 98,541,834.35 08/31/18 169,092,973.62 01/31/10 104,838,291.70 05/31/14 95,103,846.00 09/30/18 167,461,074.68 02/28/10 104,864,103.11 06/30/14 122,883,782.00 10/31/18 168,975,135.70 03/31/10 103,854,789.67 07/31/14 113,327,256.18 11/30/18 162,330,274.67 04/30/10 98,183,077.33 08/31/14 109,603,756.37 12/31/18 179,716,517.72 05/31/10 111,608,210.69 09/30/14 109,275,831.00 01/31/19 171,206,079.23 06/30/10 128,279,716.19 10/31/14 101,285,566.72 02/28/19 167,558,852.67 07/31/10 119,642,649.15 11/30/14 97,119,208.93 03/31/19 159,549,535.86 08/31/10 116,632,252.40 12/31/14 112,281,466.37 04/30/19 155,780,499.49 09/30/10 118,416,709.45 01/31/15 103,499,061.06 05/31/19 148,297,131.48 10/31/10 112,912,072.36 02/28/15 99,594,218.25 06/30/19 179,976,642.47 11/30/10 113,513,586.86 03/31/15 92,334,813.71 07/31/19 169,098,059.79 12/31/10 121,274,488.95 04/30/15 89,927,304.71 08/31/19 166,065,012.41 01/31/11 113,796,557.05 05/31/15 86,034,381.75 09/30/19 162,816,628.89 02/28/11 109,647,280.68 06/30/15 110,214,298.75 03/31/11 105,410,957.45 07/31/15 100,449,392.01 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 - September 30, 2019 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 $160,000,000 $180,000,000 $200,000,000 2019-09 Monthly Cash Report 12