Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
11-2017 Cash Reserve Summary
Period Ending: Issued by: City of South Bend Cash Reserves Summary Page Number(s)Contents 2 - 3 Funds by Status 4 - 6 Cash Reserves Summary 7 General Fund Trends 8 Parks & Recreation Fund Trends 9 Motor Vehicle Highway Fund Trends 10 Liability Insurance Fund Trends 11 Public Safety LOIT Fund Trends 12 County Option Income Tax Fund (COIT) Trends 13 Economic Development Income Tax Fund (EDIT) Trends 14 Self-funded Employee Benefits Fund Trends 15 - 17 Controller's Cash Report Distribution Mayor Pete Buttigieg Chief of Staff Laura O'Sullivan Deputy Chief of Staff Suzanna Fritzberg Common Council Department Heads Fiscal Officers November 30, 2017 Controller Cash Reserve Report 1 City of South BendCash Reserves Summary by Fund Status ActualFund Fund NameCash Outstanding Available Cash ReservePercentageBalance Encumbrances Cash Requirement Variance of Budget Notes Threshold MeasurementInsufficient Balances201 PARKS & RECREATION 2,002,482.91 559,412.28 1,443,070.63 4,760,722.00(3,317,651.37)8%Property taxes received June & December 25%Annual expenditures219 UNSAFE BUILDING 267,500.40 73,964.78 193,535.62 226,369.75(32,834.13)21%Encumbrances 25%Annual expenditures432 TIF SSDA #3 - ERSKINE VILLAGE 0.00 0.00 0.00 1,219,698.75(1,219,698.75)0%Pay off loan, then close 25%Annual expenditures610 SOLID WASTE OPERATIONS 534,189.26 152,454.53 381,734.73 566,291.00(184,556.27)7%Working to increase fund reserves 10%Annual expenditures643 SEWAGE WORKS RESERVE - O & M 5,153,129.15 0.00 5,153,129.15 5,201,280.05(48,150.90)16.52%Just slightly under reserve requirement 16.67%Annual operating expenses in Fund 641, net of transfers7,957,301.72 785,831.59 7,171,470.13 11,974,361.55(4,802,891.42)Meets or Exceeds Requirements101 GENERAL FUND 22,944,498.49 1,349,655.45 21,594,843.04 21,052,606.75 542,236.29 36%35%Annual expenditures102 RAINY DAY FUND 10,278,731.88 0.00 10,278,731.88 8,620,603.69 1,658,128.19 4%3%Total expenditures in previous fiscal year-contingency202 MOTOR VEHICLE HIGHWAY 6,729,754.44 598,216.24 6,131,538.20 2,941,382.75 3,190,155.45 52%25%Annual expenditures203 RECREATION - NONREVERTING 794,378.18 103,482.75 690,895.43 399,920.75 290,974.68 43%25%Annual expenditures211 DCI ADMINISTRATION FUND 958,947.44 126,360.32 832,587.12 693,844.00 138,743.12 30%25%Annual expenditures216 POLICE STATE SEIZURES 257,416.71 0.00 257,416.71 29,000.00 228,416.71 222%25%Annual expenditures218 POLICE CURFEW VIOLATIONS 12,840.57 0.00 12,840.57 250.00 12,590.57 1284%25%Annual expenditures220 LAW ENFORCEMENT CONTINUING EDUCATION 554,897.02 58,305.67 496,591.35 197,105.50 299,485.85 63%25%Annual expenditures222 CENTRAL SERVICES 1,184,047.89 26,223.36 1,157,824.53 1,101,160.75 56,663.78 26%25%Annual expenditures, excluding utility accounting226 LIABILITY INSURANCE 4,651,761.20 34,572.49 4,617,188.71 1,793,793.00 2,823,395.71 129%50%Annual expenditures249 PUBLIC SAFETY L.O.I.T. 1,172,950.34 0.00 1,172,950.34 597,011.60575,938.74 16%8%Annual expenditures - one month reserve251 LOCAL ROADS & STREETS 3,111,247.80 228,518.73 2,882,729.07 577,136.00 2,305,593.07 125%25%Annual expenditures258 HUMAN RIGHTS - FEDERAL GRANT 506,261.47 2,157.13 504,104.34 50,443.25 453,661.09 250%25%Annual expenditures273 MORRIS PAC/PALAIS ROYALE MARKETING 52,272.90 0.00 52,272.90 5,418.75 46,854.15 241%25%Annual expenditures278 TAKE HOME VEHICLE POLICE 753,878.45 0.00 753,878.45 750,000.00 3,878.45 7539%750,000$ set dollar amount287 EMS / FIRE DEPARTMENT CAPITAL 4,319,150.89 736,155.53 3,582,995.36 997,866.50 2,585,128.86 90%25%Annual expenditures288 EMS / FIRE DEPARTMENT OPERATING 2,032,669.53 144,389.80 1,888,279.73 1,534,478.50 353,801.23 31%25%Annual expenditures289 HAZMAT 24,290.52 0.00 24,290.52 2,607.75 21,682.77 233%25%Annual expenditures291 INDIANA RIVER RESCUE 121,624.52 183.78 121,440.74 29,337.25 92,103.49 103%25%Annual expenditures294 REGIONAL POLICE ACADEMY 86,898.09 0.00 86,898.09 5,625.00 81,273.09 386%25%Annual expenditures299 POLICE FEDERAL DRUG ENFORCEMENT 130,626.01 0.00 130,626.01 71,584.25 59,041.76 46%25%Annual expenditures315 AIRPORT 2003 DEBT RESERVE 1,038,904.00 0.00 1,038,904.00 1,038,904.00 0.00 100%100%100% debt service reserve per bond covenants317 COVELESKI BOND DEBT RESERVE 517,214.64 0.00 517,214.64 517,214.64 0.00 100%100%100% debt service reserve per bond covenants319 REDEVELOPMENT BOND - BLACKTHORN GOLF 0.00 0.00 0.00 0.00 0.00 100%100%100% debt service reserve per bond covenants324 RIVER WEST TIF (AIRPORT TIF) 27,109,510.54 11,061,635.88 16,047,874.66 9,904,721.75 6,143,152.91 41%25%Annual expenditures328 SBCDA 2003 DEBT RESERVE 1,735,840.00 0.00 1,735,840.00 1,735,840.00 0.00 100%100%100% debt service reserve per bond covenants404 COUNTY OPTION INCOME TAX 8,892,903.86 207,418.23 8,685,485.63 6,035,796.50 2,649,689.13 72%50%Annual expenditures405 PARK NONREVERTING CAPITAL 189,244.93 27,275.62 161,969.31 138,256.00 23,713.31 29%25%Annual expenditures406 CUMULATIVE CAPITAL DEVELOPMENT 405,269.28 0.00 405,269.28 119,125.00 286,144.28 85%25%Annual expenditures407 CUMULATIVE CAPITAL IMPROVEMENT 301,278.61 0.00 301,278.61 93,062.50 208,216.11 81%25%Annual expenditures408 ECONOMIC DEVELOPMENT INCOME TAX 13,635,047.25 536,453.58 13,098,593.67 5,779,592.00 7,319,001.67 113%50%Annual expenditures416 MORRIS PERFORMING ARTS CENTER CAPITAL 604,418.54 203,802.12 400,616.42 100,286.00 300,330.42 100%25%Annual expenditures422 TIF DISTRICT - WEST WASHINGTON 2,105,427.12 445,400.69 1,660,026.43 357,073.00 1,302,953.43 116%25%Annual expenditures425 TIF LEIGHTON PLAZA 178,049.09 0.00 178,049.09 39,541.50 138,507.59 113%25%Annual expenditures429 RIVER EAST DEV TIF (NORTHEAST TIF) 7,902,964.26 1,892,595.39 6,010,368.87 2,650,674.00 3,359,694.87 57%25%Annual expenditures430 TIF SOUTHSIDE DEVELOPMENT AREA #1 6,906,923.27 707,184.55 6,199,738.72 1,729,356.50 4,470,382.22 90%25%Annual expenditures433 REDEVELOPMENT ADMINISTRATION GENERAL 7,392.13 0.00 7,392.13 1,125.00 6,267.13 164%25%Annual expenditures435 TIF - DOUGLAS ROAD 40,073.67 4,200.00 35,873.67 34,421.60 1,452.07 10%10%Annual expenditures436 RIVER EAST RESIDENTIAL (NE RES TIF) 1,550,032.15 0.00 1,550,032.15 857,557.75 692,474.40 45%25%Annual expenditures450 PALAIS ROYALE HISTORIC PRESERVATION 108,187.83 0.00 108,187.83 1,250.00 106,937.83 2164%25%Annual expenditures600 CONSOLIDATED BUILDING DEPARTMENT 2,794,667.40 70,799.03 2,723,868.37 946,410.75 1,777,457.62 72%25%Annual expenditures601 PARKING GARAGES 1,299,255.54 262,253.95 1,037,001.59 311,813.50 725,188.09 83%25%Annual expenditures620 WATER WORKS OPERATIONS 3,944,891.51 897,127.74 3,047,763.77 886,362.70 2,161,401.07 17%5%Annual expenditures624 WATER WORKS CUSTOMER DEPOSIT 1,510,836.49 0.00 1,510,836.49 1,510,836.49 0.00 100%100%100% cash reserves for customer deposits625 WATER WORKS SINKING FUND 1,561,497.89 0.00 1,561,497.89 1,561,497.89 0.00 100%100%100% cash reserves per bond covenants626 WATER WORKS BOND RESERVE 1,424,519.25 0.00 1,424,519.25 1,424,519.25 0.00 100%100%100% cash reserves per bond covenants and Crowe Horwath629 WATER WORKS RESERVE - O & M 2,613,999.68 0.00 2,613,999.68 2,601,580.71 12,418.97 16.75%16.67%Annual operating expenses in Fund 620, net of transfers640 SEWER REPAIR INSURANCE 1,880,033.69 54,656.65 1,825,377.04 158,627.25 1,666,749.79 288%25%Annual expenditures641 SEWAGE WORKS OPERATIONS 13,940,684.29 3,840,046.58 10,100,637.71 2,241,559.25 7,859,078.46 23%5%Annual expenditures649 SEWAGE WORKS BOND SINKING 84,253.38 0.00 84,253.38 84,253.38 0.00100%100%100% cash reserves per bond covenants653 SEWAGE WORKS DEBT SERVICE RESERVE 4,131,914.86 0.00 4,131,914.86 4,131,914.86 0.00 100%100%100% cash reserves per bond covenants and Crowe Horwath655 PROJECT RELEAF 896,112.80 1,222.24 894,890.56 134,292.75 760,597.81 167%25%Annual expenditures670 CENTURY CENTER 1,389,280.39 0.00 1,389,280.39 1,048,577.50 340,702.89 33%25%Annual expenditures671 CENTURY CENTER CAPITAL 865,279.14 0.00 865,279.14 800,000.00 65,279.14 100%$800,000Minimum per Board of Managers701 FIREFIGHTERS PENSION 851,069.24 0.00 851,069.24 509,826.90 341,242.34 17%10%Annual expenditures702 POLICE PENSION 1,387,500.71 0.00 1,387,500.71 642,388.90 745,111.81 22%10%Annual expenditures703 POLICE/FIRE 1977 STATE PENSION 0.00 0.00 0.00 0.00 0.00 100%100%100% cash reserves - trust & agency funds705 POLICE K-9 UNIT 2,884.77 0.00 2,884.77 505.00 2,379.77 143%25%Annual expendituresNovember 30, 2017Cash Reserve PolicyCash Reserve Report2 City of South BendCash Reserves Summary by Fund Status ActualFund Fund NameCash Outstanding Available Cash ReservePercentageBalance Encumbrances Cash Requirement Variance of Budget Notes Threshold MeasurementNovember 30, 2017Cash Reserve Policy709 PAYROLL FUND 0.00 0.00 0.00 0.00 0.00 100%100%100% cash reserves - trust & agency funds711 SELF-FUNDED EMPLOYEE BENEFITS 9,421,738.31 45,228.66 9,376,509.65 4,450,800.00 4,925,709.65 53%25%Annual expenditures712 PUBLIC EMPLOYEES RETIREMENT FUND 0.00 0.00 0.00 0.00 0.00 100%100%100% cash reserves - trust & agency funds713 UNEMPLOYMENT COMP FUND 231,341.54 11,000.00 220,341.54 21,026.25199,315.29 262%25%Annual expenditures718 STATE TAX DEDUCTION FUND 278,674.15 0.00 278,674.15 278,674.15 0.00 100%100%100% cash reserves - trust & agency funds725 MORRIS / PALAIS BOX OFFICE 2,495,148.18 0.00 2,495,148.18 2,495,148.18 0.00 100%100%100% cash reserves - trust & agency funds726 POLICE DISTRIBUTIONS PAYABLE 839,350.50 0.00 839,350.50 839,350.50 0.00 100%100%100% cash reserves - trust & agency funds730 CITY CEMETERY TRUST 28,470.76 0.00 28,470.76 1,500.00 26,970.76 475%25%Annual expenditures750 EQUIPMENT/VEHICLE LEASING 4,289,838.44 3,007,993.55 1,281,844.89 1,281,844.89 0.00 100%100%100% cash reserves per bond covenants751 PARKS BOND CAPITAL 3,294,213.12 33,238.17 3,260,974.95 3,260,974.95 0.00 100%100%100% cash reserves per bond covenants752 SOUTH BEND REDEVELOPMENT AUTHORITY 561,388.42 0.00 561,388.42 561,388.42 0.00 100%100%100% cash reserves per bond covenants753 SMART STREET BOND CAPITAL 1,063,473.55 0.00 1,063,473.55 1,063,473.55 0.00 100%100%100% cash reserves per bond covenants755 SOUTH BEND BUILDING CORPORATION 771,822.21 0.00 771,822.21 771,822.21 0.00 100%100%100% cash reserves per bond covenants756 SMART STREETS DEBT SERVICE FUND 1,718,071.18 0.00 1,718,071.18 1,718,071.18 0.00 100%100%100% cash reserves per bond covenants757 PARKS BOND DEBT SERVICE 525,742.21 0.00 525,742.21 525,742.21 0.00 100%100%100% cash reserves per bond covenants758 ERSKINE VILLAGE DEBT SERVICE 0.00 0.00 0.00 0.00 0.00 100%100%100% cash reserves per bond covenants760 EDDY ST. COMMONS DEBT SERVICE 2,500,643.87 0.00 2,500,643.87 0.00 2,500,643.87 100%100%100% cash reserves per bond covenants202,506,422.98 26,717,753.88 175,788,669.10 108,849,757.35 66,938,911.75No Reserve Requirements103 EXCESS LEVY 0.00 0.00 0.00 0.00 0.00 100%0%No reserve requirement209 STUDEBAKER/OLIVER REVERTING GRANTS 909,642.69 131,171.67 778,471.02 0.00 778,471.02 100%0%No reserve requirement210 DEPT COMMUNITY INVESTMENT STATE GRANTS 356,929.75 185,120.00 171,809.75 0.00 171,809.75 100%To be reimbursed by grant receipts 0%No reserve requirement212 DCI GRANT FUND 436,923.72 2,329,131.16 (1,892,207.44) 0.00(1,892,207.44)100%To be reimbursed by grant receipts 0%Grant fund - reimbursement grants - no reserves217 GIFT, DONATION, BEQUEST 103,768.40 3,461.00 100,307.40 0.00 100,307.40 100%0%No reserve requirement221 LANDLORD REGISTRATION 8,655.00 0.00 8,655.00 0.00 8,655.00 100%0%No reserve requirement224 CENTRAL SERVICES CAPITAL 200,554.32 75,291.40 125,262.92 0.00 125,262.92 100%0%No reserve requirement227 LOSS RECOVERY FUND 847,373.50 265,209.23 582,164.27 0.00 582,164.27 100%0%No reserve requirement244 EMERGENCY PHONE SYSTEM 0.00 0.00 0.00 0.00 0.00 100%0%No reserve requirement252 EXCESS WELFARE DISTRIBUTION 0.00 0.00 0.00 0.00 0.00 100%0%No reserve requirement257 LOIT 2016 SPECIAL DISTRIBUTION 2,328,569.05 1,306,037.20 1,022,531.85 0.00 1,022,531.85 100%0%No reserve requirement265 LOCAL ROAD & BRIDGE GRANT 1,533,265.02 977,953.70 555,311.32 0.00 555,311.32 100%0%No reserve requirement271 EASTRACE WATERWAY 3.35 0.00 3.35 0.00 3.35 100%0%No reserve requirement279 311 CALL CENTER 1,537,196.99 355,295.62 1,181,901.37 0.00 1,181,901.37 100%Will be reimbursed through inter-fund xfr 0%No reserve requirement280 POLICE BLOCK GRANTS 3,921.39 0.00 3,921.39 0.00 3,921.39 100%0%No reserve requirement281 REDEVELOPMENT COMMISSION - REV BONDS 27,868.13 0.00 27,868.13 0.00 27,868.13 100%0%No reserve requirement292 POLICE GRANTS 48,450.50 4,756.20 43,694.30 0.00 43,694.30 100%0%No reserve requirement295 COPS MORE GRANT 154,687.79 40,826.12 113,861.67 0.00 113,861.67 100%0%No reserve requirement313 HALL OF FAME DEBT SERVICE (376,413.04) 0.00 (376,413.04) 0.00(376,413.04)100%Will be reimbursed from property taxes 0%No reserve requirement377 PROFESSIONAL SPORTS DEVELOPMENT (172,095.98) 0.00 (172,095.98) 0.00(172,095.98)100%Delay in State revenue distributions 0%No reserve requirement401 COVELESKI STADIUM CAPITAL 54,530.17 0.00 54,530.17 0.00 54,530.17100%0%No reserve requirement403 ZOO ENDOWMENT 0.00 0.00 0.00 0.00 0.00 100%0%No reserve requirement410 URBAN DEVELOPMENT ACTION GRANT (UDAG) 471,232.52 0.00 471,232.52 0.00 471,232.52 100%0%No reserve requirement412 MAJOR MOVES CONSTRUCTION 2,906,523.83 1,057,837.67 1,848,686.160.00 1,848,686.16 100%0%No reserve requirement434 CRED FUND 0.00 0.00 0.00 0.00 0.00 100%0%No reserve requirement439 CERTIFIED TECHNOLOGY PARK 613,093.67 0.00 613,093.67 0.00 613,093.67 100%0%No reserve requirement454 AIRPORT URBAN ENTERPRISE ZONE 386,644.52 0.00 386,644.52 0.00 386,644.52 100%0%No reserve requirement611 SOLID WASTE CAPITAL 40,331.98 0.00 40,331.98 0.00 40,331.98 100%0%No reserve requirement622 WATER WORKS CAPITAL 2,130,787.24 371,787.30 1,758,999.94 0.00 1,758,999.94 100%0%No reserve requirement642 SEWAGE WORKS CAPITAL 7,401,491.36 1,204,994.00 6,196,497.36 0.006,196,497.36 100%0%No Reserves - transfer from operating account as needed645 2006 SEWER BOND 0.00 0.00 0.00 0.00 0.00 100%0%Bond fund - spend down to zero - no reserves647 2007 SEWER BOND 0.00 0.00 0.00 0.00 0.00 100%0%Bond fund - spend down to zero - no reserves651 2007B SEWER BOND 0.00 0.00 0.00 0.00 0.00 100%0%Bond fund - spend down to zero - no reserves required658 2010 SEWER BOND 0.00 0.00 0.00 0.00 0.00 100%0%Bond fund - spend down to zero - no reserves required659 2011 SEWER BOND 145.04 0.00 145.04 0.00 145.04 100%0%Bond fund - spend down to zero - no reserves required661 2012 SEWER BOND 642,150.74 632,185.84 9,964.90 0.00 9,964.90 100%0%Bond fund - spend down to zero - no reserves required664 2013A SEWER REFUNDING BOND 0.00 0.00 0.00 0.00 0.00 100%0%Bond fund - spend down to zero - no reserves required666 2015 SEWER BOND 0.00 0.00 0.00 0.00 0.00 100%0%Bond fund - spend down to zero - no reserves required672 CENTURY CENTER ENERGY SAVINGS 58,877.40 0.00 58,877.40 0.00 58,877.40 100%0%No reserve requirement677 HALL OF FAME CAPITAL FUND 457,737.25 11,490.16 446,247.09 0.00 446,247.09 100%0%No reserve requirement754 INDUSTRIAL REVOLVING FUND 2,879,898.00 0.00 2,879,898.00 0.00 2,879,898.00 100%0%No City reserve requirement; there are program requirements759 EDDY ST COMMONS CAPITAL 22,103,750.00 0.00 22,103,750.00 0.00 22,103,750.00 100%0%Bond fund - spend down to zero - no reserves required48,096,494.30 8,952,548.27 39,143,946.03 0.00 39,143,946.03City Operations Total 258,560,219.00 36,456,133.74 222,104,085.26 120,824,118.90 101,279,966.36Cash Reserve Report3 City of South BendCash Reserves Summary by Fund ActualFund Fund NameCash Outstanding Available Cash ReservePercentageBalance Encumbrances Cash Requirement Variance of Budget Notes Threshold MeasurementCity Controlled FundsGeneral Fund101 GENERAL FUND 22,944,498.49 1,349,655.45 21,594,843.04 21,052,606.75 542,236.29 36%35%Annual expendituresSpecial Revenue Funds102 RAINY DAY FUND 10,278,731.88 0.00 10,278,731.88 8,620,603.69 1,658,128.19 4%3%Total expenditures in previous fiscal year-contingency103 EXCESS LEVY 0.00 0.00 0.00 0.00 0.00 100%0%No reserve requirement201 PARKS & RECREATION 2,002,482.91 559,412.28 1,443,070.63 4,760,722.00(3,317,651.37)8%Property taxes received June & December 25%Annual expenditures202 MOTOR VEHICLE HIGHWAY 6,729,754.44 598,216.24 6,131,538.20 2,941,382.75 3,190,155.45 52%25%Annual expenditures203 RECREATION - NONREVERTING 794,378.18 103,482.75 690,895.43 399,920.75 290,974.68 43%25%Annual expenditures209 STUDEBAKER/OLIVER REVERTING GRANTS 909,642.69 131,171.67 778,471.02 0.00 778,471.02 100%0%No reserve requirement210 DEPT COMMUNITY INVESTMENT STATE GRANTS 356,929.75 185,120.00 171,809.75 0.00 171,809.75 100%To be reimbursed by grant receipts 0%No reserve requirement211 DCI ADMINISTRATION FUND 958,947.44 126,360.32 832,587.12 693,844.00 138,743.12 30%25%Annual expenditures212 DCI GRANT FUND 436,923.72 2,329,131.16 (1,892,207.44) 0.00(1,892,207.44)100%To be reimbursed by grant receipts 0%Grant fund - reimbursement grants - no reserves216 POLICE STATE SEIZURES 257,416.71 0.00 257,416.71 29,000.00 228,416.71 222%25%Annual expenditures217 GIFT, DONATION, BEQUEST 103,768.40 3,461.00 100,307.40 0.00 100,307.40 100%0%No reserve requirement218 POLICE CURFEW VIOLATIONS 12,840.57 0.00 12,840.57 250.00 12,590.57 1284%25%Annual expenditures219 UNSAFE BUILDING 267,500.40 73,964.78 193,535.62 226,369.75(32,834.13)21%Encumbrances 25%Annual expenditures220 LAW ENFORCEMENT CONTINUING EDUCATION 554,897.02 58,305.67 496,591.35 197,105.50 299,485.85 63%25%Annual expenditures221 LANDLORD REGISTRATION 8,655.00 0.00 8,655.00 0.00 8,655.00 100%0%No reserve requirement227 LOSS RECOVERY FUND 847,373.50 265,209.23 582,164.27 0.00 582,164.27 100%0%No reserve requirement244 EMERGENCY PHONE SYSTEM 0.00 0.00 0.00 0.00 0.00 100%0%No reserve requirement249 PUBLIC SAFETY L.O.I.T. 1,172,950.34 0.00 1,172,950.34 597,011.60575,938.74 16%8%Annual expenditures - one month reserve251 LOCAL ROADS & STREETS 3,111,247.80 228,518.73 2,882,729.07 577,136.00 2,305,593.07 125%25%Annual expenditures252 EXCESS WELFARE DISTRIBUTION 0.00 0.00 0.00 0.00 0.00 100%0%No reserve requirement257 LOIT 2016 SPECIAL DISTRIBUTION 2,328,569.05 1,306,037.20 1,022,531.85 0.00 1,022,531.85 100%0%No reserve requirement258 HUMAN RIGHTS - FEDERAL GRANT 506,261.47 2,157.13 504,104.34 50,443.25 453,661.09 250%25%Annual expenditures265 LOCAL ROAD & BRIDGE GRANT 1,533,265.02 977,953.70 555,311.32 0.00 555,311.32 100%0%No reserve requirement271 EASTRACE WATERWAY 3.35 0.00 3.35 0.00 3.35 100%0%No reserve requirement273 MORRIS PAC/PALAIS ROYALE MARKETING 52,272.90 0.00 52,272.90 5,418.75 46,854.15 241%25%Annual expenditures279 311 CALL CENTER 1,537,196.99 355,295.62 1,181,901.37 0.00 1,181,901.37 100%Will be reimbursed through inter-fund xfr 0%No reserve requirement280 POLICE BLOCK GRANTS 3,921.39 0.00 3,921.39 0.00 3,921.39 100%0%No reserve requirement281 REDEVELOPMENT COMMISSION - REV BONDS 27,868.13 0.00 27,868.13 0.00 27,868.13 100%0%No reserve requirement289 HAZMAT 24,290.52 0.00 24,290.52 2,607.75 21,682.77 233%25%Annual expenditures291 INDIANA RIVER RESCUE 121,624.52 183.78 121,440.74 29,337.25 92,103.49 103%25%Annual expenditures292 POLICE GRANTS 48,450.50 4,756.20 43,694.30 0.00 43,694.30 100%0%No reserve requirement294 REGIONAL POLICE ACADEMY 86,898.09 0.00 86,898.09 5,625.00 81,273.09 386%25%Annual expenditures295 COPS MORE GRANT 154,687.79 40,826.12 113,861.67 0.00 113,861.67 100%0%No reserve requirement299 POLICE FEDERAL DRUG ENFORCEMENT 130,626.01 0.00 130,626.01 71,584.25 59,041.76 46%25%Annual expenditures404 COUNTY OPTION INCOME TAX 8,892,903.86 207,418.23 8,685,485.63 6,035,796.50 2,649,689.13 72%50%Annual expenditures408 ECONOMIC DEVELOPMENT INCOME TAX 13,635,047.25 536,453.58 13,098,593.67 5,779,592.00 7,319,001.67 113%50%Annual expenditures410 URBAN DEVELOPMENT ACTION GRANT (UDAG) 471,232.52 0.00 471,232.52 0.00 471,232.52 100%0%No reserve requirement655 PROJECT RELEAF 896,112.80 1,222.24 894,890.56 134,292.75 760,597.81 167%25%Annual expenditures705 POLICE K-9 UNIT 2,884.77 0.00 2,884.77 505.00 2,379.77 143%25%Annual expendituresTotal Special Revenue Funds59,258,557.68 8,094,657.63 51,163,900.05 31,158,548.54 20,005,351.51 Debt Service Fund313 HALL OF FAME DEBT SERVICE (376,413.04) 0.00 (376,413.04) 0.00(376,413.04)100%Will be reimbursed from property taxes 0%No reserve requirement755 SOUTH BEND BUILDING CORPORATION 771,822.21 0.00 771,822.21 771,822.21 0.00 100%100%100% cash reserves per bond covenants757 PARKS BOND DEBT SERVICE 525,742.21 0.00 525,742.21 525,742.21 0.00 100%100%100% cash reserves per bond covenants760 EDDY ST. COMMONS DEBT SERVICE 2,500,643.87 0.00 2,500,643.87 0.00 2,500,643.87 100%100%100% cash reserves per bond covenantsCapital Project Funds377 PROFESSIONAL SPORTS DEVELOPMENT (172,095.98) 0.00 (172,095.98) 0.00(172,095.98)100%Delay in State revenue distributions 0%No reserve requirement401 COVELESKI STADIUM CAPITAL 54,530.17 0.00 54,530.17 0.00 54,530.17100%0%No reserve requirement403 ZOO ENDOWMENT 0.00 0.00 0.00 0.00 0.00 100%0%No reserve requirement405 PARK NONREVERTING CAPITAL 189,244.93 27,275.62 161,969.31 138,256.00 23,713.31 29%25%Annual expenditures406 CUMULATIVE CAPITAL DEVELOPMENT 405,269.28 0.00 405,269.28 119,125.00 286,144.28 85%25%Annual expenditures407 CUMULATIVE CAPITAL IMPROVEMENT 301,278.61 0.00 301,278.61 93,062.50 208,216.11 81%25%Annual expenditures412 MAJOR MOVES CONSTRUCTION 2,906,523.83 1,057,837.67 1,848,686.160.00 1,848,686.16 100%0%No reserve requirement416 MORRIS PERFORMING ARTS CENTER CAPITAL 604,418.54 203,802.12 400,616.42 100,286.00 300,330.42 100%25%Annual expenditures434 CRED FUND 0.00 0.00 0.00 0.00 0.00 100%0%No reserve requirement450 PALAIS ROYALE HISTORIC PRESERVATION 108,187.83 0.00 108,187.83 1,250.00 106,937.83 2164%25%Annual expenditures677 HALL OF FAME CAPITAL FUND 457,737.25 11,490.16 446,247.09 0.00 446,247.09 100%0%No reserve requirement751 PARKS BOND CAPITAL 3,294,213.12 33,238.17 3,260,974.95 3,260,974.95 0.00 100%100%100% cash reserves per bond covenants750 EQUIPMENT/VEHICLE LEASING 4,289,838.44 3,007,993.55 1,281,844.89 1,281,844.89 0.00 100%100%100% cash reserves per bond covenants753 SMART STREET BOND CAPITAL 1,063,473.55 0.00 1,063,473.55 1,063,473.55 0.00 100%100%100% cash reserves per bond covenants759 EDDY ST COMMONS CAPITAL 22,103,750.00 0.00 22,103,750.00 0.00 22,103,750.00 100%0%Bond fund - spend down to zero - no reserves requiredNovember 30, 2017Cash Reserve PolicyCash Reserve Report4 City of South BendCash Reserves Summary by Fund ActualFund Fund NameCash Outstanding Available Cash ReservePercentageBalance Encumbrances Cash Requirement Variance of Budget Notes Threshold MeasurementNovember 30, 2017Cash Reserve PolicyTotal Capital & Debt Service Funds39,028,164.82 4,341,637.29 34,686,527.53 7,355,837.31 27,330,690.22Enterprise Funds287 EMS / FIRE DEPARTMENT CAPITAL 4,319,150.89 736,155.53 3,582,995.36 997,866.50 2,585,128.86 90%25%Annual expenditures288 EMS / FIRE DEPARTMENT OPERATING 2,032,669.53 144,389.80 1,888,279.73 1,534,478.50 353,801.23 31%25%Annual expenditures600 CONSOLIDATED BUILDING DEPARTMENT 2,794,667.40 70,799.03 2,723,868.37 946,410.75 1,777,457.62 72%25%Annual expenditures601 PARKING GARAGES 1,299,255.54 262,253.95 1,037,001.59 311,813.50 725,188.09 83%25%Annual expenditures610 SOLID WASTE OPERATIONS 534,189.26 152,454.53 381,734.73 566,291.00(184,556.27)7%Working to increase fund reserves 10%Annual expenditures611 SOLID WASTE CAPITAL 40,331.98 0.00 40,331.98 0.00 40,331.98 100%0%No reserve requirement620 WATER WORKS OPERATIONS 3,944,891.51 897,127.74 3,047,763.77 886,362.70 2,161,401.07 17%5%Annual expenditures622 WATER WORKS CAPITAL 2,130,787.24 371,787.30 1,758,999.94 0.00 1,758,999.94 100%0%No reserve requirement624 WATER WORKS CUSTOMER DEPOSIT 1,510,836.49 0.00 1,510,836.49 1,510,836.49 0.00 100%100%100% cash reserves for customer deposits625 WATER WORKS SINKING FUND 1,561,497.89 0.00 1,561,497.89 1,561,497.89 0.00 100%100%100% cash reserves per bond covenants626 WATER WORKS BOND RESERVE 1,424,519.25 0.00 1,424,519.25 1,424,519.25 0.00 100%100%100% cash reserves per bond covenants and Crowe Horwath629 WATER WORKS RESERVE - O & M 2,613,999.68 0.00 2,613,999.68 2,601,580.71 12,418.97 16.75%16.67%Annual operating expenses in Fund 620, net of transfers640 SEWER REPAIR INSURANCE 1,880,033.69 54,656.65 1,825,377.04 158,627.25 1,666,749.79 288%25%Annual expenditures641 SEWAGE WORKS OPERATIONS 13,940,684.29 3,840,046.58 10,100,637.71 2,241,559.25 7,859,078.46 23%5%Annual expenditures642 SEWAGE WORKS CAPITAL 7,401,491.36 1,204,994.00 6,196,497.36 0.006,196,497.36 100%0%No Reserves - transfer from operating account as needed643 SEWAGE WORKS RESERVE - O & M 5,153,129.15 0.00 5,153,129.15 5,201,280.05(48,150.90)16.52%Just slightly under reserve requirement 16.67%Annual operating expenses in Fund 641, net of transfers645 2006 SEWER BOND 0.00 0.00 0.00 0.00 0.00 100%0%Bond fund - spend down to zero - no reserves647 2007 SEWER BOND 0.00 0.00 0.00 0.00 0.00 100%0%Bond fund - spend down to zero - no reserves649 SEWAGE WORKS BOND SINKING 84,253.38 0.00 84,253.38 84,253.38 0.00100%100%100% cash reserves per bond covenants651 2007B SEWER BOND 0.00 0.00 0.00 0.00 0.00 100%0%Bond fund - spend down to zero - no reserves required653 SEWAGE WORKS DEBT SERVICE RESERVE 4,131,914.86 0.00 4,131,914.86 4,131,914.86 0.00 100%100%100% cash reserves per bond covenants and Crowe Horwath658 2010 SEWER BOND 0.00 0.00 0.00 0.00 0.00 100%0%Bond fund - spend down to zero - no reserves required659 2011 SEWER BOND 145.04 0.00 145.04 0.00 145.04 100%0%Bond fund - spend down to zero - no reserves required661 2012 SEWER BOND 642,150.74 632,185.84 9,964.90 0.00 9,964.90 100%0%Bond fund - spend down to zero - no reserves required664 2013A SEWER REFUNDING BOND 0.00 0.00 0.00 0.00 0.00 100%0%Bond fund - spend down to zero - no reserves required666 2015 SEWER BOND 0.00 0.00 0.00 0.00 0.00 100%0%Bond fund - spend down to zero - no reserves required670 CENTURY CENTER 1,389,280.39 0.00 1,389,280.39 1,048,577.50 340,702.89 33%25%Annual expenditures671 CENTURY CENTER CAPITAL 865,279.14 0.00 865,279.14 800,000.00 65,279.14 100%800,000$ Minimum per Board of Managers672 CENTURY CENTER ENERGY SAVINGS 58,877.40 0.00 58,877.40 0.00 58,877.40 100%0%No reserve requirementTotal Enterprise Funds59,754,036.10 8,366,850.95 51,387,185.15 26,007,869.58 25,379,315.57Internal Service Funds222 CENTRAL SERVICES 1,184,047.89 26,223.36 1,157,824.53 1,101,160.75 56,663.78 26%25%Annual expenditures, excluding utility accounting224 CENTRAL SERVICES CAPITAL 200,554.32 75,291.40 125,262.92 0.00 125,262.92 100%0%No reserve requirement226 LIABILITY INSURANCE 4,651,761.20 34,572.49 4,617,188.71 1,793,793.00 2,823,395.71 129%50%Annual expenditures278 TAKE HOME VEHICLE POLICE 753,878.45 0.00 753,878.45 750,000.00 3,878.45 7539%750,000$ set dollar amount711 SELF-FUNDED EMPLOYEE BENEFITS 9,421,738.31 45,228.66 9,376,509.65 4,450,800.00 4,925,709.65 53%25%Annual expenditures713 UNEMPLOYMENT COMP FUND 231,341.54 11,000.00 220,341.54 21,026.25199,315.29 262%25%Annual expendituresTotal Internal Service Funds16,443,321.71 192,315.91 16,251,005.80 8,116,780.00 8,134,225.80Trust & Agency Funds701 FIREFIGHTERS PENSION 851,069.24 0.00 851,069.24 509,826.90 341,242.34 17%10%Annual expenditures702 POLICE PENSION 1,387,500.71 0.00 1,387,500.71 642,388.90 745,111.81 22%10%Annual expenditures703 POLICE/FIRE 1977 STATE PENSION 0.00 0.00 0.00 0.00 0.00 100%100%100% cash reserves - trust & agency funds709 PAYROLL FUND 0.00 0.00 0.00 0.00 0.00 100%100%100% cash reserves - trust & agency funds712 PUBLIC EMPLOYEES RETIREMENT FUND 0.00 0.00 0.00 0.00 0.00 100%100%100% cash reserves - trust & agency funds718 STATE TAX DEDUCTION FUND 278,674.15 0.00 278,674.15 278,674.15 0.00 100%100%100% cash reserves - trust & agency funds725 MORRIS / PALAIS BOX OFFICE 2,495,148.18 0.00 2,495,148.18 2,495,148.18 0.00 100%100%100% cash reserves - trust & agency funds726 POLICE DISTRIBUTIONS PAYABLE 839,350.50 0.00 839,350.50 839,350.50 0.00 100%100%100% cash reserves - trust & agency funds730 CITY CEMETERY TRUST 28,470.76 0.00 28,470.76 1,500.00 26,970.76 475%25%Annual expendituresTotal Trust & Agency Funds5,880,213.54 0.00 5,880,213.54 4,766,888.63 1,113,324.91Total City Funds203,308,792.34 22,345,117.23 180,963,675.11 98,458,530.81 82,505,144.30Cash Reserve Report5 City of South BendCash Reserves Summary by Fund ActualFund Fund NameCash Outstanding Available Cash ReservePercentageBalance Encumbrances Cash Requirement Variance of Budget Notes Threshold MeasurementNovember 30, 2017Cash Reserve PolicyRedevelopment Commission Controlled FundsTax Increment Financing Funds324 RIVER WEST TIF (AIRPORT TIF) 27,109,510.54 11,061,635.88 16,047,874.66 9,904,721.75 6,143,152.91 41%25%Annual expenditures422 TIF DISTRICT - WEST WASHINGTON 2,105,427.12 445,400.69 1,660,026.43 357,073.00 1,302,953.43 116%25%Annual expenditures425 TIF LEIGHTON PLAZA 178,049.09 0.00 178,049.09 39,541.50 138,507.59 113%25%Annual expenditures429 RIVER EAST DEV TIF (NORTHEAST TIF) 7,902,964.26 1,892,595.39 6,010,368.87 2,650,674.00 3,359,694.87 57%25%Annual expenditures430 TIF SOUTHSIDE DEVELOPMENT AREA #1 6,906,923.27 707,184.55 6,199,738.72 1,729,356.50 4,470,382.22 90%25%Annual expenditures432 TIF SSDA #3 - ERSKINE VILLAGE 0.00 0.00 0.00 1,219,698.75(1,219,698.75)0%Pay off loan, then close 25%Annual expenditures435 TIF - DOUGLAS ROAD 40,073.67 4,200.00 35,873.67 34,421.60 1,452.07 10%10%Annual expenditures436 RIVER EAST RESIDENTIAL (NE RES TIF) 1,550,032.15 0.00 1,550,032.15 857,557.75 692,474.40 45%25%Annual expendituresTotal Tax Increment Financing Funds45,792,980.10 14,111,016.51 31,681,963.59 16,793,044.85 14,888,918.74Redevelopment Funds433 REDEVELOPMENT ADMINISTRATION GENERAL 7,392.13 0.00 7,392.13 1,125.00 6,267.13 164%25%Annual expenditures439 CERTIFIED TECHNOLOGY PARK 613,093.67 0.00 613,093.67 0.00 613,093.67 100%0%No reserve requirement454 AIRPORT URBAN ENTERPRISE ZONE 386,644.52 0.00 386,644.52 0.00 386,644.52 100%0%No reserve requirement754 INDUSTRIAL REVOLVING FUND 2,879,898.00 0.00 2,879,898.00 0.00 2,879,898.00 100%0%No City reserve requirement; there are program requirementsTotal Redevelopment Funds3,887,028.32 0.00 3,887,028.32 1,125.00 3,885,903.32Debt Service Funds 315 AIRPORT 2003 DEBT RESERVE 1,038,904.00 0.00 1,038,904.00 1,038,904.00 0.00 100%100%100% debt service reserve per bond covenants317 COVELESKI BOND DEBT RESERVE 517,214.64 0.00 517,214.64 517,214.64 0.00 100%100%100% debt service reserve per bond covenants319 REDEVELOPMENT BOND - BLACKTHORN GOLF 0.00 0.00 0.00 0.00 0.00 100%100%100% debt service reserve per bond covenants328 SBCDA 2003 DEBT RESERVE 1,735,840.00 0.00 1,735,840.00 1,735,840.00 0.00 100%100%100% debt service reserve per bond covenants752 SOUTH BEND REDEVELOPMENT AUTHORITY 561,388.42 0.00 561,388.42 561,388.42 0.00 100%100%100% cash reserves per bond covenants756 SMART STREETS DEBT SERVICE FUND 1,718,071.18 0.00 1,718,071.18 1,718,071.18 0.00 100%100%100% cash reserves per bond covenants758 ERSKINE VILLAGE DEBT SERVICE 0.00 0.00 0.00 0.00 0.00 100%100%100% cash reserves per bond covenantsTotal Debt Service Funds5,571,418.24 0.00 5,571,418.24 5,571,418.24 0.00Total Redevelopment Commission Funds55,251,426.66 14,111,016.51 41,140,410.15 22,365,588.09 18,774,822.06City Operations Total 258,560,219.00 36,456,133.74 222,104,085.26 120,824,118.90 101,279,966.36Cash Reserve Report6 General Fund - 101Date Available CashReserve Requirement Date Available CashReserve Requirement Date Actual PercentPercent Requirement Date Actual PercentPercent Requirement02/28/14 19,666,397.13$ 14,060,717.50$ 01/31/17 29,435,203.64$ 20,988,556.75$ 02/28/14 35% 25% 01/31/17 49% 35%03/31/14 16,931,467.58$ 14,071,197.25$ 02/28/17 26,574,277.45$ 20,988,556.75$ 03/31/14 30% 25% 02/28/17 44% 35%04/30/14 13,664,592.50$ 14,071,197.25$ 03/31/17 23,476,220.09$ 21,038,606.75$ 04/30/14 24% 25% 03/31/17 39% 35%05/31/14 10,906,411.36$ 14,071,197.25$ 04/30/17 20,453,998.82$ 21,038,606.75$ 05/31/14 19% 25% 04/30/17 34% 35%06/30/14 29,432,779.84$ 14,071,197.25$ 05/31/17 17,285,863.47$ 21,038,606.75$ 06/30/14 52% 25% 05/31/17 29% 35%07/31/14 26,473,744.03$ 14,088,697.25$ 06/30/17 36,025,333.23$ 21,038,606.75$ 07/31/14 47% 25% 06/30/17 60% 35%08/31/14 23,722,786.84$ 14,088,697.25$ 07/31/17 33,239,836.07$ 21,038,606.75$ 08/31/14 42% 25% 07/31/17 55% 35%09/30/14 20,202,390.82$ 14,088,697.25$ 08/31/17 30,504,589.15$ 21,038,606.75$ 09/30/14 36% 25% 08/31/17 51% 35%10/31/14 17,007,547.31$ 14,088,697.25$ 09/30/17 28,097,823.09$ 21,038,606.75$ 10/31/14 30% 25% 09/30/17 47% 35%11/30/14 13,644,872.96$ 14,088,697.25$ 10/31/17 24,602,000.32$ 21,052,606.75$ 11/30/14 24% 25% 10/31/17 41% 35%12/31/14 27,947,677.74$ 14,238,697.25$ 11/30/17 21,594,843.04$ 21,052,606.75$ 12/31/14 49% 25% 11/30/17 36% 35%01/31/15 23,253,550.72$ 13,344,782.75$ 01/31/15 44% 25%02/28/15 20,413,331.83$ 13,344,782.75$ 02/28/15 38% 25%03/31/15 17,372,699.76$ 13,344,782.75$ 03/31/15 33% 25%04/30/15 13,029,346.27$ 13,344,782.75$ 04/30/15 24% 25%05/31/15 10,341,225.60$ 13,344,782.75$ 05/31/15 19% 25%06/30/15 29,661,774.55$ 13,344,782.75$ 06/30/15 56% 25%07/31/15 25,659,540.97$ 13,344,782.75$ 07/31/15 48% 25%08/31/15 23,117,854.30$ 13,344,782.75$ 08/31/15 43% 25%09/30/15 20,515,512.68$ 13,344,782.75$ 09/30/15 38% 25%10/31/15 19,719,996.44$ 13,344,782.75$ 10/31/15 37% 25%11/30/15 18,556,106.39$ 13,344,782.75$ 11/30/15 35% 25%12/31/15 30,019,921.23$ 13,344,794.00$ 12/31/15 56% 25%01/31/16 26,714,068.20$ 16,356,186.90$ 01/31/16 49% 30%02/29/16 22,402,610.86$ 16,356,186.90$ 02/29/16 41% 30%03/31/16 19,441,972.53$ 16,356,186.90$ 03/31/16 36% 30%04/30/16 16,414,709.77$ 16,356,186.90$ 04/30/16 30% 30%05/31/16 13,709,088.23$ 16,363,686.90$ 05/31/16 25% 30%06/30/16 34,004,009.56$ 16,363,686.90$ 06/30/16 62% 30%07/31/16 29,671,975.06$ 16,363,686.90$ 07/31/16 54% 30%08/31/16 26,819,728.97$ 16,363,686.90$ 08/31/16 49% 30%09/30/16 24,943,409.67$ 16,426,158.90$ 09/30/16 46% 30%10/31/16 21,886,688.46$ 13,666,773.30$ 10/31/16 48% 30%11/30/16 19,361,974.38$ 16,426,158.90$ 11/30/16 35% 30%12/31/16 33,059,765.29$ 16,535,388.90$ 12/31/16 60% 30%$-$5 $10 $15 $20 $25 $30 $35 $40 MILLIONSAvailable CashReserve Requirement0%10%20%30%40%50%60%70%Actual PercentPercent RequirementCash Reserve Report7 Parks & Recreation - 201Date Available CashReserve Requirement Date Available CashReserve Requirement Date Actual PercentPercent Requirement Date Actual PercentPercent Requirement02/28/14 1,648,649.90$ 3,150,219.50$ 01/31/17 2,925,226.89$ 3,414,992.50$ 02/28/14 13% 25% 01/31/17 21% 25%03/31/14 1,032,377.06$ 3,150,219.50$ 02/28/17 2,453,108.31$ 3,414,992.50$ 03/31/14 8% 25% 02/28/17 18% 25%04/30/14 590,542.73$ 3,150,219.50$ 03/31/17 1,610,744.33$ 3,471,329.25$ 04/30/14 5% 25% 03/31/17 12% 25%05/31/14 83,244.80$ 3,150,219.50$ 04/30/17 865,269.10$ 3,471,329.25$ 05/31/14 1% 25% 04/30/17 6% 25%06/30/14 3,535,769.93$ 3,150,219.50$ 05/31/17 (168,880.67)$ 3,471,329.25$ 06/30/14 28% 25% 05/31/17 -1% 25%07/31/14 3,047,667.29$ 3,150,219.50$ 06/30/17 4,251,412.34$ 3,481,329.25$ 07/31/14 24% 25% 06/30/17 31% 25%08/31/14 2,094,579.12$ 3,150,219.50$ 07/31/17 3,654,236.33$ 4,731,329.25$ 08/31/14 17% 25% 07/31/17 19% 25%09/30/14 1,554,697.71$ 3,150,219.50$ 08/31/17 3,026,746.69$ 4,731,329.25$ 09/30/14 12% 25% 08/31/17 16% 25%10/31/14 1,005,198.50$ 3,150,219.50$ 09/30/17 2,865,453.39$ 4,731,329.25$ 10/31/14 8% 25% 09/30/17 15% 25%11/30/14 282,628.37$ 3,150,219.50$ 10/31/17 2,266,142.00$ 4,760,722.00$ 11/30/14 2% 25% 10/31/17 12% 25%12/31/14 3,405,573.74$ 3,150,219.50$ 11/30/17 1,443,070.63$ 4,760,722.00$ 12/31/14 27% 25% 11/30/17 8% 25%01/31/15 1,840,741.75$ 2,765,998.75$ 01/31/15 17% 25%02/28/15 1,273,084.28$ 2,765,998.75$ 02/28/15 12% 25%03/31/15 623,258.50$ 2,765,998.75$ 03/31/15 6% 25%04/30/15 181,071.57$ 2,765,998.75$ 04/30/15 2% 25%05/31/15 (211,123.70)$ 2,765,998.75$ 05/31/15 -2% 25%06/30/15 3,436,165.29$ 2,765,998.75$ 06/30/15 31% 25%07/31/15 2,719,475.08$ 2,765,998.75$ 07/31/15 25% 25%08/31/15 2,327,362.23$ 2,765,998.75$ 08/31/15 21% 25%09/30/15 1,843,771.49$ 2,765,998.75$ 09/30/15 17% 25%10/31/15 1,728,926.62$ 2,765,998.75$ 10/31/15 16% 25%11/30/15 1,255,488.41$ 2,765,998.75$ 11/30/15 11% 25%12/31/15 3,854,236.64$ 2,765,998.75$ 12/31/15 35% 25%01/31/16 2,893,336.74$ 2,812,174.25$ 01/31/16 26% 25%02/29/16 2,266,893.61$ 2,812,174.25$ 02/29/16 20% 25%03/31/16 1,219,651.51$ 2,812,174.25$ 03/31/16 11% 25%04/30/16 627,650.50$ 2,812,174.25$ 04/30/16 6% 25%05/31/16 239,003.78$ 2,812,174.25$ 05/31/16 2% 25%06/30/16 4,395,360.17$ 2,812,174.25$ 06/30/16 39% 25%07/31/16 3,544,105.58$ 2,840,864.75$ 07/31/16 31% 25%08/31/16 2,753,224.95$ 2,840,864.75$ 08/31/16 24% 25%09/30/16 2,279,903.71$ 2,840,864.75$ 09/30/16 20% 25%10/31/16 1,745,715.68$ 2,362,416.25$ 10/31/16 18% 25%11/30/16 1,153,428.68$ 2,840,864.75$ 11/30/16 10% 25%12/31/16 4,422,311.14$ 2,840,864.75$ 12/31/16 39% 25%$(1)$-$1 $2 $3 $4 $5 $6 MILLIONSAvailable CashReserve Requirement-5%0%5%10%15%20%25%30%35%40%45%Actual PercentPercent RequirementCash Reserve Report8 Motor Vehicle Highway - 202Date Available CashReserve Requirement Date Available CashReserve Requirement Date Actual PercentPercent Requirement Date Actual PercentPercent Requirement02/28/14 2,055,931.61$ 1,941,729.60$ 01/31/17 5,007,393.23$ 2,891,382.75$ 02/28/14 21% 20% 01/31/17 43% 25%03/31/14 1,890,447.88$ 1,941,729.60$ 02/28/17 5,575,658.13$ 2,891,382.75$ 03/31/14 19% 20% 02/28/17 48% 25%04/30/14 3,351,701.43$ 1,941,729.60$ 03/31/17 5,809,872.14$ 2,891,382.75$ 04/30/14 35% 20% 03/31/17 50% 25%05/31/14 3,470,456.90$ 1,941,729.60$ 04/30/17 6,489,346.99$ 2,891,382.75$ 05/31/14 36% 20% 04/30/17 56% 25%06/30/14 3,366,866.26$ 1,941,729.60$ 05/31/17 6,560,982.91$ 2,891,382.75$ 06/30/14 35% 20% 05/31/17 57% 25%07/31/14 2,837,076.85$ 2,001,775.40$ 06/30/17 6,107,587.26$ 2,941,382.75$ 07/31/14 28% 20% 06/30/17 52% 25%08/31/14 2,217,578.14$ 2,001,775.40$ 07/31/17 6,156,503.01$ 2,941,382.75$ 08/31/14 22% 20% 07/31/17 52% 25%09/30/14 2,402,072.20$ 2,001,775.40$ 08/31/17 5,381,190.04$ 2,941,382.75$ 09/30/14 24% 20% 08/31/17 46% 25%10/31/14 3,204,864.97$ 2,001,775.40$ 09/30/17 6,134,135.15$ 2,941,382.75$ 10/31/14 32% 20% 09/30/17 52% 25%11/30/14 2,968,298.70$ 2,001,775.40$ 10/31/17 6,263,061.22$ 2,941,382.75$ 11/30/14 30% 20% 10/31/17 53% 25%12/31/14 3,093,394.24$ 2,001,775.40$ 11/30/17 6,131,538.20$ 2,941,382.75$ 12/31/14 31% 20% 11/30/17 52% 25%01/31/15 3,012,565.62$ 2,097,077.20$ 01/31/15 29% 20%02/28/15 3,448,810.96$ 2,097,077.20$ 02/28/15 33% 20%03/31/15 3,183,955.62$ 2,097,077.20$ 03/31/15 30% 20%04/30/15 3,452,526.78$ 2,097,077.20$ 04/30/15 33% 20%05/31/15 4,710,213.84$ 2,097,077.20$ 05/31/15 45% 20%06/30/15 4,107,360.98$ 2,097,077.20$ 06/30/15 39% 20%07/31/15 3,592,332.11$ 2,097,077.20$ 07/31/15 34% 20%08/31/15 3,616,538.87$ 2,097,077.20$ 08/31/15 34% 20%09/30/15 4,646,069.85$ 2,097,077.20$ 09/30/15 44% 20%10/31/15 5,122,032.44$ 2,097,077.20$ 10/31/15 49% 20%11/30/15 4,893,300.77$ 2,097,077.20$ 11/30/15 47% 20%12/31/15 4,592,169.19$ 2,097,077.20$ 12/31/15 44% 20%01/31/16 4,945,234.80$ 2,744,352.25$ 01/31/16 45% 25%02/29/16 4,719,277.00$ 2,744,352.25$ 02/29/16 43% 25%03/31/16 4,655,411.71$ 2,744,352.25$ 03/31/16 42% 25%04/30/16 6,006,911.17$ 2,744,352.25$ 04/30/16 55% 25%05/31/16 5,946,807.19$ 2,744,352.25$ 05/31/16 54% 25%06/30/16 5,362,184.14$ 2,744,352.25$ 06/30/16 49% 25%07/31/16 5,851,030.22$ 2,744,352.25$ 07/31/16 53% 25%08/31/16 6,027,050.77$ 2,744,352.25$ 08/31/16 55% 25%09/30/16 6,063,105.99$ 2,744,352.25$ 09/30/16 55% 25%10/31/16 5,855,952.75$ 2,286,877.50$ 10/31/16 64% 25%11/30/16 6,459,148.62$ 2,744,352.25$ 11/30/16 59% 25%12/31/16 5,313,010.73$ 2,744,352.25$ 12/31/16 48% 25%$-$1 $2 $3 $4 $5 $6 $7 MILLIONSAvailable CashReserve Requirement0%10%20%30%40%50%60%70%Actual PercentPercent RequirementCash Reserve Report9 Liability Insurance - 226Date Available CashReserve Requirement Date Available CashReserve Requirement Date Actual PercentPercent Requirement Date Actual PercentPercent Requirement02/28/14 5,019,217.44$ 724,300.00$ 01/31/17 4,584,760.08$ 1,793,793.00$ 02/28/14 173% 25% 01/31/17 128% 50%03/31/14 5,075,527.45$ 724,300.00$ 02/28/17 4,669,055.28$ 1,793,793.00$ 03/31/14 175% 25% 02/28/17 130% 50%04/30/14 5,218,468.25$ 724,300.00$ 03/31/17 4,650,125.60$ 1,793,793.00$ 04/30/14 180% 25% 03/31/17 130% 50%05/31/14 5,341,078.00$ 724,300.00$ 04/30/17 4,759,077.61$ 1,793,793.00$ 05/31/14 184% 25% 04/30/17 133% 50%06/30/14 5,099,755.96$ 724,300.00$ 05/31/17 4,299,654.88$ 1,793,793.00$ 06/30/14 176% 25% 05/31/17 120% 50%07/31/14 5,133,550.90$ 724,300.00$ 06/30/17 4,426,119.91$ 1,793,793.00$ 07/31/14 177% 25% 06/30/17 123% 50%08/31/14 5,274,005.60$ 724,300.00$ 07/31/17 4,120,212.24$ 1,793,793.00$ 08/31/14 182% 25% 07/31/17 115% 50%09/30/14 5,400,963.70$ 724,300.00$ 08/31/17 4,252,678.22$ 1,793,793.00$ 09/30/14 186% 25% 08/31/17 119% 50%10/31/14 5,541,538.17$ 724,300.00$ 09/30/17 4,366,555.29$ 1,793,793.00$ 10/31/14 191% 25% 09/30/17 122% 50%11/30/14 5,813,654.41$ 724,300.00$ 10/31/17 4,424,697.38$ 1,793,793.00$ 11/30/14 201% 25% 10/31/17 123% 50%12/31/14 5,682,684.39$ 724,300.00$ 11/30/17 4,617,188.71$ 1,793,793.00$ 12/31/14 196% 25% 11/30/17 129% 50%01/31/15 5,461,655.49$ 764,197.75$ 01/31/15 179% 25%02/28/15 5,314,999.89$ 764,197.75$ 02/28/15 174% 25%03/31/15 5,269,874.19$ 764,197.75$ 03/31/15 172% 25%04/30/15 5,024,562.10$ 764,197.75$ 04/30/15 164% 25%05/31/15 4,960,310.54$ 764,197.75$ 05/31/15 162% 25%06/30/15 4,559,500.84$ 764,197.75$ 06/30/15 149% 25%07/31/15 4,349,972.24$ 764,197.75$ 07/31/15 142% 25%08/31/15 4,391,466.11$ 764,197.75$ 08/31/15 144% 25%09/30/15 4,412,089.90$ 764,197.75$ 09/30/15 144% 25%10/31/15 4,536,090.51$ 764,197.75$ 10/31/15 148% 25%11/30/15 4,528,101.76$ 764,197.75$ 11/30/15 148% 25%12/31/15 4,485,904.07$ 764,197.75$ 12/31/15 147% 25%01/31/16 4,527,921.79$ 1,560,174.00$ 01/31/16 145% 50%02/29/16 4,467,494.26$ 1,560,174.00$ 02/29/16 143% 50%03/31/16 4,575,011.10$ 1,560,174.00$ 03/31/16 147% 50%04/30/16 4,715,447.12$ 1,560,174.00$ 04/30/16 151% 50%05/31/16 4,742,379.31$ 1,560,174.00$ 05/31/16 152% 50%06/30/16 4,468,697.42$ 1,560,174.00$ 06/30/16 143% 50%07/31/16 4,564,161.11$ 1,560,174.00$ 07/31/16 146% 50%08/31/16 4,560,561.09$ 1,560,174.00$ 08/31/16 146% 50%09/30/16 4,579,422.21$ 1,560,174.00$ 09/30/16 147% 50%10/31/16 4,648,635.57$ 1,300,070.00$ 10/31/16 179% 50%11/30/16 4,720,318.40$ 1,560,174.00$ 11/30/16 151% 50%12/31/16 4,578,150.44$ 1,560,174.00$ 12/31/16 147% 50%$-$1 $2 $3 $4 $5 $6 $7 MILLIONSAvailable CashReserve Requirement0%50%100%150%200%250%Actual PercentPercent RequirementCash Reserve Report10 Public Safety LOIT - 249Date Available CashReserve Requirement Date Available CashReserve Requirement Date Actual PercentPercent Requirement Date Actual PercentPercent Requirement02/28/14 1,965,415.14$ 1,442,931.60$ 01/31/17 1,097,183.08$ 597,011.60$ 02/28/1427% 20% 01/31/17 15% 8%03/31/14 1,788,938.50$ 1,442,931.60$ 02/28/17 1,232,147.28$ 597,011.60$ 03/31/1425% 20% 02/28/17 17% 8%04/30/14 1,727,753.74$ 1,442,931.60$ 03/31/17 1,242,144.77$ 597,011.60$ 04/30/1424% 20% 03/31/17 17% 8%05/31/14 1,686,442.29$ 1,442,931.60$ 04/30/17 1,266,041.56$ 597,011.60$ 05/31/1423% 20% 04/30/17 17% 8%06/30/14 1,604,462.03$ 1,442,931.60$ 05/31/17 1,277,948.86$ 597,011.60$ 06/30/1422% 20% 05/31/17 17% 8%07/31/14 1,028,769.93$ 1,442,931.60$ 06/30/17 982,853.93$ 597,011.60$ 07/31/1414% 20% 06/30/17 13% 8%08/31/14 1,313,459.48$ 1,442,931.60$ 07/31/17 985,373.67$ 597,011.60$ 08/31/1418% 20% 07/31/17 13% 8%09/30/14 1,263,069.52$ 1,442,931.60$ 08/31/17 980,843.43$ 597,011.60$ 09/30/1418% 20% 08/31/17 13% 8%10/31/14 704,536.10$ 1,442,931.60$ 09/30/17 983,177.31$ 597,011.60$ 10/31/1410% 20% 09/30/17 13% 8%11/30/14 1,313,921.77$ 1,442,931.60$ 10/31/17 1,087,107.57$ 597,011.60$ 11/30/1418% 20% 10/31/17 15% 8%12/31/14 1,293,978.68$ 1,442,931.60$ 11/30/17 1,172,950.34$ 597,011.60$ 12/31/1418% 20% 11/30/17 16% 8%01/31/15 1,101,184.99$ 1,449,310.20$ 01/31/15 15% 20%02/28/15 1,122,087.44$ 1,449,310.20$ 02/28/15 15% 20%03/31/15 573,193.85$ 1,449,310.20$ 03/31/15 8% 20%04/30/15 1,146,259.78$ 1,449,310.20$ 04/30/15 16% 20%05/31/15 1,168,383.41$ 1,449,310.20$ 05/31/15 16% 20%06/30/15 1,149,240.91$ 1,449,310.20$ 06/30/15 16% 20%07/31/15 970,331.63$ 1,449,310.20$ 07/31/15 13% 20%08/31/15 467,350.59$ 1,449,310.20$ 08/31/15 6% 20%09/30/15 976,720.23$ 1,449,310.20$ 09/30/15 13% 20%10/31/15 997,198.89$ 1,449,310.20$ 10/31/15 14% 20%11/30/15 899,505.58$ 1,449,310.20$ 11/30/15 12% 20%12/31/15 642,770.29$ 1,449,310.20$ 12/31/15 9% 20%01/31/16 687,550.93$ 528,050.08$ 01/31/16 10% 8%02/29/16 760,706.63$ 528,050.08$ 02/29/16 12% 8%03/31/16 813,317.68$ 528,050.08$ 03/31/16 12% 8%04/30/16 879,072.20$ 528,050.08$ 04/30/16 13% 8%05/31/16 925,892.22$ 528,050.08$ 05/31/16 14% 8%06/30/16 936,320.86$ 528,050.08$ 06/30/16 14% 8%07/31/16 805,810.30$ 528,050.08$ 07/31/16 12% 8%08/31/16 896,024.75$ 528,050.08$ 08/31/16 14% 8%09/30/16 954,088.40$ 528,050.08$ 09/30/16 14% 8%10/31/16 1,049,974.52$ 440,036.00$ 10/31/16 19% 8%11/30/16 1,148,056.62$ 528,050.08$ 11/30/16 17% 8%12/31/16 940,622.30$ 528,050.08$ 12/31/16 14% 8%$-$1 $1 $2 $2 $3 MILLIONSAvailable CashReserve Requirement0%5%10%15%20%25%30%Actual PercentPercent RequirementCash Reserve Report11 County Option Income Tax (COIT) - 404Date Available CashReserve Requirement Date Available CashReserve Requirement Date Actual PercentPercent Requirement Date Actual PercentPercent Requirement02/28/14 14,064,953.63$ 4,988,101.00$ 01/31/17 7,596,122.20$ 5,960,796.50$ 02/28/14 141% 50% 01/31/17 64% 50%03/31/14 14,419,544.87$ 5,096,642.50$ 02/28/17 7,113,881.19$ 5,960,796.50$ 03/31/14 141% 50% 02/28/17 60% 50%04/30/14 14,138,281.09$ 5,096,642.50$ 03/31/17 7,457,891.77$ 6,035,796.50$ 04/30/14 139% 50% 03/31/17 62% 50%05/31/14 14,417,615.48$ 5,582,892.50$ 04/30/17 7,025,268.70$ 6,035,796.50$ 05/31/14 129% 50% 04/30/17 58% 50%06/30/14 14,566,201.25$ 5,582,892.50$ 05/31/17 8,054,643.75$ 6,035,796.50$ 06/30/14 130% 50% 05/31/17 67% 50%07/31/14 13,784,177.94$ 5,582,892.50$ 06/30/17 8,445,453.70$ 6,035,796.50$ 07/31/14 123% 50% 06/30/17 70% 50%08/31/14 14,852,716.09$ 5,582,892.50$ 07/31/17 8,582,569.29$ 6,035,796.50$ 08/31/14 133% 50% 07/31/17 71% 50%09/30/14 14,014,334.96$ 5,582,892.50$ 08/31/17 8,962,390.29$ 6,035,796.50$ 09/30/14 126% 50% 08/31/17 74% 50%10/31/14 12,625,447.23$ 5,582,892.50$ 09/30/17 8,227,476.53$ 6,035,796.50$ 10/31/14 113% 50% 09/30/17 68% 50%11/30/14 13,703,278.95$ 5,582,892.50$ 10/31/17 8,141,460.28$ 6,035,796.50$ 11/30/14 123% 50% 10/31/17 67% 50%12/31/14 13,810,191.53$ 5,582,892.50$ 11/30/17 8,685,485.63$ 6,035,796.50$ 12/31/14 124% 50% 11/30/17 72% 50%01/31/15 13,363,623.40$ 7,830,185.50$ 01/31/15 85% 50%02/28/15 13,104,068.98$ 7,830,185.50$ 02/28/15 84% 50%03/31/15 12,417,613.96$ 7,830,185.50$ 03/31/15 79% 50%04/30/15 13,525,436.86$ 7,830,185.50$ 04/30/15 86% 50%05/31/15 13,483,035.78$ 7,830,185.50$ 05/31/15 86% 50%06/30/15 13,641,102.60$ 7,830,185.50$ 06/30/15 87% 50%07/31/15 13,287,258.01$ 7,830,185.50$ 07/31/15 85% 50%08/31/15 12,603,271.36$ 7,830,185.50$ 08/31/15 80% 50%09/30/15 11,982,696.06$ 7,830,185.50$ 09/30/15 77% 50%10/31/15 11,727,154.29$ 7,830,185.50$ 10/31/15 75% 50%11/30/15 11,326,023.58$ 7,830,185.50$ 11/30/15 72% 50%12/31/15 9,895,195.52$ 7,946,833.50$ 12/31/15 62% 50%01/31/16 8,575,802.53$ 7,581,074.00$ 01/31/16 57% 50%02/29/16 8,755,381.46$ 7,581,074.00$ 02/29/16 58% 50%03/31/16 8,571,654.20$ 7,581,074.00$ 03/31/16 57% 50%04/30/16 8,681,223.99$ 7,581,074.00$ 04/30/16 57% 50%05/31/16 9,021,396.98$ 7,595,724.00$ 05/31/16 59% 50%06/30/16 9,622,287.72$ 7,595,724.00$ 06/30/16 63% 50%07/31/16 8,477,616.02$ 7,595,724.00$ 07/31/16 56% 50%08/31/16 8,686,205.23$ 7,595,724.00$ 08/31/16 57% 50%09/30/16 8,985,128.00$ 7,845,724.00$ 09/30/16 57% 50%10/31/16 8,807,914.09$ 6,453,868.50$ 10/31/16 68% 50%11/30/16 8,416,562.21$ 7,845,724.00$ 11/30/16 54% 50%12/31/16 7,711,791.05$ 7,920,724.00$ 12/31/16 49% 50%$-$2 $4 $6 $8 $10 $12 $14 $16 MILLIONSAvailable CashReserve Requirement0%20%40%60%80%100%120%140%160%Actual PercentPercent RequirementCash Reserve Report12 Economic Development Income Tax (EDIT) - 408Date Available CashReserve Requirement Date Available CashReserve Requirement Date Actual PercentPercent Requirement Date Actual PercentPercent Requirement02/28/14 9,278,816.60$ 5,007,492.00$ 01/31/17 9,194,505.22$ 5,750,742.00$ 02/28/14 93% 50% 01/31/17 80% 50%03/31/14 9,966,875.90$ 5,007,492.00$ 02/28/17 9,252,762.76$ 5,750,742.00$ 03/31/14 100% 50% 02/28/17 80% 50%04/30/14 9,076,730.26$ 5,007,492.00$ 03/31/17 10,077,286.70$ 5,779,592.00$ 04/30/14 91% 50% 03/31/17 87% 50%05/31/14 9,202,305.40$ 5,144,992.00$ 04/30/17 9,293,535.73$ 5,779,592.00$ 05/31/14 89% 50% 04/30/17 80% 50%06/30/14 9,910,209.22$ 5,144,992.00$ 05/31/17 9,918,416.21$ 5,779,592.00$ 06/30/14 96% 50% 05/31/17 86% 50%07/31/14 8,958,071.99$ 5,144,992.00$ 06/30/17 10,646,124.47$ 5,779,592.00$ 07/31/14 87% 50% 06/30/17 92% 50%08/31/14 9,903,901.38$ 5,144,992.00$ 07/31/17 11,495,770.59$ 5,779,592.00$ 08/31/14 96% 50% 07/31/17 99% 50%09/30/14 10,608,492.02$ 5,144,992.00$ 08/31/17 12,321,615.32$ 5,779,592.00$ 09/30/14 103% 50% 08/31/17 107% 50%10/31/14 7,941,968.89$ 5,144,992.00$ 09/30/17 11,440,557.45$ 5,779,592.00$ 10/31/14 77% 50% 09/30/17 99% 50%11/30/14 9,294,422.29$ 5,144,992.00$ 10/31/17 12,252,009.80$ 5,779,592.00$ 11/30/14 90% 50% 10/31/17 106% 50%12/31/14 10,033,655.55$ 5,144,992.00$ 11/30/17 13,098,593.67$ 5,779,592.00$ 12/31/14 98% 50% 11/30/17 113% 50%01/31/15 10,065,104.57$ 4,813,809.00$ 01/31/15 105% 50%02/28/15 9,059,022.75$ 4,813,809.00$ 02/28/15 94% 50%03/31/15 8,960,343.03$ 4,813,809.00$ 03/31/15 93% 50%04/30/15 10,291,604.12$ 4,813,809.00$ 04/30/15 107% 50%05/31/15 10,408,959.43$ 4,813,809.00$ 05/31/15 108% 50%06/30/15 11,163,475.51$ 4,971,854.50$ 06/30/15 112% 50%07/31/15 9,675,461.38$ 4,971,854.50$ 07/31/15 97% 50%08/31/15 9,550,701.30$ 4,971,854.50$ 08/31/15 96% 50%09/30/15 9,399,079.89$ 5,066,874.50$ 09/30/15 93% 50%10/31/15 9,158,107.55$ 5,066,874.50$ 10/31/15 90% 50%11/30/15 9,112,235.29$ 5,066,874.50$ 11/30/15 90% 50%12/31/15 9,776,901.11$ 5,066,874.50$ 12/31/15 96% 50%01/31/16 7,938,199.64$ 5,280,090.50$ 01/31/16 75% 50%02/29/16 8,715,559.52$ 5,280,090.50$ 02/29/16 83% 50%03/31/16 9,792,593.12$ 5,280,090.50$ 03/31/16 93% 50%04/30/16 9,500,919.49$ 5,280,090.50$ 04/30/16 90% 50%05/31/16 10,151,893.76$ 5,280,090.50$ 05/31/16 96% 50%06/30/16 10,863,175.70$ 5,280,090.50$ 06/30/16 103% 50%07/31/16 8,965,098.11$ 5,280,090.50$ 07/31/16 85% 50%08/31/16 9,561,231.11$ 5,280,090.50$ 08/31/16 91% 50%09/30/16 10,311,520.69$ 5,280,090.50$ 09/30/16 98% 50%10/31/16 10,734,550.50$ 4,400,030.50$ 10/31/16 122% 50%11/30/16 9,932,601.72$ 5,280,090.50$ 11/30/16 94% 50%12/31/16 10,653,382.38$ 5,280,090.50$ 12/31/16 101% 50%$-$2 $4 $6 $8 $10 $12 $14 MILLIONSAvailable CashReserve Requirement0%20%40%60%80%100%120%140%Actual PercentPercent RequirementCash Reserve Report13 Self-funded Employee Benefits - 711Date Available CashReserve Requirement Date Available CashReserve Requirement Date Actual PercentPercent Requirement Date Actual PercentPercent Requirement02/28/14 5,189,194.64$ 3,620,865.75$ 01/31/17 6,927,761.17$ 4,450,800.00$ 02/28/14 36% 25% 01/31/17 39% 25%03/31/14 4,881,271.34$ 3,620,865.75$ 02/28/17 6,357,001.17$ 4,450,800.00$ 03/31/14 34% 25% 02/28/17 36% 25%04/30/14 4,775,766.48$ 3,620,865.75$ 03/31/17 6,922,985.97$ 4,450,800.00$ 04/30/14 33% 25% 03/31/17 39% 25%05/31/14 4,734,213.61$ 3,620,865.75$ 04/30/17 7,269,206.71$ 4,450,800.00$ 05/31/14 33% 25% 04/30/17 41% 25%06/30/14 4,967,756.75$ 3,620,865.75$ 05/31/17 7,945,120.14$ 4,450,800.00$ 06/30/14 34% 25% 05/31/17 45% 25%07/31/14 4,547,283.48$ 3,620,865.75$ 06/30/17 7,697,434.70$ 4,450,800.00$ 07/31/14 31% 25% 06/30/17 43% 25%08/31/14 4,497,229.79$ 3,620,865.75$ 07/31/17 7,959,186.08$ 4,450,800.00$ 08/31/14 31% 25% 07/31/17 45% 25%09/30/14 4,488,566.83$ 3,620,865.75$ 08/31/17 8,115,830.24$ 4,450,800.00$ 09/30/14 31% 25% 08/31/17 46% 25%10/31/14 4,312,284.67$ 3,620,865.75$ 09/30/17 8,590,159.56$ 4,450,800.00$ 10/31/14 30% 25% 09/30/17 48% 25%11/30/14 4,290,596.22$ 3,620,865.75$ 10/31/17 8,877,757.40$ 4,450,800.00$ 11/30/14 30% 25% 10/31/17 50% 25%12/31/14 4,054,314.37$ 3,620,865.75$ 11/30/17 9,376,509.65$ 4,450,800.00$ 12/31/14 25% 25% 11/30/17 53% 25%01/31/15 4,151,993.32$ 4,174,233.75$ 01/31/15 25% 25%02/28/15 4,252,749.21$ 4,174,233.75$ 02/28/15 25% 25%03/31/15 4,364,599.56$ 4,174,233.75$ 03/31/15 26% 25%04/30/15 4,140,504.23$ 4,174,233.75$ 04/30/15 25% 25%05/31/15 4,243,077.17$ 4,174,233.75$ 05/31/15 25% 25%06/30/15 4,502,701.32$ 4,349,567.00$ 06/30/15 26% 25%07/31/15 4,444,106.98$ 4,174,233.75$ 07/31/15 27% 25%08/31/15 4,406,259.32$ 4,174,233.75$ 08/31/15 26% 25%09/30/15 4,326,879.00$ 4,174,233.75$ 09/30/15 26% 25%10/31/15 4,572,942.80$ 4,174,233.75$ 10/31/15 27% 25%11/30/15 4,547,867.48$ 4,174,233.75$ 11/30/15 27% 25%12/31/15 4,329,762.09$ 4,174,233.75$ 12/31/15 26% 25%01/31/16 4,820,833.64$ 4,344,722.50$ 01/31/16 28% 25%02/29/16 3,690,587.57$ 4,344,722.50$ 02/29/16 21% 25%03/31/16 3,747,383.70$ 4,344,722.50$ 03/31/16 22% 25%04/30/16 4,011,625.62$ 4,344,722.50$ 04/30/16 23% 25%05/31/16 4,340,426.68$ 4,344,722.50$ 05/31/16 25% 25%06/30/16 4,401,917.72$ 4,344,722.50$ 06/30/16 25% 25%07/31/16 4,830,517.74$ 4,344,722.50$ 07/31/16 28% 25%08/31/16 5,180,514.41$ 4,344,722.50$ 08/31/16 30% 25%09/30/16 5,735,599.33$ 4,344,722.50$ 09/30/16 33% 25%10/31/16 6,346,521.45$ 3,620,570.00$ 10/31/16 44% 25%11/30/16 6,282,432.34$ 4,344,722.50$ 11/30/16 36% 25%12/31/16 6,724,703.22$ 4,344,722.50$ 12/31/16 39% 25%$-$1 $2 $3 $4 $5 $6 $7 $8 $9 $10 MILLIONSAvailable CashReserve Requirement0%10%20%30%40%50%60%Actual PercentPercent RequirementCash Reserve Report14 City of South BendMonth of: November 2017Controller'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 $25,993,513.13$1,406,953.64$4,479,133.71 $23,165.43$0.00 $0.00 $22,944,498.49$0.00$22,944,498.49$457,737.25Special Revenue Funds102 RAINY DAY FUND 10,269,956.12 0.00 0.00 8,775.76 0.00 0.00 10,278,731.88 0.0010,278,731.880.00201 PARKS & RECREATION 2,840,574.36 111,340.94 952,285.30 2,852.91 0.00 0.00 2,002,482.91 0.002,002,482.910.00202 MOTOR VEHICLE HIGHWAY 6,943,112.70 391,270.54 610,549.20 5,920.40 0.00 0.00 6,729,754.44 0.006,729,754.440.00203 RECREATION - NONREVERTING 805,829.59 36,758.54 48,909.61 699.66 0.00 0.00 794,378.18 0.00794,378.180.00209 STUDEBAKER/OLIVER REVERTING GRANTS 909,791.50 26,532.27 27,462.27 781.19 0.00 0.00 909,642.69 0.00909,642.69300,000.00210 DEPT COMMUNITY INVESTMENT STATE GRANTS 356,627.49 0.00 0.00 302.26 0.00 0.00 356,929.75 0.00356,929.750.00211 DCI OPERATING FUND 861,587.64 306,839.71 210,278.37 798.46 0.00 0.00 958,947.44 0.00958,947.440.00212 DEPARTMENT OF COMMUNITY INVESTMENT 154,831.73 724,032.99 442,027.46 86.46 0.00 0.00 436,923.72 0.00436,923.720.00216 POLICE STATE SEIZURES 259,381.56 3,681.50 5,868.00 221.65 0.00 0.00 257,416.71 0.00257,416.710.00217 GIFT, DONATION, BEQUEST 105,102.50 586.16 2,009.40 89.14 0.00 0.00103,768.40 0.00103,768.400.00218 POLICE CURFEW VIOLATIONS 12,817.12 12.50 0.00 10.95 0.00 0.00 12,840.57 0.0012,840.570.00219 UNSAFE BUILDING 278,062.80 32,181.50 42,743.90 0.00 0.00 0.00 267,500.40 0.00267,500.400.00220 LAW ENFORCEMENT CONTINUING EDUCATION 553,793.70 27,676.15 27,063.20 490.37 0.00 0.00 554,897.02 0.00554,897.020.00221 LANDLORD REGISTRATION 7,775.00 880.00 0.00 0.00 0.00 0.00 8,655.00 0.008,655.000.00227 LOSS RECOVERY FUND 857,294.94 0.00 10,654.00 732.56 0.00 0.00 847,373.50 0.00847,373.500.00244 EMERGENCY TELEPHONE SYSTEM 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.000.00249 PUBLIC SAFETY L.O.I.T. 1,087,107.57 622,811.50 537,609.27 640.540.00 0.00 1,172,950.34 0.001,172,950.340.00251 LOCAL ROADS & STREETS 2,947,325.72 161,394.24 0.00 2,527.84 0.00 0.00 3,111,247.80 0.003,111,247.800.00252 EXCESS WELFARE DISTRIBUTION 8.07 0.00 8.07 0.00 0.00 0.00 0.00 0.000.000.00257 LOIT 2016 SPECIAL DISTRIBUTION 2,713,714.66 0.00 387,600.25 2,454.64 0.00 0.00 2,328,569.05 0.002,328,569.050.00258 HUMAN RIGHTS - FEDERAL GRANT 512,924.97 0.00 76,394.87 374.12 0.00 0.00 436,904.22 69,357.25506,261.470.00265 LOCAL ROAD & BRIDGE GRANT 1,998,536.12 0.00 465,271.10 0.00 0.00 0.00 1,533,265.02 0.001,533,265.020.00271 EASTRACE WATERWAY 3.35 0.00 0.00 0.00 0.00 0.00 3.35 0.003.350.00273 MORRIS PAC/PALAIS ROYALE MARKETING 51,029.83 1,200.00 0.00 43.070.00 0.00 52,272.90 0.0052,272.900.00280 POLICE BLOCK GRANTS 3,918.04 0.00 0.00 3.35 0.00 0.00 3,921.39 0.003,921.390.00281 DEPT. COMMUNITY INVESTMENT - REV BONDS 27,844.33 0.00 0.00 23.800.00 0.00 27,868.13 0.0027,868.130.00289 HAZMAT 24,269.78 0.00 0.00 20.74 0.00 0.00 24,290.52 0.0024,290.520.00291 INDIANA RIVER RESCUE 120,554.45 1,200.00 230.80 100.87 0.00 0.00 121,624.52 0.00121,624.520.00292 POLICE GRANTS 48,450.50 0.00 0.00 0.00 0.00 0.00 48,450.50 0.0048,450.500.00294 REGIONAL POLICE ACADEMY 87,663.75 200.00 1,038.54 72.88 0.00 0.00 86,898.09 0.0086,898.090.00295 COPS MORE GRANT 136,393.63 19,122.38 960.00 131.78 0.00 0.00 154,687.79 0.00154,687.790.00299 POLICE FEDERAL DRUG ENFORCEMENT 80,441.57 50,000.00 0.00 184.44 0.00 0.00 130,626.01 0.00130,626.010.00404 COUNTY OPTION INCOME TAX 8,444,790.96 871,605.42 430,827.25 7,334.73 0.00 0.00 8,892,903.86 0.008,892,903.861,257,269.00408 ECONOMIC DEVELOPMENT INCOME TAX 13,077,200.45 866,667.43 319,415.37 10,594.74 0.00 0.00 13,635,047.25 0.0013,635,047.250.00410 URBAN DEVELOPMENT ACTION GRANT (UDAG) 470,821.43 0.00 0.00 411.09 0.00 0.00 471,232.52 0.00471,232.52(1,257,269.00)655 PROJECT RELEAF 874,803.62 35,287.60 14,732.45 754.03 0.00 0.00 896,112.80 0.00896,112.800.00705 POLICE K-9 UNIT 2,882.31 0.00 0.00 2.46 0.00 0.00 2,884.77 0.002,884.770.00Total Special Revenue Funds57,927,223.864,291,281.374,613,938.6847,436.890.00 0.00 57,652,003.4469,357.2557,721,360.69300,000.00 Debt Service Fund313 HALL OF FAME DEBT SERVICE (376,430.57)0.00 0.00 17.53 0.00 0.00(376,413.04)0.00(376,413.04)0.00755 SB BUILDING CORPORATION 772,492.46 0.00 1,000.00 329.75 0.00 0.00 771,822.21 0.00771,822.210.00757 PARKS BOND DEBT SERVICE 462,183.44 63,446.88 0.00 111.89 0.00 0.00525,742.21 0.00525,742.210.00760 EDDY ST. COMMONS DEBT SERVICE 2,500,232.88 0.00 0.00 410.99 0.00 0.00 2,500,643.87 0.002,500,643.870.00Capital Project Funds377 PROFESSIONAL SPORTS DEVELOPMENT(172,095.98)0.00 0.00 0.00 0.00 0.00(172,095.98)0.00(172,095.98)0.00401 COVELESKI STADIUM CAPITAL 54,445.15 0.00 0.00 85.02 0.00 0.00 54,530.17 0.0054,530.170.00403 ZOO ENDOWMENT 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.000.00405 PARK NONREVERTING CAPITAL 185,476.31 3,680.37 88.25 0.00 0.00 189,244.93 0.00189,244.930.00406 CUMULATIVE CAPITAL DEVELOPMENT 402,272.72 2,643.96 0.00 352.60 0.00 0.00 405,269.28 0.00405,269.280.00407 CUMULATIVE CAPITAL IMPROVEMENT 301,020.87 0.00 0.00 257.74 0.00 0.00 301,278.61 0.00301,278.610.00412 MAJOR MOVES CONSTRUCTION 2,904,726.16 0.00 721.25 2,518.92 0.00 0.00 2,906,523.83 0.002,906,523.833,189,107.50416 MORRIS PERFORMING ARTS CENTER CAPITAL 633,608.61 2,350.00 32,075.18 535.11 0.00 0.00 604,418.54 0.00604,418.540.00Cash Reserve Report15 City of South BendMonth of: November 2017Controller'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)450 PALAIS ROYALE HISTORIC PRESERVATION 106,590.82 1,507.16 0.00 89.85 0.00 0.00 108,187.83 0.00108,187.830.00677 HALL OF FAME CAPITAL FUND 458,783.87 0.00 1,440.09 393.47 0.00 0.00 457,737.25 0.00457,737.25(457,737.25)750 EQUIPMENT / VEHICLE LEASING 4,729,070.70 0.00 440,171.45 939.19 0.00 0.00 4,289,838.44 0.004,289,838.440.00751 PARKS BOND CAPITAL 3,319,157.01 903.14 26,400.93 553.90 0.00 0.00 3,294,213.12 0.003,294,213.120.00753 SMART STREET BOND CAPITAL 1,069,740.59 20,000.00 26,451.79 184.75 0.00 0.00 1,063,473.55 0.001,063,473.550.00759 EDDY ST COMMONS CAPITAL 22,103,750.00 0.00 0.00 0.00 0.00 0.00 22,103,750.00 0.0022,103,750.00Total Capital & Debt Service Funds39,455,025.0494,531.51 528,260.696,868.960.00 0.00 39,028,164.820.0039,028,164.822,731,370.25Enterprise Funds287 EMS CAPITAL 4,378,455.40 0.00 63,102.36 3,797.85 0.00 0.00 4,319,150.89 0.004,319,150.890.00288 EMS OPERATING 1,952,142.30 556,372.28 477,526.19 1,681.14 0.00 0.00 2,032,669.53 0.002,032,669.530.00600 CONSOLIDATED BUILDING DEPARTMENT 2,914,312.63 172,694.33 294,888.76 2,549.20 0.00 0.00 2,794,667.40 0.002,794,667.400.00601 PARKING GARAGES 1,218,103.25 95,756.34 15,625.76 1,021.71 0.00 0.00 1,299,255.54 0.001,299,255.54(31,191.33)610 SOLID WASTE OPERATIONS 393,524.61 437,304.85 297,018.13 377.93 0.00 0.00 534,189.26 0.00534,189.260.00611 SOLID WASTE CAPITAL 60,190.76 0.00 19,920.96 62.18 0.00 0.00 40,331.98 0.0040,331.980.00620 WATER WORKS OPERATIONS 3,788,643.28 1,521,892.15 1,215,009.03 2,743.40 10,621.71 164,000.00 3,944,891.51 0.003,944,891.510.00622 WATER WORKS CAPITAL 2,202,523.54 0.00 73,618.38 1,882.08 0.00 0.002,130,787.24 0.002,130,787.240.00624 WATER WORKS CUSTOMER DEPOSIT 1,506,840.44 18,019.18 14,023.13 1,287.31 0.00 1,287.31 1,510,836.49 0.001,510,836.490.00625 WATER WORKS SINKING FUND 1,397,497.89 0.00 0.00 1,099.70 164,000.00 1,099.70 1,561,497.89 0.001,561,497.890.00626 WATER WORKS BOND RESERVE 1,429,301.78 0.00 0.00 1,217.47 0.00 6,000.00 1,424,519.25 0.001,424,519.250.00629 WATER WORKS RESERVE - O & M 2,613,999.68 0.00 0.00 2,234.70 0.002,234.70 2,613,999.68 0.002,613,999.680.00640 SEWER REPAIR INSURANCE 1,860,148.14 51,346.96 33,044.87 1,583.460.00 0.00 1,880,033.69 0.001,880,033.690.00641 SEWAGE WORKS OPERATIONS 13,884,405.76 3,033,680.65 1,731,420.3912,410.37 4,405.40 1,262,797.50 13,940,684.29 0.0013,940,684.290.00642 SEWAGE WORKS CAPITAL 7,162,970.98 0.00 267,590.00 6,110.38 500,000.00 0.00 7,401,491.36 0.007,401,491.360.00643 SEWAGE WORKS RESERVE - O & M 5,153,129.15 0.00 0.00 4,405.40 0.004,405.40 5,153,129.15 0.005,153,129.150.00649 SEWAGE WORKS BOND SINKING 7,392,425.10 0.00 8,077,054.94 6,085.72 762,797.50 0.00 84,253.38 0.0084,253.380.00653 SEWAGE WORKS DEBT SERVICE RESERVE 4,128,908.39 0.00 0.00 3,006.47 0.00 0.00 4,131,914.86 0.004,131,914.860.00659 2011 SEWER BOND 144.91 0.00 0.00 0.13 0.00 0.00 145.04 0.00145.040.00661 2012 SEWER BOND 641,544.20 0.00 0.00 606.54 0.00 0.00 642,150.74 0.00642,150.740.00670 CENTURY CENTER 1,718,483.10 15,026.49 344,229.20 0.00 0.00 0.00 1,389,280.39 0.001,389,280.390.00671 CENTURY CENTER CAPITAL 866,708.02 0.00 1,500.00 71.12 0.00 0.00 865,279.14 0.00865,279.140.00672 CENTURY CENTER ENERGY SAVINGS 3,482.04 0.00 0.00 55,395.36 0.00 0.00 58,877.40 0.0058,877.400.00Total Enterprise Funds66,667,885.355,902,093.2312,925,572.10109,629.621,441,824.61 1,441,824.61 59,754,036.100.0059,754,036.10(31,191.33)Internal Service Funds222 CENTRAL SERVICES 1,150,487.99 947,707.51 914,746.91 599.30 0.00 0.00 1,184,047.89 0.001,184,047.890.00224 CENTRAL SERVICES CAPITAL 200,367.18 0.00 0.00 187.14 0.00 0.00 200,554.32 0.00200,554.320.00226 LIABILITY INSURANCE 4,460,107.47 345,194.75 157,291.42 3,750.40 0.00 0.00 4,651,761.20 0.004,651,761.200.00278 TAKE HOME VEHICLE POLICE 759,558.98 240.00 6,569.50 648.97 0.00 0.00 753,878.45 0.00753,878.450.00279 311 CALL CENTER 1,361,939.28 430,638.43 255,380.72 0.00 0.00 0.00 1,537,196.99 0.001,537,196.990.00711 SELF-FUNDED EMPLOYEE BENEFITS 9,196,984.59 1,459,446.34 1,243,049.36 8,356.74 0.00 0.00 9,421,738.31 0.009,421,738.310.00713 UNEMPLOYMENT COMP FUND 234,490.04 0.00 3,352.42 203.92 0.00 0.00 231,341.54 0.00231,341.540.00Total Internal Service Funds17,363,935.533,183,227.032,580,390.3313,746.470.00 0.00 17,980,518.700.0017,980,518.700.00Trust & Agency Funds701 FIREFIGHTERS PENSION 1,224,213.84 1,889.40 376,382.86 1,348.86 0.00 0.00 851,069.24 0.00851,069.240.00702 POLICE PENSION 1,892,241.66 66.26 506,830.19 2,022.98 0.00 0.00 1,387,500.71 0.001,387,500.710.00709 PAYROLL FUND 0.00 8,582,266.62 8,582,266.62 0.00 0.00 0.00 0.00 0.000.000.00718 STATE TAX DEDUCTION FUND 267,391.86 278,674.15 267,391.86 0.00 0.00 0.00 278,674.15 0.00278,674.150.00725 MORRIS / PALAIS BOX OFFICE 2,137,747.57 357,400.61 0.00 0.00 0.000.00 2,495,148.18 0.002,495,148.180.00726 POLICE DISTRIBUTIONS PAY 844,226.20 1,903.94 6,779.64 0.00 0.00 0.00 839,350.50 0.00839,350.500.00730 CITY CEMETERY TRUST 28,445.96 0.00 0.00 24.80 0.00 0.00 28,470.76 0.0028,470.760.00Total Trust & Agency Funds6,394,267.099,222,200.989,739,651.173,396.640.00 0.00 5,880,213.540.005,880,213.540.00Total City Funds213,801,850.0024,100,287.7634,866,946.68204,244.01 1,441,824.61 1,441,824.61 203,239,435.0969,357.25203,308,792.343,457,916.17Cash Reserve Report16 City of South BendMonth of: November 2017Controller'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)Redevelopment Commission Controlled FundsTax Increment Financing Funds324 TIF RIVER WEST - AIRPORT 27,545,537.65 48,114.04 509,095.62 22,582.34 2,372.13 0.00 27,109,510.54 0.0027,109,510.54(300,000.00)422 TIF DISTRICT - WEST WASHINGTON 2,103,627.72 0.00 0.00 1,799.40 0.00 0.00 2,105,427.12 0.002,105,427.120.00425 TIF LEIGHTON PLAZA 175,982.37 26,414.40 24,491.09 143.41 0.00 0.00178,049.09 0.00178,049.090.00429 TIF RIVER EAST DEV (NE) 7,922,064.12 0.00 25,916.44 6,816.58 0.00 0.00 7,902,964.26 0.007,902,964.260.00430 TIF SOUTHSIDE DEVELOPMENT AREA #1 6,948,864.70 0.00 47,895.00 5,953.57 0.00 0.00 6,906,923.27 0.006,906,923.270.00432 TIF SSDA #3 - ERSKINE VILLAGE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.000.00435 TIF DOUGLAS ROAD 40,039.36 0.00 0.00 34.31 0.00 0.00 40,073.67 0.0040,073.67436 TIF RIVER EAST RES (NE RE) 1,550,532.15 0.00 500.00 0.00 0.00 0.00 1,550,032.15 0.001,550,032.15(3,157,916.17)Total Tax Increment Financing Funds46,286,648.0774,528.44607,898.1537,329.61 2,372.130.00 45,792,980.100.0045,792,980.10(3,457,916.17)Redevelopment Funds433 REDEVELOPMENT ADMINISTRATION GENERAL 7,385.82 0.00 0.00 6.31 0.000.00 7,392.13 0.007,392.130.00439 CERTIFIED TECHNOLOGY PARK 612,570.22 0.00 0.00 523.45 0.00 0.00 613,093.67 0.00613,093.670.00454 AIRPORT URBAN ENTERPRISE ZONE 386,314.41 0.00 0.00 330.11 0.00 0.00 386,644.52 0.00386,644.520.00754 INDUSTRIAL REVOLVING FUND 2,879,898.00 0.00 0.00 0.00 0.00 0.00 2,879,898.00 0.002,879,898.000.00Total Redevelopment Funds3,886,168.450.00 0.00 859.87 0.00 0.00 3,887,028.320.003,887,028.320.00Debt Service Funds 315 AIRPORT 2003 DEBT RESERVE 1,038,904.00 0.00 0.00 888.16 0.00 888.16 1,038,904.00 0.001,038,904.000.00317 COVELESKI BOND DEBT RESERVE 516,773.06 0.00 0.00 441.58 0.00 0.00 517,214.64 0.00517,214.640.00328 SBCDA 2003 DEBT RESERVE 1,735,840.00 0.00 0.00 1,483.97 0.00 1,483.97 1,735,840.00 0.001,735,840.000.00752 SB REVELOPMENT AUTHORITY 364,623.86 196,500.00 0.00 264.56 0.00 0.00 561,388.42 0.00561,388.420.00756 SMARTS STREETS DEBT SERVICE 1,717,788.81 0.00 0.00 282.37 0.00 0.00 1,718,071.18 0.001,718,071.180.00758 ERSKINE VILLAGE DEBT SERVICE 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.000.00Total Debt Service Funds5,373,929.73196,500.000.00 3,360.640.00 2,372.135,571,418.240.005,571,418.240.00Total Redevelopment Commission Funds55,546,746.25 271,028.44 607,898.15 41,550.12 2,372.13 2,372.13 55,251,426.66 0.00 55,251,426.66(3,457,916.17)City Operations Total269,348,596.2524,371,316.2035,474,844.83245,794.131,444,196.741,444,196.74258,490,861.7569,357.25258,560,219.000.00Memo ItemPooled Investment AccountOpening Interest Accrued Change in Transfer In Transfer out Investment Total Cash &Balance Net of Fees Income Asset Value from Depository to DepositoryBalance Investments1st Source Bank Investment Account174,505,686.72266,863.880.00 (137,307.73)0.00 130,139.17174,505,103.70174,505,103.70Cash Reserve Report17