|
<br />
<br />$33,735,000
<br />City of Elk River, Minnesota
<br />General Obligation Sales Tax Revenue Bonds, Series 2019A
<br />NET DEBT SERVICE vs. REVENUE
<br />DatePrincipalCouponInterestTotal P+INet New D/S105% OverlevyRevenueSrpls(Shrtfall)
<br />12/01/2019--------
<br />12/01/2020605,000.004.000%1,452,015.002,057,015.002,057,015.002,159,865.752,073,978.00(85,887.75)
<br />12/01/2021870,000.004.000%1,185,812.502,055,812.502,055,812.502,158,603.132,073,978.00(84,625.13)
<br />12/01/2022905,000.004.000%1,151,012.502,056,012.502,056,012.502,158,813.132,073,978.00(84,835.13)
<br />12/01/2023940,000.004.000%1,114,812.502,054,812.502,054,812.502,157,553.132,073,978.00(83,575.13)
<br />12/01/2024980,000.004.000%1,077,212.502,057,212.502,057,212.502,160,073.132,073,978.00(86,095.13)
<br />12/01/20251,015,000.004.000%1,038,012.502,053,012.502,053,012.502,155,663.132,073,978.00(81,685.13)
<br />12/01/20261,060,000.004.000%997,412.502,057,412.502,057,412.502,160,283.132,073,978.00(86,305.13)
<br />12/01/20271,100,000.004.000%955,012.502,055,012.502,055,012.502,157,763.132,073,978.00(83,785.13)
<br />12/01/20281,145,000.004.000%911,012.502,056,012.502,056,012.502,158,813.132,073,978.00(84,835.13)
<br />12/01/20291,190,000.004.000%865,212.502,055,212.502,055,212.502,157,973.132,073,978.00(83,995.13)
<br />12/01/20301,240,000.004.000%817,612.502,057,612.502,057,612.502,160,493.132,073,978.00(86,515.13)
<br />12/01/20311,285,000.004.000%768,012.502,053,012.502,053,012.502,155,663.132,073,978.00(81,685.13)
<br />12/01/20321,340,000.004.000%716,612.502,056,612.502,056,612.502,159,443.132,073,978.00(85,465.13)
<br />12/01/20331,390,000.004.000%663,012.502,053,012.502,053,012.502,155,663.132,073,978.00(81,685.13)
<br />12/01/20341,450,000.003.000%607,412.502,057,412.502,057,412.502,160,283.132,073,978.00(86,305.13)
<br />12/01/20351,490,000.003.000%563,912.502,053,912.502,053,912.502,156,608.132,073,978.00(82,630.13)
<br />12/01/20361,535,000.003.050%519,212.502,054,212.502,054,212.502,156,923.132,073,978.00(82,945.13)
<br />12/01/20371,585,000.003.100%472,395.002,057,395.002,057,395.002,160,264.752,073,978.00(86,286.75)
<br />12/01/20381,630,000.003.200%423,260.002,053,260.002,053,260.002,155,923.002,073,978.00(81,945.00)
<br />12/01/20391,685,000.003.250%371,100.002,056,100.002,056,100.002,158,905.002,073,978.00(84,927.00)
<br />12/01/20401,740,000.003.300%316,337.502,056,337.502,056,337.502,159,154.382,073,978.00(85,176.38)
<br />12/01/20411,795,000.003.350%258,917.502,053,917.502,053,917.502,156,613.382,073,978.00(82,635.38)
<br />12/01/20421,855,000.003.400%198,785.002,053,785.002,053,785.002,156,474.252,073,978.00(82,496.25)
<br />12/01/20431,920,000.003.450%135,715.002,055,715.002,055,715.002,158,500.752,073,978.00(84,522.75)
<br />12/01/20441,985,000.003.500%69,475.002,054,475.002,054,475.002,157,198.752,079,978.00(77,220.75)
<br />Total$33,735,000.00-$17,649,300.00$51,384,300.00$51,384,300.00$53,953,515.00$51,855,450.00(2,098,065.00)
<br />
<br />Dated..................................................................................................................................................................................................
<br />.9/19/2019
<br />Delivery Date..........................................................................................................................................................................................
<br />.9/19/2019
<br />First Coupon Date......................................................................................................................................................................................
<br />.6/01/2020
<br />
<br />Yield Statistics
<br />
<br />Bond Year Dollars......................................................................................................................................................................................
<br />.$510,207.00
<br />Average Life...........................................................................................................................................................................................
<br />.15.124 Years
<br />Average Coupon.........................................................................................................................................................................................
<br />.3.4592430%
<br />
<br />Net Interest Cost (NIC)................................................................................................................................................................................
<br />.3.0518393%
<br />True Interest Cost (TIC)...............................................................................................................................................................................
<br />.2.9459354%
<br />Bond Yield for Arbitrage Purposes......................................................................................................................................................................
<br />.2.8774304%
<br />All Inclusive Cost (AIC)...............................................................................................................................................................................
<br />.2.9735509%
<br />Series 2019A GO Sales Tax | SINGLE PURPOSE | 7/10/2019 | 1:56 PM
<br />
<br />
<br /> Page 7
<br />
|