HomeMy WebLinkAbout185462 05/11/2010 CITY OF CARMEL, INDIANA VENDOR: 00351669 Page 1 of 1
i ONE CIVIC SQUARE UMBAUGH ASSOCIATES CHECK AMOUNT: $1,767.29
1 CARMEL, INDIANA 46032 PO BOX 40458
INDIANAPOLIS IN 46240 -0458
CHECK NUMBER: 185462
CHECK DATE: 5/11/2010
DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION
920 4341999 121592 626.27 OTHER PROFESSIONAL FE
920 4341999 121628 1,141.02 OTHER PROFESSIONAL FE
r f l J. Umbaugh Associates
Certified Public Accountants, LLP
8365 Keystone Crossing, Suite 300
P.O. Box 40458
Indianapolis, IN 46240 -0458
(317) 465 -1500
Ms. Diana Cordray, Clerk- Treasurer
City of Carmel
City Hall
One Civic Square
Carmel, IN 46032
Invoice No. 121628
Date 04/28/2010
Client No, C00600
For professional services for Cash Advisory Services rendered in accordance
with the Engagement Letter.
Keystone Ave. 2009 Depository Account 1,141.02
Current Amount Due 1.141.02
See attached for detail of fees.
I.Carmet Keystone Ave. 2009 Depository Account
Cash Advisory Services
Quarterly Fee Calculation
Detail of 1st Quarter 2010
-Keystone Ave. 2 De"positoQ Account
Average Interest
Date Principal Balance Earninvu Fee
1/3112010 9,126,329 1,784 380.26
2/28/2010 9,128,234 1,661 390.34
3/3112010 9,129,956 1,636 390.42
Total Fee for Period Ending March 31, 2010: S 1,141.02
`City of Carmel
Weystone Avenue Investments
Activity and Fund Balance Summa Unaudited
Acco i n>t Name. Keystone Ave. 20309 Depositary Acc ount
Accounts: Wells Fargo Bank #23499600 and KeyBank #949683001759
For Period Ending: March 31 2010
Activity
Date Interest Income' Disbursements Other Withdrawals Other Receipts Balance
12/31/09 9,127,342.06
01/39/10 1,784.08 9,129,126.14
02128/10 1,660.61 9,130,786.75
03/31/10 1,635.77 9,132,422.52
Totals 5,080.46 9,13 2,422.52
1. Interest Income is reported on a cash basis and as such does not include accrued income on investments.
Also, accrued interest paid on securities (if applicable) is netted out of first interest payment.
Securi_.. Face Value Cost Basis Mlatur1 Date Rate
Key Public Money Market Savings Account 6,015,465.06 6,015,465.06 n/a 0.26%
Wells l=argo Institutional Money Market 3,116,957.46 3,116,957.46 n/a 0.15%
Total 9,132,422.52 9,132,422.52
Note This statement is provided for your information only, and is a highlight of the official trust statement
All information in this report was taken from Wells Fargo Bank statements.
Umbaugh Cash Advisory So!` icts. L C
S is a a c st Crra� rr�
a PO X30_N 75f?
t�� a��:� {tifEna 11 15Cr1 i.7t�
aea 3174
h J
il'x ai €al tofu ':.1;`y?CIY,:.
April 27, 2010
Ms. Diana Cordray
Clerk Treasurer
City of Carmel
City Hali, One Civic Square
Carmel, IN 46032
Re: Quarterly Summary Statements for the Keystone Avenue 2009 Depository Account
Dear Diana:
Attached please find our Cash Advisory Services quarterly summary statement for the period
ending March 31, 2010. The statement is a summary of activity and investments in the Wells
Fargo Bank depository account and the Key Public Money Market Savings Account, which
includes interest earned and expenditures for the quarter. It also includes a summary of
investments held in the accounts as of March 31, 2010.
In preparing our summary, we have relied on the accuracy and reliability of information
provided by Wells Fargo Bank and Key Bank. We have not audited, examined or reviewed the
information and express no assurance on it. The attached summary statement is intended solely
for the information and use of management, and is not intended to be and should not be used by
anyone other than management.
We have also attached our quarterly fee bill for the account. We appreciate the opportunity to
serve you and thank the individuals in your organization for their cooperation. If you have any
questions, please do not hesitate to call me at 317 -465 -153 1.
Very Truly Yours,
UM 3
Jc6rey A. Messer
J AM/indm
Enclosures
Prescribed by State Board of Accounts City Form No 201 (Rev. 1995)
ACCOUNTS PAYABLE VOUCHER
CITY OF CARMEL
An invoice or bill to be properly itemized must show: kind of service, where performed, dates service rendered, by
whom, rates per day, number of hours, rate per hour, number of units, price per unit, etc.
Payee
H. J. Umbaugh Associates Purchase Order No. NA
8 365 Keyst C rossing, S uite 300 Terms
Indianapo IN 46240 -0458 Date Due
Invoice Invoice Description Amount
Date Number (or note attached invoice(s) or bill(s))
04 /28/10 121628 Keystone Reconstruction Project $1,141.02
Professional Services
Project 07 -08
Total 1,141. 02
1 hereby certify that the attached invoice(s), or bills(s), is (are) true and correct and I have audited same in accordance
with IC 5- 11- 10 -1.6.
20
Clerk Treasurer
VOUCHER NO. WARRANT NO.
H. J. Umbaugh Associates ALLOWED 20
8365 Keystone Crossing, Suite 300 IN THE SUM OF
Indianapolis IN 46240 -0458
1,141.02
ON ACCOUNT OF APPROPRIATION FOR
H. J. Umbaugh Associates
PO# or INVOICE NO. ACCT #/TITLE AMOUNT Board Members
DEPT.#
NA 121828 4341999 $1,141.02
NA I hereby certify that the attched invoice(s), or
bill(s) is (are) true and correct and that the
materials or services itemized thereon for
which charge is made were ordered and
received except
10 -May 20 10
Total $1,141.02 Signature
Cost distribution ledger classification if Cit En
claim paid motor vehicle highway fund Title
H. J. Umbaugh Associates
Certified Public Accountants, LLP
8365 Keystone Crossing, Suite 300
P.O. Box 40458
Indianapolis, IN 46240 -0456
(317) 465 -1500
Ms. Diana Cordray, Clerk- Treasurer
City of Carmel
City Hall
One Civic Square
Carmel, IN 46032
Invoice No. 121592
Date 04/27/2010
Client No. C00600
Total Fee for Period Ending March 31, 2010;
For professional services for Cash Advisory Services rendered in accordance
with the Engagement Letter.
Keystone Ave. 2007 Depository Account 626.27
Current Amount Due 626.27
See attached for detail of fees.
V
4'
City of Carmel .a
Keystone Avenue Investments
Activity and Fund Balance Summa Unaudited
Account Name: Keystone Ave. 2007 Depository Account
Accounts: KeyBank #949683009742
For Period Ending: March 31 2010
Date Interest Interest Income' Disbursements Other Withdrawals Other Receipts Balance
12/31/09 11,719,531.91
01131/10 1,918.72 6,710,610.92 5,010,859.71
02/28/10 961.07 5,011,820.78
03131110 1,064.27 5,012,885.05
Totals 3,944.06 6,710,610.92 5,012,885.05
1. Interest Income is reported on a cash basis and as such does not include accrued income on investments.
Also, accrued interest paid on securities (if applicable) is netted out of first interest payment.
S ecurity ace Value Cost Basis Matu n ate Rate
Key Public Money Market Savings Account 5,012,885.05 5,012,885.05 nla 0.25%
Total 5,012,885.05 5
Note This statement is provided for your information only, and is a highlight of the official trust statement.
All information In this report was taken from Wells.Fargo Bank statements.
l Carmel Keys 'Ave. 2 0' D e ito j y "A" c' c ou n f
Cash A dvisarj7 Services
Quarterly rw Calculation
Detail of Ist Quarter 2010
keystone Ave'. 2U07 Account
Average Interest
Date Principal Balance Earnings Fee
1 /31 /2010 S 5,008,941 1 1,919 208.71
2/28/2010 5,009.900 961 208.75
3/3112010 5,011,340 1,064 208.81
Total Fee for Period Ending March 31, 2010: S 62617
�I
4 Umbaugh trash Adv+qury Services. LLC
:e 5V �E]:3 NY SI.Jne �r4:35'3^Li
300
9w +o458
m
a e tarslx N V�2'40-015$
mi cnnna 31 �tt1U
M K Fax 31 nP E 0
April 27, 2010
Ms. Diana Cordray
Clerk Treasurer
City of Carmel
City Hall, One Civic Square
Carmel, IN 46032
Re: Quarterly Summary Statements for the Keystone Avenue 2007 Depository Account
Dear Diana:
Attached please find our Cash Advisory Services quarterly summary statement for the period
ending March 31, 2010. The statement is a summary of activity and investments in the Wells
Fargo Bank depository account and the Key Public Money Market Savings Account, which
includes interest earned and expenditures for the quarter. It also includes a summary of
investments held in the accounts as of March 31, 2010.
In preparing our summary, we have relied on the accuracy and reliability of information
1 provided by Wells Fargo Bank and Key Bank. We have not audited, examined or reviewed the
information and express no assurance on it. The attached summary statement is intended solely
for the information and use of management, and is not intended to be and should not be used by
anyone other than management.
We have also attached our quarterly fee bill for the account. We appreciate the opportunity to
serve you and thank the individuals in your organization for their cooperation. If you have any
questions, please do not hesitate to call me at 317 -465 -1531.
Very Truly Yours,
UM AUGH
a
JeVrey A. Messer
JAMlmdm
Enclosures
Prescribed by State Board of Accounts City Form No. 201 (Rev. 1995)
ACCOUNTS PAYABLE VOUCHER
CITY OF CARMEL
An invoice or bill to be properly itemized must show: kind of service, where performed, dates service rendered, by
whom, rates per day, number of hours, rate per hour, number of units, price per unit, etc.
Payee
H. J. Umbaugh Associates Purchase Order No. NA
8365 Keystone Crossing, Suite 30 Terms
Indianapolis IN 46240 -04 Date Due
Invoice Invoice Description Amount
Date Number (or note attached invoice(s) or bill(s))
04/2 7/10 121592 Keystone Reconstruction Pr oject $6 26.27
Professional Services
P 07 -0
Total Y $626.27
I hereby certify that the attached invoice(s), or bills(s), is (are) true and correct and I have audited same in accordance
with IC 5- 11- 10 -1.6.
20
Clerk- Treasurer
VOUCHER NO. WARRANT N0,
H. J. Umbaugh Associates ALLOWED 20
8365 Keystone Crossing, Suite 300 IN THE SUM OF
Indianapolis IN 46240 -0458
626.27
ON ACCOUNT OF APPROPRIATION FOR
H. J. Umbaugh Associates
PO# or INVOICE NO. ACCT /TITLE AMOUNT Board Members
DEPT.#
NA 121592 4341999 $626.27
NA I hereby certify that the attched invoice(s), or
bill(s) is (are) true and correct and that the
materials or services itemized thereon for
which charge is made were ordered and
received except
10 -May 20 10
Total 626.27 Signature
Cost distribution ledger classification if Cit En
claim paid motor vehicle highway fund Title