Loading...
HomeMy WebLinkAboutVILLAGE FINANCIAL, LLC- 002994- 6/21/2012 CARMEL REDEVELOPMENT COMMISSION 0 0 2994 Village Financial, LLC Check: 2994 One Pedcor Square Date: 6/21/2012 770 3rd Ave. SW Vendor: VILLFI1 Carmel, IN 46032 Prior Invoice P.O. Num. Invoice Amt Balance Retention Discount Amt. Paid 70712-A 185,909.94 185,909.94 0.00 0.00 185,909.94 Installment purchase obligatio 70712-B 5,497.98 5,497.98 0.00 0.00 5,497.98 Admin fee 191,407.92 191,407.92 0.00 0.00 191,407.92 .: t ;yTHE KEY;!MDOCUMENT SECURITY HEAT ACTIVATEDtTHUMB PRINT tADDITIONAL SECURITY FEATURES INCLUDEd SEE BACK FOR DETAILS y V,, ,,; PP %ti Carmel Redevelopment Commission A t30 West Main Street �2REG IONS 0 0 2 994 Suite 220 `ykMf`i Carmel, IN 46032 2994 DATE AMOUNT z ' 6/21/2012 ********191,407.92 PAY THE SUM OF ONE HUNDRED NINETY ONE THOUSAND FOUR HUNDRED SEVEN DOLLARS AND 92 CENTS"' TO THE ORDER OF Village Financial, LLC One Pedcor Square SE,S, i 770 3rd Ave. SW ,� .„ Carmel, IN 46032 '= i 90 C ES ygtH 11°0029441i° ':0740142 / 300 0087504 / 1111° VILLAGE FINANCIAL, LLC One Pedcor Square 770 3rd Ave. SW Carmel,Indiana 46032 June 7, 2012 Village Financial Attention: Dolores Krohne • INVOICE+ Due: July 7, 2012 Charge Date Item Amount 7/7/2012 Administrative Fee to Village Financial $5,497.98 7/7/2012 Projected Installment Purchase Obligation $185.909.9, 7/7/2012 Adjusted Quarterly Fee to Regions Bank $0.00 Offset/Addition Amount $0.00 Total Amount Due $191,407.92 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 CU Attn: Dolores Krohne One Pedcor Square 770 3rd Ave. SW Cannel, Indiana 46032 VILLAGE FINANCIAL, LLC One Pedcor Square 770 3rd Ave. SW Carmel,Indiana 46032 June 7,2012 Village Financial Attention: Dolores Krohne • INVOICE Due: July 7, 2012 Charge Date Item Amount 7/7/2012 Administrative Fee to Village Financial 5,497. 7/7/2012 Projected Installment Purchase Obligation $185,909.94 7/7/2012 Adjusted Quarterly Fee to Regions Bank $0.00 Offset/Addition Amount $0.00 Total Amount Due $191,407.92 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 1 V Cannel, Indiana 46032 Projection Notice Backup to CRC PAC Equipment Installment Purchases 2nd Quarter 2012 May 15,2012 Payment Due Date:July 7,2012 Beginning Date Ending Date Dates 04/07/12 7/6/12 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 $3,034,000.00 $0.00 $0.00 PAC Air Handler $1,005,000.00 $1,005,000.00 $954,750.00 $50,250.00 $0.00 PAC Acoustical Equipment $1,360,000.00 $1,360,000.00 $1,111,932.00 $0.00 $0.00 PAC Millwork $3,196,705.00 $3,196,705.00 $3,007,018.02 $162,381.10 $27,305.88 PAC Stage Equipment $818,334.00 $818,334.00 $726,972.30 $0.00 $91,361.70 Note the PAC Acoustical Equipment Loan was reduced by the remaining$248,068 on 10/4/11. PAC Lighting&Generator Date Description Amount #of Days 1/28/10 Fully Fund Loan $3,034,000.00 91 Unamortized Balance $2,919,234.70 Administrative Fee $1,824.52 • Projected Interest*See attached sheet* $36,600.72 a Projected Principal*See attached sheet* $23,813.93 Adjusted Quarterly Fee S0.00 Total Due $62,239.16 PAC Air Handler Date Description Amount 4 of Days 1/28/10 Fully Fund Loan $1.005,000.00 91 Unamortized Balance $965,392.24 Administrative Fee $603.37 Projected Interest*See attached sheet* $11,176.56 b Projected Principal*See attached sheet* $8,195.72 Adjusted Quarterly Fee $0.00 Total Due $19,975.65 PAC Acoustical Equipment Date Description Amount #of Days 1/28/10 Fully Fund Loan $1,360,000.00 91 Unamortized Balance $1,051,145.06 Administrative Fee $656.97 Projected Interest*See attached sheet* $13,179.02 a Projected Principal*See attached sheet* $13,866.56 Adjusted Quarterly Fee $0.00 Total Due $27,702.55 M:\MS\BANKS\PedBancEmployees\Vicki\Village Financial\Regions\Most Current Copy of Village Financial Equipment Loans-Regions(2) • Projection Notice Backup to CRC PAC Equipment Installment Purchases 2nd Quarter 2012 May 15,2012 Payment Due Date:July 7,2012 Beginning Date Ending Date Dates 04/07/12 7/6/12 Administrative Fee Rate(to Village Financial) 0.06% Fixed Projected Interest Rate 4.96% a Projected Interest Rate 4.58% h 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 $3,034,000.00 $0.00 $0.00 PAC Air Handler $1,005,000.00 $1,005,000.00 $954,750.00 $50,250.00 $0.00 PAC Acoustical Equipment $1,360,000.00 $1,360,000.00 $1,111,932.00 $0.00 $0.00 PAC Millwork $3,196,705.00 $3,196,705.00 $3,007,018.02 $162,381.10 $27,305.88 PAC Stagc Equipment $818,334.00 $818,334.00 $726,972.30 $0.00 $91,361.70 PAC Millwork Date Description Amount 4 of Days 1/28/10 Fully Fund Loan $1,370,000.00 91 1/28/10 Fully Fund Loan $1,826,705.00 91 Unamortized Balance S3,073,614.66 Administrative Fee $1,921.01 Projected Interest*See attached sheet* $37,272.20 ab Projected Principal*See attached sheet* $25,510.12 Adjusted Quarterly Fee $0.00 Total Due $64,703.33 PAC Stage Equipment Date Description Amount 4 of Days 1/28/10 Fully Fund Loan $818,334.00 91 Unamortized Balance $787,379.37 Administrative Fee $492.1 I Projected Interest*See attached sheet* $9,871.99 a Projected Principal*See attached sheet* $6,423.12 Adjusted Quarterly Fee $0.00 Total Due $16,787.22 Total Administrative Fee $5,497.98 Projected Interest*See attached sheet* $108,100.49 Projected Principal*See attached sheet* $77,809.46 Total Adjusted Quarterly Fee $0.00 Offset Adjustment $0.00 TOTAL DUE 7/7/12 $191,407.92 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\BANKS\PedBancEmployees\Vicki\Village FinanciallRegions\Most Current Copy of Village Financial Equipment Loans-Regions(2) REGIONS BANK CALCULATION Total Payment . April 7,2012 Lighting and Generator Air Handier Equipment Acoustical Equipment Millwork Millwork Stage Equipment Total Rate 4.95% 4.58% 4.96% 4.58% 4.96% 4.96% Amount $3,034,000.00 51305.000.00 $1,360,000.00 $1,370,000.00 $1,826,70500 $818,334.00 4/7/2011 $60,012.44 $19,249.46 $26,900.76 526,240.56 536,132.18 $16,186.62 $184,722.03 7/7/2011 $60,427.37 $19,376.34 $27,086.76 $26,413.51 $36,382.00 $16,298.54 $185,984.52 10/4/2011 $0.00 $0.00 $248,068.00 $0.00 $0.00 $0.00 5248,068.00 10/7/2011 560,836.06 $19,501.22 $27,201.60 $26,583.75 $36,628.06 $16,408.77 $187,159.45 1/7/2012 $60,829.73 $19,499.20 $27,197.91 $26,581.00 $36,624.25 $16,407.07 $187,139.17 4/7/2012 $60,417.88 $19,373.31 $27,047.47 $26,409.39 $36,376.29 $16,295.98 5185,920,33 7/7/2012 $60,414.64 $19,372.28 $27,045.59 $26,407.99 $36,374.33 $16,295.11 $185,909.94 10/7/2012 $60,810.29 $19,493.02 $27,186.59 $26,572.57 $36,612.54 $16,401.82 $187,076.83 1/7/2013 $60,803.64 $19,490.91 $27,182.72 $26,569.69 $36,608.54 $16,400.03 $187,055.54 4/7/2013 $60,012.44 $19,249.46 $26,900.76 $26,240.56 $36,132.18 $16,186.62 $184,722.03 7/7/2013 $60,401.27 $19,368.04 $27,037.80 $26,402.20 $36.366.29 016,291.50 $185,867 11 10/7/2013 $60,783.22 $19,484.43 $27,170 83 526,560.87 $36,596.24 $16,394.52 $186,990 11 1/7/2014 $60,776.24 $19,482.23 $27,166 76 526,557.86 $36,592.04 $16,392.64 $186,967.76 4/7/2014 $60,012.44 $19,249.46 $26,900 76 $26,240.56 $36,132.18 $16,186.62 $184,722.03 7/7/2014 560,387.23 $19,363.60 527,029.62 526,396.15 $36,357.83 $16,287.71 $185,822.14 10/7/2014 560,754.78 $19,475.45 $27,154.27 $26,548.62 $36,579.12 $16,386.85 $186,899.09 ' 1/7/2015 $60,747.44 $19,473.14 $27,150.00 $26,545.47 $36,574.71 $16,384.87 $186,875.63 4/7/2015 $60,012.44 $19,249 46 $26,900.76 $26,240.56 $36,132.18 516,186.62 $184,722.03 7/7/2015 $60,372.47 $19,358.95 $27,021.03 $26,389.81 $36,348.94 $16,283.73 $185,774.95 10/7/2015 $60,724.90 $19,466.05 $27,136.87 $26,535.81 $36,561.13 $16,378.79 $186,803.55 $3,785,202.23 Principal Lighting and Generator Alr Handler Equipment Acoustical Equipment Millwork Millwork Stage Equipment Intel Rate 4.96% 4.58% 4.96% 4.58% 4.96% 4.96% Amount $3,034,00000 81,005,000.00 $1,360,000.00 51,370,000.00 $1,826,705.00 $818,334.00 $9,414,039.00 4/7/2011 522,390.84 $7,742.21 $10,036.76 $10,554.06 $13,481.03 $6,039.28 $70,244.19 7/7/2011 522,668.48 $7,830.86 $10,161.22 $10,674.91 $13,648.20 $6,114.17 $71,097.84 10/4/2011 $000 $0.00 $248,068.00 $0.00 $0.00 $0.00 $248,068.00 10/7/2011 $22,949.57 57,920.52 $13,363.26 $10,797.13 $13,817.44 56,189.99 $75,037.92 1/7/2012 $23,234.15 $8,011.21 $13,528.97 $10,920.76 $13,988.77 56,266.74 $75,950.60 4/7/2012 $23,522.25 $8,102.94 $13,696.73 $11,045.80 $14,162.23 $6,344.45 $76,874.41 7/7/2012 $23,813.93 $8,195.72 613,866.56 $11,172.28 $14,337.84 $6,423.12 $77,809.46 10/7/2012 $24,109.22 $8,289.56 $14,038.51 $11,300.20 $14,515.63 $6,502.77 $78,755.89 1/7/2013 $24,408.18 $8,384.48 $14,212.59 $11,429.59 $14,695.63 $6,583.40 $79,713.86 4/7/2013 $24,710.84 $8,480.48 514,388.82 511,560.46 $14,877.85 $6,665.04 $80,683.49 7/7/2013 525,017.26 58,577.58 $14,567.24 $11,692.82 $15,062.34 $6,747.68 581,664.92 10/7/2013 $25,327.46 $8,675.80 514,747.88 $11,826.71 $15,249.11 $6,831.35 $82,658.31 1/7/2014 $25,641.53 $8,775.13 $14,930.75 $11,962.12 $15,438.20 $6,916.06 583,663.80 4/7/2014 $25,959.48 $8,875.61 $15,115.89 512,099.09 $15,629.63 $7,001.82 $84,681.53 7/7/2014 $26,281.38 $8,977.23 $15,303.33 $12,237.62 $15,823.44 $7,088.64 $85,711.65 10/7/2014 $26,607.27 $9,080.02 $15,493.09 $12,377.74 $16,019.65 $7,176.54 586,754.32 1/7/2015 526,937.20 59,183.99 $15,685.21 512,519.47 $16,218.30 57,269.53 $87,809.69 4/7/7015 $27,271.22 $9,289 15 $15,879.70 $12,662.82 $16,419.40 $7,355.62 $88,877.91 7/2/2015 $27,609.38 $9,395.51 $16,076.61 $12,807.81 $16,623.00 $7,446.83 589,959.14 10/7/2015 527,951.74 $9,503.09 $16,275.96 $12,954.46 $16,829.13 $7,539.18 $91,053.55 End Bal $2,579,979.48 5849,451.10 5850,59967 $1,157,958.22 $1,553,349.18 $695,875.06 $7,616,968.52 Interest lighting and Generator Air Handler Equipment Acoustical Equipment Millwork Millwork Stage Equipment Total Rate 4.96% 4.58% 4.96% 4.58% 4.96% 4.96% 53,034,000.00 $1,005,000 00 $1,360,00000 $1,370,000.00 $1,826,705.00 $818,334.00 4/7/2011 $37,621.60 511,507.25 516,864.00 $15,686.50 $22,651.14 $10,147.34 $114,477.83 7/7/2011 $37,758.89 $I1,545.47 $16,925.54 $15,738.61 $22,733.80 $10,184.37 $114,886.68 10/4/2011 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10/7/7011 $37,886.48 $11,580.69 $13,838.34 $15,786.62 $22,810.62 $10,218.79 $112,121.54 1/7/2012 $37,595.58 $11,487.99 $13,668.95 $15,660.24 $22,635.48 $10,140.32 $111,188.57 4/7/2012 $36,895.63 $11,270.37 $13,350.75 $15,363.59 $22,214.05 $9,951.53 $109,045.93 7/7/2012 $36,600.72 $11,176.56 $13,179.02 $15,235.71 $22,036.49 $9,871.99 5108,100.49 10/7/2012 $36,701.07 $11,203 45 $13,148.08 $15,272.37 $22,096.91 59,899.05 $108,320.93 1/7/2013 $36,395 47 $11,106.43 $12,970.14 $15,140.11 $21,912.92 $9,816.63 $107,341.68 4/7/2013 $35,301.60 $10,768.98 $12,511.94 $14,680.11 $21,254.32 $9,521.59 $104,038.54 7/7/2013 $35,384.02 $10,790.46 512,470.56 $14,709.38 $21,303.95 $9,543.82 $104,202.18 10/7/2013 $35,455.75 $10,808.64 $12,422.95 $14,734.16 $21,347.13 $9,563.17 $104,331.80 1/7/2014 $35,134.71 $10,707.09 $12,236.01 $14,595.74 $21,153.84 $9,476.58 $103,303.97 4/7/2014 $34,052.96 $10,373.85 $11,784.87 $14,141.47 $20,502.54 $9,184.80 $100,040.50 7/7/2014 $34,105.85 $10,386.36 $11,726.29 $14,158.53 $20,534.39 $9,199.07 $100,110.49 10/7/2014 $34,147.51 $10,395.43 $11,661.17 $14,170.88 $20,559.47 $9,210.31 $100,144.76 1/7/2015 $33,810.25 $10,289.15 $11,464.79 $14,026.01 $20,356.41 $9,119.34 $99,065.94 4/7/2015 $32,741.22 $9,960.32 $11,021.06 $13,577.74 $19,712.77 58,831.00 $95,844.11 7/7/2015 $32,763.09 $9,963.44 510,944.42 513,582.01 $19,725.94 $8,836.90 $95,815.80 10/7/2015 $32,773.16 $9,962.96 $10,860.91 513,581.35 $19,732.00 $8,839.61 $95,750.00 $1,988,131.75 Unamortited Balance as of Date Lighting and Generator Air Handler Equipment Acoustical Equipment Millwork Millwork Stage Equipment Total Rate 4.96% 4.58% 4.96% 4 58% 4.96% 4.96% Amount 53,034,000.00 $1,005,000.00 $1,360,000.00 $1,370,000.00 $1,826,705.00 $818,334.00 4/7/2011 53,011,609.16 0997,257.79 $1,349,963.24 $1,359,445.94 $1,813,223.97 $810294.72 59,343,79481 7/7/2011 55988,94068 5989,426.93 $1,339,802.02 51,348,771.03 $1,799,575.77 $806,18055 $9,27;69697 10/4/7011 $2,988,940 68 $989,426 93 $1,091,734.02 $1,348,771.03 $1,799,575 77 $806,18055 $9,024,628 97 10/7/2011 $2,965,991.10 $981,505 40 51,078,370.76 $1,337,973.90 $1,785,758.33 $799,990.56 $8,949,591.05 1/7/2012 $2,942,756.95 $973,495.19 $1,064,841.79 $1,327,053.14 $1,771,769.56 $793,723.82 $8,873,640.45 4/7/2012 $2,919,134.70 $965,392.24 $1,051,145.06 $1,316,007.34 $1,757,60733 $787,37937 $8,796,766.04 7/7/2012 $2,895,420.77 $957,196.52 $1,037,278.50 51,304,835.06 $1,743,269.48 $780,956.25 $8,718,956.58 10/7/201.2 52,871,31155 $948,906.96 01,023,239.99 51,293,534.86 $1,728,753.85 $774,453.48 $8,640,200.69 1/7/2013 52,846,903.38 5940,522.48 $1,009,027.40 51,282,105.27 $1,714,058.22 $767,870.08 $8560,486.83 • 4/7/2013 $2,822,192.54 5932,04230 $994,638.58 $1,270,544.81 $1,699,180.37 $761,205.05 $8,479,803.35 7/7/2013 $2,797,175.29 5923,464.42 0980,071.33 $1,258,851.99 $1,684,118.03 $754,457.36 58,398,138.42 10/7/2013 $2,771,847.83 $914,788.62 $965,323.46 51,247,025.28 $1,668,868.91 5747,626.01 $8,315,480.11 1/7/2014 52,746,206.30 $906,013.49 $950,392.70 $1,235,063.16 $1,653,430.71 $740,709.95 $8,231,816.32 4/7/2014 $2,720,246.82 5897,137.88 $935,276.81 $1,222,964.07 51,637,801.08 $733,708.13 $8,147,134.79 7/7/2014 $2,693,965.44 $888,160.64 $919,973.48 $1,210,726.45 $1,621,977.64 $726,619 48 58,061,423.14 10/7/2014 52,667,358.18 $879,080.62 $904,480.39 $1,198,348.71 $1,605,957.98 $719,442.94 57,974,668.81 1/7/2015 52,640,420.98 $869,896.63 $883,795.18 $1,185,82924 $1,589,739.69 $712,177 41 57,886,859.12 4/7/2015 52,613,149.76 0860,607.48 5872,915.48 $1,173,166.42 $1,573,320.28 0704,82179 $7,797,981.21 7/7/2015 52585,540.38 $851,211.98 $856,838.86 $1,160,358.61 $1,556,697.28 $697,374 95 $7,708,022.07 10/7/2015 52,557588.64 6841.708.89 $840,562.90 $1,147,404.16 $1,539,868.15 $689,835 78 57,616,968.52 M IMSIBANKS\PedBencEmployean54okstllage Financial)Regions\Moot Current Copy of Village Financial Equipment Loans-Regions(2) 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. V \kPayr`ee Z. F1 C10(j�\ L C Purchase Order No. / 7� • 51� —7 Terms (krmJ) Tfi/ qU32_ Date Due Invoice Invoice Description Amount Date Number (or note attached invoice(s) or bill(s)) L1-t2 (.0-1 -\ SJMZ -\L 0 07 II-2_ IIS n9,a if • Total 19 I' 7,`�2. 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. Caa 2.0 , 20tL �� : • -Treasurer VOUCHER NO. WARRANT NO. l ALLOWED 20 ViI! ,e FIh&n(il(l f /L`-// IN SUM OF $ 77� 3r� AIJP . 54/ ( rmz\1.L 1A-(632 $ 161 Ij LW. 12 ON ACCOUNT OF APPROPRIATION FOR 0 2 1/ 14G626 Board Members D PT.# INVOICE NO. ACCT#/TITLE AMOUNT I hereby certify that the attached invoice(s), clIOZ QA6112—( k b iz r; 5.J 1IS or bill(s) is (are) true and correct and that 102 0‘,(1712_-2_ 1 N --6 A 9()9,1't. the materials or services itemized thereon for which charge is made were ordered and received except -(2- 20/2 Signature Fxecutive Director Title Cost distribution ledger classification if claim paid motor vehicle highway fund Carmel Redevelopment Commission