HomeMy WebLinkAbout182122 02/03/2010 CITY OF CARMEL, INDIANA VENDOR: 00351669 Page 1 of 1
ONE CIVIC SQUARE
UMBAUGH ASSOCIATES
Po BOX 40458 CHECK AMOUNT: $2,967.29
:,r a CARMEL, INDIANA 46032
'--::',4 -6 INDIANAPOLIS IN 46240 -0458 CHECK NUMBER: 182122
CHECK DATE: 213/2010
DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION
920 4341999 119554 2,967.29 OTHER PROFESSIONAL FE
11. J. Um ugh Associates
Certified Public Accountants, LLP
8365 Keystone Crossing, Suite 300
P.O. Box 4045U
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. 120914
Date 01/21/2010
Client No. C00600
For professional services for Cash Advisory Services rendered in accordance
with the Engagement Letter.
Keystone Ave. 2009 Depository Account 1,464.26
tt
Current Amount Due 1,464,20
See attached for detail of fees.
Carmel Keystone Ave. 2009 Depository Account
Cash Advisory Services
Quarterly Fee Calculation
Detail of 4th Quarter 2009
Keystone Ave. 2009 Depository Account
Average Interest
Date Principal Balance Earnings Fee
10/31/2009 11,711 ,268 2,519 487.97
11/30/2009 1 1,714,368 2,084 488.10
12/31/2009 11,716,670 1,840 488.19
Total Fee for Period Ending I)cccrnber 31, 2009: 1,464.26
City of Carmel
4
Keystone Avenue Investments
Activity and Fund Balance Summary Unaudited
Account Name: Keystone Ave. 2009 Depository Account
Accounts: Wells Fargo Bank #23499600 and KeyBank #149683001759
For Period Ending_. December 31,, 2009
Activity
Date Interest Income Disbursements Other Withdrawals I Other Receipts Balance
09130/09 13,436,899.22
10/31/09 3,160.80 1,039,225.35 12,400,834.67
11/30/09 2,432.89 12,403,267.56
12/31/09 2,025.38 3,277,951.88 9,127,342.06
Totals 7,620.07 4,317,177.23 I 9,127,342.06
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.
Security Face Value Ca Basis �l�ati�rity Date Rate I
Key Public Money Market Savings Account 6,011,758.06 6,011,758.06 n /a: 0.26%
Wells Fargo Institutional Money Market 3,115,584.00 3,115,584.00 nia 0,00%
Total 1 9,127,342.06 9,127,342.06 I
Note*** This statement is provided for your information only, and is a highlight of the official trust statement.
Ali information in this was taken from Wells Fargo Bank statements.
c i ce, 14. ,1. Urnbaugh lssoclutes
3 t II t Certr1 €etl LIP
CO l t i 8365 3tevstone Crossing
dl ,l I Sure 300
�mm ,,]r t?0. 6 40458
p w lit IncI■anap0hs, IN 46240-0458
eA r,. Phone' 317 46
k J jr 04 a fox: 317
W w. unbaugh.corn
ICs all atrail estknence
January 22, 2010
Ms. Diana Cordray
Clerk- Treasurer
City of Carmel
City 1 -tall, 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 December 31, 2009. 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 December 31, 2009.
In preparing our summary, we have relied on the accuracy arid 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 sununary statement is intended solely
for the information and use of management, and is not intended to be and should riot 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,
Ui'iBAUGH
1 -1
i
�r
/Jeffrey A. 1G]esser
JA 1VUtrm
Enclosures
Prescribed by Slate Board of Accounts City Farm 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 300 Terms
Indianapolis IN 46240 -0458 Date Due
Invoice Invoice Description Amount
Date Number (or note attached invoice(s) or bill(s))
01/21/10 120914 Keystone Reconstruction Project $1,464.26
Professional Services
Project 07 -08
T Total $1,464.26
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
,4
VOUCHER NO. WARRANT NO.
H. J. Umbaugh Associates ALLOWED 20
8365 Keystone Crossing, Suite 300 IN THE SUM OF
Indianapolis IN 46240 -0458
1,464.26
ON ACCOUNT OF APPROPRIATION FOR
H. J. Umbaugh Associates
PO# or INVOICE NO. ACCT /TfTLE AMOUNT Board Members
DEPT.#
NA 119554 4341999 $1,464.26
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
February 1, 20 10
Total $1,464.26 Signature
Cost distribution ledger classification if City Engineer
claim paid motor vehicle highway fund Title
H. J. Umbau h 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. 120906
Date 01/21/2010
Client No. C00600
For professional services for Cash Advisory Services rendered in accordance
with the Engagement Letter.
Keystone Ave. 2007 Depository Account 1.503.03
Current Amount Due 1 O
See attached for detail of fees.
{Carmel Keystone Ave. 2007 Depository Account
Cash Advisory Services
Quarterly Fee Calculation
Detail of 411, Quarter 2009
Keystone Ave. 2007 Depository Account
Average Interest
Date Principal Balance Earnings Fee
10/31/2009 12,910.352 3,161 537.93
11/30/2009 12,399,254 2,433 516.64
12/31/2009 10.763,075 2,026 448.46
'Total Fee for Period Ending December 31, 2009: 1 ,503.03
City of Carmel Keystone A venue investments
Activity and Fund Balance Surrarsary Unaudited
Account Name: Keystone Ave. 2007 Depository Account
Accounts: Wells Fargo Bank #22567400 and KeyBank #149683001742
For Period Ending: December 31, 2009
Activity
Date interest Income Disbursements Other Withdrawals Other Receipts Balance
09130109 5 11,713,108.41
10/31/09 2,519.44 11,715,627.85
11/30/09 2,083.97 11,717,711.82
12/31109 1,840.09 11,719,551.91
Totals 6,443.50 11,719,551.91
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.
Security Fac iVllue Oa st-4 asis MatuTit ate Rate
Key Public Money Market Savings Account 5,009,795.88 5,009,795.88 n/a 0.26%
Wells Fargo Institutional Money Market 6,709,756.03 6,709,756.03 n/a 0.00%
Total 11,719,551.91 11,719,551.91
Mote 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.
,4 ;4 H. 1 Uiitbaugh Associates
a �+a 3 i Gertifled Public Acooun UP iants, P ll W 4d t! 83f35 Keystone Crossing
XN r e r di Suite 3 00
A s o P0. Box 4045a
i i 9 inWanapei €s. IN 46240 0458
mf
1 m 1 Fax: ln 31 3465 1550
4
!r's Mahout cit rirnx
At
January 22, 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 December 31, 2009. 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 December 31, 2009.
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 naanagernent, 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 Inc at 317 -465 -1531.
Very Truly Yours,
UIkIBAUGH
Jeffrey A`�1Cless
r
JAM/trill s'
..J
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 300 Terms
4 Indianapolis IN 46240 -0458 Date Due
Invoice Invoice Description Amount
Date Number (or note attached invoice(s) or bill(s))
01/21/10 120906 Keystone Reconstruction Project $1,503.03
Professional Services
Project 07 -08
i
Total $1,503.03
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
P
VOUCHER NO. WARRANT NO.
H. J. Umbaugh Associates ALLOWED 20
8365 Keystone Crossing, Suite 300 IN THE SUM OF
Indianapolis IN 46240 -0458
1,503.03
ON ACCOUNT OF APPROPRIATION FOR
H. J. Umbaugh Associates
PO# or INVOICE NO. ACCT /TITLE AMOUNT Board Members
DEPT.#
NA 119554 4341999 $1,503.03
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
February 1, 20 10
Total $1,503.03 Signature
Cost distribution ledger classification if City Engineer
claim paid motor vehicle highway fund Title