|
<br />City of Elk River, MN
<br />$3,220,000 G.o. LIbrary Bonds, Series 2007
<br />
<br />Debt Service Schedule
<br />
<br />Date Principal Couron Interest Total P+ I Fiscal Total
<br />12101/2006
<br />08/0112007 92,285.00 92,285.00
<br />0210112008 85,000.00 3.850% 69,213.75 154,213.75 246,498.75
<br />08/0112008 67,577.50 67,577.50
<br />0210112009 110,000.00 3.900% 67,577.50 177,577.50 245,155.00
<br />08/0112009 65,432.50 65,432.50
<br />02/0112010 115,000.00 3.950% 65,432.50 180,432.50 245,865.00
<br />08/01/2010 63,161.25 63,161.25
<br />02/01/2011 120,000.00 4.000% 63,161.25 183,161.25 246,322.50
<br />08/0112011 60,761.25 60,761.25
<br />02/01/2012 125,000.00 4.050% 60,761.25 185,761.25 246,522.50
<br />08/0112012 58,230.00 58,230.00
<br />02/01/2013 130,000.00 4.100% 58,230.00 188,230.00 246,460.00
<br />08/0112013 55,565.00 55,565.00
<br />0210112014 135,000.00 4.150% 55,565.00 190,565.00 246,130.00
<br />08/0112014 52,763.75 52,763.75
<br />0210112015 140,000.00 4.200% 52,763.75 192,763.75 245,527.50
<br />08/01/2015 49,823.75 49,823.75
<br />02/0112016 150,000.00 4.200% 49,823.75 199,823.75 249,647.50
<br />08/0112016 46,673.75 46,673.75
<br />0210112017 155,000.00 4.300% 46,673.75 201,673.75 248,347.50
<br />08/0112017 43,341.25 43,341.25
<br />02/0112018 160,000.00 4.300% 43,341.25 203,341.25 246,682.50
<br />08/01/2018 39,901.25 39,901.25
<br />02/01/2019 170,000.00 4.350% 39,901.25 209,901.25 249,802.50
<br />08/0112019 36,203.75 36,203.75
<br />02/0112020 175,000.00 4.350% 36,203.75 211,203.75 247,407.50
<br />08/0112020 32,397.50 32,397.50
<br />02/0112021 180,000.00 4.400% 32,397.50 212,397.50 244,795.00
<br />08/0112021 28,437.50 28,437.50
<br />02101/2022 190,000.00 4.400% 28,437.50 218,437.50 246,875.00
<br />08/01/2022 24,257.50 24,257.50
<br />0210112023 200,000.00 4.450% 24,257.50 224,257.50 248,515.00
<br />08/0112023 19,807.50 19,807.50
<br />02/0112024 205,000.00 4.450% 19,807.50 224,807.50 244,615.00
<br />08/0112024 15,246.25 15,246.25
<br />02/01/2025 215,000.00 4.500% 15,246.25 230,246.25 245,492.50
<br />08/01/2025 10,408.75 10,408.75
<br />02101/2026 225,000.00 4.500% 10,408.75 235,408.75 245,817.50
<br />08/01/2026 5,346.25 5,346.25
<br />0210112027 235,000.00 4.550% 5,346.25 240,346.25 245,692.50
<br />Total $3,220,000.00 $1,712,171.25 $4,932,171.25
<br />Yield Statistics
<br />
<br />Bond Year Dollars.. .............. ......... .... .......... .... ......... .......... ............. .... ........ .... ... ...................... ............ .... ..... .... ............ ....... ........ .... ...... .....
<br />Average Life............................................................. ...............................................................................................................................
<br />Average Coupon............................................................. .............................................................................................................................
<br />
<br />$39,011.67
<br />12.115 Years
<br />4.3888698%
<br />
<br />Net Interest Cost (NIC) .......... .... ...... ....... ...... .... .... .... ........... ........ .... ............... ............. .... ........ .............. .... ... .......... ...... ......... ...... ...... ...... .....
<br />True Interest Cost (TIC). ...... ........ ... .................. ........... ................. .... ........ ........... .... .... .... .......... .... ........ .... ......... ...... ...... ......... .......... ...... ....,
<br />Bond Yield for Arbitrage Purposes... ....... .... .......... ........... .... .... .... .... ... .... ............ .... ..... .... .... ...... .... ..... .......... ...... ........... .... ............ ... ...... .............
<br />All Inclusive Cost (AI C)... .... .... ..... .... .... ............. ........ .... .... ........ .... ..... .... ....... ........ .... .... .............. .... .... .... ......... ...... .... ......... ...... ...... ...... .......
<br />
<br />4.4920440%
<br />4.5156889%
<br />4.3746227%
<br />4.6296972%
<br />
<br />IRS Form &03&
<br />
<br />NetlnterestCost.......................................................................................................................................................................................
<br />Weighted Average Maturity.......... .... .... ..... .... .... .... .... .... ....... .... .......... .... ... ................ .... ... ...... .... ........ ....... ...... .... ...... ...... .... ........... ...... .... .........
<br />
<br />4.3888698%
<br />12.115 Years
<br />
<br />Ser06.';'3.375KGOC/PLIb / SINGLEPUKPOSE /1//1/2006/ 7:53PM
<br />
<br />Ehlers & Associates, Inc.
<br />Leaders in Public Finance
<br />
<br />Page 2
<br />
|