Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2018-12 - Monthly Cash Report
Period Ending: Issued by: Page Number(s) Contents 2 Narrative 3 - 5 Controller's Cash Report 6 - 7 Cash Reserves Summary by Fund Status 8 - 9 Cash Trends - All Funds 10 Cash Trends - Enterprise Funds 11 Cash Trends - Redevelopment Funds 12 Cash Trends - Civil City Funds Distribution Mayor Pete Buttigieg Chief of Staff Laura O'Sullivan Deputy Chief of Staff Suzanna Fritzberg Common Council Department Heads Fiscal Officers December 31, 2018 Controller City of South Bend Monthly Cash Report Monthly Cash Report 12-2018 Preliminary Report - Final Report to Follow Upon Year-End Closing 1 Questions If you should have additional questions, please contact the Department of Administration & Finance by calling 311. Narrative Fiscal Responsibility The City’s management team is responsible for establishing and maintaining an internal control structure designed to ensure that the assets of the City are protected from loss, theft, or misuse and to ensure that adequate accounting data is compiled to allow for the preparation of financial statements in conformity with generally accepted accounting principles. Controller's Cash Report (pages 3-5) The Controller’s Cash Report is a monthly summary of cash and investment transactions within the current period by Fund. It summarizes the cash received, interest earned, cash disbursed, and cash transferred between Funds within the City of South Bend as well as any loans between Funds. The report provides a month-end view of the City’s cash balance in the reporting period. Cash Reserves Summary (pages 6-8) The purpose of the Cash Reserves Summary Report is keep track of whether the City's funds are meeting their cash reserve requirement. Cash reserve requirements are set for each fund by the City of South Bend or other governing body (e.g. bond counsel, Century Center Board of Managers). Cash Trends Summary (pages 9-13) The purpose of the Cash Trends Summary is to track trends in cash balances for the City of South Bend over an extended period of time, from January 1, 2007 through the present date. Charts and graphs for the cash balances are provided in four areas--total cash, enterprise fund cash, redevelopment fund cash, and civil city fund cash. Cash Reserve Requirements Cash reserve requirements are typically based on fund type. - Most City funds are assigned a cash reserve requirement of a percentage of the fund's annual expenditures. - The Rainy Day Fund 102 has a reserve requirement of 3% of the City's prior year expenditures. - Some funds have a set dollar amount as the reserve requirement, such as the Police Take Home Vehicle Fund 278, Century Center Capital Fund 671, and Bowman Cemetery Fund 731. - 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. Monthly Cash Report 12-2018 Preliminary Report - Final Report to Follow Upon Year-End Closing 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 22,783,319.01 21,588,311.46 5,524,807.06 97,493.800.00 0.00 38,944,317.21 0.0038,944,317.21426,398.66Special Revenue Funds102 RAINY DAY FUND 10,442,445.28 0.00 0.00 22,551.76 0.00 0.00 10,464,997.04 0.0010,464,997.040.00201 PARKS & RECREATION 3,482,103.10 4,783,716.94 1,356,053.35 8,392.94 1,380,145.95 0.00 8,298,305.58 0.008,298,305.580.00202 MOTOR VEHICLE HIGHWAY 7,521,161.90 607,885.60 1,080,230.92 16,747.27 946,937.50 0.00 8,012,501.35 0.008,012,501.350.00203 RECREATION - NONREVERTING 825,976.77 49,636.22 78,410.27 1,773.77 0.00 798,976.49 0.00 0.000.000.00209 STUDEBAKER/OLIVER REVERTING GRANTS 933,724.15 23,459.37 2,758.75 2,038.74 0.00 0.00 956,463.51 0.00956,463.51200,000.00210 DEPT COMMUNITY INVESTMENT STATE GRANTS 362,911.65 0.00 18,002.61 783.75 0.00 0.00 345,692.79 0.00345,692.790.00211 DCI OPERATING FUND 426,076.93 55,728.96 218,077.57 1,231.15 466,505.00 0.00 731,464.47 0.00731,464.470.00212 DEPARTMENT OF COMMUNITY INVESTMENT 525,357.52 440,703.36 618,286.16 7.39 0.00 0.00 347,782.11 0.00347,782.110.00216 POLICE STATE SEIZURES 227,415.22 0.00 803.50 491.12 0.00 0.00 227,102.84 0.00227,102.840.00217 GIFT, DONATION, BEQUEST 183,108.75 1,558.50 19,842.89 394.32 0.000.00 165,218.68 0.00165,218.680.00218 POLICE CURFEW VIOLATIONS 13,081.00 0.00 0.00 28.24 0.00 0.00 13,109.24 0.0013,109.240.00219 UNSAFE BUILDING 423,479.50 23,225.70 37,692.18 974.24 162,068.25 27,500.00 544,555.51 0.00544,555.510.00220 LAW ENFORCEMENT CONTINUING EDUCATION 490,934.11 13,070.31 58,856.15 1,083.99 0.00 0.00 446,232.26 0.00446,232.260.00221 LANDLORD REGISTRATION 10,108.20 0.00 0.00 21.82 0.00 0.00 10,130.020.0010,130.020.00227 LOSS RECOVERY FUND 670,581.63 0.00 44,722.50 1,465.40 0.00 0.00 627,324.53 0.00627,324.530.00249 PUBLIC SAFETY L.O.I.T. 1,883,744.88 645,794.92 574,232.89 3,401.46 0.00 0.00 1,958,708.37 0.001,958,708.370.00251 LOCAL ROADS & STREETS 4,136,431.03 153,409.98 84,680.28 8,839.120.00 284,500.00 3,929,499.85 0.003,929,499.850.00257 LOIT 2016 SPECIAL DISTRIBUTION 895,248.72 0.00 391,725.88 1,833.98 254,000.00 0.00 759,356.82 0.00759,356.820.00258 HUMAN RIGHTS - FEDERAL GRANT 540,065.23 3,912.21 89,771.61 1,337.14 0.00 0.00 455,542.97 73,993.34529,536.310.00265 LOCAL ROAD & BRIDGE GRANT 535,990.73 0.00 237,472.61 1,158.80 30,500.00 0.00 330,176.92 0.00330,176.920.00273 MORRIS PAC/PALAIS ROYALE MARKETING 54,486.23 6,870.00 4,000.00 128.63 0.00 0.00 57,484.86 0.0057,484.860.00274 MORRIS PAC SELF-PROMOTION 84,621.55 16,959.00 0.00 165.72 0.00 0.00 101,746.27 0.00101,746.270.00280 POLICE BLOCK GRANTS 3,983.82 0.00 0.00 8.59 0.00 0.00 3,992.41 0.003,992.410.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,044.37 0.00 0.00 41.12 0.00 0.00 19,085.49 0.0019,085.490.00291 INDIANA RIVER RESCUE 176,045.26 73,351.70 68,133.69 382.69 0.00 0.00 181,645.96 0.00181,645.960.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,585.30 0.00 119.53 213.88 0.00 0.00 98,679.65 0.0098,679.650.00295 COPS MORE GRANT 175,734.16 27,359.75 900.00 334.29 0.00 0.00 202,528.20 0.00202,528.200.00299 POLICE FEDERAL DRUG ENFORCEMENT 123,903.06 29,758.50 0.00 258.090.00 0.00 153,919.65 0.00153,919.650.00404 COUNTY OPTION INCOME TAX 12,392,086.75 1,018,043.14 939,653.1025,879.34 0.00 696,900.00 11,799,456.13 0.0011,799,456.13867,317.80408 ECONOMIC DEVELOPMENT INCOME TAX 16,493,497.58 893,413.25 142,806.08 34,259.82 0.00 2,144,095.36 15,134,269.21 0.0015,134,269.210.00410 URBAN DEVELOPMENT ACTION GRANT (UDAG) 28,936.28 0.00 0.00 53.64 0.00 0.00 28,989.92 0.0028,989.92(867,317.80)655 PROJECT RELEAF 715,848.49 37,431.52 22,576.11 1,551.11 0.00 137,500.00 594,755.01 0.00594,755.010.00705 POLICE K-9 UNIT 2,329.78 0.00 0.00 5.55 0.00 0.00 2,335.33 0.002,335.330.00Total Special Revenue Funds64,925,764.43 8,905,288.93 6,089,808.63 137,838.87 3,240,156.70 4,089,471.85 67,029,768.45 73,993.3467,103,761.79200,000.00 Debt Service Fund312 2017 PARKS BOND DEBT SERVICE(187,997.71)335,681.76 0.00 0.00 0.00 0.00 147,684.05 0.00147,684.050.00313 HALL OF FAME DEBT SERVICE (109,687.50)206,764.28 0.00 0.00 0.00 0.00 97,076.78 0.0097,076.780.00755 SB BUILDING CORPORATION 790,129.06 0.00 1,100.00 1,996.84 0.00 0.00 791,025.90 0.00791,025.900.00757 2015 PARKS BOND DEBT SERVICE 495,777.01 64,063.54 0.00 590.22 0.00 0.00 560,430.77 0.00560,430.770.00760 EDDY ST. COMMONS DEBT SERVICE 2,506,650.82 0.00 0.00 1,256.91 945,000.00 0.00 3,452,907.73 0.003,452,907.730.00Capital Project Funds377 PROFESSIONAL SPORTS DEVELOPMENT(783,696.36)0.00 0.00 0.00 783,696.36 0.00 0.00 0.000.000.00401 COVELESKI STADIUM CAPITAL 74,509.22 0.00 1,249.28 174.60 0.00 0.0073,434.54 0.0073,434.540.00405 PARK NONREVERTING CAPITAL 126,488.18 43.00 0.00 143.91 0.00 126,675.09 0.00 0.000.000.00406 CUMULATIVE CAPITAL DEVELOPMENT 312,078.06 216,350.91 0.00 898.85 0.00 0.00 529,327.82 0.00529,327.820.00407 CUMULATIVE CAPITAL IMPROVEMENT 322,488.83 124,664.42 0.00 696.450.00 0.00 447,849.70 0.00447,849.700.00412 MAJOR MOVES CONSTRUCTION 2,793,241.95 0.00 26,587.65 6,042.27 0.00 0.00 2,772,696.57 0.002,772,696.574,208,792.61416 MORRIS PERFORMING ARTS CENTER CAPITAL 361,282.52 16,959.00 0.00768.94 0.00 0.00 379,010.46 0.00379,010.460.00450 PALAIS ROYALE HISTORIC PRESERVATION 128,626.36 504.46 0.00 274.67 0.00 0.00 129,405.49 0.00129,405.490.00451 2018 FIRE STATION #9 CAPITAL 3,495,018.04 0.00 0.00 7,951.37 0.000.00 3,502,969.41 0.003,502,969.410.00452 2018 TIF PARK BOND CAPITAL 10,688,701.82 0.00 259,361.95 0.00 0.00 0.00 10,429,339.87 0.0010,429,339.870.00471 2017 PARKS BOND CAPITAL 13,349,066.65 0.00 402,211.98 28,848.18 0.00 0.00 12,975,702.85 0.0012,975,702.850.00677 HALL OF FAME CAPITAL FUND 426,398.66 0.00 1,792.00 920.86 0.00 0.00 425,527.52 0.00425,527.52(426,398.66)Month of: December 2018Monthly Cash Report 12-2018 Preliminary Report - Final Report to Follow Upon Year-End Closing 3 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: December 2018750 EQUIPMENT / VEHICLE LEASING 2,857,950.77 522,878.28 444,397.71 5,608.92 0.00 0.00 2,942,040.26 0.002,942,040.260.00751 2015 PARKS BOND CAPITAL 909,495.71 36,176.29 474,235.05 538.53 0.00 288.37 471,687.11 0.00471,687.110.00753 SMART STREET BOND CAPITAL 68,807.97 0.00 0.00 34.86 0.00 0.00 68,842.83 0.0068,842.830.00759 EDDY ST COMMONS CAPITAL 8,785,600.61 0.00 1,135,369.24 12.88 0.000.00 7,650,244.25 0.007,650,244.250.00Total Capital & Debt Service Funds47,410,930.67 1,524,085.94 2,746,304.86 56,759.26 1,728,696.36 126,963.46 47,847,203.91 0.0047,847,203.913,782,393.95Enterprise Funds287 EMS CAPITAL 4,168,022.84 0.00 68,000.00 9,496.50 0.00 0.00 4,109,519.34 0.004,109,519.340.00288 EMS OPERATING 2,206,460.90 607,750.53 859,136.33 6,266.03 0.00 0.00 1,961,341.13 0.001,961,341.130.00600 CONSOLIDATED BUILDING DEPARTMENT 2,049,075.24 199,110.29 430,509.88 4,742.66 274,888.25 0.00 2,097,306.56 0.002,097,306.560.00601 PARKING GARAGES 1,306,089.18 164,879.05 144,534.44 2,751.58 0.00 0.00 1,329,185.37 0.001,329,185.37(1,427,141.00)610 SOLID WASTE OPERATIONS 452,675.13 450,738.16 377,535.38 975.03 0.00 0.00 526,852.94 0.00526,852.940.00611 SOLID WASTE CAPITAL 44,278.51 102.47 182.49 404.54 0.00 0.00 44,603.03 0.0044,603.030.00620 WATER WORKS OPERATIONS 4,368,117.70 1,622,843.03 1,240,472.65 8,207.45 36,369.91 165,595.00 4,629,470.44 0.004,629,470.440.00622 WATER WORKS CAPITAL 1,991,099.83 2,165.00 104,729.00 4,295.88 0.00 0.00 1,892,831.71 0.001,892,831.710.00624 WATER WORKS CUSTOMER DEPOSIT 1,505,825.76 12,079.57 10,913.35 3,255.30 0.00 3,255.30 1,506,991.98 0.001,506,991.980.00625 WATER WORKS SINKING FUND 1,564,683.50 0.00 0.00 3,337.21 165,595.00 3,337.21 1,730,278.50 0.001,730,278.500.00626 WATER WORKS BOND RESERVE 1,447,148.48 0.00 0.00 3,164.29 0.00 24,000.00 1,426,312.77 0.001,426,312.770.00629 WATER WORKS RESERVE - O & M 2,670,169.40 0.00 0.00 5,777.40 0.005,777.40 2,670,169.40 0.002,670,169.400.00640 SEWER REPAIR INSURANCE 1,989,826.77 53,086.61 27,478.92 4,283.520.00 0.00 2,019,717.98 0.002,019,717.980.00641 SEWAGE WORKS OPERATIONS 13,780,124.74 3,277,150.45 1,948,012.1930,669.87 61,681.90 0.00 15,201,614.77 0.0015,201,614.770.00642 SEWAGE WORKS CAPITAL 9,318,424.01 9,503.50 225,138.35 20,193.72 0.00 0.00 9,122,982.88 0.009,122,982.880.00643 SEWAGE WORKS RESERVE - O & M 5,399,084.29 0.00 0.00 11,681.90 0.00 11,681.90 5,399,084.29 0.005,399,084.290.00649 SEWAGE WORKS BOND SINKING 949,002.53 0.00 550.00 17,577.04 0.00 0.00 966,029.57 0.00966,029.570.00653 SEWAGE WORKS DEBT SERVICE RESERVE 4,190,118.25 0.00 0.00 14,127.44 0.00 0.00 4,204,245.69 0.004,204,245.690.00670 CENTURY CENTER 1,652,394.42 789,721.01 909,106.75 0.00 0.00 0.00 1,533,008.68 0.001,533,008.680.00671 CENTURY CENTER CAPITAL 856,877.14 0.00 0.00 486.08 0.00 0.00 857,363.22 0.00857,363.220.00672 CENTURY CENTER ENERGY SAVINGS 170,598.31 0.00 0.00 10.66 0.00 0.00170,608.97 0.00170,608.970.00Total Enterprise Funds62,080,096.93 7,189,129.67 6,346,299.73 151,704.10 538,535.06 213,646.81 63,399,519.22 0.0063,399,519.22(1,427,141.00)Internal Service Funds222 CENTRAL SERVICES 993,448.03 943,651.24 932,559.69 1,333.43 0.00 0.00 1,005,873.01 0.001,005,873.010.00224 CENTRAL SERVICES CAPITAL 172,995.74 0.00 4,771.20 381.81 0.00 0.00168,606.35 0.00168,606.350.00226 LIABILITY INSURANCE 3,695,509.65 172,936.26 170,466.45 7,816.18 0.00 0.00 3,705,795.64 0.003,705,795.640.00278 TAKE HOME VEHICLE POLICE 748,766.53 320.00 0.00 1,616.55 0.00 0.00750,703.08 0.00750,703.080.00279 IT / INNOVATION / 311 CALL CENTER 2,743,571.75 565,951.61 549,887.31 5,389.17 0.00 0.00 2,765,025.22 0.002,765,025.220.00711 SELF-FUNDED EMPLOYEE BENEFITS 12,003,261.33 1,488,521.02 1,492,543.94 27,068.39 0.00 0.00 12,026,306.80 0.0012,026,306.800.00713 UNEMPLOYMENT COMP FUND 208,572.54 0.00 0.00 450.44 0.00 0.00 209,022.98 0.00209,022.980.00714 PARENTAL LEAVE FUND 52,078.33 12,008.82 12,938.06 101.68 0.00 0.0051,250.77 0.0051,250.770.00Total Internal Service Funds20,618,203.90 3,183,388.95 3,163,166.65 44,157.65 0.00 0.00 20,682,583.85 0.0020,682,583.850.00Trust & Agency Funds701 FIREFIGHTERS PENSION 678,420.89 1,664.45 366,431.66 2,199.57 0.00 0.00 315,853.25 0.00315,853.250.00702 POLICE PENSION 1,454,765.96 0.00 511,079.19 4,159.60 0.00 0.00 947,846.37 0.00947,846.370.00709 PAYROLL FUND 0.00 9,540,552.75 9,540,552.75 0.00 0.00 0.00 0.00 0.000.000.00718 STATE TAX DEDUCTION FUND 403,298.44 324,526.47 403,298.44 0.00 0.00 0.00 324,526.47 0.00324,526.470.00725 MORRIS / PALAIS BOX OFFICE 2,738,650.68 0.00 511,736.24 0.00 0.000.00 2,226,914.44 0.002,226,914.440.00726 POLICE DISTRIBUTIONS PAYABLE 831,998.89 6,527.28 0.00 0.00 0.00 0.00 838,526.17 0.00838,526.170.00730 CITY CEMETERY TRUST 28,924.19 0.00 0.00 62.46 0.00 0.00 28,986.65 0.0028,986.650.00731 BOWMAN CEMETERY 455,997.61 0.00 0.00 0.00 0.00 0.00 455,997.61 0.00455,997.610.00Total Trust & Agency Funds6,592,056.66 9,873,270.95 11,333,098.28 6,421.63 0.00 0.00 5,138,650.96 0.005,138,650.960.00Total City Funds224,410,371.60 52,263,475.90 35,203,485.21 494,375.31 5,507,388.12 4,430,082.12 243,042,043.60 73,993.34 243,116,036.94 2,981,651.61Monthly Cash Report 12-2018 Preliminary Report - Final Report to Follow Upon Year-End Closing 4 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: December 2018Redevelopment Commission Controlled FundsTax Increment Financing Funds324 TIF RIVER WEST 24,986,765.84 8,065,677.58 1,370,855.55 50,696.83 6,014.94 0.00 31,738,299.64 0.0031,738,299.64(200,000.00)422 TIF DISTRICT - WEST WASHINGTON 1,643,186.22 158,637.81 4,251.25 3,893.47 0.00 0.00 1,801,466.25 0.001,801,466.250.00425 REDEVELOPMENT RETAIL AREA 141,846.44 0.00 1,453.99 301.33 0.00 132,306.00 8,387.78 0.008,387.780.00429 TIF RIVER EAST DEV (NE) 9,512,485.49 1,620,729.44 159,102.05 20,565.26 0.00 0.00 10,994,678.14 0.0010,994,678.140.00430 TIF SOUTHSIDE DEVELOPMENT AREA #1 8,854,685.91 908,058.31 326,848.82 19,206.99 0.00 0.00 9,455,102.39 0.009,455,102.390.00435 TIF DOUGLAS ROAD 203,891.15 0.00 0.00 440.32 0.00 0.00 204,331.47 0.00204,331.470.00436 TIF RIVER EAST RES (NE RE) 1,864,504.85 2,070,515.38 0.00 0.00 0.00 945,000.00 2,990,020.23 0.002,990,020.23(2,781,651.61)Total Tax Increment Financing Funds47,207,365.90 12,823,618.52 1,862,511.66 95,104.20 6,014.94 1,077,306.00 57,192,285.90 0.0057,192,285.90(2,981,651.61)Redevelopment Funds433 REDEVELOPMENT ADMINISTRATION GENERAL 614,409.35 0.00 0.00 1,385.55 0.00 0.00 615,794.90 0.00615,794.900.00439 CERTIFIED TECHNOLOGY PARK 622,858.61 0.00 0.00 1,345.14 0.00 0.00 624,203.75 0.00624,203.750.00454 AIRPORT URBAN ENTERPRISE ZONE 392,802.74 0.00 0.00 848.30 0.00 0.00 393,651.04 0.00393,651.040.00754 INDUSTRIAL REVOLVING FUND 2,591,336.00 7,581.00 1,007,108.00 40,682.00 0.00 0.00 1,632,491.00 0.001,632,491.000.00Total Redevelopment Funds4,221,406.70 7,581.00 1,007,108.00 44,260.99 0.00 0.00 3,266,140.69 0.003,266,140.690.00Debt Service Funds 315 AIRPORT 2003 DEBT RESERVE 1,040,462.24 0.00 0.00 2,251.23 0.00 2,251.23 1,040,462.24 0.001,040,462.240.00317 COVELESKI BOND DEBT RESERVE 525,452.50 0.00 0.00 1,134.78 0.00 0.00 526,587.28 0.00526,587.280.00328 SBCDA 2003 DEBT RESERVE 1,739,494.86 0.00 0.00 3,763.71 0.00 3,763.71 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 247,863.23 0.00 38,006.25 635.06 0.00 0.00 210,492.04 0.00210,492.040.00756 SMARTS STREETS DEBT SERVICE 1,725,924.68 0.00 0.00 865.42 0.00 0.00 1,726,790.10 0.001,726,790.100.00Total Debt Service Funds6,272,692.51 0.00 38,006.25 8,650.20 0.00 6,014.94 6,237,321.52 0.006,237,321.520.00Total Redevelopment Commission Funds57,701,465.11 12,831,199.52 2,907,625.91 148,015.39 6,014.94 1,083,320.94 66,695,748.11 0.00 66,695,748.11(2,981,651.61)City Operations Total282,111,836.71 65,094,675.42 38,111,111.12 642,390.70 5,513,403.06 5,513,403.06 309,737,791.71 73,993.34 309,811,785.05 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,176,961.51 243,076.62 0.00 285,433.52 0.00 380,874.19 184,324,597.46 184,324,597.46Monthly Cash Report 12-2018 Preliminary Report - Final Report to Follow Upon Year-End Closing 5 City of South BendCash Reserves Summary by Fund Status Cash ActualFund Fund NameCash Outstanding AvailableReserve % ofBalance Encumb. Cash Requirement Variance Budget Notes Cash Reserve PolicyInsufficient Balances211 DCI Administration Fund 731,464 93,297 638,167 769,274 (131,107) 21% Just under reserve target due to encumbrances25% of Annual expenditures222 Central Services 1,005,873 22,444 983,429 1,110,381 (126,952) 22% Just under reserve target due to encumbrances25% of Annual expenditures, excluding utility accounting610 Solid Waste Operations 526,853 16,077 510,776 568,605 (57,829) 9% Just under reserve target due to encumbrances10% of Annual expenditures629 Water Works Reserve - O & M 2,670,169 - 2,670,169 2,670,510 (341) 17% Just under reserve target16.67% of annual operating expenses in Fund 620, net of transfers701 Firefighters Pension 315,853 - 315,853 511,246 (195,393) 6% Pension payments received in June & Sept10% of Annual expenditures5,250,213 131,819 5,118,394 5,630,016 (511,622) Meets or Exceeds Requirements101 General Fund 38,944,317 820,914 38,123,403 21,735,076 16,388,327 61% Property tax distribution received in June & Dec35% of Annual expenditures102 Rainy Day Fund 10,464,997 - 10,464,997 9,745,767 719,230 3%3% of total expenditures in previous fiscal year201 Parks & Recreation 8,298,306 1,400,311 6,897,995 4,070,515 2,827,480 42% Property tax distribution received in June & Dec25% of Annual expenditures202 Motor Vehicle Highway 8,012,501 972,278 7,040,223 3,098,495 3,941,728 57%25% of Annual expenditures216 Police State Seizures 227,103 - 227,103 8,000 219,103 710%25% of Annual expenditures218 Police Curfew Violations 13,109 - 13,109 250 12,859 1311%25% of Annual expenditures219 Unsafe Building 544,556 180,746 363,809 243,103 120,706 37% High encumbrances25% of Annual expenditures220 Law Enforce. Continuing Education 446,232 107,046 339,186 157,906 181,280 54%25% of Annual expenditures226 Liability Insurance 3,705,796 164,872 3,540,924 2,550,121 990,803 69%50% of Annual expenditures249 Public Safety L.O.I.T. 1,958,708 - 1,958,708 609,838 1,348,870 26% 8% of Annual expenditures - one month reserve251 Local Roads & Streets 3,929,500 1,204,710 2,724,790 854,627 1,870,163 80%25% of Annual expenditures258 Human Rights - Federal Grant 529,536 - 529,536 43,084 486,452 307%25% of Annual expenditures273 Morris PAC/Palais Royale Marketing 57,485 - 57,485 4,500 52,985 319%25% of Annual expenditures274 Morris PAC/Self-Promotion 101,746 - 101,746 12,500 89,246 203%25% of Annual expenditures278 Take Home Vehicle Police 750,703 - 750,703 750,000 703 2502%Set dollar amount of $750,000287 EMS Capital 4,109,519 836,763 3,272,757 847,433 2,425,324 97%25% of Annual expenditures288 EMS Operating 1,961,341 24,723 1,936,618 1,607,937 328,681 30%25% of Annual expenditures289 HAZMAT 19,085 472 18,613 2,500 16,113 186%25% of Annual expenditures291 Indiana River Rescue 181,646 7,520 174,126 25,450 148,676 171%25% of Annual expenditures294 Regional Police Academy 98,680 - 98,680 5,625 93,055 439%25% of Annual expenditures299 Police Federal Drug Enforcement 153,920 - 153,920 12,750 141,170 302%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 526,587 - 526,587 526,587 - 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) 31,738,300 5,179,517 26,558,783 12,089,046 14,469,737 55%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,799,456 1,750,440 10,049,017 6,525,837 3,523,180 77%50% of Annual expenditures406 Cumulative Capital Development 529,328 - 529,328 143,851 385,477 92%25% of Annual expenditures407 Cumulative Capital Improvement 447,850 - 447,850 69,625 378,225 161%25% of Annual expenditures408 Economic Development Income Tax 15,134,269 1,942,214 13,192,055 6,499,132 6,692,923 101%50% of Annual expenditures416 Morris Performing Arts Center Capital 379,010 8,462 370,549 46,025 324,524 201%25% of Annual expenditures422 TIF District - West Washington 1,801,466 795,130 1,006,336 571,479 434,857 44%25% of Annual expenditures429 River East Dev TIF (Northeast TIF) 10,994,678 5,101,982 5,892,696 2,396,923 3,495,773 61%25% of Annual expenditures430 TIF Southside Development Area #1 9,455,102 803,618 8,651,485 2,139,007 6,512,478 101%25% of Annual expenditures433 Redev Administration General 615,795 - 615,795 8,150 607,645 1889%25% of Annual expenditures435 TIF - Douglas Road 204,331 - 204,331 20,465 183,866 100%10% of Annual expenditures436 River East Residential (Ne Res TIF) 2,990,020 - 2,990,020 1,316,250 1,673,770 57%25% of Annual expenditures450 Palais Royale Historic Preservation 129,405 36,967 92,438 11,250 81,188 205%25% of Annual expenditures600 Consolidated Building Department 2,097,307 99,541 1,997,765 1,190,796 806,969 42%25% of Annual expenditures601 Parking Garages 1,329,185 34,789 1,294,397 313,086 981,311 103%25% of Annual expenditures620 Water Works Operations 4,629,470 981,121 3,648,349 903,514 2,744,835 20%5% of Annual expenditures624 Water Works Customer Deposit 1,506,992 - 1,506,992 1,506,992 - 100%100% cash reserves for customer deposits625 Water Works Sinking Fund 1,730,279 - 1,730,279 1,730,279 - 100%100% cash reserves per bond covenants626 Water Works Bond Reserve 1,426,313 - 1,426,313 1,426,313 - 100%100% cash reserves per bond covenants and Crowe Horwath640 Sewer Repair Insurance 2,019,718 30,073 1,989,645 158,056 1,831,589 315%25% of Annual expenditures641 Sewage Works Operations 15,201,615 4,958,805 10,242,809 2,506,347 7,736,462 20%5% of Annual expenditures643 Sewage Works Reserve - O & M 5,399,084 - 5,399,084 5,386,928 12,156 17% 16.67% of annual operating expenses in Fund 641, net of transfers649 Sewage Works Bond Sinking 966,030 550 965,480 965,480 - 100%100% cash reserves per bond covenants653 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 594,755 - 594,755 175,511 419,244 85%25% of Annual expendituresDecember 31, 2018Monthly Cash Report 12-2018 Preliminary Report - Final Report to Follow Upon Year-End Closing 6 City of South BendCash Reserves Summary by Fund Status Cash ActualFund Fund NameCash Outstanding AvailableReserve % ofBalance Encumb. Cash Requirement Variance Budget Notes Cash Reserve PolicyDecember 31, 2018670 Century Center 1,533,009 9,070 1,523,939 1,139,279 384,660 33%25% of Annual expenditures671 Century Center Capital 857,363 - 857,363 800,000 57,363 4287%$800,000 Minimum per Board of Managers702 Police Pension 947,846 - 947,846 658,345 289,501 14% Pension payments received in June & Sept10% of Annual expenditures705 Police K-9 Unit 2,335 - 2,335 505 1,830 116%25% of Annual expenditures711 Self-Funded Employee Benefits 12,026,307 586 12,025,721 4,536,380 7,489,341 66%25% of Annual expenditures713 Unemployment Comp Fund 209,023 - 209,023 20,000 189,023 261%25% of Annual expenditures714 Parental Leave Fund 51,251 - 51,251 38,924 12,327 33%25% of Annual expenditures718 State Tax Withholding Fund 324,526 - 324,526 324,526 - 100%100% cash reserves - trust & agency funds725 Morris / Palais Box Office 2,226,914 - 2,226,914 2,226,914 - 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 28,987 - 28,987 6,250 22,737 116%25% of Annual expenditures731 Bowman Cemetery 455,998 - 455,998 400,000 55,998 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 91%$2,500,000 minimum242,445,406 27,453,220 214,992,186 118,843,840 96,148,346 No Reserve Requirements209 Studebaker/Oliver Revitalizing Grants 956,464 257,782 698,681 - 698,681 100%No reserve requirement - Grant fund - spend down to zero210 DCI State Grants 345,693 81,000 264,693 - 264,693 100% To be reimbursed by grant receiptsNo reserve requirement - Grant fund - spend down to zero212 DCI Grant Fund 347,782 2,733,915 (2,386,132) - (2,386,132) 100% To be reimbursed by grant receiptsNo reserve requirement - Grant fund - spend down to zero217 Gift, Donation, Bequest 165,219 38,476 126,743 - 126,743 100%No reserve requirement221 Landlord Registration 10,130 - 10,130 - 10,130 100%No reserve requirement224 Central Services Capital 168,606 27,671 140,936 - 140,936 100%No reserve requirement - Capital fund - spend down to zero227 Loss Recovery Fund 627,325 47,506 579,819 - 579,819 100%No reserve requirement257 LOIT 2016 Special Distribution 759,357 836,263 (76,906) - (76,906) 100% Will receive interfund transfer to coverNo reserve requirement265 Local Road & Bridge Grant 330,177 83,291 246,886 - 246,886 100%No reserve requirement - Grant fund - spend down to zero279 IT / Innovation / 311 Call Center 2,765,025 840,583 1,924,442 - 1,924,442 100% Reimbursed through interfund allocationNo reserve requirement280 Police Block Grants 3,992 - 3,992 - 3,992 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 202,528 41,554 160,975 - 160,975 100%No reserve requirement - Grant fund - spend down to zero312 2017 Parks Bond Debt Service 147,684 - 147,684 - 147,684 100% Will be reimbursed from property taxes in DecNo reserve requirement313 Hall of Fame Debt Service 97,077 - 97,077 - 97,077 100% Will be reimbursed from property taxes in DecNo reserve requirement401 Coveleski Stadium Capital 73,435 64,622 8,813 - 8,813 100%No reserve requirement - Capital fund - spend down to zero410 Urban Develop Action Grant (UDAG) 28,990 - 28,990 - 28,990 100%No reserve requirement - Grant fund - spend down to zero412 Major Moves Construction 2,772,697 771,236 2,001,461 - 2,001,461 100%No reserve requirement - Capital fund - spend down to zero425 Redevelopment Retail Area 8,388 - 8,388 - 8,388 100% Fund 425 to be closed in 2019No reserve requirement - Fund to be closed439 Certified Technology Park 624,204 - 624,204 - 624,204 100%No reserve requirement451 2018 Fire St #9 Capital 3,502,969 3,232,757 270,212 - 270,212 100%No reserve requirement - Bond capital fund - spend down to zero452 2018 TIF Park Bond Capital 10,429,340 3,158,734 7,270,606 - 7,270,606 100%No reserve requirement - Bond capital fund - spend down to zero454 Airport Urban Enterprise Zone 393,651 - 393,651 - 393,651 100%No reserve requirement471 2017 Parks Bond Capital 12,975,703 2,727,666 10,248,036 - 10,248,036 100%Bond fund - spend down to zero - no reserves611 Solid Waste Capital 44,603 - 44,603 - 44,603 100% Receives transfers from Fund 611 as neededNo reserve requirement - Capital fund - spend down to zero622 Water Works Capital 1,892,832 215,291 1,677,541 - 1,677,541 100%No reserve requirement - Capital fund - spend down to zero642 Sewage Works Capital 9,122,983 8,485,103 637,880 - 637,880 100% Receives transfers from Fund 641 as neededNo reserve requirement - Capital fund - spend down to zero672 Century Center Energy Savings 170,609 - 170,609 - 170,609 100%No reserve requirement677 Hall of Fame Capital Fund 425,528 3,514 422,014 - 422,014 100%No reserve requirement - Capital fund - spend down to zero750 Equipment/Vehicle Leasing 2,942,040 998,124 1,943,916 - 1,943,916 100% No reserve requirement - Capital lease fund - spend down to zero751 2015 Parks Bond Capital 471,687 58,687 413,000 - 413,000 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,241 3 - 3 100%No reserve requirement - Bond capital fund - spend down to zero62,116,166 32,354,013 29,762,154 - 29,762,154 City Operations Total 309,811,785 59,939,052 249,872,734 124,473,856 125,398,878 Note: Available Cash is a Fund's cash balance minus any outstanding encumbrancesMonthly Cash Report 12-2018 Preliminary Report - Final Report to Follow Upon Year-End Closing 7 January 1, 2007 - December 31, 2018 $329,782,565 6/30/2018 $122,056,198 5/31/2007 $212,604,128 -- $292,509,503 -- 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 12-2018 Preliminary Report - Final Report to Follow Upon Year-End Closing 8 January 1, 2007 - December 31, 2018 City of South Bend Cash Balances - All Funds Enterprise Redevelopment Civil City Date Total Cash Funds Funds Funds 06/30/15 249,603,497.41 68,746,632.56 70,642,566.10 110,214,298.75 07/31/15 236,381,857.01 70,884,051.33 65,048,413.67 100,449,392.01 08/31/15 228,483,356.31 72,023,119.13 61,042,169.83 95,418,067.35 09/30/15 234,514,964.30 75,617,268.98 59,936,471.64 98,961,223.68 10/31/15 230,114,056.20 77,155,814.42 56,339,743.69 96,618,498.09 11/30/15 222,277,823.00 75,987,100.36 54,715,027.81 91,575,694.83 12/31/15 228,782,505.24 64,215,673.59 61,194,710.47 103,372,121.18 01/31/16 217,346,607.43 65,062,377.54 55,690,681.11 96,593,548.78 02/29/16 213,873,714.80 67,564,110.56 53,548,676.30 92,760,927.94 03/31/16 211,205,005.30 69,211,164.87 53,434,486.66 88,559,353.77 04/30/16 207,587,385.26 69,616,174.97 51,317,725.09 86,653,485.20 05/31/16 206,530,605.82 69,399,868.04 50,296,085.76 86,834,652.02 06/30/16 249,745,397.89 68,720,691.90 64,433,239.06 116,591,466.93 07/31/16 236,139,560.82 69,227,392.30 58,518,600.58 121,999,405.01 08/31/16 229,469,472.57 67,673,880.42 55,966,718.35 105,828,873.80 09/30/16 231,252,737.44 69,398,336.63 55,065,472.04 106,788,928.77 10/31/16 224,757,043.80 68,809,369.21 52,059,580.89 103,888,093.70 11/30/16 210,677,437.29 61,451,803.84 51,222,578.99 98,003,054.46 12/31/16 234,529,325.24 58,486,210.11 60,406,691.98 115,636,423.15 01/31/17 237,205,923.15 58,517,537.99 54,709,591.50 123,978,793.66 02/28/17 242,890,155.89 60,687,347.41 60,693,512.64 121,509,295.84 03/31/17 233,258,187.04 62,502,426.31 54,200,785.07 116,554,975.66 04/30/17 227,611,544.94 63,062,862.44 53,618,489.08 110,930,193.42 05/31/17 222,671,842.56 62,923,609.40 50,870,962.23 108,877,270.93 06/30/17 264,329,452.56 62,218,464.08 64,818,554.92 137,292,433.56 07/31/17 254,200,729.74 63,518,960.13 59,955,849.53 130,725,920.08 08/31/17 252,059,534.11 64,818,240.75 60,726,084.24 126,515,209.12 09/30/17 277,635,581.14 66,236,471.94 57,532,562.70 153,866,546.50 10/31/17 269,348,596.25 66,667,885.35 55,546,746.25 147,133,964.65 11/30/17 258,560,219.00 59,754,036.10 55,251,426.66 143,554,756.24 12/31/17 291,289,923.15 57,620,088.62 65,818,514.83 167,851,319.70 01/31/18 282,785,943.66 59,858,871.62 60,435,599.30 162,491,472.74 02/28/18 276,155,955.04 58,423,954.94 58,919,560.09 158,812,440.01 03/31/18 274,783,580.98 60,255,912.54 56,967,800.25 157,559,868.19 04/30/18 280,256,559.54 61,537,542.97 70,308,595.71 148,410,420.86 05/31/18 280,820,481.43 62,676,079.74 69,433,440.38 148,710,961.31 06/30/18 329,782,564.72 62,779,584.12 81,992,642.55 185,010,338.05 07/31/18 317,008,229.34 64,079,751.06 78,753,842.27 174,174,636.01 08/31/18 308,391,385.21 65,896,576.77 73,401,834.82 169,092,973.62 09/30/18 306,023,826.98 67,628,081.52 70,934,670.78 167,461,074.68 10/31/18 297,350,750.07 70,191,910.88 58,183,703.49 168,975,135.70 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 Monthly Cash Report 12-2018 Preliminary Report - Final Report to Follow Upon Year-End Closing 9 $83,296,822 1/31/2013 $28,657,187 1/1/2007 $58,310,564 -- $62,584,429 -- 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 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 - December 31, 2018 Maximum Total Cash Minimum Total Cash Average Cash Average - last 12 months $0 $10,000,000 $20,000,000 $30,000,000 $40,000,000 $50,000,000 $60,000,000 $70,000,000 $80,000,000 $90,000,000 Monthly Cash Report 12-2018 Preliminary Report - Final Report to Follow Upon Year-End Closing 10 $81,992,643 6/30/2018 $26,731,149 1/31/2009 $49,572,764 -- $66,439,347 -- 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 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 - December 31, 2018 Maximum Total Cash Minimum Total Cash Average Cash Average - last 12 months $0 $10,000,000 $20,000,000 $30,000,000 $40,000,000 $50,000,000 $60,000,000 $70,000,000 $80,000,000 $90,000,000 Monthly Cash Report 12-2018 Preliminary Report - Final Report to Follow Upon Year-End Closing 11 $185,010,338 6/30/2018 $53,052,887 5/31/2007 $104,851,543 -- $163,868,014 -- 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 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 - December 31, 2018 Maximum Total Cash Minimum Total Cash Average Cash Average - last 12 months $0 $20,000,000 $40,000,000 $60,000,000 $80,000,000 $100,000,000 $120,000,000 $140,000,000 $160,000,000 $180,000,000 $200,000,000 Monthly Cash Report 12-2018 Preliminary Report - Final Report to Follow Upon Year-End Closing 12