HomeMy WebLinkAbout2018-09 - Monthly Cash ReportPeriod Ending:
Issued by:
Page Number(s) Contents
2 Narrative
3 - 5 Controller's Cash Report
6 - 8 Cash Reserves Summary by Fund Status
9 - 10 Cash Trends - All Funds
11 Cash Trends - Enterprise Funds
12 Cash Trends - Redevelopment Funds
13 Cash Trends - Civil City Funds
Distribution
Mayor Pete Buttigieg
Chief of Staff Laura O'Sullivan
Deputy Chief of Staff Suzanna Fritzberg
Common Council
Department Heads
Fiscal Officers
September 30, 2018
Controller
City of South Bend
Monthly Cash Report
Monthly Cash Report 09-2018 1
September 2018 Highlights:
Questions
If you should have additional questions, please contact the Department of Administration & Finance by calling 311.
Narrative
Fiscal Responsibility
The City’s management team is responsible for establishing and maintaining an internal control structure designed to ensure that the assets of the City are
protected from loss, theft, or misuse and to ensure that adequate accounting data is compiled to allow for the preparation of financial statements in conformity
with generally accepted accounting principles.
Controller's Cash Report (pages 3-5)
The Controller’s Cash Report is a monthly summary of cash and investment transactions within the current period by Fund. It summarizes the cash received,
interest earned, cash disbursed, and cash transferred between Funds within the City of South Bend as well as any loans between Funds. The report provides a
month-end view of the City’s cash balance in the reporting period.
Cash Reserves Summary (pages 6-8)
The purpose of the Cash Reserves Summary Report is keep track of whether the City's funds are meeting their cash reserve requirement. Cash reserve
requirements are set for each fund by the City of South Bend or other governing body (e.g. bond counsel, Century Center Board of Managers).
Cash Trends Summary (pages 9-13)
The purpose of the Cash Trends Summary is to track trends in cash balances for the City of South Bend over an extended period of time, from January 1, 2007
through the present date. Charts and graphs for the cash balances are provided in four areas--total cash, enterprise fund cash, redevelopment fund cash, and
civil city fund cash.
Cash Reserve Requirements
Cash reserve requirements are typically based on fund type.
- Most City funds are assigned a cash reserve requirement of a percentage of the fund's annual expenditures.
- The Rainy Day Fund 102 has a reserve requirement of 3% of the City's prior year expenditures.
- Some funds have a set dollar amount as the reserve requirement, such as the Police Take Home Vehicle Fund 278 and the Century Center Capital Fund 671.
- Capital project funds, grant funds, and bond capital funds do not have reserve requirements as they are spent down to zero.
- The IT/Innovation/311 Call Center Fund 279 does not have a reserve requirement because it is an internal service fund, reimbursed by departments within
other City funds. Its budgeted revenues are equal to its budgeted expenditures.
- Debt service reserve funds are required to hold all reserves until the respective debt has been paid in full. The amount is often defined in bond covenants.
Pooled Cash
The City utilities pooled cash, the majority of the City's money being held in a single bank account. Although the money is in a single account, each fund retains
ownership of its own cash. Any interest earned on the bank account is distributed amongst the funds based on each funds' cash balance.
Trustee Cash
The City also has cash maintained by trustee financial institutions and expended upon the provision by the City of a proper claim form and invoice. These funds
are typically for debt service payments, debt service reserves, or capital project expenditures.
Changes in Cash Balance
Property taxes are received in June and December of each year and this will cause the cash balances to fluctuate for total cash, redevelopment fund cash and
civil city fund cash. Enterprise fund cash balances will fluctuate based on the receipt of bond proceeds and the spending down of cash on capital projects.
Redevelopment fund cash accounts will vary based on capital spending on projects in tax increment financing (TIF) funds.
Negative Cash Balances
Due to the timing of revenue and expenditures, certain funds will not meet cash reserve requirements and may even have a negative cash balance at different
times throughout the year. Although a fund has a negative cash balance, the City does not have negative cash overall. Pooled cash can cover those funds so
necessary expenditures can be made even if revenues have not been received yet.
General Fund 101 & Redevelopment General Fund 433: The City received a donation in the amount of $1,214,603 from the Pokagon Band of the
Potawatomi, a Native American tribe. The tribe built Four Winds Casino on tribal land adjacent to the City. This donation was split 50/50 between Fund 101 and
Fund 433.
Fire Pension Fund 701 and Police Pension Fund 702: The City received its second biannual disbursement from the State in the amount of $5,346,563.
Parks & Recreation Fund 201: Cash receipts will decrease in the fall and winter with the end of the summer recreational activities and the closure of the golf
courses.
Fund 312, 313, 377, and 709 have negative cash balances.
- The 2017 Parks Bond Debt Service Fund 312 receives property tax revenue in June and December, but still has to make a debt payments in January and
July. When property tax revenue is received in December, this fund won't be negative.
- The Hall of Fame Debt Service Fund 313 receives property tax revenue in June and December, but still had to make the final debt payment for the Hall of
Fame Bonds in January. When property tax revenue is received in December, this fund won't be negative.
- The Professional Sports Development Area Fund 377 hasn't received its PSDA revenue yet, but still had to make debt payments in January and July.
- The Payroll Fund 709 has a negative balance due to checks that were voided and reissued. Adjustments will be made in October to correct it.
Monthly Cash Report 09-2018 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 $33,143,826.07 $1,671,173.47 $4,853,267.96 $61,827.84 $0.00 $0.00 $30,023,559.42 $0.00$30,023,559.42$425,095.11Special Revenue Funds102 RAINY DAY FUND 10,391,692.96 0.00 0.00 18,857.55 0.00 0.00 10,410,550.51 0.0010,410,550.510.00201 PARKS & RECREATION 5,419,736.01 278,375.26 980,970.43 10,994.70321,900.00 0.00 5,050,035.54 0.005,050,035.540.00202 MOTOR VEHICLE HIGHWAY 8,022,705.24 596,194.28 686,871.50 14,705.42 946,937.50 0.00 8,893,670.94 0.008,893,670.940.00203 RECREATION - NONREVERTING 880,030.80 60,727.20 69,642.03 1,603.97 0.00 0.00 872,719.94 0.00872,719.940.00209 STUDEBAKER/OLIVER REVERTING GRANTS 962,956.52 0.00 15,026.24 1,751.33 0.00 0.00 949,681.61 0.00949,681.61200,000.00210 DEPT COMMUNITY INVESTMENT STATE GRANTS 361,142.19 16,458.67 18,002.61 2,199.30 0.00 0.00 361,797.55 0.00361,797.550.00211 DCI OPERATING FUND 539,274.47 44,337.61 261,902.31 1,085.37 466,505.00 0.00 789,300.14 0.00789,300.140.00212 DEPARTMENT OF COMMUNITY INVESTMENT 392,537.13 40,118.24 321,499.66 82.71 0.00 0.00 111,238.42 0.00111,238.420.00216 POLICE STATE SEIZURES 207,208.25 26,099.55 2,052.91 375.03 0.00 0.00 231,629.92 0.00231,629.920.00217 GIFT, DONATION, BEQUEST 142,401.41 434.80 7,790.70 258.81 0.00 0.00 135,304.32 0.00135,304.320.00218 POLICE CURFEW VIOLATIONS 13,606.79 0.00 0.00 24.71 0.00 0.00 13,631.50 0.0013,631.500.00219 UNSAFE BUILDING 443,741.45 25,640.04 69,932.18 828.79 162,068.25 0.00 562,346.35 0.00562,346.350.00220 LAW ENFORCEMENT CONTINUING EDUCATION 569,749.84 17,657.71 30,800.78 1,020.40 0.00 0.00 557,627.17 0.00557,627.170.00221 LANDLORD REGISTRATION 10,059.08 0.00 0.00 18.26 0.00 0.00 10,077.340.0010,077.340.00227 LOSS RECOVERY FUND 700,243.03 0.00 10,149.08 1,270.71 0.00 0.00 691,364.66 0.00691,364.660.00249 PUBLIC SAFETY L.O.I.T. 1,797,562.84 636,704.92 578,943.54 2,672.21 0.00 0.00 1,857,996.43 0.001,857,996.430.00251 LOCAL ROADS & STREETS 4,023,487.89 205,708.01 316,352.47 7,579.69 0.00 0.00 3,920,423.12 0.003,920,423.120.00257 LOIT 2016 SPECIAL DISTRIBUTION 2,429,229.59 0.00 121,273.17 4,421.48 0.00 1,340,000.00 972,377.90 0.00972,377.900.00258 HUMAN RIGHTS - FEDERAL GRANT 543,951.52 5,496.70 82,592.07 876.90 0.00 0.00 467,733.05 69,782.00537,515.050.00265 LOCAL ROAD & BRIDGE GRANT(709,269.00)0.00 0.00 0.00 1,340,000.00 0.00 630,731.00 0.00630,731.000.00273 MORRIS PAC/PALAIS ROYALE MARKETING 61,891.56 0.00 2,225.33 109.03 0.00 0.00 59,775.26 0.0059,775.260.00274 MORRIS PAC SELF-PROMOTION 68,516.80 0.00 0.00 122.04 0.00 0.00 68,638.84 0.0068,638.840.00280 POLICE BLOCK GRANTS 3,964.47 0.00 0.00 7.20 0.00 0.00 3,971.67 0.003,971.670.00281 DEPT. COMMUNITY INVESTMENT - REV BONDS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.000.00289 HAZMAT 24,127.11 0.00 0.00 44.40 0.00 0.00 24,171.51 0.0024,171.510.00291 INDIANA RIVER RESCUE 172,765.77 6,352.00 1,244.56 315.01 0.00 0.00178,188.22 0.00178,188.220.00292 POLICE GRANTS 26,715.50 0.00 0.00 0.00 0.00 0.00 26,715.50 0.0026,715.500.00294 REGIONAL POLICE ACADEMY 99,564.71 0.00 465.13 180.48 0.00 0.00 99,280.06 0.0099,280.060.00295 COPS MORE GRANT 120,759.33 917.48 6,857.29 217.24 0.00 0.00 115,036.76 0.00115,036.760.00299 POLICE FEDERAL DRUG ENFORCEMENT 145,208.64 0.00 0.00 246.36 0.00 0.00 145,455.00 0.00145,455.000.00404 COUNTY OPTION INCOME TAX 11,695,899.55 909,497.75 792,858.92 20,371.86 0.00 696,900.00 11,136,010.24 0.0011,136,010.24867,317.80408 ECONOMIC DEVELOPMENT INCOME TAX 16,609,201.66 893,413.25 13,322.88 28,749.18 0.00 1,392,430.77 16,125,610.44 0.0016,125,610.440.00410 URBAN DEVELOPMENT ACTION GRANT (UDAG) 405,222.85 0.00 0.00 735.34 0.00 0.00 405,958.19 0.00405,958.19(867,317.80)655 PROJECT RELEAF 809,554.23 32,368.34 12,238.86 1,437.32 0.00 137,500.00 693,621.03 0.00693,621.030.00705 POLICE K-9 UNIT 2,916.47 0.00 0.00 5.29 0.00 0.00 2,921.76 0.002,921.760.00Total Special Revenue Funds67,388,356.66 3,796,501.81 4,403,014.65 123,168.09 3,237,410.75 3,566,830.77 66,575,591.89 69,782.0066,645,373.89200,000.00 Debt Service Fund312 2017 PARKS BOND DEBT SERVICE(187,997.71)0.00 0.00 0.00 0.00 0.00(187,997.71)0.00(187,997.71)0.00313 HALL OF FAME DEBT SERVICE (109,687.50)0.00 0.00 0.00 0.00 0.00(109,687.50)0.00(109,687.50)0.00755 SB BUILDING CORPORATION 1,988,158.49 0.00 1,200,393.75 1,849.55 0.00 0.00 789,614.29 0.00789,614.290.00757 2015 PARKS BOND DEBT SERVICE 588,278.51 31,460.94 188,765.63 386.19 32,031.77 0.00 463,391.78 0.00463,391.780.00760 EDDY ST. COMMONS DEBT SERVICE 2,504,695.73 0.00 0.00 634.74 0.00 0.00 2,505,330.47 0.002,505,330.470.00Capital Project Funds377 PROFESSIONAL SPORTS DEVELOPMENT(783,696.36)0.00 0.00 0.00 0.00 0.00(783,696.36)0.00(783,696.36)0.00401 COVELESKI STADIUM CAPITAL 55,129.42 0.00 0.00 100.04 0.00 0.00 55,229.46 0.0055,229.460.00405 PARK NONREVERTING CAPITAL 107,610.13 27,950.00 3,871.41 86.56 0.00 0.00 131,775.28 0.00131,775.280.00406 CUMULATIVE CAPITAL DEVELOPMENT 428,375.56 0.00 0.00 826.17 0.00 0.00 429,201.73 0.00429,201.730.00407 CUMULATIVE CAPITAL IMPROVEMENT 320,921.45 0.00 0.00 582.39 0.00 0.00 321,503.84 0.00321,503.840.00412 MAJOR MOVES CONSTRUCTION 2,835,125.85 0.00 0.00 5,227.92 0.00 0.002,840,353.77 0.002,840,353.774,208,792.61416 MORRIS PERFORMING ARTS CENTER CAPITAL 400,641.11 0.00 18,050.00724.73 0.00 0.00 383,315.84 0.00383,315.840.00450 PALAIS ROYALE HISTORIC PRESERVATION 123,680.20 0.00 0.00 221.96 0.00 0.00 123,902.16 0.00123,902.160.00451 2018 FIRE STATION #9 CAPITAL 4,692,688.26 0.00 246,464.20 8,584.98 0.00 0.00 4,454,809.04 0.004,454,809.040.00471 2017 PARKS BOND CAPITAL 13,521,614.68 0.00 14,400.00 24,568.50 0.00 0.00 13,531,783.18 0.0013,531,783.180.00677 HALL OF FAME CAPITAL FUND 425,844.83 0.00 1,524.33 774.61 0.00 0.00 425,095.11 0.00425,095.11(425,095.11)Month of: September 2018Monthly Cash Report 09-20183
City of South BendController's Cash ReportOpening Interest Transfers Transfers Ending Total Cash & Interfund LoansFund Fund Name Cash Balance Receipts Disbursements Earned In Out Cash Balance Investments Investments (Borrowing)Month of: September 2018750 EQUIPMENT / VEHICLE LEASING 4,313,358.01 0.00 253,092.00 6,368.50 0.00 0.00 4,066,634.51 0.004,066,634.510.00751 2015 PARKS BOND CAPITAL 1,691,038.27 0.00 8,595.41 430.59 0.00 0.00 1,682,873.45 0.001,682,873.450.00753 SMART STREET BOND CAPITAL 70,265.60 0.00 0.00 17.81 0.00 0.00 70,283.41 0.0070,283.410.00759 EDDY ST COMMONS CAPITAL 12,458,009.90 0.00 1,335,948.49 6.49 0.000.00 11,122,067.90 0.0011,122,067.900.00Total Capital & Debt Service Funds45,444,054.43 59,410.94 3,271,105.22 51,391.73 32,031.77 0.00 42,315,783.65 0.0042,315,783.653,783,697.50Enterprise Funds287 EMS CAPITAL 4,118,844.99 2,315.24 6,430.53 7,572.60 0.00 0.00 4,122,302.30 0.004,122,302.300.00288 EMS OPERATING 2,390,236.71 553,945.59 491,278.37 4,706.20 0.00 0.00 2,457,610.13 0.002,457,610.130.00600 CONSOLIDATED BUILDING DEPARTMENT 2,337,016.07 146,454.27 334,900.85 4,377.59 247,388.25 0.00 2,400,335.33 0.002,400,335.330.00601 PARKING GARAGES 1,355,463.28 86,575.25 142,064.03 2,366.91 0.00 0.00 1,302,341.41 0.001,302,341.41(1,427,141.00)610 SOLID WASTE OPERATIONS 398,438.03 405,065.31 322,667.58 1,041.680.00 233,310.00 248,567.44 0.00248,567.440.00611 SOLID WASTE CAPITAL 2,903.77 0.00 218.38 37.32 233,310.00 0.00 236,032.71 0.00236,032.710.00620 WATER WORKS OPERATIONS 3,323,592.23 1,806,035.43 1,344,299.53 4,852.64 9,468.27 165,595.00 3,634,054.04 0.003,634,054.040.00622 WATER WORKS CAPITAL 1,967,974.81 2,992.50 0.00 3,553.25 0.00 0.00 1,974,520.56 0.001,974,520.560.00624 WATER WORKS CUSTOMER DEPOSIT 1,510,446.63 8,604.26 13,808.36 2,744.70 0.00 2,744.70 1,505,242.53 0.001,505,242.530.00625 WATER WORKS SINKING FUND 1,067,898.50 0.00 0.00 1,872.43 165,595.00 1,872.43 1,233,493.50 0.001,233,493.500.00626 WATER WORKS BOND RESERVE 1,440,127.12 0.00 0.00 2,602.67 0.00 0.001,442,729.79 0.001,442,729.790.00629 WATER WORKS RESERVE - O & M 2,670,169.40 0.00 0.00 4,851.14 0.004,851.14 2,670,169.40 0.002,670,169.400.00640 SEWER REPAIR INSURANCE 1,947,045.96 45,588.84 32,591.46 3,510.430.00 0.00 1,963,553.77 0.001,963,553.770.00641 SEWAGE WORKS OPERATIONS 12,183,533.55 2,736,677.11 1,672,998.6121,153.19 59,809.01 763,031.54 12,565,142.71 0.0012,565,142.710.00642 SEWAGE WORKS CAPITAL 9,922,348.62 17,518.50 148,581.67 18,245.140.00 0.00 9,809,530.59 0.009,809,530.590.00643 SEWAGE WORKS RESERVE - O & M 5,399,084.29 0.00 0.00 9,809.01 0.009,809.01 5,399,084.29 0.005,399,084.290.00649 SEWAGE WORKS BOND SINKING 6,772,620.46 0.00 0.00 11,978.06 763,031.54 0.00 7,547,630.06 0.007,547,630.060.00653 SEWAGE WORKS DEBT SERVICE RESERVE 4,171,231.31 0.00 0.00 6,128.54 0.00 0.00 4,177,359.85 0.004,177,359.850.00670 CENTURY CENTER 1,822,019.78 24,768.99 4,063.40 0.00 0.00 85,909.001,756,816.37 0.001,756,816.370.00671 CENTURY CENTER CAPITAL 855,909.31 0.00 0.00 70.35 0.00 0.00 855,979.66 0.00855,979.660.00672 CENTURY CENTER ENERGY SAVINGS 239,671.95 0.00 0.00 4.13 85,909.000.00 325,585.08 0.00325,585.080.00Total Enterprise Funds65,896,576.77 5,836,541.29 4,513,902.77 111,477.98 1,564,511.07 1,267,122.82 67,628,081.52 0.0067,628,081.52(1,427,141.00)Internal Service Funds222 CENTRAL SERVICES 1,179,337.66 951,520.37 972,879.95 1,026.67 0.0077,000.00 1,082,004.75 0.001,082,004.750.00224 CENTRAL SERVICES CAPITAL 113,446.44 0.00 0.00 205.87 77,000.00 0.00 190,652.31 0.00190,652.310.00226 LIABILITY INSURANCE 3,172,390.26 805,762.52 223,557.62 5,884.27 0.00 0.00 3,760,479.43 0.003,760,479.430.00278 TAKE HOME VEHICLE POLICE 762,193.80 280.00 395.82 1,382.87 0.00 0.00 763,460.85 0.00763,460.850.00279 IT / INNOVATION / 311 CALL CENTER 2,669,211.85 570,619.40 336,082.59 4,473.02 0.00 0.00 2,908,221.68 0.002,908,221.680.00711 SELF-FUNDED EMPLOYEE BENEFITS 11,984,649.12 1,483,701.70 1,449,786.67 22,597.82 0.00 0.00 12,041,161.97 0.0012,041,161.970.00713 UNEMPLOYMENT COMP FUND 208,151.66 0.00 593.96 377.73 0.00 0.00 207,935.43 0.00207,935.430.00714 PARENTAL LEAVE FUND 36,316.12 12,430.70 11,146.24 67.46 0.00 0.00 37,668.04 0.0037,668.040.00Total Internal Service Funds20,125,696.91 3,824,314.69 2,994,442.85 36,015.71 77,000.00 77,000.00 20,991,584.46 0.0020,991,584.460.00Trust & Agency Funds701 FIREFIGHTERS PENSION (445,849.63)2,236,234.37 380,807.30 0.00 0.00 0.00 1,409,577.44 0.001,409,577.440.00702 POLICE PENSION (149,616.74)3,110,403.11 501,552.84 574.00 0.00 0.00 2,459,807.53 0.002,459,807.530.00709 PAYROLL FUND 0.00 8,621,739.42 8,623,181.63 0.00 0.00 0.00(1,442.21)0.00(1,442.21)0.00718 STATE TAX DEDUCTION FUND 277,805.78 282,189.86 277,805.78 0.00 0.00 0.00 282,189.86 0.00282,189.860.00725 MORRIS / PALAIS BOX OFFICE 2,421,627.03 61,353.91 0.00 0.00 0.00 0.00 2,482,980.94 0.002,482,980.940.00726 POLICE DISTRIBUTIONS PAYABLE 858,289.48 0.00 35,465.64 0.00 0.00 0.00 822,823.84 0.00822,823.840.00730 CITY CEMETERY TRUST 28,783.63 0.00 0.00 52.23 0.00 0.00 28,835.86 0.0028,835.860.00Total Trust & Agency Funds2,991,039.55 14,311,920.67 9,818,813.19 626.23 0.00 0.00 7,484,773.260.007,484,773.260.00Total City Funds234,989,550.39 29,499,862.87 29,854,546.64 384,507.58 4,910,953.59 4,910,953.59 235,019,374.20 69,782.00 235,089,156.20 2,981,651.61Monthly Cash Report 09-20184
City of South BendController's Cash ReportOpening Interest Transfers Transfers Ending Total Cash & Interfund LoansFund Fund Name Cash Balance Receipts Disbursements Earned In Out Cash Balance Investments Investments (Borrowing)Month of: September 2018Redevelopment Commission Controlled FundsTax Increment Financing Funds324 TIF RIVER WEST 28,985,853.11 1,081.00 1,660,270.53 54,238.88 5,050.60 0.00 27,385,953.06 0.0027,385,953.06(200,000.00)422 TIF DISTRICT - WEST WASHINGTON 2,290,171.22 0.00 394,811.82 4,155.89 0.00 0.00 1,899,515.29 0.001,899,515.290.00425 REDEVELOPMENT RETAIL AREA 141,114.86 2,954.76 2,929.54 280.19 0.00 0.00 141,420.27 0.00141,420.270.00429 TIF RIVER EAST DEV (NE) 9,512,757.27 0.00 3,859.87 17,368.59 0.00 0.00 9,526,265.99 0.009,526,265.990.00430 TIF SOUTHSIDE DEVELOPMENT AREA #1 8,899,303.73 0.00 22,401.86 16,233.83 0.00 0.00 8,893,135.70 0.008,893,135.700.00435 TIF DOUGLAS ROAD 202,900.22 0.00 0.00 368.19 0.00 0.00 203,268.41 0.00203,268.410.00436 TIF RIVER EAST RES (NE RE) 1,866,530.85 0.00 0.00 0.00 0.00 0.00 1,866,530.85 0.001,866,530.85(2,781,651.61)Total Tax Increment Financing Funds51,898,631.26 4,035.76 2,084,273.62 92,645.57 5,050.60 0.00 49,916,089.57 0.0049,916,089.57(2,981,651.61)Redevelopment Funds433 REDEVELOPMENT ADMINISTRATION GENERAL 35,085.71 607,301.60 1,332.80 63.67 0.00 0.00 641,118.18 0.00641,118.180.00439 CERTIFIED TECHNOLOGY PARK 619,831.41 0.00 0.00 1,124.80 0.00 0.00 620,956.21 0.00620,956.210.00452 2018 TIF PARK BOND CAPITAL 10,752,536.15 0.00 8,163.46 0.00 0.00 0.00 10,744,372.69 0.0010,744,372.690.00454 AIRPORT URBAN ENTERPRISE ZONE 390,893.65 0.00 0.00 709.35 0.00 0.00 391,603.00 0.00391,603.000.00754 INDUSTRIAL REVOLVING FUND 2,780,571.00 7,011.00 251,381.00 12,516.00 0.00 0.00 2,548,717.00 0.002,548,717.000.00Total Redevelopment Funds14,578,917.92 614,312.60 260,877.26 14,413.82 0.00 0.00 14,946,767.080.0014,946,767.080.00Debt Service Funds 315 AIRPORT 2003 DEBT RESERVE 1,040,462.24 0.00 0.00 1,890.30 0.00 1,890.30 1,040,462.24 0.001,040,462.240.00317 COVELESKI BOND DEBT RESERVE 522,898.70 0.00 0.00 948.89 0.00 0.00 523,847.59 0.00523,847.590.00328 SBCDA 2003 DEBT RESERVE 1,739,494.86 0.00 0.00 3,160.30 0.00 3,160.30 1,739,494.86 0.001,739,494.860.00351 2018 TIF PARK BOND DEBT SERVICE RESERVE 993,495.00 0.00 0.00 0.00 0.00 0.00 993,495.00 0.00993,495.000.00752 SB REDEVELOPMENT AUTHORITY 47,536.30 1,846.87 0.00 71.57 0.00 0.0049,454.74 0.0049,454.740.00756 SMARTS STREETS DEBT SERVICE 2,580,398.54 0.00 855,909.38 570.54 0.00 0.00 1,725,059.70 0.001,725,059.700.00Total Debt Service Funds6,924,285.64 1,846.87 855,909.38 6,641.60 0.00 5,050.60 6,071,814.13 0.006,071,814.130.00Total Redevelopment Commission Funds73,401,834.82 620,195.23 3,201,060.26 113,700.99 5,050.60 5,050.60 70,934,670.78 0.00 70,934,670.78(2,981,651.61)City Operations Total308,391,385.21 30,120,058.10 33,055,606.90 498,208.57 4,916,004.19 4,916,004.19 305,954,044.98 69,782.00 306,023,826.98 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,342,003.25 118,508.44 0.00 (129,181.36) 0.00 312,697.14 184,018,633.19 184,018,633.19Monthly Cash Report 09-20185
City of South BendCash Reserves Summary by Fund Status Cash ActualFund Fund NameCash Outstanding Available Reserve % ofBalance Encumb. Cash Requirement Variance Budget Notes Cash Reserve PolicyInsufficient Balances211 DCI Administration Fund 789,300 136,550 652,750 769,274 (116,524) 21% Receives quarterly transfers25% of Annual expenditures222 Central Services 1,082,005 30,628 1,051,377 1,108,172 (56,795) 24% Just under reserve target25% of Annual expenditures, excluding utility accounting610 Solid Waste Operations 248,567 159,643 88,924 549,605 (460,681) 2% High encumbrances10% of Annual expenditures714 Parental Leave Fund 37,668 - 37,668 38,924 (1,256) 24% New fund established 2018, building reserves25% of Annual expenditures2,157,540 326,821 1,830,719 2,465,975 (635,256) Meets or Exceeds Requirements101 General Fund 30,023,559 622,010 29,401,549 21,640,751 7,760,798 48% Property tax distribution received in June & Dec35% of Annual expenditures102 Rainy Day Fund 10,410,551 - 10,410,551 9,745,767 664,784 3%3% of total expenditures in previous fiscal year201 Parks & Recreation 5,050,036 577,271 4,472,764 4,070,515 402,249 27% Property tax distribution received in June & Dec25% of Annual expenditures202 Motor Vehicle Highway 8,893,671 1,440,147 7,453,524 3,098,495 4,355,029 60%25% of Annual expenditures203 Recreation - Nonreverting 872,720 95,572 777,148 435,101 342,047 45%25% of Annual expenditures216 Police State Seizures 231,630 - 231,630 8,000 223,630 724%25% of Annual expenditures218 Police Curfew Violations 13,632 604 13,027 250 12,777 1303%25% of Annual expenditures219 Unsafe Building 562,346 307,700 254,646 243,103 11,543 26%25% of Annual expenditures220 Law Enforce. Continuing Education 557,627 49,239 508,388 148,656 359,732 85%25% of Annual expenditures226 Liability Insurance 3,760,479 213,567 3,546,912 2,196,121 1,350,791 81%50% of Annual expenditures249 Public Safety L.O.I.T. 1,857,996 - 1,857,996 609,838 1,248,158 24% 8% of Annual expenditures - one month reserve251 Local Roads & Streets 3,920,423 406,749 3,513,674 854,627 2,659,047 103%25% of Annual expenditures258 Human Rights - Federal Grant 537,515 8,937 528,578 40,809 487,769 324%25% of Annual expenditures273 Morris PAC/Palais Royale Marketing 59,775 1,606 58,170 4,500 53,670 323%25% of Annual expenditures274 Morris PAC/Self-Promotion 68,639 - 68,639 12,500 56,139 137%25% of Annual expenditures278 Take Home Vehicle Police 763,461 - 763,461 750,000 13,461 7635%Set dollar amount of $750,000287 EMS Capital 4,122,302 224,762 3,897,540 847,433 3,050,107 115%25% of Annual expenditures288 EMS Operating 2,457,610 77,086 2,380,525 1,607,937 772,588 37%25% of Annual expenditures289 HAZMAT 24,172 5,641 18,531 2,500 16,031 185%25% of Annual expenditures291 Indiana River Rescue 178,188 6,093 172,095 25,450 146,645 169%25% of Annual expenditures294 Regional Police Academy 99,280 - 99,280 5,625 93,655 441%25% of Annual expenditures299 Police Federal Drug Enforcement 145,455 22,100 123,355 12,750 110,605 242%25% of Annual expenditures315 Airport 2003 Debt Reserve 1,040,462 - 1,040,462 1,040,462 - 100%100% debt service reserve per bond covenants317 Coveleski Bond Debt Reserve 523,848 - 523,848 523,848 - 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) 27,385,953 9,059,054 18,326,899 12,089,046 6,237,853 38%25% of Annual expenditures351 2018 TIF Park Bond Debt Svc Reserve 993,495 - 993,495 - 993,495 100% 100% debt service reserve per bond covenants404 County Option Income Tax 11,136,010 828,208 10,307,802 6,000,837 4,306,965 86%50% of Annual expenditures405 Park Nonreverting Capital 131,775 23,454 108,321 69,468 38,853 39%25% of Annual expenditures406 Cumulative Capital Development 429,202 - 429,202 114,800 314,402 93%25% of Annual expenditures407 Cumulative Capital Improvement 321,504 - 321,504 69,625 251,879 115%25% of Annual expenditures408 Economic Development Income Tax 16,125,610 614,538 15,511,073 6,107,297 9,403,776 127%50% of Annual expenditures416 Morris Performing Arts Center Capital 383,316 31,550 351,766 46,025 305,741 191%25% of Annual expenditures422 TIF District - West Washington 1,899,515 907,158 992,357 571,479 420,878 43%25% of Annual expenditures425 Redevelopment Retail Area 141,420 - 141,420 39,542 101,878 89%25% of Annual expenditures429 River East Dev TIF (Northeast TIF) 9,526,266 590,957 8,935,309 2,396,923 6,538,386 93%25% of Annual expenditures430 TIF Southside Development Area #1 8,893,136 3,386,317 5,506,819 2,139,007 3,367,812 64%25% of Annual expenditures433 Redev Administration General 641,118 - 641,118 8,150 632,968 1967%25% of Annual expenditures435 TIF - Douglas Road 203,268 4,200 199,068 20,465 178,603 97%10% of Annual expenditures436 River East Residential (Ne Res TIF) 1,866,531 - 1,866,531 1,080,000 786,531 43%25% of Annual expenditures450 Palais Royale Historic Preservation 123,902 31,537 92,365 11,250 81,115 205%25% of Annual expenditures600 Consolidated Building Department 2,400,335 63,312 2,337,023 1,160,813 1,176,210 50%25% of Annual expenditures601 Parking Garages 1,302,341 49,617 1,252,725 313,086 939,639 100%25% of Annual expenditures620 Water Works Operations 3,634,054 646,053 2,988,001 903,514 2,084,487 17%5% of Annual expenditures624 Water Works Customer Deposit 1,505,243 - 1,505,243 1,505,243 - 100%100% cash reserves for customer deposits625 Water Works Sinking Fund 1,233,494 - 1,233,494 1,233,494 - 100%100% cash reserves per bond covenants626 Water Works Bond Reserve 1,442,730 - 1,442,730 1,442,730 - 100%100% cash reserves per bond covenants and Crowe Horwath629 Water Works Reserve - O & M 2,670,169 - 2,670,169 2,670,169 - 16.67% 16.67% of annual operating expenses in Fund 620, net of transfersSeptember 30, 2018Monthly Cash Report 09-20186
City of South BendCash Reserves Summary by Fund Status Cash ActualFund Fund NameCash Outstanding Available Reserve % ofBalance Encumb. Cash Requirement Variance Budget Notes Cash Reserve PolicySeptember 30, 2018640 Sewer Repair Insurance 1,963,554 95,985 1,867,569 158,056 1,709,513 295%25% of Annual expenditures641 Sewage Works Operations 12,565,143 2,904,797 9,660,346 2,506,017 7,154,329 19%5% of Annual expenditures643 Sewage Works Reserve - O & M 5,399,084 - 5,399,084 5,385,244 13,840 17% 16.67% of annual operating expenses in Fund 641, net of transfers649 Sewage Works Bond Sinking 7,547,630 - 7,547,630 7,547,630 - 100%100% cash reserves per bond covenants653 Sewage Works Debt Service Reserve 4,177,360 - 4,177,360 4,177,360 - 100%100% cash reserves per bond covenants and Crowe Horwath655 Project Releaf 693,621 115 693,506 175,511 517,995 99%25% of Annual expenditures670 Century Center 1,756,816 23,438 1,733,378 1,139,279 594,099 38%25% of Annual expenditures671 Century Center Capital 855,980 - 855,980 800,000 55,980 4280%$800,000 Minimum per Board of Managers701 Firefighters Pension 1,409,577 - 1,409,577 511,246 898,331 28% Pension payments received in June & Sept10% of Annual expenditures702 Police Pension 2,459,808 - 2,459,808 658,345 1,801,463 37% Pension payments received in June & Sept10% of Annual expenditures705 Police K-9 Unit 2,922 592 2,329 505 1,824 115%25% of Annual expenditures711 Self-Funded Employee Benefits 12,041,162 437,112 11,604,050 4,536,380 7,067,670 64%25% of Annual expenditures713 Unemployment Comp Fund 207,935 - 207,935 20,000 187,935 260%25% of Annual expenditures718 State Tax Withholding Fund 282,190 - 282,190 282,190 - 100%100% cash reserves - trust & agency funds725 Morris / Palais Box Office 2,482,981 - 2,482,981 2,482,981 - 100%100% cash reserves - trust & agency funds726 Police Distributions Payable 822,824 - 822,824 822,824 - 100%100% cash reserves - trust & agency funds730 City Cemetery Trust 28,836 - 28,836 6,250 22,586 115%25% of Annual expenditures752 South Bend Redevelopment Authority 49,455 - 49,455 49,455 - 100%100% cash reserves per bond covenants753 Smart Street Bond Capital 70,283 - 70,283 70,283 - 100%100% cash reserves per bond covenants755 South Bend Building Corporation 789,614 - 789,614 789,614 - 100%100% cash reserves per bond covenants756 Smart Streets Debt Service Fund 1,725,060 - 1,725,060 1,725,060 - 100%100% cash reserves per bond covenants757 2015 Parks Bond Debt Service 463,392 - 463,392 463,392 - 100%100% cash reserves per bond covenants760 Eddy St. Commons Debt Service 2,505,330 2,500,000 5,330 5,330 - 100%100% cash reserves per bond covenants232,605,817 26,257,078 206,348,739 123,970,448 82,378,291 No Reserve Requirements209 Studebaker/Oliver Revitalizing Grants 949,682 58,158 891,524 - 891,524 100%No reserve requirement - Grant fund - spend down to zero210 DCI State Grants 361,798 81,000 280,798 - 280,798 100% To be reimbursed by grant receiptsNo reserve requirement - Grant fund - spend down to zero212 DCI Grant Fund 111,238 3,070,800 (2,959,561) - (2,959,561) 100% To be reimbursed by grant receiptsNo reserve requirement - Grant fund - spend down to zero217 Gift, Donation, Bequest 135,304 13,148 122,157 - 122,157 100%No reserve requirement221 Landlord Registration 10,077 - 10,077 - 10,077 100%No reserve requirement224 Central Services Capital 190,652 13,311 177,341 - 177,341 100%No reserve requirement - Capital fund - spend down to zero227 Loss Recovery Fund 691,365 110,615 580,750 - 580,750 100%No reserve requirement257 LOIT 2016 Special Distribution 972,378 971,877 501 - 501 100%No reserve requirement265 Local Road & Bridge Grant 630,731 424,053 206,678 - 206,678 100% Will receive interfund transfer to coverNo reserve requirement - Grant fund - spend down to zero279 IT / Innovation / 311 Call Center 2,908,222 1,539,698 1,368,524 - 1,368,524 100% Reimbursed through inter-fund transferNo reserve requirement280 Police Block Grants 3,972 - 3,972 - 3,972 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 115,037 3,370 111,667 - 111,667 100%No reserve requirement - Grant fund - spend down to zero312 2017 Parks Bond Debt Service(187,998) - (187,998) - (187,998) 100% Will be reimbursed from property taxes in DecNo reserve requirement313 Hall of Fame Debt Service (109,688) - (109,688) - (109,688) 100% Will be reimbursed from property taxes in DecNo reserve requirement377 Professional Sports Development(783,696) - (783,696) - (783,696) 100% Waiting on the receipt of PSDA revenueNo reserve requirement401 Coveleski Stadium Capital 55,229 - 55,229 - 55,229 100%No reserve requirement - Capital fund - spend down to zero410 Urban Develop Action Grant (UDAG) 405,958 - 405,958 - 405,958 100%No reserve requirement - Grant fund - spend down to zero412 Major Moves Construction 2,840,354 695,328 2,145,026 - 2,145,026 100%No reserve requirement - Capital fund - spend down to zero439 Certified Technology Park 620,956 - 620,956 - 620,956 100%No reserve requirement451 2018 Fire St #9 Capital 4,454,809 3,205,191 1,249,618 - 1,249,618 100%No reserve requirement - Bond capital fund - spend down to zero452 2018 TIF Park Bond Capital 10,744,373 541,430 10,202,943 - 10,202,943 100%No reserve requirement - Bond capital fund - spend down to zero454 Airport Urban Enterprise Zone 391,603 - 391,603 - 391,603 100%No reserve requirement471 2017 Parks Bond Capital 13,531,783 54,945 13,476,838 - 13,476,838 100%Bond fund - spend down to zero - no reserves611 Solid Waste Capital 236,033 - 236,033 - 236,033 100%No reserve requirement - Capital fund - spend down to zero622 Water Works Capital 1,974,521 289,579 1,684,942 - 1,684,942 100%No reserve requirement - Capital fund - spend down to zero642 Sewage Works Capital 9,809,531 1,932,401 7,877,129 - 7,877,129 100% Receives transfers from Fund 641 as neededNo reserve requirement - Capital fund - spend down to zero672 Century Center Energy Savings 325,585 - 325,585 - 325,585 100%No reserve requirement677 Hall of Fame Capital Fund 425,095 3,254 421,841 - 421,841 100%No reserve requirement - Capital fund - spend down to zero750 Equipment/Vehicle Leasing 4,066,635 2,063,232 2,003,403 - 2,003,403 100% No reserve requirement - Capital lease fund - spend down to zero751 2015 Parks Bond Capital 1,682,873 1,432,546 250,327 - 250,327 100% No reserve requirement - Bond capital fund - spend down to zeroMonthly Cash Report 09-20187
City of South BendCash Reserves Summary by Fund Status Cash ActualFund Fund NameCash Outstanding Available Reserve % ofBalance Encumb. Cash Requirement Variance Budget Notes Cash Reserve PolicySeptember 30, 2018754 Industrial Revolving Fund 2,548,717 - 2,548,717 - 2,548,717 100%No City reserve requirement; there are program requirements759 Eddy St Commons Capital 11,122,068 16,103,750 (4,981,682) - (4,981,682) 100% Over encumbered, fund is being reviewedNo reserve requirement - Bond capital fund - spend down to zero71,261,912 32,607,685 38,654,228 - 38,654,228 City Operations Total 306,025,269 59,191,584 246,833,686 126,436,423 120,397,263 Note: Available Cash is a Fund's cash balance minus any outstanding encumbrancesMonthly Cash Report 09-20188
January 1, 2007 - September 30, 2018
$329,782,565 6/30/2018
$122,056,198 5/31/2007
$210,833,268 --
$286,064,456 --
Enterprise Redevelopment Civil City Enterprise Redevelopment Civil City
Date Total Cash Funds Funds Funds Date Total Cash Funds Funds Funds
01/01/07 153,934,542.58 28,657,187.47 40,101,775.51 85,175,579.60 03/31/11 204,406,098.50 46,555,428.08 52,439,712.97 105,410,957.45
01/31/07 140,751,745.07 30,058,091.08 37,204,941.29 73,488,712.70 04/30/11 196,890,904.95 46,284,639.10 51,775,206.12 98,831,059.73
02/28/07 134,780,141.52 30,099,578.04 42,400,991.27 62,279,572.21 05/31/11 187,084,917.40 45,692,919.82 45,543,075.85 95,848,921.73
03/31/07 130,695,124.81 30,984,947.93 36,322,464.80 63,387,712.08 06/30/11 230,633,979.38 46,029,921.56 57,605,720.29 126,998,337.53
04/30/07 123,592,524.20 29,218,887.63 36,374,308.24 57,999,328.33 07/31/11 215,737,687.08 45,556,018.39 51,845,520.23 118,336,148.46
05/31/07 122,056,197.59 32,424,086.65 36,579,224.31 53,052,886.63 08/31/11 208,031,597.26 45,688,053.72 49,085,008.00 113,258,535.54
06/30/07 153,755,514.81 48,699,567.31 35,914,061.41 69,141,886.09 09/30/11 203,800,576.60 46,330,287.44 47,073,543.39 110,396,745.77
07/31/07 137,115,793.85 48,096,309.22 33,046,039.94 55,973,444.69 10/31/11 218,059,539.64 67,040,484.39 44,750,523.17 106,268,532.08
08/31/07 135,817,993.03 47,662,427.04 31,416,991.60 56,738,574.39 11/30/11 207,257,743.68 61,691,017.04 41,844,406.42 103,722,320.22
09/30/07 130,647,671.00 45,360,303.16 30,955,278.22 54,332,089.62 12/31/11 231,757,444.75 58,173,399.01 51,201,636.39 122,382,409.35
10/31/07 139,006,258.42 46,717,357.10 29,953,285.20 62,335,616.12 01/31/12 216,528,714.30 59,207,692.55 44,464,972.65 112,856,049.10
11/30/07 149,006,468.44 41,716,114.28 29,049,190.99 78,241,163.17 02/29/12 210,660,777.01 59,272,665.18 43,124,396.97 108,263,714.86
12/31/07 191,315,373.73 55,204,053.77 43,118,912.28 92,992,407.68 03/31/12 204,985,024.71 59,768,182.49 40,875,506.16 104,341,336.06
01/31/08 178,454,459.92 56,114,335.03 41,405,052.40 80,935,072.49 04/30/12 202,396,668.08 60,202,795.65 39,972,677.94 102,221,194.49
02/29/08 175,025,158.07 54,575,012.50 40,635,068.99 79,815,076.58 05/31/12 194,807,225.14 59,123,171.41 37,283,464.71 98,400,589.02
03/31/08 170,888,981.29 54,575,272.95 40,558,124.18 75,755,584.16 06/30/12 244,718,879.49 67,140,754.63 48,308,618.33 129,269,506.53
04/30/08 165,390,558.53 54,929,047.02 40,290,091.29 70,171,420.22 07/31/12 230,268,324.98 67,955,663.74 43,597,429.86 118,715,231.38
05/31/08 156,964,559.54 53,052,472.03 40,210,711.69 63,701,375.82 08/31/12 223,526,459.82 67,464,201.30 41,355,817.62 114,706,440.90
06/30/08 167,363,776.09 53,204,418.10 39,857,987.53 74,301,370.46 09/30/12 223,261,928.97 65,732,654.52 40,654,565.67 116,874,708.78
07/31/08 171,036,661.63 54,533,563.28 39,145,712.40 77,357,385.95 10/31/12 214,815,908.26 66,270,486.67 38,605,222.83 109,940,198.76
08/31/08 163,938,453.44 54,251,216.99 36,074,455.00 73,612,781.45 11/30/12 203,844,116.85 59,658,568.60 37,090,958.24 107,094,590.01
09/30/08 160,071,575.14 53,272,451.68 35,928,266.53 70,870,856.93 12/31/12 255,285,203.18 82,506,887.41 47,393,846.15 125,384,469.62
10/31/08 164,801,788.81 68,706,036.43 34,674,631.21 61,421,121.17 01/31/13 247,853,896.56 83,296,821.86 45,144,294.34 119,412,780.36
11/30/08 148,390,201.07 54,077,562.73 33,382,904.90 60,929,733.44 02/28/13 237,222,593.71 82,484,393.54 41,364,435.41 113,373,764.76
12/31/08 140,621,861.88 44,639,804.67 28,608,922.65 67,373,134.56 03/31/13 232,080,046.72 82,950,715.18 41,430,811.51 107,698,520.03
01/31/09 129,082,048.94 45,793,529.09 26,731,148.85 56,557,371.00 04/30/13 226,442,650.85 80,568,512.43 42,438,979.52 103,435,158.90
02/28/09 136,587,197.92 46,941,062.25 28,199,966.51 61,446,169.16 05/31/13 220,102,647.01 79,672,318.05 42,077,874.12 98,352,454.84
03/31/09 150,350,125.92 47,265,006.09 27,482,787.81 75,602,332.02 06/30/13 259,848,268.81 79,520,360.08 55,157,971.58 125,169,937.15
04/30/09 156,355,774.87 48,061,985.20 38,905,572.01 69,388,217.66 07/31/13 252,445,699.79 79,867,774.82 51,147,079.40 121,430,845.57
05/31/09 154,015,638.43 46,623,111.00 38,656,758.39 68,735,769.04 08/31/13 242,038,208.31 79,782,901.50 48,231,381.91 114,023,924.90
06/30/09 145,255,362.21 46,662,615.02 36,003,705.47 62,589,041.72 09/30/13 242,325,305.67 79,940,103.15 47,344,717.04 115,040,485.48
07/31/09 151,028,950.92 45,609,990.75 39,288,192.08 66,130,768.09 10/31/13 235,335,719.18 79,663,547.72 45,849,747.51 109,822,423.95
08/31/09 154,754,067.65 44,700,623.82 38,981,480.90 71,071,962.93 11/30/13 222,610,337.19 72,524,668.50 45,831,055.40 104,254,613.29
09/30/09 153,379,153.77 44,771,129.93 38,365,267.66 70,242,756.18 12/31/13 247,349,777.30 67,716,137.82 55,315,510.06 124,318,129.42
10/31/09 150,364,096.50 44,855,908.07 36,749,933.72 68,758,254.71 01/31/14 232,044,399.72 66,889,990.77 50,898,242.66 114,256,166.29
11/30/09 144,010,184.05 44,458,186.54 35,847,660.55 63,704,336.96 02/28/14 227,156,115.52 67,566,543.96 49,986,290.38 109,603,281.18
12/31/09 188,453,001.03 36,891,179.40 34,358,243.89 117,203,577.74 03/31/14 222,046,327.82 68,633,684.73 49,028,261.04 104,384,382.05
01/31/10 196,099,529.93 37,726,300.40 53,534,937.83 104,838,291.70 04/30/14 214,783,605.41 68,960,383.93 47,281,387.13 98,541,834.35
02/28/10 194,663,355.99 36,982,623.93 52,816,628.95 104,864,103.11 05/31/14 209,324,809.29 67,425,749.33 46,795,213.96 95,103,846.00
03/31/10 197,907,655.27 41,475,717.35 52,577,148.25 103,854,789.67 06/30/14 251,700,644.00 67,697,981.00 61,118,881.00 122,883,782.00
04/30/10 190,430,003.35 40,478,357.60 51,768,568.42 98,183,077.33 07/31/14 238,781,403.03 68,611,865.99 56,842,280.86 113,327,256.18
05/31/10 201,229,420.61 38,739,522.56 50,881,687.36 111,608,210.69 08/31/14 234,086,687.41 68,747,483.87 55,735,447.17 109,603,756.37
06/30/10 230,557,975.59 39,738,881.62 62,539,377.78 128,279,716.19 09/30/14 233,595,370.44 69,430,344.98 54,889,194.46 109,275,831.00
07/31/10 217,064,522.90 42,020,069.17 55,401,804.58 119,642,649.15 10/31/14 225,913,486.47 70,431,027.92 54,196,891.83 101,285,566.72
08/31/10 210,387,480.23 40,331,826.60 53,423,401.23 116,632,252.40 11/30/14 216,583,420.38 64,909,392.12 54,554,819.33 97,119,208.93
09/30/10 211,494,373.45 40,245,656.32 52,832,007.68 118,416,709.45 12/31/14 239,808,095.03 61,623,499.90 65,903,128.76 112,281,466.37
10/31/10 204,642,650.38 39,984,803.80 51,745,774.22 112,912,072.36 01/31/15 225,471,264.56 61,585,040.94 60,387,162.56 103,499,061.06
11/30/10 198,782,418.22 35,695,100.47 49,573,730.89 113,513,586.86 02/28/15 221,854,105.82 63,269,776.69 58,990,110.88 99,594,218.25
12/31/10 227,739,252.18 41,300,042.16 65,164,721.07 121,274,488.95 03/31/15 215,278,052.12 64,288,370.38 58,654,868.03 92,334,813.71
01/31/11 214,107,834.98 42,918,366.28 57,392,911.65 113,796,557.05 04/30/15 213,330,317.66 65,430,174.18 57,972,838.77 89,927,304.71
02/28/11 208,263,626.92 44,793,554.36 53,822,791.88 109,647,280.68 05/31/15 209,379,494.75 65,714,228.05 57,630,884.95 86,034,381.75
Note: Property tax distributions are received
in June and December.
City of South Bend Cash Balances - All Funds
Maximum Total Cash
Minimum Total Cash
Average Cash
Average - last 12 months
$0
$50,000,000
$100,000,000
$150,000,000
$200,000,000
$250,000,000
$300,000,000
$350,000,000
Monthly Cash Report 09-2018 9
January 1, 2007 - September 30, 2018
City of South Bend Cash Balances - All Funds
Enterprise Redevelopment Civil City
Date Total Cash Funds Funds Funds
06/30/15 249,603,497.41 68,746,632.56 70,642,566.10 110,214,298.75
07/31/15 236,381,857.01 70,884,051.33 65,048,413.67 100,449,392.01
08/31/15 228,483,356.31 72,023,119.13 61,042,169.83 95,418,067.35
09/30/15 234,514,964.30 75,617,268.98 59,936,471.64 98,961,223.68
10/31/15 230,114,056.20 77,155,814.42 56,339,743.69 96,618,498.09
11/30/15 222,277,823.00 75,987,100.36 54,715,027.81 91,575,694.83
12/31/15 228,782,505.24 64,215,673.59 61,194,710.47 103,372,121.18
01/31/16 217,346,607.43 65,062,377.54 55,690,681.11 96,593,548.78
02/29/16 213,873,714.80 67,564,110.56 53,548,676.30 92,760,927.94
03/31/16 211,205,005.30 69,211,164.87 53,434,486.66 88,559,353.77
04/30/16 207,587,385.26 69,616,174.97 51,317,725.09 86,653,485.20
05/31/16 206,530,605.82 69,399,868.04 50,296,085.76 86,834,652.02
06/30/16 249,745,397.89 68,720,691.90 64,433,239.06 116,591,466.93
07/31/16 236,139,560.82 69,227,392.30 58,518,600.58 121,999,405.01
08/31/16 229,469,472.57 67,673,880.42 55,966,718.35 105,828,873.80
09/30/16 231,252,737.44 69,398,336.63 55,065,472.04 106,788,928.77
10/31/16 224,757,043.80 68,809,369.21 52,059,580.89 103,888,093.70
11/30/16 210,677,437.29 61,451,803.84 51,222,578.99 98,003,054.46
12/31/16 234,529,325.24 58,486,210.11 60,406,691.98 115,636,423.15
01/31/17 237,205,923.15 58,517,537.99 54,709,591.50 123,978,793.66
02/28/17 242,890,155.89 60,687,347.41 60,693,512.64 121,509,295.84
03/31/17 233,258,187.04 62,502,426.31 54,200,785.07 116,554,975.66
04/30/17 227,611,544.94 63,062,862.44 53,618,489.08 110,930,193.42
05/31/17 222,671,842.56 62,923,609.40 50,870,962.23 108,877,270.93
06/30/17 264,329,452.56 62,218,464.08 64,818,554.92 137,292,433.56
07/31/17 254,200,729.74 63,518,960.13 59,955,849.53 130,725,920.08
08/31/17 252,059,534.11 64,818,240.75 60,726,084.24 126,515,209.12
09/30/17 277,635,581.14 66,236,471.94 57,532,562.70 153,866,546.50
10/31/17 269,348,596.25 66,667,885.35 55,546,746.25 147,133,964.65
11/30/17 258,560,219.00 59,754,036.10 55,251,426.66 143,554,756.24
12/31/17 291,289,923.15 57,620,088.62 65,818,514.83 167,851,319.70
01/31/18 282,785,943.66 59,858,871.62 60,435,599.30 162,491,472.74
02/28/18 276,155,955.04 58,423,954.94 58,919,560.09 158,812,440.01
03/31/18 274,783,580.98 60,255,912.54 56,967,800.25 157,559,868.19
04/30/18 280,256,559.54 61,537,542.97 70,308,595.71 148,410,420.86
05/31/18 280,820,481.43 62,676,079.74 69,433,440.38 148,710,961.31
06/30/18 329,782,564.72 62,779,584.12 81,992,642.55 185,010,338.05
07/31/18 317,008,229.34 64,079,751.06 78,753,842.27 174,174,636.01
08/31/18 308,391,385.21 65,896,576.77 73,401,834.82 169,092,973.62
09/30/18 306,023,826.98 67,628,081.52 70,934,670.78 167,461,074.68
Monthly Cash Report 09-2018 10
$83,296,822 1/31/2013
$28,657,187 1/1/2007
$58,164,509 --
$62,730,934 --
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
05/31/10 38,739,522.56 08/31/14 68,747,483.87
06/30/10 39,738,881.62 09/30/14 69,430,344.98
07/31/10 42,020,069.17 10/31/14 70,431,027.92
08/31/10 40,331,826.60 11/30/14 64,909,392.12
09/30/10 40,245,656.32 12/31/14 61,623,499.90
10/31/10 39,984,803.80 01/31/15 61,585,040.94
11/30/10 35,695,100.47 02/28/15 63,269,776.69
12/31/10 41,300,042.16 03/31/15 64,288,370.38
01/31/11 42,918,366.28 04/30/15 65,430,174.18
02/28/11 44,793,554.36 05/31/15 65,714,228.05
Note: Cash goes down in June and at
year-end due to the timing of debt service
payments. Debt service payments for
Wastewater are paid out twice a year:
interest in June and principal and interest
in November. Debt service payments for
Water Works are paid out twice a year:
interest in June and principal and interest
in December.
The total cash has been declining as bond
funds are spent down.
In March 2017, the Utility Commission
approved a water rate increase in two
phases: phase 1 - 22% over 12 months,
phase 2 - 22% over 12 months. The
increase was added starting with April
2017 billing. Water Works expects to see
increase in cash in May 2017, when they
begin collecting on April billing.
City of South Bend Cash Balances - Enterprise Funds
January 1, 2007 - September 30, 2018
Maximum Total Cash
Minimum Total Cash
Average Cash
Average - last 12 months
$0
$10,000,000
$20,000,000
$30,000,000
$40,000,000
$50,000,000
$60,000,000
$70,000,000
$80,000,000
$90,000,000
Monthly Cash Report 09-2018 11
$81,992,643 6/30/2018
$26,731,149 1/31/2009
$49,334,295 --
$65,812,523 --
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
05/31/10 50,881,687.36 08/31/14 55,735,447.17
06/30/10 62,539,377.78 09/30/14 54,889,194.46
07/31/10 55,401,804.58 10/31/14 54,196,891.83
08/31/10 53,423,401.23 11/30/14 54,554,819.33
09/30/10 52,832,007.68 12/31/14 65,903,128.76
10/31/10 51,745,774.22 01/31/15 60,387,162.56
11/30/10 49,573,730.89 02/28/15 58,990,110.88
12/31/10 65,164,721.07 03/31/15 58,654,868.03
01/31/11 57,392,911.65 04/30/15 57,972,838.77
02/28/11 53,822,791.88 05/31/15 57,630,884.95
Note: TIF property tax distributions
are received in June and December.
Cash goes down in May and
November due to the timing of debt
service payments.
April 2018, Redevelopment District
Bonds totaling $11,995,000 were
issued for parks improvements to be
repaid by TIF Fund 324.
City of South Bend Cash Balances - Redevelopment Funds
January 1, 2007 - September 30, 2018
Maximum Total Cash
Minimum Total Cash
Average Cash
Average - last 12 months
$0
$10,000,000
$20,000,000
$30,000,000
$40,000,000
$50,000,000
$60,000,000
$70,000,000
$80,000,000
$90,000,000
Monthly Cash Report 09-2018 12
$185,010,338 6/30/2018
$53,052,887 5/31/2007
$103,467,970 --
$157,903,284 --
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
05/31/10 111,608,210.69 08/31/14 109,603,756.37
06/30/10 128,279,716.19 09/30/14 109,275,831.00
07/31/10 119,642,649.15 10/31/14 101,285,566.72
08/31/10 116,632,252.40 11/30/14 97,119,208.93
09/30/10 118,416,709.45 12/31/14 112,281,466.37
10/31/10 112,912,072.36 01/31/15 103,499,061.06
11/30/10 113,513,586.86 02/28/15 99,594,218.25
12/31/10 121,274,488.95 03/31/15 92,334,813.71
01/31/11 113,796,557.05 04/30/15 89,927,304.71
02/28/11 109,647,280.68 05/31/15 86,034,381.75
Note: Property tax collections are
received in June and December.
Effective January 1, 2017, a total of
eight (8) funds with trustee cash
balances were included in the City's
formal accounting system,
signficantly increasing Civil City cash.
Also, bond proceeds received during
2017, totaling $43.4 million,
increased cash.
City of South Bend Cash Balances - Civil City Funds
January 1, 2007 - September 30, 2018
Maximum Total Cash
Minimum Total Cash
Average Cash
Average - last 12 months
$0
$20,000,000
$40,000,000
$60,000,000
$80,000,000
$100,000,000
$120,000,000
$140,000,000
$160,000,000
$180,000,000
$200,000,000
Monthly Cash Report 09-2018 13