|
City of Louisville, Colorado
<br />Proposed Water Revenue Refunding Bonds, Series 2012
<br />Refunding of the 2003 Series A CWRPDA Water Resources Revenue Bonds
<br />Debt Service/Savings
<br />DatePrincipalCouponInterestTotal P+IOld Debt SvcSavings
<br />12/01/2013660,000.001.900%165,934.39825,934.39890,012.5067,022.25
<br />12/01/2014705,000.001.900%162,640.00867,640.00938,562.5070,922.50
<br />12/01/2015720,000.001.900%149,245.00869,245.00938,875.0069,630.00
<br />12/01/2016730,000.001.900%135,565.00865,565.00937,750.0072,185.00
<br />12/01/2017750,000.001.900%121,695.00871,695.00940,137.5068,442.50
<br />12/01/2018765,000.001.900%107,445.00872,445.00940,812.5068,367.50
<br />12/01/2019775,000.001.900%92,910.00867,910.00939,712.5071,802.50
<br />12/01/2020795,000.001.900%78,185.00873,185.00941,775.0068,590.00
<br />12/01/2021805,000.001.900%63,080.00868,080.00937,325.0069,245.00
<br />12/01/2022825,000.001.900%47,785.00872,785.00940,325.0067,540.00
<br />12/01/2023840,000.001.900%32,110.00872,110.00941,925.0069,815.00
<br />12/01/2024850,000.001.900%16,150.00866,150.00937,125.0070,975.00
<br />Total$9,220,000.00-$1,172,744.39$10,392,744.39$11,224,337.50$834,537.25
<br />Savings Analysis
<br />Net PV Cashflow Savings @ 1.900%(Bond Yield)793,667.76
<br />Transfers from Prior Issue Debt Service Fund(52,000.00)
<br />Contingency or Rounding Amount 2,944.14
<br />Net Present Value Benefit $744,611.90
<br />Net PV Benefit / $8,905,000 Refunded Principal8.362%
<br />Yield Statistics
<br />Bond Year Dollars $61,723.39
<br />Average Coupon 1.9000000%
<br />Net Interest Cost (NIC) 1.9000000%
<br />True Interest Cost (TIC)1.9000683%
<br />All Inclusive Cost (AIC)1.9884356%
<br />IRS Form 8038
<br />Bond Yield for Arbitrage Purposes1.9000683%
<br />Weighted Average Maturity6.695 Years
<br />First Coupon Date6/01/2013
<br />Prop Ref of 2003A CWRPDA | SINGLE PURPOSE | 9/12/2012 | 11
<br />BLX Group LLC
<br />Independent Financial Advisor
<br />Page 3
<br />10
<br />
|