Projected Interfund Loan Report
<br /> City of Elk River, Minnesota
<br /> Tax Increment Financing(Economic Development)District No.23
<br /> Proposed Preferred Powder Coating Project
<br /> EMV$4,670,900(Land:$815,900 and Building:$3,855,000)with 3%Annual MV Inflato
<br /> Note Date: 10/01/13
<br /> Note Rate: 1.50%
<br /> Amount: $1,153,878
<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) (8)
<br /> 1,153,878.00
<br /> 02/01/14 0.00 0.00 0.00 5,769.39 5,769.39 0.00 1,153,878.00
<br /> 08/01/14 0.00 0.00 0.00 14,423.48 14,423.48 0.00 1,153,878.00
<br /> 02/01/15 0.00 0.00 0.00 23,077.57 23,077.57 0.00 1,153,878.00
<br /> 08/01/15 29,155.84 31,731.66 60,887.50 31,731.66 0.00 60,887.50 1,124,722.16
<br /> 02/01/16 52,452.08 8,435.42 60,887.50 8,435.42 0.00 60,887.50 1,072,270.08
<br /> 08/01/16 55,057.97 8,042.03 63,100.00 8,042.03 0.00 63,100.00 1,017,212.11
<br /> 02/01/17 55,470.91 7,629.09 63,100.00 7,629.09 0.00 63,100.00 961,741.20
<br /> 08/01/17 58,166.94 7,213.06 65,380.00 7,213.06 0.00 65,380.00 903,574.26
<br /> 02/01/18 58,603.19 6,776.81 65,380.00 6,776.81 0.00 65,380.00 844,971.07
<br /> 08/01/18 61,390.72 6,337.28 67,728.00 6,337.28 0.00 67,728.00 783,580.35
<br /> 02/01/19 61,851.15 5,876.85 67,728.00 5,876.85 0.00 67,728.00 721,729.20
<br /> 08/01/19 64,733.53 5,412.97 70,146.50 5,412.97 0.00 70,146.50 656,995.67
<br /> 02/01/20 65,219.03 4,927.47 70,146.50 4,927.47 0.00 70,146.50 591,776.64
<br /> 08/01/20 68,199.18 4,438.32 72,637.50 4,438.32 0.00 72,637.50 523,577.46
<br /> 02/01/21 68,710.67 3,926.83 72,637.50 3,926.83 0.00 72,637.50 454,866.79
<br /> 08/01/21 71,791.50 3,411.50 75,203.00 3,411.50 0.00 75,203.00 383,075.29
<br /> 02/01/22 72,329.94 2,873.06 75,203.00 2,873.06 0.00 75,203.00 310,745.35
<br /> 08/01/22 75,514.91 2,330.59 77,845.50 2,330.59 0.00 77,845.50 235,230.44
<br /> 02/01/23 76,081.27 1,764.23 77,845.50 1,764.23 0.00 77,845.50 159,149.17
<br /> 08/01/23 79,373.88 1,193.62 80,567.50 1,193.62 0.00 80,567.50 79,775.29
<br /> 02/01/24 79,775.29 598.31 80,373.60 598.31 0.00 80,373.60 0.00
<br /> 08/01/24 0.00 0.00 0.00 0.00 0.00 0.00 0.00
<br /> 02/01/25 0.00 0.00 0.00 0.00 0.00 0.00 0.00
<br /> $1,153,878 $112,919.10 $1,266,797.10 $43,270.44 $1,266,797.10
<br /> Surplus Tax Increment 193.90
<br /> Total Net Revenue $1,266,991.00
<br /> Prepared by:Springsted Incorporated(printed on 8/27/2013 at 8:37 AM) Elk River(Economic Development)TIF 23 Final Projections 082713.xls
<br />
|