HomeMy WebLinkAbout2019-01 Monthly Cash ReportPeriod Ending:
Issued by:
Page Number(s)Contents
2 Narrative
3 - 5 Controller's Cash Report
6 - 7 Cash Reserves Summary by Fund Status
8 - 9 Cash Trends - All Funds
10 Cash Trends - Enterprise Funds
11 Cash Trends - Redevelopment Funds
12 Cash Trends - Civil City Funds
Distribution
Mayor Pete Buttigieg
Chief of Staff Laura O'Sullivan
Deputy Chief of Staff Suzanna Fritzberg
Common Council
Department Heads
Fiscal Officers
January 31, 2019
Controller
City of South Bend
Monthly Cash Report
2019-01 Monthly Cash Report 1
January 2019 Highlights:
Questions
If you should have additional questions, please contact the Department of Administration & Finance by calling 311.
Narrative
Fiscal Responsibility
The City’s management team is responsible for establishing and maintaining an internal control structure designed to ensure that the assets of the City are
protected from loss, theft, or misuse and to ensure that adequate accounting data is compiled to allow for the preparation of financial statements in conformity
with generally accepted accounting principles.
Controller's Cash Report (pages 3-5)
The Controller’s Cash Report is a monthly summary of cash and investment transactions within the current period by Fund. It summarizes the cash received,
interest earned, cash disbursed, and cash transferred between Funds within the City of South Bend as well as any loans between Funds. The report provides a
month-end view of the City’s cash balance in the reporting period.
Cash Reserves Summary (pages 6-8)
The purpose of the Cash Reserves Summary Report is keep track of whether the City's funds are meeting their cash reserve requirement. Cash reserve
requirements are set for each fund by the City of South Bend or other governing body (e.g. bond counsel, Century Center Board of Managers).
Cash Trends Summary (pages 9-13)
The purpose of the Cash Trends Summary is to track trends in cash balances for the City of South Bend over an extended period of time, from January 1, 2007
through the present date. Charts and graphs for the cash balances are provided in four areas--total cash, enterprise fund cash, redevelopment fund cash, and
civil city fund cash.
Cash Reserve Requirements
Cash reserve requirements are typically based on fund type.
- Most City funds are assigned a cash reserve requirement of a percentage of the fund's annual expenditures.
- The Rainy Day Fund 102 has a reserve requirement of 3% of the City's prior year 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.
The City received a donation of $545,000 from the Pokagon Band of the Potawatomi. $100,000 is to be spent on the Bowman Creek Project and $445,000 is to
be spent on Howard Park Improvements.
The City received the Cities of Service-Love Your Block grant for $12,500. The City will match this grant.
Fund 312, 701, and 377 have negative cash balances.
- The 2017 Parks Bond Debt Service Fund 312 receives property tax revenue in June and December, but still has to make a debt payments in January and
July. When property tax revenue is received in December, this fund won't be negative.
- The Professional Sports Development Area Fund 377 made the final debt service payment on the Coveleski Stadium Bonds on January 15, 2019. This fund
will receive an interfund transfer from the Coveleski Debt Service Reserve Fund 317 in February to cover this final payment.
- 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.
2019-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 38,944,317.21 1,265,505.93 4,849,453.18 51,058.61 0.00 0.00 35,411,428.57 0.0035,411,428.570.00Special Revenue Funds102 RAINY DAY FUND 10,464,997.04 0.00 0.00 18,481.84 0.00 0.00 10,483,478.88 0.0010,483,478.880.00201 PARKS & RECREATION 8,298,305.58 123,731.21 1,629,598.85 10,414.70 0.00 0.00 6,802,852.64 0.006,802,852.640.00202 MOTOR VEHICLE HIGHWAY 8,012,501.35 523,523.56 875,225.22 14,254.66 0.00 0.00 7,675,054.35 0.007,675,054.350.00209 STUDEBAKER/OLIVER REVERTING GRANTS 956,463.51 0.00 56,570.60 1,664.68 0.00 0.00 901,557.59 0.00901,557.59200,000.00210 DEPT COMMUNITY INVESTMENT STATE GRANTS 345,692.79 16,582.11 230,000.00 2,061.48 0.00 0.00 134,336.38 0.00134,336.380.00211 DCI OPERATING FUND 731,464.47 10,259.37 202,464.75 1,375.07 0.00 0.00 540,634.16 0.00540,634.160.00212 DEPARTMENT OF COMMUNITY INVESTMENT 347,782.11 85,322.32 172,936.00 7.34 0.00 0.00 260,175.77 0.00260,175.770.00216 POLICE STATE SEIZURES 227,102.84 100.00 0.00 401.87 0.00 0.00 227,604.71 0.00227,604.710.00217 GIFT, DONATION, BEQUEST 165,218.68 545,709.09 4,667.47 298.01 0.00 0.00 706,558.31 0.00706,558.310.00218 POLICE CURFEW VIOLATIONS 13,109.24 0.00 0.00 23.15 0.00 0.00 13,132.39 0.0013,132.390.00219 UNSAFE BUILDING 544,555.51 11,244.50 42,738.20 994.68 0.00 0.00 514,056.49 0.00514,056.490.00220 LAW ENFORCEMENT CONTINUING EDUCATION 446,232.26 14,523.26 112,153.39 837.49 0.00 0.00 349,439.62 0.00349,439.620.00221 LANDLORD REGISTRATION 10,130.02 0.00 0.00 17.89 0.00 0.00 10,147.910.0010,147.910.00227 LOSS RECOVERY FUND 627,324.53 0.00 0.00 1,152.14 0.00 0.00 628,476.67 0.00628,476.670.00249 PUBLIC SAFETY L.O.I.T. 1,958,708.37 713,379.58 440,338.68 3,052.36 0.00 0.00 2,234,801.63 0.002,234,801.630.00251 LOCAL ROADS & STREETS 3,929,499.85 160,392.21 52,414.98 7,121.080.00 0.00 4,044,598.16 0.004,044,598.160.00257 LOIT 2016 SPECIAL DISTRIBUTION 759,356.82 0.00 142,635.99 1,202.50 0.00 0.00 617,923.33 0.00617,923.330.00258 HUMAN RIGHTS - FEDERAL GRANT 529,536.31 10,000.00 83,624.57 811.90 0.00 0.00 456,723.64 73,993.34530,716.980.00265 LOCAL ROAD & BRIDGE GRANT 330,176.92 0.00 0.00 592.42 0.00 0.00 330,769.34 0.00330,769.340.00273 MORRIS PAC/PALAIS ROYALE MARKETING 57,484.86 0.00 0.00 94.79 0.000.00 57,579.65 0.0057,579.650.00274 MORRIS PAC SELF-PROMOTION 101,746.27 0.00 0.00 153.04 0.00 0.00 101,899.31 0.00101,899.310.00280 POLICE BLOCK GRANTS 3,992.41 0.00 0.00 7.05 0.00 0.00 3,999.46 0.003,999.460.00281 DEPT. COMMUNITY INVESTMENT - REV BONDS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.000.00289 HAZMAT 19,085.49 0.00 528.85 33.70 0.00 0.00 18,590.34 0.0018,590.340.00291 INDIANA RIVER RESCUE 181,645.96 11,700.00 6,794.78 384.54 0.00 0.00 186,935.72 0.00186,935.720.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 98,679.65 2,400.00 139.95 174.21 0.00 0.00101,113.91 0.00101,113.910.00295 COPS MORE GRANT 202,528.20 3,536.64 19,042.52 310.60 0.00 0.00 187,332.92 0.00187,332.920.00299 POLICE FEDERAL DRUG ENFORCEMENT 153,919.65 0.00 0.00 281.11 0.00 0.00 154,200.76 0.00154,200.760.00404 COUNTY OPTION INCOME TAX 11,799,456.13 1,045,720.83 1,187,570.58 20,660.66 830,000.00 0.00 12,508,267.04 0.0012,508,267.04480,253.20408 ECONOMIC DEVELOPMENT INCOME TAX 15,134,269.21 966,435.50 451,807.10 26,180.05 0.00 63,643.87 15,611,433.79 0.0015,611,433.790.00410 URBAN DEVELOPMENT ACTION GRANT (UDAG) 28,989.92 11,310.00 15,000.00 51.20 0.00 0.00 25,351.12 0.0025,351.12(480,253.20)655 PROJECT RELEAF 594,755.01 34,464.99 5,821.46 1,057.10 0.00 0.00 624,455.64 0.00624,455.640.00705 POLICE K-9 UNIT 2,335.33 0.00 0.00 4.13 0.00 0.00 2,339.46 0.002,339.460.00Total Special Revenue Funds67,103,761.79 4,290,335.17 5,732,073.94 114,157.44 830,000.00 63,643.87 66,542,536.59 73,993.3466,616,529.93200,000.00 Debt Service Fund312 2017 PARKS BOND DEBT SERVICE 147,684.05 0.00 583,382.50 0.00 0.000.00(435,698.45)0.00(435,698.45)0.00313 HALL OF FAME DEBT SERVICE 97,076.78 0.00 0.00 0.00 0.00 0.00 97,076.78 0.0097,076.780.00755 SB BUILDING CORPORATION 791,025.90 0.00 0.00 0.00 0.00 0.00 791,025.90 0.00791,025.900.00757 2015 PARKS BOND DEBT SERVICE 560,430.77 0.00 0.00 0.00 0.00 0.00 560,430.77 0.00560,430.770.00760 EDDY ST. COMMONS DEBT SERVICE 3,452,907.73 0.00 0.00 0.00 0.00 0.00 3,452,907.73 0.003,452,907.730.00Capital Project Funds377 PROFESSIONAL SPORTS DEVELOPMENT 0.00 3,786.24 353,970.00 0.00 0.00 0.00(350,183.76)0.00(350,183.76)0.00401 COVELESKI STADIUM CAPITAL 73,434.54 0.00 0.00 130.92 0.00 0.00 73,565.46 0.0073,565.460.00406 CUMULATIVE CAPITAL DEVELOPMENT 529,327.82 0.00 110,683.03 695.47 0.00 0.00 419,340.26 0.00419,340.260.00407 CUMULATIVE CAPITAL IMPROVEMENT 447,849.70 0.00 0.00 674.86 0.00 0.00 448,524.56 0.00448,524.560.00412 MAJOR MOVES CONSTRUCTION 2,772,696.57 0.00 0.00 4,903.51 0.00 0.002,777,600.08 0.002,777,600.082,781,424.34416 MORRIS PERFORMING ARTS CENTER CAPITAL 379,010.46 199.99 399.98 642.71 0.00 0.00 379,453.18 0.00379,453.180.00450 PALAIS ROYALE HISTORIC PRESERVATION 129,405.49 1,866.20 0.00 227.75 0.00 0.00 131,499.44 0.00131,499.440.00451 2018 FIRE STATION #9 CAPITAL 3,502,969.41 0.00 572,506.90 6,186.27 0.00 0.00 2,936,648.78 0.002,936,648.780.00452 2018 TIF PARK BOND CAPITAL 10,429,339.87 0.00 50,312.55 18,672.22 0.00 0.00 10,397,699.54 0.0010,397,699.540.00471 2017 PARKS BOND CAPITAL 12,975,702.85 0.00 509,634.79 23,311.35 0.00 0.00 12,489,379.41 0.0012,489,379.410.00677 HALL OF FAME CAPITAL FUND 425,527.52 0.00 0.00 754.32 0.00 0.00 426,281.84 0.00426,281.840.00750 EQUIPMENT / VEHICLE LEASING 2,942,040.26 0.00 0.00 3.99 0.00 0.00 2,942,044.25 0.002,942,044.250.00Month of: January 20192019-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 2019751 2015 PARKS BOND CAPITAL 471,687.11 0.00 0.00 0.00 0.00 0.00 471,687.11 0.00471,687.110.00753 SMART STREET BOND CAPITAL 68,842.83 0.00 0.00 0.00 0.00 0.00 68,842.83 0.0068,842.830.00759 EDDY ST COMMONS CAPITAL 7,650,244.25 0.00 0.00 0.00 0.00 0.00 7,650,244.25 0.007,650,244.250.00Total Capital & Debt Service Funds47,847,203.91 5,852.43 2,180,889.75 56,203.37 0.00 0.00 45,728,369.960.0045,728,369.962,781,424.34Enterprise Funds287 EMS CAPITAL 4,109,519.34 0.00 164,050.25 7,324.71 0.00 202,750.003,750,043.80 0.003,750,043.800.00288 EMS OPERATING 1,961,341.13 447,135.93 455,268.24 4,577.73 0.00 0.00 1,957,786.55 0.001,957,786.550.00600 CONSOLIDATED BUILDING DEPARTMENT 2,097,306.56 128,864.36 346,683.00 3,825.14 0.00 0.00 1,883,313.06 0.001,883,313.060.00601 PARKING GARAGES 1,329,185.37 104,170.40 162,012.06 2,321.93 0.00 0.00 1,273,665.64 0.001,273,665.640.00610 SOLID WASTE OPERATIONS 526,852.94 401,517.00 337,478.86 882.53 0.00 332,860.00 258,913.61 0.00258,913.610.00611 SOLID WASTE CAPITAL 44,603.03 0.00 185,116.08 78.61 332,860.00 0.00 192,425.56 0.00192,425.560.00620 WATER WORKS OPERATIONS 4,629,470.44 1,486,238.77 1,361,374.36 6,983.99 10,426.62 663,635.00 4,108,110.46 0.004,108,110.460.00622 WATER WORKS CAPITAL 1,892,831.71 2,139.50 38,597.50 3,444.73 270,083.00 0.00 2,129,901.44 0.002,129,901.440.00624 WATER WORKS CUSTOMER DEPOSIT 1,506,991.98 9,913.55 11,746.88 2,663.65 0.00 2,663.65 1,505,158.65 0.001,505,158.650.00625 WATER WORKS SINKING FUND 1,730,278.50 0.00 1,715,666.93 3,040.56 168,000.00 3,040.56 182,611.57 0.00182,611.570.00626 WATER WORKS BOND RESERVE 1,426,312.77 0.00 0.00 2,476.21 0.00 0.001,428,788.98 0.001,428,788.980.00629 WATER WORKS RESERVE - O & M 2,670,169.40 0.00 0.00 4,722.41 225,552.00 4,722.41 2,895,721.40 0.002,895,721.400.00640 SEWER REPAIR INSURANCE 2,019,717.98 51,119.71 27,271.84 3,545.140.00 0.00 2,047,110.99 0.002,047,110.990.00641 SEWAGE WORKS OPERATIONS 15,201,614.77 2,776,120.29 2,153,243.2225,221.05 9,548.71 1,266,629.50 14,592,632.10 0.0014,592,632.100.00642 SEWAGE WORKS CAPITAL 9,122,982.88 6,183.00 344,225.50 16,265.55 425,000.00 0.00 9,226,205.93 0.009,226,205.930.00643 SEWAGE WORKS RESERVE - O & M 5,399,084.29 0.00 0.00 9,548.71 151,717.00 9,548.71 5,550,801.29 0.005,550,801.290.00649 SEWAGE WORKS BOND SINKING 966,029.57 0.00 1,100.00 1,699.32 648,400.00 0.00 1,615,028.89 0.001,615,028.890.00653 SEWAGE WORKS DEBT SERVICE RESERVE 4,204,245.69 0.00 0.00 0.00 0.00 0.00 4,204,245.69 0.004,204,245.690.00670 CENTURY CENTER 1,533,008.68 818,212.99 198,940.52 0.00 0.00 0.00 2,152,281.15 0.002,152,281.150.00671 CENTURY CENTER CAPITAL 857,363.22 0.00 0.00 1,092.93 0.00 0.00 858,456.15 0.00858,456.150.00672 CENTURY CENTER ENERGY SAVINGS 170,608.97 0.00 0.00 223.43 0.00 0.00 170,832.40 0.00170,832.400.00Total Enterprise Funds63,399,519.22 6,231,615.50 7,502,775.24 99,938.33 2,241,587.33 2,485,849.83 61,984,035.31 0.0061,984,035.310.00Internal Service Funds222 CENTRAL SERVICES 1,005,873.01 1,101,505.63 1,071,999.81 1,122.420.00 0.00 1,036,501.25 0.001,036,501.250.00224 CENTRAL SERVICES CAPITAL 168,606.35 0.00 14,260.44 302.48 0.00 0.00 154,648.39 0.00154,648.390.00226 LIABILITY INSURANCE 3,705,795.64 340,986.00 163,212.44 6,669.54 0.00 0.00 3,890,238.74 0.003,890,238.740.00278 TAKE HOME VEHICLE POLICE 750,703.08 320.00 0.00 1,325.43 0.00 0.00752,348.51 0.00752,348.510.00279 IT / INNOVATION / 311 CALL CENTER 2,765,025.22 679,854.90 1,101,185.91 5,117.70 0.00 0.00 2,348,811.91 0.002,348,811.910.00711 SELF-FUNDED EMPLOYEE BENEFITS 12,026,306.80 1,114,143.21 1,561,378.25 21,857.80 0.00 0.00 11,600,929.56 0.0011,600,929.560.00713 UNEMPLOYMENT COMP FUND 209,022.98 0.00 0.00 369.15 0.00 0.00 209,392.13 0.00209,392.130.00714 PARENTAL LEAVE FUND 51,250.77 12,711.24 12,059.09 91.89 0.00 0.00 51,994.81 0.0051,994.810.00Total Internal Service Funds20,682,583.85 3,249,520.98 3,924,095.94 36,856.41 0.00 0.00 20,044,865.30 0.0020,044,865.300.00Trust & Agency Funds701 FIREFIGHTERS PENSION 315,853.25 0.00 367,448.83 1,127.86 0.00 0.00(50,467.72)0.00(50,467.72)0.00702 POLICE PENSION 947,846.37 59.06 514,919.42 2,464.90 0.00 0.00 435,450.91 0.00435,450.910.00709 PAYROLL FUND 0.00 8,113,267.05 8,979,554.46 0.00 0.00 0.00(866,287.41)0.00(866,287.41)0.00718 STATE TAX DEDUCTION FUND 324,526.47 281,924.40 360,981.86 0.00 0.00 0.00 245,469.01 0.00245,469.010.00725 MORRIS / PALAIS BOX OFFICE 2,226,914.44 89,438.83 0.00 0.00 0.00 0.00 2,316,353.27 0.002,316,353.270.00726 POLICE DISTRIBUTIONS PAYABLE 838,526.17 0.00 0.00 0.00 0.00 0.00 838,526.17 0.00838,526.170.00730 CITY CEMETERY TRUST 28,986.65 0.00 0.00 51.19 0.00 0.00 29,037.84 0.0029,037.840.00731 BOWMAN CEMETERY 455,997.61 0.00 0.00 805.79 0.00 0.00 456,803.40 0.00456,803.400.00Total Trust & Agency Funds5,138,650.96 8,484,689.34 10,222,904.57 4,449.74 0.00 0.00 3,404,885.47 0.003,404,885.470.00Total City Funds243,116,036.94 23,527,519.35 34,412,192.62 362,663.90 3,071,587.33 2,549,493.70 233,116,121.20 73,993.34 233,190,114.54 2,981,424.342019-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 2019Redevelopment Commission Controlled FundsTax Increment Financing Funds324 TIF RIVER WEST 31,738,299.64 235,000.00 3,172,435.24 44,897.23 4,916.58 1,935,487.50 26,915,190.71 0.0026,915,190.71(200,000.00)422 TIF DISTRICT - WEST WASHINGTON 1,801,466.25 0.00 0.00 3,010.12 0.00 0.00 1,804,476.37 0.001,804,476.370.00425 REDEVELOPMENT RETAIL AREA 8,387.78 0.00 0.00 167.31 0.00 0.00 8,555.09 0.008,555.090.00429 TIF RIVER EAST DEV (NE) 10,994,678.14 0.00 12,683.35 17,779.610.00 0.00 10,999,774.40 0.0010,999,774.400.00430 TIF SOUTHSIDE DEVELOPMENT AREA #1 9,455,102.39 0.00 426,683.8516,003.17 0.00 0.00 9,044,421.71 0.009,044,421.710.00435 TIF DOUGLAS ROAD 204,331.47 0.00 0.00 360.86 0.00 0.00 204,692.33 0.00204,692.330.00436 TIF RIVER EAST RES (NE RE) 2,990,020.23 0.00 1,883,253.13 4,478.23 0.00 0.00 1,111,245.33 0.001,111,245.33(2,781,424.34)Total Tax Increment Financing Funds57,192,285.90 235,000.00 5,495,055.57 86,696.53 4,916.58 1,935,487.50 50,088,355.94 0.0050,088,355.94(2,981,424.34)Redevelopment Funds433 REDEVELOPMENT ADMINISTRATION GENERAL 615,794.90 0.00 0.00 1,087.50 0.00 0.00 616,882.40 0.00616,882.400.00439 CERTIFIED TECHNOLOGY PARK 624,203.75 0.00 0.00 1,102.38 0.00 0.00 625,306.13 0.00625,306.130.00454 AIRPORT URBAN ENTERPRISE ZONE 393,651.04 0.00 0.00 695.22 0.00 0.00 394,346.26 0.00394,346.260.00754 INDUSTRIAL REVOLVING FUND 1,632,491.00 0.00 0.00 0.00 0.00 0.00 1,632,491.00 0.001,632,491.000.00Total Redevelopment Funds3,266,140.69 0.00 0.00 2,885.10 0.00 0.00 3,269,025.79 0.003,269,025.790.00Debt Service Funds 315 AIRPORT 2003 DEBT RESERVE 1,040,462.24 0.00 0.00 1,840.14 0.00 1,840.14 1,040,462.24 0.001,040,462.240.00317 COVELESKI BOND DEBT RESERVE 526,587.28 0.00 0.00 929.98 0.00 0.00 527,517.26 0.00527,517.260.00328 SBCDA 2003 DEBT RESERVE 1,739,494.86 0.00 0.00 3,076.44 0.00 3,076.44 1,739,494.86 0.001,739,494.860.00351 2018 TIF PARK BOND DEBT SERVICE RESERVE 993,495.00 0.00 0.00 1,755.58 0.00 0.00 995,250.58 0.00995,250.580.00752 SB REDEVELOPMENT AUTHORITY 210,492.04 0.00 0.00 0.00 0.00 0.00 210,492.04 0.00210,492.040.00756 SMARTS STREETS DEBT SERVICE 1,726,790.10 0.00 0.00 0.00 0.00 0.00 1,726,790.10 0.001,726,790.100.00Total Debt Service Funds6,237,321.52 0.00 0.00 7,602.14 0.00 4,916.58 6,240,007.08 0.006,240,007.080.00Total Redevelopment Commission Funds66,695,748.11 235,000.00 5,495,055.57 97,183.77 4,916.58 1,940,404.08 59,597,388.81 0.00 59,597,388.81(2,981,424.34)City Operations Total309,811,785.05 23,762,519.35 39,907,248.19 459,847.67 3,076,503.91 4,489,897.78 292,713,510.01 73,993.34 292,787,503.35 0.00Memo ItemPooled Investment AccountOpening Interest Accrued Change in Transfer In Transfer out Investment Total Cash &Balance Net of Fees Income Asset Value from Depositoryto DepositoryBalance Investments1st Source Bank Investment Account184,324,597.46 265,281.92 0.00 451,192.13 0.00 292,801.06 184,748,270.45 184,748,270.452019-01 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 Requirement211 DCI Administration Fund 540,634 93,410 447,225 788,167 (340,942) 14% Receives quarterly interfund transfers to cover25% of Annual expenditures222 Central Services 1,036,501 26,473 1,010,028 1,197,546 (187,518) 21% Just under reserve target25% of Annual expenditures, excluding utility accounting406 Cumulative Capital Development 419,340 380,053 39,287 204,530 (165,243) 5% Encumbrances reflect total annual debt payments25% of Annual expenditures610 Solid Waste Operations 258,914 705,250 (446,336) 552,998 (999,334) -8% High encumbrances10% of Annual expenditures701 Firefighters Pension (50,468) - (50,468) 511,246 (561,714) -1% Pension payments received in June & Sept10% of Annual expenditures702 Police Pension 435,451 - 435,451 635,590 (200,139) 7% Pension payments received in June & Sept10% of Annual expenditures2,640,372 1,205,185 1,435,187 3,890,077 (2,454,890) Meets or Exceeds Requirement101 General Fund 35,411,429 1,138,258 34,273,171 22,934,842 11,338,329 52% Property tax distribution received in June & Dec35% of Annual expenditures102 Rainy Day Fund 10,483,479 - 10,483,479 9,142,632 1,340,847 3%3% of total expenditures in previous fiscal year, excluding one-time capital expenditures202 Motor Vehicle Highway 7,675,054 1,571,071 6,103,984 3,829,557 2,274,427 40%25% of Annual expenditures201 Parks & Recreation 6,802,853 1,336,924 5,465,929 5,444,236 21,693 25% Property tax distribution received in June & Dec25% of Annual expenditures216 Police State Seizures 227,605 - 227,605 8,000 219,605 711%25% of Annual expenditures218 Police Curfew Violations 13,132 - 13,132 250 12,882 1313%25% of Annual expenditures219 Unsafe Building 514,056 193,086 320,970 260,859 60,111 31%25% of Annual expenditures220 Law Enforce. Continuing Education 349,440 13,325 336,115 129,387 206,728 65%25% of Annual expenditures226 Liability Insurance 3,890,239 281,917 3,608,322 2,078,828 1,529,494 87%50% of Annual expenditures249 Public Safety L.O.I.T. 2,234,802 - 2,234,802 685,324 1,549,478 26% 8% of Annual expenditures - one month reserve251 Local Roads & Streets 4,044,598 1,161,209 2,883,390 1,733,678 1,149,712 42%25% of Annual expenditures258 Human Rights - Federal Grant 530,717 - 530,717 58,747 471,970 226%25% of Annual expenditures273 Morris PAC/Palais Royale Marketing 57,580 - 57,580 7,500 50,080 192%25% of Annual expenditures274 Morris PAC/Self-Promotion 101,899 - 101,899 18,750 83,149 136%25% of Annual expenditures278 Take Home Vehicle Police 752,349 - 752,349 750,000 2,349 1505%Set dollar amount of $750,000287 EMS Capital 3,750,044 1,453,024 2,297,020 875,569 1,421,451 66%25% of Annual expenditures288 EMS Operating 1,957,787 148,222 1,809,564 1,607,667 201,897 28%25% of Annual expenditures289 HAZMAT 18,590 - 18,590 2,618 15,972 178%25% of Annual expenditures291 Indiana River Rescue 186,936 1,736 185,200 27,580 157,620 168%25% of Annual expenditures294 Regional Police Academy 101,114 - 101,114 5,625 95,489 449%25% of Annual expenditures299 Police Federal Drug Enforcement 154,201 22,499 131,702 12,750 118,952 258%25% of Annual expenditures315 Airport 2003 Debt Reserve 1,040,462 - 1,040,462 1,040,462 - 100%100% debt service reserve per bond covenants317 Coveleski Bond Debt Reserve 527,517 - 527,517 527,517 - 100%100% debt service reserve per bond covenants328 SBCDA 2003 Debt Reserve 1,739,495 - 1,739,495 1,739,495 - 100%100% debt service reserve per bond covenants324 River West TIF (Airport TIF) 26,915,191 8,466,636 18,448,554 6,121,238 12,327,316 75%25% of Annual expenditures351 2018 TIF Park Bond Debt Svc Reserve 995,251 - 995,251 - 995,251 100% 100% debt service reserve per bond covenants404 County Option Income Tax 12,508,267 2,936,742 9,571,525 7,472,727 2,098,798 64%50% of Annual expenditures407 Cumulative Capital Improvement 448,525 - 448,525 7,000 441,525 1602%25% of Annual expenditures408 Economic Development Income Tax 15,611,434 4,707,295 10,904,139 7,085,351 3,818,788 77%50% of Annual expenditures416 Morris Performing Arts Center Capital 379,453 23,684 355,769 56,366 299,403 158%25% of Annual expenditures422 TIF District - West Washington 1,804,476 795,130 1,009,346 423,783 585,563 60%25% of Annual expenditures425 Redevelopment Retail Area 8,555 - 8,555 - 8,555 100%25% of Annual expenditures429 River East Dev TIF (Northeast TIF) 10,999,774 5,090,089 5,909,685 2,550,496 3,359,189 58%25% of Annual expenditures430 TIF Southside Development Area #1 9,044,422 1,474,376 7,570,045 1,263,182 6,306,863 150%25% of Annual expenditures433 Redev Administration General 616,882 - 616,882 268,500 348,382 57%25% of Annual expenditures435 TIF - Douglas Road 204,692 - 204,692 - 204,692 100%10% of Annual expenditures436 River East Residential (Ne Res TIF) 1,111,245 - 1,111,245 1,068,750 42,495 26%25% of Annual expenditures450 Palais Royale Historic Preservation 131,499 36,967 94,532 27,992 66,540 84%25% of Annual expenditures600 Consolidated Building Department 1,883,313 273,782 1,609,531 1,192,076 417,455 34%25% of Annual expenditures601 Parking Garages 1,273,666 48,190 1,225,475 476,646 748,829 64%25% of Annual expenditures620 Water Works Operations 4,108,110 2,023,906 2,084,205 1,140,646 943,559 9%5% of Annual expenditures624 Water Works Customer Deposit 1,505,159 - 1,505,159 1,505,159 - 100%100% cash reserves for customer deposits625 Water Works Sinking Fund 182,612 2,014,541 (1,831,930) (1,831,930) - 100% Encumbrances reflect total annual debt payments100% cash reserves per bond covenants626 Water Works Bond Reserve 1,428,789 - 1,428,789 1,428,789 - 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,047,111 22,961 2,024,150 165,797 1,858,353 305%25% of Annual expenditures641 Sewage Works Operations 14,592,632 6,440,517 8,152,115 2,307,147 5,844,968 18%5% of Annual expenditures643 Sewage Works Reserve - O & M 5,550,801 - 5,550,801 5,537,667 13,134 17% 16.67% of annual operating expenses in Fund 641, net of transfers649 Sewage Works Bond Sinking 1,615,029 7,773,226 (6,158,197) (6,158,197) - 100% Encumbrances reflect total annual debt payments100% cash reserves per bond covenantsJanuary 31, 20192019-01 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 PolicyJanuary 31, 2019653 Sewage Works Debt Service Reserve 4,204,246 - 4,204,246 4,204,246 - 100%100% cash reserves per bond covenants and Crowe Horwath655 Project Releaf 624,456 - 624,456 168,741 455,715 93%25% of Annual expenditures670 Century Center 2,152,281 31,162 2,121,119 1,127,471 993,648 47%25% of Annual expenditures671 Century Center Capital 858,456 - 858,456 800,000 58,456 4292%$800,000 Minimum per Board of Managers705 Police K-9 Unit 2,339 - 2,339 505 1,834 116%25% of Annual expenditures711 Self-Funded Employee Benefits 11,600,930 1,272,331 10,328,598 4,155,747 6,172,851 62%25% of Annual expenditures713 Unemployment Comp Fund 209,392 - 209,392 17,500 191,892 299%25% of Annual expenditures714 Parental Leave Fund 51,995 - 51,995 38,924 13,071 33%25% of Annual expenditures718 State Tax Withholding Fund 245,469 - 245,469 245,469 - 100%100% cash reserves - trust & agency funds725 Morris / Palais Box Office 2,316,353 - 2,316,353 2,316,353 - 100%100% cash reserves - trust & agency funds726 Police Distributions Payable 838,526 - 838,526 838,526 - 100%100% cash reserves - trust & agency funds730 City Cemetery Trust 29,038 - 29,038 - 29,038 100%25% of Annual expenditures731 Bowman Cemetery 456,803 - 456,803 400,000 56,803 100%$400,000 minimum752 South Bend Redevelopment Authority 210,492 - 210,492 210,492 - 100%100% cash reserves per bond covenants753 Smart Street Bond Capital 68,843 - 68,843 68,843 - 100%100% cash reserves per bond covenants755 South Bend Building Corporation 791,026 - 791,026 791,026 - 100%100% cash reserves per bond covenants756 Smart Streets Debt Service Fund 1,726,790 - 1,726,790 1,726,790 - 100%100% cash reserves per bond covenants757 2015 Parks Bond Debt Service 560,431 - 560,431 560,431 - 100%100% cash reserves per bond covenants760 Eddy St. Commons Debt Service 3,452,908 - 3,452,908 2,500,000 952,908 266%$2,500,000 minimum230,828,760 50,752,807 180,075,952 108,081,344 71,994,608 No Reserve Requirement209 Studebaker/Oliver Revitalizing Grants 901,558 199,351 702,207 - 702,207 100%No reserve requirement - Grant fund - spend down to zero210 DCI State Grants 134,336 153,010 (18,674) - (18,674) 100% To be reimbursed by grant receiptsNo reserve requirement - Grant fund - spend down to zero212 DCI Grant Fund 260,176 2,557,977 (2,297,802) - (2,297,802) 100% To be reimbursed by grant receiptsNo reserve requirement - Grant fund - spend down to zero217 Gift, Donation, Bequest 706,558 52,894 653,664 - 653,664 100%No reserve requirement221 Landlord Registration 10,148 - 10,148 - 10,148 100%No reserve requirement224 Central Services Capital 154,648 17,607 137,042 - 137,042 100%No reserve requirement - Capital fund - spend down to zero227 Loss Recovery Fund 628,477 47,506 580,971 - 580,971 100%No reserve requirement257 LOIT 2016 Special Distribution 617,923 687,363 (69,440) - (69,440) 100%No reserve requirement265 Local Road & Bridge Grant 330,769 83,291 247,479 - 247,479 100%No reserve requirement - Grant fund - spend down to zero279 IT / Innovation / 311 Call Center 2,348,812 1,707,901 640,911 - 640,911 100% Reimbursed through interfund allocationNo reserve requirement280 Police Block Grants 3,999 - 3,999 - 3,999 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 187,333 45,534 141,799 - 141,799 100%No reserve requirement - Grant fund - spend down to zero312 2017 Parks Bond Debt Service(435,698) 597,758 (1,033,456) - (1,033,456) 100% Property tax distribution received in June & DecNo reserve requirement313 Hall of Fame Debt Service 97,077 - 97,077 - 97,077 100%No reserve requirement377 Professional Sports Development(350,184) - (350,184) - (350,184) 100% Interfund transfer will cover in FebruaryNo reserve requirement401 Coveleski Stadium Capital 73,565 64,622 8,943 - 8,943 100%No reserve requirement - Capital fund - spend down to zero410 Urban Develop Action Grant (UDAG) 25,351 - 25,351 - 25,351 100%No reserve requirement - Grant fund - spend down to zero412 Major Moves Construction 2,777,600 771,236 2,006,365 - 2,006,365 100%No reserve requirement - Capital fund - spend down to zero439 Certified Technology Park 625,306 - 625,306 - 625,306 100%No reserve requirement451 2018 Fire St #9 Capital 2,936,649 2,660,251 276,398 - 276,398 100%No reserve requirement - Bond capital fund - spend down to zero452 2018 TIF Park Bond Capital 10,397,700 3,279,741 7,117,959 - 7,117,959 100%No reserve requirement - Bond capital fund - spend down to zero454 Airport Urban Enterprise Zone 394,346 - 394,346 - 394,346 100%No reserve requirement471 2017 Parks Bond Capital 12,489,379 2,641,409 9,847,971 - 9,847,971 100%No reserve requirement - Bond capital fund - spend down to zero611 Solid Waste Capital 192,426 776,372 (583,946) - (583,946) 100% Receives transfers from Fund 610 as neededNo reserve requirement - Capital fund - spend down to zero622 Water Works Capital 2,129,901 177,121 1,952,780 - 1,952,780 100%No reserve requirement - Capital fund - spend down to zero642 Sewage Works Capital 9,226,206 8,150,109 1,076,097 - 1,076,097 100% Receives transfers from Fund 641 as neededNo reserve requirement - Capital fund - spend down to zero672 Century Center Energy Savings 170,832 415,424 (244,592) - (244,592) 100%No reserve requirement677 Hall of Fame Capital Fund 426,282 3,514 422,768 - 422,768 100%No reserve requirement - Capital fund - spend down to zero750 Equipment/Vehicle Leasing 2,942,044 998,124 1,943,920 - 1,943,920 100% No reserve requirement - Capital lease fund - spend down to zero751 2015 Parks Bond Capital 471,687 25,258 446,429 - 446,429 100% No reserve requirement - Bond capital fund - spend down to zero754 Industrial Revolving Fund 1,632,491 - 1,632,491 - 1,632,491 100%No City reserve requirement; there are program requirements759 Eddy St Commons Capital 7,650,244 - 7,650,244 - 7,650,244 100%No reserve requirement - Bond capital fund - spend down to zero60,184,659 26,113,370 34,071,287 - 34,071,287 City Operations Total 293,653,791 78,071,363 215,582,426 111,971,421 103,611,005 Note: Available Cash is a Fund's cash balance minus any outstanding encumbrances2019-01 Monthly Cash Report7
January 1, 2007 - January 31, 2019
$329,782,565 6/30/2018
$122,056,198 5/31/2007
$213,153,329 --
$294,954,309 --
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-01 Monthly Cash Report 8
January 1, 2007 - January 31, 2019
City of South Bend Cash Balances - All Funds
Enterprise Redevelopment Civil City
Date Total Cash Funds Funds Funds
06/30/15 249,603,497.41 68,746,632.56 70,642,566.10 110,214,298.75
07/31/15 236,381,857.01 70,884,051.33 65,048,413.67 100,449,392.01
08/31/15 228,483,356.31 72,023,119.13 61,042,169.83 95,418,067.35
09/30/15 234,514,964.30 75,617,268.98 59,936,471.64 98,961,223.68
10/31/15 230,114,056.20 77,155,814.42 56,339,743.69 96,618,498.09
11/30/15 222,277,823.00 75,987,100.36 54,715,027.81 91,575,694.83
12/31/15 228,782,505.24 64,215,673.59 61,194,710.47 103,372,121.18
01/31/16 217,346,607.43 65,062,377.54 55,690,681.11 96,593,548.78
02/29/16 213,873,714.80 67,564,110.56 53,548,676.30 92,760,927.94
03/31/16 211,205,005.30 69,211,164.87 53,434,486.66 88,559,353.77
04/30/16 207,587,385.26 69,616,174.97 51,317,725.09 86,653,485.20
05/31/16 206,530,605.82 69,399,868.04 50,296,085.76 86,834,652.02
06/30/16 249,745,397.89 68,720,691.90 64,433,239.06 116,591,466.93
07/31/16 236,139,560.82 69,227,392.30 58,518,600.58 121,999,405.01
08/31/16 229,469,472.57 67,673,880.42 55,966,718.35 105,828,873.80
09/30/16 231,252,737.44 69,398,336.63 55,065,472.04 106,788,928.77
10/31/16 224,757,043.80 68,809,369.21 52,059,580.89 103,888,093.70
11/30/16 210,677,437.29 61,451,803.84 51,222,578.99 98,003,054.46
12/31/16 234,529,325.24 58,486,210.11 60,406,691.98 115,636,423.15
01/31/17 237,205,923.15 58,517,537.99 54,709,591.50 123,978,793.66
02/28/17 242,890,155.89 60,687,347.41 60,693,512.64 121,509,295.84
03/31/17 233,258,187.04 62,502,426.31 54,200,785.07 116,554,975.66
04/30/17 227,611,544.94 63,062,862.44 53,618,489.08 110,930,193.42
05/31/17 222,671,842.56 62,923,609.40 50,870,962.23 108,877,270.93
06/30/17 264,329,452.56 62,218,464.08 64,818,554.92 137,292,433.56
07/31/17 254,200,729.74 63,518,960.13 59,955,849.53 130,725,920.08
08/31/17 252,059,534.11 64,818,240.75 60,726,084.24 126,515,209.12
09/30/17 277,635,581.14 66,236,471.94 57,532,562.70 153,866,546.50
10/31/17 269,348,596.25 66,667,885.35 55,546,746.25 147,133,964.65
11/30/17 258,560,219.00 59,754,036.10 55,251,426.66 143,554,756.24
12/31/17 291,289,923.15 57,620,088.62 65,818,514.83 167,851,319.70
01/31/18 282,785,943.66 59,858,871.62 60,435,599.30 162,491,472.74
02/28/18 276,155,955.04 58,423,954.94 58,919,560.09 158,812,440.01
03/31/18 274,783,580.98 60,255,912.54 56,967,800.25 157,559,868.19
04/30/18 280,256,559.54 61,537,542.97 70,308,595.71 148,410,420.86
05/31/18 280,820,481.43 62,676,079.74 69,433,440.38 148,710,961.31
06/30/18 329,782,564.72 62,779,584.12 81,992,642.55 185,010,338.05
07/31/18 317,008,229.34 64,079,751.06 78,753,842.27 174,174,636.01
08/31/18 308,391,385.21 65,896,576.77 73,401,834.82 169,092,973.62
09/30/18 306,023,826.98 67,628,081.52 70,934,670.78 167,461,074.68
10/31/18 297,350,750.07 70,191,910.88 58,183,703.49 168,975,135.70
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
2019-01 Monthly Cash Report 9
$83,296,822 1/31/2013
$28,657,187 1/1/2007
$58,335,725 --
$62,743,715 --
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
09/30/10 40,245,656.32 12/31/14 61,623,499.90
10/31/10 39,984,803.80 01/31/15 61,585,040.94
11/30/10 35,695,100.47 02/28/15 63,269,776.69
12/31/10 41,300,042.16 03/31/15 64,288,370.38
01/31/11 42,918,366.28 04/30/15 65,430,174.18
02/28/11 44,793,554.36 05/31/15 65,714,228.05
Note: Cash goes down in June and at
year-end due to the timing of debt service
payments. Debt service payments for
Wastewater are paid out twice a year:
interest in June and principal and interest
in November. Debt service payments for
Water Works are paid out twice a year:
interest in June and principal and interest
in December.
The total cash has been declining as bond
funds are spent down.
In March 2017, the Utility Commission
approved a water rate increase in two
phases: phase 1 - 22% over 12 months,
phase 2 - 22% over 12 months. The
increase was added starting with April
2017 billing. Water Works expects to see
increase in cash in May 2017, when they
begin collecting on April billing.
City of South Bend Cash Balances - Enterprise Funds
January 1, 2007 - January 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-01 Monthly Cash Report 10
$81,992,643 6/30/2018
$26,731,149 1/31/2009
$49,641,426 --
$66,749,772 --
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
09/30/10 52,832,007.68 12/31/14 65,903,128.76
10/31/10 51,745,774.22 01/31/15 60,387,162.56
11/30/10 49,573,730.89 02/28/15 58,990,110.88
12/31/10 65,164,721.07 03/31/15 58,654,868.03
01/31/11 57,392,911.65 04/30/15 57,972,838.77
02/28/11 53,822,791.88 05/31/15 57,630,884.95
Note: TIF property tax distributions
are received in June and December.
Cash goes down in May and
November due to the timing of debt
service payments.
April 2018, Redevelopment District
Bonds totaling $11,995,000 were
issued for parks improvements to be
repaid by TIF Fund 324.
City of South Bend Cash Balances - Redevelopment Funds
January 1, 2007 - January 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-01 Monthly Cash Report 11
$185,010,338 6/30/2018
$53,052,887 5/31/2007
$105,306,026 --
$165,843,108 --
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
09/30/10 118,416,709.45 12/31/14 112,281,466.37
10/31/10 112,912,072.36 01/31/15 103,499,061.06
11/30/10 113,513,586.86 02/28/15 99,594,218.25
12/31/10 121,274,488.95 03/31/15 92,334,813.71
01/31/11 113,796,557.05 04/30/15 89,927,304.71
02/28/11 109,647,280.68 05/31/15 86,034,381.75
Note: Property tax collections are
received in June and December.
Effective January 1, 2017, a total of
eight (8) funds with trustee cash
balances were included in the City's
formal accounting system,
signficantly increasing Civil City cash.
Also, bond proceeds received during
2017, totaling $43.4 million,
increased cash.
City of South Bend Cash Balances - Civil City Funds
January 1, 2007 - January 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-01 Monthly Cash Report 12