Loading...
HomeMy WebLinkAboutSummary of the BondsJEFFERSONVILLE MUNICIPAL SEWAGE WORKS [effersonville, Indiana SUMMARY OF THE BONDS January 10, 2000 L, JEFFERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonville, Indiana TABLE OF CONTENTS PURPOSE OF THE REPORT EXHIBIT A Sinking Fund Requirements EXHIBIT B Combined Annual Debt Service EXHIBIT C Sewage Works Refund/ng Revenue Bonds of 1995 Amortization Schedule EXHIBIT D Sewage Works Revenue Bonds, Series 1998 Amortization Schedule EXHIBiT E Sewage Works Revenue Bonds, Series 1999 Estimated Amortization Schedule Page 1 2 3 4 5 JEFFERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonville, Indiana PURPOSE OF THE REPORT Crowe, Chizek and Company LLP (Crowe Chizek) has prepared this report to assist with the monthly transfers to the Sinking Fund. The amortization schedule for the Sewage Works Revenue Bonds, Series 1999 will be revised by. the State Budget Agency after the project is completed. At that time, this report will need to be updated to reflect the final amortization schedule. If you have any questions regarding this report, please call Mike Claytor or Jennifer Wilson of Crowe Chizek at (317) 632-1100. -1- Fiscal Year 2OOO 2001 2002 2003 2004 2005 20O6 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 JEFFERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonville, Indiana Sinking Fund Requirements Estimated Combined Estimated Annual Fiscal Agency Annual Debt Service Charge Total 1,257,965.00 1,377,861.08 1,484,513.82 1,481,513.04 1,487,073.96 1,485,673.60 1,483,073.56 1,493,673.76 1,496,673.74 1,497,248.54 1,500 328.52 710 953.42 710 953.38 710 953.90 710 953.04 710 953.90 710 954.00 710 953.58 710 953.30 710 953.60 Deposit Each Month EXHIBIT A 4,000.00 $ 1,261,965.00 $ 105,165.00 4,000.00 1,381,861.08 115,156.00 4,000.00 1,488,513.82 124,044.00 4,000.00 1,485,513.04 123,794.00 4,000.00 1,491,073.96 124,257.00 4,000.00 1,489,673.60 124,140.00 4,000.00 1,48~073.56 123,924.00 4,000.00 1,497,673.76 124,807.00 4,000.00 1,500,673.74 125,057.00 4,000.00 1,501,248.54 125,105.00 4,000.00 1,504,328.52 125,362.00 2,000.00 712,953.42 59,414.00 2,000.00 712,953.38 59,414.00 2,000.00 712,953.90 59,414.00 2,000.00 712,953.04 59,414.00 2,000.00 712,953.90 59,414.00 2,000.00 712,954.00 59,414.00 2,000.00 712,953.58 59,414.00 Z000.00 712,953.30 59,414.00 710,953.60 59,247.00 -2- JEFFERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonville, Indiana Combined Annual Debt Service EXHIBIT B Fiscal 1995 1998 Year Bonds Bonds 2OOO 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 20~7 2018 2019 Estimated 1999 Bonds Estimated Combined Armual Debt Service. 765,195.00 764,945.00 773,56O.OO 770,560.00 776,120.00 774,720.00 772,120.00 782,720.00 785,720.00 786,295.00 789,375.00 $ 492,770.O0 493,740.00 489,065.00 488,945.00 488,385.00 492,385.00 490,725.00 488,625.00 491,085.00 492,885.O0 494,025.00 494,505.00 499,325.00 50Z900.00 500,575.00 50~575.00 508,450.00 513,425.00 517,275.00 119 176.08 221 888.82 222 008.04 222 568.96 218 568.60 220 228.56 222328.76 219 868.74 218 068.54 216 928.52 216448.42 211 628.38 208 053.90 210 378.04 203 378.90 202 504.00 197 528.58 193,678.30 710,953.60 $ 1,25Z965.00 1,377,861.08 1,484,513.82 1,481,513.04 1,48Z073.96 1,485,673.60 1,483,073.56 1,493,673.76 1,496,673.74 1,49~248.54 1,500,328.52 710,953.42 710,953.38 710,953.90 710,953.04 710,953.90 710,954.00 710,953.58 710,953.30 710,953.60 $8,541,330.00 $9,446,665.00 $ 4,456,185.74 $22,444,180.74 Maximum Annual Debt Service (2010) $ 1,500,329 -3- Date 7/1/oo 1/1/Ol 7/1/Ol 1/1/o2 7/1/o2 1/1/o3 7/1/o3 1/1/o4 7/1/04 1/1/o5 7/1/o5 1/1/o6 7/1/o6 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 Principal $ 450,000 470,000 500,000 520,000 550,000 575,000 600,000 640,000 675,000 710,000 750,000 $6,440,000 JEFFERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonville, Indiana Sewage Works Refunding Revenue Bonds of 1995 Amortization Schedule Period Fiscal Coupon Interest Total Total 4.50 % 4.55 4.60 4.70 4.80 4.80 4.90 5.00 5.10 5.20 5.25 157 597.50 157 597.50 147 472.50 147 472.50 136 780.0O 136 780.00 125 280.00 125 280.00 113 060.00 113 060.00 99,860.00 99,860.00 86,060.00 86,060.00 71,360.00 71,360.00 55,360.00 55,360.00 38,147.50 38,147.50 19,687.50 19,687.50 $ 15%597.50 60%597.50 14%472.50 617,472.50 136,780.00 636,780.00 125,280.00 645,280.00 113,060.00 663,060.00 99,860.00 674,860.00 86,060.00 686,060.00 71,360.00 711,360.00 55,360.00 730,360.00 38,147.50 748,147.50 19,687.50 769,687.50 $ 2,101,330.00 $8,541,330.00 -4- EXHIBIT C $ 765,195.00 764,945.OO 773,560.00 770,56O.00 776,120.00 774,720.00 772,120.00 782,720.00 785,720.00 786,295.00 789,375.00 JEFFERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonville, Indiana Sewage Works Revenue Bonds, Series 1998 Amortization Schedule Date Principal Coupon Interest 7/1/oo 1/1/Ol 7/1/Ol 1/1/o2 7/1/o2 1/1/o3 7/1/o3 1/1/o4 7/1/o4 1/1/o5 7/1/o5 1/1/o6 7/1/o6 1/1/o7 7/1/o7 1/1/o8 7/1/o8 1/1/o9 7/1/o9 1/1/lO 7/1/lO 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 Period To~l 215,000 225,000 230,000 240,000 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 4.20 % 4.30 4.40 4.40 4.40 4.40 4.40 4.40 4.40 4.40 4.40 4.40 4.50 4.50 4.50 4.50 4.50 $ 138,885.00 138,885.00 134 370.00 134 370.00 129 532.50 129 532.50 124472.50 124472.50 119192.50 119 192.50 113 692.50 113 692.50 107 862.50 107 862.50 101,812.50 101,812.50 95,542.50 95,542.50 88,942.50 88,942.50 8Z012.50 82,012.50 74,752.50 74,752.50 6Z162.50 67,162.50 58,950.00 58,950.00 50,287.50 50,287.50 41,287.50 41,287.50 31,725.00 31,725.00 $ 138 885.00 353 885.00 134 370.00 359 370.00 129 532.50 359 532.50 124472.50 364 47Z50 119 192.50 369 192.50 113 692.50 378692.50 107 862.50 382 862.50 101 812.50 386 812.50 95,542.50 395,542.50 88,942.50 403,942.50 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 -5- EXHIBIT D Fiscal Total $ 492,770.00 493,740.00 489,065.00 488,945.00 488,385.00 492,385.00 490,725.00 488,625.00 491,085.00 49Z885.00 494,025.00 494,505.00 499,325.00 50Z900.00 500,575.00 507,575.00 508,450.00 JEFFERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonville, Indiana Sewage Works Revenue Bonds, Series 1998 Amortization Schedule Date Principal Coupon Interest 7/1/17 1/1/18 470,000 4.50 % 7/1/18 1/1/19 495,000 4.50 Totals $ 6,260,000 21,712.50 21,712.50 11,137.50 11,137.50 $3,186,665.00 Period Total 21,712.50 491,712.50 11,137.50 506,137.50 $9,446,665.00 -6- EXHIBIT D (Continued) Fiscal Total 513,425.00 517,275.00 Date~ 1/1/02 7/1/02 1/1/03 7/1/o3 1/1/o4 7/1/04 1/1/05 7/1/o5 1/1/o6 7/1/o6 1/1/o7 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 JEFFERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonville, Indiana Sewage Works Revenue Bonds, Series 1999 Estimated Amortization Schedule Principal Coupon Interest 118,903 2.90 % 273.08 47,430.91 ~_~7~27__ 2.90 47,430.91 45,589.02 130,830 2.90 45,589.02 43,691.98 135,185 2.90 43,691.98 41,731.80 135,105 2.90 41,731.80 39,772.78 140,683 2.90 39,772.78 37,732.88 146,863 2.90 37,732.88 35,603.37 148,662 2.90 35,603.37 33,447.77 151,173 2.90 33,447.77 31,255.76 154,417 2.90 31,255.76 29,016.71 158,415 2.90 29,016.71 26,719.69 158,189 2.90 26,719.69 24,425.95 159,202 2.90 24,425.95 22,117.52 166,143 2.90 22,117.52 19,708.45 163,962 2.90 19,708.45 17,331.00 167,842 2.90 17,331.00 14,897.29 167,734 2.90 14,897.29 Period Fiscal Total Total $ 119,176~08 $ 119,176.08 47,430.91 174,457.91 221,888.82 45,589.02 176,419.02 222,008.04 43,691.98 178,876.98 222,568.96 41~731.80 176,836.80 218,568.60 39,772.78 180,455.78 220,228.56 37,732.88 184,595.88 222,328.76 35,603.37 184,265.37 219,868.74 33,447.77 184,620.77 218,068.54 31,255.76 185,672.76 216,928.52 29,016.71 187,431.71 216,448.42 26,719.69 184,908.69 211,628.38 24,425.95 183,627.95 208,053.90 22,117.52 188,260.52 210,378.04 19,708.45 183,670.45 203,378.90 17,331.00 185,173.00 202,504.00 14,897.29 182,631.29 197,528.58 EXHIBIT E -7- EXHIBIT E · , (Continued) JEFFERSONVILLE MUNICIPAL SEWAGE WORKS Jeffersonvi!le, Indiana Sewage Works Revenue Bonds, Series 1999 Estimated Amortization Schedule Date Principal Coupon Interest 7/1/18 1/1/19 168,748 2.90 % 7/1/19 1/1/20 690,917 2.90 Totals $ 3,390,000 12,465.15 12,465.15 10,018.30 10,018.30 $1,066,185.74 Period Total 12,465.15 181,213.15 1~018.30 700,935.30 $4,456,185.74 -8- Fiscal Total 193,678.30 710,953.60 >