Loading...
HomeMy WebLinkAboutFinancial April 2012CARMEL REDEVELOPMENT COMMISSION Financial Information Packet For the Month Ending April 30, 2012 Carmel Redevelopment Commission Financial Packet Table of Contents Schedule Section Schedule 1- Budget Year 2012 Monthly Projections and Results - Combined 1 Budget Year 2012 Monthy Projections and Resultes - Non Operating 1A Budget Year 2012 Monthy Projections and Resultes - Operating 1B Revenue Budget Analysis 1C Expenditure Budget Analysis 10 Summary of Cash and Cash Rights 1E Schedule 2 - Debt Summary 2 Additional Information 2A Developer Bonds 2B Schedule 3 - 4CDC Grant Obligations 3 Schedule 4 - Installment Purchase Contract Summary 4 Mercantile $10,000,000 Contract 4A National Bank of Indianapolis $10,000,000 Contract 4B Regions Bank $25,000,000 Contract 4C Regions Bank $10,000,000 Contract 4D Appendix A - Analysis of December 2011 TIF Collections A -1 1•1:1 111111111111111110111■11111166■11111111■11111111111111111111111111MIE1111111■1111111111E1 13,..,,t ■2/151.1,iillIONIONI1111111111111111111111111111111111011111111111111111111111111011 Nom Carmel Redevelopment Commission Budget tear 2012 Monthly Projections - Non Operating For month ending April 30, 2012 Reference A 6 C C [ r G H 1 1 K L f'9 N 0 Reference 1 Actual Actual Actual Actual 900( @CTIFA P110199'I'An NRCIIECTED PROpEG.TLM PRO /ECEED PROJECTED PROJECTED PROJECTED( 2 ®IMMI®IEMI®® 2'nt;ul x252 Budget 2 3 3 4 NON OPERATING BALANCE 55.8]3.910 $887,401 $372,590 $312,961 .h"G 0lS2!SgE, §2,339909 §b Sb $tf SD 50 4 5 5 6 Line a4 Credit -Non Operating 7 Line ot1,743 Draws q 1,033,692 800,965 439303 55£0750 2.6£10 .F,6 777602 12593 ,t0, *197 595.2'120 8,$95,E?2 7 8 1;17 of Cr,dii Repnyments tl 0 tl 0 12!1'x051.01 167618:4') (8, 535,014229 3 9 Total Line of Credit Activity 0 D la 800,965 48'),3£3 .9159 12.3 felrJj '4.800,460 777 J90 C'%'S947 5955 "L9' (516:: &331 1'1 - A 10 IIIIIIIMIMIIIIIIIIIMIIIIIMIIIIIIIMMIIMIIIMIIIelil - - -- 10 11 RECEIPTS - NON OPERATING (.04,5031 0 _ 0 - _IIIMMIIIIII-llIllnlil. .44504 -- 713q 363 ,1X,505,130 17,664,443 11 12 12 TIP Revenue, Net of Developer Pass Through 13 N611nstallmen!Purcha.se Contract 45],000 0 0 518 IN10 zoom 860,000 13 14 Regions Installment Purchase Contract 0 0 0 225,000 14 15 Installment Purchase Contract b 0 0 1,750L'0l) 1111 1,`/.50004; 2,000,000 15 16 Wells Fargo 0 96753 0 Pi p fl '59,732 354,960 16 17 TOTAL RECEIPTS- NON OPERATING 1' ''''31 96153 Q 06955 ® ! ly lC >6(', 0 20,211,9'33 0f,17.11„P223 21,104,403 21,1tl4,40) 17 13 19 18 TOTAL REVENUE5 -NON OPERATING INFORMIMPEI 29 20 EXPENDITURES NON OPERATING ®® 20 21 Construction ■■■ 21 22 PAC Construction/Retention 969015 p 96.753 34 , ?43 >'��' 2lD w20 70,672 '011 „Ypt, f OOt 13 ft 'I'1, PE9L' 1.550,200 103,000 22 23 23 PAC Consultants 24 Palladium Landscaping 0. 5],000 0 0 4 PO -__ frl',1 2J -- 60,000 24 25 RPACThearer Equipment MIMI 111111KI - - -_ -- :' 27 225,000 25 26 Parcel 73 071 Construction Management ® 21,123 0 S,33d 8,325 ©- a5,p6fl 1111111EMMIIIIIIMIEMIIIIIIESEIMIIMMIMM 1 / 0t NIX 1772000 120,000 25 27 27 Parcel 5 3D Parcel 5 P II 0 0 0 6 17v7 ObG 1 7,0 J4l' 1.740.000 28 29 Parcel 575 II suance Costs 0 0 0 1 MEM■■■ 250,000 29 3D Parcel 4]51 to pe 23,433 0 50,435 13,071 92,23 251,200 30 31 Demolition f G in Elpvalors IIMIIIMMI113 =IIIIIIIIIMMMIIIIIMIIIMIIIIIIIIIIIIIMIIII 7210000 200.000 31 32 Monon Trail Revisions 0 0 0 0 0.i,120q J5,000 25,ftilf, 2505161 100,000 100,000 32 33 Miscellaneous tan lns 0 6,340 451 6q6 157'1 6206 6,200 6,218 0$08 f20tl 40 , OM 40,000 33 34 Other Projects 78,519 1P,234 5,774 16047 a,!4�dk 90,934 E�0,63.4 20,6E 30.634 ',(16,;14 OGin 3(1G3a 390,900 850,000 34 35 4C0C Grants 33 36 Parking Surcharge 0 26 900 10,640 ,:488 1 aVW 1,, "1,q 11 41,,:44 A4, <ut.�4 el4q�4¢ J. ,.1in 26413;? "S ]85,Q04 36 37 Parcel ?Tenants' Rent q &787 48,78] ,, '2. 186,4 &6,4a2R3Y 97674 4P'x72 49,57Z 56,21P ,524,)4 6 ?' lr'70i 2:1628 „! u18 21?7,398 338,349 37 35 1arkington Construction Shortfall ®�IIIIIMII -MIIIIIIIIMIMMIIIIIIIIIIMIIIIIII -- 1 „03:,692 964,000 38 39 Professional Fees 39 40 Legal Fees 33,327 44,150 102093 L1 Y,253 !6'296 HR7U7 34,.0'7 34.707 3a ��Tf :1,A,'tp7 '9!:,715% 34,707 1506000 600,000 40 41 Arch/Engineering 37,530 44,421 88,94 4 C ]0LC17 ,h]0 50',170 5D. :70 5f1.170 501TtiI 1,,1:'!9 00,170 570,900 620,000 91 42 Accounting Rees ® ®IIIMM ® ® 04,95,, 45,000 42 43 and Contracts 43 44 Parcel 9,25 Party Tone 19,000 19,000 19,000 18,000 IS 900 13,0012 15,990 19,009 15,090 9;1110 191709 n,pr;12'1 228.,:,00 223,000 94 45 Parcel 9 -31 Chaos - land acquisition 2,436 24436 2,436 2,436 2 „133 't,�tp0 .436 2,456 2„430. 2;436 2,434 2,150 46,1!2r1 29230 45 96 Parcel 14 Harrill Properly Purchase 19090 10,000 10000 10,000 117,700 10,00) 'WAX/ 10,000 2 ,0,000 10,000 'IC,000 ',2,06'0 120,000 120,00D 46 47 eobbylohn, LLC 7,625 9,625 7,625 7,625 7,623 7,525 7,625 7,,i. >: 7,92,9 7,625 7.625 7,525 91,5 00 91,500 47 48 Non'P0 Service 4,298,669 0 0 0 hid 5,362. 3,5Ltr1,L)01 Mld1,E &M 7,738,661 3,213,802 48 49 2005 PAC lease Lome R 9 . 0 7,690,0902 5,60511100 ".r,2tN2,0f211 5,20.000 49 50 Instalment Purchase Contract Payments 407,690 238,289 23,4091 499,536 299,9127 200070 571488 ::92,420 ]G9 „0]Z 76,001 262,128 29 ,,238. 4 .'220,'!i,v 8,561,609 50 31 Contract Purchase Administrative Fees 12,481 12.755 44,630 2,095 8,1 M7 98,273 Z,OF'0 3,30 0,273 2.023 10,'56 .40150 2'3,420 245,000 51 52 4100 Grant. Line of Credit Interest Expense 0 0 0 0 1t 6;36 9,F1an2 119919 21,2712 ;.3. 723 26,69E 29,0126 14O, 150,000 52 53 TOTAL EXPENDITURES ' NON OPERATING 4,497,637 1,695,259 860,555 887,191 492,261 6,1205 X5,.1.09,'159 777,(}02 .,2 „154 895,9,15 ,',5829 (.. 25,927,31E 27,068,690 53 54 OPERATING FUNDS TRANSFERRED TO NON OPERATING 134,848 647,2147 Sq. SS INTERFUND LOAN (141,367) 0 0 tl 0 ,. f) q CI n 0 $5 56 ENDING BALANCE-505 OPERATING 887,403 $3'2550 5312,961 $0 h.FD3 ,,,56,),M)9 L'1 Cd p q fl 56 -SA- Carmel Redevelopment Commission Budget Year 2012 Monthly Projections - Operating For month ending April 30, 2012 Reference A 0 c C 1 3 9 H I 1 IS L M N 0 Reference 1 Actual Actual Actual Actual PROJECTED 7001820815 PROJECTED PROIECTED PROIECTED PROJECTED 1102544035 2005120802 1 2 January February March April May lone 0489 Aorgett September October November December Mara 2012 Budget 7 3 3 4 OPERATING BALANCE 108,672 108,072 144,075 214,130 190,107 190409 005,440 108,949 108,054 115,835 1,921609 1776090 4 5 5 6 Line of Credit - Operating 6 7 Line of Credit Draws 0 67,048 242,094 192,320 210,001 62,929 169,079 168,002 1,012329 7 8 Line of Credit Repayments 0 0 0 0 (1,112,029) 14110,629) 9 9 Total Line of Credit Activity 0 67,048 242,004 192,523 210,001 00,959 169,079 065,012 0 (10110,5251 15 0 0 9 10 10 11 Receipts-OPERATING 11 12 Parcel 7o roof repair reimbursement 0 9 0 0 0,000,000 3,000,009 3,000,000 12 13 Energy Center Payments 32,429 37,760 26,922 0 95,912 30,908 38,919 30,009 00,905 95,935 00,059 .50,909 095,940 448,000 13 14 Parking Surcharge 0 26,900 11,143 19,340 17,052 17,050 17,052 17,052 44,440 45,4.50 00444 44344 299.959 136,000 14 15 Parcel 7 Tenants' Rent 48,787 48,787 48,787 46,787 49,767 49,579 49,572 01,159 51,505 52,0700 40,620 67,350 349,759 338,349 15 16 Keystone Group LLC Receivable 0 0 8 0 900,000 200,700 200,000 06 17 Miscellaneous revenue 755 0 64,763 1,090 5,970 29,000 9,000 5,900 25,020 041,459 70,000 17 18 Line of Credit Grant to CPAP 603,571 525,000 485,000 615,000 485,705 389,710 3,000,001 3,000,000 18 19 0160 99 Credit Grant from 4CDC 0 0 0 0 19 20 Total 60001440 -0966071362 685,542 638,447 637,314 675,627 404,407 220,507 110,612 117,200 040,000 6146,040 161,060 045,040 7,084,744 7,242,349 20 21 Total Revenue- OPERATING 685,342 793,494 679,316 663,155 695,348 079,316 279,091 285,089 044,000 2,034,441 101,000 140,000 7,634,904 7,242,349 21 22 22 23 EXPENDITURES- OPERATING 23 24 Operations and Maint. 24 25 OpereOons 37,839 40,357 53,585 37,522 64,049 40,570 19,970 45.070 40,870 400,875 90,070 42,070 119,005 040,530 25 26 Marketing/Events 7,913 6,418 8,393 4,963 1,202 20,000 00,000 00,000 40,000 30,000 44,094 43,094 270,000 270,000 26 27 Marketing/Business Development 27,450 9,159 13,650 11,900 07,540 15,970 13,972 00,372 15,972 10,372 66,970 15,970 201,500 201,500 27 CRC Lease 8,185 5,990 7,042 7,042 7,040 7,040 7,040 7,042 7,042 7,047 7,042 7,042 94,010 98,223 28 29 010 06066 Shopper and Carrnel OTS Lease 2,769 319 5,538 3,730 2,085 5,079 5,079 5,079 5,079 0,079 5,079 0,079 90,000 50,000 29 20 Parcel 7C Energy Center Utilities 59,390 23,420 21,430 27,240 40,901 41,659 60.069 33.660 30,669 38,609 05,159 08,069 430,000 450,000 30 31 Parcel 7C Management Fee 2 0 13,000 0 22305 0,251 9,231 9,211 '0,001 9,051 0,231 9,741 100,000 100,000 31 32 Parcel 7C Garage CAM 23,434 0 0 0 8,708 3,710 5,702 5,700 0,751 5,703 0,750 50,000 15,000 32 33 Parcel 700933/0531 CAM 0 0 33,651 19,523 00415 34,171 66,222 44.,251 34,221 34,221 94,701 .34,221 002000 330,000 34 Parcel 205689(146 0 3,000 1,000 7,670 3,209 0,000 1,000 1,000 0,000 1,000 1,000 1,000 20,579 12,000 34 35 Line of Credit Grant to CPAF 603,571 525,000 485,000 615,000 005,715 005,710 3,000,000 3,000,000 35 16 Veterans Way Snow Removal 2 11,884 27,562 0 87,000 120,746 350,000 36 37 Profession/199es 37 38 Legal 10,339 14,310 27,633 2,352 10,305 19,977 19,577 19,577 15,577 15,077 23,077 19,577 210,000 210,000 38 39 Arch/Engineering 0 913 1,338 677 901 2,299 2,299 0,295 2,296 2,059 0,299 7,299 20,000 20,000 39 40 Accountng Fees 13,269 6,203 15,289 8,691 11,009 21,213 20,715 21,219 21,219 21,219 01,019 21,010 201,000 203,000 40 41 P18n3i34, Appraisals, Engineer Consulting 11,597 17,095 84,520 9,700 00,773 19,207 19,617 19,617 10,617 19,617 19,107 19,017 315,000 315,000 41 42 Miscellaneous 21,100 6,326 3,616 1,432 148 2,402 7,.510 2,411 0,411 0,411 0,411 2,411 00,200 52,300 42 43 4CDC Grant - Line of Credit Interest Expense 0 0 0 0 17,095 13,094 19,750 19,878 19,970 9,40.5 5,313 100,444 43 44 TOTAL EXPENDITURES - OPERATING 026,909 670,092 809,265 757,251 597,397 608,011 279,600 280,254 .055,010 200,100 324,403 360,908 0,242,766 6,385,253 44 45 TOTAL OPERATING FUNDS TRANSFERRED TO NON OPERATING 5 0 0 ($159,143) 0 7 (1 0 0 11 (847,947) 45 46 187866430 LOAN 141,367 46 47 ENDING 0506920 006645333 101,672 144,075 214,130 190,187 000,139 109,646 113,149 100,054 105,036 0,321,306 4770,039 709;243 47 -1B- Carmel Redevelz A Commission Month and 'fear to Date Revenue Budget Analysis For the Month Ending April 30, 2012 Reference A I 8 0 I 9 .1 E I F 3 1 H 1 I 1 1 K Reference 1 p .1 Current Month Comments Current Year Budget 1 2 2 3 % YTI) Bi.__*,0„ 4E384i 9 Varian 4e Proposed Adjustments Revised YTO $ Remaining, Recognized 4 RECEIPTS- NON OPERATING i 4 5 Line of Credit Draws $439,383 439,383 50 41,929,069 51,929,069 $2.274,040 IF 349,4 ',II). 117.88% 5 6 Line of Credit Repayments 0 0 0 0 0 0 0 0.00% 7 TIF Revenue, Net of Developer Pass Through 0 0 0 17,664,443 17,664,443 9294,501) 18,458,946 -4.55% 7 8 1401 Installment Purchase Contract 0 0 0 860,000 860,000 457,000 403,000 53.14% 8 9 Regions Installment Purchase Contract 0 0 0 225,000 225,000 0 225,000 0.00% 9 10 Installment Purchase Contract 0 0 0 2.000,000 2,000,000 0 2,000,000 100% 10 11 Wells Fargo 150,819 0 95,..j11„) bneing able to draw this amount to begin paying down the Feinstein Build-out note but negotions for terms 01 030 g note have delayed this ie b tor the anticipated tm 154,960 . 354,960 96,751 252,207 27.2691 11 12 12 13 TOTAL REVENUES- NON OPERATING 590,202 439,363 1.390,913i 23,033,475 23,033,472 2,023,290 21,012,102 878% 13 14 14 15 15 16 16 17 .____ 17 18 RECEIPTS • OPERATING 18 19 Line of Credit Draws 192,428 192,428 0 0 0 501,560 1011,1.1111) 0.00% 19 20 Line of Credit Repayments 0 0 0 0 0 0 0 0.00% 20 21 Parcel 7e roof repair reimbursement 2 0 0 3,000,000 3,000,000 0 3,000,000 0.0000 21 22 Energy Center payments 38,988 0 H011) we did not receive any April energy payments until May 1st 440,000 448,000 97,111 350,889 21.68% 22 23 Parking Surcharge 0 10,840 10,840 we did not ant1cipate receiving 354 01 April 186,000 180,000 49,583 136,417 26.66% 23 24 Parcel 7 Tenants' Rent 48,787 48,787 0 338,349 330,349 195,148 143,201 57.68% 24 25 Keystone Group, 11,0 Receivable 0 0 0 200,090 200,000 0 200,000 0.00% 25 26 Miscellaneous revenue 0 1,000 1,000 Shapiro's rent that we didn't anticipate receiving in April 70,990 70,000 66,518 3,482 95.03% 26 27 Line of Credit Grant from 400080 CPAF 615,000 615,000 0 3,000,090 3,000,000 2,228,571 771,429 74.29% 27 28 1199 08 Credit Grant from 4000 0 0 0 0 0 00000 28 29 29 30 TOTAL REVENUES - OPERATING 895,303 858,155 R1,1481 7,242,349 7,242,349 3,13E511 4,103,838 43.34% 30 31 31 32 TOTAL REVENUES - COMBINED 01,485,305 41,307,538 {S 1 719*/ 530,275,821 330,275,821 55,161,801 525,114,020 32 33 33 34 34 35 35 36 36 mvl Rodeos. Month and Your to Data bapendit mBudget Analysis For the Month Ending April 30, 2012 Re en A J R C D E E I G H 1 I K Reference 2 3 curzon t Mamh Cammmnts Current Year Budget 840473 Anunl $04153340 y13MOM4 pdiustmenb Revised y7Q $37 I ■ 8 Reco. d a E %DEN 0170730: 50N4030Ai1NG on.trucVo 5 PAC Censtructl7n /PHrmlon 515333 5454 3450, }) an c paled be1713617 Jo Flayl18d0wnlhe13090 nBU lld,o01n0136736ltamovn7 bM ne¢otlansfertormsofthe note 6300404330 th Is far the Ylmeb1114 51,559,000 61,050,00 513],471 71,432,529 9.377,3. 0 103000 103,300 30.008 03,102 9.42% 8 Palladium Landscaping p 86 OD 860000 45],000 406000 PP terfiquIPrrem 0 335.00 3.2] 8 22],]13 DI f0 ,77 Pmrca 78 AJl.ConxtnimIon Manage manL 7 10 0 12'7,660 177,000 0 840 177 000 40,151 0,0073 66.$4% 11 45,06 45,069 12 Porre15pha.se11 p 3230,000 1.750,00 1750000 000% 12 33 Parcels Ph33011 Issuance 00173 0 050,000 0 250,000 0007,. 00 ]4 71,7714757re1101400 ])8)' 13,871 231,20 251,200 37,700 260.431 39,93% 15 00m011tio3 of fualn Ele ator 3 200,00 200,000 0 )00,000 0.00% 43 Manors Trall Rev13 s 0 1 100,00 100,00 0,0051. 1T Mlacel[aneaas Lnndscnping 59 593 40,000 40,000 ],390 3'$,614 10.490 17 1$ 0163177110373 8,95 16,047 11.U3Pol tllfi3 s du e to plymen1 02111nvolctt Shal Ly 37,3333,00X7 Mav 850,00 850,.0 110,5]6 100,424 13.01% 38 9 4000 Grants 0 9 0 0 0,00% 20 73,37 73721053,33 0 10,040 paymen4 of parking svr<harpt if dependent Upon receipt of payment from the Center, which 00 didn't an ticlpate on recelvin810APrll 99,583 136.41] 26.66% 20 21 rtt176002nL Rent 46.'16] 97,574 7, 1711 May rent was 311213theend ofnp l 723212 of Itf'sl week of Mar 338.399 334,3140 033,57 3 ;:lei 133,7773 21 33 Terkington Donn 70030313005411 0 0 964,00 964,000 1,003002 ,,.. 407.0073 22 23 Proltsi0rval rtes tl 0 A P,W'14 23 14 25 031414105 ArcF /En8lneerin3 E03,204 42,204 511203 46,204 60,000 - 420,0. - 45.0. 6.,000 620.00 68' 000 113 413 ' �' r 46,2 310,70) 021,300 ®® 111111111111111=11111119211 . 805, 20 In8 Yee! 2,006 x000 La d p 0 0.0% •T 28 P' '2 06347.me ]9,40 10,400 228,0. Y9.33U 220,00 20230 70740 9] .0 15948 19,986 33.33% 23 4 31 1 3] and acqu s ties 2,436 111 P 14 Narr IProperky Purchase ]0001 0000 10,600 320,000 91,50 91 0,500 8000 61000 33.33,E 33.03% 30 31 33 Bobby loan, 170 7,605 7,625 32 Non PAC Debt 1erv1ce 0 0 3,213 802 3 213 800 3 098,664 184,8627 102,640 32 33 YWS770134se 0 0 00 000 5,20000 0 520000 000'73 33 34 InStallmenY PUlehme f- on CrvatY 7aymenCt 687103 949535 1 65:1; dIH n was apprpved and odg na lv set7o be padln Mareh but was Vnid'n early APrI Instead 6,561,603 245,000 - 000 244,000 1.42§000 ,555 71961 ®� 171.039 1.50,00 ®® 0.00'4. 36 15 Contract Porthase AdminlHr4tivl Feai 2,095 2,095 36 4 u of At e 1 Drpens 2150,000 TOTAL AA Di NON op IN 541,414 E87 190 3 21048,488 Q 2),068,686 ],890,682 19, 78000 39 38 40 0 41 E%pENQITUPE5:0f+ERATING a2 Dperatlons and Malnten ance 0 0 0 0,00 w aE 007773[1013 87,507 37,522 49,98 TM10 difference Is due Laos eztlmnte of $40,000 of property [eves I6a[ wtr4 approved In Ap711, but o check wasn'lo03,011M4y. Al30, thert was one less weekafpayro111n A2r11, 640,530 640,000 164,296 971,232 ?6.4777 43 d4 Morketln3 /Events 4,963 4,943 ?15,07 242,313 10,25% 49 45 MarkUlncPBUS(neas Development 11,900 11,90G 20],9110 201,50(1 62,150 139.950 10.84'16 46 CAC Lease 7,042 7,042 98,223 90,223 50,000 20.269 12,355 704 3705,645 2 8. 4 66 E3 M.3N 4U 47 40 OId 02wn 362004 4 4 02 1411.107341443 3,740 9]30 5000 48 P 47437734,3 707 707 701 3 711111¢1 27,243 07.243 450,000 450,000 101,499 318,501 29.23% 48 40 74/192/0 Man 3437401 Fee 0 Q 1QQ00 144.00 13,000 87,000 007 49 50 Parrel 721311a09 iNM 0 DO 8 000 20.432 61,516 003513• S9 51 Pa7ce17CC 000/0177 CAM 19,029 19,329 330,00 12,06 1111111111111 3,0007100 030.004 12,000 3,00,060 57,98 7 2,220.$21 2/2,013 .4 751,029 115773 94.25^2. 74.29% 41 _...........52.. 53 52 14 Oros 7,670 7,670 53 Llne ofcredh Grant. CPA E 615,00 615.00 tl SA te 4040208 Way.Snnw Aemovnl 0 0 350000 350,000 39,296 310,]59 11./144 54 55 71ofeaatunal Fees 0 0 d 0.00% �b 46 Legal Fees 2,826 2,362 47 010913 1x dve to Invoice beln3 approved tar the.5[3116 lime mod 11 had already bean paid In aaprevloocmoath o 310060 210,000 04,634 155,466 26.00% 56 57 4rch /E781noc,1n3 677 977 20.070 20000 2,928 37,072 14.64"/3 57 58 co Untlne Fete 8,691 20300 3,000 9 3.45E 8 40 58 59 114 00113.4301810111, Englnecr C40711 0;114 9,700 9,700 315,000 9 0 1,0,0 0 00 a101147eoas ] 0 111131erre33 duets Reg 101 131 ed 5 MO 50 0 4.8, 94 70 tit 4 C Grant -Lino of Credit Interest ExPenxe tl 171.000 / 0 1)1,900 0.0073 63 62 TOTAL ENPEN81745&0' OPERATING 807,528 757,295 0 1 . 6,406143 0 6,556,213 9063,483 3,432,770 46.7011 62 63 69 00303 E801340100005- 0073025E0 $1.346,942 51,644,409 1'.' 671 533,024,141 $6 533,624.941 510,954,262 512,610,776 82580I 45 65 -10- Carmel Redevels. .nt Commission Summary of Cash and Cash Rights For the Month Ending April 30. 2012 Reference A I B C 0 1 E F G 1 H I 1 J K Reference 1 2 Description Clerk - Treasurer (1) CRC (2) Lake City (3) Harris Bank (4) Wells Fargo (5) Mercantile (6) Star(6) Marine (6) Fowler (6) Harris Bank (6) Total 2 3 Cash and Rights Balance 4/1/12 3 4 1101 Cash $ 9,438.26 $ - 0 - $ - $ - $ _ $ - $ _ $ _ $ _ $ 9,438.26 4 5 1110 TIF Distributions 7,275.56 - - - - - - - 7.275,56 5 s 1118 2008 TIF Bond Proceeds 2,485.01 - - - - - _ _ - 2.48531 6 7 1119 2008 TIF Debt Service Res 3,309.91 - - - _ - _ - _ _ 3309.91 7 8 CRC Star bank - 255,001.12 - - _ - - _ - - 255,001.12 8 9 4807257943 BMO Harris Bank - 68,608.73 - - - - - - - - 68,608.73 9 10 87504111 Regions Bank - 180,972.46 - - - - - - - 180.972.46 10 11 Wells Fargo- Energy Center Sale - - - - 259,209.98 - 259,209.98 11 12 Cash Rights - - 1.671,865.00 315,438.00 - 0.00 1,825,179.00 1,197.591.10 2,500,000.00 418,139.15 7.928,212.25 12 13 Total Cash $ 22,508.74 $ 504,582.31 0 1.571,865.00 $ 315,438.00 $ 259,209.98 $ 0.00 5 1,825,179.00 $ 1,197.591.10 $ 2,500,005.00 $ 418,139.15 $ 8,714,513.28 13 14 14 15 Receipts 6 16 Clerk-Treasurer Funds $ - $ - $ - $ - $ _ $ _ $ _ $ _ $ _ $ _ $ _ 16 17 Developer Payments - _ _ - _ _ _ _ - 15 18 CRC Star Bank 48,787.06 - _ _ _ _ _ _ _ 48,787.06 15 19 4807257943 BMO Harris Bank - - - _ 20 87504111 Regions Bank - 261,840.00 - - - - - - - - 261,840.00 20 21 Transfer - 4)19112 - 631,910.38 - - - - - (631,910.38) - - _ 21 22 Transfer -/12 - - - - - - (615,000.05) - - - (615,000.00) 22 23 Transfer -/12 23 24 Transfer -/12 - 24 25 Total Receipts 5 - $ 942,537.44 $ - $ - $ - $ - $ (615,000.00) $ (631,910.38) $ - $ - $ (304,372.94) 25 26 26 27 Disbursements 27 2a Clerk - Treasurer Funds S 269.28 $ - $ - $ - $ _ $ _ $ _ $ _ $ _ $ - $ 269.28 28 z9 PAC 20 30 Non -PAC - - _ a1 CRC Funds - 31 32 CRC Star Bank - 250.000.00 - - _ _ _ _ _ _ 250300.00 32 33 4807257943 BMO Harris Bank - 16.81 - - _ _ _ _ _ - 16.81 33 34 87504111 Regions Bank - - 34 35 Installment Centred Loans - - - - _ _ - _ - - 35 CPAF - 36 PAC - - - - - - - - - - 36 371 Non -PAC - 1,029,155.35 - _ - _ _ _ - 38 4CDC LOC Approved Draws - - - _ _ - _ _ - - - 38 39 Total Disbursements $ 269.26 $ 1,279.172.15 $ - $ - S - $ - $ _ $ _ $ _ $ - $ 250.286.09 39 40 40 41 1101 Cash $ 3168.98 $ - $ _ $ _ $ _ $ - $ _ $ _ $ _ $ _ $ 9.168.98 41 42 1110 TIF Distributions 7,275.56 - - - _ _ _ - - 7.275.56 42 43 1118 2008 TIF Bond Proceeds 2,485.01 - - _ - _ _ _ _ - 2.485.01 43 44 1119 2008 TIF Debt Service Res 3,309.91 - - _ _ _ _ - _ - 3309.91 44 45 CRC Star Bank - 53.788.18 - - - - - - - - 53.788.18 45 46 4807257943 BMO Harris Bank - 68,591.92 - - _ - _ _ _ _ 68,591.92 46 a7 87504111 Regions Bank - 45.567.49 - - - - - - - - 45,567.49 47 as Wells Fargo - Energy Center Sale - - - 259,209.98 - - - 259,209.98 48 49 Cash Rights - - 1,671,865.00 315,438.00 - 0.00 1,210.179.00 565,680.72 2,500.000.00 418,139.15 6,681,301.87 a9 50 Cash and Rights Balance4 /30/12 $ 22,239.46 $ 167,947.59 $ 1,671,865.00 $ 315,438.00 $ 259,209.98 $ 0.00 $ 1,210,179.00 $ 565,680.72 $ 2.500,000.00 $ 418,139.15 $ 8,159,854.25 50 51 Total Operating Balance (7) (1) 017100,gs funds that are held by the Clerk- Treasurers Office (2) Represents funds That are held in Accounts controlled bythe Carmel (3) Represents remaining funds from the $8,000,000 bank loan closed in (4) Represents rsmaning funds from the $12,500.000 bank loan closed (5) Represents remaining funds from the Certificates of Participation. Series (6) Represents remaining funds from Line of Credit with the indicated Financial (7) Total operating Balance is the sum of the ending Cash and Cash Rights 4205 4C0C of Credit Funds are granted from the 4CDC and CRC Funds 51 52 190.187.05 52 53 54 Redevelopment Commission 2010 and 11e12 by Me he 2011 and held bythe 2010 C (Energy Center) Institution, Line for the Clerk - Treasurer 50 55 54 56 55 57 56 58 57 59 58 60 59 60 -1E- Carmel Redevelc„nt Commission Debt Summary For the Year Ending December 31, 2012 Reference A 3 0 0 E F 5 13 1 1 K Reference Old Town Properties - Chaos - Parcel -931 Issuance Type Revenue Source Original Debt Amount Interest Rate 1/1/12 Outstanding Par Amount 2012 Principal Due (1) 2012 Interest Due (1) Total Debt Service First Installment (2) Second Installment (2) Dean & Dottie Harrill 85469( 14 1 Tax Increment Revenue Bonds, Series 2004 A (111inois Street) Bond 786 $9,500,000 6.650% $7,670,000 2410,000 $503,405 $913,405 $455,023 $458,378 1 2 C0IT Revenue Refunding Bonds, Series 2006 Bond TIF 5,580,000 5.250 - 5.270% 5,580,000 695,000 281,996 966,996 485,341 481,654 2 3 Tex Increment Revenue Bonds of 2008 (City Center) Bond TIF 14,000,000 5.020 - 7.900% 12,935,000 395,000 930,401 1,333,401 667,053 666,349 3 4 Lease Rental Revenue Bonds, Series 2005(942 Bonds) Lease 119 79,998,227 4.000 - 5.000% 75,131,081 1,294,005 3,910,996 5,195,000 2,600,000 2,500,000 4 Sub Totals 5109,078,207 1501,416,081 2,774,005 55,634,797 58,408,802 54,207,421 14,206,381 Sub Totals 52,515,074 52,158,453 186,979 5153,751 $240,730 520,061 Issuance Type Revenue Source Original Debt Amount Interest Rate 1/1/2012 Outstanding Par Amount 2012 Principal Due (1) 2012 Interest Due (1) Total Debt Service monthly Payment Reference 5 Old Town Properties - Chaos - Parcel -931 Contract TIF 5341,174 6.000% 5322,601 59,560 519,670 529,230 $2,436 5 3802,301 Dean & Dottie Harrill 85469( 14 Contact 11F 874,000 8.000% 546,543 73,072 46,928 120,000 10,000 6 7 Bobby John, LC Contract -n6 1,300,000 6.770% 1,239,302 4,348 87,152 91,500 7,625 7 Sub Totals 52,515,074 52,158,453 186,979 5153,751 $240,730 520,061 Sub Totals 556,715,000 556,715,000 50 14,238,090 $94.762 Installment Purchase Contract Type Revenue Source Total Available Contract Interest Rate 1/1/2012 2012 Principal Due (1) 2012 Interest Due (1) Fees Total Debt Service Total Available Remaining Detail (Page) Reference 11 Revenue Original TIF Outstanding 2012 2012 5315,031 Total 225,000 3802,301 Certificate of Participation (COP) Type Source Debt Amount Interest Rate Amount Principal Due (1) Interest Due (11 Fees (3) Debt Service Reference 8 Certificate of Participation, Series 2010 A COP TIF 137.905,000 7.750 - 8.000% 537,905,000 50 $2,979,900 531,557 53,011,487 8 9 Certificate of Participation, Series 2010 6 COP TIF 2,510,000 9.250% 2,510,000 0 232,175 31,587 263,762 9 10 Certificate of Participation, Series 2010 C (Energy Center) 10P TIP 16,300,000 5.750 - 6.500% 16,300,000 0 1.025,975 31,567 1,057,562 10 Sub Totals 556,715,000 556,715,000 50 14,238,090 $94.762 Sub Totals Grand Total 500 ,500.000 579,770,745 52,017,623 52 586,791 5117,770 54,722,173 5447,840 5243,808,401 5239,960,279 54,078,607 512,613,379 5212,532 517,709,518 5447,840 (1) Total debt servoce 48,440 per 0mo,142140 scteduies of ,8,■,ra semi eon, lease payment fortheLerne Rental P8010,0 44804. Seri e 2005 (PAC Bends) Is eque, co 00m0! de, ser,e plus $5.000 for adrr.,traVve or, trustee fees 2,1,20 402 (3) Represent Adrnin,rative fees polo, 040t con0a. (0) rentracts cre controllec PEI to provide deveoprerl and construct.: for a portion cf the reglc,ai per; onr,,, nts <earn (5) Controc. ore used for the PedcorDevelcpar ll4d 8eThrInC,9 Ord !,j%,0084 finon, partior, Pha5e Developmept. (4) C.,,,,cms ore pa, our of desigooted oreas. In the extent the, wet. he a shorlfoll ova, Hie rdstolnienr gni/hoer, tire voyrnerr, W., be from then. Incremen. from other ore. and 440, ovalloble fund, (7)06,9u2i454 ore paod out of designotetl arm. InthecAtent therewould n ,ortfolf to make NIP im7Wimenrproorents, 548 8868880 weuld be deferred ond pal.. ill veor, 203054 2032 Installment Purchase Contract Type Revenue Source Total Available Contract Interest Rate 1/1/2012 Outstanding Par Amount 2012 Principal Due (1) 2012 Interest Due (1) Fees Total Debt Service Total Available Remaining Detail (Page) Reference 11 8-31-2009 100 Clancy Theater Equipment Sound Equipment, and SECOA Seating (Mercantile Bank) IFIC TIF 510,000,000 4.750 - 6.000% 59,047.952 5315,031 1462,221 225,000 3802,301 59,806 4A 11 12 1-29-2010100 MI) IPC TIF 10,000,000 5.340 - 6.00014 10,000,000 235,261 483,464 25,000 748,725 402,456 46 12 13 0-0-2309100 Contracts [Regions Bank) IPC TIF 17,500,000 4.580 - 6.000% 17,090,910 567,652 785,992 23,929 1.377,572 9,223 4C 13 14 0-22-2005100 Garage P47 Contra= (Regions Bank) IPC TIF 7,500,000 4.960 - 6.000% 7,331,883 329,841 269,543 23,929 623,317 0 4C 15 7-26-2010100 CTDC Contracts (Regions Bank( IPC TIF 10,000,000 5.240 - 6.000% 10,000,000 531,770 143,903 13,662 639,341 26,356 4D 15 16 9-10-2010160 (United Fidelity Bank) (3) IPC TIF 2,500,000 5.250 - 6.0001) 2,500,000 38,012 119,845 6,250 164,107 0 9/04) 16 17 Primary Village Installment Contract (Harris Bank) (6) 170 TIF 17,500,000 3.000% 17,500,000 316,809 0 316,809 0 13/9151 17 19 Secondary Village Financial Contract 1 - CCC LLC (7) 190 TIF 4,500,000 3.500% 4,500,000 1 0 0 0 0 Ifilk (5) 18 19 Secondary Village Financial Contract 2 - 100 00 (7) IPC TIF 1,000,000 3300% 1,000,000 0 0 0 0 IVA (5) 19 Sub Totals Grand Total 500 ,500.000 579,770,745 52,017,623 52 586,791 5117,770 54,722,173 5447,840 5243,808,401 5239,960,279 54,078,607 512,613,379 5212,532 517,709,518 5447,840 (1) Total debt servoce 48,440 per 0mo,142140 scteduies of ,8,■,ra semi eon, lease payment fortheLerne Rental P8010,0 44804. Seri e 2005 (PAC Bends) Is eque, co 00m0! de, ser,e plus $5.000 for adrr.,traVve or, trustee fees 2,1,20 402 (3) Represent Adrnin,rative fees polo, 040t con0a. (0) rentracts cre controllec PEI to provide deveoprerl and construct.: for a portion cf the reglc,ai per; onr,,, nts <earn (5) Controc. ore used for the PedcorDevelcpar ll4d 8eThrInC,9 Ord !,j%,0084 finon, partior, Pha5e Developmept. (4) C.,,,,cms ore pa, our of desigooted oreas. In the extent the, wet. he a shorlfoll ova, Hie rdstolnienr gni/hoer, tire voyrnerr, W., be from then. Incremen. from other ore. and 440, ovalloble fund, (7)06,9u2i454 ore paod out of designotetl arm. InthecAtent therewould n ,ortfolf to make NIP im7Wimenrproorents, 548 8868880 weuld be deferred ond pal.. ill veor, 203054 2032 Carmel Redevek, .nt Commission Debt Summary - Additional Information For the Year Ending December 31, 2012 Reference A 8 C D E F Reference Bond Additional Information Issuance Year Issued 1st Call Final Maturity Payment Dates Purpose of Issuance 1 Tax Increment Revenue Bonds, Series 2004 A (Illinois Street) 2004 7/19/2014 7/15/2024 7/15/11, 1/15/12 To finance road and intersection improvements 1 2 MIT Revenue Refunding Bonds. Series 2006 2006 12/15 /2012 2/15/20156 /15/11,12/15/11 To refund COIT Revenue Bonds of 1998 , which were originally issued for the acquisition and redevelopment of property n the City Center Redevelopment Area 2 3 Tax Increment Revenue Bonds 002008 (City Center) 2003 7/ 15/2012 1/15/20291 /15/11,7/10/11 To refund 2003, 2004, 2005, and 2007 Notes that were issued to fund property acquisition and redevelopment projects located in or serving or benefiting the City Center Redevelopment Area or the 126th Street Corridor EDA 3 45017 Lease Rental Revenue Bonds of 2005 (Performing Arts Center) 2005 2/1/2011 2/1/20337/11 /11,1/11/12 To finance the design and construction of new performing arts center complex 4 Land Contract Additional Information Issuance Year Issued 1st Call Final Maturity Payment Dates Purpose of Issuance 501d Town Properties - Chaos - Parcel -931 2006 N/A 11/1/2016 First of every month Acquisition of Parcel 931 5 6 Dean & Dottie Harrill Parcel 14 2010 N/A 8/1/2015 First of every month Acquisition of Parcel 14 7 Bobby John LLC 2011 N/A 8/2/2013 First of every month Acquisition of Property 7 Certificate of Participation - Additional Information Issuance Year Issued 1st Call Final Maturity Payment Dates Purpose of Issuance 8 Certificate of Participation, Series 2010 A 2010 1/ 15/19301/15/20357 /15/11,1/15/12 To Provide for the development and construction of a portion of the regional performing arts center 8 9 Certificate of Participation, Series 2010 6 2010 N/A 1/13/20357/15/11,1 /15/12 To Provide for the development and construction of a portion of the regional performing arts center 9 10 Certificate of Participation, Series 20105 /Energy Center) 2010 7/15/2022 7/15/20057/15/11,1 /15/12 To Provide for the development and construction of portion of the regional performing arts center 10 Installment Purchase Contract - Additional information Issuance Year Issued let Call Final Maturity Payment Dates Purpose of Issuance 11 1- 31- 20091C0 Clancy Theater Equipment, Sound Equipment, and 51100 Seating (Mercantile Bank) 2009 N/A 7/1/ 203110/1/11,11/1 2/1/11,3/1/11,4 /1/11,5/1/11, 6 /1 /11, 7/1/11, 8 /1 /11, 9/1/11, /11,12 /1/11,1/1/12 To provide Theater Equipment, Sound Equipment, and SECOA Seating I1 12 1-29-2010150 (National Bank of Indianapolis) 2010 N/0 7/1/20304/1/11,7 /1 /11,10 /1/11,1/1/12 To Provide for the development and construction of portion of the regional performing arts center 12 131- 1- 20091CC Contracts /Regions Bank) 2009 N/A 1 /1/ 20294 /1/11,7/1/11,10 /1/11,1/1/12 To Provide for the development and construction of a portion of the regional performing arts center 13 14 5- 22- 20091CC Garage P47 Contracts (Regions Bank) 2009 N/A 1/1/2029 4/1/11, 7/1/11, 1/1/12 To Provide for the development and construction of a portion of the regional performing arts center 14 15 7 -25 -2010 ICO CT DC Contracts (Regions Bank) 2010 N/A 7/1/2030 4/1/11, 7/1/11, 10/1/11,1/1/12 To Provide for the development and construction of a portion of the regional performing arts center 15 16 6-10 -2010 IC0 O./tilted Fidelity Bank) 2010 N/A 1/1/2029 4/1/11, 7/1/11, 10/1/11,1/1/12 To Provide for the development and construction of a portion of the regional performing arts center 16 17 Primary Village Installment Contract (Harris Sank)[ 1] 2011 N/A 7/15/20331/15 and 7/15 To Provide for the development and construction of a portion of Pedcor 17 18 Secondary Village Financial Contract 1- CCC LLC [2] 2011 N/A 7/15/2034 No Payments in 2012 To Provide for the development and construction of a portion of Pedcor 18 19 Secondary Village Financial Contract 2 • ICC LLC [2] 2011 N/6 7/15/2034 No Payments in 2012 To Provide for the development and construction of a portion of Pedcor 19 Carmel Redeye, _nt Commission Developer Bonds (Informational Purposes Only) As of April 30, 2012 Ref■ e Ice A B C 11 E 1' G Refermee Original Issuance Outstanding June 2011 December 2011 1 Issuance (1) TIF Area (2) Amount Balance Maturity Collections (2) Collections (2) 1 2 Taxable Increment Revenue Bonds of 1998 (Merchants Square Project) Merchants Square 52,655,000 51,640,000 2018 5281,593 5219,155 2 3 Taxable Economic Development Revenue Bonds, Series 2002 (Parkwood East Project) Parkwood East 3,560,000 2,955,000 2022 487,980 487,980 3 4 Taxable Economic Development Revenue Bonds, Series 2006 (Parkwood West Project; Parkwood Crossing 4,800,000 3,285,000 2026 660,752 316,518 4 5 Taxable Economic Development Revenue Bonds, Series 20068 (Buckingham - Gramercy Project) (3; Gramercy 20,000,000 148,107 2027 4 4 5 6 Taxable Economic Development Revenue Bonds of 2011 Meridian and Main 751,500 751,500 2031 0 0 6 7 Senior Economic Development Revenue Bonds, Series 2011A Arts District Lofts & Shoppes 9,630,000 9,630,000 2031 10,925 10,925 7 R Subordinate Economic Development Revenue Bonds, Series 20116 (4; Arts District Lofts & Shoppes 3,370,000 2,370,000 2035 0 0 S 9 Total 544,766,500 520,779,607 $1,441,253 $1,034,582 9 10 10 11 (7) The CPC Payable potion of the debt service is limited up to the total incremental revenues of the designated TlF area. Any debt service in excess of the increment revenues Iliable to the developer. The total outstanding principal amounts seen above do not reflect a 11 12 directobligation to the Carmel Redevelopment Commission. 12 13 13 14 (2) All collections are allocated to the developer payments with the exception of the Taxable Economic Development Revenue Bonds of 2011, only50% of the total of the increment generated is pledged towards payment of the bonds. 14 19 15 16 (3) The Bonds were issued as draw bonds. The amount shown represents the amount of principal drown down and outstanding per the Trustee. 16 17 17 18 (4) The Bonds were issued as drow bonds. The amount shown represents the amount of principal drawn down and outstanding per the offc/al draws scheduled in the issuance Offering Documents. 18 19 19 Carmel Redeveb, ,nt Commission 4CDC Grant Obligations As of April 30, 2012 Reference A 6 c I 3 1 E F I 6 H 1 K 1 Reference 1 2 3 Current Grants /Obligations 2 Closing Original Current Amount Use of Primary 3 4 Bank Typ e Interest Rate Date Maturity Debt Amount Balance Available for Use Proceeds Repayment Option 4 Star Financial Bank LOC LIBOR plus 3.50% Floating 11/8/2011 11/7/2012 15,000,000 $3,789,821 $1,210179 ' . {,y Sp � °?p ?i TIF 5 6 7 5 Fowler State Bank LOC 4.50% Floating 11/8/2011 11/7/2012 2,500,000 0 2,500 000 'T 'may. TIF 6 Marne Bank 100 4.50% Floating 11/30/2011 11/29/2012 2,500,000 1,934,319 565,631 Ft.,:,+1 ,.4 `ti3•^,0"'u``f'H `. 'e iy,yi' Aj °: TIF 7 8 Mercantile IMO Harris Bank LOC LOC 4.5% Floating LIBOR plus 2.75% Floating 1/13/2012 2/17/2012 1/17/2013 2/16/2013 2,500,900 2,500,900 2.500,000 2,081,861 0 418,139 hd - „` *", }4iwf' Ck "``$` i ww � «na&s. $A �s3 ' :'im" x"? TIF TIF 3 9 9 10 IMO Harris Bank Bank Loan 3.97% Fixed Rate 9/30/2011 9/30/2016 12,500,000 12,184,562 515,438 Pay Construction Costs on Office Building One TIF 10 11 Lake City Bank Bank Loan 5.00% Floating Rate 12/28/2010 12/28/2012 8,000,000 6,328,135 1, 671,865 . Parcei 65 - Veterans Way Street Extension and Hot and Cold Water line extension and retrofit of City Building TIF 11 12 Total 00 000 5/ X18.69@ 12 13 13 14 14 15 15 16 10 17 17 18 18 19 19 20 2 20 21 21 22 22 CarmelRedevelc,,. .gent Commission Installment Purchase Contracts - Summary As of April 30, 2012 Reference A 8 ICI D 1 E I F I G I H K Reference 2 3 4 5 7 s 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Description Amount Original Contract Available $57,500,000 Plus: Renewed NBI Contracts 860,000 Less: Current Contract Obligations 56,305,538 Less: Installment Contracts Due 127,639 Less: Attorney Fees 357,701 Less: Bank Fees and Wire Fees 112,896 Less: Closing Costs 219,500 Less: Design Fees 800,000 Less: Retention Hold (Mercantile) 13,303 Add: Interest 24,417 Remaining Available for Contracts $447,840 -4- 2 3 4 5 6 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Carmel Redevelo, ..,ent Commission Installment Purchase Contracts - Summary As of April 30, 2012 Reference .1 A I B I C I D I E Reference 1 1 2 Contract Name 8/31/2009 ICO Clancy Theater Equipment, Sound Equipment, and SECOA Seating 2 3 3 4 4 5 IPC # Vendor Bank Equipment/Contract Contracts 5 6 Mercantile Mercantile Capitalized Payment $ 127,639.00 6 7 1 JR Clancy Mercantile Theater Equipment $ 6,990,040 7 8 2 SECOA Mercantile Theater Seating $ 776,883 8 9 3 All Pro Sound Mercantile Sound Equipment $ 1,530,970 9 10 4 Smock Fansler Mercantile Hanover Square Improvements $ 331,500 10 11 Total $ 9,629,393 11 12 Original Contact Amount $10,000,000 Less: Current Obligations 9,629,393 Less: Closing Costs 219,500 Less: Installment Obligations Due 127,639 Less: Retention Held 13,303 Less: Wire Fees 360 Remaining Available for Contracts $9 806 12 13 13 14 14 15 15 16 16 17 17 18 18 19 19 -4A- Carmel Redevek,,...ent Commission Installment Purchase Contracts - Summary As of April 30, 2012 Reference A I B C 1 D I E Reference 1 1 2 Contract Name 1/29/2010 ICO 2 3 IPC# Vendor Bank Equipment /Contract Contracts 3 4 1 Bybee Stone NBI Limestone $ 3,215,420 4 5 2 Horning Roofing NBI Red Clay Tile Roofing $ 419,400 5 6 3 Certified Floorcovering NBI Carpet and Tile $ 467,525 6 7 4 Cincinnati Floor Company NBI Wood Flooring for Auditorium, Stage, and Suites $ 694,459 7 8 5 Gibraltar NBI Veteran's Way $ 1,914,078 8 9 6 Signature NBI City Center Dr. /Rangeline Rd. Streetscape $ 1,459,095 9 10 7 Sign -A -Rama NBI WayfindingSignage Improvements $ 72,658 10 11 8 C &T Design NBI Cafe Equipment $ 30,345 11 12 9 Indy Stage and Sales NBI Lighting Equipment $ 43,495 12 13 10 Alexis Manufacturing NBI Seating $ 10,861 13 14 11 PS Furniture NBI Furniture $ 4,690 14 15 12 Smock NBI Motor Court Improvements $ 51,598 15 16 13 C &T Design NBI Kitchen Equipment $ 7,833 16 17 14 Brenner Design NBI FF &E $ 198,156 17 18 15 Antresian NBI Bar Equipment $ 25,000 18 19 16 Series, LLC NBI Custom Chairs $ 22,564 19 20 17 Harmon Signs NBI Parcel 7C Venues Signage $ 177,000 20 21 18 Indy Stage and Sales NBI Studio Theater Lighting $ 25,000 21 22 19 Indy Stage and Sales NBI Tarkington Theater Lighting $ 39,416 22 23 20 Indiana Store Fixture NBI Gift Shop Improvements $ 60,000 23 24 21 Bybee Stone NBI Stone Planters $ 457,000 24 25 N/A Parcel 16 Land Purchase NBI Parcel 16 Land Purchase $ 860,503 25 26 Total $ 10,256,095 26 Original Contact Amount $10,000,000 Plus Renewed Contract Amounts 860,000 Less: Current Obligations 10,256,095 Less Bank Fees 37,500 Less: WSH Legal Fees 157,400 Less: Hall Render Legal Fees 30,930 Less: Wire Fees 36 Add: Interest Earned * 24,417 Remaining Available for Contracts $402 456 27 27 28 28 29 29 30 30 31 31 32 32 33 33 34 34 35 35 *Note - Earned interest is due to funds deposited in a Capital Money Market Savings Account. 36 36 -4B- Carmel Redevelt.,..,ient Commission Installment Purchase Contracts - Summary As of April 30, 2012 Reference A 1 B ] C I D I E Reference 1 1 2 Contract Name 1/1/2009 ICO Contracts 2 3 3 4 IPC # Vendor Bank Equipment /Contract Contracts 4 5 Various Regions P47 Garage $ 8,825,000 5 6 1 Ermco Regions Lighting Fixtures and Generator $ 3,034,000 6 7 2 Waltek Regions Acoustical Canopy $ 1,111,932 7 8 3 Indy Stage and Sales Regions Production Lighting $ 765,374 8 9 4 Poynter Regions Air Handlers, Fans, VAV Boxes $ 1,005,000 9 10 5 Ebenisterie Beaubois Regions Mill Work $ 3,165,282 10 11 11 12 6 WR Dunkin Regions Elevators, Fire Protection, and Pumps $ 2,208,370 12 13 6 Simplex Grinnell Regions Elevators, Fire Protection, and Pumps $ 629,930 13 14 6 General Piping Regions Elevators, Fire Protection, and Pumps $ 614,483 14 15 Total $ 3,452,782 15 16 7 Spohn Associates Regions Interior Ornamental $ 2,100,157 16 17 7 Leach and Russell Regions Interior Ornamental $ 573,000 17 18 Total $ 2,673,157 18 19 8 Brad Howe Regions Sculpture Improvements $ 80,000.00 19 20 9 Incord Regions Pit Safety Equipment $ 6,643.00 20 21 10 Esco Communications Regions Microphone Equipment $ 51,607 21 22 11 Morphey Construction Regions Signage Improvements $ 20,000 22 23 Total $ 24,190,777 23 24 24 25 Original Contact Amount $25,000,000 25 26 Less: Current Obligations 24,190,777 26 27 Less: Design Fees 800,000 27 28 Remaining Available for Contracts 59.223 28 29 29 30 Note - The above information is far the combined Regions $17,500,000 and $7,500,000 obligations 30 -4C- N o a m D w ti 8 w 2 w 2 o w a o g. a w o w 2 N a w w o o p w ti o w o p w N o e w, w a w,, F. Total $ 9,729,273 Original Contact Amount $10,O00,000 Less: Current Obligations 0,729,273 Less: Bank Fees 75,000 Less WSH Legal Fees 65,821 Less: Other Legal Fees 103.550 Remaining Available for Contracts $26,356 A 1 E Contract Name 17-26-2010 CTDC Contracts Eco Communications Wenger .Gibraltar Office Works, LLC m Indy Stage and Sales Argo Chem East Signature Construction Indy Stage and Sales Meridian Music Smock f ansler RE Construction AED Professionals LaFever Electric Meyer Najem DAM Equipment Gibraltar Construction Dodd Technologies Indianapolis Stage C &T Design Piano Solutions The Sculpture Foundation Sensory Technologies Nelson Alarm EZ Software Solutions Bunting Graphics Van Ausdall & Farrar T Dre tcom Advantage Opltcs (S k Fe ter Signature Gibraltar Signature Smock Signature Signature Van Ausdall & Farrar Telecom Placement Smock 1DH ever z < iv y a 3 = Meyer Najem Meridian Music Gibraltar LaFever n P Z IS mplex _... Antreaslan Chance Bros. Diversified Poynter Ermco Circle GPI Gibraltar Office Works, LLC Regions (last) I Regions (last) Regions (last) Regions (last) Regions (last) Regions (last) ''..Regions (last) Regions (last) Regi Regions (last) Regions (last) Regions (last) Regions (last) Regions (last) Regions (last) Regions (last) Regions (Ost) Regions (last) Regions (last) Regions (last) Regions (last) Regions (last) Regions (last) Regions (last) Regions (last) Regions (last) Regions (last) Regions (last) Regions (last) Regions (last) Regions (last) Regions (last) Regions (fast) Regions (last) Regions (last) Regions (last) Regions (last) Regions (last) Regions (last) Regions (last) Regions (last) Regions (last) Regions (last) Garage West Wall Improvements Furniture for the Cafe Motor Court Exterior Wall Speakers Equipment Tarkington Fixtures De -Icing Equipment Fountain Rough -in Tarkington Stage Equipment Piano Equipment Fountain Rough -in Amphitheater Equipment and Improvements Defibrillator Equipment Amphitheater Equipment and Improvements Amphitheater Equipment and Improvements Lifts, Lighting, and Rigging Equipment Amphitheater Equipment and Improvements Lifts, Lighting, and Rigging Equipment Lifts, Lighting, and Rigging Equipment Concert Hall Catering Equipment ,Musical Equipment Sculptures Monitoring Equipment Camera Equipment Catering Computer System and Software PACSlgnege Box Office Computer Equipment Network Switches Opt cal Electronic Modules Motor Court Improvements Motor Court improvements Motor Court Improvements Motor Court Improvements Decorative Fountains Decorative Fountains Fountains Computers and Servers Security Equipment Fountains 3 3 Box Office, Phone System, and Music Equipment Security Equipment Green Improvements Box Office, Phone System, and Music Equipment Green Improvements Green Improvements PAC Loose Seating PAC Retaining Wall/Ve ult Cladding Cafe Improvements Cafe Improvements Cafe Improvements Cafe Improvements Cafe Improvements Cafe Improvements Cafeimprovements Cafe Improvements Hardscape PAC FF &E Equipment /Contract ti ti a o ti ti 0 o ti ti ti o° o ti N ti N $ N o ti ti $ o ti ti a N. N. V o ti r v ti ti ti titititi o titi titi o, ti o ti N. N e o N. ti N N ti tititititi w ti titi ti ti ti ti a ti ti w o ti ti o ti titi tititi o