HomeMy WebLinkAbout2013 Board of Finance Annual Investment ReportOT11
�pU
� d
J
V
W PEACE ►a
x �
1865
City of South Bend
Board of Finance
Annual Investment Report
For the year ended
December 31, 2013
Report Date: February 10, 2014
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
InvestmentPolicy .............................................. ..............................3-5
Investment Report ( 12/ 31/ 13) ......................... ..............................6-11
State Dated Check Policy ........................... ............................... 12-13
State Dated Check Report ......................... ............................... 14-17
Controller's Cash Report (December, 2013 ) ............................. 18-20
1St Source Bank Interest Earnings (Cash Basis) ... .............................21
Total Interest Earnings by Fund ................. ............................... 22-24
Cash Reserve Procedure ........................... ............................... 25-27
Cash Reserves Summary (December, 2013) ............................ 28-39
CITY OF SOUTH BEND
BOARD OF FINANCE
INVESTMENT OFFICERS
John H. Murphy, 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 1" Source Bank
(No Change)
1
CITY OF SOUTH BEND
BOARD OF FINANCE
INVESTMENT REVIEW MEETINGS
QUARTER DATE
1 Sr QUARTER
4/22/14
2ND QUARTER
7/22/14
3RD QUARTER
10/21/14
4T" QUARTER
1/20/15
Investment Review Meetings will be held at 1St. Source Bank
2
TIME
10:00 A.M.
10:00 A.M.
10:00 A.M.
10:00 A.M.
City of South Bend Administration & Finance Policy Manual
R
All.
U �d_
x 1865 r
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
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
32 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- 1.3 -9.5.
4.0 Terms of Repurchase Agreements
Each investment officer may enter into, with any funds that are held by the officer and available for
investment, repurchase agreements with depositories designated by the State Board of Finance as
depositories under IC 5- 13 -9.5; and involving the political subdivision's purchase and guaranteed resale
of any interest - bearing obligations;
A. issued; or
B. fully insured or guaranteed by the United States, a United States Government Agency, an
instrumentality of the United States, or a federal government sponsored enterprise.
The depository shall determine daily that the amount of money in this type of agreement must be fully
collateralized by interest - bearing obligations as determined by their current market value. The collateral
is not subject to the two -year maturity limitation.
4
Repurchase agreements may be entered into for a fixed term or arranged on an open or continuing basis
as a continuing contract that:
1. operates like a series of overnight repurchase agreements (may be referred to as overnight
sweep products),
2. is renewed each day with the repurchase rate and the amount of funds invested determined
daily; and
3. for this purpose is considered to have a final maturity of one day.
5.0 Investment in Other Securities
Each investing officer may invest or reinvest in obligations issued, assumed or guaranteed by the
International Bank for Reconstruction and Redevelopment or the African Development Bank (IC
5 -13- 9.3.3)
6.0 Inter -local Cooperation Agreement
IC 36 -1 -7 -1 authorizes and permits local units of government to enter into inter -local cooperation
agreements, and thus to exercise a power jointly pursuant to a written agreement authorized by
ordinance or resolution. MBIA provides through Invest Indiana, such an inter -local agreement. The
investments of the joint structure are limited to all investments authorized by IC 5 -13.
7.0 Maturity Limitations
1. A minimum of 75% of the total portfolio must be invested with a maximum maturity of two (2) years in permitted
investments as defined as above.
2. A maximum of 25% of the total portfolio may be invested with a maturity of two (2) to five (5) years as permitted
in IC 5- 13 -9 -5.7 in permitted investments as defined as above. This policy expires on January 31, 2017.
5
k�.
Bq
Investment Presentation for
City of South Bend Corporate Agency
Prepared by Paul W Gifford, CFA
M1
Asset Category
Market Value % Total
0 Cash
2,435,442.27 1.4
0 Fixed Income
172,474,132.64 98.6
Total
$174,909,574.91 100.00/0
Account Summary as of 1/22/2014
City of South Bend Corporate Agency
Total Market Value
$174,909,574.91
Total Unrealized Gain /Loss
$49,129.22
Estimated Annual Income
$965,472.72
Estimated Portfolio Yield
0.55%
YTD Long Term Gain /Loss
$0.00
YTD Short Term Gain /Loss
$0.00
Policy Account
Income
Minor Account Type
AGENCY
Investment Officer
PAUL GIFFORD
Administrative Officer
JIM WELCH
Asset
I Units
Price
Tax Cost
Market Value
Gain /Loss
Est. Income
Yield
% Total
Merchants Bank CD
12,000,000
100.00
12,000,000.00
12,000,000.00
0.00
42,000.00
0.35
6.86
FNMA 0.500% 5/27/15
10,000,000
100.28
10,037,419.85
10,035,838.89
- 1,580.96
50,000.00
0.50
5.74
FHLMC 0.350% 3/18/15
10,000,000
100.11
10,000,000.00
10,022,555.56
22,555.56
35,000.00
0.35
5.73
FNMA 0.625% 10/30/14
9,000,000
100.36
9,029,235.91
9,044,942.50
15,706.59
56,250.00
0.62
5.17
Fifth Third Bank CD
7,000,000
100.00
7,000,000.00
7,034,244.38
34,244.38
50,400.00
0.72
4.02
Total
* Market values include accruals.
January 22, 2014
$48,066,655.76 $48,137,581.33
Page 1 of 5
$70,925.57 $233,650.00 0.49% 27.520/o
HE]
lowsourc(su
an
Holdings Detail as of 12/31/2013
City of South Bend Corporate Agency
Asset
Quantity
Tax Cost
Market Value
Gain /Loss
Est. Income
Yield
% Total
Cash
Taxable Money Market Funds
Federated Treasury Obliga -ss
4,448,983
4,448,983.38
4,449,031.64
48.26
476.04
0.01%
3%
Total Cash
$4,448,983.38
$4,449,031.64
$48.26
$476.04
0.01%
30/0
Fixed Income
Time Deposits
5/3 Bk CD 002 - 0668396324 0.86%
3,030,602
3,030,602.32
3,030,959.35
357.03
26,063.18
0.86%
2%
Ally Bank UT CD 0.950% 9/25/15
250,000
250,000.00
250,877.67
877.67
2,375.00
0.95%
0%
Apple Bk Svgs. NY CD 0.550% 9/12/14
250,000
250,000.00
251,060.65
1,060.65
1,375.00
0.55%
0%
Bbcn Bank CD 0.500% 8/18/15
250,000
250,000.00
249,317.95
- 682.05
1,250.00
0.50%
0%
Beal Bk USA CD 0.650% 11/25/15
250,000
250,000.00
249,360.82
- 639.18
1,625.00
0.65%
0%
Cathay Bank Cd -sa 0.600% 12/30/15
250,000
250,000.00
249,083.22
- 916.78
1,500.00
0.60%
0%
Comenity Capital CD 0.600% 11/25/15
250,000
250,000.00
249,281.27
- 718.73
1,500.00
0.60%
0%
Compass Bank CD 0.750% 11/20/15
250,000
250,000.00
249,500.75
- 499.25
1,875.00
0.75%
0%
Eaglebank CD 0.400% 11/24/14
250,000
250,000.00
250,684.66
684.66
1,000.00
0.40%
0%
Everbank FL CD 0.550% 8/15/14
250,000
250,000.00
251,133.63
1,133.63
1,375.00
0.55%
0%
Fifth Third Bank CD
6,500,000
6,500,000.00
6,506,767.12
6,767.12
49,400.00
0.76%
4%
Fifth Third Bank CD
7,000,000
7,000,000.00
7,031,344.66
31,344.66
50,400.00
0.72%
4%
Fifth Third Bank CD 0.400% 4/17/14
1,500,000
1,500,000.00
1,503,837.53
3,837.53
6,000.00
0.40%
1%
First Nad Bk NE CD 0.600% 6/20/14
250,000
250,000.00
250,091.82
91.82
1,500.00
0.60%
0%
Goldman Sachs Bk CD 1.200% 2/13/18
245,000
245,000.00
242,139.78
- 2,860.22
2,940.00
1.21%
0%
Great Southern Bk CD 0.650% 8/10/15
250,000
250,000.00
250,080.55
80.55
1,625.00
0.65%
0%
Harris Bank CD #6900310796 0.712%
5,044,581
5,044,581.36
5,051,371.23
6,789.87
35,917.42
0.71%
39%
Harris Bank CD #69003111910.56%
5,029,515
5,029,514.63
5,033,835.88
4,321.25
28,165.28
0.56%
3%
Harris Bank CD #6900312041,0.65%
5,027,247
5,027,247.46
5,030,29136
3,043.90
32,677.11
0.65%
3%
Huntington Nat Bk CD 0.500% 5/19/14
2,500,000
2,500,000.00
2,505,581.85
5,581.85
12,500.00
0.50%
1%
Huntington Nat Bk CD 0.550% 3/03/14
2,500,000
2,500,000.00
2,502,192.81
2,192.81
13,750.00
0.55%
1%
Huntington Natl CD 0.500% 5/27/14
2,500,000
2,500,000.00
2,505,542.12
5,542.12
12,500.00
0.50%
1%
Huntington Natl CD 0.650% 6/09/14
2,500,000
2,500,000.00
2,505,618.49
5,618.49
16,250.00
0.65%
1%
Investors Svgs Sk CD 0.500% 7/21/14
250,000
250,000.00
250,612.02
612.02
1,250.00
0.50%
0%
7P Morgan Chase CD 1.125% 2/19/18
1,079,000
1,079,000.00
1,067,492.83
- 11,507.17
12,138.75
1.14%
1%
Key Bank NA CD 0.350% 4/24/14
2,000,000
2,000,000.00
2,001,683.29
1,683.29
7,000.00
0.35%
1%
Key Bank NA CD 0.450% 2/27/15
5,000,000
5,000,000.00
5,004,328.77
4,328.77
22,500.00
0.45%
3%
January 22, 2014
Page 2 of 5
H.
Holdings Detail as of 12/31/2013
City of South Bend Corporate Agency
Asset
Quantity
Tax Cost
Market Value
Gain /Loss
Est. Income
Yield
% Total
Fixed Income
Time Deposits (continued)
Key Bank NA CD 0.450% 3/13/15
5,000,000
5,000,000.00
5,002,730.82
2,730.82
22,500.00
0.45%
3%
Key Bank NA CD 0.450% 7/31/15
3,000,000
3,000,000.00
3,002,785.89
2,785.89
13,500.00
0.45%
2%
Key Bank NA CD 0.600% 12/18/15
2,000,000
2,000,000.00
1,993,320.27
- 6,679.73
12,000.00
0.60%
1%
Lake City Bank CD
5,000,000
5,000,000.00
5,011,095.89
11,095.89
18,000.00
0.36%
3%
Lake City Bank CD
5,000,000
5,000,000.00
5,010,471.23
10,471.23
19,500.00
0.39%
3%
Merchants Bank CD
10,000,000
10,000,000.00
10,017,452.05
17,452.05
35,000.00
0.35%
6%
Merrick Bank CD 0.650% 8/24/15
250,000
250,000.00
249,397.57
- 602.43
1,625.00
0.65%
0%
Sovereign Bank CD 0.650% 6/13/14
250,000
250,000.00
250,547.09
547.09
1,625.00
0.65%
0%
TCF National Bk CD 0.550% 11/20/15
250,000
250,000.00
249,443.22
- 556.78
1,375.00
0.55%
0%
Usameribank CD 0.550% 12/03/15
250,000
250,000.00
249,309.25
- 690.75
1,375.00
0.55%
0%
Val Natl Bk NJ CD 0.600% 7/28/14
250,000
250,000.00
250,608.05
608.05
1,500.00
0.60%
0%
Wells Fargo CD V -A 0.950% 2/28/18
5,000,000
5,000,000.00
4,941,254.79
- 58,745.21
47,500.00
0.96%
3%
Government Agency
FHLB 0.250% 2/20/15
5,000,000
4,994,320.00
5,005,598.61
11,278.61
12,500.00
0.25%
3%
FHLB 0.350% 2/25/14
5,000,000
4,999,150.00
5,007,725.00
8,575.00
17,500.00
0.35%
3%
FHLB 0.375% 1/29/14
5,400,000
5,401,707.08
5,409,522.00
7,814.92
20,250.00
0.37%
3%
FHLB 0.375% 8/28/15
5,000,000
5,005,200.00
5,009,506.25
4,306.25
18,750.00
0.37%
3%
FHLMC 0.350% 3/18/15
10,000,000
10,000,000.00
10,018,113.89
18,113.89
35,000.00
0.35%
6%
FHLMC 0.400% 11/27/15
3,500,000
3,500,000.00
3,498,732.22
- 1,267.78
14,000.00
0.40%
2%
FHLMC 0.625% 12/29/14
2,200,000
2,206,882.07
2,209,580.39
2,698.32
13,750.00
0.62%
1%
FHLMC 1.060% 4/30/18
2,000,000
2,000,000.00
1,944,312.22
- 55,687.78
21,200.00
1.09%
1%
FHLMC MTN 0.350% 6/26/15
5,000,000
4,999,250.00
5,002,143.06
2,893.06
17,500.00
0.35%
3%
FHLMC MTN 0.750% 11/25/14
2,000,000
2,009,126.67
2,012,080.00
2,953.33
15,000.00
0.75%
1%
FHLMC MTN 1.000% 7/30/14
5,000,000
5,032,794.68
5,046,072.22
13,277.54
50,000.00
0.99%
3%
FNMA 0.375% 12/21/15
500,000
499,781.00
499,287.08
- 493.92
1,875.00
0.38%
0%
FNMA 0.500% 3/30/16
3,000,000
3,004,605.02
3,000,551.67
- 4,053.35
15,000.00
0.50%
2%
FNMA 0.500% 5/27/15
10,000,000
10,037,419.85
10,031,222.22
- 6,197.63
50,000.00
0.50%
6%
FNMA 0.625% 10/30/14
9,000,000
9,029,235.91
9,042,651.25
13,415.34
56,250.00
0.62%
5%
FNMA 1.010% 9/06/17
2,000,000
1,999,600.00
1,982,072.78
- 17,527.22
20,200.00
1.02%
1610
FNMA 1.150% 2/28/18
5,000,000
5,000,000.00
4,916,295.83
- 83,704.17
57,500.00
1.17%
3%
Total Fixed Income $170,425,018.05 $170,387,954.89 $- 37,063.16 $958,226.74 0.56% 97%
January 22, 2014
Page 3 of 5
0
Source.
Bank
Total Portfolio
* Market values include accruals.
January 22, 2014
Holdings Detail as of 12/31/2013
City of South Bend Corporate Agency
$174,874,001.43 $174,836,986.53
Page 4of5
$- 37,011..90 $958,702.78 0.55% 100%
Source®
Bank
% Bond
Maturity (Years) Market Value Holdings
00-1 72,170,734.74 42.4%
® 1 - 3 83,123,651.92 48.8%
03-5 15,093,568.23 8.9%
Total $170,387,954.89 100.0%
Ito
% Bond
Credit Rating Market Value Holdings
AAA 79,635,466.69
® NR 90,752,488.20
Total $170,387,954.89
46.7%
53.3%
100.0% GO
* Only fixed income assets are included; Market values include accruals.
January 22, 2014
Fixed Income Summary as of 12/31/2013
City of South Bend Corporate Agency
Asset Class Allocation
Bond
Subclass Market Value Holdings
e Time Deposits 90,752,488.20 53.3%
® Government 79,635,466.69 46.7%
Agency
Total $170,387,954.89 100.0%
% Bond
Duration (Years) Market Value Holdings
Q Less than 1.00 77,422,238.62 45.4%
❑ 1.00 - 3.00 77,872,148.04 45.7%
❑ 3.00 - 5.00 15,093,568.23 8.9% Ll
Total $170,387,954.89 100.0% Ito
Page 5 of 5
City of South Bend Administration & Finance Policy Manual
4SpUT11
'17 Z Cyr1�
\.' 6
2.99 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.
Approved By: City Controller Approved By: Mayor
AF Policy 211 Stale Dated Check Policy.doc Page 2 of 2
12
City of South Bend Administration & Finance Policy Manual
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 By: City Controller Approved By: Mayor AF Policy 2.11 State Dated Check Policy.doc Page 2 of 2
Approved By: City Controller Approved By: Mayor
AF Policy 2. 11 Stale Dated Check Policy. doc Page 2 of 2
13
South Bend
Board of Finance
Annual Investment Report
For the year ended December 31, 2013
Payroll Stale Dated Checks
The current policy, as defined and approved by the Board of Finance, has defined that payroll checks
drawn on city accounts will have a two (2) year active life from the date of issuance as noted on the
check. Un- cashed checks, beyond the two (2) year active life period, are no longer valid and shall be
classified as a stale dated check.
Such checks, defined as stale dated, will be reported to the Board of Finance with a recommendation
from the City Controller on the disposition of the stale dated checks.
Therefore, the following represents the list of Stale Dated Payroll Checks as of December 31, 2013.
Ck #
Name
Date
$ Amount
Fund #
Fund Name
Payroll
376062
Bueno, Mercedez
11/10/2011
45.26
203
Recreation
376085
Summers, Ronald
11/10/2011
37.14
203
Recreation
376342
Danik, Matthew J
11/23/2011
I 29.64
I 203
I Recreation
377734
Jones, Tyree A
12/23/2011
14.82
610
Solid Waste
Total
126.86
City Recommendation
The City of South Bend recommends that such payroll checks, classified by city policy as stale dated, to
be approved by the Board of Finance for cancellation. Said checks, shall be voided within the city's
payroll system and removed as a payroll liability of the City of South Bend.
Indiana Statute, allowing cancellation and voidance of un- cashed payroll checks defined as stale dated,
will remain subject to claim by the payee for a period of seven (7) years from date of issuance. The City
will maintain record of these potential liabilities in the event a claim is made by any payee.
14
City of South Bend
Board of Finance
Annual Investment Deport
For the year ended December 39, 2093
Accounts Payable Stale Dated Checks
The current policy, as defined and approved by the Board of Finance, has defined that disbursement
checks drawn on city accounts will have a two (2) year active life from the date of issuance as noted on
the check. Un- cashed checks, beyond the two (2) year active life period, are no longer valid and shall be
classified as a stale dated check.
Such checks, defined as stale dated, will be reported to the Board of Finance, with a recommendation
from the City Controller on the disposition of the stale dated checks.
Therefore, following represents the list of stale dated disbursement checks as of December 31, 2013.
Ckock
#
Name
Date
. ----
Amount
E d # I
Fund Name
397958
Montague, James A.
02/04/2010
68.35 1_
620 1
Water Works Operations
406687
Rettke, Casey
08/04/2010
90.80 1
620 1
Water Works Operations
414438
State of Indiana
01/17/2011
5.00
226 1
Liability Insurance
415273
Ciullo, Jay
02/04/2011
14.27
620 1
Water Works Operations
415288
Jones, Larry
02/04/2011
40.00
620
Water Works Operations
415289
Group LLC
02/04/2011
20.00
620
Water Works Operations
415294
lalactus
ckson, Linda
02/04/2011
13.64
620
Water Works Operation
415518
Mdwise Select Health Network
02/07/2011
117.46
288
EMS
415801
Gregory ABT
02/14/2011
26.87
288
EMS
416170
Julia Mark
02/21/2011
290.99
288
EMS
1.416484 1
Nicole Houghton
02/28/2011
62.00
203 1
Recreation
416569
Hardman, Damon
03/04/2011
40.00
620 1
Water Works 'O erations
417288
Horvath, Mark
03/21/2011
7.47
203
Recreation
417306
{ Cullens, Jalen
03/21/2011
137.75
203
Recreation
418916
Amkor Wig Shop
04/07/2011
16.17
620
Water Works Operations
418206
Burnett, Joseph
04/07/2011
40.00
1 620
Water Works Operations
420438
Tiller -Hill, Lenoria
05/24/2011
50.00
1 620
Water Works Operations
420441
Stalling, lesha
05/24/2011
10.00
1 620
Water Works Operations
420807
Chi o Malekanol
05/31/2011
124.21
620
1 Water Works Operations
420808
K & S Land Trust
05/31/2011
72.61
620
Water Works Operations
420810
Caleb Holzwart
05/31/2011
81.28
620
Water Works Operations
422529
Tw ckenham Estates LLC
07/08/2011
59.28
620
Water Works Operations
422542
1 Wesolowski, S
07/08/2011
171.27
620
Water Works Operations
422547
Gassensmith, Mercedes
07/08/2011
38.58
620
Water Works Operations
422551
Camacho, Jacqueline
07/08/2011
11.67
620
1 Water Works Operations
422577
Boodt, Lisa
07/08/2011
4.06
1 620
1 Water Works Operations
422579
Carpenter, Kendra
07/08/2011
5.43
620.1
Water Works Operations
422588
1 Melendez, Carlos
07/08/2011
( 7.10
6201
Water Works Operations
1422590
1 Alock, John
07/08/2011
3.79
620
1 Water Works Operations
422595
1 Wilford, Cedrick
1 07/08/2011
12.48
1 620
1 Water Works Operations
422600
Hamann for Mayor
07/08/2011
1 25.53
1 6201
Water Works Operations
422602
1 Smith, Trana K
07/08/2011
20.00
620
1 Water Works Operations
1422607
1 Demetrio, Thomas
07/08/2011
I 10.68
1 620
j Water Works Operations
15
422613
Linda Chism
07/08/2011
40.00
620
Water Works Operations
425348
Yanez, Louis
09102/2011
49.82
620
Water Works Operations
425370
Famoso, Monica
09/02/2011
40.00
620
Water Works Operations
425396
Gravell, Ralph
09/02/2011
33.42
620
Water Works Operations
425397
Nalezn , Emma K
09/02/2011
13.72
620
Water Works Operations
425398
Swan, Ryan
09102/2011
4.06
620
Water Works Operations
425400
Vanderwende, Nick
09/02/2011
_
9.15
620
Water Works Operations
425481
Ambassadors for Christ Church
09/06/2011
378.00
101
General Fund
427261
Taylor Walter
10/11)/2011
500.00
203
Recreation
428316
_
Coc u t, John C.
11104/2011
40.00
620
Water Works Operations
428325
Hathom, E W
11/04/2011
364.85
620
Water Works Operations
428353
Trainor Glass
11/04/2011
92.09
620
WaterWorks Operations
428364
Peg y, Shawntalia
11/04/2011
20.00
620
Water Works Operations
428989
Neer, Christopher
11/15/2011
82.22
620
Water Works Operations
428992
Homecomings Financial
11/15/2011
38.37
620
Water Works Operations
428994
US Bank NA As Trustee
11/15/2011
127.28
620
Water Works Operations
428995
Weils Fargo Bank Minesota
11/15/2011
41.87
620
Water Works Operations
428998
JP'Mor an Chase Bank
11/15/2011
35.50
620
Water Works Operations
429002
Washington Mutual Bank
11/15/2011
26.62
620
Water Works Operations
429005
JP Morgan Chase Bank
11/15/2011
36.88
620
Water Works Operations
429007
HSBC Bank USA as Trustee
11/15/2011
240.24
620
Water Works Operations
429009
TRI State MTG
11/15/2011
34.27
620
Water Works Operations
429001
Deutsche Bank National Trust
11/15/2011
153.04
620
Water Works Operations
429012
Homecomings Financial Network
11/15/2011
94.91
620
Water Works Operations
429013
WM Special MTG LLC
11/15/2011
48.50
620
Water Works Operations
429016
US Bank as Custodian
11/15/2011
59.91
620
Water Works Operations
429017
Deutsche Bank Trust
11/15/2011
27.53
620
Water Works Operations
429019
Affordable Property Management
11/15/2011
43.79
620
Water Works Operations
429020
Deutsche Bank Trust
11/15/2011
127.79
620
Water Works Operations
429021
US Bank NA
11/15/2011
58.58
620
Water Works Operations
429022
National Ci Bank
11/15/2011
6.10
620
Water Works Operations
429025
Associates Home Equity
11/15/2011
108.55
620
Water Works Operations
429028
HSBC Bank USA
11/15/2011
43.00
620
Water Works Operations
429029
Associates Financial Services
11/15/2011
99.05
620
Water Works Operations
429031
Deutsche Bank National Trust
11/15/2011
77.64
620.
Water Works Operations
429037
James Bishop
11/15/2011
57.44
620
Water Works Operations
429039
Wayne and Jocelyn Ra buck,
11/15/2011
58.29
620
Water Works Operations
429041
Jeremie Shenman
11/15/2011
38.72
620
Water Works Operations
429046
1042 N. Elmer Land Trust
11/15/2011
53.00
620
Water Works Operations
429047
David and Carla Leitch
11/15/2011
41.40
620
Water Works Operations
429048
Lesley Levits
11/15/2011
31.43
620
Water Works Operations
429049
Leon and Deborah Grim
11/15/2011
41.83
6201
Water Works Operations
429050
Theresa McCubbins and Louis
11/15/2011
70.54
620
Water Works Operations
429052
Marilyn Shelton
11/15/2011
31.29
620
Water Works Operations
429053
Cristine Murray
11/15/2011
163.28
620
Water Works Operations
429054
Shelly Rupert
11/15/2011
56.38
620
Water Works Operations
429059
Debbie McAlpine
11/15/2011
178.27
620
Water Works Operations
429062
Charles Lee Nelson
11/15/2011
133.32
620
Water Works Operations
429063
Irene Muikia
11/15/2011
49.81
620
Water Works Operations
429064.
Michael A lin
11/15/2011
26.55
620
Water Works Operations
429065
Charles Baariu
11/15/2011.
89.30
620
Water Works Operations
429068
Jesse Snowden
11/15/2011
41.45
620
Water Works Operations
429070
1 Dara Marvel
11/15/2011
82.25
620
1 Water Works Operations
16
429074 1
Steve Purvis
11/15/2011
55.96
620
Water Works Operations
429075
Brian Woods
11/15/2011
74.89
_
620
Water Works Operations
429079 1
Fred Johnson
11/15/2011
56.03
620
Water Works Operations
429080
James Moore
11/15/2011
42.81
620
Water Works Operations
429082
B adley A Clark Jr.
11/15/2011
67.19
620
Water Works Operations
_429083
429084
Dwaine Goshen
Joel and Stephanie Beernier
11/15/2011
11/15/2011
69.90
98.93
620
620
Water Works Operations
Water Works Operations
429087
Virginia Wawrz nick
11/15/2011
69.50
620
Water Works Operations
429088
John Njoery
11/15/2011
26.33
620
Water Works Operations
'429092
John Blasko and Nicole Smith
11/15/2011
88.00
620
Water Works Operations
429093
KeIly Uller
11/15/2011
66.53
620
Water Works Operations
429105
Pamela Swartz
11/15/2011
107.77
620
Water Works Operations
429106
Elaine Cole
11/15/2011
68.68
620
Water Works Operations
429108
Russell Basham
11/15/2011
60.89
620
Water Works Operations
429109
Frank and Christine Richmond
11/15/2011
56.69
620.1
Water Works Operations
429114
Ronald Jackson
11/15/2011
73.71
620
Water Works Operations
429115
Donald Turner
11/15/2011
50.00
620
Water Works Operations
1__4f2_ 9122
Robert and Cecelia Stone
11/15/2011
38.28
620
Water Works Operations
429124
Elhassani Salaheddine
11/15/2011
51.18
620
Water Works Operations
429127
1G LLC
11/15/2011
64.09
620
Water Works Operations
429142
Brantner and Sally Hackman
11/15/2011
72.79
620
Water Works Operations
429146
Matthew and Kathie Forti
11/15/2011
64.77
1 620J
Water Works Operations
429499
Miester Medde
11/21/2011
75.94
620
Water Works Operations
429502
Catherine Schlemmer
11/21/2011
82.71
620
Water Works Operations
429504
SB Invest Holding LLC
11/21/2011
109.46
620
Water Works Operations
429791
Myers, Michelle
12/02/2011
3.10
620
Water Works Operations
429800
F McCra , L E
12/02/2011
6.86
620
Water Works Operations.
429923
Lar Zielinski
12/05/2011
157.94
201
Parks and Recreation
430987
Allison Loomis
12/19/2011
697.97
226
Liability Insurance
431082
K and S Land Trust
12/28/2011
69.23
620
Water Works Operations
431087
Paul C. Kusbach
12/28/2011
119.80
620
Water Works Operations
431758
Christina St lianou
01/17/2012
27.00
203
Recreation
432192
I Chase Manhattan Bank
01/27/2012
53.81
620
I Water Works Operations
Total
$8,968.78
City Recommendation
The city recommends that such accounts payable checks, classified by city policy as stale dated, to be
approved by the Board of Finance for cancellation. Said checks, shall be voided within the city's accounts
payable disbursement system and removed as a liability of the City of South Bend.
Indiana Statute, allowing cancellation and voidance of un- cashed disbursement checks defined as stale
dated, will remain subject to claim by the payee for a period of seven (7) years from date of issuance. The
city will maintain record of these potential liabilities, in the event a claim is made by any payee.
17
1„ 1
City of South Bend
Controller's Cash Report
Month of. December 2093
Special Revenue Funds
Opening
Interest
Transfers
Transfers
Ending
Total Cash &
lnterfundLoans
Fund
Fund Name
Cash Balance
Receipts
Disbursements
Earned
in
Out
Cash Balance
Investments
Investments
(Borrowing)
Special Revenue Funds
102 RAINY DAY FUND
8,615,628.58
0.00
0.00
2,076.03
0.00
0.00
8,617,704.61
D.00
8,617,704.61
O.DO
201 PARKS & RECREATION
1,614,561.64
3,75D,016.07
900,070.67
476.81
0.00
209,824.00
4,255,159.85
0.00
4,255,159.85
0.00
202 MOTOR VEHICLE HIGHWAY
4,191,754.42
569,393.25
1,082,256.36
1,023.59
0.00
O.DO
3,679,914,90
0.00
3,679,914.90
0.00
203 RECREATION - NONREVERTING
788,786.12
49,679.03
60,407.90
191.78
0.00
O.DO
778,249.03
0.00
778,249.03
0.00
209 STUDEBAKERIOLIVER REVERTING GRANTS
1,083,125.91
0.00
0.00
260.99
0.00
0.00
1,083,386.90
0.00
1,083,386.90
500,000.00
210 DEPT COMMUNITY INVESTMENT STATE GRANTS
682,452.9B
14,280.35
351,669.62
3,886.70
0.00
O.DO
348,950.41
0.00
348,950.41
0.00
211 DCI OPERATING FUND
1,083,268.61
6,809.37
182,999.66
236.63
0.00
O.DO
907,314.95
0.00
907,314.95
0.00
212 DEPARTMENT OF COMMUNITY INVESTMENT
527,678.40
230,921.07
168,470.44
32.93
0.00
0.00
590,161.96
0.00
590,161.96
0.00
213 POLICE FEDERAL GRANTS
0.00
0.00
0.00
0.00
O.DO
0.0D
0.00
O.OD
0.00
0.00
216 POLICE STATE SEIZURES
151,896.54
7,733.31
1,000.00
36.71
0.00
0.00
158,666.56
0.00
158,666.56
0.00
217 GIFT, DONATION, BEQUEST
74,716.28
0.00
0.00
18.00
0.00
0.00
74,734.28
0.00
74,734.28
0,00
218 POLICE CURFEW VIOLATIONS
11,542.43
2.50
O.DO
2.76
0.00
0.00
11,547.69
0.00
11,547.69
0.00
220 LAW ENFORCEMENT CONTINUING EDUCATION
966,832.17
24,263.57
10,104,00
233.95
0.00
0.00
981,225.69
O,OD
981,225.69
0.00
227 LOSS RECOVERY FUND
7,946,045.94
0.00
11,939.46
1,926.19
0.00
0.00
7,936,032.67
0.00
7,936,032.67
0.00
249 PUBLIC SAFETY L.O.I.T.
1,572,948.63
491,032.15
0.00
292.24
103,271.89
135,350.63
2,032,194.08
0.00
2,032,194.08
0.00
251 LOCAL ROADS & STREETS
1,849,376.09
91,556.87
0.00
441.75
0.00
O.DO
1,941,374.71
O.DO
1,941,374.71
0.00
252 EXCESS WELFARE DISTRIBUTION
1,149.54
0.00
0.00
0.27
0.00
D.00
1,149.81
D.OD
1,149.81
0.00
256 HUMAN RIGHTS - FEDERAL GRANT
489,448.35
2,654.56
25,447.32
119.38
0.00
0.00
466,774.97
0.00
466,774.97
0.00
271 EASTRACE WATERWAY
14,368.80
0.00
0.00
3.47
0.00
O.DO
14,372.27
0.00
14,372.27
0.00
273 MORRIS PACIPALAIS ROYALE MARKETING
27,556.73
422.00
0.00
6.55
0.00
0.00
27,985.28
0.00
27,985.28
0.00
280 POLICE BLOCK GRANTS
3,816.28
0.00
0.00
0.92
0.00
0.00
3,817.20
0.00
3,817.20
0.00
281 DEPT. COMMUNITY INVESTMENT - REV BONDS
27,121.18
0.00
0.00
6.54
0.00
0.00
27,127.72
0.00
27,127.72
0.00
289 HAZMAT
16,203.48
1,990.00
1,990.00
3.91
D.00
0.00
16,207.39
0.00
16,207.39
0,00,
291 INDIANA RIVER RESCUE
96,841.36
O.OD
1,146.73
23.72
0.00
0.DO
95,718.35
0.00
95,718.35
0.00
292 POLICE GRANTS
80,202.62
124,306.25
0.00
0.00
0.00
0.00
204,508.87
0.00
204,508.87
0.00
294 REGIONAL POLICE ACADEMY
68,599.76
0.00
531.55
16.54
0.00
0.00
68,084.75
0.00
68,084.75
0.00
295 COPS MORE GRANT
101,994.74
12,730.00
1,406.91
24.77
0.00
O.DO
113,342.6D
0.D0
113,342.60
0.00
299 POLICE FEDERAL DRUG ENFORCEMENT
391,894.36
13,236.48
20,054.00
83.17
0.00
0.00
385,160.01
0.00
385,160.01
0.00
404 COUNTY OPTION INCOME TAX
15,128,441.47
694,925.59
021,319.83
3,587.63
0.00
0.00
14,905,634.86
0.00
14,905,634.86
2,027,973.00
408 ECONOMIC DEVELOPMENT INCOME TAX
10,230,228.80
831,445.98
221,932.95
2,386.14
0.00
0.00
10,842,127.97
0.00
10,842,127.97
0.00
410 URBAN DEVELOPMENT ACTION GRANT (UDAG)
27,580.44
0.00
0.00
6.62
0.00
0.00
27,587.06
0.00
27,587.06
(2_.027,973.00)
655 PROJECT RELEAF
923,644.87
39,029.68
24,318.97
222.53
0.00
0,00
938,578.11
0.00
938,578.11
0.00
705 POLICE K -9 UNIT
1,937.73
0.00
625.00
0.46
0.00
0.00
1,313.19
0.00
1,313.19
0.00
Total Special Revenue Funds
56,791,645.25
6,956,428.08
3,987,691.37
17,629.68
103,271.89
345,174.83
61,536,106.70
0.00 1
61,536,108.70
500,000.00
tJeot z;ervtce Tuna
313 HALL OF FAME DEBT SERVICE
102,369.18
613,966.48
0.00
0.00
0.00
0.00
716,335.66
0.00
716,335.66
0.00
Capital Project Funds
288 EMS I FIRE DEPARTMENT CAPITAL
1,526,937.70
5,311,085.37
1,284,075.09
636.60
0.00
0.00
5,554,584.58
0.00
5,554,584.58
0.00
377 PROFESSIONAL SPORTS DEVELOPMENT
691,257.49
15D,533.00
0.00
•166.55
0.00
0.00
842,057.05
0.00
842,057.05
0.00
401 COVELESKI STADIUM CAPITAL
26,843.62
O.DO
0.00
6.47
0.00
O.DO
26,850.09
O.DO
26,850.09
0.00
403 ZOO ENDOWMENT
49,002.20
8.37
0.00
11.81
0.00
0.00
49,022.38
0.00
49,022.38
0.00
405 PARK NONREVERTING CAPITAL
378,004.06
2D.OD
15,034.75
77.83
209,824.00
0.00
572,891.14
0.00
572,891.14
0.00
406 CUMULATIVE CAPITAL DEVELOPMENT
608,686.14
233,538.40
56,587.50
161.54
0.00
0.00
785,798,58
0.00
785,798.58
0.00
407 CUMULATIVE CAPITAL IMPROVEMENT
34,367.09
142,348.53
0.00
8.28
D.OD
0.00
176,723.90
0.00
176,723.90
0.00
412 MAJOR MOVES CONSTRUCTION
7,178,531.64
0.00
36,359.50
1,725.78
0.00
0.00
7,143,897.92
0.00
7,143,897.92
5,912,837.01
416 MORRIS PERFORMING ARTS CENTER CAPITAL
431,603.73
25,103.00
0.00
103.46
0.00
0.00
456,810.19
0.00
456,810.19
D.00
2013 December. controllers cash roped - Controflers Cash Repot Page 2 of 6
co
City of South Bend
Controller's Cash Report
Month oh December 2013
434 CREED FUND
(649,944.31)
Opening
0.00
0.00
Interest
Transfers
Transfers
Ending
9,536.69
Total Cash &
Interfund Loans
Fund
Fund Name
Cash Balance
Receipts
Disbursements
Earned
In
I Out
Cash Balance
Investments
Investments
(Borrowing)
434 CREED FUND
(649,944.31)
659,481.00
0.00
0.00
0.00
0.00
9,536.69
0.00
9,536.69
0.00
450 PALAIS ROYALE HISTORIC PRESERVATION
72,679.60
1,168.31
20,470.00
17.39
0.00
0.00
53,395.30
0.00
53,395.30
0.00
677 HALL OF FAME CAPITAL FUND
664,572,77
0.00
6,327.09
161.05
0.00
0.00
658,406.73
0.00
658,406.73
(658,406.73)
Total Capital & Debt Service Funds
11,114.910.91
7,137,352.46
1,418,853.93
3,076.77
209,824.00
0.00
17,046,310.21
0.00
17,046,310.21
5,254,430.28
Enterprise Funds
600 CONSOLIDATED BUILDING DEPARTMENT
183,391.08
63,950.01
95,645.33
44.90
0.00
0.00
151,740.66
0.00
151,740.66
O.DO
601 PARKING GARAGES
1,036,895.40
60,456.95
213,404.28
239.55
0.00
0.00
884,187.62
0.00
884,187.62
0.00
610 SOLID WASTE OPERATIONS
713,691.86
503,817.05
422,423.23
1B7.97
0.00
0.00
795,274.55
0.00
795,274.65
0.00
611 SOLID WASTE CAPITAL
169,850.84
0.00
51,454.72
44.40
0.00
0.00
118,440.52
0.00
118,440.52
0.00
620 WATER WORKS OPERATIONS
3,492,207.40
1,351,217.49
1,145,947.95
759.19
1,186.72
189,667.18
3,509,755.67
0.00
3,509,755.67
0.00
622 WATER WORKS CAPITAL
3,531,761.58
0.00
890.00
853.86
D.OD
0,00
3,531,725.44
0.00
3,531,725.44
0.00
623 WATERWORKS BOND CAPITAL
2,235,208.53
0.00
1,423,216.31
638.04
0.0D
0.00
812,630.26
0.00
812,630.26
0.00
624 WATER WORKS CUSTOMER DEPOSIT
1,451,510.73
20,515.02
19,210.72
349.69
0.00
349.69
1,452,815.03
0.00
1,452,815.03
0.00
625 WATER WORKS SINKING FUND
1,476,371.15
D.00
1,643,239.48
347.48
172,205.00
347.48
5,336.67
0.00
5,336.67
0.00
626 WATER WORKS BOND RESERVE
1,547,848.22
534.00
534.06
365.65
17,462.18
0.00
1,565,576.05
O.DO
1,565,676.05
0.00
629 WATER WORKS RESERVE - 0 & M
2,031,531.68
0.00
0.00
489.55
0.00
489.55
2,031,531.68
0.00
2,031,531.68
0.00
640 SEWER REPAIR INSURANCE
1,333,651.46
50,542.54
20,819.39
321.23
0.00
0.00
1,363,695.84
0.00
1,363,695.84
0.00
641 SEWAGE WORKS OPERATIONS
6,946,240.89
2,041,990.79
1,829,706.30
1,603.27
793.45
774,919.02
7,286,003.08
0.00
7,286,003.08
0.00
642 SEWAGE WORKS CAPITAL
4,639,340.16
O.DO
595,959.43
1,185.28
0.00
0.00
4,044,566,01
0.00
4,044,566.01
0.00
643 SEWAGE WORKS RESERVE - O & M
3,292,599.55
0.00
0.00
793.45
0.00
793.45
3,292,599.55
0.00
3,292,599.55
0.00
645 2006 SEWER BOND
0.00
12.43
12.43
0.00
0.00
0.00
0.00
0.00
0.00
0.00
647 2007 SEWER BOND
5,402.57
0.00
4,262.99
1.30
0.00
0.00
1,140.88
0.00
1,140.88
0.00
649 SEWAGE WORKS BOND SINKING
1,243,862.13
0.00
1,237,364.60
1,39Q,07
774,919.02
O.DO
782,606.62
0.00
782,806.62
0.00
650 CLAY SEWAGE WORKS OPERATIONS
0.00
0.00
0.00
0.D0
0.00
0.00
0.00
0.00
0.00
0.00
651 20078 SEWER BOND
3,640.23
0.00
3,639.00
0.88
0.00
0.00
2.11
O.OD
2.11
0.00
653 SEWAGE WORKS DEBT SERVICE RESERVE
7,286,825.11
0.00
0.00
3.29
0.00
O.DO
7,286,828.40
0.00
7,286,828.40
0.00
658 2010 SEWER BOND CSO PLAN
3,682.28
0.00
1,468.00
0.88
0.00
0.00
2,215.16
0.00
2,216.16
0.00
659 2011 SEWER BOND
8,163,735.07
0.00
317,227.95
1,991.97
0.00
0.00
7,848,499.09
0.00
7,848,499.09
0.00
661 2012 SEWER BOND
18,843,354.01
0.00.
548,972.74
4,045.52
0.00
0.00
16,299,026.79
0.00
18,299,026.79
0.00
664 2013 SEWER REFUND BOND
4,466.63
0.00
D,00
1.10
0.00
0.00
4,467.73
0.00
4,467.73
0.00
670 CENTURY CENTER
968,075.39
1,272,318.49
1,352,918.83
0.00
D.00
0.00
887,475.05
0.00
887,475.05
0.00
671 CENTURY CENTER CAPITAL
1,919,524.55
0.00
161,856.87
31.68
0,00
0.00
1,757,697.36
0.00
1,757,697.36
0.00
Total Enterprise Funds
72,524,668.50
6,265,355.73
11,090,176.61
16,290.20
966,566.37
966,566.37
67,716,137.82
0.00
67,716,137.82
0.00
Internal Service Funds
222 CENTRAL SERVICES
1,102,356.57
1,524,293.78
1,161,194.55
248.96
0.00
0.00
1,465,706.76
0.00
1,465,706.76
0.00
226 LIABILITY INSURANCE
5,573,662.79
1,250,135.75
1,639,661.21
1,360.05
0.00
0.00
5,185,497.36
0.00
5,185,497.38
0.00
278 TAKE HOME VEHICLE POLICE
443,286.95
9,560.00
0.00
105.86
0.00
0.00
452,952.01
0.00
462,962.81
0.00
711 SELF- FUNDED EMPLOYEE BENEFITS
5,925,742.92
988,775.64
1,254,581.50
1,510.04
0.00
0.00
5,661,44710
0.00
5,661,447.10
O.DO
713 UNEMPLOYMENT COMP FUND
254,030.55
15,996.14
10,057.01
60.35
0.00
0.00
260,030.03
0.00
260,030.03
0.00
Total Internal Service Funds
13,299,081.78
3,788,761.31
4,065,494.27
3,285.26
0.00
0.00
13,025,634.08
0.00
13 025,634.08
0.00
Trust & Agency Funds
701 FIREFIGHTERS PENSION 1,401,152.55 50.00 463,528.91 426.67 0.00 O.DO 938,100.31 0.00 938,100.31 0.00
702 POLICE PENSION 2,243,848.72 D.00 535,840.68 648.42 0.00 0.00 1,708,656.46 0.00 1,708,656.46 0.00
703 POLICE/FIRE 1077 STATE PENSION 273.49 0.00 0.00 0.00 0.00 0.00 273.49 0.00 273.49 0.00
709 PAYROLL FUND (393.48) 8,173,611.27 8,170,239.16 0.00 0,00 0.00 2,978.63 0.00 2,978.63 0.00
712 , PUBLIC EMPLOYEES RETIREMENT FUND 695.86 0.00 0.00 D.OD 0.00 0.00 695.88 0.00 695.88 0.00
718 STATE TAX DEDUCTION FUND 261,541.10 294,748.93 261,541.10 0.00 0.00 0.00 294,748.93 0.00 294,748.93 0.00
725 MORRIS/ PALAIS BOX OFFICE 2,580,970.99 0.00 1,241,373.18 0.00 0.00 0.00 1,339,597.81 O.DO 1,339,697.81 0.00
2013 December. controllers cosh report - Controllers Cash Report Page 3 of 6
N
O
City of South Bend
Controller's Cash Report
Month of. December 2013
730 CITY CEMETERY r
I
Opening
I 3
I
Interest
Transfers
Transfers
Ending
I 36,934.10
Total Cash &
Interfund Loans
Fund
Fund Name
Cash Balance
Receipts
Disbursements
Earned
In
Out
Cash Balance
Investments
Investments
(Borrowing)
I
730 CITY CEMETERY r
I
I
I 3
I
I
I 00
I 1 0
I
I 36,934.10
I
Total Trust 8 Agency Funds
25,742.31
0
.3
.
0
0.
4,3
0.I 0
4,32,985.6
0.00
Total City Funds
176,779,281.79
52,117,845.45
36,908,352.10
45,492.10
1,415,013.09
1,415,013.09
192,034,267.24
0.00
192,034,267.24
6,412,837.01
Redevelopment Commission Controlled Funds
25,742.31
0.00
0.00
6.21
0.00
0.00
25,748.52
0,00
25,748.52
0,00
Tax increment Financing Funds
3,681,855.80
D.OD
0.00
739.66
0.00
0.00
3,682,595.46
0.00
3,682,595.46
0.00
324 TIF REVENUE - AIRPORT
19,486,381.26
6,228,798.58
700,031.56
4,730.82
250.36
0.00
25,020,129.46
0.00
25,020,129.46
5,752,006.93
420 TIF DISTRICT- SBCDA GENERAL
1,697,442.73
931,256.34
32,169.68
7,526.44
418.30
0.00
2,604,474.13
0,01)
2,604,474.13
O.DO
422 TIF DISTRICT - WEST WASHINGTON
383,950.30
228,918.51
0.00
93.41
0.00
0.00
612,962.22
0.00
612,962.22
0.00
425 TIF LEIGHTON PLAZA
139,666.83
13,204.99
19,826.79
21.55
0.00
0.00
133,066.58
O.DO
133,066.58
0.00
426 TIF CENTRAL MEDICAL SERVICE AREA
2,942,700.89
608,491.41
319,503.22
723.32
0.00
0.00
3,232,412.40
0.01)
3,232,412.40
0.00
429 TIF NORTHEAST DISTRICT
2,598,515.10
409,648.70
0.00
626.74
0.00
0.DO
3,008,790.54
0.00
3,008,790.54
0.00
430 TIF SOUTHSIDE DEVELOPMENT AREA #1
3,01D,322.13
1,022,878.60
594,367.87
815.06
0.00
0.00
3,439,647.92
0.00
3,439,647.92
0.0D
431 TIF SSDA #2 - ERSKINE COMM
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0,00
0.00
432 TIF SSDA #3 - ERSKINE VILLAGE
6,315,905.69
651,393.90
0.00
1,386.68
O.OD
0.00
6,968,686.27
O.OD
6,968,686.27,
0.00
435 TIF - DOUGLAS ROAD
134,796.93
159,770.93
0.00
32.49
0.00
0.00
294,600.35
0.00
294,600.35
(923,829.00)
436 TIF -NORTHEST RESIDENTIAL
1,630,948.63
922,737.17
0.00
392.99
0.00
0.00
2,554,078.79
0.00
2,554,078.79
(4,989,008.01)
Total Tax Increment Financing Funds
38,340,630.49
11,177,099.13
1,665,899.12
16,349.50
668.66
0.00
47,868,848.66
0.00
47,868,848.66
(160,830.08)
Redevelopment Funds
Pooled Investment Account
1st Source Bank investment Account
Opening
Balance
174,744,865.88
Interest
Net of Fees
21,800.20
Accrued
Income
Changein
Asset Value
Transferin
from Depository
Transfer out
to Depository
Investment
Balance
174,596,059.49
Total Cash &
Investments
174,596,059.49
433 REDEVELOPMENT ADMINISTRATION GENERAL
25,742.31
0.00
0.00
6.21
0.00
0.00
25,748.52
0,00
25,748.52
0,00
439 CERTIFIED TECHNOLOGY PARK
3,681,855.80
D.OD
0.00
739.66
0.00
0.00
3,682,595.46
0.00
3,682,595.46
0.00
454 AIRPORT URBAN ENTERPRISE ZONE
376,280.90
0.00
0.00
90.67
0.00
0.00
376,371.57
0.00
376,371.57
0.00
619 BLACKTHORN GOLF COURSE OPERATIONS
128,450.77
30,118.89
74,840.22
0.00
0.00
0.00
83,729.44
0.00
83,729.44
(6,252,006.93)
Total Redevelopment Funds
4.212,329.78
30,118.89
74,840.22
836,54
0.00
0.00
4,168,444.99
0.00
4,168,444.99
(6,252,0060
Debt Service Funds
Pooled Investment Account
1st Source Bank investment Account
Opening
Balance
174,744,865.88
Interest
Net of Fees
21,800.20
Accrued
Income
Changein
Asset Value
Transferin
from Depository
Transfer out
to Depository
Investment
Balance
174,596,059.49
Total Cash &
Investments
174,596,059.49
315 AIRPORT 2003 DEBT RESERVE
1,038,904.00
0.00
0.00
250.36
0.00
250.36
1,038,904.00
0.00
1,038,904.00
0.00
317 COVELESKI BOND DEBT RESERVE
503,351.13
0.00
0.00
121.28
0.00
0.00
503,472.41
0.00
503,472.41
0.00
319 REDEVELOPMENT BOND - BLACKTHORN GOLF
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
328 SBCDA 2003 DEBT RESERVE
1,735,840.00
0.00
0.00
418,30
0.00
418.30
1,735,840.00
1,735,840.00
0.00
Total Debt Service Funds
3,278,095.13
0.00
0.00
769.94
0.00
668.66
3,278,216.41
0.00
3,278,216.41
0.00
0.00
Total Redevelopment Commission Funds
45,831,055.40
11,207,218.02
1,740,739.34
17,975.98
668.66
668.66
55,315,510.06
0.00
55,315,510.06
(6,412,837.01)
City Operations Total 222,610,33 .19 63,325,063.47 38,649,091.44 63,468.08 1,415,681.75 1 1,415 681.75 247,349,777.30 O.OD 247,349,777.30 0.00
Memo Item
2013 December. controllers cash report - Controllers Cash Report Page 4 or 6
Pooled Investment Account
1st Source Bank investment Account
Opening
Balance
174,744,865.88
Interest
Net of Fees
21,800.20
Accrued
Income
Changein
Asset Value
Transferin
from Depository
Transfer out
to Depository
Investment
Balance
174,596,059.49
Total Cash &
Investments
174,596,059.49
0.00
(126,720.74
D.DO
43,885.85
2013 December. controllers cash report - Controllers Cash Report Page 4 or 6
City of South Bend, Indiana
Interest Earnings Summary - 2013
December 31, 2013
Prepared - January 24, 2014
1st Source 1st Source
Paid Investment Checking Other Total
Month Month Interest Interest Interest(1) Interest
Dec -12
Jan -13
$91,933
$18,219
$4,980
$115,133
Jan -13
Feb -13
78,723
22,510
165,453
$266,687
Feb -13.
Mar -13
70,574
12,360
4,647
$87,581
Mar -13 -
Apr-13
30,172
11,284
4,589
$46,045
Apr -13
May-1 3
34,663
9,960
8,452
$53,074
May -13
Jun -13
86,972
7,810
4,330
$99,112
Jun -13
Jul -13
29,149
11,289
4,383
$44,821
Jul -13
Aug -13
39,021
15,019
35,685
$89,725
Aug -13
Sep-1 3
58,597
12,065
3,961
$74,623
Sep -13
Oct -13
36,151
10,412
10,596
$57,158
Oct -13
Nov -13
18,844
10,496
92,372
$121,711
Nov -13
Dec -13
43,886
8,505
11,077
$63,468
$618,685
$149,929
$350,525
$1,119,139
(1) interest on DCI loaris, Major Moves interfund loans, Key Bank accounts, Bank of New York Mellon accounts.
21
Interest Earnings 2002 -2013
$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 A-T _np - F1
2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013
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
Total 2002 -2013
$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 1 st 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.
22
N
W
City of South Bend, Indiana
Interest Eaminos Summary - 2002 through 2013
December 31, 2013
Prepared - January 27, 2014
Fund Fund 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013
Number Name 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
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
103
Excess Levy
0
0
0
13,820
10,148
0
742
285
395
261
0
0
201
Parks & Recreation
1,336
715
4,11D
15,942
0
4,937
12,910
591
9,423
8,467
14,802
12,082
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
203
Recreation - Non Reverting
3.641
4,074
6,525
114,6134
11,183
22,181
20,904
6,223
2,899
2,006
3,332
2,692
209
Studebaker /Oliver Grants
0
0
0
0
25,516
44,983
63,975
16,413
6.401
4,486
5,485
3,712
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
211
DCI Administration
0
0
0
0
0
0
0
0
0
1,625
3,057
2,610
212
DC 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
216
State Seized Drug Money
0
0
0
0
0
0
0
0
351
336
653
498
217
Gift Donation Bequest
0
0
0
0
0
0
0
0
102
112
287
232
218
SBPD Curfew Violations
0
0
0
0
0
0
0
0
29
28
52
38
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
222
Central Services.
0
0
0
0
0
0
0
0
972
1,917
4,688
3,421
226
Liability Insurance
9,717
12,936
27,596
57,359
87,864
97,529
95,123
21,770
12,954
11,066
23,376
18,597
227
Loss Recovery Fund
0
0
0
0
0
0
0
22.1 B7
16,057
12,545
21,894
18,685
249
Public Safety LOIT Fund
0
0
0
0
0
0
0
0
4 741
2,308
8,296
6,954
250
General Grant
0
0
0
0
0
0
1,160
319
15
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
252
Excess Welfare Distribution
0
0
0
0
0
0
0
0
17,808
6,545
5,407
4
258
Human Rights - Federal Grant
414
2,486
5,303
1.1 447
10,991
10,149
9,328
2,746
1,606
1,404
2,279
1,593
271
Eastrace Waterway
910
576
619
1,428
1,045
1,338
1,194
284
118
78
99
49
272
Special Events
910
576
72
284
210
0
0
0
0
0
0
0
273
MorrislPalais Marketln Fund
0
0
0
0
0
0
90
86
47
60
122
95
278
Police Take Home Liability
0
0
0
0
0
0
0
0
871
833
1,828
1,435
280
Police Block Grants
9 303
5,143
4,011
4,806
1,255
0
0
262
2,031
3,433
459
13
281
Economic Revenue Bond
0
0
0
0
0
0
0
0
88
76
133
93
288
EMS/Fire Dept. Capital
2 326
5,310
8,346
23,079
37,833
32,047
47134
24,891
17,438
15,121
30,051
16,450
289
Hazmat
0
0
0
0
0
0
0
0
21
8
13
40
291
Indiana River Rescue-
0
0
0
0
0
0
0
0
269
195
408
368
294
Regional Police Academy
0
1 0
1,074
2,678
1,560
1,352
1,351
481
285
231
399
268
295
COPS More Grant
0
0
0
0
0
0
0
0
418
323
492
364
299
Federal Drug Enforcement
0
0
0
0
1 2,638
8,187
14,177
2,1356
981
724
941
947
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
310
Studebaker Bond
0
0
0
3,685
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 1
0
0
313
Hall of Fame Debt Service
0
0
0
10,388
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
315
Redev Bond - Airport - Taxable
14134
10,282 1
0
7,759
35,113 1
60,099
61,564
16,949
7,090
5,538
5,571
3,567
316
Redev Bond -Airport - Exempt
6,745
4.848
377
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
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
320
Edit Bond - Plaza Garage-Exempt
9,971
6,934
8,462
17,392
20,739
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
324
TIF Revenue -Airport-.
30,708
33,136
68,642
305,809
606,063
6111.747
719,473
143.202
90,268
68,381
80,260
61,707
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
377
Professional Sports Development
7,531
4,225
5,540
15,702
21,241
23,705
17,892
4 876
3,669
3,415
5,025
2,742
401
Coveleski Stadium Capital
5,451
5,028
6,506
9,974
4,704
9,015
7,462
1,594
370
262
327
92
403
Zoo Endowment
0
0
0
0
335
880
897 1
250
113
97
211
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
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
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
407
Cumulative Capital Improvement
226
1,714
453
505
0
0
0
57
45
36
15
122
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
410
UDAG
2,198
2,102
1,599
3,897
155,290
156,013
144,853
30,480
14,170
2,659
917
88
412
Ma'or Moves Const action 1
0
Ol
0 1
Ol
63,5191
744,851
463,752
113,908
36,180
77,860
394 379
261,866
414
TIF District - Sample/Ewing
4,983
4,582
5 292
5 833
8191
12,163
5,876
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
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
422
TIF District - W. Washin ton
438
501
970
9,884
12 070
13,574
13,029
1,117
1,959
3,141
3,920
1,435
Dept Administrallon/Finance 1/2612014 Pagel
N
City of South Bend, Indiana
Interest Earnings Summary - 2002 through 2013
December 31, 2013
Prepared - January 27, 2014
Fund Fund 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013
Number Name Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual
424
TIF SBCDA- Building Operations
0
0
0
0
j 1,514
0
0
0
0
0' 0
0
425
TIF - Leighton Plaza
0
0
i 0
275
2.387
1,117
3,976
1,037
488
334
383
298
426
TIF - Cent. Mod Sery Area
0
1 0
3,856
27,339
37,495
31,719
52,519
14,711
15,948
10,028
16,841
12,242
427
Redevel ment - TJX '
0
6,587
0
0
0
0
0
0
0
0
0
0
428
Red Dist Capital - AEDA2003
0
0
126,419
194,658
177,528
48,069
10,213
2,725
1,202
0
0
0
429
Northeast Development Area TIF
0
0
0
0
0
0
233
376
345
1,040
5,286
8,057
430
Southside TIF Area #1
0
0
0
0
0
0
0
1,786
8,816
10,154
19,939
17,222
431
Southside TIF #2 - Eskine Commons
0
0
0
0
0
0
0
1,647
10,074
4,029
2,329
0
432
Southside TIF #3 - Eskine Village
0
0
0
0
0
01
0
2,238
11.905
13,192
27,801
18,842
433
Redevelopment Admin General
2,134
1,532
1 1.557
3,679
5,367
3,581
2,822
669
214
107
164
104
434
CREED
0
0
0
22,425
70,155
82,537
67,563
8,287
3,214
1,507
1,259
418
435
Douglas Road TIF
0
0
0
0
0
0
0
0
756
246
723
454
436
Notheast Residential TIF
0
0
0
0
0
0
0
0
1,478
2,266
10,211
8,423
438
Coveleski Bond Construction
0
0
0
0
0
0
0
0
0
5,268
0
0
439
Certified Technology Park
0
0
0
0
0
0
0
0
0
0
3,571
7,207
450
Palais Royale Historic Preservation
0
0
0
0
0
0
136
271
124
118
247
215
454
Airport Urban Enterprise Zone
0
0
0
0
0
0
0
0
741
473
1.323
1 1.289
600
Building Department
2.166
1,590
1.662
.3159
1.557
791
1,440
674
129
113
380
667
601
Parking Garages
0
0
0
0
0
99
0
0
1,207
2,112
4,124
2,408
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,9N
611
Solid Waste Capital
4,720
6,900
5,664
2,527
0
0
0
0
234
210
279
469
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
621
WW SRLF Eq Rapt Cost
0
1,492
1,030
0
0
0
0
0
0
0
0
0
622
Water Works Capital
6,028
19,015
12,121
4,728
0
18INS
13,230
4,240
1,977
1.9D9
6,523
13,79
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
624
Water Works Customer Deposit
23,275
14,037
18.675
1 42.571
56,031
55.4971
47,733
11,614
4,960
3,971
6,864
4,861
625
WW 1993 Sinking Fund
41,628
9,710
0
55,524
65,651
57,907
50,215
4,094
6,260
4,581
3,961
2,064
626
Water Works Bond Reserve
0
0
0
0
0
0
0
0
162
606
3,221
4,767
628
WW SRLF Rev Bd Reserve
28,516
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
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
641
Sewage Works Operations
0
0
8,743
41,178
68,139
221,041
282,825
68,581
24,711
19.879
16.545
16,604
642
Sewage Works Capital
41.628
V10
0
55.524
80.013
75,937
5,673
2,687
1,577
13,101
46,026
26,316
643
Sewage Works Resv - 08M
60,135
33,892
43,577
93,871
124,089
140,000
118,399
27,752
10,034
8,429
15,457
11,036
644
Sewer Water Leak Ins. Fund
0
0
0
0
1,804
1 161
464
0
0
0
0
0
645
2004 -2006 Sewer Bonds
0
0
39,942
232,890
235,216
97 408
1 668
0
97
12
0
0
646
Sewa a Rev Bond Reserve
20,593
12,058
14,714
0
0
0
0
0
0
0
0
0
647
2007 Sewer Band
0
0
0
0
0
202,306
278,351
36.998
3,595
1,352
202
42
849
Sewage Works Bond Sinking
50,268
14,642
11,027
22,438
44 831
29,886
129
0
6,167
t3 987
14,736
10,232
650
Clay Sewage Works Operations
16,056
11.787
14.070
31.648
43 527
44,421
38,408
8,481
2
2
3
2
651
20078 Sewer Bond
0
0
0
0
0
0
469 876
142,314
30,308
2,989
575
69
653
Sewage Works Debt Service Reserve
0
0
0
0
0
0
0
0
14,267
4,901
30,127
3
655 '
Project Releaf
0
0
0
0
0
0
0
0
2,312
2,111
4,230
2,914
656
Sewa a SRLF Rev BD Resv
37,669
22,055
26,915
0
0
0
0
0
0
0
0
0
657
S SRLF EP Rapt Cost Resv
39,391
29,869
38,D28
83,441
11 580
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
659
2011 Sewer Bond
0
0
0
0
0
0 1
0
0 1
0
8,738
91,421
30,970
661
2012 Sewer Bond
0
0
0
0
0
0
0
01
0
0 1
0
65,016
664
2013A Sewer Bonds Refunds
0
0
0
0
0
0
0
0
• 0
0
0
7
670
Century Center
4 013
2 359
551
279
916
972
8,736
21,304
7,288
1,839
228
3,079
671
Century Center Capital
0
0
0
0
0
0
0
0
0
0
365
315
677
Hall of Fame Capital
0
0
0
0
0
22,317
24,403
6,277
4,024
2,910
3.906
2,416
701
Fire Pension
16,161
13,M
17,393
36,176
28,062
11,298
33,589
6,346
6,632
4,330
4,740
2,918
702
Police Pension
16,644
12,567
15,595
.28 822
23 695
3,949
44,011
8,639
7,340
5,510
6.904
5,432
705
K-9 Unit
0
0
0
0
0
0
0
0
4
6
11
7
711
Self- Funded Employee Benefits
8.999
01
14.8671
61.414_
91,183
110,237
169,758 !
50.616
34.807
27.732.
42,730
25,351
713
Unemployment Com Fund
0
0
0
0
0
0
0
0
0
81
101-
524
730
City Cemetary Trust
545
360
465
11106
828
11690
174
357
150
118
202
138
Total Interest
$1,296,410
$661 968
$1,36.7,297 1
$3 392 461
$.66132272
$76010 8 96
SB 281,342
$1 348 289
$809,279
$643 643
$16474,283
$1,119,139
(1) includes NE TIF and Douglas Road
TIF repayment of interest
on advances from Major Moves,
Dept. Administration /Finance 1126/2014 Paget
City of South Bend Administration & Finance Policy Manual
U Cl
2.3.1 Cash Reserve Procedure Effective: January 1, 2010, Revised January 1, 2013,
Revised 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.
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 Fun_ d Name Cash Reserve Policy
101 1 General Fund 25% of annual expenditures
102 —I Rainy Day Fund ----,-- -3%--contingency of total expenditures in prior year
201 Parks & Recreation Fund 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
t
210 Department of Community Investment State
20% of annual expenditures
Grants Fund
Department of Community Investment
211 20% of annual expenditures
Administration Fund
216 Police State Seizures Fund 20% of annual expenditures
--
217 Gift, Donation, Bequest Fund 120% of annual expenditures
218
220
222
226
227
244*
249
251
252
2-5-8
271
273
Police Curfew Violations Fund 20% of annual expenditures
Law Enforcement Continuing Education Fund j 20% of annual expenditures
Central Services Fund 20% of annual expenditures
Liability Insurance Fund 25% of annual expenditures
Loss Recovery Fund
20% of annual expenditures
Emergency Telephone Fund
No reserve requirement
--- -- - ------ -
Public Safety LOIT Fund _ __
_ j 20 %° of annual expenditures
Local Roads & Streets Fund
20% of annual expenditures
Excess Welfare Distribution Fund
20% of annual
Human Rights - Federal Grants Fund
.expenditures -,
-T
t_20% of annual expenditures
Eastrace Waterway Fund
20% of annual expenditures
MPAC/Palais Royale Marketing Fund
20% of annual expenditures
25
Fund F
Fund Name _
_ — -Cash Reserve Polic rte_
_ 278 T
Take Home Police Vehicle Fund ;
_ _ 2
26
Fund
Fund Name
Cash Reserve Policy
No reserve requirement - spend down of available
funds
622*
Water Works Capital Fund
626
Water Works Bond Reserve Fund
100% cash reserves per bond covenants
629
640
641
Water Works Reserve 0 & M Fund
ewerRepa_ir._Insurance Fund
Sewage Works Operations Fund
16.67% of annual operating expenses in fund 620, net
of transfers ......
20% of annual expenditures
5% of annual expenditures
No reserve requirement - spend down of available
funds
16.67% of annual operating expenses in fund 641, net
of transfers
100% reserves of cash available_ __
642 *
Sewage Works Capital Fund
A
Sewage Works Reserve - 0 & M Fund
643
650
Clay Sewage Works Operations Fund
653
Sewage Works Debt Service Reserve Fund
100% cash reserves pi��ILop_q covenants
20% of annual expenditures
20% of annual expenditures
20% of annual ex. enditures
655 -
-Project Releaf Fund
Century Center Fund
670
671
Century Center Capital Fund
677
Hall of Fame Capital Fund
20% of annual expenditures
25% of annual expenditures
26% of annual expenditures
701
Firefighters Pension Fund
702
Police Pension Fund
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
100% cash reserves - trust & agency funds
�
0 of annual expenditures
0 1 100% cash reserves - trust LqgLe�ncX funds —_
j_ 100% cash reserves - trust & gency funds
20% of annual expenditures
No cash reserves - spend down of cash on projects
712
Public Employees Retirement Fund
713
Unemployment Compensation Fund
718
State Tax Deduction Fund
725
Morris I Palais Box Office Fund
City Cemetery Trust
730
Water & Sewer Bond Funds
* change for 2014
27
•e
City of South Bend
Cash Reserves Summary
December 31, 2013
Fund
Fund Name
Cash Outstanding Available Cash Reserve Actual
Balance Encumbrances Cash Requirement Variance Percentage Notes Cash Reserve Policy
City Controlled
Funds
General Fund
_
101
GENERAL FUND
28,299,807.16
828,098.12
27,484,709.03
16,272,893.00
11,191,816.03
. 42%
Propety, taxes in June and December
25% of annual expenditures - higher due to property tax delays
Special Revenue Funds
102
RAINY DAY FUND
8,6117.704.61
0.00
6,617704.61
8,486 515.37
151,18924
3%
No expenditures budgeted
3% contingency of total expenditures In previous fiscal year
201
PARKS 8 RECREATION
4255,159.55
216,349.13
4,038,810.72
3,231,885.75
808 944.97
31%
Propety taxes in June and December
25% of annual expenditures - higher due to property tax delays _
202
MOTOR VEHICLE HIGHWAY
3,679,914.90
802,87720
1 3077037.70
1.835,29920
1,241,736.50
34%
Transfers from EDIT fund
20% of annual expenditures
203
RECREATION- NONREVEFITING
778,249.03
2,975.75
775,27328
312,155.40
403117.88
0%
50%w-
20% of annual expenditures
209
STUDEBAKERIOLIVER REVERTING GRANTS
1,083,386.90
0.00
1,053,336.90
200,1100.00
583,38a.90
108%
20% of annual expendllures
210
DEPT COMMUNITY INVESTMENT STATE GRANTS
348,950.41
0.00
348,950.41
252,155.40
98 795.01
28%
20% of annual expenditures
211
OCI ADMINISTRATION FUND
907,314.96
21,083.09
886,231.86
470,556.20
415,365.66
38%
20% of annual expenditures
212
DCI GRANT FUND
590,181.96
3,099,780.55
2,509818.59)
2509618.59)
O.OD
0%
DO grant fund - COBS, HUD etc
Grant fund - reimbursement grants - no reserves _
215
POLICE STATE SEIZURES
158,888.56
0.DO
158,566.56
9,180.00
149,486.58
346%
7U
20% of annual expenditures
217
GIFT, DONATION BEQUEST
74 734.28
1,31022
73,424.06
Z150.40
1 71273.66
100%
_
2D% of annual expenditures
218
POLICE CURFEW VIOLATIONS
11,647.69
0.00
11,547.69
200.00
11,347.69
1155%
20% of annual expenditures
220
LAW ENFORCEMENT CONTINUING EDUCATION
981 X5.69
24 801.96
958,423.73
95,628.20
880,797.53
200%
20% of annual expenditures
227
LOSS RECOVERY FUND
7 938,032.87
985,804.58
6,970,228.09
105 237.00
6,804 991.09
1325%
W
20% of annual expenditures
249
PUBLIC SAFETY L.O.I.T.
2,032,194.08
0.00
2,032,194.08
1,420 351.40
611,84268
29%
6
Quarterly transfers and settlements
20% of annual nditures
251
ILOCAL ROADS & STREETS
1.941,374.71
42,019.17
1,899,355.54
247184.80
1,65217074.
164%
0
1
20% of annual expenditures
252
EXCESS WELFARE DISTRIBUTION
1,149.81
0.00
1,149.81
0.00
1,149.81
100%
20% of annual expenditures
255
HUMAN RIGHTS - FEDERAL GRANT
468,774.87
0.00
488,774.97
45 788.00
420,988.97
204%
®
20% of annual expenditures
271
EASTRACE WATERWAY
14,37227
346.27
14,026.00
1 69.20
13,956.30
100%
_
20% of annual expenditures
273
MORRIS PACIPALAIS ROYALE MARKETING
27,955.28
0.DO
27,96528
2,029.80
25 955.48
276%
20% of annual expenditures _
280
POLICE BLOCK GRANTS
3,817.20
0.00
3817-20
37.000.00
33,18280)
2%
Police grantfund, reimbursement
20% of annual expenditures
281
REDEVLOPMENT COMMISSION -REV BONDS
27,127.72
0.00
27127.72
5420.40
21,707.32
100%
20% of annual expenditures
289
HAZMAT
16,207.39
0.00
16,207.39
700.00
15,507.39
463%
'
2D% of annual expenditures
291
INDIANA RIVER RESCUE
95,716.35
0.00
95,718.35
18 42520
77 293.15
104%
20% of annual expenditures
292
POLICE GRANTS
204508.87
.01
204,508.88
22000.00
182,508.88
186%
20% of annual expenditures
294
REGIONAL POLICE ACADEMY
88 084.75
0.00
88,084.75
5,700.00
82,384.75
239%
20% of annual expenditures
295
COPS MORE GRANT
113,342.60
0.00
113 342.60
8,396.00
104,946.60
270%
20% of annual expenditures
299
POLICE FEDERAL DRUG ENFORCEMENT
385,160.01
1,499.00
383,661.01
37 714.60
345 946.41
203%
20% of annual expenditures
404
COUNTY OPTION INCOME TAX
905,634.88
220,262.53
14,685,372.33
4,721,708.50
9,983 063.83
158%
50% of annual expenditures - higher due to bonding and rating agencies
408
ECONOMIC DEVELOPMENT INCOME TAX
842,127.97
756 971.03
10,085,158.94
4,496,689.50
5 588,467.44
112%
50% of annual expenditures - higher due to bonding and rating a endes
410
URBAN DEVELOPMENT ACTION GRANT UDAG
27,587.06
0.00
27,587.110
63,62920
26.04214)
10%
''
UDAG revenue Is minimal
20 %0! annual expenditures
655
PROJECT RELEAF
996 578.11
rl
1,302.34
937,275.T7
SS 413.00
650 882.77
217 %
20% of annual expenditures
705
POLICE K -9 UNIT
1,313.19
0000
1,313.19
400.00
913.19
66%
"
20% of annual expendllures
Total Special Revenue Funds
536,106 .70
5, 967, 382.91
66,678,725.89
23,681,249.93
31,897,475.96
Debt Service Fund
313
HALL OF FAME DEBT SERVICE
716,335.86
0.00
718,935.66
253 600.00
482,735.66
1%
Pro et taxes intone and December
20% of annual expenditures - cash Dow problems due to property taxes
Capital Project Funds
288
EMS 1 FIRE DEPARTMENT CAPITAL
5,654 584.58
1,898,108.80
3 858,475.78
2,215,832.60
1 440 843.18 .
33%
0
Bond proceeds received in December
20% of annual expenditures
377
PROFESSIONAL SPORTS DEVELOPMENT
542,057.05
0.00
842 057.05
17b 334.20
666 722.85 I
96%
IT
20% of annual expenditures
401
COVELESM STADIUM CAPITAL
26,550.08
3,540.44 1
- 23,309.65
708.00
22 601.65
658%
20% of annual expenditures
403
ZOO ENDOWMENT
49,022.38
0.00
49022.38
0.00
49022.38 1
100%
to
20% of annual expenditures
405
PARK NONREVERTING CAPITAL
572,891.14
28,417.13
544,474.01
43 463.20
501,010.81
251%
'
20% of annual expenditures
405
CUMULATIVE CAPITAL DEVELOPMENT
785,798.68
0.00
785,798.68
227805.00
557993.58
86%
25% of annual expenditures - hi her due to property lax delays
407
CUMULATIVE CAPITAL IMPROVEMENT
176,723.90
0.00
176,723.90
91,893.75 1
84,830.15
48%
Cigarette and hotel /motel taxes
25% of annual expenditures - higher due to state tax delays
412
MAJOR MOVES CONSTRUCTION
7,143,897.92
1,323,729.67
5820,16825
879,16920
5,140,999.05
171%
W
20% or annual expenditures
416
MORRIS PERFORMING ARTS CENTER CAPITAL
456,810.19
0.00
456,810.19
14,53320
442,276.99
820%
20% of annual expenditures
434
CREED FUND
9,536.69
0.00
9,635.69
218,48725
208,950.56)
1%
SCREED
reclass07ation In December
25% of annual expenditures - higher due to slate tax delays
450
PALAIS ROYALE HISTORIC PRESERVATION
53,395.30
0.00
53,395.30
0.00
53,395.30
100%
20% of annual expend1lures
677
HALL OF FAME CAPITAL FUND
868,408.73
8,907.66
649,498.87
35,864.40
613,634.47
362%
20% of annual expenditures
Total Capital 6 Debt Service Funds
17,046,31021
3,262,703.90
13,763,606.31
3,956,490.80
9,827,11551
Enterprise Funds
600
CONSOLIDATED BUILDING DEPARTMENT
151,710.86
14,054.50
137,686.18 ji
229,630.40
91,94424)
12%
Cash reserves less than target
2D% of annual expenditures
601
PARKING GARAGES
884,187.82
68,829.81
795,557.61 1
225.987.80
569,590.01
70%
20% of annual expenditures
Casa R- R.W
1r2412014
Paaa 2
fV
CD
City of South Bend
WATER WORKS OPERATIONS
3509,755.67
158,13263
3,351,823.04
739,797.35
Cash Reserves Summary
622
WATER WORKS CAPITAL
3,531,725.44
24,757.50
3,506,967.94
December 31, 2013
3,283 609.54
823
WATER WORKS BOND CAPITAL
812,630.26
558,26023
Fund
Fund Name
254 370.03
cash
Outstanding
Available
Cash Reserve
Actual
1,452 815.03
0,00
625
Balance
Encumbrances
Cash
Re uirement
Variance Percentage Notes Cash Reserve Policy
610
1SOUOWASTE OPERATIONS
WATER WORKS BOND RESERVE
1 795,274.55
61,763.901
733,510.851
1,129,595.801
(398,086.15)1 13 %1
�
I Hlgh blanket encumbrances, cash ok
120% of annual expencillures
R71
S" IA WASTE r:APrTAI
1.25025
11R ddfl 59
1Rn fNIR M
rd1 R77 dRl
n M
_ ,___.,
Id1 R9I dRI i
I '•
111,188.80
rJn Pu¢on,er_ _ r.onefe. r n,n n.,e.- „i,.,. �,.rn,.n, r.,� non,
620
WATER WORKS OPERATIONS
3509,755.67
158,13263
3,351,823.04
739,797.35
2,611,825.69
622
WATER WORKS CAPITAL
3,531,725.44
24,757.50
3,506,967.94
243,358.40
3,283 609.54
823
WATER WORKS BOND CAPITAL
812,630.26
558,26023
254,370.03
0.00
254 370.03
824
WATER WORKS CUSTOMER DEPOSIT
1,452.815.03
0.00
1,452,815.03
1,452 815.03
0,00
625
IWATER WORKS SINKING FUND
5,336.87
0.00
5,336.67
0.00
6.338.67
626
WATER WORKS BOND RESERVE
1,585,876.05
0.00
1,565,878.05
1,565,876.05
0.00
629
WATER WORKS RESERVE - 0 & M
2,031.531.65
0.00
2031,531.68
1.25025
2.030A1.43
640
SEWER REPAIR INSURANCE
1.303,695.841
2,441.68
1 1,361,254.16
111,188.80
1,260,085.36
841
SEWAGE WORKS OPERATIONS
7286,003.08
1899,691.91
5,586,311.17
1,765,937.00
3820374.17
842
SEWAGE WORKS CAPITAL
4,044,568.01
5,740.381143
(1,696,795.a2)
2,299,914.20
3,905,710.02
643
SEWAGE WORKS RESERVE -O &M
3,29Z599.55
2.001
3,292,599.55
3,000.60
3289598.95
645
2008 SEWER BOND
0.00
.001
0.00
0.00
0.00
847
78 BOND
1,140.88
1,137.76
3.12
0000
3.12
649
SEWAGE WORKS BOND SINKING
782,805.62
0.00
782 806.82
0.00
782,808.62
650
CLAY SEWAGE WORKS OPERATIONS
1 0.00
0.00
0.00
0.00
0.00
651
20078 SEWER BOND
211
0.D0
2.11
0.00
2.11
853
SEWAGE WORKS DEBT SERVICE RESERVE
7,286,828.40
0.00
7,286,828.40
7,286,828AO
0.00
658
12trio SEWER BOND
1 2,215.16
0.00
2,215.16
0.00
2,215.16
BOND
1_829_2%1
v
2,970.53
695.89
16.67% of annual operating expenses in fund 641, net of transfers
2,970.03
895.88
I
0.00
0:00
Bond fund - spend down t0 zero - no reserves
1
1DO %cash reserves - trust & agency funds
10D% cash reserves - trust & agency funds
Bond fund - spend down to zero - no reserves
STATE TAX DEDUCTION FUND
294,748.93
0.00
No Reserves - transfer from operating account for debt service as
0%
0.00
100%
100% reserves of cash available
0
725
Bond fund - spend down to zero - no reserves required
1 oo %!,
o.cal
1,339,597.81
100% cash reserves per bond covenants and Crowe Horweth
0.00
100%
Bond fund - spend down to zero - no reserves required
100% cash reserves - trust & agency funds
730
CITY CEMETERY TRUST
Bond fund - spend down to zero - no reserves required
10,595.00
j
3,000.00
Bond fund - spend down to zero - no reserves required
176%
Bond fund - wend dawn to zero - no reserves reauired
278 TAKE HOME VEHICLE POLICE 452,952.81 0.00 452,852.81 20,740.00 432 212.01 437% tY 20% of annual expenditures
711 SELF - FUNDED EMPLOYEE BENEFITS 5.681,447.10 0.00 5,881,447.10 3,337,207.25 2,324,239.85 42% 25% of annual expenditures • hi9_her reserves for future deims
713 1 UNEMPLOYMENT COMP FUND 260.030.03 1 0.00 1 260.030.03 1 53.449.401 208,580.63 1 97%1W 1 Rates chareed to departments reduced 20% of annual expenditures
708
712
PAYROLL FUND
PUBLIC EMPLOYEES RETIREMENT FUND
2,970.53
695.89
0.00 1
0.00
2,970.03
895.88
2.971012 1
895.88
0.00
0:00
100%1%0
i OD%
1
1DO %cash reserves - trust & agency funds
10D% cash reserves - trust & agency funds
718
STATE TAX DEDUCTION FUND
294,748.93
0.00
294,748.93
294,748.93
0.00
100%
180% cash reserves - trust & agency funds
725
MORRIS / PALAIS BOX OFFICE
1,339,597.81
o.cal
1,339,597.81
1,339 597.81
0.00
100%
100% cash reserves - trust & agency funds
730
CITY CEMETERY TRUST
36,934.10
10,595.00
26,339.10
3,000.00
23 339.10
176%
20% of annual expenditures
Total Trust & Agency Funds
4,321,985.61
10,695.00
4,311,390.61
4,848,584.99
(537,194.38)
Total Ct Funds
191,937,277.03
26136 46211
166,800,824.92
71,672 99.80
96126 5.12
Redevelopment
commission Controlled Funds
I 422 I IIt- Ulb I KIUI - VVtSI WASMINU I UN I 01Z,96Z.ZZ I 8,019.551 504,342.511 157,ZIx1.751 4:f7,13a.0Z I 90 %I V 1 12591. of annual expenditures- hinher due to oroDertv tax delays I
Cash Reserve Report
1/24/2014
taxes In June and December
PAPS 3
co
City of South Bend
Cash Reserves Summary
December 31, 2013
Fund
Fund Name
Cash Outstanding Available Cash Reserw Actual
Balance Encumbrances Cash Re uirement Variance Percentage Notes Cash Reserve Policy
436
TIF- NORTHEST RESIDENTIAL
2 554 078.79
0.00
2,554,076.79
807,469.25
1,748,589.54
79%
0
Pmpetv taxes In June and December
25% of annual expenditures- higher due to property tax delays
_
Total Tax Increment Financing Funds
47,868,848.68
8,331,622.04
39,537,326.62
12,201,M2.00
27,336,104.62
Redevelopment Funds
433
REDEVELOPMENT ADMINISTRATION GENERAL
25,746.52
0.00
25748.52
1357.40
24391.12
379%
20% or annual expenditures
439
CERTIFIED TECHNOLOGY PARK
3,682.595.48
0.00
3,682,595.46
0.00
3,882 595,46
100%
0
No 2013 ndlture bud et
_
20% of annual expenditures
454
AIRPORT URBAN ENTERPRISE ZONE
376,371.57
0.00
376,371.57
0.00
376,371.57
100%
No 2013 expenditure budget
20% of annual expenditures
819
BLACKTHORN GOLF COURSE OPERATIONS
83,729.44
0.00
83,729.44
399 541.20
315,611.76)
4%
Cash reserves less than target
20% of annual expenditures
I
Total Redevelopment Funds
4,168,444.99
0.00
4,168,444.99
400,898.60
3,767,546,39
IDebt Service Funds
315
AIRPORT 20D3 DEBT RESERVE
1,036.904.00
0.00
1,038 904.00
1,0311,904.00
0.00
100%
100% debt service reserve per bond covenants
317
COVELESKI BOND DEBT RESERVE
503 ,472.41
0.00
503472.41
503,472.41
0.00
100%
100% debt service reserve per bond covenants
319
REDEVELOPMENT BOND - BLACKTHORN GOLF
0.00
0.00
0.00
0.00
0.00
_
D%w
100% debt service reserve per band covenants
328
SBCDA 2003 DEBT RESERVE
1,735,840.00
0.00
1,735,840.00
1,735,840.00
_
0.00
10D%
100% debt service reserve per bond covenants
Total Debt Service Funds
3,276,216.41
0.00
3,278,216.41
3,278,216 .41
0.00
I
Total Redevelopment Commission Funds
68,315,510.06
8,331,52.2.04
46,993.988.02
16,880 337.01
31 103 681.01
city Operetlons Total
247 62,787.09
33.467,970.16
213,7114,812.84
87,552,936.81
128,231876.13
Cash R...- Report
1n4rz014
PW4
General Fund -101
$35,000,000.00
$30,000,000.00
$25,000,000.00 Available Cash
$20,000,000.00
$15,000,000.007
$10,000,000.00 Reserve
Requirement
$5,000,000.00
$-
M M M M T M M M Co M Co M
T T T T T T T T T T
M CL � O C M Q > U
p� V_ � Q �� Q rn Q Z D
T 7
Reserve
Date Available Cash Requirement
31- Dec -12 $ 27,733,383.63 $ 16,173,912.25
31- Jan -13 $ 25,550,484.83 $ 16,173,912.25
28- Feb -13 $ 22,353,542.47 $ 16,173,912.25
31- Mar -13 $ 16,598,780.26 $ 16,233,266.50
30- Apr -13 $ 15,116,269.16 $ 16,233,266.50
31- May -13 $ 12,079,846.98 $ 16,233,266.50
30- Jun -13 $ 29,307,356.46 $ 16,233,266.50
31- Jul -13 $ 27,482,947.63 $ 16,233,266.50
31- Aug -13 $ 22,315,551.29 $ 16,233,266.50
30- Sep -13 $ 18,544,399.98 $ 16,233,266.50
31- Oct -13 $ 16,816,726.59 $ 16,272,893.00
30- Nov -13 $13,615,491.79 $16,272,893.00
31- Dec -13 $27,464,709.03 $16,272,893.00
50%
45%
40%
35% Actual
30% a Percent
20%
15%
10% �^�° Percent
5% Requirement
0%
O O Q} T T r O N O O
C 11 C
O 7 Q U) U z 0
? ? T T Q T T
T T T T
31
Percent
Date
Actual Percent
Requirement
31- Dec -12
43%
25%
31- Jan -13
39%
25%
28- Feb -13
35%
25%
31- Mar -13
26%
25%
30- Apr -13
23%
25%
31- May -13
19%
25%
30- Jun -13
45%
25%
31- Jul -13
42%
25%
31- Aug -13
34%
25%
30- Sep -13
29%
25%
31- Oct -13
26%
25%
30- Nov -13
21%
25%
31- Dec -13
42%
25%
31
Parks & Recreation - 201
$6,000,000.00
$5,000,000.00
$4,000,000.00 Available
Cash
$3,000,000.00 `-
$2,000,000.00 A —0— Reserve
$1,000,000.00 Requirement
N M M M M A M M M M M M M
r r r r r r r r r r r r
a)CO
CL
Ur : Q :3 Q (n 0 Z 0
r � i
r r r r r r r r
40%
35%
30%
25% __, � �, _ °�— Actual
Percent
20%
15%
10% --r--Percent
5% Requirement
0%
M M Q > V
7 N �, O N
D M , , a Q U) v Z
r 7 r Q -'� , r r O r r -
r r r r
Percent
Date
Reserve
Date
Available Cash
37%
Requirement
31- Dec -12
$
4,763,668.60
$
3,223,115.75
31- Jan -13
$
3,563,772.38
$
3,223,115.75
28- Feb -13
$
2,773,384.04
$
3,223,115.75
31- Mar -13
$
1,708,681.50
$
3,223,115.75
30- Apr -13
$
1,052,663.00
$
3,223,115.75
31- May -13
$
866,259.51
$
3,223,115.75
30- Jun -13
$
4,545,667.87
$
3,223,115.75
31- Jul -13
$
4,143,899.98
$
3,223,115.75
31- Aug -13
$
3,304,340.26
$
3,223,115.75
30- Sep -13
$
2,735,245.44
$
3,223,115.75
31- Oct -13
$
2,126,910.16
$
3,231,865.75
30- Nov -13
$
1,330,822.60
$
3,231,865.75
31- Dec -13
$
4,038,810.72
$
3,231,865.75
40%
35%
30%
25% __, � �, _ °�— Actual
Percent
20%
15%
10% --r--Percent
5% Requirement
0%
M M Q > V
7 N �, O N
D M , , a Q U) v Z
r 7 r Q -'� , r r O r r -
r r r r
32
Percent
Date
Actual Percent
Requirement
31- Dec -12
37%
25%
31- Jan -13
28%
25%
28- Feb -13
22%
25%
31- Mar -13
13%
25%
30- Apr -13
8%
25%
31- May -13
7%
25%
30- Jun -13
35%
25%
31- Jul -13
32%
25%
31- Aug -13
26%
25%
30- Sep -13
21%
25%
31- Oct -13
16%
25%
30- Nov -13
10%
25%
31- Dec -13
31%
25%
32
Motor Vehicle Highway - 202
$4,500,000.00
$4,000,000.00
$3,500,000.00
$3,000,000.00 °Available
$2,500,000.00 Cash
$2,000,000.00
$1,500,000.00 1 > -C—Reserve
$1,000,000.00 Requirement
$500,000.00
$-
N CO CO M M CO CO CO CO M M CO
T T T T T T T T T T T
❑ lL Q 3 Q (A O Z❑
T
T T T T T T T T T T T
45%
Percent
Date
Reserve
Date
Available Cash
23%
Requirement
31- Dec -12
$
2,057,519.44
$
1,813,299.20
31- Jan -13
$
1,840,647.98
$
1,813,299.20
28- Feb -13
$
1,556,523.49
$
1,813,299.20
31- Mar -13
$
1,348,215.94
$
1,813,299.20
30- Apr -13
$
3,844,596.47
$
1,813,299.20
31- May -13
$
2,375,503.84
$
1,813,299.20
30- Jun -13
$
2,582,299.16
$
1,813,299.20
31- Jul -13
$
3,701,668.02
$
1,813,299.20
31- Aug -13
$
3,587,289.24
$
1,813,299.20
30- Sep -13
$
3,867,160.45
$
1,813,299.20
31- Oct -13
$
3,728,689.78
$
1,835,299.20
30- Nov -13
$
3,693,079.20
$
1,835,299.20
31- Dec -13
$
3,077,037.70
$
1,835,299.20
45%
Percent
Date
40%
Requirement
31- Dec -12
23%
35%
31- Jan -13
20%
20%
30%
17%
20%
Actual Percent
25%
20%
30- Apr -13
42%
20%
31- May -13
26%
20%
20%
28%
20%
31- Jul -13
15%
��
31- Aug -13
40%
20%
30- Sep -13
43%
—
° Percent
10%
41%
20%
Requirement
5%
20%
31- Dec -13
34%
0%
N M M CO
M T CO M CO M
M CO M
T T T T
U G Q
N CO O
rc'
T T T T T
'�- C r0..
O_ 7 7
T T T
4. > U
O N
Q
❑ ? L1.
Q T � � Q �
Z �
33
Percent
Date
Actual Percent
Requirement
31- Dec -12
23%
20%
31- Jan -13
20%
20%
28- Feb -13
17%
20%
31- Mar -13
15%
20%
30- Apr -13
42%
20%
31- May -13
26%
20%
30- Jun -13
28%
20%
31- Jul -13
41%
20%
31- Aug -13
40%
20%
30- Sep -13
43%
20%
31- Oct -13
41%
20%
30- Nov -13
40%
20%
31- Dec -13
34%
20%
33
Liability Insurance - 226
$6,000,000.00
Available Cash
Requirement
31- Dec -12
$
5,245,130.31
$
728,981.75
31- Jan -13
$5,000,000.00
5,237,429.00
$
728,981.75
28- Feb -13
$4,000,000.00
5,339,402.41
$
728,981.75
--O--Available
$
5,492,965.69
$
728,981.75
Cash
$3,000,000.00
5,485,327.28
$
728,981.75
31- May -13
$2,000,000.00
5,537,525.90
$
728,981.75
— Reserve
$
5,697,952.53
$
728,981.75
Requirement
$1,000,000.00
5,288,540.45
$
728,981:75
31- Aug -13
$
5,269,618.39
$
728,981.75
30- Sep -13
$
5,430,336.47
$
728,981.75
31-'Oct-13
$
p @ LL n
=
Q rn Z p
30- Nov -13
$
5,571,676.20
$
728,981.75
31- Dec -13
$
5,185,497.38
$
Reserve
250%
200%
150%
100%
50%
0%
C
� j M �6
Date
Available Cash
Requirement
31- Dec -12
$
5,245,130.31
$
728,981.75
31- Jan -13
$
5,237,429.00
Date
Available Cash
Requirement
31- Dec -12
$
5,245,130.31
$
728,981.75
31- Jan -13
$
5,237,429.00
$
728,981.75
28- Feb -13
$
5,339,402.41
$
728,981.75
31- Mar -13
$
5,492,965.69
$
728,981.75
30- Apr -13
$
5,485,327.28
$
728,981.75
31- May -13
$
5,537,525.90
$
728,981.75
30- Jun -13
$
5,697,952.53
$
728,981.75
31- Jul -13
$
5,288,540.45
$
728,981:75
31- Aug -13
$
5,269,618.39
$
728,981.75
30- Sep -13
$
5,430,336.47
$
728,981.75
31-'Oct-13
$
5,563,697.82
$
728,981.75
30- Nov -13
$
5,571,676.20
$
728,981.75
31- Dec -13
$
5,185,497.38
$
728,981.75
� �- N (0 c- �- • i 7 N i O N
a UJ � Z p
25%
31- Dec -13 178% 25%
34
Actual
Percent
-�� Percent
Requirement
Percent
Date Actual Percent Requirement
31- Dec -12 180% 25%
31- Jan -13 180% 25%
28- Feb -13 183% 25%
31- Mar -13 188% 25%
30- Apr -13 188% 25%
31- May -13 190% 25%
30- Jun -13 195% 25%
31- Jul -13 181% 25%
31- Aug -13 181% 25%
30- Sep -13 186% 25%
31- Oct -13 191% 25%
30- Nov -13 191%
25%
31- Dec -13 178% 25%
34
Actual
Percent
-�� Percent
Requirement
Percent
Date Actual Percent Requirement
31- Dec -12 180% 25%
31- Jan -13 180% 25%
28- Feb -13 183% 25%
31- Mar -13 188% 25%
30- Apr -13 188% 25%
31- May -13 190% 25%
30- Jun -13 195% 25%
31- Jul -13 181% 25%
31- Aug -13 181% 25%
30- Sep -13 186% 25%
31- Oct -13 191% 25%
30- Nov -13 191%
34
Actual
Percent
-�� Percent
Requirement
Percent
Date Actual Percent Requirement
31- Dec -12 180% 25%
31- Jan -13 180% 25%
28- Feb -13 183% 25%
31- Mar -13 188% 25%
30- Apr -13 188% 25%
31- May -13 190% 25%
30- Jun -13 195% 25%
31- Jul -13 181% 25%
31- Aug -13 181% 25%
30- Sep -13 186% 25%
31- Oct -13 191% 25%
30- Nov -13 191%
Loss Recovery Fund - 227
$9,000,000.00
$8,000,000.00 >
$7,000.000.00
$6,000,000.00 —,—Available
$5,000,000.00 Cash
$4;000,000.00
$3,000,000.00 --o—Reserve
$2,000,000.00 Requirement
$1,000,000.00
O C i C 7 N O N
LL Z ❑
❑i f6 i 3 7 Q (n U
r O
Q
1600%
1400%
1200%
1000% Actual
800% Percent
600%
Percent
400% Requirement
200%
O C LL CC 7 O O O
`- Q rn Z ❑
r' Q O r
� r r � r
Percent
Date
Reserve
Date
Available Cash
822%
Requirement
31- Dec -12
$
4,323,375.44
$
105,237.00
31- Jan -13
$
4,325,602.08
$
105,237.00
28- Feb -13
$
4,327,476.71
$
105,237.00
31- Mar -13
$
4,330,502.38
$
105,237.00
30- Apr -13
$
4,305,322.97
$
105,237.00
31- May -13
$
4,248,806.13
$
105,237.00
30- Jun -13
$
4,241,869.33
$
105,237.00
31- Jul -13
$
8,017,301.53
$
105,237.00
31- Aug -13
$
7,992,320.28
$
105,237.00
30- Sep -13
$
7,983,890.02
$
105,237.00
31- Oct -13
$
7,957,776.85
$
105,237.00
30- Nov -13
$
7,898,750.90
$
105,237.00
31- Dec -13
$
6,970,228.09
$
105,237.00
1600%
1400%
1200%
1000% Actual
800% Percent
600%
Percent
400% Requirement
200%
O C LL CC 7 O O O
`- Q rn Z ❑
r' Q O r
� r r � r
35
Percent
Date
Actual Percent
Requirement
31- Dec -12
822%
20%
31- Jan -13
822%
20%
28- Feb -13
822%
20%
31- Mar -13
823%
20%
30- Apr -13
818%
20%
31- May -13
807%
20%
30- Jun -13
806%
20%
31- Jul -13
1524%
20%
31- Aug -13
1519%
20%
30- Sep -13
1517%
20%
31- Oct -13
1512%
20%
30- Nov -13
1501%
20%
31- Dec -13
1325%
20%
35
Public Safety LOIT - 249
$3,500,000.00
$3,000,000.00
$2,500,000.00 --:,—Available
Cash
$2,000,000.00
$1,500,000.00
$1,000,000.00 Reserve
Requirement
$500,000.00
$-
N M Co M M M M M M M M M
U C .fl C 5 O) Q U > U
7 7 N O O N
45%
40%
35% Actual
30% Percent
25%
20%
15% —C— Percent
10% Requirement
5%
0%
N M M M M M M M_ M M M M Co
r r r r r r r r r r r r
U C
N .Q �- � T C � � O. � > U
(0 N N Q (a O 7 N U O N
O
z �
Percent
Date
Reserve
Date
Available Cash
42%
Requirement
31- Dec -12
$
2,989,940.29
$
1,420,351.40
31- Jan -13
$
1,707,066.63
$
1,420,351.40
28- Feb -13
$
2,198,878.63
$
1,420,351.40
31- Mar -13
$
2,894,230.79
$
1,420,351.40
30- Apr -13
$
1,610,292.75
$
1,420,351.40
31- May -13
$
2,101,634.36
$
1,420,351.40
30- Jun -13
$
2,932,383.17
$
1,420,351.40
31- Jul -13
$
1,648,375.38
$
1,420,351.40
31- Aug -13
$
2,139,726.11
$
1,420,351.40
30- Sep -13
$
2,631,285.15
$
1,420,351.40
31- Oct -13
$
1,081,697.22
$
1,420,351.40
30- Nov -13
$
1,572,948.63
$
1,420,351.40
31- Dec -13
$
2,032,194.08
$
1,420,351.40
45%
40%
35% Actual
30% Percent
25%
20%
15% —C— Percent
10% Requirement
5%
0%
N M M M M M M M_ M M M M Co
r r r r r r r r r r r r
U C
N .Q �- � T C � � O. � > U
(0 N N Q (a O 7 N U O N
O
z �
36
Percent
Date
Actual Percent
Requirement
31- Dec -12
42%
20%
31- Jan -13
24%
20%
28- Feb -13
31%
20%
31- Mar -13
41%
20%
30- Apr -13
23%
20%
31- May -13
30%
20%
30- Jun -13
41%
20%
31- Jul -13
23%
20%
31- Aug -13
30%
20%
30- Sep -13
37%
20%
31- Oct -13
15%
20%
30- Nov -13
22%
20%
31- Dec -13
29%
20%
36
COIT - 404
$16,000,000.00
$14,000,000.00
$12,000,000.00 Available
$10,000,000.00 Cash
$8,000,000.00
$6,000,000.00
Reserve
$4,000,000.00 Requirement
$2,000,000.00
$-
U M L• M
r M M m Q > U
N r N r r �— 7 O T M
O O
c LL q Z Q (n ❑
Q
r
180%
160%
140%
120% Actual
100% Percent
80%
60%
40% - Percent
20% Requirement
0%
N M M M M M M M M M M M M
N (6 N c6 5 O N U O N
Percent
Date
Reserve
Date
Available Cash
158%
Requirement
31- Dec -12
$
14,646,009.47
$
4,629,457.50
31- Jan -13
$
14,043,937.84
$
4,629,457.50
28- Feb -13
$
14,324,313.22
$
4,629,457.50
31- Mar -13
$
14,546,016.24
$
4,629,457.50
30- Apr -13
$
13,577,433.87
$
4,629,457.50
31- May -13
$
13,898,356.40
$
4,629,457.50
30- Jun -13
$
14,106,489.14
$
4,629,457.50
31- Jul -13
$
13,742,205.73
$
4,629,457.50
31- Aug -13
$
14,058,497.85
$
4,629,457.50
30- Sep -13
$
14,316,443.37
$
4,629,457.50
31- Oct -13
$
14,635,975.61
$
4,721,708.50
30- Nov -13
$
14,942,528.27
$
4,721,708.50
31- Dec -13
$
14,685,372.33
$
4,721,708.50
180%
160%
140%
120% Actual
100% Percent
80%
60%
40% - Percent
20% Requirement
0%
N M M M M M M M M M M M M
N (6 N c6 5 O N U O N
37
Percent
Date
Actual Percent
Requirement
31- Dec -12
158%
50%
31- Jan -13
152%
50%
28- Feb -13
155%
50%
31 -Mar -13
157%
50%
30- Apr -13
147%
50%
31- May -13
150%
50%
30- Jun -13
152%
50%
31- Jul -13
148%
50%
31- Aug -13
152%
50%
30- Sep -13
155%
50%
31- Oct -13
155%
50%
30- Nov -13
158%
50%
31- Dec -13
156%
50%
37
EDIT - 408
$12,000,000.00
$10,000,000.00
---c-- Available
$8,000,000.00 Cash
$6,000,000.00
-- t�,_ =Reserve
$4,000,000.00 Requirement
$2,000,000.00
�-- 7 u..
1 ,
C-
120%
Percent
Date
Reserve
Date
Available Cash
y
Requirement
31- Dec -12
$
9,681,669.68
$
4,466,689.50
31- Jan -13
$
8,627,786.20
$
4,466,689.50
28- Feb -13
$
9,173,159.35
$
4,466,689.50
31- Mar -13
$
9,813,962.38
$
4,466,689.50
30- Apr -13
$
8,769,019.26
$
4,466,689.50
31- May -13
$
9,408,926.05
$
4,466,689.50
30- Jun -13
$
9,991,563.47
$
4,466,689.50
31- Jul -13
$
7,961,922.30
$
4,466,689.50
31- Aug -13
$
8,588,537.46
$
4,466,689.50
30- Sep -13
$
9,145,793.98
$
4,466,689.50
31- Oct -13
$
9,731,662.47
$
4,496,689.50
30- Nov -13
$
9,296,619.48
$
4,496,689.50
31- Dec -13
$
10,085,156.94
$
4,496,689.50
120%
Percent
Date
100%
Requirement
31- Dec -12
y
50%
31- Jan -13
97%
--o—Actual
80%
103%
50%
Percent
60%
50%
30- Apr -13
98%
40%
31- May -13
105%
--r—'—Percent
30- Jun -13
112%
50%
Requirement
20%
50%
31- Aug -13
96%
0%
30- Sep -13
102%
50%
31- Oct -13
N M Co
M M M
M M M M M M
103%
r r r
r r r
r r r r r r
QO O
50%
z o
38
Percent
Date
Actual Percent
Requirement
31- Dec -12
108%
50%
31- Jan -13
97%
50%
28- Feb -13
103%
50%
31 -Mar -13
110%
50%
30- Apr -13
98%
50%
31- May -13
105%
50%
30- Jun -13
112%
50%
31- Jul -13
89%
50%
31- Aug -13
96%
50%
30- Sep -13
102%
50%
31- Oct -13
108%
50%
30- Nov -13
103%
50%
31- Dec -13
112%
50%
38
Self- funded Employee Benefits - 711
$8,000,000.00
$7,000,000.00
$6,000,000.00 ---,- Available
$5,000,000.00 Cash
$4,000,000.00
$3,000,000.00 -` -` �_ -'-'�
fir- Reserve
$2,000,000.00 Requirement
$1,000,000.00
$ -
N M 'M M M M M M M M M M
Q Q W O Z O
r � i
1 i r i . r! i 7
r r �'
Reserve
Date Available Cash Requirement
31- Dec -12 $ 7,427,897.64 $ 3,337,207.25
31- Jan -13 $ 7,292,748.29 $ 3,337,207.25
28- Feb -13 $ 7,018,370.79 $ 3,337,207.25
31- Mar -13 $ 7,196,983.44 $ 3,337,207.25
30- Apr -13 $ 7,321,766.97 $ 3,337,207.25
31- May -13 $ 7,536,131.78 $ 3,337,207.25
30- Jun -13 $ 7,345,334.98 $ 3,337,207.25
31- Jul -13 $ 7,117,175.97 $ 3,337,207.25
31- Aug -13 $ 7,122,787.23 $ 3,337,207.25
30- Sep -13 $ 6,960,945.55 $ 3,337,207.25
31- Oct -13 $ 6,291,676.90 $ 3,337,207.25
30- Nov -13 $ 5,925,449.92 $ 3,337,207.25
31- Dec -13 $ 5,661,447.10 $ 3,337,207.25
60%
Cam.
50%
Actual
40% Percent
30%
20% -C--Percent
10% Requirement
0%
Q_ M M Q (n v Z
-� Q -5 O
M
Percent
Date
Actual Percent
Requirement
31- Dec -12
56%
25%
31- Jan -13
55%
25%
28- Feb -13
53%
25%
31- Mar -13
54%
25%
30- Apr -13
55%
25%
31- May -13
56%
25%
30- Jun -13
55%
25%
31- Jul -13
53%
25%
31- Aug -13
53%
25%
30- Sep -13
52%
25%
31- Oct -13
47%
25%
30- Nov -13
44%
25%
31- Dec -13
42%
25%
M