|
$4,215,000
<br />City of Lino Lakes, Minnesota
<br />General Obligation Tax Increment Bonds, Series 2007A
<br />NET DEBT SERVICE vs. REVENUE
<br />(1) (2) (3) (4) (5) (6) (7)
<br />Date Principal Coupon Interest Total P +I 105% Overlevy TIF Revenue Levy Required
<br />02/01/2008 - - 89,680.89 89,680.89 94,164.93 54,926.99 39,237.94
<br />02/01/2009 165,000.00 3.700% 164,720.00 329,720.00 346,206.00 110,191.33 236,014.67
<br />02/01/2010 175,000.00 3.700% 158,615.00 333,615.00 350,295.75 112,082.59 238,213.16
<br />02/01/2011 215,000.00 3.700% 152,140.00 367,140.00 385,497.00 149,904.15 235,592.85
<br />02/01/2012 265,000.00 3.750% 144,185.00 409,185.00 429,644.25 196,458.84 233,185.41
<br />02/01/2013 285,000.00 3.750% 134,247.50 419,247.50 440,209.88 206,608.12 233,601.75
<br />02/01/2014 345,000.00 3.800% 123,560.00 468,560.00 491,988.00 255,042.73 236,945.27
<br />02/01/2015 360,000.00 3.800% 110,450.00 470,450.00 493,972.50 260,578.33 233,394.17
<br />02/01/2016 380,000.00 3.850% 96,770.00 476,770.00 500,608.50 266,223.73 234,384.77
<br />02/01/2017 400,000.00 3.900% 82,140.00 482,140.00 506,247.00 271,981.78 234,265.22
<br />02/01/2018 190,000.00 4.000% 66,540.00 256,540.00 269,367.00 277,856.25 (8,489.25)
<br />02/01/2019 200,000.00 4.000% 58,940.00 258,940.00 271,887.00 283,847.16 (11,960.16)
<br />02/01/2020 215,000.00 4.050% 50,940.00 265,940.00 279,237.00 289,958.28 (10,721.28)
<br />02/01/2021 230,000.00 4.100% 42,232.50 272,232.50 285,844.13 296,191.51 (10,347.38)
<br />02/01/2022 245,000.00 4.100% 32,802.50 277,802.50 291,692.63 302,548.74 (10,856.11)
<br />02/01/2023 265,000.00 4.150% 22,757.50 287,757.50 302,145.38 309,033.76 (6,888.38)
<br />02/01/2024 280,000.00 4.200% 11,760.00 291,760.00 306,348.00 315,648.46 (9,300.46)
<br />Total $4,215,000.00 - $1,542,480.89 $5,757,480.89 $6,045,354.93 $3,959,082.75 $2,086,272.19
<br />Dated 7/15/2007
<br />Delivery Date 7/15/2007
<br />First Coupon Date 2/01 /2008
<br />Yield Statistics
<br />Bond Year Dollars $38,724.83
<br />Average Life 9.187 Years
<br />Average Coupon 3.9831828%
<br />Net Interest Cost (NIC) 4.0974699%
<br />True Interest Cost (TIC) 4.1145500%
<br />Bond Yield for Arbitrage Purposes 3.9716630%
<br />All Inclusive Cost (AIC) 4.2314469%
<br />2007T1FBondv,5.21.07 Op / SINGLE PURPOSE / .5/21/2007 / II..39AM
<br />Springsted
<br />Page 7
<br />
|