|
1(
<br /> City of Pequot Lakes,Minnesota
<br /> Cash Flow Analysis/Debt Service Schedule
<br /> (Financing Industrial Park Improvement Bonds)
<br /> REVISED 10/15)2004
<br /> Sale Details
<br /> 242,855
<br /> General Obligation Improvement Bonds,Series 2004
<br /> Sale
<br /> 5-Oct
<br /> Par Amount of Bonds
<br /> 340,000
<br /> Estimated Closing
<br /> 27-Oct
<br /> Total Sources
<br /> 340,000
<br /> Dated
<br /> 10/27/2004
<br /> 75%
<br /> Assessed/BondIssue
<br /> 1st Interest
<br /> 8/1/2005
<br /> Total Underwriter's Discount (1.500%)
<br /> 4,080
<br /> Interest
<br /> Feb/Aug
<br /> Costs of Issuance
<br /> 9,832
<br /> Assmt
<br /> Asamt
<br /> Deposit to Capitalized Interest(CIF)Fund
<br /> 0
<br /> Needed From Land Sal
<br /> No
<br /> Construction Costs
<br /> 322,721
<br /> Rounding Amount
<br /> 3,367
<br /> Total Uses
<br /> 340,000
<br /> Special Assessments
<br /> Amount
<br /> 242,855
<br /> Deferred
<br /> 138,407
<br /> Assessed
<br /> 104,448
<br /> Rate(2%over bond rate)
<br /> 6.07%
<br /> Term
<br /> 10
<br /> Start Year(Levy/Collect)
<br /> 2004/2005
<br /> Assessed/Project
<br /> 75%
<br /> Assessed/BondIssue
<br /> 71%
<br /> Calculation Method
<br /> Equal P&I
<br /> A
<br /> 19 I
<br /> 16 ASSOCIATES INC
<br /> Shelly Eldridge/Sid Inman
<br /> Financial Advisors
<br /> 651.697-8504/8507
<br /> 1-800-552.1171
<br /> Prepared by Ehlers&Associates,Inc.
<br /> Estimates Only
<br /> 10/15/2004
<br /> Principal
<br /> Levy
<br /> Year
<br /> Collect
<br /> Year
<br /> Payment
<br /> Date
<br /> Bond Bond
<br /> Principal Rate
<br /> Bond
<br /> Interest
<br /> Total
<br /> P&I
<br /> Total
<br /> Assmt
<br /> Asamt
<br /> Total
<br /> TIF
<br /> Needed From Land Sal
<br /> No
<br /> 7/1/2004
<br /> +5.00%
<br /> Principal
<br /> Interest
<br /> Revenue
<br /> Revenue-
<br /> Re enuee
<br /> Sell
<br /> Re enuee
<br /> Over/(short)
<br /> O er/short)
<br /> 2003
<br /> 2004
<br /> 2/1/2005
<br /> 2004
<br /> 2005
<br /> 2005
<br /> 2006
<br /> 2/1/2006
<br /> 2/1/2007
<br /> 25,000 2.10%
<br /> 30,000 2.40%
<br /> 15,300
<br /> 11,608
<br /> 40,300
<br /> 41,608
<br /> 42,315
<br /> 43,688
<br /> (7,898)
<br /> (6,340)
<br /> (14,238)
<br /> 9,932
<br /> 9,932
<br /> 13,838.98
<br /> Lot 4Bl3
<br /> 48,600
<br /> 9,932
<br /> 30,455
<br /> 9,932
<br /> 2006
<br /> 2007
<br /> 2/1/2008
<br /> 30,000 3.00%
<br /> 10,888
<br /> 40,888
<br /> 42,932
<br /> (8,378)
<br /> (8,886)
<br /> (5,861)
<br /> (5,352)
<br /> (14,238)
<br /> 9,932
<br /> 15,211.40
<br /> (19,518)
<br /> 40,387
<br /> 20,869
<br /> 2007
<br /> 2008
<br /> 2008
<br /> 2009
<br /> 2/1/2009
<br /> 30,000 3.25%
<br /> 9,988
<br /> 39,988
<br /> 41,987
<br /> (9,426)
<br /> (4,813)
<br /> (14,238)
<br /> (14,238)
<br /> 9,932
<br /> 9,932
<br /> 14,455.40
<br /> (35,583)
<br /> 2009
<br /> 2010
<br /> 2/1/2010
<br /> 2/1/2011
<br /> 30,000 3.50%
<br /> 35,000 4.00%
<br /> 9,013
<br /> 39,013
<br /> 40,963
<br /> (9,998)
<br /> (4,241)
<br /> (14,238)
<br /> 9,932
<br /> 13,510.40
<br /> 12,486.65
<br /> Lot 3 BI 1
<br /> 53,400
<br /> 37,6918
<br /> 2010
<br /> 2011
<br /> 2/1/2012
<br /> 35,000 4.00%
<br /> 7,963
<br /> 6,563
<br /> 42,963
<br /> 41,563
<br /> 45,111
<br /> 43,641
<br /> (10,605)
<br /> (11,248)
<br /> (3,634)
<br /> (14,238)
<br /> 8,074
<br /> 16,634.15
<br /> Lot 814
<br /> 48,900
<br /> (26,101)
<br /> 46,999
<br /> 2011
<br /> 2012
<br /> 2012
<br /> 2013
<br /> 2/1/2013
<br /> 40,000 4.00%
<br /> 5,163
<br /> 45,183
<br /> 47,421
<br /> (11,931)
<br /> (2,990)
<br /> (2,307)
<br /> (14,238)
<br /> 238)
<br /> (14,238)
<br /> 15,164.15
<br /> (29,402)
<br /> 17,517
<br /> 2013
<br /> 2014
<br /> 2/1/2014
<br /> 2/1/2015
<br /> 40,000 4.125%
<br /> 3,563
<br /> 43,563
<br /> 45,741
<br /> (12,655)
<br /> (1,583)
<br /> (14,
<br /> 18,944.15
<br /> 17,264.15
<br /> Lot 1 BI 2
<br /> 55,500
<br /> 22,318
<br /> 39,915
<br /> 45,000 4.25%
<br /> 1,913
<br /> 46,913
<br /> 46,913
<br /> (13,423)
<br /> (815)
<br /> (14,238)
<br /> 18,436.02
<br /> Lott 812
<br /> 52,200
<br /> (31,502)
<br /> 8,412
<br /> 19,526
<br /> 27,938
<br /> 340,000
<br /> 81,958
<br /> 421,958
<br /> _440,71 0
<br /> 104 448
<br /> 37 934
<br /> 142 382
<br /> 67 666
<br /> 155.945
<br /> ' Includes engineering,
<br /> administration,
<br /> end contingency.
<br /> 258,600
<br /> 27 938
<br /> " 90%of
<br /> District 1-8 and 1-10 based on P2003 collections.
<br /> Prepared by Ehlers&Associates,Inc.
<br /> Estimates Only
<br /> 10/15/2004
<br />
|