Loading...
HomeMy Public PortalAboutExhibit MSD 67L MSD_TIC_Calculations - Excel Version 5/6/2004 -173957693.30000001 585000 -173372693.30000001 11/28/2006 -63068705.100000001 241700 -62827005.100000001 11/25/2008 -29697429.07 -29697429.07 11/1/2004 3969453.91 3969453.91 5/1/2007 1233350 1233350 5/1/2009 707388.5 707388.5 5/1/2005 4082866.88 4082866.88 11/1/2007 1451000 1451000 11/1/2009 816217.5 816217.5 11/1/2005 4082866.88 4082866.88 5/1/2008 1451000 1451000 5/1/2010 816217.5 816217.5 5/1/2006 5582866.8799999999 5582866.8799999999 1500000 2979166.6666666665 11/1/2008 1451000 1451000 11/1/2010 816217.5 816217.5 11/1/2006 4067866.88 4067866.88 0 0 5/1/2009 1451000 1451000 5/1/2011 816217.5 816217.5 5/1/2007 5572866.8799999999 5572866.8799999999 1505000 4494097.222222222 11/1/2009 1451000 1451000 11/1/2011 816217.5 816217.5 11/1/2007 4052816.88 4052816.88 0 0 5/1/2010 1451000 1451000 5/1/2012 816217.5 816217.5 5/1/2008 5562816.8799999999 5562816.8799999999 1510000 6019027.777777778 11/1/2010 1451000 1451000 11/1/2012 816217.5 816217.5 11/1/2008 4033941.88 4033941.88 0 0 5/1/2011 1451000 1451000 5/1/2013 816217.5 816217.5 5/1/2009 5553941.8799999999 5553941.8799999999 1520000 7578888.8888888881 11/1/2011 1451000 1451000 11/1/2013 816217.5 816217.5 11/1/2009 4013041.88 4013041.88 0 0 5/1/2012 1451000 1451000 5/1/2014 816217.5 816217.5 5/1/2010 5608041.8799999999 5608041.8799999999 1595000 9547847.222222222 11/1/2012 1451000 1451000 11/1/2014 816217.5 816217.5 11/1/2010 3989116.88 3989116.88 0 0 5/1/2013 1451000 1451000 5/1/2015 816217.5 816217.5 5/1/2011 5769116.8799999999 5769116.8799999999 1780000 12435277.777777778 11/1/2013 1451000 1451000 11/1/2015 816217.5 816217.5 11/1/2011 3960191.88 3960191.88 0 0 5/1/2014 1451000 1451000 5/1/2016 816217.5 816217.5 5/1/2012 5920191.8799999999 5920191.8799999999 1960000 15652777.777777776 11/1/2014 1451000 1451000 11/1/2016 816217.5 816217.5 11/1/2012 3925891.88 3925891.88 0 0 5/1/2015 1451000 1451000 5/1/2017 816217.5 816217.5 5/1/2013 6090891.8799999999 6090891.8799999999 2165000 19454930.555555556 11/1/2015 1451000 1451000 11/1/2017 816217.5 816217.5 11/1/2013 3886921.88 3886921.88 0 0 5/1/2016 1451000 1451000 5/1/2018 816217.5 816217.5 5/1/2014 6261921.8799999999 6261921.8799999999 2375000 23717013.888888888 11/1/2016 1451000 1451000 11/1/2018 816217.5 816217.5 11/1/2014 3842390.63 3842390.63 0 0 5/1/2017 1451000 1451000 5/1/2019 816217.5 816217.5 5/1/2015 6457390.6299999999 6457390.6299999999 2615000 28728680.555555556 11/1/2017 1451000 1451000 11/1/2019 816217.5 816217.5 11/1/2015 3790090.63 3790090.63 0 0 5/1/2018 1451000 1451000 5/1/2020 816217.5 816217.5 5/1/2016 6645090.6299999999 6645090.6299999999 2855000 34220347.222222224 11/1/2018 1451000 1451000 11/1/2020 816217.5 816217.5 11/1/2016 3732990.63 3732990.63 0 0 5/1/2019 1451000 1451000 5/1/2021 816217.5 816217.5 5/1/2017 6857990.6299999999 6857990.6299999999 3125000 40581597.222222224 11/1/2019 1451000 1451000 11/1/2021 816217.5 816217.5 11/1/2017 3670490.63 3670490.63 0 0 5/1/2020 1451000 1451000 5/1/2022 816217.5 816217.5 5/1/2018 7075490.6299999999 7075490.6299999999 3405000 47622708.333333328 11/1/2020 1451000 1451000 11/1/2022 816217.5 816217.5 11/1/2018 3600262.5 3600262.5 0 0 5/1/2021 1451000 1451000 5/1/2023 816217.5 816217.5 5/1/2019 7340262.5 7340262.5 3740000 56048055.555555552 11/1/2021 1451000 1451000 11/1/2023 816217.5 816217.5 11/1/2019 3509687.5 3509687.5 0 0 5/1/2022 1451000 1451000 5/1/2024 816217.5 816217.5 5/1/2020 7599687.5 7599687.5 4090000 65383194.44444444 11/1/2022 1451000 1451000 11/1/2024 816217.5 816217.5 11/1/2020 3407640.63 3407640.63 0 0 5/1/2023 1451000 1451000 5/1/2025 816217.5 816217.5 5/1/2021 7867640.6299999999 7867640.6299999999 4460000 75758055.555555552 11/1/2023 1451000 1451000 11/1/2025 816217.5 816217.5 11/1/2021 3296515.63 3296515.63 0 0 5/1/2024 1451000 1451000 5/1/2026 816217.5 816217.5 5/1/2022 8156515.6299999999 8156515.6299999999 4860000 87412500 11/1/2024 1451000 1451000 11/1/2026 816217.5 816217.5 11/1/2022 3183840.63 3183840.63 0 0 5/1/2025 1451000 1451000 5/1/2027 816217.5 816217.5 5/1/2023 8463840.6300000008 8463840.6300000008 5280000 100246666.66666667 11/1/2025 1451000 1451000 11/1/2027 816217.5 816217.5 11/1/2023 3054381.25 3054381.25 0 0 5/1/2026 1451000 1451000 5/1/2028 816217.5 816217.5 5/1/2024 8784381.25 8784381.25 5730000 114520416.66666667 11/1/2026 1451000 1451000 11/1/2028 816217.5 816217.5 11/1/2024 2911131.25 2911131.25 0 0 5/1/2027 5451000 5451000 4000000 81700000 5/1/2029 816217.5 816217.5 5/1/2025 9121131.25 9121131.25 6210000 130323750 11/1/2027 1368500 1368500 0 0 11/1/2029 816217.5 816217.5 11/1/2025 2763643.75 2763643.75 0 0 5/1/2028 5813500 5813500 4445000 95234125 5/1/2030 3466217.5 3466217.5 2650000 56798333.333333336 5/1/2026 12653643.75 12653643.75 9890000 217442638.8888889 11/1/2028 1257375 1257375 0 0 11/1/2030 748642.5 748642.5 0 0 11/1/2026 2528756.25 2528756.25 0 0 5/1/2029 5922375 5922375 4665000 104612625 5/1/2031 3373642.5 3373642.5 2625000 58887500 5/1/2027 12743756.25 12743756.25 10215000 234803125 11/1/2029 1140750 1140750 0 0 11/1/2031 681048.75 681048.75 0 0 11/1/2027 2286150 2286150 0 0 5/1/2030 6040750 6040750 4900000 114782500 5/1/2032 3441048.75 3441048.75 2760000 64676000 5/1/2028 13706150 13706150 11420000 273921388.8888889 11/1/2030 1018250 1018250 0 0 11/1/2032 609288.75 609288.75 0 0 11/1/2028 2014925 2014925 0 0 5/1/2031 6158250 6158250 5140000 125544500 5/1/2033 3519288.75 3519288.75 2910000 71101000 5/1/2029 13974925 13974925 11960000 298833888.8888889 11/1/2031 909025 909025 0 0 11/1/2033 532901.25 532901.25 0 0 11/1/2029 1730875 1730875 0 0 5/1/2032 6269025 6269025 5360000 136278000 5/1/2034 3597901.25 3597901.25 3065000 77953166.666666672 5/1/2030 14260875 14260875 12530000 325605972.22222221 11/1/2032 787250 787250 0 0 11/1/2034 452445 452445 0 0 11/1/2030 1417625 1417625 0 0 5/1/2033 6392250 6392250 5605000 148112125 5/1/2035 3682445 3682445 3230000 85379666.666666672 5/1/2031 14572625 14572625 13155000 355002291.66666669 11/1/2033 647125 647125 0 0 11/1/2035 366850 366850 0 0 11/1/2031 1088750 1088750 0 0 5/1/2034 6532125 6532125 5885000 161396125 5/1/2036 3791850 3791850 3425000 93959166.666666672 5/1/2032 14903750 14903750 13815000 386628125 11/1/2034 500000 500000 0 0 11/1/2036 268381.25 268381.25 0 0 11/1/2032 743375 743375 0 0 5/1/2035 10500000 10500000 10000000 284250000 5/1/2037 4798381.25 4798381.25 4530000 128803000 5/1/2033 15248375 15248375 14505000 420443541.66666669 11/1/2035 250000 250000 0 0 11/1/2037 138143.75 138143.75 0 0 11/1/2033 380750 380750 0 0 5/1/2036 10250000 10250000 10000000 294250000 5/1/2038 4943143.75 4943143.75 4805000 141427166.66666666 5/1/2034 15610750 15610750 15230000 456688472.22222221 360986178.44999993 187613485.14999992 175000000 3852094444.4444442 135029900 72202894.900000006 60000000 1546160000 72583926 42886496.93 30000000 778985000 175000000 60000000 30000000 469594.55 3411105.1 229552.4 0 0 0 -1511901.25 -342400 -532123.32999999996 173957693.30000001 63068705.100000001 29697429.07 4.8679451082650302E-2 4.5326152903566959E-2 5.527216667846381E-2 22.011968253968252 25.769333333333332 25.966166666666666 Prepared by Public Financial Management, Inc Page of Metropolitan St. Louis Sewer District Payment Date Service Bond Debt Total Par Amount Accrued Interest Bond Cash Flows Purchase Price to MSD Purchase of Bond Insurance Cash Flow Underwriter's Discount Purchase Price Wastewater System Revenue Bonds, Series 2004A True Interest Cost Wastewater System Revenue Bonds, Series 2006C Wastewater System Revenue Bonds, Series 2008A Average Maturity Bond Years Principal Historical Average Life & True Interest Cost (TIC) Calculations Premium/Discount Exhibit MSD 67L