Loading...
185871 05/26/2010 CITY OF CARMEL, INDIANA VENDOR: 364142 Page 1 of 1 ONE CIVIC SQUARE MERCANTILE BANK CARMEL, INDIANA 46032 12813 E NEWMARKET CHECK AMOUNT: $121,388.89 CARMEL IN 46032 CHECK NUMBER: 185871 CHECK DATE: 5/2612010 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 902 4460926 060110 121,388.89 INSTALLMENT PURCHASE A VILLAGE FINANCIAL, LLC One Pedcor Square 770 3rd Ave. SW Carmel, Indiana 46032 April 27, 2010 The City of Carmel Redevelopment. Connnission Attention: Les Olds INVOICE CE Due: June I, 2010 Charge Date Item Amount 6/1/2010 Administrative Fee to Village Financial $6.250.01 6/1/2010 Projected Installment Purchase Obligation $121,388.89 Adjusted Quarterly Fee to Mercantile Bazrlc Total Amount Due 127,638.90 Please make check for Installment Purchase Obligation payable to Mercantile Barak and send to Mike Branigan or Dave Weber at the following address: Mercantile Bank Attn: Mike Branigan or Dave Weber 12813 East New Market Street Carmel, IN 46032 Please make check for Administrative Fee payable to Village Financial, LLC. and send to the address noted at the top of invoice. F Projection Notice Backup to CRC PAC Equipment Loans Second Quarter 2010 May 1, 2010 PaYment Due Date: Jane 1, 2010 Beginning Date Ending Dow Dates 03 /01 /10 5/31110 Administrative Fee Rate (to Village Financial) 0.06% Floor Ivi Libor +375bp Projected Interest Rate (Max between Fitwr and 1M14 Libor +;t75bp) 4.75°/ 3.99% Projected Quarterly Fee Rate (to Lender) 1.16750% 0.99635 i Loan Contract Amount Advanced Funds Past 1)isbursentcnts New 1)istursetutnts Itcmaining llalancr PAC Equipment S7,515,800.00 57,515,800.00 $644,076.84 £246,478.22 $6,625,244.94 PACSoundl?gp 31,649,004.00 $1,649,004.00 $290 $80,19}5.10 $[.278,563.19 PAC Fixed Seating S835,i96.00 $535,196.00 $94,030,35 50.00 $741,165.65 PAC Equipment Date Description Antount. 4 of Days Projected Interest 6131109 Fully Fund Loan 57,515,800.00 92 591,233.46 Beginning Balance $0.00 Advanced Funds 57,57.5,800.00 Adutinistranve Fee $4.697.38 Projected Interest $91,233.46 Adjusted Quarterly pee $0.00 Total Due $95,930.84 PAC Sound Eqp Date Description Amount Ir ofDays Prcieetcdinterest 8131 /09 Payment fee toVillagcFinancial $100,000.00 92 51213,89 8/31109 Lender fees and loan costs $119,500.00 92 51,450.60 8/31109 Fully FundLOan $1,429,504.00 92 $'17,352.59 Beginning Balance. $0.00 Advanced Funds $1,649.004.00 Administrative Fee 1,030.63 Projected Interest $20,017.06 Adjusted Quarterly Fee $0.00 Total Due 1;21,047.70 PAC Fixed Seating Date Description Amount of Days PrniectedInterest 6131109 Fully Fund Loan 5835,196.00 9^ $10,136.35 Beginning Balance $0,00 Advanced Funds 563 00 Adtninismtive Fee $522.00 Projected interest 510,138,35 Adjusted Quarterly Fee $0 00 Total Due $10,660.35 Total Administrative Fec Total Projected tttcrest 51233RS.fi9 Total Adjusted Quarterly rly Fee 50.00 Offset Adi usunent TOTAL DUCE: 6/1/2010 $127.636.90 Calculation Key Adminisravve Fee (To Village Financial) I-Dan Balance Projected Administrative Fee Rate Adjusted Quarterly Fee (To Lender): Projev ed Quarierl Fee RateAdvanced Funds Accrued Interest V 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 k Purchase Order No. A•Nn� Mike Br�n)snr, 1 2- 213 F Ne w ft kef Sf. Terms C r M l, 6X32 Date Due Invoice Invoice Description Amount Date Number (or note attached invoice(s) or bill(s)) i 4 1 7 -W 060110 'i r 46)6.enl bW r6AdfC u r+erIt e e 121 3 9 g. 619 Total l2 39e, I 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. J ALLOWED 20 NjL'rC�a'1�`)�� dan IN SUM OF$ A #n; Mike Grar'kq�h 128 E, New Ae+ S C Armel,1A/ 46032 12 �,388.�� ON ACCOUNT OF APPROPRIATION FOR F 106 9 0 2 0 q2 G Board Members D T INVOICE NO. ACCT #j /TITLE AMOUNT I hereby certify that the attached 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 U 2 I 20(() ignature `ray •t�F gf Redevelopment Cost distribution ledger classification if Title claim paid motor vehicle highway fund