Loading...
HomeMy WebLinkAboutVILLAGE FINANCIAL, LLC. -002460 -11/18/2011 CARMEL REDEVELOPMENT COMMISSION 002460 Village Financial, LLC Check: 2460 One Pedcor Square Date: 11/18/2011 770 3rd Ave. SW Vendor: VILLFI1 Carmel, IN 46032 Prior Invoice P.O. Num. Invoice Amt Balance Retention Discount Amt. Paid 120111 201,837.59 201,837.59 0.00 0.00 201,837.59 Installment purchase payment , - 201,837.59 201,837.59 0.00 0.00 201,837.59 VILLAGE FINANCIAL, LLC One Pedcor Square 770 3rd Ave. SW Cannel, Indiana 46032 October 24, 2011 The City of Carmel Redevelopment Commission Attention: Les Olds INVOICE Due: December 1, 2011 Charge Date Item Amount 12/1/2011 Administrative Fee to Village Financial $6,202.76 12/1/2011 Projected Installment Purchase Obligation $195,634.83 Adjusted Quarterly Fee to Mercantile Bank $0.00 Total Amount Due $201,837.59 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 /,Oj One Pedcor Square I I 770 3rd Ave. SW Carmel, Indiana 46032 t\snaplalidata\MS\BANKS1Ped BancEmployeeslMichael\VF PAC Loans\Mercantile\Projection Notice\Projection Notice Projection Notice Backup to CRC PAC Equipment Loons Second Quarter 2011 October 24,2011 Payment Due Date:December 1,2011 Beginning Date Ending Date Dates 09/01/11 11/30/11 Administrative Fee Rote(to Village Financial) 0 06% Floor IM Libor*375bp d Interest Rate(Max between Floor and 1M Libor+375bp) 475% Projected Quarterly Fee Rate(to Lender) 1.18750% 0.00000% Loan Original Contract Amount Modified Amount Past Disbursements New Disbursements Remaining Balance PAC Equipment $7,515,800.00 $7,213,652.04 $6,848,116.85 $349,522.00 $16,013.19 MC Sound Eqp $1,649,04.00 $1,649084.00 $1,451,486.64 ($SO.UI) $197,677.40 PAC Fixed Seating 3835,196.00 5795,958.35 5769,97835 $0,00 $25,980.00 PAC Hanover Square $0.00 0341305.61 $0.00 $263.370.32 577,935.29 MC Equipment Date Description Amount F of Days 8/31/09 Fully Fund Loan $7,515,800.00 91 5/1/11 Hanover Square Adjustment (5302,147.96) 91 Advanced Funds $7,213,652,04 Unamortized Balance $7,159,134.61 Administrative Fee $4,474.46 Projected Interest $85,959.33 Projected Principal $55,164.82 *see attached sheet Adjusted Quarterly Fee $0.00 Total Due $145,598.61 MC Sound Eqp Date Description Amount it of Days 8/31/09 Payment fee to Village Financial $100,000.00 91 8/31/09 Lender fees and loon costs $119,500.00 91 8/31/09 Fully Fund Loan $1,429,504.00 91 5/1/11 Hanover Square Adjustment $80.00 91 Advanced Funds $I,649,084.00 Unamortized Balance $1,636,620.99 Administrative Fee $1,022.89 Projected Interest $19,650.82 Projected Principal $12,611.01 *see attached sheet Adjusted Quarterly Fee $0.00 Total Due $33,284.72 PAC Fixed Seating Date Description Amount F of Days 8/31/09 Fully Fund Loan $835,196.00 91 5/1/11 Hanover Square Adjustment ($39,237.65) 91 Advanced Funds $795,958.33 Unamartized Balance 5789,942.87 Administrative Fee $493,71 Projected Interest $9,484.80 Projected Principal 56,086.92 *see attached sheet Adjusted Quarterly Fee $0.00 Total Due S16,065.43 PAC Hanover Square Date Description Amount If of Days Projected interest 5/1/11 Fully Fund Loan $341,303.61 91 Unamortized Balance 533 8,726.18 Administrative Fee $211.70 Projected Interest $4,067,07 Projected Principal $2,610.06 *see attached sheet Adjusted Quarterly Fee 50.00 Toed Due 56,888.83 Total Administrative Fee $6,202.76 Total Projected Interest $119,162.02 Total['Inject Principal $76,472.81 Total Adjusted Quarterly Fee $0.00 Offset Adjustment TOTAL DUE 12/1/2011 $201,837.58 Calculation Key Administrative Fee(To Village Financial):Loan Balance*Ptojecled Administrative Fee Rate Adjusted Quarterly Fee(To Lender):Projected Quarterly Fee Rate*Advanced Funds-Accrued Interest ItsnaplalldatalMS1 BANKSsPaaBancEmployeeslMichaetlVF PAC LoanslMercantleProjecton NoticeiVille9e Finandal Equipmenl 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 Ptescribed by State Board of Accounts ACCOUNTS PAYABLE VOUCHER City Form No.201(Rev.1995) 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 1// l lay r f",l44iol,-4i/ LL G Purchase Order No. 667e 644/4„re, 771J 3e-e- 6,4,;5-6cI Terms /V 27/6 X32 Date Due Invoice Invoice Description Amount Date Number (or note attached invoice(s) or bill(s)) ZW2V// /O2 y// Z1:7.77z✓eye-/-- 2x78)3 7-5, Total 20; 37 5 • I hereby certify that the attached invoice(s), or bill(s), is (are) true and correct -. have .• accordance with IC 5-11-10-1.6. t -I L , 20 1l / - reasurer VOUCHER NO. WARRANT NO. ALLOWED 20 "//c7,9� ���//%�/ /'.?/ ) LLG IN SUM OF $ 007 /'P cal cJ✓ .Sfx ucrrP 7 s42 ea,/^ // X603 2 $2O(, S37, s9 ON ACCOUNT OF APPROPRIATION FOR Board Members PO#or INVOICE NO. ACCT#/TITLE AMOUNT DEPT.# I hereby certify that the attached invoice(s), or }�Z 1-/v4o9.26 2o/ -37.5, 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 /c7 -25-20 ignature Executive Director Title Cost distribution ledger classification if claim paid motor vehicle highway fund Carmel Redevelopment Commission