{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["SCHEDULE MJL-S1-1","SCHEDULE MJL-S1-2","SCHEDULE MJL-S2-1","SCHEDULE MJL-S2-2","SCHEDULE MJL-S3","SCHEDULE MJL-S4","SCHEDULE MJL-S5","SCHEDULE MJL-S6","SCHEDULE MJL-S7","SCHEDULE MJL-S8","SCHEDULE MJL-S9","SCHEDULE MJL-S10","SCHEDULE MJL-S11-1","SCHEDULE MJL-S11-5","SCHEDULE MJL-S12-1","SCHEDULE MJL-S12-2","SCHEDULE MJL-S13","SCHEDULE MJL-S14-1","SCHEDULE MJL-S14-2","SCHEDULE MJL-S15","SCHEDULE MJL-S16","SCHEDULE MJL-S17"],"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-S1-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-S3'!A3:G3","v":"BY FUNCTIONAL CLASSIFICATION FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
["($000)"]
[]
[]
[null,null,null,null,"TOTALS",null,"ADJUSTED"]
[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,4924,15184,{"$f":"SUM(E12:F12)","v":20108}]
[]
[{"$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,6761,0,{"$f":"SUM(E16:F16)","v":6761}]
[]
[{"$f":"+A16+1","v":4},null,"DISTRIBUTION PLANT",null,533640,0,{"$f":"SUM(E18:F18)","v":533640}]
[]
[{"$f":"1+A18","v":5},null,"GENERAL PLANT",null,42406,14461,{"$f":"SUM(E20:F20)","v":56867}]
[]
[{"$f":"1+A20","v":6},null,"INCENTIVE COMPENSATION CAPITALIZED",null,0,-1812,{"$f":"SUM(E22:F22)","v":-1812}]
[]
[{"$f":"1+A22","v":7},null,"TOTAL PLANT IN SERVICE",null,{"$f":"SUM(E12:E22)","v":587731},{"$f":"SUM(F12:F22)","v":27833},{"$f":"SUM(G12:G22)","v":615564}]
[]
[]
[]
["(1) Details of pro forma adjustments per SCHEDULE MJL-S1-2."]

{"sheet":"SCHEDULE MJL-S1-2","index":1,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[9,2,10,8],[13,2,13,8]]}
[{"$f":"+'SCHEDULE MJL-S1-1'!A1:G1","v":"AMEREN MISSOURI"}]
["EXPLANATION OF PRO FORMA ADJUSTMENTS TO PLANT"]
[{"$f":"+'SCHEDULE MJL-S1-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,"Reduce Plant-in-Service for AMI software investment.",null,null,null,null,null,null,null,-4545]
[]
[{"$f":"+A8+1","v":2},-2,"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,34190]
[]
[]
[]
[{"$f":"+A10+1","v":3},-3,"Reduce Plant-in-Service for disallowed capital incentive compensation.",null,null,null,null,null,null,null,-1812]
[]
[]
[{"$f":"1+A14","v":4},null,"Total Pro Forma Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(K8:K14)","v":27833}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null," "]

{"sheet":"SCHEDULE MJL-S2-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-S1-1'!A3:G3","v":"BY FUNCTIONAL CLASSIFICATION FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
["($000)"]
[]
[]
[null,null,null,null,"TOTALS",null,"ADJUSTED"]
[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,2549,7370,{"$f":"E12+F12","v":9919}]
[]
[{"$f":"1+A12","v":2},null,"PRODUCTION PLANT",null,-779,0,-779]
[]
[{"$f":"1+A14","v":3},null,"TRANSMISSION PLANT",null,3098,0,3098]
[]
[{"$f":"1+A16","v":4},null,"DISTRIBUTION PLANT",null,200114,0,200114]
[]
[{"$f":"1+A18","v":5},null,"GENERAL PLANT",null,9297,4192,13489]
[]
[{"$f":"1+A20","v":6},null,"INCENTIVE COMPENSATION CAPITALIZED",null,0,-515,{"$f":"E22+F22","v":-515}]
[]
[{"$f":"1+A22","v":7},null,"TOTAL DEPRC. & AMORT RESERVE",null,{"$f":"E12+E14+E16+E18+E20+E22","v":214279},{"$f":"F12+F14+F16+F18+F20+F22","v":11047},{"$f":"G12+G14+G16+G18+G20+G22","v":225326}]
[]
["(1) Details of pro forma adjustments per SCHEDULE MJL-S2-2."]

{"sheet":"SCHEDULE MJL-S2-2","index":3,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[10,2,11,8]]}
[{"$f":"+'SCHEDULE MJL-S1-1'!A1:G1","v":"AMEREN MISSOURI"}]
["EXPLANATION OF PRO FORMA ADJUSTMENTS TO ACCUMULATED RESERVES"]
[{"$f":"+'SCHEDULE MJL-S1-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,"Reduce Plant-in-Service for AMI software investment.",null,null,null,null,null,null,null,-1141]
[]
[{"$f":"+A9+1","v":2},-2,{"$f":"+'SCHEDULE MJL-S1-2'!C10","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,12703]
[{"$f":"A11+1","v":3}]
[]
[]
[{"$f":"+A12+1","v":4},-3,"Reserve Balance adjustment for disallowed Incentive Compensation capitalized.",null,null,null,null,null,null,null,-515]
[]
[]
[{"$f":"A15+1","v":5},null,"Total Pro Forma Adjustments",null,null,null,null,null,null,null,{"$f":"SUM(K9:K15)","v":11047}]

{"sheet":"SCHEDULE MJL-S3","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,"ADJUSTED"]
[null,null,null,"PER",null,"GAS"]
["LINE",null,"DESCRIPTION","BOOKS","ADJUSTMENTS","TOTALS"]
[null,null,"(A)","(B)","(C)","(D)"]
[]
[]
[1,null,"GENERAL MATERIALS AND SUPPLIES",2325,0,{"$f":"D12+E12","v":2325}]
[]
[{"$f":"1+A12","v":2},null,"GAS STORED UNDERGROUND",4338,0,{"$f":"D14+E14","v":4338}]
[]
[{"$f":"1+A14","v":3},null,"TOTAL",{"$f":"D12+D14","v":6663},{"$f":"E12+E14","v":0},{"$f":"F12+F14","v":6663}]

{"sheet":"SCHEDULE MJL-S4","index":5,"n_rows":48,"n_cols":7,"rows_kept":48,"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-S3'!A3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
[null,"($000)"]
[]
[null,null,null,null,"TOTALS",null,"ADJUSTED"]
[null,null,null,null,"PER",null,"GAS"]
[null,"LINE",null,"DESCRIPTION ","BOOKS(1)","ADJUSTMENTS","TOTALS"]
[null,null,null,"(A)","(B)","(C)","(D)"]
[]
[null,1,null,"   RENTS (3)",392,-383,{"$f":"E11+F11","v":9}]
[null,{"$f":"1+B11","v":2},null,"   INSURANCE - DIRECT (2)",11367,-10738,629]
[null,3,null,"   REG. COMMISSION ASSESSMENTS (3)",0,0,0]
[null,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)",4591,-4480,111]
[null,7,null,"   SYBASE MAINTENANCE (ELEC ONLY)",0,0,0]
[null,8,null,"   IMAGING SOFTWARE (ELEC ONLY)",60,-60,0]
[null,9,null,"   FUELWORKS SOFTWARE (ELEC ONLY)",0,0,0]
[null,10,null,"   MICROSOFT ENTERPRISE APPLICATIONS (3)",0,0,0]
[null,11,null,"   SECUREWORKS APPLICATIONS (ELEC ONLY)",0,0,0]
[null,12,null,"   ARBOR NEWSTAR SERVICE FEE (3)",0,0,0]
[null,13,null,"   OPTIV GIGAMON (3)",0,0,0]
[null,14,null,"   CAROUSEL (AVAYA) MAINTENANCE (3)",0,0,0]
[null,15,null,"   ENERGY EFFICIENCY PROGRAM VENDORS (2)",0,0,0]
[null,16,null,"   NSR & OPACITY LITIGATION (2)",0,0,0]
[null,17,null,"   ENERGY EFFICENCY PROGRAM VENDORS (GAS ONLY)",0,0,0]
[null,18,null,"   CRM SALESFORCE SUBSCRIPTION (3)",0,0,0]
[null,19,null,"   KANSAS CITY POWER & LIGHT (ELEC ONLY)",2034,-2034,0]
[null,20,null,"   PALO ALTO ENTERPRISE (3)",123,-120,3]
[null,21,null,"   RCGA MEMBERSHIP DUES (ELEC ONLY)",33,-33,0]
[null,22,null,"   AGA MEMBERSHIP DUES (GAS ONLY)",14,0,14]
[null,23,null,"   ENERGY EFFICENCY MO COLLABORATIVE (GAS ONLY)",0,0,0]
[null,24,null,"   LOW INCOME WEATHERIZATION - DIRECT (2)",386,-302,84]
[]
[null,{"$f":"1+B34","v":25},null,"TOTAL AVERAGE PREPAYMENTS",{"$f":"SUM(E11:E34)","v":19000},{"$f":"SUM(F11:F34)","v":-18150},{"$f":"SUM(G11:G34)","v":850}]
[]
[null,{"$f":"1+B36","v":26},-1,"Reflects 13 month average"]
[null,{"$f":"1+B38","v":27},-2,"Directly assigned to electric or gas."]
[null,{"$f":"1+B39","v":28},-3,"Allocated to gas based on operating expenses excluding  purchased power, fuel adjustment clause and purchased gas."]
[]
[]
[]
[null,null,"PRO FORMA ADJUSTMENT"]
[]
[null,{"$f":"B40+1","v":29},-1,"Eliminate portions of prepayments which are applicable to electric operations.  Allocated between",null,null,{"$f":"+F36","v":-18150}]
[null,{"$f":"1+B46","v":30},null,"electric and gas operations based on operating expenses excluding purchased power, fuel adjustment clause"]
[null,{"$f":"1+B47","v":31},null,"and purchased gas."]

{"sheet":"SCHEDULE MJL-S5","index":6,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[35,2,35,7],[0,0,0,10],[1,0,1,10]]}
["AMEREN MISSOURI"]
["TOTAL GAS CASH WORKING CAPITAL"]
[{"$f":"+'SCHEDULE MJL-S3'!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.42,-10.9,28.520000000000003,7.8136999999999998E-2,16413,1282]
[{"$f":"1+A11","v":2},null,"PENSIONS AND OPEBs",null,39.42,-15.7,23.720000000000002,6.4986000000000002E-2,-567,-37]
[3,null,"OTHER EMPLOYEE BENEFITS",null,39.42,-17.649999999999999,21.770000000000003,5.9644000000000003E-2,2546,152]
[4,null,"FUEL",null,39.42,-39.42,0,0,42944,0]
[5,null,"INCENTIVE COMPENSATION",null,39.42,-250.8,-211.38,-0.57912300000000005,1699,-984]
[6,null,"UNCOLLECTIBLE ACCOUNTS",null,39.42,-39.42,0,0,646,0]
[7,null,"OTHER OPERATING EXPENSES",null,39.42,-43.85,-4.43,-1.2137E-2,14320,-174]
[8]
[9,null,"TOTAL O&M EXPENSES",null,null,null,null,null,35056]
[]
[{"$f":"1+A19","v":10},null,"     TOTAL CASH WORKING CAPITAL REQUIREMENT",null,null,null,null,null,null,{"$f":"SUM(J11:J17)","v":239}]
[]
[{"$f":"1+A21","v":11},null,"FICA - EMPLOYER'S PORTION",null,39.42,-9.3800000000000008,30.04,8.2300999999999999E-2,1080,89]
[{"$f":"1+A23","v":12},null,"FEDERAL UNEMPLOYMENT TAXES",null,39.42,-9.3800000000000008,30.04,8.2300999999999999E-2,8,1]
[{"$f":"1+A24","v":13},null,"PROPERTY TAXES",null,39.42,-183,-143.57999999999998,-0.39337,8126,-3197]
[14,null,"SALES TAXES",null,39.42,-9.31,30.11,8.2492999999999997E-2,3115,257]
[15,null,"SELF PROCURED INSURANCE TAX",null,39.42,-241.5,-202.07999999999998,-0.55364400000000002,8,-4]
[16,null,"GROSS RECEIPTS TAXES",null,24.21,-26.14,-1.9299999999999997,-5.2880000000000002E-3,5812,-31]
[]
[{"$f":"1+A28","v":17},null,"TOTAL TAXES AND OTHER EXPENSES",null,null,null,null,null,{"$f":"SUM(I23:I28)","v":18149}]
[]
[{"$f":"1+A30","v":18},null,"     NET CUSTOMER SUPPLIED FUNDS",null,null,null,null,null,null,{"$f":"SUM(J23:J28)","v":-2885}]
[]
[{"$f":"1+A32","v":19},null,"NET CASH WORKING CAPITAL REQUIREMENT",null,null,null,null,null,null,{"$f":"J21+J32","v":-2646}]

{"sheet":"SCHEDULE MJL-S6","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-S5'!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.42,-38,1.4200000000000017,3.8899999999999998E-3,3769,{"$f":"ROUND(+H14*I14,0)","v":15}]
[]
[]
[{"$f":"1+A14","v":2},null,"STATE INCOME TAX CASH REQUIREMENT",null,39.42,-38,1.4200000000000017,3.8899999999999998E-3,669,{"$f":"ROUND(+H17*I17,0)","v":3}]
[]
[]
[{"$f":"1+A17","v":3},null,"CITY EARNINGS TAX CASH REQUIREMENT",null,39.42,-274.5,-235.07999999999998,-0.64405500000000004,-45,{"$f":"ROUND(+H20*I20,0)","v":29}]
[]
[]
[{"$f":"1+A20","v":4},null,"INTEREST EXPENSE CASH REQUIREMENT",null,39.42,-91.37,-51.95,-0.14232900000000001,5794,{"$f":"ROUND(+H23*I23,0)","v":-825}]

{"sheet":"SCHEDULE MJL-S7","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-S4'!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,-445]
[]
[]
[{"$f":"1+A13","v":2},null,"AVERAGE CUSTOMER DEPOSITS",null,-711]

{"sheet":"SCHEDULE MJL-S8","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-S9'!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,-513]
[]
[]
[{"$f":"1+A15","v":2},null,"OTHER POST-EMPLOYMENT BENEFITS",null,null,null,null,-933]
[]
[]
[]
[{"$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-S9","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-S3'!A3:G3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
["($000)"]
[]
[null,null,null,null,null,"TOTAL"]
[null,null,null,null,null,"GAS",null,"GAS"]
["LINE",null,"DESCRIPTION",null,null,"PER BOOKS","ADJUSTMENTS","TOTAL"]
[null,null,"(A)",null,null,"(B)","(C)","(D)"]
[]
[1,null,"ACCOUNT 190",null,null,1561,0,{"$f":"+F11+G11","v":1561}]
[]
[{"$f":"1+A11","v":2},null,"ACCOUNT 282",null,null,-79661,0,{"$f":"+F13+G13","v":-79661}]
[]
[{"$f":"1+A13","v":3},null,"ACCOUNT 283",null,null,-250,0,{"$f":"+F15+G15","v":-250}]
[]
[{"$f":"1+A15","v":4},null,"TOTAL ACCUMULATED DEFERRED INCOME TAXES",null,null,{"$f":"SUM(F11:F16)","v":-78350},{"$f":"SUM(G11:G16)","v":0},{"$f":"SUM(H11:H16)","v":-78350}]

{"sheet":"SCHEDULE MJL-S10","index":11,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["AMEREN MISSOURI"]
["TOTAL GAS PER BOOK AND PRO FORMA OPERATING REVENUES"]
[{"$f":"'SCHEDULE MJL-S5'!A3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
["($000)"]
[]
[]
[]
[null,null,null,null,null,"ADJUSTED"]
[null,null,null,"TOTAL ",null,"TOTAL "]
["LINE",null,"DESCRIPTION","GAS","ADJUSTMENTS","GAS"]
[null,null,"(A)","(B)","(C)","(D)"]
[]
[null,null,"OPERATING REVENUES"]
[1,null,"RETAIL REVENUES",108814,-47418,{"$f":"D14+E14","v":61396}]
[{"$f":"1+A14","v":2},null,"TRANSPORTATION",13442,777,{"$f":"D15+E15","v":14219}]
[3,null,"PROVISION FOR RATE REFUNDS",769,-769,{"$f":"D16+E16","v":0}]
[{"$f":"1+A16","v":4},null,"OTHER GAS REVENUES",1561,291,{"$f":"D17+E17","v":1852}]
[]
[{"$f":"+A17+1","v":5},null,"TOTAL REVENUES PER BOOKS",{"$f":"SUM(D14:D18)","v":124586},-47119,{"$f":"SUM(F14:F18)","v":77467}]
[]
[]
[]
[null,null,"PRO FORMA ADJUSTMENTS:"]
[{"$f":"1+A19","v":6},-1,"REMOVE ADD ON REVENUE TAX",-5763]
[{"$f":"1+A24","v":7},-2,"ADJUSTMENT TO REFLECT NORMAL WEATHER",961]
[8,-3,"ELIMINATE PGA REVENUES",-42475]
[{"$f":"1+A26","v":9},-4,"ADJUST FOR BILLING UNITS",750]
[10,-5,"ELIMINATE  UNBILLED REVENUE",-1385]
[11,-6,"SOFTWARE RENTAL ADJUSTMENT",153]
[12,-7,"REMOVE BOA LEASE REVENUES",-72]
[13,-8,"GROWTH ADJUSTMENT",249]
[14,-9,"INTERCOMPANY FACILITY REVENUES",42]
[15,-10,"DISCONNECT/RECONNECT FEE REVENUES",16]
[16,-11,"DAYS & LEAP YEAR ADJUSTMENT",61]
[17,-12,"COVID ADJUSTMENT",193]
[18,-13,"LATE FEE REVENUE NORMALIZATION",151]
[]
[{"$f":"1+A36","v":19},null,"TOTAL PRO FORMA ADJUSTMENTS",null,{"$f":"SUM(D24:D36)","v":-47119}]

{"sheet":"SCHEDULE MJL-S11-1","index":12,"n_rows":45,"n_cols":49,"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","#27","#28",null,null,null,null,"#29","#30"]
[null,null,"Title included in Page header for printing purposes.",null,null,null,"SHORT-TERM","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","INTENTIONALLY","QUALIFIED","PENSION","PENSION","DEPRECIATION","BOA","ELECTRIC COSTS",null,null,null,null,null,"ALLOCATION","INTENTIONALLY","REMOVE ","BOARD OF ","SOFTWARE","INTERCOMPANY","EV","CUSTOMER","INTENTIONALLY","CALL CENTER",null,null,null,null,"NORMALIZE",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/","LEFT ","PENSION","AND OPEB","AND OPEB","AND RATE","RENTAL","ALLOCATED","DEPR TO O&M",null,null,null,null,"FACTOR","LEFT ","ALCOHOL","DIRECTORS","RENTAL","FACILITY","INCENTIVE","CONVENIENCE","LEFT ","COST",null,null,null,null,"INJURIES &","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","BLANK","ADJUST.","TRACKER","TRACKER","CASE EXPENSE","EXPENSE","TO GAS","ADJUSTMENT",null,null,"LINE","FUNCTIONAL CLASSIFICATION","ADJUSTMENT","BLANK","PURCHAES","EXPENSE","EXPENSE","RENT","ADJUSTMENT","FEES","BLANK","ADJUSTMENT",null,null,"LINE","FUNCTIONAL CLASSIFICATION","DAMAGES","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)","(K)",null,null,null,"(A)","(B)","(C)","(D)","(E)","(F)","(G)","(H)","(I)","(J)","(K)",null,null,null,"(A)","(B)","(C)","(D)","(E)"]
[]
[]
[null,null,{"$f":"1","v":1},"  PRODUCTION:",43713,10,-4,-15,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,0,0,null,null,{"$f":"1","v":1},"  PRODUCTION:",0,0,{"$f":"SUM(F9:M9,R9:AA9,AF9:AO9,AT9:AU9)","v":-42953},{"$f":"+E9+AV9","v":760}]
[]
[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,0,0,null,null,{"$f":"1+AR9","v":2},"  TOTAL TRANSMISSION EXPENSES:",0,0,{"$f":"SUM(F11:M11,R11:AA11,AF11:AO11,AT11:AU11)","v":0},{"$f":"+E11+AV11","v":8}]
[]
[null,null,{"$f":"1+C11","v":3},"  DISTRIBUTION EXPENSES:",14480,182,-43,-47,0,0,0,0,0,null,null,{"$f":"1+P11","v":3},"  DISTRIBUTION EXPENSES:",0,-165,0,0,0,0,0,0,0,-66,null,null,{"$f":"1+AD11","v":3},"  DISTRIBUTION EXPENSES:",1,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AR11","v":3},"  DISTRIBUTION EXPENSES:",0,0,{"$f":"SUM(F13:M13,R13:AA13,AF13:AO13,AT13:AU13)","v":-138},{"$f":"+E13+AV13","v":14342}]
[]
[null,null,{"$f":"1+C13","v":4},"  CUSTOMER ACCOUNTING EXPENSES:",5680,64,-15,-12,-104,0,0,30,0,null,null,{"$f":"1+P13","v":4},"  CUSTOMER ACCOUNTING EXPENSES:",0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"1+AD13","v":4},"  CUSTOMER ACCOUNTING EXPENSES:",0,0,0,0,0,0,0,461,0,11,null,null,{"$f":"1+AR13","v":4},"  CUSTOMER ACCOUNTING EXPENSES:",0,0,{"$f":"SUM(F15:M15,R15:AA15,AF15:AO15,AT15:AU15)","v":435},{"$f":"+E15+AV15","v":6115}]
[]
[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,0,0,null,null,{"$f":"1+AR15","v":5},"  CUSTOMER SERV. & INFO. EXPENSES:",0,0,{"$f":"SUM(F17:M17,R17:AA17,AF17:AO17,AT17:AU17)","v":-1},{"$f":"+E17+AV17","v":804}]
[]
[null,null,{"$f":"1+C17","v":6},"  SALES EXPENSES:",54,1,0,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,0,0,null,null,{"$f":"1+AR17","v":6},"  SALES EXPENSES:",0,0,{"$f":"SUM(F19:M19,R19:AA19,AF19:AO19,AT19:AU19)","v":1},{"$f":"+E19+AV19","v":55}]
[]
[null,null,{"$f":"1+C19","v":7},"  ADMINISTRATIVE & GENERAL EXPENSES:",13156,89,-30,-368,0,-55,0,0,41,null,null,{"$f":"1+P19","v":7},"  ADMINISTRATIVE & GENERAL EXPENSES:",130,-21,0,35,260,-20,213,-127,-14,0,null,null,{"$f":"1+AD19","v":7},"  ADMINISTRATIVE & GENERAL EXPENSES:",53,0,-1,-18,-22,38,-1,0,0,0,null,null,{"$f":"1+AR19","v":7},"  ADMINISTRATIVE & GENERAL EXPENSES:",-360,-6,{"$f":"SUM(F21:M21,R21:AA21,AF21:AO21,AT21:AU21)","v":-184},{"$f":"+E21+AV21","v":12972}]
[]
[null,null,{"$f":"1+C21","v":8},"TOTAL OPERATIONS & MAINTENANCE EXPENSES",{"$f":"SUM(E9:E21)","v":77896},{"$f":"SUM(F9:F21)","v":346},-92,-443,{"$f":"SUM(I9:I21)","v":-104},-55,{"$f":"SUM(K9:K21)","v":-42944},30,41,null,null,{"$f":"1+P21","v":8},"TOTAL OPERATIONS & MAINTENANCE EXPENSES",{"$f":"SUM(R9:R21)","v":130},{"$f":"SUM(S9:S21)","v":-186},0,35,260,-20,213,{"$f":"SUM(Y9:Y21)","v":-127},{"$f":"SUM(Z9:Z21)","v":-14},-66,null,null,{"$f":"1+AD21","v":8},"TOTAL OPERATIONS & MAINTENANCE EXPENSES",{"$f":"SUM(AF9:AF21)","v":54},{"$f":"SUM(AG9:AG21)","v":0},{"$f":"SUM(AH9:AH21)","v":-1},-18,-22,38,-1,461,{"$f":"SUM(AN9:AN21)","v":0},11,null,null,{"$f":"1+AR21","v":8},"TOTAL OPERATIONS & MAINTENANCE EXPENSES",{"$f":"SUM(AT9:AT21)","v":-360},{"$f":"SUM(AU9:AU21)","v":-6},{"$f":"SUM(AV9:AV21)","v":-42840},{"$f":"SUM(AW9:AW21)","v":35056}]
[]
[null,null,{"$f":"1+C23","v":9},"NOTE: See SCHEDULE MJL-S11-5 for explanation of the pro forma adjustments.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+P23","v":9},{"$f":"D25","v":"NOTE: See SCHEDULE MJL-S11-5 for explanation of the pro forma adjustments."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+AD23","v":9},{"$f":"D25","v":"NOTE: See SCHEDULE MJL-S11-5 for explanation of the pro forma adjustments."},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+AR23","v":9},{"$f":"D25","v":"NOTE: See SCHEDULE MJL-S11-5 for explanation of the pro forma adjustments."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SCHEDULE MJL-S11-1",null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE MJL-S11-2",null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE MJL-S11-3",null,null,null,null,null,null,null,null,null,null,null,null,null,"SCHEDULE MJL-S11-4"]

{"sheet":"SCHEDULE MJL-S11-5","index":13,"n_rows":77,"n_cols":12,"rows_kept":77,"cut":false,"hidden":false,"merged":[[68,2,68,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],[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]]}
["AMEREN MISSOURI"]
["GAS OPERATING AND MAINTENANCE EXPENSE"]
["PRO FORMA ADJUSTMENTS"]
[{"$f":"'SCHEDULE MJL-S5'!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-S11-1'!F23","v":346}]
[{"$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 per share targets.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!G23","v":-92}]
[{"$f":"1+A14","v":5}]
[]
[{"$f":"1+A15","v":6},-3,"Eliminate the long term incentive compensation related to earnings per share targets.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!H23","v":-443}]
[]
[{"$f":"1+A17","v":7},-4,"To adjust bad debt expense to write-offs. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!I23","v":-104}]
[]
[{"$f":"1+A19","v":8},-5,"Management and Contract salaries  annualized for increased headcount (-54 Ameren MO and 56 Ameren Services employees) ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!J23","v":-55}]
[]
[]
[{"$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-S11-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-S11-1'!L23","v":30}]
[{"$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-S11-1'!M23","v":41}]
[]
[{"$f":"1+A29","v":13},-9,"Increase administrative and general expenses to reflect the annualized true-up period in the other employee benefit expenses.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!R23","v":130}]
[{"$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-S11-1'!S23","v":-186}]
[]
[{"$f":"1+A34","v":16},-11,"Intentionally left blank",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!T23","v":0}]
[]
[{"$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-S11-1'!U23","v":35}]
[]
[{"$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-S11-1'!V23","v":260}]
[]
[{"$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-S11-1'!W23","v":-20}]
[]
[{"$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-S11-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-S11-1'!Y23","v":-127}]
[]
[{"$f":"A47+1","v":23},-17,"To remove Electric Costs Allocated to Gas",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-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-S11-1'!AA23","v":-66}]
[]
[{"$f":"A51+1","v":25},-19,"To adjust Allocation Factors to 2021 levels.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AF23","v":54}]
[]
[{"$f":"A53+1","v":26},-20,"Intentionally left blank",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AG23","v":0}]
[]
[{"$f":"A55+1","v":27},-21,"Remove alcohol expenses",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AH23","v":-1}]
[]
[{"$f":"A57+1","v":28},-22,"To remove certain Board of Directors travel costs. ",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AI23","v":-18}]
[]
[{"$f":"A59+1","v":29},-23,"To decrease software rental expense as a result of true-up.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AJ23","v":-22}]
[]
[{"$f":"A61+1","v":30},-24,"To increase in Building rent charged to AMS allocated to Ameren Missouri as a result of true-up.",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AK23","v":38}]
[]
[{"$f":"A63+1","v":31},-25,"To remove EV Incentive costs",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AL23","v":-1}]
[]
[{"$f":"A65+1","v":32},-26,"To include customer convenience fees",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AM23","v":461}]
[]
[{"$f":"A67+1","v":33},-27,"Intentionally left blank",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AN23","v":0}]
[]
[{"$f":"A69+1","v":34},-28,"To adjust outside call center costs to a 3 year average",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AO23","v":11}]
[]
[{"$f":"A71+1","v":35},-29,"To normalize injuries & damages to a 5 year average",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AT23","v":-360}]
[]
[{"$f":"A73+1","v":36},-30,"Decrease test year expenses to annualize MPSC assessment",null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE MJL-S11-1'!AU23","v":-6}]
[]
[{"$f":"1+A75","v":37},"     Total Pro Forma Adjustments to Gas Operating and Maintenance Expenses",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L10:L76)","v":-42840}]

{"sheet":"SCHEDULE MJL-S12-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-S5'!A3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
[null,"($000)"]
[]
[null,null,null,"TOTALS",null,"ADJUSTED"]
[null,null,null,"PER",null,"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-S12-2'!E18+'SCHEDULE MJL-S12-2'!E27","v":2465},{"$f":"SUM(D12:E12)","v":3382}]
[null,{"$f":"1+B12","v":2},"PRODUCTION",0,{"$f":"+'SCHEDULE MJL-S12-2'!E14+'SCHEDULE MJL-S12-2'!E23","v":0},0]
[null,{"$f":"1+B13","v":3},"TRANSMISSION PLANT",107,{"$f":"+'SCHEDULE MJL-S12-2'!E15+'SCHEDULE MJL-S12-2'!E24","v":-16},91]
[null,4,"DISTRIBUTION PLANT",10836,{"$f":"+'SCHEDULE MJL-S12-2'!E16+'SCHEDULE MJL-S12-2'!E25","v":-899},9937]
[null,5,"GENERAL PLANT",2335,{"$f":"+'SCHEDULE MJL-S12-2'!E17+'SCHEDULE MJL-S12-2'!E26+'SCHEDULE MJL-S12-2'!E31","v":-29},{"$f":"SUM(D16:E16)","v":2306}]
[null,6,"INCENTIVE COMPENSATION",0,{"$f":"+'SCHEDULE MJL-S12-2'!E33","v":-54},-54]
[]
[null,{"$f":"1+B17","v":7},"    TOTAL DEPRECIATION EXPENSE",{"$f":"SUM(D12:D18)","v":14195},{"$f":"SUM(E12:E18)","v":1467},{"$f":"SUM(F12:F18)","v":15662}]
[]
[null,null,"MISC. AMORTIZATION:"]
[null,{"$f":"1+B19","v":8},"  AMORTIZATION OF COVID AAO",0,{"$f":"'SCHEDULE MJL-S12-2'!E35","v":65},{"$f":"SUM(D22:E22)","v":65}]
[null,{"$f":"1+B22","v":9},"  AMORTIZATION OF OVER/UNDER COLLECTION",-187,{"$f":"'SCHEDULE MJL-S12-2'!E39","v":42},{"$f":"SUM(D23:E23)","v":-145}]
[null,{"$f":"1+B23","v":10},"  AMORTIZATION OF EXCESS TRACKER",6,{"$f":"'SCHEDULE MJL-S12-2'!E37","v":65},71]
[null,{"$f":"1+B24","v":11},"  AMORTIZATION OF LOW INCOME ",0,0,0]
[]
[null,{"$f":"1+B25","v":12},"  TOTAL MISC AMORTIZATION",{"$f":"SUM(D22:D26)","v":-181},{"$f":"SUM(E22:E26)","v":172},{"$f":"SUM(F22:F26)","v":-9}]
[]
[null,{"$f":"1+B27","v":13},"TOTAL DEPR & AMORTIZATION EXPENSE",{"$f":"+D19+D27","v":14014},{"$f":"+E19+E27","v":1639},{"$f":"+F19+F27","v":15653}]
[]
[null,{"$f":"1+B29","v":14},"(1)  See SCHEDULE MJL-S12-2 for explanation of the pro forma adjustments."]

{"sheet":"SCHEDULE MJL-S12-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-S5'!A3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
["($000)"]
[]
[]
[]
["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,-1]
[{"$f":"1+A15","v":5},null,"Change in Depr. Exp. - Distribution",null,773]
[6,null,"Change in Depr. Exp. - General Plant",null,852]
[{"$f":"1+A17","v":7},null,"Change in Amort. Exp. - Intangible Plant",null,2465]
[{"$f":"1+A18","v":8},null,"Total Increase in Depreciation Expense",null,{"$f":"SUM(E14:E18)","v":4089}]
[]
[{"$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,-15]
[{"$f":"1+A24","v":12},null,"Change in Depr. Exp. - Distribution",null,-1672]
[13,null,"Change in Depr. Exp. - General Plant",null,-183]
[14,null,"Change in Amort. Exp. - Intangible Plant",null,0]
[15,null,"Total Increase in Depreciation Expense",null,{"$f":"SUM(E23:E27)","v":-1870}]
[]
[{"$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,-698]
[]
[{"$f":"1+A31","v":18},-4,"Depreciation on Incentive Compensation Capitalized",null,-54]
[]
[{"$f":"1+A33","v":19},-5,"Amortization of COVID AAO",null,65]
[]
[{"$f":"1+A35","v":20},-6,"Amortization of Excess Tracker",null,65]
[]
[{"$f":"1+A37","v":21},-7,"Amortization of Over/Under Collection",null,42]
[]
[{"$f":"1+A39","v":22},"TOTAL PRO FORMA ADJUSTMENTS: DEPRECIATION & AMORTIZATION",null,null,{"$f":"SUM(E19,E28,E31:E39)","v":1639}]

{"sheet":"SCHEDULE MJL-S13","index":16,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,0,1,4]]}
[]
["INTENTIONALLY LEFT BLANK"]

{"sheet":"SCHEDULE MJL-S14-1","index":17,"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-S5'!A3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"},{"$f":"\"FOR THE \" & 'SCHEDULE MJL-S5'!#REF!","v":{"$error":"#REF!"}},{"$f":"\"FOR THE \" & 'SCHEDULE MJL-S5'!#REF!","v":{"$error":"#REF!"}},{"$f":"\"FOR THE \" & 'SCHEDULE MJL-S5'!#REF!","v":{"$error":"#REF!"}},{"$f":"\"FOR THE \" & 'SCHEDULE MJL-S5'!#REF!","v":{"$error":"#REF!"}},{"$f":"\"FOR THE \" & 'SCHEDULE MJL-S5'!#REF!","v":{"$error":"#REF!"}}]
[null,"($000)"]
[]
[null,null,null,null,"TOTAL",null,"ADJUSTED"]
[null,null,null,null,"PER",null,"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,1096,{"$f":"'SCHEDULE MJL-S14-2'!K11","v":-16},{"$f":"E12+F12","v":1080}]
[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":1104},{"$f":"SUM(F12:F15)","v":-16},{"$f":"SUM(G12:G15)","v":1088}]
[]
[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,{"$f":"'SCHEDULE MJL-S14-2'!K13","v":-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":15029},{"$f":"F16+F21+F23+F29","v":-5828},{"$f":"G16+G21+G23+G29","v":9201}]
[]
[null,{"$f":"1+B32","v":15},"(1) See SCHEDULE MJL-D13-2 for explanation of the pro forma adjustments."]

{"sheet":"SCHEDULE MJL-S14-2","index":18,"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-S5'!A3","v":"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2020"}]
["($000)"]
[]
[]
["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,-16]
[]
[{"$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":-5828}]

{"sheet":"SCHEDULE MJL-S15","index":19,"n_rows":71,"n_cols":5,"rows_kept":71,"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-S5'!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,21849]
[]
[null,null,"ADD"]
[{"$f":"1+A10","v":2},null,"CURRENT INCOME TAXES",null,4392]
[{"$f":"1+A13","v":3},null,"DEFERRED INCOME TAXES"]
[{"$f":"1+A14","v":4},null,"     DEFERRED INCOME TAX EXPENSE",null,-1102]
[{"$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":25093}]
[]
[null,null,"ADDITIONS TO NET INCOME BEFORE INCOME TAX"]
[{"$f":"1+A18","v":7},null,"     BOOK DEPRECIATION",null,15653]
[{"$f":"1+A21","v":8},null,"     BOOK DEPRECIATION CHARGED TO O&M",null,698]
[9,null,"     EQUITY ISSUANCE COSTS",null,0]
[]
[{"$f":"1+A23","v":10},null,"TOTAL ADDITIONS",null,{"$f":"SUM(E21:E24)","v":16351}]
[]
[null,null,"SUBTRACTIONS TO NET INCOME BEFORE INCOME TAX"]
[{"$f":"1+A25","v":11},null,"     INTEREST ON DEBT (1)",null,5794]
[{"$f":"1+A28","v":12},null,"     TAX STRAIGHT LINE",null,16621]
[{"$f":"1+A29","v":13},null,"     RSU's perm item added from MPSC 0881",null,44]
[{"$f":"1+A30","v":14},null,"     PREFERRED DIVIDEND DEDUCTION",null,415]
[]
[{"$f":"1+A31","v":15},null,"TOTAL SUBTRACTIONS",null,{"$f":"SUM(E28:E31)","v":22874}]
[]
[{"$f":"1+A33","v":16},null,"TOTAL GAS NET TAXABLE INCOME",null,{"$f":"E18+E25-E33","v":18570}]
[]
[null,null,"FEDERAL INCOME TAX "]
[{"$f":"1+A35","v":17},null,"  NET TAXABLE INCOME",null,{"$f":"E35","v":18570}]
[{"$f":"1+A38","v":18},null,"  DEDUCT MISSOURI INCOME TAX",null,{"$f":"+E51","v":669}]
[{"$f":"1+A39","v":19},null,"  DEDUCT CITY EARNINGS TAX",null,{"$f":"+E58","v":-45}]
[{"$f":"1+A40","v":20},null,"  FEDERAL TAXABLE INCOME",null,{"$f":"E38-E39-E40","v":17946}]
[]
[{"$f":"1+A41","v":21},null,{"$f":"\"  FEDERAL INCOME TAX\"","v":"  FEDERAL INCOME TAX"},0.21,{"$f":"ROUND(E41*D43,0)-1","v":3768}]
[]
[null,null,"STATE INCOME TAXES"]
[{"$f":"1+A43","v":22},null,"  NET TAXABLE INCOME",null,{"$f":"E35","v":18570}]
[{"$f":"1+A46","v":23},null,"  DEDUCT 50% OF FEDERAL INCOME TAX",null,{"$f":"ROUND(E43*0.5,0)","v":1884}]
[{"$f":"1+A47","v":24},null,"  DEDUCT CITY EARNINGS TAX",null,{"$f":"+E58","v":-45}]
[{"$f":"1+A48","v":25},null,"  MISSOURI TAXABLE INCOME",null,{"$f":"E46-E47-E48","v":16731}]
[]
[{"$f":"1+A49","v":26},null,"TOTAL GAS MISSOURI INCOME TAX",0.04,{"$f":"ROUND(E49*D51,0)","v":669}]
[]
[null,null,"CITY EARNINGS TAX"]
[{"$f":"1+A51","v":27},null,"  NET TAXABLE INCOME",null,{"$f":"+E35","v":18570}]
[{"$f":"1+A54","v":28},null,"  LESS TAX ADJUSTMENTS TO INCOME",null,-56912.358770000006]
[{"$f":"1+A55","v":29},null,"  CITY TAXABLE INCOME",null,{"$f":"+E54+E55","v":-38342.358770000006}]
[]
[{"$f":"1+A56","v":30},null,"  CITY EARNINGS TAX",1.175E-3,{"$f":"ROUND(E56*D58,0)","v":-45}]
[]
[{"$f":"+A58+1","v":31},null,"TOTAL GAS CURRENT INCOME TAXES",null,{"$f":"E43+E51+E58","v":4392}]
[]
[null,null,"DEFERRED INCOME TAXES:"]
[{"$f":"1+A60","v":32},null,"     DEFERRED INCOME TAX EXPENSE",null,{"$f":"+E15","v":-1102}]
[{"$f":"1+A63","v":33},null,"     I.T.C. AMORTIZATION",null,{"$f":"+E16-1","v":-47}]
[{"$f":"1+A64","v":34},null,"TOTAL GAS DEFERRED INCOME TAX",null,{"$f":"SUM(E63:E64)","v":-1149}]
[]
[{"$f":"1+A65","v":35},null,"TOTAL GAS CURRENT & DEFERRED INCOME TAX",null,{"$f":"+E60+E65","v":3243}]
[]
[]
[{"$f":"1+A67","v":36},null,"(1)  RATE BASE X EMBEDDED"]
[{"$f":"1+A70","v":37},null,"       COST OF DEBT.",1.8489999999999999E-2]

{"sheet":"SCHEDULE MJL-S16","index":20,"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-S5'!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-S1",null,{"$f":"+'SCHEDULE MJL-S1-1'!G24","v":615564}]
[null,{"$f":"1+B13","v":2},"LESS: RESERVES FOR DEPRECIATION & AMORTIZATION","SCHEDULE MJL-S2",null,{"$f":"+'SCHEDULE MJL-S2-1'!G24","v":225326}]
[null,{"$f":"1+B14","v":3},"     NET ORIGINAL COST OF PLANT",null,null,{"$f":"F13-F14","v":390238}]
[null,4,"AVERAGE FUEL AND MATERIALS AND SUPPLIES","SCHEDULE MJL-S3",null,{"$f":"+'SCHEDULE MJL-S3'!F16","v":6663}]
[null,5,"AVERAGE PREPAYMENTS","SCHEDULE MJL-S4",null,{"$f":"+'SCHEDULE MJL-S4'!G36","v":850}]
[null,6,"CASH WORKING CAPITAL (LEAD/LAG)","SCHEDULE MJL-S5",null,{"$f":"'SCHEDULE MJL-S5'!J34","v":-2646}]
[null,7,"FEDERAL INCOME TAX CASH REQUIREMENT","SCHEDULE MJL-S6",null,{"$f":"'SCHEDULE MJL-S6'!J14","v":15}]
[null,8,"STATE INCOME TAX CASH REQUIREMENT","SCHEDULE MJL-S6",null,{"$f":"'SCHEDULE MJL-S6'!J17","v":3}]
[null,9,"CITY EARNINGS TAX CASH REQUIREMENT","SCHEDULE MJL-S6",null,{"$f":"'SCHEDULE MJL-S6'!J20","v":29}]
[null,{"$f":"1+B21","v":10},"INTEREST EXPENSE CASH REQUIREMENT","SCHEDULE MJL-S6",null,{"$f":"'SCHEDULE MJL-S6'!J23","v":-825}]
[null,{"$f":"1+B22","v":11},"AVERAGE CUSTOMER ADVANCES FOR CONSTRUCTION","SCHEDULE MJL-S7",null,{"$f":"'SCHEDULE MJL-S7'!E13","v":-445}]
[null,12,"AVERAGE CUSTOMER DEPOSITS","SCHEDULE MJL-S7",null,{"$f":"'SCHEDULE MJL-S7'!E16","v":-711}]
[null,{"$f":"1+B24","v":13},"PENSION TRACKER REG ASSET","SCHEDULE MJL-S8",null,{"$f":"+'SCHEDULE MJL-S8'!H15","v":-513}]
[null,{"$f":"1+B25","v":14},"OPEB TRACKER REG  LIABILITY","SCHEDULE MJL-S8",null,{"$f":"+'SCHEDULE MJL-S8'!H18","v":-933}]
[null,{"$f":"1+B26","v":15},"ACCUMULATED DEFERRED INCOME TAXES ","SCHEDULE MJL-S9",null,{"$f":"+'SCHEDULE MJL-S9'!H17","v":-78350}]
[]
[null,{"$f":"1+B27","v":16},"TOTAL GAS NET ORIGINAL COST RATE BASE",null,null,{"$f":"SUM(F15:F27)","v":313375}]
[]
[null,null,"B. TOTAL GAS REVENUE REQUIREMENT"]
[]
[null,null,"TOTAL GAS OPERATING EXPENSES:"]
[null,{"$f":"1+B29","v":17},"PRODUCTION","SCHEDULE MJL-S11-1",null,{"$f":"+'SCHEDULE MJL-S11-1'!AW9","v":760}]
[null,{"$f":"1+B34","v":18},"TRANSMISSION","SCHEDULE MJL-S11-1",null,{"$f":"+'SCHEDULE MJL-S11-1'!AW11","v":8}]
[null,19,"DISTRIBUTION","SCHEDULE MJL-S11-1",null,{"$f":"+'SCHEDULE MJL-S11-1'!AW13","v":14342}]
[null,20,"CUSTOMER ACCOUNTS","SCHEDULE MJL-S11-1",null,{"$f":"+'SCHEDULE MJL-S11-1'!AW15","v":6115}]
[null,21,"CUSTOMER SERVICE","SCHEDULE MJL-S11-1",null,{"$f":"+'SCHEDULE MJL-S11-1'!AW17","v":804}]
[null,22,"SALES","SCHEDULE MJL-S11-1",null,{"$f":"+'SCHEDULE MJL-S11-1'!AW19","v":55}]
[null,23,"ADMINISTRATIVE AND GENERAL","SCHEDULE MJL-S11-1",null,{"$f":"+'SCHEDULE MJL-S11-1'!AW21","v":12972}]
[null,24,"   TOTAL GAS OPERATING EXPENSES",null,null,{"$f":"SUM(F34:F40)","v":35056}]
[null,25,"DEPRECIATION AND AMORTIZATION","SCHEDULE MJL-S12-1",null,{"$f":"+'SCHEDULE MJL-S12-1'!F29","v":15653}]
[null,26,"TAXES OTHER THAN INCOME TAXES","SCHEDULE MJL-S14-1",null,{"$f":"+'SCHEDULE MJL-S14-1'!G32","v":9201}]
[null,null,"INCOME TAXES-BASED ON PROPOSED RATE OF RETURN"]
[null,{"$f":"1+B43","v":27},"  FEDERAL","SCHEDULE MJL-S15",null,{"$f":"+'SCHEDULE MJL-S15'!E43","v":3768}]
[null,{"$f":"1+B45","v":28},"  STATE","SCHEDULE MJL-S15",null,{"$f":"+'SCHEDULE MJL-S15'!E51","v":669}]
[null,{"$f":"1+B46","v":29},"  CITY EARNINGS ","SCHEDULE MJL-S15",null,{"$f":"+'SCHEDULE MJL-S15'!E58","v":-45}]
[null,{"$f":"1+B47","v":30},"TOTAL INCOME TAXES",null,null,{"$f":"SUM(F45:F47)","v":4392}]
[null,null,"DEFERRED INCOME TAXES",null,0]
[null,{"$f":"1+B48","v":31},"     DEFERRED INCOME TAX EXPENSE","SCHEDULE MJL-S15",null,{"$f":"+'SCHEDULE MJL-S15'!E63","v":-1102}]
[null,{"$f":"1+B50","v":32},"     I.T.C. AMORTIZATION","SCHEDULE MJL-S15",null,{"$f":"+'SCHEDULE MJL-S15'!E64","v":-47}]
[null,{"$f":"1+B51","v":33},"TOTAL DEFERRED INCOME TAXES",null,null,{"$f":"SUM(F50:F51)","v":-1149}]
[]
[null,{"$f":"1+B52","v":34},{"$f":"\"RETURN (RATE BASE * \"&TEXT(D54,\"0.000%\")&\")\"","v":"RETURN (RATE BASE * 6.972%)"},6.9720000000000004E-2,null,{"$f":"ROUND(D54*F29,0)","v":21849}]
[]
[null,{"$f":"1+B54","v":35},"TOTAL GAS REVENUE REQUIREMENT",null,null,{"$f":"+F41+F42+F43+F48+F52+F54","v":85002}]

{"sheet":"SCHEDULE MJL-S17","index":21,"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-S16'!D54,\"0.000%\") &\" RETURN ON \"","v":"INCREASE REQUIRED TO PRODUCE 6.972% RETURN ON "}]
["TOTAL GAS NET ORIGINAL COST RATE BASE"]
[{"$f":" 'SCHEDULE MJL-S5'!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-S16'!F29","v":313375}]
[]
[null,null,"TOTAL GAS REVENUE REQUIREMENT:"]
[{"$f":"1+A13","v":2},null,{"$f":"\"RETURN AT PROPOSED RATE (\"&TEXT('SCHEDULE MJL-S16'!D54,\"0.000%\")&\")\"","v":"RETURN AT PROPOSED RATE (6.972%)"},null,{"$f":"'SCHEDULE MJL-S16'!F54","v":21849}]
[{"$f":"1+A16","v":3},null,"OPERATING AND MAINTENANCE EXPENSES",null,{"$f":"'SCHEDULE MJL-S16'!F41","v":35056}]
[4,null,"DEPRECIATION AND AMORTIZATION",null,{"$f":"'SCHEDULE MJL-S16'!F42","v":15653}]
[5,null,"TAXES OTHER THAN INCOME",null,{"$f":"'SCHEDULE MJL-S16'!F43","v":9201}]
[6,null,"FEDERAL AND STATE INCOME AND CITY EARNINGS TAXES AT CLAIMED RETURN",null,{"$f":"'SCHEDULE MJL-S16'!F45+'SCHEDULE MJL-S16'!F46+'SCHEDULE MJL-S16'!F47","v":4392}]
[7,null,"DEFERRED INCOME TAXES",null,{"$f":"'SCHEDULE MJL-S16'!F52","v":-1149}]
[8,null,"TOTAL GAS REVENUE REQUIREMENT",null,{"$f":"SUM(E16:E21)","v":85002}]
[]
[]
[{"$f":"1+A22","v":9},null,"PRO FORMA TOTAL GAS OPERATING REVENUE AT PRESENT RATES",null,{"$f":"+'SCHEDULE MJL-S10'!F19","v":77467}]
[null,null,""]
[{"$f":"1+A25","v":10},null,"DEFICIENCY IN TOTAL GAS OPERATING REVENUE",null,{"$f":"E22-E25","v":7535}]
[]
[]
[null,null,null,null,null,{"$f":"+UPPER(C30)","v":""}]