<br />
<br />I
<br />I
<br />i
<br />I
<br />I
<br />I
<br />I
<br />i
<br />I
<br />I
<br />I
<br />I
<br />I
<br />I
<br />II
<br />
<br />City of Centerville, Minnesota
<br />G.O. Improvement Refunding Bonds of 2009 (Early Savings)
<br />2oo6A
<br />
<br />Debt Service Comparison
<br />
<br />Date
<br />0310112010
<br />0310112011
<br />03/0112012
<br />0310112013
<br />0310112014
<br />0310112015
<br />- 03101/2016
<br />0310112017
<br />03/0112018
<br />031Oif2019
<br />0310112020
<br />0310112021
<br />-03/0112022---
<br />Total
<br />
<br />-------~~~l
<br />PCF Existln CIS Net New D/S Old Net Olsl Savin
<br />(2.420,000.00) 2,616,981.25 195,919.07 196,981.25 1,062.181
<br />220,831.25 248,525.00, 27,693.75,
<br />234.215.00 252,825.001 18,610.ooi
<br />237,027.50 256.665.001 19,637.501
<br />234.237.50 255,035.001 20,797.50l
<br />___ _ _ 240.817.~ ~,122.501_~7,305,001
<br />241,637.50 260,722.501 19,085.00.
<br />256.762.50 262,922.501 6.160.00!
<br />1,230,850.00 264,620.001 (966,230.00)1
<br />260,805.001 260,805.001
<br />266.675.00: 266,675.00:
<br />- 271.805.00: 271.805.001
<br />- .-. 271.180~ 271,1801)01
<br />I I
<br />$3,326,883.751 ~34,sa5.9~!
<br />
<br />Total P+I
<br />
<br />220,831.25
<br />234.215.00
<br />237.027.50
<br />234,237.50
<br />240,817.50
<br />~41,637.5()--
<br />258,762.50
<br />1.230,850.00
<br />
<br />$2,896,378.75
<br />
<br />(2,420,000.0"1
<br />
<br />PV Analysis Summary (Net to Net)
<br />
<br />Gross ~ Debt _Service Savings.~.=...~
<br />
<br />$2,616,981.25
<br />
<br />$3.092,297.82
<br />
<br />_140.810.~
<br />
<br />~t pYSashfl~Savings L2.6!!6%(BOfld. YI6ld}~..~__
<br />
<br />________ -.--!40,810.38.
<br />
<br />~ntingel'lCY or Rounding AmounL..~==~..~:~._.__
<br />!!et Present Value Benefit__ __ __ __
<br />
<br />1,062.18
<br />== == =_ ==- ---==-..~_ ._$141,~72.56
<br />
<br />Net PV Beneflt I $2,615,810.38 PV Refunded Debt Service 5.424%
<br />NetPVB~fitl $2,:420,OOO-RefundedPrincipa~- ---- .~---_-'--'~5.863%
<br />Nei-PVBenefitl $2,475,000 -Refunding PrincipaL- =--_-==--_ -==-_ --==- ~. -=---=- ==-- ==- :-- 5.!32%
<br />
<br />Refunding Bond Information
<br />
<br />~efunding Dateci Date
<br />Refunding DeI~~_~
<br />
<br />0611"" 3 I SINGLE PURPOSE I 8119i2009 I 8~2t; AM
<br />
<br />Northland Securities
<br />Public Finance
<br />
<br />__1110112~
<br />_.1110112009
<br />
<br />P_2
<br />
|