The URL can be used to link to this page

Home My WebLink About2014 Board of Finance Annual Investment Report• City of South Bend Board of Finance Annual Investment Report For the Year Ended December 31, 2014 Report Date: January 26, 2015 Report Distribution: Mayor Chief of Staff Deputy Chief of Staff City Clerk South Bend Common Council Members Common Council Attorney City Attorney State Board of Accounts (local office) Submitted By: City Controller 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 Report (12/31/14) ..................... ............................... 6 -11 Stale Dated Check Policy .............................. ..........................12 -13 Stale Dated Check Report ............................. ..........................14 -16 Controller's Cash Report (December 31, 2014) ..........................17 -19 11t Source Bank Interest Earnings (Cash Basis) .............................20 Total Interest Earnings by Fund ..................... ..........................21 -23 Cash Reserve Procedure .............................. ..........................24 -26 Cash Reserves Summary (December 31, 2014) ..........................27 -38 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 AUTHORIZED INVESTMENT AMOUNT Maximum of $175 million with 1St Source Bank (No Change) CITY OF SOUTH BEND BOARD OF FINANCE INVESTMENT REVIEW MEETINGS QUARTER DATE TIME 1ST QUARTER 4/22/15 10:00 A.M. 2ND QUARTER 7/29/15 10:00 A.M. 3RD QUARTER 10/21/15 10:00 A.M. 4T" QUARTER 1/20/16 10:00 A.M. Investment Review Meetings will be held at 1St Source Bank City of South Bend Administration & Finance Policy Manual 1 SOI, TH BF, �O 2, u � v 1865 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 1 Monday in January and before January 31 . 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: 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. Repurchase agreements may be entered into for a fixed term or arranged on an open or continuing basis as a continuing contract that: operates like a series of overnight repurchase agreements (may be referred to as overnight sweep products), is renewed each day with the repurchase rate and the amount of funds invested determined daily; and 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. sank e. Investment Presentation for City of South Bend Corporate Agency Account xxxxxxxxx Prepared by Paul W Gifford, CFA sank e. Asset Category Market Value % Total Cash 7,561,171.91 4.3 Fixed Income 167,533,129.32 95.7 Total $175,094,301.23 100.00/0 Account Summary as of 1/21/2015 City of South Bend Corporate Agency IF 1-1 1 gill Units Total Market Value $175,094,301.23 Total Unrealized Gain /Loss $224,325.16 Estimated Annual Income $1,067,759.86 Estimated Portfolio Yield 0.61% YTD Long Term Gain /Loss $2,998.00 YTD Short Term Gain /Loss $4,000.00 Policy Account Income Minor Account Type AGENCY Investment Officer PAUL GIFFORD Administrative Officer JIM WELCH Asset Units Price Tax Cost Market Value Gain /Loss Est. Income Yield %Total FNMA 0.500% 5/27/15 10,000,000 100.14 10,012,488.86 10,021,200.00 8,711.14 50,000.00 0.50 5.72 Fifth Third Bank CD 0.72% 5/17/15 7,000,000 100.00 7,000,000.00 7,034,106.30 34,106.30 50,400.00 0.72 4.02 FHLB 0.450% 6/17/16 7,000,000 100.05 7,000,000.00 7,006,685.00 6,685.00 31,500.00 0.45 4.00 Fifth Third Bank CD 0.76% 11/12/15 6,500,000 100.00 6,500,000.00 6,509,473.97 9,473.97 49,400.00 0.76 3.72 FHLB 0.375% 2/19/16 6,000,000 100.09 5,995,860.00 6,014,720.00 18,860.00 22,500.00 0.37 3.44 Total $36,508,348.86 $36,586,185.27 $77,836.41 $203,800.00 0.56% 20.90% * Market values include accruals. January 21, 2015 7 sank e. Holdings Detail as of 12/31/2014 City of South Bend Corporate Agency Asset CUSIP Quantity Tax Cost Market Value Gain /Loss Est. Income Yield Cash Taxable Money Market Funds Federated Treasury Obliga -ss 60934N872 7,589,598 7,589,598.46 7,589,614.05 15.59 758.96 0.01% Total Cash Fixed Income Time Deposits Ally Bank UT CD 0.950% 9/25/15 Amer Expr Bk FSB CD 1.100% 10/24/16 Apple Bk Savings CD 0.400% 12/31/15 Barclays Bank DE CD 0.550% 4/15/16 Barclays Bank DE CD 0.650% 7/05/16 Bbcn Bank CD 0.500% 8/18/15 Beal Bk USA CD 0.650% 11/25/15 Bk Rhode Island CD 0.400% 2/12/16 Bmo Harris Bk CD 0.700% 2/21/17 BMW Bank of NA CD 0.550% 6/20/16 Capital One Bank CD 1.000% 10/31/16 Cathay Bank Cd -sa 0.600% 12/30/15 Comenity Cap Bk CD 0.750% 8/04/16 Compass Bank CD 0.750% 11/20/15 Customers Bk CD 0.500% 2/26/16 Discover Bank CD 0.950% 10/31/16 Dollar Bk Fed CD 0.400% 11/17/15 Fifth Third Bank CD .70% 2/28/16 Fifth Third Bank CD 0.72% 5/17/15 Fifth Third Bank CD 0.76% 11/12/15 First Merit Bk CD 0.450% 11/13/15 GE Capital Bank CD 0.950% 7/29/16 Goldman Sachs Bk CD 1.200% 2/13/18 Great Southern Bk CD 0.650% 8/10/15 Investors Bk CD 0.450% 11/17/15 JP Morgan Chase CD 1.125% 2/19/18 Key Bank NA CD 0.450% 2/27/15 $7,589,598.46 $7,589,614.05 $15.59 $758.96 0.01% 02006LAG8 250,000 250,000.00 251,357.67 1,357.67 2,375.00 0.94% 02587CBZ2 250,000 250,000.00 249,777.40 - 222.60 2,750.00 1.10% 037843CY8 250,000 250,000.00 249,507.81 - 492.19 1,000.00 0.40% 06740KGH4 250,000 250,000.00 249,868.84 - 131.16 1,375.00 0.55% 06740KGY7 250,000 250,000.00 250,122.23 122.23 1,625.00 0.65% 073296AZ8 250,000 250,000.00 250,292.95 292.95 1,250.00 0.50% 07370WBF2 250,000 250,000.00 250,548.32 548.32 1,625.00 0.65% 064577BR9 250,000 250,000.00 249,204.32 - 795.68 1,000.00 0.40% 055733WR1 5,000,000 5,000,000.00 4,997,253.42 - 2,746.58 35,000.00 0.70% 05580AA33 250,000 250,000.00 249,162.71 - 837.29 1,375.00 0.55% 140420QK9 250,000 250,000.00 249,583.36 - 416.64 2,500.00 1.00% 149159JP1 250,000 250,000.00 250,403.22 403.22 1,500.00 0.60% 20033AFW1 250,000 250,000.00 249,218.84 - 781.16 1,875.00 0.75% 20451PHF6 250,000 250,000.00 250,635.75 635.75 1,875.00 0.75% 23204HAR9 250,000 250,000.00 250,415.86 415.86 1,250.00 0.50% 25467205 250,000 250,000.00 249,516.44 - 483.56 2,375.00 0.95% 25665QAL9 250,000 250,000.00 249,688.29 - 311.71 1,000.00 0.40% 992572012 3,000,000 3,000,000.00 3,000,000.00 0.00 21,000.00 0.70% 992571901 7,000,000 7,000,000.00 7,031,344.66 31,344.66 50,400.00 0.72% 992571794 6,500,000 6,500,000.00 6,506,767.12 6,767.12 49,400.00 0.76% 320844PC1 250,000 250,000.00 249,835.45 - 164.55 1,125.00 0.45% 36830TDD5 250,000 250,000.00 249,763.42 - 236.58 2,375.00 0.95% 38143A6F7 245,000 245,000.00 243,867.03 - 1,132.97 2,940.00 1.21% 39120VRB2 250,000 250,000.00 250,933.05 933.05 1,625.00 0.65% 46176PDQ5 250,000 250,000.00 249,811.20 - 188.80 1,125.00 0.45% 481243SY5 1,079,000 1,079,000.00 1,061,450.43 - 17,549.57 12,138.75 1.14% 49306SRF5 5,000,000 5,000,000.00 5,009,378.77 9,378.77 22,500.00 0.45% January 21, 2015 s sank e. Holdings Detail as of 12/31/2014 City of South Bend Corporate Agency Asset CUSIP Quantity Tax Cost Market Value Gain /Loss Est. Income Yield Fixed Income Time Deposits (continued) Key Bank NA CD 0.450% 3/13/15 49306SRH1 5,000,000 5,000,000.00 5,008,780.82 8,780.82 22,500.00 0.45% Key Bank NA CD 0.450% 7/31/15 49306SSE7 3,000,000 3,000,000.00 3,010,285.89 10,285.89 13,500.00 0.45% Key Bank NA CD 0.600% 12/18/15 49306STC0 2,000,000 2,000,000.00 2,003,540.27 3,540.27 12,000.00 0.60% Lake City Bank CD 0.36% 5/21/15 992571919 5,000,000 5,000,000.00 5,011,095.89 11,095.89 18,000.00 0.36% Lake City Bank CD 0.39% 6/19/15 992571935 5,000,000 5,000,000.00 5,010,471.23 10,471.23 19,500.00 0.39% Merrick Bank CD 0.650% 8/24/15 59012Y4R5 250,000 250,000.00 250,332.57 332.57 1,625.00 0.65% Needham Bk CD 0.750% 11/14/16 63983RAR0 250,000 250,000.00 248,869.35 - 1,130.65 1,875.00 0.75% Pacific Western CD 0.400% 11/12/15 69506YBD0 250,000 250,000.00 249,642.29 - 357.71 1,000.00 0.40% Peoples United CD 0.850% 9/12/16 71270QGN0 250,000 250,000.00 249,330.38 - 669.62 2,125.00 0.85% Sallie Mae Bank CD 1.000% 10/11/16 795450TQ8 250,000 250,000.00 250,112.19 112.19 2,500.00 1.00% Santander Bk Natl CD 0.400% 8/12/15 80280JCB5 250,000 250,000.00 249,976.99 -23.01 1,000.00 0.40% Standard B &t Co CD 0.450% 5/31/16 853117NN5 2,500,000 2,500,000.00 2,492,797.95 - 7,202.05 11,250.00 0.45% Synchrony Bank CD 0.650% 6/20/16 87165FAX2 250,000 250,000.00 249,315.92 - 684.08 1,625.00 0.65% Synovus Bank GA CD 0.650% 6/24/16 87164DFZ8 250,000 250,000.00 249,296.68 - 703.32 1,625.00 0.65% TCF National Bk CD 0.550% 11/20/15 872278BQ8 250,000 250,000.00 250,578.22 578.22 1,375.00 0.55% Usameribank CD 0.550% 12/03/15 917312CB4 250,000 250,000.00 250,511.75 511.75 1,375.00 0.55% Washington Tr Westerly 0.7% 7/29/16 940637GL9 250,000 250,000.00 249,766.68 - 233.32 1,750.00 0.70% Wells Fargo CD V -A 0.950% 2/28/18 94986TMB0 5,000,000 5,000,000.00 4,986,654.79 - 13,345.21 47,500.00 0.95% Wex Bank CD 0.900% 11/14/16 92937CCM8 250,000 250,000.00 249,273.39 - 726.61 2,250.00 0.90% Government Agency FFCB 0.340% 3/10/16 3133EDGK2 5,000,000 4,993,750.00 4,983,491.67 - 10,258.33 17,000.00 0.34% FFCB 0.370% 2/12/16 3133EDEZ1 3,000,000 2,998,500.00 2,986,105.83 - 12,394.17 11,100.00 0.37% FFCB 0.680% 9/23/16 3133EDW24 5,000,000 4,995,550.00 4,989,605.56 - 5,944.44 34,000.00 0.68% FFCB 0.690% 10/14/16 3133EDXE7 5,000,000 5,002,343.75 4,994,329.17 - 8,014.58 34,500.00 0.69% FHLB 0.375% 2/19/16 3130AOSD3 6,000,000 5,995,860.00 6,006,330.00 10,470.00 22,500.00 0.37% FHLB 0.375% 8/28/15 313383V81 5,000,000 5,002,841.02 5,010,756.25 7,915.23 18,750.00 0.37% FHLB 0.450% 6/17/16 3130A23M6 7,000,000 7,000,000.00 6,985,475.00 - 14,525.00 31,500.00 0.45% FHLB 0.500% 6/30/16 3130A2CB0 3,000,000 3,000,000.00 2,989,901.67 - 10,098.33 15,000.00 0.50% FHLB 0.550% 7/15/16 3130A2GZ3 5,000,000 5,000,000.00 5,000,680.56 680.56 27,500.00 0.55% FHLB 0.700% 11/25/16 3130A3FY5 3,000,000 3,000,000.00 2,994,965.00 - 5,035.00 21,000.00 0.70% FHLB 0.800% 12/30/16 3130A3Q23 5,000,000 5,000,000.00 4,995,361.11 - 4,638.89 40,000.00 0.80% January 21, 2015 9 sank e. Holdings Detail as of 12/31/2014 City of South Bend Corporate Agency Asset CUSIP Quantity Tax Cost Market Value Gain /Loss Est. Income Yield Fixed Income Government Agency (continued) FHLB 0.800% 12/30/16 3130A3U85 5,000,000 5,000,000.00 4,996,861.11 - 3,138.89 40,000.00 0.80% FHLMC 1.060% 4/30/18 3134G43H9 2,000,000 2,000,000.00 1,977,092.22 - 22,907.78 21,200.00 1.07% FHLMC MTN 0.500% 6/24/16 3134G56P5 3,000,000 3,000,000.00 2,990,961.67 - 9,038.33 15,000.00 0.50% FHLMC MTN 0.600% 7/29/16 3134G5EH4 5,000,000 5,000,000.00 5,000,366.67 366.67 30,000.00 0.60% FHLMC MTN 0.700% 12/12/16 3134G5Q40 3,000,000 3,000,000.00 2,993,788.33 - 6,211.67 21,000.00 0.70% FHLMC MTN 0.700% 9/29/16 3134G53L0 5,000,000 4,998,000.00 5,000,894.44 2,894.44 35,000.00 0.70% FHLMC MTN 0.875% 2/28/17 3134G4UY2 2,000,000 2,000,000.00 2,002,699.17 2,699.17 17,500.00 0.87% FHLMC MTN 1.250% 11/28/17 3134G5GC3 2,000,000 2,000,000.00 1,999,071.67 - 928.33 25,000.00 1.25% FHLMC MTN V -A 0.450% 11/25/16 3134G5NX9 3,000,000 3,000,000.00 2,986,260.00 - 13,740.00 13,500.00 0.45% FNMA 0.500% 3/30/16 3135GOVA8 3,000,000 3,002,769.05 3,021,521.67 18,752.62 15,000.00 0.50% FNMA 0.500% 5/27/15 3135GOKM4 10,000,000 10,012,488.86 10,015,922.22 3,433.36 50,000.00 0.50% FNMA 0.875% 8/28/17 3135GOMZ3 2,000,000 1,990,220.00 1,998,999.17 8,779.17 17,500.00 0.88% FNMA 1.010% 9/06/17 3136G1EQ8 2,000,000 1,999,600.00 1,994,452.78 - 5,147.22 20,200.00 1.01% FNMA 1.150% 2/28/18 3135GOUN1 5,000,000 5,000,000.00 4,992,745.83 - 7,254.17 57,500.00 1.15% Total Fixed Income $167,315,922.68 $167,278,980.58 $- 36,942.10 $1,042,003.75 0.62% Total Portfolio $174,905,521.14 $174,868,594.63 $- 36,926.51 $1,042,762.71 0.60% * Market values include accruals. January 21, 2015 10 sank e. Bond Maturity (Years) Market Value Holdings 0 0 - 1 57,122,890.84 34.1% 0 1 - 3 96,894,279.44 57.9% N 3 - 5 13,261,810.30 7.9% Total $167,278,980.58 100.0% Bond Credit Rating Market Value Holdings I Li 14 Ll� AAA 103,908,638.77 62.1% ❑ NR 63,370,341.81 37.9% Total $167,278,980.58 100.0% 04io * Market values include accruals. January 21, 2015 11 Fixed Income Summary as of 12/31/2014 City of South Bend Corporate Agency Bond Subclass Market Value Holdings Time Deposits 63,370,341.81 37.9% Government 103,908,638.77 62.1% Agency Total $167,278,980.58 100.0% Bond Duration (Years) Market Value Holdings Less than 1.00 1.00-3.00 03.00-5.00 Total 57,372,398.65 34.3% 96,644,771.63 57.8% 13,261,810.30 7.9% $167,278,980.58 100.0% dLIO 1w City of South Bend Administration & Finance Policy Manual 01 , 1865 Al G 2, ,� rH.ACe y 1865 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. `F: 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 13 City of South Bend Board of Finance Annual Investment Report For the Year Ended December 31, 2014 Other Business — 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, following represents the list of Stale Dated Payroll Checks as of December 31, 2014. Payroll Ck # Name Date $ Amount Fund # Fund Name 382785 Goerner, Elizabeth McKee, Jeff Nagy, Karen 6/08/2012 9/14/2012 9/28/2012 338.48 250.04 253.99 600 Animal Control 385889 249 PS WIT 386835 201 Parks 386983 Vail, Michael 10/12/2012 2.62 202 Street Dept 387398 Henry, Richard 10/26/2012 14.65 12/07/2012 239.39 201 Parks 388628 Brady, Christopher 249 PS LOIT 389977 Yoder, Jeffrey 12/21/2012 345.21 101 Fire Total $1,444.38 City Recommendation The city 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. 14 City of South Bend Board of Finance Annual Investment Report For the Year Ended December 31, 2014 Other Business — Disbursement 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, 2014. Check No. Name Date $ Amount Fund # Fund Name 432459 Alabama Child Support Center 2/02/2012 115.38 709 Payroll 432810 Griffin, Todd 2/07/2012 131.43 620 Water Ops 432816 Trojan, Michael 2/07/2012 20.00 620 Water Ops 434100 McCune, Step hanie Harper, Nora 3/06/2012 1.91 620 Water Ops Water Ops 434101 3/06/2012 5.73 620 434110 Slab y, Ma 3/08/2012 6.15 620 Water Ops 434536 Michiana Golf Course 3/20/2012 190.00 201 Parks 434781 Alan Neighbor 3/20/2012 97.69 620 Water Ops 434782 Anthony Turner 3/20/2012 68.95 620 Water Ops 434783 Amanda Hostetler 3/20/2012 134.55 620 Water Ops 434784 Lakeview Land Co LLC 3/20/2012 69.11 620 Water Ops General 434961 Christopher Voros 3/27/2012 34.75 101 -0801 435454 Hutter, J 4/05/2012 5.64 620 Water Ops 435466 436370 Carrillo, Rebecca Emily McClelland 4/05/2012 4/24/2012 3.21 620 Water Ops 92.01 201 Parks 437403 Richard Powers 5/22/2012 29.91 101 -0801 General 438293 Center late 6/05/2012 18.50 711 Benefits 438295 Amy Marazita 6/05/2012 110.00 203 Recreation 438518 Andrew Myer 6/12/2012 6/11/2012 7/31/2012 47.55 1.02 101 -0901 620 Fire 438668 Stalling, lesha Water Ops 440899 Michiana Lock & Key 368.75 201 Parks 15 Check No. Name Date $ Amount Fund # Fund Name 441027 Greswick, Pauline 8/06/2012 40.00 620 Water Ops 441037 Charles Jr, Lonnie 8/06/2012 10.00 620 General 441175 EEOC 8/07/2012 319.00 258 Human Rights 441966 Markus Anderson 8/20/2012 3.10 709 Payroll 441973 Mary C. Fanello 8/20/2012 11.14 709 Payroll 441976 Janice L. Hall 8/20/2012 40.21 709 Payroll 441979 Jennifer L. Jackson 8/20/2012 3.08 709 Payroll 441981 Jerome Johnson 8/20/2012 2.99 709 Payroll 441994 Warren C. O'neal 8/20/2012 4.92 709 Payroll 441995 David Opfer 8/20/2012 4.68 709 Payroll 442000 Darwin Shipley 8/20/2012 7.81 709 Payroll 442006 Jeff Vitton 8/20/2012 2.49 709 Payroll 442009 Ton'ia Wino 8/20/2012 4.12 709 Payroll 442012 Sha ne Varga 8/20/2012 2.93 709 Payroll 442697 Crawford, Bill 9/07/2012 12.01 620 Water ops 443934 Corley, David 10/02/2012 5.75 620 Water ops 443941 Ma'eski, Bruce 10/02/2012 45.10 620 Water ops 443943 Diedrich Jr, W 10/02/2012 5.74 620 Water ops 444144 Christina Stylianou Michiana lawn Equipment 10/09/2012 63.00 203 101 -1201 Recreation 444796 10/23/2012 709.93 Code 445562 Smith, Jordan 11/09/2012 20.00 620 Water O s 446227 American Bar Association 11/27/2012 85.00 101 -0501 General 446775 Taelman, Craig 12/07/2012 6.32 620 Water ops 446779 Darnold, Richard Total 12/07/2012 3.99 620 Water ops $5,274.29 City Recommendation The city recommends that such disbursement 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. `r^ City of South Bend Controller's Cash Report Month of. December 2014 City Controlled Funds General Fund 101 GENERAL FUND 14,408,608.69 1 $19,749,353.18 $5,476,498.68 $3,109.71 $0.00 $0.00 28,684,572.90 0.00 28,684,572.90 559,542.62 Special Revenue Funds 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 14,408,608.69 1 $19,749,353.18 $5,476,498.68 $3,109.71 $0.00 $0.00 28,684,572.90 0.00 28,684,572.90 559,542.62 Special Revenue Funds 102 RAINY DAY FUND 8,645,474.55 0.00 0.00 1,703.10 0.00 0.00 8,647,177.65 0.00 8,647,177.65 0.00 103 EXCESS LEVY 0.00 3,647.54 0.00 0.00 0.00 0.00 3,647.54 0.00 3,647.54 0.00 201 PARKS & RECREATION 563,299.60 3,835,179.01 801,204.36 179.06 0.00 96,819.00 3,500,634.31 0.00 3,500,634.31 0.00 202 MOTOR VEHICLE HIGHWAY 4,070,688.38 316,468.17 740,547.79 870.33 250,000.00 0.00 3,897,479.09 0.00 3,897,479.09 0.00 203 RECREATION - NONREVERTING 811,423.61 73,534.26 70,068.94 162.91 0.00 0.00 815,051.84 0.00 815,051.84 0.00 209 STUDEBAKER/OLIVER REVERTING GRANTS 1,086,878.03 0.00 0.00 214.10 0.00 0.00 1,087,092.13 0.00 1,087,092.13 500,000.00 210 DEPT COMMUNITY INVESTMENT STATE GRANTS 329,556.34 14,713.60 18,002.61 3,355.69 0.00 0.00 329,623.02 0.00 329,623.02 0.00 211 DCI OPERATING FUND 1,234,018.42 13,208.37 172,644.13 255.90 0.00 0.00 1,074,838.56 0.00 1,074,838.56 0.00 212 DEPARTMENT OF COMMUNITY INVESTMENT 639,591.69 594,498.65 442,561.25 110.94 0.00 0.00 791,640.03 0.00 791,640.03 0.00 216 POLICE STATE SEIZURES 187,505.39 0.00 0.00 34.81 0.00 0.00 187,540.20 0.00 187,540.20 0.00 217 GIFT, DONATION, BEQUEST 179,954.25 3,804.79 45,776.42 35.45 0.00 0.00 138,018.07 0.00 138,018.07 0.00 218 POLICE CURFEW VIOLATIONS 11,935.42 87.50 12.50 2.35 0.00 0.00 12,012.77 0.00 12,012.77 0.00 220 LAW ENFORCEMENT CONTINUING EDUCATION 978,944.02 14,928.84 32,228.57 192.41 0.00 0.00 961,836.70 0.00 961,836.70 0.00 227 LOSS RECOVERY FUND 6,134,748.56 114.00 268,822.03 1,237.94 0.00 0.00 5,867,278.47 0.00 5,867,278.47 0.00 244 EMERGENCY TELEPHONE SYSTEM 45,308.03 0.00 11,637.29 0.00 0.00 0.00 33,670.74 0.00 33,670.74 0.00 249 PUBLIC SAFETY L.O.I.T. 1,313,921.77 533,119.80 553,224.49 161.60 0.00 0.00 1,293,978.68 0.00 1,293,978.68 0.00 251 LOCAL ROADS & STREETS 2,354,192.97 93,300.85 2,100.00 464.91 0.00 0.00 2,445,858.73 0.00 2,445,858.73 0.00 252 EXCESS WELFARE DISTRIBUTION 1,153.50 0.00 1,146.00 0.23 0.00 0.00 7.73 0.00 7.73 0.00 258 HUMAN RIGHTS - FEDERAL GRANT 444,871.84 45,509.37 14,035.08 391.75 0.00 0.00 476,737.88 53,777.93 530,515.81 0.00 271 EASTRACE WATERWAY 5,314.31 0.00 0.00 1.05 0.00 0.00 5,315.36 0.00 5,315.36 0.00 273 MORRIS PAC /PALAIS ROYALE MARKETING 26,201.31 1,400.00 877.50 5.16 0.00 0.00 26,728.97 0.00 26,728.97 0.00 280 POLICE BLOCK GRANTS 3,829.50 0.00 0.00 0.76 0.00 0.00 3,830.26 0.00 3,830.26 0.00 281 DEPT. COMMUNITY INVESTMENT - REV BONDS 27,215.13 0.00 0.00 5.36 0.00 0.00 27,220.49 0.00 27,220.49 0.00 289 HAZMAT 39,643.52 0.00 0.00 7.89 0.00 0.00 39,651.41 0.00 39,651.41 0.00 291 INDIANA RIVER RESCUE 104,014.88 2,400.00 975.09 20.57 0.00 0.00 105,460.36 0.00 105,460.36 0.00 292 POLICE GRANTS 95,463.84 0.00 0.00 0.00 0.00 0.00 95,463.84 0.00 95,463.84 0.00 294 REGIONAL POLICE ACADEMY 68,851.85 0.00 543.18 13.59 0.00 0.00 68,322.26 0.00 68,322.26 0.00 295 COPS MORE GRANT 108,390.74 750.00 2,867.00 21.33 0.00 0.00 106,295.07 0.00 106,295.07 0.00 299 POLICE FEDERAL DRUG ENFORCEMENT 349,001.95 0.00 3,537.32 77.94 0.00 0.00 345,542.57 0.00 345,542.57 0.00 404 COUNTY OPTION INCOME TAX 15,383,999.78 773,438.93 1,200,341.12 2,916.44 0.00 0.00 14,960,014.03 0.00 14,960,014.03 2,027,973.00 408 ECONOMIC DEVELOPMENT INCOME TAX 9,483,954.18 841,942.12 151,484.32 1,730.16 0.00 0.00 10,176,142.14 0.00 10,176,142.14 0.00 410 URBAN DEVELOPMENT ACTION GRANT (UDAG) 27,675.96 0.00 0.00 5.45 0.00 0.00 27,681.41 0.00 27,681.41 (2,027,973.00) 655 PROJECT RELEAF 1,204,306.85 39,219.90 13,402.35 237.24 0.00 250,000.00 980,361.64 0.00 980,361.64 0.00 705 POLICE K -9 UNIT 3,320.14 0.00 0.00 0.65 0.00 0.00 3,320.79 0.00 3,320.79 0.00 Total Special Revenue Funds 55,964,650.31 7,201,265.70 4,548,039.34 1 14,417.07 1 250,000.00 1 346,819.00 1 58,535,474.74 53,777.93 58,589,252.67 500,000.00 Debt Service Fund 313 HALL OF FAME DEBT SERVICE (181,959.68) 256,123.38 0.00 0.00 0.00 0.00 74,163.70 0.00 74,163.70 0.00 Capital Project Funds 288 EMS / FIRE DEPARTMENT CAPITAL 2,787,632.12 344,354.49 221,592.99 623.05 0.00 0.00 2,911,016.67 0.00 2,911,016.67 0.00 377 PROFESSIONAL SPORTS DEVELOPMENT 596,325.99 0.00 0.00 110.18 0.00 0.00 596,436.17 0.00 596,436.17 0.00 401 COVELESKI STADIUM CAPITAL 40,465.93 0.00 0.00 7.97 0.00 0.00 40,473.90 0.00 40,473.90 0.00 403 ZOO ENDOWMENT 49,180.34 0.00 0.00 9.69 0.00 0.00 49,190.03 0.00 49,190.03 0.00 405 PARK NONREVERTING CAPITAL 433,363.86 14,428.48 23,220.00 73.49 96,819.00 0.00 521,464.83 0.00 521,464.83 0.00 406 CUMULATIVE CAPITAL DEVELOPMENT 419,313.52 218,719.92 56,545.49 98.05 0.00 0.00 581,586.00 0.00 581,586.00 0.00 407 CUMULATIVE CAPITAL IMPROVEMENT 105,682.88 143,923.32 0.00 20.82 0.00 0.00 249,627.02 0.00 249,627.02 0.00 412 MAJOR MOVES CONSTRUCTION 4,423,127.84 0.00 780,315.03 952.32 0.00 0.00 3,643,765.13 0.00 3,643,765.13 5,627,495.31 2014 December controllers cash report - Controllers Cash Report 17 City of South Bend Controller's Cash Report Month of: December 2014 416 MORRIS PERFORMING ARTS CENTER CAPITAL 502,730.20 Opening 4,213.14 99.26 Interest Transfers Transfers Ending 515,718.32 Total Cash & Interfund Loans Fund Fund Name Cash Balance Receipts Disbursements Earned In Out Cash Balance Investments Investments (Borrowing) 416 MORRIS PERFORMING ARTS CENTER CAPITAL 502,730.20 17,102.00 4,213.14 99.26 0.00 0.00 515,718.32 0.00 515,718.32 0.00 434 CRIED FUND (11,160.68) 20,974.50 0.00 23.85 0.00 0.00 9,837.67 0.00 9,837.67 0.00 450 PALAIS ROYALE HISTORIC PRESERVATION 62,882.16 303.16 0.00 12.34 0.00 0.00 63,197.66 0.00 63,197.66 0.00 677 HALL OF FAME CAPITAL FUND 564,447.69 0.00 5,019.49 114.42 0.00 0.00 559,542.62 0.00 559,542.62 (559,542.62) Total Capital & Debt Service Funds 9,792,032.17 1,015,929.25 1,090,906.14 2,145.44 96,819.00 0.00 9,816,019.72 0.00 9,816,019.72 5,067,952.69 Enterprise Funds 600 CONSOLIDATED BUILDING DEPARTMENT 842,606.42 186,172.18 293,762.56 176.10 0.00 0.00 735,192.14 0.00 735,192.14 0.00 601 PARKING GARAGES 1,168,684.69 89,627.90 184,287.45 223.58 0.00 0.00 1,074,248.72 0.00 1,074,248.72 0.00 610 SOLID WASTE OPERATIONS 251,853.66 496,306.72 341,695.86 69.09 0.00 0.00 406,533.61 0.00 406,533.61 0.00 611 SOLID WASTE CAPITAL 46,117.15 0.00 10,902.12 5.16 0.00 0.00 35,220.19 0.00 35,220.19 0.00 620 WATER WORKS OPERATIONS 4,215,721.17 1,348,805.41 1,089,935.66 767.73 992.44 170,810.00 4,305,541.09 0.00 4,305,541.09 0.00 622 WATER WORKS CAPITAL 3,156,219.25 0.00 16,264.39 623.08 0.00 0.00 3,140,577.94 0.00 3,140,577.94 0.00 623 WATERWORKS BOND CAPITAL 219,690.82 0.00 17,120.40 45.05 0.00 0.00 202,615.47 0.00 202,615.47 0.00 624 WATER WORKS CUSTOMER DEPOSIT 1,476,419.47 23,562.13 18,765.94 290.70 0.00 290.70 1,481,215.66 0.00 1,481,215.66 0.00 625 WATERWORKS SINKING FUND 1,499,627.07 0.00 1,665,779.05 290.96 170,810.00 290.96 4,658.02 0.00 4,658.02 0.00 626 WATER WORKS BOND RESERVE 1,647,291.18 0.00 0.00 318.18 0.00 0.00 1,647,609.36 0.00 1,647,609.36 0.00 629 WATER WORKS RESERVE - O & M 2,085,038.68 0.00 0.00 410.78 0.00 410.78 2,085,038.68 0.00 2,085,038.68 0.00 640 SEWER REPAIR INSURANCE 1,492,658.32 54,709.69 39,797.69 294.43 0.00 0.00 1,507,864.75 0.00 1,507,864.75 0.00 641 SEWAGE WORKS OPERATIONS 8,076,629.41 3,089,600.12 1,397,162.11 1,592.69 674.29 773,536.25 8,997,798.15 0.00 8,997,798.15 0.00 642 SEWAGE WORKS CAPITAL 4,082,930.00 0.00 329,856.14 813.87 0.00 0.00 3,753,887.73 0.00 3,753,887.73 0.00 643 SEWAGE WORKS RESERVE - O & M 3,422,563.54 0.00 0.00 674.29 0.00 674.29 3,422,563.54 0.00 3,422,563.54 0.00 647 2007 SEWER BOND 0.14 0.00 0.00 0.00 0.00 0.00 0.14 0.00 0.14 0.00 649 SEWAGE WORKS BOND SINKING 1,993,892.77 0.00 1,977,890.00 1,253.97 773,536.25 0.00 790,792.99 0.00 790,792.99 0.00 651 2007B SEWER BOND 0.00 2.44 0.00 0.00 0.00 0.00 2.44 0.00 2.44 0.00 653 SEWAGE WORKS DEBT SERVICE RESERVE 7,286,828.40 0.00 0.00 3.10 0.00 0.00 7,286,831.50 0.00 7,286,831.50 0.00 658 2010 SEWER BOND CSO PLAN 1.85 0.00 0.00 0.20 0.00 0.00 2.05 0.00 2.05 0.00 659 2011 SEWER BOND 2,150,060.50 0.00 550,237.14 485.88 0.00 0.00 1,600,309.24 0.00 1,600,309.24 0.00 661 2012 SEWER BOND 17,384,395.09 0.00 558,853.93 3,434.31 0.00 0.00 16,828,975.47 0.00 16,828,975.47 0.00 664 2013 SEWER REFUND BOND 4,482.13 0.00 0.00 0.88 0.00 0.00 4,483.01 0.00 4,483.01 0.00 670 CENTURY CENTER 987,042.01 702,820.48 796,986.98 0.00 0.00 0.00 892,875.51 0.00 892,875.51 0.00 671 CENTURY CENTER CAPITAL 1,418,638.40 0.00 0.00 24.10 0.00 0.00 1,418,662.50 0.00 1,418,662.50 0.00 Total Enterprise Funds 64,909,392.12 5,991,607.07 9,289,297.42 1 11,798.13 1 946,012.98 1 946,012.98 1 61,623,499.90 0.00 61,623,499.90 0.00 Internal Service Funds 222 CENTRAL SERVICES 1,546,520.90 932,636.11 939,948.03 242.08 0.00 0.00 1,539,451.06 0.00 1,539,451.06 0.00 226 LIABILITY INSURANCE 5,815,085.41 242,613.22 375,456.21 1,110.97 0.00 0.00 5,683,353.39 0.00 5,683,353.39 0.00 278 TAKE HOME VEHICLE POLICE 506,771.19 9,440.00 0.01 98.97 0.00 0.00 516,310.15 0.00 516,310.15 0.00 711 SELF - FUNDED EMPLOYEE BENEFITS 4,304,930.15 1,087,307.16 1,333,809.53 886.59 0.00 0.00 4,059,314.37 0.00 4,059,314.37 0.00 713 UNEMPLOYMENT COMP FUND 233,975.84 8,530.35 1,241.27 45.14 0.00 0.00 241,310.06 0.00 241,310.06 0.00 Total Internal Service Funds 12,407,283.49 2,280,526.84 2,650,455.05 2,383.75 0.00 0.00 12,039,739.03 0.00 12,039,739.03 0.00 Trust & Agency Funds 701 FIREFIGHTERS PENSION 1,073,956.03 1,483.53 436,224.42 281.05 0.00 0.00 639,496.19 0.00 639,496.19 0.00 702 POLICE PENSION 1,653,368.40 137.04 542,503.86 410.20 0.00 0.00 1,111,411.78 0.00 1,111,411.78 0.00 709 PAYROLL FUND (24.01) 8,339,150.30 8,339,126.29 0.00 0.00 0.00 0.00 0.00 0.00 0.00 718 STATE TAX DEDUCTION FUND 263,533.96 301,548.33 263,533.96 0.00 0.00 0.00 301,548.33 0.00 301,548.33 0.00 725 MORRIS I PALAIS BOX OFFICE 1,527,411.34 1,894.35 458,274.09 0.00 0.00 0.00 1,071,031.60 0.00 1,071,031.60 0.00 730 CITY CEMETERY TRUST 28,388.55 0.00 0.00 5.60 0.00 0.00 28,394.15 0.00 28,394.15 0.00 2014 December controllers cash report - Controllers Cash Report 18 City of South Bend Controller's Cash Report Month of: December 2014 Total Trust& Agency Funds 1 4,546,634.27 1 8,644,213.55 1 10,039,662.62 1 696.85 1 0.00 1 0.00 1 3,151,882.05 1 0.00 1 3,151,882.05 1 0.00 Total City Funds 162,028,601.05 Opening 33,094,859.25 34,550.95 Interest Transfers Transfers Ending 173,904,966.27 Total Cash & Interfund Loans Fund Fund Name Cash Balance Receipts Disbursements Earned In Out Cash Balance Investments Investments (Borrowing) Total Trust& Agency Funds 1 4,546,634.27 1 8,644,213.55 1 10,039,662.62 1 696.85 1 0.00 1 0.00 1 3,151,882.05 1 0.00 1 3,151,882.05 1 0.00 Total City Funds 162,028,601.05 44,882,895.59 33,094,859.25 34,550.95 1,292,831.98 1,292,831.98 173,851,188.34 53,777.93 173,904,966.27 6,127,495.31 Redevelopment Commission Controlled Funds 10,094.00 0.00 0.00 1.99 0.00 0.00 10,095.99 0.00 10,095.99 0.00 Tax Increment Financing Funds 5,022,644.39 0.00 0.00 815.01 0.00 0.00 5,023,459.40 0.00 5,023,459.40 0.00 324 TIF REVENUE - AIRPORT 25,611,863.10 6,765,485.35 971,637.94 5,111.00 204.68 0.00 31,411,026.19 0.00 31,411,026.19 5,741,428.09 420 TIF DISTRICT - SBCDA GENERAL 2,465,643.57 1,872,122.57 244,736.14 5,606.71 341.99 0.00 4,098,978.70 0.00 4,098,978.70 0.00 422 TIF DISTRICT - WEST WASHINGTON 919,423.54 276,835.15 0.00 181.12 0.00 0.00 1,196,439.81 0.00 1,196,439.81 0.00 425 TIF LEIGHTON PLAZA 167,527.72 9,942.41 4,910.17 17.71 0.00 0.00 172,577.67 0.00 172,577.67 0.00 426 TIF CENTRAL MEDICAL SERVICE AREA 1,903,928.68 391,551.74 0.00 377.35 0.00 0.00 2,295,857.77 0.00 2,295,857.77 0.00 429 TIF NORTHEAST DISTRICT 3,803,137.63 760,056.03 4,833.94 750.58 0.00 0.00 4,559,110.30 0.00 4,559,110.30 0.00 430 TIF SOUTHSIDE DEVELOPMENT AREA #1 3,945,686.85 1,110,265.51 96,588.45 789.21 0.00 0.00 4,960,153.12 0.00 4,960,153.12 0.00 432 TIF SSDA #3 - ERSKINE VILLAGE 6,505,114.86 0.00 0.00 1,170.93 0.00 0.00 6,506,285.79 0.00 6,506,285.79 0.00 435 TIF - DOUGLAS ROAD 60,598.91 160,947.28 0.00 11.94 0.00 0.00 221,558.13 0.00 221,558.13 (886,677.00) 436 TIF - NORTHEST RESIDENTIAL 363,005.64 1,343,410.58 0.00 71.51 0.00 0.00 1,706,487.73 0.00 1,706,487.73 (4,740,818.31) Total Tax Increment Financing Funds 45,745,930.50 12,690,616.62 1,322,706.64 14,088.06 546.67 0.00 57,128,475.21 0.00 57,128,475.21 113,932.78 Redevelopment Funds Opening Interest Accrued Change in Transfer In Transfer out Investment Total Cash & 433 REDEVELOPMENT ADMINISTRATION GENERAL 10,094.00 0.00 0.00 1.99 0.00 0.00 10,095.99 0.00 10,095.99 0.00 439 CERTIFIED TECHNOLOGY PARK 5,022,644.39 0.00 0.00 815.01 0.00 0.00 5,023,459.40 0.00 5,023,459.40 0.00 454 AIRPORT URBAN ENTERPRISE ZONE 377,584.39 0.00 0.00 74.39 0.00 0.00 377,658.78 0.00 377,658.78 0.00 619 BLACKTHORN GOLF COURSE OPERATIONS 118,727.24 5,277.71 40,503.88 0.00 0.00 0.00 83,501.07 0.00 83,501.07 (6,241,428.09) Total Redevelopment Funds 5,529,050.02 5,277.71 40,503.88 891.39 0.00 0.00 5,494,715.24 0.00 5,494,715.24 (6,241,428.09) Debt Service Funds Opening Interest Accrued Change in Transfer In Transfer out Investment Total Cash & 315 AIRPORT 2003 DEBT RESERVE 1,038,904.00 0.00 0.00 204.68 0.00 204.68 1,038,904.00 0.00 1,038,904.00 0.00 317 COVELESKI BOND DEBT RESERVE 505,094.81 0.00 0.00 99.50 0.00 0.00 505,194.31 0.00 505,194.31 0.00 328 SBCDA 2003 DEBT RESERVE 1,735,840.00 0.00 0.00 341.99 0.00 341.99 1,735,840.00 1,735,840.00 0.00 Total Debt Service Funds 3,279,838.81 0.00 0.00 646.17 0.00 546.67 3,279,938.31 0.00 3,279,938.31 0.00 0.00 Total Redevelopment Commission Funds 54,554,819.33 12,695,894.33 1,363,210.52 15,625.62 546.67 546.67 65,903,128.76 0.00 65,903,128.76 (6,127,495.31) City Operations Total 216,583,420.38 57,578,789.92 34,458,069.77 50,176.57 1 1,293,378.65 1 1,293,378.65 1 239,754,317.10 53,777.93 1 239,808,095.03 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 174,886,648.40 54,926.02 0.00 (283,010.23) 0.00 34,124.04 174,624,440.15 174,624,440.15 2014 December controllers cash report - Controllers Cash Report 19 City of South Bend, Indiana Interest Earnings Summary - 2014 December 31, 2014 Prepared - January 24, 2015 1st Source 1st Source Paid Investment Checking Other Total Month Month Interest Interest Interest (1) Interest $3,848 90,291 23,287 Dec -13 Jan -14 $18,386 $10,245 $32,479 Jan -14 Feb -14 72,637 10,811 $173,739 Feb -14 Mar -14 100,586 7,627 $131,500 Mar -14 Apr -14 103,393 7,470 9,408 $120,271 Apr -14 May -14 29,134 5,918 3,147 $38,199 May -14 Jun -14 44,023 4,626 3,290 $51,939 Jun -14 Jul -14 13,048 8,090 6,740 $27,878 Jul -14 Aug -14 28,444 12,267 25,681 $66,391 Aug -14 Sep -14 115,148 10,461 99,164 $224,772 Sep -14 Oct -14 60,741 9,262 6,452 $76,455 Oct -14 Nov -14 19,292 9,066 2,899 $31,256 Nov -14 Dec -14 34,124 7,139 8,914 J5LQ 176 $638,957 $102,980 $283,120 $1,025,058 (1) interest on DCI loans, Major Moves interfund loans, Key Bank accounts, Bank of New York Mellon accounts. 20 $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 $0 Interest Earnings 2002 -2014 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Interest Earninas 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 Total 2002 -2014 $30,727,278 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. `I City of South Bend, Indiana Interest Earnings Summary Years 2002 through 2014 December 31, 2014 Updated - January 26, 2015 Fund Fund 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 Number Name Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual 101 General 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 102 Rainy Day Fund 0 0 26,967 74,033 105,664 102,063 159,362 26,065 28,532 24,477 42,239 29,524 29,473 103 Excess Levy 0 0 0 13,820 10,148 0 742 285 395 261 0 0 0 201 Parks & Recreation 1,336 715 4,110 15,942 0 4,937 12,910 591 9,423 8,467 14,802 12,082 8,075 202 Motor Vehicle Highway 2,735 86 2,035 3,834 4,576 14 40,014 21,066 11,099 5,314 7,431 11,791 12,300 203 Recreation - Non Reverting 31641 4,074 6,525 14,684 11,183 22,181 20,904 6,223 2,899 2,006 3,332 2,692 2,893 209 Studebaker /Oliver Grants 0 0 0 0 25,516 44,983 63,975 16,413 6,401 4,486 5,485 3,712 3,705 210 Econ Dev State Grants 4,745 0 0 2,457 33,945 262,672 136,850 103,213 89,744 13,016 64,332 60,703 15,033 211 DCI Administration 0 0 0 0 0 0 0 0 0 1,625 3,057 2,610 3,246 212 DCI Grants 3,443 2,521 3,095 6,452 61,934 105,380 59,659 11,241 5,760 3,147 2,578 2,152 2,038 216 State Seized Drug Money 0 0 0 0 0 0 0 0 351 336 653 498 564 217 Gift, Donation, Bequest 0 0 0 0 0 0 0 0 102 112 287 232 462 218 SBPD Curfew Violations 0 0 0 0 0 0 0 0 29 28 52 38 40 220 Law Enforcement Cont. Education 0 0 0 0 3,698 6,601 9,941 5,930 3,174 2,990 5,194 3,491 3,394 222 Central Services 0 0 0 0 0 0 0 0 972 1,917 4,688 3,421 3,950 226 Liability Insurance 9,717 12,936 27,596 57,359 87,864 97,529 95,123 21,770 12,954 11,068 23,376 18,597 17,712 227 Loss Recovery Fund 0 0 0 0 0 0 0 22,187 16,057 12,545 21,894 18,685 25,717 249 Public Safety LOT Fund 0 0 0 0 0 0 0 0 4,741 2,308 8,296 6,954 5,168 250 General Grant 0 0 0 0 0 0 1,160 319 15 0 0 0 0 251 Local Roads & Streets 16,344 6,649 19,300 52,910 52,077 43,249 83,884 23,395 8,710 6,031 7,306 6,247 7,585 252 Excess Welfare Distribution 0 0 0 0 0 0 0 0 17,808 6,545 5,407 4 4 258 Human Rights - Federal Grant 414 2,486 5,303 11,447 10,991 10,149 9,328 2,746 1,606 1,404 2,279 1,593 1,743 271 Eastrace Waterway 910 576 619 1,428 1,045 1,338 1,194 284 118 78 99 49 35 272 Special Events 910 576 72 284 210 0 0 0 0 0 0 0 0 273 Morris /Palais Marketing Fund 0 0 0 0 0 0 90 86 47 60 122 95 90 278 Police Take Home Liability 0 0 0 0 0 0 0 0 871 833 1,828 1,435 1,705 280 Police Block Grants 9,303 5,143 4,011 4,806 1,255 0 0 282 2,031 3,433 459 13 13 281 Economic Revenue Bond 0 0 0 0 0 0 0 0 88 76 133 93 93 288 EMS /Fire Dept. Capital 2,326 5,310 8,346 23,079 37,833 32,047 47,134 24,891 17,438 15,121 30,051 16,450 14,964 289 Hazmat 0 0 0 0 0 0 0 0 21 8 13 40 86 291 Indiana River Rescue 0 0 0 0 0 0 0 0 269 195 408 368 361 294 Regional Police Academy 0 0 1,074 2,678 1,560 1,352 1,351 481 285 231 399 268 262 295 COPS More Grant 0 0 0 0 0 0 0 0 418 323 492 364 380 299 Federal Drug Enforcement 0 0 0 0 2,638 8,187 14,177 2,856 981 724 941 947 978 305 SBCDA Bond Proceeds 2003 16,390 12,560 210,112 334,547 278,555 191,225 188,939 34,171 8,832 2,657 0 0 0 310 Studebaker Bond 0 0 0 3,685 0 0 0 0 0 0 0 0 0 312 Redevelopment Bond Wayne Street 11,615 8,247 8,473 2,700 0 0 0 0 0 0 0 0 0 313 Hall of Fame Debt Service 0 0 0 10,388 0 0 0 0 0 0 0 0 0 314 Redev Bond 1990 12,668 9,359 11,151 27,488 37,797 37,256 30,589 7,136 3,027 2,373 3,009 0 0 315 Redev Bond - Airport - Taxable 14,134 10,282 0 7,759 35,113 60,099 61,564 16,949 7,090 5,538 5,571 3,567 3,548 316 Redev Bond - Airport - Exempt 6,745 4,848 377 0 0 0 0 0 0 0 0 0 0 317 Coveleski Bond Debt Service Reserve 0 0 0 0 0 0 0 0 0 1,277 2,470 1,725 1,722 319 Blackthorn Debt Service 15,467 12,533 14,873 33,589 44,200 43,567 36,470 8,742 3,627 2,827 4,420 464 0 320 Edit Bond - Plaza Garage- Exempt 9,971 6,934 8,462 17,392 20,739 0 0 0 0 0 0 0 0 321 Edit Bond - Plaza Garage - Taxable 9,664 6,721 8,202 16,857 20,102 0 0 0 0 0 0 0 0 324 TIF Revenue- Airport 30,708 33,136 68,642 305,809 606,063 611,747 719,473 143,202 90,268 68,381 80,260 61,707 85,249 328 Redev Bond - Palais Royale 5,380 0 0 4,428 20,031 36,324 35,225 9,768 4,053 3,159 8,258 5,959 5,929 377 Professional Sports Development 7,531 4,225 5,540 15,702 21,241 23,706 17,892 4,878 3,669 3,415 5,025 2,742 1,963 401 Coveleski Stadium Capital 5,451 5,028 6,506 9,974 4,704 9,015 7,462 1,594 370 262 327 92 98 403 Zoo Endowment 0 0 0 0 335 880 897 250 113 97 211 168 168 404 COIT 114,650 119,802 146,338 198,693 226,073 147,718 143,485 49,035 50,033 37,973 69,195 50,203 50,003 405 Park Nonreverting Capital 1,817 1,456 3,941 7,977 5,000 13,465 8,332 2,502 1,319 1,020 1,772 1,386 1,384 406 Cumulative Capital Development 16,436 12,971 18,158 49,285 70,351 65,648 37,124 7,373 3,267 1,769 3,808 2,701 2,156 407 Cumulative Capital Improvement 226 1,714 453 505 0 0 0 57 45 36 15 122 227 408 EDIT 33,039 26,721 20,597 21,945 33,450 53,971 32,231 9,600 18,952 22,135 45,531 33,100 34,399 410 UDAG 2,198 2,102 1,599 3,897 155,290 156,013 144,853 30,480 14,170 2,659 917 88 94 412 Major Moves Construction (1) 0 0 0 0 63,519 744,851 463,752 113,908 36,180 77,860 394,379 261,868 253,216 414 TIF District - Sample /Ewing 4,983 4,582 5,292 5,833 8,191 12,163 5,876 0 0 0 0 0 0 416 Morris PAC Capital 581 677 1,475 4,402 7,318 10,049 8,811 2,385 1,434 1,503 1,997 1,412 1,651 420 TIF District - SBCDA General 32,618 14,221 27,672 94,991 131,554 109,284 126,073 13,569 15,002 9,217 45,913 59,683 42,533 422 TIF District- W. Washington 438 501 970 9,884 12,070 13,574 13,029 1,117 1,959 3,141 3,920 1,435 2,502 424 TIF SBCDA - Building Operations 0 0 0 0 1,514 0 0 0 0 0 0 0 0 425 TIF - Leighton Plaza 0 0 0 275 2,387 1,117 3,976 1,037 488 334 383 298 306 426 TIF - Cent. Med Sery Area 0 0 3,856 27,339 37,495 31,719 52,519 14,711 15,948 10,028 16,841 12,242 8,308 427 Redevelpment - TJX 1 01 6,587 1 01 01 01 01 01 01 01 01 01 01 0 Dept. Administration /Finance 22 City of South Bend, Indiana Interest Earnings Summary Years 2002 through 2014 December 31, 2014 Updated - January 26, 2015 Fund Fund 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 Number Name Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual 428 Red Dist Capital - AEDA2003 0 0 126,419 194,558 177,528 48,069 10,213 2,725 1,202 0 0 0 0 429 Northeast Development Area TIF 0 0 0 0 0 0 233 376 345 1,040 5,286 8,057 11,381 430 Southside TIF Area #1 0 0 0 0 0 0 0 1,786 8,816 10,154 19,939 17,222 12,462 431 Southside TIF #2 - Eskine Commons 0 0 0 0 0 0 0 1,647 10,074 4,029 2,329 0 0 432 Southside TIF #3- Eskine Village 0 0 0 0 0 0 0 2,238 11,905 13,192 27,801 18,842 20,575 433 Redevelopment Admin General 2,134 1,532 1,557 3,679 5,367 3,581 2,822 669 214 107 164 104 51 434 CREED 0 0 0 22,425 70,155 82,537 67,563 8,287 3,214 1,507 1,259 418 301 435 Douglas Road TIF 0 0 0 0 0 0 0 0 756 246 723 454 685 436 Notheast Residential TIF 0 0 0 0 0 0 0 0 1,478 2,266 10,211 8,423 3,380 438 Coveleski Bond Construction 0 0 0 0 0 0 0 0 0 5,268 0 0 0 439 Certified Technology Park 0 0 0 0 0 0 0 0 0 0 3,571 7,207 12,682 450 Palais Royale Historic Preservation 0 0 0 0 0 0 136 271 124 118 247 215 195 454 Airport Urban Enterprise Zone 0 0 0 0 0 0 0 0 741 473 1,323 1,289 1,287 600 Building Department 2,166 11590 1,662 3,159 1,557 791 1,440 674 129 113 380 667 1,354 601 Parking Garages 0 0 0 0 0 99 0 0 1,207 2,112 4,124 2,408 3,407 610 Solid 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 611 Solid Waste Capital 4,720 6,900 5,654 2,527 0 0 0 0 234 210 279 469 169 620 Water 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 621 WW SRLF Eq Repl Cost 0 1,492 1,030 0 0 0 0 0 0 0 0 0 0 622 Water Works Capital 6,028 19,015 12,121 4,728 0 18,885 13,230 4,240 1,977 11909 6,523 13,709 11,944 623 WW 1997 Bond Capital 42,322 58,644 14,492 0 104,552 103,801 1,401 0 10,555 1,764 11,241 16,550 1,731 624 Water 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 625 WW 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 626 Water Works Bond Reserve 0 0 0 0 0 0 0 0 162 606 3,221 4,767 5,391 628 WW SRLF Rev Bd Reserve 28,516 0 0 0 0 0 0 0 0 0 0 0 0 629 WW 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 640 Sewer 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 641 Sewage Works Operations 0 0 81743 41,178 68,139 221,041 282,825 68,581 24,711 19,879 16,545 16,604 20,498 642 Sewage 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 643 Sewage WorksResv - O &M 50,135 33,892 43,577 93,871 124,089 140,000 118,399 27,752 10,034 8,429 15,457 11,036 11,635 644 Sewer Water Leak Ins. Fund 0 0 0 0 1,604 1,161 464 0 0 0 0 0 0 645 2004 -2006 Sewer Bonds 0 0 39,942 232,890 235,216 97,408 1,868 0 97 12 0 0 0 646 Sewage Rev Bond Reserve 20,593 12,058 14,714 0 0 0 0 0 0 0 0 0 0 647 2007 Sewer Bond 0 0 0 0 0 202,306 278,351 36,998 3,595 1,352 202 42 3 649 Sewage 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 650 Clay Sewage Works Operations 16,055 11,787 14,070 31,648 43,527 44,421 38,408 8,481 2 2 3 2 0 651 20078 Sewer Bond 0 0 0 0 0 0 469,876 142,314 30,308 2,989 575 69 0 653 Sewage Works Debt Service Reserve 0 0 0 0 0 0 0 0 14,267 4,901 30,127 3 3 655 Project Releaf 0 0 0 0 0 0 0 0 2,312 2,111 4,230 2,914 3,642 656 Sewage SRLF Rev BD Resv 37,669 22,055 26,915 0 0 0 0 0 0 0 0 0 0 657 Sewg SRLF EP Repl Cost Resv 39,391 29,869 38,028 83,441 11,580 0 0 0 0 0 0 0 0 658 2010 Sewer Bond 0 0 0 0 0 0 0 0 0 18,528 4,348 216 6 659 2011 Sewer Bond 0 0 0 0 0 0 0 0 0 8,738 91,421 30,970 20,589 661 2012 Sewer Bond 0 0 0 0 0 0 0 0 0 0 0 65,016 60,972 664 2013A Sewer Bonds Refunds 0 0 0 0 0 0 0 0 0 0 0 7 15 670 Century Center 4,013 2,359 551 279 916 972 8,736 21,304 7,288 1,839 228 3,079 0 671 Century Center Capital 0 0 0 0 0 0 0 0 0 0 365 315 328 677 Hall of Fame Capital 0 0 0 0 0 22,317 24,403 6,277 4,024 2,910 3,906 2,416 2,145 701 Fire 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 702 Police 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 705 K -9 Unit 0 0 0 0 0 0 0 0 4 6 11 7 8 711 Self- Funded Employee Benefits 81999 0 14,667 61,414 91,183 110,237 169,758 50,616 34,807 27,732 42,730 25,351 18,112 713 Unemployment Comp Fund 0 0 0 0 0 0 0 0 0 81 101 524 822 730 City Cemetery Trust 545 360 465 1,106 828 1,690 1,474 357 150 118 202 138 118 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) includes NE TIF and Douglas Road TIF repayment of interest on advances from Major Moves. Dept. Administration /Finance 23 City of South Bend Administration & Finance Policy Manual 2.3.1 Cash Reserve Procedure Effective: January 1, 2010; Revised January 1, 2013 and January 1, 2014 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 and January 1, 2014. 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 101 General Fund 102 Rainy Day Fund 201 Parks & Recreation Fund Cash Reserve Policy 25% of annual expenditures 3% contingency of total expenditures in prior year 25% of annual expenditures 202 Motor Vehicle Highway Fund 20% of annual expenditures 203 Recreation — Nonreverting Fund 20% of annual expenditures 209 Studebaker /Oliver Reverting Grants Fund 20% of annual expenditures 210 Department of Community Investment State Grants Fund 20% of annual expenditures 211 Department of Community Investment Administration Fund 20% of annual expenditures 216 Police State Seizures Fund 20% of annual expenditures 217 Gift, Donation, Bequest Fund 20% of annual expenditures 218 Police Curfew Violations Fund 20% of annual expenditures 220 Law Enforcement Continuing Education Fund 20% of annual expenditures 222 Central Services Fund 20% of annual expenditures 226 Liability Insurance Fund 25% of annual expenditures 227 Loss Recovery Fund 20% of annual expenditures 244 Emergency Telephone Fund No reserve requirement 249 Public Safety LOIT Fund 20% of annual expenditures 251 Local Roads & Streets Fund 20% of annual expenditures 252 Excess Welfare Distribution Fund 20% of annual expenditures 258 Human Rights — Federal Grants Fund 20% of annual expenditures 271 Eastrace Waterway Fund 20% of annual expenditures 273 Morris Performing Arts Center /Palais Royale Marketing Fund 20% of annual expenditures Fund Fund Name Cash Reserve Policy 280 Police Block Grants Fund 20% of annual expenditures 281 Economic Development Commission — Revenue Bonds Fund 20% of annual expenditures 288 EMS / Fire Department Capital Fund 20% of annual expenditures 289 HAZMAT Fund 20% of annual expenditures 291 Indiana River Rescue Fund 20% of annual expenditures 292 Police Grants Fund 20% of annual expenditures 294 Regional Police Academy Fund 20% of annual expenditures 295 COPS More Grant Fund 20% of annual expenditures 299 Police Federal Drug Enforcement Grant 20% of annual expenditures 313 Hall of Fame Debt Service Fund 20% of annual expenditures 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 —Airport Fund 25% of annual expenditures 328 SBCDA 2003 Debt Reserve Fund 100% debt service reserve per bond covenants 377 Professional Sports Development Fund 20% of annual expenditures 401 Coveleski Stadium Capital Fund 20% of annual expenditures 403 Zoo Endowment Fund 20% of annual expenditures 404 County Option Income Tax Fund 50% of annual expenditures 405 Park Nonreverting Capital Fund 20% 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 Major Moves Costruction Fund 20% of annual expenditures 20% of annual expenditures 412 416 Morris Performing Arts Center Capital Fund TIF District — SBCDA General (Downtown) Fund 20% of annual expenditures 25% of annual expenditures 420 422 TIF District —West Washington Fund 25% of annual expenditures 425 TIF Leighton Plaza Fund 20% of annual expenditures 426 TIF Central Medical Service Area Fund 25% of annual expenditures 429 TIF Northeast 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 20% of annual expenditures 434 CREED Fund 25% of annual expenditures 435 TIF — Douglas Road Fund 25% of annual expenditures 436 TIF — Northeast Residential Fund 25% of annual expenditures 439 Certified Technology Park Fund 20% of annual expenditures 450 Palais Royale Historic Preservation Fund 20% of annual expenditures 454 Airport Urban Enterprise Zone Fund 20% of annual expenditures 600 Consolidated Building Department Fund 20% of annual expenditures 601 Parking Garages Fund 20% of annual expenditures 610 Solid Waste Operations Fund 20% of annual expenditures 619 Blackthorn Golf Course Operations Fund 20% of annual expenditures 620 Water Works Operations Fund 5% of annual expenditures 622 Water Works Capital Fund 20% of annual expenditures 624 Water Works Customer Deposit Fund 100% cash reserves for customer deposits 25 Fund Fund Name Cash Reserve Policy 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 20% of annual expenditures 641 Sewage Works Operations Fund 5% of annual expenditures 642 Sewage Works Capital Fund 20% of annual expenditures 643 Sewage Works Reserve — O & M Fund 16.67% of annual operating expenses in fund 641, net of transfers 650 Clay Sewage Works Operations Fund 100% reserves of cash available 653 Sewage Works Debt Service Reserve Fund 100% cash reserves per bond covenants 655 Project Releaf Fund 20% of annual expenditures 670 Century Center Fund 20% of annual expenditures 671 Century Center Capital Fund 20% of annual expenditures 677 Hall of Fame Capital Fund 20% of annual expenditures 701 Firefighters Pension Fund 25% of annual expenditures 702 Police Pension Fund 25% of annual expenditures 703 Police /Fire 1977 State Pension Fund 100% cash reserves — trust & agency funds 705 Police K -9 Unit Fund 20% 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 20% 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 730 City Cemetery Trust 20% of annual expenditures - -- I Water & Sewer Bond Funds No cash reserves — spend down of cash on projects 26 City of South Bend Cash Reserves Summary December 31, 2014 Fund Fund Name Cash Balance Outstanding Encumbrances Available Cash Cash Reserve Requirement Variance Percentage of Budget Notes Cash Reserve Policy City Controlled Funds 405 PARK NONREVERTING CAPITAL 406 CUMULATIVE CAPITAL DEVELOPMENT 407 CUMULATIVE CAPITAL IMPROVEMENT 412 MAJOR MOVES CONSTRUCTION General Fund MORRIS PERFORMING ARTS CENTER CAPITAL 20% of annual expenditures 49,190.03 0.00 49,190.03 0.00 49,190.03 101 GENERAL FUND 28,684,572.90 736,895.16 27,947,677.74 14,238,697.25 13,708,980.49 49% d Property taxes in June and December 251/6 of annual expenditures - higher due to property tax delays 581,586.00 Special Revenue Funds 581,586.00 180,733.75 400,852.25 80% 0 25% of annual expenditures- higher due to property tax delays 249,627.02 0.00 102 RAINY DAY FUND 8,647,177.65 0.00 8,647,177.65 8,389,741.30 257,436.35 3% ® No expenditures budgeted 3% contingency of total expenditures in previous fiscal year 103 EXCESS LEVY 3,647.54 0.00 3,647.54 0.00 3,647.54 100% No expenditures budgeted 950% O 201 PARKS & RECREATION 3,500,634.31 95,060.57 3,405,573.74 3,150,219.50 255,354.24 27% Property taxes in June and December 25% of annual expenditures - higher due to property tax delays 202 MOTOR VEHICLE HIGHWAY 3,897,479.09 804,084.85 3,093,394.24 2,001,775.40 1,091,618.84 31% Transfers from EDIT fund 20% of annual expenditures 203 RECREATION - NONREVERTING 815,051.84 13,206.41 801,845.43 295,812.80 506,032.63 54% 20% of annual expenditures 209 STUDEBAKERIOLIVER REVERTING GRANTS 1,087,092.13 30,000.00 1,057,092.13 283,000.00 774,092.13 75% 20% of annual expenditures 210 DEPT COMMUNITY INVESTMENT STATE GRANTS 329,623.02 22,400.00 307,223.02 432,577.20 (125,354.18) 14% ® No IDGF received yet 20% of annual expenditures 211 DCI ADMINISTRATION FUND 1,074,838.56 30,105.22 1,044,733.34 480,976.80 563,756.54 43% 0 20% of annual expenditures 212 DCI GRANT FUND 791,640.03 2,447,967.48 (1,656,327.45) (1,656,327.45) 0.00 100% o DCI grant fund - CDBG, HUD, etc. Grant fund - reimbursement grants - no reserves 216 POLICE STATE SEIZURES 187,540.20 0.00 187,540.20 8,000.00 179,540.20 469% 4P 20% of annual expenditures 217 GIFT, DONATION, BEQUEST 138,018.07 81,181.75 56,836.32 40,202.00 16,634.32 28% 4P 20% of annual expenditures 218 POLICE CURFEW VIOLATIONS 12,012.77 0.00 12,012.77 200.00 11,812.77 1201% 4D 20% of annual expenditures 220 LAW ENFORCEMENT CONTINUING EDUCATION 961,836.70 6,498.00 955,338.70 58,960.40 896,378.30 324% 4P 20% of annual expenditures 227 LOSS RECOVERY FUND 5,867,278.47 4,187,273.53 1,680,004.94 1,323,161.00 356,843.94 25% 20% of annual expenditures 244 EMERGENCY PHONE SYSTEM 33,670.74 0.00 33,670.74 0.00 33,670.74 16% No reserve requirement 249 PUBLIC SAFETY L.O.I.T. 1,293,978.68 0.00 1,293,978.68 1,442,931.60 (148,952.92) 18% © Fire Dept O/T over by $183K 20% of annual expenditures 251 LOCAL ROADS & STREETS 2,445,858.73 333,720.52 2,112,138.21 224,904.00 1,887,234.21 188% 20% of annual expenditures 252 EXCESS WELFARE DISTRIBUTION 7.73 0.00 7.73 229.20 (221.47) 1% ® 20% of annual expenditures 258 HUMAN RIGHTS - FEDERAL GRANT 530,515.81 0.00 530,515.81 54,800.20 475,715.61 194% O 20% of annual expenditures 271 EASTRACE WATERWAY 5,315.36 0.00 5,315.36 2,069.20 3,246.16 51% ® 20% of annual expenditures 273 MORRIS PAC /PALAIS ROYALE MARKETING 26,728.97 973.50 25,755.47 3,600.00 22,155.47 143% O 20% of annual expenditures 280 POLICE BLOCK GRANTS 3,830.26 0.00 3,830.26 0.00 3,830.26 100% O Police grant fund, reimbursement 20% of annual expenditures 281 REDEVLOPMENT COMMISSION - REV BONDS 27,220.49 0.00 27,220.49 0.00 27,220.49 100% 4P 20% of annual expenditures 289 HAZMAT 39,651.41 21,529.55 18,121.86 6,000.00 12,121.86 60% 45' 20% of annual expenditures 291 INDIANA RIVER RESCUE 105,460.36 0.00 105,460.36 10,460.00 95,000.36 202% 20% of annual expenditures 292 POLICE GRANTS 95,463.84 15,144.28 80,319.56 45,612.00 34,707.56 35% 20% of annual expenditures 294 REGIONAL POLICE ACADEMY 68,322.26 0.00 68,322.26 4,750.00 63,572.26 288% 20% of annual expenditures 295 COPS MORE GRANT 106,295.07 30,735.00 75,560.07 28,320.00 47,240.07 53% 20% of annual expenditures 299 POLICE FEDERAL DRUG ENFORCEMENT 345,542.57 23,960.12 321,582.45 33,299.80 288,282.65 193% 20% of annual expenditures 404 COUNTY OPTION INCOME TAX 14,960,014.03 1,149,822.50 13,810,191.53 5,582,892.50 8,227,299.03 124% 50% of annual expenditures - higher due to bonding and rating agencies 408 ECONOMIC DEVELOPMENT INCOME TAX 10,176,142.14 142,486.59 10,033,655.55 5,144,992.00 4,888,663.55 98% 50% of annual expenditures - higher due to bonding and rating agencies 410 URBAN DEVELOPMENT ACTION GRANT (UDAG) 27,681.41 0.00 27,681.41 0.00 27,681.41 100% 4P UDAG revenue is minimal 20% of annual expenditures 655 PROJECT RELEAF 980,361.64 0.00 980,361.64 86,022.80 894,338.84 228% ® 20% of annual expenditures 705 POLICE K -9 UNIT 3,320.79 0.00 3,320.79 400.00 2,920.79 166% ® 20% of annual expenditures TO Special Revenue Funds 58,589,252.67 9,436,149.87 49,153,102.80 27,479,582.25 21,673,520.55 Debt Service Fund 313 HALL OF FAME DEBT SERVICE Cash Reserve Report 74,163.70 0.00 74,163.70 254,260.00 (180,096.30) 6% ® Property taxes in June and December of annual expenditures - cash flow problems due to property taxes 2,911,016.67 Capital Project Funds 288 EMS / FIRE DEPARTMENT CAPITAL 377 PROFESSIONAL SPORTS DEVELOPMENT 401 COVELESKI STADIUM CAPITAL 403 ZOO ENDOWMENT 405 PARK NONREVERTING CAPITAL 406 CUMULATIVE CAPITAL DEVELOPMENT 407 CUMULATIVE CAPITAL IMPROVEMENT 412 MAJOR MOVES CONSTRUCTION 416 MORRIS PERFORMING ARTS CENTER CAPITAL Cash Reserve Report 74,163.70 0.00 74,163.70 254,260.00 (180,096.30) 6% ® Property taxes in June and December of annual expenditures - cash flow problems due to property taxes 2,911,016.67 198,332.56 2,712,684.11 1,257,459.80 1,455,224.31 43% 20% of annual expenditures 596,436.17 0.00 596,436.17 173,149.20 423,286.97 69% 20% of annual expenditures 40,473.90 0.00 40,473.90 708.00 39,765.90 1143% 20% of annual expenditures 49,190.03 0.00 49,190.03 0.00 49,190.03 100% 42' 20% of annual expenditures 521,464.83 9,932.95 511,531.88 41,043.40 470,488.48 249% 4" 20% of annual expenditures 581,586.00 0.00 581,586.00 180,733.75 400,852.25 80% 0 25% of annual expenditures- higher due to property tax delays 249,627.02 0.00 249,627.02 92,450.00 157,177.02 68% G Cigarette and hotel /motel taxes 25% of annual expenditures - higher due to state tax delays 3,643,765.13 1,766,060.45 1,877,704.68 1,164,745.80 712,958.88 32% 4S 20% of annual expenditures 515,718.32 10,247.69 505,470.63 10,640.00 494,830.63 950% O 20% of annual expenditures 27 City of South Bend Cash Reserves Summary December 31, 2014 Fund Fund Name Cash Balance Outstanding Encumbrances Available Cash Cash Reserve Requirement Variance Percentage of Budget Notes Cash Reserve Policy 434 CREED FUND 9,837.67 0.00 9,837.67 162,737.50 (152,899.83) 2% Revenue collected in Nov /Dec 25% of annual expenditures - higher due to state tax delays 450 PALAIS ROYALE HISTORIC PRESERVATION 63,197.66 0.00 63,197.66 2,000.00 61,197.66 632% 20% of annual expenditures 677 HALL OF FAME CAPITAL FUND 559,542.62 0.00 559,542.62 37,713.40 521,829.22 297% 20% of annual expenditures 649 Total Capital & Debt Service Funds 9,816,019.72 1,984,573.65 7,831,446.07 3,377,640.85 4,453,805.22 SEWAGE WORKS DEBT SERVICE RESERVE 658 Cash Reserve Report 735,192.14 Enterprise Funds 600 CONSOLIDATED BUILDING DEPARTMENT 601 PARKING GARAGES 610 SOLID WASTE OPERATIONS 611 SOLID WASTE CAPITAL 620 WATER WORKS OPERATIONS 622 WATER WORKS CAPITAL 623 WATERWORKS BOND CAPITAL 624 WATERWORKS CUSTOMER DEPOSIT 625 WATERWORKS SINKING FUND 626 WATER WORKS BOND RESERVE 629 WATER WORKS RESERVE - O & M 640 SEWER REPAIR INSURANCE 641 SEWAGE WORKS OPERATIONS 642 SEWAGE WORKS CAPITAL 643 SEWAGE WORKS RESERVE - O & M 645 2006 SEWER BOND 647 2007 SEWER BOND 649 SEWAGE WORKS BOND SINKING 650 CLAY SEWAGE WORKS OPERATIONS 651 2007B SEWER BOND 653 SEWAGE WORKS DEBT SERVICE RESERVE 658 2010 SEWER BOND 659 2011 SEWER BOND 661 2012 SEWER BOND 664 2013A SEWER REFUNDING BOND 670 CENTURY CENTER 671 CENTURY CENTER CAPITAL 4,658.02 Total Enterprise Funds Cash Reserve Report 735,192.14 Internal Service Funds 222 CENTRAL SERVICES 226 LIABILITY INSURANCE 278 TAKE HOME VEHICLE POLICE 711 SELF - FUNDED EMPLOYEE BENEFITS 713 UNEMPLOYMENT COMP FUND 55% O Total Internal Service Funds 406,533.61 Trust & Agency Funds 701 FIREFIGHTERS PENSION 702 POLICE PENSION 703 POLICE/FIRE 1977 STATE PENSION 709 PAYROLLFUND 712 PUBLIC EMPLOYEES RETIREMENT FUND 718 STATE TAX DEDUCTION FUND 725 MORRIS / PALAIS BOX OFFICE 730 CITY CEMETERY TRUST 4,069,312.02 Total Trust & Agency Funds Cash Reserve Report 735,192.14 51,286.74 683,905.40 759,781.80 (75,876.40) 18% ® Cash reserves less than target 20% of annual expenditures 1,074,248.72 192,984.32 881,264.40 319,561.60 561,702.80 55% O 20% of annual expenditures 406,533.61 1,955.16 404,578.45 1,170,892.60 (766,314.15) 7% ® High blanket encumbrances, cash ok 20% of annual expenditures 35,220.19 0.00 35,220.19 0.00 35,220.19 100% O Transfers made as needed No Reserves - transfer from operating account for debt service as needed 4,305,541.09 236,229.07 4,069,312.02 0.00 4,069,312.02 27% 4P No reserves - transfer from operating accounts as needed 3,140,577.94 85,892.20 3,054,685.74 195,651.60 2,859,034.14 312% 4P 20% of annual expenditures 202,615.47 53,085.18 149,530.29 0.00 149,530.29 100% O Bond fund - spend down to zero - no reserves 1,481,215.66 0.00 1,481,215.66 1,481,215.66 0.00 1o0% O 100% rash reserves for customer deposits 4,658.02 0.00 4,658.02 0.00 4,658.02 100% d No Reserves - transfer from operating account for debt service as needed 1,647,609.36 0.00 1,647,609.36 1,647,609.36 0.00 100% G 100% cash reserves per bond covenants and Crowe Horwath 2,085,038.68 0.00 2,085,038.68 1,416.95 2,083,621.73 24530% G 16.67% of annual operating expenses in fund 620, net of transfers 1,507,864.75 0.00 1,507,864.75 109,995.60 1,397,869.15 274% 0 20% of annual expenditures 8,997,798.15 1,253,785.05 7,744,013.10 1,777,809.70 5,966,203.40 22% G 5% of annual expenditures, $1.5 million target, see also fund 643 3,753,887.73 3,712,709.03 41,178.70 0.00 41,178.70 0% o No Reserves - transfer from operating account as needed 3,422,563.54 0.00 3,422,563.54 2,500.50 3,420,063.04 22817% O 16.67% of annual operating expenses in fund 641, net of transfers 0.00 0.00 0.00 0.00 0.00 100% O Bond fund - spend down to zero - no reserves 0.14 0.00 0.14 0.00 0.14 1o0% O Bond fund - spend down to zero - no reserves 790,792.99 0.00 790,792.99 0.00 790,792.99 100% O No Reserves - transfer from operating account for debt service as needed 0.00 0.00 0.00 0.00 0.00 100% O 100% reserves of cash available 2.44 0.00 2.44 0.00 2.44 100% O Bond fund - spend down to zero - no reserves required 7,286,831.50 0.00 7,286,831.50 7,286,831.50 0.00 100% 100% cash reserves per bond covenants and Crowe Horwath 2.05 0.00 2.05 0.00 2.05 100% Bond fund - spend down to zero - no reserves required 1,600,309.24 1,705,837.65 (105,528.41) 0.00 (105,528.41) 100% ® Bond fund - spend down to zero - no reserves required 16,828,975.47 1,624,274.75 15,204,700.72 0.00 15,204,700.72 100% Bond fund - spend down to zero - no reserves required 4,483.01 0.00 4,483.01 0.00 4,483.01 100% O Bond fund - spend down to zero - no reserves required 892,875.51 0.00 892,875.51 912,979.60 (20,104.09) 20% © 20% of annual expenditures 1,418,662.50 0.00 1,418,662.50 393,547.00 1,025,115.50 360% G 20% of annual expenditures, $800,000 minimum per Board of Managers 61,623,499.90 8,918,039.15 52,705,460.75 16,059,793.47 36,645,667.28 1,539,451.06 167,445.78 1,372,005.28 726,935.20 645,070.08 38% exclude utilities budget & encumb. 20% of annual expenditures, excluding utility accounting 5,683,353.39 669.00 5,682,684.39 724,300.00 4,958,384.39 196% 25% of annual expenditures - higher reserves for future claims 516,310.15 0.00 516,310.15 16,116.00 500,194.15 641% 20% of annual expenditures 4,059,314.37 5,000.00 4,054,314.37 3,982,909.25 71,405.12 25% 0 25% of annual expenditures - higher reserves for future claims 241,310.06 0.00 241,310.06 45,594.80 195,715.26 106% o Rates charged to departments reduced 20% of annual expenditures 12,039,739.03 173,114.78 11,866,624.25 5,495,855.25 6,370,769.00 639,496.19 0.00 639,496.19 1,468,611.25 (829,115.06) 11% ® Pension relief June & September 25% of annual expenditures, higher due to pension relief paid later 1,111,411.78 0.00 1,111,411.78 1,805,485.25 (694,073.47) 15% ® Pension relief June & September 25% of annual expenditures, higher due to pension relief paid later 0.00 0.00 0.00 0.00 0.00 100% ® 100% rash reserves - trust & agency funds 0.00 0.00 0.00 0.00 0.00 100% 0 100% cash reserves - trust & agency funds 0.00 0.00 0.00 0.00 0.00 100% ® 100% cash reserves - trust & agency funds 301,548.33 0.00 301,548.33 301,548.33 0.00 100% ® 100% cash reserves - trust &agency funds 1,071,031.60 0.00 1,071,031.60 1,071,031.60 0.00 100% O 100% cash reserves - trust &agency funds 28,394.15 0.00 28,394.15 4,119.00 24,275.15 138% 20% of annual expenditures 3,151,882.05 0.00 3,151,882.05 4,650,795.43 (1,498,913.38) 28 City of South Bend Cash Reserves Summary December 31, 2014 Actual Fund Fund Name Cash Outstanding Available Cash Reserve Percentage Balance Encumbrances Cash Requirement Variance of Budget Notes Cash Reserve Policy Total City Funds 173,904,966.27 21,248,772.61 152,656,193.66 71,302,364.50 81,353,829.16 0 Redevelopment Commission Controlled Funds Tax Increment Financing Funds 324 TIF REVENUE - AIRPORT 31,411,026.19 1,861,382.51 29,549,643.68 6,821,673.25 22,727,970.43 108% 0 Property taxes in June and December 25% of annual expenditures - higher due to property tax delays 420 TIF DISTRICT - SBCDA GENERAL (DOWNTOWN) 4,098,978.70 192,965.77 3,906,012.93 1,457,315.25 2,448,697.68 67% 0 Property taxes in June and December 25% of annual expenditures - higher due to property tax delays 422 TIF DISTRICT - WEST WASHINGTON 1,196,439.81 38,900.36 1,157,539.45 164,383.50 993,155.95 176% 0 25% of annual expenditures- higher due to property tax delays 425 TIF LEIGHTON PLAZA 172,577.67 0.00 172,577.67 29,885.00 142,692.67 115% 0 Property taxes in June and December 20% of annual expenditures 426 TIF CENTRAL MEDICAL SERVICE AREA 2,295,857.77 179,125.85 2,116,731.92 1,025,876.00 1,090,855.92 52% 0 Property taxes in June and December 25% of annual expenditures - higher due to property tax delays 429 TIF NORTHEAST DISTRICT 4,559,110.30 187,523.81 4,371,586.49 701,529.25 3,670,057.24 156% 0 Property taxes in June and December 25% of annual expenditures - higher due to property tax delays 430 TIF SOUTHSIDE DEVELOPMENT AREA #1 4,960,153.12 1,222,533.09 3,737,620.03 1,621,989.25 2,115,630.78 58% 0 Property taxes in June and December 25% of annual expenditures - higher due to property tax delays 432 TIF SSDA #3 - ERSKINE VILLAGE 6,506,285.79 0.00 6,506,285.79 123,537.75 6,382,748.04 1317% 0 Property taxes in June and December 25% of annual expenditures - higher due to property tax delays 435 TIF - DOUGLAS ROAD 221,558.13 4,200.00 217,358.13 99,955.75 117,402.38 54% 0 Property taxes in June and December 25% of annual expenditures - higher due to property tax delays 436 TIF - NORTHEST RESIDENTIAL 1,706,487.73 0.00 1,706,487.73 895,807.00 810,680.73 48% 0 Property taxes in June and December 25% of annual expenditures - higher due to property tax delays Total Tax Increment Financing Funds 57,128,475.21 3,686,631.39 53,441,843.82 12,941,952.00 40,499,891.82 0 Redevelopment Funds 433 REDEVELOPMENT ADMINISTRATION GENERAL 10,095.99 0.00 10,095.99 4,000.00 6,095.99 50% 0 20% of annual expenditures 439 CERTIFIED TECHNOLOGY PARK 5,023,459.40 0.00 5,023,459.40 720,000.00 4,303,459.40 140% 0 20% of annual expenditures 454 AIRPORT URBAN ENTERPRISE ZONE 377,658.78 0.00 377,658.78 0.00 377,658.78 100% 0 20% of annual expenditures 619 BLACKTHORN GOLF COURSE OPERATIONS 83,501.07 0.00 83,501.07 334,341.20 (250,840.13) 5% ® Cash reserves less than target 20% of annual expenditures Total Redevelopment Funds 5,494,715.24 0.00 5,494,715.24 1,058,341.20 4,436,374.04 0 Debt Service Funds 315 AIRPORT 2003 DEBT RESERVE 1,038,904.00 0.00 1,038,904.00 1,038,904.00 0.00 100 % 0 100% debt service reserve per bond covenants 317 COVELESKI BOND DEBT RESERVE 505,194.31 0.00 505,194.31 505,194.31 0.00 100 % 0 100% debt service reserve per bond covenants 319 REDEVELOPMENT BOND - BLACKTHORN GOLF 0.00 0.00 0.00 0.00 0.00 100% 0 100% debt service reserve per bond covenants 328 SBCDA 2003 DEBT RESERVE 1,735,840.00 0.00 1,735,840.00 1,735,840.00 0.00 100 % 0 100% debt service reserve per bond covenants Total Debt Service Funds 3,279,938.31 0.00 3,279,938.31 3,279,938.31 0.00 0 Total Redevelopment Commission Funds 65,903,128.76 3,686,631.39 62,216,497.37 17,280,231.51 44,936,265.86 0 City Operations Total 239,808,095.03 24,935,404.00 214,872,691.03 88,582,596.01 126,290,095.02 0 Cash Reserve Report 29 General Fund - 101 60% w $35 p $30 Reserve $25 Actual Percent Date Available Cash $20 Requirement $15 Percent 0% OeG F�,p PQI' Do's OeG Fep PQt' �JC PJ� �o�" Oec; 3^ 4r 3� "gyp �^ 3 3u `!�r 3,,� 3^ 3^ tActual Percent —0--Percent Requirement 31- Dec -12 $10 27,733,383.63 $5 16,173,912.25 31- Dec -12 43% 25% 31- Jan -13 $- Q�d �� e PQC Available Cash —0--Reserve Requirement 60% 50% Reserve 40% 30% Actual Percent Date Available Cash 20% 10% Requirement Date Percent 0% OeG F�,p PQI' Do's OeG Fep PQt' �JC PJ� �o�" Oec; 3^ 4r 3� "gyp �^ 3 3u `!�r 3,,� 3^ 3^ tActual Percent —0--Percent Requirement Cash Reserve Report 30 Reserve Actual Percent Date Available Cash Requirement Date Percent Requirement 31- Dec -12 $ 27,733,383.63 $ 16,173,912.25 31- Dec -12 43% 25% 31- Jan -13 $ 25,550,484.83 $ 16,173,912.25 31- Jan -13 39% 25% 28- Feb -13 $ 22,353,542.47 $ 16,173,912.25 28- Feb -13 35% 25% 31- Mar -13 $ 16,598,780.26 $ 16,233,266.50 31- Mar -13 26% 25% 30- Apr -13 $ 15,116,269.16 $ 16,233,266.50 30- Apr -13 23% 25% 31- May -13 $ 12,079,846.98 $ 16,233,266.50 31- May -13 19% 25% 30- Jun -13 $ 29,307,356.46 $ 16,233,266.50 30- Jun -13 45% 25% 31- Jul -13 $ 27,482,947.63 $ 16,233,266.50 31- Jul -13 42% 25% 31- Aug -13 $ 22,315,551.29 $ 16,233,266.50 31- Aug -13 34% 25% 30- Sep -13 $ 18,544,399.98 $ 16,233,266.50 30- Sep -13 29% 25% 31- Oct -13 $ 16,816,726.59 $ 16,272,893.00 31- Oct -13 26% 25% 30- Nov -13 $ 13,615,491.79 $ 16,272,893.00 30- Nov -13 21% 25% 31- Dec -13 $ 27,464,709.03 $ 16,272,893.00 31- Dec -13 42% 25% 31- Jan -14 $ 22,475,568.55 $ 13,854,192.00 31- Jan -14 41% 25% 28- Feb -14 $ 19,666,397.13 $ 14,060,717.50 28- Feb -14 35% 25% 31- Mar -14 $ 16,931,467.58 $ 14,071,197.25 31- Mar -14 30% 25% 30- Apr -14 $ 13,664,592.50 $ 14,071,197.25 30- Apr -14 24% 25% 31- May -14 $ 10,906,411.36 $ 14,071,197.25 31- May -14 19% 25% 30- Jun -14 $ 29,432,779.84 $ 14,071,197.25 30- Jun -14 52% 25% 31- Jul -14 $ 26,473,744.03 $ 14,088,697.25 31- Jul -14 47% 25% 31- Aug -14 $ 23,722,786.84 $ 14,088,697.25 31- Aug -14 42% 25% 30- Sep -14 $ 20,202,390.82 $ 14,088,697.25 30- Sep -14 36% 25% 31- Oct -14 $ 17,007,547.31 $ 14,088,697.25 31- Oct -14 30% 25% 30- Nov -14 $ 13,644,872.96 $ 14,088,697.25 30- Nov -14 24% 25% 31- Dec -14 $ 27,947,677.74 $ 14,238,697.25 31- Dec -14 49% 25% Cash Reserve Report 30 Parks & Recreation - 201 Cash Reserve Report 31 U) $6 C °_ $5 _ Reserve Actual $4 Date $3 $2 Date Percent Requirement $1 $ 4,763,668.60 $ 3,223,115.75 Ooc Q�� PQ� �JC „�� 0 go ryo „��•' g� „�' eye " ' „�� g� „��•' —*--Available Cash (Reserve Requirement Cash Reserve Report 31 Reserve Actual Percent Date Available Cash Requirement Date Percent Requirement 31- Dec -12 $ 4,763,668.60 $ 3,223,115.75 31- Dec -12 37% 25% 31- Jan -13 $ 3,563,772.38 $ 3,223,115.75 31- Jan -13 28% 25% 28- Feb -13 $ 2,773,384.04 $ 3,223,115.75 28- Feb -13 22% 25% 31- Mar -13 $ 1,708,681.50 $ 3,223,115.75 31- Mar -13 13% 25% 30- Apr -13 $ 1,052,663.00 $ 3,223,115.75 30- Apr -13 8% 25% 31- May -13 $ 866,259.51 $ 3,223,115.75 31- May -13 7% 25% 30- Jun -13 $ 4,545,667.87 $ 3,223,115.75 30- Jun -13 35% 25% 31- Jul -13 $ 4,143,899.98 $ 3,223,115.75 31- Jul -13 32% 25% 31- Aug -13 $ 3,304,340.26 $ 3,223,115.75 31- Aug -13 26% 25% 30- Sep -13 $ 2,735,245.44 $ 3,223,115.75 30- Sep -13 21% 25% 31- Oct -13 $ 2,126,910.16 $ 3,231,865.75 31- Oct -13 16% 25% 30- Nov -13 $ 1,330,822.60 $ 3,231,865.75 30- Nov -13 10% 25% 31- Dec -13 $ 4,038,810.72 $ 3,231,865.75 31- Dec -13 31% 25% 31- Jan -14 $ 2,247,629.45 $ 3,096,131.75 31- Jan -14 18% 25% 28- Feb -14 $ 1,648,649.90 $ 3,150,219.50 28- Feb -14 13% 25% 31- Mar -14 $ 1,032,377.06 $ 3,150,219.50 31- Mar -14 8% 25% 30- Apr -14 $ 590,542.73 $ 3,150,219.50 30- Apr -14 5% 25% 31- May -14 $ 83,244.80 $ 3,150,219.50 31- May -14 1% 25% 30- Jun -14 $ 3,535,769.93 $ 3,150,219.50 30- Jun -14 28% 25% 31- Jul -14 $ 3,047,667.29 $ 3,150,219.50 31- Jul -14 24% 25% 31- Aug -14 $ 2,094,579.12 $ 3,150,219.50 31- Aug -14 17% 25% 30- Sep -14 $ 1,554,697.71 $ 3,150,219.50 30- Sep -14 12% 25% 31- Oct -14 $ 1,005,198.50 $ 3,150,219.50 31- Oct -14 8% 25% 30- Nov -14 $ 282,628.37 $ 3,150,219.50 30- Nov -14 2% 25% 31- Dec -14 $ 3,405,573.74 $ 3,150,219.50 31- Dec -14 27% 25% Cash Reserve Report 31 Motor Vehicle Highway - 202 Cash Reserve Report 32 U) $5 Reserve o $4 Actual Percent $4 2 Available Cash $3 Requirement Date $3 Requirement 31- Dec -12 $2 2,057,519.44 $ $2 31- Dec -12 23% $1 31- Jan -13 $ $1 $ 1,813,299.20 ��M ^,J ee P �O �J ^,��0 ee`��P3� "P e3� ti�.e P 3, 33�3��o3 ^�eG � ��3�g 3 � Available Cash (Reserve Requirement Cash Reserve Report 32 Reserve Actual Percent Date Available Cash Requirement Date Percent Requirement 31- Dec -12 $ 2,057,519.44 $ 1,813,299.20 31- Dec -12 23% 20% 31- Jan -13 $ 1,840,647.98 $ 1,813,299.20 31- Jan -13 20% 20% 28- Feb -13 $ 1,556,523.49 $ 1,813,299.20 28- Feb -13 17% 20% 31- Mar -13 $ 1,348,215.94 $ 1,813,299.20 31- Mar -13 15% 20% 30- Apr -13 $ 3,844,596.47 $ 1,813,299.20 30- Apr -13 42% 20% 31- May -13 $ 2,375,503.84 $ 1,813,299.20 31- May -13 26% 20% 30- Jun -13 $ 2,582,299.16 $ 1,813,299.20 30- Jun -13 28% 20% 31- Jul -13 $ 3,701,668.02 $ 1,813,299.20 31- Jul -13 41% 20% 31- Aug -13 $ 3,587,289.24 $ 1,813,299.20 31- Aug -13 40% 20% 30- Sep -13 $ 3,867,160.45 $ 1,813,299.20 30- Sep -13 43% 20% 31- Oct -13 $ 3,728,689.78 $ 1,835,299.20 31- Oct -13 41% 20% 30- Nov -13 $ 3,693,079.20 $ 1,835,299.20 30- Nov -13 40% 20% 31- Dec -13 $ 3,077,037.70 $ 1,835,299.20 31- Dec -13 34% 20% 31- Jan -14 $ 2,350,831.49 $ 1,821,153.60 31- Jan -14 26% 20% 28- Feb -14 $ 2,055,931.61 $ 1,941,729.60 28- Feb -14 21% 20% 31- Mar -14 $ 1,890,447.88 $ 1,941,729.60 31- Mar -14 19% 20% 30- Apr -14 $ 3,351,701.43 $ 1,941,729.60 30- Apr -14 35% 20% 31- May -14 $ 3,470,456.90 $ 1,941,729.60 31- May -14 36% 20% 30- Jun -14 $ 3,366,866.26 $ 1,941,729.60 30- Jun -14 35% 20% 31- Jul -14 $ 2,837,076.85 $ 2,001,775.40 31- Jul -14 28% 20% 31- Aug -14 $ 2,217,578.14 $ 2,001,775.40 31- Aug -14 22% 20% 30- Sep -14 $ 2,402,072.20 $ 2,001,775.40 30- Sep -14 24% 20% 31- Oct -14 $ 3,204,864.97 $ 2,001,775.40 31- Oct -14 32% 20% 30- Nov -14 $ 2,968,298.70 $ 2,001,775.40 30- Nov -14 30% 20% 31- Dec -14 $ 3,093,394.24 $ 2,001,775.40 31- Dec -14 31% 20% Cash Reserve Report 32 Liability Insurance - 226 Cash Reserve Report 33 y $7 o $6 Reserve $5 Actual $4 Date Available Cash Requirement Date $3 Requirement 31- Dec -12 $ $2 $ $1 31- Dec -12 180% 25% 31- Jan -13 $ N M M M M M M M M M M M M V V V V V V V V V 7 V V r r r r r r r r r r r r r r r r r r r r r r r r r i am m o am m > ? > o O o aU > > � 2 Q 1 - ? 5 n ) O 00 _ � N M M 0 M 0 0 M N M Cl) CO �Avaiable Cash —0--Reserve Requirement Cash Reserve Report 33 Reserve Actual Percent Date Available Cash Requirement Date Percent Requirement 31- Dec -12 $ 5,245,130.31 $ 728,981.75 31- Dec -12 180% 25% 31- Jan -13 $ 5,237,429.00 $ 728,981.75 31- Jan -13 180% 25% 28- Feb -13 $ 5,339,402.41 $ 728,981.75 28- Feb -13 183% 25% 31- Mar -13 $ 5,492,965.69 $ 728,981.75 31- Mar -13 188% 25% 30- Apr -13 $ 5,485,327.28 $ 728,981.75 30- Apr -13 188% 25% 31- May -13 $ 5,537,525.90 $ 728,981.75 31- May -13 190% 25% 30- Jun -13 $ 5,697,952.53 $ 728,981.75 30- Jun -13 195% 25% 31- Jul -13 $ 5,288,540.45 $ 728,981.75 31- Jul -13 181% 25% 31- Aug -13 $ 5,269,618.39 $ 728,981.75 31- Aug -13 181% 25% 30- Sep -13 $ 5,430,336.47 $ 728,981.75 30- Sep -13 186% 25% 31- Oct -13 $ 5,563,697.82 $ 728,981.75 31- Oct -13 191% 25% 30- Nov -13 $ 5,571,676.20 $ 728,981.75 30- Nov -13 191% 25% 31- Dec -13 $ 5,185,497.38 $ 728,981.75 31- Dec -13 178% 25% 31- Jan -14 $ 5,235,932.06 $ 724,300.00 31- Jan -14 181% 25% 28- Feb -14 $ 5,019,217.44 $ 724,300.00 28- Feb -14 173% 25% 31- Mar -14 $ 5,075,527.45 $ 724,300.00 31- Mar -14 175% 25% 30- Apr -14 $ 5,218,468.25 $ 724,300.00 30- Apr -14 180% 25% 31- May -14 $ 5,341,078.00 $ 724,300.00 31- May -14 184% 25% 30- Jun -14 $ 5,099,755.96 $ 724,300.00 30- Jun -14 176% 25% 31- Jul -14 $ 5,133,550.90 $ 724,300.00 31- Jul -14 177% 25% 31- Aug -14 $ 5,274,005.60 $ 724,300.00 31- Aug -14 182% 25% 30- Sep -14 $ 5,400,963.70 $ 724,300.00 30- Sep -14 186% 25% 31- Oct -14 $ 5,541,538.17 $ 724,300.00 31- Oct -14 191% 25% 30- Nov -14 $ 5,813,654.41 $ 724,300.00 30- Nov -14 201% 25% 31- Dec -14 $ 5,682,684.39 $ 724,300.00 31- Dec -14 196% 25% Cash Reserve Report 33 Loss Recovery Fund - 227 $9 1600% N p $8 1400% $7 1200% $6 1000% $5 $4 1 1 4 800% $3 600% $2 400% $1 200% $- 0% M M M M M M - M_ M M M �_ V V V i V V V 7 V V - N M M M M M M M M M M M M_ V V V V V V V V V V V V U C T C N (6 N O- N O ❑ lL Q O O m O O ? Q d > U N O O N (n Q Z ❑ C N N LL T C m Q > U @ O- N O O O N O O N Q O ? O Q In Z ❑ O U N ❑ C a Q T C t6 N N O Q = O m d U O N ? Q (n �, = > U C d T C ] m Q U > U O N t6 N f0 O O N O UI Z ❑ LL Q ? Q (7 0, Z ❑ aD O M -4--Available Cash _ CO) M CO) M M N --w-Reserve Requirement O M O O M M M M M M M M M (") W O M N M M M M -4--Actual Percent M O O W O O M O O M M M M t M M M Nq i CO M CO M M M --w-Percent Re uiremen`� Reserve Actual Percent Date Available Cash Requirement Date Percent Requirement 31- Dec -12 $ 4,323,375.44 $ 105,237.00 31- Dec -12 822% 20% 31- Jan -13 $ 4,325,602.08 $ 105,237.00 31- Jan -13 822% 20% 28- Feb -13 $ 4,327,476.71 $ 105,237.00 28- Feb -13 822% 20% 31- Mar -13 $ 4,330,502.38 $ 105,237.00 31- Mar -13 823% 20% 30- Apr -13 $ 4,305,322.97 $ 105,237.00 30- Apr -13 818% 20% 31- May -13 $ 4,248,806.13 $ 105,237.00 31- May -13 807% 20% 30- Jun -13 $ 4,241,869.33 $ 105,237.00 30- Jun -13 806% 20% 31- Jul -13 $ 8,017,301.53 $ 105,237.00 31- Jul -13 1524% 20% 31- Aug -13 $ 7,992,320.28 $ 105,237.00 31- Aug -13 1519% 20% 30- Sep -13 $ 7,983,890.02 $ 105,237.00 30- Sep -13 1517% 20% 31- Oct -13 $ 7,957,776.85 $ 105,237.00 31- Oct -13 1512% 20% 30- Nov -13 $ 7,898,750.90 $ 105,237.00 30- Nov -13 1501% 20% 31- Dec -13 $ 6,970,228.09 $ 105,237.00 31- Dec -13 1325% 20% 31- Jan -14 $ 6,313,244.00 $ 930,000.00 31- Jan -14 136% 20% 28- Feb -14 $ 6,890,352.55 $ 1,123,161.00 28- Feb -14 123% 20% 31- Mar -14 $ 6,953,221.38 $ 1,123,161.00 31- Mar -14 124% 20% 30- Apr -14 $ 6,914,254.79 $ 1,123,161.00 30- Apr -14 123% 20% 31- May -14 $ 6,537,384.88 $ 1,123,161.00 31- May -14 116% 20% 30- Jun -14 $ 6,568,028.80 $ 1,123,161.00 30- Jun -14 117% 20% 31- Jul -14 $ 6,517,717.27 $ 1,323,161.00 31- Jul -14 99% 20% 31- Aug -14 $ 5,840,729.06 $ 1,323,161.00 31- Aug -14 88% 20% 30- Sep -14 $ 5,587,766.78 $ 1,323,161.00 30- Sep -14 84% 20% 31- Oct -14 $ 5,078,962.94 $ 1,323,161.00 31- Oct -14 77% 20% 30- Nov -14 $ 3,601,667.73 $ 1,323,161.00 30- Nov -14 54% 20% 31- Dec -14 $ 1,680,035.15 $ 1,323,161.00 31- Dec -14 25% 20% Cash Reserve Report 34 Public Safety LOIT - 249 N $4 45O % o $3 40% $3 35% t' s t' Na Nt' N)' Na N� N q , ° N's R ° (° P \° 00 30% $2 25% $2 20% $1 15% 10% $1 5% 0% � 3 d ) MT 3 0 M d o d °G A q cY �PQ�la�JPJ �O ° �� °V �J � � Q N M M —*--Available Cash —0--Reserve Requirement —$--Actual Percent —0--Percent Requirement Reserve Actual Percent Date Available Cash Requirement Date Percent RequiremenC t 31- Dec -12 $ 2,989,940.29 $ 1,420,351.40 31- Dec -12 42% 20% 31- Jan -13 $ 1,707,066.63 $ 1,420,351.40 31- Jan -13 24% 20% 28- Feb -13 $ 2,198,878.63 $ 1,420,351.40 28- Feb -13 31% 20% 31- Mar -13 $ 2,894,230.79 $ 1,420,351.40 31- Mar -13 41% 20% 30- Apr -13 $ 1,610,292.75 $ 1,420,351.40 30- Apr -13 23% 20% 31- May -13 $ 2,101,634.36 $ 1,420,351.40 31- May -13 30% 20% 30- Jun -13 $ 2,932,383.17 $ 1,420,351.40 30- Jun -13 41% 20% 31- Jul -13 $ 1,648,375.38 $ 1,420,351.40 31- Jul -13 23% 20% 31- Aug -13 $ 2,139,726.11 $ 1,420,351.40 31- Aug -13 30% 20% 30- Sep -13 $ 2,631,285.15 $ 1,420,351.40 30- Sep -13 37% 20% 31- Oct -13 $ 1,081,697.22 $ 1,420,351.40 31- Oct -13 15% 20% 30- Nov -13 $ 1,572,948.63 $ 1,420,351.40 30- Nov -13 22% 20% 31- Dec -13 $ 2,032,194.08 $ 1,420,351.40 31- Dec -13 29% 20% 31- Jan -14 $ 2,046,798.30 $ 1,442,931.60 31- Jan -14 28% 20% 28- Feb -14 $ 1,965,415.14 $ 1,442,931.60 28- Feb -14 27% 20% 31- Mar -14 $ 1,788,938.50 $ 1,442,931.60 31- Mar -14 25% 20% 30- Apr -14 $ 1,727,753.74 $ 1,442,931.60 30- Apr -14 24% 20% 31- May -14 $ 1,686,442.29 $ 1,442,931.60 31- May -14 23% 20% 30- Jun -14 $ 1,604,462.03 $ 1,442,931.60 30- Jun -14 22% 20% 31- Jul -14 $ 1,028,769.93 $ 1,442,931.60 31- Jul -14 14% 20% 31- Aug -14 $ 1,313,459.48 $ 1,442,931.60 31- Aug -14 18% 20% 30- Sep -14 $ 1,263,069.52 $ 1,442,931.60 30- Sep -14 18% 20% 31- Oct -14 $ 704,536.10 $ 1,442,931.60 31- Oct -14 10% 20% 30- Nov -14 $ 1,313,921.77 $ 1,442,931.60 30- Nov -14 18% 20% 31- Dec -14 $ 1,293,978.68 $ 1,442,931.60 31- Dec -14 18% 20% Cash Reserve Report 35 t' s t' Na Nt' N)' Na N� N q , ° N's R ° (° P \° 00 Cash Reserve Report 35 COIT - 404 Cash Reserve Report 36 Reserve Actual Percent Date Available Cash Requirement Date Percent Requirement 31- Dec -12 $ 14,646,009.47 $ 4,629,457.50 31- Dec -12 158% 50% 31- Jan -13 $ 14,043,937.84 $ 4,629,457.50 31- Jan -13 152% 50% 28- Feb -13 $ 14,324,313.22 $ 4,629,457.50 28- Feb -13 155% 50% 31- Mar -13 $ 14,546,016.24 $ 4,629,457.50 31- Mar -13 157% 50% 30- Apr -13 $ 13,577,433.87 $ 4,629,457.50 30- Apr -13 147% 50% 31- May -13 $ 13,898,356.40 $ 4,629,457.50 31- May -13 150% 50% 30- Jun -13 $ 14,106,489.14 $ 4,629,457.50 30- Jun -13 152% 50% 31- Jul -13 $ 13,742,205.73 $ 4,629,457.50 31- Jul -13 148% 50% 31- Aug -13 $ 14,058,497.85 $ 4,629,457.50 31- Aug -13 152% 50% 30- Sep -13 $ 14,316,443.37 $ 4,629,457.50 30- Sep -13 155% 50% 31- Oct -13 $ 14,635,975.61 $ 4,721,708.50 31- Oct -13 155% 50% 30- Nov -13 $ 14,942,528.27 $ 4,721,708.50 30- Nov -13 158% 50% 31- Dec -13 $ 14,685,372.33 $ 4,721,708.50 31- Dec -13 156% 50% 31- Jan -14 $ 13,669,378.75 $ 4,877,970.00 31- Jan -14 140% 50% 28- Feb -14 $ 14,064,953.63 $ 4,988,101.00 28- Feb -14 141% 50% 31- Mar -14 $ 14,419,544.87 $ 5,096,642.50 31- Mar -14 141% 50% 30- Apr -14 $ 14,138,281.09 $ 5,096,642.50 30- Apr -14 139% 50% 31- May -14 $ 14,417,615.48 $ 5,582,892.50 31- May -14 129% 50% 30- Jun -14 $ 14,566,201.25 $ 5,582,892.50 30- Jun -14 130% 50% 31- Jul -14 $ 13,784,177.94 $ 5,582,892.50 31- Jul -14 123% 50% 31- Aug -14 $ 14,852,716.09 $ 5,582,892.50 31- Aug -14 133% 50% 30- Sep -14 $ 14,014,334.96 $ 5,582,892.50 30- Sep -14 126% 50% 31- Oct -14 $ 12,625,447.23 $ 5,582,892.50 31- Oct -14 113% 50% 30- Nov -14 $ 13,703,278.95 $ 5,582,892.50 30- Nov -14 123% 50% 31- Dec -14 $ 13,810,191.53 $ 5,582,892.50 31- Dec -14 124% 50% Cash Reserve Report 36 EDIT - 408 Cash Reserve Report 37 Reserve Actual Percent Date Available Cash Requirement Date Percent Requirement 31- Dec -12 $ 9,681,669.68 $ 4,466,689.50 31- Dec -12 108% 50% 31- Jan -13 $ 8,627,786.20 $ 4,466,689.50 31- Jan -13 97% 50% 28- Feb -13 $ 9,173,159.35 $ 4,466,689.50 28- Feb -13 103% 50% 31- Mar -13 $ 9,813,962.38 $ 4,466,689.50 31- Mar -13 110% 50% 30- Apr -13 $ 8,769,019.26 $ 4,466,689.50 30- Apr -13 98% 50% 31- May -13 $ 9,408,926.05 $ 4,466,689.50 31- May -13 105% 50% 30- Jun -13 $ 9,991,563.47 $ 4,466,689.50 30- Jun -13 112% 50% 31- Jul -13 $ 7,961,922.30 $ 4,466,689.50 31- Jul -13 89% 50% 31- Aug -13 $ 8,588,537.46 $ 4,466,689.50 31- Aug -13 96% 50% 30- Sep -13 $ 9,145,793.98 $ 4,466,689.50 30- Sep -13 102% 50% 31- Oct -13 $ 9,731,662.47 $ 4,496,689.50 31- Oct -13 108% 50% 30- Nov -13 $ 9,296,619.48 $ 4,496,689.50 30- Nov -13 103% 50% 31- Dec -13 $ 10,085,156.94 $ 4,496,689.50 31- Dec -13 112% 50% 31- Jan -14 $ 8,379,313.95 $ 4,629,006.50 31- Jan -14 91% 50% 28- Feb -14 $ 9,278,816.60 $ 5,007,492.00 28- Feb -14 93% 50% 31- Mar -14 $ 9,966,875.90 $ 5,007,492.00 31- Mar -14 100% 50% 30- Apr -14 $ 9,076,730.26 $ 5,007,492.00 30- Apr -14 91% 50% 31- May -14 $ 9,202,305.40 $ 5,144,992.00 31- May -14 89% 50% 30- Jun -14 $ 9,910,209.22 $ 5,144,992.00 30- Jun -14 96% 50% 31- Jul -14 $ 8,958,071.99 $ 5,144,992.00 31- Jul -14 87% 50% 31- Aug -14 $ 9,903,901.38 $ 5,144,992.00 31- Aug -14 96% 50% 30- Sep -14 $ 10,608,492.02 $ 5,144,992.00 30- Sep -14 103% 50% 31- Oct -14 $ 7,941,968.89 $ 5,144,992.00 31- Oct -14 77% 50% 30- Nov -14 $ 9,294,422.29 $ 5,144,992.00 30- Nov -14 90% 50% 31- Dec -14 $ 10,033,655.55 $ 5,144,992.00 31- Dec -14 98% 50% Cash Reserve Report 37 Self- funded Employee Benefits - 711 Date Available Cash Requirement Date Percent Requirement 31- Dec -12 $ 7,427,897.64 $ 3,337,207.25 31- Dec -12 56% 25% 31- Jan -13 $ 7,292,748.29 $ 3,337,207.25 31- Jan -13 55% 25% 28- Feb -13 $ 7,018,370.79 $ 3,337,207.25 28- Feb -13 53% 25% 31- Mar -13 $ 7,196,983.44 $ 3,337,207.25 31- Mar -13 54% 25% 30- Apr -13 $ 7,321,766.97 $ 3,337,207.25 30- Apr -13 55% 25% 31- May -13 $ 7,536,131.78 $ 3,337,207.25 31- May -13 56% 25% 30- Jun -13 $ 7,345,334.98 $ 3,337,207.25 30- Jun -13 55% 25% 31- Jul -13 $ 7,117,175.97 $ 3,337,207.25 31- Jul -13 53% 25% 31- Aug -13 $ 7,122,787.23 $ 3,337,207.25 31- Aug -13 53% 25% 30- Sep -13 $ 6,960,945.55 $ 3,337,207.25 30- Sep -13 52% 25% 31- Oct -13 $ 6,291,676.90 $ 3,337,207.25 31- Oct -13 47% 25% 30- Nov -13 $ 5,925,449.92 $ 3,337,207.25 30- Nov -13 44% 25% 31- Dec -13 $ 5,661,447.10 $ 3,337,207.25 31- Dec -13 42% 25% 31- Jan -14 $ 6,054,616.69 $ 3,620,865.75 31- Jan -14 42% 25% 28- Feb -14 $ 5,189,194.64 $ 3,620,865.75 28- Feb -14 36% 25% 31- Mar -14 $ 4,881,271.34 $ 3,620,865.75 31- Mar -14 34% 25% 30- Apr -14 $ 4,775,766.48 $ 3,620,865.75 30- Apr -14 33% 25% 31- May -14 $ 4,734,213.61 $ 3,620,865.75 31- May -14 33% 25% 30- Jun -14 $ 4,967,756.75 $ 3,620,865.75 30- Jun -14 34% 25% 31- Jul -14 $ 4,547,283.48 $ 3,620,865.75 31- Jul -14 31% 25% 31- Aug -14 $ 4,497,229.79 $ 3,620,865.75 31- Aug -14 31% 25% 30- Sep -14 $ 4,488,566.83 $ 3,620,865.75 30- Sep -14 31% 25% 31- Oct -14 $ 4,312,284.67 $ 3,620,865.75 31- Oct -14 30% 25% 30- Nov -14 $ 4,290,596.22 $ 3,620,865.75 30- Nov -14 30% 25% 31- Dec -14 $ 4,054,314.37 $ 3,620,865.75 31- Dec -14 25% 25% Cash Reserve Report 38