Press Alt + R to read the document text or Alt + P to download or print.

No preview available

The URL can be used to link to this page

Home My WebLink AboutVILLAGE FINANCIAL, LLC. -002571 -12/22/2011 CARMEL REDEVELOPMENT COMMISSION 0 0 2571 Village Financial, LLC Check: 2571 One Pedcor Square Date: 12/22/2011 770 3rd Ave. SW Vendor: VILLFI1 Carmel, IN 46032 Prior Invoice P.O. Num. Invoice Amt Balance Retention Discount Amt. Paid 111811 192,664.31 192,66.4.31 0.00 0:00 192,664.31 Installment contract payments 192,664.31 192,664.31 0.00 0.00 192,664.31 5 VILLAGE FINANCIAL, LLC One Pedcor Square 770 3rd Ave. SW Carmel,Indiana 46032 November 18, 2011 Village Financial Attention: Dolores Krohne INVOICE Due: January 7, 2012 Charge Date Item Amount 1/7/2012 Administrative Fee to Village Financial $5,593.49 1/7/2012 Projected Installment Purchase Obligation $187,139.17 1/7/2012 Adjusted Quarterly Fee to Regions Bank $0.00 Offset/Addition Amount ($68.35) Total Amount Due $192,664.31 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 P16 b9 V Projection Notice Backup to CRC PAC Equipment Installment Purchases 4th Quarter 2011 November 15,2011 Payment Due Date:January 7,2012 Beginning Date Ending Date Dates 10/07/Il 1/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 $0.00 $50,250.00 PAC Acoustical Equipment $1,360,000.00 $1,360,000.00 $1,111,932.00 $0.00 $248,068.00 PAC Millwork $3,196,705.00 $3,196,705.00 $3,007,018.02 $0.00 $189,686.98 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 92 Unamortized Balance $2,965,991.10 Administrative Fee $1,853.74 Projected Interest*See attached sheet* $37,595.58 a Projected Principal*See attached sheet* $23,234.15 Adjusted Quarterly Fee $0.00 Total Due $62,683.47 PAC Air Handler Date Description Amount #of Days 1/28/10 Fully Fund Loan $1,005,000.00 92 Unamortized Balance $981,506.40 Administrative Fee $613.44 Projected Interest*See attached sheet* $11,487.99 b Projected Principal*See attached sheet* $8,011.21 Adjusted Quarterly Fee $0.00 Total Due $20,112.64 PAC Acoustical Equipment Date Description Amount #of Days 1/28/10 Fully Fund Loan $1,360,000.00 92 Unamortized Balance $1,078,370.76 Administrative Fee $673.98 Projected Interest*See attached sheet* $13,668.95 a Projected Principal*See attached sheet* $13,528.97 Adjusted Quarterly Fee $0.00 Total Due $27,871.90 C:\Users\doloresk\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\Y35PCS63\Village Financial Equipment Loans-Regions • Projection Notice Backup to CRC PAC Equipment Installment Purchases 4th Quarter 2011 November 15,2011 Payment Due Date:January 7,2012 Beginning Date Ending Date Dates 10/07/11 1/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 $0.00 $50,250.00 PAC Acoustical Equipment $1,360,000.00 $1,360,000.00 $1,111,932.00 $0.00 $248,068.00 PAC Millwork $3,196,705.00 $3,196,705.00 $3,007,018.02 $0.00 $189,686.98 PAC Stage Equipment $818,334.00 $818,334.00 $726,972.30 $0.00 $91,361.70 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,123,732.23 Administrative Fee $1,952.33 Projected Interest*See attached sheet* $38,295.72 ab Projected Principal*See attached sheet* $24,909.53 Adjusted Quarterly Fee $0.00 Total Due $65,157.59 PAC Stage Equipment Date Description Amount #of Days 1/28/10 Fully Fund Loan $818,334.00 92 Unamortized Balance $799,990.56 Administrative Fee $499.99 Projected Interest*See attached sheet* $10,140.32 a Projected Principal*See attached sheet* $6,266.74 Adjusted Quarterly Fee $0.00 Total Due $16,907.06 Total Administrative Fee $5,593.49 Projected Interest*See attached sheet* $111,188.57 Projected Principal*See attached sheet* $75,950.60 Total Adjusted Quarterly Fee $0.00 Offset Adjustment (Adjustment to 1 0/7/2011 payment made-see attached) ($68.35) TOTAL DUE 1/7/12 $192,664.31 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 C:\Users\doloresk'AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\Y35PCS63\Village Financial Equipment Loans-Regions ■ REGIONS BANK CALCULATION Total Payment January 7,2012 Lighting and Generator Air Handler Equipment Acoustical Equipment Millwork Millwork Stage Equipment Total Rate 4.96% 458% 4.96% 458% 4.96% 4,96% Amount 53,034,000.00 $1,005,00000 51,360,000.00 51,370,000.00 $1,826,705.00 5818,33400 4/7/2011 $60012.44 919,249 46 $26,900.76 $26,240.56 $36,132.18 916,186.62 5184,722.03 7/7/2011 560,42737 519,376.34 527,086.76 $26,413.51 $36,382.00 $16,298.54 $185,984.52 10/4/2011 90.00 50.00 5248,068.00 50.00 $0.00 $000 5248,068.00 10/7/2011 $60,836.06 $19,501.22 527,201.60 526,583,75 536,628.06 516,408.77 5187,159,45 1/7/2012 560,829.73 519,499.20 $27,197.91 $26,581.00 536,624.25 $16,407.07 5187,139.17 4/7/2012 $60,417.88 $19,373.31 $27,047.47 526,409 39 $36,375.29 $16,295.98 5185,920 33 7/7/2012 560,414.64 519,372.28 $27,045.59 926,407.99 036,374,33 516,295.11 5185,90994 10/7/2012 $60,810.29 519,493.02 $27,186.59 $26,572.57 936,612.54 516,401.82 $187,076.83 1/7/2013 $60,803.64 $19,490.91 $27,182.72 526,569.69 536,608.54 $16,400.03 $187,055.54 4/7/2013 $60,012.44 519,249,46 $26,900.76 $26,240.56 $36,132.18 $16,186.62 $184,722.03 7/7/2013 560,401.27 $19,368.04 527,037.80 926,402.20 $36,366.29 $16,291.50 $185,867.11 10/7/2013 560,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 519,482.23 $27,166.76 526.557 86 $36,592.04 $16,392.64 $186,967.76 4/7/2014 960,012.44 $19,249.46 $26,900.76 $26,240 56 536,132.18 516,186.62 5184,722.03 7/7/2014 $60,387.23 519,363.60 $27,029.62 526,396.15 $36,357.83 $16,287,71 $185,822.14 10/7/2014 $60,754 78 $19,475 45 $27,154.27 $26,548.62 936,579.12 $16,386.85 $186,899.09 1/7/2015 $60,747.44 919,473,14 $27,150.00 $26,545 47 $36,574.71 $16,384.87 5186,875,63 4/7/2015 560,012.44 $19,249.46 526,900.76 926,240.56 $36,132.18 516,186.62 $184,72203 7/7/2015 560,372.47 519,358.95 927,021.03 $26,389.81 $36,348.94 $16,283.73 $185,774.95 10/7/2015 560,724.90 $19,466.05 $27,136.87 $26,535.81 $36,561.13 $16,370.79 $186,803.55 $3,785,202.23 Principal Lighting and Generator Air Handler Equipment Acoustical Equipment Millwork Millwork Stage Equipment Total Rate 496% 4,58% 4.96% 4.58% 4.96% 495% Amount $3,034,000.00 $1,005,000.00 $1,360,000.00 51,370,000.00 $1,826,701.00 $818,334.00 $9,414,039.00 4/7/2011 522,390.84 57,742.21 $10,036.76 $10,554.06 $13,481.03 $6,039.20 $70,244.19 7/7/2011 $22,668.48 57,830 86 510,161.22 910,674.91 $13,648.20 $6,114.17 $71,097.84 10/4/2011 $0.00 $0.00 5248,068.00 90.00 $000 50.00 5248,068.00 10/7/2011 922,949.57 57,920.52 513,363.26 $10,797.13 $13,817.44 $6,189.99 $75,037.92 1/7/2012 523,234.15 $8,011.21 $13,528.97 $10,920.76 $13,988.77 56,266.74 975,950.60 4/7/2012 523,522.25 $8,102.94 513,696.73 511,045,80 $14,162.23 $6,344.45 $76,874.41 7/7/2012 923,813.93 $8,195.72 913,866.56 511,172.28 914,337.84 $6,423.12 577,809.46 10/7/2012 $24,109.22 58,289.56 914,038.51 $11,300.20 $14,515.63 $6,502.77 $78,755.89 1/7/2013 $24,408.16 58,394.48 614,217.59 $11,42959 514,695.63 $6,583.40 $79,713.86 4/7/2013 $24,710.84 98,480.48 514,388.82 011,56026 $14,877.85 $6,665.04 580,683.49 7/7/2013 $25,017.25 $8,577.58 $14,567.24 511,692,82 $15,062.34 $6,747.68 181.664.92 10/7/2013 $25,327.46 $8,675.80 514.747,88 511,82671 $15,249.11 $6,831 35 $82,658.31 1/7/2014 $25,641.53 $8,775.13 $14,930.75 $11,962.12 515,438,20 $6,916.06 $83,663.80 4/7/2014 525,959 48 $8,875 61 $15,115.89 $12,099.09 $15,629.63 $7,001.82 $84,681.53 7/7/2014 526,281.38 $8,977.23 $15,303.33 $12,237.62 515,823.44 $7,088.64 585,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 515,685.21 912,519.47 516,218.30 $7,265.53 $87,809.69 4/7/2015 527,271.22 $9,289.15 $15,879.70 $12,662.82 516,419.40 57,355.62 588,877,91 7/7/2015 $27,609.38 $9,395.51 $16,076.61 $12,807.81 516,623.00 57,446.83 089,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.51 End MI $2,579,97948 9849,451 10 9850,599.67 51,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% 496% 4,96% 03,034,000.00 $1,005,000.00 51,360,00000 $1,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 $22,651.14 $10,147.34 $114,477.83 7/7/2011 $37,758.89 $11,545.47 516,925.54 $15,738.61 $22,733.80 $10,184.37 9114,886.68 10/4/2011 90.00 $0.00 50,00 $0.00 90.00 90.00 50.00 10/7/2011 537,886.48 511,580.69 $13,838.34 $15,786.62 $22,810.62 510,218.79 9112,121,54 1/7/2012 $37,595.58 511,487.99 513,668.95 515,660,24 522,635,48 510,140.32 5111,188.57 4/7/2012 536,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 913,179.02 515,235.71 922,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 511,10643 012,970.14 515,140.11 $21,912.92 $9,816.63 $107,341.68 4/7/2012 535,301.60 $10,768.98 $12,511.94 $14,680.11 $21,254.32 59,521.59 9104,038.54 7/7/2013 535,384.02 $10,790.46 $12,470.56 514,709.38 521,303,95 59,543.82 $104,202.18 10/7/2013 $35,455.75 $10,808.64 $12,422 95 514,734.16 521,347.13 59,563 17 5104,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 511,784.87 014,141,47 $20,502.54 59,184.80 $100,040.50 7/7/2014 $34,105.85 $10,386.36 $11,726.29 514,158.53 $20,534.39 59,199.07 $100,110.49 10/7/2014 $34,147.51 $10,395.43 $11,661 17 914,170.88 $20,559.47 $9,210.31 $100,144.76 1/7/2015 933,810 25 $10,289.15 511,464.79 $14,026.01 920,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 $8,831.00 $95,844.11 7/7/2015 $32,763.09 $9,963.44 $10,944.42 $13,582.01 519,725.94 58,836.90 $95,815 80 10/7/2015 $32,773.16 59,962.96 $10,86091 513,581.35 $19,732.00 98,839.61 995,750.00 $1,988,131.75 Unamortited Balance as of Date Lighting and Generator Alr 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,00000 $1,005,000.00 $1,360,000.00 51,370,000.00 $1,826,705.00 $818234,00 4/7/2011 $3,011,609.16 9997,25779 51,349,963.24 $1,359,445.94 51,813,223.97 5812,294.72 59,343,794.81 7/7/2011 52,988,940 68 5989,426,93 91,339,802.02 51,348,771.03 51,799,57577 5806,18055 $9,272,69697 10/4/2011 $2,988,940.68 $989,426.93 51,091,73402 $1,348,77103 $1,799,575 77 5806,180,55 $9,024,628.97 10/7/2011 97,955,99110 $981,50640 $1,078,370.76 51,337,97390 $1,785,75833 9799,990.56 98,949,591.05 1/7/2012 52,942,75695 $973,495.19 51,064,841.79 51,327,053.14 51,771,769.56 $793,723.82 $8,873,640.45 4/7/2012 92,919,234.70 $969,392.24 01,051,145.06 $1,316,007.34 $1,757,607.33 5787,379,37 $8,796,766.04 7/7/2012 $2,895,420.77 5957,196.52 $1,037,278.50 $1,304,835.06 51,743,26948 5780,956.25 58,718,956.58 10/7/2012 $2,871,311.55 $948,906.96 51,023.23999 51,293,534.86 51,728,753.85 9774,453.48 $8,640,200.69 1/7/2013 02,846,90338 $940,522.48 51,9679,027.40 51,282,105,27 51,714,05822 $767,870.08 $8,560,486.83 4/7/2013 $2,822,192.54 $932,042.00 $994,638.58 $1,270,544 81 51,699,18037 5761,205.05 18,479,80335 7/7/2013 $2,797,175.29 $923,464.42 $980,071.33 $1,258,851.99 51,684,118,03 $754,457.36 58,398,13842 10/7/2013 $2,771,847.83 $914,788.62 $965,323.46 $1247,025.28 $1,668,868.91 $747,626.01 $8,315,480.11 1/7/2014 $2,746,206.30 $906,013.49 $950192.70 $1,235,06316 51,653,43071 $740,709.95 $8,231,816.32 4/7/2014 52,720,246.82 5897,137.88 $935,276.81 51,222,96407 51,637,801.08 5733,708.13 $8,147,134.79 7/7/2014 $2,693,965.44 $888,160.64 $919,973.48 51,210,72645 $1,621,977.64 $726,619.48 $8,061,423.14 10/7/2014 92,667,358,18 $879,080.62 5904,480.39 51,198,34871 51,605,957.98 $719,442.94 57,974,668,81 1/7/2015 $2,640,420.98 $869,896.63 $888,795.18 51,185.829.24 51,589,739.69 0712,177.41 57,836,859.12 4/7/2015 02,613,149.76 5860,607.48 5872,915.48 51,173,16642 51,573,320.28 5704,821,79 $7,797,981.21 7/7/2015 52,585,540.38 5851,21198 5856,838.86 51,160,358.61 $1,556,697.28 $697,374.95 $7,708,022.07 10/7/2015 92,557,588.64 $841,708.89 5840,562.90 51,147,40416 $1539,868.15 $689,835.78 57,616,968.52 M\MS\BANKS\pedBancEmpioyeee5lann84r\Village FinanciahVillage Financial Equipment Loans-RegionsJP-Copy Acoustical Principal Interest Total Payment 10/7/11 Payment Made 10,287.22 16,982.73 27,269.95 Correct 10/7 Payment 13,363.26 13,838.34 27,201.60 (3,076.04) 3,144.39 $ 68.35 Over Payment Made 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. `l Payee V I l ll�9 FI M (I(1I L L C Purchase Order No. 1 7� Ord Pk, S W Terms 7 I l 6.rmel T 6b32 Date Due Invoice Invoice Description Amount Date Number (or note attached invoice(s) or bill(s)) II-A-\ \\\EI\ llegi4115 ti_t,ArAerly otli94. rah c A11\11) fef 192, 04, 3/ a / f..• Total ea b�� 31 hereby certify that the attached invoice(s), or bill(s), is (are) true and correct and I ha - . •ited ame in accor- dance with IC 5-11-10-1.6. , 20 1 CiciK '1r_:!frer VOUCHER NO. WARRANT NO. ALLOWED 20 V Ill�g Tlivo LLC IN SUM OF $ 770 3rd AVt S � C me1)_T $ \Q( 60.31 ON ACCOUNT OF APPROPRIATION FOR CM/04() c\IU Board Members D PT.# INVOICE NO. ACCT#/TITLE AMOUNT I hereby certify that the attached invoice(s), �Q`l__ \\M\ LkikbQO2A, 192 31 or 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 �Z-s-20I� i i nat e Executive`utrector _.. . Title Cost distribution ledger classification if claim paid motor vehicle highway fund Carmel Redevelopment Commission