|
Exhibit VI
<br />Pro'ected Pa -As-You-Go Note Re ort
<br />City of Roseville, Minnesota
<br />Tax Increment Financing (Housing) District No. 18
<br />Proposed Har Mar Apartments Project
<br />TIF Plan Exhibits: $12.2M EMV - Full 25+years
<br />Note Date: 02/01/10
<br />Note Rate: 4.50 %
<br />Amount: $913,610
<br />Semi-Annual Loan
<br />Net Capitalized Balance
<br />Date Principal Interest P& I Revenue Interest Outstanding
<br />(�) (Z) (3) (4) (5) (6) (�)
<br />913,610.00
<br />02/01/10 0.00 0.00 0.00 0.00 0.00 913,610.00
<br />08/01/10 0.00 0.00 0.00 0.00 20,556.23 934,166.23
<br />02/01/11 0.00 0.00 0.00 0.00 21,018.74 955,184.97
<br />08/01/11 0.00 0.00 0.00 0.00 21,491.66 976,676.63
<br />02/01/12 0.00 0.00 0.00 0.00 21,975.22 998,651.85
<br />08/01/12 0.00 0.00 0.00 0.00 22,469.67 1,021,121.52
<br />02/01/13 0.00 0.00 0.00 0.00 22,975.23 1,044,096.75
<br />08/01/13 0.00 16,949.50 16,949.50 16,949.50 6,542.68 1,050,639.43
<br />02/01/14 0.00 16,949.50 16,949.50 16,949.50 6,689.89 1,057,329.32
<br />08/01 /14 382.59 23, 789. 91 24,172.50 24,172.50 0.00 1, 056, 946.73
<br />02/01 /15 391.20 23, 781. 30 24,172.50 24,172.50 0.00 1, 056, 555.53
<br />08/01 /15 1, 400.50 23, 772. 50 25,173.00 25,173.00 0.00 1, 055,155.03
<br />02/01 /16 1, 432.01 23, 740. 99 25,173.00 25,173.00 0.00 1, 053, 723.02
<br />08/01 /16 2, 489.23 23, 708. 77 26,198.00 26,198.00 0.00 1, 051, 233.79
<br />02/01 /17 2, 545.24 23, 652. 76 26,198.00 26,198.00 0.00 1, 048, 688.55
<br />08/01/17 3,653.01 23,595.49 27,248.50 27,248.50 0.00 1,045,035.54
<br />02/01/18 3,735.20 23,513.30 27,248.50 27,248.50 0.00 1,041,300.34
<br />08/01/18 4,896.24 23,429.26 28,325.50 28,325.50 0.00 1,036,404.10
<br />02/01/19 5,006.41 23,319.09 28,325.50 28,325.50 0.00 1,031,397.69
<br />08/01/19 6,222.55 23,206.45 29,429.00 29,429.00 0.00 1,025,175.14
<br />02/01/20 6,362.56 23,066.44 29,429.00 29,429.00 0.00 1,018,812.58
<br />08/01/20 7,637.72 22,923.28 30,561.00 30,561.00 0.00 1,011,174.86
<br />02/01/21 7,809.57 22,751.43 30,561.00 30,561.00 0.00 1,003,365.29
<br />08/01 /21 9,144.28 22, 575. 72 31, 720.00 31, 720.00 0.00 994, 221.01
<br />02/01 /22 9, 350.03 22, 369. 97 31, 720.00 31, 720.00 0.00 984, 870.98
<br />08/01 /22 10, 749.40 22,159. 60 32, 909.00 32, 909.00 0.00 974,121.58
<br />02/01/23 10,991.26 21,917.74 32,909.00 32,909.00 0.00 963,130.32
<br />08/01 /23 12, 456.57 21, 670. 43 34,127.00 34,127.00 0.00 950, 673.75
<br />02/01 /24 12, 736.84 21, 390.16 34,127.00 34,127.00 0.00 937, 936.91
<br />08/01 /24 14, 272.92 21,103. 58 35, 376.50 35, 376.50 0.00 923, 663.99
<br />02/01/25 14,594.06 20,782.44 35,376.50 35,376.50 0.00 909,069.93
<br />08/01/25 16,201.93 20,454.07 36,656.00 36,656.00 0.00 892,868.00
<br />02/01/26 16,566.47 20,089.53 36,656.00 36,656.00 0.00 876,301.53
<br />08/01/26 18,251.72 19,716.78 37,968.50 37,968.50 0.00 858,049.81
<br />02/01/27 18,662.38 19,306.12 37,968.50 37,968.50 0.00 839,387.43
<br />08/01/27 20,426.78 18,886.22 39,313.00 39,313.00 0.00 818,960.65
<br />02/01/28 20,886.39 18,426.61 39,313.00 39,313.00 0.00 798,074.26
<br />08/01/28 22,734.33 17,956.67 40,691.00 40,691.00 0.00 775,339.93
<br />02/01/29 23,245.85 17,445.15 40,691.00 40,691.00 0.00 752,094.08
<br />08/01 /29 25,182.38 16, 922.12 42,104.50 42,104.50 0.00 726, 911.70
<br />02/01 /30 25, 748.99 16, 355. 51 42,104.50 42,104.50 0.00 701,162.71
<br />08/01/30 27,776.84 15,776.16 43,553.00 43,553.00 0.00 673,385.87
<br />02/01 /31 28, 401.82 15,151.18 43, 553.00 43, 553.00 0.00 644, 984.05
<br />08/01/31 30,524.86 14,512.14 45,037.00 45,037.00 0.00 614,459.19
<br />02/01/32 31,211.67 13,825.33 45,037.00 45,037.00 0.00 583,247.52
<br />08/01 /32 33, 435.93 13,123. 07 46, 559.00 46, 559.00 0.00 549, 811.59
<br />02/01/33 34,188.24 12,370.76 46,559.00 46,559.00 0.00 515,623.35
<br />08/01 /33 36, 516.97 11, 601. 53 48,118.50 48,118.50 0.00 479,106.38
<br />02/01 /34 37, 338.61 10, 779. 89 48,118.50 48,118.50 0.00 441, 767.77
<br />08/01/34 39,777.73 9,939.77 49,717.50 49,717.50 0.00 401,990.04
<br />02/01/35 40,672.72 9,044.78 49,717.50 49,717.50 0.00 361,317.32
<br />08/01 /35 43, 226.36 8,129. 64 51, 356.00 51, 356.00 0.00 318, 090.96
<br />02/01 /36 44,198.95 7,157. O5 51, 356.00 51, 356.00 0.00 273, 892.01
<br />08/01 /36 46, 872.43 6,162. 57 53, 035.00 53, 035.00 0.00 227, 019.58
<br />02/01 /37 47, 927.06 5,107. 94 53, 035.00 53, 035.00 0.00 179, 092.52
<br />08/01/37 50,727.42 4,029.58 54,757.00 54,757.00 0.00 128,365.10
<br />02/01/38 51,868.79 2,888.21 54,757.00 54,757.00 0.00 76,496.31
<br />08/01/38 54,800.33 1,721.17 56,521.50 56,521.50 0.00 21,695.98
<br />02/01/39 21.695.98 488.16 22.184.14 22.184.14 0.00 0.00
<br />$1,057,329 $883,487.32 $1,940,816.64 $1,940,816.64 $143,719.32
<br />SurplusTaulncrement 34,337.36
<br />Total Net Revenue $1,975,154.00
<br />SPRINGSTED Page 18
<br />
|