|
Projected Pay-As-You-Go Note Report
<br /> City of Elk River,Minnesota
<br /> Tax Increment Financing(Housing)District No.24
<br /> Blackhawk Woods Senior Housing Project
<br /> Preliminary TIF Projections:84-unit Townhomes 4d classification
<br /> Note Date: 12131/13
<br /> Note Rate: 4.70%
<br /> Amount: $996,871
<br /> Cumulative Unpaid Semi-Annual Loan
<br /> Interest Accrued Net Balance
<br /> Date Principal Interest P&I Due Interest Revenue Outstanding
<br /> (1) (2) (3) (4) (5) (6) (1) (8)
<br /> 996,871.00
<br /> 02/01/14 0.00 0.00 0.00 3,904.41 3,904.41 0.00 996,871.00
<br /> 08/01/14 0.00 0.00 0.00 27,330.88 27,330.88 0.00 996,871.00
<br /> 02/01/15 0.00 0.00 0.00 50,757.35 50,757.35 0.00 996,871.00
<br /> 08/01/15 0.00 0.00 0.00 74,183.82 74,183.82 0.00 996,871.00
<br /> 02101/16 0.00 0.00 0.00 97,61029 97,61029 0.00 996,871.00
<br /> 08/01/16 0.00 27,985.00 27,985.00 121,036.76 93,051.76 27,985.00 996,871.00
<br /> 02101/17 0.00 27,985.00 27,985.00 116,47823 88,49323 27,985.00 996,871.00
<br /> 08/01/17 0.00 40,696.00 40,696.00 111,919.70 71,223.70 40,696.00 996,871.00
<br /> 02101/18 0.00 40,696.00 40,696.00 94,650.17 53,954.17 40,696.00 996,871.00
<br /> 08/01/18 0.00 40,696.00 40,696.00 77,380.64 36,684.64 40,696.00 996,871.00
<br /> 02101/19 0.00 40,696.00 40,696.00 60,111.11 19,415.11 40,696.00 996,871.00
<br /> 08/01/19 0.00 40,696.00 40,696.00 42,841.58 2,145.58 40,696.00 996,871.00
<br /> 02101/20 15,123.95 25,572.05 40,696.00 25,572.05 0.00 40,696.00 981,747.05
<br /> 08/01/20 17,624.94 23,071.06 40,696.00 23,071.06 0.00 40,696.00 964,122.11
<br /> 02101/21 18,039.13 22,656.87 40,696.00 22,656.87 0.00 40,696.00 946,082.98
<br /> 08/01/21 18,463.05 22,232.95 40,696.00 22,232.95 0.00 40,696.00 927,619.93
<br /> 02101/22 18,896.93 21,799.07 40,696.00 21,799.07 0.00 40,696.00 908,723.00
<br /> 08/01/22 19,341.01 21,354.99 40,696.00 21,354.99 0.00 40,696.00 889,381.99
<br /> 02101/23 19,795.52 20,900.48 40,696.00 20,900.48 0.00 40,696.00 869,586.47
<br /> 08/01/23 20,260.72 20,43528 40,696.00 20,43528 0.00 40,696.00 849,325.75
<br /> 02101/24 20,736.84 19,959.16 40,696.00 19,959.16 0.00 40,696.00 828,588.91
<br /> 08/01/24 21,224.16 19,471.84 40,696.00 19,471.84 0.00 40,696.00 807,364.75
<br /> 02101/25 21,722.93 18,973.07 40,696.00 18,973.07 0.00 40,696.00 785,641.82
<br /> 08/01/25 22,233.42 18,462.58 40,696.00 18,462.58 0.00 40,696.00 763,408.40
<br /> 02101/26 22,755.90 17,940.10 40,696.00 17,940.10 0.00 40,696.00 740,652.50
<br /> 08/01/26 23,290.67 17,405.33 40,696.00 17,405.33 0.00 40,696.00 717,361.83
<br /> 02101/27 23,838.00 16,858.00 40,696.00 16,858.00 0.00 40,696.00 693,523.83
<br /> 08/01/27 24,398.19 16,297.81 40,696.00 16,297.81 0.00 40,696.00 669,125.64
<br /> 02101/28 24,971.55 15,724.45 40,696.00 15,724.45 0.00 40,696.00 644,154.09
<br /> 08/01/28 25,558.38 15,137.62 40,696.00 15,137.62 0.00 40,696.00 618,595.71
<br /> 02101/29 26,159.00 14,537.00 40,696.00 14,537.00 0.00 40,696.00 592,436.71
<br /> 08/01/29 26,773.74 13,92226 40,696.00 13,92226 0.00 40,696.00 565,662.97
<br /> 02101/30 27,402.92 13,293.08 40,696.00 13,293.08 0.00 40,696.00 538,260.05
<br /> 08/01/30 28,046.89 12,649.11 40,696.00 12,649.11 0.00 40,696.00 510,213.16
<br /> 02101/31 28,705.99 11,990.01 40,696.00 11,990.01 0.00 40,696.00 481,507.17
<br /> 08/01/31 29,380.58 11,315.42 40,696.00 11,315.42 0.00 40,696.00 452,126.59
<br /> 02101/32 30,071.03 10,624.97 40,696.00 10,624.97 0.00 40,696.00 422,055.56
<br /> 08/01/32 30,777.69 9,918.31 40,696.00 9,918.31 0.00 40,696.00 391,277.87
<br /> 02101/33 31,500.97 9,195.03 40,696.00 9,195.03 0.00 40,696.00 359,776.90
<br /> 08/01/33 32,24124 8,454.76 40,696.00 8,454.76 0.00 40,696.00 327,535.66
<br /> 02101/34 32,998.91 7,697.09 40,696.00 7,697.09 0.00 40,696.00 294,536.75
<br /> 08/01/34 33,774.39 6,921.61 40,696.00 6,921.61 0.00 40,696.00 260,762.36
<br /> 02101/35 34,568.08 6,127.92 40,696.00 6,127.92 0.00 40,696.00 226,19428
<br /> 08/01/35 35,380.43 5,315.57 40,696.00 5,315.57 0.00 40,696.00 190,813.85
<br /> 02101/36 36,211.87 4,484.13 40,696.00 4,484.13 0.00 40,696.00 154,601.98
<br /> 08/01/36 37,062.85 3,633.15 40,696.00 3,633.15 0.00 40,696.00 117,539.13
<br /> 02101/37 37,933.83 2,762.17 40,696.00 2,762.17 0.00 40,696.00 79,605.30
<br /> 08/01/37 38,82528 1,870.72 40,696.00 1,870.72 0.00 40,696.00 40,780.02
<br /> 02101/38 39,737.67 958.33 40,696.00 958.33 0.00 40,696.00 1,042.35
<br /> 08/01/38 1,042.35 24.50 1,066.85 24.50 0.00 1,066.85 0.00
<br /> 02101/39 0.00 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 08/01/39 0.00 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 02101/40 0.00 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 08/01/40 0.00 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 02101/41 0.00 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 08/01/41 0.00 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 02101/42 0.00 0.00 0.00 0.00 0.00 0.00 0.00
<br /> $996,871 $769,397.85 $1,766,268.85 $618,754.94 $1,766,268.85
<br /> Surplus Tax Increment 324,501.15
<br /> Total Net Revenue $2,090,770.00
<br /> Public Sector Advisors
<br />
|