|
City of Pequot Lakes,Minnesota
<br /> Cash Flow Analysis/Debt Service Schedule EpH L ErR S
<br /> (Financing Industrial Park Improvement Bonds)
<br /> Shelly Eldridge/Sid Inman
<br /> Financial Advisors
<br /> 651-697-8504/8507
<br /> 1-800-552-1171
<br /> Sale Details General Obligation Improvement Bonds,Series 2004 Special Assessments
<br /> Sale 14OW Per Amount of Bonds 405,000 Amount(4 lots at$25,000) 100,000
<br /> Estimated Closing 29-Mey Total Sources 405,000 Rate(2%over bond rate) 6.80%
<br /> Dated 50PB129e4 Term 10
<br /> tat Interest 2/1/2005 Total Underwriters Discount (1.500%) 6,075 Start Year(Levy/Collect) 2004/2005
<br /> Interest Feb/Aug Costs Of Issuance 10,000 Assessed/Project 26%
<br /> Deposit to Capitalized Interest(CIF)Fund 0 Assessed/Bond Issue 25%
<br /> Construction Costs 385,004• Calculation Method Equal P81
<br /> Rounding Amount 3,921
<br /> Total Uses 405,000
<br /> Principal Needed From
<br /> Levy Collect Payment Bond Bond Bond Total Total Assmt Assmt Total TIF Land Sale No Lots Land Sale Annual Cummulative
<br /> Year Year Date Principal Rate Interest P 81 +5.00% Principal Interest Revenue Revenue- Revenue to Sell Revenue Over/(short) Over/(short)
<br /> 7/1/2004
<br /> 2003 2004 2/1/2005 12,960 12,960 13,608 9,932 (3,676) (3,676)
<br /> 2004 2005 2/1/2006 30,000 4.80% 19,440 49,440 51,912 (7,306) (6,800) (14,106) 9,932 37,805.59 Lot 4 BI 3 48,600 20,726 17,050
<br /> 2005 2006 2/1/2007 35,000 4.80% 18,000 53,000 55,650 (7,803) (6,303) (14,106) 9,932 41,543.59 Lot BI 53,400 21,788 38,839
<br /> 2006 2007 2/1/2008 35,000 4.80% 16,320 51,320 53,886 (8,334) (5,773) (14,106) 9,932 39,779.59 (29,848) 81991
<br /> 2007 2008 2/1/2009 35,000 4.80% 14,640 49,640 52,122 (8,901) (5,206) (14,106) 9,932 38,015.59 Lot BI 48,900 20,816 29,808
<br /> 2008 2009 2/1/2010 40,000 4.80% 12,960 52,960 55,608 (9,506) (4,601) (14,106) 9,932 41,501.59 Lot 1 BI 2 55,500 23,930 53,738
<br /> 2009 2010 2/1/2011 40,000 4.80% 11,040 51,040 53,592 (10,152) (3,954) (14,106) 8,074 39,485.59 (31,412) 22,326
<br /> 2010 2011 2/1/2012 45,000 4.80% 9,120 54,120 56,826 (10,843) (3,264) (14,106) 42,719.59 Lott BI 52,200 9,480 31,807
<br /> 2011 2012 211/2013 45,000 4.80% 6,960 51,960 54,558 (11,580) (2,527) (14,106) 40,451.59 Lot 3 BI 2 52,200 11,748 43,555
<br /> 2012 2013 2/1/2014 50,000 4.80% 4,800 54,800 57,540 (12,367) (1,739) (14,106) 43,433.59 (43,434) 121
<br /> 2013 2014 2/1/2015 50,000 4.80% 2,400 52,400 55,020 (13,208) (898) (14,106) 40,913.59 Lot 812 52,500 11,586 11,708
<br /> 405,000 128,640 533,640 560,322 (100,000) (41,064) (141,064) 67,666 T05,850 363,300 11.708
<br /> Includes engineering,administration,and contingency.
<br /> " 90%of District 1-8 and 1-10 based on P2003 collections.
<br /> Prepared by )d Associates.Inc. Estimate. )1/2004
<br />
|