Loading...
HomeMy WebLinkAboutHazel Dell - Penn Road Bond SummaryHazel Dell & Penn Projects 1997 Bond Fifth,Third Bank - original amount of Construction Fund Debt Service Reserve Fund added to Construction Fund after being replaced with insurance policy. Construction Fund Total Remaining in fund 1/16/04 (approx) Expenditures to date Hazel Dell = 80% Penn = 20% $ 26,620,107.70 $ 2,669,901.26 $ 29,290,008.96 $ 3,000,000.00 $ 26,290,008.96 $ 21,032,007.17 $ 5,258,001.79 /eV arid constr. fund CONSTRUCTION FUND ACTIVITY STATEMENT BALANCE DIFFERENCE BOND PROCEEDS $320,000.00 BOND PROCEEDS 526,300,107.01 EXPENSES (518,303.35) cm OF CARMEL (5261,800.00) Cm OF CARMEL (5168,660.00) Cm OF CARMEL (5629,899.41) an OF CARMEL (515,831.00) CITY OF CARMEL (57,158,000.00) cm OF CARMEL (511,179.00) CURTIS L. COONROD (525,515.78) cm of CARMEL (5325,562.28) MILESTONE CONTRACTORS INCOME 5156,971.24 OCT. 31, 1997 518,162,327.43 518,143,287.43 519,040.00 This represents 10131 income not reflected in balance INCOME $57,884.51 INCOME (DDA NOW 55,980.05 NOV. 30, 1997 518,226,191.99 518,226,191.99 50.00 EXPENSES (518,832.71) AMERICAN CONSULTING ENGINEERS (57,242.31) AMERICAN CONSULTING ENGINEERS (526,510.00) AMERICAN CONSULTING ENGINEERS ($9,455.58) AMERICAN CONSULTING ENGINEERS (518,718.38) AMERICAN CONSULTING ENGINEERS ($9,185.) AMERICAN CONSULTING ENGINEERS (561,322.33) AMERICAN CONSULTING ENGINEERS (51,153.00) CURTIS L COONROD ($11,172.40) BARNES 6 THORNBURG (513,898.11) BARNES & THORNBURG (511,193.20) BARNES & THORNBURG (519,833.50) COSMOPOLITAN CONSULTING (516,620.75) COSMOPOLITAN CONSULTING (5697,832.94) MILESTONE CONTRACTORS ($250,037.04) MILESTONE CONTRACTORS INCOME 5106,076.98 INCOME (DDA NOW ACCOUNT) 54,603.31 DEC. 31, 1997 517,163,865.03 517,130,039.57 533,825.46 This represents 12/31 income not reflected in balance Page 1 constr. fund Page 2 ACTIVITY STATEMENT BALANCE DIFFERENCE EXPENSES (5141,566.81) MILESTONE CONTRACTORS (5586.90) US FILTER DISTRIBUTION GROUP ($410.00) US FILTER DISTRIBUTION GROUP (563.36) INDIANAPOLIS NEWSPAPERS (512.00) INDIANAPOLIS NEWSPAPERS (510.49) TOPICS NEWSPAPERS (556.19) TOPICS NEWSPAPERS (516,620.75) COSMOPOLITAN ENGINEERING (57,800.00) COSMOPOLITAN ENGINEERING (56,047.25) COSMOPOLITAN ENGINEERING (51,325.00) AMERICAN CONSULTING ENGINEERS (5552.12) LEE SUPPLY ($5,171.32) SERVICE PIPE E. SUPPLY ($1,500.00) CARMEL UTILmES (529,088.82) AMERICAN CONSULTING ENGINEERS (5283.00) CURBS L. COONROD (57,842.68) BARNES 8 THORNBURG (52,220.00) BARNES & THORNBURG (51,713.50) DEBRA M. GRISHAM (53,317.50) DEBRA M. GRISHAM (51,528.50) DEBRA M. GRISHAM (56,825.00) JOHN R. MOLITOR (51,700.00) JOHN R. MOLROR (520,000.00) AMERICAN CONSULTING ENGINEERS (514,404.65) COSMOPOLITAN ENGINEERING ($577,842.18) MILESTONE CONTRACTORS INCOME 576,057.61 INCOME (DDA NOW ACCOUNT) 5210.42 ADDITIONS 564,582.48 JAN. 31, 1998 516,456,227.52 516,456,227.52 50.00 EXPENSES ($384.76) AMERICAN CONSULTING ENGINEERS INCOME 567,919.31 INCOME (DDA NOW ACCOUNT) L 5109.82 FEB. 28, 1998 516,523,871.89 516,523,871.89 50.00 Page 2 constr. fund Page 3 ACTIVITY STATEMENT BALANCE DIFFERENCE EXPENSES ($601,305.39) MILESTONE CONTRACTORS (518,200.00) COSMOPOLITAN ENGINEERING (56,500.00) COSMOPOLITAN ENGINEERING ($33,618.45) COSMOPOLITAN ENGINEERING (556,732.06) AMERICAN CONSULTING ENGINEERS ($57,895.00) AMERICAN CONSULTING ENGINEERS ($200.00) AMERICAN CONSULTING ENGINEERS ($59,830.00) AMERICAN CONSULTING ENGINEERS ($1,359,942.47) MILESTONE CONSTRACTORS INCOME $54,996.51 INCOME (DDA NOW ACCOUNT) $0.00 ADDITIONS 5712,617.53 ASSET WRITE OFF ($692,871.89) MARCH. 31, 1998 514,404,390.67 514,404,390.67 $0.00 EXPENSES (52,103.85) BARNES& THORNBURG ($267.50) BARNES & THORNBURG ($69,966.85) AMERICAN CONSULTING ENGINEERS ($534,357.00) MILESTONE CONTRACTORS ($6,878.70) SUNDOWN GARDENS INCOME 526,205.78 515,394.42 CD PURCHASE ADJ ($150,000.00) APRIL 30, 1998 513,682,416.97 513,682,416.97 50.00 EXPENSES (517,748.50) COSMOPOLITAN ENGINEERING ($10,365.00) AMERICAN CONSULTING ENGINEERS ($66,857.75) AMERICAN CONSULTING ENGINEERS ($934.20) BARNES & THORNBURG (52,644.61) SUNDOWN GARDENS - (57,410.00) COSMOPOLITAN ENGINEERING ($9,718.65) COSMOPOLITAN ENGINEERING ($4,656.00) OAIWIEW AssocwTEs INCOME $4,187.22 $429.52 CD ADJUSTMENT ($700,000.00) CD PROCEEDS $700,000.00 MAY. 31, 1998 513,566,699.00 513,566,699.00 50.00 Page 3 constr. fund Page 4 ACTIVITY STATEMENT BALANCE DIFFERENCE EXPENSES (51,593, .09) MILESTONE CONTRACTORS (574,697.31) AMERICAN CONSULTING ENGINEERS (562.50) BARNES & THORNBURG INCOME 5124,146.44 CD ADJUSTMENT 5150,000.00 JUNE. 30, 1998 512,172,585.54 $12,172,585.54 50.00 ACTIVITY STATEMENT BALANCE DIFFERENCE EXPENSES (568,051.36) AMERICAN CONSULTING ENGINEERS (521,412.50) COSMOPOLITAN CONSULTING (559.45) TOPICS NEWSPAPERS (571.06) INDLANAPOUS NEWSPAPERS (577.87) INDNNAPOUS NEWSPAPERS (5103,684.89) SUNDOWN GARDENS (5499,813.21) MILESTONECONTRACTORS (59,697.60) HAMILTON COUNTY TREASURER (5401,851.33) MILESTONE CONTRACTORS (53,150.00) AMERICAN CONSULTING ENGINEERS (52,805.00) AMERICAN CONSULTING ENGINEERS (565,098.49) AMERICAN CONSULTING ENGINEERS INCOME 514,776.95 JULY. 31, 1992 $11,011,389.73 511,011,389.73 50.00 ACTIVITY STATEMENT BALANCE DIFFERENCE EXPENSES (5548,814.66) MILESTONE CONTRACTORS INCOME 548,677.20 CD INTEREST ' POSTED INCORRECTLY 555,711.11 AUGUST. 31, 1998 510,566,963.18 510,566963.18 50.00 Page 4 Vendor Payment Sumary CITY OF CARMEL REDEVELOPMENT AUTHORITY COUNTY OPTION INCOME TAX REVENUE BONDS SERIES 1997 VENDOR PAYMENT SUMMARY VENDOR NAME Underwriter City of Carmel Curtis Coonrod Milestone Contractors American Consulting Engineers Cosmopolitan Consulting Barnes & Thornburg US Filter Distr. Sep -97 $400,000.00 Oct -97 * $8,278,009.54 $11,179.00 $325,562.28 Nov -97 Dec -97 $1,153.00 $947,869.98 $151,266.31 $36,454.25 $36,263.71 Jan -98 $283.00 $719,408.99 $50,413.82 $44,872.65 $10,062.68 $996.90 Adj for spend -down calculation ($7,158,000.00) Total for spend -down $400,000.00 $1,120,009.54 $12,615.00 $1,992,841.25 $201,680.13 $81,326.90 $46,326.39 $996.90 Feb -98 $384.75 Mar -98 $1,961,247.86 $174,657.06 $58,318.45 Apr -98 $534,357.00 $69,966.85 $2,371.35 May -98 $77,222.75 $34,877.15 $934.20 Jun -98 $1,593,500.09 $74,697.31 $62.50 Jul -98 $901,664.54 $139,104.85 $21,412.50 Aug -98 $548,814.86 Sep -98 $713,358.44 $66,102.86 $1,210.00 Total for spend -down $400,000.00 $1,120,009.54 $12,615.00 $8,245,784.04 $803,816.56 $197,145.00 549,694.44 $996.90 Oct -98 Nov -98 Dec -98 TOTAL $400,000.00 $2,240,019.08 $25,230.00 $16,491,568.08 $1,607,633.12 $394,290.00 $99,388.88 $1,993.80 ` Includes $7,158,000 paid as real estate purchase Total for 1st qtr spend -down test $3,944,185.93 Total for 2nd qtr spend -down test $11,046,421.48 _ Page 1