VILLAGE FINANCIAL, LLC. -002236 -8/18/2011 CARMEL REDEVELOPMENT COMMISSION 002236
Village Financial, LLC Check: 2236
One Pedcor Square Date: 8/18/2011
770 3rd Ave. SW Vendor: VILLFI1
Carmel, IN 46032
Prior
Invoice P.O. Num. Invoice Amt Balance Retention Discount Amt. Paid
71 911 203,214.25 203,214.25 0.00 0.00 203,214.25
Installment purchase obligatio .
203,214.25 203,214.25 0.00 0.00 203,214.25
VILLAGE FINANCIAL, LLC
One Pedcor Square
770 3rd Ave. SW
Carmel,Indiana 46032
July 19, 2011
The City of Carmel Redevelopment Commission
Attention: Les Olds
INVOICE
Due: September 1, 2011
Charge Date Item Amount
09/01/11 Administrative Fee to Village Financial $6,250.01
09/01/11 Projected Installment Purchase Obligation $196,964.24
Adjusted Quarterly Fee to Mercantile Bank $0.00
Total Amount Due $203,214.25
Please make payment for Installment Purchase Obligation and Administrative 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. SW 1 nb'
Carmel, Indiana 46032 �/
•
Projection Notice Backup to CRC
PAC Equipment Loans
Second Quarter 2011
July 19,2011
Payment Due Date:September 1,2(111
Beginning Date Ending Date
Dates 06/01/11 831/11
Administrative Fee Rate Ito Village Financial) 0.06%
Floor 1M Libor+375bp
d Interest Rate(Max between Floor and 1M Libor+375bp) 4.75%
Projected Quarterly Fee Rate Ito Lender) 1.18750% 0.00000%
Loan Orginal Contract Amount Modified Amount Past Disbursements New Disbursements Remaining Balance
PAC Equipment $7,515,800.00 $7,213.652.04 $6,848,116.85 $0.00 $365.535.19
PAC Sound Eqp $1.649.004.00 $1,649.084.00 51,448.737.01 $2.749.60 $197,597.39
PAC Fixed Seating $835.196.00 $795.958.35 $731.114.20 S38,864.15 , $25.980.00
PAC Hanover Square $0.00 $341,305.61 $0.00 $0.00 $341,305.61
PAC Equipment
Date Description Amount 8 of Days Projected Interest
8/31/09 Fully Fund Loan $7,515,800.00 92 S91.233.46
5/1/11 Hanover Square Adjustment t,•302,1.1';.00; 92 (53.607.741
Advanced Funds $7,213,652.04 $87.565.72
Administrative Fee $4,508.53
Projected Interest $87,565.72
Projected Principal $54,517.43 'see attached sheet
Adjusted Quarterly Fee $0.00
Total Due $146,591.68
PAC Sound Eqp
Date Description Amount 9 of Days Projected Interest
8/31/09 Payment fee to Village Financial S100.000.00 92 $1113.89
8/31(09 Lender fees and loan costs $119,500.00 92 $1.450.60
8/31/09 Fully Fund Loan $1,429,504.00 92 $17,352.59
5/1/11 Hanover Square Adjustment $80.00 92 $0.97
Advanced Funds $1,649,084.00 $20.018.05
Administrative Fee $1,030.68
Projected Interest $20,018.05
Protected Principal $12,463.01 'see attached sheet
Adjusted Quarterly Fee $0.00
Total Due $33,511.74
PAC Fixed Seating
Date Description Amount t!of Days Projected interest
8/31/09 Fully Fund Loan $835,196.00 92 $10.138.35
5/1/II Hanover Square Adjustment ($39?37,051 92 15476.305
Advanced Funds $795,958.35 $9,662.05
Administrative Fee S497.48
Projected Interest $9,662.05
Projected Principal $6,015.48 *see attached sheet
Adjusted Quarterly Fee S0.00
Total Due $16,175.02
PAC Hanover Square
Date Description Amount 8 of Days Projected Interest
5/1/1l Fully Fund Loan $341,305.61 92 $4,143.07
Administrative Fee $213.32
Projected Interest $4,143.07
Projected Principal $2,579.43 *see attached sheet
Adjusted Quarterly Fee $0.00
Total Due $6,935.82
Total Administrative Fee $6,250.01
Total Projected Interest $121.388.89
Total Project Principal $75,575.35
Total Adjusted Quarterly Fee $0.00
Offset Ad_tusunent
TOTAL DUE 09/1/2011 $203,214.25
Calculation Key
Administrative Fee(To Village Financial):Loan Balance"Protected Administrative Fee Rate
Adjusted Quarterly Fee(To Lender):Projected Quarterly Fee Rate•Advanced Funds-Accrued Interest
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
it,/4 p- 4,LG Purchase Order No.
Terms
Date Due
Invoice Invoice Description Amount
Date Number (or note attached invoice(s) or bill(s))
2-/9-1/ 9c/// SP,f� Gam ���s 2. 3-.2//._2
7.
/
1 L5
Total 20 2/y25—
I hereby certify that the attached invoice(s), or bill(s), is (are) true and cor - . • :• e ,_�= -• -1 e in accordance
with IC 5-11-10-1.6. /
g —n , 20 11
—Treasurer
VOUCHER NO. WARRANT NO.
ALLOWED 20
V%/may 4)
IN SUM OF $
47fQ ( �Y�- r SC�UCjr -
(70-1",i77 /,
$ / /.-;`'
ON ACCOUNT OF APPROPRIATION FOR
9ei /4V/ a
Board Members
PO#or INVOICE NO. ACCT#/TITLE AMOUNT
DEPT.# I hereby certify that the attached invoice(s), or
gat
77P// 17"WIZ 7-o3/2y23- 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
20
EX68e rDirector
Title
Cost distribution ledger classification if Carmel Redevelopment Commission
claim paid motor vehicle highway fund