Loading...
HomeMy WebLinkAboutVILLAGE FINANCIAL, LLC- 003194- 9/20/2012 CARMEL REDEVELOPMENT COMMISSION 003194 Village Financial, LLC Check: 3194 One Pedcor Square Date: 9/20/2012 770 3rd Ave. SW Vendor: VILLFI1 Carmel, IN 46032 Prior Invoice P.O. Num. Invoice Amt Balance Retention Discount Amt. Paid 90712A 5,449.35 5,449.35 0.00 0.00 5,449.35 Administrative fee 90712B 187,076.83 187,076.83 0.00 0.00 187,076.83 Installment contract payments 192,526.18 192,526.18 0.00 0.00 192,526.18 y`f�eTHE REYiTODQGUMEN;Tj3ECUirzity�}HEIA,�Tj�1 iTcoTEUiTHi UINB_PRINTaADDITiONAL'SE_Cuoly FEATURES ttoici DED SEE BACK FORIDETAILS ; '` i Alt tg6 i Es . Carmel Redevelopment Commission 003194 30 West Main Street A REGIONS 20-1421!740 Suite 220 °AR"'E` Carmel, IN 46032 i/STRILt 3194 DATE AMOUNT 9/20/2012 ********192,526.18 PAY THE SUM OF ONE HUNDRED NINETY TWO THOUSAND FIVE HUNDRED TWENTY SIX DOLLARS AND 18 CENTS"'******** { TO THE ORDER OF Village Financial, LLC One Pedcor Square 770 3rd Ave. SW r=""'' Carmel, IN 46032 "� II'003 L94" 1:0740 L4 2 L31: 0087504 L L 1,11° CARMEL REDEVELOPMENT COMMISSION 003194 Village Financial, LLC Check: 3194 One Pedcor Square Date: 9/20/2012 770 3rd Ave. SW Vendor: VILLFI1 Carmel, IN 46032 Prior Invoice P.O. Num. Invoice Amt Balance Retention Discount Amt. Paid 90712A 5,449.35 5,449.35 0.00 0.00 5,449.35 Administrative fee 90712B 187,076.83 187,076.83 0.00 0.00 187,076.83 Installment contract payments 192,526.18 192,526.18 0.00 0.00 192,526.18 <-11-52 COMPUTEREASE FORMS DIVISION(877)577-5791 T-71771 VILLAGE FINANCIAL, LLC One Pedcor Square 770 3rd Ave. SW Cannel,Indiana 46032 September 7, 2012 Village Financial Attention: Dolores Krohne INVOICE Due: October 7, 2012 Charge Date Item Amount 10/7/2012 Administrative Fee to Village Financial $5,449.35 10/7/2012 Projected Installment Purchase Obligation $187,076.83 10/7/2012 Adjusted Quarterly Fee to Regions Bank $0.00 Offset/Addition Amount $0.00 Total Amount Due $192,526.18 101()� 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 Projection Notice Backup to CRC PAC Equipment Installment Purchases 3rd Quarter 2012 September 7,2012 Payment Due Date:October 7,2012 Beginning Date Ending Date Dates 07/07/12 10/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 $1,005,000.00 $0.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,169,399.12 $0.00 $27,305.88 PAC Stage Equipment $818,334.00 $818,334.00 $726,972.30 $38,401.70 $52,960.00 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 92 Unamortized Balance $2,895,420.77 Administrative Fee $1,809.64 Projected Interest*See attached sheet* $36,701.07 a Projected Principal*See attached sheet* $24,109.22 Adjusted Quarterly Fee $0.00 Total Due $62,619.93 PAC Air Handler Date Description Amount #of Days 1/28/10 Fully Fund Loan $1,005.000.00 92 Unamonized Balance $957,196.52 Administrative Fee $598.25 Projected Interest*See attached sheet* S11,203.45 b Projected Principal*See attached sheet* $8,289.56 Adjusted Quarterly Fee $0.00 Total Duc $20,091.26 PAC Acoustical Equipment Date Description Amount #of Days 1/28/10 Fully Fund Loan $1,360,000.00 92 Unamortized Balance $1,037,278.50 Administrative Fee $648.30 Projected Interest*See attached sheet* $13,148.08 a Projected Principal*See attached sheet* $14,038.51 Adjusted Quarterly Fee $0.00 Total Due $27.834.89 M:1MS\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 3rd Quarter 2012 September 7,2012 Payment Due Date:October 7,2012 Beginning Date Ending Date Dates 07/07/12 10/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 $1005,000.00 $1,005,000.00 $0.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,169,399.12 $0.00 $27,305.88 PAC Stage Equipment $818,334.00 $818,334.00 $726,972.30 $38.401.70 $52,960.00 PAC Millwork Date Description Amount #of Days 1/28/10 Fully Fund Loan $1,370,000.00 92 1/28/10 Fully Fund Loan $1,826,705.00 92 Unamortized Balance $3,048,104.54 Administrative Fee $1,905.07 Projected Interest*See attached sheet* 537,369.28 ab Projected Principal*See attached sheet* $25,815.83 Adjusted Quarterly Fee $0.00 Total Due $65,090.18 PAC Stage Equipment Date Description Amount #of Days 1/28/10 Fully Fund Loan $818,334.00 92 Unamortized Balance $780,956.25 Administrative Fee $488.10 Projected Interest*See attached sheet* $9,899.05 a Projected Principal*See attached sheet* $6,502.77 Adjusted Quarterly Fee $0.00 Total Due $16,889.92 Total Administrative Fee $5,449.35 Projected Interest*See attached sheet* $108,320.93 Projected Principal*See attached sheet* $78,755.89 Total Adjusted Quarterly Fee $0.00 Offset Adjustment $0.00 TOTAL DUE 10/7/12 $192,526.18 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 FinancialtRegions\Most Current Copy of Village Financial Equipment Loans-Regions(2) REGIONS BANK CALCULATION Total Payment 1119 7,2012 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 13,034,000.00 $1,05,000.0 $1,360,000.00 $1,370,000.00 51,826,705.00 $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 $77,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 $248,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 50,829.73 $19,499.20 527,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 $185,920.33 7/7/2012 $60,414.64 $19,372.28 $27,045.59 $26,407.99 $36,374.33 $16,295.11 5185,909.94 10/7/2012 $60,810.29 $19,493.02 $27,186.59 $26,572.57 $36,612.54 516,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 526,240.56 $36,132.18 $16,186.62 $184,722.03 7/7/2013 $60,401.27 $19,367.04 $27,037.80 $26,402.20 536,366.29 $16,291.50 $185,867.11 10/7/2013 $60,783.22 $19,484.43 $27,170.83 $26,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 $60,387.23 $19,363.60 $27,029.62 $26,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 519,249.46 $26,900.76 $26,240.56 $36,132.18 $16,186.62 $184,722.03 7/7/2015 $60,372.47 $19,358.95 $27,021.03 $26,389.81 536,348.94 $16,283.73 $185,774.95 10/7/2015 $60,724.90 $19,466.05 $27,136.87 526535.81 536,561.13 $16,378.79 $186,803.55 $3,785,202.23 Principal Lighting and Generator Air Handler Equipment Acoustical Equipment Millwork Millwork Stage E g quipment Tgtal Rate 4.96% 4.58% 4.96% 4.58% 4.96% 496% Amount $3,034,000.00 $1,005,000.00 $1,360,000.00 51,370,000.00 51,826.7M 00 5818,334.00 $9.414,039,00 4/7/2011 $22,390.84 $7,742.21 $10,036.76 $10,554.06 $13,481.03 $6,039.28 $70,244.19 7/7/7011 522,668.48 $7,830.86 $10,161.22 $10,674.91 $13,648.20 $6,114.17 $71,097.84 10/4/2011 $0.00 $0.00 $248,068.00 $0.00 $0.00 $0.00 $248,068.00 10/7/2011 $22,949.57 $7,920.52 $13,363.26 $10,797.13 $13,817.44 $6,189.99 $75,037.92 1/7/2012 $23,234.15 $8,011.21 $13,528.97 $10,920.76 $13,988.77 $6,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 $13,866.56 $11,172.28 $14,337.84 $6,423.12 $77,809.46 10/7/2012 $24,309.22 $8,289.56 $14,038.51 $11,300.20 $14,525.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 56583.40 $79,713.86 4/7/2013 $24,710.84 $8,480.48 $14,388.82 $11,560.46 $14,877.85 $6,665.04 $80,683.49 7/7/2013 $25,017.25 $8,577.58 $14,567.24 511,692.82 $15,062.34 $6,747.68 581,664.92 10/7/2013 $25,327.46 $8,675.80 $14,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 56,916.06 $83,663.80 4/7/2014 $25,959.48 $8,875.61 $15,115.89 $12,099.09 $15,629.63 $7,001.82 $84,681.53 7/7/2014 $26,281.38 $8,977.23 515,303.33 $12,237.62 $15,823.44 $7,088.64 $85,711.65 10/7/2014 $26,607.27 $9,080.02 515,493.09 $12,377.74 $16,019.65 $7,176.54 $86,754.32 1/7/2015 $26,937.20 $9,183.99 $15,685.21 $12,519.47 $16,218.30 $7,265.53 $87,809.69 4/7/2015 $27,271.22 59,289.15 $15,879.70 $12,662.82 $16,419.40 $7,355.62 $88,877.91 7/7/2015 $27,609.38 $9,395.51 $16,076.61 012,807.81 $16,623.00 $7,446.83 $89,959.14 10/7/2015 $27,951.74 $9,503.09 $16,275.96 $12,954.46 $16,829.13 $7,539.18 $91,053.55 End 841 $2,579,979.48 $849,451.10 $850,599.67 $1,157,958.22 $1,553,349.18 5695,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,00000 $1,005,000.00 $1,360,000.00 51,370,000.00 $1,826,705.00 $818,334.00 4/7/2011 $37,621.60 $11,507.25 $16,864.00 $15,686.50 522,651.14 510,147.34 $114,477.83 7/7/2011 $37,758.89 $11,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 $000 $0.00 $0.00 $0.00 10/7/2011 $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 511,487.99 $13,668.95 $15,660.24 522,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 59,951.53 $109,045.93 7/7/2012 $36,600.72 $11,176.56 $13,179.02 515,235.71 $22,036.49 $9,871.99 $108,100.49 10/7/2012 $36,701.07 $11,203.45 $13,148.08 $15,272.37 $22,096.91 $9,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 $12,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 514595.74 $21,153.84 $9,476.58 $103,303.97 4/7/2014 $34,052.96 510,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 $10,944.42 $13,582.01 $19,725.94 $8,836.90 595,81530 10/7/2015 $32,773.16 59,962.96 510,860.91 $13,581.35 $19,732.00 $8,839.61 $95,750.00 $1,988,131.75 Unan,ortired Balance as of Date Ughting 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 $3,034,000.00 $1005,000.0 $1,360,000.00 $1,370,000.00 $1,826,705.00 $818,334.00 4/7/2011 $3,011,609 16 $997,257.79 $1,349,963 24 $1,359,445 94 $1,813,223.97 $812,294.72 $9,343,794.81 7/7/2011 $2,988,940.68 $989,426.93 $1,339,80202 $1,348,771.03 $1,799,575.77 $806,180.55 $9,272,696.97 10/4/2011 $2,988,94068 5989,426.93 $1,091,734.02 $1,348,771.03 $1,799,575.77 $806,180.55 $9,024,628.97 10/7/2011 $2,965,991.10 $981,506 40 $1,078,370 76 $1,337,973.90 $1,785,758.33 $799,990.56 58,949,591.05 1/7/2012 $2,942,756.95 5973,495.19 $1,064,841.79 11,327,053.14 $1,771,769.56 $793,723.82 $8,873,640.45 4/7/2012 $2,919,234.70 $965,392.24 $1,051,145.05 $1,316,07.34 $1,757,607.33 1787,379.37 $8,79,766.04 7/7/2012 $2,895,420.77 $957,196.52 $1,037,278.50 $1,104,835.06 $1,743,269.48 $780,956.25 0,718956.58 10/7/2012 $2,871,311.55 $948,906.96 $1,023,239.99 51,293,534.86 $1,728,753.85 $774,45348 58,640,200 69 1/7/2013 $2,846,903.38 5940,522.48 $1,009,027.40 $1,282,515.27 $1,714,058.22 1767,670.08 $8,560,486.83 4/7/2013 02,822,192.54 $932,042.0 1994,63858 $1,270,544.81 $1,699,180.37 5761,205.0 $8,479,803.35 7/7/2013 $2,797,175.29 5923,45442 $980,071.33 51,258,85199 51,684,118.03 $754,457.36 $8,398,138.42 10/7/2013 $2,771,847.83 $914,788.62 $965,323.46 $1,247,025.28 51,668,868.91 $747,626.01 $8,315,480.11 1/7/2014 $2,746,20.30 $906,013.49 $950,392.70 11,235,03.16 $1,653,430.71 1740,709.95 $8,231,816.32 4/7/2014 $2,720,246.82 $897,137.88 5935,276.81 $1,222,964.07 $1,637,801.08 $733,708.13 $8,147,134.79 7/7/2014 $2,693,965.44 $688,16064 5919,973.48 $1,210,776 45 $1,621,977.64 $726,619.48 $8,01,423.14 10/7/2014 $2,667,358.18 $879,080.62 5904,480.39 $1,198,348.71 11,605,957.98 1719,442.94 $7,974,668.81 1/7/2015 52,640,42098 5869,896.63 $888,795.18 51185,829.24 51,589,739.69 $712,177.41 $7,886,859.12 4/7/2015 $2,613,149.76 $860,607.48 $872,915.48 $1173,166.42 $1,573,320.28 $704,821.79 $7,797,981.21 7/7/2015 $2,585,540.38 $851,211.98 5856,838,86 $1,160,358.61 51,556,697.28 $697,374.95 $7,708,02207 10/7/2015 52,557588.64 $841,708.89 5840,562.90 $1,147,404.16 $1,539,868.15 $689,835.78 $7,616,008.52 M.V4518ANK5 1Ped8ancEmployeesWick■3Illa8e FinanGelLRogionslMnst Current Copy of Village Financial Equipment Lonna-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. Payee )647 v 7 4-4 G Purchase Order No. 0/7P /2J�!C1� .562(..y.-✓ 7 70 3rd ,*2;/,. 5e=C/ Terms (-(r /, //e) 17/603 2 Date Due Invoice Invoice Description Amount Date Number (or note attached invoice(s) or bill(s)) -471-714- % a 7 l2/'' 70%,;,3 t�r7i'✓P /— S `7( 9.3 5 7//2 2 , 2,2_ 6 s //,,7,,77" 12,,-z4 5r- //cY .0 8- 7/d 76, Total /92, 52 6/1 I hereby certify that the attached invoice(s), or bill(s), is (are) true and correct and I have - •' -d same in accor- dance with IC 5-11-10-1.6. - , 20 t Z ° - - easurer VOUCHER NO. WARRANT NO. ALLOWED 20 //�/66 ,c/, l L C � �^ IN SUM OF $ QU7 2° �'°lac ey. ' Ca r'27 o/ /ry `7'60 3 $ /22, 526 ,/e • • ON ACCOUNT OF APPROPRIATION FOR 26)2 Board Members PO#or INVOICE NO. ACCT#/TITLE AMOUNT DEPT.# I hereby certify that the attached invoice(s), 'g/609t 5,1/4g 39- or bill(s) is (are) true and correct and that 7/2- 6 174/6092 187 07?3 the materials or services itemized thereon for which charge is made were ordered and received except • —2J 20 rZ .gnature Executive Director Title Cost distribution ledger classification if Carmel Redevelopment Commission claim paid motor vehicle highway fund