Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
09-2016 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 James Mueller Deputy Chief of Staff Suzanna Fritzberg Common Council City Controller John Murphy Deputy City Controller Jennifer Hockenhull City Finance Director Rahman Johnson Senior Budget Analyst Amy O'Connor Department Heads Fiscal Officers September 30, 2016 Controller Cash Reserve Report 1 City of South BendCash Reserves Summary by Fund Status Actua l Fund Fund Name CashOutstanding Available Cash Reserv e Percentag e Balanc e Encumbrance s CashRequiremen t Varianc e of Budget NotesThreshold Measuremen t Insufficient Balances 201PARKS & RECREATION 2,486,791.93206,888.222,279,903.712,840,864.75 (560,961.04) 20% Property taxes received in June25% Annual expenditures 219UNSAFE BUILDING387,005.75200,218.61186,787.14231,624.25 (44,837.11) 20% High encumbrances25% Annual expenditures 436RIVER EAST RESIDENTIAL (NE RES TIF)973,939.111,331.00972,608.11857,500.00115,108.1128% Will be tight in 2016; committed to debt svc25% Annual expenditures 610SOLID WASTE OPERATIONS286,160.69235,283.7350,876.96574,741.20 (523,864.24) 1% Tight budget10% Annual expenditures 629WATER WORKS RESERVE - O & M2,462,727.680.002,462,727.682,473,229.55 (10,501.87) 17% Actual Percentage = 16.599%, only slightly less16.67% Annual operating expenses in Fund 620, net of transfers 6,596,625.1 6 643,721.5 6 5,952,903.6 0 6,977,959.7 5 (1,025,056.15 ) Meets or Exceeds Requirements 101GENERAL FUND 25,719,540.82776,131.1524,943,409.6716,426,158.908,517,250.7746% Property taxes received in June30% Annual expenditures - higher due to property tax delays 102RAINY DAY FUND10,162,862.340.0010,162,862.348,805,170.671,357,691.673% 3% Total expenditures in previous fiscal year-contingency 202MOTOR VEHICLE HIGHWAY6,444,190.14381,084.156,063,105.992,744,352.253,318,753.7455% 25% Annual expenditures 203RECREATION - NONREVERTING875,047.6789,250.19785,797.48364,938.50420,858.9854% 25% Annual expenditures 211DCI ADMINISTRATION FUND1,138,993.8379,349.351,059,644.48671,828.25387,816.2339% 25% Annual expenditures 216POLICE STATE SEIZURES228,328.640.00228,328.649,000.00219,328.64634% 25% Annual expenditures 218POLICE CURFEW VIOLATIONS12,511.760.0012,511.76250.0012,261.761251% 25% Annual expenditures 220LAW ENFORCEMENT CONTINUING EDUCATION815,591.3358,207.59757,383.74185,877.00571,506.74102% 25% Annual expenditures 222CENTRAL SERVICES1,608,671.19503,311.961,105,359.231,005,449.5099,909.7327% 25% Annual expenditures, excluding utility accounting 226LIABILITY INSURANCE4,606,391.0526,968.844,579,422.211,560,174.003,019,248.21147% 50% Annual expenditures - higher reserves for future claims 249PUBLIC SAFETY L.O.I.T.954,088.400.00954,088.40528,050.08426,038.3214% 8% Annual expenditures - one month reserve 251LOCAL ROADS & STREETS3,081,694.56640,732.082,440,962.48560,736.001,880,226.48109% 25% Annual expenditures 258HUMAN RIGHTS - FEDERAL GRANT475,783.261,698.50474,084.7655,459.50418,625.26214% 25% Annual expenditures 273MORRIS PAC/PALAIS ROYALE MARKETING42,106.362,632.5039,473.864,719.5034,754.36209% 25% Annual expenditures 278TAKE HOME VEHICLE POLICE729,136.960.00729,136.962,500.00726,636.967291% 25% Annual expenditures 287EMS / FIRE DEPARTMENT CAPITAL3,456,397.7249,856.503,406,541.22795,096.502,611,444.72107% 25% Annual expenditures 288EMS / FIRE DEPARTMENT OPERATING2,094,389.8750,123.352,044,266.521,535,160.75509,105.7733% 25% Annual expenditures 289HAZMAT24,666.070.0024,666.072,500.0022,166.07247% 25% Annual expenditures 291INDIANA RIVER RESCUE170,034.8410,806.69159,228.1523,825.00135,403.15167% 25% Annual expenditures 294REGIONAL POLICE ACADEMY85,081.750.0085,081.755,625.0079,456.75378% 25% Annual expenditures 299POLICE FEDERAL DRUG ENFORCEMENT252,683.620.00252,683.6242,241.25210,442.37150% 25% Annual expenditures 315AIRPORT 2003 DEBT RESERVE1,038,904.000.001,038,904.001,038,904.000.00100% 100% 100% debt service reserve per bond covenants 317COVELESKI BOND DEBT RESERVE511,384.200.00511,384.20511,384.200.00100% 100% 100% debt service reserve per bond covenants 319REDEVELOPMENT BOND - BLACKTHORN GOLF0.000.000.000.000.00100% 100% 100% debt service reserve per bond covenants 324RIVER WEST TIF (AIRPORT TIF)28,880,665.397,583,725.8721,296,939.5211,125,519.2510,171,420.2748% 25% Annual expenditures 328SBCDA 2003 DEBT RESERVE1,735,840.000.001,735,840.001,735,840.000.00100% 100% 100% debt service reserve per bond covenants 377PROFESSIONAL SPORTS DEVELOPMENT218,481.750.00218,481.75209,513.008,968.7526% Fund balance declining as debt paid off25% Annual expenditures 404COUNTY OPTION INCOME TAX 9,812,307.76827,179.768,985,128.007,845,724.001,139,404.0057% 50% Annual expenditures - higher due to bonding and rating agencies 405PARK NONREVERTING CAPITAL365,209.2540,709.72324,499.5395,773.75228,725.7885% 25% Annual expenditures 406CUMULATIVE CAPITAL DEVELOPMENT 371,540.930.00371,540.93131,684.25239,856.6871% 25% Annual expenditures 407CUMULATIVE CAPITAL IMPROVEMENT241,526.350.00241,526.3592,062.50149,463.8566% 25% Annual expenditures 408ECONOMIC DEVELOPMENT INCOME TAX 10,795,906.61484,385.9210,311,520.695,280,090.505,031,430.1998% 50% Annual expenditures - higher due to bonding and rating agencies 416MORRIS PERFORMING ARTS CENTER CAPITAL559,770.546,869.00552,901.5419,730.75533,170.79701% 25% Annual expenditures 422TIF DISTRICT - WEST WASHINGTON 1,789,771.63305,847.251,483,924.38350,841.501,133,082.88106% 25% Annual expenditures 425TIF LEIGHTON PLAZA208,516.890.00208,516.8940,101.50168,415.39130% 25% Annual expenditures429RIVER EAST DEV TIF (NORTHEAST TIF)7,808,005.663,380,989.314,427,016.352,083,789.752,343,226.6053%25%Annual expenditures430TIF SOUTHSIDE DEVELOPMENT AREA #1 4,489,746.961,780,343.532,709,403.431,852,953.75856,449.6837% Enc for large project in 201625% Annual expenditures 432TIF SSDA #3 - ERSKINE VILLAGE4,848,003.400.004,848,003.40122,625.754,725,377.65988% 25% Annual expenditures 433REDEVELOPMENT ADMINISTRATION GENERAL8,763.080.008,763.081,125.007,638.08195% 25% Annual expenditures 435TIF - DOUGLAS ROAD243,765.154,316.00239,449.1535,420.00204,029.1568% Using cash bal for debt svc; then will close10% Annual expenditures 450PALAIS ROYALE HISTORIC PRESERVATION87,336.740.0087,336.740.0087,336.74100% 25% Annual expenditures 600CONSOLIDATED BUILDING DEPARTMENT2,361,735.76132,184.772,229,550.99881,119.251,348,431.7463% 25% Annual expenditures 601PARKING GARAGES856,373.69287,254.80569,118.89348,367.75220,751.1441% Enc is for year's operations under contract25% Annual expenditures 620WATER WORKS OPERATIONS3,873,787.83823,930.253,049,857.58852,382.852,197,474.7318% 5% Annual expenditures 624WATER WORKS CUSTOMER DEPOSIT1,540,709.930.001,540,709.931,540,709.930.00100% 100% 100% cash reserves for customer deposits 626WATER WORKS BOND RESERVE1,644,326.340.001,644,326.341,644,326.340.00100% 100% 100% cash reserves per bond covenants and Crowe Horwath 640SEWER REPAIR INSURANCE1,774,107.5128,693.531,745,413.98137,353.251,608,060.73318% 25% Annual expenditures 641SEWAGE WORKS OPERATIONS11,933,135.633,005,877.158,927,258.482,004,871.906,922,386.5822% 5% Annual expenditures 643SEWAGE WORKS RESERVE - O & M4,636,374.150.004,636,374.154,635,601.94772.2117% Actual Percentage = 16.673%, only slightly less16.67% Annual operating expenses in Fund 641, net of transfers 653SEWAGE WORKS DEBT SERVICE RESERVE4,109,042.540.004,109,042.544,109,042.540.00100% 100% 100% cash reserves per bond covenants and Crowe Horwath 655PROJECT RELEAF824,669.321,322.56823,346.76132,089.50691,257.26156% 25% Annual expenditures 670CENTURY CENTER1,744,266.140.001,744,266.14993,109.50751,156.6444% 25% Annual expenditures 671CENTURY CENTER CAPITAL884,782.230.00884,782.23800,000.0084,782.23100% 800,000$ Minimum per Board of Managers 701FIREFIGHTERS PENSION 1,388,933.980.001,388,933.98546,484.30842,449.6825% Pension payments received in June & Sep10% Annual expenditures 702POLICE PENSION 2,334,300.370.002,334,300.37679,739.801,654,560.5734% Pension payments received in June & Sep10% Annual expenditures 703POLICE/FIRE 1977 STATE PENSION0.000.000.000.000.00100% 100% 100% cash reserves - trust & agency funds 705POLICE K-9 UNIT2,852.250.002,852.25505.002,347.25141% 25% Annual expenditures September 30, 2016 Cash Reserve Policy Cash Reserve Report 2 City of South BendCash Reserves Summary by Fund Status Actua l Fund Fund Name CashOutstanding Available Cash Reserv e Percentag e Balanc e Encumbrance s CashRequiremen t Varianc e of Budget NotesThreshold Measuremen t September 30, 2016 Cash Reserve Policy 709PAYROLL FUND 6,613.590.006,613.596,613.590.00100% 100% 100% cash reserves - trust & agency funds 711SELF-FUNDED EMPLOYEE BENEFITS5,906,436.85170,837.525,735,599.334,344,722.501,390,876.8333% 25% Annual expenditures 712PUBLIC EMPLOYEES RETIREMENT FUND0.000.000.000.000.00100% 100% 100% cash reserves - trust & agency funds 713UNEMPLOYMENT COMP FUND307,280.4015,400.00291,880.4028,470.50263,409.90256% 25% Annual expenditures 718STATE TAX DEDUCTION FUND262,319.630.00262,319.63262,319.630.00100% 100% 100% cash reserves - trust & agency funds 725MORRIS / PALAIS BOX OFFICE1,924,618.680.001,924,618.681,924,618.680.00100% 100% 100% cash reserves - trust & agency funds 726POLICE DISTRIBUTIONS PAYABLE825,901.480.00825,901.48825,901.480.00100% 100% 100% cash reserves - trust & agency funds 730CITY CEMETERY TRUST28,742.090.0028,742.095,000.0023,742.09144% 25% Annual expenditures 186,164,948.8621,550,019.79164,614,929.0794,605,546.3370,009,382.75 No Reserve Requirements 103EXCESS LEVY0.000.000.000.000.00100% 0% No reserve requirement 209STUDEBAKER/OLIVER REVERTING GRANTS1,186,884.06831,020.18355,863.880.00355,863.88100% 0% No reserve requirement 210DEPT COMMUNITY INVESTMENT STATE GRANTS 231,795.01437,745.00(205,949.99)0.00 (205,949.99) 100% To be reimbursed by grant receipts0% No reserve requirement 212DCI GRANT FUND480,632.673,186,420.42(2,705,787.75)0.00 (2,705,787.75) 100% To be reimbursed by grant receipts0% Grant fund - reimbursement grants - no reserves 217GIFT, DONATION, BEQUEST104,909.220.00104,909.220.00104,909.22100% 0% No reserve requirement 224CENTRAL SERVICES CAPITAL(16,896.22)10,012.54(26,908.76)0.00 (26,908.76) 100% 0% No reserve required 227LOSS RECOVERY FUND 974,967.44105,141.92869,825.520.00869,825.52100% 0% No reserve requirement 244EMERGENCY PHONE SYSTEM33,670.740.0033,670.740.0033,670.74100% 0% No reserve requirement 252EXCESS WELFARE DISTRIBUTION8.070.008.070.008.07100% 0% No reserve requirement 257LOIT 2016 SPECIAL DISTRIBUTION4,058,382.29550,331.513,508,050.780.003,508,050.78100% 0% No reserve requirement 271EASTRACE WATERWAY1,344.400.001,344.400.001,344.40100% 0% No reserve requirement 279311 CALL CENTER(180.03)2,978.37(3,158.40)0.00 (3,158.40) 100% Will be reimbursed through inter-fund xfr0% No reserve requirement 280POLICE BLOCK GRANTS3,877.200.003,877.200.003,877.20100% 0% No reserve requirement 281REDEVELOPMENT COMMISSION - REV BONDS27,553.990.0027,553.990.0027,553.99100% 0% No reserve requirement 292POLICE GRANTS87,957.3022,134.0065,823.300.0065,823.30100% 0% No reserve requirement 295COPS MORE GRANT147,617.67173,862.87(26,245.20)0.00 (26,245.20) 100% 0% No reserve requirement 313HALL OF FAME DEBT SERVICE (397,174.84)0.00(397,174.84)0.00 (397,174.84) 100% Will be reimbursed from property taxes0% No reserve requirement 401COVELESKI STADIUM CAPITAL101,819.288,045.0093,774.280.0093,774.28100% 0% No reserve requirement 403ZOO ENDOWMENT49,792.720.0049,792.720.0049,792.72100% 0% No reserve requirement 410URBAN DEVELOPMENT ACTION GRANT (UDAG)395,985.060.00395,985.060.00395,985.06100% 0% No reserve requirement 412MAJOR MOVES CONSTRUCTION2,244,132.71477,605.131,766,527.580.001,766,527.58100% 0% No reserve requirement 434CRED FUND2,916.190.002,916.190.002,916.19100% 0% No reserve requirement 439CERTIFIED TECHNOLOGY PARK2,145,880.570.002,145,880.570.002,145,880.57100% 0% No reserve required 454AIRPORT URBAN ENTERPRISE ZONE382,286.000.00382,286.000.00382,286.00100% 0% No reserve required 611SOLID WASTE CAPITAL178,383.58307.41178,076.170.00178,076.17100% 0% No reserve requirement 622WATER WORKS CAPITAL2,589,963.01107,028.002,482,935.010.002,482,935.01100% 0% No reserve requirement 625WATER WORKS SINKING FUND1,191,941.870.001,191,941.870.001,191,941.87100% 0% No Reserves - transfer from operating account for debt service as needed 642SEWAGE WORKS CAPITAL7,898,376.721,835,213.096,063,163.630.006,063,163.63100% 0% No Reserves - transfer from operating account as needed 6452006 SEWER BOND0.000.000.000.000.00100% 0% Bond fund - spend down to zero - no reserves 6472007 SEWER BOND0.000.000.000.000.00100% 0% Bond fund - spend down to zero - no reserves 649SEWAGE WORKS BOND SINKING6,537,418.910.006,537,418.910.006,537,418.91100% 0% No Reserves - transfer from operating account for debt service as needed 6512007B SEWER BOND0.000.000.000.000.00100% 0% Bond fund - spend down to zero - no reserves required 6582010 SEWER BOND0.000.000.000.000.00100% 0% Bond fund - spend down to zero - no reserves required 6592011 SEWER BOND233,522.46222,168.5811,353.880.0011,353.88100% 0% Bond fund - spend down to zero - no reserves required 6612012 SEWER BOND7,013,554.594,563,064.672,450,489.920.002,450,489.92100% 0% Bond fund - spend down to zero - no reserves required 6642013A SEWER REFUNDING BOND0.000.000.000.000.00100% 0% Bond fund - spend down to zero - no reserves required 6662015 SEWER BOND0.000.000.000.000.00100% 0% Bond fund - spend down to zero - no reserves required 672CENTURY CENTER ENERGY SAVINGS96,857.780.0096,857.780.0096,857.78100% 0% No reserve required 677HALL OF FAME CAPITAL FUND502,983.002,215.98500,767.020.00500,767.02100% 0% No reserve requirement 38,491,163.4212,535,294.6725,955,868.750.0025,955,868.75City Operations Total231,252,737.4434,729,036.02196,523,701.42101,583,506.0794,940,195.35Cash Reserve Report 3 City of South BendCash Reserves Summary by Fund Actual FundFund Nam e CashOutstandingAvailableCash ReservePercentageBalanceEncumbrancesCashRequirement V arianceof BudgetNotesThresholdMeasurement City Controlled Fund sGeneral Fund 101GENERAL FUND 25,719,540.82776,131.1524,943,409. 6716,426,158.908,517,250.7746% Property taxes received in June30% Annual expenditures - higher due to property tax delays Special Revenue Funds 102RAINY DAY FUND10,162,862.340.00 10,162,862.348,805,170. 671,357,691.673% 3% Total expenditures in previous fiscal year-contingency 103EXCESS LEVY0.000.000.000.000.00 100% 0% No reserve requirement 201PARKS & RECREATION 2,486,791. 93206,888.222,279, 903.712,840,864.75 (560,961.04) 20% Property taxes received in June25% Annual expenditures 202MOTOR VEHICLE HIGHWAY6,444,190.14 381,084.156,063,105.992, 744,352.253,318,753.7455% 25% Annual expenditures 203RECREATION - NONREVERTING 875,047.6789,250.19785,797. 48364,938.50420,858.9854% 25% Annual expenditures 209STUDEBAKER/OLIVER REVERTING GRANTS1,186,884.06831,020.18355,863. 880.00355,863.88100% 0% No reserve requirement 210DEPT COMMUNITY INVESTMENT STATE GRANTS 231,795.01437,745.00 (205,949.99)0.00 (205,949.99) 100% To be reimbursed by grant receipts0% No reserve requirement 211DCI ADMINISTRATION FUND1,138,993. 8379,349.351,059,644.48 671,828.25387,816.2339% 25% Annual expenditures 212DCI GRANT FUND480,632.67 3,186,420.42(2,705,787.75)0.00 (2,705,787.75) 100% To be reimbursed by grant receipts0% Grant fund - reimbursement grants - no reserves 216POLICE STATE SEIZURES228,328. 640.00228,328.649, 000.00219,328.64634% 25% Annual expenditures 217GIFT, DONATION, BEQUEST104,909.220.00104,909.22 0.00104,909.22100% 0% No reserve requirement 218POLICE CURFEW VIOLATIONS12,511.760.0012,511.76 250.0012,261.761251% 25% Annual expenditures 219UNSAFE BUILDING387,005. 75200,218.61186,787.14231,624.25 (44,837.11) 20% High encumbrances25% Annual expenditures 220LAW ENFORCEMENT CONTINUING EDUCA TION815,591.3358,207.59757, 383.74185,877.00571,506.74102% 25% Annual expenditures 227LOSS RECOVERY FUND 974, 967.44105,141.92869,825. 520.00869,825.52100% 0% No reserve requirement 244EMERGENCY PHONE SYSTEM33, 670.740.0033,670.740.0033,670.74100% 0% No reserve requirement 249PUBLIC SAFETY L.O.I.T.954,088. 400.00954,088.40528, 050.08426,038.3214% 8% Annual expenditures - one month reserve 251LOCAL ROADS & STREETS3,081,694.56 640,732.082,440,962.48560, 736.001,880,226.48109% 25% Annual expenditures 252EXCESS WELFARE DISTRIBUTION8.070.008.070.008.07 100% 0% No reserve requirement 257LOIT 2016 SPECIAL DISTRIBUTION4,058,382.29550,331.513,508,050. 780.003,508,050.78100% 0% No reserve requirement 258HUMAN RIGHTS - FEDERAL GRANT 475,783.261,698.50474,084. 7655,459.50418,625.26214% 25% Annual expenditures 271EASTRACE WATERWAY1,344.400.001,344.400.001,344.40100% 0% No reserve requirement 273MORRIS PAC/PALAIS ROYALE MARKETIN G42,106.362,632.5039,473. 864,719.5034,754.36209% 25% Annual expenditures 279311 CALL CENTER(180.03)2,978.37(3,158.40)0.00 (3,158.40) 100% Will be reimbursed through inter-f und xfr0% No reserve requirement 280POLICE BLOCK GRANTS3,877. 200.003,877.200.003,877.20100% 0% No reserve requirement 281REDEVELOPMENT COMMISSION - REV BONDS27,553.990.0027,553.990.0027,553.99100% 0% No reserve requirement 289HAZMAT24,666.070.0024, 666.072,500.0022,166.07247% 25% Annual expenditures 291INDIANA RIVER RESCUE170,034.84 10,806.69159,228.1523, 825.00135,403.15167% 25% Annual expenditures 292POLICE GRANTS87,957.3022, 134.0065,823.300.0065,823.30100% 0% No reserve requirement 294REGIONAL POLICE ACADEMY85,081.750.0085,081.75 5,625.0079,456.75378% 25% Annual expenditures 295COPS MORE GRANT147,617. 67173,862.87(26,245.20)0.00 (26,245.20) 100% 0% No reserve requirement 299POLICE FEDERAL DRUG ENFORCEMENT 252,683.620.00252,683.62 42,241.25210,442.37150% 25% Annual expenditures 404COUNTY OPTION INCOME TAX 9,812,307.76827,179.768,985,128.007, 845,724.001,139,404.0057% 50% Annual expenditures - higher due to bonding and rating agencies 408ECONOMIC DEVELOPMENT INCOME TAX 10,795,906.61484,385.9210,311,520.69 5,280,090.505,031,430.1998% 50% Annual expenditures - higher due to bonding and rating agencies 410URBAN DEVELOPMENT ACTION GRANT (UDAG) 395,985.060.00395,985. 060.00395,985.06100% 0% No reserve requirement 655PROJECT RELEAF824,669.321, 322.56823,346.76132, 089.50691,257.26156% 25% Annual expenditures 705POLICE K-9 UNIT2,852.25 0.002,852.25505.002,347.25141% 25% Annual expenditures Total Special Revenue Funds 56,808,603.288,293,390.3948,515, 212.8930,335,471.0018,179,741.89 Debt Service Fund 313HALL OF FAME DEBT SERVICE (397,174.84)0.00(397,174.84)0.00 (397,174.84) 100% Will be reimbursed from property taxes0% No reserve requirement Capital Project Funds 377PROFESSIONAL SPORTS DEVELOPMENT 218,481.750.00218,481.75 209,513.008,968.7526% Fund balance declining as debt paid off25% Annual expenditures 401COVELESKI STADIUM CAPITAL 101,819.288,045.0093,774. 280.0093,774.28100% 0% No reserve requirement 403ZOO ENDOWMENT49,792.72 0.0049,792.720.0049,792.72100% 0% No reserve requirement 405PARK NONREVERTING CAPITAL 365,209.2540,709.72324,499. 5395,773.75228,725.7885% 25% Annual expenditures 406CUMULATIVE CAPITAL DEVELOPMENT 371,540.930.00371,540.93 131,684.25239,856.6871% 25% Annual expenditures 407CUMULATIVE CAPITAL IMPROVEMENT 241,526.350.00241,526.35 92,062.50149,463.8566% 25% Annual expenditures 412MAJOR MOVES CONSTRUCTION2,244,132.71477,605.131,766,527. 580.001,766,527.58100% 0% No reserve requirement 416MORRIS PERFORMING ARTS CENTER CAPITAL559,770.546,869.00552, 901.5419,730.75533,170.79701% 25% Annual expenditures 434CRED FUND2,916.190.00 2,916.190.002,916.19100% 0% No reserve requirement 450PALAIS ROYALE HISTORIC PRESERVATION87,336.740.0087,336.740.0087,336.74100% 25% Annual expenditures 677HALL OF FAME CAPITAL FUND502, 983.002,215.98500,767. 020.00500,767.02100% 0% No reserve requirement Total Capital & Debt Service Funds 4,348,334.62535,444.833,812, 889.79548,764.253,264,125.54 Enterprise Funds 287EMS / FIRE DEPARTMENT CAPITAL3,456,397.7249,856.503,406,541. 22795,096.502,611,444.72107% 25% Annual expenditures 288EMS / FIRE DEPARTMENT OPERATING2,094,389.8750,123.352,044,266. 521,535,160.75509,105.7733% 25% Annual expenditures 600CONSOLIDATED BUILDING DEPARTMENT2,361,735.76132,184.772,229,550. 99881,119.251,348,431.7463% 25% Annual expenditures 601PARKING GARAGES856,373.69287, 254.80569,118.89348, 367.75220,751.1441% Enc is for year's operations under contract25% Annual expenditures September 30, 2016 Cash Reserve Policy Cash Reserve Report 4 City of South BendCash Reserves Summary by Fund Actual FundFund Nam e CashOutstandingAvailableCash ReservePercentageBalanceEncumbrancesCashRequirement V arianceof BudgetNotesThresholdMeasurement September 30, 2016 Cash Reserve Policy 610SOLID WASTE OPERATIONS 286,160.69235,283.73 50,876.96574,741.20 (523,864.24) 1% Tight budget10% Annual expenditures 611SOLID WASTE CAPITAL178,383. 58307.41178,076.170.00178,076.17100% 0% No reserve requirement 620WATER WORKS OPERATIONS3,873,787.83 823,930.253,049,857.58852, 382.852,197,474.7318% 5% Annual expenditures 622WATER WORKS CAPITAL2,589,963.01 107,028.002,482,935.01 0.002,482,935.01100% 0% No reserve requirement 624WATER WORKS CUSTOMER DEPOSIT1, 540,709.930.001,540,709. 931,540,709.930.00100% 100% 100% cash reserves for customer deposits 625WATER WORKS SINKING FUND1,191, 941.870.001,191,941.87 0.001,191,941.87100% 0% No Reserves - transfer from operating account for debt service as needed 626WATER WORKS BOND RESERVE1,644,326.340.001,644,326. 341,644,326.340.00100% 100% 100% cash reserves per bond covenants and Crowe Horwath 629WATER WORKS RESERVE - O & M2,462,727.680.002,462, 727.682,473,229.55 (10,501.87) 17% Actual Percentage = 16.599%, only slightly less16.67% Annual operating expenses in Fund 620 , net of transfers 640SEWER REPAIR INSURANCE1,774,107.5128,693.531,745,413. 98137,353.251,608,060.73318% 25% Annual expenditures 641SEWAGE WORKS OPERATIONS11,933,135.633, 005,877.158,927,258.482, 004,871.906,922,386.5822% 5% Annual expenditures 642SEWAGE WORKS CAPITAL7,898,376.72 1,835,213.096,063,163.63 0.006,063,163.63100% 0% No Reserves - transfer from operating account as needed 643SEWAGE WORKS RESERVE - O & M4,636,374.150.004,636,374. 154,635,601.94772.2117% Actual Percentage = 16.673%, only slightly less16.67% Annual operating expenses in Fund 641 , net of transfers 6452006 SEWER BOND0.000.000.000.000.00100% 0% Bond fund - spend down to zero - no reserves 6472007 SEWER BOND0.000.000.000.000.00100% 0% Bond fund - spend down to zero - no reserves 649SEWAGE WORKS BOND SINKING6,537, 418.910.006,537,418.91 0.006,537,418.91100% 0% No Reserves - transfer from operating account for debt service as needed 6512007B SEWER BOND0.000.000.000.000.00100% 0% Bond fund - spend down to zero - no reserves required 653SEWAGE WORKS DEBT SERVICE RESERVE4,109,042.540.004,109,042. 544,109,042.540.00100% 100% 100% cash reserves per bond covenants and Crowe Horwath 6582010 SEWER BOND0.000.000.000.000.00100% 0% Bond fund - spend down to zero - no reserves required 6592011 SEWER BOND233,522.46222, 168.5811,353.880.0011,353.88100% 0% Bond fund - spend down to zero - no reserves required 6612012 SEWER BOND7,013,554.594,563, 064.672,450,489.920. 002,450,489.92100% 0% Bond fund - spend down to zero - no reserves required 6642013A SEWER REFUNDING BO ND0.000.000.000.000.00100% 0% Bond fund - spend down to zero - no reserves required 6662015 SEWER BOND0.000.000.000.000.00100% 0% Bond fund - spend down to zero - no reserves required 670CENTURY CENTER1,744,266.140. 001,744,266.14993,109.50751,156.6444% 25% Annual expenditures 671CENTURY CENTER CAPITAL884, 782.230.00884,782.23 800,000.0084,782.23100% 800,000$ Minimum per Board of Managers 672CENTURY CENTER ENERGY SAVINGS96,857.780.0096,857.780.0096,857.78100% 0% No reserve required Total Enterprise Funds 69,398,336.6311,340,985.8358,057, 350.8023,325,113.2434,732,237.56 Internal Service Funds 222CENTRAL SERVICES1,608,671.19503, 311.961,105,359.231, 005,449.5099,909.7327% 25% Annual expenditures, excluding utility accounting 224CENTRAL SERVICES CAPITAL( 16,896.22)10,012.54(26,908.76)0.00 (26,908.76) 100% 0% No reserve required 226LIABILITY INSURANCE4,606,391.0526, 968.844,579,422.211,560, 174.003,019,248.21147% 50% Annual expenditures - higher reserves for future claims 278TAKE HOME VEHICLE POLICE 729,136.960.00729,136.96 2,500.00726,636.967291% 25% Annual expenditures 711SELF-FUNDED EMPLOYEE BENEFITS5,906,436.85170,837.525,735, 599.334,344,722.501,390,876.8333% 25% Annual expenditures 713UNEMPLOYMENT COMP FUND307,280. 4015,400.00291,880.40 28,470.50263,409.90256% 25% Annual expenditures Total Internal Service Funds 13,141,020.23726,530.8612,414,489. 376,941,316.505,473,172.87 Trust & Agency Funds 701FIREFIGHTERS PENSION 1,388,933. 980.001,388,933.98 546,484.30842,449.6825% Pension payments received in June & Sep10% Annual expenditures 702POLICE PENSION 2,334,300.370. 002,334,300.37679,739. 801,654,560.5734% Pension payments received in June & Sep10% Annual expenditures 703POLICE/FIRE 1977 STATE PENSION0.000.000.000.000.00100% 100% 100% cash reserves - trust & agency funds 709PAYROLL FUND 6,613.590.006,613.596,613.590.00100% 100% 100% cash reserves - trust & agency funds 712PUBLIC EMPLOYEES RETIREMENT FUND0.000.000.000.000.00 100% 100% 100% cash reserves - trust & agency funds 718STATE TAX DEDUCTION FUND262,319.630.00262,319.63262,319.630.00100% 100% 100% cash reserves - trust & agency funds 725MORRIS / PALAIS BOX OFFICE1,924, 618.680.001,924,618.68 1,924,618.680.00100% 100% 100% cash reserves - trust & agency funds 726POLICE DISTRIBUTIONS PAYABLE 825,901.480.00825,901. 48825,901.480.00100% 100% 100% cash reserves - trust & agency funds 730CITY CEMETERY TRUST28,742. 090.0028,742.095,000.0023,742.09144% 25% Annual expenditures Total Trust & Agency Funds 6,771,429.820.006,771,429. 824,250,677.482,520,752.34 Total City Funds 176,187,265.4021,672,483.06154,514, 782.3481,827,501.3772,687,280.97 Redevelopment Commission Controlled FundsTax Increment Financing Funds 324RIVER WEST TIF (AIRPORT TIF)28,880,665. 397,583,725.8721,296,939.52 11,125,519.2510,171,420.2748% 25% Annual expenditures 422TIF DISTRICT - WEST WASHINGTON 1,789,771.63305,847.251,483,924. 38350,841.501,133,082.88106% 25% Annual expenditures 425TIF LEIGHTON PLAZA208,516. 890.00208,516.8940, 101.50168,415.39130% 25% Annual expenditures 429RIVER EAST DEV TIF (NORTHEAST TIF)7,808,005.663,380,989.314, 427,016.352,083,789.752, 343,226.6053%25%Annual expenditures 430TIF SOUTHSIDE DEVELOPMENT AREA #1 4,489,746.961,780,343.532,709,403. 431,852,953.75856,449.6837% Enc for large project in 201625% Annual expenditures 432TIF SSDA #3 - ERSKINE VILLAGE4,848, 003.400.004,848,003.40 122,625.754,725,377.65988% 25% Annual expenditures 435TIF - DOUGLAS ROAD243,765.15 4,316.00239,449.1535, 420.00204,029.1568% Using cash bal for debt svc; then w ill close10% Annual expenditures 436RIVER EAST RESIDENTIAL (NE RES TIF) 973,939.111,331.00972,608. 11857,500.00115,108.1128% Will be tight in 2016; committed to debt svc25% Annual expenditures Total Tax Increment Financing Funds 49,242,414.1913,056,552.9636,185, 861.2316,468,751.5019,717,109.73 Redevelopment Funds 433REDEVELOPMENT ADMINISTRATION GENERAL8,763.080.008,763.08 1,125.007,638.08195% 25% Annual expenditures Cash Reserve Report 5 City of South BendCash Reserves Summary by Fund Actual FundFund Nam e CashOutstandingAvailableCash ReservePercentageBalanceEncumbrancesCashRequirement V arianceof BudgetNotesThresholdMeasurement September 30, 2016 Cash Reserve Policy 439CERTIFIED TECHNOLOGY PARK2,145,880.570.002,145,880.57 0.002,145,880.57100% 0% No reserve required 454AIRPORT URBAN ENTERPRISE ZO NE382,286.000.00382,286. 000.00382,286.00100% 0% No reserve required Total Redevelopment Funds 2,536,929.650.002,536,929. 651,125.002,535,804.65 Debt Service Funds 315AIRPORT 2003 DEBT R ESERVE1,038,904.000.001,038,904. 001,038,904.000.00100% 100% 100% debt service reserve per bond covenants 317COVELESKI BOND DEBT RESERVE 511,384.200.00511,384. 20511,384.200.00100% 100% 100% debt service reserve per bond covenants 319REDEVELOPMENT BOND - BLACKTHORN GOLF0.000.000.000.000.00 100% 100% 100% debt service reserve per bond covenants 328SBCDA 2003 DEBT R ESERVE1,735,840.000.001,735,840. 001,735,840.000.00100% 100% 100% debt service reserve per bond covenants Total Debt Service Funds 3,286,128.200.003,286, 128.203,286,128.200.00 Total Redevelopment Commission Funds 55,065,472.0413,056,552.9642,008, 919.0819,756,004.7022,252,914.38 City Operations Total 231,252,737.4434,729,036.02196,523, 701.42101,583,506.0794,940,195.35 Cash Reserve Report 6 General Fund - 101 DateAvailable Cash Reserve RequirementDateActual Percent Percent Requirement 02/28/1419,666,397.13$ 14,060,717.50$ 02/28/1435%25% 03/31/1416,931,467.58$ 14,071,197.25$ 03/31/1430%25% 04/30/1413,664,592.50$ 14,071,197.25$ 04/30/1424%25% 05/31/1410,906,411.36$ 14,071,197.25$ 05/31/1419%25% 06/30/1429,432,779.84$ 14,071,197.25$ 06/30/1452%25% 07/31/1426,473,744.03$ 14,088,697.25$ 07/31/1447%25% 08/31/1423,722,786.84$ 14,088,697.25$ 08/31/1442%25% 09/30/1420,202,390.82$ 14,088,697.25$ 09/30/1436%25% 10/31/1417,007,547.31$ 14,088,697.25$ 10/31/1430%25% 11/30/1413,644,872.96$ 14,088,697.25$ 11/30/1424%25% 12/31/1427,947,677.74$ 14,238,697.25$ 12/31/1449%25% 01/31/1523,253,550.72$ 13,344,782.75$ 01/31/1544%25% 02/28/1520,413,331.83$ 13,344,782.75$ 02/28/1538%25% 03/31/1517,372,699.76$ 13,344,782.75$ 03/31/1533%25% 04/30/1513,029,346.27$ 13,344,782.75$ 04/30/1524%25% 05/31/1510,341,225.60$ 13,344,782.75$ 05/31/1519%25% 06/30/1529,661,774.55$ 13,344,782.75$ 06/30/1556%25% 07/31/1525,659,540.97$ 13,344,782.75$ 07/31/1548%25% 08/31/1523,117,854.30$ 13,344,782.75$ 08/31/1543%25% 09/30/1520,515,512.68$ 13,344,782.75$ 09/30/1538%25% 10/31/1519,719,996.44$ 13,344,782.75$ 10/31/1537%25% 11/30/1518,556,106.39$ 13,344,782.75$ 11/30/1535%25% 12/31/1530,019,921.23$ 13,344,794.00$ 12/31/1556%25% 01/31/1626,714,068.20$ 16,356,186.90$ 01/31/1649%30% 02/29/1622,402,610.86$ 16,356,186.90$ 02/29/1641%30% 03/31/1619,441,972.53$ 16,356,186.90$ 03/31/1636%30% 04/30/1616,414,709.77$ 16,356,186.90$ 04/30/1630%30% 05/31/1613,709,088.23$ 16,363,686.90$ 05/31/1625%30% 06/30/1634,004,009.56$ 16,363,686.90$ 06/30/1662%30% 07/31/1629,671,975.06$ 16,363,686.90$ 07/31/1654%30% 08/31/1626,819,728.97$ 16,363,686.90$ 08/31/1649%30% 09/30/1624,943,409.67$ 16,426,158.90$ 09/30/1646%30% $- $5 $10 $15 $20 $25 $30 $35 $40 Millions Available Cash Reserve Requirement 0% 10%20%30%40%50%60%70% Actual Percent Percent Requirement Cash Reserve Report 7 Parks & Recreation - 201 DateAvailable Cash Reserve RequirementDateActual Percent Percent Requirement 02/28/141,648,649.90$ 3,150,219.50$ 02/28/1413%25% 03/31/141,032,377.06$ 3,150,219.50$ 03/31/148%25% 04/30/14590,542.73$ 3,150,219.50$ 04/30/145%25% 05/31/1483,244.80$ 3,150,219.50$ 05/31/141%25% 06/30/143,535,769.93$ 3,150,219.50$ 06/30/1428%25% 07/31/143,047,667.29$ 3,150,219.50$ 07/31/1424%25% 08/31/142,094,579.12$ 3,150,219.50$ 08/31/1417%25% 09/30/141,554,697.71$ 3,150,219.50$ 09/30/1412%25% 10/31/141,005,198.50$ 3,150,219.50$ 10/31/148%25% 11/30/14282,628.37$ 3,150,219.50$ 11/30/142%25% 12/31/143,405,573.74$ 3,150,219.50$ 12/31/1427%25% 01/31/151,840,741.75$ 2,765,998.75$ 01/31/1517%25% 02/28/151,273,084.28$ 2,765,998.75$ 02/28/1512%25% 03/31/15623,258.50$ 2,765,998.75$ 03/31/156%25% 04/30/15181,071.57$ 2,765,998.75$ 04/30/152%25% 05/31/15(211,123.70)$ 2,765,998.75$ 05/31/15-2%25% 06/30/153,436,165.29$ 2,765,998.75$ 06/30/1531%25% 07/31/152,719,475.08$ 2,765,998.75$ 07/31/1525%25% 08/31/152,327,362.23$ 2,765,998.75$ 08/31/1521%25% 09/30/151,843,771.49$ 2,765,998.75$ 09/30/1517%25% 10/31/151,728,926.62$ 2,765,998.75$ 10/31/1516%25% 11/30/151,255,488.41$ 2,765,998.75$ 11/30/1511%25% 12/31/153,854,236.64$ 2,765,998.75$ 12/31/1535%25% 01/31/162,893,336.74$ 2,812,174.25$ 01/31/1626%25% 02/29/162,266,893.61$ 2,812,174.25$ 02/29/1620%25% 03/31/161,219,651.51$ 2,812,174.25$ 03/31/1611%25% 04/30/16627,650.50$ 2,812,174.25$ 04/30/166%25% 05/31/16239,003.78$ 2,812,174.25$ 05/31/162%25% 06/30/164,395,360.17$ 2,812,174.25$ 06/30/1639%25% 07/31/163,544,105.58$ 2,840,864.75$ 07/31/1631%25% 08/31/162,753,224.95$ 2,840,864.75$ 08/31/1624%25% 09/30/162,279,903.71$ 2,840,864.75$ 09/30/1620%25% $(1) $- $1 $2 $3 $4 $5 Millions Available Cash Reserve Requirement -5%0%5% 10%15%20%25%30%35%40%45% Actual Percent Percent Requirement Cash Reserve Report 8 Motor Vehicle Highway - 202 DateAvailable Cash Reserve RequirementDateActual Percent Percent Requirement 02/28/142,055,931.61$ 1,941,729.60$ 02/28/1421%20% 03/31/141,890,447.88$ 1,941,729.60$ 03/31/1419%20% 04/30/143,351,701.43$ 1,941,729.60$ 04/30/1435%20% 05/31/143,470,456.90$ 1,941,729.60$ 05/31/1436%20% 06/30/143,366,866.26$ 1,941,729.60$ 06/30/1435%20% 07/31/142,837,076.85$ 2,001,775.40$ 07/31/1428%20% 08/31/142,217,578.14$ 2,001,775.40$ 08/31/1422%20% 09/30/142,402,072.20$ 2,001,775.40$ 09/30/1424%20% 10/31/143,204,864.97$ 2,001,775.40$ 10/31/1432%20% 11/30/142,968,298.70$ 2,001,775.40$ 11/30/1430%20% 12/31/143,093,394.24$ 2,001,775.40$ 12/31/1431%20% 01/31/153,012,565.62$ 2,097,077.20$ 01/31/1529%20% 02/28/153,448,810.96$ 2,097,077.20$ 02/28/1533%20% 03/31/153,183,955.62$ 2,097,077.20$ 03/31/1530%20% 04/30/153,452,526.78$ 2,097,077.20$ 04/30/1533%20% 05/31/154,710,213.84$ 2,097,077.20$ 05/31/1545%20% 06/30/154,107,360.98$ 2,097,077.20$ 06/30/1539%20% 07/31/153,592,332.11$ 2,097,077.20$ 07/31/1534%20% 08/31/153,616,538.87$ 2,097,077.20$ 08/31/1534%20% 09/30/154,646,069.85$ 2,097,077.20$ 09/30/1544%20% 10/31/155,122,032.44$ 2,097,077.20$ 10/31/1549%20% 11/30/154,893,300.77$ 2,097,077.20$ 11/30/1547%20% 12/31/154,592,169.19$ 2,097,077.20$ 12/31/1544%20% 01/31/164,945,234.80$ 2,744,352.25$ 01/31/1645%25% 02/29/164,719,277.00$ 2,744,352.25$ 02/29/1643%25% 03/31/164,655,411.71$ 2,744,352.25$ 03/31/1642%25% 04/30/166,006,911.17$ 2,744,352.25$ 04/30/1655%25% 05/31/165,946,807.19$ 2,744,352.25$ 05/31/1654%25% 06/30/165,362,184.14$ 2,744,352.25$ 06/30/1649%25% 07/31/165,851,030.22$ 2,744,352.25$ 07/31/1653%25% 08/31/166,027,050.77$ 2,744,352.25$ 08/31/1655%25% 09/30/166,063,105.99$ 2,744,352.25$ 09/30/1655%25% $- $1 $2 $3 $4 $5 $6 $7 Millions Available Cash Reserve Requirement 0% 10%20%30%40%50%60% Actual Percent Percent Requirement Cash Reserve Report 9 Liability Insurance - 226 DateAvailable Cash Reserve RequirementDateActual Percent Percent Requirement 02/28/145,019,217.44$ 724,300.00$ 02/28/14173%25% 03/31/145,075,527.45$ 724,300.00$ 03/31/14175%25% 04/30/145,218,468.25$ 724,300.00$ 04/30/14180%25% 05/31/145,341,078.00$ 724,300.00$ 05/31/14184%25% 06/30/145,099,755.96$ 724,300.00$ 06/30/14176%25% 07/31/145,133,550.90$ 724,300.00$ 07/31/14177%25% 08/31/145,274,005.60$ 724,300.00$ 08/31/14182%25% 09/30/145,400,963.70$ 724,300.00$ 09/30/14186%25% 10/31/145,541,538.17$ 724,300.00$ 10/31/14191%25% 11/30/145,813,654.41$ 724,300.00$ 11/30/14201%25% 12/31/145,682,684.39$ 724,300.00$ 12/31/14196%25% 01/31/155,461,655.49$ 764,197.75$ 01/31/15179%25% 02/28/155,314,999.89$ 764,197.75$ 02/28/15174%25% 03/31/155,269,874.19$ 764,197.75$ 03/31/15172%25% 04/30/155,024,562.10$ 764,197.75$ 04/30/15164%25% 05/31/154,960,310.54$ 764,197.75$ 05/31/15162%25% 06/30/154,559,500.84$ 764,197.75$ 06/30/15149%25% 07/31/154,349,972.24$ 764,197.75$ 07/31/15142%25% 08/31/154,391,466.11$ 764,197.75$ 08/31/15144%25% 09/30/154,412,089.90$ 764,197.75$ 09/30/15144%25% 10/31/154,536,090.51$ 764,197.75$ 10/31/15148%25% 11/30/154,528,101.76$ 764,197.75$ 11/30/15148%25% 12/31/154,485,904.07$ 764,197.75$ 12/31/15147%25% 01/31/164,527,921.79$ 1,560,174.00$ 01/31/16145%50% 02/29/164,467,494.26$ 1,560,174.00$ 02/29/16143%50% 03/31/164,575,011.10$ 1,560,174.00$ 03/31/16147%50% 04/30/164,715,447.12$ 1,560,174.00$ 04/30/16151%50% 05/31/164,742,379.31$ 1,560,174.00$ 05/31/16152%50% 06/30/164,468,697.42$ 1,560,174.00$ 06/30/16143%50% 07/31/164,564,161.11$ 1,560,174.00$ 07/31/16146%50% 08/31/164,560,561.09$ 1,560,174.00$ 08/31/16146%50% 09/30/164,579,422.21$ 1,560,174.00$ 09/30/16147%50% $- $1 $2 $3 $4 $5 $6 $7 Millions Available Cash Reserve Requirement 0% 50%100%150%200%250% Actual Percent Percent Requirement Cash Reserve Report 10 Public Safety LOIT - 249 DateAvailable Cash Reserve RequirementDateActual Percent Percent Requirement 02/28/141,965,415.14$ 1,442,931.60$ 02/28/1427%20% 03/31/141,788,938.50$ 1,442,931.60$ 03/31/1425%20% 04/30/141,727,753.74$ 1,442,931.60$ 04/30/1424%20% 05/31/141,686,442.29$ 1,442,931.60$ 05/31/1423%20% 06/30/141,604,462.03$ 1,442,931.60$ 06/30/1422%20% 07/31/141,028,769.93$ 1,442,931.60$ 07/31/1414%20% 08/31/141,313,459.48$ 1,442,931.60$ 08/31/1418%20% 09/30/141,263,069.52$ 1,442,931.60$ 09/30/1418%20% 10/31/14704,536.10$ 1,442,931.60$ 10/31/1410%20% 11/30/141,313,921.77$ 1,442,931.60$ 11/30/1418%20% 12/31/141,293,978.68$ 1,442,931.60$ 12/31/1418%20% 01/31/151,101,184.99$ 1,449,310.20$ 01/31/1515%20% 02/28/151,122,087.44$ 1,449,310.20$ 02/28/1515%20% 03/31/15573,193.85$ 1,449,310.20$ 03/31/158%20% 04/30/151,146,259.78$ 1,449,310.20$ 04/30/1516%20% 05/31/151,168,383.41$ 1,449,310.20$ 05/31/1516%20% 06/30/151,149,240.91$ 1,449,310.20$ 06/30/1516%20% 07/31/15970,331.63$ 1,449,310.20$ 07/31/1513%20% 08/31/15467,350.59$ 1,449,310.20$ 08/31/156%20% 09/30/15976,720.23$ 1,449,310.20$ 09/30/1513%20% 10/31/15997,198.89$ 1,449,310.20$ 10/31/1514%20% 11/30/15899,505.58$ 1,449,310.20$ 11/30/1512%20% 12/31/15642,770.29$ 1,449,310.20$ 12/31/159%20% 01/31/16687,550.93$ 528,050.08$ 01/31/1610%8% 02/29/16760,706.63$ 528,050.08$ 02/29/1612%8% 03/31/16813,317.68$ 528,050.08$ 03/31/1612%8% 04/30/16879,072.20$ 528,050.08$ 04/30/1613%8% 05/31/16925,892.22$ 528,050.08$ 05/31/1614%8% 06/30/16936,320.86$ 528,050.08$ 06/30/1614%8% 07/31/16805,810.30$ 528,050.08$ 07/31/1612%8% 08/31/16896,024.75$ 528,050.08$ 08/31/1614%8% 09/30/16954,088.40$ 528,050.08$ 09/30/1614%8% $- $1 $1 $2 $2 $3 Millions Available Cash Reserve Requirement 0%5% 10%15%20%25%30% Actual Percent Percent Requirement Cash Reserve Report 11 COIT - 404 DateAvailable Cash Reserve RequirementDateActual Percent Percent Requirement 02/28/1414,064,953.63$ 4,988,101.00$ 02/28/14141%50% 03/31/1414,419,544.87$ 5,096,642.50$ 03/31/14141%50% 04/30/1414,138,281.09$ 5,096,642.50$ 04/30/14139%50% 05/31/1414,417,615.48$ 5,582,892.50$ 05/31/14129%50% 06/30/1414,566,201.25$ 5,582,892.50$ 06/30/14130%50% 07/31/1413,784,177.94$ 5,582,892.50$ 07/31/14123%50% 08/31/1414,852,716.09$ 5,582,892.50$ 08/31/14133%50% 09/30/1414,014,334.96$ 5,582,892.50$ 09/30/14126%50% 10/31/1412,625,447.23$ 5,582,892.50$ 10/31/14113%50% 11/30/1413,703,278.95$ 5,582,892.50$ 11/30/14123%50% 12/31/1413,810,191.53$ 5,582,892.50$ 12/31/14124%50% 01/31/1513,363,623.40$ 7,830,185.50$ 01/31/1585%50% 02/28/1513,104,068.98$ 7,830,185.50$ 02/28/1584%50% 03/31/1512,417,613.96$ 7,830,185.50$ 03/31/1579%50% 04/30/1513,525,436.86$ 7,830,185.50$ 04/30/1586%50% 05/31/1513,483,035.78$ 7,830,185.50$ 05/31/1586%50% 06/30/1513,641,102.60$ 7,830,185.50$ 06/30/1587%50% 07/31/1513,287,258.01$ 7,830,185.50$ 07/31/1585%50% 08/31/1512,603,271.36$ 7,830,185.50$ 08/31/1580%50% 09/30/1511,982,696.06$ 7,830,185.50$ 09/30/1577%50% 10/31/1511,727,154.29$ 7,830,185.50$ 10/31/1575%50% 11/30/1511,326,023.58$ 7,830,185.50$ 11/30/1572%50% 12/31/159,895,195.52$ 7,946,833.50$ 12/31/1562%50% 01/31/168,575,802.53$ 7,581,074.00$ 01/31/1657%50% 02/29/168,755,381.46$ 7,581,074.00$ 02/29/1658%50% 03/31/168,571,654.20$ 7,581,074.00$ 03/31/1657%50% 04/30/168,681,223.99$ 7,581,074.00$ 04/30/1657%50% 05/31/169,021,396.98$ 7,595,724.00$ 05/31/1659%50% 06/30/169,622,287.72$ 7,595,724.00$ 06/30/1663%50% 07/31/168,477,616.02$ 7,595,724.00$ 07/31/1656%50% 08/31/168,686,205.23$ 7,595,724.00$ 08/31/1657%50% 09/30/168,985,128.00$ 7,845,724.00$ 09/30/1657%50% $- $2 $4 $6 $8 $10 $12 $14 $16 Millions Available Cash Reserve Requirement 0% 20%40%60%80%100%120%140%160% Actual Percent Percent Requirement Cash Reserve Report 12 EDIT - 408 DateAvailable Cash Reserve RequirementDateActual Percent Percent Requirement 02/28/149,278,816.60$ 5,007,492.00$ 02/28/1493%50% 03/31/149,966,875.90$ 5,007,492.00$ 03/31/14100%50% 04/30/149,076,730.26$ 5,007,492.00$ 04/30/1491%50% 05/31/149,202,305.40$ 5,144,992.00$ 05/31/1489%50% 06/30/149,910,209.22$ 5,144,992.00$ 06/30/1496%50% 07/31/148,958,071.99$ 5,144,992.00$ 07/31/1487%50% 08/31/149,903,901.38$ 5,144,992.00$ 08/31/1496%50% 09/30/1410,608,492.02$ 5,144,992.00$ 09/30/14103%50% 10/31/147,941,968.89$ 5,144,992.00$ 10/31/1477%50% 11/30/149,294,422.29$ 5,144,992.00$ 11/30/1490%50% 12/31/1410,033,655.55$ 5,144,992.00$ 12/31/1498%50% 01/31/1510,065,104.57$ 4,813,809.00$ 01/31/15105%50% 02/28/159,059,022.75$ 4,813,809.00$ 02/28/1594%50% 03/31/158,960,343.03$ 4,813,809.00$ 03/31/1593%50% 04/30/1510,291,604.12$ 4,813,809.00$ 04/30/15107%50% 05/31/1510,408,959.43$ 4,813,809.00$ 05/31/15108%50% 06/30/1511,163,475.51$ 4,971,854.50$ 06/30/15112%50% 07/31/159,675,461.38$ 4,971,854.50$ 07/31/1597%50% 08/31/159,550,701.30$ 4,971,854.50$ 08/31/1596%50% 09/30/159,399,079.89$ 5,066,874.50$ 09/30/1593%50% 10/31/159,158,107.55$ 5,066,874.50$ 10/31/1590%50% 11/30/159,112,235.29$ 5,066,874.50$ 11/30/1590%50% 12/31/159,776,901.11$ 5,066,874.50$ 12/31/1596%50% 01/31/167,938,199.64$ 5,280,090.50$ 01/31/1675%50% 02/29/168,715,559.52$ 5,280,090.50$ 02/29/1683%50% 03/31/169,792,593.12$ 5,280,090.50$ 03/31/1693%50% 04/30/169,500,919.49$ 5,280,090.50$ 04/30/1690%50% 05/31/1610,151,893.76$ 5,280,090.50$ 05/31/1696%50% 06/30/1610,863,175.70$ 5,280,090.50$ 06/30/16103%50% 07/31/168,965,098.11$ 5,280,090.50$ 07/31/1685%50% 08/31/169,561,231.11$ 5,280,090.50$ 08/31/1691%50% 09/30/1610,311,520.69$ 5,280,090.50$ 09/30/1698%50% $- $2 $4 $6 $8 $10 $12 Millions Available Cash Reserve Requirement 0% 20%40%60%80%100%120% Actual Percent Percent Requirement Cash Reserve Report 13 Self-funded Employee Benefits - 711 DateAvailable Cash Reserve RequirementDateActual Percent Percent Requirement 02/28/145,189,194.64$ 3,620,865.75$ 02/28/1436%25% 03/31/144,881,271.34$ 3,620,865.75$ 03/31/1434%25% 04/30/144,775,766.48$ 3,620,865.75$ 04/30/1433%25% 05/31/144,734,213.61$ 3,620,865.75$ 05/31/1433%25% 06/30/144,967,756.75$ 3,620,865.75$ 06/30/1434%25% 07/31/144,547,283.48$ 3,620,865.75$ 07/31/1431%25% 08/31/144,497,229.79$ 3,620,865.75$ 08/31/1431%25% 09/30/144,488,566.83$ 3,620,865.75$ 09/30/1431%25% 10/31/144,312,284.67$ 3,620,865.75$ 10/31/1430%25% 11/30/144,290,596.22$ 3,620,865.75$ 11/30/1430%25% 12/31/144,054,314.37$ 3,620,865.75$ 12/31/1425%25% 01/31/154,151,993.32$ 4,174,233.75$ 01/31/1525%25% 02/28/154,252,749.21$ 4,174,233.75$ 02/28/1525%25% 03/31/154,364,599.56$ 4,174,233.75$ 03/31/1526%25% 04/30/154,140,504.23$ 4,174,233.75$ 04/30/1525%25% 05/31/154,243,077.17$ 4,174,233.75$ 05/31/1525%25% 06/30/154,502,701.32$ 4,349,567.00$ 06/30/1526%25% 07/31/154,444,106.98$ 4,174,233.75$ 07/31/1527%25% 08/31/154,406,259.32$ 4,174,233.75$ 08/31/1526%25% 09/30/154,326,879.00$ 4,174,233.75$ 09/30/1526%25% 10/31/154,572,942.80$ 4,174,233.75$ 10/31/1527%25% 11/30/154,547,867.48$ 4,174,233.75$ 11/30/1527%25% 12/31/154,329,762.09$ 4,174,233.75$ 12/31/1526%25% 01/31/164,820,833.64$ 4,344,722.50$ 01/31/1628%25% 02/29/163,690,587.57$ 4,344,722.50$ 02/29/1621%25% 03/31/163,747,383.70$ 4,344,722.50$ 03/31/1622%25% 04/30/164,011,625.62$ 4,344,722.50$ 04/30/1623%25% 05/31/164,340,426.68$ 4,344,722.50$ 05/31/1625%25% 06/30/164,401,917.72$ 4,344,722.50$ 06/30/1625%25% 07/31/164,830,517.74$ 4,344,722.50$ 07/31/1628%25% 08/31/165,180,514.41$ 4,344,722.50$ 08/31/1630%25% 09/30/165,735,599.33$ 4,344,722.50$ 09/30/1633%25% $- $1 $2 $3 $4 $5 $6 $7 Millions Available Cash Reserve Requirement 0%5% 10%15%20%25%30%35%40% Actual Percent Percent Requirement Cash Reserve Report 14 City of South Bend Month of: Controller's Cash Report OpeningInterestTransfersTransfersEndingTotal Cash &Interfund LoansFundFund NameCash BalanceReceiptsDisbursementsEarnedInOutCash BalanceInvestmentsInvestments(Borrowing)City Controlled FundsGeneral Fund 101GENERAL FUND $28,115,817.1 5 $1,952,928.3 7 $4,384,402.6 9 $35,258.1 5 $0.00$60.16$25,719,540.8 2 $0.00 $25,719,540.8 2 $502,983.0 0 Special Revenue Funds 102RAINY DAY FUND10,150,791.990.000.0012,070.350.000.0010,162,862.340.00 10,162,862.34 0.00 103EXCESS LEVY0.000.000.000.000.000.000.000.00 0.00 0.00 201PARKS & RECREATION 3,025,719.74256,395.53799,401.944,078.600.000.002,486,791.930.00 2,486,791.93 0.00 202MOTOR VEHICLE HIGHWAY6,929,867.25458,020.06951,610.937,913.760.000.006,444,190.140.00 6,444,190.14 0.00 203RECREATION - NONREVERTING876,752.9252,555.9355,296.751,035.570.000.00875,047.670.00 875,047.67 0.00 209STUDEBAKER/OLIVER REVERTING GRANTS1,207,677.720.0022,223.811,430.150.000.001,186,884.060.00 1,186,884.06 500,000.00 210DEPT COMMUNITY INVESTMENT STATE GRANTS 338,369.660.00106,907.61332.960.000.00231,795.010.00 231,795.01 0.00 211DCI OPERATING FUND1,324,749.611,300.00188,745.851,690.070.000.001,138,993.830.00 1,138,993.83 0.00 212DEPARTMENT OF COMMUNITY INVESTMENT464,259.53665,894.18649,530.409.360.000.00480,632.670.00 480,632.67 0.00 216POLICE STATE SEIZURES228,057.830.000.00270.810.000.00228,328.640.00 228,328.64 0.00 217GIFT, DONATION, BEQUEST105,385.88420.001,000.00103.340.000.00104,909.220.00 104,909.22 0.00 218POLICE CURFEW VIOLATIONS12,484.4212.500.0014.840.000.0012,511.760.00 12,511.76 0.00 219UNSAFE BUILDING443,277.8614,661.1370,993.400.0060.160.00387,005.750.00 387,005.75 0.00 220LAW ENFORCEMENT CONTINUING EDUCATION814,892.9116,916.0917,202.93985.260.000.00815,591.330.00 815,591.33 0.00 227LOSS RECOVERY FUND 973,807.880.000.001,159.560.000.00974,967.440.00 974,967.44 0.00 244EMERGENCY TELEPHONE SYSTEM33,670.740.000.000.000.000.0033,670.740.00 33,670.74 0.00 249PUBLIC SAFETY L.O.I.T.896,024.75566,580.00509,347.70831.350.000.00954,088.400.00 954,088.40 0.00 251LOCAL ROADS & STREETS2,973,006.65194,445.8589,349.523,591.580.000.003,081,694.560.00 3,081,694.56 0.00 252EXCESS WELFARE DISTRIBUTION8.070.000.000.000.000.008.070.00 8.07 0.00 257LOIT 2016 SPECIAL DISTRIBUTION4,038,204.0087,788.0067,609.710.000.000.004,058,382.290.00 4,058,382.29 0.00 258HUMAN RIGHTS - FEDERAL GRANT447,162.4650,214.0090,990.40457.170.000.00406,843.2368,940.03 475,783.26 0.00 271EASTRACE WATERWAY1,342.800.000.001.600.000.001,344.400.00 1,344.40 0.00 273MORRIS PAC/PALAIS ROYALE MARKETING38,161.583,900.000.0044.780.000.0042,106.360.00 42,106.36 0.00 280POLICE BLOCK GRANTS3,872.600.000.004.600.000.003,877.200.00 3,877.20 0.00 281DEPT. COMMUNITY INVESTMENT - REV BONDS27,521.260.000.0032.730.000.0027,553.990.00 27,553.99 0.00 289HAZMAT24,636.770.000.0029.300.000.0024,666.070.00 24,666.07 0.00 291INDIANA RIVER RESCUE170,396.460.00566.86205.240.000.00170,034.840.00 170,034.84 0.00 292POLICE GRANTS87,957.300.000.000.000.000.0087,957.300.00 87,957.30 0.00 294REGIONAL POLICE ACADEMY85,358.850.00378.84101.740.000.0085,081.750.00 85,081.75 0.00 295COPS MORE GRANT160,213.12740.0013,490.00154.550.000.00147,617.670.00 147,617.67 0.00 299POLICE FEDERAL DRUG ENFORCEMENT247,047.868,093.262,578.56121.060.000.00252,683.620.00 252,683.62 0.00 404COUNTY OPTION INCOME TAX 9,637,462.85925,604.21762,287.3511,528.050.000.009,812,307.760.00 9,812,307.76 1,589,770.50 408ECONOMIC DEVELOPMENT INCOME TAX 10,081,381.03799,550.1796,448.5011,423.910.000.0010,795,906.610.00 10,795,906.61 0.00 410URBAN DEVELOPMENT ACTION GRANT (UDAG)487,510.610.0092,105.25579.700.000.00395,985.060.00 395,985.06 (1,589,770.50) 655PROJECT RELEAF800,349.0634,923.0811,534.60931.780.000.00824,669.320.00 824,669.32 0.00 705POLICE K-9 UNIT2,847.700.000.004.550.000.002,852.250.00 2,852.25 0.00 Total Special Revenue Funds 57,140,231.7 2 4,138,013.9 9 4,599,600.9161,138.3 2 60.160.0056,739,843.2 8 68,940.0 3 56,808,783.31 500,000.0 0 Debt Service Fund 313HALL OF FAME DEBT SERVICE (406,517.84) 9,343.000.000.000.000.00 (397,174.84) 0.00 (397,174.84) 0.00 Capital Project Funds 377PROFESSIONAL SPORTS DEVELOPMENT179,015.1639,290.000.00176.590.000.00218,481.750.00 218,481.75 0.00 401COVELESKI STADIUM CAPITAL60,957.5440,789.250.0072.490.000.00101,819.280.00 101,819.28 0.00 403ZOO ENDOWMENT49,733.580.000.0059.140.000.0049,792.720.00 49,792.72 0.00 405PARK NONREVERTING CAPITAL374,191.18257.009,614.91375.980.000.00365,209.250.00 365,209.25 0.00 406CUMULATIVE CAPITAL DEVELOPMENT 366,664.964,420.000.00455.970.000.00371,540.930.00 371,540.93 0.00 407CUMULATIVE CAPITAL IMPROVEMENT241,268.270.000.00258.080.000.00241,526.350.00 241,526.35 0.00 412MAJOR MOVES CONSTRUCTION2,242,433.490.00988.962,688.180.000.002,244,132.710.00 2,244,132.71 4,590,581.70 416MORRIS PERFORMING ARTS CENTER CAPITAL534,309.4628,415.003,590.00636.080.000.00559,770.540.00 559,770.54 0.00 434CRED FUND2,853.670.000.0062.520.000.002,916.190.00 2,916.19 0.00 450PALAIS ROYALE HISTORIC PRESERVATION86,132.061,103.970.00100.710.000.0087,336.740.00 87,336.74 0.00 677HALL OF FAME CAPITAL FUND511,770.050.009,400.33613.280.000.00502,983.000.00 502,983.00 (502,983.00)September 2016 Cash Reserve Report 15 City of South Bend Month of: Controller's Cash Report OpeningInterestTransfersTransfersEndingTotal Cash &Interfund LoansFundFund NameCash BalanceReceiptsDisbursementsEarnedInOutCash BalanceInvestmentsInvestments(Borrowing)September 2016 Total Capital & Debt Service Funds 4,242,811.5 8 123,618.2 2 23,594.2 0 5,499.020.000.004,348,334.6 2 0.00 4,348,334.6 2 4,087,598.7 0 Enterprise Funds 287EMS CAPITAL3,513,383.950.0060,935.163,948.930.000.003,456,397.720.00 3,456,397.72 0.00 288EMS OPERATING2,059,891.09563,978.06531,838.742,359.460.000.002,094,389.870.00 2,094,389.87 0.00 600CONSOLIDATED BUILDING DEPARTMENT2,474,192.84125,399.77240,876.653,019.800.000.002,361,735.760.00 2,361,735.76 0.00 601PARKING GARAGES800,595.76114,768.4059,938.79948.320.000.00856,373.690.00 856,373.69 0.00 610SOLID WASTE OPERATIONS242,991.23449,673.00406,929.10425.560.000.00286,160.690.00 286,160.69 0.00 611SOLID WASTE CAPITAL189,201.310.0011,039.89222.160.000.00178,383.580.00 178,383.58 0.00 620WATER WORKS OPERATIONS3,557,444.341,678,832.911,201,765.533,860.335,920.78170,505.003,873,787.830.00 3,873,787.83 0.00 622WATER WORKS CAPITAL2,586,765.090.000.003,197.920.000.002,589,963.010.00 2,589,963.01 0.00 624WATER WORKS CUSTOMER DEPOSIT1,537,565.0927,196.1624,051.321,821.950.001,821.951,540,709.930.00 1,540,709.93 0.00 625WATER WORKS SINKING FUND1,021,436.870.000.001,169.48170,505.001,169.481,191,941.870.00 1,191,941.87 0.00 626WATER WORKS BOND RESERVE1,642,410.370.000.001,915.970.000.001,644,326.340.00 1,644,326.34 0.00 629WATER WORKS RESERVE - O & M2,462,727.680.000.002,929.350.002,929.352,462,727.680.00 2,462,727.68 0.00 640SEWER REPAIR INSURANCE1,757,341.6749,891.0535,200.702,075.490.000.001,774,107.510.00 1,774,107.51 0.00 642SEWAGE WORKS CAPITAL6,750,091.840.00346,750.008,034.881,487,000.000.007,898,376.720.00 7,898,376.72 0.00 643SEWAGE WORKS RESERVE - O & M4,575,374.150.000.005,442.2761,000.005,442.274,636,374.150.00 4,636,374.15 0.00 649SEWAGE WORKS BOND SINKING5,758,844.330.000.006,439.43772,135.150.006,537,418.910.00 6,537,418.91 0.00 650CLAY SEWAGE WORKS OPERATIONS0.00 0.000.00 0.00 0.00 653SEWAGE WORKS DEBT SERVICE RESERVE4,107,883.920.000.001,158.620.000.004,109,042.540.00 4,109,042.54 0.00 6592011 SEWER BOND233,245.110.000.00277.350.000.00233,522.460.00 233,522.46 0.00 6612012 SEWER BOND7,012,306.470.009,333.1010,581.220.000.007,013,554.590.00 7,013,554.59 0.00 6642013 SEWER REFUND BOND4,532.560.000.005.390.004,537.950.000.00 0.00 0.00 6662015 SEWER BOND6,696.580.000.007.970.006,704.550.000.00 0.00 0.00 670CENTURY CENTER1,675,723.39772,054.88703,512.130.000.001,744,266.140.00 1,744,266.14 0.00 671CENTURY CENTER CAPITAL884,709.710.000.0072.520.000.00884,782.230.00 884,782.23 0.00 672CENTURY CENTER ENERGY SAVINGS96,853.684.244.244.100.000.0096,857.780.00 96,857.78 0.00 Total Enterprise Funds 67,673,880.4 2 7,000,919.8 2 5,351,900.3 3 75,436.7 2 2,502,003.2 0 2,502,003.2 0 69,398,336.6 3 0.00 69,398,336.6 3 0.00 Internal Service Funds 222CENTRAL SERVICES1,511,334.35981,967.40885,965.401,334.840.000.001,608,671.190.00 1,608,671.19 0.00 224CENTRAL SERVICES CAPITAL18,646.360.0035,575.4032.820.000.00 (16,896.22) 0.00 (16,896.22) 0.00 226LIABILITY INSURANCE4,600,004.44187,279.00186,329.425,437.030.000.004,606,391.050.00 4,606,391.05 0.00 278TAKE HOME VEHICLE POLICE719,866.858,420.000.00850.110.000.00729,136.960.00 729,136.96 0.00 279311 CALL CENTER (0.02) 37,247.6837,427.690.000.000.00 (180.03) 0.00 (180.03) 0.00 711SELF-FUNDED EMPLOYEE BENEFITS5,363,827.611,375,788.83839,792.796,613.200.000.005,906,436.850.00 5,906,436.85 0.00 713UNEMPLOYMENT COMP FUND303,933.2812,006.419,014.33355.040.000.00307,280.400.00 307,280.40 0.00 Total Internal Service Funds 12,517,612.8 7 2,602,709.3 2 1,994,105.0 3 14,623.0 4 0.000.0013,140,840.2 0 0.00 13,140,840.2 0 0.00 Trust & Agency Funds 701FIREFIGHTERS PENSION (639,774.55) 2,431,635.66402,927.130.000.000.001,388,933.980.00 1,388,933.98 0.00 702POLICE PENSION (142,563.13) 2,994,375.04517,916.02404.480.000.002,334,300.370.00 2,334,300.37 0.00 709PAYROLL FUND 6,613.597,841,465.367,841,465.360.000.000.006,613.590.00 6,613.59 0.00 718STATE TAX DEDUCTION FUND265,473.05262,319.63265,473.050.000.000.00262,319.630.00 262,319.63 0.00 725MORRIS / PALAIS BOX OFFICE3,468,042.090.001,543,423.410.000.000.001,924,618.680.00 1,924,618.68 0.00 726POLICE DISTRIBUTIONS PAY825,901.480.000.000.000.000.00825,901.480.00 825,901.48 0.00 730CITY CEMETERY TRUST28,707.950.000.0034.140.000.0028,742.090.00 28,742.09 0.00 Total Trust & Agency Funds 3,812,400.4 8 13,529,795.6 9 10,571,204.9 7 438.620.000.006,771,429.8 2 0.00 6,771,429.8 2 0.00 Total City Funds 173,502,754.2229,347,985.4126,924,808.13192,393.872,502,063.362,502,063.36176,118,325.3768,940.03176,187,265.405,090,581.70 Redevelopment Commission Controlled Funds Tax Increment Financing Funds 324TIF RIVER WEST - AIRPORT29,293,299.89298,623.40754,794.9540,236.583,300.470.0028,880,665.390.00 28,880,665.39 (500,000.00) Cash Reserve Report 16 City of South Bend Month of: Controller's Cash Report OpeningInterestTransfersTransfersEndingTotal Cash &Interfund LoansFundFund NameCash BalanceReceiptsDisbursementsEarnedInOutCash BalanceInvestmentsInvestments(Borrowing)September 2016 422TIF DISTRICT - WEST WASHINGTON 1,787,645.930.000.002,125.700.000.001,789,771.630.00 1,789,771.63 0.00 425TIF LEIGHTON PLAZA208,515.5816,220.2016,416.25197.360.000.00208,516.890.00 208,516.89 0.00 429TIF RIVER EAST DEV (NE)7,747,453.0064,824.0013,917.889,646.540.000.007,808,005.660.00 7,808,005.66 0.00 430TIF SOUTHSIDE DEVELOPMENT AREA #1 5,050,706.340.00567,687.656,728.270.000.004,489,746.960.00 4,489,746.96 0.00 432TIF SSDA #3 - ERSKINE VILLAGE4,842,245.480.000.005,757.920.000.004,848,003.400.00 4,848,003.40 0.00 435TIF DOUGLAS ROAD243,475.630.000.00289.520.000.00243,765.150.00 243,765.15 (511,408.00) 436TIF RIVER EAST RES (NE RE) 973,939.110.000.000.000.000.00973,939.110.00 973,939.11 (4,079,173.70) Total Tax Increment Financing Funds 50,147,280.9 6 379,667.6 0 1,352,816.7 3 64,981.8 9 3,300.4 7 0.0049,242,414.1 9 0.00 49,242,414.1 9 (5,090,581.70 ) Redevelopment Funds 433REDEVELOPMENT ADMINISTRATION GENERAL8,752.670.000.0010.410.000.008,763.080.00 8,763.08 0.00 439CERTIFIED TECHNOLOGY PARK2,143,331.930.000.002,548.640.000.002,145,880.570.00 2,145,880.57 0.00 454AIRPORT URBAN ENTERPRISE ZONE381,831.960.000.00454.040.000.00382,286.000.00 382,286.00 0.00 Total Redevelopment Funds 2,533,916.5 6 0.000.003,013.0 9 0.000.002,536,929.6 5 0.00 2,536,929.6 5 0.00 Debt Service Funds 315AIRPORT 2003 DEBT RESERVE1,038,904.000.000.001,235.740.001,235.741,038,904.000.00 1,038,904.00 0.00 317COVELESKI BOND DEBT RESERVE510,776.830.000.00607.370.000.00511,384.200.00 511,384.20 0.00 328SBCDA 2003 DEBT RESERVE1,735,840.000.000.002,064.730.002,064.731,735,840.000.00 1,735,840.00 0.00 Total Debt Service Funds 3,285,520.8 3 0.000.003,907.8 4 0.003,300.4 7 3,286,128.2 0 0.00 3,286,128.2 0 0.00 Total Redevelopment Commission Funds 55,966,718.35379,667.601,352,816.7371,902.823,300.473,300.4755,065,472.040.0055,065,472.04 (5,090,581.70) City Operations Total 229,469,472.5 7 29,727,653.0128,277,624.8 6 264,296.6 9 2,505,363.8 3 2,505,363.8 3 231,183,797.4168,940.0 3 231,252,737.4 4 0.00 Memo Ite m Pooled Investment Account OpeningInterestAccruedChange inTransfer InTransfer outInvestmentTotal Cash &BalanceNet of FeesIncomeAsset Valuefrom Depositoryto DepositoryBalanceInvestments 1st Source Bank Investment Accoun t 175,204,084.41234,464.310.00(3,908.27)0.0073,918.8 7 175,360,721.5 8 175,360,721.5 8 Cash Reserve Report 17