|
<br />Projected Pay-as-you-Go Loan Report
<br />City of Elk River, Minnesota
<br />Tax Increment Financing (Housing ) District
<br />Hillside Senior Housing
<br />Prelminiary Revenue Projections
<br />Note Date:02/01/21
<br />Note Rate:4.00%
<br />Amount:$780,000
<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)(7)(7)
<br />780,000.00
<br />02/01/21 0.00 0.00 0.00 0.00 0.00 0.00 780,000.00
<br />08/01/21 0.00 0.00 0.00 15,600.00 15,600.00 0.00 780,000.00
<br />02/01/22 0.00 0.00 0.00 31,200.00 31,200.00 0.00 780,000.00
<br />08/01/22 0.00 0.00 0.00 46,800.00 46,800.00 0.00 780,000.00
<br />02/01/23 0.00 0.00 0.00 62,400.00 62,400.00 0.00 780,000.00
<br />08/01/23 0.00 54,564.50 54,564.50 78,000.00 23,435.50 54,564.50 780,000.00
<br />02/01/24 15,529.00 39,035.50 54,564.50 39,035.50 0.00 54,564.50 764,471.00
<br />08/01/24 39,275.08 15,289.42 54,564.50 15,289.42 0.00 54,564.50 725,195.92
<br />02/01/25 40,060.58 14,503.92 54,564.50 14,503.92 0.00 54,564.50 685,135.34
<br />08/01/25 40,861.79 13,702.71 54,564.50 13,702.71 0.00 54,564.50 644,273.55
<br />02/01/26 41,679.03 12,885.47 54,564.50 12,885.47 0.00 54,564.50 602,594.52
<br />08/01/26 42,512.61 12,051.89 54,564.50 12,051.89 0.00 54,564.50 560,081.91
<br />02/01/27 43,362.86 11,201.64 54,564.50 11,201.64 0.00 54,564.50 516,719.05
<br />08/01/27 44,230.12 10,334.38 54,564.50 10,334.38 0.00 54,564.50 472,488.93
<br />02/01/28 45,114.72 9,449.78 54,564.50 9,449.78 0.00 54,564.50 427,374.21
<br />08/01/28 46,017.02 8,547.48 54,564.50 8,547.48 0.00 54,564.50 381,357.19
<br />02/01/29 46,937.36 7,627.14 54,564.50 7,627.14 0.00 54,564.50 334,419.83
<br />08/01/29 47,876.10 6,688.40 54,564.50 6,688.40 0.00 54,564.50 286,543.73
<br />02/01/30 48,833.63 5,730.87 54,564.50 5,730.87 0.00 54,564.50 237,710.10
<br />08/01/30 49,810.30 4,754.20 54,564.50 4,754.20 0.00 54,564.50 187,899.80
<br />02/01/31 50,806.50 3,758.00 54,564.50 3,758.00 0.00 54,564.50 137,093.30
<br />08/01/31 51,822.63 2,741.87 54,564.50 2,741.87 0.00 54,564.50 85,270.67
<br />02/01/32 52,859.09 1,705.41 54,564.50 1,705.41 0.00 54,564.50 32,411.58
<br />08/01/32 32,411.58 648.23 33,059.81 648.23 0.00 33,059.81 0.00
<br />02/01/33 0.00 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 0.00
<br />02/01/34 0.00 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 0.00
<br />02/01/35 0.00 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 0.00
<br />02/01/36 0.00 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 0.00
<br />02/01/37 0.00 0.00 0.00 0.00 0.00 0.00 0.00
<br />08/01/37 0.00 0.00 0.00 0.00 0.00 0.00 0.00
<br />02/01/38 0.00 0.00 0.00 0.00 0.00 0.00 0.00
<br />$780,000 $235,220.81 $1,015,220.81 $1,015,220.81
<br />Surplus Tax Increment 1,822,133
<br />Total Net Revenue $2,837,354.00
|