|
•
<br />•
<br />•
<br />$3,025,000
<br />City of Lino Lakes, Minnesota
<br />General Obligation Capital Improvement Plan Refunding Bonds, Series 2006E
<br />Current Refunding of Series 1998A (79.45% of Prior Bonds)
<br />Debt Service Comparison
<br />Date Total P41 Escrow Existing D/S Net New D/S Old Net D/S Savings
<br />02/01/2007 29,248.75 (9,855.23) 250,967.50 270,361.02 329,866.04 59,505.02
<br />02/01/2008 116,995.00 281,125.00 398,120.00 438,922.08 40,802.08
<br />02/01/2009 116,995.00 289,250.00 406,245.00 447,047.08 40,802.08
<br />02/01/2010 201,995.00 120,750.00 322,745.00 333,547.08 10,802.08
<br />02/01/2011 433,892.50 - 433,892.50 445,047.08 11,154.58
<br />02/01/2012 432,052.50 432,052.50 445,547.08 13,494.58
<br />02/01/2013 439,842.50 439,842.50 449,992.08 10,149.58
<br />02/01/2014 431,717.50 431,717.50 448,417.08 16,699.58
<br />02/01/2015 433,050.00 433,050.00 450,567.08 17,517.08
<br />02/01/2016 433,620.00 433,620.00 451,667.08 18,047.08
<br />02/01/2017 438,412.50 438,412.50 456,337.08 17,924.58
<br />02/01/2018 442,212.50 442,212.50 459,669.58 17,457.08
<br />02/01/2019 - 68,822.08 68,822.08
<br />Total $3,950,033.75 (9,855.23) $942,092.50 $4,882,271.02 $5,225,448.50 $343,177.48
<br />PV Analysis Summary (Net to Net)
<br />Net FV Cashflow Savings 343,177.48
<br />Gross PV Debt Service Savings 690,386.16
<br />Effects of changes in DSR investments (419,916.11)
<br />PV of Escrow Eamings 9,823.54
<br />Net PV Cashflow Savings @ 3.903 %(Bond Yield) 280,293.59
<br />Total Cash contribution (58,825.00)
<br />Contingency or Rounding Amount 4,438.33
<br />Net Future Value Benefit $288,790.81
<br />Net Present Value Benefit $225,906.92
<br />Net PV Benefit / $1,297,901.84 PV Refunded Interest 17.406%
<br />Net PV Benefit / $3,715,386.16 PV Refunded Debt Service 6.080%
<br />Net PV Benefit / $3,345,000 Refunded Principal 6.754%
<br />Net PV Benefit / $3,025,000 Refunding Principal 7.468%
<br />Refunding Bond Information
<br />Refunding Dated Date 11/01/2006
<br />Refunding Delivery Date 11/01/2006
<br />Senes 200C Ref 98A EDA a / SINGLEru)rc1E / 9/12/2006' / 77:15 AM
<br />Springsted
<br />- 6 9 -
<br />Page 13
<br />
|