Loading...
HomeMy Public PortalAboutExhibit MSD 86D - Excel Version of Appendix 7.5.1 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 0 8388316 9004459.7955390327 9516132.5059390329 9968327.718899034 10359569.333787274 10683750.425925277 10939155.341754043 11124032.265579382 11236592.444193229 11275009.475171354 0 4918215.7955390336 4942806.8703999994 4967520.9220000003 4992358.5123999994 5017320.3275999995 5042406.9359999998 5067618.9843999995 5092957.0803999994 5118421.8707999997 5144014.0023999996 -2014 -4302072 -4431134.16 -4515325.7090399992 -4601116.8975117588 -4693139.235461995 -4787002.0201712344 -4882742.0605746601 -4980396.9017861523 -5080004.839821876 -5232404.9850165322 -2014 616143.7955390336 511672.71039999928 452195.21296000108 391241.61488824058 324181.09213800449 255404.91582876537 184876.92382533941 112560.17861384712 38417.030978123657 -88390.982616532594 -2014 9004459.7955390327 9516132.5059390329 9968327.718899034 10359569.333787274 10683750.425925277 10939155.341754043 11124032.265579382 11236592.444193229 11275009.475171354 11186618.492554821 2913622.4613698628 2968981.2881358899 3025391.9326104713 3085899.7712626816 3147617.7666879348 3210570.1220216942 3274781.5244621271 3340277.1549513703 3440485.4695999115 3543700.0336879087 6090837.3341691699 6547151.217803143 6942935.7862885632 7273669.5625245925 7536132.659237342 7728585.2197323497 7849250.7411172548 7896315.2892418588 7834524.0055714417 7642918.4588669129 20859440 27850916.018811051 34330087.465789385 35700007.535250679 35711201.689729981 25301795.094885379 19621794.233985309 19360647.088151731 19897922.473538857 21825004.183140602 0 11709374.779999999 11709374.779999999 24607839.900000002 24730879 24854533.5 24978806.200000003 25103700.300000001 25229218.800000001 25355364.900000002 25482141.800000001 1368464.3699999999 1382149.0136999998 0 0 0 0 0 0 0 0 2939311.1632800405 1580993.3422681943 1774509.2974080232 1383167.0745129583 1371394.751156349 1296385.7623597891 1200378.5122421768 1116838.9132177287 1144229.414544926 1109199.9159582132 1088818.539902085 2939311.1632800405 14658832.492268194 14866033.091108022 25991006.974512961 26102273.751156349 26150919.262359791 26179184.712242179 26220539.213217728 26373448.214544926 26464564.815958217 26570960.339902084 0 -1700989.3966041948 -1761671.8638873016 -1109197.828745699 -1193615.6402600096 -1197389.4018557353 -1232936.7448978149 -1268225.132447737 -1306326.7824952076 -1345487.8574687906 -1389788.2715570868 8813971.0608800407 -5966367.0768529512 -6625189.7802423863 -15106478.260079918 -17941313.032743227 -16914141.415549688 -17491746.743898913 -17791140.347898554 -18290248.753041379 -18864619.128213618 -19378762.823923338 8813971.0608800407 -7667356.4734571464 -8386861.6441296879 -16215676.088825617 -19134928.673003238 -18111530.817405425 -18724683.48879673 -19059365.480346292 -19596575.535536587 -20210106.985682409 -20768551.095480423 11753282.224160081 6991476.0188110471 6479171.4469783353 9775330.8856873419 6967345.078153111 8039388.4449543655 7454501.223445449 7161173.7328714356 6776872.6790083386 6254457.8302758075 5802409.2444216609 0 0 0 0 0 0 0 0 0 0 0 4.7677819106685115E-2 6.9849193096160889E-10 4.6566128730773926E-10 -8405410.8162260558 -6956150.9236738104 -18448795.039798968 -13134502.08434552 -7422320.8787050135 -6239597.293621215 -4327376.1206740625 -2728800.3736650259 11753282.271837899 6991476.018811048 6479171.4469783362 1369920.0694612861 11194.154479300603 -10409406.594844602 -5680000.8609000705 -261147.14583357796 537275.38538712356 1927081.709601745 3073608.870756635 27850916.018811043 34330087.465789385 35700007.535250664 35711201.689729989 25301795.094885379 19621794.233985312 19360647.088151738 19897922.473538857 21825004.183140598 24898613.053897236 10490528.747920889 13631343.647911638 15607262.840886572 14994851.541611454 15459738.416855646 15742755.643345281 16160201.054677965 16629114.624989118 17096519.066628136 17618446.405810464 17360387 20698744 20092745 20716350 9842057 3879039 3200446 3268808 4728485 7280167 39536253 36023579.812372468 24220658.222951844 11993829.604540126 2483366.2061672937 343380.71954343002 282002.97611501731 880390.70277907979 1130723.3736790798 1206760.7684584549 8777797.5999999978 8777797.5999999978 0 0 0 0 0 0 0 0 0.23215408384847014 -3045000 -3136350 0 0 0 0 0 0 0 0 0 -9245470.7876275256 -17444369.189420626 -12226828.618411718 -9510463.3983728327 -2139985.4866238637 -61377.743428412723 598387.72666406247 250332.6709 76037.394779374983 8270.6492268749989 0.23215408384847014 -3512673.1876275279 -11802921.589420628 -12226828.618411718 -9510463.3983728327 -2139985.4866238637 -61377.743428412723 598387.72666406247 250332.6709 76037.394779374983 8270.6492268749989 36023579.812372468 24220658.222951844 11993829.604540126 2483366.2061672937 343380.71954343002 282002.97611501731 880390.70277907979 1130723.3736790798 1206760.7684584549 1215031.4176853299 0 1.9599999999999999E-2 1.9599999999999999E-2 1.9599999999999999E-2 1.9599999999999999E-2 1.9599999999999999E-2 1.9599999999999999E-2 1.9599999999999999E-2 1.9599999999999999E-2 1.9599999999999999E-2 1.9599999999999999E-2 0 0 0 8.7999999999999995E-2 8.7999999999999995E-2 8.7999999999999995E-2 8.7999999999999995E-2 8.7999999999999995E-2 8.7999999999999995E-2 8.7999999999999995E-2 8.7999999999999995E-2 0 0 0 1.2E-2 1.2E-2 1.2E-2 1.2E-2 1.2E-2 1.2E-2 1.2E-2 1.2E-2 Arial,Bold" 4 Exhibit MSD 86D 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 20859440 27850916.018811051 34330087.465789385 29594153.546560623 27325055.779909518 14238091.382899094 8620580.8258399032 5735066.2612561127 1431693.9560084026 791018 0 11709374.779999999 11709374.779999999 1368464.3699999999 1382149.0136999998 0 0 0 0 0 0 0 0 2939311.1632800405 1580993.3422681943 1774509.2974080232 1383167.0745129583 1136841.9684111788 991952.42928353033 675489.58037477161 490668.69247671083 338946.91022540146 79809.076439725919 39462.766537261086 2939311.1632800405 14658832.492268194 14866033.091108022 1383167.0745129583 1136841.9684111788 991952.42928353033 675489.58037477161 490668.69247671083 338946.91022540146 79809.076439725919 39462.766537261086 0 -1700989.3966041948 -1761671.8638873016 0 0 0 0 0 0 0 0 8813971.0608800407 -5966367.0768529512 -6625189.7802423863 0 0 0 0 0 0 0 0 8813971.0608800407 -7667356.4734571464 -8386861.6441296879 0 0 0 0 0 0 0 0 11753282.224160081 6991476.0188110471 6479171.4469783353 1383167.0745129583 1136841.9684111788 991952.42928353033 675489.58037477161 490668.69247671083 338946.91022540146 79809.076439725919 39462.766537261086 0 0 0 0 0 0 0 0 0 0 0 4.7677819106685115E-2 1.6298145055770874E-9 4.6566128730773926E-10 -5119100.9937417191 -2405939.7350622821 -13078916.826293953 -5293000.137433962 -3376183.2570605008 -4642319.2154731117 -720485.5149850992 -767157.77073050151 0 0 -1000000 -1000000 -1000000 -1000000 0 0 0 0 11753282.271837899 6991476.0188110489 6479171.4469783362 -4735933.9192287605 -2269097.7666511033 -13086964.397010423 -5617510.5570591902 -2885514.56458379 -4303372.3052477101 -640676.43854537327 -727695.00419324043 27850916.018811043 34330087.465789385 29594153.546560623 27325055.779909518 14238091.382899094 8620580.8258399032 5735066.2612561127 1431693.9560084026 791018 63323 0 0 0 6105853.9886900485 8386145.9098204542 11063703.711986274 11001213.40814539 13625580.826895602 18466228.517530441 21033986.665677559 1219799.97 0 0 21654899.112000003 21763173.52 21871989.48 21981349.456000004 22091256.264000002 22201712.544 22312721.112000003 22424284.784000002 0.09 0 0 0 234552.78274517017 304433.33307625877 524888.93186740519 626170.22074101795 805282.50431952463 1029390.8395184872 1049355.7733648238 1219800.06 0 0 21654899.112000003 21997726.302745171 22176422.813076258 22506238.38786741 22717426.484741021 23006995.048319526 23342111.951518491 23473640.557364825 -39514595.950000003 0 0 -1109197.828745699 -1193615.6402600096 -1197389.4018557353 -1232936.7448978149 -1268225.132447737 -1306326.7824952076 -1345487.8574687906 -1389788.2715570868 39514595.960000001 0 0 -15106478.260079918 -17941313.032743227 -16914141.415549688 -17491746.743898913 -17791140.347898554 -18290248.753041379 -18864619.128213618 -19378762.823923338 9.9999979138374329E-3 0 0 -16215676.088825617 -19134928.673003238 -18111530.817405425 -18724683.48879673 -19059365.480346292 -19596575.535536587 -20210106.985682409 -20768551.095480423 1219800.0700000003 0 0 5439223.0231743846 2862797.6297419332 4064891.9956708327 3781554.8990706801 3658061.0043947287 3410419.5127829388 3132004.9658360817 2705089.4618844017 0 0 0 2952940.7880000002 2967705.48 2982544.02 2997456.7440000004 3012444.0359999998 3027506.2560000001 3042643.7880000002 3057857.0159999998 2014 1.6298145055770874E-9 4.6566128730773926E-10 -1286309.822484337 -1550211.1886115286 -2369878.2135050148 -4841501.9469115576 -4046137.6216445128 -1597278.0781481024 -3606890.6056889636 -1961642.6029345244 -1000000 -2000000 -2000000 -2000000 0 0 0 0 1221814.0700000003 1.6298145055770874E-9 4.6566128730773926E-10 6105853.9886900485 2280291.9211304048 2677557.8021658175 -62490.303840876557 2624367.4187502163 4840647.6906348364 2567758.1481471187 3801303.8749498772 1.6298145055770874E-9 4.6566128730773926E-10 6105853.9886900485 8386145.9098204542 11063703.711986274 11001213.40814539 13625580.826895602 18466228.517530441 21033986.665677559 24835290.540627435 20859440 27850916.018811051 34330087.465789385 35700007.535250671 35711201.689729974 25301795.094885368 19621794.233985294 19360647.088151716 19897922.473538846 21825004.665677559 -642488.72584432364 11709374.779999999 11709374.779999999 21654899.112000003 21763173.52 21871989.48 21981349.456000004 22091256.264000002 22201712.544 22312721.112000003 22424284.784000002 1580993.3422681943 1774509.2974080232 1383167.0745129583 1371394.751156349 1296385.7623597891 1200378.5122421768 1116838.9132177287 1144229.414544926 1109199.9159582132 1088818.539902085 -642488.72584432364 14658832.492268194 14866033.091108022 23038066.186512962 23134568.271156348 23168375.242359787 23181727.96824218 23208095.177217733 23345941.958544929 23421921.027958218 23513103.323902085 -34772166.053333335 -1700989.3966041948 -1761671.8638873016 -1109197.828745699 -1193615.6402600096 -1197389.4018557353 -1232936.7448978149 -1268225.132447737 -1306326.7824952076 -1345487.8574687906 -1389788.2715570868 -5966367.0768529512 -6625189.7802423863 -15106478.260079918 -17941313.032743227 -16914141.415549688 -17491746.743898913 -17791140.347898554 -18290248.753041379 -18864619.128213618 -19378762.823923338 -7667356.4734571464 -8386861.6441296879 -16215676.088825617 -19134928.673003238 -18111530.817405425 -18724683.48879673 -19059365.480346292 -19596575.535536587 -20210106.985682409 -20768551.095480423 6991476.0188110471 6479171.4469783353 6822390.0976873431 3999639.598153112 5056844.4249543631 4457044.4794454519 4148729.6968714395 3749366.4230083404 3211814.0422758074 2744552.2284216629 0 0 0 2952940.7880000002 2967705.48 2982544.02 2997456.7440000004 3012444.0359999998 3027506.2560000001 3042643.7880000002 3057857.0159999998 4918215.7955390336 3.2596290111541748E-9 9.3132257461547852E-10 -6405410.8162260558 -3956150.9236738104 -15448795.039798968 -10134502.08434552 -7422320.8787050135 -6239597.2936212141 -4327376.1206740625 -2728800.3736650259 0 0 -2000000 -3000000 -3000000 -3000000 0 0 0 0 6991476.0188110508 6479171.4469783362 1369920.0694612879 11194.154479301535 -10409406.594844606 -5680000.8609000668 -261147.14583357377 537275.38538712636 1927081.7096017455 3073608.8707566368 27850916.018811043 34330087.465789385 35700007.535250671 35711201.689729974 25301795.094885368 19621794.233985294 19360647.088151716 19897922.473538846 21825004.665677559 24898613.540627435 27850916.018811043 34330087.465789385 35700007.535250664 35711201.689729989 25301795.094885379 19621794.233985312 19360647.088151738 19897922.473538857 21825004.183140598 24898613.053897236 10514791.837056737 13674885.262229662 15607262.840886572 14994851.541611454 15459738.416855646 15742755.643345281 16160201.054677965 16629114.624989118 17096519.066628136 17618446.405810464 17336124 20655202 20092745 20716350 9842057 3879039 3200446 3268808 4728485 7280167 -8405410.8162260558 -6956150.9236738104 -18448795.039798968 -13134502.08434552 -7422320.8787050135 -6239597.293621215 -4327376.1206740625 -2728800.3736650259 7512901 5993656 16325528.643749997 10681625.452734374 4859408.355840819 3574168.2697819322 1555329.9359453332 -154127.65845910212 -892509.81622605585 -962494.92367381044 -2123266.3960489705 -2452876.631611146 -2562912.5228641946 -2665429.0238392828 -2772046.1847287295 -2882928.0321241282 0.72915443831587967 0.50010762210046922 0.76625576588456101 0.46514945098493948 0.43097740909104715 0.68054931701914645 0.21937800855085668 0.36809979131077014 0.27084556168412027 0.49989237789953084 0.23374423411543907 0.53485054901506057 0.56902259090895291 0.3194506829808535 0.78062199144914335 0.6319002086892298 -650777.4937417187 -481351.04756228195 -1626965.1184814556 -1140954.2185277122 -1104557.3988310096 -1713955.9017368341 -508125.97161678888 -961205.20698886085 -241732.32248433706 -481143.87611152855 -496301.27756751515 -1311922.4130834339 -1458355.124033185 -951473.12210244848 -2263920.2131119408 -1921722.8251352671 -100000 -100000 -100000 1383167.0745129583 1371394.751156349 1296385.7623597891 1200378.5122421768 1116838.9132177287 1144229.414544926 1109199.9159582132 1088818.539902085 1000000 2000000 2000000 2000000 1000000 1000000 1000000 1000000 4468323.5 1924588.6875 11451951.707812497 4152045.91890625 2271625.8582294914 2928363.3137362781 212359.54336831038 -194047.43625835932 1044577.5 1069067.3125 1873576.9359374999 3529579.5338281239 2587782.4976113276 645804.95604565402 1342970.3925770228 39919.777799257194 Arial,Bold" 4 Exhibit MSD 86D Metropolitan St. Louis Sewer District Cost of Service and Financial Planning Model Key Scenario Results - Stormwater Beginning Balance - Regulatory Fund Regulatory Tax Revenue Regulatory Expenses - Subtotal: Annual Surplus / (Deficit) Ending Balance - Regulatory Fund Target Balance (240 Days O&M) Over / (Under) Target Balance Beginning Balance - Operating Funds Revenues Stormwater Service Tax (5₵/8.8 ₵ Tax) Miscellaneous Revenue Subtotal: Revenues Operating Expenses Engineering Other Operations Subtotal: Operating Expenses Income before Capital Revenue From Incremental Tax (1.2₵ Tax) Capital Projects (Includes IR) Ending Balance - Operating Fund Beginning Balance - OMCI Funds OMCI Tax Revenue Stormwater Operations OMCI Capital Projects Ending Balance - OMCI Funds Stormwater Tax Rates Tax-Based Charges (per $100 Assessed Taxable Value) Regulatory Tax Stormwater O&M Stormwater Incremental Stormwater Service Tax (5₵ Tax) Stormwater Service Tax (8.8 ₵ Tax) Misc Rev Combined Ending Balance Capital Projects Infrastructure Repair Total with labor Labor Amount Cap Labor Adjustment 5130 Cap Labor Allocation 5130 Stormwater O&M Fund (5130) Proposed District Wide Stormwater Fund (5120) Input from T38 on Inflation spreadsheet (5130) Input from T9 on Inflation spreadsheet (5120) 5120 Cap Labor Allocation 5120 IR 5130 IR Stormwater Flat Fee Revenue 5120 Total W/O labor (T36) Regulatory Fund Stormwater Service Funds OMCI District Funds Annual Activity Stormwater Service Funds (Combined) Joe Crea: Includes capitalized internal labor