No preview available
HomeMy WebLinkAboutVILLAGE FINANCIAL, LLC- 003332- 11/16/2012 CARMEL REDEVELOPMENT COMMISSION 0 0 3 3 3 2 Village Financial, LLC Check: 3332 One Pedcor Square Date: 11/16/2012 770 3rd Ave. SW Vendor: VILLFII Carmel, IN 46032 Prior Invoice P.O. Num. Invoice Amt Balance Retention Discount Amt. Paid 120112 201,611.83 201,611.83 0.00 0.00 201,611.83 December2012 expense 201,611.83 201,611.83 0.00 0.00 201,611.83 «. i- THE tyo-c DOCOMEMTSECURITY±HE�ITACTd,VA'GEDs MBPR1N irien0A1A FR RITYftcec RES dj1iiDED•SEETACK F,oR DETAILS "ts��fsc Carmel Redevelopment Commission __ ..0 ti 30 West Main Street REGIONS 003332 } PI 20-1421/740 Suite 220 `YRME`.' Carmel, IN 46032 sralc 3332 DATE AMOUNT 11/16/2012 *******201,611.83 PAY THE SUM OF TWO HUNDRED ONE THOUSAND SIX HUNDRED ELEVEN DOLLARS AND 83 CENTS ********** TO THE ORDER OF Village Financial, LLC One Pedcor Square 4Pt SENSi 770 3rd Ave. SW hP Carmel, IN 46032 00333 2" 1:0740 L4 2 L3': 00E1 504 L L LH° CARMEL REDEVELOPMENT COMMISSION 003332 Village Financial, LLC Check: 3332 One Pedcor Square Date: 11/16/2012 770 3rd Ave. SW Vendor: VILLFII Carmel, IN 46032 Prior Invoice P.O. Num. Invoice Amt Balance Retention Discount Amt. Paid 120112 201,611.83 201,611.83 0.00 0.00 201,611.83 December2012 expense 201,611.83 201,611.83 0.00 0.00 201,611.83 K-11-52 COMPUTEREASE FORMS DIVISION(877)577-5791 T-71771 VILLAGE FINANCIAL,LLC One Pedcor Square 770 3rd Ave. SW Carmel,Indiana 46032 October 15, 2012 The City of Carmel Redevelopment Commission Attention: Les Olds INVOICE Due: December 1, 2012 Charge Date Item Amount 12/1/2012 Administrative Fee to Village Financial $6,008.14 12/1/2012 Projected Installment Purchase Obligation $195,593.73 Adjusted Quarterly Fee to Mercantile Bank Offset Adjustment $9.96 Total Amount Due $201,611.83 Please make payment for Installment Purchase Obligation and Administrative Fee payable to Village Financial and send to Dolores Krohne at the following address: 1p Village Financial Attn: Dolores Krohne One Pedcor Square 770 3rd Ave. SW Carmel, Indiana 46032 M:\MS\BANKS\PedBancEmployees\Michael\VF PAC Loans\Mercantile\Projection Notice\Projection Notice Projection Notice Backup to CRC PAC Equipment Loans Fourth Quarter 2012 October 15,2012 Payment Due Date:December 1,2012 Beginning Date Ending Date Dates 09/01/12 11/30/12 Administrative Fee Rate(to Village Financial) 0.06% Floor I M Libor+375bp I Interest Rate(Man between Floor and 151 Libor+375bp) 4.75% Projected Quarterly Fee Rate Ito Lender) 1.18750% 0.00000% Loan Original Contract Amount Modified Amount Past Disbursements New Disbursements Remaining Balance MC Equipment $7,515,800.00 $7,213,652.04 $7,197,638.85 $0.00 516,013.19 PAC Sound Eqp $1,649,004.00 $1,649,084.00 51,599,588.00 $14,116.69 $35,379.31 PAC Fixed Seating $835,196.00 $795,958.35 $769,978.35 $0.00 $25,980.00 PAC Hanover Square $0.00 $341,305.61 $331,600.00 $0.00 $9,705.61 PAC Equipment Date Description Amount N of Days 8/31/09 Fully Fund Loan $7,515,800.00 91 5/1/11 Hanover Square Adjustment 1$302.147.90 91 Advanced Funds $7,213,652.04 Unamortized Balance $6.934,513.62 Administrative Fee $4,334.07 Projected Interest $83,262.32 Projected Principal $57,832.20 'see attached sheet Adjusted Quarterly Fee $0.00 Total Due $145,428.59 PAC Sound Eqp Date Description Amount 19 of Days 8/31/09 Payment fee to Village Financial $100,000.00 91 8/31/09 Lender fees and loan costs 5119.500.00 91 8/31/09 Fully Fund Loan $1,429,504.00 91 5/1/11 Hanover Square Adjustment 580.00 91 Advanced Funds $1.649.084.00 Unamortized Balance $1.585.271.29 Administrative Fee $990.79 Projected Interest $19,034.26 Projected Principal $13220.79 'see attached sheet Adjusted Quarterly Fee $0.00 Total Due $33,245.83 PAC Fined Seating Date Description Amount of Days 8/31/09 Fully Fund Loan $835,196.00 91 5/1/11 Hanover Square Adjustment (539.2_37.051 91 Advanced Funds 5795.958.35 Unamortized Balance $765,158.06 Administrative Fee $478.22 Projected Interest $9,187.21 Projected Principal $6,381.24 .see attached sheet Adjusted Quarterly Fee $0.00 Total Due $16,046.67 PAC Hanover Square Date-.: . • -Description Amount 4 of Days Projected Interest 5/1/11 Fully Fund Loan $341,305.61 91 Unamortized Balance $328,098.50 Administrative Fee $205.06 Projected Interest $3,939.46 Projected Principal $2,736.26 °see attached sheet Adjusted Quarterly Fee $0.00 Total Due $6,880.78• Total Administrative Fee $6,008.14 Total Projected Interest $115,423.25 Total Project Principal $80,170.48 Total Adjusted Quarterly Fee $0.00 Offset Adjustment $9.96 TOTAL DUE 12/12012 5201,611.83 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 M:.MS\BANKSIPedBancEmployeeslMichael\VF PAC LoansOAercantle'Projection NonoelVillage Financial Equipment Loans Scheduled Principal Payments-Mercantile Bank PAC Equipment Sound Fixed Seating Hanover Square Total Rate 4.75% 4.75% 4.75% 4.75% Amount $7,213,652.04 $1,649,084.00 $795,958.35 $341,305.61 $10,000,000.00 9/1/2011 $54,517.43 $12,463.01 $6,015.48 $2,579.43 $75,575.35 12/1/2011 $55,164.82 $12,611.01 $6,086.92 $2,610.06 $76,472.81 3/1/2012 $55,819.91 $12,760.76 $6,159.20 $2,641.05 $77,380.92 6/1/2012 $56,482.77 $12,912.30 $6,232.34 $2,672.42 $78,299.82 9/1/2012 $57,153.50 $13,065.63 $6,306.35 $2,704.15 $79,229.63 12/1/2012 $57,832.20 $13,220.79 $6,381.24 $2,736.26 $80,170.48 3/1/2013 $58,518.95 $13,377.78 $6,457.01 $2,768.76 $81,122.51 6/1/2013 $59,213.87 $13,536.64 $6,533.69 $2,801.64 $82,085.84 9/1/2013 $59,917.03 $13,697.39 $6,611.28 $2,834.91 $83,060.61 12/1/2013 $60,628.55 $13,860.05 $6,689.79 $2,868.57 $84,046.95 3/1/2014 $61,348.51 $14,024.64 $6,769.23 $2,902.63 $85,045.01 6/1/2014 $62,077.02 $14,191.18 $6,849.61 $2,937.10 $86,054.92 9/1/2014 $62,814.19 $14,359.70 $6,930.95 $2,971.98 $87,076.82 12/1/2014 $63,560.11 $14,530.22 $7,013.26 $3,007.27 $88,110.86 3/1/2015 $64,314.88 $14,702.77 $7,096.54 $3,042.98 $89,157.17 6/1/2015 $65,078.62 $14,877.36 $7,180.81 $3,079.12 $90,215.92 9/1/2015 $65,851.43 $15,054.03 $7,266.08 $3,115.68 $91,287.23 12/1/2015 $66,633.42 $15,232.80 $7,352.37 $3,152.68 $92,371.27 3/1/2016 $67,424.69 $15,413.69 $7,439.68 $3,190.12 $93,468.17 6/1/2016 $6,059,300.14 $1,385,192.25 $668,586.52 $286,688.78 $8,399,767.70 End Bal $0.00 $0.00 $0.00 $0.00 $0.00 Unamortized Balance-Mercantile Bank PAC Equipment Sound Fixed Seating Hanover Square Total After: 40695 $7,213,652.04 $1,649,084.00 $795,958.35 $341,305.61 $10,000,000.00 9/1/2011 $7,159,134.61 $1,636,620.99 $789,942.87 $338,726.18 $9,924,424.65 12/1/2011 $7,103,969.79 $1,624,009.98 $783,855.95 $336,116.12 $9,847,951.84 3/1/2012 $7,048,149.88 $1,611,249.22 $777,696.75 $333,475.07 $9,770,570.92 6/1/2012 $6,991,667.12 $1,598,336.92 $771,464.41 $330,802.65 $9,692,271.10 9/1/2012 $6,934,513.62 $1,585,271.29 $765,158.06 $328,098.50 $9,613,041.46 12/1/2012 $6,876,681.42 $1,572,050.50 $758,776.83 $325,362.23 $9,532,870.98 3/1/2013 $6,818,162.47 $1,558,672.72 $752,319.81 $322,593.48 $9,451,748.47 6/1/2013 $6,758,948.60 $1,545,136.07 $745,786.12 $319,791.84 $9,369,662.63 9/1/2013 $6,699,031.57 $1,531,438.68 $739,174.84 $316,956.94 $9,286,602.03 12/1/2013 $6,638,403.02 $1,517,578.63 $732,485.06 $314,088.37 $9,202,555.08 3/1/2014 $6,577,054.51 $1,503,554.00 $725,715.83 $311,185.73 $9,117,510.07 6/1/2014 $6,514,977.48 $1,489,362.82 $718,866.21 $308,248.63 $9,031,455.15 9/1/2014 $6,452,163.30 $1,475,003.12 $711,935.26 $305,276.65 $8,944,378.33 12/1/2014 $6,388,603.19 $1,460,472.90 $704,922.00 $302,269.38 $8,856,267.47 3/1/2015 $6,324,288.30 $1,445,770.13 $697,825.46 $299,226.39 $8,767,110.29 6/1/2015 $6,259,209.68 $1,430,892.77 $690,644.65 $296,147.27 $8,676,894.38 9/1/2015 $6,193,358.25 $1,415,838.74 $683,378.57 $293,031.59 $8,585,607.15 12/1/2015 $6,126,724.83 $1,400,605.94 $676,026.20 $289,878.91 $8,493,235.88 3/1/2016 $6,059,300.14 $1,385,192.25 $668,586.52 $286,688.78 $8,399,767.70 6/1/2016 $0.00 $0.00 $0.00 $0.00 $0.00 Village Financial, LLC Offset Account Summary Due Date Account From City To Bank Difference 9/1/12 PAC Equimpment $142,002.48 $142,009.66 ($7.18) Sound Equipment $32,462.60 $32,464.26 ($1.66) Fixed Seating $15,668.64 $15,669.42 ($0.78) HIS $6,718.68 $6,719.02 ($0.34) $196,852.40 $196,862.36 ($9.96) M:\MS\BANKS\PedBancEmployees\Michael\VF PAC Loans\Mercantile\Projection Notice\Village Financial Equipment Loans 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 r �r< ` / L c u y Purchase Order No. (9 r?0, /"61-101 SCtt/gra 7 7v 3r- 5 Sri' Terms / /4.) "G 3` Date Due Invoice Invoice Description Amount Date Number (or I note attached invoice(s) or bill(s)) /6/51-12 /i /2 /4//-77,h v 1,7447.= / ay o e.. y /9//,2-/e/ / 06;603,69 Total 207 6//-cf-3 I hereby certify that the attached invoice(s), or bill(s), is (are)true and correct and I have audited same in accor- dance with IC 5-11-10-1.6. IL-1,$ , 20 ( � - reasurer VOUCHER NO. WARRANT NO. ALLOWED 20 X561 J �` IN SUM OF $ ��, � 7 3/L- J S $ 20/, a('/- a23 ON ACCOUNT OF APPROPRIATION FOR L Board Members PO#or INVOICE NO. ACCT#!TITLE AMOUNT DEPT.# I hereby certify that the attached invoice(s), 9e72. /? c ( /2 W60,2 6 006;72/ or bill(s) is (are) true and correct and that 12- // jZ `/4'b0921.1, i9,s,( 5.6, the materials or services itemized thereon for which charge is made were ordered and received except /D -25-20 12 1C2W' Signature Executive Director Title Cost distribution ledger classification if Carmel Redevelopment Commission claim paid motor vehicle highway fund