VILLAGE FINANCIAL, LLC. -002325 -9/22/2011 CARMEL REDEVELOPMENT COMMISSION 002325
Village Financial, LLC Check: 2325
One Pedcor Square Date: 9/22/2011
770 3rd Ave. SW Vendor: VILLFI1
Carmel, IN 46032
Prior
Invoice P.O. Num. Invoice Amt Balance Retention Discount Amt. Paid
90711 193,023.25 193,023.25 0.00 0.00 193,023.25
Quarterly installment contract
193,023.25 193,023.25 0.00 0.00 193,023.25
•
VILLAGE FINANCIAL, LLC
One Pedcor Square
770 3rd Ave. SW
Carmel,Indiana 46032
September 7, 2011
The City of Carmel Redevelopment Commission
Attention: Les Olds
INVOICE
Due: October 7, 2011
Charge Date Item Amount
10/07/11 Administrative Fee to Village Financial $5,795.44
10/07/11 Projected Installment Purchase Obligation $187,227.81
10/07/11 Adjusted Quarterly Fee to Regions Bank $0.00
Offset/Addition Amount* $0.00
Total Amount Due $ 193,023.25
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 A
One Pedcor Square 1
770 3rd Ave. SW
Cannel, Indiana 46032
Projection Notice Backup to CRC
PAC Equipment Installment Purchases
3rd Quarter 2011
September 7,2011
Payment Due Date:October 7,2011
Beginning Date Ending Date
Dates 07/07/11 10/6/11
Administrative Fee Rate(to Village Financial) 0.06%
Fixed
Projected Interest Rate 4.96% a
Projected Interest Rate 4.58% b
Projected Quarterly Fee Rate(to Lender) 1.24000%
Loan Loan Amount Advanced Funds Past Disbursements New Disbursements Remaining Balance
PAC Lighting&Generator $3,034,000.00 $3,034,000.00 $2,882,300.00 $0.00 $151,700.00
PAC Air Handler $1,005,000.00 $1,005,000.00 $954,750.00 $0.00 $50,250.00
PAC Acoustical Equipment $1,360,000.00 $1,360,000.00 $1,044,430.00 $0.00 $315,570.00
PAC Millwork $3,196,705.00 $3,196,705.00 $2,977,157.52 $0.00 $219,547.48
PAC Stage Equipment $818,334.00 $818,334.00 $620,098.30 $0.00 $198,235.70
PAC Lighting&Generator
Date Description Amount #of Days
1/28/10 Fully Fund Loan $3,034,000.00 92
Unamortized Balance $2,988,940.68
Administrative Fee S1,868.09
Projected Interest*See attached sheet* $37,886.48 a
Projected Principal*See attached sheet* $22,949.57
Adjusted Quarterly Fee $0.00
Total Due $62,704.15
PAC Air Handler
Date Description Amount #of Days
1/28/10 Fully Fund Loan $1,005,000.00 92
Unamortized Balance $989,426.93
Administrative Fee $618.39
Projected Interest*See attached sheet* $11,580.69 b
Projected Principal*See attached sheet* $7,920.52
Adjusted Quarterly Fec $0.00
Total Due $20,119.61
PAC Acoustical Equipment
Date Description Amount #of Days
1/28/10 Fully Fund Loan $1,360,000.00 92
Unamortized Balance $1,339,802.02
Administrative Fee $837.38
Projected Interest*See attached sheet* $16,982.73 a
Projected Principal*See attached sheet* $10,287.22
Adjusted Quarterly Fee $0.00
Total Due $28,107.33
Projection Notice Backup to CRC
PAC Equipment Installment Purchases
3rd Quarter 2011
September 7,2011
Payment Due Date:October 7,2011
Beginning Date Ending Date
Dates 07/07/11 10/6/11
Administrative Fee Rate(to Village Financial) 0.06%
Fixed
Projected Interest Rate 4.96% a
Projected Interest Rate 4.58% b
Projected Quarterly Fee Rate(to Lender) 1.24000%
Loan Loan Amount Advanced Funds Past Disbursements New Disbursements Remaining Balance
PAC Lighting&Generator $3,034,000.00 $3,034,000.00 $2,882,300.00 $0.00 $151,700.00
PAC Air Handler $1,005,000.00 $1,005,000.00 $954,750.00 $0.00 $50,250.00
PAC Acoustical Equipment $1,360,000.00 $1,360,000.00 $1,044,430.00 $0.00 $315,570.00
PAC Millwork $3,196,705.00 $3,196,705.00 $2,977,157.52 $0.00 $219,547.48
PAC Stage Equipment $818,334.00 $818,334.00 $620,098.30 $0.00 $198,235.70
PAC Millwork
Date Description Amount #of Days
1/28/10 Fully Fund Loan $1,370,000.00 92
1/28/10 Fully Fund Loan $1,826,705.00 92
Unamortized Balance $3,148,346.80
Administrative Fee $1,967.72
Projected Interest*See attached sheet* $38,597.24 ab
Projected Principal*See attached sheet* $24,614.57
Adjusted Quarterly Fee $0.00
Total Due $65,179.52
PAC Stage Equipment
Date Description Amount #of Days
1/28/10 Fully Fund Loan $818,334.00 92
Unamortized Balance $806,180.55
Administrative Fee S503.86
Projected Interest*See attached sheet* $10,218.79 a
Projected Principal*Sec attached sheet* 56,189.99
Adjusted Quarterly Fee $0.00
Total Due $16,912.63
Total Administrative Fee $5,795.44
Projected Interest*See attached sheet* $115,265.94
Projected Principal*See attached sheet* $71,961.87
Total Adjusted Quarterly Fee $0.00
Offset Adjustment $0.00
TOTAL DUE 10/7/11 $193,023.25
Calculation Key
Administrative Fee(To Village Financial):Loan Balance*Projected 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.
J Payee
V/1 4p9 /fc L Purchase Order No.
7 7D vt'.; S Terms
n
Date Due
Invoice Invoice Description Amount
Date Number (or note attached invoice(s) or bill(s))
^7-1/ go7//
62z-/-74,---4 7zA, /9 0,23-25-
Total /23G2_3
I hereby certify that the attached invoice(s), or bill(s), is (are) true a d .r -ct .nd I hav- .udited same in accordance
with IC 5-11-10-1.6.
, 20 ` / /0
• r
lerk-Treasurer
VOUCHER NO. WARRANT NO.
ALLOWED 20
V aoy y 7';'e?/ }1) LL C IN SUM OF $
77 .2
C /2/ yGa 32
$ /93;02Y.a5—
ON ACCOUNT OF APPROPRIATION FOR
Board Members
PO#or INVOICE NO. ACCT#!TITLE AMOUNT hereby certify invoice(s),DEPT.# I hereb certif that the attached invoices , or
gds 207// 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//
E RPM Director
Title
Cost distribution ledger classification if Carmel Redevelopment Commission
claim paid motor vehicle highway fund