Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2020-01 - 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 Chief of Staff Deputy Chief of Staff Common Council Department Heads Fiscal Officers January 31, 2020 Controller's Office City of South Bend Monthly Cash Report 2020-01 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-7) 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-12) 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 224, 312, and 701 have a negative cash balance. - The Central Service Capital Fund 224 receives interfund transfers from the Central Services Operating Fund 222 to support capital purchases. Funds will be transferred to cover January's capital purchases. - 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 Firefighter's Pension Fund 701 receives reimbursement from the State in June and September. This fund can a have a negative balance when it is waiting to be reimbursed by the State. 2020-01 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 $44,786,780.84$1,657,815.39$5,096,058.40$59,137.17$133,333.00$0.00 $41,541,008.00$0.00$41,541,008.00$0.00Special Revenue Funds102 RAINY DAY FUND 10,708,299.51 0.00 0.00 18,224.09 0.00 0.00 10,726,523.60 0.0010,726,523.600.00201 PARKS & RECREATION 3,641,123.97 836,036.81 2,032,165.46 2,293.54 66,663.00 0.00 2,513,951.86 0.002,513,951.860.00202 MOTOR VEHICLE HIGHWAY 4,732,078.16 265,879.56 896,613.90 6,998.15 369,818.00 0.00 4,478,159.97 0.004,478,159.970.00209 STUDEBAKER/OLIVER REVERTING GRANTS 927,234.76 0.00 23,029.28 1,578.26 0.00 0.00 905,783.74 0.00905,783.74100,000.00210 DEPT COMMUNITY INVESTMENT STATE GRANTS 64,753.99 17,085.20 4,881.75 1,063.50 0.00 0.00 78,020.94 0.0078,020.940.00211 DCI OPERATING FUND 1,009,932.54 30,019.36 238,883.82 1,000.86 190,737.00 0.00 992,805.94 0.00992,805.940.00212 DEPARTMENT OF COMMUNITY INVESTMENT 305,248.08 298,686.84 272,306.82 230.04 0.00 0.00 331,858.14 0.00331,858.140.00216 POLICE STATE SEIZURES 237,763.95 0.00 0.00 404.64 0.00 0.00 238,168.59 0.00238,168.590.00217 GIFT, DONATION, BEQUEST 666,875.29 71,833.58 13,428.85 1,034.57 0.00 0.00 726,314.59 70,828.53797,143.120.00218 POLICE CURFEW VIOLATIONS 12,863.73 0.00 0.00 21.88 0.00 0.00 12,885.61 0.0012,885.610.00219 UNSAFE BUILDING 920,988.93 2,708.79 16,798.94 1,292.40 0.00 0.00 908,191.18 0.00908,191.180.00220 LAW ENFORCEMENT CONTINUING EDUCATION 420,288.18 31,251.42 38,520.00 701.14 0.00 0.00 413,720.74 0.00413,720.740.00221 LANDLORD REGISTRATION 17,781.27 1,350.00 12,214.80 29.89 20,467.00 0.00 27,413.36 0.0027,413.360.00227 LOSS RECOVERY FUND 604,050.53 0.00 0.00 1,028.01 0.00 0.00 605,078.54 0.00605,078.540.00230 CODE ENFORCEMENT 0.00 23,604.27 272,823.35 0.00 301,619.00 0.00 52,399.92 0.0052,399.920.00249 PUBLIC SAFETY L.O.I.T. 3,246,155.37 730,527.50 683,650.89 5,561.83 0.00 0.00 3,298,593.81 0.003,298,593.810.00251 LOCAL ROADS & STREETS 5,220,874.32 159,735.61 22,964.35 7,591.12 0.00 0.00 5,365,236.70 0.005,365,236.700.00257 LOIT 2016 SPECIAL DISTRIBUTION 170,334.55 0.00 32,337.92 296.23 0.00 0.00 138,292.86 0.00138,292.860.00258 HUMAN RIGHTS - FEDERAL GRANT 519,829.22 1,000.00 14,422.93 782.07 0.00 0.00 507,188.36 0.00507,188.360.00265 LOCAL ROAD & BRIDGE GRANT 448,377.06 0.00 80,354.09 763.03 0.00 0.00 368,786.00 0.00368,786.000.00266 MVH RESTRICTED 648,876.73 238,269.40 5,161.39 1,281.37 0.00 0.00 883,266.11 0.00883,266.110.00273 MORRIS PAC/PALAIS ROYALE MARKETING 72,873.25 500.00 0.00 117.71 0.00 0.00 73,490.96 0.0073,490.960.00274 MORRIS PAC SELF-PROMOTION 186,401.14 10,572.00 0.00 302.18 0.00 0.00 197,275.32 0.00197,275.320.00280 POLICE BLOCK GRANTS 4,085.21 0.00 0.00 6.94 0.00 0.00 4,092.15 0.004,092.150.00289 HAZMAT 27,581.68 0.00 0.00 47.77 0.00 0.00 27,629.45 0.0027,629.450.00291 INDIANA RIVER RESCUE 292,637.24 13,000.00 446.16 496.47 0.00 0.00 305,687.55 0.00305,687.550.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 118,203.52 4,850.00 0.00 201.37 0.00 0.00 123,254.89 0.00123,254.890.00295 COPS MORE GRANT 169,041.58 46,391.54 145,199.68 322.82 0.00 0.00 70,556.26 0.0070,556.260.00299 POLICE FEDERAL DRUG ENFORCEMENT 113,551.50 45,427.36 45,427.36 165.63 0.00 0.00 113,717.13 0.00113,717.130.00404 COUNTY OPTION INCOME TAX 12,694,851.99 1,048,787.47 1,191,126.33 23,168.46 0.00 530,127.00 12,045,554.59 0.0012,045,554.59420,253.20408 ECONOMIC DEVELOPMENT INCOME TAX 17,348,536.33 1,459,834.04 487,871.59 31,533.44 0.00 550,455.90 17,801,576.32 0.0017,801,576.320.00410 URBAN DEVELOPMENT ACTION GRANT (UDAG) 53,711.51 5,212.00 10,000.00 91.40 0.00 0.00 49,014.91 0.0049,014.91(420,253.20)655 PROJECT RELEAF 397,249.04 37,989.81 3,581.02 915.56 0.00 25,000.00 407,573.39 0.00407,573.390.00705 POLICE K-9 UNIT 2,389.60 0.00 0.00 4.07 0.00 0.00 2,393.67 0.002,393.670.00754 INDUSTRIAL REVOLVING FUND 2,078,332.97 0.00 0.00 0.00 0.00 0.00 2,078,332.97 0.002,078,332.970.00Total Special Revenue Funds68,109,892.205,380,552.566,544,210.68109,550.44949,304.001,105,582.9066,899,505.6270,828.5366,970,334.15100,000.00 Debt Service Fund312 2017 PARKS BOND DEBT SERVICE 208,250.67 0.00 576,832.50 0.00 0.00 0.00(368,581.83)0.00(368,581.83)0.00350 2018 FIRE ST #9 DEBT SERVICE 0.00 0.00 173,865.64 0.00 173,865.64 0.00 0.00 0.000.000.00752 SB REDEVELOPMENT AUTHORITY 222,584.44 0.00 0.00 283.02 1,237,000.00 0.00 1,459,867.46 0.001,459,867.460.00755 SB BUILDING CORPORATION 815,025.00 0.00 0.00 710.67 1,319,250.00 0.00 2,134,985.67 0.002,134,985.670.00756 SMARTS STREETS DEBT SERVICE 1,734,900.75 0.00 0.00 221.01 858,000.00 0.00 2,593,121.76 0.002,593,121.760.00757 2015 PARKS BOND DEBT SERVICE 590,496.66 0.00 0.00 267.45 31,282.90 0.00 622,047.01 0.00622,047.010.00760 EDDY ST. COMMONS DEBT SERVICE 3,461,700.03 0.00 0.00 441.00 648,125.00 0.00 4,110,266.03 0.004,110,266.030.00Capital Project Funds401 COVELESKI STADIUM CAPITAL 25,788.90 0.00 0.00 46.92 0.00 0.00 25,835.82 0.0025,835.820.00406 CUMULATIVE CAPITAL DEVELOPMENT 223,092.91 0.00 82,580.10 166.34 0.00 0.00 140,679.15 0.00140,679.150.00407 CUMULATIVE CAPITAL IMPROVEMENT 687,398.63 0.00 0.00 968.64 0.00 20,837.00 667,530.27 0.00667,530.270.00412 MAJOR MOVES CONSTRUCTION 2,190,821.50 0.00 11,932.92 3,734.46 0.00 0.00 2,182,623.04 0.002,182,623.042,388,902.44416 MORRIS PERFORMING ARTS CENTER CAPITAL 421,134.98 10,572.00 81,282.00 702.92 0.00 0.00 351,127.90 0.00351,127.900.00450 PALAIS ROYALE HISTORIC PRESERVATION 107,538.79 1,834.92 34,160.00 182.46 0.00 0.00 75,396.17 0.0075,396.170.00451 2018 FIRE STATION #9 CAPITAL 398,939.58 0.00 0.00 678.94 0.00 0.00 399,618.52 0.00399,618.520.00Month of: January 20202020-01 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: January 2020453 2018 ZOO BOND CAPITAL 120,929.14 0.00 0.00 94.08 0.00 0.00 121,023.22 0.00121,023.220.00471 2017 PARKS BOND CAPITAL 9,041,541.92 0.00 108,859.62 15,401.74 0.00 0.00 8,948,084.04 0.008,948,084.040.00750 EQUIPMENT / VEHICLE LEASING 1,016,471.64 809.96 338,807.67 472.23 0.00 0.00 678,946.16 0.00678,946.160.00759 EDDY ST COMMONS BOND CAPITAL 3,048,190.46 0.00 215,224.47 3.28 0.00 2,832,969.27 0.002,832,969.270.00Total Capital & Debt Service Funds24,314,806.0013,216.881,623,544.9224,375.164,267,523.5420,837.0026,975,539.660.0026,975,539.662,388,902.44Enterprise Funds287 EMS CAPITAL 1,957,611.44 0.00 30,125.57 3,152.91 0.00 375,615.64 1,555,023.14 0.001,555,023.140.00288 EMS OPERATING 2,514,249.60 0.00 56,309.36 3,688.31 0.00 0.00 2,461,628.55 0.002,461,628.550.00600 CONSOLIDATED BUILDING DEPARTMENT 2,280,373.12 89,875.01 144,422.00 2,975.27 0.00 0.00 2,228,801.40 0.002,228,801.400.00601 PARKING GARAGES 1,323,141.97 62,000.75 367,220.63 2,211.80 0.00 0.00 1,020,133.89 0.001,020,133.890.00610 SOLID WASTE OPERATIONS 448,091.10 451,479.93 371,352.05 788.50 0.00 185,000.00 344,007.48 0.00344,007.480.00611 SOLID WASTE CAPITAL 64,772.56 0.00 185,051.06 110.20 185,000.00 0.00 64,831.70 0.0064,831.700.00620 WATER WORKS OPERATIONS 4,194,556.57 1,856,252.36 1,510,476.71 6,151.87 9,991.24 440,268.00 4,116,207.33 0.004,116,207.330.00622 WATER WORKS CAPITAL 4,177,610.69 161,595.00 29,731.50 7,064.26 321,837.00 0.00 4,638,375.45 0.004,638,375.450.00624 WATER WORKS CUSTOMER DEPOSIT 1,284,428.68 9,730.91 9,624.74 2,188.68 0.00 2,188.68 1,284,534.85 0.001,284,534.850.00625 WATER WORKS SINKING FUND 285,459.84 0.00 0.00 2,868.18 101,500.00 2,868.18 386,959.84 0.00386,959.840.00626 WATER WORKS BOND RESERVE 1,424,700.96 0.00 0.00 2,423.29 0.00 0.00 1,427,124.25 0.001,427,124.250.00629 WATER WORKS RESERVE - O & M 2,895,721.40 0.00 0.00 4,934.38 16,931.00 4,934.38 2,912,652.40 0.002,912,652.400.00640 SEWER REPAIR INSURANCE 2,168,507.39 57,826.82 73,774.89 3,660.92 0.00 0.00 2,156,220.24 0.002,156,220.240.00641 SEWAGE WORKS OPERATIONS 15,373,313.18 3,318,479.17 2,022,184.05 26,096.90 10,144.00 41,389.50 16,664,459.70 0.0016,664,459.700.00642 SEWAGE WORKS CAPITAL 9,394,977.31 391,590.00 361,864.00 17,120.92 0.00 0.00 9,441,824.23 0.009,441,824.230.00643 SEWAGE WORKS RESERVE - O & M 5,550,801.29 0.00 0.00 9,458.71 0.00 9,458.71 5,550,801.29 0.005,550,801.290.00649 SEWAGE WORKS BOND SINKING 1,085,193.51 0.00 1,100.00 1,843.08 0.00 0.00 1,085,936.59 0.001,085,936.590.00653 SEWAGE WORKS DEBT SERVICE RESERVE 4,291,915.06 0.00 0.00 5,339.65 0.00 0.00 4,297,254.71 0.004,297,254.710.00654 SEWAGE WORKS DEPOSIT FUND 412,188.06 30,880.14 9,152.00 685.29 0.00 685.29 433,916.20 0.00433,916.200.00667 STORM SEWER FUND 124,114.28 88,830.22 19,531.67 153.14 0.00 0.00 193,565.97 0.00193,565.970.00670 CENTURY CENTER 1,537,196.18 716,252.05 122,279.73 0.00 0.00 0.00 2,131,168.50 0.002,131,168.500.00671 CENTURY CENTER CAPITAL 981,681.30 0.00 0.00 831.82 0.00 0.00 982,513.12 0.00982,513.120.00672 CENTURY CENTER ENERGY SAVINGS 189,082.38 221,437.00 0.00 246.81 0.00 0.00 410,766.19 0.00410,766.190.00Total Enterprise Funds63,959,687.877,456,229.365,314,199.96103,994.89645,403.241,062,408.3865,788,707.020.0065,788,707.020.00Internal Service Funds222 CENTRAL SERVICES 1,451,744.77 1,076,128.37 1,006,258.57 1,591.60 0.00 0.00 1,523,206.17 0.001,523,206.170.00224 CENTRAL SERVICES CAPITAL 21,869.92 0.00 51,795.00 76.50 0.00 0.00(29,848.58)0.00(29,848.58)0.00226 LIABILITY INSURANCE 4,949,789.69 1,648,063.06 523,749.75 8,527.88 0.00 0.00 6,082,630.88 0.006,082,630.880.00278 TAKE HOME VEHICLE POLICE 723,492.74 360.00 0.00 1,251.65 0.00 0.00 725,104.39 0.00725,104.390.00279 IT / INNOVATION / 311 CALL CENTER 3,101,052.00 637,047.38 748,388.05 4,464.83 0.00 0.00 2,994,176.16 0.002,994,176.160.00711 SELF-FUNDED EMPLOYEE BENEFITS 9,255,644.05 1,334,071.95 1,544,906.58 16,085.48 0.00 0.00 9,060,894.90 0.009,060,894.900.00713 UNEMPLOYMENT COMP FUND 180,487.12 539.88 0.00 307.28 0.00 0.00 181,334.28 0.00181,334.280.00714 PARENTAL LEAVE FUND 32,486.14 19,123.56 7,235.78 50.60 0.00 0.00 44,424.52 0.0044,424.520.00Total Internal Service Funds19,716,566.434,715,334.203,882,333.7332,355.820.00 0.00 20,581,922.720.0020,581,922.720.00Trust & Agency Funds701 FIREFIGHTERS PENSION 335,712.10 0.00 359,411.99 1,164.58 0.00 0.00(22,535.31)0.00(22,535.31)0.00702 POLICE PENSION 696,510.51 504.44 513,423.43 1,971.49 0.00 0.00 185,563.01 0.00185,563.010.00709 PAYROLL FUND 0.00 9,749,824.01 9,749,592.98 0.00 0.00 0.00 231.03 0.00231.030.00718 STATE TAX DEDUCTION FUND 335,621.39 292,691.50 335,621.39 0.00 0.00 0.00 292,691.50 0.00292,691.500.00725 MORRIS / PALAIS BOX OFFICE 3,065,971.72 0.00 125,472.45 0.00 0.00 0.00 2,940,499.27 0.002,940,499.270.00726 POLICE DISTRIBUTIONS PAYABLE 857,177.58 0.00 0.00 0.00 0.00 0.00 857,177.58 0.00857,177.580.00730 CITY CEMETERY TRUST 29,660.54 11,856.48 11,856.48 49.30 0.00 0.00 29,709.84 0.0029,709.840.00731 BOWMAN CEMETERY 466,595.52 186,516.59 186,516.59 775.73 0.00 0.00 467,371.25 0.00467,371.250.00Total Trust & Agency Funds5,787,249.3610,241,393.0211,281,895.31 3,961.100.00 0.00 4,750,708.170.004,750,708.170.00Total City Funds226,674,982.7029,464,541.41 33,742,243.00333,374.585,995,563.782,188,828.28226,537,391.1970,828.53226,608,219.722,488,902.442020-01 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: January 2020Redevelopment Commission Controlled FundsTax Increment Financing Funds324 TIF RIVER WEST 30,879,977.31 0.00 3,203,736.01 45,938.69 4,737.11 1,934,110.50 25,792,806.60 0.0025,792,806.60(100,000.00)422 TIF DISTRICT - WEST WASHINGTON 1,029,402.39 300.00 0.00 1,757.26 0.00 0.00 1,031,459.65 0.001,031,459.650.00429 TIF RIVER EAST DEV (NE) 8,196,148.94 0.00 516,748.50 12,987.97 0.00 0.00 7,692,388.41 0.007,692,388.410.00430 TIF SOUTHSIDE DEVELOPMENT AREA #1 9,585,265.16 0.00 30,337.40 15,179.03 0.00 0.00 9,570,106.79 0.009,570,106.790.00435 TIF DOUGLAS ROAD 187,365.96 0.00 14,050.00 324.24 0.00 0.00 173,640.20 0.00173,640.200.00436 TIF RIVER EAST RES (NE RE) 3,698,203.06 0.00 0.00 4,255.94 0.00 1,885,125.00 1,817,334.00 0.001,817,334.00(2,388,902.44)Total Tax Increment Financing Funds53,576,362.82300.00 3,764,871.91 80,443.134,737.11 3,819,235.5046,077,735.650.0046,077,735.65(2,488,902.44)Redevelopment Funds433 REDEVELOPMENT ADMINISTRATION GENERAL 1,473,450.98 731.25 41,850.13 2,527.99 12,500.00 0.00 1,447,360.09 0.001,447,360.090.00439 CERTIFIED TECHNOLOGY PARK 10,939.14 0.00 0.00 18.59 0.00 0.00 10,957.73 0.0010,957.730.00452 2018 TIF PARK BOND CAPITAL 4,076,089.72 0.00 28,483.52 7,248.70 0.00 0.00 4,054,854.90 0.004,054,854.900.00454 AIRPORT URBAN ENTERPRISE ZONE 402,803.07 0.00 0.00 685.51 0.00 0.00 403,488.58 0.00403,488.580.00Total Redevelopment Funds5,963,282.91 731.25 70,333.6510,480.7912,500.000.00 5,916,661.300.005,916,661.300.00Debt Service Funds 315 AIRPORT 2003 DEBT RESERVE 1,040,462.24 0.00 0.00 1,772.97 0.00 1,772.97 1,040,462.24 0.001,040,462.240.00328 SBCDA 2003 DEBT RESERVE 1,739,494.86 0.00 0.00 2,964.14 0.00 2,964.14 1,739,494.86 0.001,739,494.860.00351 2018 TIF PARK BOND DEBT SERVICE RESERVE 1,016,593.95 0.00 0.00 1,730.10 0.00 0.00 1,018,324.05 0.001,018,324.050.00352 SOUTH SHORE DOUBLE TRACKING BONDS 29,818.51 0.00 0.00 2.07 0.00 0.00 29,820.58 0.0029,820.580.00Total Debt Service Funds3,826,369.560.00 0.00 6,469.280.00 4,737.11 3,828,101.730.003,828,101.730.00Total Redevelopment Commission Funds63,366,015.29 1,031.25 3,835,205.56 97,393.20 17,237.11 3,823,972.61 55,822,498.68 0.00 55,822,498.68(2,488,902.44)City Operations Total290,040,997.9929,465,572.6637,577,448.56430,767.786,012,800.896,012,800.89282,359,889.8770,828.53282,430,718.400.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,621,290.18234,639.470.00 43,521.490.00 323,645.64185,575,805.50185,575,805.502020-01 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 2,513,952 885,871 1,628,081 4,006,377 (2,378,296) 10% Building back up reserves after capital spend in 201925% of Annual expenditures221 Landlord Registration 27,413 2,722 24,691 34,583 (9,892) 7% Slightly under reserve requirement10% of Annual expenditures230 Code Enforcement 52,400 100,892 (48,492) - (48,492) -1% Fund created in 2020, still establishing reserves10% of Annual expenditures278 Take Home Vehicle Police 725,104 - 725,104 750,000 (24,896) 1450% Slightly under reserve requirementSet dollar amount of $750,000610 Solid Waste Operations 344,007 1,056,636 (712,629) 609,152 (1,321,781) -12% Expenditures higher than revenues10% of Annual expenditures667 Storm Sewer Fund 193,566 25,094 168,472 217,933 (49,461) 19% Fund created in 2019, still establishing reserves25% of Annual expenditures701 Firefighters Pension (22,535) - (22,535) 479,931 (502,466) 0% Pension payments received in June & Sept10% of Annual expenditures702 Police Pension 185,563 - 185,563 624,141 (438,578) 3% Pension payments received in June & Sept10% of Annual expenditures4,019,471 2,071,215 1,948,255 6,722,117 (4,773,862) Meets or Exceeds Requirement101 General Fund 41,541,008 1,295,820 40,245,188 25,275,207 14,969,981 56% Property tax distribution received in June & Dec35% of Annual expenditures102 Rainy Day Fund 10,726,524 - 10,726,524 8,811,060 1,915,464 4%3% of total expenditures in previous fiscal year, excluding one-time capital expenditures202 Motor Vehicle Highway 4,478,160 690,606 3,787,554 2,310,044 1,477,510 41%25% of Annual expenditures211 DCI Administration Fund 992,806 284,404 708,402 350,068 358,334 20%10% of Annual expenditures216 Police State Seizures 238,169 - 238,169 19,250 218,919 309%25% of Annual expenditures218 Police Curfew Violations 12,886 - 12,886 250 12,636 1289%25% of Annual expenditures220 Law Enforce. Continuing Education 413,721 14,698 399,023 98,844 300,179 101%25% of Annual expenditures222 Central Services 1,523,206 25,064 1,498,142 845,763 652,379 18%10% of Annual expenditures, excluding utility accounting226 Liability Insurance 6,082,631 292,931 5,789,700 2,134,077 3,655,623 136%50% of Annual expenditures249 Public Safety L.O.I.T. 3,298,594 - 3,298,594 716,044 2,582,550 37% 8% of Annual expenditures - one month reserve273 Morris PAC/Palais Royale Marketing 73,491 10,816 62,675 7,704 54,971 203%25% of Annual expenditures274 Morris PAC/Self-Promotion 197,275 - 197,275 28,750 168,525 172%25% of Annual expenditures288 EMS Operating 2,461,629 40,125 2,421,504 456,015 1,965,489 133%25% of Annual expenditures289 HAZMAT 27,629 - 27,629 2,500 25,129 276%25% of Annual expenditures291 Indiana River Rescue 305,688 6,111 299,576 23,771 275,805 315%25% of Annual expenditures294 Regional Police Academy 123,255 - 123,255 5,625 117,630 548%25% of Annual expenditures299 Police Federal Drug Enforcement 113,717 - 113,717 12,750 100,967 223%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 covenants351 2018 TIF Park Bond Debt Svc Reserve 1,018,324 - 1,018,324 1,018,324 - 100% 100% debt service reserve per bond covenants352 South Shore Double Tracking Debt Service29,821 - 29,821 - 29,821 100%No reserve requirement404 County Option Income Tax 12,045,555 3,461,282 8,584,273 8,094,122 490,151 53%50% of Annual expenditures408 Economic Development Income Tax 17,801,576 2,727,336 15,074,240 7,927,850 7,146,390 95%50% of Annual expenditures433 Redev Administration General 1,447,360 347,786 1,099,574 354,784 744,790 77%25% of Annual expenditures600 Consolidated Building Department 2,228,801 264,968 1,963,834 501,357 1,462,477 98%25% of Annual expenditures601 Parking Garages 1,020,134 217,244 802,890 414,889 388,001 48%25% of Annual expenditures620 Water Works Operations 4,116,207 1,368,334 2,747,874 1,169,837 1,578,037 12%5% of Annual expenditures624 Water Works Customer Deposit 1,284,535 - 1,284,535 1,284,535 - 100%100% cash reserves for customer deposits625 Water Works Sinking Fund 386,960 - 386,960 386,960 - 100%100% cash reserves per bond covenants626 Water Works Bond Reserve 1,427,124 - 1,427,124 1,427,124 - 100%100% cash reserves per bond covenants629 Water Works Reserve - O & M 2,912,652 - 2,912,652 2,907,791 4,861 17%16.67% of annual operating expenses in Fund 620, net of transfers640 Sewer Repair Insurance 2,156,220 350,594 1,805,626 185,589 1,620,037 243%25% of Annual expenditures641 Sewage Works Operations 16,664,460 4,437,843 12,226,617 2,385,805 9,840,812 26%5% of Annual expenditures643 Sewage Works Reserve - O & M 5,550,801 - 5,550,801 5,323,399 227,402 17% 16.67% of annual operating expenses in Fund 641, net of transfers649 Sewage Works Bond Sinking 1,085,937 - 1,085,937 1,085,937 - 100%100% cash reserves per bond covenants653 Sewage Works Debt Service Reserve 4,297,255 - 4,297,255 4,297,255 - 100%100% cash reserves per bond covenants654 Sewage Works Deposit Fund 433,916 - 433,916 433,916 - 100%100% cash reserves for customer deposits655 Project Releaf 407,573 - 407,573 108,365 299,208 94%25% of Annual expenditures670 Century Center 2,131,169 32,885 2,098,284 1,258,975 839,309 42%25% of Annual expenditures671 Century Center Capital 982,513 - 982,513 800,000 182,513 4913%$800,000 Minimum per Board of Managers711 Self-Funded Employee Benefits 9,060,895 1,065,206 7,995,689 4,627,133 3,368,556 43%25% of Annual expenditures713 Unemployment Comp Fund 181,334 - 181,334 13,750 167,584 330%25% of Annual expenditures714 Parental Leave Fund 44,425 - 44,425 20,308 24,117 18%8% of Annual expenditures - one month reserve718 State Tax Withholding Fund 292,692 - 292,692 292,692 - 100%100% cash reserves - trust & agency funds725 Morris / Palais Box Office 2,940,499 - 2,940,499 2,940,499 - 100%100% cash reserves - trust & agency funds726 Police Distributions Payable 857,178 - 857,178 857,178 - 100%100% cash reserves - trust & agency funds730 City Cemetery Trust 29,710 - 29,710 5,000 24,710 149%25% of Annual expendituresJanuary 31, 20202020-01 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 PolicyJanuary 31, 2020731 Bowman Cemetery 467,371 - 467,371 400,000 67,371 100%$400,000 minimum752 South Bend Redevelopment Authority 1,459,867 - 1,459,867 1,459,867 - 100%100% cash reserves per bond covenants755 South Bend Building Corporation 2,134,986 - 2,134,986 2,134,986 - 100%100% cash reserves per bond covenants756 Smart Streets Debt Service Fund 2,593,122 - 2,593,122 2,593,122 - 100%100% cash reserves per bond covenants757 2015 Parks Bond Debt Service 622,047 - 622,047 622,047 - 100%100% cash reserves per bond covenants760 Eddy St Commons Bond Debt Service 4,110,266 - 4,110,266 2,500,000 1,610,266 295%$2,500,000 minimum179,613,629 16,934,052 162,679,579 103,711,075 58,968,504 No Reserve Requirement209 Studebaker/Oliver Revitalizing Grants 905,784 825,435 80,349 - 80,349 100%No reserve requirement - Grant fund - spend down to zero210 DCI State Grants 78,021 58,581 19,440 - 19,440 100% To be reimbursed by grant receiptsNo reserve requirement - Grant fund - spend down to zero212 DCI Federal Grants 331,858 2,150,154 (1,818,296) - (1,818,296) 100% To be reimbursed by grant receiptsNo reserve requirement - Grant fund - spend down to zero217 Gift, Donation, Bequest 797,143 332,457 464,686 - 464,686 100%No reserve requirement219 Unsafe Building 908,191 38,943 869,248 - 869,248 100%No reserve requirement224 Central Services Capital(29,849) 61,869 (91,718) - (91,718) 100% To receive interfund transfer from Fund 222No reserve requirement - Capital fund - spend down to zero227 Loss Recovery Fund 605,079 200,000 405,079 - 405,079 100%No reserve requirement251 Local Roads & Streets 5,365,237 2,769,718 2,595,518 - 2,595,518 100%25% of Annual expenditures257 LOIT 2016 Special Distribution 138,293 131,749 6,544 - 6,544 100%No reserve requirement258 Human Rights - Federal Grant 507,188 28,091 479,097 - 479,097 100%No reserve requirement - Grant fund - spend down to zero265 Local Road & Bridge Grant 368,786 893,987 (525,201) - (525,201) 100%No reserve requirement - Grant fund - spend down to zero266 MVH Restricted 883,266 16,675 866,591 - 866,591 100%New fund - reserve requirement to be determined279 IT / Innovation / 311 Call Center 2,994,176 2,675,340 318,836 - 318,836 100% Reimbursed through interfund allocationNo reserve requirement280 Police Block Grants 4,092 - 4,092 - 4,092 100%No reserve requirement - Grant fund - spend down to zero287 EMS Capital 1,555,023 1,430,408 124,615 - 124,615 100%No reserve requirement - Capital fund - spend down to zero292 Police Grants 26,716 - 26,716 - 26,716 100%No reserve requirement295 COPS MORE Grant 70,556 14,154 56,402 - 56,402 100%No reserve requirement312 2017 Parks Bond Debt Service(368,582) - (368,582) - (368,582) 100% Property tax distribution received in June & DecNo reserve requirement324 TIF - River West TIF (Airport) 25,792,807 6,668,441 19,124,365 - 19,124,365 100% Property tax distribution received in June & DecNo reserve requirement350 2018 Fire Station #9 Debt Service - - - - - 100% Receives transfers from Fund 287 for debt svc pmtsNo reserve requirement401 Coveleski Stadium Capital 25,836 - 25,836 - 25,836 100%No reserve requirement - Capital fund - spend down to zero406 Cumulative Capital Development 140,679 14,389 126,291 - 126,291 100% Property tax distribution received in June & DecNo reserve requirement - Capital fund - spend down to zero407 Cumulative Capital Improvement 667,530 - 667,530 - 667,530 100%No reserve requirement - Capital fund - spend down to zero410 Urban Develop Action Grant (UDAG) 49,015 - 49,015 - 49,015 100%No reserve requirement - Grant fund - spend down to zero412 Major Moves Construction 2,182,623 315,412 1,867,211 - 1,867,211 100%No reserve requirement - Capital fund - spend down to zero416 Morris Performing Arts Center Capital 351,128 344,387 6,741 - 6,741 100%No reserve requirement422 TIF - West Washington 1,031,460 342,165 689,295 - 689,295 100% Property tax distribution received in June & DecNo reserve requirement429 TIF - River East Devevelopment 7,692,388 4,263,529 3,428,859 - 3,428,859 100% Property tax distribution received in June & DecNo reserve requirement430 TIF - Southside Development Area #1 9,570,107 204,614 9,365,493 - 9,365,493 100% Property tax distribution received in June & DecNo reserve requirement435 TIF - Douglas Road 173,640 73,175 100,465 - 100,465 100% Property tax distribution received in June & DecNo reserve requirement436 TIF - River East Residential 1,817,334 - 1,817,334 - 1,817,334 100% Property tax distribution received in June & DecNo reserve requirement439 Certified Technology Park 10,958 752 10,206 - 10,206 100%No reserve requirement450 Palais Royale Historic Preservation 75,396 - 75,396 - 75,396 100%No reserve requirement451 2018 Fire Station #9 Capital 399,619 89,311 310,307 - 310,307 100%No reserve requirement - Bond capital fund - spend down to zero452 2018 TIF Park Bond Capital 4,054,855 1,129,990 2,924,865 - 2,924,865 100%No reserve requirement - Bond capital fund - spend down to zero453 2018 Zoo Bond Capital 121,023 - 121,023 - 121,023 100%No reserve requirement - Bond capital fund - spend down to zero454 Airport Urban Enterprise Zone 403,489 - 403,489 - 403,489 100%No reserve requirement471 2017 Parks Bond Capital 8,948,084 1,355,567 7,592,517 - 7,592,517 100%No reserve requirement - Bond capital fund - spend down to zero611 Solid Waste Capital 64,832 94,000 (29,168) - (29,168) 100% Receives transfers from Fund 610 as neededNo reserve requirement - Capital fund - spend down to zero622 Water Works Capital 4,638,375 647,143 3,991,233 - 3,991,233 100%No reserve requirement - Capital fund - spend down to zero642 Sewage Works Capital 9,441,824 5,703,030 3,738,794 - 3,738,794 100% Receives transfers from Fund 641 as neededNo reserve requirement - Capital fund - spend down to zero672 Century Center Energy Savings 410,766 - 410,766 - 410,766 100%No reserve requirement705 Police K-9 Unit 2,394 - 2,394 - 2,394 100%No reserve requirement709 Payroll Fund 231 - 231 - 231 100%No reserve requirement - clearing fund750 Equipment/Vehicle Leasing 678,946 - 678,946 - 678,946 100% No reserve requirement - Capital lease fund - spend down to zero754 Industrial Revolving Fund 2,078,333 - 2,078,333 - 2,078,333 100%No City reserve requirement; there are program requirements759 Eddy Street Commons Bond Capital 2,832,969 - 2,832,969 - 2,832,969 100%No reserve requirement - Bond capital fund - spend down to zero98,797,619 32,873,467 65,924,152 - 65,924,152 City Operations Total 282,430,718 51,878,735 230,551,986 110,433,192 120,118,794 Note: Available Cash is a Fund's cash balance minus any outstanding encumbrances2020-01 Monthly Cash Report7 January 1, 2007 - January 31, 2020 $329,782,565 6/30/2018 $122,056,198 5/31/2007 $218,634,891 -- $287,609,008 -- 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 2020-01 Monthly Cash Report 8 January 1, 2007 - January 31, 2020 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 10/31/19 280,029,157.59 71,823,087.19 54,434,324.03 153,771,746.37 12/31/15 228,782,505.24 64,215,673.59 61,194,710.47 103,372,121.18 11/30/19 258,487,347.42 63,466,347.56 53,127,541.62 141,893,458.24 01/31/16 217,346,607.43 65,062,377.54 55,690,681.11 96,593,548.78 12/31/19 290,040,997.99 63,959,687.87 63,366,015.29 162,715,294.83 02/29/16 213,873,714.80 67,564,110.56 53,548,676.30 92,760,927.94 01/31/20 282,430,718.40 65,788,707.02 55,822,498.68 160,819,512.70 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 2020-01 Monthly Cash Report 9 $83,296,822 1/31/2013 $28,657,187 1/1/2007 $58,937,314 -- $66,256,649 -- Date Cash Date Cash Date Cash 01/01/07 28,657,187.47 08/31/11 45,688,053.72 04/30/16 69,616,174.97 01/31/07 30,058,091.08 09/30/11 46,330,287.44 05/31/16 69,399,868.04 02/28/07 30,099,578.04 10/31/11 67,040,484.39 06/30/16 68,720,691.90 03/31/07 30,984,947.93 11/30/11 61,691,017.04 07/31/16 69,227,392.30 04/30/07 29,218,887.63 12/31/11 58,173,399.01 08/31/16 67,673,880.42 05/31/07 32,424,086.65 01/31/12 59,207,692.55 09/30/16 69,398,336.63 06/30/07 48,699,567.31 02/29/12 59,272,665.18 10/31/16 68,809,369.21 07/31/07 48,096,309.22 03/31/12 59,768,182.49 11/30/16 61,451,803.84 08/31/07 47,662,427.04 04/30/12 60,202,795.65 12/31/16 58,486,210.11 09/30/07 45,360,303.16 05/31/12 59,123,171.41 01/31/17 58,517,537.99 10/31/07 46,717,357.10 06/30/12 67,140,754.63 02/28/17 60,687,347.41 11/30/07 41,716,114.28 07/31/12 67,955,663.74 03/31/17 62,502,426.31 12/31/07 55,204,053.77 08/31/12 67,464,201.30 04/30/17 63,062,862.44 01/31/08 56,114,335.03 09/30/12 65,732,654.52 05/31/17 62,923,609.40 02/29/08 54,575,012.50 10/31/12 66,270,486.67 06/30/17 62,218,464.08 03/31/08 54,575,272.95 11/30/12 59,658,568.60 07/31/17 63,518,960.13 04/30/08 54,929,047.02 12/31/12 82,506,887.41 08/31/17 64,818,240.75 05/31/08 53,052,472.03 01/31/13 83,296,821.86 09/30/17 66,236,471.94 06/30/08 53,204,418.10 02/28/13 82,484,393.54 10/31/17 66,667,885.35 07/31/08 54,533,563.28 03/31/13 82,950,715.18 11/30/17 59,754,036.10 08/31/08 54,251,216.99 04/30/13 80,568,512.43 12/31/17 57,620,088.62 09/30/08 53,272,451.68 05/31/13 79,672,318.05 01/31/18 59,858,871.62 10/31/08 68,706,036.43 06/30/13 79,520,360.08 02/28/18 58,423,954.94 11/30/08 54,077,562.73 07/31/13 79,867,774.82 03/31/18 60,255,912.54 12/31/08 44,639,804.67 08/31/13 79,782,901.50 04/30/18 61,537,542.97 01/31/09 45,793,529.09 09/30/13 79,940,103.15 05/31/18 62,676,079.74 02/28/09 46,941,062.25 10/31/13 79,663,547.72 06/30/18 62,779,584.12 03/31/09 47,265,006.09 11/30/13 72,524,668.50 07/31/18 64,079,751.06 04/30/09 48,061,985.20 12/31/13 67,716,137.82 08/31/18 65,896,576.77 05/31/09 46,623,111.00 01/31/14 66,889,990.77 09/30/18 67,628,081.52 06/30/09 46,662,615.02 02/28/14 67,566,543.96 10/31/18 70,191,910.88 07/31/09 45,609,990.75 03/31/14 68,633,684.73 11/30/18 62,080,096.93 08/31/09 44,700,623.82 04/30/14 68,960,383.93 12/31/18 63,399,519.22 09/30/09 44,771,129.93 05/31/14 67,425,749.33 01/31/19 61,984,035.31 10/31/09 44,855,908.07 06/30/14 67,697,981.00 02/28/19 62,312,317.89 11/30/09 44,458,186.54 07/31/14 68,611,865.99 03/31/19 65,067,673.27 12/31/09 36,891,179.40 08/31/14 68,747,483.87 04/30/19 65,875,626.86 01/31/10 37,726,300.40 09/30/14 69,430,344.98 05/31/19 65,258,811.69 02/28/10 36,982,623.93 10/31/14 70,431,027.92 06/30/19 65,359,551.38 03/31/10 41,475,717.35 11/30/14 64,909,392.12 07/31/19 67,151,539.38 04/30/10 40,478,357.60 12/31/14 61,623,499.90 08/31/19 68,160,947.96 05/31/10 38,739,522.56 01/31/15 61,585,040.94 09/30/19 70,855,493.40 06/30/10 39,738,881.62 02/28/15 63,269,776.69 10/31/19 71,823,087.19 07/31/10 42,020,069.17 03/31/15 64,288,370.38 11/30/19 63,466,347.56 08/31/10 40,331,826.60 04/30/15 65,430,174.18 12/31/19 63,959,687.87 09/30/10 40,245,656.32 05/31/15 65,714,228.05 01/31/20 65,788,707.02 10/31/10 39,984,803.80 06/30/15 68,746,632.56 11/30/10 35,695,100.47 07/31/15 70,884,051.33 12/31/10 41,300,042.16 08/31/15 72,023,119.13 01/31/11 42,918,366.28 09/30/15 75,617,268.98 02/28/11 44,793,554.36 10/31/15 77,155,814.42 03/31/11 46,555,428.08 11/30/15 75,987,100.36 04/30/11 46,284,639.10 12/31/15 64,215,673.59 05/31/11 45,692,919.82 01/31/16 65,062,377.54 06/30/11 46,029,921.56 02/29/16 67,564,110.56 07/31/11 45,556,018.39 03/31/16 69,211,164.87 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 - January 31, 2020 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 2020-01 Monthly Cash Report 10 $81,992,643 6/30/2018 $26,731,149 1/31/2009 $50,304,765 -- $58,375,388 -- Date Cash Date Cash Date Cash 01/01/07 40,101,775.51 08/31/11 49,085,008.00 04/30/16 51,317,725.09 01/31/07 37,204,941.29 09/30/11 47,073,543.39 05/31/16 50,296,085.76 02/28/07 42,400,991.27 10/31/11 44,750,523.17 06/30/16 64,433,239.06 03/31/07 36,322,464.80 11/30/11 41,844,406.42 07/31/16 58,518,600.58 04/30/07 36,374,308.24 12/31/11 51,201,636.39 08/31/16 55,966,718.35 05/31/07 36,579,224.31 01/31/12 44,464,972.65 09/30/16 55,065,472.04 06/30/07 35,914,061.41 02/29/12 43,124,396.97 10/31/16 52,059,580.89 07/31/07 33,046,039.94 03/31/12 40,875,506.16 11/30/16 51,222,578.99 08/31/07 31,416,991.60 04/30/12 39,972,677.94 12/31/16 60,406,691.98 09/30/07 30,955,278.22 05/31/12 37,283,464.71 01/31/17 54,709,591.50 10/31/07 29,953,285.20 06/30/12 48,308,618.33 02/28/17 60,693,512.64 11/30/07 29,049,190.99 07/31/12 43,597,429.86 03/31/17 54,200,785.07 12/31/07 43,118,912.28 08/31/12 41,355,817.62 04/30/17 53,618,489.08 01/31/08 41,405,052.40 09/30/12 40,654,565.67 05/31/17 50,870,962.23 02/29/08 40,635,068.99 10/31/12 38,605,222.83 06/30/17 64,818,554.92 03/31/08 40,558,124.18 11/30/12 37,090,958.24 07/31/17 59,955,849.53 04/30/08 40,290,091.29 12/31/12 47,393,846.15 08/31/17 60,726,084.24 05/31/08 40,210,711.69 01/31/13 45,144,294.34 09/30/17 57,532,562.70 06/30/08 39,857,987.53 02/28/13 41,364,435.41 10/31/17 55,546,746.25 07/31/08 39,145,712.40 03/31/13 41,430,811.51 11/30/17 55,251,426.66 08/31/08 36,074,455.00 04/30/13 42,438,979.52 12/31/17 65,818,514.83 09/30/08 35,928,266.53 05/31/13 42,077,874.12 01/31/18 60,435,599.30 10/31/08 34,674,631.21 06/30/13 55,157,971.58 02/28/18 58,919,560.09 11/30/08 33,382,904.90 07/31/13 51,147,079.40 03/31/18 56,967,800.25 12/31/08 28,608,922.65 08/31/13 48,231,381.91 04/30/18 70,308,595.71 01/31/09 26,731,148.85 09/30/13 47,344,717.04 05/31/18 69,433,440.38 02/28/09 28,199,966.51 10/31/13 45,849,747.51 06/30/18 81,992,642.55 03/31/09 27,482,787.81 11/30/13 45,831,055.40 07/31/18 78,753,842.27 04/30/09 38,905,572.01 12/31/13 55,315,510.06 08/31/18 73,401,834.82 05/31/09 38,656,758.39 01/31/14 50,898,242.66 09/30/18 70,934,670.78 06/30/09 36,003,705.47 02/28/14 49,986,290.38 10/31/18 58,183,703.49 07/31/09 39,288,192.08 03/31/14 49,028,261.04 11/30/18 57,701,465.11 08/31/09 38,981,480.90 04/30/14 47,281,387.13 12/31/18 66,695,748.11 09/30/09 38,365,267.66 05/31/14 46,795,213.96 01/31/19 59,597,388.81 10/31/09 36,749,933.72 06/30/14 61,118,881.00 02/28/19 60,283,680.41 11/30/09 35,847,660.55 07/31/14 56,842,280.86 03/31/19 57,633,297.22 12/31/09 34,358,243.89 08/31/14 55,735,447.17 04/30/19 55,133,997.10 01/31/10 53,534,937.83 09/30/14 54,889,194.46 05/31/19 53,673,044.13 02/28/10 52,816,628.95 10/31/14 54,196,891.83 06/30/19 68,360,737.05 03/31/10 52,577,148.25 11/30/14 54,554,819.33 07/31/19 61,596,350.52 04/30/10 51,768,568.42 12/31/14 65,903,128.76 08/31/19 60,712,190.84 05/31/10 50,881,687.36 01/31/15 60,387,162.56 09/30/19 56,360,982.88 06/30/10 62,539,377.78 02/28/15 58,990,110.88 10/31/19 54,434,324.03 07/31/10 55,401,804.58 03/31/15 58,654,868.03 11/30/19 53,127,541.62 08/31/10 53,423,401.23 04/30/15 57,972,838.77 12/31/19 63,366,015.29 09/30/10 52,832,007.68 05/31/15 57,630,884.95 01/31/20 55,822,498.68 10/31/10 51,745,774.22 06/30/15 70,642,566.10 11/30/10 49,573,730.89 07/31/15 65,048,413.67 12/31/10 65,164,721.07 08/31/15 61,042,169.83 01/31/11 57,392,911.65 09/30/15 59,936,471.64 02/28/11 53,822,791.88 10/31/15 56,339,743.69 03/31/11 52,439,712.97 11/30/15 54,715,027.81 04/30/11 51,775,206.12 12/31/15 61,194,710.47 05/31/11 45,543,075.85 01/31/16 55,690,681.11 06/30/11 57,605,720.29 02/29/16 53,548,676.30 07/31/11 51,845,520.23 03/31/16 53,434,486.66 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 - January 31, 2020 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 2020-01 Monthly Cash Report 11 $185,010,338 6/30/2018 $53,052,887 5/31/2007 $109,512,799 -- $160,695,198 -- Date Cash Date Cash Date Cash 01/01/07 85,175,579.60 08/31/11 113,258,535.54 04/30/16 86,653,485.20 01/31/07 73,488,712.70 09/30/11 110,396,745.77 05/31/16 86,834,652.02 02/28/07 62,279,572.21 10/31/11 106,268,532.08 06/30/16 116,591,466.93 03/31/07 63,387,712.08 11/30/11 103,722,320.22 07/31/16 121,999,405.01 04/30/07 57,999,328.33 12/31/11 122,382,409.35 08/31/16 105,828,873.80 05/31/07 53,052,886.63 01/31/12 112,856,049.10 09/30/16 106,788,928.77 06/30/07 69,141,886.09 02/29/12 108,263,714.86 10/31/16 103,888,093.70 07/31/07 55,973,444.69 03/31/12 104,341,336.06 11/30/16 98,003,054.46 08/31/07 56,738,574.39 04/30/12 102,221,194.49 12/31/16 115,636,423.15 09/30/07 54,332,089.62 05/31/12 98,400,589.02 01/31/17 123,978,793.66 10/31/07 62,335,616.12 06/30/12 129,269,506.53 02/28/17 121,509,295.84 11/30/07 78,241,163.17 07/31/12 118,715,231.38 03/31/17 116,554,975.66 12/31/07 92,992,407.68 08/31/12 114,706,440.90 04/30/17 110,930,193.42 01/31/08 80,935,072.49 09/30/12 116,874,708.78 05/31/17 108,877,270.93 02/29/08 79,815,076.58 10/31/12 109,940,198.76 06/30/17 137,292,433.56 03/31/08 75,755,584.16 11/30/12 107,094,590.01 07/31/17 130,725,920.08 04/30/08 70,171,420.22 12/31/12 125,384,469.62 08/31/17 126,515,209.12 05/31/08 63,701,375.82 01/31/13 119,412,780.36 09/30/17 153,866,546.50 06/30/08 74,301,370.46 02/28/13 113,373,764.76 10/31/17 147,133,964.65 07/31/08 77,357,385.95 03/31/13 107,698,520.03 11/30/17 143,554,756.24 08/31/08 73,612,781.45 04/30/13 103,435,158.90 12/31/17 167,851,319.70 09/30/08 70,870,856.93 05/31/13 98,352,454.84 01/31/18 162,491,472.74 10/31/08 61,421,121.17 06/30/13 125,169,937.15 02/28/18 158,812,440.01 11/30/08 60,929,733.44 07/31/13 121,430,845.57 03/31/18 157,559,868.19 12/31/08 67,373,134.56 08/31/13 114,023,924.90 04/30/18 148,410,420.86 01/31/09 56,557,371.00 09/30/13 115,040,485.48 05/31/18 148,710,961.31 02/28/09 61,446,169.16 10/31/13 109,822,423.95 06/30/18 185,010,338.05 03/31/09 75,602,332.02 11/30/13 104,254,613.29 07/31/18 174,174,636.01 04/30/09 69,388,217.66 12/31/13 124,318,129.42 08/31/18 169,092,973.62 05/31/09 68,735,769.04 01/31/14 114,256,166.29 09/30/18 167,461,074.68 06/30/09 62,589,041.72 02/28/14 109,603,281.18 10/31/18 168,975,135.70 07/31/09 66,130,768.09 03/31/14 104,384,382.05 11/30/18 162,330,274.67 08/31/09 71,071,962.93 04/30/14 98,541,834.35 12/31/18 179,716,517.72 09/30/09 70,242,756.18 05/31/14 95,103,846.00 01/31/19 171,206,079.23 10/31/09 68,758,254.71 06/30/14 122,883,782.00 02/28/19 167,558,852.67 11/30/09 63,704,336.96 07/31/14 113,327,256.18 03/31/19 159,549,535.86 12/31/09 117,203,577.74 08/31/14 109,603,756.37 04/30/19 155,780,499.49 01/31/10 104,838,291.70 09/30/14 109,275,831.00 05/31/19 148,297,131.48 02/28/10 104,864,103.11 10/31/14 101,285,566.72 06/30/19 179,976,642.47 03/31/10 103,854,789.67 11/30/14 97,119,208.93 07/31/19 169,098,059.79 04/30/10 98,183,077.33 12/31/14 112,281,466.37 08/31/19 166,065,012.41 05/31/10 111,608,210.69 01/31/15 103,499,061.06 09/30/19 162,816,628.89 06/30/10 128,279,716.19 02/28/15 99,594,218.25 10/31/19 153,771,746.37 07/31/10 119,642,649.15 03/31/15 92,334,813.71 11/30/19 141,893,458.24 08/31/10 116,632,252.40 04/30/15 89,927,304.71 12/31/19 162,715,294.83 09/30/10 118,416,709.45 05/31/15 86,034,381.75 01/31/20 160,819,512.70 10/31/10 112,912,072.36 06/30/15 110,214,298.75 11/30/10 113,513,586.86 07/31/15 100,449,392.01 12/31/10 121,274,488.95 08/31/15 95,418,067.35 01/31/11 113,796,557.05 09/30/15 98,961,223.68 02/28/11 109,647,280.68 10/31/15 96,618,498.09 03/31/11 105,410,957.45 11/30/15 91,575,694.83 04/30/11 98,831,059.73 12/31/15 103,372,121.18 05/31/11 95,848,921.73 01/31/16 96,593,548.78 06/30/11 126,998,337.53 02/29/16 92,760,927.94 07/31/11 118,336,148.46 03/31/16 88,559,353.77 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 and capital lease proceeds significantly increased cash during 2017 ($43.4 million) and 2018 ($11,664,070). As these one time bond proceeds are spent, cash will decrease. City of South Bend Cash Balances - Civil City Funds January 1, 2007 - January 31, 2020 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 2020-01 Monthly Cash Report 12