HomeMy WebLinkAbout2018-10 - Monthly Cash ReportPeriod Ending:
Issued by:
Page Number(s) Contents
2 Narrative
3 - 5 Controller's Cash Report
6 - 8 Cash Reserves Summary by Fund Status
9 - 10 Cash Trends - All Funds
11 Cash Trends - Enterprise Funds
12 Cash Trends - Redevelopment Funds
13 Cash Trends - Civil City Funds
Distribution
Mayor Pete Buttigieg
Chief of Staff Laura O'Sullivan
Deputy Chief of Staff Suzanna Fritzberg
Common Council
Department Heads
Fiscal Officers
October 31, 2018
Controller
City of South Bend
Monthly Cash Report
Monthly Cash Report 10-2018 1
October 2018 Highlights:
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 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 trustee 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.
Gift, Donation, Bequest Fund 217: The City received a $50,000 donation from Visit South Bend Mishawaka for wayfinding signs.
Parks & Recreation Fund 201: Cash receipts will decrease in the fall and winter with the end of the summer recreational activities and the closure of the golf
courses.
Fund 312, 313, and 377 have negative cash balances.
- 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.
- The Hall of Fame Debt Service Fund 313 receives property tax revenue in June and December, but still had to make the final debt payment for the Hall of
Fame Bonds in January. When property tax revenue is received in December, this fund won't be negative.
- The Professional Sports Development Area Fund 377 hasn't received its PSDA revenue yet, but still had to make debt payments in January and July.
Monthly Cash Report 10-2018 2
City of South BendController's Cash ReportOpening Interest Transfers TransfersEnding Total Cash & Interfund LoansFund Fund Name Cash Balance Receipts Disbursements Earned InOut Cash Balance Investments Investments (Borrowing)City Controlled FundsGeneral Fund101 GENERAL FUND 30,023,559.42 1,530,456.22 4,570,416.29 32,549.38 428,422.60 0.00 27,444,571.33 0.0027,444,571.33425,542.47Special Revenue Funds102 RAINY DAY FUND 10,410,550.51 0.00 0.00 10,926.51 0.00 0.00 10,421,477.02 0.0010,421,477.020.00201 PARKS & RECREATION 5,050,035.54 190,004.08 1,062,168.91 5,436.07 0.00 0.00 4,183,306.78 0.004,183,306.780.00202 MOTOR VEHICLE HIGHWAY 8,893,670.94 542,304.09 1,609,483.12 8,777.32 27,213.44 0.00 7,862,482.67 0.007,862,482.670.00203 RECREATION - NONREVERTING 872,719.94 34,653.16 71,496.08 926.41 0.00 0.00 836,803.43 0.00836,803.430.00209 STUDEBAKER/OLIVER REVERTING GRANTS 949,681.61 0.00 6,974.06 1,000.34 0.00 0.00 943,707.89 0.00943,707.89200,000.00210 DEPT COMMUNITY INVESTMENT STATE GRANTS 361,797.55 0.00 0.00 385.39 0.00 0.00 362,182.94 0.00362,182.940.00211 DCI OPERATING FUND 789,300.14 27,765.91 233,093.50 639.02 0.00 0.00 584,611.57 0.00584,611.570.00212 DEPARTMENT OF COMMUNITY INVESTMENT 111,238.42 841,622.97 517,984.80 156.24 0.00 0.00 435,032.83 0.00435,032.830.00216 POLICE STATE SEIZURES 231,629.92 100.00 5,000.00 228.43 0.00 0.00 226,958.35 0.00226,958.350.00217 GIFT, DONATION, BEQUEST 135,304.32 50,665.00 4,031.43 145.85 0.000.00 182,083.74 0.00182,083.740.00218 POLICE CURFEW VIOLATIONS 13,631.50 12.50 604.00 14.30 0.00 0.00 13,054.30 0.0013,054.300.00219 UNSAFE BUILDING 562,346.35 15,320.50 111,784.75 497.36 0.00 0.00 466,379.46 0.00466,379.460.00220 LAW ENFORCEMENT CONTINUING EDUCATION 557,627.17 21,785.17 61,300.53 583.37 0.00 0.00 518,695.18 0.00518,695.180.00221 LANDLORD REGISTRATION 10,077.34 0.00 0.00 10.57 0.00 0.00 10,087.910.0010,087.910.00227 LOSS RECOVERY FUND 691,364.66 0.00 10,323.55 732.60 0.00 0.00 681,773.71 0.00681,773.710.00249 PUBLIC SAFETY L.O.I.T. 1,857,996.43 635,794.92 556,544.64 1,789.64 0.00 0.00 1,939,036.35 0.001,939,036.350.00251 LOCAL ROADS & STREETS 3,920,423.12 156,854.21 55,412.66 4,071.590.00 0.00 4,025,936.26 0.004,025,936.260.00257 LOIT 2016 SPECIAL DISTRIBUTION 972,377.90 0.00 190,905.43 1,798.79 0.00 0.00 783,271.26 0.00783,271.260.00258 HUMAN RIGHTS - FEDERAL GRANT 537,515.05 0.00 80,026.45 490.86 0.00 0.00 457,979.46 69,782.00527,761.460.00265 LOCAL ROAD & BRIDGE GRANT 630,731.00 0.00 94,928.22 0.00 0.00 0.00535,802.78 0.00535,802.780.00273 MORRIS PAC/PALAIS ROYALE MARKETING 59,775.26 506.00 0.00 64.06 0.00 0.00 60,345.32 0.0060,345.320.00274 MORRIS PAC SELF-PROMOTION 68,638.84 7,611.00 0.00 72.04 0.00 0.00 76,321.88 0.0076,321.880.00280 POLICE BLOCK GRANTS 3,971.67 0.00 0.00 4.16 0.00 0.00 3,975.83 0.003,975.830.00281 DEPT. COMMUNITY INVESTMENT - REV BONDS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.000.00289 HAZMAT 24,171.51 0.00 5,198.14 25.36 0.00 0.00 18,998.73 0.0018,998.730.00291 INDIANA RIVER RESCUE 178,188.22 3,900.00 7,701.08 182.30 0.00 0.00174,569.44 0.00174,569.440.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 99,280.06 0.00 113.93 104.38 0.00 0.00 99,270.51 0.0099,270.510.00295 COPS MORE GRANT 115,036.76 965.52 1,440.00 122.44 0.00 0.00 114,684.72 0.00114,684.720.00299 POLICE FEDERAL DRUG ENFORCEMENT 145,455.00 0.00 22,100.00 254.580.00 0.00 123,609.58 0.00123,609.580.00404 COUNTY OPTION INCOME TAX 11,136,010.24 1,501,557.54 421,657.8812,049.44 0.00 0.00 12,227,959.34 0.0012,227,959.34867,317.80408 ECONOMIC DEVELOPMENT INCOME TAX 16,125,610.44 893,463.25 934,827.83 17,354.18 0.00 32,031.77 16,069,568.27 0.0016,069,568.270.00410 URBAN DEVELOPMENT ACTION GRANT (UDAG) 405,958.19 0.00 387,064.60 426.07 0.00 0.00 19,319.66 0.0019,319.66(867,317.80)655 PROJECT RELEAF 693,621.03 43,991.46 27,591.82 819.90 0.00 0.00 710,840.57 0.00710,840.570.00705 POLICE K-9 UNIT 2,921.76 0.00 0.00 3.06 0.00 0.00 2,924.82 0.002,924.820.00Total Special Revenue Funds66,645,373.89 4,968,877.28 6,479,757.41 70,092.63 27,213.44 32,031.77 65,199,768.06 69,782.0065,269,550.06200,000.00 Debt Service Fund312 2017 PARKS BOND DEBT SERVICE(187,997.71)0.00 0.00 0.00 0.00 0.00(187,997.71)0.00(187,997.71)0.00313 HALL OF FAME DEBT SERVICE (109,687.50)0.00 0.00 0.00 0.00 0.00(109,687.50)0.00(109,687.50)0.00755 SB BUILDING CORPORATION 789,614.29 0.00 0.00 880.07 0.00 0.00 790,494.36 0.00790,494.360.00757 2015 PARKS BOND DEBT SERVICE 463,391.78 0.00 0.00 152.32 32,031.77 0.00 495,575.87 0.00495,575.870.00760 EDDY ST. COMMONS DEBT SERVICE 2,505,330.47 0.00 0.00 702.45 0.00 0.00 2,506,032.92 0.002,506,032.920.00Capital Project Funds377 PROFESSIONAL SPORTS DEVELOPMENT(783,696.36)0.00 0.00 0.00 0.00 0.00(783,696.36)0.00(783,696.36)0.00401 COVELESKI STADIUM CAPITAL 55,229.46 29,082.25 0.00 57.96 0.00 0.0084,369.67 0.0084,369.670.00405 PARK NONREVERTING CAPITAL 131,775.28 60.00 4,414.49 56.09 0.00 0.00 127,476.88 0.00127,476.880.00406 CUMULATIVE CAPITAL DEVELOPMENT 429,201.73 0.00 10,711.49 450.460.00 0.00 418,940.70 0.00418,940.700.00407 CUMULATIVE CAPITAL IMPROVEMENT 321,503.84 0.00 0.00 337.44 0.00 0.00 321,841.28 0.00321,841.280.00412 MAJOR MOVES CONSTRUCTION 2,840,353.77 0.00 40,662.00 2,981.10 0.00 0.00 2,802,672.87 0.002,802,672.874,208,792.61416 MORRIS PERFORMING ARTS CENTER CAPITAL 383,315.84 7,611.00 32,301.50 408.62 0.00 0.00 359,033.96 0.00359,033.960.00450 PALAIS ROYALE HISTORIC PRESERVATION 123,902.16 2,849.89 0.00 130.04 0.00 0.00 126,882.09 0.00126,882.090.00451 2018 FIRE STATION #9 CAPITAL 4,454,809.04 0.00 746,621.00 4,701.33 0.00 0.00 3,712,889.37 0.003,712,889.370.00452 2018 TIF PARK BOND CAPITAL 10,744,372.69 0.00 55,670.87 0.00 0.000.00 10,688,701.82 0.0010,688,701.820.00471 2017 PARKS BOND CAPITAL 13,531,783.18 0.00 209,987.79 14,211.00 0.00 0.00 13,336,006.39 0.0013,336,006.390.00Month of: October 2018Monthly Cash Report 10-20183
City of South BendController's Cash ReportOpening Interest Transfers TransfersEnding Total Cash & Interfund LoansFund Fund Name Cash Balance Receipts Disbursements Earned InOut Cash Balance Investments Investments (Borrowing)Month of: October 2018677 HALL OF FAME CAPITAL FUND 425,095.11 0.00 0.00 447.36 0.00 0.00 425,542.47 0.00425,542.47(425,542.47)750 EQUIPMENT / VEHICLE LEASING 4,066,634.51 302,399.37 1,445,213.87 4,398.00 0.00 58,707.41 2,869,510.60 0.002,869,510.600.00751 2015 PARKS BOND CAPITAL 1,682,873.45 260.00 44,870.01 430.86 0.000.00 1,638,694.30 0.001,638,694.300.00753 SMART STREET BOND CAPITAL 70,283.41 0.00 0.00 17.91 0.00 0.00 70,301.32 0.0070,301.320.00759 EDDY ST COMMONS CAPITAL 11,122,067.90 0.00 1,863,332.33 17.51 0.00 0.00 9,258,753.08 0.009,258,753.080.00Total Capital & Debt Service Funds53,060,156.34 342,262.51 4,453,785.35 30,380.52 32,031.77 58,707.41 48,952,338.38 0.0048,952,338.383,783,250.14Enterprise Funds287 EMS CAPITAL 4,122,302.30 276,753.60 5,197.07 4,326.83 2,315.24 0.00 4,400,500.90 0.004,400,500.900.00288 EMS OPERATING 2,457,610.13 628,885.22 735,273.49 2,438.55 0.00 0.00 2,353,660.41 0.002,353,660.410.00600 CONSOLIDATED BUILDING DEPARTMENT 2,400,335.33 180,905.02 319,479.38 2,449.09 7,428.06 0.00 2,271,638.12 0.002,271,638.120.00601 PARKING GARAGES 1,302,341.41 73,713.68 72,876.49 1,357.05 0.00 0.00 1,304,535.65 0.001,304,535.65(1,427,141.00)610 SOLID WASTE OPERATIONS 248,567.44 539,814.27 354,575.18 312.72 0.00 39,246.00 394,873.25 0.00394,873.250.00611 SOLID WASTE CAPITAL 236,032.71 1,332.11 83,973.89 199.00 39,246.00 0.00 192,835.93 0.00192,835.930.00620 WATER WORKS OPERATIONS 3,634,054.04 2,219,280.52 1,327,425.76 3,183.94 5,663.62 165,595.00 4,369,161.36 0.004,369,161.360.00622 WATER WORKS CAPITAL 1,974,520.56 11,574.54 3,629.00 2,071.23 0.000.00 1,984,537.33 0.001,984,537.330.00624 WATER WORKS CUSTOMER DEPOSIT 1,505,242.53 14,368.01 15,356.75 1,583.93 0.00 1,583.93 1,504,253.79 0.001,504,253.790.00625 WATER WORKS SINKING FUND 1,233,493.50 0.00 0.00 1,273.11 165,595.00 1,273.11 1,399,088.50 0.001,399,088.500.00626 WATER WORKS BOND RESERVE 1,442,729.79 0.00 0.00 1,529.55 0.00 0.001,444,259.34 0.001,444,259.340.00629 WATER WORKS RESERVE - O & M 2,670,169.40 0.00 0.00 2,806.58 0.002,806.58 2,670,169.40 0.002,670,169.400.00640 SEWER REPAIR INSURANCE 1,963,553.77 63,374.93 51,970.90 2,053.280.00 0.00 1,977,011.08 0.001,977,011.080.00641 SEWAGE WORKS OPERATIONS 12,565,142.71 4,128,935.13 2,132,593.1113,004.81 12,716.97 763,031.54 13,824,174.97 0.0013,824,174.970.00642 SEWAGE WORKS CAPITAL 9,809,530.59 29,083.00 338,515.00 10,410.520.00 0.00 9,510,509.11 0.009,510,509.110.00643 SEWAGE WORKS RESERVE - O & M 5,399,084.29 0.00 0.00 5,674.90 0.005,674.90 5,399,084.29 0.005,399,084.290.00649 SEWAGE WORKS BOND SINKING 7,547,630.06 0.00 0.00 7,761.93 763,031.54 0.00 8,318,423.53 0.008,318,423.530.00653 SEWAGE WORKS DEBT SERVICE RESERVE 4,177,359.85 0.00 0.00 6,363.41 0.00 0.00 4,183,723.26 0.004,183,723.260.00670 CENTURY CENTER 1,756,816.37 43,954.99 83,069.87 0.00 0.00 0.00 1,717,701.49 0.001,717,701.490.00671 CENTURY CENTER CAPITAL 855,979.66 0.00 0.00 181.77 0.00 0.00 856,161.43 0.00856,161.430.00672 CENTURY CENTER ENERGY SAVINGS 325,585.08 0.00 209,987.99 10.65 0.00 0.00 115,607.74 0.00115,607.740.00Total Enterprise Funds67,628,081.52 8,211,975.02 5,733,923.88 68,992.85 995,996.43 979,211.06 70,191,910.88 0.0070,191,910.88(1,427,141.00)Internal Service Funds222 CENTRAL SERVICES 1,082,004.75 1,039,424.91 1,094,794.12 732.38 0.00 0.00 1,027,367.92 0.001,027,367.920.00224 CENTRAL SERVICES CAPITAL 190,652.31 0.00 12,178.36 151.62 0.00 0.00 178,625.57 0.00178,625.570.00226 LIABILITY INSURANCE 3,760,479.43 215,602.46 284,985.39 3,465.69 0.00 0.00 3,694,562.19 0.003,694,562.190.00278 TAKE HOME VEHICLE POLICE 763,460.85 302.86 17,802.40 801.37 0.00 0.00 746,762.68 0.00746,762.680.00279 IT / INNOVATION / 311 CALL CENTER 2,908,221.68 572,253.61 810,633.36 2,723.92 0.00 0.00 2,672,565.85 0.002,672,565.850.00711 SELF-FUNDED EMPLOYEE BENEFITS 12,041,161.97 1,487,784.92 1,667,142.67 13,035.57 0.00 413,714.00 11,461,125.79 0.0011,461,125.790.00713 UNEMPLOYMENT COMP FUND 207,935.43 0.00 0.00 218.30 0.00 0.00 208,153.73 0.00208,153.730.00714 PARENTAL LEAVE FUND 37,668.04 12,225.39 5,007.19 36.41 0.00 0.00 44,922.65 0.0044,922.650.00Total Internal Service Funds20,991,584.46 3,327,594.15 3,892,543.49 21,165.26 0.00 413,714.00 20,034,086.38 0.0020,034,086.380.00Trust & Agency Funds701 FIREFIGHTERS PENSION 1,409,577.44 0.00 368,808.35 0.00 0.00 0.00 1,040,769.09 0.001,040,769.090.00702 POLICE PENSION 2,459,807.53 2,522.81 503,418.70 0.00 0.00 0.00 1,958,911.64 0.001,958,911.640.00709 PAYROLL FUND (1,442.21)8,256,558.09 8,255,115.88 0.00 0.00 0.00 0.00 0.000.000.00718 STATE TAX DEDUCTION FUND 282,189.86 272,760.67 282,189.86 0.00 0.00 0.00 272,760.67 0.00272,760.670.00725 MORRIS / PALAIS BOX OFFICE 2,482,980.94 202,783.77 0.00 0.00 0.000.00 2,685,764.71 0.002,685,764.710.00726 POLICE DISTRIBUTIONS PAYABLE 822,823.84 9,175.05 0.00 0.00 0.00 0.00 831,998.89 0.00831,998.890.00730 CITY CEMETERY TRUST 28,835.86 0.00 0.00 30.26 0.00 0.00 28,866.12 0.0028,866.120.00731 BOWMAN CEMETERY 0.00 455,518.43 0.00 0.00 0.00 0.00 455,518.43 0.00455,518.430.00Total Trust & Agency Funds7,484,773.26 9,199,318.82 9,409,532.7930.26 0.00 0.00 7,274,589.55 0.007,274,589.550.00Total City Funds245,833,528.89 27,580,484.00 34,539,959.21 223,210.90 1,483,664.24 1,483,664.24 239,097,264.58 69,782.00 239,167,046.58 2,981,651.61Monthly Cash Report 10-20184
City of South BendController's Cash ReportOpening Interest Transfers TransfersEnding Total Cash & Interfund LoansFund Fund Name Cash Balance Receipts Disbursements Earned InOut Cash Balance Investments Investments (Borrowing)Month of: October 2018Redevelopment Commission Controlled FundsTax Increment Financing Funds324 TIF RIVER WEST 27,385,953.06 410,154.94 2,236,674.36 27,781.30 2,981.97 198,500.00 25,391,696.91 0.0025,391,696.91(200,000.00)422 TIF DISTRICT - WEST WASHINGTON 1,899,515.29 0.00 10,143.52 2,153.95 0.00 0.00 1,891,525.72 0.001,891,525.720.00425 REDEVELOPMENT RETAIL AREA 141,420.27 0.00 0.00 145.99 0.00 0.00 141,566.26 0.00141,566.260.00429 TIF RIVER EAST DEV (NE) 9,526,265.99 0.00 26,932.50 10,001.56 0.00 0.00 9,509,335.05 0.009,509,335.050.00430 TIF SOUTHSIDE DEVELOPMENT AREA #1 8,893,135.70 0.00 19,125.75 9,342.35 0.00 0.00 8,883,352.30 0.008,883,352.300.00435 TIF DOUGLAS ROAD 203,268.41 0.00 0.00 213.34 0.00 0.00 203,481.75 0.00203,481.750.00436 TIF RIVER EAST RES (NE RE) 1,866,530.85 0.00 2,026.00 0.00 0.00 0.00 1,864,504.85 0.001,864,504.85(2,781,651.61)Total Tax Increment Financing Funds49,916,089.57 410,154.94 2,294,902.13 49,638.49 2,981.97 198,500.00 47,885,462.84 0.0047,885,462.84(2,981,651.61)Redevelopment Funds433 REDEVELOPMENT ADMINISTRATION GENERAL 641,118.18 0.00 0.00 100.610.00 0.00 641,218.79 0.00641,218.790.00439 CERTIFIED TECHNOLOGY PARK 620,956.21 0.00 0.00 651.72 0.00 0.00 621,607.93 0.00621,607.930.00454 AIRPORT URBAN ENTERPRISE ZONE 391,603.00 0.00 0.00 411.00 0.00 0.00 392,014.00 0.00392,014.000.00754 INDUSTRIAL REVOLVING FUND 2,548,717.00 10,211.00 8,554.00 20,387.00 0.00 0.00 2,570,761.00 0.002,570,761.000.00Total Redevelopment Funds4,202,394.39 10,211.00 8,554.00 21,550.33 0.00 0.00 4,225,601.72 0.004,225,601.720.00Debt Service Funds 315 AIRPORT 2003 DEBT RESERVE 1,040,462.24 0.00 0.00 1,093.61 0.00 1,093.61 1,040,462.24 0.001,040,462.240.00317 COVELESKI BOND DEBT RESERVE 523,847.59 0.00 0.00 549.81 0.00 0.00 524,397.40 0.00524,397.400.00328 SBCDA 2003 DEBT RESERVE 1,739,494.86 0.00 0.00 1,828.36 0.00 1,828.36 1,739,494.86 0.001,739,494.860.00351 2018 TIF PARK BOND DEBT SERVICE RESERVE 993,495.00 0.00 0.00 0.00 0.00 0.00 993,495.00 0.00993,495.000.00752 SB REDEVELOPMENT AUTHORITY 49,454.74 0.00 1,200.00 1,035.46 0.00 0.00 49,290.20 0.0049,290.200.00756 SMARTS STREETS DEBT SERVICE 1,725,059.70 0.00 0.00 439.53 0.00 0.00 1,725,499.23 0.001,725,499.230.00Total Debt Service Funds6,071,814.13 0.00 1,200.00 4,946.770.00 2,921.97 6,072,638.93 0.006,072,638.930.00Total Redevelopment Commission Funds60,190,298.09 420,365.94 2,304,656.13 76,135.59 2,981.97 201,421.97 58,183,703.49 0.00 58,183,703.49(2,981,651.61)City Operations Total306,023,826.98 28,000,849.94 36,844,615.34 299,346.49 1,486,646.21 1,685,086.21 297,280,968.07 69,782.00 297,350,750.07 0.00Memo ItemPooled Investment AccountOpening Interest Accrued Change in Transfer In Transfer out Investment Total Cash &Balance Net of Fees Income Asset Value from Depositoryto DepositoryBalance Investments1st Source Bank Investment Account184,018,633.19 311,180.56 0.00 (89,889.59) 0.00 118,508.44 184,121,415.72 184,121,415.72Monthly Cash Report 10-20185
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 PolicyInsufficient Balances201 Parks & Recreation 4,183,307 1,889,346 2,293,960 4,070,515 (1,776,555) 14% Property tax distribution received in June & Dec25% of Annual expenditures211 DCI Administration Fund 584,612 131,774 452,837 769,274 (316,437) 15%25% of Annual expenditures219 Unsafe Building 466,379 236,112 230,267 243,103 (12,836) 24% High encumbrances25% of Annual expenditures222 Central Services 1,027,368 21,366 1,006,002 1,108,172 (102,170) 23% Just under reserve target25% of Annual expenditures, excluding utility accounting278 Take Home Vehicle Police 746,763 - 746,763 750,000 (3,237) 7468% Just under reserve targetSet dollar amount of $750,000610 Solid Waste Operations 394,873 107,262 287,611 549,605 (261,994) 5% High encumbrances10% of Annual expenditures629 Water Works Reserve - O & M 2,670,169 - 2,670,169 2,670,510 (341) 17% Just under reserve target16.67% of annual operating expenses in Fund 620, net of transfers10,073,471 2,385,861 7,687,609 10,161,179 (2,473,570) Meets or Exceeds Requirements101 General Fund 27,444,571 585,398 26,859,174 21,640,751 5,218,423 43% Property tax distribution received in June & Dec35% of Annual expenditures102 Rainy Day Fund 10,421,477 - 10,421,477 9,745,767 675,710 3%3% of total expenditures in previous fiscal year202 Motor Vehicle Highway 7,862,483 1,016,539 6,845,944 3,098,495 3,747,449 55%25% of Annual expenditures203 Recreation - Nonreverting 836,803 102,523 734,281 435,101 299,180 42%25% of Annual expenditures216 Police State Seizures 226,958 804 226,155 8,000 218,155 707%25% of Annual expenditures218 Police Curfew Violations 13,054 - 13,054 250 12,804 1305%25% of Annual expenditures220 Law Enforce. Continuing Education 518,695 20,490 498,205 148,656 349,549 84%25% of Annual expenditures226 Liability Insurance 3,694,562 283,097 3,411,465 2,196,121 1,215,344 78%50% of Annual expenditures249 Public Safety L.O.I.T. 1,939,036 - 1,939,036 609,838 1,329,198 25% 8% of Annual expenditures - one month reserve251 Local Roads & Streets 4,025,936 582,346 3,443,591 854,627 2,588,964 101%25% of Annual expenditures258 Human Rights - Federal Grant 527,761 8,272 519,490 40,809 478,681 318%25% of Annual expenditures273 Morris PAC/Palais Royale Marketing 60,345 1,606 58,740 4,500 54,240 326%25% of Annual expenditures274 Morris PAC/Self-Promotion 76,322 - 76,322 12,500 63,822 153%25% of Annual expenditures287 EMS Capital 4,400,501 215,619 4,184,882 847,433 3,337,449 123%25% of Annual expenditures288 EMS Operating 2,353,660 73,272 2,280,388 1,607,937 672,451 35%25% of Annual expenditures289 HAZMAT 18,999 472 18,526 2,500 16,026 185%25% of Annual expenditures291 Indiana River Rescue 174,569 12,210 162,359 25,450 136,909 159%25% of Annual expenditures294 Regional Police Academy 99,271 355 98,916 5,625 93,291 440%25% of Annual expenditures299 Police Federal Drug Enforcement 123,610 - 123,610 12,750 110,860 242%25% of Annual expenditures315 Airport 2003 Debt Reserve 1,040,462 - 1,040,462 1,040,462 - 100%100% debt service reserve per bond covenants317 Coveleski Bond Debt Reserve 524,397 - 524,397 524,397 - 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) 25,391,697 8,065,554 17,326,143 12,089,046 5,237,097 36%25% of Annual expenditures351 2018 TIF Park Bond Debt Svc Reserve 993,495 - 993,495 - 993,495 100% 100% debt service reserve per bond covenants404 County Option Income Tax 12,227,959 883,682 11,344,277 6,000,837 5,343,440 95%50% of Annual expenditures405 Park Nonreverting Capital 127,477 19,264 108,213 69,468 38,745 39%25% of Annual expenditures406 Cumulative Capital Development 418,941 - 418,941 114,800 304,141 91%25% of Annual expenditures407 Cumulative Capital Improvement 321,841 - 321,841 69,625 252,216 116%25% of Annual expenditures408 Economic Development Income Tax 16,069,568 465,384 15,604,184 6,107,297 9,496,887 128%50% of Annual expenditures416 Morris Performing Arts Center Capital 359,034 - 359,034 46,025 313,009 195%25% of Annual expenditures422 TIF District - West Washington 1,891,526 1,051,535 839,991 571,479 268,512 37%25% of Annual expenditures425 Redevelopment Retail Area 141,566 - 141,566 61,042 80,524 58%25% of Annual expenditures429 River East Dev TIF (Northeast TIF) 9,509,335 940,724 8,568,611 2,396,923 6,171,688 89%25% of Annual expenditures430 TIF Southside Development Area #1 8,883,352 3,816,717 5,066,635 2,139,007 2,927,628 59%25% of Annual expenditures433 Redev Administration General 641,219 - 641,219 8,150 633,069 1967%25% of Annual expenditures435 TIF - Douglas Road 203,482 4,200 199,282 20,465 178,817 97%10% of Annual expenditures436 River East Residential (Ne Res TIF) 1,864,505 - 1,864,505 1,080,000 784,505 43%25% of Annual expenditures450 Palais Royale Historic Preservation 126,882 31,537 95,345 11,250 84,095 212%25% of Annual expenditures600 Consolidated Building Department 2,271,638 93,821 2,177,817 1,160,813 1,017,004 47%25% of Annual expenditures601 Parking Garages 1,304,536 52,611 1,251,924 313,086 938,838 100%25% of Annual expenditures620 Water Works Operations 4,369,161 571,856 3,797,305 903,514 2,893,791 21%5% of Annual expenditures624 Water Works Customer Deposit 1,504,254 - 1,504,254 1,504,254 - 100%100% cash reserves for customer deposits625 Water Works Sinking Fund 1,399,089 - 1,399,089 1,399,089 - 100%100% cash reserves per bond covenants626 Water Works Bond Reserve 1,444,259 - 1,444,259 1,444,259 - 100%100% cash reserves per bond covenants and Crowe Horwath640 Sewer Repair Insurance 1,977,011 102,609 1,874,402 158,056 1,716,346 296%25% of Annual expendituresOctober 31, 2018Monthly Cash Report 10-20186
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 PolicyOctober 31, 2018641 Sewage Works Operations 13,824,175 2,857,054 10,967,121 2,506,017 8,461,104 22%5% of Annual expenditures643 Sewage Works Reserve - O & M 5,399,084 - 5,399,084 5,385,828 13,256 17% 16.67% of annual operating expenses in Fund 641, net of transfers649 Sewage Works Bond Sinking 8,318,424 - 8,318,424 8,318,424 - 100%100% cash reserves per bond covenants653 Sewage Works Debt Service Reserve 4,183,723 - 4,183,723 4,183,723 - 100%100% cash reserves per bond covenants and Crowe Horwath655 Project Releaf 710,841 1,250 709,591 175,511 534,080 101%25% of Annual expenditures670 Century Center 1,717,701 26,361 1,691,341 1,139,279 552,062 37%25% of Annual expenditures671 Century Center Capital 856,161 - 856,161 800,000 56,161 4281%$800,000 Minimum per Board of Managers701 Firefighters Pension 1,040,769 - 1,040,769 511,246 529,523 20% Pension payments received in June & Sept10% of Annual expenditures702 Police Pension 1,958,912 - 1,958,912 658,345 1,300,567 30% Pension payments received in June & Sept10% of Annual expenditures705 Police K-9 Unit 2,925 592 2,332 505 1,827 115%25% of Annual expenditures711 Self-Funded Employee Benefits 11,461,126 413,783 11,047,343 4,536,380 6,510,963 61%25% of Annual expenditures713 Unemployment Comp Fund 208,154 - 208,154 20,000 188,154 260%25% of Annual expenditures714 Parental Leave Fund 44,923 - 44,923 38,924 5,999 29%25% of Annual expenditures718 State Tax Withholding Fund 272,761 - 272,761 272,761 - 100%100% cash reserves - trust & agency funds725 Morris / Palais Box Office 2,685,765 - 2,685,765 2,685,765 - 100%100% cash reserves - trust & agency funds726 Police Distributions Payable 831,999 - 831,999 831,999 - 100%100% cash reserves - trust & agency funds730 City Cemetery Trust 28,866 - 28,866 6,250 22,616 115%25% of Annual expenditures752 South Bend Redevelopment Authority 49,290 - 49,290 49,290 - 100%100% cash reserves per bond covenants753 Smart Street Bond Capital 70,301 - 70,301 70,301 - 100%100% cash reserves per bond covenants755 South Bend Building Corporation 790,494 - 790,494 790,494 - 100%100% cash reserves per bond covenants756 Smart Streets Debt Service Fund 1,725,499 - 1,725,499 1,725,499 - 100%100% cash reserves per bond covenants757 2015 Parks Bond Debt Service 495,576 - 495,576 495,576 - 100%100% cash reserves per bond covenants760 Eddy St. Commons Debt Service 2,506,033 - 2,506,033 2,506,033 - 100%100% cash reserves per bond covenants220,748,298 22,301,536 198,446,763 119,978,099 78,468,664 No Reserve Requirements209 Studebaker/Oliver Revitalizing Grants 943,708 51,184 892,524 - 892,524 100%No reserve requirement - Grant fund - spend down to zero210 DCI State Grants 362,183 81,000 281,183 - 281,183 100% To be reimbursed by grant receiptsNo reserve requirement - Grant fund - spend down to zero212 DCI Grant Fund 435,033 2,972,650 (2,537,617) - (2,537,617) 100% To be reimbursed by grant receiptsNo reserve requirement - Grant fund - spend down to zero217 Gift, Donation, Bequest 182,084 8,941 173,142 - 173,142 100%No reserve requirement221 Landlord Registration 10,088 - 10,088 - 10,088 100%No reserve requirement224 Central Services Capital 178,626 11,158 167,468 - 167,468 100%No reserve requirement - Capital fund - spend down to zero227 Loss Recovery Fund 681,774 100,291 581,482 - 581,482 100%No reserve requirement257 LOIT 2016 Special Distribution 783,271 816,459 (33,187) - (33,187) 100%No reserve requirement265 Local Road & Bridge Grant 535,803 329,125 206,678 - 206,678 100% Will receive interfund transfer to coverNo reserve requirement - Grant fund - spend down to zero279 IT / Innovation / 311 Call Center 2,672,566 1,182,695 1,489,871 - 1,489,871 100% Reimbursed through inter-fund transferNo reserve requirement280 Police Block Grants 3,976 - 3,976 - 3,976 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 114,685 2,510 112,175 - 112,175 100%No reserve requirement - Grant fund - spend down to zero312 2017 Parks Bond Debt Service(187,998) - (187,998) - (187,998) 100% Will be reimbursed from property taxes in DecNo reserve requirement313 Hall of Fame Debt Service (109,688) - (109,688) - (109,688) 100% Will be reimbursed from property taxes in DecNo reserve requirement377 Professional Sports Development(783,696) - (783,696) - (783,696) 100% Waiting on the receipt of PSDA revenueNo reserve requirement401 Coveleski Stadium Capital 84,370 23,516 60,854 - 60,854 100%No reserve requirement - Capital fund - spend down to zero410 Urban Develop Action Grant (UDAG) 19,320 - 19,320 - 19,320 100%No reserve requirement - Grant fund - spend down to zero412 Major Moves Construction 2,802,673 741,666 2,061,007 - 2,061,007 100%No reserve requirement - Capital fund - spend down to zero439 Certified Technology Park 621,608 - 621,608 - 621,608 100%No reserve requirement451 2018 Fire St #9 Capital 3,712,889 2,734,124 978,766 - 978,766 100%No reserve requirement - Bond capital fund - spend down to zero452 2018 TIF Park Bond Capital 10,688,702 485,759 10,202,943 - 10,202,943 100%No reserve requirement - Bond capital fund - spend down to zero454 Airport Urban Enterprise Zone 392,014 - 392,014 - 392,014 100%No reserve requirement471 2017 Parks Bond Capital 13,336,006 2,708,356 10,627,650 - 10,627,650 100%Bond fund - spend down to zero - no reserves611 Solid Waste Capital 192,836 - 192,836 - 192,836 100%No reserve requirement - Capital fund - spend down to zero622 Water Works Capital 1,984,537 324,120 1,660,417 - 1,660,417 100%No reserve requirement - Capital fund - spend down to zero642 Sewage Works Capital 9,510,509 1,593,886 7,916,623 - 7,916,623 100% Receives transfers from Fund 641 as neededNo reserve requirement - Capital fund - spend down to zero672 Century Center Energy Savings 115,608 - 115,608 - 115,608 100%No reserve requirement677 Hall of Fame Capital Fund 425,542 5,122 420,420 - 420,420 100%No reserve requirement - Capital fund - spend down to zero731 Bowman Cemetery 455,518 - 455,518 - 455,518 100%No reserve requirement established yet750 Equipment/Vehicle Leasing 2,869,511 1,098,220 1,771,290 - 1,771,290 100% No reserve requirement - Capital lease fund - spend down to zeroMonthly Cash Report 10-20187
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 PolicyOctober 31, 2018751 2015 Parks Bond Capital 1,638,694 742,127 896,567 - 896,567 100% No reserve requirement - Bond capital fund - spend down to zero754 Industrial Revolving Fund 2,570,761 - 2,570,761 - 2,570,761 100%No City reserve requirement; there are program requirements759 Eddy St Commons Capital 9,258,753 - 9,258,753 - 9,258,753 100% Over encumbered, fund is being reviewedNo reserve requirement - Bond capital fund - spend down to zero66,528,981 16,012,909 50,516,072 - 50,516,072 City Operations Total 297,350,750 40,700,306 256,650,444 130,139,278 126,511,166 Note: Available Cash is a Fund's cash balance minus any outstanding encumbrancesMonthly Cash Report 10-20188
January 1, 2007 - October 31, 2018
$329,782,565 6/30/2018
$122,056,198 5/31/2007
$211,438,286 --
$289,299,543 --
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
Monthly Cash Report 10-2018 9
January 1, 2007 - October 31, 2018
City of South Bend Cash Balances - All 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
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
Monthly Cash Report 10-2018 10
$83,296,822 1/31/2013
$28,657,187 1/1/2007
$58,248,617 --
$63,114,768 --
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 03/31/18 60,255,912.54
10/31/09 44,855,908.07 01/31/14 66,889,990.77 04/30/18 61,537,542.97
11/30/09 44,458,186.54 02/28/14 67,566,543.96 05/31/18 62,676,079.74
12/31/09 36,891,179.40 03/31/14 68,633,684.73 06/30/18 62,779,584.12
01/31/10 37,726,300.40 04/30/14 68,960,383.93 07/31/18 64,079,751.06
02/28/10 36,982,623.93 05/31/14 67,425,749.33 08/31/18 65,896,576.77
03/31/10 41,475,717.35 06/30/14 67,697,981.00 09/30/18 67,628,081.52
04/30/10 40,478,357.60 07/31/14 68,611,865.99 10/31/18 70,191,910.88
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.
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 - October 31, 2018
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
Monthly Cash Report 10-2018 11
$81,992,643 6/30/2018
$26,731,149 1/31/2009
$49,396,179 --
$65,630,925 --
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 03/31/18 56,967,800.25
10/31/09 36,749,933.72 01/31/14 50,898,242.66 04/30/18 70,308,595.71
11/30/09 35,847,660.55 02/28/14 49,986,290.38 05/31/18 69,433,440.38
12/31/09 34,358,243.89 03/31/14 49,028,261.04 06/30/18 81,992,642.55
01/31/10 53,534,937.83 04/30/14 47,281,387.13 07/31/18 78,753,842.27
02/28/10 52,816,628.95 05/31/14 46,795,213.96 08/31/18 73,401,834.82
03/31/10 52,577,148.25 06/30/14 61,118,881.00 09/30/18 70,934,670.78
04/30/10 51,768,568.42 07/31/14 56,842,280.86 10/31/18 58,183,703.49
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: 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 - October 31, 2018
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
Monthly Cash Report 10-2018 12
$185,010,338 6/30/2018
$53,052,887 5/31/2007
$103,926,062 --
$160,936,136 --
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 03/31/18 157,559,868.19
10/31/09 68,758,254.71 01/31/14 114,256,166.29 04/30/18 148,410,420.86
11/30/09 63,704,336.96 02/28/14 109,603,281.18 05/31/18 148,710,961.31
12/31/09 117,203,577.74 03/31/14 104,384,382.05 06/30/18 185,010,338.05
01/31/10 104,838,291.70 04/30/14 98,541,834.35 07/31/18 174,174,636.01
02/28/10 104,864,103.11 05/31/14 95,103,846.00 08/31/18 169,092,973.62
03/31/10 103,854,789.67 06/30/14 122,883,782.00 09/30/18 167,461,074.68
04/30/10 98,183,077.33 07/31/14 113,327,256.18 10/31/18 168,975,135.70
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
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 - October 31, 2018
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
Monthly Cash Report 10-2018 13