186707 06/21/2010 CITY OF CARMEL, INDIANA VENDOR: 363909 Page 1 of 1
ONE CIVIC SQUARE VILLAGE FINANCIAL, LLC CHECK AMOUNT: $115,275.15
CARMEL, INDIANA 46032 ONE PEDCOR SQUARE
770 3RD AVE SW CHECK NUMBER: 186707
CARMEL IN 46032
CHECK DATE: 6/21/2010
DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION
902 4460926 060110 -1 115,275.15 INSTALLMENT PURCHASE
r:
VILLAGE FINANCIAL, LLC
One Pedcor Square
770 3rd Ave. Sly'
Carmel, Indiana 46032
June 1, 2010
The City of Carmel Redevelopment Commission
Attention: Les Olds
INVOICE
Due: July 1, 2010
Charge Date Item Amount
07/07/10 A_dmir strative Fee to Village Financial $5,883.77
07/07/10 Projected Installment Purchase Obligation $112,577.83
07/07/10 Adjusted Quarterly Fee to Regions .Bank $0.00
Offset/Addition Amount* ($3,186.46)
Total Amount Due 115,275.15
Please make payment for Installment Purchase Obligation and Adminstrative Fee payable to Village
Financial and send to Dolores Krohne at the following address:
Village Financial
Attn: Dolores Krohne
One Pedcor Square
770 3rd Ave. SM
Carmel, Indiana 46032
Village Financial, LLC
Offset Account Summary
Due Date Account From CRC Amount Due Difference
4/7/10 Light and Gen $28 843.23 $28,843.23 $0.00
Air Handler $9 $8,822.23 ($731.97)
Acoustical $12,929.07 $12,802.85 (5126.22)
Millwork $30,390.01 $28.061.74 (52,328.27)
Stage $7 $7,779.63 $0.00
(53.186.46)
Projection Notice Backup to CRC
PAC Equipment Loans
Second Quarter 2010
June 1, 2010
Payment Due Date: July 7, 2010
Beginning Date Ending Date
Data., 04108110 7/6/10
NOTE: Interest rate has been confirmed. Need loan statement to nonage remaining balance of loan funds,
Administrative Fee Rate (to Village Financial) 0.061
Fixed
Projected Interest Rate 4.96% a
Projected Interest Rate 4.58% b
Projected Quarterly Fcc Rate Ito Lender) 1.2400090
Loan Loan Amount Advanced Funds Past Disbursements Nevv Disbursements Remaining Balance
PAC Lighting Generator 53 $3,034.000.00 $1,174,050.00 51,200,643.00 1659,307.00
PAC Air Handier $1,005,000Ao 31,1)05,UU0.00 $888,060.00 SW690.00
$50 50.00
PAC Acoustical Equipment 51,360,000.00 51160.000.00 $132,822.00 $0.00 S 1,227, 178.00
PAC Millwork $3,06,705.00 $3,196.705.00 $293,137.10 1567,694.88 $2.335,873,02
PAC Stage Equipment 5818,334,06 SE 18,334.00 S40,500.U0 50.00 S777.834.M
PAC Lighting Generator
Date Description Amount 4 of Days Projected Interest
1/28!10 Fully Fund Loan 53,034,000.00 90 $37,621.60 a
Beginning Balance 50.00
Advanced Funds S3,034,000.00
Administrative Fee SI,896.25
Projected Interest $37,621.60
Adjusted Quarterly Fee $0.00
Total Due
539.517.85
S2,148.R6
PAC Air Handler
Date Description Amount t: of Da Projected Interest
1128 /10 Fully Fund Loan 51,005,000.00 90 511,50725 b
Beginning Balance S0.00
Advanced Funds SI,005,00ur.)
Administrative Fee 5628.13
Projected Interest $11,507.25
Adjusted Quarterly Fee S0 00
Total Due
$12.135.38
PAC Acoustical Equipment
Date Description Annount 4 of Days Projected interest
1/28!10 Fully Fund Loan S1,186,705.04) 90 $14.715.14 a
1128 /10 Fully Fund Loan $173,295.60 90 SI,984.23 b
S 1,360,000.06 S16,699.37
Beginning Balance $0.00
Advanced Funds S 1,360,000.00
Administrative Fee $850.00
Projected Interest $16,699.37
Adjusted Quarterly Fee S0.00
Total Due 517,549.37
PAC Mill%ork
Daze Description Amomn 7 of Days Projected interest
1/28/10 Fully Fund Low $3,196,705.00 90 536,60227 b
Beginning Balance 50.00
.Advanced Funds 53,196,705.00
Administrative Fee $1.997.94
Pt ejected Interest $36,602.:7
Adjusted Quarterly Fee
$6.06
Total Due
$38,600.21
PAC Stage Equipment
Date Description Amount H of Days Projected Interest
1/28110 Fullv Fund Loan 5818,334.00 90 510,147.34 a
Beginning Balance $0.00
Advanced Funds
5818,334.00
Administrative Fee $511.46
Projected Interest S10,147.34
Adjusted Quarterly Fee S0.00
Total Due
S I O,li5S.80
Total Administrative Fee
55,883.77
Total Projected interest SI 12.577.0
Total Adjusted Quarterly Fee
$0,00
Offset Adjustment
TOTAL DUE 4l7 /2010 x115,275.15
Calculation Frey
Administrative Fee (To Village Financial): ],can Balance Projected Administrative Fee Rate
Adjusted Quarterly Fee (To Lenderj: Proiecled Quererly Fee Rate ".Advanced Funds Accrued Interest
Prescribed by Slate Board of Accounts City Form No. 201 (Rev. 1995)
ACCOUNTS PAYABLE VOUCHER
CITY OF CARMEL
f'
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
ky e R h o o L L CF
Purchase Order No.
/j-�I n': Doletes krotine
Or,e Furor 3 gykYe 1 '5 Ayt S W Terms
Date Due
Invoice Invoice Description Amount
Date Number (or note attached invoice(s) or bill(s))
—1— 0' nS�, \me ur 1 o a'lon
Total
1 hereby certify that the attached invoice(s), or bill(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.
ALLOWED 20
C
IN SUM OF
At v. No e s Kro4e-
One ttdcor SgAkye 770 3� LO
Cdrme Af 4 c
ON ACCOUNT OF APPROPRIATION FOR
Pay from TIF 1
'9 02/4'4012
Board Members
Po# or INVOICE NO. ACCT #!TITLE AMOUNT
DEPT. I hereby certify that the attached invoice(s), or
9 02. 2 1 F bill(s) is (are) true and correct and that the
materials or services itemized thereon for
which charge is made were ordered and
fr received except
20 )0
Director o ?We
Cost distribution ledger classification if Title
claim paid motor vehicle highway fund