Hazel 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