|
<br />CITY OF CENTERVILLE, MINNESOTA
<br />CASH FLOW ANALYSIS
<br />GENERAL OBLIGATION IMPROVEMENT BONDS OF 2002 (MS 429)
<br />AMOUNT, $635,000
<br />
<br />(A)
<br />
<br />(B)
<br />
<br />(C)
<br />
<br />(D)
<br />
<br />(E)
<br />
<br />(F)
<br />
<br />(G)
<br />
<br />(II)
<br />
<br />(I)
<br />
<br />(J)
<br />
<br />(I<)
<br />
<br />(L)
<br />
<br />(M)
<br />
<br />(N)
<br />
<br />. '><<<>i'li>j,lI'f)e~tseryicePlly~niS:><>>>' . . . . . . < < < Reveliiie$oliicO$: < < . ,.......,..,. ............. · CiishFJow( ..............
<br /> ",,"<,".,..
<br /> """"'""'"..
<br /> Cap. Assessment Cumul
<br /> Total Interest Infonnation Tax Interest Annual -ative
<br /> (211) Interest (211 & 811) Debt Statutory 16 Assessment Interest Assessment Levy Income @ Surplus 1 Cash
<br />Year Princioal Rates Interest Service 105.00% Months Principal 8.00% Income Revenue 1.00% Deficit Balance
<br />10/1/2002 0.00 0.00 0.00 29,826.67 .. UNUSED UNDERWRITER'S BOND DISCOUNT . 4,256,00 34,082,67 34,082,67
<br />8/1/2003 18,641.67 18,641.67 IS,641.67 0,00 0,00 0,00 0,00 272,00 (18,369,67) 15,713.00
<br />2/112004 0 0.00% 1l,185,OO 11,185,00 11,744.25 21,916.86 33,286,14 55,203,01 0,00 78,57 43,537.32 59,250,32
<br />S/1/2004 11,185,00 11,IS5,OO 11,744,25 21,916,86 33,2S6,14 55,203.01 0,00 296,25 43,755,01 103,005,33
<br />2/1/2005 55,000 3_00% 11,185,00 66,185.00 69,494.25 23,670,21 31.532_79 55,203,01 0_00 515_03 (13,776.22) 89,229_11
<br />S/I/2OO5 10,360,00 10,360,00 10,878_00 23,670.21 31,532,79 55,203,01 0_00 446,15 44,771.15 134,000_26
<br />2/1/2006 55,000 3_00% 10,360,00 65,360,00 68,628,00 25,563,83 29,639_18 55,203_01 0_00 670,00 (12,754,99) 121,245,27
<br />8/1/2006 9,535_00 9,535_00 10,011.75 25,563,83 29,639,18 55,203,01 0_00 606_23 45,797.48 167,042,76
<br />2/1/2007 55,000 3,00% 9,535,00 64,535,00 67,761.75 27,608,93 27,594,07 55,203_01 0,00 835_21 (11,723.53) 155,319.23
<br />81112007 8,710_00 8,710,00 9,145.50 27,608_93 27,594,07 55,203_01 0_00 776_60 46,834,10 202,153.33
<br />2/112008 60,000 3_00% 8,710_00 68,710_00 72,145.50 29,811,65 25,385,36 55,203_01 0_00 1,010_77 (15,931.73) 186,221.60
<br />8/1/2008 7,810_00 7,810,00 8,200.50 29,817_65 25,385,36 55,203_01 0,00 931.11 47,933_61 234,155.22
<br />2/112009 60,000 3_30% 7,810_00 67,810,00 71,200_50 32,203_06 22,999,94 55,203,01 0_00 1,110_78 (14,826_72) 219,328.50
<br />8/1/2009 6,820_00 6,820,00 7,161.00 32,203_06 22,999_94 55,203_01 0,00 1,096,64 49,138_65 268,467_15
<br />2/1/2010 65,000 3_60% . 6,820_00 71,820_00 75,411.00 34,779,31 20,423_70 55,203_01 0_00 1,342_34 (18,865,66) 249,601.49
<br />8/1/2010 5,650_00 5,650_00 5,932_50 34,779,31 20,423,70 55,203_01 0.00 1,248.ot 50,518_51 300, t2O,00
<br />2/1/2011 70,000 3.75% 5,650,00 75,650,00 79,432_50 37,561.65 17,641-36 55,203_01 0,00 1,500_60 (22,728_89) 277,391.11
<br />8/1/2011 4,337_50 4,33750 4,554,38 37,561.65 11,641-36 55,203.01 0,00 1,386,96 52,035,59 329,426,70
<br />2/1/2012 70,000 4,00% 4,337,50 74,33750 78,054,38 40,566.58 14,636.42 55,203,01 0,00 1,647,13 (21,204,24) 308,222,46
<br />8/1/2012 2,93750 2,937,50 3,084,38 40,566,58 14,636.42 55,203,01 0,00 1,541.\1 53,659,74 361,882_21
<br />2/1/2013 70,000 4,00% 2,93750 72,937,50 76,584.38 43,811.91 11,391.10 55,203,01 0.00 1,809,41 (19,57\'96) 342,310,25
<br />8/1/2013 1,53750 1,53750 1,614_38 43,811.91 11,391.10 55,203,01 0_00 1,711.55 55,300_18 397,610.43
<br />2/1/2014 75,000 4,10% 1,537.50 76,53750 80,364,38 0,00 0_00 0_00 0_00 0,00 (80,364.38) 311,246_06
<br />
<br />635,000
<br />
<br />167,591.67
<br />
<br />802,591.67
<br />
<br />841,789,11
<br />
<br />29,826_67
<br />
<br />635,000_00
<br />
<br />469,060_13 1,104,060_13
<br />
<br />0_00
<br />
<br />25,148.43
<br />
<br />311,246.06
<br />
<br />pbeasant phase 2 10/9/2002
<br />
|