{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["SCHEDULE MJL-D1-1","SCHEDULE MJL-D1-2","SCHEDULE MJL-D2-1","SCHEDULE MJL-D2-2","SCHEDULE MJL-D3","SCHEDULE MJL-D4","SCHEDULE MJL-D5","SCHEDULE MJL-D6","SCHEDULE MJL-D7","SCHEDULE MJL-D8","SCHEDULE MJL-D9","SCHEDULE MJL-D10","SCHEDULE MJL-D11-1","SCHEDULE MJL-D11-4","SCHEDULE MJL-D12-1","SCHEDULE MJL-D12-2","SCHEDULE MJL-D14-1","SCHEDULE MJL-D14-2","SCHEDULE MJL-D15","SCHEDULE MJL-D16","SCHEDULE MJL-D17","SCHEDULE MJL-D18"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":35,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"SCHEDULE MJL-D1-1","index":0,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,6]]}
["AMEREN MISSOURI"]
["ORIGINAL COST OF GAS PLANT"]
[{"$f":"\"BY FUNCTIONAL CLASSIFICATION \"&'SCHEDULE MJL-D3'!A3:G3","v":"BY FUNCTIONAL CLASSIFICATION FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
["($000)"]
[]
[]
[null,null,null,null,"TOTALS","PRO FORMA","PRO FORMA"]
[null,null,null,null,"PER","ADJUSTMENTS","GAS"]
["LINE",null,"FUNCTIONAL CLASSIFICATION",null,"BOOKS","          (1)          ","TOTALS"]
[null,null,"(A)",null,"(B)","(C)","(D)"]
[]
[1,null,"INTANGIBLE PLANT",null,4563,{"$f":"15050+1","v":15051},{"$f":"SUM(E12:F12)","v":19614}]
[]
[{"$f":"+A12+1","v":2},null,"PRODUCTION PLANT",null,0,0,{"$f":"SUM(E14:F14)","v":0}]
[]
[{"$f":"+A14+1","v":3},null,"TRANSMISSION PLANT",null,6739,0,{"$f":"SUM(E16:F16)","v":6739}]
[]
[{"$f":"+A16+1","v":4},null,"DISTRIBUTION PLANT",null,517727,18743,{"$f":"SUM(E18:F18)","v":536470}]
[]
[{"$f":"1+A18","v":5},null,"GENERAL PLANT",null,{"$f":"31886","v":31886},25433,{"$f":"SUM(E20:F20)","v":57319}]
[]
[{"$f":"1+A20","v":6},null,"INCENTIVE COMPENSATION CAPITALIZED",null,0,-1639,{"$f":"SUM(E22:F22)","v":-1639}]
[]
[{"$f":"1+A22","v":7},null,"TOTAL PLANT IN SERVICE",null,{"$f":"SUM(E12:E22)","v":560915},{"$f":"SUM(F12:F22)","v":57588},{"$f":"SUM(G12:G22)","v":618503}]
[]
[]
[]
["(1) Details of pro forma adjustments per SCHEDULE MJL-D1-2."]

{"sheet":"SCHEDULE MJL-D1-2","index":1,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[11,2,12,8],[15,2,15,8]]}
[{"$f":"+'SCHEDULE MJL-D1-1'!A1:G1","v":"AMEREN MISSOURI"}]
["EXPLANATION OF PRO FORMA ADJUSTMENTS TO PLANT"]
[{"$f":"+'SCHEDULE MJL-D1-1'!A3:G3","v":"BY FUNCTIONAL CLASSIFICATION FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
["($000)"]
[]
["Line",null,"Description",null,null,null,null,null,null,null,"Amount"]
[]
[1,-1,"Pro Forma adjustment for forecasted plant additions through September 30, 2021.",null,null,null,null,null,null,null,30023]
[]
[{"$f":"+A8+1","v":2},-2,"Reduce Plant-in-Service for AMI software investment.",null,null,null,null,null,null,null,-4547]
[]
[{"$f":"+A10+1","v":3},-3,"Allocate portions of plant in service for intangible assets and multi use general facilities which are applicable to gas operations.  For convenience, such facilities are recorded as electric plant but are commonly used for both electric and gas.",null,null,null,null,null,null,null,33751]
[{"$f":"A12+1","v":4}]
[]
[]
[{"$f":"+A13+1","v":5},-4,"Reduce Plant-in-Service for disallowed capital incentive compensation.",null,null,null,null,null,null,null,-1639]
[]
[]
[{"$f":"1+A16","v":6},null,"Total Pro Forma Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(K8:K16)","v":57588}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null," "]

{"sheet":"SCHEDULE MJL-D2-1","index":2,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,0,2,6],[1,0,1,6],[3,0,3,6]]}
["AMEREN MISSOURI"]
["TOTAL GAS RESERVES FOR DEPRECIATION AND AMORTIZATION"]
[{"$f":"+'SCHEDULE MJL-D1-1'!A3:G3","v":"BY FUNCTIONAL CLASSIFICATION FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
["($000)"]
[]
[]
[null,null,null,null,"TOTALS","PRO FORMA","PRO FORMA"]
[null,null,null,null,"PER","ADJUSTMENTS","GAS"]
["LINE",null,"FUNCTIONAL CLASSIFICATION",null,"BOOKS","          (1)          ","TOTALS"]
[null,null,"(A)",null,"(B)","(C)","(D)"]
[]
[1,null,"INTANGIBLE PLANT",null,1831,8184,{"$f":"E12+F12","v":10015}]
[]
[{"$f":"1+A12","v":2},null,"PRODUCTION PLANT",null,-779,0,-779]
[]
[{"$f":"1+A14","v":3},null,"TRANSMISSION PLANT",null,3025,80,3105]
[]
[{"$f":"1+A16","v":4},null,"DISTRIBUTION PLANT",null,193478,8585,202063]
[]
[{"$f":"1+A18","v":5},null,"GENERAL PLANT",null,8759,5611,14370]
[]
[{"$f":"1+A20","v":6},null,"INCENTIVE COMPENSATION CAPITALIZED",null,0,-455,{"$f":"E22+F22","v":-455}]
[]
[{"$f":"1+A22","v":7},null,"TOTAL DEPRC. & AMORT RESERVE",null,{"$f":"E12+E14+E16+E18+E20+E22","v":206314},{"$f":"F12+F14+F16+F18+F20+F22","v":22005},{"$f":"G12+G14+G16+G18+G20+G22","v":228319}]
[]
["(1) Details of pro forma adjustments per SCHEDULE MJL-D2-2."]

{"sheet":"SCHEDULE MJL-D2-2","index":3,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[[16,2,17,8],[12,2,13,8]]}
[{"$f":"+'SCHEDULE MJL-D1-1'!A1:G1","v":"AMEREN MISSOURI"}]
["EXPLANATION OF PRO FORMA ADJUSTMENTS TO ACCUMULATED RESERVES"]
[{"$f":"+'SCHEDULE MJL-D1-1'!A3:G3","v":"BY FUNCTIONAL CLASSIFICATION FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
["($000)"]
[]
[]
["Line",null,"Description",null,null,null,null,null,null,null,"Amount"]
[]
[1,-1,"Reserve Balance at December 31, 2020 adjusted to reflect Reserve Balance at September 30, 2021.",null,null,null,null,null,null,null,10478]
[]
[{"$f":"+A9+1","v":2},-2,"Reduce Plant-in-Service for AMI software investment.",null,null,null,null,null,null,null,-1124]
[]
[{"$f":"+A11+1","v":3},-3,"Adjustment to depreciation reserve for the additions to plant in service for the true-up period of January 1, 2021 through September 30, 2021.",null,null,null,null,null,null,null,642]
[{"$f":"A13+1","v":4}]
[]
[]
[{"$f":"+A14+1","v":5},-4,{"$f":"+'SCHEDULE MJL-D1-2'!C12","v":"Allocate portions of plant in service for intangible assets and multi use general facilities which are applicable to gas operations.  For convenience, such facilities are recorded as electric plant but are commonly used for both electric and gas."},null,null,null,null,null,null,null,12465]
[{"$f":"A17+1","v":6}]
[]
[]
[{"$f":"+A18+1","v":7},-5,"Reserve Balance adjustment for disallowed Incentive Compensation capitalized.",null,null,null,null,null,null,null,-455]
[]
[]
[{"$f":"A21+1","v":8},null,"Total Pro Forma Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(K9:K21)","v":22006}]

{"sheet":"SCHEDULE MJL-D3","index":4,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,5],[3,0,3,5]]}
["AMEREN MISSOURI"]
["AVERAGE FUEL AND MATERIALS & SUPPLIES INVENTORIES"]
["FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"]
["($000)"]
[]
[null,null,null,"TOTALS",null,"PRO FORMA"]
[null,null,null,"PER","PRO FORMA","GAS"]
["LINE",null,"DESCRIPTION","BOOKS","ADJUSTMENTS","TOTALS"]
[null,null,"(A)","(B)","(C)","(D)"]
[]
[]
[1,null,"GENERAL MATERIALS AND SUPPLIES",2203,0,{"$f":"D12+E12","v":2203}]
[]
[{"$f":"1+A12","v":2},null,"GAS STORED UNDERGROUND",4297,0,{"$f":"D14+E14","v":4297}]
[]
[{"$f":"1+A14","v":3},null,"TOTAL",{"$f":"D12+D14","v":6500},{"$f":"E12+E14","v":0},{"$f":"F12+F14","v":6500}]

{"sheet":"SCHEDULE MJL-D4","index":5,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,1,0,6],[1,1,1,6],[2,1,2,6],[3,1,3,6]]}
[null,"AMEREN MISSOURI"]
[null,"AVERAGE PREPAYMENTS"]
[null,{"$f":"+'SCHEDULE MJL-D3'!A3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
[null,"($000)"]
[]
[null,null,null,null,"TOTALS",null,"PRO FORMA"]
[null,null,null,null,"PER","PRO FORMA","GAS"]
[null,"LINE",null,"DESCRIPTION ","BOOKS(1)","ADJUSTMENTS","TOTALS"]
[null,null,null,"(A)","(B)","(C)","(D)"]
[]
[null,1,null,"   RENTS (3)",39,-38,{"$f":"E11+F11","v":1}]
[null,{"$f":"1+B11","v":2},null,"   INSURANCE - DIRECT (2)",9686,-9066,620]
[null,{"$f":"B12+1","v":3},null,"   REG. COMMISSION ASSESSMENTS (3)",0,0,0]
[null,{"$f":"B13+1","v":4},null,"   COAL CAR LEASE (2)",0,0,0]
[null,5,null,"   M/A COMM RADIO SYS SRVC AGREEMENT (3)",0,0,0]
[null,6,null,"   MEDICAL AND DENTAL VEBA (3)",4372,-4267,105]
[null,7,null,"   IMAGING SOFTWARE (ELEC ONLY)",82,-82,{"$f":"E17+F17","v":0}]
[null,8,null,"   FUELWORKS SOFTWARE (ELEC ONLY)",0,0,0]
[null,9,null,"   MICROSOFT ENTERPRISE APPLICATIONS (3)",0,0,0]
[null,10,null,"   ARBOR NEWSTAR SERVICE FEE (3)",0,0,{"$f":"E20+F20","v":0}]
[null,11,null,"   OPTIV GIGAMON (3)",5,-5,0]
[null,12,null,"   CAROUSEL (AVAYA) MAINTENANCE (3)",0,0,0]
[null,13,null,"   ENERGY EFFICIENCY PROGRAM VENDORS (2)",0,0,0]
[null,14,null,"   NSR & OPACITY LITIGATION (2)",0,0,0]
[null,15,null,"   CRM SALESFORCE SUBSCRIPTION (3)",36,-35,1]
[null,16,null,"   KANSAS CITY POWER & LIGHT (ELEC ONLY)",3111,-3111,0]
[null,17,null,"   PALO ALTO ENTERPRISE (3)",12,-12,0]
[null,18,null,"   LOW INCOME WEATHERIZATION - DIRECT (2)",133,-104,29]
[]
[null,{"$f":"1+B28","v":19},null,"TOTAL AVERAGE PREPAYMENTS",{"$f":"SUM(E11:E28)","v":17476},{"$f":"SUM(F11:F28)","v":-16720},{"$f":"SUM(G11:G28)","v":756}]
[]
[null,{"$f":"1+B30","v":20},-1,"Reflects 13 month average"]
[null,{"$f":"1+B32","v":21},-2,"Directly assigned to electric or gas."]
[null,{"$f":"1+B33","v":22},-3,"Allocated to gas based on operating expenses excluding  purchased power, fuel adjustment clause and purchased gas."]
[]
[]
[]
[null,null,"PRO FORMA ADJUSTMENT"]
[]
[null,{"$f":"B34+1","v":23},-1,"Eliminate portions of prepayments which are applicable to electric operations.  Allocated between",null,null,{"$f":"+F30","v":-16720}]
[null,{"$f":"1+B40","v":24},null,"electric and gas operations based on operating expenses excluding purchased power, fuel adjustment clause"]
[null,{"$f":"1+B41","v":25},null,"and purchased gas."]

{"sheet":"SCHEDULE MJL-D5","index":6,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[[34,2,34,7],[0,0,0,10],[1,0,1,10]]}
["AMEREN MISSOURI"]
["TOTAL GAS CASH WORKING CAPITAL"]
[{"$f":"+'SCHEDULE MJL-D3'!A3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
["($000)"]
[]
[null,null,null,null,null,null,null,null,null,"CASH WORKING"]
[null,null,null,null,"REVENUE","EXPENSE","NET",null,"TEST YEAR","CAPITAL"]
["LINE",null,"DESCRIPTION",null,"LAG","LEAD","LEAD/LAG","FACTOR","EXPENSE ","REQUIREMENT"]
[null,null,"(A)",null,"(B)","(C)","(D)","(E)","(F)","(G)"]
[]
[1,null,"PAYROLL & WITHHOLDINGS",null,39.5,-10.15,{"$f":"+E11+F11","v":29.35},{"$f":"ROUND(+G11/365,6)","v":8.0410999999999996E-2},16973,{"$f":"ROUND(+H11*I11,0)","v":1365}]
[{"$f":"1+A11","v":2},null,"PENSIONS AND BENEFITS",null,39.5,-18.41,{"$f":"+E12+F12","v":21.09},{"$f":"ROUND(+G12/365,6)","v":5.7780999999999999E-2},1925,{"$f":"ROUND(+H12*I12,0)","v":111}]
[3,null,"FUEL",null,39.5,-35.020000000000003,{"$f":"+E13+F13","v":4.4799999999999969},{"$f":"ROUND(+G13/365,6)","v":1.2274E-2},42944,{"$f":"ROUND(+H13*I13,0)","v":527}]
[4,null,"INCENTIVE COMPENSATION",null,39.5,-250.29,{"$f":"+E14+F14","v":-210.79},{"$f":"ROUND(+G14/365,6)","v":-0.57750699999999999},1570,{"$f":"ROUND(+H14*I14,0)","v":-907}]
[5,null,"UNCOLLECTIBLE ACCOUNTS",null,39.5,-39.5,{"$f":"+E15+F15","v":0},{"$f":"ROUND(+G15/365,6)","v":0},646,{"$f":"ROUND(+H15*I15,0)","v":0}]
[6,null,"OTHER OPERATING EXPENSES",null,39.5,-43.85,-4.3500000000000014,-1.1918E-2,15014,{"$f":"ROUND(+H16*I16,0)","v":-179}]
[7]
[8,null,"TOTAL O&M EXPENSES",null,null,null,null,null,35892]
[]
[{"$f":"1+A18","v":9},null,"     TOTAL CASH WORKING CAPITAL REQUIREMENT",null,null,null,null,null,null,{"$f":"SUM(J11:J16)","v":917}]
[]
[{"$f":"1+A20","v":10},null,"FICA - EMPLOYER'S PORTION",null,39.5,-9.3800000000000008,{"$f":"+E22+F22","v":30.119999999999997},{"$f":"ROUND(+G22/365,6)","v":8.2520999999999997E-2},1110,{"$f":"ROUND(+H22*I22,0)","v":92}]
[{"$f":"1+A22","v":11},null,"FEDERAL UNEMPLOYMENT TAXES",null,39.5,-9.3800000000000008,{"$f":"+E23+F23","v":30.119999999999997},{"$f":"ROUND(+G23/365,6)","v":8.2520999999999997E-2},8,1]
[{"$f":"1+A23","v":12},null,"PROPERTY TAXES",null,39.5,-183,-143.5,-0.39315099999999997,8126,-3195]
[13,null,"SALES TAXES",null,39.5,-9.31,30.189999999999998,8.2711999999999994E-2,2857,236]
[14,null,"SELF PROCURED INSURANCE TAX",null,39.5,-241.5,-202,-0.55342499999999994,10,-6]
[15,null,"GROSS RECEIPTS TAXES",null,24.29,-26.14,-1.8500000000000014,-5.0679999999999996E-3,5812,-29]
[]
[{"$f":"1+A27","v":16},null,"TOTAL TAXES AND OTHER EXPENSES",null,null,null,null,null,{"$f":"SUM(I22:I27)","v":17923}]
[]
[{"$f":"1+A29","v":17},null,"     NET CUSTOMER SUPPLIED FUNDS",null,null,null,null,null,null,{"$f":"SUM(J22:J27)","v":-2901}]
[]
[{"$f":"1+A31","v":18},null,"NET CASH WORKING CAPITAL REQUIREMENT",null,null,null,null,null,null,{"$f":"J20+J31","v":-1984}]

{"sheet":"SCHEDULE MJL-D6","index":7,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[26,2,26,7],[4,0,4,10],[25,2,25,7],[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,10],[5,0,5,10]]}
["AMEREN MISSOURI"]
["TOTAL GAS FEDERAL AND STATE INCOME TAX AND CITY EARNINGS TAX CASH REQUIREMENTS"]
["AND INTEREST EXPENSE CASH REQUIREMENT "]
[{"$f":"'SCHEDULE MJL-D5'!A3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
["($000)"]
[]
[]
[null,null,null,null,null,null,null,null,null,"CASH WORKING"]
[null,null,null,null,"REVENUE","EXPENSE","NET",null,"TEST YEAR","CAPITAL"]
["LINE",null,"DESCRIPTION",null,"LAG","LEAD (1)","LEAD/LAG","FACTOR","EXPENSE ","REQUIREMENT"]
[null,null,"(A)",null,"(B)","(C)","(D)","(E)","(F)","(G)"]
[]
[]
[1,null,"FEDERAL INCOME TAX CASH REQUIREMENT",null,39.5,-38,{"$f":"+E14+F14","v":1.5},{"$f":"ROUND(+G14/365,6)","v":4.1099999999999999E-3},3942,{"$f":"ROUND(+H14*I14,0)","v":16}]
[]
[]
[{"$f":"1+A14","v":2},null,"STATE INCOME TAX CASH REQUIREMENT",null,39.5,-38,{"$f":"+E17+F17","v":1.5},{"$f":"ROUND(+G17/365,6)","v":4.1099999999999999E-3},700,{"$f":"ROUND(+H17*I17,0)","v":3}]
[]
[]
[{"$f":"1+A17","v":3},null,"CITY EARNINGS TAX CASH REQUIREMENT",null,39.5,-274.5,{"$f":"+E20+F20","v":-235},{"$f":"ROUND(+G20/365,6)","v":-0.64383599999999996},20,{"$f":"ROUND(+H20*I20,0)","v":-13}]
[]
[]
[{"$f":"1+A20","v":4},null,"INTEREST EXPENSE CASH REQUIREMENT",null,39.5,-91.37,{"$f":"+E23+F23","v":-51.870000000000005},{"$f":"ROUND(+G23/365,6)","v":-0.14210999999999999},5663,{"$f":"ROUND(+H23*I23,0)","v":-805}]

{"sheet":"SCHEDULE MJL-D7","index":8,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["AMEREN MISSOURI"]
["TOTAL GAS AVERAGE CUSTOMER ADVANCES FOR CONSTRUCTION AND "]
["AVERAGE CUSTOMER DEPOSITS"]
[{"$f":"'SCHEDULE MJL-D4'!B3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
["($000)"]
[]
[]
["LINE",null,"DESCRIPTION",null,"TOTAL GAS"]
[null,null,"(A)",null,"(B)"]
[]
[]
[]
[{"$f":"1","v":1},null,"AVERAGE CUSTOMER ADVANCES FOR CONSTRUCTION",null,-391]
[]
[]
[{"$f":"1+A13","v":2},null,"AVERAGE CUSTOMER DEPOSITS",null,-885]

{"sheet":"SCHEDULE MJL-D8","index":9,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[9,2,9,5],[10,2,10,5]]}
["AMEREN MISSOURI"]
["OTHER REGULATORY ASSETS "]
["AND REGULATORY LIABILITIES "]
[{"$f":"+'SCHEDULE MJL-D9'!A3:H3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
["($000)"]
[]
[]
[]
[null,null,null,null,null,null,null,"TOTAL"]
["LINE",null,"DESCRIPTION",null,null,null,null,"GAS (1)"]
[null,null,"(A)",null,null,null,null,"(B)"]
[]
[]
[]
[{"$f":"1","v":1},null,"PENSIONS",null,null,null,null,-579]
[]
[]
[{"$f":"1+A15","v":2},null,"OTHER POST-EMPLOYMENT BENEFITS",null,null,null,null,-958]
[]
[]
[]
[{"$f":"1+A18","v":3},null,"(1)  A positive balance is a Regulatory Asset and a negative balance is a"]
[{"$f":"1+A22","v":4},null,"       Regulatory Liability."]

{"sheet":"SCHEDULE MJL-D9","index":10,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,0,2,7],[7,2,7,3],[8,2,8,3],[3,0,3,7]]}
["AMEREN MISSOURI"]
["ACCUMULATED DEFERRED INCOME TAXES"]
[{"$f":"+'SCHEDULE MJL-D3'!A3:G3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
["($000)"]
[]
[null,null,null,null,null,"TOTAL",null,"PRO FORMA"]
[null,null,null,null,null,"GAS","PRO FORMA","GAS"]
["LINE",null,"DESCRIPTION",null,null,"PER BOOKS","ADJUSTMENTS","TOTAL"]
[null,null,"(A)",null,null,"(B)","(C)","(D)"]
[]
[1,null,"ACCOUNT 190",null,null,2022,-185,{"$f":"+F11+G11","v":1837}]
[]
[{"$f":"1+A11","v":2},null,"ACCOUNT 282",null,null,-80210,-2716,{"$f":"+F13+G13","v":-82926}]
[]
[{"$f":"1+A13","v":3},null,"ACCOUNT 283",null,null,-294,0,{"$f":"+F15+G15","v":-294}]
[]
[{"$f":"1+A15","v":4},null,"TOTAL ACCUMULATED DEFERRED INCOME TAXES",null,null,{"$f":"SUM(F11:F16)","v":-78482},{"$f":"SUM(G11:G16)","v":-2901},{"$f":"SUM(H11:H16)","v":-81383}]

{"sheet":"SCHEDULE MJL-D10","index":11,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["AMEREN MISSOURI"]
["TOTAL GAS PER BOOK AND PRO FORMA OPERATING REVENUES"]
[{"$f":"'SCHEDULE MJL-D5'!A3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
["($000)"]
[]
[]
[]
[null,null,null,null,null,"ADJUSTED"]
[null,null,null,"TOTAL ","PRO FORMA","TOTAL "]
["LINE",null,"DESCRIPTION","GAS","ADJUSTMENTS","GAS"]
[null,null,"(A)","(B)","(C)","(D)"]
[]
[null,null,"OPERATING REVENUES"]
[1,null,"RETAIL REVENUES",108814,{"$f":"-47206+1","v":-47205},{"$f":"D14+E14","v":61609}]
[{"$f":"1+A14","v":2},null,"TRANSPORTATION",13442,191,{"$f":"D15+E15","v":13633}]
[3,null,"PROVISION FOR RATE REFUNDS",769,{"$f":"-768+1","v":-767},{"$f":"D16+E16","v":2}]
[{"$f":"1+A16","v":4},null,"OTHER GAS REVENUES",1561,260,{"$f":"D17+E17","v":1821}]
[]
[{"$f":"+A17+1","v":5},null,"TOTAL REVENUES PER BOOKS",{"$f":"SUM(D14:D18)","v":124586},-47521,{"$f":"SUM(F14:F18)","v":77065}]
[]
[]
[]
[null,null,"PRO FORMA ADJUSTMENTS:"]
[{"$f":"1+A19","v":6},-1,"REMOVE ADD ON REVENUE TAX",{"$f":"-5764","v":-5764}]
[{"$f":"1+A24","v":7},-2,"ADJUSTMENT TO REFLECT NORMAL WEATHER",2732]
[8,-3,"ELIMINATE PGA REVENUES",-42475]
[{"$f":"1+A26","v":9},-4,"ADJUST FOR BILLING UNITS",-2013]
[10,-5,"ELIMINATE  UNBILLED REVENUE",-1385]
[11,-6,"SOFTWARE RENTAL ADJUSTMENT",161]
[12,-7,"REMOVE BOA LEASE REVENUES",-72]
[13,-8,"GROWTH ADJUSTMENT",585]
[14,-9,"DAYS & LEAP YEAR ADJUSTMENT",{"$f":"-151","v":-151}]
[15,-10,"COVID ADJUSTMENT",689]
[16,-11,"LATE FEE REVENUE NORMALIZATION",172]
[]
[{"$f":"1+A34","v":17},null,"TOTAL PRO FORMA ADJUSTMENTS",null,{"$f":"SUM(D24:D34)","v":-47521}]

{"sheet":"SCHEDULE MJL-D11-1","index":12,"n_rows":45,"n_cols":41,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"#1","#2","#3","#4","#5","#6","#7","#8",null,null,null,null,"#9","#10","#11","#12","#13","#14","#15","#16","#17","#18",null,null,null,null,"#19","#20","#21","#22","#23","#24","#25","#26"]
[null,null,"Title included in Page header for printing purposes.",null,null,null,null,"LONG TERM",null,null,null,null,null,null,null,null,null,"PRO FORMA",null,null,"NON- ","REBASE","AMORTIZE","ANNUALIZE",null,"REMOVE"]
[null,null,null,null,"TOTAL",null,"INCENTIVE","INCENTIVE","BAD DEBT",null,"ELIMINATE","ADD INTEREST",null,null,null,null,null,"MEDICAL & ","NORMALIZE","INCREMENTAL","QUALIFIED","PENSION","PENSION","DEPRECIATION","BOA","ELECTRIC COSTS",null,null,null,null,null,"ALLOCATION",null,"REMOVE ","BOARD OF ","SOFTWARE","EV","CUSTOMER",null,"TOTAL","PRO FORMA"]
[null,null,null,null,"PER","LABOR","COMPENSATN","COMPENSATN","EXPENSE","STAFFING","PURCHASED","ON CUSTOMER","INSURANCE",null,null,null,null,"BENEFIT","AAO COSTS/","JANITORIAL","PENSION","AND OPEB","AND OPEB","AND RATE","RENTAL","ALLOCATED","DEPR TO O&M",null,null,null,null,"FACTOR","COLI","ALCOHOL","DIRECTORS","RENTAL","INCENTIVE","CONVENIENCE","MPSC","PRO FORMA","GAS"]
[null,null,"LINE","FUNCTIONAL CLASSIFICATION","BOOKS","ADJUSTMENT","ADJUSTMENT","ADJUSTMENT","TO WRITEOFFS","ADJUSTMENT","GAS EXPENSE","DEPOSITS","ADJUST.",null,null,"LINE","FUNCTIONAL CLASSIFICATION","ADJUST.","SAVINGS","COSTS","ADJUST.","TRACKER","TRACKER","CASE EXPENSE","EXPENSE","TO GAS","ADJUSTMENT",null,null,"LINE","FUNCTIONAL CLASSIFICATION","ADJUSTMENT","NORMALIZATION","PURCHAES","EXPENSE","EXPENSE","ADJUSTMENT","FEES","ASSESSMENT","ADJUSTMENT","TOTALS"]
[null,null,null,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)","(J)",null,null,null,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)","(J)","(J)",null,null,null,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)","(J)","(J)"]
[]
[]
[null,null,{"$f":"1","v":1},"  PRODUCTION:",43713,10,-11,-13,0,0,-42944,0,0,null,null,{"$f":"1","v":1},"  PRODUCTION:",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1","v":1},"  PRODUCTION:",0,0,0,0,0,0,0,0,{"$f":"SUM(F9:M9,R9:AA9,AF9:AM9)","v":-42958},{"$f":"+E9+AN9","v":755}]
[]
[null,null,{"$f":"1+C9","v":2},"  TOTAL TRANSMISSION EXPENSES:",8,0,0,0,0,0,0,0,0,null,null,{"$f":"1+P9","v":2},"  TOTAL TRANSMISSION EXPENSES:",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AD9","v":2},"  TOTAL TRANSMISSION EXPENSES:",0,0,0,0,0,0,0,0,{"$f":"SUM(F11:M11,R11:AA11,AF11:AM11)","v":0},{"$f":"+E11+AN11","v":8}]
[]
[null,null,{"$f":"1+C11","v":3},"  DISTRIBUTION EXPENSES:",14480,183,-134,-40,0,0,0,0,0,null,null,{"$f":"1+P11","v":3},"  DISTRIBUTION EXPENSES:",0,-246,0,0,0,0,0,0,0,-46,null,null,{"$f":"1+AD11","v":3},"  DISTRIBUTION EXPENSES:",1,0,0,0,0,0,0,0,{"$f":"SUM(F13:M13,R13:AA13,AF13:AM13)","v":-282},{"$f":"+E13+AN13","v":14198}]
[]
[null,null,{"$f":"1+C13","v":4},"  CUSTOMER ACCOUNTING EXPENSES:",5680,64,-45,-10,-104,0,0,38,0,null,null,{"$f":"1+P13","v":4},"  CUSTOMER ACCOUNTING EXPENSES:",0,-7,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AD13","v":4},"  CUSTOMER ACCOUNTING EXPENSES:",0,0,0,0,0,0,503,0,{"$f":"SUM(F15:M15,R15:AA15,AF15:AM15)","v":439},{"$f":"+E15+AN15","v":6119}]
[]
[null,null,{"$f":"1+C15","v":5},"  CUSTOMER SERV. & INFO. EXPENSES:",805,0,0,-1,0,0,0,0,0,null,null,{"$f":"1+P15","v":5},"  CUSTOMER SERV. & INFO. EXPENSES:",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AD15","v":5},"  CUSTOMER SERV. & INFO. EXPENSES:",0,0,0,0,0,0,0,0,{"$f":"SUM(F17:M17,R17:AA17,AF17:AM17)","v":-1},{"$f":"+E17+AN17","v":804}]
[]
[null,null,{"$f":"1+C17","v":6},"  SALES EXPENSES:",54,1,-1,0,0,0,0,0,0,null,null,{"$f":"1+P17","v":6},"  SALES EXPENSES:",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AD17","v":6},"  SALES EXPENSES:",0,0,0,0,0,0,0,0,{"$f":"SUM(F19:M19,R19:AA19,AF19:AM19)","v":0},{"$f":"+E19+AN19","v":54}]
[]
[null,null,{"$f":"1+C19","v":7},"  ADMINISTRATIVE & GENERAL EXPENSES:",13156,89,-91,-317,0,581,0,0,418,null,null,{"$f":"1+P19","v":7},"  ADMINISTRATIVE & GENERAL EXPENSES:",231,117,11,19,105,133,213,-110,-14,0,null,null,{"$f":"1+AD19","v":7},"  ADMINISTRATIVE & GENERAL EXPENSES:",39,-340,-1,-17,-20,-1,0,-11,{"$f":"SUM(F21:M21,R21:AA21,AF21:AM21)","v":1034},{"$f":"+E21+AN21","v":14190}]
[]
[null,null,{"$f":"1+C21","v":8},"TOTAL OPERATIONS & MAINTENANCE EXPENSES",{"$f":"SUM(E9:E21)","v":77896},{"$f":"SUM(F9:F21)","v":347},-282,-381,{"$f":"SUM(I9:I21)","v":-104},581,{"$f":"SUM(K9:K21)","v":-42944},38,418,null,null,{"$f":"1+P21","v":8},"TOTAL OPERATIONS & MAINTENANCE EXPENSES",{"$f":"SUM(R9:R21)","v":231},{"$f":"SUM(S9:S21)","v":-136},11,19,105,133,213,{"$f":"SUM(Y9:Y21)","v":-110},{"$f":"SUM(Z9:Z21)","v":-14},-46,null,null,{"$f":"1+AD21","v":8},"TOTAL OPERATIONS & MAINTENANCE EXPENSES",{"$f":"SUM(AF9:AF21)","v":40},{"$f":"SUM(AG9:AG21)","v":-340},{"$f":"SUM(AH9:AH21)","v":-1},-17,-20,-1,503,-11,{"$f":"SUM(AN9:AN21)","v":-41768},{"$f":"SUM(AO9:AO21)","v":36128}]
[]
[null,null,{"$f":"1+C23","v":9},"NOTE: See SCHEDULE MJL-D11-4 for explanation of the pro forma adjustments.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+P23","v":9},"NOTE: See SCHEDULE MJL-D11-4 for explanation of the pro forma adjustments.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+AD23","v":9},"NOTE: See SCHEDULE MJL-D11-4 for explanation of the pro forma adjustments."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SCHEDULE MJL-D11-1",null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE MJL-D11-2",null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE MJL-D11-3"]

{"sheet":"SCHEDULE MJL-D11-4","index":13,"n_rows":70,"n_cols":12,"rows_kept":70,"cut":false,"hidden":false,"merged":[[46,2,46,9],[23,2,23,9],[7,2,7,9],[9,2,11,9],[20,2,20,9],[16,2,16,9],[13,2,14,9],[30,2,31,9],[35,2,35,9],[39,2,39,9],[37,2,37,9],[0,0,0,11],[2,0,2,11],[1,0,1,11],[6,2,6,9],[3,0,3,11],[4,0,4,11]]}
["AMEREN MISSOURI"]
["GAS OPERATING AND MAINTENANCE EXPENSE"]
["PRO FORMA ADJUSTMENTS"]
[{"$f":"'SCHEDULE MJL-D5'!A3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
["($000)"]
[null,"PRO FORMA",null,null,null,null,null,null,null,null,null,"TOTAL"]
["LINE","ITEM NO.","DESCRIPTION",null,null,null,null,null,null,null,null,"AMOUNT"]
[null,"(A)","(B)",null,null,null,null,null,null,null,null,"(C)"]
[]
[1,-1,"Increased labor expense from annualizing the average 1.83% wage increase for management employees effective January 1, 2021, and the 2.50% wage increase for the Company's union employees effective Jan 1, 2021 per the labor contracts. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1'!F23","v":347}]
[{"$f":"1+A10","v":2}]
[{"$f":"1+A11","v":3}]
[]
[{"$f":"1+A12","v":4},-2,"Decrease the incentive compensation expense for the incentive compensation applicable to AMS and Ameren Missouri officers related to earnings.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1'!G23","v":-282}]
[{"$f":"1+A14","v":5}]
[]
[{"$f":"1+A15","v":6},-3,"Eliminate the long term incentive compensation related to earnings.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1'!H23","v":-381}]
[]
[{"$f":"1+A17","v":7},-4,"To adjust bad debt expense to writeoffs. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1'!I23","v":-104}]
[]
[{"$f":"1+A19","v":8},-5,"Management and Contract salaries and average benefits annualized for increased headcount (232 employees) ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1'!J23","v":581}]
[]
[]
[{"$f":"1+A21","v":9},-6,"Eliminate cost of purchased gas and other related costs and expenses that are collected through the PGA",null,null,null,null,null,null,null,null,{"$f":"+'SCHEDULE MJL-D11-1'!K23","v":-42944}]
[]
[{"$f":"1+A24","v":10},-7,"Increase in customer accounting expenses to reflect interest expense at 4.25% on the average customer deposit",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1'!L23","v":38}]
[{"$f":"1+A26","v":11},null,"balance."]
[]
[{"$f":"1+A27","v":12},-8,"Annualize insurance expense based upon current insurance premiums.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1'!M23","v":418}]
[]
[{"$f":"1+A29","v":13},-9,"Decrease administrative and general expenses to reflect annualized year 2021 in the other employee benefit expenses (excludes Major Medical which is covered in AAO adjustment #10.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1'!R23","v":231}]
[{"$f":"1+A31","v":14}]
[]
[{"$f":"1+A32","v":15},-10,"To adjust costs related to COVID-19 pandemic to normal levels. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1'!S23","v":-136}]
[]
[{"$f":"1+A34","v":16},-11,"To normalize janitorial costs for new cleaning procedures subsequent to a global pandemic. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1'!T23","v":11}]
[]
[{"$f":"1+A36","v":17},-12,"Increase non-qualified pension expense to reflect current level of expense.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1'!U23","v":19}]
[]
[{"$f":"1+A38","v":18},-13,"Rebase Pension and OPEB Tracker to year 2021 level. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1'!V23","v":105}]
[]
[{"$f":"1+A40","v":19},-14,"Update the amortization of the net regulatory liabilities for Pension and OPEB Tracker.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1'!W23","v":133}]
[]
[{"$f":"1+A42","v":20},-15,"To annualize rate case expense over a 2 year period. ",null,null,null,null,null,null,null,null,{"$f":"+'SCHEDULE MJL-D11-1'!X23","v":213}]
[{"$f":"1+A44","v":21},null,"To annualize depreciation study expense over a 5 year period. "]
[]
[{"$f":"1+A45","v":22},-16,"To remove rental expense for the Bank of America Lease",null,null,null,null,null,null,null,null,{"$f":"+'SCHEDULE MJL-D11-1'!Y23","v":-110}]
[]
[{"$f":"A47+1","v":23},-17,"Remove Electric Costs Allocated to Gas",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1'!Z23","v":-14}]
[]
[{"$f":"A49+1","v":24},-18,"Decrease distribution expenses for changes in depreciation charged to O&M",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1'!AA23","v":-46}]
[]
[{"$f":"A51+1","v":25},-19,"To adjust Allocation Factors to 2021",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1'!AF23","v":40}]
[]
[{"$f":"A53+1","v":26},-20,"Normalize COLI expense to a 5 year average",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1'!AG23","v":-340}]
[]
[{"$f":"A55+1","v":27},-21,"Remove alcohol expenses",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1'!AH23","v":-1}]
[]
[{"$f":"A57+1","v":28},-22,"To remove Board of Directors luxury travel costs. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1'!AI23","v":-17}]
[]
[{"$f":"A59+1","v":29},-23,"Pro Forma decrease in software rental expense.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1'!AJ23","v":-20}]
[]
[{"$f":"A61+1","v":30},-24,"Remove EV Incentive costs",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1'!AK23","v":-1}]
[]
[{"$f":"A63+1","v":31},-25,"To include customer convenience fees",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1'!AL23","v":503}]
[]
[{"$f":"A65+1","v":32},-26,"Decrease test year expenses to annualize MPSC Assessment.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-D11-1'!AM23","v":-11}]
[]
[]
[{"$f":"1+A67","v":33},"     Total Pro Forma Adjustments to Gas Operating and Maintenance Expenses",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L10:L69)","v":-41768}]

{"sheet":"SCHEDULE MJL-D12-1","index":14,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,1,1,5],[2,1,2,5],[3,1,3,5]]}
["AMEREN MISSOURI"]
[null,"DEPRECIATION & AMORTIZATION EXPENSE"]
[null,{"$f":" 'SCHEDULE MJL-D5'!A3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
[null,"($000)"]
[]
[null,null,null,"TOTALS",null,"PRO FORMA"]
[null,null,null,"PER","PRO FORMA","GAS"]
[null,"LINE","DESCRIPTION","BOOKS","ADJUSTMENTS(1)","TOTALS"]
[null,null,"(A)","(B)","(C)","(D)"]
[]
[null,null,"DEPRECIATION EXPENSE:"]
[null,{"$f":"1","v":1},"INTANGIBLE",917,{"$f":"+'SCHEDULE MJL-D12-2'!E18+'SCHEDULE MJL-D12-2'!E27","v":2199},{"$f":"SUM(D12:E12)","v":3116}]
[null,{"$f":"1+B12","v":2},"PRODUCTION",0,{"$f":"+'SCHEDULE MJL-D12-2'!E14+'SCHEDULE MJL-D12-2'!E23","v":0},0]
[null,{"$f":"1+B13","v":3},"TRANSMISSION PLANT",107,{"$f":"+'SCHEDULE MJL-D12-2'!E15+'SCHEDULE MJL-D12-2'!E24","v":-14},93]
[null,4,"DISTRIBUTION PLANT",10836,{"$f":"+'SCHEDULE MJL-D12-2'!E16+'SCHEDULE MJL-D12-2'!E25","v":-878},9958]
[null,5,"GENERAL PLANT",2335,{"$f":"+'SCHEDULE MJL-D12-2'!E17+'SCHEDULE MJL-D12-2'!E26+'SCHEDULE MJL-D12-2'!E31","v":-312},{"$f":"SUM(D16:E16)","v":2023}]
[null,6,"INCENTIVE COMPENSATION",0,{"$f":"+'SCHEDULE MJL-D12-2'!E33","v":-48},-48]
[]
[null,{"$f":"1+B17","v":7},"    TOTAL DEPRECIATION EXPENSE",{"$f":"SUM(D12:D18)","v":14195},{"$f":"SUM(E12:E18)","v":947},{"$f":"SUM(F12:F18)","v":15142}]
[]
[null,null,"MISC. AMORTIZATION:"]
[null,{"$f":"1+B19","v":8},"  AMORTIZATION OF COVID AAO",0,18,{"$f":"SUM(D22:E22)","v":18}]
[null,{"$f":"1+B22","v":9},"  AMORTIZATION OF OVER/UNDER COLLECTION",-188,0,{"$f":"SUM(D23:E23)","v":-188}]
[null,{"$f":"1+B23","v":10},"  AMORTIZATION OF EXCESS TRACKER",6,42,48]
[null,{"$f":"1+B24","v":11},"  AMORTIZATION OF LOW INCOME ",0,700,700]
[]
[null,{"$f":"1+B25","v":12},"  TOTAL MISC AMORTIZATION",{"$f":"SUM(D22:D26)","v":-182},{"$f":"SUM(E22:E26)","v":760},{"$f":"SUM(F22:F26)","v":578}]
[]
[null,{"$f":"1+B27","v":13},"TOTAL DEPR & AMORTIZATION EXPENSE",{"$f":"+D19+D27","v":14013},{"$f":"+E19+E27","v":1707},{"$f":"+F19+F27","v":15720}]
[]
[null,{"$f":"1+B29","v":14},"(1)  See SCHEDULE MJL-D12-2 for explanation of the pro forma adjustments."]

{"sheet":"SCHEDULE MJL-D12-2","index":15,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[10,2,11,2]]}
["AMEREN MISSOURI"]
["GAS DEPRECIATION & AMORTIZATION EXPENSE PRO FORMA ADJUSTMENTS"]
[{"$f":"'SCHEDULE MJL-D5'!A3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
["($000)"]
[]
[]
[null,null,null,null,"PRO FORMA"]
["LINE","ITEM NO.","DESCRIPTION",null,"ADJUSTMENTS"]
[null,"(A)","(B)",null,"(C)"]
[]
[1,-1,"To reflect the book depreciation annualized for the plant in service depreciable balances at September 30, 2021"]
[{"$f":"1+A11","v":2}]
[]
[{"$f":"1+A12","v":3},null,"Change in Depr. Exp. - Production",null,0]
[{"$f":"1+A14","v":4},null,"Change in Depr. Exp. - Transmission",null,0]
[{"$f":"1+A15","v":5},null,"Change in Depr. Exp. - Distribution",null,802]
[6,null,"Change in Depr. Exp. - General Plant",null,645]
[{"$f":"1+A17","v":7},null,"Change in Amort. Exp. - Intangible Plant",null,2199]
[{"$f":"1+A18","v":8},null,"Total Increase in Depreciation Expense",null,{"$f":"SUM(E14:E18)","v":3646}]
[]
[{"$f":"1+A19","v":9},-2,"Adjust depreciation expense to reflect the proposed rates"]
[]
[{"$f":"1+A21","v":10},null,"Change in Depr. Exp. - Production",null,0]
[{"$f":"1+A23","v":11},null,"Change in Depr. Exp. - Transmission",null,-14]
[{"$f":"1+A24","v":12},null,"Change in Depr. Exp. - Distribution",null,-1680]
[13,null,"Change in Depr. Exp. - General Plant",null,-201]
[14,null,"Change in Amort. Exp. - Intangible Plant",null,0]
[15,null,"Total Increase in Depreciation Expense",null,{"$f":"SUM(E23:E27)","v":-1895}]
[]
[{"$f":"1+A28","v":16},-3,"To reduce depreciation expense charged to O&M"]
[{"$f":"1+A30","v":17},null,"Decrease in Depr. Exp. - General Plant",null,-756]
[]
[{"$f":"1+A31","v":18},-4,"Depreciation on Incentive Compensation Capitalized",null,-48]
[]
[{"$f":"1+A33","v":19},-5,"Amortization of COVID AAO",null,18]
[]
[{"$f":"1+A35","v":20},-6,"Amortization of Excess Tracker",null,42]
[]
[{"$f":"1+A37","v":21},-7,"Amortization of Low Income",null,700]
[]
[{"$f":"1+A39","v":22},"TOTAL PRO FORMA ADJUSTMENTS: DEPRECIATION & AMORTIZATION",null,null,{"$f":"SUM(E19,E28,E31:E39)","v":1707}]

{"sheet":"SCHEDULE MJL-D14-1","index":16,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[3,1,3,6],[0,1,0,6],[1,1,1,6],[2,1,2,6]]}
[null,"AMEREN MISSOURI"]
[null,"TAXES OTHER THAN INCOME TAXES"]
[null,{"$f":"'SCHEDULE MJL-D5'!A3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"},{"$f":"\"FOR THE \" & 'SCHEDULE MJL-D5'!#REF!","v":{"$error":"#REF!"}},{"$f":"\"FOR THE \" & 'SCHEDULE MJL-D5'!#REF!","v":{"$error":"#REF!"}},{"$f":"\"FOR THE \" & 'SCHEDULE MJL-D5'!#REF!","v":{"$error":"#REF!"}},{"$f":"\"FOR THE \" & 'SCHEDULE MJL-D5'!#REF!","v":{"$error":"#REF!"}},{"$f":"\"FOR THE \" & 'SCHEDULE MJL-D5'!#REF!","v":{"$error":"#REF!"}}]
[null,"($000)"]
[]
[null,null,null,null,"TOTAL",null,"PRO FORMA"]
[null,null,null,null,"PER","PRO FORMA","GAS"]
[null,"LINE ","DESCRIPTION",null,"BOOKS","ADJUSTMENTS(1)","TOTALS"]
[null,null,"(A)",null,"(B)","(C)","(D)"]
[]
[null,null,"PAYROLL TAXES"]
[null,1,"   F.I.C.A.",165021,1097,13,{"$f":"E12+F12","v":1110}]
[null,{"$f":"1+B12","v":2},"   FEDERAL UNEMPLOYMENT",null,8,0,{"$f":"E13+F13","v":8}]
[null,{"$f":"1+B13","v":3},"   MISSOURI UNEMPLOYMENT",null,0,0,{"$f":"E14+F14","v":0}]
[null,{"$f":"1+B14","v":4},"   ST. LOUIS EMPLOYMENT TAX",null,0,0,{"$f":"E15+F15","v":0}]
[null,{"$f":"1+B15","v":5},"      TOTAL PAYROLL TAXES",null,{"$f":"SUM(E12:E15)","v":1105},{"$f":"SUM(F12:F15)","v":13},{"$f":"SUM(G12:G15)","v":1118}]
[]
[null,null,"R.E., P.P. & CORP FRANCHISE"]
[null,{"$f":"1+B16","v":6},"   MISSOURI R.E., & P.P.",685910,7999,0,{"$f":"SUM(E19:F19)","v":7999}]
[null,{"$f":"1+B19","v":7},"   OTHER STATES R.E. & P.P.",null,127,0,127]
[null,8,"      TOTAL R.E., P.P. & CORP FRANCHISE",{"$f":"SUM(D19:D20)","v":685910},{"$f":"SUM(E19:E20)","v":8126},{"$f":"SUM(F19:F20)","v":0},{"$f":"SUM(G19:G20)","v":8126}]
[]
[null,{"$f":"1+B21","v":9},"MUNICIPAL GROSS RECEIPTS",null,5812,-5812,{"$f":"SUM(E23:F23)","v":0}]
[]
[null,null,"MISCELLANEOUS"]
[null,{"$f":"1+B23","v":10},"   MISSOURI CORP FRANCHISE",null,-13,0,{"$f":"E26+F26","v":-13}]
[null,{"$f":"1+B26","v":11},"   ILLINOIS CORP FRANCHISE",null,0,0,{"$f":"E27+F27","v":0}]
[null,{"$f":"1+B27","v":12},"   MISCELLANEOUS",null,0,0,{"$f":"E28+F28","v":0}]
[null,{"$f":"1+B28","v":13},"      TOTAL MISCELLANEOUS",null,{"$f":"SUM(E26:E28)","v":-13},{"$f":"SUM(F26:F28)","v":0},{"$f":"SUM(G26:G28)","v":-13}]
[]
[]
[null,{"$f":"1+B29","v":14},"TOTAL TAXES OTHER THAN INCOME TAXES",null,{"$f":"E16+E21+E23+E29","v":15030},{"$f":"F16+F21+F23+F29","v":-5799},{"$f":"G16+G21+G23+G29","v":9231}]
[]
[null,{"$f":"1+B32","v":15},"(1) See SCHEDULE MJL-D14-2 for explanation of the pro forma adjustments."]

{"sheet":"SCHEDULE MJL-D14-2","index":17,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,2,12,8],[10,2,10,8],[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,10],[8,2,8,8],[7,2,7,8],[4,0,4,10]]}
["AMEREN MISSOURI"]
["TAXES OTHER THAN INCOME"]
["PRO FORMA ADJUSTMENTS"]
[{"$f":"'SCHEDULE MJL-D5'!A3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
["($000)"]
[]
[null,null,null,null,null,null,null,null,null,null,"PRO FORMA"]
["LINE","ITEM NO.","DESCRIPTION",null,null,null,null,null,null,null,"AMOUNT"]
[null,"(A)","(B)",null,null,null,null,null,null,null,"(C)"]
[]
[1,-1,"Increase the F.I.C.A. taxes to reflect the pro forma wage adjustments.",null,null,null,null,null,null,null,13]
[]
[{"$f":"1+A11","v":2},-2,"Eliminate the gross receipts tax as they are a pass through tax.",null,null,null,null,null,null,null,-5812]
[]
[{"$f":"1+A13","v":3},null,"Total Pro Forma Adjustments to Taxes Other Than Income",null,null,null,null,null,null,null,{"$f":"SUM(K10:K14)","v":-5799}]

{"sheet":"SCHEDULE MJL-D15","index":18,"n_rows":70,"n_cols":5,"rows_kept":70,"cut":false,"hidden":false,"merged":[[0,0,0,5],[2,0,2,5],[1,0,1,5]]}
["AMEREN MISSOURI"]
[{"$f":"\"TOTAL GAS INCOME TAXES AT THE PROPOSED RETURN\n\" & 'SCHEDULE MJL-D5'!A3","v":"TOTAL GAS INCOME TAXES AT THE PROPOSED RETURN\nFOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
["($000)"]
[]
[]
[null,null,null,null,"TOTAL"]
["LINE",null,"DESCRIPTION",null,"GAS"]
[null,null,"(A)","(B)","(C)"]
[]
[1,null,"TOTAL GAS NET INCOME FROM OPERATIONS",null,21555]
[]
[null,null,"ADD"]
[{"$f":"1+A10","v":2},null,"CURRENT INCOME TAXES",null,4607]
[{"$f":"1+A13","v":3},null,"DEFERRED INCOME TAXES"]
[{"$f":"1+A14","v":4},null,"     DEFERRED INCOME TAX EXPENSE",null,-729]
[{"$f":"1+A15","v":5},null,"     I.T.C. AMORTIZATION",null,-46]
[]
[{"$f":"1+A16","v":6},null,"TOTAL GAS NET INCOME BEFORE INCOME TAX",null,{"$f":"SUM(E10:E16)","v":25387}]
[]
[null,null,"ADDITIONS TO NET INCOME BEFORE INCOME TAX"]
[{"$f":"1+A18","v":7},null,"     BOOK DEPRECIATION",null,15723]
[{"$f":"1+A21","v":8},null,"     BOOK DEPRECIATION CHARGED TO O&M",null,756]
[9,null,"     EQUITY ISSUANCE COSTS",null,0]
[]
[{"$f":"1+A23","v":10},null,"TOTAL ADDITIONS",null,{"$f":"SUM(E21:E24)","v":16479}]
[]
[null,null,"SUBTRACTIONS TO NET INCOME BEFORE INCOME TAX"]
[{"$f":"1+A25","v":11},null,"     INTEREST ON DEBT (1)",null,5663]
[{"$f":"1+A28","v":12},null,"     TAX STRAIGHT LINE",null,16525]
[{"$f":"1+A29","v":13},null,"     PREFERRED DIVIDEND DEDUCTION",null,415]
[]
[{"$f":"1+A30","v":14},null,"TOTAL SUBTRACTIONS",null,{"$f":"SUM(E28:E30)","v":22603}]
[]
[{"$f":"1+A32","v":15},null,"TOTAL GAS NET TAXABLE INCOME",null,{"$f":"E18+E25-E32","v":19263}]
[]
[null,null,"FEDERAL INCOME TAX "]
[{"$f":"1+A34","v":16},null,"  NET TAXABLE INCOME",null,{"$f":"E34","v":19263}]
[{"$f":"1+A37","v":17},null,"  DEDUCT MISSOURI INCOME TAX",null,{"$f":"+E50","v":693}]
[{"$f":"1+A38","v":18},null,"  DEDUCT CITY EARNINGS TAX",null,{"$f":"+E57","v":20}]
[{"$f":"1+A39","v":19},null,"  FEDERAL TAXABLE INCOME",null,{"$f":"E37-E38-E39","v":18550}]
[]
[{"$f":"1+A40","v":20},null,{"$f":"\"  FEDERAL INCOME TAX\"","v":"  FEDERAL INCOME TAX"},0.21,{"$f":"ROUND(E40*D42,0)","v":3896}]
[]
[null,null,"STATE INCOME TAXES"]
[{"$f":"1+A42","v":21},null,"  NET TAXABLE INCOME",null,{"$f":"E34","v":19263}]
[{"$f":"1+A45","v":22},null,"  DEDUCT 50% OF FEDERAL INCOME TAX",null,{"$f":"ROUND(E42*0.5,0)","v":1948}]
[{"$f":"1+A46","v":23},null,"  DEDUCT CITY EARNINGS TAX",null,{"$f":"+E57","v":20}]
[{"$f":"1+A47","v":24},null,"  MISSOURI TAXABLE INCOME",null,{"$f":"E45-E46-E47","v":17295}]
[]
[{"$f":"1+A48","v":25},null,"TOTAL GAS MISSOURI INCOME TAX",0.04,{"$f":"ROUND(E48*D50,0)+1","v":693}]
[]
[null,null,"CITY EARNINGS TAX"]
[{"$f":"1+A50","v":26},null,"  NET TAXABLE INCOME",null,{"$f":"+E34","v":19263}]
[{"$f":"1+A53","v":27},null,"  LESS TAX ADJUSTMENTS TO INCOME",null,2833]
[{"$f":"1+A54","v":28},null,"  CITY TAXABLE INCOME",null,{"$f":"+E53-E54","v":16430}]
[]
[{"$f":"1+A55","v":29},null,"  CITY EARNINGS TAX",1.2199999999999999E-3,{"$f":"ROUND(E55*D57,0)","v":20}]
[]
[{"$f":"+A57+1","v":30},null,"TOTAL GAS CURRENT INCOME TAXES",null,{"$f":"E42+E50+E57","v":4609}]
[]
[null,null,"DEFERRED INCOME TAXES:"]
[{"$f":"1+A59","v":31},null,"     DEFERRED INCOME TAX EXPENSE",null,{"$f":"+E15","v":-729}]
[{"$f":"1+A62","v":32},null,"     I.T.C. AMORTIZATION",null,{"$f":"+E16","v":-46}]
[{"$f":"1+A63","v":33},null,"TOTAL GAS DEFERRED INCOME TAX",null,{"$f":"SUM(E62:E63)","v":-775}]
[]
[{"$f":"1+A64","v":34},null,"TOTAL GAS CURRENT & DEFERRED INCOME TAX",null,{"$f":"+E59+E64","v":3834}]
[]
[]
[{"$f":"1+A66","v":35},null,"(1)  RATE BASE X EMBEDDED"]
[{"$f":"1+A69","v":36},null,"       COST OF DEBT.",1.8239999999999999E-2]

{"sheet":"SCHEDULE MJL-D16","index":19,"n_rows":56,"n_cols":6,"rows_kept":56,"cut":false,"hidden":false,"merged":[[3,1,3,5],[0,1,0,5],[1,1,1,5],[2,1,2,5]]}
[null,"AMEREN MISSOURI"]
[null,"TOTAL GAS NET ORIGINAL COST RATE BASE AND REVENUE REQUIREMENT"]
[null,{"$f":" 'SCHEDULE MJL-D5'!A3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
[null,"($000)"]
[]
[null,null,null,null,null,"TOTAL"]
[null,null,null,null,null,"GAS"]
[null,"LINE","DESCRIPTION","REFERENCE",null,"AMOUNT"]
[null,null,"(A)","(B)",null,"(C)"]
[]
[null,null,"A. TOTAL GAS NET ORIGINAL COST RATE BASE"]
[]
[null,1,"ORIGINAL COST OF PLANT IN SERVICE","SCHEDULE MJL-D1",null,{"$f":"+'SCHEDULE MJL-D1-1'!G24","v":618503}]
[null,{"$f":"1+B13","v":2},"LESS: RESERVES FOR DEPRECIATION & AMORTIZATION","SCHEDULE MJL-D2",null,{"$f":"+'SCHEDULE MJL-D2-1'!G24","v":228319}]
[null,{"$f":"1+B14","v":3},"     NET ORIGINAL COST OF PLANT",null,null,{"$f":"F13-F14","v":390184}]
[null,4,"AVERAGE FUEL AND MATERIALS AND SUPPLIES","SCHEDULE MJL-D3",null,{"$f":"+'SCHEDULE MJL-D3'!F16","v":6500}]
[null,5,"AVERAGE PREPAYMENTS","SCHEDULE MJL-D4",null,{"$f":"+'SCHEDULE MJL-D4'!G30","v":756}]
[null,6,"CASH WORKING CAPITAL (LEAD/LAG)","SCHEDULE MJL-D5",null,{"$f":"'SCHEDULE MJL-D5'!J33","v":-1984}]
[null,7,"FEDERAL INCOME TAX CASH REQUIREMENT","SCHEDULE MJL-D6",null,{"$f":"'SCHEDULE MJL-D6'!J14","v":16}]
[null,8,"STATE INCOME TAX CASH REQUIREMENT","SCHEDULE MJL-D6",null,{"$f":"'SCHEDULE MJL-D6'!J17","v":3}]
[null,9,"CITY EARNINGS TAX CASH REQUIREMENT","SCHEDULE MJL-D6",null,{"$f":"'SCHEDULE MJL-D6'!J20","v":-13}]
[null,{"$f":"1+B21","v":10},"INTEREST EXPENSE CASH REQUIREMENT","SCHEDULE MJL-D6",null,{"$f":"'SCHEDULE MJL-D6'!J23","v":-805}]
[null,{"$f":"1+B22","v":11},"AVERAGE CUSTOMER ADVANCES FOR CONSTRUCTION","SCHEDULE MJL-D7",null,{"$f":"'SCHEDULE MJL-D7'!E13","v":-391}]
[null,12,"AVERAGE CUSTOMER DEPOSITS","SCHEDULE MJL-D7",null,{"$f":"'SCHEDULE MJL-D7'!E16","v":-885}]
[null,{"$f":"1+B24","v":13},"PENSION TRACKER REG ASSET","SCHEDULE MJL-D8",null,{"$f":"+'SCHEDULE MJL-D8'!H15","v":-579}]
[null,{"$f":"1+B25","v":14},"OPEB TRACKER REG  LIABILITY","SCHEDULE MJL-D8",null,{"$f":"+'SCHEDULE MJL-D8'!H18","v":-958}]
[null,{"$f":"1+B26","v":15},"ACCUMULATED DEFERRED INCOME TAXES ","SCHEDULE MJL-D9",null,{"$f":"+'SCHEDULE MJL-D9'!H17","v":-81383}]
[]
[null,{"$f":"1+B27","v":16},"TOTAL GAS NET ORIGINAL COST RATE BASE",null,null,{"$f":"SUM(F15:F27)","v":310461}]
[]
[null,null,"B. TOTAL GAS REVENUE REQUIREMENT"]
[]
[null,null,"TOTAL GAS OPERATING EXPENSES:"]
[null,{"$f":"1+B29","v":17},"PRODUCTION","SCHEDULE MJL-D11-3",null,{"$f":"+'SCHEDULE MJL-D11-1'!AO9","v":755}]
[null,{"$f":"1+B34","v":18},"TRANSMISSION","SCHEDULE MJL-D11-3",null,{"$f":"+'SCHEDULE MJL-D11-1'!AO11","v":8}]
[null,19,"DISTRIBUTION","SCHEDULE MJL-D11-3",null,{"$f":"+'SCHEDULE MJL-D11-1'!AO13","v":14198}]
[null,20,"CUSTOMER ACCOUNTS","SCHEDULE MJL-D11-3",null,{"$f":"+'SCHEDULE MJL-D11-1'!AO15","v":6119}]
[null,21,"CUSTOMER SERVICE","SCHEDULE MJL-D11-3",null,{"$f":"+'SCHEDULE MJL-D11-1'!AO17","v":804}]
[null,22,"SALES","SCHEDULE MJL-D11-3",null,{"$f":"+'SCHEDULE MJL-D11-1'!AO19","v":54}]
[null,23,"ADMINISTRATIVE AND GENERAL","SCHEDULE MJL-D11-3",null,{"$f":"+'SCHEDULE MJL-D11-1'!AO21","v":14190}]
[null,24,"   TOTAL GAS OPERATING EXPENSES",null,null,{"$f":"SUM(F34:F40)","v":36128}]
[null,25,"DEPRECIATION AND AMORTIZATION","SCHEDULE MJL-D12-1",null,{"$f":"+'SCHEDULE MJL-D12-1'!F29","v":15720}]
[null,26,"TAXES OTHER THAN INCOME TAXES","SCHEDULE MJL-D13-1",null,{"$f":"+'SCHEDULE MJL-D14-1'!G32","v":9231}]
[null,null,"INCOME TAXES-BASED ON PROPOSED RATE OF RETURN"]
[null,{"$f":"1+B43","v":27},"  FEDERAL","SCHEDULE MJL-D14",null,{"$f":"+'SCHEDULE MJL-D15'!E42","v":3896}]
[null,{"$f":"1+B45","v":28},"  STATE","SCHEDULE MJL-D14",null,{"$f":"+'SCHEDULE MJL-D15'!E50","v":693}]
[null,{"$f":"1+B46","v":29},"  CITY EARNINGS ","SCHEDULE MJL-D14",null,{"$f":"+'SCHEDULE MJL-D15'!E57","v":20}]
[null,{"$f":"1+B47","v":30},"TOTAL INCOME TAXES",null,null,{"$f":"SUM(F45:F47)","v":4609}]
[null,null,"DEFERRED INCOME TAXES",null,0]
[null,{"$f":"1+B48","v":31},"     DEFERRED INCOME TAX EXPENSE","SCHEDULE MJL-D14",null,{"$f":"+'SCHEDULE MJL-D15'!E62","v":-729}]
[null,{"$f":"1+B50","v":32},"     I.T.C. AMORTIZATION","SCHEDULE MJL-D14",null,{"$f":"+'SCHEDULE MJL-D15'!E63","v":-46}]
[null,{"$f":"1+B51","v":33},"TOTAL DEFERRED INCOME TAXES",null,null,{"$f":"SUM(F50:F51)","v":-775}]
[]
[null,{"$f":"1+B52","v":34},{"$f":"\"RETURN (RATE BASE * \"&TEXT(D54,\"0.000%\")&\")\"","v":"RETURN (RATE BASE * 6.943%)"},6.9430000000000006E-2,null,{"$f":"ROUND(D54*F29,0)","v":21555}]
[]
[null,{"$f":"1+B54","v":35},"TOTAL GAS REVENUE REQUIREMENT",null,null,{"$f":"+F41+F42+F43+F48+F52+F54","v":86468}]

{"sheet":"SCHEDULE MJL-D17","index":20,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[3,0,3,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[4,0,4,4]]}
["AMEREN MISSOURI"]
[{"$f":"\"INCREASE REQUIRED TO PRODUCE \"& TEXT('SCHEDULE MJL-D16'!D54,\"0.000%\") &\" RETURN ON \"","v":"INCREASE REQUIRED TO PRODUCE 6.943% RETURN ON "}]
["TOTAL GAS NET ORIGINAL COST RATE BASE"]
[{"$f":" 'SCHEDULE MJL-D5'!A3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
["($000)"]
[]
[]
[null,null,null,null,"TOTAL"]
[null,null,null,null,"GAS"]
["LINE",null,"DESCRIPTION",null,"AMOUNT"]
[null,null,"(A)",null,"(B)"]
[]
[1,null,"TOTAL GAS NET ORIGINAL COST RATE BASE",null,{"$f":"'SCHEDULE MJL-D16'!F29","v":310461}]
[]
[null,null,"TOTAL GAS REVENUE REQUIREMENT:"]
[{"$f":"1+A13","v":2},null,{"$f":"\"RETURN AT PROPOSED RATE (\"&TEXT('SCHEDULE MJL-D16'!D54,\"0.000%\")&\")\"","v":"RETURN AT PROPOSED RATE (6.943%)"},null,{"$f":"'SCHEDULE MJL-D16'!F54","v":21555}]
[{"$f":"1+A16","v":3},null,"OPERATING AND MAINTENANCE EXPENSES",null,{"$f":"'SCHEDULE MJL-D16'!F41","v":36128}]
[4,null,"DEPRECIATION AND AMORTIZATION",null,{"$f":"'SCHEDULE MJL-D16'!F42","v":15720}]
[5,null,"TAXES OTHER THAN INCOME",null,{"$f":"'SCHEDULE MJL-D16'!F43","v":9231}]
[6,null,"FEDERAL AND STATE INCOME AND CITY EARNINGS TAXES AT CLAIMED RETURN",null,{"$f":"'SCHEDULE MJL-D16'!F45+'SCHEDULE MJL-D16'!F46+'SCHEDULE MJL-D16'!F47","v":4609}]
[7,null,"DEFERRED INCOME TAXES",null,{"$f":"'SCHEDULE MJL-D16'!F52","v":-775}]
[8,null,"TOTAL GAS REVENUE REQUIREMENT",null,{"$f":"SUM(E16:E21)","v":86468}]
[]
[]
[{"$f":"1+A22","v":9},null,"PRO FORMA TOTAL GAS OPERATING REVENUE AT PRESENT RATES",null,{"$f":"+'SCHEDULE MJL-D10'!F19","v":77065}]
[null,null,""]
[{"$f":"1+A25","v":10},null,"DEFICIENCY IN TOTAL GAS OPERATING REVENUE",null,{"$f":"E22-E25","v":9403}]
[]
[]
[null,null,null,null,null,{"$f":"+UPPER(C30)","v":""}]

{"sheet":"SCHEDULE MJL-D18","index":21,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10],[2,0,2,10]]}
["Ameren Missouri"]
["Cash Working Capital Requirement"]
["For the Twelve Months Ended December 31, 2020"]
[]
[]
[]
["Line No.",null,"Description",null,"Revenue Lag",null,"Expense Lead",null,"Net Lag",null,"CWC Factor"]
[null,null,"(A)",null,"(B)",null,"(C)",null,"(D)",null,"(E)"]
[]
[1,null,"Pensions & Benefits",null,39.500661774353489,null,-18.40927550774337,null,{"$f":"E10+G10","v":21.091386266610119},null,{"$f":"I10/365","v":5.7784619908520872E-2}]
[{"$f":"A10+1","v":2},null,"Payroll and Withholdings",null,39.500661774353489,null,-10.150332037892337,null,29.350329736461152,null,8.0411862291674394E-2]
[3,null,"Payroll Taxes",null,39.500661774353489,null,-9.3785215167225466,null,30.122140257630942,null,8.2526411664742311E-2]
[4,null,"Other Operations and Maintenance Expenses",null,39.500661774353489,null,-43.847672964108341,null,-4.347011189754852,null,-1.1909619697958498E-2]
[5,null,"Property/Real Estate Taxes",null,39.500661774353489,null,-183,null,-143.49933822564651,null,-0.39314887185108632]
[6,null,"Sales Tax",null,39.500661774353489,null,-9.312952732948057,null,30.187709041405434,null,8.2706052168234068E-2]
[7,null,"Gross Receipts Taxes",null,24.29232844102016,null,-26.13670422107019,null,-1.8443757800500293,null,-5.0530843289041897E-3]
[8,null,"Federal Income Tax",null,39.500661774353489,null,-38,null,1.5006617743534889,null,4.1114021215164082E-3]
[9,null,"State Income Tax",null,39.500661774353489,null,-38,null,1.5006617743534889,null,4.1114021215164082E-3]
[10,null,"St Louis Corporate Earnings Tax",null,39.500661774353489,null,-274.5,null,-234.99933822564651,null,-0.64383380335793561]
[11,null,"PGA Expense",null,39.500661774353489,null,-35.017627922770231,null,4.483033851583258,null,1.2282284524885638E-2]
[12,null,"Interest Expense",null,39.500661774353489,null,-91.368771393379063,null,-51.868109619025574,null,-0.14210440991513856]
[13,null,"Incentive Compensation",null,39.500661774353489,null,-250.29206629223631,null,-210.79140451788282,null,-0.57751069730926796]
[14,null,"Self Procured Insurance Tax",null,39.500661774353489,null,-241.5,null,-201.99933822564651,null,-0.55342284445382606]