Loading...
HomeMy WebLinkAbout2018-07 Controller's Monthly Cash ReportPeriod Ending: Issued By: City of South Bend Controller's Cash Report Tab Page Contents Overview 2 Overview of Controller's Cash Report Controller Cash 3-5 Controller's Cash Report Distribution Mayor Pete Buttigieg Chief of Staff Laura O'Sullivan Deputy Chief of Staff Suzanna Fritzberg South Bend Common Council Members Admininstration and Finance Department Heads City Fiscal Officers July 2018 Controller 2018 July. controllers cash report Page 1 of 5 CONTROLLER’S CASH REPORT OVERVIEW: 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 among/between Funds. The report provides a month-end view of the City’s cash balance in the reporting period. 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. July 2018 HIGHLIGHTS: Total City Funds (pg. 5): July 2018 beginning cash balance of $247,789,922 and ending cash balance of $238,254,387 represents a decrease in cash of ~$9.5 million. Compared to July 2017, beginning cash balance of $199,510,897 and ending cash balance of $194,244,880 represents a decrease in cash of approximately $5.2 million. In comparison, there is an increase y-o-y in expenditures of ~$4.3 million. Variance can be attributed to ~$3.0 million spent this year in funds 750 (Equipment /Vehicle Leasing) and fund 759 (Eddy St. Commons Capital). Total Redevelopment Commission Funds (pg.5): July 2018 beginning cash balance of $81,992,642 and ending cash balance of $78,753,842 represents a decrease in cash of ~$3.2 million. Compared to July 2017 beginning cash balance of $64,818,554 and ending cash balance of $59,955,849 represents a decrease in cash of ~$4.8 million. In comparison, there is a decrease year over year in expenditures of ~ $1.6 million. Fund 101 (General Fund): July 2018 actual receipts were $1,509,919 vs. prior year actual receipts of $1,476,573. The largest receipt this month was in the amount of $58,129 from the State of Indiana for the liquor tax distribution. . Fund 201 (Parks & Recreation): July 2018 actual receipts were $359,724 vs. prior year actual receipts of $415,303. Disbursements are consistent with normal operating costs. Fund 212 (DCI): Negative cash balance reflects payments for CDBG projects. Revenue will increase when additional grant monies are received in early August. Fund 312 (2017 Parks Bond Debt Service): Negative cash balance reflects debt service payments of $593,303 this month. Revenue will increase when property taxes are received later this year Fund 313 (Hall of Fame): Negative cash balance reflects a debt service payment of $633,000 in January. Please note that this was the final payment and the debt has been satisfied. Revenue will increase when property taxes are received later this year. Fund 377 (Professional Sports Development): Negative cash balance reflects a debt service payment of $361,390 made in January for the 2010 Coveleski bond as well as a payment of $100,000 for the Synagogue relocation at Four Winds Field. Revenue will increase when state shared revenue is received later this year. Fund 701 (Fire Pension): This fund has a negative balance because of monthly pension payments made to firemen hired prior to May 1, 1977. Revenue will increase once the mandatory state pension relief distribution is received in October 2018. For July 2018, cash interest received was $322,677 compared to $328,750 in July 2017. 2018 July. controllers cash report - Overview Page 2 of 5 City of South Bend Month of:July 2018 Controller's Cash Report Opening Interest Transfers Transfers Ending Total Cash &Interfund Loans Fund Fund Name Cash Balance Receipts Disbursements Earned In Out Cash Balance Investments Investments (Borrowing) City Controlled Funds General Fund 101 GENERAL FUND $38,612,095.50 $1,509,919.65 $4,545,779.06 $26,140.32 $0.00 $0.00 $35,602,376.41 $0.00 $35,602,376.41 $426,301.79 Special Revenue Funds 102 RAINY DAY FUND 10,361,067.10 0.00 0.00 12,785.99 0.00 0.00 10,373,853.09 0.00 10,373,853.09 0.00 201 PARKS & RECREATION 7,327,451.07 359,724.74 1,185,147.83 3,739.67 0.00 0.00 6,505,767.65 0.00 6,505,767.65 0.00 202 MOTOR VEHICLE HIGHWAY 8,326,376.86 732,960.25 990,211.18 9,628.35 0.00 0.00 8,078,754.28 0.00 8,078,754.28 0.00 203 RECREATION - NONREVERTING 889,533.49 155,425.94 139,116.82 1,126.64 0.00 0.00 906,969.25 0.00 906,969.25 0.00 209 STUDEBAKER/OLIVER REVERTING GRANTS 875,070.42 100,000.00 3,888.00 1,081.50 0.00 0.00 972,263.92 0.00 972,263.92 200,000.00 210 DEPT COMMUNITY INVESTMENT STATE GRANTS 397,720.16 16,214.54 55,661.82 2,258.13 0.00 0.00 360,531.01 0.00 360,531.01 0.00 211 DCI OPERATING FUND 895,573.52 7,612.19 238,374.79 800.03 0.00 0.00 665,610.95 0.00 665,610.95 0.00 212 DEPARTMENT OF COMMUNITY INVESTMENT 413,943.21 78,018.38 621,769.24 401.53 0.00 0.00 (129,406.12)0.00 (129,406.12)0.00 216 POLICE STATE SEIZURES 203,258.45 0.00 0.00 250.83 0.00 0.00 203,509.28 0.00 203,509.28 0.00 217 GIFT, DONATION, BEQUEST 144,604.04 775.63 1,619.21 183.34 0.00 0.00 143,943.80 0.00 143,943.80 0.00 218 POLICE CURFEW VIOLATIONS 12,993.41 25.00 0.00 15.99 0.00 0.00 13,034.40 0.00 13,034.40 0.00 219 UNSAFE BUILDING 492,067.98 14,637.50 55,401.23 468.84 0.00 0.00 451,773.09 0.00 451,773.09 0.00 220 LAW ENFORCEMENT CONTINUING EDUCATION 571,857.33 16,132.67 22,455.04 710.81 0.00 0.00 566,245.77 0.00 566,245.77 0.00 221 LANDLORD REGISTRATION 10,029.44 0.00 0.00 12.37 0.00 0.00 10,041.81 0.00 10,041.81 0.00 227 LOSS RECOVERY FUND 698,171.18 0.00 0.00 869.71 0.00 0.00 699,040.89 0.00 699,040.89 0.00 249 PUBLIC SAFETY L.O.I.T.1,688,964.31 636,978.67 602,151.35 1,975.14 0.00 0.00 1,725,766.77 0.00 1,725,766.77 0.00 251 LOCAL ROADS & STREETS 4,302,167.25 180,648.01 255,583.91 5,228.78 0.00 0.00 4,232,460.13 0.00 4,232,460.13 0.00 257 LOIT 2016 SPECIAL DISTRIBUTION 2,536,650.89 0.00 82,510.18 3,129.19 0.00 0.00 2,457,269.90 0.00 2,457,269.90 0.00 258 HUMAN RIGHTS - FEDERAL GRANT 568,785.74 1,524.06 80,965.58 576.33 0.00 0.00 489,920.55 69,738.08 559,658.63 0.00 265 LOCAL ROAD & BRIDGE GRANT 588,701.70 0.00 566,886.70 726.41 0.00 0.00 22,541.41 0.00 22,541.41 0.00 273 MORRIS PAC/PALAIS ROYALE MARKETING 58,631.82 284.00 0.00 69.78 0.00 0.00 58,985.60 0.00 58,985.60 0.00 274 MORRIS PAC SELF-PROMOTION 63,844.79 2,520.00 0.00 76.95 0.00 0.00 66,441.74 0.00 66,441.74 0.00 280 POLICE BLOCK GRANTS 3,952.79 0.00 0.00 4.87 0.00 0.00 3,957.66 0.00 3,957.66 0.00 281 DEPT. COMMUNITY INVESTMENT - REV BONDS 28,091.35 0.00 0.00 34.66 0.00 28,126.01 0.00 0.00 0.00 0.00 289 HAZMAT 27,683.09 0.00 1,860.26 34.16 0.00 0.00 25,856.99 0.00 25,856.99 0.00 291 INDIANA RIVER RESCUE 151,762.55 34,500.00 6,023.66 174.92 0.00 0.00 180,413.81 0.00 180,413.81 0.00 292 POLICE GRANTS 48,450.50 0.00 0.00 0.00 0.00 0.00 48,450.50 0.00 48,450.50 0.00 294 REGIONAL POLICE ACADEMY 99,878.09 0.00 807.70 123.19 0.00 0.00 99,193.58 0.00 99,193.58 0.00 295 COPS MORE GRANT 117,849.83 1,343.30 78.00 148.63 0.00 0.00 119,263.76 0.00 119,263.76 0.00 299 POLICE FEDERAL DRUG ENFORCEMENT 138,059.09 0.00 0.00 226.75 0.00 0.00 138,285.84 0.00 138,285.84 0.00 404 COUNTY OPTION INCOME TAX 11,091,772.67 942,459.35 946,275.64 13,917.79 0.00 0.00 11,101,874.17 0.00 11,101,874.17 867,317.80 408 ECONOMIC DEVELOPMENT INCOME TAX 15,585,632.90 893,413.25 672,503.83 19,593.04 0.00 0.00 15,826,135.36 0.00 15,826,135.36 0.00 410 URBAN DEVELOPMENT ACTION GRANT (UDAG)428,196.16 0.00 33,601.60 528.41 0.00 0.00 395,122.97 0.00 395,122.97 (867,317.80) 655 PROJECT RELEAF 735,619.93 39,154.71 2,666.33 1,025.84 0.00 0.00 773,134.15 0.00 773,134.15 0.00 705 POLICE K-9 UNIT 2,907.87 0.00 0.00 3.59 0.00 0.00 2,911.46 0.00 2,911.46 0.00 Total Special Revenue Funds 69,887,320.98 4,214,352.19 6,565,559.90 81,932.16 0.00 28,126.01 67,589,919.42 69,738.08 67,659,657.50 200,000.00 Debt Service Fund 312 2017 PARKS BOND DEBT SERVICE 404,542.86 0.00 593,303.69 99.91 0.00 0.00 (188,660.92)0.00 (188,660.92)0.00 313 HALL OF FAME DEBT SERVICE (358,411.25)0.00 0.00 0.00 0.00 0.00 (358,411.25)0.00 (358,411.25)0.00 755 SB BUILDING CORPORATION 664,424.41 0.00 0.00 723.00 0.00 0.00 665,147.41 0.00 665,147.41 0.00 757 2015 PARKS BOND DEBT SERVICE 524,799.80 62,921.88 0.00 253.53 0.00 0.00 587,975.21 0.00 587,975.21 0.00 760 EDDY ST. COMMONS DEBT SERVICE 2,503,649.59 0.00 0.00 531.59 0.00 0.00 2,504,181.18 0.00 2,504,181.18 0.00 Capital Project Funds 377 PROFESSIONAL SPORTS DEVELOPMENT (438,447.26)7,430.90 352,680.00 0.00 0.00 0.00 (783,696.36)0.00 (783,696.36)0.00 401 COVELESKI STADIUM CAPITAL 54,966.94 0.00 0.00 67.83 0.00 0.00 55,034.77 0.00 55,034.77 0.00 405 PARK NONREVERTING CAPITAL 115,166.21 566.00 5,285.86 67.26 0.00 0.00 110,513.61 0.00 110,513.61 0.00 2018 July. controllers cash report - Controllers Cash Report Page 3 of 5 City of South Bend Month of:July 2018 Controller's Cash Report Opening Interest Transfers Transfers Ending Total Cash &Interfund Loans Fund Fund Name Cash Balance Receipts Disbursements Earned In Out Cash Balance Investments Investments (Borrowing) 406 CUMULATIVE CAPITAL DEVELOPMENT 649,847.46 0.00 195,230.57 546.59 0.00 0.00 455,163.48 0.00 455,163.48 0.00 407 CUMULATIVE CAPITAL IMPROVEMENT 295,074.45 25,000.00 0.00 332.03 0.00 0.00 320,406.48 0.00 320,406.48 0.00 412 MAJOR MOVES CONSTRUCTION 2,765,232.01 246,664.00 120,795.18 3,412.36 0.00 0.00 2,894,513.19 0.00 2,894,513.19 4,208,792.61 416 MORRIS PERFORMING ARTS CENTER CAPITAL 399,124.05 2,520.00 4,144.14 490.68 0.00 0.00 397,990.59 0.00 397,990.59 0.00 450 PALAIS ROYALE HISTORIC PRESERVATION 119,508.14 1,704.85 0.00 145.76 0.00 0.00 121,358.75 0.00 121,358.75 0.00 451 2018 FIRE STATION #9 CAPITAL 4,879,202.53 0.00 109,679.40 6,021.14 0.00 0.00 4,775,544.27 0.00 4,775,544.27 0.00 471 2017 PARKS BOND CAPITAL 13,556,856.61 0.00 40,725.00 16,770.55 0.00 0.00 13,532,902.16 0.00 13,532,902.16 0.00 677 HALL OF FAME CAPITAL FUND 426,988.79 0.00 1,215.21 528.21 0.00 0.00 426,301.79 0.00 426,301.79 (426,301.79) 750 EQUIPMENT / VEHICLE LEASING 7,552,505.70 279,920.00 1,313,860.85 1,076.31 0.00 0.00 6,519,641.16 0.00 6,519,641.16 0.00 751 2015 PARKS BOND CAPITAL 1,696,692.13 0.00 4,819.76 364.86 0.00 0.00 1,692,237.23 0.00 1,692,237.23 0.00 753 SMART STREET BOND CAPITAL 189,435.80 0.00 119,251.73 45.86 0.00 0.00 70,229.93 0.00 70,229.93 0.00 759 EDDY ST COMMONS CAPITAL 16,129,365.10 0.00 2,282,638.98 5.44 0.00 0.00 13,846,731.56 0.00 13,846,731.56 Total Capital & Debt Service Funds 52,130,524.07 626,727.63 5,143,630.37 31,482.91 0.00 0.00 47,645,104.24 0.00 47,645,104.24 3,782,490.82 Enterprise Funds 287 EMS CAPITAL 4,785,768.39 0.00 596,733.80 5,375.87 0.00 0.00 4,194,410.46 0.00 4,194,410.46 0.00 288 EMS OPERATING 2,099,641.61 438,769.85 524,110.72 3,923.71 0.00 0.00 2,018,224.45 0.00 2,018,224.45 0.00 600 CONSOLIDATED BUILDING DEPARTMENT 2,648,906.62 136,042.71 377,276.01 3,168.88 0.00 0.00 2,410,842.20 0.00 2,410,842.20 0.00 601 PARKING GARAGES 1,322,750.43 129,744.49 185,145.91 1,588.21 0.00 0.00 1,268,937.22 0.00 1,268,937.22 (1,427,141.00) 610 SOLID WASTE OPERATIONS 373,375.19 486,147.96 371,840.00 782.86 0.00 0.00 488,466.01 0.00 488,466.01 0.00 611 SOLID WASTE CAPITAL 186,629.61 0.00 185,406.69 16.70 0.00 0.00 1,239.62 0.00 1,239.62 0.00 620 WATER WORKS OPERATIONS 2,742,261.05 1,866,835.57 1,523,010.90 2,873.47 6,406.92 173,647.50 2,921,718.61 0.00 2,921,718.61 0.00 622 WATER WORKS CAPITAL 1,776,348.33 168,530.00 6,624.70 2,178.32 8,052.50 0.00 1,948,484.45 0.00 1,948,484.45 0.00 624 WATER WORKS CUSTOMER DEPOSIT 1,518,077.63 12,900.13 15,361.36 1,877.88 0.00 1,877.88 1,515,616.40 0.00 1,515,616.40 0.00 625 WATER WORKS SINKING FUND 737,208.50 0.00 0.00 1,229.56 165,595.00 1,229.56 902,803.50 0.00 902,803.50 0.00 626 WATER WORKS BOND RESERVE 1,435,891.20 0.00 0.00 1,775.18 0.00 0.00 1,437,666.38 0.00 1,437,666.38 0.00 629 WATER WORKS RESERVE - O & M 2,670,169.40 0.00 0.00 3,299.48 0.00 3,299.48 2,670,169.40 0.00 2,670,169.40 0.00 640 SEWER REPAIR INSURANCE 1,899,987.81 57,131.22 39,009.38 2,344.24 0.00 0.00 1,920,453.89 0.00 1,920,453.89 0.00 641 SEWAGE WORKS OPERATIONS 11,270,497.56 3,840,179.60 2,681,350.63 16,192.45 6,671.55 982,961.54 11,469,228.99 0.00 11,469,228.99 0.00 642 SEWAGE WORKS CAPITAL 9,732,314.91 534,885.00 352,355.00 9,674.71 219,930.00 0.00 10,144,449.62 0.00 10,144,449.62 0.00 643 SEWAGE WORKS RESERVE - O & M 5,399,084.29 0.00 0.00 6,671.55 0.00 6,671.55 5,399,084.29 0.00 5,399,084.29 0.00 649 SEWAGE WORKS BOND SINKING 5,212,703.48 0.00 0.00 6,338.58 780,313.75 0.00 5,999,355.81 0.00 5,999,355.81 0.00 653 SEWAGE WORKS DEBT SERVICE RESERVE 4,159,984.59 0.00 0.00 5,598.56 0.00 0.00 4,165,583.15 0.00 4,165,583.15 0.00 659 2011 SEWER BOND 146.21 0.00 0.00 0.18 0.00 146.39 (0.00)0.00 (0.00)0.00 661 2012 SEWER BOND 17,114.70 0.00 0.00 21.12 0.00 17,135.82 0.00 0.00 0.00 0.00 670 CENTURY CENTER 1,695,295.24 492,115.25 79,898.19 0.00 0.00 0.00 2,107,512.30 0.00 2,107,512.30 0.00 671 CENTURY CENTER CAPITAL 855,763.94 0.00 0.00 72.68 0.00 0.00 855,836.62 0.00 855,836.62 0.00 672 CENTURY CENTER ENERGY SAVINGS 239,663.43 0.00 0.00 4.26 0.00 0.00 239,667.69 0.00 239,667.69 0.00 Total Enterprise Funds 62,779,584.12 8,163,281.78 6,938,123.29 75,008.45 1,186,969.72 1,186,969.72 64,079,751.06 0.00 64,079,751.06 (1,427,141.00) Internal Service Funds 222 CENTRAL SERVICES 1,103,652.75 1,061,902.13 1,131,709.72 800.25 0.00 0.00 1,034,645.41 0.00 1,034,645.41 0.00 224 CENTRAL SERVICES CAPITAL 118,813.67 0.00 5,711.11 148.50 0.00 0.00 113,251.06 0.00 113,251.06 0.00 226 LIABILITY INSURANCE 3,712,213.34 168,935.49 632,712.47 4,738.76 0.00 0.00 3,253,175.12 0.00 3,253,175.12 0.00 278 TAKE HOME VEHICLE POLICE 759,389.16 280.00 0.00 936.92 0.00 0.00 760,606.08 0.00 760,606.08 0.00 279 INNOVATION & TECHNOLOGY 311 CALL CENTER 2,314,136.10 567,506.00 441,065.42 2,524.08 0.00 0.00 2,443,100.76 0.00 2,443,100.76 0.00 711 SELF-FUNDED EMPLOYEE BENEFITS 11,676,523.76 1,503,207.29 1,412,493.32 15,021.82 0.00 0.00 11,782,259.55 0.00 11,782,259.55 0.00 713 UNEMPLOYMENT COMP FUND 209,260.04 0.00 1,728.00 260.74 0.00 0.00 207,792.78 0.00 207,792.78 0.00 714 PARENTAL LEAVE FUND 37,691.71 12,566.66 13,384.20 45.32 0.00 0.00 36,919.49 0.00 36,919.49 0.00 Total Internal Service Funds 19,931,680.53 3,314,397.57 3,638,804.24 24,476.39 0.00 0.00 19,631,750.25 0.00 19,631,750.25 0.00 2018 July. controllers cash report - Controllers Cash Report Page 4 of 5 City of South Bend Month of:July 2018 Controller's Cash Report Opening Interest Transfers Transfers Ending Total Cash &Interfund Loans Fund Fund Name Cash Balance Receipts Disbursements Earned In Out Cash Balance Investments Investments (Borrowing) Trust & Agency Funds 701 FIREFIGHTERS PENSION 302,985.98 0.00 384,851.46 0.00 0.00 0.00 (81,865.48)0.00 (81,865.48)0.00 702 POLICE PENSION 853,441.34 228.66 506,179.74 0.00 0.00 0.00 347,490.26 0.00 347,490.26 0.00 709 PAYROLL FUND 0.00 8,695,935.51 8,695,935.51 0.00 0.00 0.00 0.00 0.00 0.00 0.00 718 STATE TAX DEDUCTION FUND 419,538.62 284,475.69 419,538.62 0.00 0.00 0.00 284,475.69 0.00 284,475.69 0.00 725 MORRIS / PALAIS BOX OFFICE 1,988,870.26 210,707.20 0.00 0.00 0.00 0.00 2,199,577.46 0.00 2,199,577.46 0.00 726 POLICE DISTRIBUTIONS PAYABLE 855,181.96 2,153.50 0.00 0.00 0.00 0.00 857,335.46 0.00 857,335.46 0.00 730 CITY CEMETERY TRUST 28,698.81 0.00 0.00 35.41 0.00 0.00 28,734.22 0.00 28,734.22 0.00 Total Trust & Agency Funds 4,448,716.97 9,193,500.56 10,006,505.33 35.41 0.00 0.00 3,635,747.61 0.00 3,635,747.61 0.00 Total City Funds 247,789,922.17 27,022,179.38 36,838,402.19 239,075.64 1,186,969.72 1,215,095.73 238,184,648.99 69,738.08 238,254,387.07 2,981,651.61 Redevelopment Commission Controlled Funds Tax Increment Financing Funds 324 TIF RIVER WEST 36,022,616.87 0.00 3,000,956.00 34,090.23 3,435.14 0.00 33,059,186.24 0.00 33,059,186.24 (200,000.00) 422 TIF DISTRICT - WEST WASHINGTON 2,313,759.15 0.00 30,244.00 2,683.92 0.00 0.00 2,286,199.07 0.00 2,286,199.07 0.00 425 TIF LEIGHTON PLAZA 180,073.91 0.00 0.00 196.66 0.00 0.00 180,270.57 0.00 180,270.57 0.00 429 TIF RIVER EAST DEV (NE)9,653,675.44 0.00 14,036.50 10,530.09 0.00 0.00 9,650,169.03 0.00 9,650,169.03 0.00 430 TIF SOUTHSIDE DEVELOPMENT AREA #1 8,983,381.53 0.00 40,813.75 9,905.91 0.00 0.00 8,952,473.69 0.00 8,952,473.69 0.00 435 TIF DOUGLAS ROAD 202,302.24 0.00 0.00 249.65 0.00 0.00 202,551.89 0.00 202,551.89 0.00 436 TIF RIVER EAST RES (NE RE) 3,999,194.85 0.00 246,664.00 0.00 0.00 0.00 3,752,530.85 0.00 3,752,530.85 (2,781,651.61) Total Tax Increment Financing Funds 61,355,003.99 0.00 3,332,714.25 57,656.46 3,435.14 0.00 58,083,381.34 0.00 58,083,381.34 (2,981,651.61) Redevelopment Funds 433 REDEVELOPMENT ADMINISTRATION GENERAL 6,890.30 0.00 0.00 9.17 28,126.01 0.00 35,025.48 0.00 35,025.48 0.00 439 CERTIFIED TECHNOLOGY PARK 618,004.68 0.00 0.00 762.64 0.00 0.00 618,767.32 0.00 618,767.32 0.00 452 2018 TIF PARK BOND CAPITAL 10,809,411.24 25,670.18 41,295.18 0.00 0.00 0.00 10,793,786.24 0.00 10,793,786.24 0.00 454 AIRPORT URBAN ENTERPRISE ZONE 389,741.63 0.00 0.00 480.95 0.00 0.00 390,222.58 0.00 390,222.58 0.00 754 INDUSTRIAL REVOLVING FUND 2,749,195.00 6,642.00 8,831.00 20,185.00 0.00 0.00 2,767,191.00 0.00 2,767,191.00 0.00 Total Redevelopment Funds 14,573,242.85 32,312.18 50,126.18 21,437.76 28,126.01 0.00 14,604,992.62 0.00 14,604,992.62 0.00 Debt Service Funds 315 AIRPORT 2003 DEBT RESERVE 1,040,462.24 0.00 0.00 1,285.68 0.00 1,285.68 1,040,462.24 0.00 1,040,462.24 0.00 317 COVELESKI BOND DEBT RESERVE 521,357.65 0.00 0.00 643.37 0.00 0.00 522,001.02 0.00 522,001.02 0.00 328 SBCDA 2003 DEBT RESERVE 1,739,494.86 0.00 0.00 2,149.46 0.00 2,149.46 1,739,494.86 0.00 1,739,494.86 0.00 351 2018 TIF PARK BOND DEBT SERVICE RESERVE 993,495.00 0.00 0.00 0.00 0.00 0.00 993,495.00 0.00 993,495.00 752 SB REDEVELOPMENT AUTHORITY 47,407.10 0.00 0.00 63.49 0.00 0.00 47,470.59 0.00 47,470.59 0.00 756 SMARTS STREETS DEBT SERVICE 1,722,178.86 0.00 0.00 365.74 0.00 0.00 1,722,544.60 0.00 1,722,544.60 0.00 Total Debt Service Funds 6,064,395.71 0.00 0.00 4,507.74 0.00 3,435.14 6,065,468.31 0.00 6,065,468.31 0.00 Total Redevelopment Commission Funds 81,992,642.55 32,312.18 3,382,840.43 83,601.96 31,561.15 3,435.14 78,753,842.27 0.00 78,753,842.27 (2,981,651.61) City Operations Total 329,782,564.72 27,054,491.56 40,221,242.62 322,677.60 1,218,530.87 1,218,530.87 316,938,491.26 69,738.08 317,008,229.34 0.00 Memo Item Pooled Investment Account Opening Interest Accrued Change in Transfer In Transfer out Investment Total Cash & Balance Net of Fees Income Asset Value from Depository to Depository Balance Investments 1st Source Bank Investment Account 183,995,204.84 280,031.53 0.00 86,788.07 0.00 185,930.81 184,176,093.63 184,176,093.63 2018 July. controllers cash report - Controllers Cash Report Page 5 of 5