Loading...
HomeMy WebLinkAboutVILLAGE FINANCIAL, LLC- 003120- 8/16/2012 CARMEL REDEVELOPMENT COMMISSION 0 0 312 0 Village Financial, LLC Check: 3120 One Pedcor Square Date: 8/16/2012 770 3rd Ave. SW Vendor: VILLFI1 Carmel, IN 46032 Prior Invoice P.O. Num. Invoice Amt Balance Retention Discount Amt. Paid 71612-A 6,057.67 6,057.67 0.00 0.00 6,057.67 Administrative Fee for Sept 71612-B 196,852.40 196,852.40 0.00 0.00 196,852.40 Installment purchase obligatio 202,910.07 202,910.07 0.00 0.00 202,910.07 ,THE KEY TO D06UMENTjECURITY o HEAT ACTiVATED�7HUM61PRIN,T'"`ADDITIONAL`SECURITY FEATURES INCLUDED qSEE,BAK.F011 DETAILS ''` Air tse°ES, Carmel Redevelopment Commission A REGIONS 003120 30 West Main Street 20-1421/740 Suite 220 CA4RMEL Carmel, IN 46032 OISTRIG 3120 DATE AMOUNT 8/16/2012 ********202,910.07 PAY THE SUM OF TWO HUNDRED TWO THOUSAND NINE HUNDRED TEN DOLLARS AND 07 CENTS** TO THE ORDER OF Village Financial, LLC One Pedcor Square 770 3rd Ave. SW IP Carmel, IN 46032 IFS rnrs 11°00 3 1 20"° 1:0 740 1 LI 2 1 31: 008 7 504 1 1 Iii° CARMEL REDEVELOPMENT COMMISSION 003120 Village Financial, LLC Check: 3120 One Pedcor Square Date: 8/16/2012 770 3rd Ave. SW Vendor: VILLFI1 Carmel, IN 46032 Prior Invoice P.O. Num. Invoice Amt Balance Retention Discount Amt. Paid 71612-A 6,057.67 6,057.67 0.00 0.00 6,057.67 Administrative Fee for Sept 71612-B 196,852.40 196,852.40 0.00 0.00 196,852.40 Installment purchase obligatio 202,910.07 202,910.07 0.00 0.00 202,910.07 • X-11-52 COMPUTEREASE FORMS DIVISION(877)577-5791 1-71771 VILLAGE FINANCIAL, LLC One Pedcor Square 770 3rd Ave. SW Carmel,Indiana 46032 July 16, 2012 The City of Carmel Redevelopment Commission Attention: Les Olds INVOICE Due: September 1, 2012 Charge Date Item Amount 9/1/2012 Administrative Fee to Village Financial $6,057.67 t' 9/1/2012 Projected Installment Purchase Obligation $196,883.03 Adjusted Quarterly Fee to Mercantile Bank Offset Adjustment ($30.63) Total Amount Due $202,910.07 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 Carmel, Indiana 46032 M:1MS\BANKS\PedBancEmployees\Michael\VF PAC Loans\Mercantile\Projection Notice\Projection Notice Projection Notice Backup to CRC PAC Equipment Loans Third Quarter 2012 Jolt•16,2012 Payment Due Date:September 1,2012 Beginning Date Ending Date Dates 06/01/12 8/31/12 Administrative Fee Rate(to Village Financial) 0.06% Floor IM Libor+375bp I interest Rate(Max between Floor and 1M 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 PAC Equipment 17,515,800.00 $7,213,652.04 $7,197,638.85 $0,00 $16,013.19 PAC SoundEgp $1,649,004.00 $1.649,084.00 $1,551,426.60 $48.161.40 $49,496.00 PAC Fixed Seating $835,1 96.00 5795 958.35 1769,978.35 $0.00 $25,980.00 PAC Hanover Square $0.00 $341305.61 $297,017.00 $34,583.00 $9,705.61 PAC Equipment Date Description Amount r of Days 8/31/09 Fully Fund Loan $7,515,800.00 92 5/1/11 Hanover Square Adjustment ;$302,147.96) 92 Advanced Funds $7,213,652.04 Unamortized Balance $6.991,667.12 Administrative Fee $4,369.79 Projected Interest $84,871.07 Projected Principal $57,153.50 `see attached sheet Adjusted Quarterly Fee $0.00 Total Due 5146,394.36 PAC Sound lEgp Dale Description Amount €of Days 8/31/09 Payment fee to Village Financial $100,000.00 92 8/31/09 Lender fees and loan costs $119,500.00 92 8/31/09 Fully Fund Loan 51,429,504'.00 92 5/1/11 Hanover Square Adjustment $80.00 92 Advanced Funds $1,649,084.00 Unamortized Balance 51,598,336,92 Administrative Fee $998.96 Projected Interest $19,402.03 Projected Principal $13,065.63 'see attached sheet Adjusted Quarterly Fee $0.00 Total Due $33,466.62 PAC Fixed Seating Date Description Amount tt of Days 8/31/09 Fully Fund Loan $835,196.00 92 5/1/11 Hanover Square Adjustment /139.237.651 92 Advanced Funds $795,958.35 Unamortized Balance $771,464.41 Administrative Fee 5482.17 Projected Interest $9,364.72 Projected Principal $6,306.35 asee attached sheet Adjusted Quarterly Fee $0.00 Total Due $16,153.24 PAC Hanover'Square Date Description Amount A of Days Projected Interest 5/l/11 Fully Fund Loan 5341,305.61 92 Unamortized Balance $330,802.65 Administrative Fee $206.73 Projected Interest $4,015.58 Projected Principal $2,704.15 •see attached sheet Adjusted Quarterly Fee $0.00 Total Due 56,926.48 Total Administrative Fee $6,057.67 Total Projected Interest $117,653.40 Total Project Principal $79229.63 Total Adjusted Quarterly Fee $0.00 Offset Adjustment t$30.63 TOTAL DUE 09/1/2012 $202,910.07 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:IMS\HANKSIPedBnnu€nrploye asUicheenVF PAC LoanauercannlerProjeetlon Native\Visage Financial Eta4pment Loaru 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 6/1/12 PAC Equimpment $142,039.48 $142,017.39 $22.09 Sound Equipment $32,471.08 $32,466.02 $5.06 Fixed Seating $15,672.71 $15,670.28 $2.43 HIS $6,720.44 $6,719.39 $1.05 $196,903.71 $196,873.08 $30.63 • M:\MS\BANKS\PedBancEmployees\Michael\VF PAC Loans\Mercantile\Projection Notice\Village Financial Equipment Loans VILLAGE FINANCIAL, LLC One Pedcor Square 770 3rd Ave.SW Cannel,Indiana 46032 July 16, 2012 The City of Carmel Redevelopment Commission Attention: Les Olds INVOICE Due: September 1, 2012 Charge Date Item Amount 9/1/2012 Administrative Fee to Village Financial $6,057.67 9/1/2012 Projected Installment Purchase Obligation $196,883.03 Adjusted Quarterly Fee to Mercantile Bank Offset Adjustment ($30.63) Total Amount Due $202,910.07 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 Carmel, Indiana 46032 M:\MS\BANKS\PedBancEmployees\Michael\VF PAC Loans\Mercantile\Projection NoticelProjection Notice Projection Notice Backup to CRC PAC Equipment Loans Third Quarter 2012 July 16,2012 Payment Dne Date:September 1,2012 Beginning Date Ending Date Dates 06/01/12 8/51/12 Administrative Fee Rate(to Village Financial) 0.06% Floor IM Libor+375bp I Interest Rate(Max between Floor and 1M Libor+375bp) 4.75% Projected Quarterly Fee Rate(ro 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 $16,013.19 PAC Sound Eqp $1,649,004.00 $1.649,084.00 $1,551,426.60 548.161.40 $49,496.00 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 $297,017.00 334,583.00 $9,705.61 PAC Equipment Date Description Amount 4 of Days 8/31/09 Fully Fund Loan $7,515,800.00 92 5/I/I I Hanover Square Adjustment i5302.147.96) 92 Advanced Funds $7,213,652.04 Unamortized Balance $6.991,667.12 Administrative Fee $4,369.79 Projected Interest $84,871.07 Projected Principal $57,153.50 *see attached sheet Adjusted Quarterly Fee 5',0.00 Total Due $146,394.36 MC Sound Eqp Date Description Amount €of Days 8/31/09 Passnent fee to Village Financial $100,000.00 92 8/31/09 Lender fees and loan costs $119,500.00 92 8/31109 Fully Fund Loan $1,429,50.4.00 92 5/1/11 Hanover Square Adjustment $80.00 92 Advanced Funds $1,649,084.00 UmmmortizedBalance $1,598,336.92 Administrative Fee $998.96 Projected Interest $19,402.03 Projected Principal $13,065.63 .see attached sheet Adjusted Quarterly Fee $0.00 Total Due $33,466.62 PAC Fixed Seating Date Description Amount 8 of Days 8/31/09 Fatly Fund lone $835,196.00 92 5/1/11 Hanover Square Adjustment (939,257 651 92 Advanced Funds $795,958.35 Unamortized Balance $771,464.41 Administrative Fee $482.17 Projected Interest $9,364.72 Projected Principal 56,306.35 •see attached sheet Adjusted Quarterly Fee $0.00 Total Due $16,153.24 PAC Hanover Square Date Description Amount If of Days Projected Interest 5/1/11 Fully Fund Loan $341,305.61 92 Unamortized Balance $330.802.65 Administrative Fee $206.75 Projected Interest $4.015.58 Projected Principal $2,704.15 `see attached sheet Adjusted Quarterly Fee $0.00 Total Due $6,926.48 Total Administrative Fee $6,057.67 Total Projected Interest $117,653.40 Total Project Principal 579229.63 Total Adjusted Quarterly Fee $0.00 . Offset Adjustment 1530.63; TOTAL DUE 09/1/2012 $202,910.07 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:IMSIBANKStPedBen sEmployeoMMIcheeSVF PAC Leena5MercanalelProjedbn NaticelVlaage 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,977A8 $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 6/1/12 PAC Equimpment $142,039.48 $142,017.39 $22.09 Sound Equipment $32,471.08 $32,466.02 $5.06 Fixed Seating $15,672.71 $15,670.28 $2.43 HIS $6,720.44 $6,719.39 $1.05 $196,903.71 $196,873.08 $30.63 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 (--,y/ LLB Purchase Order No. Cr)w /o%av' ..6<vq�� >67 �,o' i'.' . Terms C<fpnpo/, At.) 2b 3 2 Date Due Invoice Invoice Description Amount Date Number (or note attached invoice(s) or bill(s)) 7-//-/Z 7/6 /2 -79 /�d � F;r (05-7, 6 7 -7-M-/2. 7/6/2-6 / 4//� t/ ��r���•sY v�/�y� '�> /)‘IS 5-2,5'c Total 202, 2/U-O 7 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. / 8-3(o , 20 ?z_ 4' e=� reasurer VOUCHER NO. WARRANT NO. /J ALLOWED 20 //!/ 7 Cio '/ 56(Lice,' IN SUM OF $ 7 549 ,/,) Go3z $ 202, 9/0-c7 - ON ACCOUNT OF APPROPRIATION FOR Board Members D PT.# INVOICE NO. ACCT#/TITLE AMOUNT I hereby certify that the attached invoice(s), P2- 7 I&(2 - liy 6092,6 60.5-7-67 or bill(s) is (are) true and correct and that 7/4/2,- 6 19a5-2. the materials or services itemized thereon for which charge is made were ordered and received except -7-2620 /2 Signature Executive Director Title Cost distribution ledger classification if Carmel Redevelopment Commission claim paid motor vehicle highway fund