|
•
<br />•
<br />•
<br />$3,040,000
<br />City of Lino Lakes, Minnesota
<br />General Obligation Capital Improvement Plan Refunding Bonds, Series 2006E
<br />Current Refunding of Series 1998A (80% of Prior Bonds)
<br />Debt Service Comparison
<br />Date Total P +I Escrow Existing D/S Net New D/S Old Net D/S Savings
<br />02/01/2007 29,396.25 (9,914.11) 250.467.50 269,949.64 329,821.04 59,871.40
<br />02/01/2008 117,585.00 - 280,125.00 397,710.00 438,832.08 41,122.08
<br />02/01/2009 117,585.00 - 288,250.00 405,835.00 446,957.08 41,122.08
<br />02/01/2010 217,585.00 - 99,750.00 317,335.00 333,457.08 16,122.08
<br />02/01/2011 428,935.00 428,935.00 444.957.08 16,022.08
<br />02/01/2012 427,280.00 - 427,280.00 445,457.08 18,177.08
<br />02/01/2013 435,255.00 435,255.00 449,902.08 14,647.08
<br />02/01/2014 432,317.50 432,317.50 448,327.08 16,009.58
<br />02/01/2015 433,650.00 433,650.00 450,477.08 16,827.08
<br />02/01/2016 439,220.00 439,220.00 451.577.08 12,357.08
<br />02/01/2017 443,815.00 - 443,815.00 456,247.08 12,432.08
<br />02/01/2018 447,415.00 447,415.00 459,579.58 12,164.58
<br />02/01 /2019 - - 66,732.08 66,732.08
<br />Total $3,970.038.75 (9,914.11) $918.592.50 $4,878,717.14 $5,222,323.50 $343,606.36
<br />PV Analysis Summary (Net to Net)
<br />Net FV Cashflow Savings 343,606.36
<br />Gross PV Debt Service Savings 696,121.70
<br />Effects of changes in DSR investments (422,026.34)
<br />PV of Escrow Eamings 9,882.22
<br />Net PV Cashflow Savings @ 3.903 %(Bond Yield) 283,977.58
<br />Total Cash contribution (58,825.00)
<br />Contingency or Rounding Amount 962.50
<br />Net Future Value Benefit $285,743.86
<br />Net Present Value Benefit $226,115.08
<br />Net PV Benefit / $1,301,135.74 PV Refunded Interest 17.378%
<br />Net PV Benefit / $3,736,121.70 PV Refunded Debt Service 6.052%
<br />Net PV Benefit / $3,365,000 Refunded Principal 6.720%
<br />Net PV Benefit / $3,040,000 Refunding Principal 7.438%
<br />Refunding Bond Information
<br />Refunding Dated Date 11/01/2006
<br />Refunding Delivery Date 11/01/2006
<br />Semen _006 Set 931 L7JA a ; SJA'.:7EJVR/'OSE 9/S '20196 ' 70:96 .�Lf
<br />plringstod
<br />—45k-
<br />o9G
<br />
|