HomeMy WebLinkAbout247527 07/15/15 CITY OF CARMEL, INDIANA VENDOR: 363909
ONE CIVIC SQUARE VILLAGE FINANCIAL, LLC CHECK AMOUNT: $****37,474.26*
r° CARMEL, INDIANA 46032 ONE PEDCOR SQUARE CHECK NUMBER: 247527
770 3RD AVE SW CHECK DATE: 07/15/15
CARMEL IN 46032
DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION
902 4460805 70615 37,474.26 RETAIL SITE #5
VILLAGE FINANCIAL, LLC
AMENDED AND RESTATED INSTALLMENT PURCHASE AGREEMENT
SECONDARY NUMBER ONE & SECONDARY NUMBER TWO
NOTICE
To: Carmel Redevelopment Commission
Date: 7/6/2015
Payment Date: 7/15/2015
This document services as the written notice for the Installment Payment Due, in accordance with the Amended and Restated
Installment Purchase Agreement(Secondary Number One)and the Amended and Restated Installment Purchase Agreement
(Secondary Number Two)both executed as of October 1,2013 between The City of Cannel Redevelopment Commission and Village
Financial,LLC.
For the Period of: 1/15/15-7/14/15
INTEREST DUE
SECONDARY SECONDARY
NUMBER ONE NUMBER TWO TOTAL
Outstanding Balance $ 4,500,000.00 $ - $ 4,500,000.00
Prorate Share 100% 0%
AVAILABLE FUNDS FOR PAYMENT
Semi Annual Existing Improvement Received $ 500,70726 $ - $ 500,707.26
Less: Semi Annual Threshold(17/185th) $ (463,233.00) $ - $ (463,233.00)
Available Increment for Interest Payment $ 37,474.26 $ - $ 37,474.26
INTEREST AMOUNT
Total Interest Due for Period $ 66,616.84 $ - $ 66,616.84
Interest Deferred Due to Unavailable Increment $ (29,142.58) $ - $ (29,142.58)
CRC Total Actual Amount to Pay $ 37,474.26 $ - $ 37,474.26
TOTAL INSTALLMENT INTEREST PAYMENT DUE: $ 37,474.26 $ - $ 37,474.26
Payment is due by the Cannel Redevelopment Commission to Village Financial, LLC by: July 15,2015
Prepared By: (x(X,l-1J1-C-Q �
111 On October 14.2014 as part of the old Shapiro's Building purchase.Installment Contract Secondary Number Two's principle.accrued interest.
and deferred interest was forgiven.
E
0
k
R
�=�� . . . . . . . . . . . . . . .E�E�LE�
E8 S8E=LsEE
w`
839 ^^-3r - �R�.:8RRBR?RB��BBB
_--- 4_-48833=�3�8�€�
c 9
E u
- 88838893389888RR88RRBBBR-8999888998
9B ��€IgE'€��E=L�EEEE=LEEE�LEE�LEEE�EE
�i
�5„„59-9885-9898389
o '-
u L
p .n v,v.v.�•
9833953383893988888=_BBR9RBBRRBRR95R
�' n�rvrry rvrnnn -----------
HH
---- -- rrrrr
} Y
6 -
U n-
� �a r.ry r ry n n n r ry r ry ry ry r r n ry n ry ry ry ry n ry ry
� �3 -oc�oo coccc <000c -
CO = �K _egg_-cc-ccrcc-�--c--c-cc-Ccccc-c--
� U
F Y _
F I oz/SI/1 SIOZ/SI/I SIIIZ/sl/L 9111Z6I/I 91111/SI/L
INSTALLMENT PURCHASE AGREEMENTS(SECONDARY#I ) Data Entry Required:
PAYMENTDETERMINATION SCHEDULE Step 2: Once TIF Settlement is available from Treasurer,the amount received by the City for the
Existing Improvement as defined by the Parcel Listing should be entered into appropriate
Date: 7/6/2015 period.
Mav RE Taxes Paid/TIF Recv'd = Nov RE Taxes Paid/TIF Reev'd=
July 15 Payment .laze 15 Payment
Amount Available Amount Availal
Remain Oale Inclement (17/1 X5th) incWuiljfl�. of'SIC Payment Payment Interest Imcfesl Principal to Ila,16 V1,'V Increment 11cliod
12/31/13 $ 271,129.25
42 01/15/14 $ 477,081.01 $ 340,194.00 $ 136,887.01 $ 83,709,56 $ 83,709.56 $ 83,709.56 $ $ 271,129.25
M 41 07/15/14 $ 483,955.74 S 429.660.00 $ 54,295.74 $ 81.708.75 $ 54,295.74 $ 54,295.74 $ 27,413.01 $ 298,542.26
O 10/14/14 $ $ $ - $ (92.532.79) $ 206,009.47
C� 40 01/15/15 $ 536,366.62 $ 429,660.00 $ 106.706.62 $ (7,467.21) $ 68,804.52 S 61,337.31 $ 61.337.31 $ $ 206.009,47
39 07/15/15 $ 500,707.26 $ 463,23.3.00 $ 37,474.26 $ 66,616.84 S 37,474.26 $ 37,474.26 S 29,142.58 $ 235,152.05
38 01/15/16 $ - S 463,233.00 S - $ 64,446.53 S $ S 64,446.53 $ 299,598.58
Q 37 07/15/16 $ $ 514.569.00 $ $ 63,350.00 $ $ $ 63,35000 $ 362,948.58
I- 36 01/15/17 $ $ 514,569.00 $ $ 64,050.00 $ $ S 64,050.00 S 426,998.58
Z 35 07/15/17 $ S 523.311.00 S $ 63,350.00 $ $ $ 63,350.00 $ 490,348.58
34 01/15/18 $ $ 523.311.00 $ $ 64,050.00 S $ $ 64,050.00 $ 554,398.58
33 07/15/18 $ $ 545,212.00 $ $ 63.350.00 $ S $ 63.350.00 $ 617,748.58
32 01/15/19 $ $ 545.213.00 S S 64,050.00 $ 140,625.00 $ $ $ $ 64,050.00 S 681,798.58
31 07/15/19 $ $ 562,650.00 $ $ 63,350.00 $ 145,161.29 S $ $ S 63,350.00 $ 745,148.58
30 01/15/20 $ $ 562,650.00 $ $ 64,050.00 $ 150,000.00 S $ $ S 64,05000 $ 809,198.58
29 07/15/20 $ $ 576,646.00 $ S 63,350.00 S 155,172.41 S S $ $ 63,350.00 S 872,54858
28 01/15/21 $ $ 576.647.00 S S 64,050.00 $ 160,714.29 S S S S 64.050.00 $ 936,598.58
27 07/15/21 $ $ 592,875.00 S $ 63.350.00 $ 166,666.67 $ $ S $ 63,350.00 S 999,948.58
26 01/15/22 $ $ 592.875.00 S $ 64,050.00 $ 173,076.92 $ $ $ $ 64,050.00 S 1.063,998.58
O 25 07/15/22 $ $ 612,219.00 S $ 63,350.00 $ 180,000.00 $ $ $ S 63,350.00 $ 1,127,348.58
24 01/15/23 $ S 612,219.00 $ $ 64,050.00 $ 187,500.00 $ S $ $ 64,05000 $ 1,191,398.58
LLJ� 23 07/15/23 $ $ 580,971.00 $ $ 63,35000 $ 195,652.17 $ $ $ $ 63,350.00 $ 1,254,74858
22 01/15/24 $ $ 580,971.00 S S 64.050.00 $ 204,545.45 $ S $ $ 64,050.00 $ 1.318,798.58
21 07/15/24 S $ 569.206.00 $ S 63.350.00 $ 214,285.71 $ $ $ $ 63,350.00 $ 1,382,148.58
0 20 01/15/25 $ $ 569.207.00 $ $ 64.050.00 $ 225,000.00 $ $ $ $ 64.050.00 S 1,446,198.58
U 19 07/15/25 $ $ 588,271.00 $ $ 63,350 00 $ 236,842.11 $ $ $ S 63,350.00 S 1,509,548.58
LLJ
n 18 01/15/26 $ $ 588,272.00 S $ 64,050.00 $ 250,000.00 $ $ $ $ 64,050.00 $ 1,573,598.58
17 07/15/26 $ $ 602,361.00 $ $ 63.350.00 $ 264,705.88 $ $ $ $ 63,350.00 $ 1,636,948.58
16 01/15/27 $ $ 602,361.00 $ $ 64,050.00 S 281,250.00 S $ $ $ 64,050.00 S 1,700,998.58
15 07/15/27 $ $ 598.408.00 $ $ 63,350.00 $ 300,000.00 $ $ - $ $ 63,350.00 S 1,764,348.58
14 01/15/28 S $ 598.409.00 S $ 64.050.00 S 321,428.57 S $ $ S 64.050.00 S 1,828,398.58
13 07/15/28 $ S 594,781.00 $ $ 63.350.00 $ 346,153.85 $ $ $ $ 63.350.00 S 1,891,748.58
12 01/15/29 $ S 594,782.00 $ $ 64,050.00 S 375,000.00 $ $ S S 64,050.00 S 1.955,798.58
II 07/15/29 S $ 486,436.00 $ $ 63,350.00 S 409,090.91 $ $ S $ 63,350.00 S 2,019,148.58
10 01/15/30 $ S 486,437.00 S $ 64.050.00 $ 450.000.00 S 201,914.86 S 715.964.86
0 9 07/15/30 $ $ 434,310.00 $ $ 57,015.00 $ 450,000.00 $ 201,914.86 $ 708,929.86
8 01/15/31 $ $ 434310.00 $ $ 51.240.00 $ 450,000.00 $ 201,914.86 S 703,154.86
7 07/15/31 $ $ 434.077.00 $ S 44,345.00 $ 450,000.00 $ 201.914.86 S 696,259.86
a
6 01/15/32 $ $ 434,078.00 $ $ 38.430.00 $ 450,000.00 $ 201.914.86 $ 690,344.86
5 07/15/32 $ S 424,638.00 $ $ 31,675.00 $ 450,000.00 $ 201.914.86 S 683,589.86
4 01/15/33 $ $ 424,638.00 $ $ 25,620.00 $ 450,000.00 $ 201,914.86 $ 677,534.86
2 3 07/15/33 $ $ 472,161.00 $ $ 19,005.00 $ 450,000.00 $ 201.914.86 $ 670 919.86
2 01/15/34 S S 472,161.00 S $ 12,810.00 $ 450,000.00 $ 201,914.86 $ 664,724.86
1 07/15/34 $ $ 468,906.00 $ $ 6,335.00 $ 450,000.00 S 201.914.86 S 658,249.86
Prepared By:
Approved 13y:
AMORTIZATON TABLE FOR PRINCIPAL
PAYMENTS DURING SECOND PERIOD
Balance of Installment Contracts is pulled in from each period
and divided over the number of remaining semi annual
payments remaining. Principal amount is adjusted each
payment date.
Amortized
Principal Payment
of based on of
Period Pa.yinent Periods
® i. a Remaining.,-
32 01/15/19 $ 4,500,000.00 $ 140,625.00
31 07/15/19 $ 4,500,000.00 $ 145,161.29
30 01/15/20 $ 4,500,000.00 $ 150,000.00
29 07/15/20 $ 4,500,000.00 $ 155,172.41
28 01/15/21 $ 4,500,000.00 $ 160,714.29
27 07/15/21 $ 4,500,000.00 $ 166,666.67
26 01/15/22 $ 4,500,000.00 $ 173,076.92
QO 25 07/15/22 $ 4,500,000.00 $ 180,000.00
24 01/15/23 $ 4,500,000.00 $ 187,500.00
W
23 07/15/23 $ 4,500,000.00 $ 195,652.17
22 01/15/24 $ 4,500,000.00 $ 204,545.45
Ca 21 07/15/24 $ 4,500,000.00 $ 214,285.71
20 01/15/25 $ 4,500,000.00 $ 225,000.00
U 19 07/15/25 $ 4,500,000.00 $ 236,842.11
18 01/15/26 $ 4,500,000.00 $ 250,000.00
17 07/15/26 $ 4,500,000.00 $ 264,705.88
16 01/15/27 $ 4,500,000.00 $ 281,250.00
15 07/15/27 $ 4,500,000.00 $ 300,000.00
14 01/15/28 $ 4,500,000.00 $ 321,428.57
13 07/15/28 $ 4,500,000.00 $ 346,153.85
12 01/15/29 $ 4,500,000.00 $ 375,000.00
11 07/15/29 $ 4,500,000.00 $ 409,090.91
Final 10 01/15/30 $ 4,500,000.00 $ 450,000.00
Prescribed 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
Villue hhocPurchase Order No.
)
77 Terms
Date Due
Invoice Invoice Description Amount
Date Number (or note attached invoice(s) or bill(s))
j,
Total
1 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.
20
Clerk-Treasurer
VOUCHER NO. WARRANT NO.
f ALLOWED 20
Vi 16 e Ellin (W, �-1 � - IN SUM OF $
oh,@ Pv--�tbr
$ 17.
ON ACCOUNT OF APPROPRIATION FOR
�Qtih
902-/44 60905
Board Members
PO#or
DEPT.# INVOICE NO. ACCT#/TITLE AMOUNT I hereby certify that the attached invoice(s),
`ATL 5 6 gU 'TNA A� 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
201_5-
Si at
Title
Cost distribution ledger classification if
claim paid motor vehicle highway fund