Loading...
HomeMy WebLinkAbout2003 Bond SummaryJEFFERSONVILLE MUNICIPAL SEWAGE WORKS jeffersonville, Indiana SLrMMARY OF THE BONDS December 16, 2003 Crowe JEFFERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonville, Indiana TABLE OF CONTENTS PURPOSE OF THE REPORT EXHIBIT A EXHIBIT B EXHIBIT C EXHIBIT D SCHEDULE D-1 EXHIBIT E EXHIBIT F - Sewage Works Revenue Refunding Bonds, Series 1995 Amortization Schedule - Sewage Works Revenue Bonds, Series 1998 Amortization Schedule - Sewage Works Revenue Bonds, Series 1999 State Revolving Fund (SRF) Loan Estimated Amortization Schedule - Sewage Works Revenue Bonds, Series 2003 Amortization Schedule - Estimated Sources and Uses of Funds - Estimated Combined Amnual Debt Service - Bond and Interest Account Monthly Transfer Page 1 3 4 5 6 7 8 Crowe Crowe Chizek and Company LLC Member Horwath International JEFFERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonville, Indiana 10 West Market Street, Suite 2000 ~ndianapolis, Indiana 46204-2975 Tel 317.632.1100 Wax 317.635.6127 PURPOSE OF THE REPORT Crowe Chizek and Company LLC has prepared this Summary of the Bonds (Report) to assist the City of Jeffersonville Mtmicipal Sewage Works with the monthly transfers to the Bond and Interest Account of the Sinking Fund. If you have any questions regarding this Report, please call Jermifer Wilson at (317) 269-6696 or Erin Clark at (317) 632-1100 Extension 6168. -1- Date. 7/1/o4 1/1/05 7/1/o5 1/1/06 7/1/o6 1/1/o7 7/1/o7 1/1/o8 7/1/o8 1/1/o9 7/1/09 1/1/10 7/1/10 1/1/11 Totals JEFFERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonville, Indiana Sewage Works Revenue Refunding Bonds, Series 1995 Amortization Schedule Principal Coupon Interest Period Tota! $ 113,060.00 $ 113,060.00 $ 550,000 4.80 % 113,060.00 663,060.00 99,860.00 99,860.00 575,000 4.80 99,860.00 674,860.00 86,060.00 86,060.00 600,000 4.90 86,060.00 686,060.00 71,360.00 71,360.00 640,000 5.00 71,360.00 711,360.00 55,360.00 55,360.00 675,000 5.10 55,360.00 730,360.00 38,147.50 38,147.50 710,000 5.20 38,147.50 748,147.50 19,687.50 19,687.50 750,000 5.25 19,687.50 769,687.50 $4,500,000 $ 967,070.00 $5,467,070.00 -2- EXHIBIT A Fiscal Total $776,120.00 774,720.00 772,120.00 782,720.00 785,720.00 786,295.00 789,375.00 Date 7/1/04 1/1/05 7/1/05 1/1/06 7/1/06 1/1/07 7/1/07 1/1/08 7/1/08 1/1/09 7/1/09 1/1/10 7/1/10 1/1/11 7/1/11 1/1/12 7/1/12 1/1/13 7/1/13 1/1/14 7/1/14 1/1/15 7/1/15 1/1/16 7/1/16 1/1/17 7/1/17 1/1/18 7/1/18 1/1/19 Totals JEFFERSONVILLE MUNICIPAL sEWAGE WORKS Jeffersonville, Indiana Sewage Works Revenue Bonds, Series 1998 Amortization Schedule Principal Coupon Interest Period TOtal 250,000 265,000 275,000 285,000 300,000 315,000 330,000 345,000 365,000 385,000 400,000 425,000 445,000 470,000 495,000 $ 119,192.50 4~4 % 119,192.50 113,692.50 4.4 113,692.50 107,862.50 4.4 107,862.50 101,812.50 4.4 - 101,812.50 95242.50 4.4 95242.50 88,942.50 4.4 88,942.50 82,012.50 4.4 82,012.50 74,752.50 4.4 74,752.50 67,162.50 4.5 67,162.50 58,950.00 4.5 58,950.00 50,287.50 4.5 50,287.50 41,287.50 4.5 41,287.50 31,725.00 4.5 31,725.00 21,712.50 4.5 21,712.50 11,137.50 4.5 11,137.50. 119,192.50 369,192.50 113,692.50 378,692.50 107,862.50 382,862.50 101,812.50 386,812.50 95,542.50 395,542.50 88,942.50 403,942.5O 82,012.50 412,012.50 74,752.50 419,752.50 67,162.50 432,162.50 58,950.00 443,950.00 50,287.50 450,287.50 41,287.50 466,287.50 31,725.00 476,725.00 21,712.50 491,712.50 11,137.50 506,137.50 $ 5,350,000 $2,132,145.00 $7,482,145.00 -3- EXHIBIT B Fiscal Total $488,385.00 492,385.00 490,725.00 488,625.00 491,085.00 492,885.00 494,025.00 494,505.00 499,325.00 502,900.00 500275.00 507,575.00 508,450.00 513,425.00 517,275.00 Date 7/1/04 1/1/05 7/1/05 1/1/06 7/1/06 1/1/07 7/1/07 1/1/08 7/1/08 1/1/09 7/1/09 1/1/10 7/1/10 1/1/11 7/1/11 1/1/12 7/1/12 1/1/13 7/1/13 1/1/14 7/1/14 1/1/15 7/1/15 1/1/16 7/1/16 1/1/17 7/1/17 1/1/18 7/1/18 1/1/19 7/1/19 1/1/20 Totals JEFFERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonville, Indiana Sewage Works Revenue Bonds, Series 1999 State Revolving Fund (SRF) Loan Estimated Amortization Schedule Principal Coupon Interest Period Total 135,185 135,105 140,683 146,863 148,662 151;173 1~4,417 158,415 158,189 159,202 166,143 163,962 167,842 167,734 168,748 690,917 $ 43,692.00 $ 43,692.00 2.9 % 43,692.00 178,877.00 41,731.81 41,731.81 2.9 41,731.81 176,836.81 39,772.79 39,772.79 2.9 39,772.79 180,455.79 37,732.88 37,732.88 2.9 37,732.88 184295.88 35,603.37 35,603.37 2.9 35,603.37 184,265.37 33,447.77 33,447.77 2.9 33,447.77 184,620.77 31,255.76 31,255.76 2.9 31,255.76 185,672.76 29,016.71 29,016.71 2.9 29,016.71 187,431.71 26,719.69 26,719.69 2.9 26,719.69 184,908.69 24,425.95 24,425.95 2.9 24,425.95 183,627.95 22,117.52 22,117.52 2.9 22,117.52 188,260.52 19,708.45 19,708.45 2.9 19,708.45 183,670.45 17,331.00 17,331.00 2.9 17,331.00 185,173.00 14,897.29 14,897.29 2.9 14,897.29 182,631.29 12,465.15 12,465.15 2.9 12,465.15 181,213.15 10,018.30 10,018.30 2.9 10,018.30 700,935.30 $ 3,013,240 $879,872.88 $3,893,112.88 -4- EXHIBIT C Fiscal Total $222269.00 218268.62 220,228.58 222,328.76 219,868.74 218,068.54 216,928.52 216,448.42 211,628.38 208,053.90 210,378.04 203,378.90 202,504.00 197228.58 193,678.30 710,953.60 Date 7/01/04 1/01/05 7/01/08 1/01/06 7/01/06 1/01/07 7/01/07 1/01/08 7/01/08 1/01/09 7/01/09 1/Ol/lO 7/01/10 1/01/11 7/ol/11 1/01/12 7/01/12 1/01/13 7/01/13 1/01/14 7/01/14 1/Ol/15 7/01/15 1/01/16 7/Ol/16 1/01/17 7/01/17 1/Ol/18 7/01/18 1/01/19 7/01/19 1/01/20 7/01/20 1/Ol/21 7/01/21 1/Ol/22 7/01/22 1/01/23 7/01/23 1/01/24 Totals JEFI-ERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonville, indiana Sewage Works Revenue Bonds, Series 2003 Amortization Schedule Principal Coupon Interest 90,000 115,000 120,000 120,000 125,000 130,000 135,000 140,000 145,000 150,000 155,000 165,000 170,000 180~00 185,000 195~00 205,000 215~00 225,000 235~00 $ 3,200,000 Period Total $ 73,314.49 $ 73,314.49 2.75 % 68,023.75 158,023.75 66,786.25 66,786.25 3.00 66,786.25 181,786.25 65,061.25 65,061.25 3.25 65,061.25 185,061.25 ' 63,111.25 63,111.25 3.50 63,111.25 183,111.25 61,011.25 61,011.25 3.60 61,011.25 186,011.25 58,761.25 58,761.25 4.00 58,761.25 188,761.25 56,161.25 56,161.25 4.10 56,161.25 191,161.25 53,393.75 53,393.75 4.15 53,393.75 193,393.75 50,488.75 50,488.75 4.20 50,488.75 195,488.75 47,443.75 47,443.75 4.25 47,443.75 197,443.75 44,256.25 44,256.25 4.30 44,256.25 199,256.25 40,923.75 40,923.75 4.35 40,923.75 205,923.75 37,335.00 37,335.00 4.40 37,335.00 207,335.00 33,595.00 33,595.00 4.50 33,595.00 213,595.00 29,545.00 29,545.00 4.55 29,545.00 214,545.00 25,336.25 25,336.25 4.60 25,336.25 220,336.25 20,851.25 20,851.25 4.70 20,851.25 225,851.25 16,033.75 16,033.75 4.75 16,033.75 231,033.75 10,927.50 10,927.50 4.70 10,927.50 235,927.50 5,640.00 5,640.00 4.80 5,640.00 240,640.00 $1,714,663.24 $4,914,663.24 -5- EXHIBIT D Fiscal .Total $231,338.24 248,572.50 250,122.50 246,222.50 247,022.50 247,522.50 247`322.50 246,787.50 245,977.50 244,887.50 243,512.50 246,847.50 244,670.00 247,190.00 244,090.00 245,672.50 246,702.50 247,067.50 246,855.00 246,280.00 [ [ [ [ [ [ F JEFFERSON¥ILLE MUNICIPAL SEWAGE WORKS JeffersonvilIe, Indiana Estimated Sources and Uses of Funds for the Sewage Works Revenue Bonds, Series 2003 Sources of Ftmds Bond Proceeds Total Sources of Funds $ 3,200,000 $ 3,200,000 Useg of Funds Construction Proceeds for Stormwater Utility Projects Indiana Bond Bank Fee Bond Counsel Local Counsel Financial Advisor Total Uses of Ftmds $ 3,060,000 80,000 25,000 15.000 20.000 $ 3.200,000 -6- SCHEDULE D-1 -7- JEFFERSONVILLE MUNICIPAL sEWAGE WORKS Jeffersonville, Indiana Bond and Interest Account Monthly Transfer Year. EXHIBIT F Monthly Deposit Monthly Deposit Sewage Works to Bond and Stormwater to Bond and Share of Interest Account for Share of Interest Account for Debt Service. Sewage Work~ _Debt Service Stormwate~ 2004 $ 1,487,074.00 $ 123,930.00 (1) $ 231,338.24 $ 19,280.00 (2) 2005 1,485,673.62 123,810.00 248,572.50 20,720.00 2006 1,483,073.58 123,590.00 250,122.50 20,850.00 20,520.00 2007 1,493,673.76 124,480.00 246,222.50 2008 1,496,673.74 124,730.00 247,022.50 20,590.00 2009 1,497,248.54 124,780.00 247,522.50 20,630.00 2010 1,500,328.52 125,030.00 247,322.50 20,620.00 2011 710,953.42 59,250.00 246,787.50 20,570.00 2012 710,953.38 59,250.00 245,977.50 20,500.00 2013 710,953.90 59,250.00 244,887.50 20,410.00 2014 710,953.04 59;250.00 243,512.50 20,300.00 2015 710,953.90 59,250.00 246,847.50 20,580.00 2016 710,954.00 59,250.00 244,670.00 20,390.00 2017 710,953.58 59,250.00 247,190.00 20,600.00 2018 710,953.30 59,250.00 244,090.00 20,350.00 2019 710,953.60 59,250.00 245,672.50 20,480.00 246,702.50 20,560.00 2020 247,067.50 20,590.00 2021 246,855.00 20,580.00 2022 246,280.00 20,530.00 2023 Totals $16,842,327.88 $ 4,914,663.24. (1) Monthly deposit amount of $123,930 to start in January, 2004. (2) Monthly deposit amount of $19,280 to start in January, 2004. -8-