The URL can be used to link to this page

Home My WebLink About2015 Board of Finance Annual Investment Report City of South Bend Board of Finance Annual Investment Report For the Year Ended December 31, 2015 Report Date: January 25, 2016 Report Distribution: Mayor Chief of Staff City Clerk South Bend Common Council Members Common Council Attorney Department Heads Fiscal Officers State Board of Accounts (local office) Submitted By: Department of Administration & Finance CITY OF SOUTH BEND BOARD OF FINANCE TABLE OF CONTENTS Investment Officers, Advisors, Authorized Investments……………….1 Investment Review Meetings ………………………………………………..2 Investment Policy …………………………………………………………...3-5 Investment Account Summary (January 20, 2016)………………………6 Investment Report (December 31, 2015) ……………………………... 7-14 Stale Dated Check Policy ……………………………………………….15-16 Stale Dated Check Report ……………………………………………....17-19 Controller’s Cash Report (December 31, 2015) ……………………..20-22 1st Source Bank Interest Earnings (Cash Basis) ………………..….…..23 Total Interest Earning by Year………………………………………….…..24 Total Interest Earnings by Fund ……………………………………….25-26 Cash Reserve Procedure ………………………………………………..27-29 Cash Reserves Summary (December 31, 2015) ……………………..30-41 CITY OF SOUTH BEND BOARD OF FINANCE INVESTMENT OFFICERS John H. Murphy, City Controller Jennifer C. Hockenhull, Deputy City Controller Rahman M. Johnson, Director of City Finance INVESTMENT ADVISORS (1ST SOURCE BANK) Paul W. Gifford, Jr., CFA Chief Investment Officer James E. Welch, CTFA Vice President and Trust Officer Erik Clapsaddle, CFA, CFP Vice President, Fixed Income Portfolio Manager AUTHORIZED INVESTMENT AMOUNT Maximum of $175 million with 1st Source Bank (No Change) 1 CITY OF SOUTH BEND BOARD OF FINANCE INVESTMENT REVIEW MEETINGS QUARTER DATE TIME 1ST QUARTER 4/20/16 10:00 A.M. 2ND QUARTER 7/27/16 10:00 A.M. 3RD QUARTER 10/19/16 10:00 A.M. 4TH QUARTER 1/18/17 10:00 A.M. Investment Review Meetings will be held at: 1st Source Bank 100 North Michigan Street, 5th Floor South Bend, IN 46601 2 City of South Bend Administration & Finance Policy Manual 2.8 Investment Policy Effective: January 1, 2011; Revised January 1, 2013 Purpose: This policy defines the cash investment policy of the City of South Bend. Scope: This statement applies to all governmental units, enterprise operations, and operations of the City of South Bend. This policy shall be in accordance with the terms and limitations of I.C. 5- 13-9, Deposit and Investment Powers, as amended from time to time. Responsibility: This policy is the responsibility of the Board of Finance of the City of South Bend. Changes or revisions to this policy are affected only with the consent and approval of the Board of Finance. Effective Date: This policy is effective upon approval and execution of the Board of Finance. The Board of Finance will review this policy on an annual basis coincident with the Annual Meeting of the Board of Finance, held after the 1st Monday in January and before January 31st. 1.0 Policy Statement The City of South Bend, Indiana shall make all investments, in both Deposit and Investment Accounts, in accordance with the terms and limitations of IC 5-13-9, Deposit and Investment Powers, as amended from time to time. 2.0 Deposit and Investment Options Eligible deposit accounts mean any of the following: 1.Any account subject to withdrawal by negotiable orders of withdrawal, unlimited as to amount or number, and without penalty, including NOW accounts 2.Passbook savings accounts 3.Certificates of Deposit 4.Money market deposit accounts 5.Any interest-bearing account that is authorized and offered by a financial institution in the course of its respective business City of South Bend Administration & Finance Policy Manual 3.0 Eligible Investment Products: Each investment officer may invest or reinvest any funds that are held by the officer and available for investment in any of the following (IC 5-13-9): 3.1 Securities backed by the full faith and credit of the United States Treasury or fully guaranteed by the United States and issued by any of the following: 3 1. The United States Treasury 2. A federal agency 3. A federal instrumentality 4. A federal government sponsored enterprise 3.2 Discount notes issued by any of the following: 1. A federal agency 2. A federal instrumentality 3. A federal government sponsored enterprise 3.3 An investment officer shall annually obtain the approval of the Common Council before making investments in the following: 1. Money market mutual funds that are in the form of securities of or interests in an open-end, no-load, management-type investment company or investment trust registered under the provisions of the federal Investment Company Act of 1940, as amended. The portfolio of this type must be limited to the following: A. Direct obligations of the United States B. Obligations issued by any of the following: a. A federal agency b. A federal instrumentality c. A federal government sponsored enterprise C. Repurchase agreements fully collateralized by obligations described in both A and B above. 2. The money market mutual fund must be rated as one of the following: A. AAAm, or its equivalent, by Standard and Poor's Corporation B. Aaa, or its equivalent, by Moody's Investors Service, Inc. 3.4 The investment is considered to have a stated final maturity of one day, and shall be made through depositories designated by the state board of finance as depositories for state deposits under IC 5-13- 9.5. 4.0 Terms of Repurchase Agreements Each investment officer may enter into, with any funds that are held by the officer and available for investment, repurchase agreements with depositories designated by the State Board of Finance as depositories under IC 5-13-9.5; and involving the political subdivision’s purchase and guaranteed resale of any interest-bearing obligations; A. issued; or B. fully insured or guaranteed by the United States, a United States Government Agency, an instrumentality of the United States, or a federal government sponsored enterprise. The depository shall determine daily that the amount of money in this type of agreement must be fully collateralized by interest-bearing obligations as determined by their current market value. The collateral is not subject to the two-year maturity limitation. 4 Repurchase agreements may be entered into for a fixed term or arranged on an open or continuing basis as a continuing contract that: 1. operates like a series of overnight repurchase agreements (may be referred to as overnight sweep products), 2. is renewed each day with the repurchase rate and the amount of funds invested determined daily; and 3. for this purpose is considered to have a final maturity of one day. 5.0 Investment in Other Securities Each investing officer may invest or reinvest in obligations issued, assumed or guaranteed by the International Bank for Reconstruction and Redevelopment or the African Development Bank (IC 5-13- 9.3.3) 6.0 Inter-local Cooperation Agreement IC 36-1-7-1 authorizes and permits local units of government to enter into inter-local cooperation agreements, and thus to exercise a power jointly pursuant to a written agreement authorized by ordinance or resolution. MBIA provides through Invest Indiana, such an inter-local agreement. The investments of the joint structure are limited to all investments authorized by IC 5-13. 7.0 Maturity Limitations 1. A minimum of 75% of the total portfolio must be invested with a maximum maturity of two (2) years in permitted investments as defined as above. 2. A maximum of 25% of the total portfolio may be invested with a maturity of two (2) to five (5) years as permitted in IC 5-13-9-5.7 in permitted investments as defined as above. This policy expires on January 31, 2017. 5 Account Summary as of 1/20/2016City of South Bend Corporate Agency Account StatisticsTotal Market Value $175,038,451.94 Total Unrealized Gain/Loss $162,527.06 Estimated Annual Income $1,545,121.87 Estimated Portfolio Yield 0.90% YTD Long Term Gain/Loss $0.00 YTD Short Term Gain/Loss $0.00 Policy Account Income Minor Account Type AGENCY Investment Officer PAUL GIFFORD Administrative Officer JIM WELCH Asset Allocation % Total Market Value Asset Category 0.5 921,070.17 Cash 99.5 174,117,381.77 Fixed Income 100.0% $175,038,451.94 Total Top 5 Holdings (Cash Excluded)Asset Units Price Tax CostMarket Value Yield Est. Income Gain/Loss % Total FHLMC MTN 0.800% 5/12/17 8.58 0.80 120,000.00 14,966.67 15,013,966.67 14,999,000.00 99.94 15,000,000 FHLMC MTN 0.850% 5/26/17 5.72 0.80 85,000.00 13,550.00 10,013,050.00 9,999,500.00 100.00 10,000,000 Key Bank NA CD 1.150% 10/02/17 4.58 1.10 92,000.00 25,350.14 8,025,350.14 8,000,000.00 99.96 8,000,000 Wells Farg Bk CD V-A 1.000% 4/16/19 4.01 1.00 70,000.00 25,130.96 7,025,130.96 7,000,000.00 100.10 7,000,000 Key Bank NA CD 0.800% 4/10/17 4.01 0.80 56,000.00 14,976.16 7,014,976.16 7,000,000.00 99.99 7,000,000 $46,998,500.00$47,092,473.93$93,973.93$423,000.000.88% Total 26.90% Market values include accruals.January 20, 2016 6 Investment Presentation forCity of South Bend Corporate Agency Prepared by Paul W Gifford, CFA 7 Account Summary as of 1/4/2016City of South Bend Corporate Agency Account StatisticsTotal Market Value $174,715,639.47 Total Unrealized Gain/Loss -$192,730.70 Estimated Annual Income $1,545,163.35 Estimated Portfolio Yield 0.90% YTD Long Term Gain/Loss $0.00 YTD Short Term Gain/Loss $0.00 Policy Account Income Minor Account Type AGENCY Investment Officer PAUL GIFFORD Administrative Officer JIM WELCH Asset Allocation % Total Market Value Asset Category 0.5 953,514.28 Cash 99.5 173,762,125.19 Fixed Income 100.0% $174,715,639.47 Total Top 5 Holdings (Cash Excluded)Asset Units Price Tax CostMarket Value Yield Est. Income Gain/Loss % Total FHLMC MTN 0.800% 5/12/17 8.56 0.80 120,000.00 -42,066.67 14,956,933.33 14,999,000.00 99.60 15,000,000 FHLMC MTN 0.850% 5/26/17 5.72 0.90 85,000.00 -14,336.11 9,985,163.89 9,999,500.00 99.77 10,000,000 Key Bank NA CD 1.150% 10/02/17 4.58 1.10 92,000.00 2,481.10 8,002,481.10 8,000,000.00 99.74 8,000,000 Key Bank NA CD 0.800% 4/10/17 4.01 0.80 56,000.00 2,961.10 7,002,961.10 7,000,000.00 99.86 7,000,000 Wells Farg Bk CD V-A 1.000% 4/16/19 4.00 1.00 70,000.00 -3,992.88 6,996,007.12 7,000,000.00 99.73 7,000,000 $46,998,500.00$46,943,546.54-$54,953.46$423,000.000.90% Total 26.87% Market values include accruals.January 1, 2016 8 Holdings Detail as of 1/4/2016City of South Bend Corporate Agency Asset CUSIPQuantity Tax Cost Yield Est. Income Gain/Loss Market Value CashTaxable Money Market FundsFederated Treasury Obliga-ss60934N872953,511953,510.72953,514.283.56136.350.01%$953,510.72$953,514.28$3.56$136.350.01% Total CashFixed IncomeTime DepositsAccess Natl Bank CD 1.000% 6/07/1700432KDL4250,000250,000.00250,444.35444.352,500.001.00%Ally Bank UT CD 1.200% 9/11/1702006LTT02 50,000250,000.00250,396.27396.273,000.001.20% Amer Expr Bk FSB CD 1.100% 10/24/1602587CBZ 2250,000250,000.00250,717.40717.402,750.001.10% Amer Expr Centur CD 0.900% 5/01/1702587DXL7250,000250,000.00249,735.86-264.142,250.000.90%Bank of NC CD 0.850% 3/30/1706414QVR7250,000250,000.00249,439.14-560.862,125.000.85% Barclays Bank DE CD 0.550% 4/15/1606740KGH 4250,000250,000.00250,283.84283.841,375.000.55% Barclays Bank DE CD 0.650% 7/05/1606740KGY7250,000250,000.00250,892.23892.231,625.000.65%Bbcn Bank CD 0.650% 12/27/16073296BR5250, 000250,000.00249,646.71-353.291,625.000.65% Bk Rhode Island CD 0.400% 2/12/16064577BR9250,000250,000.00250,021.82 21.821,000.000.40% Bmo Harris Bank CD 0.660% 3/30/1705573J2H65,000,0005,000,000.004,976,630.82-23,369.1833,000.000.66% Bmo Harris Bank CD 0.900% 3/23/1705573J4Q41,000,0001,000,000.001,000,835.75 835.759,000.000.90% Bmo Harris Bk CD 0.700% 2/21/17 05573JWR15,000,0005,000,000.004,996,753.42 -3,246.5835,000.000.70% Bmo Harris Bk CD 0.910% 6/26/17 05573J2F05,000,0005,000,000.004,980,297.95 -19,702.0545,500.000.91% Bmo Harris Bk CD 1.100% 9/29/17 05573J4X91,000,0001,000,000.001,000,102.74 102.7411,000.001.10% BMW Bank of NA CD 0.550% 6/20/16 05580AAJ3250,000 250,000.00 250,050.21 50.211,375.000.55% Capital One Bank CD 1.000% 10/31/16 140420QK9250,000 250,000.00 250,780.86 780.862,500.001.00% Capital One NA CD 1.150% 7/17/17 14042E4Q0250,000 250,000.00 250,449.04 449.042,875.001.15% Comenity Cap Bk CD 0.750% 8/04/16 20033AFW1250,000 250,000.00 250,020.00 20.001,875.000.75% Customers Bk CD 0.500% 2/26/16 23204HAR 9250,000 250,000.00 250,433.36 433.361,250.000.50% Discover Bank CD 0.950% 10/31/16 254672CJ5250,000 250,000.00 250,656.44 656.442,375.000.95% Enerbank USA CD 1.050% 7/31/17 29266NP35250,000 250,000.00 250,196.92 196.922,625.001.05% Everbank FL CD 0.700% 12/30/16 29976DYN4 250,000 250,000.00 249,644.59 -355.411,750.000.70% January 1, 2016 9 Holdings Detail as of 1/4/2016City of South Bend Corporate Agency Asset CUSIPQuantity Tax Cost Yield Est. Income Gain/Loss Market Value Fixed IncomeTime Deposits (continued)Fifth Third Bank CD .70% 2/28/169925720123,000,0003,000,000.003,000,000.00 0.0021,000.000.70% First Farmers Bk CD 0.900% 5/11/17 320165GZ0 1,000,0001,000,000.00 997,627.81 -2,372.199,000.000.90% First Merit Bank CD 1.000% 11/13/17 320844PU12 50,000 250,000.00 249,115.14 -884.862,500.001.00% First Niagara Bk CD 1.150% 9/11/17 33583CRR2 250,000 250,000.00 250,349.69 349.692,875.001.15% Flushing Bank CD 1.000% 6/26/17 34387ABR92 50,000 250,000.00 249,053.94 -946.062,500.001.00% GE Capital Bank CD 0.950% 7/29/16 36830TDD52 50,000 250,000.00 250,524.93 524.932,375.000.95% Goldman Sachs Bk CD 1.200% 2/13/18 38143A6F72 45,000 245,000.00 244,374.18 -625.822,940.001.20% Guaranty Bk & Tr CD 0.750% 12/30/16 400820BS4 250,000 250,000.00 249,645.27 -354.731,875.000.75% JP Morgan Chase CD 0.850% 2/27/17 48125T2X25,000,0005,000,000.004,904,287.67-95,712.3342,500.000.87% JP Morgan Chase CD 0.850% 4/30/17 48125YBF05,000,0005,000,000.004,991,185.62 -8 ,814.3842,500.000.85% JP Morgan Chase CD 0.875% 1/16/17 48125TU785,000,0005,000,000.005,017,606.85 17,606.8543,750.000.87% JP Morgan Chase CD 0.950% 3/13/17 48125T5A95,000,0005,000,000.004,998,922.60 -1,077.4047,500.000.95% JP Morgan Chase CD 1.125% 2/19/18 48124JSY51,079,0001,079,000.001,070,772.99 -8,227.0112,138.751.13% Key Bank NA CD 0.800% 4/10/17 49306SUX27, 000,0007,000,000.007,002,961.10 2,961.1056,000.000.80% Key Bank NA CD 1.150% 10/02/17 49306SVE38,000,0008,000,000.008,002,481.10 2,481.1092,000.001.15% Key Bank NA CD 1.200% 11/27/17 49306SVN32,000,0002,000,000.001,993,332.88 -6,667.1224,000.001.20% Lake City Bank CD 1.10% 5/28/17 9925720385, 000,0005,000,000.005,032,849.32 32,849.3255,000.001.09% Lake City Bank CD 1.13% 6/19/17 9925720416, 000,0006,000,000.006,036,407.67 36,407.6767,800.001.12% MB Financial Bk CD 0.900% 11/06/17 55266CPG5250,000 250,000.00 249,205.27 -794.732,250.000.90% Mercantil Commer CD 1.050% 6/26/17 58733ABS 7250,000 250,000.00 249,020.65 -979.352,625.001.05% Merrick Bank CD 1.150% 8/11/17 59013JGY9 250,000 250,000.00 249,860.41 -139.592,875.001.15% Midland St Bk IL CD 0.900% 2/13/17 59774QEU2250,000 250,000.00 250,102.05 102.052,250.000.90% Needham Bk CD 0.750% 11/14/16 63983RAR0 250,000 250,000.00 250,194.35 194.351,875.000.75% Old Natl Bank CD 0.500% 11/10/16 680061GQ5 250,000 250,000.00 249,658.73 -341.271,250.000.50% Peoples United CD 0.850% 9/12/16 71270QGN0250,000 250,000.00 250,792.88 792.882,125.000.85% Sallie Mae Bank CD 1.000% 10/11/16 795450TQ8250,000 250,000.00 250,864.69 864.692,500.001.00% January 1, 2016 10 Holdings Detail as of 1/4/2016City of South Bend Corporate Agency Asset CUSIPQuantity Tax Cost Yield Est. Income Gain/Loss Market Value Fixed IncomeTime Deposits (continued)Standard B&t Co CD 0.450% 5/31/16853117NN52, 500,0002,500,000.002,501,147.951,147.9511,250.000.45%Synchrony Bank CD 0.650% 6/20/1687165FAX22 50,000250,000.00250,103.42103.421,625.000.65% Synovus Bank GA CD 0.650% 6/24/1687164DFZ8250,000250,000.00250,179.18179.181,625.000.65%Townbank Ports VA CD 0.900% 6/12/1789214PAU3250,000250,000.00249,170.79-829.212,250.000.90%United Bank CD 0.850% 6/12/17909552AW1250,000250,000.00249,198.94-801.062,125.000.85% Washington Tr Westerly 0.7% 7/29/16940637GL9 250,000250,000.00250,743.36743.361,750.000.70% Wells Farg Bk CD V-A 1.000% 4/16/1994986TVU87 ,000,0007,000,000.006,996,007.12 -3,992.8870,000.001.00% Wells Fargo Bank CD 1.250% 11/20/179497482S55,000,0005,000,000.004,979,997.26-20,002.7462,500.001.26% Wells Fargo CD V-A 0.950% 2/28/1894986TMB05,000,0005,000,000.005,004,954.794,954.7947,500.000.95%Wex Bank CD 0.900% 11/14/1692937CCM8250,000250,000.00250,403.39403.392,250.000.90% Whitney Bank MS CD 1.200% 8/14/17966594AM5 250,000250,000.00250,564.62564.623,000.001.20% US TreasuryU.S. Treasury Notes 0.625% 12/31/16912828H295, 000,0004,997,656.264,991,685.85 -5,970.4131,250.000.63% Government AgencyFFCB 1.625% 5/13/193133EEK33 2,000,0002,000,000.002,007,433.33 7,433.3332,500.001.62% FHLB 0.625% 3/30/17 3130A4ZB14,785,0004,786,070.444,776,577.74 -9,492.7029,906.250.63% FHLB 0.800% 12/30/16 3130A3QN76,000,0006,009,272.825,997,313.33-11,959.4948,000.000.80% FHLB 0.800% 7/28/17 3130A5X K04,800,0004,800,000.004,801,584. 00 1,584.0038,400.000.80% FHLB 0.810% 10/19/17 3130A6JJ75,000,0005,000,500.004,975,100. 00-25,400.0040,500.000.81% FHLB 0.875% 1/27/17 3130A3UU61,500,0001,500,000.001,503,394.58 3,394.5813,125.000.87% FHLB 0.875% 8/25/17 3130A6A643,000,0003,000,000.002,996,767.50 -3,232.5026,250.000.88% FHLB 0.980% 11/24/17 3130A6S321,290,0001,289,754.901,285,094.42 -4,660.4812,642.000.98% FHLMC 1.060% 4/30/18 3134G43H 92,000,0002,000,000.002,004,152.22 4,152.2221,200.001.06% FHLMC MTN 0.800% 10/27/17 3134G7U252,500,0002,500,000.002,487,980.56-12,019.4420,000.000.80% FHLMC MTN 0.800% 5/12/17 3134G6WW915,000,00014,999,000.0014,956,933.33-42,066.67120,000.000.80% FHLMC MTN 0.850% 5/26/17 3134G6E8210,000,0009,999,500.009,985,163.89-14,336.1185,000.000.85% FHLMC MTN 0.850% 8/29/17 3134G7SP71,000,0001,000,000.001,003,026.94 3,026.948,500.000.85% January 1, 2016 11 Holdings Detail as of 1/4/2016City of South Bend Corporate Agency Asset CUSIPQuantity Tax Cost Yield Est. Income Gain/Loss Market Value Fixed IncomeGovernment Agency (continued)FHLMC MTN 1.000% 9/28/173134G7WS62,500,000 2,500,000.002,499,283.33-716.6725,000.001.00% FHLMC MTN V-A 1.000% 2/13/203134G6CT83,500, 0003,500,000.003,502,601.672,601.6735,000.001.00%FNMA 0.500% 3/30/163135G0VA83,000,0003,000,925.033,004,031.67 3,106.6415,000.000.50% FNMA 1.125% 7/20/18 3135G0E332,000,0001,998,180.002,001,902.50 3,722.5022,500.001.12% $173,954,859.45$173,762,125.19$-192,734.26$1,545,027.000.89% Total Fixed IncomeTotal Portfolio $174,908,370.17$174,715,639.47$-192,730.70$1,545,163.350.88% *Market values include accruals.January 1, 2016 12 Fixed Income Summary as of 1/4/2016City of South Bend Corporate Agency Maturity SummaryMaturity (Years) Market Value % BondHoldings 0 - 1 19,758,750.6111.4% 1 - 3 141,497,332.4681.4% 3 - 5 12,506,042.127.2% Total $173,762,125.19100.0% Asset Class AllocationSubclass Market Value % Bond Holdings Time Deposits 98,982,098.3357.0% US Treasury 4,991,685.852.9% Government Agency 69,788,341.0140.2% Total$173,762,125.19100.0% Bond Rating SummaryCredit Rating Market Value % Bond Holdings AAA 74,780,026.8643.0% NR 98,982,098.3357.0% Total $173,762,125.19100.0% Duration SummaryDuration (Years) Market Value % Bond Holdings Less than 1.00 34,770,003.7420.0% 1.00 - 3.00 128,493,512.6673.9% 3.00 - 5.00 10,498,608.796.0% Total $173,762,125.19100.0% *Market values include accruals.January 1, 2016 13 Performance Summary as of 12/31/2015City of South Bend Corporate Agency Return Details YTD1 Year3 Year Total Managed 0.72%0.72%0.51% Benchmark - 80ml1yrtr/20ml1-5treas 0.32%0.32%0.29% Benchmark - Merrill 1 Yr Treas Note 0.15%0.15%0.20% *Market values include accruals.January 20, 2016 14 City of South Bend Administration & Finance Policy Manual 2.11 Stale Dated Check Policy Effective: January 1, 2010 Purpose: This policy defines the practice and protocol for handling stale dated checks issued by the City of South Bend. Scope: This statement applies to all governmental units, enterprise operations, and operations of the City of South Bend. Responsibility: This policy is the responsibility of the Controller of the City of South Bend. Changes or revisions to this policy are affected only with the consent and approval of the Controller. Effective Date: This policy is effective January 1, 2010. 1.0 Policy Statement The City of South Bend has defined that payroll checks and account payable disbursement checks drawn on city accounts will have a two (2) year active life from the date of issuance as noted on the check. Un-cashed checks, beyond two (2) year active life period, are no longer valid and shall be classified as a stale dated check. 2.0 Responsibility Administration of the stale dated check policy is delegated by the Controller, to be the responsibility of the Director City Finance. The Director City Finance will identify the payroll and payable disbursement checks that are classified as stale dated checks, prepare such list and submit to the Controller for approval. Upon approval of the Controller, the stale dated check list will be presented to the City of South Bend Board of Finance, at the first annual Board of Finance Meeting during each calendar year, for Board of Finance vote on the stale dated check disposition recommendations as presented by the Controller. 3.0 Board of Finance Filing Requirements 3.1 The Controller shall file with the Board of Finance, documents as defined in paragraphs 3.1.1 and 3.1.2 and the Controller’s recommendation, at least 72 hours prior to the first annual Board of Finance Meeting called for each calendar year: 3.1.1 Payroll Stale Dated Checks: Proposed list of all stale dated checks recommended to be written off, identifying the check number, employee name, date of check, amount of check, fund name, fund number, and any other information deemed necessary by the Controller. 3.1.2 Account Payable Stale Dated Checks: Proposed list of all stale dated checks recommended to be written off, identifying the check number, vendor name, date of check, amount of check, fund name, fund number, and any other information deemed necessary by the Controller. 15 4.0 Board of Finance Requirements The Board of Finance shall be required to review all information filed by the Controller as referenced above and hear presentation and recommendation from the Controller or designee at the first annual Board of Finance meeting. The Board will motion, second, and vote on the recommendation as presented by the Controller with, majority in favor and supporting the recommendation of the Controller, the recommendation will be passed, and the Controller provided with the authority to execute the recommendation as approved. A copy of all guidelines shall be filed of record with the Office of the City Clerk and with the City Controller in the Department of Administration and Finance. 5.0 Other Matters Additional guidelines may be promulgated by the Board of Finance when deemed necessary. Approved 16 City of South Bend Board of Finance Annual Investment Report For the year ended December 31, 2015 Payroll Stale Dated Checks The current policy, as defined and approved by the Board of Finance, has defined that payroll checks drawn on city accounts will have a two (2) year active life from the date of issuance as noted on the check. Un- cashed checks, beyond the two (2) year active life period, are no longer valid and shall be classified as a stale dated check. Such checks, defined as stale dated, will be reported to the Board of Finance with a recommendation from the City Controller on the disposition of the stale dated checks. Therefore, the following represents the list of Stale Dated Payroll Checks as of December 31, 2015. Check # Name Date $ Amount Fund # Fund Name 395040 Brown, Nicholas D 7/5/2013 114.99 201 Parks 396029 Ramirez, Alexander 8/2/2013 36.24 201 Parks 397049 Camparone, Christopher 9/13/2013 239.39 249 PS LOIT 397602 Gresham, Vincent 9/13/2013 39.51 201 Parks 397670 Griffin, Matthew 9/13/2013 112.82 101 General Total $542.95 City Recommendation The City of South Bend recommends that such payroll checks, classified by city policy as stale dated, to be approved by the Board of Finance for cancellation. Said checks, shall be voided within the city’s payroll system and removed as a payroll liability of the City of South Bend. Indiana Statute, allowing cancellation and voidance of un-cashed payroll checks defined as stale dated, will remain subject to claim by the payee for a period of seven (7) years from date of issuance. The City will maintain record of these potential liabilities in the event a claim is made by any payee. 17 City of South Bend Board of Finance Annual Investment Report For the year ended December 31, 2015 Accounts Payable Stale Dated Checks The current policy, as defined and approved by the Board of Finance, has defined that disbursement checks drawn on city accounts will have a two (2) year active life from the date of issuance as noted on the check. Un-cashed checks, beyond the two (2) year active life period, are no longer valid and shall be classified as a stale dated check. Such checks, defined as stale dated, will be reported to the Board of Finance, with a recommendation from the City Controller on the disposition of the stale dated checks. Therefore, following represents the list of stale dated disbursement checks as of December 31, 2015. Ckeck # Name Date Amount Fund # Fund Name 439979 Wood, Barbara J 07/09/2012 11.54 620 Water Works Operations 440577 Indiana Housing & Community 07/24/2012 2,297.20 212 Dept. Community Invest. 452207 David Trout 04/09/2013 7.32 101 General 453166 Allen Davis 04/30/2013 65.58 620 Water Works Operations 453167 Joel Kirundke 04/30/2013 78.39 620 Water Works Operations 453168 Sean Pritzel 04/30/2013 53.34 620 Water Works Operations 453173 Camex Corp. 04/30/2013 58.24 620 Water Works Operation 453177 Rachel Besserra 04/30/2013 32.99 620 Water Works Operation 453179 Stephen Mndalila 04/30/2013 105.97 620 Water Works Operation 453180 Preston Moore 04/30/2013 50.96 620 Water Works Operation 453184 Kimberly Spychalski 04/30/2013 25.34 620 Water Works Operation 453185 Clarence Taylor 04/30/2013 26.86 620 Water Works Operation 453186 Lois Traustason 04/30/2013 111.67 620 Water Works Operation 453455 J Przygoda 05/07/2013 5.91 620 Water Works Operation 453978 Kippard Peters 05/21/2013 17.06 711 Benefits 454756 Savely, Stephen 06/06/2013 6.30 620 Water Works Operations 454759 Mcleod, Yakira S. 06/06/2013 18.79 620 Water Works Operations 454977 Kippard Peters 06/11/2013 7.47 711 Benefits 455714 Cristela Romo 06/25/2013 55.00 203 Recreation 457078 Bob Sullivan 07/23/2013 112.00 201 Parks 457838 Vince Gresham 08/13/2013 15.13 201 Parks 457906 Katana Forensics Inc. 08/13/2013 845.00 101 General 459115 Ohio State University 09/10/2013 90.00 101 General 460227 Harmon, H 10/01/2013 46.51 620 Water Works Operations 460997 Jack Doheny Supplies 10/22/2013 86.89 201 Parks 461284 Keith D. Peczkowski 10/29/2013 96.00 203 Recreation 461615 Ambassadors for Christ Church 11/05/2013 378.00 101/211 General and DCI 461804 Joe Vencel 11/05/2013 1,000.00 101 General 461831 Klimek, David L. 11/05/2013 11.20 620 Water Works Operations 462708 Christina Stylianou 11/26/2013 45.00 203 Recreation 462828 Wendy Noble 11/26/2013 40.00 203 Recreation 462928 Ambassadors for Christ Church 12/03/2013 378.00 101/211 General and DCI 463333 Christina Stylianou 12/10/2013 40.50 203 Recreation 463464 Bradley Management 12/10/2013 39.90 620 Water Works Operations 18 463768 Janet Billsborough 12/17/2013 73.38 620 Water Works Operations 464303 Sterling, Greg 12/27/2013 29.35 620 Water Works Operations 451644 Kaitlyn Snowden 03/27/2013 1.00 709 Payroll 458049 Sun Life Financial 08/15/2013 6,418.23 709 Payroll Total $12,782.02 City Recommendation The city recommends that such accounts payable checks, classified by city policy as stale dated, to be approved by the Board of Finance for cancellation. Said checks, shall be voided within the city’s accounts payable disbursement system and removed as a liability of the City of South Bend. Indiana Statute, allowing cancellation and voidance of un-cashed disbursement checks defined as stale dated, will remain subject to claim by the payee for a period of seven (7) years from date of issuance. The city will maintain record of these potential liabilities, in the event a claim is made by any payee. 19 City of South Bend Month of:December 2015 Controller's Cash Report` Opening Interest Transfers Transfers Ending Total Cash &Interfund Loans Fund Fund Name Cash Balance Receipts Disbursements Earned In Out Cash Balance Investments Investments(Borrowing) City Controlled Funds General Fund 101 GENERAL FUND $19,013,134.96$17,814,713.17$6,366,999.94$25,161.02$0.00$0.00$30,486,009.21$0.00$30,486,009.21$503,531.04 Special Revenue Funds 102 RAINY DAY FUND 8,692,120.72 0.00 0.00 11,300.95 0.00 0.00 8,703,421.67 0.00 8,703,421.67 0.00 103 EXCESS LEVY 3,665.38 0.00 0.00 4.77 0.00 0.00 3,670.15 0.00 3,670.15 0.00 201 PARKS & RECREATION 1,399,403.13 3,417,080.83 893,546.41 2,054.35 0.00 0.00 3,924,991.90 0.00 3,924,991.90 0.00 202 MOTOR VEHICLE HIGHWAY 6,148,336.15 520,730.86 1,451,676.31 8,295.03 0.00 0.00 5,225,685.73 0.00 5,225,685.73 0.00 203 RECREATION - NONREVERTING 840,951.40 44,305.21 62,377.75 1,084.74 0.00 0.00 823,963.60 0.00 823,963.60 0.00 209 STUDEBAKER/OLIVER REVERTING GRANTS 1,098,255.50 22,003.28 13,041.00 1,424.50 0.00 0.00 1,108,642.28 0.00 1,108,642.28 500,000.00 210 DEPT COMMUNITY INVESTMENT STATE GRANTS 394,188.45 156,299.34 390,636.07 509.69 0.00 0.00 160,361.41 0.00 160,361.41 0.00 211 DCI OPERATING FUND 1,372,559.39 9,826.72 260,517.34 1,883.97 0.00 0.00 1,123,752.74 0.00 1,123,752.74 0.00 212 DEPARTMENT OF COMMUNITY INVESTMENT 612,917.50 299,067.14 358,292.34 182.83 0.00 0.00 553,875.13 0.00 553,875.13 0.00 216 POLICE STATE SEIZURES 202,850.10 0.00 3,116.00 263.74 0.00 0.00 199,997.84 0.00 199,997.84 0.00 217 GIFT, DONATION, BEQUEST 64,021.26 2,203.00 1,349.29 83.04 0.00 0.00 64,958.01 0.00 64,958.01 0.00 218 POLICE CURFEW VIOLATIONS 12,225.37 12.50 0.00 15.88 0.00 0.00 12,253.75 0.00 12,253.75 0.00 220 LAW ENFORCEMENT CONTINUING EDUCATION 906,352.06 14,367.45 9,777.50 1,169.39 0.00 0.00 912,111.40 0.00 912,111.40 0.00 227 LOSS RECOVERY FUND 1,100,820.42 71,970.11 179,746.14 1,497.70 0.00 0.00 994,542.09 0.00 994,542.09 0.00 244 EMERGENCY TELEPHONE SYSTEM 33,670.74 0.00 0.00 0.00 0.00 0.00 33,670.74 0.00 33,670.74 0.00 249 PUBLIC SAFETY L.O.I.T.899,505.58 568,657.92 826,176.26 783.05 0.00 0.00 642,770.29 0.00 642,770.29 0.00 251 LOCAL ROADS & STREETS 2,583,954.08 166,680.80 23,102.17 3,391.95 0.00 0.00 2,730,924.66 0.00 2,730,924.66 0.00 252 EXCESS WELFARE DISTRIBUTION 8.07 0.00 0.00 0.00 0.00 0.00 8.07 0.00 8.07 0.00 258 HUMAN RIGHTS - FEDERAL GRANT 440,498.64 2,540.03 86,637.85 553.29 0.00 0.00 356,954.11 68,896.24 425,850.35 0.00 271 EASTRACE WATERWAY 1,335.05 0.00 0.00 1.73 0.00 0.00 1,336.78 0.00 1,336.78 0.00 273 MORRIS PAC/PALAIS ROYALE MARKETING 29,986.67 1,244.25 877.50 37.84 0.00 0.00 30,391.26 0.00 30,391.26 0.00 280 POLICE BLOCK GRANTS 3,850.17 0.00 0.00 5.01 0.00 0.00 3,855.18 0.00 3,855.18 0.00 281 DEPT. COMMUNITY INVESTMENT - REV BONDS 27,361.96 0.00 0.00 35.57 0.00 0.00 27,397.53 0.00 27,397.53 0.00 289 HAZMAT 32,062.47 0.00 0.00 41.69 0.00 0.00 32,104.16 0.00 32,104.16 0.00 291 INDIANA RIVER RESCUE 73,552.30 22,150.00 230.80 97.63 0.00 0.00 95,569.13 0.00 95,569.13 0.00 292 POLICE GRANTS 128,520.30 0.00 7,324.50 0.00 0.00 0.00 121,195.80 0.00 121,195.80 0.00 294 REGIONAL POLICE ACADEMY 69,910.86 750.00 442.64 91.61 0.00 0.00 70,309.83 0.00 70,309.83 0.00 295 COPS MORE GRANT 121,550.02 400.00 400.00 165.46 0.00 0.00 121,715.48 0.00 121,715.48 0.00 299 POLICE FEDERAL DRUG ENFORCEMENT 252,686.52 0.00 0.00 65.02 0.00 0.00 252,751.54 0.00 252,751.54 0.00 404 COUNTY OPTION INCOME TAX 12,510,195.89 1,127,112.39 1,553,293.61 16,651.96 0.00 0.00 12,100,666.63 0.00 12,100,666.63 1,589,770.50 408 ECONOMIC DEVELOPMENT INCOME TAX 9,295,300.14 765,100.50 184,872.33 11,369.80 0.00 0.00 9,886,898.11 0.00 9,886,898.11 0.00 410 URBAN DEVELOPMENT ACTION GRANT (UDAG)922,157.13 0.00 292,135.00 1,198.93 0.00 0.00 631,221.06 0.00 631,221.06(1,589,770.50) 655 PROJECT RELEAF 893,866.35 52,273.42 23,871.14 1,171.14 0.00 0.00 923,439.77 0.00 923,439.77 0.00 705 POLICE K-9 UNIT 3,868.89 0.00 0.00 5.03 0.00 0.00 3,873.92 0.00 3,873.92 0.00 Total Special Revenue Funds 51,172,508.66 7,264,775.75 6,623,439.95 65,437.29 0.00 0.00 51,879,281.75 68,896.24 51,948,177.99 500,000.00 Debt Service Fund 313 HALL OF FAME DEBT SERVICE (612,830.59)632,424.70 8,197.78 0.00 0.00 0.00 11,396.33 0.00 11,396.33 0.00 Capital Project Funds 377 PROFESSIONAL SPORTS DEVELOPMENT 427,424.31 0.00 0.00 506.25 0.00 0.00 427,930.56 0.00 427,930.56 0.00 401 COVELESKI STADIUM CAPITAL 82,554.05 0.00 0.00 107.33 0.00 0.00 82,661.38 0.00 82,661.38 0.00 403 ZOO ENDOWMENT 49,445.68 0.00 0.00 64.29 0.00 0.00 49,509.97 0.00 49,509.97 0.00 405 PARK NONREVERTING CAPITAL 469,770.83 32.00 0.00 532.31 0.00 0.00 470,335.14 0.00 470,335.14 0.00 406 CUMULATIVE CAPITAL DEVELOPMENT 380,209.98 192,003.36 0.00 491.12 0.00 0.00 572,704.46 0.00 572,704.46 0.00 407 CUMULATIVE CAPITAL IMPROVEMENT 175,074.59 136,334.34 0.00 227.62 0.00 0.00 311,636.55 0.00 311,636.55 0.00 412 MAJOR MOVES CONSTRUCTION 2,235,760.36 0.00 79,032.92 3,069.14 0.00 0.00 2,159,796.58 0.00 2,159,796.58 5,071,712.83 416 MORRIS PERFORMING ARTS CENTER CAPITAL 515,340.53 10,022.00 8,631.00 666.95 0.00 0.00 517,398.48 0.00 517,398.48 0.00 2015 December. controllers cash report - Controllers Cash Report 20 City of South Bend Month of:December 2015 Controller's Cash Report` Opening Interest Transfers Transfers Ending Total Cash &Interfund Loans Fund Fund Name Cash Balance Receipts Disbursements Earned In Out Cash Balance Investments Investments(Borrowing) 434 CRED FUND 2,373.49 0.00 0.00 30.34 0.00 0.00 2,403.83 0.00 2,403.83 0.00 450 PALAIS ROYALE HISTORIC PRESERVATION 75,753.62 661.34 0.00 98.03 0.00 0.00 76,512.99 0.00 76,512.99 0.00 677 HALL OF FAME CAPITAL FUND 505,692.54 0.00 2,821.15 659.65 0.00 0.00 503,531.04 0.00 503,531.04(503,531.04) Total Capital & Debt Service Funds 4,306,569.39 971,477.74 98,682.85 6,453.03 0.00 0.00 5,185,817.31 0.00 5,185,817.31 4,568,181.79 Enterprise Funds 287 EMS CAPITAL 2,572,244.49 0.00 0.00 3,344.25 0.00 0.00 2,575,588.74 0.00 2,575,588.74 0.00 288 EMS OPERATING 2,360,194.36 584,322.72 731,140.08 3,621.37 0.00 0.00 2,216,998.37 0.00 2,216,998.37 0.00 600 CONSOLIDATED BUILDING DEPARTMENT 2,132,712.86 180,345.06 419,398.93 2,818.93 0.00 0.00 1,896,477.92 0.00 1,896,477.92 0.00 601 PARKING GARAGES 1,075,842.08 67,071.76 502,871.80 1,409.01 0.00 0.00 641,451.05 0.00 641,451.05 0.00 610 SOLID WASTE OPERATIONS 282,982.32 520,193.71 437,769.79 407.37 0.00 46,000.00 319,813.61 0.00 319,813.61 0.00 611 SOLID WASTE CAPITAL 133.10 0.00 45,690.13 0.31 46,000.00 443.28 0.00 443.28 0.00 620 WATER WORKS OPERATIONS 4,289,389.33 1,268,296.00 1,501,121.99 5,109.26 8,847.35 170,275.00 3,900,244.95 0.00 3,900,244.95 0.00 622 WATER WORKS CAPITAL 2,880,412.59 0.00 0.00 3,744.93 0.00 0.00 2,884,157.52 0.00 2,884,157.52 0.00 624 WATER WORKS CUSTOMER DEPOSIT 1,508,755.14 23,551.34 18,221.34 1,959.82 0.00 1,959.82 1,514,085.14 0.00 1,514,085.14 0.00 625 WATER WORKS SINKING FUND 1,511,700.56 0.00 1,677,564.70 1,884.71 170,275.00 1,884.71 4,410.86 0.00 4,410.86 0.00 626 WATER WORKS BOND RESERVE 1,641,654.34 0.00 0.00 2,095.60 0.00 2,095.90 1,641,654.04 0.00 1,641,654.04 0.00 629 WATER WORKS RESERVE - O & M 2,235,266.68 0.00 0.00 2,906.92 0.00 2,906.92 2,235,266.68 0.00 2,235,266.68 0.00 640 SEWER REPAIR INSURANCE 1,655,552.53 51,840.04 57,058.61 2,159.80 0.00 0.00 1,652,493.76 0.00 1,652,493.76 0.00 641 SEWAGE WORKS OPERATIONS 8,584,030.03 3,016,216.60 1,830,830.80 10,401.11 4,784.02 760,892.65 9,023,708.31 0.00 9,023,708.31 0.00 642 SEWAGE WORKS CAPITAL 9,304,228.96 0.00 568,724.84 12,218.89 0.00 0.00 8,747,723.01 0.00 8,747,723.01 0.00 643 SEWAGE WORKS RESERVE - O & M 3,678,649.42 0.00 0.00 4,784.02 0.00 4,784.02 3,678,649.42 0.00 3,678,649.42 0.00 649 SEWAGE WORKS BOND SINKING 6,243,545.93 0.00 6,209,221.26 9,580.63 760,892.65 0.00 804,797.95 0.00 804,797.95 0.00 653 SEWAGE WORKS DEBT SERVICE RESERVE 7,286,831.50 0.00 3,181,210.98 3.11 0.00 0.00 4,105,623.63 0.00 4,105,623.63 0.00 659 2011 SEW ER BOND 231,696.58 0.00 0.00 499.83 0.00 0.00 232,196.41 0.00 232,196.41 0.00 661 2012 SEW ER BOND 14,134,365.05 0.00 224,758.56 18,542.66 0.00 0.00 13,928,149.15 0.00 13,928,149.15 0.00 664 2013 SEW ER REFUND BOND 4,506.31 0.00 0.00 5.86 0.00 0.00 4,512.17 0.00 4,512.17 0.00 666 2015 SEW ER BOND 0.00 88,231.33 30,000.00 0.00 0.00 0.00 58,231.33 0.00 58,231.33 0.00 670 CENTURY CENTER 1,320,391.64 751,818.56 975,317.83 0.00 0.00 0.00 1,096,892.37 0.00 1,096,892.37 0.00 671 CENTURY CENTER CAPITAL 1,001,986.89 0.00 0.00 85.11 0.00 0.00 1,002,072.00 0.00 1,002,072.00 0.00 672 CENTURY CENTER ENERGY SAVINGS 50,027.67 0.00 0.00 4.25 0.00 0.00 50,031.92 0.00 50,031.92 0.00 Total Enterprise Funds 75,987,100.36 6,551,887.12 18,410,901.64 87,587.75 990,799.02 990,799.02 64,215,673.59 0.00 64,215,673.59 0.00 Internal Service Funds 222 CENTRAL SERVICES 1,462,060.74 863,527.82 993,488.24 1,452.73 0.00 0.00 1,333,553.05 0.00 1,333,553.05 0.00 224 CENTRAL SERVICES CAPITAL 210,241.05 0.00 23,351.55 273.35 0.00 0.00 187,162.85 0.00 187,162.85 226 LIABILITY INSURANCE 4,596,330.45 101,897.25 172,105.00 5,937.42 0.00 0.00 4,532,060.12 0.00 4,532,060.12 0.00 278 TAKE HOME VEHICLE POLICE 628,029.50 13,460.00 0.00 818.07 0.00 0.00 642,307.57 0.00 642,307.57 0.00 711 SELF-FUNDED EMPLOYEE BENEFITS 4,633,214.12 1,057,579.48 1,323,306.74 7,234.03 0.00 0.00 4,374,720.89 0.00 4,374,720.89 0.00 713 UNEMPLOYMENT COMP FUND 266,669.69 8,473.38 5,852.01 341.85 0.00 0.00 269,632.91 0.00 269,632.91 0.00 Total Internal Service Funds 11,796,545.55 2,044,937.93 2,518,103.54 16,057.45 0.00 0.00 11,339,437.39 0.00 11,339,437.39 0.00 Trust & Agency Funds 701 FIREFIGHTERS PENSION 922,917.36 0.00 451,637.94 1,639.55 0.00 0.00 472,918.97 0.00 472,918.97 0.00 702 POLICE PENSION 1,664,948.43 0.00 508,743.52 2,720.91 0.00 0.00 1,158,925.82 0.00 1,158,925.82 0.00 709 PAYROLL FUND 0.00 11,086,706.27 11,086,706.27 0.00 0.00 0.00 0.00 0.00 0.00 0.00 718 STATE TAX DEDUCTION FUND 260,592.68 412,690.08 260,592.68 0.00 0.00 0.00 412,690.08 0.00 412,690.08 0.00 725 MORRIS / PALAIS BOX OFFICE 1,572,223.80 0.00 67,766.16 0.00 0.00 0.00 1,504,457.64 0.00 1,504,457.64 0.00 726 POLICE DISTRIBUTIONS PAY 837,712.24 0.00 2,604.34 0.00 0.00 0.00 835,107.90 0.00 835,107.90 0.00 730 CITY CEMETERY TRUST 28,541.76 0.00 0.00 37.11 0.00 0.00 28,578.87 0.00 28,578.87 0.00 2015 December. controllers cash report - Controllers Cash Report 21 City of South Bend Month of:December 2015 Controller's Cash Report` Opening Interest Transfers Transfers Ending Total Cash &Interfund Loans Fund Fund Name Cash Balance Receipts Disbursements Earned In Out Cash Balance Investments Investments(Borrowing) Total Trust & Agency Funds 5,286,936.27 11,499,396.35 12,378,050.91 4,397.57 0.00 0.00 4,412,679.28 0.00 4,412,679.28 0.00 Total City Funds 167,562,795.19 46,147,188.06 46,396,178.83 205,094.11 990,799.02 990,799.02 167,518,898.53 68,896.24 167,587,794.77 5,571,712.83 Redevelopment Commission Controlled Funds Tax Increment Financing Funds 324 TIF RIVER WEST - AIRPORT 28,682,587.30 7,991,886.50 3,947,846.02 40,764.38 3,608.51 0.00 32,771,000.67 0.00 32,771,000.67(500,000.00) 422 TIF DISTRICT - WEST WASHINGTON 1,368,237.38 207,045.03 68,275.50 1,778.97 0.00 0.00 1,508,785.88 0.00 1,508,785.88 0.00 425 TIF LEIGHTON PLAZA 209,856.58 14,676.57 15,716.88 214.51 0.00 0.00 209,030.78 0.00 209,030.78 0.00 429 TIF RIVER EAST DEV (NE)7,177,472.88 1,030,295.80 646,126.74 9,332.14 0.00 0.00 7,570,974.08 0.00 7,570,974.08 0.00 430 TIF SOUTHSIDE DEVELOPMENT AREA #1 5,191,350.63 906,847.80 1,646.59 6,761.44 0.00 0.00 6,103,313.28 0.00 6,103,313.28 0.00 432 TIF SSDA #3 - ERSKINE VILLAGE 5,855,814.07 7,692.47 561,092.69 6,883.86 0.00 0.00 5,309,297.71 0.00 5,309,297.71 0.00 435 TIF DOUGLAS ROAD 44,990.42 106,813.87 0.00 58.49 0.00 0.00 151,862.78 0.00 151,862.78(635,520.00) 436 TIF RIVER EAST RES (NE RE) 156,017.61 1,466,109.03 0.00 0.00 0.00 0.00 1,622,126.64 0.00 1,622,126.64(4,436,192.83) Total Tax Increment Financing Funds 48,686,326.87 11,731,367.07 5,240,704.42 65,793.79 3,608.51 0.00 55,246,391.82 0.00 55,246,391.82(5,571,712.83) Redevelopment Funds 433 REDEVELOPMENT ADMINISTRATION GENERAL 8,701.46 0.00 0.00 11.88 0.00 0.00 8,713.34 0.00 8,713.34 0.00 439 CERTIFIED TECHNOLOGY PARK 2,357,813.82 114,911.00 199,541.50 3,082.53 0.00 0.00 2,276,265.85 0.00 2,276,265.85 0.00 454 AIRPORT URBAN ENTERPRISE ZONE 379,621.63 0.00 0.00 493.56 0.00 0.00 380,115.19 0.00 380,115.19 0.00 Total Redevelopment Funds 2,746,136.91 114,911.00 199,541.50 3,587.97 0.00 0.00 2,665,094.38 0.00 2,665,094.38 0.00 Debt Service Funds 315 AIRPORT 2003 DEBT RESERVE 1,038,904.00 0.00 0.00 1,351.08 0.00 1,351.08 1,038,904.00 0.00 1,038,904.00 0.00 317 COVELESKI BOND DEBT RESERVE 507,820.03 0.00 0.00 660.24 0.00 0.00 508,480.27 0.00 508,480.27 0.00 328 SBCDA 2003 DEBT RESERVE 1,735,840.00 0.00 0.00 2,257.43 0.00 2,257.43 1,735,840.00 0.00 1,735,840.00 0.00 0.00 Total Debt Service Funds 3,282,564.03 0.00 0.00 4,268.75 0.00 3,608.51 3,283,224.27 0.00 3,283,224.27 0.00 Total Redevelopment Commission Funds 54,715,027.81 11,846,278.07 5,440,245.92 73,650.51 3,608.51 3,608.51 61,194,710.47 0.00 61,194,710.47(5,571,712.83) City Operations Total 222,277,823.00 57,993,466.13 51,836,424.75 278,744.62 994,407.53 994,407.53 228,713,609.00 68,896.24 228,782,505.24 0.00 Memo Item Pooled Investment Account Opening Interest Accrued Change in Transfer In Transfer out Investment Total Cash & Balance Net of Fees Income Asset Value from Depository to Depository Balance Investments 1st Source Bank Investment Account 175,023,087.14 70,584.85 0.00(446,798.97)0.00 265,414.63 174,381,458.39 174,381,458.39 2015 December. controllers cash report - Controllers Cash Report 22 City of South Bend, Indiana Interest Earnings Summary - 2015 December 31, 2015 Prepared - January 20, 2016 1st Source 1st Source Paid Investment Checking Other Total Month Month Interest Interest Interest (1)Interest Dec-14 Jan-15$56,126$9,553$131,579$197,258 Jan-15 Feb-15 37,541 10,885 121,074$169,500 Feb-15 Mar-15 67,428 7,768 503$75,698 Mar-15 Apr-15 108,562 7,345 2,547$118,454 Apr-15 May-15 56,638 6,502 2,442$65,582 May-15 Jun-15 206,658 6,035 10,501$223,194 Jun-15 Jul-15 135,249 11,552 281$147,082 Jul-15 Aug-15 35,444 16,105 116,386$167,935 Aug-15 Sep-15 124,049 13,128 207$137,385 Sep-15 Oct-15 93,648 11,571 198$105,416 Oct-15 Nov-15 66,840 11,876 4,926$83,642 Nov-15 Dec-15 265,415 9,856 3,020$278,291 $1,253,598$122,176$393,663$1,769,437 (1) interest on DCI loans, Major Moves interfund loans, Key Bank accounts, Bank of New York Mellon accounts. 23 Interest Earnings 2002 Actual$1,296,410 2003 Actual 861,968 2004 Actual 1,357,297 2005 Actual 3,392,461 2006 Actual 5,132,272 2007 Actual 7,010,895 2008 Actual 6,281,342 2009 Actual 1,348,289 2010 Actual 809,279 2011 Actual 643,643 2012 Actual 1,474,283 2013 Actual 1,119,139 2014 Actual 1,025,058 2015 Actual 1,769,437 Total 2002-2015$33,521,772 The City of South Bend earns interest on checking account balances,certificates of deposit,repayment of loans on economic development projects and short-term investments.In May 11,2011,the City opened a new investment account with 1st Source Bank in the amount of$150,000,000.Investment earnings are reported net of fees.Investment earnings are recorded in the general ledger on a cash basis when realized and do not reflect changes in asset value and accrued interest until the investment is sold or matures.Interest is also earned on advances from the Major Moves Fund to the Northeast Residental and Douglas Road TIF Funds.In January 2013,the Board of Finance increased the authorized investment amount at 1st Source Bank to $175,000,000. Meetings are held quarterly with the investment staff of 1st Source Bank. $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 $8,000,000 2002 Actual 2003 Actual 2004 Actual 2005 Actual 2006 Actual 2007 Actual 2008 Actual 2009 Actual 2010 Actual 2011 Actual 2012 Actual 2013 Actual 2014 Actual 2015 Actual Interest Earnings 2002-2015 24 City of South Bend, IndianaInterest Earnings Summar y Years 2002 through 2014December 31, 2015 Updated - January 20, 2016 Fund Fund 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 Numbe r Name Actual Actual A ctual A ctual A ctual A ctual A ctual Actual A ctual A ctual A ctual A ctual A ctual A ctual 101General Fund $405,523$217,817$210,697$792,662$1,525,832$2,456,361$1,576,724$130,034$50,536$56,303$99,725$81,117$74,513$146,438102Rainy Day Fund0026,96774,033105,664102,063159,36226,06528,53224,47742,23929,52429,47361,234103Excess Levy00013,82010,148074228539526100023201Parks & Recreation1,3367154,11015,94204,93712,9105919,4238,46714,80212,0828,07513,649202Motor Vehicle Highway2,735862,0353,8344,5761440,01421,06611,0995,3147,43111,79112,30034,302203Recreation - Non Reverting3,6414,0746,52514,68411,18322,18120,9046,2232,8992,0063,3322,6922,8936,075209Studebaker/Oliver Grants 000025,51644,98363,97516,4136,4014,4865,4853,7123,7057,750210Econ Dev State Grants4,745002,45733,945262,672136,850103,21389,74413,01664,33260,70315,03311,236211DCI Administration 0000000001,6253,0572,6103,2467,938212DCI Grants3,4432,5213,0956,45261,934105,38059,65911,2415,7603,1472,5782,1522,0381,972216State Seized Drug Money 000000003513366534985641,368 217Gift, Donation, Bequest 00000000102112287232462592 218SBPD Curfew Violations 00000000292852384085 220Law Enforcement Cont. Education 00003,6986,6019,9415,9303,1742,9905,1943,4913,3946,715 222Central Services 000000009721,9174,6883,4213,9508,574 224Central Services Capital 0000000000000322226Liability Insurance9,71712,93627,59657,35987,86497,52995,12321,77012,95411,06823,37618,59717,71235,042227Loss Recovery Fund 000000022,18716,05712,54521,89418,68525,71724,843 244Emergency Telephone System 000000000000019 249Public Safety LOIT Fund 000000004,7412,3088,2966,9545,1686,209 250General Grant 0000001,16031915 00000251Local Roads & Streets16,3446,64919,30052,91052,07743,24983,88423,3958,7106,0317,3066,2477,58518,729252Excess Welfare Distribution 0000000017,8086,5455,407440258Human Rights - Federal Grant4142,4865,30311,44710,99110,1499,3282,7461,6061,4042,2791,5931,7432,960271Eastrace Waterway9105766191,4281,0451,3381,1942841187899493522272Special Events91057672284210 000000000 273Morris/Palais Marketing Fund 000000908647601229590198 278Police Take Home Liability 000000008718331,8281,4351,7054,062 280Police Block Grants9,3035,1434,0114,8061,255002822,0313,433459131327281Economic Revenue Bond 0000000088761339393193 287EMS Capital Fund 00000000000006,860288EMS Operating Fund2,3265,3108,34623,07937,83332,04747,13424,89117,43815,12130,05116,45014,96422,372289Hazmat 00000000218134086231 291Indiana River Rescue 00000000269195408368361618 292Police Grants Fund 000000000000055294Regional Police Academy001,0742,6781,5601,3521,351481285231399268262480295COPS More Grant 00000000418323492364380778 299Federal Drug Enforcement 00002,6388,18714,1772,856981724941947978975305SBCDA Bond Proceeds 200316,39012,560210,112334,547278,555191,225188,93934,1718,8322,657 0000 310Studebaker Bond0003,685 0000000000 312Redevelopment Bond Wayne Street11,6158,2478,4732,700 0000000000 313Hall of Fame Debt Service00010,388 00000000041314Redev Bond 199012,6689,35911,15127,48837,79737,25630,5897,1363,0272,3733,009000315Redev Bond - Airport - Taxable14,13410,28207,75935,11360,09961,56416,9497,0905,5385,5713,5673,5487,340316Redev Bond - Airport - Exempt6,7454,848377 00000000000 317Coveleski Bond Debt Service Reserve 0000000001,2772,4701,7251,7223,577 319Blackthorn Debt Service15,46712,53314,87333,58944,20043,56736,4708,7423,6272,8274,42046400320Edit Bond - Plaza Garage-Exempt9,9716,9348,46217,39220,739 000000000 321Edit Bond - Plaza Garage-Taxable9,6646,7218,20216,85720,102 000000000324TIF Revenue - Airport30,70833,13668,642305,809606,063611,747719,473143,20290,26868,38180,26061,70785,249255,183328Redev Bond - Palais Royale5,380004,42820,03136,32435,2259,7684,0533,1598,2585,9595,92912,263377Professional Sports Development7,5314,2255,54015,70221,24123,70617,8924,8783,6693,4155,0252,7421,9632,947401Coveleski Stadium Capital5,4515,0286,5069,9744,7049,0157,4621,5943702623279298358403Zoo Endowment 000033588089725011397211168168348404COIT114,650119,802146,338198,693226,073147,718143,48549,03550,03337,97369,19550,20350,003100,599405Park Nonreverting Capital1,8171,4563,9417,9775,00013,4658,3322,5021,3191,0201,7721,3861,3843,120406Cumulative Capital Development16,43612,97118,15849,28570,35165,64837,1247,3733,2671,7693,8082,7012,1563,051407Cumulative Capital Improvement2261,714453505000574536151222271,042408EDIT33,03926,72120,59721,94533,45053,97132,2319,60018,95222,13545,53133,10034,39969,484410UDAG2,1982,1021,5993,897155,290156,013144,85330,48014,1702,65991788942,306412Major Moves Construction (1) 000063,519744,851463,752113,90836,18077,860394,379261,868253,216252,281414TIF District - Sample/Ewing4,9834,5825,2925,8338,19112,1635,876 0000000416Morris PAC Capital5816771,4754,4027,31810,0498,8112,3851,4341,5031,9971,4121,6513,642420TIF District - SBCDA General32,61814,22127,67294,991131,554109,284126,07313,56915,0029,21745,91359,68342,5330422TIF District - W. Washington4385019709,88412,07013,57413,0291,1171,9593,1413,9201,4352,5028,903424TIF SBCDA-Building Operations 00001,514 000000000425TIF - Leighton Plaza0002752,3871,1173,9761,0374883343832983061,071426TIF - Cent. Med Serv Area003,85627,33937,49531,71952,51914,71115,94810,02816,84112,2428,3080427Redevelopment - TJX06,587 000000000000 Dept. Administration/Finance 25 City of South Bend, IndianaInterest Earnings Summar y Years 2002 through 2014December 31, 2015 Updated - January 20, 2016 Fund Fund 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 Numbe r Name Actual Actual A ctual A ctual A ctual A ctual A ctual Actual A ctual A ctual A ctual A ctual A ctual A ctual 428Red Dist Capital - AEDA2003 0 0126,419194,558177,528 48,069 10,213 2,725 1,202 00000 429Northeast Development Area TIF 0000002333763451,040 5,286 8,057 11,381 44,638 430Southside TIF Area #1 00000001,786 8,816 10,154 19,939 17,222 12,462 34,652 431Southside TIF #2 - Erskine Commons 00000001,647 10,074 4,029 2,329 0 0 0 432Southside TIF #3 - Erskine Village 00000002,238 11,905 13,192 27,801 18,842 20,575 38,457 433Redevelopment Admin General 2,134 1,532 1,557 3,679 5,367 3,581 2,822 669 214 107 164 104 51 70 434CRED 0 0 0 22,425 70,155 82,537 67,563 8,287 3,214 1,507 1,259 418 301 360 435Douglas Road TIF 00000000756246723454685606 436Northeast Residential TIF 000000001,478 2,266 10,211 8,423 3,380 1,571 438Coveleski Bond Construction 0000000005,268 0000 439Certified Technology Park 00000000003,571 7,207 12,682 28,205 450Palais Royale Historic Preservation 000000136271124118247215195488 454Airport Urban Enterprise Zone 000000007414731,323 1,289 1,287 2,674 600Building Department 2,166 1,590 1,662 3,159 1,557 791 1,440 674 129 113 380 667 1,354 9,357 601Parking Garages 0000099001,207 2,112 4,124 2,408 3,407 7,543 610Solid Waste Operations 0 3,420 9,917 13,562 6,024 2,313 1,347 0 2,854 3,363 5,359 2,996 1,765 2,578 611Solid Waste Capital 4,720 6,900 5,654 2,527 0000234210279469169114 620Water Works Operations 0 0 4,199 16,705 0 24,504 66,840 19,115 6,735 4,545 10,309 6,453 11,007 30,010 621WW SRLF Eq Repl Cost 0 1,492 1,030 00000000000 622Water Works Capital 6,028 19,015 12,121 4,728 0 18,885 13,230 4,240 1,977 1,909 6,523 13,709 11,944 21,149 623WW 1997 Bond Capital 42,322 58,644 14,492 0104,552103,801 1,401 0 10,555 1,764 11,241 16,550 1,731 544 624Water Works Customer Deposit 23,275 14,037 18,675 42,571 56,031 55,497 47,733 11,514 4,960 3,971 6,864 4,861 4,997 10,564 625WW 1993 Sinking Fund 41,628 9,710 0 55,524 65,651 57,907 50,215 4,094 5,260 4,581 3,961 2,064 2,535 6,268 626Water Works Bond Reserve 000000001626063,221 4,767 5,391 8,258 628WW SRLF Rev Bd Reserve 28,516 0000000000000 629WW Resv O&M Fund 28,712 17,524 22,441 51,489 70,518 71,887 60,947 15,165 8,691 7,206 9,729 6,927 7,079 15,609 640Sewer Repair Insurance 851 1,187 1,004 1,529 145 5,967 6,164 2,314 1,710 2,179 5,003 4,204 4,907 11,145 641Sewage Works Operations 0 0 8,743 41,178 68,139221,041282,825 68,581 24,711 19,879 16,545 16,604 20,498 58,066 642Sewage Works Capital 41,628 9,710 0 55,524 80,013 75,937 5,673 2,687 1,577 13,101 46,026 26,316 17,278 46,366 643Sewage Works Resv - O&M 50,135 33,892 43,577 93,871124,089140,000118,399 27,752 10,034 8,429 15,457 11,036 11,635 25,652 644Sewer Water Leak Ins. Fund 00001,604 1,161 464 0000000 6452004-2006 Sewer Bonds 0 0 39,942232,890235,216 97,408 1,868 0 97 12 0000 646Sewage Rev Bond Reserve 20,593 12,058 14,714 00000000000 6472007 Sewer Bond 00000202,306278,351 36,998 3,595 1,352 202 42 3 3 649Sewage Works Bond Sinking 50,268 14,642 11,027 22,438 44,831 29,886 129 0 6,167 6,987 14,736 10,232 12,563 30,784 650Clay Sewage Works Operations 16,055 11,787 14,070 31,648 43,527 44,421 38,408 8,481 223200 6512007B Sewer Bond 000000469,876142,314 30,308 2,989 575 69 0 0 653Sewage Works Debt Service Reserve 0000000014,267 4,901 30,127 3 3 3 655Project ReLeaf 000000002,312 2,111 4,230 2,914 3,642 7,334 656Sewage SRLF Rev BD Resv 37,669 22,055 26,915 00000000000 657Sewg SRLF EP Repl Cost Resv 39,391 29,869 38,028 83,441 11,580 000000000 6582010 Sewer Bond 00000000018,528 4,348 216 6 0 6592011 Sewer Bond 0000000008,738 91,421 30,970 20,589 5,103 6612012 Sewer Bond 0000000000065,016 60,972110,899 6642013A Sewer Bonds Refunds 0000000000071532 670Century Center 4,013 2,359 551 279 916 972 8,736 21,304 7,288 1,839 228 3,079 0 0 671Century Center Capital 0000000000365315328809 672Century Center Energy Savings Bond 000000000000032 677Hall of Fame Capital 0000022,317 24,403 6,277 4,024 2,910 3,906 2,416 2,145 3,767 701Fire Pension 16,161 13,522 17,393 36,175 28,062 11,298 33,589 6,346 5,532 4,330 4,740 2,918 1,690 3,275 702Police Pension 16,544 12,567 15,595 26,822 23,695 3,949 44,011 8,639 7,340 5,510 6,904 5,432 3,308 5,842 705K-9 Unit 0000000046117825 711Self-Funded Employee Benefits 8,999 0 14,667 61,414 91,183110,237169,758 50,616 34,807 27,732 42,730 25,351 18,112 34,136 713Unemployment Comp Fund 000000000811015248221,747 730City Cemetery Trust 545 360 465 1,106 828 1,690 1,474 357 150 118 202 138 118 201 Total Interest $1,296,410 $861,968 $1,357,297 $3,392,461 $5,132,272 $7,010,895 $6,281,342 $1,348,289 $809,279 $643,643 $1,474,283 $1,119,139 $1,025,058 $1,769,437 (1) includes NE TIF and Douglas Road TIF repayment of interest on advances from Major Moves.Dept. Administration/Finance 26 City of South Bend Administration & Finance Policy Manual 2.3.1 Cash Reserve Procedure Effective: January 1, 2010 Revised January 1, 2013, January 1, 2014 and January 1, 2016 Purpose: This procedure defines the cash reserve practices for the City of South Bend. Scope: This statement applies to all governmental units, enterprise operations, and operations of the City of South Bend. Responsibility: This policy is the responsibility of the Controller of the City of South Bend. Changes or revisions to this policy are affected only with the consent and approval of the Controller. Effective Date: This policy is effective January 1, 2010 and revised January 1, 2013, January 1, 2014 and January 1, 2016 1.0 Procedure Statement The City of South Bend has established the following cash reserve guidelines. Cash reserves are defined as cash balances on hand less outstanding encumbrances. Fund Fund Name Cash Reserve Policy 101 General Fund 30% of annual expenditures 102 Rainy Day Fund 3% contingency of total expenditures in prior year 103 Excess Levy Fund No reserve requirement 201 Parks & Recreation Fund 25% of annual expenditures 202 Motor Vehicle Highway Fund 25% of annual expenditures 203 Recreation – Nonreverting Fund 25% of annual expenditures 209 Studebaker/Oliver Reverting Grants Fund No reserve requirement 210 Department of Community Investment State Grants Fund No reserve requirement 211 Department of Community Investment Administration Fund 25% of annual expenditures 216 Police State Seizures Fund 25% of annual expenditures 217 Gift, Donation, Bequest Fund No reserve requirement 218 Police Curfew Violations Fund 25% of annual expenditures 219 Unsafe Building Fund 25% of annual expenditures 220 Law Enforcement Continuing Education Fund 25% of annual expenditures 222 Central Services Fund 25% of annual expenditures, excluding utilities 224 Central Services Capital Fund No reserve requirement 226 Liability Insurance Fund 50% of annual expenditures 227 Loss Recovery Fund No reserve requirement 244 Emergency Telephone Fund No reserve requirement 249 Public Safety LOIT Fund 8% of annual expenditures – 1 month of expenditures 27 Fund Fund Name Cash Reserve Policy 251 Local Roads & Streets Fund 25% of annual expenditures 252 Excess Welfare Distribution Fund No reserve requirement 258 Human Rights – Federal Grants Fund 25% of annual expenditures 271 Eastrace Waterway Fund No reserve requirement 273 Morris Performing Arts Center/Palais Royale Marketing Fund 25% of annual expenditures 278 Take Home Vehicle Police Fund 25% of annual expenditures 279 311 Call Center Fund No reserve requirement 280 Police Block Grants Fund No reserve requirement 281 Economic Development Commission – Revenue Bonds Fund No reserve requirement 287 EMS Capital Fund 25% of annual expenditures 288 EMS Operating Fund 25% of annual expenditures 289 HAZMAT Fund 25% of annual expenditures 291 Indiana River Rescue Fund 25% of annual expenditures 292 Police Grants Fund No reserve requirement 294 Regional Police Academy Fund 25% of annual expenditures 295 COPS More Grant Fund No reserve requirement 299 Police Federal Drug Enforcement Grant 25% of annual expenditures 313 Hall of Fame Debt Service Fund No reserve requirement 315 Airport 2003 Debt Reserve Fund 100% of debt service reserve per bond covenants 317 Coveleski Bond Debt Reserve Fund 100% of debt service reserve per bond covenants 319 Redevelopment Bond – Blackthorn Golf Fund 100% of debt service reserve per bond covenants 324 TIF Revenue – River West Fund 25% of annual expenditures 328 SBCDA 2003 Debt Reserve Fund 100% debt service reserve per bond covenants 377 Professional Sports Development Fund 25% of annual expenditures 401 Coveleski Stadium Capital Fund No reserve requirement 403 Zoo Endowment Fund No reserve requirement 404 County Option Income Tax Fund 50% of annual expenditures 405 Park Nonreverting Capital Fund 25% of annual expenditures 406 Cumulative Capital Development Fund 25% of annual expenditures 407 Cumulative Capital Improvement Fund 25% of annual expenditures 408 Economic Development Income Tax Fund 50% of annual expenditures 410 Urban Development Action Grant (UDAG) Fund No reserve requirement 412 Major Moves Construction Fund No reserve requirement 416 Morris Performing Arts Center Capital Fund 25% of annual expenditures 422 TIF District – West Washington Fund 25% of annual expenditures 425 TIF Leighton Plaza Fund 25% of annual expenditures 429 TIF River East District Fund 25% of annual expenditures 430 TIF Southside Development Area #1 Fund 25% of annual expenditures 432 TIF Southside Development Area #3 – Erskine Village Fund 25% of annual expenditures 433 Redevelopment Administration General Fund 25% of annual expenditures 434 CRED Fund No reserve requirement 435 TIF – Douglas Road Fund 10% of annual expenditures 436 TIF – River East Residential Fund 25% of annual expenditures 439 Certified Technology Park Fund No reserve requirement 450 Palais Royale Historic Preservation Fund 25% of annual expenditures 454 Airport Urban Enterprise Zone Fund No reserve requirement 28 Fund Fund Name Cash Reserve Policy 600 Consolidated Building Department Fund 25% of annual expenditures 601 Parking Garages Fund 25% of annual expenditures 610 Solid Waste Operations Fund 10% of annual expenditures 611 Solid Waste Capital Fund No reserve requirement 620 Water Works Operations Fund 5% of annual expenditures 622 Water Works Capital Fund No reserve requirement 624 Water Works Customer Deposit Fund 100% cash reserves for customer deposits 626 Water Works Bond Reserve Fund 100% cash reserves per bond covenants 629 Water Works Reserve – O & M Fund 16.67% of annual operating expenses in fund 620, net of transfers 640 Sewer Repair Insurance Fund 25% of annual expenditures 641 Sewage Works Operations Fund 5% of annual expenditures 642 Sewage Works Capital Fund No reserve requirement 643 Sewage Works Reserve – O & M Fund 16.67% of annual operating expenses in fund 641, net of transfers 653 Sewage Works Debt Service Reserve Fund 100% cash reserves per bond covenants 655 Project ReLeaf Fund 25% of annual expenditures 670 Century Center Fund 25% of annual expenditures 671 Century Center Capital Fund $800,000 Reserve 672 Century Center Energy Conservation Bond Fund No reserve requirement 677 Hall of Fame Capital Fund No reserve requirement 701 Firefighters Pension Fund 10% of annual expenditures 702 Police Pension Fund 10% of annual expenditures 703 Police/Fire 1977 State Pension Fund 100% cash reserves – trust & agency funds 705 Police K-9 Unit Fund 25% of annual expenditures 709 Payroll Fund 100% cash reserves – trust & agency funds 711 Self-Funded Employee Benefits 25% of annual expenditures 712 Public Employees Retirement Fund 100% cash reserves – trust & agency funds 713 Unemployment Compensation Fund 25% of annual expenditures 718 State Tax Deduction Fund 100% cash reserves – trust & agency funds 725 Morris / Palais Box Office Fund 100% cash reserves – trust & agency funds 726 Police Distributions Payable 100% cash reserves – trust & agency funds 730 City Cemetery Trust 25% of annual expenditures --- Water & Sewer Bond Funds No reserve requirement 29 City of South BendCash Reserves Summary Actual FundFund Name CashOutstanding AvailableCash Reserve Percentage BalanceEncumbrancesCashRequirement Varianceof Budget Notes Cash Reserve Policy City Controlled FundsGeneral Fund 101GENERAL FUND 30,486,009.21466,087.9830,019,921.2313,344,794.0016,675,127.2356 % Property taxes in June and December 25% of annual expenditures - higher due to property tax delays Special Revenue Funds 102RAINY DAY FUND8,703,421.670.008,703,421.678,063,537.60639,884.073%3% contingency of total expenditures in previous fiscal ye ar 103EXCESS LEVY3, 670.150.003,670.150.003,670.15100% No expenditures budgeted 201PARKS & RECREATION 3,924,991.9070,755.263,854,236.642,765,998.751,088,237.8935% Property taxes in June and December 25% of annual expenditures - higher due to property tax delays202MOTOR VEHICLE HIGHWAY5,225,685.73633,516.544,592,169.192,097,077.202,495,091.9944%20% of annual expenditures203RECREATION - NONREVERTING823,963.6011,550.04812,413.56309,893.80502,519.7652%20% of annual expenditures 209STUDEBAKER/OLIVER REVERTING GR ANTS1,108,642.28483,250.33625,391.95126,000.00499,391.9599%20% of annual expenditures210DEPT COMMUNITY INVESTMENT STATE GRANTS160,361.411,863,485.50(1,703,124.09)738,882.40 (2,442,006.49) -46% Budgeted grant hasn't been received yet 20% of annual expenditures 211DCI ADMINISTRATION FUND1,123,752.7439,612.211,084,140.53532,346.00551,794.5341% 20% of annual expenditures 212DCI GRANT FUND553,875.133,556,961.76(3,003,086.63)0.00 (3,003,086.63) 100% Budgeted grant hasn't been received yet Grant fund - reimbursement grants - no reserves216POLICE STATE SEIZURES199,997.840.00199,997.847,180.00192,817.84557%20% of annual expenditures217GIFT, DONATION, BEQUEST64,958.010.0064,958.0162,729.202,228.8121% Budget will spend down balance 20% of annual expenditures218POLICE CURFEW VIOLATIONS12,253.750.0012,253.75200.0012,053.751225%20% of annual expenditures220LAW ENFORCEMENT CONTINUING EDUCATION912,111.4010,008.00902,103.4080,495.60821,607.80224%20% of annual expenditures227LOSS RECOVERY FUND 994,542.09130,310.92864,231.171,047,448.60 (183,217.43) 17% Fund is used for one ‐time projects 20% of annual expenditures 244EMERGENCY PHONE SYSTEM33, 670.740.0033,670.740.0033,670.74100%No reserve requirement 249PUBLIC SAFETY L.O.I.T. 642,770.290.00642,770.291,449,310.20 (806,539.91) 9% Budget will reduce cash 20% of annual expenditures251LOCAL ROADS & STREETS2,730,924.661,011,945.021,718,979.64484,744.201,234,235.4471%20% of annual expenditures252EXCESS WELFARE DISTRIBUTION8.070.00 8.071.606.47101%20% of annual expenditures258HUMAN RIGHTS - FEDERAL GRANT425,850.350.00425,850.3549,811.40376,038.95171%20% of annual expenditures271EASTRACE WATERWAY1,336. 780.001,336.78800.00536.7833%20% of annual expenditures273MORRIS PAC/PALAIS ROYALE MARKETING30,391.26877.5029,513.763,794.8025,718.96156%20% of annual expenditures280POLICE BLOCK GRANTS3,855.180.003,855.180.003,855.18100%20% of annual expenditures281REDEVELOPMENT COMMISSION - REV BONDS27,397.53 0.0027,397.530.0027,397.53100%20% of annual expenditures289HAZMAT32,104.160.0032,104.166,306.0025,798.16102%20% of annual expenditures291INDIANA RIVER RESCUE95,569.130.0095,569.1324,160.0071,409.1379%20% of annual expenditures292POLICE GRANTS121,195.8055,372.5065,823.3021,029.0044,794.3063%20% of annual expenditures294REGIONAL POLICE ACADEMY70,309.830.0070,309.834,750.0065,559.83296%20% of annual expenditures295COPS MORE GRANT121,715.4810,245.00111,470.4834,467.0077,003.4865%20% of annual expenditures299POLICE FEDERAL DRUG ENFORCEMENT252,751.546,964.53245,787.0149,792.00195,995.0199%20% of annual expenditures404COUNTY OPTION INCOME TAX 12,100,666.632,205,471.119,895,195.527,946,833.501,948,362.0262%50% of annual expenditures - higher due to bonding and rating agencies408ECONOMIC DEVELOPMENT INCOME TA X 9,886,898.11109,997.009,776,901.115,066,874.504,710,026.6196%50% of annual expenditures - hi gher due to bonding and rating agencies 410URBAN DEVELOPMENT ACTION GRAN T (UDAG) 631,221.06 0.00631,221.0687,640.60543,580.46144% 20% of annual expenditures 655PROJECT RELEAF 923,439.77 0.00923,439.77105,671.60817,768.17175% 20% of annual expenditures 705POLICE K-9 UNIT 3,873.92 0.003,873.92400.00 3,473.92194% 20% of annual expenditures Total Special Revenue Funds 51,948,177.9910,200,323.2241,747,854.7731,168,175.5510,579,679.22 Debt Service Fund 313HALL OF FAME DEBT SERVICE 11,396.33 0.0011,396.33254,400.00 (243,003.67) 1% Property taxes in June and December 20% of annual expenditures - cash flow problems due to property taxes Capital Project Funds 377PROFESSIONAL SPORTS DEVELOPMENT427, 930.560.00427,930.56171,120.60256,809.9650%20% of annual expenditures 401COVELESKI STADIUM CAPITAL 82,661.380.0082,661.380.0082,661.38100%20% of annual expenditures403ZOO ENDOWMENT49,509.970.0049,509.979,800.0039,709.97101%20% of annual expenditures405PARK NONREVERTING CAPITAL470, 335.1411,333.42459,001.7238,586.60420,415.12238%20% of annual expenditures 406CUMULATIVE CAPITAL DEVELOPMENT 572, 704.460.00572,704.46135,672.75437,031.71106%25% of annual expenditures - higher due to pr operty tax delays407CUMULATIVE CAPITAL IMPROVEMENT311,636.550.00311,636.5591,968.75219,667.8085%25% of annual expenditures - higher due to state tax delays412MAJOR MOVES CONSTRUCTION2,159, 796.58795,032.761,364,763.82619,212.20745,551.6244%20% of annual expenditures 416MORRIS PERFORMING ARTS CENTER CAPITAL517,398.4814,923.00502,475.4816,049.60486,425.88626%20% of annual expenditures434CRED FUND2,403.830.002,403.83162,500.00 (160,096.17) 0% No future revenue; spending down balance 25% of annual expenditures - higher due to state tax delays 450PALAIS ROYALE HISTORIC PRESERVATION76,512.990.00 76,512.993,230.0073,282.99474%20% of annual expenditures 677HALL OF FAME CAPITAL FUND503,531.040.00503,531.0437,764.80465,766.24267%20% of annual expendituresTotal Capital & Debt Service Funds 5,185,817.31821,289.184,364,528.131,540,305.302,824,222.83 Enterprise Funds 287EMS / FIRE DEPARTMENT CAPITAL2,575, 588.74363,611.002,211,977.74150,000.002,061,977.74295% 20% of annual expenditures 288EMS / FIRE DEPARTMENT OPERATING2, 216,998.3757,305.012,159,693.361,371,073.20788,620.1632% 20% of annual expenditures 600CONSOLIDATED BUILDING DEPARTM ENT1,896,477.92143,387.021,753,090.90841,080.20912,010.7042%20% of annual expenditures 601PARKING GARAGES641,451.05211,465.46429,985.59361,342.4068,643.1924%20% of annual expenditures610SOLID WASTE OPERATIONS319,813.6116,000.87303,812.741,174,772.60 (870,959.86) 5% Systemic budgetary shortfall 20% of annual expenditures 611SOLID WASTE CAPITAL443.280.00443.280.00443.28100%No Reserves - transfer from operating account for debt service as needed620WATER WORKS OPERATIONS3,900,244.95399,556.473,500,688.480.003,500,688.4822%5% of annual expendituresDecember 31, 2015Cash Reserve Report 30 City of South BendCash Reserves Summary Actual FundFund Name CashOutstanding AvailableCash Reserve Percentage BalanceEncumbrancesCashRequirement Varianceof Budget Notes Cash Reserve Policy December 31, 2015622WATER WORKS CAPITAL 2,884,157.52177,796.652,706,360.87167,778.602,538,582.27323% 20% of annual expenditures 623WATER WORKS BOND CAPITAL 0.00 0.00 0.00 0.00 0.00100% Bond fund - spend down to zero - no reserves 624WATER WORKS CUSTOMER DEPOSIT 1,514,085.14 0.001,514,085.141,514,085.14 0.00100% 100% cash reserves for customer deposits 625WATER WORKS SINKING FUND 4,410.86 0.004,410.86 0.00 4,410.86100% No Reserves - transfer from operating account for debt service as needed 626WATER WORKS BOND RESERVE 1, 641,654.04 0.001,641,654.041,641,654.04 0.00100% 100% cash reserves per bond covenants and Crowe Horwath 629WATER WORKS RESERVE - O & M 2,235,266. 68 0.002,235,266.682,333.802,232,932.8815966% 16.67% of annual operating expenses in fund 620, net of transfers 640SEWER REPAIR INSURANCE 1,652, 493.763,751.471,648,742.29109,140.601,539,601.69302% 20% of annual expenditures 641SEWAGE WORKS OPERATIONS 9,023,708.312,167,327.966,856,380.352,029,245.604,827,134.7517% 5% of annual expenditures 642SEWAGE WORKS CAPITAL 8,747,723.015,144,945.633,602,777.38 0.003,602,777.3838% No Reserves - transfer from operating account as needed 643SEWAGE WORKS RESERVE - O & M 3,678,649. 42 0.003,678,649.423,527.373,675,122.0517385% 16.67% of annual operating expenses in fund 641, net of transfers 6452006 SEWER BOND 0.00 0.00 0.00 0.00 0.00100% Bond fund - spend down to zero - no reserves 6472007 SEWER BOND 0.00 0.00 0.00 0.00 0.00100% Bond fund - spend down to zero - no reserves 649SEWAGE WORKS BOND SINKING 804,797.95 0.00804,797.95 0.00804,797.95100% No Reserves - transfer from operating account for debt service as needed 650CLAY SEWAGE WORKS OPERATIONS 0.00 0.00 0.00 0.00 0.00100% 100% reserves of cash available 6512007B SEWER BOND 0.00 0.00 0.00 0.00 0.00100% Bond fund - spend down to zero - no reserves required 653SEWAGE WORKS DEBT SERVICE RESERVE 4,105,623.63 0.004,105,623.63 4,105,623.63 0.00100% 100% cash reserves per bond covenants and C rowe Horwath 6582010 SEWER BOND 0.00 0.00 0.00 0.00 0.00100% Bond fund - spend down to zero - no reserves required 6592011 SEWER BOND 232,196.41172,087.8560,108.56 0.00 60,108.56100% Bond fund - spend down to zero - no reserves required 6612012 SEWER BOND 13,928,149.1510,187,062.703,741,086.45 0.003,741,086.45100% Bond fund - spend down to zero - no reserves requir ed 6642013A SEWER REFUNDING BOND 4,512.17 0.004,512.17 0.00 4,512.17100% Bond fund - spend down to zero - no reserves required 6662015 SEWER BOND 58,231.33 0.0058,231.33 0.00 58,231.33100% Bond fund - spend down to zero - no reserves required 670CENTURY CENTER 1,096,892.37 0.001,096,892.37906,512.40190,379.9724% 20% of annual expenditures 671CENTURY CENTER CAPITAL 1,002,072.00 0.001,002,072.00605,656.00396,416.00165% 20% of annual expenditures, $800,000 minimum per Board of Managers 672CENTURY CENTER ENERGY SAVI NGS 50,031.92 0.0050,031.92 0.00 50,031.92100% No reserve required Total Enterprise Funds 64,215,673.5919,044,298.0945,171,375.5014,983,825.5830,187,549.92 Internal Service Funds222CENTRAL SERVICES 1,333,553.0594,275.251,239,277.80837,940.00401,337.8030% exclude utilities budget & encumb. 20% of annual expenditures, excluding ut ility accounting 224CENTRAL SERVICES CAPITAL187,162.85175,065.3312,097.5254,370.00 (42,272.48) 4% Budget contingent on transfers in 20% of annual expenditures 226LIABILITY INSURANCE4,532,060.1246,156.054,485,904.07764,197.753,721,706.32147%25% of annual expenditures - higher reserves for future claims278TAKE HOME VEHICLE POLICE 642,307.570.00642,307.5714,220.00628,087.57903%20% of annual expenditures 711SELF-FUNDED EMPLOYEE BENEFITS4,374, 720.8944,958.804,329,762.094,174,233.75155,528.3426%25% of annual expenditures - higher r eserves for future claims 713UNEMPLOYMENT COMP FUND269,632.916,600.00263,032.9145,359.20217,673.71116%20% of annual expendituresTotal Internal Service Funds 11,339,437.39367,055.4310,972,381.965,890,320.705,082,061.26 Trust & Agency Funds 701FIREFIGHTERS PENSION 472,918.970.00472,918.971,416,644.75 (943,725.78) 8% Pension payments received in June & Sep 25% of annual expenditures, higher due to pension relief paid later 702POLICE PENSION 1,158,925.820.001,158,925.821,708,058.75 (549,132.93) 17% Pension payments received in June & Sep 25% of annual expenditures, higher due to pension relief paid later703POLICE/FIRE 1977 STATE PENSION0.000.000.000.000.00100%100% cash reserves - trust & agency funds709PAYRO LL FUND 0.000.000.000.000.00100%100% ca sh reserves - trust & agency funds 712PUBLIC EMPLOYEES RETIREMENT FU ND0.000.000.000.000.00100%100% cash reserves - trust & agency funds718STATE TAX DEDUCTION FUND412,690.080.00412,690.08412,690.080.00100%100% cash reserves - trust & agency funds725MORRIS / PALAIS BOX OFFICE1,504,457.640.001,504,457.641,504,457.640.00100%100% cash reserves - trust & agency funds726POLICE DISTRIBUTIONS PAYABLE 835,107.900.00835,107.90835,107.900.00100%100% cash reserves - trust & agency funds730CITY CEMETERY TRUST28,578.870.0028,578.874,000.0024,578.87143%20% of annual expendituresTotal Trust & Agency Funds 4,412,679.280.004,412,679.285,880,959.12 (1,468,279.84) Total City Funds 167,587,794.7730,899,053.90136,688,740.8772,808,380.2563,880,360.62 Redevelopment Commission Controlled FundsTax Increment Financing Funds 324RIVER WEST TIF (AIRPORT TIF)32,771,000.6711,802,075.6720,968,925.0011,927,649.259,041,275.7544%25% of annual expenditures - higher due to property tax delays420TIF DISTRICT - SBCDA GENERAL (DOWNTOWN)0.000.000.000.000.000% Fund closed in TIF realignment 422TIF DISTRICT - WEST WASHINGTON 1,508,785.88303,366.001,205,419.88190,225.001,015,194.88158% 25% of annual expenditures - higher due to property tax delays 425TIF LEIGHTON PLAZA 209,030.78 0.00209,030.7830,943.20178,087.58135% 20% of annual expenditures 426TIF CENTRAL MEDICAL SERVICE AREA 0.00 0.00 0.00 0.00 0.000% Fund closed in TIF realignment 429RIVER EAST DEV TIF (NORTHEAST TIF) 7,570,974.084,535,157.903,035,816.181,809,881.001,225,935.1842%25% of annual expenditures - higher due to property tax delays 430TIF SOUTHSIDE DEVELOPMENT AREA #1 6,103,313.281,311,814.194,791,499.09710,633.754,080,865.34169% 25% of annual expenditures - higher due to property tax delays 432TIF SSDA #3 - ERSKINE VILLAGE 5,309,297.71 0.005,309,297.71172,845.005,136,452.71768% 25% of annual expenditures - higher due to property tax delays 435TIF - DOUGLAS ROAD 151,862.784,200.00147,662.7886,347.25 61,315.5343% Loan balance to be paid down 25% of annual expenditures - higher due to property tax delays 436RIVER EAST RESIDENTIAL (NE RES TIF) 1,622,126.640.001,622,126.64856,408.00765,718.6447% Loan balance to be paid down 25% of annual expenditures - higher due to property tax delays Total Tax Increment Financing Funds 55,246,391.8217,956,613.7637,289,778.0615,784,932.4521,504,845.61 Redevelopment Funds Cash Reserve Report 31 City of South BendCash Reserves Summary Actual FundFund Name CashOutstanding AvailableCash Reserve Percentage BalanceEncumbrancesCashRequirement Varianceof Budget Notes Cash Reserve Policy December 31, 2015433REDEVELOPMENT ADMINISTRATION GENERAL8,713.340.008,713.341,200.007,513.34145%20% of annual expenditures 439CERTIFIED TECHNOLOGY PARK2,276,265.85142,912.702,133,353.151,000,000.001,133,353.1543%20% of annual expenditures454AIRPORT URBAN ENTERPRISE ZONE380,115.190.00380,115.190.00380,115.19100%20% of annual expenditures619BLACKTHORN GOLF COURSE OPERATIONS0.000.000.000.000.000% The golf course has been sold Total Redevelopment Funds 2,665,094.38142,912.702,522,181.681,001,200.001,520,981.68 Debt Service Funds 315AIRPORT 2003 DEBT RESERVE 1,038,904.000.001,038,904.001,038,904.000.00100%100% debt service reserve per bond covenants317COVELESKI BOND DEBT RESERVE508,480.27 0.00508,480.27508,480.270.00100%100% debt service reserve per bond covenants319REDEVELOPMENT BOND - BLACKTHORN GOLF0.000.000.000.000.00100%100% debt service reserve per bond covenants 328SBCDA 2003 DEBT RESERVE1, 735,840.000.001,735,840.001,735,840.000.00100%100% debt service reserve per bond covenants Total Debt Service Funds 3,283,224.27 0.003,283,224.273,283,224.27 0.00 Total Redevelopment Commission Funds 61,194,710.4718,099,526.4643,095,184.0120,069,356.7223,025,827.29 City Operations Total 228,782,505.2448,998,580.36179,783,924.8892,877,736.9786,906,187.91 Cash Reserve Report 32 General Fund - 101 DateAvailable Cash Reserve RequirementDate Actual Percent Percent Requirement 31-Jul-1327,482,947.63$ 16,233,266.50$ 31-Jul-1342%25% 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% $- $5 $10 $15 $20 $25 $30 $35 31-Jul-13 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 Millions Available Cash Reserve Requirement 0%10%20%30%40%50%60% 31-Jul-13 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 Actual Percent Percent Requirement Cash Reserve Report 33 Parks & Recreation - 201 DateAvailable Cash Reserve RequirementDate Actual Percent Percent Requirement 31-Jul-134,143,899.98$ 3,223,115.75$ 31-Jul-1332%25% 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% $(1) $- $1 $1 $2 $2 $3 $3 $4 $4 $5 31-Jul-13 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 Millions Available Cash Reserve Requirement -5%0%5% 10%15%20%25%30%35%40% 31-Jul-13 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 Actual Percent Percent Requirement Cash Reserve Report 34 Motor Vehicle Highway - 202 DateAvailable Cash Reserve RequirementDate Actual Percent Percent Requirement 31-Jul-133,701,668.02$ 1,813,299.20$ 31-Jul-1341%20% 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% $- $1 $2 $3 $4 $5 $6 31-Jul-13 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 Millions Available Cash Reserve Requirement 0% 10%20%30%40%50%60% 31-Jul-13 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 Actual Percent Percent Requirement Cash Reserve Report 35 Liability Insurance - 226 DateAvailable Cash Reserve RequirementDate Actual Percent Percent Requirement 31-Jul-135,288,540.45$ 728,981.75$ 31-Jul-13181%25% 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% $- $1 $2 $3 $4 $5 $6 $7 31-Jul-13 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 Millions Available Cash Reserve Requirement 0% 50%100%150%200%250% 31-Jul-13 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 Actual Percent Percent Requirement Cash Reserve Report 36 Loss Recovery Fund - 227 DateAvailable Cash Reserve RequirementDate Actual Percent Percent Requirement 31-Jul-138,017,301.53$ 105,237.00$ 31-Jul-131524%20% 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% $- $1 $2 $3 $4 $5 $6 $7 $8 $9 31-Jul-13 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 Millions Available Cash Reserve Requirement 0%200%400%600%800% 1000%1200%1400%1600% 31-Jul-13 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 Actual Percent Percent Requirement Cash Reserve Report 37 Public Safety LOIT - 249 DateAvailable Cash Reserve RequirementDate Actual Percent Percent Requirement 31-Jul-131,648,375.38$ 1,420,351.40$ 31-Jul-1323%20% 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-15 6% 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% $- $1 $1 $2 $2 $3 $3 31-Jul-13 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 Millions Available Cash Reserve Requirement 0%5%10%15%20%25%30%35%40% 31-Jul-13 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 Actual Percent Percent Requirement Cash Reserve Report 38 COIT - 404 DateAvailable Cash Reserve RequirementDate Actual Percent Percent Requirement 31-Jul-1313,742,205.73$ 4,629,457.50$ 31-Jul-13148%50% 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% $- $2 $4 $6 $8 $10 $12 $14 $16 31-Jul-13 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 Millions Available Cash Reserve Requirement 0%40%80%120%160%200% 31-Jul-13 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 Actual Percent Percent Requirement Cash Reserve Report 39 EDIT - 408 DateAvailable Cash Reserve RequirementDate Actual Percent Percent Requirement 31-Jul-137,961,922.30$ 4,466,689.50$ 31-Jul-1389%50% 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% $- $2 $4 $6 $8 $10 $12 31-Jul-13 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 Millions Available Cash Reserve Requirement 0% 20%40%60%80%100%120% 31-Jul-13 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 Actual Percent Percent Requirement Cash Reserve Report 40 Self-funded Employee Benefits - 711 DateAvailable Cash Reserve RequirementDate Actual Percent Percent Requirement 31-Jul-137,117,175.97$ 3,337,207.25$ 31-Jul-1353%25% 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% $- $1 $2 $3 $4 $5 $6 $7 $8 31-Jul-13 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 Millions Available Cash Reserve Requirement 0%10%20%30%40%50%60% 31-Jul-13 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 Actual Percent Percent Requirement Cash Reserve Report 41