Loading...
Financials July thru December 2011December 2011 Carmel Petlevenornent Comm anion Budget Peer Qi ProjeCn004 4■4 n18, 9011 Renee. Weronce 1 Attual Attoal Attoal Attual Actuel AM Actual Aptual et, A4 aeteal 1 2 Mary Feboany 11111.1 Anil 540,234 5161.374 8196.656 56.946 990 51.910,130 5839,OP 5126,112 SO 1 ,,,,,,,, IMINIIIMI 2°.'....°' 7 ME NON OPZIPATMG BALANCE 5099 0,4 11P Pfalln5 918 Paver. 111111.....1111.111111111111111.111111111111111 INERIBMIIMMEMILIMMEMEI 6 0 TIP Innapt, WI elf Envelop., PAymervea IIMIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIUIIIIIIIIIMIIIIIIIIIMII IIIIIMIIIIIRIIIIIIIIIIIIIMIIIIIR .1,554 11aPnen, 0'. 1111,111111111 MIMI , 1.038,4,5 :99, 4,8 4 . E C 13 12 hlersanalle LOC 0 C 0 625870 225,00 0 linaHIIIII1==IIIIIIIIIBIIIIII===IIIIIM 0' 0 13 MarrOnn BOPP 404.793 344,436 396,264 256,336 54.7EP 26.211 272.432 0 0 72.965 0 0 ,, 0,4,,,,,,o,,,, Pentaal 11.11111111111111MOMMEMEUMMEM 565,575 eiana PP A .00,6,9 897,0,5 0 0 0 0 0 0 0 10 Total Poem., MP °MATING 4.04.70P 0,4,0,4 ,,P5,,,5,42 164.45Mal 0 , 8,9,04„9 3 2,3,129 . 17 , 19 EXPENDITURE, NON OPERATING 13 19 2D P404vrenn to LOC Lard Ineeintlne and to5961 MI a5 20 21 . Pnenv Conon 84,41 7 enerfirni ON,ryMel 0 0 5,91 0 0 0 0 0 0 2,624, 0 0 52,831 0 0 35,513 19,471 0 0 5.575,000 0 0 5,575.000 5.3,900 21 22 . Panel 7,444Pna PP 0 7 0 0 0 23 84 25 Oeher Owl...nem and lean. Other cenntaenlon 0 8 , 0 0 39,457 0 81,657 0 0 5,UP 0 5,740 0 0 15,800 5,396 0 0 0 83,989 0 P1,425 100000 350,000 0 0 10,C00 350400 24 25 26 Parn14,411nenn1 Peep penal, ce, ,e„,,, 0 IMO, 0 112.47, 0 0 41490 0 I 80,8 0 10.10P 71,49 2,828 0 la P48,P18 P69,98 32,720 4484000 32,20 3,800 26 27 19,000 19.09 19.000 15,000 1.59,00. 19,000 19.000 19.000 19,000 10,000 19,00D 18,0P4P 8PSIXP9 222,000 223,00 23 =11:1•211=1111•11111111= ear, 5-31 Leman - 144,9 argeenon 2,439 8,4 10.000 2.435 10.009 P.4,6 10000 8 488 90,000 2.498 10000 9.488 1,000 1111111111111111===1811321 19.000 10,900 10000 118,009 =111111=1■31:1 120,00 18,0,000 380,009 ME 32 Pare, 47 Ares Disarla Loan 8..0pp. P4ran 94 WananaPe 49,1,P 111ZIBMIIIMI1=111.11.EZIENIIIIIIIIIIMM1111111 1.037 0 499,8 0 MEM 1.5'9100 SOC,000 0 aannneelen Pniattn PPAC PAC Cornaltare WI: 543,030 932,789 lal,047 852,301 45,7 1,479,364 l20353 764,894 268,538 44,0 MAIO 40580 174.,4,99 4 1.119/1111/1 MN ' 2,100, 4,,t MP Illn 2.401,000 318,ODD 8,4000 00000 6 175000 598000 31 34 ...Moe 0 0 0 0 0 482,7 1,124.121 0 0 0 0 55 Noe,. Dker5erala0 2005 PACleana Gla8,02, 0 488,7 (3 9 4,0985W Zane,. 4920,090 3,395.072 4,980,000 .11.11.131 3,355.072 9 44,000 36 0 270.69a 2 0 632,5,2 Q 0 0 395,58 1.11111111111111110=111111111111101■1■91=111111111= NM ii=1:1111111111111111MININeelea ■=11111■111=111====11/1115321 4 ¢ i 2 . eo08,49,PP^rno PP,44,00r, l'IP Peennentenntoren . 5P5 IIIIII==I=111=1 0 0 Al TOTAL P.PPPellant188, NON OPEPAIING OPERAIING Pl1405711ANSPEP11810 TO NONOPEPATING 1.3,2,185 565 . 2.168.904 1.24... a 603,2a 1_88,382 263176 693133 4,1.756 4.432,034 922.256 713,83 733064,, 32,465,587 34469.587 41 42 1147811PLINO LOAN 0 Manna, uui_ 22,314 0 4, ENINNG BAPANCE • PIONOPEPATINB 50 SO 850.214 5181,373 5156.656 56,946,990 S73 224 $0 PP a47,70, 44 45 V) J) BJOBBIIIIIIIIIIT=AIIE11111E1111 IBIIIIIIUIIIILItI1=I1A■JII3I1=III1■IVII1111I371I11I1=I3II/1=M11111I111111=II11I11111S1111111=I11IIN1 I IM ■1111111111 1O1111111P 1111111 = IIIIIIIIIIIIIIMIINIIIIIMIIIIMIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIMI 1111111111111111111111111 IIIIIIIIIIII=IIIIIIIIIIIII===I=IIIIIIIII=IIIIIIIIIIII ■=111=EIR Ell C 0 ' „ 57 Ener,aa 9 ewer Payment; NE C El D 0 •IIIIEIIIIIM 9 0 8 52 LAP Me En, 0 535.000 0 D 0 IIIIIIIIIIIIIIIIIIII=1=111===IIIIIIIIIIIIIIIIIIII 9 IIIMMarall111111 0 .1111111111111/ 1,6,943 .11111110 111111111111111111= =NM 0 1299,548 =11111111=11■13 52 Wella Pane (fovea' 9e0t4P) Other Pecelpte: ,...,..t% lilliNEINEE- 0 0 ::1:1 0 :1■SIMIMINIEININNEEEKEMIIIIIIIIIIIMINERMIIIIIIIMEN 11111111111111111111111111111111.1 4,201 °0 IllE 0 0 ,MIIIIIIIIInaPna '?0,150 11111.1.1113=9== 018000 1.022,000 0 0 075,000 1092.0 53 55 Panel.- Oltrown Show, II ,,,,,, 28 - Lore Pokey. Condo: ,„,„e„eneeen 1:l=:i..................................MMNEIE 111=1111111111===11111011111111111111111111111111111111=1111111113 5 , 0 3 P 2 ,, i 0 3 0 0 0 0 0 I =1:11111111==1=1111.11=11123111=1111113 0 3.000.080 0 3.9000D0 58 88 Pann 74 ne,f repnatelettauneleent Panel 702 anyway nren4P a 0 2 0 0 0 , 28 4.000 0 4 DOC 64 .P448404.45 PPP40.4 19.779 12 P91 0 47..7 1,598 S05,005 58,485 ?sc .1.?1,?Y n,.§J. '!,2, 98,9194 24.068 484,886 228,91/ 65 Total Repellent - OPEOPCNNC .777 21,837 585,847 P08,OPP 888.006 / 1,44P 1•10,914 5838 / 4,5•45, 1,229 566,57 66 6, PAPPNOITUPP4 ,PPOP PAYING 11111111111111111111111111111111111011111 11111111=31=11111111111=3 ZS a.n 8 14,0,P 1•11111111=111111111111==11111111111111=3 !RIIUIIIIIIINIBEIIIIIIIIIIIIIIIIIIIIIIIIIMIIIIIIIIIIIIINMIIIIIIIIIIIIIIIIIIIIIIIIIINIIONIIIIIIIIIIIINIIIIMI IIIIIIIEMIIIIIIIIIIIIM=§11 1P,P9P 20,507 70,644 809400 n000 0 1.11111111111111111111111111111111110IMMEI 11111111=111111=11211:121=1=1 =1 D mom ■111■11111 ■321 74,820 111111111 HME1=311=3 0 111=111111■3■3■:1■=31■=1111111111111111111111111111=11111=O 30.630 1,000 40APP 0 ,,,,,, :1,, =111=1=11111=11111111111111111111111==== 0 MEI Pmnol POSInenn MIMI 0,000:0,, Parelne mann. shordall P.44aPenk,994emahna0eP4 30,521 0 36729 86.418 IA60 MEI 113 14,70 42,28 9,250 49.12P 20.124 0 0 18,14, a,,,, 200000 rj 27,900 75 75 Ma netlep/88. Devonomara 27,234 19,132 76 , Profeenional Pon Lea 4,578 69 721 24147 107,698 .3,4 10,18 6,21 4.1.15 0 10687P: an,087 MI 500000 290979 ..6,71 ME 78 Arch/CP , 441 7,564 1541.74," ME 30.728. 42309 23,017 ata0 19 312 81,6 9,503 18,548 6,77 23.783 14,3E7 29.548 53.935 16.332 13.511 5418 35,25 13,849 2,000 19 4,585 .747 /146 689,91, ,R.1c, =COP 500,000 400000 150,00D 141438 642. 4W.000 499eurarno Pen 37,04 98,418 2,9545 N11:4,4 neon TOTAL 64PENDITUPE5 a OPERATING 5,852 4.545 5,182 8,869 15 460 1,401 .293 2,130 32,161 15,950 yeg99 51,04P 178.995 sscoon 194043 • 469.314 337,358 0 275.619 i,60,N 193.138 0,5 %,.0 470,044 0 350,665 441,942 0 349833 401,353 D ,,, eeD 11'6,1 127,963 PRO 212 9149,5 3.965,00D 6,229,854 38 . TOTAL OPERATING FUNDS TRANSFERRED TO NON 0458A7IN pal PlnlaaD LOAN 85 EN0948 BALANCE 9PPRATING 1,193,743 570,323 P43,86 473,096 117,779 1. 611 72 567 87 960 405 PI 26 MOM, BALANCE NON OPERATING ANDOPENAIING 82,188,7 4 . $ 54, 7 554 , 5 45,546,950 51,930,543 5452,157 51,93,173 579,2,24 5409,2. 55,74797n Carmel Redeye' nit Commission Month and Year to Do, ,enue Budget Analysis For the Month Ending December 31, 2911 Reference A 1 B C U 1 E 1 F ] 9 I H 1 . 1 1 K Reference 1 Current Month Comments Current Year Budget 1 2 2 3 Budget Actual 8 Variance Proposed Adjustments Revised YTD $ Remaining % YTO 3 Recognized 4 RECEIPTS • NON OPERATING: 4 5 TIE Revenue 59,898,557 9,898,557 50 518,054,793 518,054,793 521,026,111 17,97 t,i4'18i 116.46% 5 6 Developer payments 11,41,'+o12I( 0 1,029,694 Payment not made until January 0 0 (171 f(3(i 0 N/A 6 Marine Bank LOC 1444,505 1,033,495 (111,01115 Difference is due to change in estimate of needs. 0 0 1,033,495 0 0.00% 7 Mercantile Line of Credit 0 0 0 0 0 848,850 1,063,000 100.00% 7 8 Lake City 0000 0 0 0 5,808,327 5,808,327 842,759 4,965,569 14.51% 8 9 Wells Fargo 0 0 0 0 0 3,310,522 9 10 Key /Harris Rank 0 0 0 0 0 0 1,838,163 0 0,00% 10 11 00 12 TOTAL REVENUES- NON OPERATING 10,013,360 10,932,052 918,684 23,863,120 23,863,120 27,432,241 (2,101,].:XlkI 114.96% 12 13 13 14 14 15 15 16 16 17 RECEIPTS - OPERATING 17 18 Marine Bank LOC 57,164 163,174 111,010 Difference is due to change in estimate or needs. 0 0 163,174 0 0.00% 18 19 Sales of Assets 0 19 20 Parcel 36- Old Town Shops 11 0 0 0 835,000 835,000 326,744 508,256 39,13% 20 21 Parcel 21 - Lurie Building Condos 0 0 0 675,000 675,000 435,201 239,799 64.47% 21 22 Parcel 92- Apostolic Church 0 0 0 1,022,000 1,022,000 798,150 223,850 78.10% 22 23 Lake City Rank 0 0 0 1,299,948 1,299,948 1,299,949 0 100.00% 23 24 Wells F 0 0 0 0 0 85,888 0 100.00% 24 25 Energy consumption payments 0 0 0 240,150 240,150 149,287 90,863 62,16% 25 26 Parcel 70 roof repair reimbursement 0 0 0 3,000,000 3,000,000 0 3,000,000 N/A 26 27 Parcel 7c -2 revenue 0 0 0 0 0 0 0 N/A 27 28 Interest 4 2 525 4,000 4,000 30 3,970 0.74% 28 29 Miscellaneous revenue 7,820 7,820 0 24,063 264,954 289,017 721,401 (4(0,311,15 250.99% 29 30 30 31 TOTAL REVENUES - OPERATING 59,988 170,996 111,008 67,190,161 $7,365,115 $3,983,823 53,381,292 54,09% 81 32 32 33 TOTAL REVENUES- COMBINED 510,073,356 511,103,048 51,029,692 530,963,281 531,228,235 531,416,064 (0112,1(2'3M 33 34 34 35 35 36 36 37 37 Carmel Redeye' nt Commission Month and Year 90 0066 iditure Budget Analysis For the Month Ending December 31, 2011 Reference A f 8.---ThF I171 6 r----F 0 H J 5 Referencd Current Month Comments Current Year Budget 2 3 % YTD B Actual Variance Pro 0060d Ad justmonts Revised YTD Remaining Reoopnt;ed PENDITURES: NON OPERATING Land Acquisitions and Leases Energy Center 0 0 95,575,000 $0 55575,000 00 55,575,000 0.00% Parcel 7 50%6160 expenses 128,608 523,891 L/5,233 Difference is 64606 9598,116.73 payment 0.1 Tarkington Shortfall that 6 budgeted for 2012, but w6668134119 paid in 2011 due to time constraint,. 500,000 0 500,000 778,525 j2'),,±,,•;:n,i) 155.71% Parcel 7 streetscaoe 0 0 0 0 0 N/A Other land acquisitions and leases 0 100,000 0 100,000 0 100,000 0.00% 10 Other construction 63,829 63,889 163/ 350,000 0 350,000 211,923 136,607 60,52% 10 11 Parcels 4E11 Interest Fees 0 0 38,720 0 38,720 0 33,720 0.00% 11 12 Parcel 5 City Center 248 273 248 778 0 2,450,000 M 875,000 925,203 (W "'OM 105 74% 17 13 Parcel 9-2$ Party Time 19,000 19,000 0 228,000 0 228 000 228,000 100.0033 13 14 Parcel 9-31 Chaos - land acquisition 2,436 2,436 0 30,000 0 30 000 29,231 769 97.44% 19 15 Parcels 14 Harrill Property Purchase 10E00 10,000 0 118 000 2 000 170 0 120,000 100.00% 15 16 Parcel 47 Arts District Lofts and Shopper 325,040 405,729 :34:17T% Difference is due to check, released that were Previously. held 1521000 329000 1150000 1,905,855 (35,835) 103.02.% 16 17 Parcel 73 Streetscape 0 0 500J!116I 0 500,000 1,037 498963 0.21% 17 18 Construction Projects: RPAC 296031 281081 15.09 Difference is due to 015,090 payment to WIC Dunkin that is actually paid with an Escrow account. 2,151,000 3,194,000 6,175,000 5,892,602 737 39a 95.43% IS 19 PAC Consultant Bills 45,693 4S,698 375,000 140 000 s15 0 502,043 12,957 57.48% 19 20 Debt Service 0 0 0 0 21 55Non,Pac Debt Service 483,773 483,773 3 985,072 0 3,885,072 2,752,992 1,122,080 71.12% 21 22 2005 PAC bease 2460,000 2,460,000 4,920,000 0 4,920, 0 4,920,000 0 100.00% 22 23 Contract Purchase Payments 656 577 636,577 8897,795 ;:,,,V.:4):X7I:1 / 6,807,795 5,592,084 215,711 96.83% 24 TIP Payments/Interest 0 0 0 N/A 24 25 TOTAL EXPENDITURES, NON OPERATING 4,719,020 5,153,352 1046,419:21 32,469,537 0 32,469,587 24,009,396 7,600,191 7E51% MIMI MEI 28 28 25 EXPENDITURES: OPERATING 29 30 Operation, 93,607 78,644 19.963 Difference i, due 60 payments previously made that just needed approval. 800,000 323,536 1,128,536 2,172,515 144. 973 104.35% 30 31 2ee9e% 075 CRC Weodewire, 8,1 0 32,195 375,000 0 375,000 5,421 29,579 92.11% 31 32 Parcel 10064100 15,141 15.240 0 90.000 0 90.000 30,141 59,659 33.4960 32 33 Marketing Communications 39,876 30.575 0 500,000 (.7%,.1411 245,859 246,051 2,105 9887% 83 34 Marketing/Bus. Development 20,795 16,143 5,150 Difference is due 60 6,663 payment 001306 DeRocker 01 610 request. 200,005 200,000 173,983 25,017 000960 34 35 Professional Fees 35 36 Legal 90,781 101,528 116 11321 Difference is due to checks released that were previously held. 600,000 266,271 866,271 788.997 77,274 91E3% 36 37 305h/66E rearm 134,195 134,695 0 005,005 142,435 642,930 636.020 6,418 99.00% 37 38 Accounting Fees 36,087 30,640 (61,55M Difference is due to checks released that were previously held 409,000 0 400,000 370,109 29,891 92,03% 38 35 Administrative 003 51606 71,965 71,640 0 150,000 0 150,000 208,093 M,3911 138,7359 09 AD Miscellaneous 50,830 00,053 (InV 550,000 (431111611) 133,850 176,099 (32,2411) .Z.) 131,56%7 40 41 TOTAL EXPENDITURES - OPERATING 583,532 580,211 3,320 3,965,000 264,154 4,229,954 4,147,429 82,525 98.05% 41 Ell 42 TOTAL EXPENDITURES, COMBINED 0E302,852 95,759E63 174171,71.11 936 A84,587 936 ,610E41 329 ,01E825 97 ,683,716 79.07% 93 44 44 November 2011 C51,51 R55,51515555,5t 55,5 rr.5i05 5500 VW 20' 1[515 750)4000115 ol-N 2511 IIIIIIIIM MEI !ill IMMMII 10,000 1111111111=1.111111111111111111111=1 1:1131111111111111111111111111111111111.1111111= 111111111=1111MEMI 444400 EMI 55..9 M10.550 52.029 MI 402004 1 0 1111=1111111111.1111 0 , 0 057.070 0704.004 0 111111111111=11 5,550,005 0 5(6.0 /1 2,055,n0 , 555,60 Illi . i ,112.755 , 5,532.G55 922,, 0 350,84 0 , 0 0 , IIIIMMINIEMESI■i=1 5,5.5,50 1 0450550 , 010000 : 111011/111,111111111111, iftWErCISIERIU '111111111111r mill,=„1 5557 755 00 5545,444 522401 ■:61 MIIIIIIIIIIIMIIIIIIIIIIIIIII MD 1111E■nIMIIIMICI ■El 11=311 MOM MMME11■1111311111111111111n==■11111111111111 B■111111111111.11M O 0 , 0 0 0 , 0 1111111111111111111541111111110* 1 777 00 MIMI ri9MijillIllill.11nl■IEIEEI INININNIMIMMIIIIIIM= El== ....... =111111IMM9 mnmim _=__--5-_ MEMMEMEMOMMEWEE=11 A al ON OKRATING DALANCE 56,906,0 115 ==11==11.1=1 11,127.551 m5551515 =MENEM Develop, MI TiF Recalptz, Net of Developer Parymon55 === ■MITIZIIIMMI3■3■271■MI Adual September 5334356 5226,113 115,55,55 5551, F55/.01EnortyCunter, Total Revo5555 ...NON OPERATING EXPENDITURES- NON OPERATING 55payrner, to LOL 559,575 4,120 Parr., Olor 115.51,555o555: Par. 5treetcapo Priler land as 515.5,55: and 15.555 .55, 55,5,55,05 1.025.57, L7,3 "P 497.375 55'.5.555 9,555 95,555 555,870 11111111111111111.1111 1111111111111111111 1111111111111111.1==1=EIM 51,575 ! 113:2111111111 52,55 =1=1= 5,7104 J5;,0,0 111111111311111111111111=1-, 5 865 33.465 20,396 50,102 55,a19.51 C5555, land a5qui,-1155 Par5511.1 5155,115re555, Purdy. 4.44E 10,000 59,000 .9,00 15.005 55,55 55 A55 1.-trld Loh: 55 Shopper, 1,55,75 Stew:5555 50.5 555555551.55, 7ebt 55,155 5015 PAC 1.55,..o 5.5,55, 55,55,5 5a15,5,5 5545555 5.. 555,5-550, 70470.414l47447 TOTAL ENP5NERTVRE5 - NON OPERATING OPEPAYING NNW, TRANSFERRED TO NON OPFRATING INURED. LOAN ENDING ...NC, NON OPERATIN4 Mho. Rote 551. Par55115 MITown Ow 5 Parc5121 I.w5m 55'1455 , Condo: P..c51.92 Ape5to 11E5,mb 5,5, .55555,55,5 roPI 0.45,5 .55,555,5 515555555.: 555.55.55 larl Revenue, OPERATING MEM/MIRES ,OPERATING 0555.55, 555 555,55 0555555.55 L55555 OT3.05C, ,55551,5,5,551 55,55,10 5555.5 Pao, 5755555 55.555155 .55,55+5,5a.55 55571,511555055.5.515.5441441- 5,555.515e. ArevEnn,n555.5 1,133,217 I 50355 135 565 : 85,765 55.555 33.05 3,373 21.050 21.505 1.000 2000 '5505 115.483 90,555 30,521 55,755 45,555 95.127 274051 15.102 5.450 ! 20 123 101055 W. 105,015 L 55.721 51,775 31.503 28.783 SA,585 :555. Acr55.11:5,55"5tl5555, 511555555,5555 TOTAL EXP55.55,1355 -OPERATING IOU OPERATING FUNDS TRANSFEVNEOTONON OP,ATINC TERF ND LOAN 55 EWING BALANC5 05,55511551 5,1 .59,045 56, ENDING DAMN. NON °MATING AND OPERATING 5,155,745 52.15,4,13 570.3 5570.573 755.853 473,096 $795 077 5094.470 1155775 5315,935 470.0151 ,555,55,1 0 5,387 59391 22,3.1„ I 550.665 52,961 56,946,490 51.550.551 505,157 55,55.5555 --- - =IM= El ■IIMI■ ..., mimmi IEWIIMBENI■:1 ■IIMISMII■CI ■Elll ■romm,mnzzaii■:1 .111111111EIMB: liftlignMIPI7S ME 300,000 la=j11000.050 IMMI IMBEIMIMI=31 MMIESIMIHNIN 2470,400 ME= ■IMMIIMEIRM !ME =MB 5,15,,n.13 1 Eill=M111MIEBRII 559.000 1.550700 105000 111111 500.0000 /MEMIEMEI MIELECII=ZIEEEIZI =BEM 5.5751000 IMMEI ■111111111=ZEIM Eim■ ■im i■a :111 MilEINMEEINII■1 5,55707 1131 2000000 111 =112E111 NM= 32.455,58n7 =1111 = ■Il ■•■=1 = = NT, 1111111171111.11111 111 I ..,„,_,.... Elm ,....m.m., ===.iwii 0 1111 111:1 1111111 15 INITZEINIMEMEE1■11, 7.11■111 1:111151■3■1:1_, 01■11 111=■■:1■1E1 ■11■:11■3:11111 101100 =11M=111.E■., 505000 - 0 •■:1=1026MEI=0011111M 0 440.444 - 1477,00 0 MIE/MENS/=1 I =MIE=11 0,000040 - 3.000 MO '., 555 Ell 555,51 ' 1837.10'0'.:41 El MIM11=1.1117ZW' riiiiii2111EMIM= II=MISI 1311211=1 M'' Ell MTERIMMIMME1114M=II 71005 0:0.0 RIM=1=2111 =mialor400..5 mlE1 000,000 :::::: 55: 850 r wi i =11=.13 ,520,000 5 555.5551 4.920.000 5,01.,53 15,8551 1,555 375,000 57,060 5110,173 571.22.1 5504,21.5 .5755,215 Carmel Redeye! ,n1 Commission Month and Year to Dal venue Budget Analysis For the Month Ending November 30, 2011 Reference A 1 8 7 I D J E I 6 I 0 i H I I .1 1 K Reference 1 Current Month Comments Current Year Budget 1 2 2 3 Buc_iggt Actual $ Variance Proposed Adjustments Revised MD S Remaining % YTI) Recognized 4 RECEIPTS - NON OPERATING : 4 5 TIF Revenue 30 30 $0 $18,054,793 31.8,054,793 511,127,554 36,927,239 61.63% 5 6 Developer payments 0 0 0 0 0 1.81 17,177 o 341A i Mscellaneous LOC 376887 , 0 1887 :tcPat'ddr77uri ne10 N7e m :e r1 Utnobing hape1:cunti 9 ecm December 50 7 Mercantile Line of Credit 225,000 225,000 0 0 0 5848,870 1,063,000 100.00% 8 Lake City Bank 0 0 0 5,808,327 5,808,327 $842,758 4,965,569 14.51% s 9 Wells Fargo 0 0 0 0 0 33,310,522 10 Key/Harris Bank 0 0 0 0 0 0 31,838,163 0 0.00% 10 11 11 12 TOTAL REVENUES - NON OPERATING 601,887 225,000 I3h,807 23,863,120 23,863,120 316,500,189 37,362,931 69.15% 12 13 13 14 14 15 15 16 16 17 RECEIPTS- OPERATING 17 18 Miscellaneous LOC 149,890 0 045,8731) Anticipated draw occuring in November, but nothing happened until December 18 19 Sales of Assets 19 20 Parcel 16 - Old Town Shops II 0 326,744 326,744 This was originally going 30 00 61550013 30 581 30 re-issue an installment purchase contract. This will be an expense in December. 335,000 835,000 326,744 503,256 39,13% 20 21 Parcel 21 - Lurie Building Condos 0 0 0 675,000 675,000 435,201 239,799 64.470 21 22 Parcel 92 - Apostolic Church 0 0 0 1,022000 1,022,000 798,150 223,850 78.10% 22 23 Lake City Bank 0 o 0 1,299,948 1,299,948 1,299,948 0 100.00% 23 24 Wells Fargo 0 0 0 0 0 85,388 0 100000 24 25 Energy consumption payments 0 149,287 149,287 This was not not anticipated to be paid until the end of the year. 240,150 240,150 149,287 90,863 62.160 25 26 Parcel 7a roof repair reimbursement 0 0 0 3,000,090 3,000,090 0 3,000,000 N/A 26 27 Parcel 70-2 revenue 0 o 0 0 0 0 0 N/A 27 28 ii Interest 4 1 101 4,000 4,000 28 3,972 0690 28 29 Miscellaneous revenue 62,965 62,965 0 34,063 264,954 289,017 689,581 (94,368) 238.60% 29 30 30 31 TOTAL REVENUES - OPERATING $212,859 326,108 $7,100,161 57,365,115 $3,784,827 53,000,288 31.39% 31 32 ,0500,997 32 33 TOTAL REVENUES - COMBINED 814,746 763,997 750,7191 30,953,281 31,228,235 20,285,016 510,943,219 33 34 34 35 35 36 36 37 37 Carmel Redeye' 'nt Commission Month and Year to Bah Allure Budget Analysis For the Month Enc., November 30,2011 Reference 4 1 8 j C Reference 1 Current Month Comments Current Year Budget 1 2 51 550 Budge 90tsd4t Variance Proposed Adjustment St i._.:1 YTD 46019iniOg Recognized 4 66843301506550 33033 OPERATING 5 Land Acquisitions and Leases G Energy Center $5,575,000 $5,575,000 50 $5,575,000 0.00% 7 Parcel 7 other final expenses 23,52 0 23,52 0834040022 due to check, that were helff 500,000 500,000 5254,635 245,565 50.93% 8 Parcel 7 streetscape SC 0 N 9 Other land acquisitions end leases 100,000 100,000 SO 100,000 0.00% 10 Other construction 77 0 77 Difference is due to checks that were held, 350,000 350,000 0147,934 202,066 42.27% 10 11 Parcels 45011Interest Fees 0 88,720 38,720 50 30,720 0.00% 11 12 Parcel 11136 Center 298,15 0 204,05 01830018 11 448 10 checks 5545 w044 held 2,450,000 11575,11171) 875,000 0676,925 198,075 77.36% 12 13 Parcel 9-28 Party Time 15,00 03,430 228,000 2 228,000 0209,000 19,000 91.5751 13 14 Parcel 9.31 Chace P land acquitition 3,43 2,436 30,000 0 30,000 426,795 3,205 89.32% 14 15 P200471 04 Harrill Property Purchase 10,00 10,000 113,000 2,000 120,000 0112,020 10,000 91.57% 15 16 Parcel 47 A rt.: Dietnct Lofts and Shoppee 76 0 75 Difference is title to checks that were held, 1,521.000 329,000 1,850,000 51,496,126 353,874 8037% 16 17 Parcel 73 Streetseape 0 500,000 0 500,000 51,937 498,903 0.21% 17 13 Construction Projects: RPAC 75,47 48,504 26,95 Difference is due to checks. that were held. 2,981,000 3,154,000 6,175,000 05,611,521 563,475 90.07% 18 19 PAC Consultant Bills 0 375,000 140,000 515,000 5456545 58,655 88.6151 19 20 Debt Service 0 50 0 N/A 20 21 7. Non-Pac Debt 5100001 3,885,072 0 3,805,070 52,279,219 1,695,853 58.67% 21 22 2000000 Lease 4,920,000 0 4920,000 52,460,000 2,460,000 50.00% 1.7 03 Contract Purchase Payments 248 08 248,086 8,897,755 12,1050.0001 6,807,795 $5,955,507 852,208 07.4051 23 24 TIF Payments/Interest 0 0 50 0 5/0 24 25 TOTAL EXPENDITURES, NON OPERATING 0583,21 $328,038 $255,177 032,469 587 SO 32 469 587 019,275,013 $13,194,569 59,3651 25 26 26 27 27 26 28 29 EXPENDITURES: OPERATING 29 30 Operation, 58.392 76,873 21,515 0,ffereoto,t due to checes that were held. 800,000 323,536 0.020,555 1,043,871 29,665 97036% 30 31 Leases: 075, CRC W0006wire, 13-1 31,030 8,695 23,135 Difference is due to checks that were held. 075,000 0 375,000 313,225 61,774 33.53% 31 32 P40031 10 Shapiro, 7 0 2 50,000 0 30,000 15,000 75,009 16.5751 32 33 Marketing Communications 21,034 6,959 04.075 Difference i.5 due to checks that were held 500,000 1050,102) 248,859 206,175 42,689 82.85% 33 35 MarketirgiEtio Development 4,893 0 4,557 Difference is due 10 0020101 that were held 200,000 200,000 154,836 95,162 77.42% 34 35 Professional Fees 9 0 8 36 Legal 31,540 0 31,946 010501000110 due to checks that were held. 602,000 266,271 866.271 682,164 184,852 78.7551 36 37 Arch/Engineering 00,089 0 50,389 Difference is due 10410800.1 that were held. 500,000 142,438 642,438 501,325 140,110 78.03% 37 33 Accounting Fees 29.892 13,542 16,260 Difference is due to checks that were held. 400,000 0 440,000 000,405 60.531 04.87% 38 39 Administrative and other 13,053 2,000 11,093 0,9080983 )8 due to checks that were helff 150,000 0 150,000 136,128 18,872 90.75% 39 40 Miscellaneous 28,377 19,899 3,473 Difference is due to check, that were held, 550,000 (110,('10) 133,850 125,017 8,833 93.40% 40 41 TOTAL EXPENDITURES-OPERATING 0404,700 5127,960 176,785 03,965,009 5264,954 04,225,954 3,567,218 5662,736 84.33% 41 42 42 43 TOTAL E86E00601045E5- COT001NE8 0887,000 5456,005 5431,962 536,434,587 530,699,541 022,042,236 013,857,305 62.24% 43 44 44 October 2011 70 660.274 ParnINI Redevelopment Corp rn.slo n 310334 0907 201' MAN Pooectont A3 7721 3 7011 NON OPEiiATING BALANCE TIFF666166.5 TIP Revenue 7666 op. Pave.. TIF Rol 6a1.6.1661 Of 16.610646 646.6n1O LOC 6.66,6nti, I 66. 447714/444 Bonk .6 CIO 16.16 $352244 IIIIIIInnIII.IlliNIIIM MIMEO MMN■■IIIIIn•■=1111= = o,,00, iimigum■Iiim=31 o , 11111111=1 NIMIIIIIMI■■•■■•11111111■Mil INIMMEINII■3 MINEME■2= TOATTTA 6,6.666 O alliM111.111:1131 IIIIIIIIIIIIIIIIIIIIII IIIIIIIIMI 54 760 IIIIIIIIIIIIIIIIIIIIIIIMI Wol T Fa. anwgv Con. 6 .345 ..367 69 ,.666.66,..L.e6 6XP4 A bttllRES . NON OPERATING MIII1111111111==111111111IIMI■" MME" ill11111111111 Total R06.065. NON OPERATING 106.666 OTO OOO ,,5O,,” I 1,I,A,IQ TO 666. r6Oter 11111111111111111111111ilill111111111=1 in in ,,o6, T Aroo.o. IMIIIIIIIIIMIN IIIINIilAnllinillIllMilleIIIIIIIII.M111111111lMIIIII." IIIIIIII1111111111113 - 1111111111111.111.0121111...in=111M IIIIII11111111111111i111111i1=111111i Mini illEl■i1111111111= IllIlli=E 11111111=11111111111illilliiiiiiiiiiiiiii 1/Mil o Other la. 6660,1666; .16666 TTTATT 11111IMMIIIIIIMIN1111111111313 E0,2o illaillIMINIIIIMI M. Imo 12000 .005 19.000 IIIIIIIIIMMIIIIIIIMEEI 3,43, MINIIIIM n lo,000 10 . 1,600 1:1111SIIMIIIIIIIIIII IIIIIIIIIIIIMNIMS 11.111=IMIIIIIIMMIll •46.164 •111112101=111iillillinnilln IIIIIIIIIIIIIIIIIIMIMMIIIIIIMMIIIIIIIIIII 142.271 Eiglill.:1 66602 IIIIIIIIIIMM TOO.. ISIEDMIMMINEEZI 66,66 1.1111.111311111.1IIIIIII1 111111111111131111111111111111.113.1111,1,FEM,m1=A1 IIIIIIIIIIIII0 :=IiMIIIMIIIHMEI 66,, IIIIIM 60,061 T.065.120 .0 1• riwy■wwilmi■no o ■=11 I■maimmoni= 2433,084 5E1756 713,033 ' ' 8 3... ellIIIIIIIIIMMIINICI 111111111=111.1111131 IIIIIIMMINI IIBMEIIIIIPIIIIIIIBEIIIENIIIEIIWBIJSIBJIJNI mizzainiimi■zaminimessmowerouim■za MOM ,___. Ra. . and Grants , OPEPATING MIIIIIIIIIIII =====iiiiiiiiii 1.11.11111111111 MEM ..1.6.6 TUT 11.11.1.11.111111111111113111111 ®=IIIIIIIIIIII.MEI=g IIIIIMMEIMIIIIIIIIIIIIIIIIIIIIIMII=dl •1 .• isilMillenlnifillillil ill10111•1111i rillIM Millii1111111 111111111111111in • 0 11111111113illnil!Ill ■■•■=1.111111111IM ■:I■:1 ■:I■il ■:Iii■EIN!1=1.1.1111!IMil IN■ll■iill ■;11 ■3■1:1■11 o ■:I■il ■::1■1■11iiil 0 111111111i11•1111111=1 M21:11!CM On31 Nov.. 41279.0 4123113 373274 .66167 AM I.O.1.6 drA.She 56: .66176 SA6.6666 Con:TAATIO, Pro 2236 10,00A .36 TOOPO 1G. ■1123 5 43 030 Co66.1,66,66 Ro6o. Fund .66..1 71 Pavlro.1.66, OTAL EIMENDITURE5 t NON OPERATING 'OPERATING PUMPS TRANSEEPPEN TO NON OPERATING IITTERPUND 'LOAN ENDING BALANCE NON CI AERATING 5646108, 1.260,66 56 160717 7,94,999 81,679,330 Reer,rkeE MI=MMIMMIMI ■=1111M1■■ Ii■iiii/O1/11■11 ■IIMM ACTT:. immmi .mri.mmrj MEITISEffilii ...... Illirlinlingliliallen =il■Mil irl 1■:1■1i1 0 5.0. ■IlillEnin ■i1111 16,37 350.0D0 = iii6. Ill 1111=11Ein 2,950.0 illniM1=1 ii= o35,. ■Illinil .00s , ,o so ,, oo a oo WI inlinnin:1 roPoo in illn 3 55...o ill Il 5.35. ....0 il ilinill i ■!1 llOillnlIMlliill ■IiilMil illn ”s000 ME:i hnillil illninillilln■liMI 1■:1 innlinill!1!1■31 =IMICIillnlinEMME = 1■M■lilEl .1111MMIM=ME I ri 111111111111 11111111111h --dimmEmma --- -i=imi....... - ■11Mi■11=1 MMIE■ilillinn!=ilinll ■=.1111 iZII■iln ■lin I■i ■!Iil ■I■MIMio lilliMillilli ■111■11I 1■1111i18111iMMI 535,. in 335,000 Irl ==l1 M.DOC :4O.OW 1 0.000 1:1 1 0,2,00 ill 1■11■1■11 l■lil illnEINI ill .1 ' ...oso 4,441, 254,854 2,,S5A 1110 .-mmii 571226 SS 1.6116 - Old Town SA.. 66.1 21- LW. Cold. 66.162 .6^6.6 Our. Ener,..6.-Ation O6o.,,00f To66.6.6.on6. 66, o. r666666 NO.11666., moor. Inta.mvenuos - OPERATING EXP6NDITURES. OPERATING 61.7TO 16.777 12.261 61.8O7 •■ ii ==I ill= 1■■ !MI 5,3oo ■InnElioMinnillnlanl■i/Bli illiiinnlil Lease6 WS. CM WOC.V.1, 6, 37:Ella32{313,.,, !IEZ/ •.,,, : 4CPC AT. Porool 10. 66, 1111111111111 .00 TT,T =639EIMMIIMIIMIMImmilmi ii1111:11111 Mark.n6 C.Toonloa.6 MarAo.tinr., Dovolopmeot 11111111MM SIORIZIMIIIIIIIIIIIMel 25.91: 11111= !I 1121i131ilEn■Enn illnlinn o5,o, 5,0=o innillinil ■ni■M■111■11■•=11MiMIlill ■Iill 11111111i1 illilill1■11:911 ■IIII■IMI =iM inn on000 moo MI ■IMIENI am■:=14,z • miN.W1.1M1=EMM■BEEII'l■BEm II■gi ,innj - inlininil illinnEllinnil INIMIEEMilllillnl 1.661146OnoT Ado, ...No. ol nor OA. TIA66 .6 ARO 250706, IA 266 6.6TO Elan T 130 1,36, ,,5,,,,E MI , 6 ,,779 130,000 illEll■lilllin .0.. ICIAL 6.6601766 OS -OPERATING TOTAt OPER.166 F.75 TRANSFORM TO NON OPORATI NI 6., , , ' ,,,,,' 196.646 9.666 MB 11111ffl OTSAIS 67,040 311.536 40'1.3T 316 066 1,666 56,887 557,0. 500.0LO 4,920,01,0 4 424.060 INTERFUNG LOAN iffifillnillE1■11110 641,992 11 661 1111116180 ENIVINM BALANCE OPERATING 2.196,746 TOD,362 748,663 473,0,6 117,77, 22.461 57460 I ENDING BALANCE NON OPERATING AND OPERATING 52.8,743 5573,323 9733,977 5554274 471.4247 44, 43,939, 864,402 4483,474 1 573434 5 Carmel Redeye' 'nt Commission Month and Year to Da, ■enue Budget Analysis For the Month Ending October31,2011 Reference A B C D E F G 1 tl 1 K Reference 1 1 2 Current Month Comments Current Year Budget 2 % YTD 3 Butlget Actual $ Variance Proposed Adjustments Revised YTD $ Remalnine Recognized 3 4 RECEIPTS - NON OPERATING: 4 5 TIE Revenue 30 $0 $0 018,054,793 313054,793 011,127554 56,927,239 61.63% 5 6 Developer payments 0 0 0 0 0 (S1„447,r173) 0 N/A 6 $225,000 of this will be drawn in November, and the remaining amount is 7 Mercantile Line of Credit 1,126,045 623,870 1 °$01,17`17 to be held for interest 0 0 5623,870 1,063,000 100,00% '7 8 Lake City Bank 0 0 5,808,327 5,800,327 842,758 4,965569 14.61% 8 Anticipated having to draw from Wells Fargo to pay for PAC construction bills. We will do this in November, but won't be 4 Wells Fargo 57,577 0 I'9.P,Ii�171037,577. 0 0 3,310,522 9 Transfer occurred to cover checks written 10 Key /Harris Bank 0 0 72,965 72,965 for Parcel 70 Office Building construction. 0 0 1,838,163 0 0.00% 10 11 11 12 TOTAL REVENUES- NON OPERATING 1,183,623 696,835 (406,78004 23,863,120 23,863,120 016,275,189 37,587,931 68,20% 12 13 13 14 14 15 15 16 16 17 RECEIPTS - OPERATING 17 18 Sales of Assets 18 We will not receive 156 in the form of cash revenue. When this transaction occurs it will go to pay down the amount 19 Parcel 16- Old Town Shops 3 335,000 0 1'a3,,.000( remaining an the NBl note. 835,000 835,000 0 835,000 0.00% 19 20 Parcel 21- Lurie Building Condos 0 0 0 675,000 675,000 435,201 239,799 64.47% 00 21 Parcel 92- Apostolic Church 0 0 0 1,022,000 1,022,500 798,150 723,850 7810% 21 22 Lake City Bank 0 0 0 1,299,948 1,299,948 1,299,948 0 100.00% 22 23 Welk Fargo 0 0 0 0 0 85,888 0 100,00% 23 24 Energy consumption payments 40,025 0 (477,075) Still have not received payments. 240,150 240,150 0 240,150 0.00% 24 25 Parcel 7a roof repair reimbursement 0 0 0 3,000,000 3,000000 0 3,000,000 N/A 25 26 Parcel 7c -2 revenue 0 0 0 0 0 0 0 N/A 26 27 Interest 4 2 jt) 4,000 4,000 27 3,973 0.67% 27 Most of this (about 5187,000) was immediately withdrawn Sons the account 28 Miscellaneous revenue 0 194,228 104,228 to cover the Regions quarterly obligation_ 24,063 264,954 289,017 626,616 (01'7, ^; °,I'3)i 216.81% 28 29 TOTAL REVENUES - OPERATING $375,029 3194,230 (0181;1 9) 07,100,161 07,365,115 53,245,830 34,119,285 44.07% _..... 29 30 ,.. _... .... 34 31 TOTAL REVENUES - COMBINED 1,558,652 891,065 'dl . on 30,963,281 31,228,235 19,521,019 311,707,216 31 32 32 33 33 34 34 35 35 Carmel Redeye Int Commission Month and Year 160, en. Budget Analysis For the Month Ent,.,,g October 31, 2011 Reference Reference Curren Month Comments 3 Current Year Budget AfILQP Bu Actual Variance Proposed AdiustmentS Revised YTD Remaining Recognized 4 EXPENDITURES: NON OPERATING 5 Land Acquisitions and Leases 6 Energy Center 0 $0 00,575,000 00 55 575 000 00 05,575,000 0.008/ 7 Parcel 7 other final expenses 52,054 19,471 52,585 Difference is due to checks that were 1,14. 500.000 0 500,000 7114,635 245,365 50,93% 8 Parcel 7 streetscape 0 0 0 0 0 0 0 0 N/A 9 Other land acquisMons and leases 0 0 0 100,000 0 140,900 0 100,000 0.09% 10 Other 1050tr461: n 5,386 5,305 0 050,000 0 300,000 147,934 202,066 42.27% 10 11 Parcels 43411 Interest Fees 0 0 0 00,720 0 33,720 0 38,720 0.00% 12 Parcel 5 CA, Center 50,549 25,528 05,027 Difference is due to chedstf at were held. 2,450,000 11,070,000 875,000 676,925 198,075 77,3904 12 13 Parcel 9.28 Per1 Time 19,000 19,400 0 228,000 0 228,000 190,000 38,000 83.33% 11 14 Parcel 9..31 Chaos ... land acquisition 2,436 2,436 0 30,000 0 30,000 24,359 5,641 81.20% 14 15 Parcels 14 Harrill Property Purchase 10,000 10,000 0 118,000 2,000 120,000 190,000 20,000 2333% 15 16 Parcel 47 Arts District Lofts and Shoppes 70,549 70,959 90 1.521,000 500,000 375,000 329,000 140,000 1,650,000 500,000 11111111111=11IIIIIIIIMEMMIIIREB2 0 1.496,126 IMMIIIIIIII=11.111111.283 5,568,007 0 353,874 fl 0 80.87% 99.09% 0/0 16 17 Parcel 75 5treetscape 0 0 0 18 Construction Projects: PPAC 114,413 16,171 98,293 56,9090 9 rheemeunt :a retenton iewi General Being, butthrouBl: en Esonweeenunt and not aut of 050gerKral fend. 18 15 20 PAC Consultant Bills 25,388 25,808 20 Debt Service 0 0 0 0 0 21 "500.550 Debt 55100ice 0 0 0 3,385,072 0 3,885,972 2,279,219 1,605,853 58.6704 21 22 2005 PAC Lease 0 0 0 4,920,000 0 4,920,000 2,460,000 2960,000 50.00% 22 23 000trunt11001I1u0o Payments 489,365 544,226 155,711; Please refer to the revenue analysis to see 04:0re we received an excessive amount that was drawn frorn um account 10me404010. That f:00,1 t hie difference plus a credit on our account. 8,097,715 IIIIIIIIIIEIIIIIIIIIIIIIIIIII 032,469,5E7 17.090,010, SO 6,507,795 0 032,460,007 5,707.419 019,357,011 1,100,376 003,117.501 83.84% FS 59.52°a 24 111111r1 TIF Payments/Interest 0 0 0 EsTOTAL EXPENDITURES - NON OPERATING 0034,135 $735,064 096,076 25 26 =El 27 28 PENDITURES: OPERATING 29 I Operations 65,953 152,416 133,4921 'I his dfference include, neer ell for 0001,1, which 10 now automatically drawn from DI, a,counl during the month, and fall proportytaxes that were due en November 1016. 800,000 323,536 1,123,536 1,011,993 106,585 90.52% 30 32 Leases: 075, CPC Woodewlre, B-1 20,597 29 597 0 375,000 0 375,000 904,591 70.460 81.21" 0,0051 10 Shapiros 13.141 0 10,101 Differeeee it. duntecheelothat were held. 90,000 11 90,000 15,000 75,000 165704 32 33 Marketing Communications 14.032 14,005 106i 500,000 1.2111.11111 241,359 199,216 49,643 00.05% 34 Marketing/Rua, Development 9,150 0 9,150 Difference is due to cheeks that were held. 200,000 200,000 154,838 45,162 77.42% 34 35 Professional Fees 35 36 Legal 21,347 4,145 24,102 600,000 266,271 366,271 682,169 194.102 36 37 Arch/Enineering. g 54,624 13,511 41,113 Difference , due to chnelo that were held. 500,000 400,000 142,438 0 642,438 400,000 150,000 501,325 111111PI 134,125 141,113 EI 05,672 111111M 81.48% 89.42% 38 38 9500011509 11501 5,918 5,910 0 39 Administrative and other 37,607 35,920 1,382 150,000 0 40 Miscellaneous 20,605 15,960 4,736 ITfterence is due to checks that were held. 550,000 (40,1,A, 183,85() 100,118 20,732 7833% 40 41 TOTAL EXPENDITURES '0666417599 0273.156 0762,900 010,206 03,9E5 000 5264 954 04,275,954 3,439,249.90 5790,704 81.51% 41 . 42 TOTAL EXPENDITURES - 000413)0E0 01.107.235 00,001,014 0106,282 036,434,507 036,699,041 027.795,055 019.505.200 62,1204 44 44 September 2011 Carmel Redevelopment 'Low... tly.,sr 2011 Monthly arojection, As of Sep... 30, 2011 1. ,...eza I Actual Fah 0.1 March . .1 meual , . 809.1 ... Roamt 472.1 9. Bobo .1.5, .0.19010 No....... PROTONIC 06.0662,0r Taal 2011 kW. OPERATING M.N. 94,444.464 52,194.743 9570,323 3739,077 0976,074, 3466,535 59289,08995 01,241.05889 01,000,833.90 0I064,06 5649 115 5500 653 4144. ...Grano 0744 0417 Bank 0 907945 470.704 537000 4382,00 60 254.709. 0. Rd. 0569, . 703 334,956 2.96.2. 256.5 50760 86,211 27.38 1.009297 Wellt Farr 443 77173,4 5996118 925527 1.084.672 690,375 90023 57070 07 57 577 07 66.1845, 315 Roten. 11 127554 S. 0. 197 9 .852,793 Goo.. Pay... E1,457.67. /1,12,6675.1 Mho Racelpto Mert... WC 43014017 64000000 2.171004 ...47.883 .05 Grant 7,105,273 Pa., IS- 0171Town Shop., OS ON MOOR 855 Po. 11 • larie 09216.0o.. 436,201 4.601 575, 932.97. • 9.5.410 Church 1 062 59572.211.... 9.65 .....3 450.65 1....5 240,150 43.561. 78.7 "522a ...moo, 3,000.0091 Mort 7. 66.406 ... 998.1....... 11,7. 12,61 47,527 1,588 1,103.289 50 75 a,„110,5,2. _.K..9..§.,1 1649144.44 0416,450 41,05470 46.219,033 41.996838 14440446 411.239364 110001001 9145.0 3933,431 04.44,490 44434.431 4.0,010,044 900,006,009 5,30,063,244 2.88.01.111951 ....I.' . .175 '2 931 55 5. 92,09" .9.1 01070,700 1,6 191 9.9:ZEOB 0,170,000 300,000 Po. 7 oho firol. expencm 5 9. OtTer land 9.180.4 #5. ISME , Mt ,O,C,0 1170,000 Gt. commotion 31,467 $1,687 9865 5.790 15.800 3.3E6 1...0 350,001 450,000 P5rool 4811 Into.. Fee, 2,36C 13,360 3fl,720 38,720 2.21 5 0,5008. 190 021 112 422 163 GS5 63 .66 70 395 19102 71,136 5,0,50 .5427 ,,b,,,,,7 1.435.000 2850,000 Parco1.0.68..2.4 19,000 29004 13.000 13,0M "0:: SOO 336 19.000 2.915 19.000 4.436 19,0091 4.706 15.0. 7.101 79.090 2836 19,000 It,. 6.12700 0,440 228.0 79000 Parcel 9.1 floos•lond am.111on 4.446 4,046 1.406 6,440 Par. O.K.., ,00 Et 1000 1000 1.000 2.000 1.000 1,000 1.0 3.41 90.0 Pool ....111 Property 160759479 10,000 TOO. '72 074 790;726 19400 19.5 19000 144.639 10 TO 345639 10.00 7E3.662 ID 000 .000 82,480 177700 76596 19 fr 19000 179090 1.96510 113.000 1,521,000 Pa.... Oser. by. a. Shop., 49,134 P92. 73 585 Cape 1,017 79487 .487 300.0 M., 045 095 W007500407, 0.0 17 019 47.014 60, 6, . 113: 00,444 1,644,469 00,464 44344 00000 295.3 43.300 390,817 47,000 144.749 00.004 140.444 00.017 114042 3' 135 05,029 3 6701790 171040 2,981,000 Conoroolon. Polo. R8. 5.030 882,239 P.K. 10744l0. Billt 111,047 46447 10.1363 45,404 40,000 32 029 70,000 09,004 39000 00,0704 011001 004.000 Opera., a. MS. 09.00,, 93,213 57,506 .710 02.6 74,530 .7.356 136560 89,764 92.6351 62953 59000 95 0. 1 101 539 600 OM 4808 Gra. P.O. 76927.4945.39 Marko.. Coornuolotlook 06 918 4 459 9. 112 27,1 521 36 729 42 928 90 127 14 OM 75 ON 748 7. 300,000 ma,' aliBus 04,41 rnent 2.0 In .0,440 0 , 104 07 14.70 20,734 19,120 9140 40,0 0.100 00.401 10.000 003,001 7refesslonal ie. 07,,4 4,073 44,064 4014.41 47,700 44,480 007,444 144.440 149018 44,041 28.7 MOM 00,400 506,271 609000 820608070744174 7,582 151,048 00,000 42,301 81.776 31,501 10,740 53.5 90,000 44000 59300 490838 000000 8.2countina Secs 37,7. 99 418 30 727 25 017 .312 10 910 19,548 1.4.182 5,911 5,,,, 8 374137 ',CV ,100,00., .1061.000 ..n1s4.11.... other 27,545 5 3 SOO .25.978 6,377 22,349 16,332 2,57 6.99S 6,915 .0,00n 150,000 0701e1147e1. 0,410 4,846 5,188 4.420 10,440 1.400 04.0 4,400 44,064 70,401 97 050 10.0 132010 950000 4707 070,107 "Nook, .1645erv52 6690. .7,977 1.4.1 30090. 2.005 9,38 tease 2,4605000 2.1.900 9,920,000 c.v. port, yyy pyycca,ty 40.040 770.2 532440 76830 349408 495.071 2,067,009 294,930 306,909 40.1,004 046005 5943rg, 0,1414.3 8.,897,795 TIF Payments/Interest 04067 48407409004 04.6,193 52,634,318 98701,080 92,314290 $1,622" 3 99,582610 54.900,049 5448.400 4,076,640 0,100.00 0,0711406. 47,07E,314 404A44,85,,, 339444. 00400. (87.10006 .120.114 92159043 9509363 9738,077 9976874 4159939 76,789,090 34791.9 01,038,830 9397.0 1060,11,9 0040,047 Current Month Comments Carmel Redeoo and Commission Month and Year to Dat, nditure Budget Analysis For the Month Enn,..y September 30, 2014 006948 ACMM41 $Varianct EXPENDITURES: %970 Proposed Adlustment5 Rev4ed 171) $Remaining Recognised Land Acquistions and Leases Energy Center 00 70 50 55,575,000 $5,575,000 50 55,575,000 0.00% Parcel 7 other final expenses 35,518 35,518 0 500,000 500,000 035,164 264,836 47,03% Parcel 75treet08404 0 0 0 0 N/A Other land 6466Aisitio65 and leases 002,020 102.000 0 100,000 0.00 "% Other construction 15,809 15,000 0 350,000 350.000 142,549 207,451. 40.73% Parcels 48,11 interest Fees 33,720 30,720 0 33,720 0,00% Parcel 0 City 0030e9 71,336 71,000 0 2,450,000 2,450,000 651,398 1,798,602 26.59% Parcel 9 -28 Party Time 19,000 19,000 0 228,000 220.000 171,000 57,000 75.00% Parcel 9-31 Chaos - land acquisition 2,436 2,431 0 30,000 30,000 21,924 5,076 73.03% Parcel 10 S'n4pi001 1.000 1.000 0 90.000 90,000 15,000 75,000 16.67 51 Parcels 14 Harrill Property Purchase 10,000 10,000 0 113,000 118,000 90,000 28,000 76.27% Parcel 47 Arts District Loft., and Shopper 82,480 02,480 0 1,521,000 1.521,000 1,510,357 10,64 8 99.50% Parcel 73 Streetscapo 590,000 500,000 1,037 498,963 0.21% Leases: OT5, CRC Wood swi re, 0 -1 21,306 21,306 0 375,000 375,000 283,934 91,066 75.72% Construction Projects: RPAC 27,845 100,810 f 12 ifri $72,965 worth of invoices were for P7C and therefore paid by a Harris Banta transfer, 2,991,000 2,981,000 5,663,277 (7 067 109.90% PAC Consultant Bins 31.321 31,321 0 375,000 375,000 430,956 656.516) 114,92% Dperations and Maint, 0 Operations 134,410 92,658 40,760 541,072,45 worth of utility bill were already paid in August, 5267,17 worth of utility bills were paid in September but won't be approved until October. Also, one invoice was underestimated by 544,01, 000,000 200.000 8884,502 ((2,,9'0.4'.'1.1 100.07% 4050 Grants 0 0 0 0 N/A Parking revenue shortfall 0 0 0 0 N/A Marketing Communications 40,127 40,127 0 500,000 500,000 184,729 315,271 36,95% Marketing/BUS. Development 20,123 20,133 0 0 154,$38 1,137,7.70'') N/A Professional Fees 0 0 0 N/A Legal 64,021 63,721 0 600,000 500,000 600,000 500,000 675,024 407013 ;721,014) 12,107 123.00% 97,56% A335/E58i5eerin3 53,930 53,955 0 Accounting Fees 59,991 59,991 0 400,000 400,000 320,009 79,991 80.00% Administrative and other 16,332 16,332 0 150,000 150,000 90,204 51,796 65.47% Miscellaneous 35,56$ 32,161 3,407 53,500 check for Alesa Rust was cut in August, and $93.08 invoice for Matt W ort'hley was paid in September but is set to be approved in October. 500,000 550,000 89,164 460,036 16.21% Debt Service 0 0 0 0 N/A n0908-Par Debt Service 3,885,072 3,8$5,072 2,279,219 1,605,053 50,6751 2005 PAC Lease 4,920,000 4,920,000 2,460,000 2,460,000 50.00% Contract Purchase Payments 739,814 306,569 493,245 5433,240 was a revision to July's quarterly obligation to Regions. It was just a formality m show that the total amount was approved even though this expenditure had already taken place, 8,897,795 8,897,735 4,747,559 4,150,226 53,36% TIF Payments /Interest o 0 0 0 N/A Total Expenditures 51,481.071 61,076,624 5404,447 $36,430.,537 536,434,507 $21,560,747 514,353,840 59.23% 1 The RPAC expenditures ere over budget due to accounting for the Parcel 70 project that that was originally not budgeted .since they are an IPC. These expenditures are offset by the revenue from the IPC, which was also not originally budgeted, 2 The PAC Consultant expenditures are over budget due to unforseeninvoices that had not been budgeted. 3 The Operations expenditures are over budget due to unf0rseen invoices that had not been budgeted. 4 The Marketing Business Development expenditures are over budget because this category was not includetlinThe original budget and therefore any dollar spent on this would be considered over budget. 5 The Legal expenditures are over budget due to unforseen invoices that had not been budgeted. Current Month Carmel Redeye' ent Commission Month and Year to Dat, avenue Budget Analysis For the Month Ending September 30, 2011 Comments Current Year Budget Actual $ Variance Proposed Adiustments R % YTD RECEIPTS: TIF Revenue 50 50 50 518,054,793 518,054,793 511,127,554 $6,927,239 61.63% Developer payments 0 0 11,10 /,(,78) 0 100.00% Other Receipts: Reimbursements 0 4CDC Grant 1,284,575 0 (1,54,1511) We expected to use Lake City funds for work on retrofitting City buildings, but have not received invoices for that yet 7,108,275 7,108,275 5,539,116 1569,159 77.92% Key Bank 0 0 0 0 1,765,198 Sales of Assets Parcel 16 - Old Town Shops II 335,000 0 131'Iiil75l This is now expected to be done in October 835,000 835,000 0 835,000 0.00% Parcel 21 - Lurie Building Condos 435,201 435,201 0 675,000 675,000 435,201 239,799 64.47% Parcel 92 - Apostolic Church 0 0 0 1,022,000 1,022,000 795,150 223,850 78.10% Energy consumption payments 40,025 0 (1007'5) We have sent the invoices, but no payments have been received yet. 240,150 240,150 0 240,150 0.00% Parcel 7a roof repair reimbursement 0 0 0 3,000,000 3,000,000 0 3,000,000 0.00% Parcel 7c-2 revenue 0 0 0 0 0 0 0 N/A Interest 4 2 (2) 4,000 4,000 25 3,975 0.62% Miscellaneous revenue 250 250 0 24,063 24,063 432,388 Nil %, 1Py ) 1796.90% Total Revenues $2,095,055 5435,453 {$ 'p,(/),') $30,963,281 $30,963,281 $18,629,954 512,333,327 60.17% 1 Key Bank is drawn from 30 549 for Office Building One expenditures, which were not budgeted, These draws were also not budgeted. 2 Miscellaneous revenue received has been much higher than budgeted because we did not anticipate bond closings this year. August 2011 Carmel BMeve mamma Commission B9dget Year 1011 Monthly Pro /ections AS 028 gust 31, 8011 111111111111111111111111111111111111111.1.111111 = - - - -11111111111111111111 1111.11111111111111111111M 1111111111111= u , $3,344481 ' -- �� - =IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII.IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII -I I 111111 1. 1111111.11=1 '3500 - - - 11111=111.1 ®��1� IB1I I�3-� ®'. ®- ��- ���� � -- w4mhx ®® IIINIMIIHMIMIIIIEHMIII IMMIIIIIIIIIIMEEMIIMIIIIMMEI OYE40 ,,, ,, nr � 11111111111111111111 )q;sn.9a1 2P336uag 38,954.)91 OPERA NO BALANCE ®"' IIIIIIIIIIIIIIIIIIIIIII �' 111111.1111111111111111111 1111111111111111111111 ME ® TS]..OR8.IL 9 - . ,isiAr. 4C000n24 Lake Gryean Nay Bunk NaAll 40879 4ro 19pv Center - IIIIIIIIII®III RECEIPTS: LIP 84 4/0002 ... -� Developer Paymene ==M � -- 0 0. IDES'. a,aa ¢mope c6ccrant 3ata at a. Parcel 16 - OIL Town Shops II �� � __ . ssoW x,6zz,W9 3 IIIII� ® ®® 4,000 ® 1 12,291 ].398 9 53&94 )S0 304„ 24.063 .' $i,tl03,898 ... g f /Yb9 11161_1 I- 53e 963281 =1.1111111111111161111110111111111.111111. MIIIIIIIIIIIIIIIIIIIIIIIMIIIIIIII I 7 000 - .......552 5.6W 1,456:.85 ] 1x38.393 E [enter Parcel 7 erher final expenses ® 2009 ®IIIIIIIIIIIIIIMEB 11111111111111=111111=1 :61095���® 19,003. 19 .000 19,009 9 000 17,a36 92933 9 000 1d?3G ® ]9.001 114,2)9 ).9,001 MH.RON ® ■ ®IIIIIIIIIIIESIMMIIIIIIIEE] ®_ 18000 0PC OOGO 090 „- 4 A0 2. 00 681 GOD 350.000 9.000 1'76,400 Pi)IIIIIIIIIIIIIIMIIIIMMIM-- DI - d m UI tl lease 4 h P, <8124.60. Pareer 46, P OW Pa NAP 688D 0021 119000 19 05P y 431C 1 111.In Parce110 F. 2,436 7,436 2 ,38 ®' O.ORO IIIIIIIIIIIII■CEEIM®IIIIIIIIEIEMI 1.634,204 ],436 -®' 0.000 ����® J64.31:n 2,di6 0 0 0 1,400 0000® 908 006 )1039 3959 2,,436 90011 6000 2,435 9gpW1111111111111111MMI 9[1355 8G .3. 2436 ®® 1 ® ®® 29,736 ® 009 -.m '4,000 90 311 30.000 90Otl0 ]14000 ,400 SUGOW 375,400 7.981.000 10,010 ),WO 10.000 2,000 10,000 207J8 �� 26,785 857,301 2.014 Drerilt Property PUrr.se Parce147 Arts 011rlet Lofts and SM1Oppes 49,134 72,074 Pa Peet )3 Streeta2 4 - 1,032 Ls. OTS 20 d wire, 80 17019 52,010 57,752 982,789 P ream D AC 111047 48,242 120,383 ��� ],934 - �- ®1111111111111=101 113 ® 30521 0" -... .. ®■Z1E211 35779 ..__... 07.8 �- -- 47, „918 3]]21 x0,132 30,085 .A OOn jp.pCO 709a 378,000 Operatlo sand Ma ni' SS.pOP - 40,000 nu. � 75.060 ■ 25.066 .,,. ]]x,772 800.000 � IIMMIIIIIIII 500.000 Iip4ror10n5 57,306 85,710 4c DC Gmn[s arr. revenniM1O1liali Markennq [0mmurt.:16ns 76,918 4.469 MarNennNBus, Dnelopment ]$335 1880 22,109 Y2bd0 1,4,924 77),j4 19132 9:159 70,123 15,044 2,054 .6,054 SOq.p00 - l9eex Legalon 4,578 41720 12,983 69.'211 2a,]BJ 07 1 0908 U3,)Y5 90,000 50,030 600.000 M175 P 0 2. 0422080 7,502 s 151.848 99,418 90,589 30222 47,301 - 81 6 31.503 88 783 935 4.0521 8142 8,467 500.140 500,900 f® ®��®® 4.0 .403 4829)2 548 ® � ® '_99x ,,,..._.. 16,332 ® 1111111111111111111M11111111111111111121=E ®, ®® 773 BODD 31Y6,BU0 ) 267,997 400.900 150,WC 656.bOC 1885.07[ 80 ¢and runes 71,545 6,3.23 8 Misullanuous 8,886 oentsen. - Service 605,021 2005 PAC teas 46tl OW 2nGD OW 4:)2008 916000 Contract Purchase Pa me. 770697 ®®_®_�_I_® ..,, ®' r : ® :.: r ® ®® • .. 52,684,325 _ ENDING OPERATING BALANCE IIIIIIMEMISI $520,333 11111111=IIIIIIEIMMIIIIIIIIIIIKEM "'�iIIIMMI '®' Current Month Carmel Redevel ant Commission Month and Year to Date L 4nditure Budget Analysis For the Month Ending August 31, 2011 Comments Current Year Budget Actual $ Variance EXPENDITURES: % YTD Prc_g=1 Adjustments Revised YTD 5 Remaining Recognized Land Acquistions and Leases Energy Center $0 50 50 55,575,000 55,575,000 50 $5,575,000 0.00% Parcel 7 other final expenses 52,931 52,931 0 500,000 500,000 199,646 300,354 39.93% Parcel 7 streetscape 0 0 0 0 0 0 0 N/A Other land acquisitions and leases 0 0 0 100,000 100,000 0 100,000 0.00% Other construction 5,740 5,740 0 350,000 350,000 125,749 223,251 36.21% Parcels 48,11 Interest Fees 0 0 0 38,720 38,720 0 38,720 0,00% Parcel 5 city Center 10,102 10,102 0 2,450,000 2,450,000 580,062 1,889,938 23.68% Parcel 9-28 Party Time 19,000 19,000 0 228,000 228,000 152,000 76,000 66.67% Parcel 9-31 Chaos - land acquisition 2,436 2,436 0 30,000 30,000 19,488 10,512 64.96% Parcel 10 Shapiros 2,000 2,000 0 90,000 90,000 14,000 75,000 15.56% Parcels 14 Harrill Property Purchase 10,050 10,000 0 118,000 118,000 80,000 38,000 67.80% Parcel 47 Arts District Lofts and Shoppes 0 0 0 1,521,000 1,521,000 1,427,877 93,123 93.88% Parcel 73 Streetscape 0 0 0 500,000 500,000 1,037 498,963 0.21% Leases: OTS, CRC Woodswire, B-1 21,030 21,030 0 375,000 375,000 262,628 112,372 70.03% Construction Projects: RPAC 123,959 123,959 0 2,981,000 2,981,000 5,562,467 (2,84L,4l 186.60% PAC Consultant Bills 32,029 32,029 0 375,000 375,000 399,635 G,4,63,f) 106.57% Operations and Maint. 0 Operations 80,753 89,764 19,01 'I ) includes invoices that will he approved in September 800,000 800,000 771,924 28,076 96.49% 4CDC Grants 0 0 0 0 0 0 0 N/A Parking revenue shortfall 0 0 0 0 0 0 0 N/A Marketing Communications 44,245 42,928 1,317 difference between what was approved at what was actually paid for two vendors 500,000 500,000 144,602 355,398 28.92% Marketing/Bus. Development 9,150 9,150 0 0 134,715 {1.34, 715) N/A Professional Fees 0 0 0 0 N/A Legal 109,018 109,018 0 600,000 600,000 614,303 114,303) 102.38% Arch/Engineering 28,783 28,783 0 500,000 500,000 433,878 66,122 86.78% Accounting Fees 14,387 14,387 0 400,00D 400,000 260,018 139,982 65.00% Administrative and other 19,349 22,349 l2,19U3 l includes invoice that was approved at meeting for 53,500 that was not on approval sheets 150,000 150,000 81,872 68,128 54.58% Miscellaneous 2,130 2,130 0 550,000 550,000 57,003 492,997 10.36% Debt Service 0 0 0 0 0 N/A "*Non-Pac Debt Service 0 0 3,885,072 3,885,072 2,279,219 1,605,853 58.67% 2005 PAC Lease 0 0 4,920,000 4,920,000 2,460,000 2,460,000 50.00% Contract Purchase Payments 250,936 250,936 0 8,897,795 8,897,795 4,441,000 4,456,795 49.91% TIF Payments/Interest 0 0 0 0 0 0 N/A Total Expenditures 5837,978 5848,672 f, !.,1(:),E'j '?,4 'I. 536,434,587 $36,434,587 520,504,123 $15,930,464 56.28% Current Month Carmel Redeye, ent Commission Month and Year to Dal _venue Budget Analysis For the Month Ending August 31, 2011 Comments Current Year Budget Actual Variance Proposed Adjustments Revi % YTD RECEIPTS: (DR Revenue $0 $0 $0 518,054,793 $18,054,793 511,127,554 56,927,239 51.63% Developer payments 0 0 0 0 0 !.1.„v...7,08) 0 100.00% Other Receipts: 0 0 0 0 Reimbursements 0 0 0 0 4CDC. Grant 930,869 91,623 (839,240) expected to use Lake City funds for work on retrofitting City buildings, but have not received invoices for that yet 7,108,275 7,108,275 5,539,116 1,569,159 77.92% Key Bank 0 0 0 Sales of Assets 0 0 0 0 Parcel 15 - Old Town Shops 11 0 0 0 835,000 835,000 0 835,000 0.00% Parcel 21 - Lurie Building Condos 0 0 0 675,000 675,000 0 575,000 0.00% Parcel 92 - Apostolic Church 0 0 0 1,022,000 1,022,000 0 1,022,000 0.00% Energy consumption payments 40,025 0 (40,0251 invoices have been sent, but no payments have been received yet 240,150 240,150 0 240,150 0.00% Parcel 7a roof repair reimbursement 0 0 0 3,000,000 3,000,000 0 3,000,000 0.00% Parcel 7c-2 revenue 0 0 0 0 0 0 0 N/A Interest 4 3 (1 1 4,000 4,000 23 3,977 0.57% Miscellaneous revenue 50,000 53,885 3,385 reimbursement for Meridian and Main bond closing was estimated on last month's 'forecast 24,063 24,063 1,230,288 1.1206,225 I 5112.78% Total Revenues $1,020,898 5145,511 (5820,222) 530,963,281 $30,963,281 $8,534,625 522,428,656 27.56% I. Key Bank is drawn from to pay for Office Building One expenditures, which were not budgeted. These draws were also not budgeted. 2 Miscellaneous revenue received has been much higher than budgeted because we did not anticipate bond closings this year. July2011 Camel (CERN Lommosion (WARM Vert . .(11 2011 2.3,32222. OPERATING BALANCE 4.,C.Granct ILLIA CIA RE. Walls SarRofEEN3L (Enter MEM :=21MMI ■=1=11E■1 Mlil=========101IMM=11 ■■■■ Mia!3:11=1■BESEI■ilEREM■MM 111 9.,9. M=31. 535.000 }=MilMill.iiiiillarn .111=1 ■EBEI!!MI =1E111■311BEI EA2. 131/ G IL MIEM IMIMIMM . I74 (1,467,o2, MIIMMI M iffailM=MilMilin==aill mil PuLal 21 L(...nr, Cu.. f ropy con:GEAR:2m .2(el . r.2 rearnarsement ERNA ....LON (SuNS IIII= 1=IIMMIMMI 1.11 IIME=1=11.111=1=MIMI .:ZIC ■1■1 ■1■1■I■11 ,,,■ ■IMIN1 .31=111.=■=11===1=i11=■ ((rod .22 reva.a int(33LL MILLellsn.A roNnue IMEIIMI OR. IMENSOMIIMMIE 2.2.Z IMZI MIIWIMEMIMMMI'''''' KIIMMIMMMI IIII. 1,3,2 LLIS Tsui Rovenu. s3,MA $1,(9R293 NZREI,. 0,0E21 MMINIE=111MA=IM:91111=111ZI II —-- Elill. EIM=1=111 IIMIIIMI 11.1M/IMENIMBIliEUSEIE MORO $25 GOO 1,022,000 2.10.1S0 (,(00 090 EXPENDITURES, Lard AOIL.NA. artl Laa.2 20.000 Inal ..3111013 ilailME111 NIIEMEI IOC. EDEI MellIMUIZSI 111.1M1 , .0 ISZEIDEMETI IBEIMilla EEMIE ,4-,75 0 MgMl.3:31311MIZIEMIS=1MIZEI III EITII=,, ., 11E1 Millinni 3.05 ffEl IIIMMIEfil 11321.11MEM=31IMMIMIMIMMIEMIEEii ■ICIEI■110111■EITE■111513 IMIMMI■KII■SEM■113311■11189 1■311:1 69,n ■M1111111■131931113II■MINEDI ■■■IIIIIWa■■■1 SNARE MOM 31,S. IIMEIIIMMIZEIMIZEI=E =32/ 42,301 .21,00 IIKEHME=IIMEIMEN (0.0(0 $00,.0 9..0. Millal■311■1311■iiii1=17111E1111111°31 moo ■CEIMI■IMMIirMEI 7 06,120 L :1°2C2':, 1:1=1 IISIMIIIESI■Mil■IMILMH,r, ■11121■1111111 moo IIIM■Mlanzal=iii■=1•111111 ,umn ■Il ■IM=11 MiEfffi■IMIEI ■IESIZI■IMEI IIIMII MOM ■•■■■■ s16.s35 $6,789,090 ELMS. RarEs1 10 NILE.. PR, 113.11 Prsparts Pars.2( 132., Ascovnti.,e, AdmirdArativ.r. 19..0 MITE111:111113=11 2=0 REM( 12.11 LOW MOO 3.23 24,72. 3E7. Lang., 23150.000 GERM, (MOOR 2.31 30.00 2000 90400 MOW 12.13,0222 1,a23.133 1,531,2.0 ;GODS SMOG( 275.000 335,000 2,981,000 ,n.coo EDO (ow. 41,220 99,41$ 21,5 a Pa( 110,692 $2,634,41( ENDINIO OPERATING SAIANCE $2,19a,70 $(70,SES 532 SSG St."1,08( $ ,O77 $030,5721 LULA IS, LES SG, 2 4 NIS .G3,2SRLISS $36A34,5” (ERMA. 3.122,ARS1 Current Month Carmel Redevei ront Commission Month and Year to Date nditure Budget Analysis For the Month Ending July 31, 2011 Comments Current Year Budget Budget Actual $ Variance EXPENDITURES, YTD Proposed Adjustments Revised YTD $ Remaining Recognized Land AcquiStiOns and leases Energy Center 50 55,575,000 55,575,000 50 55,575,000 0.09% Parcel 7 other final expenses 51,179 51,179 0 500,000 500,000 146,715 353,285 29.34% Parcel 7 streetscape 0 0 0 0 0 N/A Other land acquisitions and Ioos 0 100,000 100,000 0 100,000 0.00% Other construction 5,865 5,855 0 350,000 350,000 121,009 228,991 34.57% Parcels 48,11 Interest Fees 0 38,720 38,720 0 38,720 0.00% Parcel 6 City Center 20,396 20,396 0 2,450,000 2,450,000 569,960 1,880,040 23.26% Parcel 9-28 Part/Time 19,000 19,000 0 228,000 258,000 133,000 95,000 58.33% Parcel 9-31 Chaos- land acquisition 2,436 2,436 0 30,000 30,000 17,052 12,948 56.84% Parcel 10 Shapiros 1,000 1,000 0 90,000 90,000 12,000 78,000 13.33% Parcels 14 Harrill Property Purchase 10,000 10,000 0 118,000 118,000 70,000 48,000 59.32% Parcel 47 Arts District Lofts and Shoppes 442,908 783,662 (740,754) 0340,714 invoice for Gibraltar was added to agenda to approve after approval sheets were created 1,521,009 1,521,000 1,427,877 93,123 93.880 Parcel 73 Streetscape 0 500,000 500,000 1,037 498,963 0.21% Leases: 073, CRC Woodsvvire, 8-1 41,449 33,373 8,076 difference was paid in June 375,000 375,000 241,598 133,402 64.430 Construction Projects: RPAC 118,378 390,817 P77„437) 9272,470 worth of invoices that were paid by dey Bank transfer 2,981,000 2,981,000 5,438,508 (i1.497,5719) 182.440 PAC Consultant Bills 40,530 40,530 0 375,000 375,000 367,606 7,394 98.030 Operations and Maint. Operations 132,883 136,569 13,996) approximately 927,800 worth of invoices were already paid 0 June, and a 531,500 invoice was paid M Ally (electric bill) but won't be approved until AllgUSI, 800,000 800,000 682,160 117,840 85.27% 4000 Grants 0 0 0 0 0 N/A Parking revenue shortfall 0 0 0 9 0 N/A Marketing Commu ni cad blIS 38,607 36,729 1,878 two approval lams were accidentally not paid until after August iSt and one invoice was paid 0 June 500,000 500,000 101,674 398,326 20.330 Marketing/Bus. Development 20,674 19,132 1,542 one approvalltern was listed 4011,000 more than It should have been and was corrected when check was cut, and $300 invoice was paid in June 0 125,565 (105,1(15) N/A Professional Fees 0 0 0 N/A Legal 143,414 143,414. 0 600,000 600,000 509,285 94,715 84,210 Arch/Engineering 31,503 31,503 0 500,000 500,000 405,095 54,905 81.02% Accounting Fees 19,548 19,548 0 400,000 400,000 245,631 154,369 61.41% Administrative and other 5,877 6,377 I500) 3100 invoice was paid in 1015, but won't be approved until August 150,000 150,000 59,523 90,477 39.680 Miscella neous 14,298 14,298 0 550,000 550,000 54,873 495,127 9.98% Debt Service 0 0 0 0 N/A "000-P9c Debt Service 1,124,121 1,124,121 0 3,885,072 3,885,072 2,279,219 1,605,853 58.670 2005 PAC Lease 0 4,920,000 4,920,000 2,460,000 2,460,000 50,000 Contract Purchase Payments 1,833,284 2,065,120 I:dill ,936) difference is amount automatically drawn from our account by Regions for installment purchase obligations, which was accounted for in last 0,0003 analysis 8,897,795 8,897,795 4,190,064 4,797,731 47,090 TIO Payments/Interest 0 0 0 0 D N/A. 536,434,587 536,434,587 519,551,451 $16,779,136 53,95%