Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
01-2016 Cash Reserve Summary
Period Ending: Issued by: City of South Bend Cash Reserves Summary Page Number(s) Contents 2 Funds by Status 4 Cash Reserves Summary 7 General Fund Trends 8 Parks & Recreation Fund Trends 9 Motor Vehicle Highway Fund Trends 10 Liability Insurance Fund Trends 11 Loss Recovery Fund Trends 12 Public Safety LOIT Fund Trends 13 County Option Income Tax Fund (COIT) Trends 14 Economic Development Income Tax Fund (EDIT) Trends 15 Self-funded Employee Benefits Fund Trends 16 Controller's Cash Report Distribution Mayor Pete Buttigieg Chief of Staff James Mueller Common Council City Controller John Murphy Deputy City Controller Jennifer Hockenhull City Finance Director Rahman Johnson Financial Officer Cecil Eastman Department Heads Fiscal Officers January 31, 2016 Controller Cash Reserve Report City of South BendCash Reserves Summary by Fund Statu s A ctua l Fund Fund Name CashOutstanding A vailable Cash Reserv e Percentag e Cash Reserve Polic y Balanc e Encumbrance s CashRequiremen t Varianc e of Budget Notes Threshold Measuremen t Insufficient Balances102RAINY DAY FUND 8,706,495.32 0.008,706,495.328,805,170.67 (98,675.35) 3% Actual Percentage = 2.97%, only slightly less3% Total expenditures in previous fiscal year-contingency 377PROFESSIONAL SPORTS DEVELOPMENT128,827.560.00128,827.56209,513.00 (80,685.44) 15% 25% Annual expenditures 436RIVER EAST RESIDENTIAL (NE RES TIF)595,625.690.00595,625.69857,500.00 (261,874.31) 17% 25% Annual expenditures 610SOLID WASTE OPERATIONS44,961.44325,941.20(280,979.76)559,741.20 (840,720.96) -5% Systemic budgetary shortfall 10% Annual expenditures 629WATER WORKS RESERVE - O & M2,235,266.680.002,235,266.682,462,727.45 (227,460.77) 15% Based on Fund 620's 2016 budge t 16.67% Annual operating expenses in Fund 620, net of transfers 643SEWAGE WORKS RESERVE - O & M3,678,649.420.003,678,649.424,575,374.23 (896,724.81) 13% Based on Fund 641's 2016 budge t 16.67% Annual operating expenses in Fund 641, net of transfers 701FIREFIGHTERS PENSION 46,066.770.0046,066.77558,272.00 (512,205.23) 1% Pension payments received in June & Sep 10% Annual expenditures 702POLICE PENSION 643,055.940.00643,055.94700,818.20 (57,762.26) 9% Pension payments received in June & Sep 10% Annual expenditures 16,078,948.82325,941.2015,753,007.6218,729,116.74(2,976,109.12) Meets or Exceeds Requirement s 101GENERAL FUND 27,526,645.68812,577.4826,714,068.2016,356,186.9010,357,881.3049% 30% Annual expenditures - higher due to property tax delays 201PARKS & RECREATION 3,325,822.60432,485.862,893,336.742,812,174.2581,162.4926% 25% Annual expenditures 202MOTOR VEHICLE HIGHWAY5,529,836.06584,601.264,945,234.802,744,352.252,200,882.5545% 25% Annual expenditures 203RECREATION - NONREVERTING845,897.3685,155.02760,742.34364,938.50395,803.8452% 25% Annual expenditures 211DCI ADMINISTRATION FUND1,455,596.8951,757.531,403,839.36671,828.25732,011.1152% 25% Annual expenditures 216POLICE STATE SEIZURES211,979.090.00211,979.099,000.00202,979.09589% 25% Annual expenditures 218POLICE CURFEW VIOLATIONS12,270.570.0012,270.57250.0012,020.571227% 25% Annual expenditures 219UNSAFE BUILDING360,371.75138,860.00221,511.750.00221,511.75100% 25% Annual expenditures 220LAW ENFORCEMENT CONTINUING EDUCATION904,089.219,600.00894,489.21185,877.00708,612.21120% 25% Annual expenditures 222CENTRAL SERVICES1,356,198.9896,204.881,259,994.101,001,074.50258,919.6031% 25% A nnual expenditures,excluding utility accounting 226LIABILITY INSURANCE 4,618,577.8490,656.054,527,921.791,560,174.002,967,747.79145% 50% Annual expenditures - higher reserves for future claims 249PUBLIC SAFETY L.O.I.T.687,550.930.00687,550.93528,050.08159,500.8510% 8% Annual expenditures - one month reserve 251LOCAL ROADS & STREETS2,955,766.02944,401.512,011,364.51560,736.001,450,628.5190% 25% Annual expenditures 258HUMAN RIGHTS - FEDERAL GRANT534,060.1820,134.00513,926.1855,459.50458,466.68232% 25% Annual expenditures 273MORRIS PAC/PALAIS ROYALE MARKETING30,751.80877.5029,874.304,719.5025,154.80158% 25% Annual expenditures 278TAKE HOME VEHICLE POLICE651,418.510.00651,418.512,500.00648,918.516514% 25% Annual expenditures 287EMS / FIRE DEPARTMENT CAPITAL2,576,498.32363,611.002,212,887.32561,902.751,650,984.5798% 25% Annual expenditures 288EMS / FIRE DEPARTMENT OPERATING2,124,535.98122,542.882,001,993.101,528,910.75473,082.3533% 25% Annual expenditures 289HAZMAT32,115.500.0032,115.502,500.0029,615.50321% 25% Annual expenditures 291INDIANA RIVER RESCUE99,798.500.0099,798.5023,825.0075,973.50105% 25% Annual expenditures 294REGIONAL POLICE ACADEMY78,533.610.0078,533.615,625.0072,908.61349% 25% Annual expenditures 299POLICE FEDERAL DRUG ENFORCEMENT252,845.436,964.53245,880.9042,241.25203,639.65146% 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 RESERVE508,659.840.00508,659.84508,659.840.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,726,527.8810,603,697.1018,122,830.787,875,519.2510,247,311.5358% 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 404COUNTY OPTION INCOME TAX 10,887,917.032,312,114.508,575,802.537,581,074.00994,728.5357% 50% Annual expenditures - higher due to bonding and rating agencies 405PARK NONREVERTING CAPITAL470,648.3814,634.17456,014.2150,083.25405,930.96228% 25% Annual expenditures 406CUMULATIVE CAPITAL DEVELOPMENT 464,644.760.00464,644.76131,684.25332,960.5188% 25% Annual expenditures 407CUMULATIVE CAPITAL IMPROVEMENT277,608.860.00277,608.8691,476.75186,132.1176% 25% Annual expenditures 408ECONOMIC DEVELOPMENT INCOME TAX 8,647,070.42708,870.787,938,199.645,280,090.502,658,109.1475% 50% Annual expenditures - higher due to bonding and rating agencies 416MORRIS PERFORMING ARTS CENTER CAPITAL522,656.4618,010.32504,646.1419,730.75484,915.39639% 25% Annual expenditures 422TIF DISTRICT - WEST WASHINGTON 1,509,301.59303,366.001,205,935.59350,841.50855,094.0986% 25% Annual expenditures 425TIF LEIGHTON PLAZA215,755.270.00215,755.2740,101.50175,653.77135% 25% Annual expenditures429RIVER EAST DEV TIF (NORTHEAST TIF)7,491,726.701,969,301.855,522,424.852,083,789.753,438,635.1066%25%Annual expenditures430TIF SOUTHSIDE DEVELOPMENT AREA #1 6,105,040.361,311,534.194,793,506.171,852,953.752,940,552.4265% 25% Annual expenditures 432TIF SSDA #3 - ERSKINE VILLAGE4,945,336.450.004,945,336.45122,625.754,822,710.701008% 25% Annual expenditures 433REDEVELOPMENT ADMINISTRATION GENERAL8,716.410.008,716.411,125.007,591.41194% 25% Annual expenditures 435TIF - DOUGLAS ROAD151,898.934,200.00147,698.9335,420.00112,278.9342% 10% Annual expenditures 450PALAIS ROYALE HISTORIC PRESERVATION76,539.940.0076,539.940.0076,539.94100% 25% Annual expenditures 600CONSOLIDATED BUILDING DEPARTMENT2,261,160.09286,774.251,974,385.841,112,743.50861,642.3444% 25% Annual expenditures 601PARKING GARAGES617,026.65210,428.41406,598.24348,367.2558,230.9929% 25% Annual expenditures 620WATER WORKS OPERATIONS3,906,205.56680,509.933,225,695.630.003,225,695.6319% 5% Annual expenditures 624WATER WORKS CUSTOMER DEPOSIT1,514,746.390.001,514,746.391,514,746.390.00100% 100% 100% cash reserves for customer deposits 626WATER WORKS BOND RESERVE1,642,223.190.001,642,223.191,642,223.190.00100% 100% 100% cash reserves per bond covenants and Crowe Horwath 640SEWER REPAIR INSURANCE1,670,172.4728,751.471,641,421.00137,353.251,504,067.75299% 25% Annual expenditures 641SEWAGE WORKS OPERATIONS9,227,486.432,250,114.826,977,371.611,986,807.204,990,564.4118% 5% Annual expenditures 653SEWAGE WORKS DEBT SERVICE RESERVE4,105,648.790.004,105,648.794,105,648.790.00100% 100% 100% cash reserves per bond covenants and Crowe Horwath 655PROJECT RELEAF943,885.810.00943,885.81132,089.50811,796.31179% 25% Annual expenditures 670CENTURY CENTER1,604,875.190.001,604,875.19993,109.50611,765.6940% 25% Annual expenditures 671CENTURY CENTER CAPITAL1,002,156.870.001,002,156.87800,000.00202,156.87100% 800,000 $ Minimum per Board of Managers 703POLICE/FIRE 1977 STATE PENSION0.000.000.000.000.00100% 100% 100% cash reserves - trust & agency funds 705POLICE K-9 UNIT3,875.280.003,875.28505.003,370.28192% 25% Annual expenditures 709PAYROLL FUND (37.00)0.00(37.00)(37.00)0.00100% 100% 100% cash reserves - trust & agency funds 711SELF-FUNDED EMPLOYEE BENEFITS5,123,550.64302,717.004,820,833.644,344,722.50476,111.1428% 25% Annual expenditures 712PUBLIC EMPLOYEES RETIREMENT FUND0.000.000.000.000.00100% 100% 100% cash reserves - trust & agency funds 713UNEMPLOYMENT COMP FUND268,240.526,600.00261,640.5228,470.50233,170.02230% 25% Annual expenditures January 31, 201 6 Cash Reserve Report2 City of South BendCash Reserves Summary by Fund Statu s A ctua l Fund Fund Name CashOutstanding A vailable Cash Reserv e Percentag e Cash Reserve Polic y Balanc e Encumbrance s CashRequiremen t Varianc e of Budget Notes Threshold Measuremen t January 31, 201 6 718STATE TAX DEDUCTION FUND 257,922.60 0.00257,922.60257,922.60 0.00100% 100% 100% cash reserves - trust & agency funds 725MORRIS / PALAIS BOX OFFICE1,525,499.200.001,525,499.201,525,499.200.00100% 100% 100% cash reserves - trust & agency funds 726POLICE DISTRIBUTIONS PAYABLE839,554.900.00839,554.90839,554.900.00100% 100% 100% cash reserves - trust & agency funds 730CITY CEMETERY TRUST28,588.960.0028,588.965,000.0023,588.96143% 25% Annual expenditures 166,498,736.6324,772,054.29141,726,682.3477,596,971.5964,129,710.75 No Reserve Requirement s 103EXCESS LEVY 3,671.45 0.003,671.45 0.00 3,671.45 0% No reserve requirement 209STUDEBAKER/OLIVER REVERTING GRANTS1,109,031.58478,750.83630,280.750.00630,280.75 0% No reserve requirement 210DEPT COMMUNITY INVESTMENT STATE GRANTS (680,075.53)1,007,353.00(1,687,428.53)0.00 (1,687,428.53) 0% No reserve requirement 212DCI GRANT FUND612,675.053,343,858.78(2,731,183.73)0.00 (2,731,183.73) 0% Grant fund - reimbursement grants - no reserves 217GIFT, DONATION, BEQUEST64,980.700.0064,980.700.0064,980.70 0% No reserve requirement 224CENTRAL SERVICES CAPITAL187,232.89175,065.3312,167.560.0012,167.56 0% No reserve required 227LOSS RECOVERY FUND 994,889.15130,302.92864,586.230.00864,586.23 0% No reserve requirement 244EMERGENCY PHONE SYSTEM33,670.740.0033,670.740.0033,670.74 0% No reserve requirement 252EXCESS WELFARE DISTRIBUTION8.070.008.070.008.07 0% No reserve requirement 271EASTRACE WATERWAY1,337.250.001,337.250.001,337.25 0% No reserve requirement 279311 CALL CENTER1,317.640.001,317.640.001,317.64 0% No reserve requirement 280POLICE BLOCK GRANTS3,856.540.003,856.540.003,856.54 0% No reserve requirement 281REDEVELOPMENT COMMISSION - REV BONDS27,407.200.0027,407.200.0027,407.20 0% No reserve requirement 292POLICE GRANTS114,483.3048,660.0065,823.300.0065,823.30 0% No reserve requirement 295COPS MORE GRANT121,941.3910,245.00111,696.390.00111,696.39 0% No reserve requirement 313HALL OF FAME DEBT SERVICE (615,260.67)0.00(615,260.67)0.00 (615,260.67) 0% No reserve requirement 401COVELESKI STADIUM CAPITAL82,690.570.0082,690.570.0082,690.57 0% No reserve requirement 403ZOO ENDOWMENT49,527.460.0049,527.460.0049,527.46 0% No reserve requirement 410URBAN DEVELOPMENT ACTION GRANT (UDAG)485,472.120.00485,472.120.00485,472.12 0% No reserve requirement 412MAJOR MOVES CONSTRUCTION2,160,452.46879,030.711,281,421.750.001,281,421.75 0% No reserve requirement 434CRED FUND2,448.660.002,448.660.002,448.66 0% No reserve requirement 439CERTIFIED TECHNOLOGY PARK2,277,098.56142,912.702,134,185.860.002,134,185.86 0% No reserve required 454AIRPORT URBAN ENTERPRISE ZONE380,249.430.00380,249.430.00380,249.43 0% No reserve required 611SOLID WASTE CAPITAL575.430.00575.430.00575.43 0% No reserve requirement 622WATER WORKS CAPITAL2,885,176.08177,796.652,707,379.430.002,707,379.43 0% No reserve requirement 625WATER WORKS SINKING FUND174,915.860.00174,915.860.00174,915.86 0% No Reserves - transfer from operating account for debt service as needed 642SEWAGE WORKS CAPITAL8,115,927.873,915,652.674,200,275.200.004,200,275.20 0% No Reserves - transfer from operating account as needed 6452006 SEWER BOND0.000.000.000.000.00 0% Bond fund - spend down to zero - no reserves 6472007 SEWER BOND0.000.000.000.000.00 0% Bond fund - spend down to zero - no reserves 649SEWAGE WORKS BOND SINKING1,565,889.370.001,565,889.370.001,565,889.37 0% No Reserves - transfer from operating account for debt service as needed 6512007B SEWER BOND0.000.000.000.000.00 0% Bond fund - spend down to zero - no reserves required 6582010 SEWER BOND0.000.000.000.000.00 0% Bond fund - spend down to zero - no reserves required 6592011 SEWER BOND232,278.40172,087.8560,190.550.0060,190.55 0% Bond fund - spend down to zero - no reserves required 6612012 SEWER BOND13,814,785.3010,068,727.513,746,057.790.003,746,057.79 0% Bond fund - spend down to zero - no reserves required 6642013A SEWER REFUNDING BOND4,513.770.004,513.770.004,513.77 0% Bond fund - spend down to zero - no reserves required 6662015 SEWER BOND6,665.830.006,665.830.006,665.83 0% Bond fund - spend down to zero - no reserves required 672CENTURY CENTER ENERGY SAVINGS50,036.160.0050,036.160.0050,036.16 0% No reserve required 677HALL OF FAME CAPITAL FUND499,051.90287.88498,764.020.00498,764.02 0% No reserve requirement 34,768,921.9820,550,731.8314,218,190.150.0014,218,190.15City Operations Total217,346,607.4345,648,727.32171,697,880.1196,326,088.3375,371,791.78Cash Reserve Report3 City of South BendCash Reserves Summary by Fund Actual FundFund Nam e CashOutstanding AvailableCash Reserve Percentage Cash Reserve Policy BalanceEncumbrancesCashRequirement V arianceof Budget Notes Threshold Measurement City Controlled Fund sGeneral Fund 101GENERAL FUND 27,526,645.68812,577.4826,714,068.2016,356,186.9010,357,881.3049% 30% A nnual expenditures - higher due to property tax delays Special Revenue Funds 102RAINY DAY FUND8,706,495. 320.008,706,495.328,805,170.67 (98,675.35) 3% Actual Percentage = 2.97%, only slightly less3% Total expenditures in previous fiscal year-contingency 103EXCESS LEVY3,671.450.003,671.450.003,671.45100% 0% No reserve requirement 201PARKS & RECREATION 3,325,822.60432, 485.862,893,336.742, 812,174.2581,162.4926% 25% Annual expenditures 202MOTOR VEHICLE HIGHWAY5,529,836.06 584,601.264,945,234.802,744,352.252,200,882.5545% 25% Annual expenditures 203RECREATION - NONREVERTING 845,897.3685,155.02760,742.34364,938.50395,803.8452% 25% Annual expenditures 209STUDEBAKER/OLIVER REVERTING GRANTS1,109,031.58478,750.83630,280.75 0.00630,280.75100% 0% No reserve requirement 210DEPT COMMUNITY INVESTMENT STATE GRANTS (680,075.53)1,007,353.00(1,687,428.53) 0.00 (1,687,428.53) 100% 0% No reserve requirement 211DCI ADMINISTRATION FUND1,455,596. 8951,757.531,403,839.36 671,828.25732,011.1152% 25% Annual expenditures 212DCI GRANT FUND612,675.05 3,343,858.78(2,731,183.73)0.00 (2,731,183.73) 100% 0% Grant fund - reimbursement grants - no reserves 216POLICE STATE SEIZURES211,979. 090.00211,979.099,000.00202,979.09589% 25% Annual expenditures 217GIFT, DONATION, BEQUEST64,980.700.0064,980.700.0064,980.70100% 0% No reserve requirement 218POLICE CURFEW VIOLATIONS12,270.570.0012,270.57 250.0012,020.571227% 25% Annual expenditures 219UNSAFE BUILDING360,371.75138, 860.00221,511.750.00221,511.75100% 25% Annual expenditures 220LAW ENFORCEMENT CONTINUING EDUCA TION904,089.219,600.00894, 489.21185,877.00708,612.21120% 25% Annual expenditures 227LOSS RECOVERY FUND 994, 889.15130,302.92864,586.23 0.00864,586.23100% 0% No reserve requirement 244EMERGENCY PHONE SYSTEM33, 670.74 0.0033,670.74 0.00 33,670.74100% 0% No reserve requirement 249PUBLIC SAFETY L.O.I.T.687,550. 930.00687,550.93528, 050.08159,500.8510% 8% Annual expenditures - one month reserve 251LOCAL ROADS & STREETS2,955,766.02 944,401.512,011,364.51560,736.001,450,628.5190% 25% Annual expenditures 252EXCESS WELFARE DISTRIBUTION8.070.008.070.008.07 100% 0% No reserve requirement 258HUMAN RIGHTS - FEDERAL GRANT 534,060.1820,134.00513,926.1855,459.50458,466.68232% 25% Annual expenditures 271EASTRACE WATERWAY1,337.250.001,337.250.001,337.25100% 0% No reserve requirement 273MORRIS PAC/PALAIS ROYALE MARKETIN G30,751.80877.5029,874.304,719.50 25,154.80158% 25% Annual expenditures 279311 CALL CENTER1,317.640. 001,317.640.001,317.64100% 0% No reserve requirement 280POLICE BLOCK GRANTS3,856. 540.003,856.540.003,856.54100% 0% No reserve requirement 281REDEVELOPMENT COMMISSION - REV BONDS27,407.200.0027,407.200.0027,407.20100% 0% No reserve requirement 289HAZMAT32,115.500.0032, 115.502,500.0029,615.50321% 25% Annual expenditures 291INDIANA RIVER RESCUE99,798. 500.0099,798.5023,825.0075,973.50105% 25% Annual expenditures 292POLICE GRANTS114,483.3048, 660.0065,823.300.0065,823.30100% 0% No reserve requirement 294REGIONAL POLICE ACADEMY78, 533.61 0.0078,533.615,625.00 72,908.61349% 25% Annual expenditures 295COPS MORE GRANT121,941.39 10,245.00111,696.390.00111,696.39100% 0% No reserve requirement 299POLICE FEDERAL DRUG ENFORCEMENT 252,845.436,964.53245,880. 9042,241.25203,639.65146% 25% Annual expenditures 404COUNTY OPTION INCOME TAX 10,887,917. 032,312,114.508,575,802.537,581,074.00994,728.5357% 50% Annual expenditures - higher due to bonding and rating agencies 408ECONOMIC DEVELOPMENT INCOME TAX 8,647,070.42708,870.787,938,199.645,280,090.502,658,109.1475% 50% Annual expenditures - higher due to bonding and rating agencies 410URBAN DEVELOPMENT ACTION GRANT (UDAG) 485,472.120.00485,472.12 0.00485,472.12100% 0% No reserve requirement 655PROJECT RELEAF943,885.810. 00943,885.81132,089.50811,796.31179% 25% Annual expenditures 705POLICE K-9 UNIT3,875.28 0.003,875.28505.003,370.28192% 25% Annual expenditures Total Special Revenue Funds 49,401,196.0110,314,993.0239,086,202.9929,810,506.259,275,696.74 Debt Service Fund 313HALL OF FAME DEBT SERVICE (615,260.67)0.00(615,260.67)0.00 (615,260.67) 100% 0% No reserve requirement Capital Project Funds 377PROFESSIONAL SPORTS DEVELOPMENT 128,827.560.00128,827.56209,513.00 (80,685.44) 15% 25% Annual expenditures 401COVELESKI STADIUM CAPITAL82,690.570.0082,690.570.0082,690.57100% 0% No reserve requirement 403ZOO ENDOWMENT49,527.46 0.0049,527.460.0049,527.46100% 0% No reserve requirement 405PARK NONREVERTING CAPITAL 470,648.3814,634.17456,014.2150,083.25405,930.96228% 25% Annual expenditures 406CUMULATIVE CAPITAL DEVELOPMENT 464,644.760.00464,644.76 131,684.25332,960.5188% 25% Annual expenditures 407CUMULATIVE CAPITAL IMPROVEMENT 277,608.860.00277,608.86 91,476.75186,132.1176% 25% Annual expenditures 412MAJOR MOVES CONSTRUCTION2,160,452.46879,030.711,281,421. 750.001,281,421.75100% 0% No reserve requirement 416MORRIS PERFORMING ARTS CENTER CAPITAL522,656.4618,010.32504, 646.1419,730.75484,915.39639% 25% Annual expenditures 434CRED FUND2,448.660.00 2,448.660.002,448.66100% 0% No reserve requirement 450PALAIS ROYALE HISTORIC PRESERVATION76,539.940.0076,539.940.0076,539.94100% 25% Annual expenditures 677HALL OF FAME CAPITAL FUND 499,051.90287.88498,764.02 0.00498,764.02100% 0% No reserve requirement Total Capital & Debt Service Funds 4,119,836.34911,963.083,207,873.26502,488.002,705,385.26 Enterprise Funds 287EMS / FIRE DEPARTMENT CAPITAL 2,576,498.32363,611.002,212,887. 32561,902.751,650,984.5798% 25% Annual expenditures 288EMS / FIRE DEPARTMENT OPERATING2,124,535.98122,542.882,001,993. 101,528,910.75473,082.3533% 25% Annual expenditures 600CONSOLIDATED BUILDING DEPARTMENT2,261,160.09286,774.251,974,385. 841,112,743.50861,642.3444% 25% Annual expenditures 601PARKING GARAGES617,026.65210, 428.41406,598.24348,367.25 58,230.9929% 25% Annual expenditures 610SOLID WASTE OPERATIONS44, 961.44325,941.20( 280,979.76)559,741.20 (840,720.96) -5% Systemic budgetary shortfall10% Annual expenditures 611SOLID WASTE CAPITAL575.430.00575.430.00575.43100% 0% No reserve requirement 620WATER WORKS OPERATIONS3,906,205. 56680,509.933,225,695.63 0.003,225,695.6319% 5% Annual expenditures 622WATER WORKS CAPITAL2,885,176.08 177,796.652,707,379.43 0.002,707,379.43100% 0% No reserve requirement January 31, 201 6 Cash Reserve Report4 City of South BendCash Reserves Summary by Fund Actual FundFund Nam e CashOutstanding AvailableCash Reserve Percentage Cash Reserve Policy BalanceEncumbrancesCashRequirement V arianceof Budget Notes Threshold Measurement January 31, 201 6 624WATER WORKS CUSTOMER DEPOSIT 1, 514,746.39 0.001,514,746. 391,514,746.39 0.00100% 100% 100% cash reserves for customer deposits 625WATER WORKS SINKING FUND 174,915.860.00174,915.86 0.00174,915.86100% 0% No Reserves - transfer from operating account for debt service as needed 626WATER WORKS BOND RESERVE1,642,223.190.001,642,223. 191,642,223.190.00100% 100% 100% cash reserves per bond covenants and Crowe Horwath 629WATER WORKS RESERVE - O & M2,235,266.680.002,235,266.682,831,342.32 (596,075.64) 13% Based on Fund 620's 2016 budget16.67% A nnual operating expenses in Fund 620 , net of transfers 640SEWER REPAIR INSURANCE1,670,172.4728,751.471,641,421. 00137,353.251,504,067.75299% 25% Annual expenditures 641SEWAGE WORKS OPERATIONS9,227,486.432, 250,114.826,977,371.611,986,807.204,990,564.4118% 5% Annual expenditures 642SEWAGE WORKS CAPITAL8,115,927.87 3,915,652.674,200,275.20 0.004,200,275.20100% 0% No Reserves - transfer from operating account as needed 643SEWAGE WORKS RESERVE - O & M3,678,649.420.003,678,649.426,624,015.20 (2,945,365.78) 9% Based on Fund 641's 2016 budget16.67% A nnual 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 SINKING1,565, 889.370.001,565,889.37 0.001,565,889.37100% 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,105,648.790.004,105,648. 794,105,648.790.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 BOND232,278.40172, 087.8560,190.550.0060,190.55100% 0% Bond fund - spend down to zero - no reserves required 6612012 SEWER BOND13,814,785.3010,068, 727.513,746,057.790. 003,746,057.79100% 0% Bond fund - spend down to zero - no reserves required 6642013A SEWER RE FUNDING BOND4,513.770.004,513.770.004,513.77100% 0% Bond fund - spend down to zero - no reserves required 6662015 SEWER BOND6,665.830. 006,665.830.006,665.83100% 0% Bond fund - spend down to zero - no reserves required 670CENTURY CENTER1,604,875.190. 001,604,875.19993,109.50611,765.6940% 25% Annual expenditures 671CENTURY CENTER CAPITAL1,002, 156.870.001,002,156.87 800,000.00202,156.87100% 800,000 $ Minimum per Board of Managers 672CENTURY CENTER ENERGY SAVINGS50,036.160.0050,036.160.0050,036.16100% 0% No reserve required Total Enterprise Funds 65,062,377.5418,602,938.6446,459,438.9024,746,911.3021,712,527.60 Internal Service Funds 222CENTRAL SERVICES1,356,198.9896, 204.881,259,994.101, 001,074.50258,919.6031% 25% A nnual expenditures, excluding utility accounting 224CENTRAL SERVICES CAPITAL 187, 232.89175,065.3312,167.56 0.00 12,167.56100% 0% No reserve required 226LIABILITY INSURANCE4,618,577.8490, 656.054,527,921.791,560, 174.002,967,747.79145% 50% Annual expenditures - higher reserves for future claims 278TAKE HOME VEHICLE POLICE 651,418.510.00651,418.51 2,500.00648,918.516514% 25% Annual expenditures 711SELF-FUNDED EMPLOYEE BEN EFITS5,123,550.64302,717.004,820,833.644,344,722.50476,111.1428% Actual Percentage = 27.74% 25% Annual expenditures 713UNEMPLOYMENT COMP FUND268,240. 526,600.00261,640.52 28,470.50233,170.02230% 25% Annual expenditures Total Internal Service Funds 12,205,219.38671,243.2611,533,976.126,936,941.504,597,034.62 Trust & Agency Funds 701FIREFIGHTERS PENSION 46,066.77 0.0046,066.77558,272.00 (512,205.23) 1% Pension payments received in June & Sep 10% Annual expenditures 702POLICE PENSION 643,055.940.00643,055.94700,818.20 (57,762.26) 9% Pension payments received in June & Sep 10% Annual expenditures 703POLICE/FIRE 1977 STATE PENSION0.000.000.000.000.00100% 100% 100% cash reserves - trust & agency funds 709PAYROLL FUND (37.00)0.00(37.00)(37.00)0.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 FUND257,922.600.00257,922.60257,922.600.00100% 100% 100% cash reserves - trust & agency funds 725MORRIS / PALAIS BOX OFFICE1,525, 499.200.001,525,499.201,525,499.20 0.00100% 100% 100% cash reserves - trust & agency funds 726POLICE DISTRIBUTIONS PAYABLE 839,554.900.00839,554.90839,554.90 0.00100% 100% 100% cash reserves - trust & agency funds 730CITY CEMETERY TRUST28,588. 960.0028,588.965,000.0023,588.96143% 25% Annual expenditures Total Trust & Agency Funds 3,340,651.37 0.003,340,651.373,887,029.90 (546,378.53) Total City Funds 161,655,926.3231,313,715.48130,342,210.8482,240,063.8548,102,146.99 Redevelopment Commission Controlled Funds Tax Increment Financing Funds 324RIVER WEST TIF (AIRPORT TIF)28,726,527. 8810,603,697.1018,122,830.787,875,519.2510,247,311.5358% 25% Annual expenditures 422TIF DISTRICT - WEST WASHINGTON 1,509,301.59303,366.001,205, 935.59350,841.50855,094.0986% 25% Annual expenditures 425TIF LEIGHTON PLAZA215,755. 270.00215,755.2740,101.50175,653.77135% 25% Annual expenditures 429RIVER EAST DEV TIF (NORTHEAST TIF)7,491,726.701,969,301.855,522,424.852,083,789.753, 438,635.1066%25%Annual expenditures 430TIF SOUTHSIDE DEVELOPMENT AREA #1 6,105,040.361,311,534.194,793,506.171,852,953.752,940,552.4265% 25% Annual expenditures 432TIF SSDA #3 - ERSKINE VILLAGE4,945, 336.450.004,945,336.45 122,625.754,822,710.701008% 25% Annual expenditures 435TIF - DOUGLAS ROAD151,898.93 4,200.00147,698.9335, 420.00112,278.9342% 10% Annual expenditures 436RIVER EAST RESIDENTIAL (NE RES TIF) 595,625.690.00595,625.69857,500.00 (261,874.31) 17% 25% Annual expenditures Total Tax Increment Financing Funds 49,741,212.8714,192,099.1435,549,113.7313,218,751.5022,330,362.23 Redevelopment Funds 433REDEVELOPMENT ADMINISTRATION GENERAL8,716.410.008,716.411,125.00 7,591.41194% 25% Annual expenditures 439CERTIFIED TECHNOLOGY PARK2,277,098.56142,912.702,134,185.86 0.002,134,185.86100% 0% No reserve required 454AIRPORT URBAN ENTERPRISE ZO NE 380,249.43 0.00380,249.43 0.00380,249.43100% 0% No reserve required Total Redevelopment Funds 2,666,064.40142,912.702,523,151.701,125.002,522,026.70 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 Cash Reserve Report5 City of South BendCash Reserves Summary by Fund Actual FundFund Nam e CashOutstanding AvailableCash Reserve Percentage Cash Reserve Policy BalanceEncumbrancesCashRequirement V arianceof Budget Notes Threshold Measurement January 31, 201 6 317COVELESKI BOND DEBT RESERVE 508,659.840.00508,659.84508,659.84 0.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,283,403.84 0.003,283,403.843,283,403.84 0.00 Total Redevelopment Commission Funds 55,690,681.1114,335,011.8441,355,669.2716,503,280.3424,852,388.93 City Operations Tota l 217,346,607.4345,648,727.32171,697,880.1198,743,344.1972,954,535.92 Cash Reserve Report6 General Fund - 101 DateAvailable Cash Reserve RequirementDate Actual Percent Percent Requirement 31-Aug-1322,315,551.29$ 16,233,266.50$ 31-Aug-1334%25% 30-Sep-1318,544,399.98$ 16,233,266.50$ 30-Sep-1329%25% 31-Oct-1316,816,726.59$ 16,272,893.00$ 31-Oct-1326%25% 30-Nov-1313,615,491.79$ 16,272,893.00$ 30-Nov-1321%25% 31-Dec-1327,464,709.03$ 16,272,893.00$ 31-Dec-1342%25% 31-Jan-1422,475,568.55$ 13,854,192.00$ 31-Jan-1441%25% 28-Feb-1419,666,397.13$ 14,060,717.50$ 28-Feb-1435%25% 31-Mar-1416,931,467.58$ 14,071,197.25$ 31-Mar-1430%25% 30-Apr-1413,664,592.50$ 14,071,197.25$ 30-Apr-1424%25% 31-May-1410,906,411.36$ 14,071,197.25$ 31-May-1419%25% 30-Jun-1429,432,779.84$ 14,071,197.25$ 30-Jun-1452%25% 31-Jul-1426,473,744.03$ 14,088,697.25$ 31-Jul-1447%25% 31-Aug-1423,722,786.84$ 14,088,697.25$ 31-Aug-1442%25% 30-Sep-1420,202,390.82$ 14,088,697.25$ 30-Sep-1436%25% 31-Oct-1417,007,547.31$ 14,088,697.25$ 31-Oct-1430%25% 30-Nov-1413,644,872.96$ 14,088,697.25$ 30-Nov-1424%25% 31-Dec-1427,947,677.74$ 14,238,697.25$ 31-Dec-1449%25% 31-Jan-1523,253,550.72$ 13,344,782.75$ 31-Jan-1544%25% 28-Feb-1520,413,331.83$ 13,344,782.75$ 28-Feb-1538%25% 31-Mar-1517,372,699.76$ 13,344,782.75$ 31-Mar-1533%25% 30-Apr-1513,029,346.27$ 13,344,782.75$ 30-Apr-1524%25% 31-May-1510,341,225.60$ 13,344,782.75$ 31-May-1519%25% 30-Jun-1529,661,774.55$ 13,344,782.75$ 30-Jun-1556%25% 31-Jul-1525,659,540.97$ 13,344,782.75$ 31-Jul-1548%25% 31-Aug-1523,117,854.30$ 13,344,782.75$ 31-Aug-1543%25% 30-Sep-1520,515,512.68$ 13,344,782.75$ 30-Sep-1538%25% 31-Oct-1519,719,996.44$ 13,344,782.75$ 31-Oct-1537%25% 30-Nov-1518,556,106.39$ 13,344,782.75$ 30-Nov-1535%25% 31-Dec-1530,019,921.23$ 13,344,794.00$ 31-Dec-1556%25% 31-Jan-1626,714,068.20$ 16,356,186.90$ 31-Jan-1649%30% $- $5 $10 $15 $20 $25 $30 $35 31-Aug-13 30-Sep-13 31-Oct-13 30-Nov-13 31-Dec-13 31-Jan-14 28-Feb-14 31-Mar-14 30-Apr-14 31-May-14 30-Jun-14 31-Jul-14 31-Aug-14 30-Sep-14 31-Oct-14 30-Nov-14 31-Dec-14 31-Jan-15 28-Feb-15 31-Mar-15 30-Apr-15 31-May-15 30-Jun-15 31-Jul-15 31-Aug-15 30-Sep-15 31-Oct-15 30-Nov-15 31-Dec-15 31-Jan-16 Millions Available Cash Reserve Requirement 0%10%20%30%40%50%60% 31-Aug-13 30-Sep-13 31-Oct-13 30-Nov-13 31-Dec-13 31-Jan-14 28-Feb-14 31-Mar-14 30-Apr-14 31-May-14 30-Jun-14 31-Jul-14 31-Aug-14 30-Sep-14 31-Oct-14 30-Nov-14 31-Dec-14 31-Jan-15 28-Feb-15 31-Mar-15 30-Apr-15 31-May-15 30-Jun-15 31-Jul-15 31-Aug-15 30-Sep-15 31-Oct-15 30-Nov-15 31-Dec-15 31-Jan-16 Actual Percent Percent Requirement Cash Reserve Report7 Parks & Recreation - 201 DateAvailable Cash Reserve RequirementDate Actual Percent Percent Requirement 31-Aug-133,304,340.26$ 3,223,115.75$ 31-Aug-1326%25% 30-Sep-132,735,245.44$ 3,223,115.75$ 30-Sep-1321%25% 31-Oct-132,126,910.16$ 3,231,865.75$ 31-Oct-1316%25% 30-Nov-131,330,822.60$ 3,231,865.75$ 30-Nov-1310%25% 31-Dec-134,038,810.72$ 3,231,865.75$ 31-Dec-1331%25% 31-Jan-142,247,629.45$ 3,096,131.75$ 31-Jan-1418%25% 28-Feb-141,648,649.90$ 3,150,219.50$ 28-Feb-1413%25% 31-Mar-141,032,377.06$ 3,150,219.50$ 31-Mar-148%25% 30-Apr-14590,542.73$ 3,150,219.50$ 30-Apr-145%25% 31-May-1483,244.80$ 3,150,219.50$ 31-May-141%25% 30-Jun-143,535,769.93$ 3,150,219.50$ 30-Jun-1428%25% 31-Jul-143,047,667.29$ 3,150,219.50$ 31-Jul-1424%25% 31-Aug-142,094,579.12$ 3,150,219.50$ 31-Aug-1417%25% 30-Sep-141,554,697.71$ 3,150,219.50$ 30-Sep-1412%25% 31-Oct-141,005,198.50$ 3,150,219.50$ 31-Oct-148%25% 30-Nov-14282,628.37$ 3,150,219.50$ 30-Nov-142%25% 31-Dec-143,405,573.74$ 3,150,219.50$ 31-Dec-1427%25% 31-Jan-151,840,741.75$ 2,765,998.75$ 31-Jan-1517%25% 28-Feb-151,273,084.28$ 2,765,998.75$ 28-Feb-1512%25% 31-Mar-15623,258.50$ 2,765,998.75$ 31-Mar-156%25% 30-Apr-15181,071.57$ 2,765,998.75$ 30-Apr-152%25% 31-May-15(211,123.70)$ 2,765,998.75$ 31-May-15-2%25% 30-Jun-153,436,165.29$ 2,765,998.75$ 30-Jun-1531%25% 31-Jul-152,719,475.08$ 2,765,998.75$ 31-Jul-1525%25% 31-Aug-152,327,362.23$ 2,765,998.75$ 31-Aug-1521%25% 30-Sep-151,843,771.49$ 2,765,998.75$ 30-Sep-1517%25% 31-Oct-151,728,926.62$ 2,765,998.75$ 31-Oct-1516%25% 30-Nov-151,255,488.41$ 2,765,998.75$ 30-Nov-1511%25% 31-Dec-153,854,236.64$ 2,765,998.75$ 31-Dec-1535%25% 31-Jan-162,893,336.74$ 2,812,174.25$ 31-Jan-1626%25% $(1) $- $1 $1 $2 $2 $3 $3 $4 $4 $5 31-Aug-13 30-Sep-13 31-Oct-13 30-Nov-13 31-Dec-13 31-Jan-14 28-Feb-14 31-Mar-14 30-Apr-14 31-May-14 30-Jun-14 31-Jul-14 31-Aug-14 30-Sep-14 31-Oct-14 30-Nov-14 31-Dec-14 31-Jan-15 28-Feb-15 31-Mar-15 30-Apr-15 31-May-15 30-Jun-15 31-Jul-15 31-Aug-15 30-Sep-15 31-Oct-15 30-Nov-15 31-Dec-15 31-Jan-16 Millions Available Cash Reserve Requirement -5%0%5% 10%15%20%25%30%35%40% 31-Aug-13 30-Sep-13 31-Oct-13 30-Nov-13 31-Dec-13 31-Jan-14 28-Feb-14 31-Mar-14 30-Apr-14 31-May-14 30-Jun-14 31-Jul-14 31-Aug-14 30-Sep-14 31-Oct-14 30-Nov-14 31-Dec-14 31-Jan-15 28-Feb-15 31-Mar-15 30-Apr-15 31-May-15 30-Jun-15 31-Jul-15 31-Aug-15 30-Sep-15 31-Oct-15 30-Nov-15 31-Dec-15 31-Jan-16 Actual Percent Percent Requirement Cash Reserve Report8 Motor Vehicle Highway - 202 DateAvailable Cash Reserve RequirementDate Actual Percent Percent Requirement 31-Aug-133,587,289.24$ 1,813,299.20$ 31-Aug-1340%20% 30-Sep-133,867,160.45$ 1,813,299.20$ 30-Sep-1343%20% 31-Oct-133,728,689.78$ 1,835,299.20$ 31-Oct-1341%20% 30-Nov-133,693,079.20$ 1,835,299.20$ 30-Nov-1340%20% 31-Dec-133,077,037.70$ 1,835,299.20$ 31-Dec-1334%20% 31-Jan-142,350,831.49$ 1,821,153.60$ 31-Jan-1426%20% 28-Feb-142,055,931.61$ 1,941,729.60$ 28-Feb-1421%20% 31-Mar-141,890,447.88$ 1,941,729.60$ 31-Mar-1419%20% 30-Apr-143,351,701.43$ 1,941,729.60$ 30-Apr-1435%20% 31-May-143,470,456.90$ 1,941,729.60$ 31-May-1436%20% 30-Jun-143,366,866.26$ 1,941,729.60$ 30-Jun-1435%20% 31-Jul-142,837,076.85$ 2,001,775.40$ 31-Jul-1428%20% 31-Aug-142,217,578.14$ 2,001,775.40$ 31-Aug-1422%20% 30-Sep-142,402,072.20$ 2,001,775.40$ 30-Sep-1424%20% 31-Oct-143,204,864.97$ 2,001,775.40$ 31-Oct-1432%20% 30-Nov-142,968,298.70$ 2,001,775.40$ 30-Nov-1430%20% 31-Dec-143,093,394.24$ 2,001,775.40$ 31-Dec-1431%20% 31-Jan-153,012,565.62$ 2,097,077.20$ 31-Jan-1529%20% 28-Feb-153,448,810.96$ 2,097,077.20$ 28-Feb-1533%20% 31-Mar-153,183,955.62$ 2,097,077.20$ 31-Mar-1530%20% 30-Apr-153,452,526.78$ 2,097,077.20$ 30-Apr-1533%20% 31-May-154,710,213.84$ 2,097,077.20$ 31-May-1545%20% 30-Jun-154,107,360.98$ 2,097,077.20$ 30-Jun-1539%20% 31-Jul-153,592,332.11$ 2,097,077.20$ 31-Jul-1534%20% 31-Aug-153,616,538.87$ 2,097,077.20$ 31-Aug-1534%20% 30-Sep-154,646,069.85$ 2,097,077.20$ 30-Sep-1544%20% 31-Oct-155,122,032.44$ 2,097,077.20$ 31-Oct-1549%20% 30-Nov-154,893,300.77$ 2,097,077.20$ 30-Nov-1547%20% 31-Dec-154,592,169.19$ 2,097,077.20$ 31-Dec-1544%20% 31-Jan-164,945,234.80$ 2,744,352.25$ 31-Jan-1645%25% $- $1 $2 $3 $4 $5 $6 31-Aug-13 30-Sep-13 31-Oct-13 30-Nov-13 31-Dec-13 31-Jan-14 28-Feb-14 31-Mar-14 30-Apr-14 31-May-14 30-Jun-14 31-Jul-14 31-Aug-14 30-Sep-14 31-Oct-14 30-Nov-14 31-Dec-14 31-Jan-15 28-Feb-15 31-Mar-15 30-Apr-15 31-May-15 30-Jun-15 31-Jul-15 31-Aug-15 30-Sep-15 31-Oct-15 30-Nov-15 31-Dec-15 31-Jan-16 Millions Available Cash Reserve Requirement 0% 10%20%30%40%50%60% 31-Aug-13 30-Sep-13 31-Oct-13 30-Nov-13 31-Dec-13 31-Jan-14 28-Feb-14 31-Mar-14 30-Apr-14 31-May-14 30-Jun-14 31-Jul-14 31-Aug-14 30-Sep-14 31-Oct-14 30-Nov-14 31-Dec-14 31-Jan-15 28-Feb-15 31-Mar-15 30-Apr-15 31-May-15 30-Jun-15 31-Jul-15 31-Aug-15 30-Sep-15 31-Oct-15 30-Nov-15 31-Dec-15 31-Jan-16 Actual Percent Percent Requirement Cash Reserve Report9 Liability Insurance - 226 DateAvailable Cash Reserve RequirementDate Actual Percent Percent Requirement 31-Aug-135,269,618.39$ 728,981.75$ 31-Aug-13181%25% 30-Sep-135,430,336.47$ 728,981.75$ 30-Sep-13186%25% 31-Oct-135,563,697.82$ 728,981.75$ 31-Oct-13191%25% 30-Nov-135,571,676.20$ 728,981.75$ 30-Nov-13191%25% 31-Dec-135,185,497.38$ 728,981.75$ 31-Dec-13178%25% 31-Jan-145,235,932.06$ 724,300.00$ 31-Jan-14181%25% 28-Feb-145,019,217.44$ 724,300.00$ 28-Feb-14173%25% 31-Mar-145,075,527.45$ 724,300.00$ 31-Mar-14175%25% 30-Apr-145,218,468.25$ 724,300.00$ 30-Apr-14180%25% 31-May-145,341,078.00$ 724,300.00$ 31-May-14184%25% 30-Jun-145,099,755.96$ 724,300.00$ 30-Jun-14176%25% 31-Jul-145,133,550.90$ 724,300.00$ 31-Jul-14177%25% 31-Aug-145,274,005.60$ 724,300.00$ 31-Aug-14182%25% 30-Sep-145,400,963.70$ 724,300.00$ 30-Sep-14186%25% 31-Oct-145,541,538.17$ 724,300.00$ 31-Oct-14191%25% 30-Nov-145,813,654.41$ 724,300.00$ 30-Nov-14201%25% 31-Dec-145,682,684.39$ 724,300.00$ 31-Dec-14196%25% 31-Jan-155,461,655.49$ 764,197.75$ 31-Jan-15179%25% 28-Feb-155,314,999.89$ 764,197.75$ 28-Feb-15174%25% 31-Mar-155,269,874.19$ 764,197.75$ 31-Mar-15172%25% 30-Apr-155,024,562.10$ 764,197.75$ 30-Apr-15164%25% 31-May-154,960,310.54$ 764,197.75$ 31-May-15162%25% 30-Jun-154,559,500.84$ 764,197.75$ 30-Jun-15149%25% 31-Jul-154,349,972.24$ 764,197.75$ 31-Jul-15142%25% 31-Aug-154,391,466.11$ 764,197.75$ 31-Aug-15144%25% 30-Sep-154,412,089.90$ 764,197.75$ 30-Sep-15144%25% 31-Oct-154,536,090.51$ 764,197.75$ 31-Oct-15148%25% 30-Nov-154,528,101.76$ 764,197.75$ 30-Nov-15148%25% 31-Dec-154,485,904.07$ 764,197.75$ 31-Dec-15147%25% 31-Jan-164,527,921.79$ 1,560,174.00$ 31-Jan-16145%50% $- $1 $2 $3 $4 $5 $6 $7 31-Aug-13 30-Sep-13 31-Oct-13 30-Nov-13 31-Dec-13 31-Jan-14 28-Feb-14 31-Mar-14 30-Apr-14 31-May-14 30-Jun-14 31-Jul-14 31-Aug-14 30-Sep-14 31-Oct-14 30-Nov-14 31-Dec-14 31-Jan-15 28-Feb-15 31-Mar-15 30-Apr-15 31-May-15 30-Jun-15 31-Jul-15 31-Aug-15 30-Sep-15 31-Oct-15 30-Nov-15 31-Dec-15 31-Jan-16 Millions Available Cash Reserve Requirement 0% 50%100%150%200%250% 31-Aug-13 30-Sep-13 31-Oct-13 30-Nov-13 31-Dec-13 31-Jan-14 28-Feb-14 31-Mar-14 30-Apr-14 31-May-14 30-Jun-14 31-Jul-14 31-Aug-14 30-Sep-14 31-Oct-14 30-Nov-14 31-Dec-14 31-Jan-15 28-Feb-15 31-Mar-15 30-Apr-15 31-May-15 30-Jun-15 31-Jul-15 31-Aug-15 30-Sep-15 31-Oct-15 30-Nov-15 31-Dec-15 31-Jan-16 Actual Percent Percent Requirement Cash Reserve Report10 Loss Recovery Fund - 227 DateAvailable Cash Reserve RequirementDate Actual Percent Percent Requirement 31-Aug-137,992,320.28$ 105,237.00$ 31-Aug-131519%20% 30-Sep-137,983,890.02$ 105,237.00$ 30-Sep-131517%20% 31-Oct-137,957,776.85$ 105,237.00$ 31-Oct-131512%20% 30-Nov-137,898,750.90$ 105,237.00$ 30-Nov-131501%20% 31-Dec-136,970,228.09$ 105,237.00$ 31-Dec-131325%20% 31-Jan-146,313,244.00$ 930,000.00$ 31-Jan-14136%20% 28-Feb-146,890,352.55$ 1,123,161.00$ 28-Feb-14123%20% 31-Mar-146,953,221.38$ 1,123,161.00$ 31-Mar-14124%20% 30-Apr-146,914,254.79$ 1,123,161.00$ 30-Apr-14123%20% 31-May-146,537,384.88$ 1,123,161.00$ 31-May-14116%20% 30-Jun-146,568,028.80$ 1,123,161.00$ 30-Jun-14117%20% 31-Jul-146,517,717.27$ 1,323,161.00$ 31-Jul-1499%20% 31-Aug-145,840,729.06$ 1,323,161.00$ 31-Aug-1488%20% 30-Sep-145,587,766.78$ 1,323,161.00$ 30-Sep-1484%20% 31-Oct-145,078,962.94$ 1,323,161.00$ 31-Oct-1477%20% 30-Nov-143,601,667.73$ 1,323,161.00$ 30-Nov-1454%20% 31-Dec-141,680,004.94$ 1,323,161.00$ 31-Dec-1425%20% 31-Jan-151,712,154.65$ 1,047,448.60$ 31-Jan-1533%20% 28-Feb-151,669,559.95$ 1,047,448.60$ 28-Feb-1532%20% 31-Mar-151,703,611.11$ 1,047,448.60$ 31-Mar-1533%20% 30-Apr-151,736,052.53$ 1,047,448.60$ 30-Apr-1533%20% 31-May-151,879,150.32$ 1,047,448.60$ 31-May-1536%20% 30-Jun-151,914,678.32$ 1,047,448.60$ 30-Jun-1537%20% 31-Jul-151,917,616.41$ 1,047,448.60$ 31-Jul-1537%20% 31-Aug-15813,516.63$ 1,047,448.60$ 31-Aug-1516%20% 30-Sep-15673,468.55$ 1,047,448.60$ 30-Sep-1513%20% 31-Oct-15687,743.22$ 1,047,448.60$ 31-Oct-1513%20% 30-Nov-15792,288.36$ 1,047,448.60$ 30-Nov-1515%20% 31-Dec-15864,231.17$ 1,047,448.60$ 31-Dec-1517%20% 31-Jan-16864,586.23$ -$ 31-Jan-16100%0% $- $1 $2 $3 $4 $5 $6 $7 $8 $9 31-Aug-13 30-Sep-13 31-Oct-13 30-Nov-13 31-Dec-13 31-Jan-14 28-Feb-14 31-Mar-14 30-Apr-14 31-May-14 30-Jun-14 31-Jul-14 31-Aug-14 30-Sep-14 31-Oct-14 30-Nov-14 31-Dec-14 31-Jan-15 28-Feb-15 31-Mar-15 30-Apr-15 31-May-15 30-Jun-15 31-Jul-15 31-Aug-15 30-Sep-15 31-Oct-15 30-Nov-15 31-Dec-15 31-Jan-16 Millions Available Cash Reserve Requirement 0%200%400%600%800% 1000%1200%1400%1600% 31-Aug-13 30-Sep-13 31-Oct-13 30-Nov-13 31-Dec-13 31-Jan-14 28-Feb-14 31-Mar-14 30-Apr-14 31-May-14 30-Jun-14 31-Jul-14 31-Aug-14 30-Sep-14 31-Oct-14 30-Nov-14 31-Dec-14 31-Jan-15 28-Feb-15 31-Mar-15 30-Apr-15 31-May-15 30-Jun-15 31-Jul-15 31-Aug-15 30-Sep-15 31-Oct-15 30-Nov-15 31-Dec-15 31-Jan-16 Actual Percent Percent Requirement Cash Reserve Report11 Public Safety LOIT - 249 DateAvailable Cash Reserve RequirementDate Actual Percent Percent Requirement 31-Aug-132,139,726.11$ 1,420,351.40$ 31-Aug-1330%20% 30-Sep-132,631,285.15$ 1,420,351.40$ 30-Sep-1337%20% 31-Oct-131,081,697.22$ 1,420,351.40$ 31-Oct-1315%20% 30-Nov-131,572,948.63$ 1,420,351.40$ 30-Nov-1322%20% 31-Dec-132,032,194.08$ 1,420,351.40$ 31-Dec-1329%20% 31-Jan-142,046,798.30$ 1,442,931.60$ 31-Jan-1428%20% 28-Feb-141,965,415.14$ 1,442,931.60$ 28-Feb-1427%20% 31-Mar-141,788,938.50$ 1,442,931.60$ 31-Mar-1425%20% 30-Apr-141,727,753.74$ 1,442,931.60$ 30-Apr-1424%20% 31-May-141,686,442.29$ 1,442,931.60$ 31-May-1423%20% 30-Jun-141,604,462.03$ 1,442,931.60$ 30-Jun-1422%20% 31-Jul-141,028,769.93$ 1,442,931.60$ 31-Jul-1414%20% 31-Aug-141,313,459.48$ 1,442,931.60$ 31-Aug-1418%20% 30-Sep-141,263,069.52$ 1,442,931.60$ 30-Sep-1418%20% 31-Oct-14704,536.10$ 1,442,931.60$ 31-Oct-1410%20% 30-Nov-141,313,921.77$ 1,442,931.60$ 30-Nov-1418%20% 31-Dec-141,293,978.68$ 1,442,931.60$ 31-Dec-1418%20% 31-Jan-151,101,184.99$ 1,449,310.20$ 31-Jan-1515%20% 28-Feb-151,122,087.44$ 1,449,310.20$ 28-Feb-1515%20% 31-Mar-15573,193.85$ 1,449,310.20$ 31-Mar-158%20% 30-Apr-151,146,259.78$ 1,449,310.20$ 30-Apr-1516%20% 31-May-151,168,383.41$ 1,449,310.20$ 31-May-1516%20% 30-Jun-151,149,240.91$ 1,449,310.20$ 30-Jun-1516%20% 31-Jul-15970,331.63$ 1,449,310.20$ 31-Jul-1513%20% 31-Aug-15467,350.59$ 1,449,310.20$ 31- Aug-156%20% 30-Sep-15976,720.23$ 1,449,310.20$ 30-Sep-1513%20% 31-Oct-15997,198.89$ 1,449,310.20$ 31-Oct-1514%20% 30-Nov-15899,505.58$ 1,449,310.20$ 30-Nov-1512%20% 31-Dec-15642,770.29$ 1,449,310.20$ 31-Dec-159%20% 31-Jan-16687,550.93$ 528,050.08$ 31-Jan-1610%8% $- $1 $1 $2 $2 $3 $3 31-Aug-13 30-Sep-13 31-Oct-13 30-Nov-13 31-Dec-13 31-Jan-14 28-Feb-14 31-Mar-14 30-Apr-14 31-May-14 30-Jun-14 31-Jul-14 31-Aug-14 30-Sep-14 31-Oct-14 30-Nov-14 31-Dec-14 31-Jan-15 28-Feb-15 31-Mar-15 30-Apr-15 31-May-15 30-Jun-15 31-Jul-15 31-Aug-15 30-Sep-15 31-Oct-15 30-Nov-15 31-Dec-15 31-Jan-16 Millions Available Cash Reserve Requirement 0%5%10%15%20%25%30%35%40% 31-Aug-13 30-Sep-13 31-Oct-13 30-Nov-13 31-Dec-13 31-Jan-14 28-Feb-14 31-Mar-14 30-Apr-14 31-May-14 30-Jun-14 31-Jul-14 31-Aug-14 30-Sep-14 31-Oct-14 30-Nov-14 31-Dec-14 31-Jan-15 28-Feb-15 31-Mar-15 30-Apr-15 31-May-15 30-Jun-15 31-Jul-15 31-Aug-15 30-Sep-15 31-Oct-15 30-Nov-15 31-Dec-15 31-Jan-16 Actual Percent Percent Requirement Cash Reserve Report12 COIT - 404 DateAvailable Cash Reserve RequirementDate Actual Percent Percent Requirement 31-Aug-1314,058,497.85$ 4,629,457.50$ 31-Aug-13152%50% 30-Sep-1314,316,443.37$ 4,629,457.50$ 30-Sep-13155%50% 31-Oct-1314,635,975.61$ 4,721,708.50$ 31-Oct-13155%50% 30-Nov-1314,942,528.27$ 4,721,708.50$ 30-Nov-13158%50% 31-Dec-1314,685,372.33$ 4,721,708.50$ 31-Dec-13156%50% 31-Jan-1413,669,378.75$ 4,877,970.00$ 31-Jan-14140%50% 28-Feb-1414,064,953.63$ 4,988,101.00$ 28-Feb-14141%50% 31-Mar-1414,419,544.87$ 5,096,642.50$ 31-Mar-14141%50% 30-Apr-1414,138,281.09$ 5,096,642.50$ 30-Apr-14139%50% 31-May-1414,417,615.48$ 5,582,892.50$ 31-May-14129%50% 30-Jun-1414,566,201.25$ 5,582,892.50$ 30-Jun-14130%50% 31-Jul-1413,784,177.94$ 5,582,892.50$ 31-Jul-14123%50% 31-Aug-1414,852,716.09$ 5,582,892.50$ 31-Aug-14133%50% 30-Sep-1414,014,334.96$ 5,582,892.50$ 30-Sep-14126%50% 31-Oct-1412,625,447.23$ 5,582,892.50$ 31-Oct-14113%50% 30-Nov-1413,703,278.95$ 5,582,892.50$ 30-Nov-14123%50% 31-Dec-1413,810,191.53$ 5,582,892.50$ 31-Dec-14124%50% 31-Jan-1513,363,623.40$ 7,830,185.50$ 31-Jan-1585%50% 28-Feb-1513,104,068.98$ 7,830,185.50$ 28-Feb-1584%50% 31-Mar-1512,417,613.96$ 7,830,185.50$ 31-Mar-1579%50% 30-Apr-1513,525,436.86$ 7,830,185.50$ 30-Apr-1586%50% 31-May-1513,483,035.78$ 7,830,185.50$ 31-May-1586%50% 30-Jun-1513,641,102.60$ 7,830,185.50$ 30-Jun-1587%50% 31-Jul-1513,287,258.01$ 7,830,185.50$ 31-Jul-1585%50% 31-Aug-1512,603,271.36$ 7,830,185.50$ 31-Aug-1580%50% 30-Sep-1511,982,696.06$ 7,830,185.50$ 30-Sep-1577%50% 31-Oct-1511,727,154.29$ 7,830,185.50$ 31-Oct-1575%50% 30-Nov-1511,326,023.58$ 7,830,185.50$ 30-Nov-1572%50% 31-Dec-159,895,195.52$ 7,946,833.50$ 31-Dec-1562%50% 31-Jan-168,575,802.53$ 7,581,074.00$ 31-Jan-1657%50% $- $2 $4 $6 $8 $10 $12 $14 $16 31-Aug-13 30-Sep-13 31-Oct-13 30-Nov-13 31-Dec-13 31-Jan-14 28-Feb-14 31-Mar-14 30-Apr-14 31-May-14 30-Jun-14 31-Jul-14 31-Aug-14 30-Sep-14 31-Oct-14 30-Nov-14 31-Dec-14 31-Jan-15 28-Feb-15 31-Mar-15 30-Apr-15 31-May-15 30-Jun-15 31-Jul-15 31-Aug-15 30-Sep-15 31-Oct-15 30-Nov-15 31-Dec-15 31-Jan-16 Millions Available Cash Reserve Requirement 0%40%80%120%160%200% 31-Aug-13 30-Sep-13 31-Oct-13 30-Nov-13 31-Dec-13 31-Jan-14 28-Feb-14 31-Mar-14 30-Apr-14 31-May-14 30-Jun-14 31-Jul-14 31-Aug-14 30-Sep-14 31-Oct-14 30-Nov-14 31-Dec-14 31-Jan-15 28-Feb-15 31-Mar-15 30-Apr-15 31-May-15 30-Jun-15 31-Jul-15 31-Aug-15 30-Sep-15 31-Oct-15 30-Nov-15 31-Dec-15 31-Jan-16 Actual Percent Percent Requirement Cash Reserve Report13 EDIT - 408 DateAvailable Cash Reserve RequirementDate Actual Percent Percent Requirement 31-Aug-138,588,537.46$ 4,466,689.50$ 31-Aug-1396%50% 30-Sep-139,145,793.98$ 4,466,689.50$ 30-Sep-13102%50% 31-Oct-139,731,662.47$ 4,496,689.50$ 31-Oct-13108%50% 30-Nov-139,296,619.48$ 4,496,689.50$ 30-Nov-13103%50% 31-Dec-1310,085,156.94$ 4,496,689.50$ 31-Dec-13112%50% 31-Jan-148,379,313.95$ 4,629,006.50$ 31-Jan-1491%50% 28-Feb-149,278,816.60$ 5,007,492.00$ 28-Feb-1493%50% 31-Mar-149,966,875.90$ 5,007,492.00$ 31-Mar-14100%50% 30-Apr-149,076,730.26$ 5,007,492.00$ 30-Apr-1491%50% 31-May-149,202,305.40$ 5,144,992.00$ 31-May-1489%50% 30-Jun-149,910,209.22$ 5,144,992.00$ 30-Jun-1496%50% 31-Jul-148,958,071.99$ 5,144,992.00$ 31-Jul-1487%50% 31-Aug-149,903,901.38$ 5,144,992.00$ 31-Aug-1496%50% 30-Sep-1410,608,492.02$ 5,144,992.00$ 30-Sep-14103%50% 31-Oct-147,941,968.89$ 5,144,992.00$ 31-Oct-1477%50% 30-Nov-149,294,422.29$ 5,144,992.00$ 30-Nov-1490%50% 31-Dec-1410,033,655.55$ 5,144,992.00$ 31-Dec-1498%50% 31-Jan-1510,065,104.57$ 4,813,809.00$ 31-Jan-15105%50% 28-Feb-159,059,022.75$ 4,813,809.00$ 28-Feb-1594%50% 31-Mar-158,960,343.03$ 4,813,809.00$ 31-Mar-1593%50% 30-Apr-1510,291,604.12$ 4,813,809.00$ 30-Apr-15107%50% 31-May-1510,408,959.43$ 4,813,809.00$ 31-May-15108%50% 30-Jun-1511,163,475.51$ 4,971,854.50$ 30-Jun-15112%50% 31-Jul-159,675,461.38$ 4,971,854.50$ 31-Jul-1597%50% 31-Aug-159,550,701.30$ 4,971,854.50$ 31-Aug-1596%50% 30-Sep-159,399,079.89$ 5,066,874.50$ 30-Sep-1593%50% 31-Oct-159,158,107.55$ 5,066,874.50$ 31-Oct-1590%50% 30-Nov-159,112,235.29$ 5,066,874.50$ 30-Nov-1590%50% 31-Dec-159,776,901.11$ 5,066,874.50$ 31-Dec-1596%50% 31-Jan-167,938,199.64$ 5,280,090.50$ 31-Jan-1675%50% $- $2 $4 $6 $8 $10 $12 31-Aug-13 30-Sep-13 31-Oct-13 30-Nov-13 31-Dec-13 31-Jan-14 28-Feb-14 31-Mar-14 30-Apr-14 31-May-14 30-Jun-14 31-Jul-14 31-Aug-14 30-Sep-14 31-Oct-14 30-Nov-14 31-Dec-14 31-Jan-15 28-Feb-15 31-Mar-15 30-Apr-15 31-May-15 30-Jun-15 31-Jul-15 31-Aug-15 30-Sep-15 31-Oct-15 30-Nov-15 31-Dec-15 31-Jan-16 Millions Available Cash Reserve Requirement 0% 20%40%60%80%100%120% 31-Aug-13 30-Sep-13 31-Oct-13 30-Nov-13 31-Dec-13 31-Jan-14 28-Feb-14 31-Mar-14 30-Apr-14 31-May-14 30-Jun-14 31-Jul-14 31-Aug-14 30-Sep-14 31-Oct-14 30-Nov-14 31-Dec-14 31-Jan-15 28-Feb-15 31-Mar-15 30-Apr-15 31-May-15 30-Jun-15 31-Jul-15 31-Aug-15 30-Sep-15 31-Oct-15 30-Nov-15 31-Dec-15 31-Jan-16 Actual Percent Percent Requirement Cash Reserve Report14 Self-funded Employee Benefits - 711 DateAvailable Cash Reserve RequirementDate Actual Percent Percent Requirement 31-Aug-137,122,787.23$ 3,337,207.25$ 31-Aug-1353%25% 30-Sep-136,960,945.55$ 3,337,207.25$ 30-Sep-1352%25% 31-Oct-136,291,676.90$ 3,337,207.25$ 31-Oct-1347%25% 30-Nov-135,925,449.92$ 3,337,207.25$ 30-Nov-1344%25% 31-Dec-135,661,447.10$ 3,337,207.25$ 31-Dec-1342%25% 31-Jan-146,054,616.69$ 3,620,865.75$ 31-Jan-1442%25% 28-Feb-145,189,194.64$ 3,620,865.75$ 28-Feb-1436%25% 31-Mar-144,881,271.34$ 3,620,865.75$ 31-Mar-1434%25% 30-Apr-144,775,766.48$ 3,620,865.75$ 30-Apr-1433%25% 31-May-144,734,213.61$ 3,620,865.75$ 31-May-1433%25% 30-Jun-144,967,756.75$ 3,620,865.75$ 30-Jun-1434%25% 31-Jul-144,547,283.48$ 3,620,865.75$ 31-Jul-1431%25% 31-Aug-144,497,229.79$ 3,620,865.75$ 31-Aug-1431%25% 30-Sep-144,488,566.83$ 3,620,865.75$ 30-Sep-1431%25% 31-Oct-144,312,284.67$ 3,620,865.75$ 31-Oct-1430%25% 30-Nov-144,290,596.22$ 3,620,865.75$ 30-Nov-1430%25% 31-Dec-144,054,314.37$ 3,620,865.75$ 31-Dec-1425%25% 31-Jan-154,151,993.32$ 4,174,233.75$ 31-Jan-1525%25% 28-Feb-154,252,749.21$ 4,174,233.75$ 28-Feb-1525%25% 31-Mar-154,364,599.56$ 4,174,233.75$ 31-Mar-1526%25% 30-Apr-154,140,504.23$ 4,174,233.75$ 30-Apr-1525%25% 31-May-154,243,077.17$ 4,174,233.75$ 31-May-1525%25% 30-Jun-154,502,701.32$ 4,349,567.00$ 30-Jun-1526%25% 31-Jul-154,444,106.98$ 4,174,233.75$ 31-Jul-1527%25% 31-Aug-154,406,259.32$ 4,174,233.75$ 31-Aug-1526%25% 30-Sep-154,326,879.00$ 4,174,233.75$ 30-Sep-1526%25% 31-Oct-154,572,942.80$ 4,174,233.75$ 31-Oct-1527%25% 30-Nov-154,547,867.48$ 4,174,233.75$ 30-Nov-1527%25% 31-Dec-154,329,762.09$ 4,174,233.75$ 31-Dec-1526%25% 31-Jan-164,820,833.64$ 4,344,722.50$ 31-Jan-1628%25% $- $1 $2 $3 $4 $5 $6 $7 $8 31-Aug-13 30-Sep-13 31-Oct-13 30-Nov-13 31-Dec-13 31-Jan-14 28-Feb-14 31-Mar-14 30-Apr-14 31-May-14 30-Jun-14 31-Jul-14 31-Aug-14 30-Sep-14 31-Oct-14 30-Nov-14 31-Dec-14 31-Jan-15 28-Feb-15 31-Mar-15 30-Apr-15 31-May-15 30-Jun-15 31-Jul-15 31-Aug-15 30-Sep-15 31-Oct-15 30-Nov-15 31-Dec-15 31-Jan-16 Millions Available Cash Reserve Requirement 0%10%20%30%40%50%60% 31-Aug-13 30-Sep-13 31-Oct-13 30-Nov-13 31-Dec-13 31-Jan-14 28-Feb-14 31-Mar-14 30-Apr-14 31-May-14 30-Jun-14 31-Jul-14 31-Aug-14 30-Sep-14 31-Oct-14 30-Nov-14 31-Dec-14 31-Jan-15 28-Feb-15 31-Mar-15 30-Apr-15 31-May-15 30-Jun-15 31-Jul-15 31-Aug-15 30-Sep-15 31-Oct-15 30-Nov-15 31-Dec-15 31-Jan-16 Actual Percent Percent Requirement Cash Reserve Report15 City of South Bend Month of: January 201 6 Controller's Cash Report Opening InterestTransfersTransfersEnding Total Cash &Interfund Loans Fund Fund Name Cash BalanceReceiptsDisbursementsEarned In OutCash BalanceInvestmentsInvestments(Borrowing) City Controlled FundsGeneral Fund 101GENERAL FUND $30,486,009.21$969,267.5 7 $3,735,384.0 2 $8,917.0 8 $0.00$202,164.1 6 $27,526,645.6 8 $0.00 $27,526,645.6 8 $499,051.9 0 Special Revenue Funds 102RAINY DAY FUND8,703,421.670.000.003,073.650.000.008,706,495.320.00 8,706,495.3 2 0.00 103EXCESS LEVY3,670.150.000.001.300.000.003,671.450.00 3,671.4 5 0.00 201PARKS & RECREATION 3,924,991.90111,344.75711,502.47988.420.000.003,325,822.600.00 3,325,822.6 0 0.00 202MOTOR VEHICLE HIGHWAY5,225,685.73302,270.51838,403.292,033.11838,250.000.005,529,836.060.00 5,529,836.0 6 0.00 203RECREATION - NONREVERTING823,963.6057,780.6336,140.96294.090.000.00845,897.360.00 845,897.3 6 0.00 209STUDEBAKER/OLIVER REVERTING GRANTS1,108,642.284,499.504,499.50389.300.000.001,109,031.580.00 1,109,031.5 8 500,000.00 210DEPT COMMUNITY INVESTMENT STATE GRANTS 160,361.4115,160.00858,470.002,873.060.000.00 (680,075.53) 0.00 (680,075.53 ) 0.00 211DCI OPERATING FUND1,123,752.7433,427.18193,932.83440.30491,909.500.001,455,596.890.00 1,455,596.8 9 0.00 213POLICE FEDERAL GRANTS0.00 0.00 0.00 0.00 216POLICE STATE SEIZURES199,997.8411,910.330.0070.920.000.00211,979.090.00 211,979.09 0.00 217GIFT, DONATION, BEQUEST64,958.010.000.0022.690.000.0064,980.700.00 64,980.7 0 0.00 218POLICE CURFEW VIOLATIONS12,253.7512.500.004.320.000.0012,270.570.00 12,270.5 7 0.00 219UNSAFE BUILDING0.0019,938.590.000.00340,433.160.00360,371.750.00 360,371.7 5 0.00 220LAW ENFORCEMENT CONTINUING EDUCATION912,111.4029,197.4637,540.85321.200.000.00904,089.210.00 904,089.21 0.00 227LOSS RECOVERY FUND 994,542.090.008.00355.060.000.00994,889.150.00 994,889.1 5 0.00 244EMERGENCY TELEPHONE SYSTEM33,670.740.000.000.000.000.0033,670.740.00 33,670.7 4 0.00 249PUBLIC SAFETY L.O.I.T.642,770.29565,930.00521,395.04245.680.000.00687,550.930.00 687,550.9 3 0.00 251LOCAL ROADS & STREETS2,730,924.66300,868.5776,979.38952.170.000.002,955,766.020.00 2,955,766.0 2 0.00 252EXCESS WELFARE DISTRIBUTION8.070.000.000.000.000.008.070.00 8.07 0.00 258HUMAN RIGHTS - FEDERAL GRANT425,850.35121,000.0081,812.53126.120.000.00465,163.9468,896.24 534,060.1 8 0.00 271EASTRACE WATERWAY1,336.780.000.000.470.000.001,337.250.00 1,337.2 5 0.00 273MORRIS PAC/PALAIS ROYALE MARKETING30,391.26350.000.0010.540.000.0030,751.800.00 30,751.8 0 0.00 280POLICE BLOCK GRANTS3,855.180.000.001.360.000.003,856.540.00 3,856.5 4 0.00 281DEPT. COMMUNITY INVESTMENT - REV BONDS27,397.530.000.009.670.000.0027,407.200.00 27,407.2 0 0.00 289HAZMAT32,104.160.000.0011.340.000.0032,115.500.00 32,115.5 0 0.00 291INDIANA RIVER RESCUE95,569.135,400.001,199.8929.260.000.0099,798.500.00 99,798.5 0 0.00 292POLICE GRANTS121,195.800.006,712.500.000.000.00114,483.300.00 114,483.3 0 0.00 294REGIONAL POLICE ACADEMY70,309.838,450.00250.9624.740.000.0078,533.610.00 78,533.61 0.00 295COPS MORE GRANT121,715.48890.00707.0042.910.000.00121,941.390.00 121,941.3 9 0.00 299POLICE FEDERAL DRUG ENFORCEMENT252,751.540.000.0093.890.000.00252,845.430.00 252,845.4 3 0.00 404COUNTY OPTION INCOME TAX 12,100,666.63978,622.781,820,646.014,273.630.00375,000.0010,887,917.030.00 10,887,917.0 3 1,589,770.50 408ECONOMIC DEVELOPMENT INCOME TAX 9,886,898.11949,550.17571,810.473,378.110.001,620,945.508,647,070.420.00 8,647,070.4 2 0.00 410URBAN DEVELOPMENT ACTION GRANT (UDAG)631,221.060.00146,067.50318.560.000.00485,472.120.00 485,472.1 2 (1,589,770.50) 655PROJECT RELEAF923,439.7734,275.0114,149.67320.700.000.00943,885.810.00 943,885.81 0.00 705POLICE K-9 UNIT3,873.920.000.001.360.000.003,875.280.00 3,875.2 8 0.00 Total Special Revenue Funds 51,948,177.9 9 3,829,603.2 3 6,142,155.1 3 20,708.8 8 1,670,592.6 6 1,995,945.5 0 49,330,982.1 3 68,896.2 4 49,399,878.3 7 500,000.0 0 Debt Service Fund 313HALL OF FAME DEBT SERVICE 11,396.339,343.00636,000.000.000.000.00 (615,260.67) 0.00 (615,260.67 ) 0.00 Capital Project Funds 377PROFESSIONAL SPORTS DEVELOPMENT427,930.56173,033.37472,287.50151.130.000.00128,827.560.00 128,827.5 6 0.00 401COVELESKI STADIUM CAPITAL82,661.380.000.0029.190.000.0082,690.570.00 82,690.5 7 0.00 403ZOO ENDOWMENT49,509.970.000.0017.490.000.0049,527.460.00 49,527.4 6 0.00 405PARK NONREVERTING CAPITAL470,335.14169.000.00144.240.000.00470,648.380.00 470,648.3 8 0.00 406CUMULATIVE CAPITAL DEVELOPMENT 572,704.464,420.00112,650.48170.780.000.00464,644.760.00 464,644.7 6 0.00 407CUMULATIVE CAPITAL IMPROVEMENT311,636.55150,000.00184,125.0097.310.000.00277,608.860.00 277,608.8 6 0.00 412MAJOR MOVES CONSTRUCTION2,159,796.580.00110.00765.880.000.002,160,452.460.00 2,160,452.4 6 5,071,712.83 416MORRIS PERFORMING ARTS CENTER CAPITAL517,398.485,076.000.00181.980.000.00522,656.460.00 522,656.4 6 0.00 434CRED FUND2,403.830.000.0044.830.000.002,448.660.00 2,448.6 6 0.00 450PALAIS ROYALE HISTORIC PRESERVATION76,512.990.000.0026.950.000.0076,539.940.00 76,539.9 4 0.00 Cash Reserve Report16 City of South Bend Month of: January 201 6 Controller's Cash Report Opening InterestTransfersTransfersEnding Total Cash &Interfund Loans Fund Fund Name Cash BalanceReceiptsDisbursementsEarned In OutCash BalanceInvestmentsInvestments(Borrowing) 677HALL OF FAME CAPITAL FUND 503,531.04 0.00 4,657.78178.64 0.00 0.00499,051.90 0.00 499,051.9 0 (499,051.90) Total Capital & Debt Service Funds 5,185,817.31342,041.3 7 1,409,830.7 6 1,808.42 0.00 0.004,119,836.3 4 0.00 4,119,836.3 4 4,572,660.9 3 Enterprise Funds 287EMS CAPITAL2,575,588.740.000.00909.580.000.002,576,498.320.00 2,576,498.3 2 0.00 288EMS OPERATING2,216,998.37531,004.39624,282.09815.310.000.002,124,535.980.00 2,124,535.9 8 0.00 600CONSOLIDATED BUILDING DEPARTMENT1,896,477.92145,468.68309,016.58713.07527,517.000.002,261,160.090.00 2,261,160.0 9 0.00 601PARKING GARAGES641,451.0587,027.50111,714.16262.260.000.00617,026.650.00 617,026.6 5 0.00 610SOLID WASTE OPERATIONS319,813.61385,201.31409,166.24112.760.00251,000.0044,961.440.00 44,961.4 4 0.00 611SOLID WASTE CAPITAL443.280.00250,878.6710.82251,000.000.00575.430.00 575.43 0.00 620WATER WORKS OPERATIONS3,900,244.951,204,521.901,031,236.091,304.291,875.51170,505.003,906,205.560.00 3,906,205.56 0.00 622WATER WORKS CAPITAL2,884,157.520.000.001,018.560.000.002,885,176.080.00 2,885,176.0 8 0.00 624WATER WORKS CUSTOMER DEPOSIT1,514,085.1419,956.5619,295.31533.800.00533.801,514,746.390.00 1,514,746.3 9 0.00 625WATER WORKS SINKING FUND4,410.860.000.00551.40170,505.00551.40174,915.860.00 174,915.8 6 0.00 626WATER WORKS BOND RESERVE1,641,654.040.000.00569.150.000.001,642,223.190.00 1,642,223.1 9 0.00 629WATER WORKS RESERVE - O & M2,235,266.680.000.00790.310.00790.312,235,266.680.00 2,235,266.6 8 0.00 640SEWER REPAIR INSURANCE1,652,493.7648,803.9531,707.70582.460.000.001,670,172.470.00 1,670,172.4 7 0.00 641SEWAGE WORKS OPERATIONS9,023,708.312,742,440.141,782,274.983,204.971,300.64760,892.659,227,486.430.00 9,227,486.4 3 0.00 643SEWAGE WORKS RESERVE - O & M3,678,649.420.000.001,300.640.001,300.643,678,649.420.00 3,678,649.4 2 0.00 6452006 SEWER BOND0.00 0.000.00 0.00 0.00 650CLAY SEWAGE WORKS OPERATIONS0.00 0.000.00 0.00 0.00 653SEWAGE WORKS DEBT SERVICE RESERVE4,105,623.630.000.0025.160.000.004,105,648.790.00 4,105,648.79 0.00 6592011 SEWER BOND232,196.410.000.0081.990.000.00232,278.400.00 232,278.4 0 0.00 6612012 SEWER BOND13,928,149.150.00118,335.194,971.340.000.0013,814,785.300.00 13,814,785.3 0 0.00 6642013 SEWER REFUND BOND4,512.170.000.001.600.000.004,513.770.00 4,513.7 7 0.00 6662015 SEWER BOND58,231.330.0051,565.500.000.000.006,665.830.00 6,665.8 3 0.00 670CENTURY CENTER1,096,892.371,414,659.52906,676.700.000.000.001,604,875.190.00 1,604,875.1 9 0.00 671CENTURY CENTER CAPITAL1,002,072.000.000.0084.870.000.001,002,156.870.00 1,002,156.8 7 0.00 672CENTURY CENTER ENERGY SAVINGS50,031.920.000.004.240.000.0050,036.160.00 50,036.1 6 0.00 Total Enterprise Funds 64,215,673.5 9 6,579,083.9 5 6,282,542.1 7 22,645.1 7 1,713,090.8 0 1,185,573.8 0 65,062,377.5 4 0.00 65,062,377.5 4 0.00 Internal Service Funds222CENTRAL SERVICES 1,333,553.05826,926.40804,633.43352.96 0.00 0.001,356,198.98 0.00 1,356,198.9 8 0.00 224CENTRAL SERVICES CAPITAL187,162.850.000.0070.040.000.00187,232.890.00 187,232.8 9 226LIABILITY INSURANCE 4,532,060.12183,301.0098,404.211,620.93 0.00 0.004,618,577.84 0.00 4,618,577.8 4 0.00 278TAKE HOME VEHICLE POLICE642,307.578,940.0053.47224.410.000.00651,418.510.00 651,418.51 0.00 279311 CALL CENTER0.0056,784.1955,466.550.000.000.001,317.640.00 1,317.6 4 711SELF-FUNDED EMPLOYEE BENEFITS 4,374,720.891,380,893.05633,839.191,775.89 0.00 0.005,123,550.64 0.00 5,123,550.6 4 0.00 713UNEMPLOYMENT COMP FUND269,632.910.001,486.9194.520.000.00268,240.520.00 268,240.5 2 0.00 Total Internal Service Funds 11,339,437.3 9 2,456,844.6 4 1,593,883.7 6 4,138.7 5 0.00 0.0012,206,537.0 2 0.00 12,206,537.0 2 0.00 701FIREFIGHTERS PENSION 472,918.97 0.00427,166.61314.41 0.00 0.0046,066.77 0.00 46,066.77 0.00 703POLICE/FIRE 1977 STATE PENSION0.00 0.000.000.000.00 0.00 0.00 709PAYROLL FUND 0.007,740,503.987,740,540.980.000.000.00 (37.00) 0.00 (37.00) 0.00 712PUBLIC EMPLOYEES RETIREMENT FUND0.00 0.000.000.000.00 0.00 0.00 718STATE TAX DEDUCTION FUND412,690.08257,922.60412,690.080.000.000.00257,922.600.00 257,922.6 0 0.00 725MORRIS / PALAIS BOX OFFICE1,504,457.6421,041.560.000.000.000.001,525,499.200.00 1,525,499.2 0 0.00 726POLICE DISTRIBUTIONS PAY835,107.904,447.000.000.000.000.00839,554.900.00 839,554.9 0 0.00 730CITY CEMETERY TRUST28,578.870.000.0010.090.000.0028,588.960.00 28,588.9 6 0.00 Total Trust & Agency Funds 4,412,679.2 8 8,023,915.1 4 9,096,849.1 8 906.13 0.00 0.003,340,651.3 7 0.00 3,340,651.3 7 0.00 Total City Funds 167,587,794.7 7 22,200,755.9 0 28,260,645.0 2 59,124.4 3 3,383,683.4 6 3,383,683.4 6 161,587,030.0 8 68,896.2 4 161,655,926.3 2 5,571,712.8 3 Cash Reserve Report17 City of South Bend Month of: January 201 6 Controller's Cash Report Opening InterestTransfersTransfersEnding Total Cash &Interfund Loans Fund Fund Name Cash BalanceReceiptsDisbursementsEarned In OutCash BalanceInvestmentsInvestments(Borrowing) Redevelopment Commission Controlled Funds Tax Increment Financing Funds 324TIF RIVER WEST - AIRPORT32,771,000.678,212.804,064,434.2610,767.61981.060.0028,726,527.880.00 28,726,527.8 8 (500,000.00) 422TIF DISTRICT - WEST WASHINGTON 1,508,785.880.000.00515.710.000.001,509,301.590.00 1,509,301.5 9 0.00 425TIF LEIGHTON PLAZA209,030.7811,147.244,481.2358.480.000.00215,755.270.00 215,755.2 7 0.00 430TIF SOUTHSIDE DEVELOPMENT AREA #1 6,103,313.280.00280.002,007.080.000.006,105,040.360.00 6,105,040.3 6 0.00 431TIF SSDA #2 - ERSKINE COMM 0.00 0.000.000.00 0.00 0.00 432TIF SSDA #3 - ERSKINE VILLAGE5,309,297.710.00365,835.001,873.740.000.004,945,336.450.00 4,945,336.45 0.00 435TIF DOUGLAS ROAD151,862.780.000.0036.150.000.00151,898.930.00 151,898.9 3 (635,520.00) 436TIF RIVER EAST RES (NE RE) 1,622,126.64210,999.051,237,500.000.000.000.00595,625.690.00 595,625.6 9 (4,436,192.83) Total Tax Increment Financing Funds 55,246,391.8 2 230,359.0 9 5,754,440.5 4 17,921.4 4 981.06 0.0049,741,212.8 7 0.00 49,741,212.8 7 (5,571,712.83 ) Redevelopment Funds 433REDEVELOPMENT ADMINISTRATION GENERAL8,713.340.000.003.070.000.008,716.410.00 8,716.41 0.00 439CERTIFIED TECHNOLOGY PARK2,276,265.850.000.00832.710.000.002,277,098.560.00 2,277,098.5 6 0.00 454AIRPORT URBAN ENTERPRISE ZONE380,115.190.000.00134.240.000.00380,249.430.00 380,249.4 3 0.00 Total Redevelopment Funds 2,665,094.3 8 0.00 0.00 970.02 0.00 0.002,666,064.4 0 0.00 2,666,064.4 0 0.00 Debt Service Funds 315AIRPORT 2003 DEBT RESERVE 1,038,904.00 0.00 0.00 367.32 0.00 367.321,038,904.00 0.00 1,038,904.0 0 0.00 319REDEVELOPMENT BOND - BLACKTHORN GOLF0.000.000.000.000.00 0.00 0.00 328SBCDA 2003 DEBT RESERVE1,735,840.000.000.00613.740.00613.741,735,840.000.00 1,735,840.0 0 0.00 Total Debt Service Funds 3,283,224.2 7 0.00 0.001,160.6 3 0.00 981.063,283,403.8 4 0.00 3,283,403.8 4 0.00 Total Redevelopment Commission Funds 61,194,710.4 7 230,359.0 9 5,754,440.5 4 20,052.0 9 981.0 6 981.0 6 55,690,681.11 0.0055,690,681.11 (5,571,712.83 ) City Operations Total 228,782,505.2 4 22,431,114.9 9 34,015,085.5 6 79,176.5 2 3,384,664.5 2 3,384,664.5 2 217,277,711.1 9 68,896.2 4 217,346,607.4 3 0.00 Memo Item Pooled Investment Account OpeningInterest A ccrue d Change in Transfer I n Transfer out Investmen t Total Cash & Balanc e Net of FeesIncome A sset Valu e from Depository to DepositoryBalanc e Investment s 1st Source Bank Investment Accoun t 175,023,087.1 4 70,584.8 5 0.00(446,798.97 ) 0.00265,414.6 3 174,381,458.3 9 174,381,458.3 9 Cash Reserve Report18