HomeMy WebLinkAbout2019-07 Monthly Cash ReportPeriod Ending:
Issued by:
Contents
Narrative
Controller's Cash Report
Cash Reserves Summary by Fund Status
Cash Trends - All Funds
Cash Trends - Enterprise Funds
Cash Trends - Redevelopment Funds
Page Number(s)
2
3 - 5
6 - 7
8 - 9
10
11
12 Cash Trends - Civil City Funds
Distribution
Mayor Pete Buttigieg
Chief of Staff Laura O'Sullivan
Deputy Chief of Staff Genevieve Miller
Common Council
Department Heads
Fiscal Officers
July 31, 2019
Controller
City of South Bend
Monthly Cash Report
2019-07 Monthly Cash Report 1
Questions
If you should have additional questions, please contact the Department of Administration & Finance by calling 311.
Narrative
Fiscal Responsibility
The City’s management team is responsible for establishing and maintaining an internal control structure designed to ensure that the assets of the City are
protected from loss, theft, or misuse and to ensure that adequate accounting data is compiled to allow for the preparation of financial statements in conformity
with generally accepted accounting principles.
Controller's Cash Report (pages 3-5)
The Controller’s Cash Report is a monthly summary of cash and investment transactions within the current period by Fund. It summarizes the cash received,
interest earned, cash disbursed, and cash transferred between Funds within the City of South Bend as well as any loans between Funds. The report provides a
month-end view of the City’s cash balance in the reporting period.
Cash Reserves Summary (pages 6-8)
The purpose of the Cash Reserves Summary Report is keep track of whether the City's funds are meeting their cash reserve requirement. Cash reserve
requirements are set for each fund by the City of South Bend or other governing body (e.g. bond counsel, Century Center Board of Managers).
Cash Trends Summary (pages 9-13)
The purpose of the Cash Trends Summary is to track trends in cash balances for the City of South Bend over an extended period of time, from January 1, 2007
through the present date. Charts and graphs for the cash balances are provided in four areas--total cash, enterprise fund cash, redevelopment fund cash, and
civil city fund cash.
Cash Reserve Requirements
Cash reserve requirements are typically based on fund type.
- Most City funds are assigned a cash reserve requirement of a percentage of the fund's annual expenditures.
- The Rainy Day Fund 102 has a reserve requirement of 3% of the City's prior year operational expenditures, excluding one-time capital expenditures.
- Some funds have a set dollar amount as the reserve requirement, such as the Police Take Home Vehicle Fund 278 and the Century Center Capital Fund 671.
- Capital project funds, grant funds, and bond capital funds do not have reserve requirements as they are spent down to zero.
- The IT/Innovation/311 Call Center Fund 279 does not have a reserve requirement because it is an internal service fund, reimbursed by departments within
other City funds. Its budgeted revenues are equal to its budgeted expenditures.
- Debt service reserve funds are required to hold all reserves until the respective debt has been paid in full. The amount is often defined in bond covenants.
Pooled Cash
The City utilities pooled cash, the majority of the City's money being held in a single bank account. Although the money is in a single account, each fund retains
ownership of its own cash. Any interest earned on the bank account is distributed amongst the funds based on each funds' cash balance.
Trustee Cash
The City also has cash maintained by trustees or escrow agents at financial institutions and expended upon the provision by the City of a proper claim form and
invoice. These funds are typically for debt service payments, debt service reserves, or capital project expenditures.
Changes in Cash Balance
Property taxes are received in June and December of each year and this will cause the cash balances to fluctuate for total cash, redevelopment fund cash and
civil city fund cash. Enterprise fund cash balances will fluctuate based on the receipt of bond proceeds and the spending down of cash on capital projects.
Redevelopment fund cash accounts will vary based on capital spending on projects in tax increment financing (TIF) funds.
Negative Cash Balances
Due to the timing of revenue and expenditures, certain funds will not meet cash reserve requirements and may even have a negative cash balance at different
times throughout the year. Although a fund has a negative cash balance, the City does not have negative cash overall. Pooled cash can cover those funds so
necessary expenditures can be made even if revenues have not been received yet.
Fund 312, 350, 667, and 701 has a negative cash balance.
- The 2017 Parks Bond Debt Service Fund 312 receives property tax revenue in June and December, but still has to make a debt payments in January and
July. When property tax revenue is received in December, this fund won't be negative.
- The 2019 Fire Station 9 Bond Debt Service Fund 350 made a debt service payment in July. It will be reimbursed by the EMS Capital Fund 287 in August.
- The Firefighter's Pension Fund 701 hasn't received the second bi-annual reimbursement from the State, but still had to make payments to pensioners.
Reimbursement is received in June and September.
- The Storm Sewer Fund 667 was established in 2019, but did not start collecting user fees until June. Some stormwater projects have already started, owning
to the negative cash balance.
2019-07 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 $42,737,600.73 $1,539,550.59 $4,829,434.00 $53,317.92 $0.00 $0.00 $39,501,035.24 $0.00$39,501,035.24$0.00Special Revenue Funds102 RAINY DAY FUND 10,584,351.47 0.00 0.00 21,928.50 0.00 0.00 10,606,279.97 0.0010,606,279.970.00201 PARKS & RECREATION 9,098,271.10 478,931.17 4,010,995.03 10,384.49 0.00 0.00 5,576,591.73 0.005,576,591.730.00202 MOTOR VEHICLE HIGHWAY 5,983,429.75 295,996.42 925,391.84 12,186.59 0.00 0.00 5,366,220.92 0.005,366,220.920.00209 STUDEBAKER/OLIVER REVERTING GRANTS 867,968.28 0.00 31,058.44 1,798.63 0.00 0.00 838,708.47 0.00838,708.47200,000.00210 DEPT COMMUNITY INVESTMENT STATE GRANTS 92,931.37 16,831.78 4,881.75 1,405.14 0.00 0.00 106,286.54 0.00106,286.540.00211 DCI OPERATING FUND 675,050.73 13,032.87 216,700.25 500.72 0.00 0.00 471,884.07 0.00471,884.070.00212 DEPARTMENT OF COMMUNITY INVESTMENT 350,339.54 4,043.48 42,462.94 64.25 0.00 0.00 311,984.33 0.00311,984.330.00216 POLICE STATE SEIZURES 230,959.84 3,637.43 0.00 478.44 0.00 0.00 235,075.71 0.00235,075.710.00217 GIFT, DONATION, BEQUEST 662,907.99 746.22 96,013.44 991.34 0.00 0.00 568,632.11 73,993.34642,625.450.00218 POLICE CURFEW VIOLATIONS 13,283.82 0.00 0.00 27.51 0.00 0.00 13,311.33 0.0013,311.330.00219 UNSAFE BUILDING 718,024.29 25,725.15 55,859.25 1,187.97 0.00 0.00 689,078.16 0.00689,078.160.00220 LAW ENFORCEMENT CONTINUING EDUCATION 408,012.73 27,081.92 20,988.64 837.67 0.00 0.00 414,943.68 0.00414,943.680.00221 LANDLORD REGISTRATION 11,695.56 1,255.00 0.00 22.96 0.00 0.00 12,973.52 0.0012,973.520.00227 LOSS RECOVERY FUND 597,058.68 0.00 0.00 1,236.97 0.00 0.00 598,295.65 0.00598,295.650.00249 PUBLIC SAFETY L.O.I.T. 3,514,933.29 713,379.58 680,077.91 6,775.75 0.00 0.00 3,555,010.71 0.003,555,010.710.00251 LOCAL ROADS & STREETS 5,568,475.12 172,371.95 225,767.86 10,488.40 0.00 0.00 5,525,567.61 0.005,525,567.610.00257 LOIT 2016 SPECIAL DISTRIBUTION 433,093.87 0.00 51,442.60 921.73 0.00 0.00 382,573.00 0.00382,573.000.00258 HUMAN RIGHTS - FEDERAL GRANT 444,578.74 0.00 16,260.91 970.79 0.00 0.00 429,288.62 0.00429,288.620.00265 LOCAL ROAD & BRIDGE GRANT 333,149.94 0.00 0.00 690.21 0.00 0.00 333,840.15 0.00333,840.150.00266 MVH RESTRICTED 1,348,466.59 275,984.86 331,444.51 0.00 0.00 0.00 1,293,006.94 0.001,293,006.940.00273 MORRIS PAC/PALAIS ROYALE MARKETING 67,696.08 8.00 0.00 140.88 0.00 0.00 67,844.96 0.0067,844.960.00274 MORRIS PAC SELF-PROMOTION 150,922.30 0.00 0.00 310.71 0.00 0.00 151,233.01 0.00151,233.010.00280 POLICE BLOCK GRANTS 4,037.94 0.00 0.00 8.36 0.00 0.00 4,046.30 0.004,046.300.00289 HAZMAT 28,179.73 0.00 0.00 58.38 0.00 0.00 28,238.11 0.0028,238.110.00291 INDIANA RIVER RESCUE 263,302.40 9,100.00 4,524.26 547.79 0.00 0.00268,425.93 0.00268,425.930.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 114,284.21 0.00 853.15 236.73 0.00 0.00 113,667.79 0.00113,667.790.00295 COPS MORE GRANT 155,610.18 527.20 0.00 322.42 0.00 0.00 156,459.80 0.00156,459.800.00299 POLICE FEDERAL DRUG ENFORCEMENT 112,223.16 0.00 0.00 279.75 0.00 0.00 112,502.91 0.00112,502.910.00404 COUNTY OPTION INCOME TAX 12,960,408.63 1,042,817.83 1,015,828.50 27,942.22 0.00 0.00 13,015,340.18 0.0013,015,340.18450,253.20408 ECONOMIC DEVELOPMENT INCOME TAX 17,427,871.25 966,835.02 311,582.96 37,274.33 0.00 0.00 18,120,397.64 0.0018,120,397.640.00410 URBAN DEVELOPMENT ACTION GRANT (UDAG) 21,852.98 11,310.00 15,000.00 45.27 0.00 0.00 18,208.25 0.0018,208.25(450,253.20)655 PROJECT RELEAF 516,554.70 41,019.02 3,391.42 1,318.55 0.00 0.00 555,500.85 0.00555,500.850.00705 POLICE K-9 UNIT 2,361.96 0.00 0.00 4.89 0.00 0.00 2,366.85 0.002,366.850.00Total Special Revenue Funds73,789,003.72 4,100,634.90 8,060,525.66 141,388.34 0.00 0.00 69,970,501.30 73,993.3470,044,494.64200,000.00 Debt Service Fund312 2017 PARKS BOND DEBT SERVICE 229,675.36 0.00 597,757.50 0.00 0.000.00(368,082.14)0.00(368,082.14)0.00350 2018 FIRE ST #9 DEBT SERVICE 0.00 0.00 170,290.64 0.00 0.00 0.00(170,290.64)0.00(170,290.64)0.00755 SB BUILDING CORPORATION 684,974.81 0.00 0.00 1,135.04 0.00 0.00 686,109.85 0.00686,109.850.00757 2015 PARKS BOND DEBT SERVICE 560,041.33 31,612.10 0.00 358.91 0.00 0.00 592,012.34 0.00592,012.340.00760 EDDY ST. COMMONS DEBT SERVICE 3,457,175.14 0.00 0.00 880.86 0.00 0.00 3,458,056.00 0.003,458,056.000.00Capital Project Funds401 COVELESKI STADIUM CAPITAL 9,320.90 0.00 0.00 19.31 0.00 0.00 9,340.21 0.009,340.210.00406 CUMULATIVE CAPITAL DEVELOPMENT 553,620.71 0.00 110,683.02 726.10 0.00 0.00 443,663.79 0.00443,663.790.00407 CUMULATIVE CAPITAL IMPROVEMENT 564,453.67 0.00 0.00 1,038.44 0.000.00 565,492.11 0.00565,492.110.00412 MAJOR MOVES CONSTRUCTION 2,766,275.07 72,224.19 462,694.83 5,743.59 0.00 0.00 2,381,548.02 0.002,381,548.022,587,222.93416 MORRIS PERFORMING ARTS CENTER CAPITAL 409,928.49 0.00 11,850.00849.30 0.00 0.00 398,927.79 0.00398,927.790.00450 PALAIS ROYALE HISTORIC PRESERVATION 105,485.48 1,543.96 7,242.07 216.81 0.00 0.00 100,004.18 0.00100,004.180.00451 2018 FIRE STATION #9 CAPITAL 1,478,739.95 0.00 491,780.00 3,063.22 0.00 0.00 990,023.17 0.00990,023.170.00452 2018 TIF PARK BOND CAPITAL 7,770,900.91 0.00 370,570.87 16,102.84 0.00 0.00 7,416,432.88 0.007,416,432.880.00453 2018 ZOO BOND CAPITAL 1,792,444.04 0.00 493,454.90 2,216.72 0.00 0.00 1,301,205.86 0.001,301,205.860.00471 2017 PARKS BOND CAPITAL 11,243,282.74 0.00 620,212.86 23,351.33 0.00 0.00 10,646,421.21 0.0010,646,421.210.00750 EQUIPMENT / VEHICLE LEASING 1,248,540.87 1,742,985.00 405,000.00 1,245.00 0.00 0.00 2,587,770.87 0.002,587,770.870.00751 2015 PARKS BOND CAPITAL 375,923.35 2,612.91 177,087.54 96.89 0.000.00 201,545.61 0.00201,545.610.00Month of: July 20192019-07 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: July 2019753 SMART STREET BOND CAPITAL 68,928.30 0.00 0.00 17.56 0.00 0.00 68,945.86 0.0068,945.860.00759 EDDY ST COMMONS CAPITAL 6,130,915.89 0.00 317,460.23 6.56 0.00 0.00 5,813,462.22 0.005,813,462.220.00Total Capital & Debt Service Funds39,450,627.01 1,850,978.16 4,236,084.46 57,068.48 0.00 0.00 37,122,589.19 0.0037,122,589.192,587,222.93Enterprise Funds287 EMS CAPITAL 2,753,220.68 0.00 237,836.48 5,522.12 0.00 0.00 2,520,906.32 0.002,520,906.320.00288 EMS OPERATING 2,228,224.75 436,923.91 471,522.00 5,664.36 0.00 0.00 2,199,291.02 0.002,199,291.020.00600 CONSOLIDATED BUILDING DEPARTMENT 2,136,666.50 204,294.76 372,279.48 3,563.87 0.00 0.00 1,972,245.65 0.001,972,245.650.00601 PARKING GARAGES 1,111,155.72 99,210.11 162,001.17 2,223.46 0.00 0.00 1,050,588.12 0.001,050,588.120.00610 SOLID WASTE OPERATIONS 267,028.06 511,547.43 463,480.52 825.63 0.00 0.00 315,920.60 0.00315,920.600.00611 SOLID WASTE CAPITAL 394,872.23 0.00 185,119.67 680.07 0.00 0.00 210,432.63 0.00210,432.630.00620 WATER WORKS OPERATIONS 3,134,175.81 2,199,616.66 1,634,784.48 5,750.53 11,165.95 438,083.00 3,277,841.47 0.003,277,841.470.00622 WATER WORKS CAPITAL 3,358,155.75 6,032.50 87,440.30 6,914.54 270,083.00 0.00 3,553,745.49 0.003,553,745.490.00624 WATER WORKS CUSTOMER DEPOSIT 1,491,849.72 20,600.24 12,383.19 3,099.43 0.00 3,099.43 1,500,066.77 0.001,500,066.770.00625 WATER WORKS SINKING FUND 758,492.27 0.00 0.00 2,056.28 168,000.00 2,056.28 926,492.27 0.00926,492.270.00626 WATER WORKS BOND RESERVE 1,432,932.28 0.00 0.00 2,962.95 0.00 0.001,435,895.23 0.001,435,895.230.00629 WATER WORKS RESERVE - O & M 2,895,721.40 0.00 0.00 6,010.24 0.006,010.24 2,895,721.40 0.002,895,721.400.00640 SEWER REPAIR INSURANCE 2,099,501.75 59,428.76 53,065.85 4,355.460.00 0.00 2,110,220.12 0.002,110,220.120.00641 SEWAGE WORKS OPERATIONS 8,830,155.49 3,843,449.90 2,307,337.59 21,953.48 11,521.02 0.00 10,399,742.30 0.0010,399,742.300.00642 SEWAGE WORKS CAPITAL 12,112,186.32 12,366.00 381,815.73 25,906.86 0.00 0.00 11,768,643.45 0.0011,768,643.450.00643 SEWAGE WORKS RESERVE - O & M 5,550,801.29 0.00 0.00 11,521.02 0.00 11,521.02 5,550,801.29 0.005,550,801.290.00649 SEWAGE WORKS BOND SINKING 7,850,108.79 0.00 0.00 13,132.37 0.00 0.00 7,863,241.16 0.007,863,241.160.00653 SEWAGE WORKS DEBT SERVICE RESERVE 4,243,294.72 0.00 0.00 8,136.17 0.00 0.00 4,251,430.89 0.004,251,430.890.00654 SEWAGE WORKS DEPOSIT FUND 815.44 48,290.58 5,438.00 0.00 0.00 0.0043,668.02 0.0043,668.020.00667 STORM SEWER FUND(36,299.84)35,522.11 7,289.78 0.00 0.00 0.00(8,067.51)0.00(8,067.51)0.00670 CENTURY CENTER 1,630,369.55 490,240.11 103,185.86 0.00 0.00 0.00 2,017,423.80 0.002,017,423.800.00671 CENTURY CENTER CAPITAL 863,764.24 177,475.00 0.00 1,261.61 0.00 0.00 1,042,500.85 0.001,042,500.850.00672 CENTURY CENTER ENERGY SAVINGS 252,358.46 0.00 0.00 429.58 0.00 0.00 252,788.04 0.00252,788.040.00Total Enterprise Funds65,359,551.38 8,144,998.07 6,484,980.10 131,970.03 460,769.97 460,769.97 67,151,539.38 0.0067,151,539.380.00Internal Service Funds222 CENTRAL SERVICES 1,227,296.05 1,233,468.37 1,142,024.15 1,545.770.00 0.00 1,320,286.04 0.001,320,286.040.00224 CENTRAL SERVICES CAPITAL 138,373.06 0.00 5,575.00 286.68 0.00 0.00133,084.74 0.00133,084.740.00226 LIABILITY INSURANCE 4,846,154.13 365,182.63 844,259.05 9,352.12 0.00 0.00 4,376,429.83 0.004,376,429.830.00278 TAKE HOME VEHICLE POLICE 760,935.98 480.00 1,816.00 1,576.35 0.000.00 761,176.33 0.00761,176.330.00279 IT / INNOVATION / 311 CALL CENTER 2,812,863.95 669,985.02 988,711.18 5,041.81 0.00 0.00 2,499,179.60 0.002,499,179.600.00711 SELF-FUNDED EMPLOYEE BENEFITS 9,673,401.48 1,095,868.43 1,265,068.97 21,006.83 0.00 0.00 9,525,207.77 0.009,525,207.770.00713 UNEMPLOYMENT COMP FUND 185,682.05 0.00 1,652.99 387.50 0.00 0.00 184,416.56 0.00184,416.560.00714 PARENTAL LEAVE FUND 30,886.78 12,161.33 24,428.40 73.06 0.00 0.00 18,692.77 0.0018,692.770.00Total Internal Service Funds19,675,593.48 3,377,145.78 4,273,535.74 39,270.12 0.00 0.00 18,818,473.64 0.0018,818,473.640.00Trust & Agency Funds701 FIREFIGHTERS PENSION 333,056.62 0.00 388,765.46 0.00 0.00 0.00(55,708.84)0.00(55,708.84)0.00702 POLICE PENSION 651,699.34 148.75 497,848.85 0.00 0.00 0.00 153,999.24 0.00153,999.240.00709 PAYROLL FUND 0.00 8,470,226.35 8,470,226.35 0.00 0.00 0.00 0.00 0.000.000.00718 STATE TAX DEDUCTION FUND 299,748.73 298,794.57 299,748.73 0.00 0.00 0.00 298,794.57 0.00298,794.570.00725 MORRIS / PALAIS BOX OFFICE 1,691,467.97 173,324.58 0.00 0.00 0.000.00 1,864,792.55 0.001,864,792.550.00726 POLICE DISTRIBUTIONS PAYABLE 857,332.92 728.47 0.00 0.00 0.00 0.00858,061.39 0.00858,061.390.00730 CITY CEMETERY TRUST 29,317.24 0.00 0.00 60.73 0.00 0.00 29,377.97 0.0029,377.970.00731 BOWMAN CEMETERY 461,194.71 0.00 0.00 955.49 0.00 0.00 462,150.20 0.00462,150.200.00Total Trust & Agency Funds4,323,817.53 8,943,222.72 9,656,589.39 1,016.22 0.00 0.00 3,611,467.08 0.003,611,467.080.00Total City Funds245,336,193.85 27,956,530.22 37,541,149.35 424,031.11 460,769.97 460,769.97 236,175,605.83 73,993.34 236,249,599.17 2,787,222.932019-07 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: July 2019Redevelopment Commission Controlled FundsTax Increment Financing Funds324 TIF RIVER WEST 34,375,373.92 960.00 4,353,934.37 54,954.71 5,769.97 0.00 30,083,124.23 0.0030,083,124.23(200,000.00)422 TIF DISTRICT - WEST WASHINGTON 1,651,912.24 0.00 42,619.85 3,398.26 0.00 0.00 1,612,690.65 0.001,612,690.650.00425 REDEVELOPMENT RETAIL AREA 858.31 0.00 858.31 0.00 0.00 0.00 0.00 0.000.000.00429 TIF RIVER EAST DEV (NE) 10,077,680.09 0.00 580,200.02 18,655.97 0.00 0.00 9,516,136.04 0.009,516,136.040.00430 TIF SOUTHSIDE DEVELOPMENT AREA #1 9,420,365.61 0.00 25,845.21 17,771.49 0.00 0.00 9,412,291.89 0.009,412,291.890.00435 TIF DOUGLAS ROAD 197,909.31 0.00 3,425.00 410.02 0.00 0.00 194,894.33 0.00194,894.330.00436 TIF RIVER EAST RES (NE RE) 3,675,066.09 0.00 1,885,750.00 3,169.53 0.00 0.00 1,792,485.62 0.001,792,485.62(2,587,222.93)Total Tax Increment Financing Funds59,399,165.57 960.00 6,892,632.76 98,359.98 5,769.97 0.00 52,611,622.76 0.0052,611,622.76(2,787,222.93)Redevelopment Funds433 REDEVELOPMENT ADMINISTRATION GENERAL 671,840.54 5,863.00 7,570.94 1,364.05 0.00 0.00 671,496.65 0.00671,496.650.00439 CERTIFIED TECHNOLOGY PARK 575,933.75 0.00 0.00 1,284.99 0.00 0.00 577,218.74 0.00577,218.740.00454 AIRPORT URBAN ENTERPRISE ZONE 398,140.68 0.00 0.00 824.85 0.00 0.00 398,965.53 0.00398,965.530.00754 INDUSTRIAL REVOLVING FUND 1,743,778.00 9,588.00 8,836.00 18,007.00 0.00 0.00 1,762,537.00 0.001,762,537.000.00Total Redevelopment Funds3,389,692.97 15,451.00 16,406.94 21,480.89 0.00 0.00 3,410,217.92 0.003,410,217.920.00Debt Service Funds 315 AIRPORT 2003 DEBT RESERVE 1,040,462.24 0.00 0.00 2,159.54 0.00 2,159.54 1,040,462.24 0.001,040,462.240.00328 SBCDA 2003 DEBT RESERVE 1,739,494.86 0.00 0.00 3,610.43 0.00 3,610.43 1,739,494.86 0.001,739,494.860.00351 2018 TIF PARK BOND DEBT SERVICE RESERVE 1,004,826.93 0.00 0.00 2,081.78 0.00 0.00 1,006,908.71 0.001,006,908.710.00752 SB REDEVELOPMENT AUTHORITY 55,972.08 0.00 0.00 108.47 0.00 0.00 56,080.55 0.0056,080.550.00756 SMARTS STREETS DEBT SERVICE 1,731,122.40 0.00 0.00 441.08 0.00 0.00 1,731,563.48 0.001,731,563.480.00Total Debt Service Funds5,571,878.51 0.00 0.00 8,401.30 0.00 5,769.97 5,574,509.84 0.005,574,509.840.00Total Redevelopment Commission Funds68,360,737.05 16,411.00 6,909,039.70 128,242.17 5,769.97 5,769.97 61,596,350.52 0.00 61,596,350.52(2,787,222.93)City Operations Total313,696,930.90 27,972,941.22 44,450,189.05 552,273.28 466,539.94 466,539.94 297,771,956.35 73,993.34 297,845,949.69 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 Account185,595,441.59 289,119.50 0.00 53,746.37 0.00 362,662.00 185,575,645.46 185,575,645.462019-07 Monthly Cash Report5
City of South BendCash Reserves Summary by Fund Status Cash ActualFund Fund NameCash Outstanding AvailableReserve % ofBalance Encumb. Cash Requirement Variance Budget Notes Cash Reserve PolicyUnder Reserve Requirement201 Parks & Recreation 5,576,592 2,811,243 2,765,348 5,608,526 (2,843,178) 12% Property tax distribution received in June & Dec25% of Annual expenditures211 DCI Administration Fund 471,884 68,190 403,695 788,167 (384,472) 13% Receives quarterly interfund transfers to cover25% of Annual expenditures406 Cumulative Capital Development 443,664 394,106 49,557 204,530 (154,973) 6% Encumbrances reflect total annual debt payments25% of Annual expenditures610 Solid Waste Operations 315,921 247,873 68,047 552,998 (484,951) 1% High encumbrances10% of Annual expenditures667 Storm Sewer Fund(8,068) 92,379 (100,446) 150,000 (250,446) -17% New fund, storm water fee revenue to begin in June25% of Annual expenditures701 Firefighters Pension (55,709) - (55,709) 511,246 (566,955) -1% Pension payments received in June & Sept10% of Annual expenditures702 Police Pension 153,999 - 153,999 635,590 (481,591) 2% Pension payments received in June & Sept10% of Annual expenditures714 Parental Leave Fund 18,693 - 18,693 38,924 (20,231) 12% Just under reserve target25% of Annual expenditures6,916,976 3,613,791 3,303,184 8,489,981 (5,186,797) Meets or Exceeds Requirement101 General Fund 39,501,035 876,200 38,624,835 22,973,642 15,651,193 59% Property tax distribution received in June & Dec35% of Annual expenditures102 Rainy Day Fund 10,606,280 - 10,606,280 9,142,632 1,463,648 3%3% of total expenditures in previous fiscal year, excluding one-time capital expenditures202 Motor Vehicle Highway 5,366,221 1,072,330 4,293,891 3,042,403 1,251,488 35%25% of Annual expenditures216 Police State Seizures 235,076 - 235,076 8,000 227,076 735%25% of Annual expenditures218 Police Curfew Violations 13,311 - 13,311 250 13,061 1331%25% of Annual expenditures219 Unsafe Building 689,078 78,863 610,215 260,859 349,356 58%25% of Annual expenditures220 Law Enforce. Continuing Education 414,944 12,486 402,458 129,387 273,071 78%25% of Annual expenditures222 Central Services 1,320,286 53,206 1,267,080 1,197,546 69,534 26%25% of Annual expenditures, excluding utility accounting226 Liability Insurance 4,376,430 216,097 4,160,333 2,178,828 1,981,505 95%50% of Annual expenditures249 Public Safety L.O.I.T. 3,555,011 - 3,555,011 685,324 2,869,687 41% 8% of Annual expenditures - one month reserve251 Local Roads & Streets 5,525,568 1,092,973 4,432,595 1,773,678 2,658,917 62%25% of Annual expenditures258 Human Rights - Federal Grant 429,289 9,782 419,507 58,747 360,760 179%25% of Annual expenditures273 Morris PAC/Palais Royale Marketing 67,845 3,815 64,030 7,500 56,530 213%25% of Annual expenditures274 Morris PAC/Self-Promotion 151,233 - 151,233 18,750 132,483 202%25% of Annual expenditures278 Take Home Vehicle Police 761,176 - 761,176 750,000 11,176 1522%Set dollar amount of $750,000287 EMS Capital 2,520,906 1,035,839 1,485,067 1,115,569 369,498 33%25% of Annual expenditures288 EMS Operating 2,199,291 67,061 2,132,230 1,607,667 524,563 33%25% of Annual expenditures289 HAZMAT 28,238 - 28,238 2,618 25,620 270%25% of Annual expenditures291 Indiana River Rescue 268,426 2,772 265,654 33,816 231,838 196%25% of Annual expenditures294 Regional Police Academy 113,668 - 113,668 5,625 108,043 505%25% of Annual expenditures299 Police Federal Drug Enforcement 112,503 - 112,503 12,750 99,753 221%25% of Annual expenditures315 Airport 2003 Debt Reserve 1,040,462 - 1,040,462 1,040,462 - 100%100% debt service reserve per bond covenants328 SBCDA 2003 Debt Reserve 1,739,495 - 1,739,495 1,739,495 - 100%100% debt service reserve per bond covenants324 River West TIF (Airport TIF) 30,083,124 11,225,255 18,857,869 10,871,238 7,986,631 43% Property tax distribution received in June & Dec25% of Annual expenditures351 2018 TIF Park Bond Debt Svc Reserve 1,006,909 - 1,006,909 1,006,909 - 100% 100% debt service reserve per bond covenants404 County Option Income Tax 13,015,340 2,526,619 10,488,721 8,504,214 1,984,507 62%50% of Annual expenditures407 Cumulative Capital Improvement 565,492 - 565,492 7,000 558,492 2020%25% of Annual expenditures408 Economic Development Income Tax 18,120,398 3,822,742 14,297,655 7,351,601 6,946,054 97%50% of Annual expenditures416 Morris Performing Arts Center Capital 398,928 16,483 382,445 56,366 326,079 170%25% of Annual expenditures422 TIF District - West Washington 1,612,691 504,735 1,107,955 423,783 684,172 65% Property tax distribution received in June & Dec25% of Annual expenditures425 Redevelopment Retail Area 0 - - - - 100%25% of Annual expenditures429 River East Dev TIF (Northeast TIF) 9,516,136 2,647,883 6,868,253 3,050,496 3,817,757 56% Property tax distribution received in June & Dec25% of Annual expenditures430 TIF Southside Development Area #1 9,412,292 452,891 8,959,401 2,588,182 6,371,219 87% Property tax distribution received in June & Dec25% of Annual expenditures433 Redev Administration General 671,497 100,000 571,497 268,500 302,997 53%25% of Annual expenditures435 TIF - Douglas Road 194,894 96,625 98,269 20,800 77,469 47%10% of Annual expenditures436 River East Residential (NE Res TIF) 1,792,486 - 1,792,486 1,068,750 723,736 42% Property tax distribution received in June & Dec25% of Annual expenditures450 Palais Royale Historic Preservation 100,004 - 100,004 27,992 72,012 89%25% of Annual expenditures600 Consolidated Building Department 1,972,246 168,423 1,803,822 1,242,076 561,746 36%25% of Annual expenditures601 Parking Garages 1,050,588 56,159 994,429 476,646 517,783 52%25% of Annual expenditures620 Water Works Operations 3,277,841 1,680,155 1,597,687 1,140,646 457,041 7%5% of Annual expenditures624 Water Works Customer Deposit 1,500,067 - 1,500,067 1,500,067 - 100%100% cash reserves for customer deposits625 Water Works Sinking Fund 926,492 1,750,922 (824,430) (824,430) - 100% Encumbrances reflect total annual debt payments100% cash reserves per bond covenants626 Water Works Bond Reserve 1,435,895 - 1,435,895 1,435,895 - 100%100% cash reserves per bond covenants and Crowe Horwath629 Water Works Reserve - O & M 2,895,721 - 2,895,721 2,879,222 16,499 17%16.67% of annual operating expenses in Fund 620, net of transfers640 Sewer Repair Insurance 2,110,220 138,033 1,972,187 165,797 1,806,390 297%25% of Annual expenditures641 Sewage Works Operations 10,399,742 5,731,395 4,668,348 2,307,147 2,361,201 10%5% of Annual expenditures643 Sewage Works Reserve - O & M 5,550,801 - 5,550,801 5,529,277 21,524 17% 16.67% of annual operating expenses in Fund 641, net of transfersJuly 31, 20192019-07 Monthly Cash Report6
City of South BendCash Reserves Summary by Fund Status Cash ActualFund Fund NameCash Outstanding AvailableReserve % ofBalance Encumb. Cash Requirement Variance Budget Notes Cash Reserve PolicyJuly 31, 2019649 Sewage Works Bond Sinking 7,863,241 6,851,977 1,011,264 1,011,264 - 100% Encumbrances reflect total annual debt payments100% cash reserves per bond covenants653 Sewage Works Debt Service Reserve 4,251,431 - 4,251,431 4,251,431 - 100%100% cash reserves per bond covenants and Crowe Horwath654 Sewage Works Deposit Fund 43,668 - 43,668 43,668 - 100%100% cash reserves for customer deposits655 Project Releaf 555,501 - 555,501 168,741 386,760 82%25% of Annual expenditures670 Century Center 2,017,424 32,938 1,984,486 1,171,839 812,647 42%25% of Annual expenditures671 Century Center Capital 1,042,501 - 1,042,501 800,000 242,501 1256%$800,000 Minimum per Board of Managers705 Police K-9 Unit 2,367 - 2,367 505 1,862 117%25% of Annual expenditures711 Self-Funded Employee Benefits 9,525,208 553,377 8,971,831 4,155,747 4,816,084 54%25% of Annual expenditures713 Unemployment Comp Fund 184,417 - 184,417 17,500 166,917 263%25% of Annual expenditures718 State Tax Withholding Fund 298,795 - 298,795 298,795 - 100%100% cash reserves - trust & agency funds725 Morris / Palais Box Office 1,864,793 - 1,864,793 1,864,793 - 100%100% cash reserves - trust & agency funds726 Police Distributions Payable 858,061 - 858,061 858,061 - 100%100% cash reserves - trust & agency funds730 City Cemetery Trust 29,378 - 29,378 - 29,378 100%25% of Annual expenditures731 Bowman Cemetery 462,150 - 462,150 400,000 62,150 100%$400,000 minimum752 South Bend Redevelopment Authority 56,081 - 56,081 56,081 - 100%100% cash reserves per bond covenants753 Smart Street Bond Capital 68,946 - 68,946 68,946 - 100%100% cash reserves per bond covenants755 South Bend Building Corporation 686,110 - 686,110 686,110 - 100%100% cash reserves per bond covenants756 Smart Streets Debt Service Fund 1,731,563 - 1,731,563 1,731,563 - 100%100% cash reserves per bond covenants757 2015 Parks Bond Debt Service 592,012 - 592,012 592,012 - 100%100% cash reserves per bond covenants760 Eddy St. Commons Debt Service 3,458,056 - 3,458,056 2,500,000 958,056 266%$2,500,000 minimum234,237,277 42,878,037 191,359,242 119,560,778 71,798,464 No Reserve Requirement209 Studebaker/Oliver Revitalizing Grants 838,708 135,126 703,583 - 703,583 100%No reserve requirement - Grant fund - spend down to zero210 DCI State Grants 106,287 65,253 41,033 - 41,033 100% To be reimbursed by grant receiptsNo reserve requirement - Grant fund - spend down to zero212 DCI Federal Grants 311,984 2,149,105 (1,837,121) - (1,837,121) 100% To be reimbursed by grant receiptsNo reserve requirement - Grant fund - spend down to zero217 Gift, Donation, Bequest 642,625 320,479 322,147 - 322,147 100%No reserve requirement221 Landlord Registration 12,974 - 12,974 - 12,974 100%No reserve requirement224 Central Services Capital 133,085 29,718 103,366 - 103,366 100%No reserve requirement - Capital fund - spend down to zero227 Loss Recovery Fund 598,296 11,406 586,890 - 586,890 100%No reserve requirement257 LOIT 2016 Special Distribution 382,573 383,864 (1,291) - (1,291) 100% High encumbrancesNo reserve requirement265 Local Road & Bridge Grant 333,840 82,493 251,347 - 251,347 100%No reserve requirement - Grant fund - spend down to zero266 MVH Restricted 1,293,007 236,977 1,056,030 - 1,056,030 100%New fund - reserve requirement to be determined279 IT / Innovation / 311 Call Center 2,499,180 1,489,228 1,009,951 - 1,009,951 100% Reimbursed through interfund allocationNo reserve requirement280 Police Block Grants 4,046 - 4,046 - 4,046 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 156,460 24,787 131,673 - 131,673 100%No reserve requirement - Grant fund - spend down to zero312 2017 Parks Bond Debt Service(368,082) - (368,082) - (368,082) 100% Property tax distribution received in June & DecNo reserve requirement350 2018 Fire St #9 Debt Service(170,291) - (170,291) - (170,291) 100% Receives transfers from Fund 287 for debt svc pmtsNo reserve requirement401 Coveleski Stadium Capital 9,340 - 9,340 - 9,340 100%No reserve requirement - Capital fund - spend down to zero410 Urban Develop Action Grant (UDAG) 18,208 - 18,208 - 18,208 100%No reserve requirement - Grant fund - spend down to zero412 Major Moves Construction 2,381,548 718,467 1,663,081 - 1,663,081 100%No reserve requirement - Capital fund - spend down to zero439 Certified Technology Park 577,219 544,611 32,608 - 32,608 100%No reserve requirement451 2018 Fire St #9 Capital 990,023 686,877 303,147 - 303,147 100%No reserve requirement - Bond capital fund - spend down to zero452 2018 TIF Park Bond Capital 7,416,433 2,597,877 4,818,556 - 4,818,556 100%No reserve requirement - Bond capital fund - spend down to zero453 2018 Zoo Bond Capital 1,301,206 - 1,301,206 - 1,301,206 100%No reserve requirement - Bond capital fund - spend down to zero454 Airport Urban Enterprise Zone 398,966 - 398,966 - 398,966 100%No reserve requirement471 2017 Parks Bond Capital 10,646,421 1,167,046 9,479,375 - 9,479,375 100%No reserve requirement - Bond capital fund - spend down to zero611 Solid Waste Capital 210,433 295,627 (85,194) - (85,194) 100% Receives transfers from Fund 610 as neededNo reserve requirement - Capital fund - spend down to zero622 Water Works Capital 3,553,745 1,127,925 2,425,820 - 2,425,820 100%No reserve requirement - Capital fund - spend down to zero642 Sewage Works Capital 11,768,643 8,221,949 3,546,695 - 3,546,695 100% Receives transfers from Fund 641 as neededNo reserve requirement - Capital fund - spend down to zero672 Century Center Energy Savings 252,788 207,863 44,925 - 44,925 100% Encumbrances reflect total annual debt paymentsNo reserve requirement750 Equipment/Vehicle Leasing 2,587,771 1,387,466 1,200,305 - 1,200,305 100% No reserve requirement - Capital lease fund - spend down to zero751 2015 Parks Bond Capital 201,546 210,966 (9,420) - (9,420) 100% No reserve requirement - Bond capital fund - spend down to zero754 Industrial Revolving Fund 1,762,537 - 1,762,537 - 1,762,537 100%No City reserve requirement; there are program requirements759 Eddy St Commons Capital 5,813,462 - 5,813,462 - 5,813,462 100%No reserve requirement - Bond capital fund - spend down to zero56,691,696 22,095,109 34,596,588 - 34,596,588 City Operations Total 297,845,950 68,586,937 229,259,014 128,050,759 101,208,255 Note: Available Cash is a Fund's cash balance minus any outstanding encumbrances2019-07 Monthly Cash Report7
January 1, 2007 - July 31, 2019
$329,782,565 6/30/2018
$122,056,198 5/31/2007
$216,107,588 --
$293,703,703 --
Enterprise Redevelopment Civil City Enterprise Redevelopment Civil City
Date Total Cash Funds Funds Funds Date Total Cash Funds Funds Funds
01/01/07 153,934,542.58 28,657,187.47 40,101,775.51 85,175,579.60 03/31/11 204,406,098.50 46,555,428.08 52,439,712.97 105,410,957.45
01/31/07 140,751,745.07 30,058,091.08 37,204,941.29 73,488,712.70 04/30/11 196,890,904.95 46,284,639.10 51,775,206.12 98,831,059.73
02/28/07 134,780,141.52 30,099,578.04 42,400,991.27 62,279,572.21 05/31/11 187,084,917.40 45,692,919.82 45,543,075.85 95,848,921.73
03/31/07 130,695,124.81 30,984,947.93 36,322,464.80 63,387,712.08 06/30/11 230,633,979.38 46,029,921.56 57,605,720.29 126,998,337.53
04/30/07 123,592,524.20 29,218,887.63 36,374,308.24 57,999,328.33 07/31/11 215,737,687.08 45,556,018.39 51,845,520.23 118,336,148.46
05/31/07 122,056,197.59 32,424,086.65 36,579,224.31 53,052,886.63 08/31/11 208,031,597.26 45,688,053.72 49,085,008.00 113,258,535.54
06/30/07 153,755,514.81 48,699,567.31 35,914,061.41 69,141,886.09 09/30/11 203,800,576.60 46,330,287.44 47,073,543.39 110,396,745.77
07/31/07 137,115,793.85 48,096,309.22 33,046,039.94 55,973,444.69 10/31/11 218,059,539.64 67,040,484.39 44,750,523.17 106,268,532.08
08/31/07 135,817,993.03 47,662,427.04 31,416,991.60 56,738,574.39 11/30/11 207,257,743.68 61,691,017.04 41,844,406.42 103,722,320.22
09/30/07 130,647,671.00 45,360,303.16 30,955,278.22 54,332,089.62 12/31/11 231,757,444.75 58,173,399.01 51,201,636.39 122,382,409.35
10/31/07 139,006,258.42 46,717,357.10 29,953,285.20 62,335,616.12 01/31/12 216,528,714.30 59,207,692.55 44,464,972.65 112,856,049.10
11/30/07 149,006,468.44 41,716,114.28 29,049,190.99 78,241,163.17 02/29/12 210,660,777.01 59,272,665.18 43,124,396.97 108,263,714.86
12/31/07 191,315,373.73 55,204,053.77 43,118,912.28 92,992,407.68 03/31/12 204,985,024.71 59,768,182.49 40,875,506.16 104,341,336.06
01/31/08 178,454,459.92 56,114,335.03 41,405,052.40 80,935,072.49 04/30/12 202,396,668.08 60,202,795.65 39,972,677.94 102,221,194.49
02/29/08 175,025,158.07 54,575,012.50 40,635,068.99 79,815,076.58 05/31/12 194,807,225.14 59,123,171.41 37,283,464.71 98,400,589.02
03/31/08 170,888,981.29 54,575,272.95 40,558,124.18 75,755,584.16 06/30/12 244,718,879.49 67,140,754.63 48,308,618.33 129,269,506.53
04/30/08 165,390,558.53 54,929,047.02 40,290,091.29 70,171,420.22 07/31/12 230,268,324.98 67,955,663.74 43,597,429.86 118,715,231.38
05/31/08 156,964,559.54 53,052,472.03 40,210,711.69 63,701,375.82 08/31/12 223,526,459.82 67,464,201.30 41,355,817.62 114,706,440.90
06/30/08 167,363,776.09 53,204,418.10 39,857,987.53 74,301,370.46 09/30/12 223,261,928.97 65,732,654.52 40,654,565.67 116,874,708.78
07/31/08 171,036,661.63 54,533,563.28 39,145,712.40 77,357,385.95 10/31/12 214,815,908.26 66,270,486.67 38,605,222.83 109,940,198.76
08/31/08 163,938,453.44 54,251,216.99 36,074,455.00 73,612,781.45 11/30/12 203,844,116.85 59,658,568.60 37,090,958.24 107,094,590.01
09/30/08 160,071,575.14 53,272,451.68 35,928,266.53 70,870,856.93 12/31/12 255,285,203.18 82,506,887.41 47,393,846.15 125,384,469.62
10/31/08 164,801,788.81 68,706,036.43 34,674,631.21 61,421,121.17 01/31/13 247,853,896.56 83,296,821.86 45,144,294.34 119,412,780.36
11/30/08 148,390,201.07 54,077,562.73 33,382,904.90 60,929,733.44 02/28/13 237,222,593.71 82,484,393.54 41,364,435.41 113,373,764.76
12/31/08 140,621,861.88 44,639,804.67 28,608,922.65 67,373,134.56 03/31/13 232,080,046.72 82,950,715.18 41,430,811.51 107,698,520.03
01/31/09 129,082,048.94 45,793,529.09 26,731,148.85 56,557,371.00 04/30/13 226,442,650.85 80,568,512.43 42,438,979.52 103,435,158.90
02/28/09 136,587,197.92 46,941,062.25 28,199,966.51 61,446,169.16 05/31/13 220,102,647.01 79,672,318.05 42,077,874.12 98,352,454.84
03/31/09 150,350,125.92 47,265,006.09 27,482,787.81 75,602,332.02 06/30/13 259,848,268.81 79,520,360.08 55,157,971.58 125,169,937.15
04/30/09 156,355,774.87 48,061,985.20 38,905,572.01 69,388,217.66 07/31/13 252,445,699.79 79,867,774.82 51,147,079.40 121,430,845.57
05/31/09 154,015,638.43 46,623,111.00 38,656,758.39 68,735,769.04 08/31/13 242,038,208.31 79,782,901.50 48,231,381.91 114,023,924.90
06/30/09 145,255,362.21 46,662,615.02 36,003,705.47 62,589,041.72 09/30/13 242,325,305.67 79,940,103.15 47,344,717.04 115,040,485.48
07/31/09 151,028,950.92 45,609,990.75 39,288,192.08 66,130,768.09 10/31/13 235,335,719.18 79,663,547.72 45,849,747.51 109,822,423.95
08/31/09 154,754,067.65 44,700,623.82 38,981,480.90 71,071,962.93 11/30/13 222,610,337.19 72,524,668.50 45,831,055.40 104,254,613.29
09/30/09 153,379,153.77 44,771,129.93 38,365,267.66 70,242,756.18 12/31/13 247,349,777.30 67,716,137.82 55,315,510.06 124,318,129.42
10/31/09 150,364,096.50 44,855,908.07 36,749,933.72 68,758,254.71 01/31/14 232,044,399.72 66,889,990.77 50,898,242.66 114,256,166.29
11/30/09 144,010,184.05 44,458,186.54 35,847,660.55 63,704,336.96 02/28/14 227,156,115.52 67,566,543.96 49,986,290.38 109,603,281.18
12/31/09 188,453,001.03 36,891,179.40 34,358,243.89 117,203,577.74 03/31/14 222,046,327.82 68,633,684.73 49,028,261.04 104,384,382.05
01/31/10 196,099,529.93 37,726,300.40 53,534,937.83 104,838,291.70 04/30/14 214,783,605.41 68,960,383.93 47,281,387.13 98,541,834.35
02/28/10 194,663,355.99 36,982,623.93 52,816,628.95 104,864,103.11 05/31/14 209,324,809.29 67,425,749.33 46,795,213.96 95,103,846.00
03/31/10 197,907,655.27 41,475,717.35 52,577,148.25 103,854,789.67 06/30/14 251,700,644.00 67,697,981.00 61,118,881.00 122,883,782.00
04/30/10 190,430,003.35 40,478,357.60 51,768,568.42 98,183,077.33 07/31/14 238,781,403.03 68,611,865.99 56,842,280.86 113,327,256.18
05/31/10 201,229,420.61 38,739,522.56 50,881,687.36 111,608,210.69 08/31/14 234,086,687.41 68,747,483.87 55,735,447.17 109,603,756.37
06/30/10 230,557,975.59 39,738,881.62 62,539,377.78 128,279,716.19 09/30/14 233,595,370.44 69,430,344.98 54,889,194.46 109,275,831.00
07/31/10 217,064,522.90 42,020,069.17 55,401,804.58 119,642,649.15 10/31/14 225,913,486.47 70,431,027.92 54,196,891.83 101,285,566.72
08/31/10 210,387,480.23 40,331,826.60 53,423,401.23 116,632,252.40 11/30/14 216,583,420.38 64,909,392.12 54,554,819.33 97,119,208.93
09/30/10 211,494,373.45 40,245,656.32 52,832,007.68 118,416,709.45 12/31/14 239,808,095.03 61,623,499.90 65,903,128.76 112,281,466.37
10/31/10 204,642,650.38 39,984,803.80 51,745,774.22 112,912,072.36 01/31/15 225,471,264.56 61,585,040.94 60,387,162.56 103,499,061.06
11/30/10 198,782,418.22 35,695,100.47 49,573,730.89 113,513,586.86 02/28/15 221,854,105.82 63,269,776.69 58,990,110.88 99,594,218.25
12/31/10 227,739,252.18 41,300,042.16 65,164,721.07 121,274,488.95 03/31/15 215,278,052.12 64,288,370.38 58,654,868.03 92,334,813.71
01/31/11 214,107,834.98 42,918,366.28 57,392,911.65 113,796,557.05 04/30/15 213,330,317.66 65,430,174.18 57,972,838.77 89,927,304.71
02/28/11 208,263,626.92 44,793,554.36 53,822,791.88 109,647,280.68 05/31/15 209,379,494.75 65,714,228.05 57,630,884.95 86,034,381.75
Note: Property tax distributions are received
in June and December.
City of South Bend Cash Balances - All Funds
Maximum Total Cash
Minimum Total Cash
Average Cash
Average - last 12 months
$0
$50,000,000
$100,000,000
$150,000,000
$200,000,000
$250,000,000
$300,000,000
$350,000,000
2019-07 Monthly Cash Report 8
January 1, 2007 - July 31, 2019
City of South Bend Cash Balances - All Funds
Enterprise Redevelopment Civil City Enterprise Redevelopment Civil City
Date Total Cash Funds Funds Funds Date Total Cash Funds Funds Funds
06/30/15 249,603,497.41 68,746,632.56 70,642,566.10 110,214,298.75 05/31/19 267,228,987.30 65,258,811.69 53,673,044.13 148,297,131.48
07/31/15 236,381,857.01 70,884,051.33 65,048,413.67 100,449,392.01 06/30/19 313,696,930.90 65,359,551.38 68,360,737.05 179,976,642.47
08/31/15 228,483,356.31 72,023,119.13 61,042,169.83 95,418,067.35 07/31/19 297,845,949.69 67,151,539.38 61,596,350.52 169,098,059.79
09/30/15 234,514,964.30 75,617,268.98 59,936,471.64 98,961,223.68
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
11/30/18 282,111,836.71 62,080,096.93 57,701,465.11 162,330,274.67
12/31/18 309,811,785.05 63,399,519.22 66,695,748.11 179,716,517.72
01/31/19 292,787,503.35 61,984,035.31 59,597,388.81 171,206,079.23
02/28/19 290,154,850.97 62,312,317.89 60,283,680.41 167,558,852.67
03/31/19 282,250,506.35 65,067,673.27 57,633,297.22 159,549,535.86
04/30/19 276,790,123.45 65,875,626.86 55,133,997.10 155,780,499.49
2019-07 Monthly Cash Report 9
$83,296,822 1/31/2013
$28,657,187 1/1/2007
$58,605,535 --
$65,183,812 --
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 11/30/18 62,080,096.93
06/30/10 39,738,881.62 09/30/14 69,430,344.98 12/31/18 63,399,519.22
07/31/10 42,020,069.17 10/31/14 70,431,027.92 01/31/19 61,984,035.31
08/31/10 40,331,826.60 11/30/14 64,909,392.12 02/28/19 62,312,317.89
09/30/10 40,245,656.32 12/31/14 61,623,499.90 03/31/19 65,067,673.27
10/31/10 39,984,803.80 01/31/15 61,585,040.94 04/30/19 65,875,626.86
11/30/10 35,695,100.47 02/28/15 63,269,776.69 05/31/19 65,258,811.69
12/31/10 41,300,042.16 03/31/15 64,288,370.38 06/30/19 65,359,551.38
01/31/11 42,918,366.28 04/30/15 65,430,174.18 07/31/19 67,151,539.38
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 - July 31, 2019
Maximum Total Cash
Minimum Total Cash
Average Cash
Average - last 12 months
$0
$10,000,000
$20,000,000
$30,000,000
$40,000,000
$50,000,000
$60,000,000
$70,000,000
$80,000,000
$90,000,000
2019-07 Monthly Cash Report 10
$81,992,643 6/30/2018
$26,731,149 1/31/2009
$50,028,482 --
$62,378,994 --
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 11/30/18 57,701,465.11
06/30/10 62,539,377.78 09/30/14 54,889,194.46 12/31/18 66,695,748.11
07/31/10 55,401,804.58 10/31/14 54,196,891.83 01/31/19 59,597,388.81
08/31/10 53,423,401.23 11/30/14 54,554,819.33 02/28/19 60,283,680.41
09/30/10 52,832,007.68 12/31/14 65,903,128.76 03/31/19 57,633,297.22
10/31/10 51,745,774.22 01/31/15 60,387,162.56 04/30/19 55,133,997.10
11/30/10 49,573,730.89 02/28/15 58,990,110.88 05/31/19 53,673,044.13
12/31/10 65,164,721.07 03/31/15 58,654,868.03 06/30/19 68,360,737.05
01/31/11 57,392,911.65 04/30/15 57,972,838.77 07/31/19 61,596,350.52
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 - July 31, 2019
Maximum Total Cash
Minimum Total Cash
Average Cash
Average - last 12 months
$0
$10,000,000
$20,000,000
$30,000,000
$40,000,000
$50,000,000
$60,000,000
$70,000,000
$80,000,000
$90,000,000
2019-07 Monthly Cash Report 11
$185,010,338 6/30/2018
$53,052,887 5/31/2007
$107,598,293 --
$166,586,898 --
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 11/30/18 162,330,274.67
06/30/10 128,279,716.19 09/30/14 109,275,831.00 12/31/18 179,716,517.72
07/31/10 119,642,649.15 10/31/14 101,285,566.72 01/31/19 171,206,079.23
08/31/10 116,632,252.40 11/30/14 97,119,208.93 02/28/19 167,558,852.67
09/30/10 118,416,709.45 12/31/14 112,281,466.37 03/31/19 159,549,535.86
10/31/10 112,912,072.36 01/31/15 103,499,061.06 04/30/19 155,780,499.49
11/30/10 113,513,586.86 02/28/15 99,594,218.25 05/31/19 148,297,131.48
12/31/10 121,274,488.95 03/31/15 92,334,813.71 06/30/19 179,976,642.47
01/31/11 113,796,557.05 04/30/15 89,927,304.71 07/31/19 169,098,059.79
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 - July 31, 2019
Maximum Total Cash
Minimum Total Cash
Average Cash
Average - last 12 months
$0
$20,000,000
$40,000,000
$60,000,000
$80,000,000
$100,000,000
$120,000,000
$140,000,000
$160,000,000
$180,000,000
$200,000,000
2019-07 Monthly Cash Report 12