|
Projected Pa -As-You-Go Note Re ort
<br /> City of Hugo,Minnesota
<br /> Tax Increment Financing(Redevelopment)District No.1-2
<br /> Carpenters Steakhouse Redevelopment Project
<br /> SCEN 2:$2.OM Total EMV-15 years-1.25%MV Inflator
<br /> Note Date: 06/30/09
<br /> Note Rate: 8.00%
<br /> Amount: $148,800
<br /> Semi-Annual Loan
<br /> Net Capitalized Balance
<br /> Date Principal Interest P&I Revenue Interest Outstanding
<br /> (1) (2) (3) (4) (5) (6) (7)
<br /> 148,800.00
<br /> 02/01/10 0.00 0.00 0.00 0.00 6,977.07 155,777.07
<br /> 08/01/10 0.00 0.00 0.00 0.00 6,231.08 162,008.15
<br /> 02/01/11 0.00 0.00 0.00 0.00 6,480.33 168,488.48
<br /> 08/01/11 0.00 5,330.00 5,330.00 5,330.00 1,409.54 169,898.02
<br /> 02/01/12 0.00 5,330.00 5,330.00 5,330.00 1,465.92 171,363.94
<br /> 08/01/12 2,388.44 6,854.56 9,243.00 9,243.00 0.00 168,975.50
<br /> 02/01/13 2,483.98 6,759.02 9,243.00 9,243.00 0.00 166,491.52
<br /> 08/01/13 2,773.34 6,659.66 9,433.00 9,433.00 0.00 163,718.18
<br /> 02/01/14 2,884.27 6,548.73 9,433.00 9,433.00 0.00 160,833.91
<br /> 08/01/14 3,192.64 6,433.36 9,626.00 9,626.00 0.00 157,641.27
<br /> 02/01/15 3,320.35 6,305.65 9,626.00 9,626.00 0.00 154,320.92
<br /> 08101/15 3,648.16 6,172.84 9,821.00 9,821.00 0.00 150,672.76
<br /> 02/01/16 3,794.09 6,026.91 9,821.00 9,821.00 0.00 146,878.67
<br /> 08/01/16 4,143.85 5,875.15 10,019.00 10,019.00 0.00 142,734.82
<br /> 02/01/17 4,309.61 5,709.39 10,019.00 10,019.00 0.00 138,425.21
<br /> 08/01/17 4,681.49 5,537.01 10,218.50 10,218.50 0.00 133,743.72
<br /> 02/01/18 4,868.75 5,349.75 10,218.50 10,218.50 0.00 128,874.97
<br /> 08/01/18 5,266.00 5,155.00 10,421.00 10,421.00 0.00 123,608.97
<br /> 02/01/19 5,476.64 4,944.36 10,421.00 10,421.00 0.00 118,132.33
<br /> 08/01/19 5,901.21 4,725.29 10,626.50 10,626.50 0.00 112,231.12
<br /> 02/01/20 6,137.26 4,489.24 10,626.50 10,626.50 0.00 106,093.86
<br /> 08/01/20 6,589.75 4,243.75 10,833.50 10,833.50 0.00 99,504.11
<br /> 02/01/21 6,853.34 3,980.16 10,833.50 10,833.50 0.00 92,650.77
<br /> 08/01/21 7,337.97 3,706.03 11,044.00 11,044.00 0.00 85,312.80
<br /> 02/01/22 7,631.49 3,412.51 11,044.00 11,044.00 0.00 77,681.31
<br /> 08/01/22 8,149.75 3,107.25 11,257.00 11,257.00 0.00 69,531.56
<br /> 02/01/23 8,475.74 2,781.26 11,257.00 11,257.00 0.00 61,055.82
<br /> 08/01/23 9,030.27 2,442.23 11,472.50 11,472.50 0.00 52,025.55
<br /> 02/01/24 9,391.48 2,081.02 11,472.50 11,472.50 0.00 42,634.07
<br /> 08101/24 9,985.14 1,705.36 11,690.50 11,690.50 0.00 32,648.93
<br /> 02/01/25 10,384.54 1,305.96 11,690.50 11,690.50 0.00 22,264.39
<br /> 08/01/25 11,020.92 890.58 11,911.50 11,911.50 0.00 11,243.47
<br /> 02/01/26 11,243.47 449.74 11,693.21 11,693.21 0.00 0.00
<br /> 08/01/26 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 02/01/27 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 08/01/27 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 02101/28 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 08/01/28 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 02/01/29 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 08/01/29 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 02/01/30 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 08/01/30 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 02/01/31 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 08/01/31 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 02/01/32 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 08/01/32 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 02/01/33 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 08/01/33 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 02/01/34 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 08/01/34 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 02/01/35 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 08/01/35 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 02/01/36 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 08/01/36 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 02/01/37 0.00 0.00 0.00 0.00 0.00 0.00
<br /> $171,364 $134,311.77 $305,675.71 $305,675.71 $22,563.94
<br /> Surplus Tax Increment 218.29
<br /> Total Net Revenue $305,894.00
<br /> Prepared by:Springsted Incorporated(printed on 4/30/2009 at 12:45 PM) Hugo TIF 1-2 Carpenters 15 Yr Term 043009.xis
<br />
|