{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["Contents (OLD)","Contents","SPOT>>","0. Wholesale market","CONTRACTS>>","1. Strike prices","2. Contract types","3. Quarterly volumes","4. Quarterly prices regional","5. Monthly volumes","6. Monthly volumes regional","7. Hedged position","COST STACK>>","8. NEM $customer","9. NEM ckWh","10. Regional ckWh","11. Network","12. Wholesale","13. Environmental","14. Cost stack retail","RETAIL>>","15. Retail market share","16. Retail offers, Resi","17. Retail offers, SME","Lists"],"not_rendered":{"charts":0,"images":91,"macros":1,"external_links":0,"defined_names":69,"comments":2,"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":"Contents (OLD)","index":0,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Inquiry into the National Electricity Market - November 2022 Report"]
[null,null,"Appendix E supplementary spreadsheet"]
[]
[null,null,"Contents"]
[null,null,{"$f":"HYPERLINK(\"#'Report figures'!A1\", \"Report figures\")","v":"Report figures"},"","Tables and Charts"]
[null,null,{"$f":"HYPERLINK(\"#'1. NEM $customer'!A1\", \"NEM-wide Cost Stacks\")","v":"NEM-wide Cost Stacks"},"$/customer","Tables and Charts"]
[null,null,{"$f":"HYPERLINK(\"#'2. NEM ckWh'!A1\", \"NEM-wide Cost Stacks\")","v":"NEM-wide Cost Stacks"},"c/kWh","Tables and Charts"]
[null,null,{"$f":"HYPERLINK(\"#'3. Regional $customer'!A1\", \"Regional Cost Stacks\")","v":"Regional Cost Stacks"},"$/customer","Tables and Charts"]
[null,null,{"$f":"HYPERLINK(\"#'4. Regional ckWh'!A1\", \"Regional Cost Stacks\")","v":"Regional Cost Stacks"},"c/kWh","Tables and Charts"]
[null,null,{"$f":"HYPERLINK(\"#'Regional $customer Fig E3.2'!A1\", \"Regional Figure E3.2\")","v":"Regional Figure E3.2"},"$/customer","Table and Chart"]
[null,null,{"$f":"HYPERLINK(\"#'Regional ckWh Fig E4.2'!A1\", \"Regional Figure E4.2\")","v":"Regional Figure E4.2"},"c/kWh","Table and Chart"]
[null,null,{"$f":"HYPERLINK(\"#'5. Network'!A1\", \"Network costs\")","v":"Network costs"},"","Tables and Charts"]
[null,null,{"$f":"HYPERLINK(\"#'6. Wholesale'!A1\", \"Wholesale electricity costs\")","v":"Wholesale electricity costs"},"","Tables and Charts"]
[null,null,{"$f":"HYPERLINK(\"#'7. Environmental'!A1\", \"Environmental costs\")","v":"Environmental costs"},"","Tables and Charts"]
[null,null,{"$f":"HYPERLINK(\"#'8. Retail'!A1\", \"Retail costs and margins\")","v":"Retail costs and margins"},"","Tables and Charts"]
[]
[]
[null,null,"*Please note that figures presented have been rounded and may not sum due to rounding."]

{"sheet":"Contents","index":1,"n_rows":111,"n_cols":4,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Inquiry into the National Electricity Market - November 2022 Report"]
[null,null,"Appendix D - Data appendix"]
[]
[null,null,"Contents"]
[null,null,"This spreadsheet contains data tables for all ACCC-authored figures in the report."]
[null,null,"It also includes supplementary analysis of cost stack data not presented in the body of the report, including additional regional breakdowns."]
[]
[null,null,"Based on energy market bodies data"]
[null,null,"Sheet name","Description"]
[null,null,{"$f":"HYPERLINK(\"#Wholesale_Tab_1\", \"0. Wholesale market\")","v":"0. Wholesale market"},"Wholesale electricity generation and consumption"]
[]
[null,null,"Based on hedge contract data"]
[null,null,"Sheet name","Description"]
[null,null,{"$f":"HYPERLINK(\"#Contracts_Tab_1\", \"1. Strike prices\")","v":"1. Strike prices"},"Contract strike prices, all regions, $/MWh"]
[null,null,{"$f":"HYPERLINK(\"#Contracts_Tab_2\", \"2. Contract types\")","v":"2. Contract types"},"Contract types (base, swap, peak, etc), all regions"]
[null,null,{"$f":"HYPERLINK(\"#Contracts_Tab_3\", \"3. Quarterly volumes\")","v":"3. Quarterly volumes"},"Contract volume by quarter, GWh and %"]
[null,null,{"$f":"HYPERLINK(\"#Contracts_Tab_4\", \"4. Quarterly prices regional\")","v":"4. Quarterly prices regional"},"Contract price ASX vs OTC, by quarter and region, $/Mwh"]
[null,null,{"$f":"HYPERLINK(\"#Contracts_Tab_5\", \"5. Monthly volumes\")","v":"5. Monthly volumes"},"Contract volumes ASX vs OTC by month, and by retailer size, GWh"]
[null,null,{"$f":"HYPERLINK(\"#Contracts_Tab_6\", \"6. Monthly volumes regional\")","v":"6. Monthly volumes regional"},"Contract volumes ASX vs OTC by month, by region, GWh"]
[null,null,{"$f":"HYPERLINK(\"#Contracts_Tab_7\", \"7. Hedged position\")","v":"7. Hedged position"},"Small retailer contract hedging target and outcomes, %"]
[]
[null,null,"Based on cost stack data"]
[null,null,"Sheet name","Description"]
[null,null,{"$f":"HYPERLINK(\"#Cost_Stack_Tab_1\", \"8. NEM $customer\")","v":"8. NEM $customer"},"NEM-wide Cost Stacks, $/customer"]
[null,null,{"$f":"HYPERLINK(\"#Cost_Stack_Tab_2\", \"9. NEM ckWh\")","v":"9. NEM ckWh"},"NEM-wide Cost Stacks, c/kWh"]
[null,null,{"$f":"HYPERLINK(\"#Cost_Stack_Tab_3\", \"10. Regional ckWh\")","v":"10. Regional ckWh"},"Regional Cost Stacks, c/kWh"]
[null,null,{"$f":"HYPERLINK(\"#Cost_Stack_Tab_4\", \"11. Network\")","v":"11. Network"},"Network costs category breakdown"]
[null,null,{"$f":"HYPERLINK(\"#Cost_Stack_Tab_5\", \"12. Wholesale\")","v":"12. Wholesale"},"Wholesale electricity costs"]
[null,null,{"$f":"HYPERLINK(\"#Cost_Stack_Tab_6\", \"13. Environmental\")","v":"13. Environmental"},"Environmental cost category breakdown"]
[null,null,{"$f":"HYPERLINK(\"#Cost_Stack_Tab_7\", \"14. Cost stack retail\")","v":"14. Cost stack retail"},"Retail costs and retail margins"]
[]
[null,null,"Based on retail data, including market offer data from government comparator websites"]
[null,null,"Sheet name","Description"]
[null,null,{"$f":"HYPERLINK(\"#Retail_Tab_1\", \"15. Retail market share\")","v":"15. Retail market share"},"Retail market share"]
[null,null,{"$f":"HYPERLINK(\"#Retail_Tab_2\", \"16. Retail offers, Resi\")","v":"16. Retail offers, Resi"},"Retail market offers, Residential"]
[null,null,{"$f":"HYPERLINK(\"#Retail_Tab_3\", \"17. Retail offers, SME\")","v":"17. Retail offers, SME"},"Retail market offers, Small Business"]
[]
[null,null,"Direct links to data tables for figures featured in the report"]
[null,null,"Please note we have not provided data tables for public-source figures where other market bodies (AEMO, AER) provide accessible data."]
[null,null,"In these cases, please refer directly to the originating institution."]
[]
[null,null,"Chapter 2 - Wholesale electricity spot market"]
[null,null,"Data Item","Description"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_2.8\", \"Figure 2.8\")","v":"Figure 2.8"},"Coal-fired power plant ownership in the NEM"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_2.11\", \"Figure 2.11\")","v":"Figure 2.11"},"Entry into and exits from the NEM by fuel type, 2014–2050"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_2.12\", \"Figure 2.12\")","v":"Figure 2.12"},"Entry into and exits from the NEM by generator type, 2014–2050"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_2.13\", \"Figure 2.13\")","v":"Figure 2.13"},"Electricity consumption in the NEM forecast"]
[]
[null,null,"Chapter 3 - Electricity Hedge Contract Markets"]
[null,null,"Report figure","Description"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_3.3\", \"Figure 3.3\")","v":"Figure 3.3"},"Average strike price and volume traded for external purchases of base swap products for Q1 to Q4 2023"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_3.4\", \"Figure 3.4\")","v":"Figure 3.4"},"Percentage of purchased volumes of Over-The-Counter (OTC) and ASX products for large and small retailers, by trade period, Q1 2021 to Q3 2022"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_3.5\", \"Figure 3.5\")","v":"Figure 3.5"},"Volume of ASX and OTC base swap contracts bought and sold in 2021 and 2022 for Q1 to Q4 2023 delivery periods, by NEM region "]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_3.6\", \"Figure 3.6\")","v":"Figure 3.6"},"Volume of contracts traded on the ASX and OTC market for large generators and gentailers (left) and small retailers (right)"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_3.7\", \"Figure 3.7\")","v":"Figure 3.7"},"Percentage volume of external contracts bought by 11 large generators and gentailers by contract type  "]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_3.8\", \"Figure 3.8\")","v":"Figure 3.8"},"Percentage volume of external contracts sold by 11 large generators and gentailers by contract type  "]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_3.9\", \"Figure 3.9\")","v":"Figure 3.9"},"Percentage volume of contracts purchased by 9 small retailers, by contract type"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_3.10\", \"Figure 3.10\")","v":"Figure 3.10"},"Average and standard deviation of hedged position of small retailers, and target hedge ratio, Q3 2022 to Q2 2024"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_3.11\", \"Figure 3.11\")","v":"Figure 3.11"},"Percentage volume of ASX and OTC contracts purchased by small retailers. Monthly comparison of 2021 and 2022, April to August"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_3.12\", \"Figure 3.12\")","v":"Figure 3.12"},"ASX and over-the-counter volumes sold between January 2021 and August 2022"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_3.13\", \"Figure 3.13\")","v":"Figure 3.13"},"Volume of ASX, and volume and strike price of over-the-counter cap contracts, sold in 2021 and 2022"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_3.14\", \"Figure 3.14\")","v":"Figure 3.14"},"Large generator and gentailers, and small retailers OTC contract volumes bought and sold in 2021 and 2022"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_3.15\", \"Figure 3.15\")","v":"Figure 3.15"},"Volume of ASX and OTC contracts purchased by small retailers in 2021 and 2022"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_3.16\", \"Figure 3.16\")","v":"Figure 3.16"},"Proportion of exchange for physical contracts traded by volume between Q1-2021 and Q2-2022"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_3.17\", \"Figure 3.17\")","v":"Figure 3.17"},"Volume weighted average of absolute price difference between OTC and ASX quarterly base swap contracts bought and sold in 2021 and 2022, by delivery period and region"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_3.18\", \"Figure 3.18\")","v":"Figure 3.18"},"Volume weighted average price difference between OTC and ASX quarterly base swap contracts bought and sold for 2023 and 2024 delivery periods, by trade date and NEM region "]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_3.19\", \"Figure 3.19\")","v":"Figure 3.19"},"ASX and OTC base swap contract purchase price trends for large generators and gentailers, and small retailers in 2021 and 2022"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_3.20\", \"Figure 3.20\")","v":"Figure 3.20"},"ASX and OTC base swap contract volumes purchased and strike price by trade date (Q1 2021 to Q3 2022). Large generators and gentailers (top), small retailers (bottom)"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_3.21\", \"Figure 3.21\")","v":"Figure 3.21"},"Large generator and gentailer, and small retailer volumes of 2024 quarterly base swap contracts purchased in 2021 and 2022, by delivery period "]
[]
[null,null,"Chapter 4 Competitive retail markets have delivered consumer benefits over the last decade"]
[null,null,"Report figure","Description"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_4.1\", \"Figure 4.1\")","v":"Figure 4.1"},"Retail electricity market share by region, 2021–22"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_4.2\", \"Figure 4.2\")","v":"Figure 4.2"},"National Electricity Market-wide small customer market share at 2014–15, 2018–19 and 2021–22"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_4.3\", \"Figure 4.3\")","v":"Figure 4.3"},"Herfindahl-Hirschman Index by region, December 2009 – June 2021"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_4.4\", \"Figure 4.4\")","v":"Figure 4.4"},"Active electricity retailers in the National Electricity Market by customer type, June 2018 – June 2022"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_4.5\", \"Figure 4.5\")","v":"Figure 4.5"},"Average retail margins (as EBITDA) per residential customer across the National Electricity Market, 2007–08 to 2021–22, real $2021–22, excluding GST"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_4.6\", \"Figure 4.6\")","v":"Figure 4.6"},"Average retail and other costs over time per residential customer across the National Electricity Market, 2007-08 to 2021-22, real $2021-22, excluding GST"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_4.7\", \"Figure 4.7\")","v":"Figure 4.7"},"Average cost to serve per residential customer across the National Electricity Market by retailer tier and percentage of residential total, 2018-19 to 2021-22, real $2021-22, excluding GST"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_4.8\", \"Figure 4.8\")","v":"Figure 4.8"},"Average cost to acquire and retain per residential customer across the National Electricity Market by retailer tier and percentage of residential total, 2018-19 to 2021-22, real $2021–22, excluding GST"]
[]
[null,null,"Chapter 5 Recent electricity market conditions and settings have put pressure on retailers"]
[null,null,"Report figure","Description"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_5.1\", \"Figure 5.1\")","v":"Figure 5.1"},"Number of single rate market offers, residential, June 2020 to October 2022"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_5.2\", \"Figure 5.2\")","v":"Figure 5.2"},"Number of retailers with at least one residential, single rate market offer below Default Market Offer and Victorian Default Offer, by distribution zone, as at 10 October 2022"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_5.3\", \"Figure 5.3\")","v":"Figure 5.3"},"Minimum and maximum market offers compared with the Default Market Offer and Victorian Default Offer, residential single rate, June 2020 to October 2022 "]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_5.4\", \"Figure 5.4\")","v":"Figure 5.4"},"Estimated median annual bill, residential single rate market offers ($, real), April 2020 to October 2022"]
[]
[null,null,"Appendix C: Further retail analysis"]
[null,null,"Report figure","Description"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_C1\", \"Figure C1\")","v":"Figure C1"},"Average retail margins (as EBITDA) per small business customer across the National Electricity Market, 2007–08 to 2021–22, real $2021–22, excluding GST"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_C2\", \"Figure C2\")","v":"Figure C2"},"Average retail and other costs over time per small business customer across the National Electricity Market, 2007-08 to 2021-22, real $2021-22, excluding GST"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_C3\", \"Figure C3\")","v":"Figure C3"},"Average Cost to Serve per small business customer across the National Electricity Market by retailer tier and percentage of residential total, 2018-19 to 2021-22, real $2021-22, excluding GST"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_C4\", \"Figure C4\")","v":"Figure C4"},"Average Cost to Acquire and Retain per small business customer across the National Electricity Market by retailer tier and percentage of residential total, 2018-19 to 2021-22, real $2021-22, excluding GST"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_C5\", \"Figure C5\")","v":"Figure C5"},"Change in cost components for the average residential customer across the National Electricity Market from 2020–21 to 2021–22), real $2021–22, excluding GST"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_C6\", \"Figure C6\")","v":"Figure C6"},"Change in cost components for the average small business customer across the National Electricity Market from 2020–21 to 2021–22), real $2021–22, excluding GST"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_C7\", \"Figure C7\")","v":"Figure C7"},"Number of single rate market offers, small business, June 2020 to October 2022"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_C8\", \"Figure C8\")","v":"Figure C8"},"Number of single rate market offers below Default Market Offer and Victorian Default Offer, residential, January to October 2022"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_C9\", \"Figure C9\")","v":"Figure C9"},"Number of single rate market offers below the Default Market Offer and Victorian Default Offer, small business, January to October 2022"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_C10\", \"Figure C10\")","v":"Figure C10"},"Number of retailers with at least one small business, single rate market offer below Default Market Offer and Victorian Default Offer (as at 10 October 2022)"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_C11\", \"Figure C11\")","v":"Figure C11"},"Minimum and maximum market offers compared with Default Market Offer/Victorian Default Offer, small business single rate"]
[null,null,{"$f":"HYPERLINK(\"#Report_Figure_C12\", \"Figure C12\")","v":"Figure C12"},"Estimated median annual bill, small business single rate market offers ($, real), June 2020 to October 2022"]
[]
[null,null,"Please note that figures presented have been rounded and may not sum due to rounding."]

{"sheet":"SPOT>>","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"0. Wholesale market","index":3,"n_rows":148,"n_cols":13,"rows_kept":148,"cut":false,"hidden":false,"merged":[[116,10,118,10],[7,1,7,4],[7,5,7,7],[116,5,118,5],[116,6,118,6],[116,7,118,7],[116,8,118,8],[116,9,118,9],[116,0,118,0],[116,1,118,1],[116,2,118,2],[116,3,118,3],[116,4,118,4]]}
["Wholesale market"]
[{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
["Please note we have not provided data tables for public-source figures where other market bodies (AEMO, AER) provide accessible data."]
["In these cases, please refer directly to the originating institution."]
[]
["Supplementary Table D0.1",null,null,null,null,null,null,null,null,null,null,null,"Figure D0.1 (report figure 2.8): Capacity of coal-fired power plant ownership in the NEM by owner, October 2022 "]
["All regions, coal-fired plant ownership"]
["Owner","Capacity ",null,null,null,"Labels"]
[null,"Black Coal","Brown Coal","Offline or retiring*",null,"Black Coal","Brown Coal ","Closures"]
["AGL Energy",2665,2210,1500,null,"Bayswater","Loy Yang A","Liddell, Jan 2023 retirement"]
["Stanwell",3310,null,null,null,"Stanwell, Tarong, Tarong North "]
["Origin Energy",2880,null,null,null,"Eraring"]
["EnergyAustralia",1390,1450,null,null,"Mt Piper","Yallourn W"]
["CS Energy",1444,null,420,null,"Kogan Ck, Callide B",null,"Callide C (offline)"]
["Gladstone Power Station Participants",1680,null,null,null,"Gladstone"]
["Sunset Power",1320,null,null,null,"Vales Point B"]
["InterGen",852,null,420,null,"Millmerran",null,"Callide C (offline)"]
["Alinta Energy",null,1160,null,null,null,"Loy Yang B"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source: AEMO, NEM Generation Information October 2022, AEMO, 7 November 2022, accessed 8 November 2022"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Note: Liddell’s remaining 3 units are scheduled to retire in January 2023. Callide unit C3 has been offline since November 2022 and is planned to return to service in January 2023. "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Callide unit C4 has been offline since November 2021 and is planned to return to service in April 2023."]
[]
[]
["Supplementary Table D0.2",null,null,null,null,null,null,null,null,null,null,null,"Figure D0.2 (report figure 2.11): Entry into and exits from the NEM by fuel type (in MW), 2014–2050"]
["Entry into and exits from the NEM by fuel type (in MW), 2014–2050"]
[null,null,"Fuel Type"]
["Period",null,"Black coal","Brown coal","Gas","Hydro","Wind","Solar","Battery"]
["Historical",2014,-1000,-240,0,0,363,0,0]
[null,2015,0,0,312,0,106,155,0]
[null,2016,-186,-530,0,0,343,57,0]
[null,2017,0,-1640,0,0,420,60,150]
[null,2018,0,0,0,0,1247,1931,90]
[null,2019,0,0,211,0,953,1291,25]
[null,2020,0,0,-240,0,1727,2019,0]
[null,2021,0,0,-150,0,1083,1593,564]
["Projected",2022,50,0,-16,0,419,887,0]
[null,2023,-1500,0,480,0,330,748,100]
[null,2024,0,0,316,250,1422,640,0]
[null,2025,-2880,0,0,0,3863,367.23999999999978,1600]
[null,2026,-700,-685,0,0,3254.7099999999973,-1.8189894035458565E-12,1530]
[null,2027,-700,-750,0,0,2042.8399999999965,471.68000000000029,1360,null,null,null,"Source: Historic data based on the AER’s State of the Energy Market report 2022, and projections based on AEMO’s 2022 Integrated System Plan, Step Change scenario; "]
[null,2028,-2020,0,0,0,4413.2000000000116,189.20000000000255,926.09999999999945,null,null,null,"              AER, State of the energy market 2022 data, Commonwealth of Australia, 29 September 2022, accessed 8 November 2022; AEMO, 2022 Integrated System Plan (ISP), AEMO, 30 June 2022, 8 November 2022."]
[null,2029,-1879,-560,0,0,3460.1399999999994,2067.8299999999981,485.0600000000004]
[null,2030,-965,-1105,0,390.00000000000091,3188.5499999999993,672.09000000000196,75.109999999999673]
[null,2031,-1400,-560,-1090.5,0,2891.6899999999987,1367.8699999999972,1528.3500000000004]
[null,2032,0,0,0,0,2115.9799999999959,938.22000000000116,0]
[null,2033,-730,-1160,-239.65999999999985,0,1580.9300000000003,2682.7300000000032,251.10000000000036]
[null,2034,-2100,0,-462,0,3957.4400000000096,560.7899999999936,246.21999999999935]
[null,2035,0,0,-117,0,627.1299999999901,951.05000000000655,120.45000000000073]
[null,2036,0,0,-880,0,234.8999999999869,4.0800000000017462,-1.1000000000003638]
[null,2037,0,0,-229.21000000000095,0,2444.4199999999983,2841.7999999999956,1323.880000000001]
[null,2038,0,0,-529,-86.399999999999636,2415.0400000000081,2205.1700000000019,444.77000000000044]
[null,2039,0,0,0,0,195.3799999999901,4386.1100000000006,963.86999999999898]
[null,2040,-2230,0,275.20999999999913,0,726.85999999999331,4149.3700000000063,2075.5699999999997]
[null,2041,-426,0,-120,0,755.55000000000291,2393.1399999999994,173.13000000000102]
[null,2042,0,0,0,0,1853.2699999999968,4100.4499999999971,560.8799999999992]
[null,2043,-426,0,94.130000000001019,-66,7133.5500000000029,6131.3500000000131,0]
[null,2044,0,0,1958.9300000000003,0,2044.7100000000064,3939.5299999999843,582.01999999999862]
[null,2045,0,0,-1158.7499999999982,0,-677.37000000000262,-351.18999999999505,2.1000000000021828]
[null,2046,0,0,647.24999999999818,0,1598.0299999999988,2909.0200000000114,-602.10000000000218]
[null,2047,0,0,-946.99999999999818,0,2528.8600000000006,1974.419999999991,0]
[null,2048,0,0,-584,0,1278.4400000000023,973.98999999999069,-924.99999999999818]
[null,2049,0,0,0,0,4395.6600000000108,7639.3100000000195,558.47999999999956]
[null,2050,0,0,690.86999999999716,0,849.03000000001339,8248.7599999999875,2541.659999999998]
[]
[]
[]
["Supplementary Table D0.3",null,null,null,null,null,null,null,null,null,null,null,"Figure D0.3 (report figure 2.12): Entry into and exits from the NEM by generator type (in MW), 2014–2050"]
["Entry into and exits from the NEM by generator type (in MW), 2014–2050"]
[null,null,"Technology"]
["Period",null,"Baseload","Flexible","Variable"]
["Historical",2014,-1240,0,363]
[null,2015,0,312,261]
[null,2016,-716,0,400]
[null,2017,-1640,150,480]
[null,2018,0,90,3178]
[null,2019,0,236,2244]
[null,2020,0,-240,3746]
[null,2021,0,414,2676]
["Projected",2022,0,0,1306]
[null,2023,-1500,580,1078]
[null,2024,0,566,2062]
[null,2025,-2880,1600,4230.24]
[null,2026,-1385,1530,3254.7099999999955]
[null,2027,-1450,1360,2514.5199999999968,null,null,null,null,null,null,null,"Source: Historic data based on the AER’s State of the Energy Market report 2022, and projections based on AEMO’s 2022 Integrated System Plan, Step Change scenario;"]
[null,2028,-2020,926.09999999999945,4602.4000000000142,null,null,null,null,null,null,null,"              AER, State of the energy market 2022 data, Commonwealth of Australia, 29 September 2022, accessed 8 November 2022; AEMO, 2022 Integrated System Plan (ISP), AEMO, 30 June 2022, 8 November 2022."]
[null,2029,-2439,485.0600000000004,5527.9699999999975,null,null,null,null,null,null,null,"Note: Figure above represents a simplified categorisation of technologies, with black and brown coal classed as ‘baseload’, all gas, hydro and battery classified as ‘flexible’ and variable renewables as ‘variable’. "]
[null,2030,-2070,465.11000000000058,3860.6400000000012,null,null,null,null,null,null,null,"We note this is a simplification and that many of these technologies can operate in different ways. "]
[null,2031,-1960,437.85000000000036,4259.5599999999959]
[null,2032,0,0,3054.1999999999971]
[null,2033,-1890,11.440000000000509,4263.6600000000035]
[null,2034,-2100,-215.78000000000065,4518.2300000000032]
[null,2035,0,3.4500000000007276,1578.1799999999967]
[null,2036,0,-881.10000000000036,238.97999999998865]
[null,2037,0,1094.67,5286.2199999999939]
[null,2038,0,-170.6299999999992,4620.21000000001]
[null,2039,0,963.86999999999898,4581.4899999999907]
[null,2040,-2230,2350.7799999999988,4876.2299999999996]
[null,2041,-426,53.130000000001019,3148.6900000000023]
[null,2042,0,560.8799999999992,5953.7199999999939]
[null,2043,-426,28.130000000001019,13264.900000000016]
[null,2044,0,2540.9499999999989,5984.2399999999907]
[null,2045,0,-1156.649999999996,-1028.5599999999977]
[null,2046,0,45.149999999995998,4507.0500000000102]
[null,2047,0,-946.99999999999818,4503.2799999999916]
[null,2048,0,-1508.9999999999982,2252.429999999993]
[null,2049,0,558.47999999999956,12034.97000000003]
[null,2050,0,3232.5299999999952,9097.7900000000009]
[]
[]
["Supplementary Table D0.4",null,null,null,null,null,null,null,null,null,null,null,"Figure D0.4 (report figure 2.13): Forecast electricity consumption in the NEM forecast (GWh)"]
["Forecast electricity consumption in the NEM forecast (GWh)"]
["Year","Business","Electric Vehicles","Electrification","Energy Efficiency","Hydrogen Production","Losses","Residential","RooftopPV","Small Non-Scheduled Generation","Operational"]
[]
[]
[2023,123809.40299999999,173.70849999999999,4605.4758299999994,2177.2223999999997,0,9607.9510000000009,42049.682000000001,20338.264999999999,6267.1620000000003,180246.2]
[2024,122869.67099999999,277.09120000000001,9431.5617999999995,4299.1210000000001,0,9792.2260000000006,40355.962,23105.642,6854.5460000000003,182726.5]
[2025,121901.49500000001,594.0181,14261.934799999999,7497.9209999999994,0,9985.887999999999,38428.813000000002,25649.307000000001,7293.5460000000003,185172.2]
[2026,120990.20600000001,1219.5260000000001,21270.494999999999,10878.476000000001,0,10340.129000000001,36016.331000000006,28123.168000000001,8160.2190000000001,189836.7]
[2027,120276.00199999999,2163.3829999999998,26468.771000000001,13666.897000000001,0,10617.429,33732.715000000004,30513.455000000002,9091.851999999999,193258.3]
[2028,119788.30699999999,3469.1280000000002,28629.512999999999,16136.295999999998,0,10750.574000000001,31829.547000000002,32824.686999999998,10072.683000000001,194467.1]
[2029,119122.49099999999,5135.3710000000001,29607.905999999999,18639.109,0,10839.304,30199.535,34846.033000000003,10987.721,194904.6]
[2030,118453.277,6842.723,31222.234,21247.832999999999,92.945869999999999,10975.23,28496.693000000003,36715.072,11963.359,196083.1]
[2031,117189.622,9091.3009999999995,34273.902999999998,23580.777999999998,203.81379999999999,11239.811000000002,27018.126,38652.21,12940.605,199016.6]
[2032,116061.927,11993.93,38163.205999999998,25908.05,513.42690000000005,11624.839,25715.652999999998,40540.300000000003,13901.635999999999,204073]
[2033,114959.815,14847.79,39979.574999999997,28155.31,957.5018,11881.733,24572.055999999997,42260.14,14836.763999999999,207198.5]
[2034,113657.038,17776.29,41901.473999999995,30276.85,1833.8510000000001,12144.576000000001,23465.52,43986.654999999999,15825.317999999999,210778.8]
[2035,112224.23000000001,20756.439999999999,43834.175000000003,32296.68,2729.2240000000002,12400.656999999999,22400.914000000001,45742.386999999995,16807.71,214345.60000000001]
[2036,110794.04300000001,24034.82,45910.530999999995,34249.65,3615.4749999999999,12678.947,21416.467000000001,47496.387999999999,17562.849000000002,218450.3]
[2037,110011.268,27208.91,47792.241999999998,36085.919999999998,4513.8010000000004,13000.904999999999,20786.616000000002,48972.253000000004,18489.34,223313.7]
[2038,109391.12299999999,30532.400000000001,49703.962999999996,38005.880000000005,5434.2659999999996,13332.662,20259.350000000002,50315.297999999995,19033.912,228653.8]
[2039,108530.41899999999,33910.71,51364.747000000003,40147.869999999995,6448.23,13656.82,19669.333999999999,51672.1,20050.553,233580.3]
[2040,107273.099,37405.339999999997,52861.895000000004,41943.380000000005,13567.81,13961.030999999999,19157.331999999999,53121.5,21144.974000000002,244226.5]
[2041,105881.00600000001,40889.81,53920.180999999997,43603.83,16472.41,14228.7,18765.753000000001,54404.869999999995,22125.876,250157.9,null,"Source: AEMO, 2022 Electricity Statement of Opportunities, 2022, accessed 8 November 2022."]
[2042,104559.355,44564.09,55497.788,45283.149999999994,16923.580000000002,14558.030999999999,18410.553,55642.62,23166.587,254513.4]
[2043,103595.08499999999,48251.34,56903.75,46804.66,34257.910000000003,14907.23,18173.595000000001,56913.39,24203.137999999999,276088.90000000002]
[2044,102395.334,52182.65,58394.479999999996,48433.34,38075.89,15261.573,17892.28,58280.82,25311.852999999999,284202.2]
[2045,101435.443,55857.65,59588.98,50013.24,35405.269999999997,15597.851000000001,17807.877999999997,59464.03,26252.063999999998,285693.09999999998]
[2046,100415.91899999999,59758.51,61050.92,51777.19,37057.730000000003,15957.511999999999,17574.960000000003,60587.28,27271.664999999997,291815.59999999998]
[2047,99842.414000000004,63892.58,62515.259999999995,52882.42,42584.62,16373.821,17502.11,61753.240000000005,28284.646000000001,302710.8]
[2048,99347.785000000003,68293.990000000005,64131.73,53795.09,45039.38,16824.75,17381.703999999998,63028.81,29378.917000000001,311019.3]
[2049,99240.571000000011,72305.73,65475.850000000006,54544.27,58893.08,17259.212,17466.831999999999,64122.5,30293.968999999997,330641.3]
[2050,99384.813999999998,76599.509999999995,66972.290000000008,54686.11,57666.32,17768.616000000002,17899.88,65177.599999999999,31288.449999999997,336291.4]
[2051,101314.34,79016.53,69104.069999999992,53805.979999999996,67079.649999999994,18279.785,18365.109000000004,66261.87,32276.210999999999,353159.5]

{"sheet":"CONTRACTS>>","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"1. Strike prices","index":5,"n_rows":96,"n_cols":7,"rows_kept":96,"cut":false,"hidden":false,"merged":[[30,1,30,2],[30,3,30,4],[56,1,56,2],[56,3,56,4],[78,1,78,2],[78,3,78,4]]}
["Strike prices"]
[{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
[" "]
["Supplementary Table D1.1a",null,null,null,null,null,"Figure D1.1 (report figure 3.3): Average strike price and volume traded for external purchases of base swap products for Q1 to Q4 2023"]
["All regions, OTC and ASX markets"]
["Average Strike Price ($/MWh)"]
["Period","2023-Q1","2023-Q2","2023-Q3","2023-Q4"]
["Q1 2021",54.33,40.36,41.4,42.94]
["Q2 2021",55.9,42.07,43.11,42.64]
["Q3 2021",65.36,48.8,48.95,46.88]
["Q4 2021",75.88,59.96,59.15,58.28]
["Q1 2022",96.06,79.72,75.900000000000006,72.66]
["Q2 2022",125.58,118.21,124.31,112.18]
["Q3 2022",179.7,184.84,173.34,135.47999999999999]
[]
["Supplementary Table D1.1b"]
["All regions, OTC and ASX markets"]
["Sum of Volume (GWh)"]
["Period","2023-Q1","2023-Q2","2023-Q3","2023-Q4"]
["Q1 2021",1490.71,1077.1500000000001,1100.9000000000001,899.54]
["Q2 2021",2414.11,2087.56,1580.56,1717.03]
["Q3 2021",2901.21,2597.86,2369.38,2179.92,null,"Source: ACCC analysis of hedging contracts data."]
["Q4 2021",2321.4699999999998,2367.85,2409.4299999999998,2146.12,null,"Note: External trades only. Quarter 3 volumes low due to incomplete data for that quarter."]
["Q1 2022",2798.44,3170.81,1919.2,2049.2600000000002]
["Q2 2022",6682.87,5765.49,4556.3599999999997,3556.63]
["Q3 2022",1424.72,1529.83,1497.24,1249.67]
[]
[]
["Supplementary Table D1.2",null,null,null,null,null,"Figure D1.2 (report figure 3.19): ASX and OTC base swap contract purchase price trends for larger generators and gentailers, and smaller retailers in 2021 and 2022 ($M/Wh)"]
["All regions, smaller retailer, and larger generator and gentailer, purchases and sales"]
[null,"ASX",null,"OTC"]
["Period","Larger generator and gentailer","Smaller retailer","Larger generator and gentailer","Smaller retailer"]
["2021-01-01",47.923074224448726,53.170865163368639,29.268018312732593,49.189869281045745]
["2021-02-01",41.446223113990435,40.636922169811314,19.753558176074719,48.243237814675943]
["2021-03-01",41.730730662396248,41.609768385864363,44.761286186574416,44.409871441689617]
["2021-04-01",45.095904279687147,45.189263010827823,46.96263527848204,44.883714618069021]
["2021-05-01",51.172861405845225,45.28229888582235,45.492167778721594,55.01666907410084]
["2021-06-01",52.972738548920418,53.869096798305755,41.887482599617833,59.189924670433136]
["2021-07-01",54.817603663513935,60.148280965225631,76.852011237982623,57.402325236417596]
["2021-08-01",57.592069132038773,58.451042789223472,60.024356875423102,64.083333333333343]
["2021-09-01",55.844440922990401,51.405849636080625,35.116168474870726,47.530514419329698]
["2021-10-01",58.477246773702419,54.609877953196765,54.514332953329031,67.3]
["2021-11-01",55.548907348392788,60.837742848845657,61.620660452612626,86.303009575923397]
["2021-12-01",69.116296359555491,60.691022727272731,50.930191934038525,117.74999999999999]
["2022-01-01",74.84416488802762,76.615024513947631,143.78363425490562,61.104972375690615,null,"Source: ACCC analysis of hedging contracts data."]
["2022-02-01",71.289628166456737,64.30004796163071,28.952225031849601,51.9,null,"Note: Excludes external trades."]
["2022-03-01",83.177963292394409,77.94654399640234,81.878176459497396,89.576026048765584]
["2022-04-01",95.076515790111642,109.96679694947571,90.432276146857859,110.54325123152711]
["2022-05-01",83.15828166856933,87.388436722920304,118.27494981984668,111.02776905536903]
["2022-06-01",159.2163389059437,138.15357765363132,127.78396389087963,106.85129754897658]
["2022-07-01",165.0225621920664,172.08188640510954,194.86439263977968,202.88108825597749]
["2022-08-01",128.81435583835227,122.89041485853159,114.41017283316721,173.80250605326876]
[]
[" "]
["Supplementary Table D1.3",null,null,null,null,null,"Figure D1.3 (report figure 3.20a): Larger generators and gentailers, ASX and OTC base swap contract volumes purchased and strike price by trade date (Q1 2021 to Q3 2022)"]
["Larger generator and gentailer purchases, all regions"]
[null,"Volume (GWh)",null,"Strike Price ($/MWh)"]
["Quarter","OTC","ASX","OTC","ASX"]
["Q1 2021",1061.3,9350,48.366379465347997,44.374505387936367]
["Q2 2021",2925.1,16799,50.970160793655587,49.582157961090253]
["Q3 2021",1107.5006800000001,12608,71.680714562840805,56.516611684331799]
["Q4 2021",2609.3669929999996,10884,62.907098720222493,59.925838374453427]
["Q1 2022",3468.1,9865,77.859329006462374,82.61416241190345]
["Q2 2022",5672,12257,141.75194670609434,103.83101944313198]
["Q3 2022",436.49,5114,162.1393775860584,149.24835014244829]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,null,null,null,null,null,"Note: Excludes external trades. OTC = over-the-counter."]
[]
[]
["Supplementary Table D1.4",null,null,null,null,null,"Figure D1.4 (report figure 3.20b): Smaller retailers, ASX and OTC base swap contract volumes purchased and strike price by trade date (Q1 2021 to Q3 2022). (bottom)"]
["Smaller retailer purchases, all regions"]
[null,"Volume (GWh)",null,"Strike Price ($/MWh)"]
["Quarter","OTC","ASX","OTC","ASX"]
["Q1 2021",78,83,47.961976678842383,42.083630826271218]
["Q2 2021",135,218,53.77846096898908,47.803415111378605]
["Q3 2021",72,198,56.231833232077804,54.765947871224256]
["Q4 2021",48,218,89.402628571428565,56.934536408864773]
["Q1 2022",240,207,86.286190519682194,71.280705246995325]
["Q2 2022",777,193,108.57161494411142,84.172626142232843]
["Q3 2022",80,54,196.33642643051778,97.673939209726498]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,null,null,null,null,null,"Note: Excludes external trades. OTC = over-the-counter."]

{"sheet":"2. Contract types","index":6,"n_rows":90,"n_cols":9,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
["Type of external contracts bought/sold"]
[{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
["Retailers are anonymised; retailer order is randomised on each graph"]
[]
["Supplementary Table D2.1",null,null,null,null,null,null,null,"Figure D2.1 (report figure 3.7): Percentage volume of external contracts bought by 11 larger generators and gentailers by contract type"]
["All regions, OTC and ASX markets"]
[null,"Base swap","Cap","Load following swap","Other","Swaption","Weather"]
["Retailer 1",0.3687914343208748,0.29269582561568469,0,2.0864533324241364E-2,0.19506621519460249,0.12258199154459661]
["Retailer 2",0.60379934787312606,1.9750780265547059E-2,0,0,0.37644987186132683,0]
["Retailer 3",0.32745661731528325,0.22302363187540369,0.12132705737317322,0.32002030336531578,8.1723900708240618E-3,0]
["Retailer 4",0.38647783256973289,5.6184836452140549E-2,0,9.300649615688829E-5,0.55722575371003458,0]
["Retailer 5",0.47624742060522185,8.37731524241251E-2,4.5116012888874023E-3,0,0.43546782568176573,0]
["Retailer 6",0.92234395588856943,3.901085098002418E-2,0,3.8645193131406345E-2,0,0]
["Retailer 7",0.25680972456646267,8.0170908002814845E-2,4.140536496552073E-5,0,0.66297796206575699,0]
["Retailer 8",0.47381158939420381,0.46497423328665272,6.121417731914356E-2,0,0,0]
["Retailer 9",0.73862978523384526,5.7944423385456509E-2,0,0,0.16684136899992177,3.6584422380776381E-2]
["Retailer 10",0.37765827336049734,0.38012211099621362,0,0,0.24221961564328909,0]
["Retailer 11",0.5517235317494118,2.4888549504412563E-2,0,0,0.42338791874617554,0]
["Note: Data arranged in randomised order"]
[]
[null,null,null,null,null,null,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,null,null,null,null,null,null,null,"Note: Data arranged in randomised order"]
[]
[]
["Supplementary Table D2.2",null,null,null,null,null,null,null,"Figure D2.2 (report figure 3.8): Percentage volume of external contracts sold by 11 larger generators and gentailers by contract type"]
["All regions, OTC and ASX markets"]
[null,"Base swap","Cap","Floor","Load following swap","Swaption"]
["Retailer 1",0.50427544818484715,0.23863936341438061,1.5594262180705892E-3,0,0.25552576218270157]
["Retailer 2",0.89086794090747046,0.10913205909252964,0,0,0]
["Retailer 3",0.40943944253106551,2.5069598663349808E-2,0,0,0.56427725327084832]
["Retailer 4",0.1108159109706169,0.82938689419071632,0,4.5349970557461282E-2,1.4447224281205541E-2]
["Retailer 5",0.50869450840022468,0.12238317515659056,0,0,0.36892231644318479]
["Retailer 6",0.25305573799694681,8.3492332872685468E-2,0,1.8918647084101194E-5,0.66343301048328363]
["Retailer 7",0.59139185028554686,7.932734331247927E-3,0,0,0.40067541538320522]
["Retailer 8",0.51911151941846145,0.48088848058153866,0,0,0]
["Retailer 9",0.36348950178392714,1.974952835031699E-2,0,0,0.6167609698657559]
["Retailer 10",0.81713895814164761,2.7841889744832468E-2,0,0,0.15501915211351996]
["Retailer 11",0.55104722033990983,8.7800069176954404E-2,0,0,0.36115271048313574]
["Note: Data arranged in randomised order"]
[]
[]
[null,null,null,null,null,null,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,null,null,null,null,null,null,null,"Note: Data arranged in randomised order"]
[]
[]
["Supplementary Table D2.3",null,null,null,null,null,null,null,"Figure D2.3 (report figure 3.9): Percentage volume of external contracts purchased by 9 smaller retailers by contract type"]
["All regions, OTC and ASX markets"]
[null,"Base swap","Cap","Load following swap","Peak swap","Swaption"]
["Retailer 1",0.63987517337031929,0.36012482662968071,0,0,0]
["Retailer 2",0.11073781414816344,3.4535182717393351E-2,0.85472700313444328,0,0]
["Retailer 3",0,0,1,0,0]
["Retailer 4",0.7628239275132922,1.958277527497056E-2,0.2048974694589876,0,1.2695827752749694E-2]
["Retailer 5",0.87566702007000774,0.12123134836018544,0,3.1016315698067739E-3,0]
["Retailer 6",0,0,1,0,0]
["Retailer 7",0,0,1,0,0]
["Retailer 8",0.70903616013404724,0.13274926621008645,0,0,0.15715871954736013]
["Retailer 9",0.53746949673333022,0.38314482950334844,0,7.9385673763321354E-2,0]
["Note: Data arranged in randomised order"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,null,null,null,null,null,null,null,"Note: Data arranged in randomised order"]
[]
[]
["Supplementary Table D2.4",null,null,null,null,null,null,null,"Figure D2.4 (report figure 3.16) Proportion of exchange for physical contracts traded in 2021 and 2022"]
["All regions, smaller retailer and, larger generator and gentailer, purchases and sales"]
["Quarter","EFP transactions"]
["Q1 2021",3.1659427389329427E-2]
["Q2 2021",1.318868604706395E-2]
["Q3 2021",2.1236922720036199E-2]
["Q4 2021",3.4169186903304512E-2]
["Q1 2022",0.13639253553495492]
["Q2 2022",0.16230864747769139]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,null,null,null,null,null,null,null,"Note: Not all participants included in our sample indicated whether a trade was an EFP transaction. "]
[null,null,null,null,null,null,null,null,"Nonetheless, we believe the increase in EFP transactions in 2022 observed in the data is representative of the general trend. "]
[null,null,null,null,null,null,null,null,"External trades only. EFP = Exchange for physical."]

{"sheet":"3. Quarterly volumes","index":7,"n_rows":121,"n_cols":6,"rows_kept":121,"cut":false,"hidden":false,"merged":[]}
["Quarterly volumes"]
[{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
[]
["Supplementary Table D3.1",null,null,null,null,"Figure D3.1 (report figure 3.4): Percentage of purchased volumes of Over-The-Counter (OTC) and ASX products for larger generator and gentailer, and smaller retailers, Q1 2021 to Q3 2022"]
["All regions and all contract types except for load following swaps"]
["Quarter","Size","ASX","OTC"]
["Q1 2021","Larger generator and gentailer",0.89,0.11]
["Q2 2021","Larger generator and gentailer",0.83,0.17]
["Q3 2021","Larger generator and gentailer",0.88,0.12]
["Q4 2021","Larger generator and gentailer",0.71,0.28999999999999998]
["Q1 2022","Larger generator and gentailer",0.78,0.22]
["Q2 2022","Larger generator and gentailer",0.73,0.27]
["Q3 2022","Larger generator and gentailer",0.88,0.12]
["Q1 2021","Smaller retailer",0.41,0.59]
["Q2 2021","Smaller retailer",0.44,0.56000000000000005]
["Q3 2021","Smaller retailer",0.77,0.23]
["Q4 2021","Smaller retailer",0.75,0.25]
["Q1 2022","Smaller retailer",0.49,0.51]
["Q2 2022","Smaller retailer",0.16,0.84]
["Q3 2022","Smaller retailer",0.31,0.69]
[]
[]
[]
[null,null,null,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,null,null,null,null,"Note: External trades only and excluding load following swap contracts. OTC = over-the-counter."]
[]
[]
["Supplementary Table D3.2",null,null,null,null,"Figure D3.2 (report figure 3.21a): Larger generator and gentailer, and smaller retailer volumes of 2024 quarterly base swap contracts purchased in 2021 and 2022, for delivery Q1 2024 (GWh)"]
["Delivery quarter Q1 2024"]
["Quarter","Larger generator and gentailer","Smaller retailer"]
["Q1 2021",1098.9360000000001,4.3680000000000003]
["Q2 2021",707.68800000000033,15.288]
["Q3 2021",1458.2970000000009]
["Q4 2021",1197.0000000000002,17.472000000000001]
["Q1 2022",2119.6800000000062,54.6]
["Q2 2022",2767.4807999999998,179.08799999999999]
["Q3 2022",1100.1126000000002,13.104000000000003]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,null,null,null,null,"Note: Excludes external trades."]
[]
[]
["Supplementary Table D3.3",null,null,null,null,"Figure D3.3 (report figure 3.21b): Larger generator and gentailer, and smaller retailer volumes of 2024 quarterly base swap contracts purchased in 2021 and 2022, for delivery Q2 2024 (GWh)"]
["Delivery quarter Q2 2024"]
["Quarter","Larger generator and gentailer","Smaller retailer"]
["Q1 2021",805.39200000000005]
["Q2 2021",622.80000000000007,15.288]
["Q3 2021",1274.3453999999995]
["Q4 2021",1030.0080000000014,17.472000000000001]
["Q1 2022",2145.2160000000044,48.048000000000002]
["Q2 2022",2023.7124000000008,157.24799999999999]
["Q3 2022",1074.4560000000006,10.920000000000002]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,null,null,null,null,"Note: Excludes external trades."]
[]
[]
["Supplementary Table D3.4",null,null,null,null,"Figure D3.4 (report figure 3.21c): Larger generator and gentailer, and smaller retailer volumes of 2024 quarterly base swap contracts purchased in 2021 and 2022, for delivery Q3 2024 (GWh)"]
["Delivery quarter Q3 2024"]
["Quarter","Larger generator and gentailer","Smaller retailer"]
["Q1 2021",427.17600000000016]
["Q2 2021",100.55999999999997,15.456]
["Q3 2021",245.25599999999991]
["Q4 2021",465.69600000000014,8.8320000000000007]
["Q1 2022",1402.4424000000008,4.4160000000000004]
["Q2 2022",1597.0080000000003,119.23199999999999]
["Q3 2022",683.45280000000059,13.247999999999999]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,null,null,null,null,"Note: Excludes external trades."]
[]
[]
["Supplementary Table D3.5",null,null,null,null,"Figure D3.5 (report figure 3.21d): Larger generator and gentailer, and smaller retailer volumes of 2024 quarterly base swap contracts purchased in 2021 and 2022, for delivery Q4 2024 (GWh)"]
["Delivery quarter Q4 2024"]
["Quarter","Larger generator and gentailer","Smaller retailer"]
["Q1 2021",150.21599999999998]
["Q2 2021",125.85600000000001,15.456]
["Q3 2021",209.75999999999993]
["Q4 2021",369.024,8.8320000000000007]
["Q1 2022",1407.8880000000008,22.08]
["Q2 2022",1341.6240000000005,105.98399999999999]
["Q3 2022",524.02080000000035,4.4160000000000004]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,null,null,null,null,"Note: Excludes external trades."]

{"sheet":"4. Quarterly prices regional","index":8,"n_rows":138,"n_cols":11,"rows_kept":138,"cut":false,"hidden":false,"merged":[]}
["Quarterly prices by region"]
[{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
[]
["Supplementary Table D4.1",null,null,null,null,null,null,null,null,null,"Figure D4.1 (report figure 3.17a): New South Wales Volume weighted average of absolute price difference between OTC and ASX quarterly base swap contracts bought and sold in 2021 and 2022, by delivery period ($/MWh)"]
["NSW - Smaller retailer, and large generator and gentailer, purchases and sales"]
["Volume weighted average price difference"]
["Period","Q1 2023","Q2 2023","Q3 2023","Q4 2023","Q1 2024","Q2 2024","Q3 2024","Q4 2024"]
[2021,6.6483935872801192,4.0271797964033622,2.0393323616189427,3.5214718911225753,5.4171784683730886,2.2109216235598828,6.8855737196389253,10.057136912615448]
[2022,40.80726871766948,40.446454560477811,2.9202798593232808,7.4418341462276256,10.270059778195829,6.5079302579374243,8.3342225501657818,4.4228072498029949]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis of hedging contracts data."]
[]
[]
["Supplementary Table D4.2",null,null,null,null,null,null,null,null,null,"Figure D4.2 (report figure 3.17b): Queensland Volume weighted average of absolute price difference between OTC and ASX quarterly base swap contracts bought and sold in 2021 and 2022, by delivery period ($/MWh)"]
["QLD - Smaller retailer, and larger generator and gentailer, purchases and sales"]
["Volume weighted average price difference"]
["Period","Q1 2023","Q2 2023","Q3 2023","Q4 2023","Q1 2024","Q2 2024","Q3 2024","Q4 2024"]
[2021,8.3892715757303282,8.4598561823640193,10.09879617814075,12.678276694979926,9.8926151488220349,13.872834697797586,0.66454041911786232,0.33093304994686501]
[2022,91.284544731467562,61.539271432160419,7.1557879166805005,4.9952490998524661,2.4812098184817599,5.0465535574610465,5.1613742790542352,2.4590993315351239]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,null,null,null,null,null,null,null,null,null,"Note: The higher price differentials for Q3 2023 to Q4 2024 swap contracts traded in Queensland in 2021 were driven primarily by the large spike in price premiums for over-the-counter contracts traded in Q3 2021."]
[null,null,null,null,null,null,null,null,null,null,"This spike was likely a response to the extreme spot prices in the state driven by the Callide C outage (among other factors) at that time."]
[]
[]
["Supplementary Table D4.3",null,null,null,null,null,null,null,null,null,"Figure D4.3 (report figure 3.17c): Victoria Volume weighted average of absolute price difference between OTC and ASX quarterly base swap contracts bought and sold in 2021 and 2022, by delivery period ($/MWh)"]
["VIC - Smaller retailer, and larger generator and gentailer, purchases and sales"]
["Volume weighted average price difference"]
["Period","Q1 2023","Q2 2023","Q3 2023","Q4 2023","Q1 2024","Q2 2024","Q3 2024","Q4 2024"]
[2021,3.4763158825094846,3.7393626468876078,2.2486002463367529,0.78306696939749665,0.32042629749643359,2.3706299240274968,1.0791947456448612,3.8098291411393141]
[2022,27.907511171894061,27.44324604834652,9.4482801634195095,7.8616323961281269,9.2792356318571994,7.880087282761469,5.0122676200659368,5.5560976907959398]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,null,null,null,null,null,null,null,null,null,"Note: External trades only. OTC = over-the-counter."]
[]
[]
["Supplementary Table D4.4",null,null,null,null,null,null,null,null,null,"Figure D4.4 (report figure 3.18a) New South Wales Volume weighted average price difference between OTC and ASX quarterly base swap contracts bought and sold for 2023 and 2024 delivery periods, by trade date ($/MWh)"]
["NSW - Smaller retailer, and larger generator and gentailer, purchases and sales"]
["Quarter","Q1 2023","Q2 2023","Q3 2023","Q4 2023","Q1 2024","Q2 2024","Q3 2024","Q4 2024"]
["Q1 2021",-5.94,2.38,-1.33,11.83,-5.12,0,0,0]
["Q2 2021",16.170000000000002,2.54,0,-4.1399999999999997,-1.85,0.5,0,26.33]
["Q3 2021",4.24,3.68,2.39,1.79,6.1,3.57,11.17,6.9]
["Q4 2021",2.0699999999999998,-6.16,-3.6,-0.69,9.8000000000000007,3.56,0,0]
["Q1 2022",-5.29,-7.33,8.4,10.96,15.63,-4.07,-3.61,-4]
["Q2 2022",75.06,69.150000000000006,-1.47,6.35,-9.8000000000000007,-16.88,-8.01,8.5399999999999991]
["Q3 2022",14.3,-2.44,-2.35,-4.26,5.23,1.38,-15.33,0]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,null,null,null,null,null,null,null,null,null,"Note: External trades only. South Australia displayed low-no traded volumes of these contracts and has therefore been excluded. "]
[null,null,null,null,null,null,null,null,null,null,"Tasmania has also been excluded as there are no ASX-listed contracts in the region. OTC = over-the-counter."]
[]
[]
["Supplementary Table D4.5",null,null,null,null,null,null,null,null,null,"Figure D4.5 (report figure 3.18b) Queensland Volume weighted average price difference between OTC and ASX quarterly base swap contracts bought and sold for 2023 and 2024 delivery periods, by trade date ($/MWh)"]
["QLD - Smaller retailer, and larger generator and gentailer, purchases and sales"]
["Quarter","Q1 2023","Q2 2023","Q3 2023","Q4 2023","Q1 2024","Q2 2024","Q3 2024","Q4 2024"]
["Q1 2021",-9.6,-7.43,2.58,-2.34,0,0,0,0]
["Q2 2021",0,0,0,0,0,0,0,0]
["Q3 2021",29.91,29.96,44.06,55.65,43.23,58.26,0,0]
["Q4 2021",-0.86,-1.77,-0.63,-1.52,0.18,-0.56999999999999995,-1.37,-0.68]
["Q1 2022",10.57,13.69,7.78,6.69,-0.05,3.82,4.51,-1.45]
["Q2 2022",139.18,100.23,5.74,-1.8,2.81,4.4000000000000004,3.19,4.47]
["Q3 2022",-57.37,17.350000000000001,13.26,16.16,7.94,-10.61,13.24,-2.19]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,null,null,null,null,null,null,null,null,null,"Note: External trades only. South Australia displayed low-no traded volumes of these contracts and has therefore been excluded. "]
[null,null,null,null,null,null,null,null,null,null,"Tasmania has also been excluded as there are no ASX-listed contracts in the region. OTC = over-the-counter."]
[]
[]
["Supplementary Table D4.6",null,null,null,null,null,null,null,null,null,"Figure D4.6 (report figure 3.18c) Victoria Volume weighted average price difference between OTC and ASX quarterly base swap contracts bought and sold for 2023 and 2024 delivery periods, by trade date ($/MWh)"]
["VIC - Smaller retailer, and larger generator and gentailer, purchases and sales"]
["Quarter","Q1 2023","Q2 2023","Q3 2023","Q4 2023","Q1 2024","Q2 2024","Q3 2024","Q4 2024"]
["Q1 2021",-4.99,-0.25,0.89,-0.56999999999999995,-1.72,0.77,0,0]
["Q2 2021",-1.27,-1.93,-0.77,-0.53,0,0,-0.62,0.31]
["Q3 2021",-1.8,6.38,0.39,1.1200000000000001,0,5.53,0,-11.05]
["Q4 2021",8.49,3.86,-10.1,0.44,0,0,-2.17,-0.47]
["Q1 2022",2.84,1.72,5.56,0.5,-1.19,-2.65,-0.97,-1.53]
["Q2 2022",47.27,54.48,15.82,14.74,15.17,10.92,9.3699999999999992,9.7200000000000006]
["Q3 2022",-3.42,2.48,-0.69,1.1000000000000001,4.59,6.7,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,null,null,null,null,null,null,null,null,null,"Note: External trades only. South Australia displayed low-no traded volumes of these contracts and has therefore been excluded. "]
[null,null,null,null,null,null,null,null,null,null,"Tasmania has also been excluded as there are no ASX-listed contracts in the region. OTC = over-the-counter."]

{"sheet":"5. Monthly volumes","index":9,"n_rows":201,"n_cols":16,"rows_kept":201,"cut":false,"hidden":false,"merged":[[29,0,30,0],[4,0,5,0],[105,1,105,2],[105,3,106,3],[157,1,157,2],[131,1,131,2],[4,1,4,2],[4,3,4,4],[29,1,29,2],[29,3,29,4]]}
["Monthly volumes"]
[{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
[]
["Supplementary Table D5.1",null,null,null,null,null,"Figure D5.1 (report figure 3.6a): Volume of contracts traded on the ASX and OTC market for larger generators and gentailers (GWh)"]
["Large generator and gentailer volumes (GWh)","ASX",null,"OTC"]
[null,"Purchase","Sale","Purchase","Sale"]
["2021-01-01",44969.16,-44536.55,3346.25,-3769.06]
["2021-02-01",46703.199999999997,-55399.87,6040.51,-8395.14]
["2021-03-01",30794.18,-39960.199999999997,4988.72,-24498.49]
["2021-04-01",31106.18,-30535.35,3363.32,-3508.68]
["2021-05-01",41452.019999999997,-53923.44,5548.62,-5470.02]
["2021-06-01",45289.99,-49224.15,16869.580000000002,-10444.379999999999]
["2021-07-01",55093,-45932.6,5839.72,-2378.34]
["2021-08-01",24405.33,-23365.45,3116.8,-2073.2199999999998]
["2021-09-01",19338.099999999999,-23324.46,5053.6099999999997,-5164.5200000000004]
["2021-10-01",22073.25,-30475.759999999998,15646.36,-9435.35]
["2021-11-01",50233.72,-58407.45,8093.7,-42094.17]
["2021-12-01",26283.63,-28243.68,16491.28,-5002.01]
["2022-01-01",25248.77,-26295.57,1541.76,-864.91]
["2022-02-01",36993.42,-40781.19,6263.33,-4251.07]
["2022-03-01",54490.33,-53026.38,26408.22,-22772.959999999999,null,"Source: ACCC analysis of hedging contracts data."]
["2022-04-01",21580.41,-20138.990000000002,7817.68,-8771.39,null,"Note: External trades only. OTC = over-the-counter."]
["2022-05-01",46110.37,-47904.04,9876.7999999999993,-9400.44]
["2022-06-01",18760.650000000001,-19505.79,14324.09,-12440.32]
["2022-07-01",17573.45,-13351.37,2043.59,-2918.86]
["2022-08-01",27978.18,-31483.34,4146.2,-5270.18]
[]
[]
["Supplementary Table D5.2",null,null,null,null,null,"Figure D5.2 (report figure 3.6b): Volume of contracts traded on the ASX and OTC market for smaller retailers (GWh)"]
["Smaller retailer volumes (GWh)","ASX",null,"OTC"]
[null,"Purchase","Sale","Purchase","Sale"]
["2021-01-01",122.54,-15.12,85.82,0]
["2021-02-01",148.77000000000001,-15.12,225.07,0]
["2021-03-01",234.52,-26.25,425.54,-8.83]
["2021-04-01",267.67,-39.619999999999997,2364.7600000000002,0]
["2021-05-01",510.16,-65.709999999999994,910.53,0]
["2021-06-01",276.08999999999997,-137.66,4307.22,-2.2000000000000002]
["2021-07-01",348.74,-241.24,445.9,0]
["2021-08-01",37.270000000000003,-155.94999999999999,19.14,-5.9]
["2021-09-01",1302.0899999999999,-1410.78,48.31,-13.24]
["2021-10-01",448.39,-284.42,162.91,-25.92]
["2021-11-01",315.72000000000003,-161.59,5282.03,-5.85]
["2021-12-01",350.85,-32.44,75.14,-13.1]
["2022-01-01",236.04,-128.49,120.55,0]
["2022-02-01",205.4,-111.33,167.73,0]
["2022-03-01",602.80999999999995,-127.72,836.3,-4.3600000000000003]
["2022-04-01",197.11,-195.04,261.33999999999997,0]
["2022-05-01",352.89,-833.81,3341.75,-179.65,null,"Source: ACCC analysis of hedging contracts data."]
["2022-06-01",81,-61.46,2149.7399999999998,-1001.44,null,"Note: External trades only. OTC = over-the-counter."]
["2022-07-01",95.35,-81.12,397.99,-118.65]
["2022-08-01",128.30000000000001,-210.74,105.35,-21.93]
[]
[]
["Supplementary Table D5.3",null,null,null,null,null,"Figure D5.3 (report figure 3.12): ASX and over-the-counter volumes sold between January 2021 and August 2022 (GWh)"]
["All regions, OTC and ASX markets"]
["Period","ASX","OTC"]
["2021-01-01",-44536.55,-3769.06]
["2021-02-01",-55399.87,-8395.14]
["2021-03-01",-39960.199999999997,-24498.49]
["2021-04-01",-30535.35,-3508.68]
["2021-05-01",-53923.44,-5470.02]
["2021-06-01",-49224.15,-10444.379999999999]
["2021-07-01",-45932.6,-2378.34]
["2021-08-01",-23365.45,-2073.2199999999998]
["2021-09-01",-23324.46,-5164.5200000000004]
["2021-10-01",-30475.77,-9435.35]
["2021-11-01",-58407.45,-42094.17]
["2021-12-01",-28243.68,-5002.01]
["2022-01-01",-26295.57,-864.91]
["2022-02-01",-40781.19,-4251.07]
["2022-03-01",-53026.38,-22772.959999999999]
["2022-04-01",-20138.990000000002,-8771.39,null,null,null,"Source: ACCC analysis of hedging contracts data."]
["2022-05-01",-47904.04,-9400.44,null,null,null,"Notes: External trades only and excludes load following swap contracts. Volumes traded filtered for sold, negative volume denotes a sale while positive volume denotes a purchase. OTC = over-the-counter."]
["2022-06-01",-19505.79,-12440.32]
["2022-07-01",-13351.37,-2918.86]
["2022-08-01",-31483.34,-5270.18]
[]
[]
["Supplementary Table D5.4",null,null,null,null,null,"Figure D5.4 (report figure 3.15): Volume of ASX and OTC contracts purchased by smaller retailers in 2021 and 2022 (GWh)"]
["All regions, OTC and ASX markets"]
["Period","ASX","OTC"]
["2021-01-01",122.54399999999998,85.824000000000012]
["2021-02-01",148.77599999999993,207.59999999999988]
["2021-03-01",234.52799999999991,425.54400000000027]
["2021-04-01",267.67199999999985,230.6159999999999]
["2021-05-01",510.16800000000046,893.06400000000053]
["2021-06-01",276.09599999999995,237.67199999999994]
["2021-07-01",348.74400000000003,445.90680000000043]
["2021-08-01",37.271999999999998,19.1496]
["2021-09-01",1302.0978000000005,48.311999999999991]
["2021-10-01",448.39200000000011,162.91199999999998]
["2021-11-01",315.71999999999991,142.36799999999997]
["2021-12-01",350.85599999999999,75.147000000000006]
["2022-01-01",236.03999999999994,120.55199999999999]
["2022-02-01",205.4009999999999,143.39099999999999]
["2022-03-01",602.81820000000062,811.95779999999968,null,null,null,"Source: ACCC analysis of hedging contracts data."]
["2022-04-01",197.11199999999991,256.34399999999994,null,null,null,"Note: Excludes load following swap contracts. OTC = over-the-counter."]
["2022-05-01",352.89600000000002,1183.6632000000006]
["2022-06-01",80.999999999999972,1767.048]
["2022-07-01",95.35439999999997,397.99200000000013]
["2022-08-01",128.30639999999997,105.3552]
[]
[]
["Supplementary Table D5.5",null,null,null,null,null,"Figure D5.5 (report figure 3.13): Volume of ASX, and volume and maximum strike price of over-the-counter cap contracts, sold in 2021 and 2022"]
["All regions, OTC and ASX markets"]
[null,"Volumes Sold (GWh)",null,"Maximum Strike Price ($/MWh)"]
["Period","ASX","OTC"]
["2021-01-01",1803.91,130.34,300]
["2021-02-01",1450.94,498.69,300]
["2021-03-01",1752.29,1493.06,300]
["2021-04-01",4375.7299999999996,873.52,300]
["2021-05-01",7186.38,517.49,300]
["2021-06-01",8573.35,5814.16,300]
["2021-07-01",2770.34,161.68,300]
["2021-08-01",3856.34,193.36,300]
["2021-09-01",3259.42,813.58,300]
["2021-10-01",3616.75,5112.5200000000004,300]
["2021-11-01",5896.97,1308.23,300]
["2021-12-01",3476.86,901.64,300]
["2022-01-01",2877.81,146.37,300]
["2022-02-01",4401.28,1077.8699999999999,300,null,null,"Source: ACCC analysis of hedging contracts data."]
["2022-03-01",3882.81,6284.74,300,null,null,"Note: External trades only and excludes load following swap contracts."]
["2022-04-01",1337.09,2710.32,300]
["2022-05-01",3289.95,976.37,500]
["2022-06-01",632.08000000000004,898.43,300]
["2022-07-01",642.07000000000005,262.56,1000]
["2022-08-01",1932.96,425.37,1000]
[]
[]
["Supplementary Table D5.6",null,null,null,null,null,"Figure D5.6 (report figure 3.14a): Larger generator and gentailers OTC contract volumes bought and sold in 2021 and 2022 (TWh)"]
["Larger generator and gentailer, All regions, OTC and ASX markets"]
[null,"OTC Contracts",null,"Total volume traded"]
["Period","Purchase","Sale"]
["2021-01-01",3346.25,-3769.06,7115.31]
["2021-02-01",6040.51,-8395.14,14435.65]
["2021-03-01",4988.72,-24498.49,29487.21]
["2021-04-01",3363.32,-3508.68,6872]
["2021-05-01",5548.62,-5470.02,11018.64]
["2021-06-01",16869.580000000002,-10444.379999999999,27313.96]
["2021-07-01",5839.72,-2378.34,8218.07]
["2021-08-01",3116.8,-2073.2199999999998,5190.03]
["2021-09-01",5053.6099999999997,-5164.5200000000004,10218.14]
["2021-10-01",15646.36,-9435.35,25081.71]
["2021-11-01",8093.7,-42094.17,50187.88]
["2021-12-01",16491.28,-5002.01,21493.3]
["2022-01-01",1541.76,-864.91,2406.67]
["2022-02-01",6263.33,-4251.07,10514.41]
["2022-03-01",26408.22,-22772.959999999999,50059.58,null,null,"Source: ACCC analysis of hedging contracts data. Figure shows over-the-counter contract volumes purchased (positive) and sold (negative) by larger generators and gentailers and smaller retailers."]
["2022-04-01",7817.68,-8771.39,16589.080000000002,null,null,"Note: External trades only and excludes load following swap contracts. OTC = over-the-counter."]
["2022-05-01",9876.7999999999993,-9400.44,19277.240000000002]
["2022-06-01",14324.09,-12440.32,26764.42]
["2022-07-01",2043.59,-2918.86,4962.45]
["2022-08-01",4146.2,-5270.18,10106.24]
[]
[]
["Supplementary Table D5.7",null,null,null,null,null,"Figure D5.7 (report figure 3.14b): Smaller retailers OTC contract volumes bought and sold in 2021 and 2022 (TWh)"]
["Smaller retailer, All regions, OTC and ASX markets"]
[null,"OTC Contracts",null,"Total Volume traded"]
["Period","Purchase","Sale"]
["2021-01-01",85.823999999999998,null,85.823999999999998]
["2021-02-01",207.59999999999988,null,207.59999999999988]
["2021-03-01",425.54400000000021,-8.831999999999999,434.3760000000002]
["2021-04-01",230.61599999999993,null,230.61599999999993]
["2021-05-01",893.06400000000053,null,893.06400000000053]
["2021-06-01",237.67199999999994,-2.2080000000000002,239.87999999999994]
["2021-07-01",445.90680000000043,null,445.90680000000043]
["2021-08-01",19.1496,-5.9004000000000003,25.05]
["2021-09-01",48.312000000000005,-13.248000000000001,61.56]
["2021-10-01",162.91199999999998,-25.92,188.83199999999999]
["2021-11-01",142.36799999999997,-5.8559999999999999,148.22399999999996]
["2021-12-01",75.146999999999991,-13.103999999999999,88.250999999999991]
["2022-01-01",120.55200000000002,null,120.55200000000002]
["2022-02-01",143.39099999999999,null,143.39099999999999,null,null,"Source: ACCC analysis of hedging contracts data. Figure shows over-the-counter contract volumes purchased (positive) and sold (negative) by larger generators and gentailers and smaller retailers."]
["2022-03-01",811.95780000000036,-4.3680000000000003,816.32580000000041,null,null,"Note: External trades only and excludes load following swap contracts. OTC = over-the-counter."]
["2022-04-01",256.34399999999999,null,256.34399999999999]
["2022-05-01",1183.6631999999995,-179.65439999999995,1363.3175999999994]
["2022-06-01",1767.0480000000002,-1001.4480000000001,2768.4960000000001]
["2022-07-01",397.99200000000013,-118.65599999999999,516.64800000000014]
["2022-08-01",105.3552,-21.936,127.2912]
[]
[]
["Supplementary Table D5.8",null,null,null,null,null,"Figure D5.8 (report figure 3.11) Percentage volume of ASX and OTC contracts purchased by smaller retailers, monthly comparison of 2021 and 2022, April to August "]
["All regions, OTC and ASX markets, 2021-2022 comparison, April-August"]
["Month","Year","ASX","OTC"]
["Apr",2021,0.53718331567286381,0.46281668432713613]
[null,2022,0.43468826082354184,0.56531173917645816]
["May",2021,0.36356639529315193,0.63643360470684818]
[null,2022,0.22966638708095327,0.77033361291904678]
["Jun",2021,0.53739431027234086,0.46260568972765925]
[null,2022,4.3830030388821051E-2,0.95616996961117895]
["Jul",2021,0.43886446726033601,0.56113553273966399]
[null,2022,0.19328082661594356,0.80671917338405641]
["Aug",2021,0.6605980688247054,0.33940193117529455]
[null,2022,0.54911204921989742,0.45088795078010258]
[]
[]
[]
[]
[null,null,null,null,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,null,null,null,null,null,"Note: External trades only and excludes load following swap contracts. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"6. Monthly volumes regional","index":10,"n_rows":108,"n_cols":7,"rows_kept":108,"cut":false,"hidden":false,"merged":[[86,1,87,1],[86,2,87,2],[86,0,87,0],[5,1,5,2],[5,3,5,4],[59,1,59,2],[59,3,59,4],[32,1,32,2],[32,3,32,4]]}
["Monthly volumes by region"]
[{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
[]
["Supplementary Table D6.1",null,null,null,null,null,"Figure D6.1 (report figure 3.5a): New South Wales Volume of ASX and OTC base swap contracts bought and sold in 2021 and 2022 for Q1 to Q4 2023 delivery periods (GWh)"]
["NSW Volumes (GWh)"]
[null,"Purchase",null,"Sale"]
["Period","ASX","OTC","ASX","OTC"]
["2021-01-01",5749.2557999999945,682.76219999999989,-7696.4964000000182,-1723.152]
["2021-02-01",6964.731000000007,3639.4611299999997,-8442.6899999999987,-1155.3600000000001]
["2021-03-01",5197.8858,798.60045837257144,-5313.8610000000026,-605.32874494799989]
["2021-04-01",6810.7146000000057,2176.0601999999999,-8229.3690000000061,-1842.0599999999997]
["2021-05-01",12199.841400000027,3455.7312857142856,-15379.527600000027,-2582.5879714285716]
["2021-06-01",15382.203600000046,10556.945272524001,-14900.146800000031,-5845.6596093840017]
["2021-07-01",9885.9918000000071,833.6142000000001,-7484.8116000000045,-431.76120098400003]
["2021-08-01",7924.934400000001,2150.4007230959996,-7665.4920000000029,-1051.3831230960002]
["2021-09-01",6684.7068000000027,722.84400000000016,-6529.7280000000037,-2184.3350832000001]
["2021-10-01",8166.4313999999995,4010.4195639599993,-10862.754000000032,-3493.0185639599999]
["2021-11-01",16438.517400000037,2566.3502142857137,-16114.905000000015,-967.73841428571427]
["2021-12-01",7670.7240000000111,4810.8239999999996,-6297.4680000000044,-2133.572064]
["2022-01-01",8981.4846000000234,711.24,-5657.471400000004,-10.92]
["2022-02-01",8945.8013999999966,2577.7649999999999,-8850.1464000000142,-2075.3172]
["2022-03-01",18577.393200000039,10782.084149952001,-18395.372400000022,-9141.0651310800004,null,"Source: ACCC analysis of hedging contracts data."]
["2022-04-01",3629.9861999999989,1047.7716060000002,-5288.4161999999988,-258.17905849799996,null,"Note: External trades only. OTC = over-the-counter."]
["2022-05-01",13168.039800000017,2409.3748799999994,-11654.183999999985,-1207.3883363159998]
["2022-06-01",5182.1952000000047,3443.2626173399995,-5511.6173999999946,-5517.5612348099967]
["2022-07-01",6285.8484000000062,557.06400000000008,-4258.8750000000009,-624.47699999999986]
["2022-08-01",8150.9334000000053,455.74619999999999,-8765.9760000000024,-313.37279999999998]
[]
[]
[]
["Supplementary Table D6.2",null,null,null,null,null,"Figure D6.2 (report figure 3.5b): Queensland Volume of ASX and OTC base swap contracts bought and sold in 2021 and 2022 for Q1 to Q4 2023 delivery periods (GWh)"]
["QLD Volumes (GWh)"]
[null,"Purchase",null,"Sale"]
["Period","ASX","OTC","ASX","OTC"]
["2021-01-01",24996.15,2189.13,-23601.200000000001,-1797.51]
["2021-02-01",12523.86,480.14,-15559.99,-6077.24]
["2021-03-01",9706.4599999999991,1331.36,-9168.81,-969.83]
["2021-04-01",17797.61,764.25,-14661.91,-288.37]
["2021-05-01",14371.4,1703.83,-19496.78,-457.81]
["2021-06-01",18809.099999999999,2662.21,-21802.19,-685.52]
["2021-07-01",19548.45,4554.18,-16744.830000000002,-1341.31]
["2021-08-01",9650.59,604.89,-9228.85,-581.45000000000005]
["2021-09-01",8419,1009.47,-12447.48,-237.21]
["2021-10-01",9792.98,3536.62,-14921.25,-1200.28]
["2021-11-01",29369.49,7205.22,-36092.199999999997,-3702.39]
["2021-12-01",14406.88,8089.3,-17396.25,-1853.17]
["2022-01-01",12745.69,822.41,-13784.58,-712.1]
["2022-02-01",21049.919999999998,1674.7,-22421.34,-1269.18,null,"Source: ACCC analysis of hedging contracts data."]
["2022-03-01",24377.61,15109.86,-25086.3,-12596.21,null,"Note: External trades only. OTC = over-the-counter."]
["2022-04-01",12609.77,4349.33,-9156.99,-5980.42]
["2022-05-01",21060.27,6903.07,-25794.560000000001,-7605.2]
["2022-06-01",9488.4,7011.12,-10407.129999999999,-2686.94]
["2022-07-01",6990.88,612.71,-6246.98,-923.12]
["2022-08-01",14523.75,3199.13,-15974.06,-4875.13]
[]
[]
[]
["Supplementary Table D6.3",null,null,null,null,null,"Figure D6.3 (report figure 3.5c): Victoria Volume of ASX and OTC base swap contracts bought and sold in 2021 and 2022 for Q1 to Q4 2023 delivery periods (GWh)"]
["VIC Volumes (GWh)"]
[null,"Purchase",null,"Sale"]
["Period","ASX","OTC","ASX","OTC"]
["2021-01-01",14263.168800000045,219.35999999999999,-13139.647800000044,-126.24]
["2021-02-01",27297.438000000075,1817.1480000000001,-31342.527000000075,-1149.1332059639999]
["2021-03-01",15944.771400000067,2535.924,-25418.370000000014,-22662.541199999996]
["2021-04-01",5937.9875999999995,1607.7623999999996,-6816.9030000000012,-553.59120000000007]
["2021-05-01",14812.523400000067,339.05700000000002,-18582.303000000044,-1310.1437999999998]
["2021-06-01",10106.672400000019,5105.3108810460008,-11618.93520000002,-2681.4042092819996]
["2021-07-01",25682.231400000004,524.69039999999995,-21653.816399999982,-315.71999999999991]
["2021-08-01",6470.6436000000049,41.073599999999999,-6375.5160000000005,-213.04200000000003]
["2021-09-01",5014.1514000000025,2311.4160000000002,-5577.5843999999997,-2047.1472000000001]
["2021-10-01",4264.1063999999988,2209.9679999999998,-4540.2780000000012,-2313.9322112159998]
["2021-11-01",4536.3330000000005,2917.4854285714277,-6077.1389999999983,-35267.018031428583]
["2021-12-01",4116.4631999999974,2552.187004032,-4242.4560000000001,-199.79554285714286]
["2022-01-01",3698.4792000000011,41.616,-6935.8224000000037,-50.352000000000004]
["2022-02-01",6486.3750000000064,1023.936,-9138.7194000000109,-577.52219999999988]
["2022-03-01",12114.009000000025,946.65000000000009,-9641.4066000000184,-841.66799999999989,null,"Source: ACCC analysis of hedging contracts data."]
["2022-04-01",5210.1239999999989,2054.9759999999997,-5614.1730000000061,-2305.7435999999998,null,"Note: External trades only. OTC = over-the-counter."]
["2022-05-01",12184.368600000013,1783.3005599999999,-11097.46800000001,-484.17068097599997]
["2022-06-01",4048.3230000000021,5513.7343031399969,-3517.9199999999996,-4573.9002030599986]
["2022-07-01",4345.7778000000035,722.51224999999999,-2829.2219999999998,-984.82214999999997]
["2022-08-01",5330.5841999999993,347.68800000000005,-6845.6880000000046,-99.253199999999993]
[]
[]
[]
["Supplementary Table D6.4",null,null,null,null,null,"Figure D6.4 (report figure 3.5d): South Australia Volume of ASX and OTC base swap contracts bought and sold in 2021 and 2022 for Q1 to Q4 2023 delivery periods (GWh)"]
["SA Volumes (GWh)"]
["Period","Purchase - ASX and OTC","Sale - ASX and OTC"]
[]
["2021-01-01",401.05200000000002,-236.49599999999995]
["2021-02-01",220.58399999999995,-83.207999999999998]
["2021-03-01",544.39237326600005,-346.30597326600002]
["2021-04-01",1928.6742000000002,-1691.463]
["2021-05-01",1471.9925999999996,-1650.0275999999992]
["2021-06-01",3508.4605257959993,-2274.5627907179987]
["2021-07-01",544.75199999999995,-576.23999999999978]
["2021-08-01",727.24800000000027,-484.80360000000002]
["2021-09-01",1262.2470000000001,-878.36220000000003]
["2021-10-01",6345.1402740000012,-2889.9558976799999]
["2021-11-01",825.59640000000036,-2447.6951999999987]
["2021-12-01",1446.6359999999995,-1056.9461999999999]
["2022-01-01",124.24800000000002,-137.73599999999999]
["2022-02-01",1699.6560000000002,-811.38120000000015,null,null,null,"Source: ACCC analysis of hedging contracts data."]
["2022-03-01",301.20780000000008,-229.41599999999997,null,null,null,"Note: External trades only. OTC = over-the-counter."]
["2022-04-01",910.09920000000125,-501.5136]
["2022-05-01",2017.9784785920001,-474.97743859199994]
["2022-06-01",520.28681600999994,-793.96381479000047]
["2022-07-01",568.82940000000008,-602.5200000000001]
["2022-08-01",299.61599999999999,-112.72799999999998]

{"sheet":"7. Hedged position","index":11,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Hedge position of smaller retailers"]
[{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
[]
["Supplementary Table D7.1",null,null,null,null,null,null,"Figure D7.1 (report figure 3.10): Average and standard deviation of hedged position of smaller retailers, and target hedge ratio, Q3 2022 to Q2 2024"]
[]
["Quarter","Target max","Target min","Target Average","Average net hedged position","Net hedged position standard deviation"]
["Q3 2022",1.075,0.9,0.99,0.93,0.4]
["Q4 2022",1.075,0.85,0.98,0.9,0.37]
["Q1 2023",1,0.625,0.85,0.83,0.34]
["Q2 2023",1,0.375,0.69,0.8,0.34]
["Q3 2023",1,0,0.5,0.64,0.47]
["Q4 2023",1,0,0.4,0.6,0.38]
["Q1 2024",1,0,0.38,0.55000000000000004,0.55000000000000004]
["Q2 2024",1,0,0.36,0.4,0.37]
[]
[]
[]
[null,null,null,null,null,null,null,"Source: ACCC analysis of hedging contracts data. Figure shows smaller retailer hedging target range, average net hedge position with standard deviation bars and median target hedge ratio values."]
[null,null,null,null,null,null,null,"Note: Analysis captures a subset of smaller retailers the ACCC collected information from."]

{"sheet":"COST STACK>>","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"8. NEM $customer","index":13,"n_rows":157,"n_cols":10,"rows_kept":157,"cut":false,"hidden":false,"merged":[]}
["Cost stacks, $/customer"]
[{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
[]
["Supplementary Table D8.1",null,null,null,null,null,null,null,null,"Figure D8.1: Cost components for the average residential customer across the NEM in 2021–22, real $2021–22, excluding GST"]
["Residential Customers"]
["2021–22","$/customer","% of cost stack"]
["Network",677.17575932914212,0.48565279770444764]
["Wholesale electricity",391.76046905037617,0.28120516499282638]
["Environmental",149.42018889754939,0.10688665710186514]
["Retail & other costs",141.00642810019849,0.10114777618364419]
["Retail margin (EBITDA)",34.783751368029101,2.4949852081003178E-2]
["Total Cost Stack",1394.1465967452953]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
["Supplementary Table D8.2",null,null,null,null,null,null,null,null,"Figure D8.2 (report figure C5): Change in cost components for the average residential customer across the NEM from 2020–21 to 2021–22, real $2021–22, excluding GST"]
["Residential Customers"]
["$/customer","2020–21","2021–22","Change"]
["Network",685.99023798691201,677.17575932914201,-8.8144786577699961]
["Wholesale electricity",480.50888020048473,391.76046905037606,-88.748411150108666]
["Environmental",156.45642734803255,149.42018889754937,-7.0362384504831823]
["Retail & other costs",146.88249446679077,141.00642810019846,-5.8760663665923119]
["Retail margin (EBITDA)",52.052175494823672,34.783751368029094,-17.268424126794578]
["Total Cost Stack",1521.8902154970438,1394.146596745295,-127.74361875174873]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
["Supplementary Table D8.3",null,null,null,null,null,null,null,null,"Figure D8.3: Average residential customer bills by NEM regions, 2007–08 to 2021–22, real $2021–22, excluding GST "]
["Residential Customers, $/customer"]
["Variable","Year","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["Total Cost Stack","2007-08",1284.9913809554932,1378.3246052591439,1505.1808700487366,1410.3007675809604,1619.7860141670399,1378.3221839502799]
["Total Cost Stack","2008-09",0,0,0,0,0,0]
["Total Cost Stack","2009-10",0,0,0,0,0,0]
["Total Cost Stack","2010-11",1495.134493344314,1864.028069448241,1608.4160744627857,1689.9217910018813,1790.8642049602311,1673.7832399750616]
["Total Cost Stack","2011-12",0,0,0,0,0,0]
["Total Cost Stack","2012-13",0,0,0,0,0,0]
["Total Cost Stack","2013–14",1728.8999158680408,1931.2652517243159,1912.2178009517575,1967.5079919943794,2292.0150225204438,1886.8011896826365]
["Total Cost Stack","2014–15",1588.9074852204819,1771.0485133613636,1827.0484748039546,1976.6971563242607,2148.3931123940365,1766.252035818733]
["Total Cost Stack","2015–16",1542.0010195298985,1658.2419497006642,1694.2478811641561,1924.3341070983554,2121.2555181222042,1684.0461984236313]
["Total Cost Stack","2016–17",1474.0394343696664,1774.0532494699116,1734.3981155284864,1882.6081446695416,2220.8473133513307,1709.3337413088943]
["Total Cost Stack","2017–18",1511.2028372623552,1842.4151211004892,1821.4743353495107,1738.3048173809368,2131.668086964848,1729.1146826781207]
["Total Cost Stack","2018–19",1514.0182269527768,1730.8922644672737,1748.4685568934703,1600.6265334300047,2174.3017324756161,1657.9940260494661]
["Total Cost Stack","2019–20",1528.8779924497894,1657.6655299686522,1760.5621527714989,1515.954179840943,2288.8207903864154,1624.6247978431009]
["Total Cost Stack","2020–21",1457.5673680337998,1558.9813298396919,1548.5988460552612,1411.8655587546302,2163.1308327273587,1521.890215497044]
["Total Cost Stack","2021–22",1308.3720364031008,1453.9736419227445,1430.5724687534148,1280.2091047537388,1947.6386240457673,1394.1465967452953]
["Network","2007-08",550.5540383485602,668.4699766438614,689.34552799959954,668.38409863402433,764.30520513084264,625.44770143076948]
["Network","2008-09",0,0,0,0,0,0]
["Network","2009-10",0,0,0,0,0,0,null,"Source: ACCC analysis based on retailers’ data."]
["Network","2010-11",554.42193747626891,1053.0047186732086,723.65951699630125,793.81769292481283,904.30456506313965,791.50916053089054,null,"Note: Small negative EBITDA for 2020–21 for SA and SEQ not shown for readability. The small negative EBITDA for 2020–21 for SA and SEQ means that actual total cost stack is lower than the sum of the cost components shown."]
["Network","2011-12",0,0,0,0,0,0]
["Network","2012-13",0,0,0,0,0,0]
["Network","2013–14",724.39159005470026,1002.372570594461,895.82368679389288,1016.5088860705658,1113.1051603844078,915.14459784953556]
["Network","2014–15",764.4702659605249,976.25211806694153,917.73548265280795,1117.1069926642292,1093.9933869215477,932.20045414608398]
["Network","2015–16",735.66488042151286,833.90486489118052,762.04362342303671,1040.5107908864272,1063.0354681227611,837.49920412853396]
["Network","2016–17",627.95098941338324,835.55860836730665,717.79140359242217,940.8654987280886,1125.3927040262326,786.34705524562332]
["Network","2017–18",598.22330586939529,789.40068857424524,718.97049632136248,784.19699009100941,902.79889303624702,725.92112983583456]
["Network","2018–19",574.06722194710574,775.4746920806989,753.93992001801678,736.31773558651093,940.87276579162187,710.24239861804779]
["Network","2019–20",619.55278397512802,732.1913382256696,834.31172104836492,755.02820470239362,994.53606328953822,719.68985926876201]
["Network","2020–21",599.90126990695057,712.96577793985671,779.65997137004115,679.09998649960812,915.77936177942854,685.99023798691223]
["Network","2021–22",567.56250334646506,731.59670017790233,754.70109249558936,650.10828799533988,932.70859428515598,677.17575932914212]
["Wholesale electricity","2007-08",467.9132850477576,584.94578650321353,612.80197458273744,522.16379107341652,716.01975318262021,528.84573257296518]
["Wholesale electricity","2008-09",0,0,0,0,0,0]
["Wholesale electricity","2009-10",0,0,0,0,0,0]
["Wholesale electricity","2010-11",459.64480802573155,475.81624027160723,597.33797254202,517.0193909939137,686.83754585844986,501.02460206745627]
["Wholesale electricity","2011-12",0,0,0,0,0,0]
["Wholesale electricity","2012-13",0,0,0,0,0,0]
["Wholesale electricity","2013–14",547.1862511596114,522.13026133085145,583.31151170905082,505.00291869851225,779.94098347291947,541.0102020897217]
["Wholesale electricity","2014–15",359.04709580163382,385.11826731251108,517.72515341995495,401.55471173820047,608.43075647093224,399.87096590011282]
["Wholesale electricity","2015–16",327.44179931714689,384.89490654213563,507.44521252183512,478.18416267748057,598.69305859534677,401.26465219946249]
["Wholesale electricity","2016–17",349.47175593111149,441.50321053304657,577.17058894125216,543.00481929985619,676.54439394270617,450.60459169051057]
["Wholesale electricity","2017–18",471.24097505792275,583.47248539929842,717.78325270617722,623.6796477250349,865.88473444576539,577.23412842294499]
["Wholesale electricity","2018–19",517.79471654711733,539.08741685149528,614.12475219122121,564.72917352736442,763.79498578788923,551.0680748895594]
["Wholesale electricity","2019–20",542.21099519571317,535.99592288978295,568.56962200784722,474.01965309210124,907.73847819554123,542.03491670057292]
["Wholesale electricity","2020–21",486.26385691328812,481.42057964744373,462.13943120900194,427.10066382043073,756.4823299629071,480.50888020048478]
["Wholesale electricity","2021–22",378.30775873823393,409.34639639772473,349.3197740872651,357.60646899750361,609.14771311373147,391.76046905037617]
["Environmental","2007-08",9.523849592447025,110.13229397350176,12.873787320500334,30.073856671358861,14.211628096332175,25.467513475311364]
["Environmental","2008-09",0,0,0,0,0,0]
["Environmental","2009-10",0,0,0,0,0,0]
["Environmental","2010-11",71.058660144630522,95.83494372818916,57.356895061986513,72.228825762949455,32.780700772832262,75.993187552628157]
["Environmental","2011-12",0,0,0,0,0,0]
["Environmental","2012-13",0,0,0,0,0,0]
["Environmental","2013–14",91.877737215772939,132.84152108192211,201.06609227662213,122.72931139827001,147.98491374345622,126.17659789299248]
["Environmental","2014–15",93.672481445374387,121.67893548568236,210.39778318308606,123.28432344780424,156.09354640269314,123.15278816248838]
["Environmental","2015–16",99.653192177382806,123.1478687001392,191.13564402062863,158.30817870666854,189.55317964137072,130.4732390717833]
["Environmental","2016–17",103.07888374538423,121.63783390669064,188.69422707602305,167.47935039982636,176.06200669333649,131.84206142858963]
["Environmental","2017–18",124.58577730479614,144.96018116692002,186.19049495574242,97.246270549205803,188.35848162761357,135.96483783291524]
["Environmental","2018–19",128.63019690797259,153.82068363315761,189.10456613091006,109.15396213788237,181.36043666526575,142.92219742459395]
["Environmental","2019–20",139.68807970234948,158.23765807669753,200.35213310503218,110.89241157414985,196.01990767957381,150.04122959758587]
["Environmental","2020–21",142.42633883735022,154.31375081503319,178.81569002721938,167.92495076905695,193.36286965523249,156.45642734803258]
["Environmental","2021–22",155.30772802114842,137.04655910533108,164.15888282317979,154.01763002977185,190.88083643978018,149.42018889754939]
["Retail & other costs","2007-08",116.58018262367986,151.84515386811549,96.013520269871023,142.31200887985099,0,122.8514837347107]
["Retail & other costs","2008-09",0,0,0,0,0,0]
["Retail & other costs","2009-10",0,0,0,0,0,0]
["Retail & other costs","2010-11",160.87555313011239,180.91077439512267,121.87602790759244,161.71494227590824,0,161.44722842900043]
["Retail & other costs","2011-12",0,0,0,0,0,0]
["Retail & other costs","2012-13",0,0,0,0,0,0]
["Retail & other costs","2013–14",222.49613103269346,218.13701219382693,176.69424566324284,168.70646903731972,0,205.37950058752878]
["Retail & other costs","2014–15",213.70411408634831,179.67120679926086,180.91575722456747,180.40888928120501,0,188.76947788595481]
["Retail & other costs","2015–16",214.72833142725378,178.33874052282906,179.06916954876377,169.12179091451705,0,186.59017360037137]
["Retail & other costs","2016–17",210.05118313344417,182.9164859227339,170.2855920945625,180.87998938589257,0,188.03147701316877]
["Retail & other costs","2017–18",206.28494351859507,178.68936360749518,169.39825811431254,194.73527241164382,0,187.39002526958259]
["Retail & other costs","2018–19",198.89860419900643,174.75876865084905,169.75704386950321,174.77862402011453,0,180.83272374056151]
["Retail & other costs","2019–20",178.20566670009569,159.20169256255679,155.3191017856916,166.64564820645722,0,166.41785963793976]
["Retail & other costs","2020–21",159.97256031580946,140.5164555612526,141.27798308114671,140.05727309646278,0,146.8824944667908]
["Retail & other costs","2021–22",155.37168970520625,135.64577582907339,133.07298514940121,128.26138486456676,0,141.00642810019849]
["Retail margin (EBITDA)","2007-08",140.42002534304868,0,94.146059876028474,47.367012322309655,0,75.709752736523299]
["Retail margin (EBITDA)","2008-09",0,0,0,0,0,0]
["Retail margin (EBITDA)","2009-10",0,0,0,0,0,0]
["Retail margin (EBITDA)","2010-11",249.13353456757059,58.461392380113189,108.18566195488549,145.14093904429714,0,143.8090613950863]
["Retail margin (EBITDA)","2011-12",0,0,0,0,0,0]
["Retail margin (EBITDA)","2012-13",0,0,0,0,0,0]
["Retail margin (EBITDA)","2013–14",142.9482064052626,55.783886523254544,55.322264508948933,154.56040678971152,0,99.090291262857917]
["Retail margin (EBITDA)","2014–15",158.01352792660057,108.32798569696781,0.27429832353789324,154.34223919282189,0,122.25834972409308]
["Retail margin (EBITDA)","2015–16",164.51281618660209,137.9555690443797,54.554231649891783,78.209183913261896,0,128.21892942347989]
["Retail margin (EBITDA)","2016–17",183.48662214634334,192.43711074013362,80.45630382422668,50.378486855877867,0,152.50855593100209]
["Retail margin (EBITDA)","2017–18",110.86783551164575,145.89240235253067,29.131833251916017,38.446636604042752,0,102.60456131684325]
["Retail margin (EBITDA)","2018–19",94.627487351574587,87.75070325107275,21.542274683819095,15.64703815813259,0,72.928631376703663]
["Retail margin (EBITDA)","2019–20",49.220466876503053,72.038918213945223,2.0095748245627765,9.3682622658408885,0,46.440932638240184]
["Retail margin (EBITDA)","2020–21",69.003342060401664,69.76476587610577,-13.294229632147847,-2.317315430928327,0,52.052175494823686]
["Retail margin (EBITDA)","2021–22",51.822356592047058,40.338210412712932,29.319734197979351,-9.7846671334432784,0,34.783751368029101]
["Retail component","2007-08",0,0,0,0,125.24942775724469,0]
["Retail component","2008-09",0,0,0,0,0,0]
["Retail component","2009-10",0,0,0,0,0,0]
["Retail component","2010-11",0,0,0,0,166.9413932658095,0]
["Retail component","2011-12",0,0,0,0,0,0]
["Retail component","2012-13",0,0,0,0,0,0]
["Retail component","2013–14",0,0,0,0,250.9839649196602,0]
["Retail component","2014–15",0,0,0,0,289.87542259886328,0]
["Retail component","2015–16",0,0,0,0,269.97381176272586,0]
["Retail component","2016–17",0,0,0,0,242.8482086890555,0]
["Retail component","2017–18",0,0,0,0,174.62597785522181,0]
["Retail component","2018–19",0,0,0,0,288.27354423083926,0]
["Retail component","2019–20",0,0,0,0,190.52634122176229,0]
["Retail component","2020–21",0,0,0,0,297.50627132979054,0]
["Retail component","2021–22",0,0,0,0,214.90148020709972,0]

{"sheet":"9. NEM ckWh","index":14,"n_rows":405,"n_cols":9,"rows_kept":405,"cut":false,"hidden":false,"merged":[]}
["NEM-wide cost stacks, c/kWh"]
[{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
[]
["Supplementary Table D9.1",null,null,null,null,null,null,null,"Figure D9.1: Average residential customer effective price across the NEM from 2007–08 to 2021–22, real $2021–22, excluding GST"]
["Residential Customers,c/kWh"]
["Variable","Year","NEM"]
["Total Cost Stack","2007–08",21.660464184494664]
["Total Cost Stack","2008–09",0]
["Total Cost Stack","2009–10",0]
["Total Cost Stack","2010–11",26.464165061137582]
["Total Cost Stack","2011–12",0]
["Total Cost Stack","2012–13",0]
["Total Cost Stack","2013–14",34.226841791346843]
["Total Cost Stack","2014–15",31.898339180048776]
["Total Cost Stack","2015–16",30.414310269898184]
["Total Cost Stack","2016–17",31.187940819821957]
["Total Cost Stack","2017–18",32.343833897616229]
["Total Cost Stack","2018–19",31.496492595106961]
["Total Cost Stack","2019–20",30.865713173167634]
["Total Cost Stack","2020–21",28.634258066627169]
["Total Cost Stack","2021–22",26.257421646232043]
["Network","2007–08",9.8289701013797153]
["Network","2008–09",0]
["Network","2009–10",0,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
["Network","2010–11",12.514541053717339]
["Network","2011–12",0]
["Network","2012–13",0]
["Network","2013–14",16.600853093626831]
["Network","2014–15",16.835449113219877]
["Network","2015–16",15.125452418705212]
["Network","2016–17",14.347429545304882]
["Network","2017–18",13.578666979922252]
["Network","2018–19",13.492294964479525]
["Network","2019–20",13.673151363513961]
["Network","2020–21",12.906858396017055]
["Network","2021–22",12.753959650170945]
["Wholesale electricity","2007–08",8.3108609749640152]
["Wholesale electricity","2008–09",0]
["Wholesale electricity","2009–10",0]
["Wholesale electricity","2010–11",7.9216934738822511]
["Wholesale electricity","2011–12",0]
["Wholesale electricity","2012–13",0]
["Wholesale electricity","2013–14",9.8140019709994419]
["Wholesale electricity","2014–15",7.2216305713260942]
["Wholesale electricity","2015–16",7.2469434887006603]
["Wholesale electricity","2016–17",8.2215830643011216]
["Wholesale electricity","2017–18",10.79741266254835]
["Wholesale electricity","2018–19",10.468500650460738]
["Wholesale electricity","2019–20",10.297943433421256]
["Wholesale electricity","2020–21",9.040741006717802]
["Wholesale electricity","2021–22",7.3784348390592438]
["Environmental","2007–08",0.40022439595299741]
["Environmental","2008–09",0]
["Environmental","2009–10",0]
["Environmental","2010–11",1.2015273010767518]
["Environmental","2011–12",0]
["Environmental","2012–13",0]
["Environmental","2013–14",2.2888614218969416]
["Environmental","2014–15",2.224127320512773]
["Environmental","2015–16",2.3563804714872694]
["Environmental","2016–17",2.4055468572506959]
["Environmental","2017–18",2.5432807753230833]
["Environmental","2018–19",2.7150567867762838]
["Environmental","2019–20",2.8505840628906429]
["Environmental","2020–21",2.9437167485848592]
["Environmental","2021–22",2.8141867659412152]
["Retail & other costs","2007–08",1.9306227487547427]
["Retail & other costs","2008–09",0]
["Retail & other costs","2009–10",0]
["Retail & other costs","2010–11",2.5526400311380284]
["Retail & other costs","2011–12",0]
["Retail & other costs","2012–13",0]
["Retail & other costs","2013–14",3.7256133355404266]
["Retail & other costs","2014–15",3.4091583252758784]
["Retail & other costs","2015–16",3.3698668353089207]
["Retail & other costs","2016–17",3.430760439362718]
["Retail & other costs","2017–18",3.505211026258888]
["Retail & other costs","2018–19",3.4352334536564189]
["Retail & other costs","2019–20",3.1617182806126229]
["Retail & other costs","2020–21",2.76358387037688]
["Retail & other costs","2021–22",2.6557216049586208]
["Retail margin (EBITDA)","2007–08",1.1897859634431931]
["Retail margin (EBITDA)","2008–09",0]
["Retail margin (EBITDA)","2009–10",0]
["Retail margin (EBITDA)","2010–11",2.2737632013232107]
["Retail margin (EBITDA)","2011–12",0]
["Retail margin (EBITDA)","2012–13",0]
["Retail margin (EBITDA)","2013–14",1.7975119692831976]
["Retail margin (EBITDA)","2014–15",2.2079738497141501]
["Retail margin (EBITDA)","2015–16",2.315667055696121]
["Retail margin (EBITDA)","2016–17",2.7826209136025382]
["Retail margin (EBITDA)","2017–18",1.9192624535636591]
["Retail margin (EBITDA)","2018–19",1.3854067397339953]
["Retail margin (EBITDA)","2019–20",0.88231603272914938]
["Retail margin (EBITDA)","2020–21",0.97935804493056944]
["Retail margin (EBITDA)","2021–22",0.65511878610202035]
[]
[]
["Supplementary Table D9.2",null,null,null,null,null,null,null,"Figure D9.2: Change in cost components of the average residential customer effective price across the NEM from 2020–21 to 2021–22, real $2021–22, excluding GST"]
["Residential Customers"]
["c/kWh","2020–21","2021–22","Change"]
["Network",12.906858396017057,12.753959650170946,-0.15289874584611063]
["Wholesale electricity",9.0407410067178038,7.3784348390592447,-1.6623061676585591]
["Environmental",2.9437167485848597,2.8141867659412156,-0.12952998264364401]
["Retail & other costs",2.7635838703768805,2.6557216049586212,-0.10786226541825927]
["Retail margin (EBITDA)",0.97935804493056955,0.65511878610202046,-0.32423925882854909]
["Total Cost Stack",28.634258066627169,26.257421646232046,-2.3768364203951222]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[null,null,null,null,null,null,null,null,"Note: Data labels for small cost components have been omitted for readability. "]
[]
["Supplementary Table D9.3",null,null,null,null,null,null,null,"Figure D9.3: Change in cost components of the average residential customer effective price across the NEM from 2007–08 to 2013–14 to 2021–22, real $2021–22, excluding GST "]
["Residential Customers"]
["c/kWh","2007–08","2013–14","Change","2021–22","Change","Total Change"]
["Network",9.8289701013797153,16.600853093626831,6.7718829922471162,12.753959650170946,-3.846893443455885,2.9249895487912312]
["Wholesale electricity",8.3108609749640152,9.8140019709994402,1.5031409960354249,7.3784348390592447,-2.4355671319401955,-0.93242613590477053]
["Environmental",0.40022439595299741,2.2888614218969416,1.8886370259439442,2.8141867659412156,0.525325344044274,2.4139623699882184]
["Retail & other costs",1.9306227487547427,3.7256133355404262,1.7949905867856835,2.6557216049586212,-1.069891730581805,0.72509885620387848]
["Retail margin (EBITDA)",1.1897859634431931,1.7975119692831973,0.60772600584000425,0.65511878610202046,-1.1423931831811769,-0.53466717734117264]
["Total Cost Stack",21.660464184494664,34.226841791346843,12.566377606852178,26.257421646232046,-7.9694201451147961,4.5969574617373823]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[null,null,null,null,null,null,null,null,"Note: Data labels for small cost components have been omitted for readability. "]
[]
[]
["Supplementary Table D9.4",null,null,null,null,null,null,null,"Figure D9.4: Average small business customer effective price across the NEM from 2007–08 to 2021–22, real $2021–22, excluding GST"]
["Small Business Customers, c/kWh"]
["Variable","Year","NEM"]
["Total Cost Stack","2007–08",19.079034353976397]
["Total Cost Stack","2008–09",0]
["Total Cost Stack","2009–10",0]
["Total Cost Stack","2010–11",23.191116712726519]
["Total Cost Stack","2011–12",0]
["Total Cost Stack","2012–13",0]
["Total Cost Stack","2013–14",30.197253885416835]
["Total Cost Stack","2014–15",28.593233438801391]
["Total Cost Stack","2015–16",27.074956786105602]
["Total Cost Stack","2016–17",28.727178459106046]
["Total Cost Stack","2017–18",30.28823129040541]
["Total Cost Stack","2018–19",30.766550079905539]
["Total Cost Stack","2019–20",29.638519455365198]
["Total Cost Stack","2020–21",27.810011347508208]
["Total Cost Stack","2021–22",25.242563463759407]
["Network","2007–08",7.5635900623172896]
["Network","2008–09",0]
["Network","2009–10",0,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
["Network","2010–11",9.767700600565318]
["Network","2011–12",0]
["Network","2012–13",0]
["Network","2013–14",14.045482034957647]
["Network","2014–15",14.668719527288392]
["Network","2015–16",13.074278151950296]
["Network","2016–17",12.687356261692758]
["Network","2017–18",12.590804823776409]
["Network","2018–19",12.907046325252088]
["Network","2019–20",12.563192616971802]
["Network","2020–21",11.779012664086238]
["Network","2021–22",11.468134231390819]
["Wholesale electricity","2007–08",8.3891718082109232]
["Wholesale electricity","2008–09",0]
["Wholesale electricity","2009–10",0]
["Wholesale electricity","2010–11",8.2629664546027168]
["Wholesale electricity","2011–12",0]
["Wholesale electricity","2012–13",0]
["Wholesale electricity","2013–14",9.6248126993805787]
["Wholesale electricity","2014–15",7.2791344086193046]
["Wholesale electricity","2015–16",7.1960633979269755]
["Wholesale electricity","2016–17",8.8306211955681349]
["Wholesale electricity","2017–18",10.850713828741307]
["Wholesale electricity","2018–19",10.542021083377982]
["Wholesale electricity","2019–20",10.696599492311842]
["Wholesale electricity","2020–21",9.3896644439259056]
["Wholesale electricity","2021–22",8.0985726557551914]
["Environmental","2007–08",0.38250184195219256]
["Environmental","2008–09",0]
["Environmental","2009–10",0]
["Environmental","2010–11",1.1832631946796401]
["Environmental","2011–12",0]
["Environmental","2012–13",0]
["Environmental","2013–14",2.5184644416941553]
["Environmental","2014–15",2.6006882715001804]
["Environmental","2015–16",2.9645488434100953]
["Environmental","2016–17",3.1864450895624628]
["Environmental","2017–18",2.9416112259458154]
["Environmental","2018–19",3.0230978262185371]
["Environmental","2019–20",3.3797256785047223]
["Environmental","2020–21",3.7306460799811063]
["Environmental","2021–22",3.5766607003109292]
["Retail & other costs","2007–08",0.64564462077338469]
["Retail & other costs","2008–09",0]
["Retail & other costs","2009–10",0]
["Retail & other costs","2010–11",0.79565787739857263]
["Retail & other costs","2011–12",0]
["Retail & other costs","2012–13",0]
["Retail & other costs","2013–14",1.7096346580302408]
["Retail & other costs","2014–15",1.6171843463685656]
["Retail & other costs","2015–16",1.6176430028828184]
["Retail & other costs","2016–17",1.5648494495979774]
["Retail & other costs","2017–18",1.6116634572060087]
["Retail & other costs","2018–19",1.8258069073491423]
["Retail & other costs","2019–20",1.6074075294468586]
["Retail & other costs","2020–21",1.4609120117054384]
["Retail & other costs","2021–22",1.3674238438274944]
["Retail margin (EBITDA)","2007–08",2.0981260207226069]
["Retail margin (EBITDA)","2008–09",0]
["Retail margin (EBITDA)","2009–10",0]
["Retail margin (EBITDA)","2010–11",3.1815285854802742]
["Retail margin (EBITDA)","2011–12",0]
["Retail margin (EBITDA)","2012–13",0]
["Retail margin (EBITDA)","2013–14",2.2988600513542115]
["Retail margin (EBITDA)","2014–15",2.4275068850249513]
["Retail margin (EBITDA)","2015–16",2.2224233899354129]
["Retail margin (EBITDA)","2016–17",2.4579064626847162]
["Retail margin (EBITDA)","2017–18",2.2934379547358676]
["Retail margin (EBITDA)","2018–19",2.4685779377077859]
["Retail margin (EBITDA)","2019–20",1.3915941381299701]
["Retail margin (EBITDA)","2020–21",1.4497761478095188]
["Retail margin (EBITDA)","2021–22",0.73177203247497047]
[]
[]
["Supplementary Table D9.5",null,null,null,null,null,null,null,"Figure D9.5  (report figure C6): Change in cost components of the average small business customer effective price across the NEM from 2020–21 to 2021–22, real $2021–22, excluding GST"]
["Small Business Customers"]
["c/kWh","2020–21","2021–22","Change"]
["Network",11.779012664086238,11.46813423139082,-0.31087843269541793]
["Wholesale electricity",9.3896644439259056,8.0985726557551914,-1.2910917881707142]
["Environmental",3.7306460799811063,3.5766607003109296,-0.15398537967017667]
["Retail & other costs",1.4609120117054384,1.3674238438274944,-9.3488167877944006E-2]
["Retail margin (EBITDA)",1.4497761478095188,0.73177203247497058,-0.71800411533454822]
["Total Cost Stack",27.810011347508208,25.24256346375941,-2.5674478837487982]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[null,null,null,null,null,null,null,null,"Note: Data labels for small cost components have been omitted for readability. "]
[]
[]
["Supplementary Table D9.6",null,null,null,null,null,null,null,"Figure D9.6: Average large business customer effective price across the NEM from 2007–08 to 2021–22, real $2021–22, excluding GST"]
["Large Business Customers, c/kWh"]
["Variable","Year","NEM"]
["Total Cost Stack","2007–08",11.358958953005157]
["Total Cost Stack","2008–09",0]
["Total Cost Stack","2009–10",0]
["Total Cost Stack","2010–11",12.827014679690159]
["Total Cost Stack","2011–12",0]
["Total Cost Stack","2012–13",0]
["Total Cost Stack","2013–14",16.632368145897068]
["Total Cost Stack","2014–15",14.599370867047936]
["Total Cost Stack","2015–16",14.243924878287656]
["Total Cost Stack","2016–17",15.548529789958701]
["Total Cost Stack","2017–18",17.609772879969679]
["Total Cost Stack","2018–19",18.285193045378488]
["Total Cost Stack","2019–20",17.709123640655442]
["Total Cost Stack","2020–21",16.035332817885468]
["Total Cost Stack","2021–22",14.531390934045708]
["Network","2007–08",3.955899406259908]
["Network","2008–09",0]
["Network","2009–10",0]
["Network","2010–11",4.7067867654057194,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
["Network","2011–12",0]
["Network","2012–13",0]
["Network","2013–14",7.1625811390477176]
["Network","2014–15",7.2622824058595681]
["Network","2015–16",6.5509611914703942]
["Network","2016–17",6.4263352267453255]
["Network","2017–18",5.8338875875654876]
["Network","2018–19",5.8074934863188874]
["Network","2019–20",5.9270629547188776]
["Network","2020–21",5.6904886567916497]
["Network","2021–22",5.5095872168712869]
["Wholesale electricity","2007–08",6.5321922771923413]
["Wholesale electricity","2008–09",0]
["Wholesale electricity","2009–10",0]
["Wholesale electricity","2010–11",6.6347248500438898]
["Wholesale electricity","2011–12",0]
["Wholesale electricity","2012–13",0]
["Wholesale electricity","2013–14",7.6326814872045068]
["Wholesale electricity","2014–15",5.4782967962936446]
["Wholesale electricity","2015–16",5.6487611408971814]
["Wholesale electricity","2016–17",6.8082236906607667]
["Wholesale electricity","2017–18",8.8082737366924935]
["Wholesale electricity","2018–19",9.6049690471966507]
["Wholesale electricity","2019–20",8.9575684144371426]
["Wholesale electricity","2020–21",7.7881100823015155]
["Wholesale electricity","2021–22",7.3431482810962807]
["Environmental","2007–08",0.33138439852581553]
["Environmental","2008–09",0]
["Environmental","2009–10",0]
["Environmental","2010–11",0.93750083772077575]
["Environmental","2011–12",0]
["Environmental","2012–13",0]
["Environmental","2013–14",1.5403544406746317]
["Environmental","2014–15",1.5632205857150863]
["Environmental","2015–16",1.6860727108894946]
["Environmental","2016–17",1.7283772893434195]
["Environmental","2017–18",2.0825590093654389]
["Environmental","2018–19",2.2185568322492251]
["Environmental","2019–20",2.3301938365702504]
["Environmental","2020–21",2.1989909582694303]
["Environmental","2021–22",1.9348100756254973]
["Retail & other costs","2007–08",9.2346506328616143E-2]
["Retail & other costs","2008–09",0]
["Retail & other costs","2009–10",0]
["Retail & other costs","2010–11",9.4656702408293492E-2]
["Retail & other costs","2011–12",0]
["Retail & other costs","2012–13",0]
["Retail & other costs","2013–14",0.24305904914144505]
["Retail & other costs","2014–15",0.25761192049480641]
["Retail & other costs","2015–16",0.30838355027779601]
["Retail & other costs","2016–17",0.29434542759460647]
["Retail & other costs","2017–18",0.36304257086049091]
["Retail & other costs","2018–19",0.23023455586033834]
["Retail & other costs","2019–20",0.2323504240564489]
["Retail & other costs","2020–21",0.24012360337433858]
["Retail & other costs","2021–22",0.21023485046954921]
["Retail margin (EBITDA)","2007–08",0.44713636469847551]
["Retail margin (EBITDA)","2008–09",0]
["Retail margin (EBITDA)","2009–10",0]
["Retail margin (EBITDA)","2010–11",0.45334552411148071]
["Retail margin (EBITDA)","2011–12",0]
["Retail margin (EBITDA)","2012–13",0]
["Retail margin (EBITDA)","2013–14",5.3692029828766717E-2]
["Retail margin (EBITDA)","2014–15",3.795915868482954E-2]
["Retail margin (EBITDA)","2015–16",4.9746284752791622E-2]
["Retail margin (EBITDA)","2016–17",0.29124815561458367]
["Retail margin (EBITDA)","2017–18",0.52200997548577088]
["Retail margin (EBITDA)","2018–19",0.42393912375338783]
["Retail margin (EBITDA)","2019–20",0.26194801087272124]
["Retail margin (EBITDA)","2020–21",0.11761951714853154]
["Retail margin (EBITDA)","2021–22",-0.46638949001690572]
[]
[]
["Supplementary Table D9.7",null,null,null,null,null,null,null,"Figure D9.7: Change in cost components of the average large business customer effective price across the NEM from 2020–21 to 2021–22, real $2021–22, excluding GST"]
["Large Business Customers"]
["c/kWh","2020–21","2021–22","Change"]
["Network",5.6904886567916506,5.5095872168712869,-0.18090143992036367]
["Wholesale electricity",7.7881100823015164,7.3431482810962807,-0.44496180120523565]
["Environmental",2.1989909582694307,1.9348100756254973,-0.26418088264393336]
["Retail & other costs",0.24012360337433861,0.21023485046954921,-2.9888752904789401E-2]
["Retail margin (EBITDA)",0.11761951714853157,-0.46638949001690572,-0.58400900716543724]
["Total Cost Stack",16.035332817885468,14.531390934045708,-1.5039418838397598]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[null,null,null,null,null,null,null,null,"Note: Data labels for small cost components have been omitted for readability. Retail margin in 2021-22 was negative, shown as the yellow section below 0 in 2021-22."]
[]
[]
["Supplementary Table D9.8",null,null,null,null,null,null,null,"Figure D9.8: Comparison of the average residential, small business customer and large business customer effective price across the NEM in 2021–22, real $2021–22, excluding GST "]
["2021-22"]
["c/kWh","Residential","Small Business","Large Business"]
["Network",12.753959650170946,11.46813423139082,5.5095872168712869]
["Wholesale electricity",7.3784348390592447,8.0985726557551914,7.3431482810962807]
["Environmental",2.8141867659412156,3.5766607003109296,1.9348100756254973]
["Retail & other costs",2.6557216049586212,1.3674238438274944,0.21023485046954921]
["Retail margin (EBITDA)",0.65511878610202046,0.73177203247497058,-0.46638949001690572]
["Total Cost Stack",26.257421646232046,25.24256346375941,14.531390934045708]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[null,null,null,null,null,null,null,null,"Note: Data labels for small cost components have been omitted for readability. Retail margin in 2021-22 was negative, shown as the yellow section below 0 under Large business."]

{"sheet":"10. Regional ckWh","index":15,"n_rows":257,"n_cols":10,"rows_kept":257,"cut":false,"hidden":false,"merged":[]}
["Regional cost stacks, c/kWh"]
[{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
[]
["Supplementary Table D10.1A",null,null,null,null,null,null,null,null,"Figure D10.1: Average residential customer effective prices by NEM regions, 2021–22, real $2021–22, excluding GST "]
["Residential Customers 2021-22"]
["c/kWh","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["Network",12.320074571969281,12.75135252232681,16.474189623457043,11.906419439989369,11.698492219286074,12.753959650170945]
["Wholesale electricity",8.2119233940379956,7.1346962102784754,7.62521779120177,6.549389836987209,7.6402317142992189,7.3784348390592438]
["Environmental",3.3712635692841864,2.3886507234095333,3.5833849863146101,2.8207585384616896,2.3941218013682075,2.8141867659412152]
["Retail & other costs",3.3726519850316943,2.3642357945852259,2.9048183617456873,2.3490453426774076,0,2.6557216049586208]
["Retail margin (EBITDA)",1.1249074664812071,0.70307416773096187,0.64001346452230412,-0.17920145477716046,0,0.65511878610202035]
["Retail component",0,0,0,0,2.6954005886936288,0]
["Total Cost Stack",28.400820986804362,25.342009418331006,31.227624227241414,23.446411703338512,24.42824632364713,26.257421646232043]
[]
[]
["Supplementary Table D10.1B"]
["Residential Customers 2021-22"]
["% of cost stack","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["Network",0.43379290259578956,0.50317053836714254,0.52755180809066438,0.50781414190957097,0.47889201968467349,0.48572780001044569]
["Wholesale electricity",0.28914387361736599,0.28153632541536472,0.24418180953227664,0.27933442097046551,0.31276218575310871,0.28100378393847569]
["Environmental",0.11870303224158726,9.4256563636256702E-2,0.11475048374601116,0.12030661979973867,9.8006290326728862E-2,0.10717681285911988]
["Retail & other costs",0.11875191870681139,9.3293146394108295E-2,9.3020792763724547E-2,0.10018783993044571,0,0.10114175111095565]
["Retail margin (EBITDA)",3.9608272838445889E-2,2.7743426187127725E-2,2.0495105867323345E-2,-7.6430226102207413E-3,0,2.4949852081003174E-2]
["Retail component",0,0,0,0,0.11,0,null,null,"Source: ACCC analysis based on retailers’ data."]
[null,null,null,null,null,null,null,null,null,"Note: Small negative EBITDA for 2021–22 SEQ not shown for readability. The small negative EBITDA for 2021–22 SEQ means that actual total cost stack is lower than the sum of the cost components shown."]
[]
[]
["Supplementary Table D10.2",null,null,null,null,null,null,null,null,"Figure D10.2: Average residential customer effective prices by NEM regions, 2007–08 to 2021–22, real $2021–22, excluding GST "]
["Residential Customers, c/kWh"]
["Variable","Year","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["Total Cost Stack","2007-08",23.322430744022189,21.297673931329413,25.016848085453034,19.517216850466205,17.13039227614825,21.660464184494664]
["Total Cost Stack","2008-09",0,0,0,0,0,0]
["Total Cost Stack","2009-10",0,0,0,0,0,0]
["Total Cost Stack","2010-11",27.137987205748274,27.072675932527421,27.309497861759287,24.648373031593607,21.253982876247587,26.464165061137582]
["Total Cost Stack","2011-12",0,0,0,0,0,0]
["Total Cost Stack","2012-13",0,0,0,0,0,0]
["Total Cost Stack","2013–14",36.321151816406221,33.078544246661146,38.610409106680642,33.04871398554863,26.166931258588903,34.226841791346843]
["Total Cost Stack","2014–15",33.701754002975221,29.582819975365446,36.732424664117055,33.342580222954943,24.296873942296639,31.898339180048776]
["Total Cost Stack","2015–16",32.407749863324774,27.536211550258301,33.969854505980841,33.00425468569729,24.990686265128417,30.414310269898184]
["Total Cost Stack","2016–17",31.01368255422036,29.734722144409407,36.891882419204173,32.722521693234128,26.094051758036237,31.187940819821957]
["Total Cost Stack","2017–18",32.554359149544048,31.858285191705288,39.756625399298784,30.86172676478116,25.337127245393553,32.343833897616229]
["Total Cost Stack","2018–19",33.422473153402649,30.4534291000442,38.386360027563533,28.600199779789676,24.853531069328753,31.496492595106961]
["Total Cost Stack","2019–20",33.490180756329877,29.277685915104602,38.247104244657805,27.671456229249827,27.364366000176055,30.865713173167634]
["Total Cost Stack","2020–21",31.732608345742005,27.455809222668201,34.563498690570846,25.090147080557813,22.004155082480583,28.634258066627169]
["Total Cost Stack","2021–22",28.400820986804362,25.342009418331006,31.227624227241414,23.446411703338512,21.7328457349535,26.257421646232043]
["Network","2007-08",9.9924860357259959,9.3948260373660766,11.457262509451109,9.2497981227219164,8.7604733812808071,9.8289701013797153]
["Network","2008-09",0,0,0,0,0,0]
["Network","2009-10",0,0,0,0,0,0,null,"Source: ACCC analysis based on retailers’ data."]
["Network","2010-11",10.063238800786761,15.293576299256241,12.287105523148327,11.578236767211452,11.835583318587677,12.514541053717339,null,"Note: Small negative EBITDA for 2021–22 SEQ not shown for readability. The small negative EBITDA for 2021–22 SEQ means that actual total cost stack is lower than the sum of the cost components shown."]
["Network","2011-12",0,0,0,0,0,0]
["Network","2012-13",0,0,0,0,0,0]
["Network","2013–14",15.218195498433264,17.168550720023745,18.087959968447002,17.074548909690396,14.270506128210224,16.600853093626831]
["Network","2014–15",16.214908096059197,16.306888513477343,18.450878530603077,18.843164417655945,14.3020534922476,16.835449113219877]
["Network","2015–16",15.461237136666405,13.847545454134831,15.279057629456089,17.845800798809378,14.350050444133384,15.125452418705212]
["Network","2016–17",13.212043172782044,14.004710998722839,15.26793406067457,16.353637786874454,14.84634416555555,14.347429545304882]
["Network","2017–18",12.886937392322329,13.64999232751909,15.692694725732476,13.922571574309176,11.688215763669346,13.578666979922252]
["Network","2018–19",12.672731392667728,13.643751283056634,16.552204553443023,13.15661954825233,12.398547732549833,13.492294964479525]
["Network","2019–20",13.571347632630573,12.931962234104407,18.124896821872234,13.781900664348228,12.969985621924328,13.673151363513961]
["Network","2020–21",13.060413166185183,12.556309691932491,17.401392535053777,12.068230178168948,10.801182357308937,12.906858396017055]
["Network","2021–22",12.320074571969281,12.75135252232681,16.474189623457043,11.906419439989369,11.698492219286074,12.753959650170945]
["Wholesale electricity","2007-08",8.4925668346659631,8.2209584536296525,10.185070917162006,7.226248596121791,8.2070250812354058,8.3108609749640152]
["Wholesale electricity","2008-09",0,0,0,0,0,0]
["Wholesale electricity","2009-10",0,0,0,0,0,0]
["Wholesale electricity","2010-11",8.3429517377326192,6.910635675201946,10.14227620756184,7.5409920634434515,8.9893641085118059,7.9216934738822511]
["Wholesale electricity","2011-12",0,0,0,0,0,0]
["Wholesale electricity","2012-13",0,0,0,0,0,0]
["Wholesale electricity","2013–14",11.4954224462669,8.9430019706162849,11.777892713117247,8.4826578035989399,9.9991923318806997,9.8140019709994419]
["Wholesale electricity","2014–15",7.6156208028123391,6.4328471440387283,10.408755135387164,6.7733543032629138,7.9541698600779274,7.2216305713260942]
["Wholesale electricity","2015–16",6.8817411873710714,6.3914361671252662,10.174331767367333,8.2013366771697651,8.0818334373802792,7.2469434887006603]
["Wholesale electricity","2016–17",7.3528603424020487,7.3999894281569496,12.276829242607519,9.4382291022060603,8.9250720035914526,8.2215830643011216]
["Wholesale electricity","2017–18",10.151481700370613,10.089166457915807,15.666781212294156,11.072759325286373,11.210301298257464,10.79741266254835]
["Wholesale electricity","2018–19",11.43049647929341,9.4847384582111776,13.482663869766554,10.090653158015034,10.065068236092092,10.468500650460738]
["Wholesale electricity","2019–20",11.877170269209889,9.4667591250693697,12.351817042668314,8.6525135500589538,11.838037297231802,10.297943433421256]
["Wholesale electricity","2020–21",10.586420128857798,8.478479721130288,10.314585772901639,7.5899708771923029,8.9223495713362961,9.040741006717802]
["Wholesale electricity","2021–22",8.2119233940379956,7.1346962102784754,7.62521779120177,6.549389836987209,7.6402317142992189,7.3784348390592438]
["Environmental","2007-08",0.17285666334288269,1.5478238052991109,0.2139686917964618,0.41619347849575317,0.16289381363203853,0.40022439595299741]
["Environmental","2008-09",0,0,0,0,0,0]
["Environmental","2009-10",0,0,0,0,0,0]
["Environmental","2010-11",1.2897762833022341,1.3918826744563186,0.97386990090586445,1.0534943395124106,0.42903544914810704,1.2015273010767518]
["Environmental","2011-12",0,0,0,0,0,0]
["Environmental","2012-13",0,0,0,0,0,0]
["Environmental","2013–14",1.9301899498829469,2.2752980870850319,4.0598116367382548,2.0615143249981509,1.8972327984979807,2.2888614218969416]
["Environmental","2014–15",1.9868538325138567,2.0324717341791905,4.2300031043780697,2.0795383003610826,2.0406505899711109,2.224127320512773]
["Environmental","2015–16",2.0943797599764409,2.0449523455262923,3.8322904755981266,2.7151436071265977,2.5588023836147533,2.3563804714872694]
["Environmental","2016–17",2.1687722214092471,2.0387590927972372,4.0136605178160538,2.9110395023756022,2.3226355888892356,2.4055468572506959]
["Environmental","2017–18",2.683829092494836,2.5065918859255381,4.0639088990760346,1.726502625187103,2.4386101834667442,2.5432807753230833]
["Environmental","2018–19",2.8395558430801531,2.7063309365383459,4.1516537027434728,1.9503769672049807,2.3899151006868276,2.7150567867762838]
["Environmental","2019–20",3.0598772837590809,2.7947932615808666,4.3525239415403236,2.0241736550058551,2.5563430810199264,2.8505840628906429]
["Environmental","2020–21",3.1007549479790302,2.7176777692697427,3.9910244566259796,2.9841805313301055,2.2806231538353505,2.9437167485848592]
["Environmental","2021–22",3.3712635692841864,2.3886507234095333,3.5833849863146101,2.8207585384616896,2.3941218013682075,2.8141867659412152]
["Retail & other costs","2007-08",2.1159155428299363,2.1340656350345748,1.595792039705604,1.9694624023340295,0,1.9306227487547427]
["Retail & other costs","2008-09",0,0,0,0,0,0]
["Retail & other costs","2009-10",0,0,0,0,0,0]
["Retail & other costs","2010-11",2.9200307544220774,2.6275026906389258,2.0693483336727998,2.358695084721099,0,2.5526400311380284]
["Retail & other costs","2011-12",0,0,0,0,0,0]
["Retail & other costs","2012-13",0,0,0,0,0,0]
["Retail & other costs","2013–14",4.6742530782899765,3.7362318838624162,3.5677092371269339,2.8338039110451168,0,3.7256133355404266]
["Retail & other costs","2014–15",4.5328022866998214,3.0011492770524031,3.6372731837430794,3.0431054370404604,0,3.4091583252758784]
["Retail & other costs","2015–16",4.512877725324107,2.9614335154949529,3.5903563485046739,2.9006078724346369,0,3.3698668353089207]
["Retail & other costs","2016–17",4.4194616249359564,3.0658442108033883,3.6220957489468524,3.1439624827453283,0,3.430760439362718]
["Retail & other costs","2017–18",4.4437940247738572,3.0898230487446221,3.6973911520154199,3.457314682984256,0,3.505211026258888]
["Retail & other costs","2018–19",4.390755105022853,3.0747169422226528,3.726892872907793,3.122966825684335,0,3.4352334536564189]
["Retail & other costs","2019–20",3.9036077561856084,2.8118200371143183,3.374209690826504,3.0418648673298136,0,3.1617182806126229]
["Retail & other costs","2020–21",3.4827526424490141,2.4746883895857801,3.153212593222773,2.4889463163842329,0,2.76358387037688]
["Retail & other costs","2021–22",3.3726519850316943,2.3642357945852259,2.9048183617456873,2.3490453426774076,0,2.6557216049586208]
["Retail margin (EBITDA)","2007-08",2.5486056674574091,0,1.5647539273378548,0.65551425079271375,0,1.1897859634431931]
["Retail margin (EBITDA)","2008-09",0,0,0,0,0,0]
["Retail margin (EBITDA)","2009-10",0,0,0,0,0,0]
["Retail margin (EBITDA)","2010-11",4.5219896295045832,0.84907859297398836,1.8368978964704552,2.1169547767051919,0,2.2737632013232107]
["Retail margin (EBITDA)","2011-12",0,0,0,0,0,0]
["Retail margin (EBITDA)","2012-13",0,0,0,0,0,0]
["Retail margin (EBITDA)","2013–14",3.003090843533132,0.95546158507366186,1.1170355512512069,2.5961890362160309,0,1.7975119692831976]
["Retail margin (EBITDA)","2014–15",3.3515689848900094,1.8094633066177828,5.5147100056720747E-3,2.6034177646345431,0,2.2079738497141501]
["Retail margin (EBITDA)","2015–16",3.4575140539867553,2.2908440679769537,1.093818285054619,1.3413657301569122,0,2.315667055696121]
["Retail margin (EBITDA)","2016–17",3.8605451926910646,3.2254184139289919,1.7113628491591766,0.87565281903268322,0,2.7826209136025382]
["Retail margin (EBITDA)","2017–18",2.3883169395824151,2.5227114716002332,0.63584941018069574,0.6825785570142513,0,1.9192624535636591]
["Retail margin (EBITDA)","2018–19",2.0889343333385098,1.543891480015386,0.472945028702698,0.27958328063299842,0,1.3854067397339953]
["Retail margin (EBITDA)","2019–20",1.0781778145447212,1.2723512572356388,4.3656747750426085E-2,0.17100349250697555,0,0.88231603272914938]
["Retail margin (EBITDA)","2020–21",1.5022674602709789,1.2286536507499006,-0.29671666723332507,-4.1180822517778021E-2,0,0.97935804493056944]
["Retail margin (EBITDA)","2021–22",1.1249074664812071,0.70307416773096187,0.64001346452230412,-0.17920145477716046,0,0.65511878610202035]
["Retail component","2007-08",0,0,0,0,1.4356101077450554,0]
["Retail component","2008-09",0,0,0,0,0,0]
["Retail component","2009-10",0,0,0,0,0,0]
["Retail component","2010-11",0,0,0,0,2.1849372939753366,0]
["Retail component","2011-12",0,0,0,0,0,0]
["Retail component","2012-13",0,0,0,0,0,0]
["Retail component","2013–14",0,0,0,0,3.2177267134684668,0]
["Retail component","2014–15",0,0,0,0,3.7896150467261691,0]
["Retail component","2015–16",0,0,0,0,3.6444106838989252,0]
["Retail component","2016–17",0,0,0,0,3.2036888752589019,0]
["Retail component","2017–18",0,0,0,0,2.2608203475407116,0]
["Retail component","2018–19",0,0,0,0,3.7987849453482427,0]
["Retail component","2019–20",0,0,0,0,2.4847001506115212,0]
["Retail component","2020–21",0,0,0,0,3.508945083488431,0]
["Retail component","2021–22",0,0,0,0,2.6954005886936288,0]
[]
[]
["Supplementary Table D10.3A",null,null,null,null,null,null,null,null,"Figure D10.3: Average small business customer effective prices by NEM regions, 2021–22, real $2021–22, excluding GST "]
["Small Business Customers 2021-22"]
["c/kWh","Victoria","NSW","SA","SEQ","NEM"]
["Network",11.232075769847988,12.065964366949572,14.068027392923275,8.52820388984936,11.468134231390819]
["Wholesale electricity",8.7228755368787958,7.5987849963774581,8.9585623259282414,7.860062883446469,8.0985726557551914]
["Environmental",3.3836542883295766,3.4966088019002304,3.2064374582799466,4.6794838736829787,3.5766607003109292]
["Retail & other costs",1.7021173182930935,1.1466677088224897,1.4507945093142331,1.1044922062754425,1.3674238438274944]
["Retail margin (EBITDA)",-0.33678399965008959,1.638645942021701,1.7501346550033747,-0.14638588890773632,0.73177203247497047]
["Retail component",0,0,0,0,0]
["Total Cost Stack",24.703938913699364,25.946671816071451,29.433956341449072,22.025856964346513,25.242563463759407]
[]
[]
["Supplementary Table D10.3B"]
["Small Business Customers 2021-22"]
["% of cost stack","Victoria","NSW","SA","SEQ","NEM"]
["Network",0.45466740381305482,0.46502936686761792,0.47795230888185408,0.38719055987942053,0.45431733777179756]
["Wholesale electricity",0.35309654737049229,0.29286164523307945,0.30436147359886989,0.35685616664857289,0.32083004039515489]
["Environmental",0.13696820981261409,0.1347613607898035,0.10893667915667261,0.21245411160427077,0.14169165922652505]
["Retail & other costs",6.8900644720635965E-2,4.4193248249752022E-2,4.9289823375568975E-2,5.0145254646086899E-2,5.4171354101602891E-2]
["Retail margin (EBITDA)",-1.3632805716797205E-2,6.3154378859747187E-2,5.9459714987034368E-2,-6.64609277835104E-3,2.8989608504919523E-2]
["Retail component",0,0,0,0,0,null,null,null,"Source: ACCC analysis based on retailers’ data. "]
[null,null,null,null,null,null,null,null,null,"Note: Data labels for small cost components have been omitted for readability. "]
[null,null,null,null,null,null,null,null,null,"Note: Small negative EBITDA for 2021–22 Victoria and SEQ not shown for readability. The small negative EBITDA for 2021–22 Victoria and SEQ means that actual total cost stack is lower than the sum of the cost components shown."]
[]
["Supplementary Table D10.4",null,null,null,null,null,null,null,null,"Figure D10.4: Change in cost components of the average Victorian small business customer effective price, 2019–20 to 2021–22, real $2021–22, excluding GST "]
["Small Business Customers, Victoria"]
["c/kWh","2019–20","2020–21","Change","2021–22","Change","Total Change"]
["Network",12.446221353126532,12.251055327631283,-0.19516602549524897,11.232075769847988,-1.018979557783295,-1.2141455832785439]
["Wholesale electricity",11.980400520012692,10.618086960780809,-1.3623135592318825,8.7228755368787958,-1.8952114239020137,-3.2575249831338962]
["Environmental",2.9281681711512526,2.9960637186111767,6.7895547459924099E-2,3.3836542883295766,0.38759056971839989,0.45548611717832399]
["Retail & other costs",1.7595400826106433,1.7521889094343894,-7.351173176253889E-3,1.7021173182930935,-5.007159114129589E-2,-5.7422764317549779E-2]
["Retail margin (EBITDA)",0.22925715304783695,0.40098751120388609,0.17173035815604915,-0.33678399965008959,-0.73777151085397574,-0.56604115269792654]
["Total Cost Stack",29.343587279948959,28.018382427661543,-1.3252048522874169,24.703938913699364,-3.3144435139621784,-4.6396483662495953]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[null,null,null,null,null,null,null,null,null,"Note: Data labels for small cost components have been omitted for readability. "]
[null,null,null,null,null,null,null,null,null,"Note: Small negative EBITDA for 2021–22 not shown for readability. The small negative EBITDA for 2021–22 means that actual total cost stack is lower than the sum of the cost components shown."]
[]
[]
["Supplementary Table D10.5",null,null,null,null,null,null,null,null,"Figure D10.5: Change in cost components of the average NSW small business customer effective price, 2019–20 to 2021–22, real $2021–22, excluding GST "]
["Small Business Customers, NSW"]
["c/kWh","2019–20","2020–21","Change","2021–22","Change","Total Change"]
["Network",11.644162350229555,11.553517002633654,-9.0645347595900816E-2,12.065964366949574,0.51244736431591953,0.42180201672001871]
["Wholesale electricity",9.6087056309681227,8.6507448971826086,-0.95796073378551405,7.5987849963774599,-1.0519599008051488,-2.0099206345906628]
["Environmental",4.1333173640189855,3.9419931901702139,-0.19132417384877165,3.4966088019002313,-0.44538438826998261,-0.63670856211875426]
["Retail & other costs",1.521152373349999,1.3672912289026888,-0.15386114444731014,1.1466677088224899,-0.22062352008019892,-0.37448466452750906]
["Retail margin (EBITDA)",2.5412018189380925,2.4267478911847538,-0.11445392775333874,1.6386459420217012,-0.78810194916305254,-0.90255587691639128]
["Total Cost Stack",29.448539537504754,27.940294210073919,-1.5082453274308349,25.946671816071454,-1.9936223940024647,-3.5018677214332996]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
["Supplementary Table D10.6",null,null,null,null,null,null,null,null,"Figure D10.6: Change in cost components of the average SA small business customer effective price, 2019–20 to 2021–22, real $2021–22, excluding GST "]
["Small Business Customers, SA"]
["c/kWh","2019–20","2020–21","Change","2021–22","Change","Total Change"]
["Network",17.107498811072041,15.883673056169163,-1.2238257549028777,14.068027392923275,-1.8156456632458884,-3.0394714181487661]
["Wholesale electricity",12.966531701769659,11.032710473064142,-1.9338212287055168,8.9585623259282414,-2.0741481471359009,-4.0079693758414177]
["Environmental",3.7903006175552099,3.4580554323353878,-0.33224518521982205,3.2064374582799466,-0.25161797405544117,-0.58386315927526322]
["Retail & other costs",1.6702862023913458,1.4643468159480608,-0.20593938644328502,1.4507945093142331,-1.3552306633827671E-2,-0.21949169307711269]
["Retail margin (EBITDA)",1.1650294024414924,0.20734193398406361,-0.9576874684574288,1.7501346550033747,1.5427927210193111,0.58510525256188228]
["Total Cost Stack",36.699646735229749,32.046127711500823,-4.6535190237289257,29.433956341449072,-2.612171370051751,-7.2656903937806767]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[null,null,null,null,null,null,null,null,null,"Note: Data labels for small cost components have been omitted for readability. "]
[]
[]
[]
["Supplementary Table D10.7",null,null,null,null,null,null,null,null,"Figure D10.7: Change in cost components of the average SEQ small business customer effective price, 2019–20 to 2021–22, real $2021–22, excluding GST "]
["Small Business Customers, SEQ"]
["c/kWh","2019–20","2020–21","Change","2021–22","Change","Total Change"]
["Network",12.686803548687049,8.7430244208852947,-3.9437791278017542,8.52820388984936,-0.21482053103593479,-4.158599658837689]
["Wholesale electricity",9.6473407479639786,8.2372699505338112,-1.4100707974301674,7.860062883446469,-0.3772070670873422,-1.7872778645175096]
["Environmental",2.0114222238318082,5.1302710506746338,3.1188488268428256,4.6794838736829787,-0.45078717699165516,2.6680616498511704]
["Retail & other costs",1.3220154934403585,1.0496008246076738,-0.27241466883268473,1.1044922062754425,5.4891381667768746E-2,-0.21752328716491598]
["Retail margin (EBITDA)",1.4655003437225314,1.4992777451345813,3.377740141204999E-2,-0.14638588890773632,-1.6456636340423176,-1.6118862326302676]
["Total Cost Stack",27.133082357645723,24.659443991835992,-2.4736383658097303,22.025856964346513,-2.6335870274894795,-5.1072253932992098]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[null,null,null,null,null,null,null,null,null,"Note: Data labels for small cost components have been omitted for readability. "]
[null,null,null,null,null,null,null,null,null,"Note: Small negative EBITDA for 2021–22 not shown for readability. The small negative EBITDA for 2021–22 means that actual total cost stack is lower than the sum of the cost components shown."]

{"sheet":"11. Network","index":16,"n_rows":89,"n_cols":9,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
["Network cost component"]
[{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
[]
["Supplementary Table D11.1a",null,null,null,null,null,null,null,"Figure D11.1: Average network costs per residential customer by NEM regions, 2013–14 to 2021–22, real $2021–22, excluding GST"]
["Residential Customers - Aggregate network costs"]
["$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["2013–14",724.39159005470026,1002.372570594461,895.82368679389288,1016.5088860705658,1113.1051603844078,915.14459784953556]
["2014–15",764.4702659605249,976.25211806694153,917.73548265280795,1117.1069926642292,1093.9933869215477,932.20045414608398]
["2015–16",735.66488042151286,833.90486489118052,762.04362342303671,1040.5107908864272,1063.0354681227611,837.49920412853396]
["2016–17",627.95098941338324,835.55860836730665,717.79140359242217,940.8654987280886,1125.3927040262326,786.34705524562332]
["2017–18",598.22330586939529,789.40068857424524,718.97049632136248,784.19699009100941,902.79889303624702,725.92112983583456]
["2018–19",574.06722194710574,775.4746920806989,753.93992001801678,736.31773558651093,940.87276579162187,710.24239861804779]
["2019–20",619.55278397512802,732.1913382256696,834.31172104836492,755.02820470239362,994.53606328953822,719.68985926876201]
["2020–21",599.90126990695057,712.96577793985671,779.65997137004115,679.09998649960812,915.77936177942854,685.99023798691223]
["2021–22",567.56250334646506,731.59670017790233,754.70109249558936,650.10828799533988,932.70859428515598,677.17575932914212]
[]
[]
["Supplementary Table D11.1b"]
["Residential Customers - Distribution costs"]
["$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["2017–18",449.81432048305254,614.98283016943151,540.79840269095621,653.03162386117197,620.83698055743832,563.21036818460186]
["2018–19",431.65094843046245,609.25002472614301,565.10508185537719,612.36158021237645,674.32466196333428,553.10397049745904]
["2019–20",458.83828893931832,581.78543265468272,629.05207624191326,626.41445182413133,723.81078978010066,560.94310321442265]
["2020–21",424.39303835508144,559.58117258007326,581.3189061168755,535.70337324757566,672.40388390847124,520.61157311669263,null,"Source: ACCC analysis based on retailers’ data. "]
["2021–22",399.86094232326775,565.52271625672927,553.99073958153463,505.07268213376994,714.62556407096145,509.26862690537945,null,"Note: Network proportions for distribution, transmission and metering were provided by distribution operators from 2016–17 onwards."]
[]
[]
["Supplementary Table D11.1c"]
["Residential Customers - Transmission costs"]
["$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["2017–18",107.88859900345517,158.41812041287116,161.39192567589629,131.16536622983762,244.78764693937828,141.10197195930564]
["2018–19",103.53208860639171,150.54955075275194,169.28468409873346,123.9561553741345,230.39416580218395,135.98138376684562]
["2019–20",117.02028339350417,131.15458533682946,185.59554028521151,128.6137528782622,234.50977796257266,134.75763048833855]
["2020–21",136.1354388124885,135.40446265968674,185.72652828187458,143.39661325203247,209.3932024441431,143.92462571659109]
["2021–22",138.06988267849459,153.78881873560573,188.90137498413151,145.03560586156991,187.05419119147726,151.93020605223563]
[]
[]
["Supplementary Table D11.1d"]
["Residential Customers - Metering costs"]
["$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["2017–18",40.520386382887366,15.999737991942641,16.780167954510055,0,37.174265539430387,21.608789691927086]
["2018–19",38.884184910251463,15.675116601803936,19.550154063906053,0,36.153938026103589,21.157044353743149]
["2019–20",43.694211642305667,19.251320234157458,19.664104521240098,0,36.215495546864908,23.989125566000759]
["2020–21",39.37279273938065,17.98014270009665,12.614536971290995,0,33.982275426814084,21.454039153628557]
["2021–22",29.631678344702713,12.285165185567543,11.808977929923239,0,31.028839022717172,15.97692637152716]
[]
[]
["Supplementary Table D11.2a",null,null,null,null,null,null,null,"Figure D11.2: Average effective price for network costs per residential customer by NEM regions, 2013–14 to 2021–22, real $2021–22, excluding GST"]
["Residential Customers - Aggregate network costs"]
["c/kWh","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["2013–14",15.218195498433264,17.168550720023745,18.087959968447002,17.074548909690396,14.270506128210224,16.600853093626831]
["2014–15",16.214908096059197,16.306888513477343,18.450878530603077,18.843164417655945,14.3020534922476,16.835449113219877]
["2015–16",15.461237136666405,13.847545454134831,15.279057629456089,17.845800798809378,14.350050444133384,15.125452418705212]
["2016–17",13.212043172782044,14.004710998722839,15.26793406067457,16.353637786874454,14.84634416555555,14.347429545304882]
["2017–18",12.886937392322329,13.64999232751909,15.692694725732476,13.922571574309176,11.688215763669346,13.578666979922252]
["2018–19",12.672731392667728,13.643751283056634,16.552204553443023,13.15661954825233,12.398547732549833,13.492294964479525]
["2019–20",13.571347632630573,12.931962234104407,18.124896821872234,13.781900664348228,12.969985621924328,13.673151363513961]
["2020–21",13.060413166185183,12.556309691932491,17.401392535053777,12.068230178168948,10.801182357308937,12.906858396017055]
["2021–22",12.320074571969281,12.75135252232681,16.474189623457043,11.906419439989369,11.698492219286074,12.753959650170945]
[]
[]
["Supplementary Table D11.2b"]
["Residential Customers - Distribution costs"]
["c/kWh","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["2017–18",9.6899083157764121,10.634030391498943,11.803800413250361,11.593871996931998,8.0377552949978917,10.535092195136412]
["2018–19",9.5288431663035116,10.719183864345343,12.406472532767388,10.941755097618802,8.8860543237783425,10.507176043695663]
["2019–20",10.050885231123205,10.275493372640229,13.665760278595247,11.434250662404372,9.4393917756892183,10.657173861478286]
["2020–21",9.2394343933123579,9.8549954543299734,12.974577180885818,9.5199407216849163,7.9306842575553373,9.7952703718693872,null,"Source: ACCC analysis based on retailers’ data. "]
["2021–22",8.6797781720849976,9.8567687806954467,12.09293133964656,9.2501623378906945,8.9631870577909112,9.5915889326631572,null,"Note: Network proportions for distribution, transmission and metering were provided by distribution operators from 2016–17 onwards."]
[]
[]
["Supplementary Table D11.2c"]
["Residential Customers - Transmission costs"]
["c/kWh","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["2017–18",2.3241381722537562,2.7393010412510002,3.5226399884118482,2.3286995773771793,3.1691784912207406,2.6393730788343808]
["2018–19",2.2855064690517497,2.6487784156245628,3.7165225564661175,2.2148644506335282,3.0360673258471462,2.5832039076098998]
["2019–20",2.5633375994416427,2.3164520745569774,4.0319462539039232,2.3476500019438564,3.0582987994571491,2.5602159809888998]
["2020–21",2.963796155535396,2.3846591511551578,4.1452688883417697,2.548289456484031,2.4696933108270254,2.707931776514926]
["2021–22",2.9970818028190265,2.6804596592809493,4.1234829292877091,2.6562571020986749,2.3461261251864638,2.8614605454158664]
[]
[]
["Supplementary Table D11.2d"]
["Residential Customers, Tasmania"]
["c/kWh","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["2017–18",0.87289090429215643,0.27666089476914862,0.36625432407026698,0,0.48128197745071383,0.4042017059514586]
["2018–19",0.85838175731246324,0.27578900308672993,0.42920946420951606,0,0.47642608292434152,0.40191501317396139]
["2019–20",0.95712480206572648,0.34001678690719878,0.42719028937306158,0,0.47229504677796175,0.45576152104677564]
["2020–21",0.85718261733742918,0.3166550864473574,0.28154646582618931,0,0.4008047889265749,0.4036562476327431]
["2021–22",0.64321459706525619,0.21412408235041935,0.257775354522773,0,0.38917903630869755,0.300910172091921]

{"sheet":"12. Wholesale","index":17,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Wholesale electricity cost component"]
[{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
[]
["Supplementary Table D12.1",null,null,null,null,null,null,null,"Figure D12.1: Average effective price for wholesale costs per residential customer by NEM regions, 2013–14 to 2021–22, real $2021–22, excluding GST"]
["Residential Customers"]
["c/kWh","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["2013–14",11.4954224462669,8.9430019706162849,11.777892713117247,8.4826578035989399,9.9991923318806997,9.8140019709994419]
["2014–15",7.6156208028123391,6.4328471440387283,10.408755135387164,6.7733543032629138,7.9541698600779274,7.2216305713260942]
["2015–16",6.8817411873710714,6.3914361671252662,10.174331767367333,8.2013366771697651,8.0818334373802792,7.2469434887006603]
["2016–17",7.3528603424020487,7.3999894281569496,12.276829242607519,9.4382291022060603,8.9250720035914526,8.2215830643011216]
["2017–18",10.151481700370613,10.089166457915807,15.666781212294156,11.072759325286373,11.210301298257464,10.79741266254835]
["2018–19",11.43049647929341,9.4847384582111776,13.482663869766554,10.090653158015034,10.065068236092092,10.468500650460738]
["2019–20",11.877170269209889,9.4667591250693697,12.351817042668314,8.6525135500589538,11.838037297231802,10.297943433421256]
["2020–21",10.586420128857798,8.478479721130288,10.314585772901639,7.5899708771923029,8.9223495713362961,9.040741006717802]
["2021–22",8.2119233940379956,7.1346962102784754,7.62521779120177,6.549389836987209,7.6402317142992189,7.3784348390592438]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data. "]
[null,null,null,null,null,null,null,null,"Note: \tNSW includes ACT from 2019–20."]

{"sheet":"13. Environmental","index":18,"n_rows":109,"n_cols":9,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
["Environmental cost component"]
[{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
[]
["Supplementary Table D13.1a",null,null,null,null,null,null,null,"Figure D13.1: Average environmental cost per residential customer by NEM regions, 2013–14 to 2021–22, real $2021–22, excluding GST"]
["Residential Customers - Aggregate environmental costs"]
["$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["2013–14",91.877737215772939,132.84152108192211,201.06609227662213,122.72931139827001,147.98491374345622,126.17659789299248]
["2014–15",93.672481445374387,121.67893548568236,210.39778318308606,123.28432344780424,156.09354640269314,123.15278816248838]
["2015–16",99.653192177382806,123.1478687001392,191.13564402062863,158.30817870666854,189.55317964137072,130.4732390717833]
["2016–17",103.07888374538416,121.63783390669062,188.69422707602308,167.47935039982642,176.06200669333668,131.84206142858963]
["2017–18",124.58577730479598,144.96018116691997,186.19049495574217,97.246270549205775,188.35848162761312,135.96483783291512]
["2018–19",128.63019690797248,153.82068363315756,189.10456613090986,109.15396213788236,181.36043666526527,142.92219742459386]
["2019–20",139.68807970532887,158.2376580898036,200.35213311449797,110.89241156987568,196.01990767957381,150.04122960407025]
["2020–21",142.42633883734987,154.31375081503353,178.81569002721938,167.92495076905689,193.36286965523249,156.45642734803261]
["2021–22",155.30772802114825,137.04655910533168,164.15888282317954,154.01763002977185,190.88083643977973,149.42018889754954]
[]
[]
["Supplementary Table D13.1b"]
["Residential Customers - Residential Customers - LRET costs"]
["$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["2017–18",65.481410920447516,75.38194000991318,63.481357373101353,69.608251118071735,109.43447093131158,71.214336470303337]
["2018–19",54.626507333664215,69.257348075498882,55.713887847503855,63.351854255943515,88.463264289221328,63.05577413566499]
["2019–20",47.880443952429999,58.002263023690368,49.176782746188465,55.424201223060592,109.60822140845485,55.270828318835001]
["2020–21",40.727157509533953,47.905229585825815,39.956905922817441,42.167751220011993,93.310449308508197,45.432579162146986,null,"Source: ACCC analysis based on retailers’ data. "]
["2021–22",33.901121113632463,40.957629979536918,32.62342995505832,38.595437047822209,94.576101567762919,39.236257133170014,null,"Note: 'FiT' for NSW includes contributions to the NSW Climate Change Fund, which are recovered through network charges like the costs of premium feed-in tariffs are in other regions. 'FiT' for NSW also includes premium feed-in tariffs in the ACT from 2019–20."]
[null,null,null,null,null,null,null,null,"         Breakdown in environmental costs only available from 2016–17 onwards"]
[null,null,null,null,null,null,null,null,"         LRET = Large-scale Renewable Energy Target, SRES = Small-scale Renewable Energy Scheme, FiT = Feed in Tariffs"]
["Supplementary Table D13.1c"]
["Residential Customers - Residential Customers - SRES costs"]
["$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["2017–18",25.670593648830792,30.046573739239154,26.240254884214167,27.638019431134047,43.504456342770659,28.322572214178638]
["2018–19",40.070702061182665,48.720021318472021,42.569762616711117,45.802107881938845,68.656242085671593,45.593621673600694]
["2019–20",47.48288204690548,57.974769228457738,49.888451652884484,55.468210346815084,86.411686271118967,54.513199900240011]
["2020–21",49.997876019742463,64.439196711370315,52.293660474909892,62.057143493337826,100.05242034672429,59.638530579018592]
["2021–22",50.589786755224154,63.543085448722614,53.041744889377632,63.458743974299061,96.304734872016823,59.614021531773609]
[]
[]
["Supplementary Table D13.1d"]
["Residential Customers - State scheme costs"]
["$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["2017–18",15.432323819039274,10.892855262574777,33.429483790112648,0,0,12.33593009463706]
["2018–19",16.163477432229257,12.29024497045941,17.468557325664413,0,0,11.547457557830487]
["2019–20",29.589018344821046,13.218557568906583,18.654571083799439,0,0,16.082019418985716]
["2020–21",35.674784691238408,14.127154599021686,14.040788822121272,0,0,17.867289505835206]
["2021–22",55.722832599280409,16.775498125489079,16.740384186908091,0,0,25.210511528782167]
[]
[]
["Supplementary Table D13.1e"]
["Residential Customers - FiT costs"]
["$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["2017–18",18.00144891647841,28.638812155192856,63.039398908314013,0,35.419554353530891,24.091999053796094]
["2018–19",17.769510080896342,23.553069268727238,73.352358341030481,0,24.240930290372344,22.725344057497683]
["2019–20",14.735735361172349,29.042068268748913,82.632327631625586,0,0,24.175181966009529]
["2020–21",16.026520616835036,27.842169918815721,72.524334807370764,63.700056055707073,0,33.518028101031838]
["2021–22",15.093987553011223,15.770345551583073,61.753323791835477,51.963449007650574,0,25.359398703823754]
[]
[]
["Supplementary Table D13.2a",null,null,null,null,null,null,null,"Figure D13.2: Average effective price for environmental costs per residential customer by NEM regions, 2013–14 to 2021–22, real $2021–22, excluding GST"]
["Residential Customers - Aggregate environmental costs"]
["c/kWh","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["2013–14",1.9301899498829469,2.2752980870850319,4.0598116367382548,2.0615143249981509,1.8972327984979807,2.2888614218969416]
["2014–15",1.9868538325138567,2.0324717341791905,4.2300031043780697,2.0795383003610826,2.0406505899711109,2.224127320512773]
["2015–16",2.0943797599764409,2.0449523455262923,3.8322904755981266,2.7151436071265977,2.5588023836147533,2.3563804714872694]
["2016–17",2.1687722214092471,2.0387590927972372,4.0136605178160538,2.9110395023756022,2.3226355888892356,2.4055468572506959]
["2017–18",2.683829092494836,2.5065918859255381,4.0639088990760346,1.726502625187103,2.4386101834667442,2.5432807753230833]
["2018–19",2.8395558430801531,2.7063309365383459,4.1516537027434728,1.9503769672049807,2.3899151006868276,2.7150567867762838]
["2019–20",3.0598772837590809,2.7947932615808666,4.3525239415403236,2.0241736550058551,2.5563430810199264,2.8505840628906429]
["2020–21",3.1007549479790302,2.7176777692697427,3.9910244566259796,2.9841805313301055,2.2806231538353505,2.9437167485848592]
["2021–22",3.3712635692841864,2.3886507234095333,3.5833849863146101,2.8207585384616896,2.3941218013682075,2.8141867659412152]
[]
[]
["Supplementary Table D13.2b"]
["Residential Customers - LRET costs"]
["c/kWh","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["2017–18",1.4106017512413167,1.3034735308215308,1.3855833683416285,1.2358194058375171,1.4168091233767341,1.3320947956771347]
["2018–19",1.2058989398682396,1.2185182073844583,1.2231580310768395,1.1319790408930746,1.1657431745771214,1.1978545712102922]
["2019–20",1.0488245174428883,1.0244358759182293,1.068334641381147,1.011685167388088,1.4294273563194899,1.0500723219277783]
["2020–21",0.8866684083554599,0.84367709805209923,0.89180646689780674,0.74935964944119882,1.1005524047465696,0.85481080245759133,null,"Source: ACCC analysis based on retailers’ data. "]
["2021–22",0.73589135598401856,0.7138703307725377,0.7121290489589962,0.70685679670087553,1.1862202140089064,0.73897748613436942,null,"Note: 'FiT' for NSW includes contributions to the NSW Climate Change Fund, which are recovered through network charges like the costs of premium feed-in tariffs are in other regions. 'FiT' for NSW also includes premium feed-in tariffs in the ACT from 2019–20."]
[null,null,null,null,null,null,null,null,"         Breakdown in environmental costs only available from 2016–17 onwards"]
[null,null,null,null,null,null,null,null,"         LRET = Large-scale Renewable Energy Target, SRES = Small-scale Renewable Energy Scheme, FiT = Feed in Tariffs"]
["Supplementary Table D13.1c"]
["Residential Customers - SRES costs"]
["$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["2017–18",0.55299639771716536,0.51955300640743829,0.5727360323271562,0.49068321934958553,0.56323670347591059,0.52978589588390057]
["2018–19",0.88457453155855992,0.85718316814557693,0.93458828736177824,0.81839792631190589,0.90473199521349756,0.86613048350261546]
["2019–20",1.0401158957323273,1.0239502805512011,1.0837952002823115,1.0124884875397484,1.1269157247004362,1.0356783883307781]
["2020–21",1.0885006433655715,1.1348630400540454,1.1671530493218549,1.1028124087257547,1.1800707490887814,1.1220947857637178]
["2021–22",1.0981520832145497,1.1075231513701009,1.1578355615958611,1.1622162597292078,1.2079015873592955,1.1227732456842279]
[]
[]
["Supplementary Table D13.2d"]
["Residential Customers - State scheme costs"]
["c/kWh","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["2017–18",0.33244340185807209,0.18835477712525103,0.72965258886308604,0,0,0.2307488785738451]
["2018–19",0.35681432424469883,0.21623535532135199,0.38350951638299424,0,0,0.21936412661819127]
["2019–20",0.64814954343255826,0.23346614244943262,0.40525881108956135,0,0,0.30553700724668098]
["2020–21",0.77667351455105405,0.24879865724226699,0.31337927656614861,0,0,0.33617180362391152]
["2021–22",1.2095750669515601,0.29238826567113729,0.36542184211328327,0,0,0.47481594308217878]
[]
[]
["Supplementary Table D13.2e"]
["Residential Customers - FiT costs"]
["c/kWh","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["2017–18",0.38778754167827884,0.49521057157131665,1.375936909544158,0,0.45856435661409417,0.45065120518820062]
["2018–19",0.39226804740865251,0.41439420568695734,1.6103978679218565,0,0.31943993089620248,0.43170760544518311]
["2019–20",0.32278732721657066,0.51294096289348301,1.7951352889929424,0,0,0.45929634550860043]
["2020–21",0.34891238170693772,0.49033897392133685,1.6186856638401694,1.1320084731631508,0,0.63063935673963933]
["2021–22",0.32764506313405417,0.27486897559576801,1.3479985336464642,0.95168548203160597,0,0.47762009104044223]

{"sheet":"14. Cost stack retail","index":19,"n_rows":346,"n_cols":11,"rows_kept":346,"cut":false,"hidden":false,"merged":[]}
["Retail costs and margins component"]
[{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
[]
["Supplementary Table D14.1a",null,null,null,null,null,null,null,null,null,"Figure D14.1: Comparison of average retail costs and retail margins (as earnings before interest, tax, depreciation and amortisation or EBITDA) per residential customer by NEM regions, 2013–14 to 2021–22, real $2021–22, excluding GST"]
["Residential Customers - Aggregate retail component"]
["$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["2013–14",365.44433743795605,273.92089871708146,232.01651017219177,323.26687582703124,250.9839649196602,304.46979185038668]
["2014–15",371.71764201294889,287.99919249622866,181.19005554810536,334.75112847402693,289.87542259886328,311.02782761004789]
["2015–16",379.2411476138559,316.29430956720876,233.62340119865556,247.33097482777896,269.97381176272586,314.80910302385126]
["2016–17",393.53780527978751,375.35359666286752,250.74189591878917,231.25847624177044,242.8482086890555,340.54003294417089]
["2017–18",317.15277903024082,324.58176596002585,198.53009136622856,233.18190901568659,174.62597785522181,289.99458658642584]
["2018–19",293.52609155058099,262.50947190192181,191.29931855332231,190.42566217824714,288.27354423083926,253.76135511726517]
["2019–20",227.42613357659874,231.24061077650202,157.32867661025438,176.01391047229811,190.52634122176229,212.85879227617994]
["2020–21",228.97590237621114,210.28122143735837,127.98375344899887,137.73995766553446,297.50627132979054,198.93466996161447]
["2021–22",207.19404629725329,175.98398624178631,162.39271934738056,118.47671773112349,214.90148020709972,175.79017946822759]
[]
[]
["Supplementary Table D14.1b"]
["Residential Customers - Retail and other costs"]
["$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["2013–14",222.49613103269346,218.13701219382693,176.69424566324284,168.70646903731972,0,205.37950058752878]
["2014–15",213.70411408634831,179.67120679926086,180.91575722456747,180.40888928120501,0,188.76947788595481]
["2015–16",214.72833142725378,178.33874052282906,179.06916954876377,169.12179091451705,0,186.59017360037137]
["2016–17",210.05118313344417,182.9164859227339,170.2855920945625,180.87998938589257,0,188.03147701316877,null,null,null,"Source: ACCC analysis based on retailers’ data."]
["2017–18",206.28494351859507,178.68936360749518,169.39825811431254,194.73527241164382,0,187.39002526958259,null,null,null,"Note: Negative retail margins for SA in 2019–20 and SEQ in 2021–22 are shown below 0. "]
["2018–19",198.89860419900643,174.75876865084905,169.75704386950321,174.77862402011453,0,180.83272374056151]
["2019–20",178.20566670009569,159.20169256255679,155.3191017856916,166.64564820645722,0,166.41785963793976]
["2020–21",159.97256031580946,140.5164555612526,141.27798308114671,140.05727309646278,0,146.8824944667908]
["2021–22",155.37168970520625,135.64577582907339,133.07298514940121,128.26138486456676,0,141.00642810019849]
[]
[]
["Supplementary Table D14.1c"]
["Residential Customers - Retail margin (EBITDA)"]
["$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
["2013–14",142.9482064052626,55.783886523254544,55.322264508948933,154.56040678971152,250.9839649196602,99.090291262857917]
["2014–15",158.01352792660057,108.32798569696781,0.27429832353789324,154.34223919282189,289.87542259886328,122.25834972409308]
["2015–16",164.51281618660209,137.9555690443797,54.554231649891783,78.209183913261896,269.97381176272586,128.21892942347989]
["2016–17",183.48662214634334,192.43711074013362,80.45630382422668,50.378486855877867,242.8482086890555,152.50855593100209]
["2017–18",110.86783551164575,145.89240235253067,29.131833251916017,38.446636604042752,174.62597785522181,102.60456131684325]
["2018–19",94.627487351574587,87.75070325107275,21.542274683819095,15.64703815813259,288.27354423083926,72.928631376703663]
["2019–20",49.220466876503053,72.038918213945223,2.0095748245627765,9.3682622658408885,190.52634122176229,46.440932638240184]
["2020–21",69.003342060401664,69.76476587610577,-13.294229632147847,-2.317315430928327,297.50627132979054,52.052175494823686]
["2021–22",51.822356592047058,40.338210412712932,29.319734197979351,-9.7846671334432784,214.90148020709972,34.783751368029101]
[]
[]
["Supplementary Table D14.2",null,null,null,null,null,null,null,null,null,"Figure D14.2: Earnings before interest, tax, depreciation and amortisation or EBITDA as a percentage of the average residential customer bill over time by NEM regions, 2013–14 to 2021–22"]
["Residential Customers"]
["% of revenue","Victoria","NSW","SA","SEQ"]
["2013–14",0.08,0.03,0.03,0.08]
["2014–15",0.1,0.06,0,0.08]
["2015–16",0.11,0.08,0.03,0.04]
["2016–17",0.12,0.11,0.05,0.03]
["2017–18",7.0000000000000007E-2,0.08,0.02,0.02]
["2018–19",0.06,0.05,0.01,0.01]
["2019–20",0.03,0.04,0,0.01]
["2020–21",0.05,0.04,-0.01,0]
["2021–22",0.04,0.03,0.02,-7.6430226102207422E-3]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[null,null,null,null,null,null,null,null,null,null,"Note: Negative retail margins for SA in 2019-20 and SEQ in 2021-22 are shown below 0. "]
[]
["Supplementary Table D14.3",null,null,null,null,null,null,null,null,null,"Figure D14.3 (report figure 4.6): Average retail and other costs over time per residential customer across the NEM, 2007–08 to 2021–22, real $2021–22, excluding GST"]
["Residential Customers - Retail and other costs"]
["$/customer","NEM"]
["2007–08",122.85148373471071]
["2008–09",0]
["2009–10",0]
["2010–11",161.44722842900043]
["2011–12",0]
["2012–13",0]
["2013–14",205.37950058752881]
["2014–15",188.76947788595484]
["2015–16",186.59017360037134]
["2016–17",184.25407018649548]
["2017–18",187.39002526958265]
["2018–19",180.83272374056202]
["2019–20",166.41785962719328]
["2020–21",146.88249446679086]
["2021–22",141.0064281001988]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
["Supplementary Table D14.4",null,null,null,null,null,null,null,null,null,"Figure D14.4 (report figure 4.5): Average retail margins (as earnings before interest, tax, depreciation and amortisation or EBITDA) per residential customer across the NEM, 2007–08 to 2021–22, real $2021–22, excluding GST"]
["Residential Customers - Retail margin (EBITDA)"]
["$/customer","NEM"]
["2007–08",75.709752736523285]
["2008–09",0]
["2009–10",0]
["2010–11",143.8090613950863]
["2011–12",0]
["2012–13",0]
["2013–14",99.090291262857917]
["2014–15",122.25834972409312]
["2015–16",128.21892942347989]
["2016–17",145.0989321031827]
["2017–18",102.60456131684337]
["2018–19",72.928631376703805]
["2019–20",46.440932631929137]
["2020–21",52.052175494823736]
["2021–22",34.783751368029257]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
["Supplementary Table D14.5",null,null,null,null,null,null,null,null,null,"Figure D14.5: Average Cost to Serve over time per residential customer across the NEM, 2007–08 to 2021–22, real $2021–22, excluding GST"]
["Residential Customers - Cost to Serve"]
["$/customer","NEM"]
["2007–08",85.433604336043388]
["2008–09",0]
["2009–10",0]
["2010–11",121.88527551942191]
["2011–12",0]
["2012–13",0]
["2013–14",130.99819331526621]
["2014–15",112.7723577235776]
["2015–16",102.520325203252]
["2016–17",101.78255359016379]
["2017–18",86.32068711052294]
["2018–19",88.43443319545176]
["2019–20",85.220029756776825]
["2020–21",77.292881783206724]
["2021–22",74.72840527244847]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
[]
["Supplementary Table D14.6",null,null,null,null,null,null,null,null,null,"Figure D14.6: Average Cost to Serve per residential customer by NEM regions, 2017–18 to 2021–22, real $2021–22, excluding GST"]
["Residential Customers - Cost to Serve"]
["$/customer","Victoria","NSW","SA","SEQ","NEM"]
["2018–19",93.021475880034757,80.792922691830952,81.679006400687555,91.764110497106671,88.43443319545176]
["2019–20",87.196424990612513,76.153262341078005,78.192867694507257,91.249694768091231,85.220029756776825]
["2020–21",83.861367045157508,68.624011929854291,71.463962900619634,76.283605042834139,77.292881783206724]
["2021–22",80.430374530387951,66.865934516044931,71.308929172186154,70.257484791679389,74.72840527244847]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
["Supplementary Table D14.7a",null,null,null,null,null,null,null,null,null,"Figure D14.7 (report figure 4.7): Average Cost to Serve per residential customer across the NEM by retailer tier, 2017–18 to 2020–21, real $2021-22, excluding GST "]
["Residential Customers - Cost to Serve"]
["$/customer","Big 3","Non-Big.3"]
["2018–19",75.346623799260072,125.17039801768814]
["2019–20",70.411936476151709,119.42558312998175]
["2020–21",61.466528530938241,116.06674862765378]
["2021–22",60.732286884494528,109.08556535800162]
[]
[]
["Supplementary Table D14.7b"]
["Residential Customers"]
[null,"Big 3",null,null,null,"Non-Big 3"]
["% of CTS","2018–19","2019–20","2020–21","2021–22","2018–19","2019–20","2020–21","2021–22"]
["Billing",0.10399496963502471,9.4062101200499848E-2,9.8471724610300279E-2,9.1662036937771751E-2,0.13372897659645708,0.1207247886736913,0.12211888593605719,0.11854012314228919]
["CTS Labour",0.39564849932594176,0.419598066151328,0.43073451410767072,0.43408104792293661,0.42420311279807654,0.43932827659498774,0.46312691035149001,0.50894195512868412]
["Customer service and IT",0.23818740623528342,0.22976964291060448,0.23724230411929095,0.2354126460423201,0.18990468086483961,0.19862438267854829,0.21491950382167369,0.19660710072825749]
["Debt collection",9.2355861742584158E-2,9.6116092547690782E-2,7.899311544264126E-2,7.6999684862786605E-2,2.2695296598465947E-2,4.6440160854908964E-2,1.4036894302051172E-2,1.5804888727131049E-2]
["Hardship",2.8677856585560327E-2,2.701180340285627E-2,1.7479576538545372E-2,1.3350967977022284E-2,7.2172093173627121E-3,1.1135697040584628E-2,1.3904961489443686E-2,1.1788003785241313E-2]
["Other Cost(s) to Serve",0.14113540647560552,0.13344229378702052,0.13707876518155149,0.14849361625716265,0.22225072382479802,0.18374669415727912,0.17189284409928424,0.14831792848839692]
[]
[null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[null,null,null,null,null,null,null,null,null,null,"Note: Data labels for small cost components have been omitted for readability. CTS = Cost to serve."]
[]
[]
["Supplementary Table D14.8",null,null,null,null,null,null,null,null,null,"Figure D14.8: Average Cost to Acquire and Retain over time per residential customer across the NEM, 2007–08 to 2021–22, real $2021–22, excluding GST "]
["Residential Customers - Cost to Acquire and Retain"]
["$/customer","NEM"]
["2007–08",37.590785907859058]
["2008–09",0]
["2009–10",0]
["2010–11",39.869015356820235]
["2011–12",0]
["2012–13",0]
["2013–14",42.147244805781426]
["2014–15",50.121047877145408]
["2015–16",52.399277326106592]
["2016–17",54.518901311715574]
["2017–18",69.852852428659489]
["2018–19",61.643571317862921]
["2019–20",53.942541564123658]
["2020–21",47.627211493472615]
["2021–22",44.905354711009167]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
["Supplementary Table D14.9",null,null,null,null,null,null,null,null,null,"Figure D14.9: Average Cost to Acquire and Retain per residential customer by NEM regions, 2017–18 to 2021–22, real $2021–22, excluding GST"]
["Residential Customers - Cost to Acquire and Retain"]
["$/customer","Victoria","NSW","SA","SEQ","NEM"]
["2018–19",68.683937409635405,61.00778715527774,54.789529298370624,65.127475846057635,61.643571317862921]
["2019–20",62.280492151090669,53.100207000836562,48.641943054188133,53.293495729566963,53.942541564123658]
["2020–21",53.561710791768085,48.217491415071038,47.806669855241672,43.208570049716108,47.627211493472615]
["2021–22",53.061569068797567,45.204841104665768,41.283680428427992,38.799880321687191,44.905354711009167]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
["Supplementary Table D14.10a",null,null,null,null,null,null,null,null,null,"Figure D14.10 (report figure 4.8): Average Cost to Acquire and Retain per residential customer across the NEM by retailer tier, 2018–19 to 2021–22, real $2021–22, excluding GST"]
["Residential Customers - Cost to Acquire and Retain"]
["$/customer","Big 3","Non-Big 3"]
["2018–19",49.597983939520262,95.454139671855842]
["2019–20",45.980368056987672,72.334548266391053]
["2020–21",40.687436566839033,64.629353720846041]
["2021–22",36.977908374578703,64.365360356916639]
[]
[]
["Supplementary Table D14.10b"]
["Residential Customers"]
[null,"Big 3",null,null,null,"Non-Big 3"]
["% of CARC","2018–19","2019–20","2020–21","2021–22","2018–19","2019–20","2020–21","2021–22"]
["Advertising and marketing",0.19800380027769882,0.19680149967333083,0.16848003713068152,0.18634792397976085,0.22116277092076231,0.25062847911425934,0.31712021550179431,0.2600336627412394]
["CARC Labour",0.37871333355335302,0.40311781560129384,0.38917725525446834,0.38952400682977772,0.25470044039266648,0.28362403594955454,0.249466887571413,0.23855081489935756]
["Churn Prevention",2.757736096520768E-2,2.1946292664911493E-2,1.9877748668189935E-2,1.4819414452949977E-2,1.32271907844894E-2,1.4282147920916666E-2,1.7662491053924766E-2,1.5242923171887798E-2]
["Customer loyalty programs",3.1049421981149111E-2,3.5584295086971945E-2,5.1200666739598118E-2,3.3651944791382303E-2,5.059537392415258E-2,7.3380590992121186E-2,7.3382643672315354E-2,7.1008823320804423E-2]
["Other Cost(s) to Acquire and Retain",0.12757207176800323,0.16492800219422227,0.13339983931280999,0.14932739414420926,0.12931324864884022,0.14112152528681804,0.19237205227900445,0.207881549058412]
["Third Party Sales",0.23708401145458805,0.17762209477926968,0.23786445289425209,0.22632931580191995,0.33100097532908901,0.23696322073633008,0.14999570992154826,0.2072822268082988]
[]
[null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[null,null,null,null,null,null,null,null,null,null,"Note: Data labels for small cost components have been omitted for readability. CARC = costs to acquire and retain."]
[]
[]
["Supplementary Table D14.11",null,null,null,null,null,null,null,null,null,"Figure D14.11 (report figure C1): Average retail margins (as earnings before interest, tax, depreciation and amortisation or EBITDA) per electricity usage for small business across the NEM, 2007–08 to 2021–22, real $2021–22, excluding GST"]
["Small Business Customers - Retail margin (EBITDA)"]
["c/kWh","NEM"]
["2007–08",2.098126020722606]
["2008–09",0]
["2009–10",0]
["2010–11",3.7186186050669803]
["2011–12",0]
["2012–13",0]
["2013–14",2.5467023603036627]
["2014–15",2.6345647922875677]
["2015–16",2.2784177567467854]
["2016–17",2.3774832111773168]
["2017–18",2.2934379547358708]
["2018–19",2.4935622218095541]
["2019–20",1.3915941381065924]
["2020–21",1.4497761478095159]
["2021–22",0.73177203247497291]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
["Supplementary Table D14.12",null,null,null,null,null,null,null,null,null,"Figure D14.12 (report figure C2): Average retail and other costs over time per electricity usage for small business across the NEM, 2007–08 to 2021–22, real $2021–22, excluding GST"]
["Small Business Customers"]
["c/kWh","NEM"]
["2007–08",0.64564462077338447]
["2008–09",0]
["2009–10",0]
["2010–11",0.9299769298523497]
["2011–12",0]
["2012–13",0]
["2013–14",1.8939520116928164]
["2014–15",1.7551245550998362]
["2015–16",1.6583998164060521]
["2016–17",1.5238490879855104]
["2017–18",1.6663588531178788]
["2018–19",1.8646369032314154]
["2019–20",1.6074075292775931]
["2020–21",1.4609120117054337]
["2021–22",1.3674238438274924]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
["Supplementary Table D14.13a",null,null,null,null,null,null,null,null,null,"Figure D14.13 (report figure C3): Average Cost to Serve per electricity usage for small business across the NEM by retailer tier and percentage of residential total, 2017–18 to 2021–22, real $2021-22, excluding GST "]
["Small Business Customers - Cost to Serve"]
["c/kWh","Big 3","Non-Big 3"]
["2018–19",0.63477964739833947,1.087349191510663]
["2019–20",0.61786169492814591,1.155837024859327]
["2020–21",0.5334585372682723,1.136014097928133]
["2021–22",0.55716859049847678,1.1060033201668928]
[]
[]
["Supplementary Table D14.13b"]
["Small Business Customers "]
[null,"Big 3",null,null,null,"Non-Big 3"]
["% of CTS","2018–19","2019–20","2020–21","2021–22","2018–19","2019–20","2020–21","2021–22"]
["Billing",0.11471568581539431,8.6960091204102322E-2,8.6369290104489321E-2,8.0258108535562783E-2,0.10524733918702819,9.4738067706979109E-2,8.6958435282968288E-2,7.6545988043600868E-2]
["CTS Labour",0.39690271756192208,0.4412656787874803,0.45982197999468838,0.46018260352317486,0.49132085444648399,0.47856380421913108,0.50948562869461445,0.53502359086358975]
["Customer service and IT",0.23431184220208578,0.21469369957725878,0.21621089540298485,0.21279806314871147,0.22205880217972399,0.23391943882354277,0.22189582055280271,0.20943614801485111]
["Debt collection",9.1855238598497882E-2,8.5192957918834411E-2,7.3809807614451994E-2,6.7576364512832013E-2,3.5441261204583477E-2,6.9944236514004707E-2,2.154024192244354E-2,2.7661616963608807E-2]
["Hardship",9.4271836690778075E-3,8.8388682490625637E-3,4.5033264629020364E-3,1.921587153094282E-3,8.5556855518331681E-3,1.0175377010359529E-2,1.3312870447855847E-2,9.5092242633055823E-3]
["Other Cost(s) to Serve",0.15278733215302204,0.16304870426326165,0.15928470042048357,0.17726327312662432,0.13737605743034723,0.1126590757259829,0.14680700309931499,0.14182343185104401]
[]
[null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[null,null,null,null,null,null,null,null,null,null,"Note: Data labels for small cost components have been omitted for readability. "]
[]
["Supplementary Table D14.14a",null,null,null,null,null,null,null,null,null,"Figure D14.14 (report figure C4): Average Cost to Acquire and Retain per electricity usage for small business across the NEM by retailer tier and percentage of residential total, 2018–19 to 2021–22, real $2021–22, excluding GST"]
["Small Business Customers - Cost to Acquire and Retain"]
["c/kWh","Big 3","Non-Big 3"]
["2018–19",0.47263769471014183,0.54591137610131579]
["2019–20",0.40239061434699114,0.35055131457492733]
["2020–21",0.34622623128214319,0.33629661300612573]
["2021–22",0.37964297583189127,0.33988440741822701]
[]
[]
["Supplementary Table D14.14b"]
["Small Business Customers "]
[null,"Big 3",null,null,null,"Non-Big 3"]
["% of CARC","2018–19","2019–20","2020–21","2021–22","2018–19","2019–20","2020–21","2021–22"]
["Advertising and marketing",0.13468273779449833,0.19019886971645067,0.14399241653105863,0.12685433631129969,0.17093251222679637,0.24134705879912513,0.30508746340343706,0.27922167873073489]
["CARC Labour",0.57924803978640504,0.48172783394928914,0.5231531500319262,0.50764983608783987,0.34506495210746502,0.23785211639930418,0.23154383484073629,0.29961630550340146]
["Churn Prevention",2.2122726922139169E-2,1.6099612091151495E-2,1.1821997618830271E-2,1.1043974085087321E-2,7.6662212023609908E-3,6.5755334218870701E-4,3.0696142075015285E-2,1.1288189591283002E-2]
["Customer loyalty programs",1.6432242145899452E-2,2.0335023686720199E-2,2.0057178379023717E-2,3.3223133634771073E-3,2.202014165447164E-2,2.7726101506400747E-2,1.6496480624462358E-2,5.4307094706915497E-3]
["Other Cost(s) to Acquire and Retain",0.10857040652166557,0.16133367514491775,0.146066461893299,0.16720246812972203,0.16381040785079928,0.10060027861189745,0.19193587724341007,0.18029306632431677]
["Third Party Sales",0.13894384682939245,0.13030498541147073,0.15490879554586209,0.18392707202257405,0.29050576495810676,0.39181689134108383,0.22424020181293905,0.22415005037957228]
[]
[null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[null,null,null,null,null,null,null,null,null,null,"Note: Data labels for small cost components have been omitted for readability. "]

{"sheet":"RETAIL>>","index":20,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"15. Retail market share","index":21,"n_rows":98,"n_cols":11,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
["Retail Market Share"]
[{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
[]
["Supplementary Table D15.1",null,null,null,null,null,null,null,null,"Figure D15.1 (report figure 4.1): Retail electricity market share by region, 2021–22"]
["Retail electricity market share by region, 2021–22"]
[null,"VIC","NSW","SA","SEQ","Tas","ACT","NEM"]
["Origin Energy",0.1733714445341617,0.29015084901246302,9.3083648864089277E-2,0.39410737091648418,0,0.19425168197012652,0.27112023212640635]
["AGL",0.23254416957224033,0.24008167594424062,0.37060831008369871,0.26778399993519836,0,5.2892142343333471E-6,0.22309265003355519]
["EnergyAustralia",0.14851317301912723,0.25178580664953243,6.6028547229972104E-2,6.4779363917907118E-2,0,5.4388989971649815E-2,0.14947237111705336]
["Alinta Energy",5.8808290155440417E-2,3.1623417892727344E-2,5.8808290155440417E-2,0.13791408922645743,0,0,5.3163946255856562E-2]
["Aurora Energy",0,0,0,0,0.95099999999999996,0,3.5797542376229799E-2]
["ActewAGL",0,8.7766860303695633E-3,0,0,0,0.71650340625396691,2.4507612228643439E-2]
["Red/Lumo Energy",9.1491573682781005E-2,1.852244899415165E-2,9.3083648864089277E-2,8.363461595578367E-3,0,5.2892142343333471E-6,2.2197221292196867E-2]
["Momentum",5.4149623562215518E-2,1.1102767933422631E-3,5.6740733359904344E-2,3.3251341258933847E-3,0,5.2363220919900144E-4,7.7022438747308825E-3]
["Other",0.24112172547403365,0.40973464533270554,0.26164682144280593,0.12538914734542786,4.9000000000000044E-2,3.4321711166588997E-2,0.21294618069532756]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Sources:","AER, Annual Retail Market Report 2021–22, Commonwealth of Australia, to be released; Essential Services Commission (ESC), Victorian Energy Market Report 2020–21 – Appendix: Retailer performance [data set], 30 November 2021, ESC website, accessed 9 November 2022. "]
[null,null,null,null,null,null,null,null,null,"Notes:","Victorian data is for June 2021, while New South Wales, South-east Queensland, Tasmania, Australian Capital Territory, National Electricity Market data is from June 2022. South-east Queensland Data has been calculated by subtracting Ergon Energy customers from Queensland market share figures and rebasing percentages."]
[]
[]
["Supplementary Table D15.2",null,null,null,null,null,null,null,null,"Figure D15.2 (report figure 4.2): National Electricity Market-wide small customer market share at 2013–14, 2017–18 and 2021–22"]
["National Electricity Market-wide small customer market share at 2013–14, 2017–18 and 2021–22"]
["Retailer","2013–14","2017–18","2021–22"]
["AGL",0.23576406566923289,0.21174607498519993,0.22361803293038485]
["EnergyAustralia",0.23273793365999212,0.16236533326322028,0.1472556890380507]
["Origin",0.27437782700871466,0.25542684827783468,0.24396409343325762]
["Other",0.25712017366206036,0.37046174347374511,0.38516218459830681]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Sources: ","AER, Annual Retail Market Report 2021–22, Commonwealth of Australia, 30 November 2022; Essential Services Commission (ESC), Victorian Energy Market Report 2020–21 – Appendix: Retailer performance [data set], 30 November 2021, ESC website, accessed 9 November 2022."]
[null,null,null,null,null,null,null,null,null,"Notes: ","Data for Victoria is as of 2021, while National Electricity Market data is from Q4 2021–22."]
[]
[]
["Supplementary Table D15.3",null,null,null,null,null,null,null,null,"Figure D15.3 (report figure 4.3): Herfindahl-Hirschman Index by region, December 2009 – June 2022"]
["Herfindahl-Hirschman Index (HHI)/10000 by region: Dec 2009 – Jun 2022"]
[]
["Point in Time","VIC","NSW","SA","SEQ","ACT","TAS"]
["Dec-09",0.21079125075303201,0.40667640557136403,0.38012358896280896,0.51626343272716801,0.89868135956345307,1]
["Dec-10",0.20392384590766199,0.38603036683995801,0.37923844783437,0.47393437309969905,0.91363558208249307,1]
["Dec-11",0.191866956962056,0.34836462962814096,0.36047052344534497,0.42851492371806799,0.92069510095528895,1]
["Dec-12",0.18134772494700099,0.32000885078277103,0.349108154852314,0.41499436440989801,0.92384897151589107,1]
["Dec-13",0.18181201637281399,0.31710659116693701,0.32582508636325602,0.40785873536633999,0.92492754304413194,1]
["Dec-14",0.17649212139283599,0.299607623408431,0.31197261216062599,0.389481022739262,0.921354996982921,1]
["Dec-15",0.16789539112876101,0.28677472490859901,0.30134826196203296,0.38071883990379701,0.873668477631383,1]
["Dec-16",0.15963618587456399,0.271417884532211,0.28419808486998899,0.36971353744143498,0.83146043869455011,1]
["Dec-17",0.15507670050410699,0.25564101734789102,0.273155113665905,0.32462493896809302,0.80023301745478703,1]
["Dec-18",0.14127942679275801,0.24808850781576197,0.26557260848299002,0.28849337372554601,0.73018587403511903,1]
["Jun-19",0.12686974788025224,0.23361913537818463,0.23874809415815998,0.26652763949052521,0.69077482656910072,0.99354677676921543]
["Jun-20",0.12544504247183358,0.22439654704910345,0.23868077598481099,0.25291091010131572,0.65409035240800462,0.97168207006622687]
["Jun-21",0.1304878868853544,0.2177651489083145,0.24314014477659798,0.24953542438889303,0.58655741945385143,0.93637769324912101]
["Jun-22","N/A",0.2144774608304324,0.23861513254046596,0.25215126126341542,0.55466399576469683,0.90631141209579635]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Sources:","AEMC, Figure 3.3a: Long-term changes in HHI, 2009 to 2018 (electricity) [data set], 2018, AEMC website, accessed 9 November 2022; AER, Annual Retail Market Report 2021–22, Commonwealth of Australia, 30 November 2022; Essential Services Commission (ESC), Victorian Energy Market Report 2020–21 – Appendix: Retailer performance [data set], 30 November 2021, ESC website, accessed 9 November 2022."]
[]
[]
["Supplementary Table D15.4",null,null,null,null,null,null,null,null,"Figure D15.4 (report figure 4.4): Active electricity retailers in the National Electricity Market by customer type, July 2017 – June 2022"]
["Active electricity retailers in the National Electricity Market by customer type, July 2017 – June 2022"]
[]
["Financial Year","Residential","SME"]
["2017–18",37,39]
["2018–19",45,46]
["2019–20",50,48]
["2020–21",56,55]
["2021–22",63,58]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Sources:","AER, Annual Retail Market Report 2021–22, Commonwealth of Australia, 30 November 2022; Essential Services Commission (ESC), Victorian Energy Market Report 2020-21 – Appendix: Retailer performance [data set], 30 November 2021, ESC website, accessed 9 November 2022; ACCC analysis of Victorian Energy Compare data. accessed 25 October 2022."]
[null,null,null,null,null,null,null,null,null,"Note:","An active retailer is a retailer with at least one customer. Retailers without customers are excluded from the count for that particular year.\nData for Victoria in years 2017 to 2021 is from June 30 each year."]

{"sheet":"16. Retail offers, Resi","index":22,"n_rows":279,"n_cols":13,"rows_kept":279,"cut":false,"hidden":false,"merged":[]}
["Retail Market Offers, Residential"]
[{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
[]
["Supplementary Table D16.1",null,null,null,null,null,null,null,null,null,null,null,"Figure D16.1 (report figure 5.1): Number of single rate market offers, residential, June 2020 to October 2022"]
["Number of single rate market offers, residential, June 2020 to October 2022"]
[]
[null,"NSW",null,"SA",null,"SEQ",null,"VIC"]
["Period","Big3","Non-Big3","Big3","Non-Big3","Big3","Non-Big3","Big3","Non-Big3"]
["2020-06-01",128,238,26,51,28,51,127,335]
["2020-07-01",125,220,25,44,27,50,126,281]
["2020-08-01",110,220,23,44,24,52,131,281]
["2020-09-01",155,237,28,46,29,57,143,295]
["2020-10-01",166,237,29,47,30,56,149,289]
["2020-11-01",166,"-",28,"-",29,"-",132,"-"]
["2020-12-01",195,"-",30,"-",31,"-",132,"-"]
["2021-01-01",192,264,30,57,31,69,137,255]
["2021-02-01",219,256,33,56,34,71,212,293]
["2021-03-01",216,238,32,52,35,65,148,326]
["2021-04-01",219,259,33,55,36,70,157,312]
["2021-05-01",218,297,32,59,33,74,162,377]
["2021-06-01",221,283,34,57,34,72,172,362]
["2021-07-01",203,325,31,63,30,84,201,313]
["2021-08-01",183,349,32,69,31,92,164,358]
["2021-09-01",195,355,35,73,33,94,210,364]
["2021-10-01",199,358,36,77,34,96,215,287]
["2021-11-01",199,367,36,76,35,98,286,370]
["2021-12-01",220,358,38,75,38,96,266,372]
["2022-01-01",193,360,40,75,40,94,181,386]
["2022-02-01",205,377,42,75,42,95,190,413]
["2022-03-01",200,368,41,76,41,93,185,422]
["2022-04-01",233,355,48,75,48,87,230,402]
["2022-05-01",229,333,46,75,47,81,180,392]
["2022-06-01",249,172,47,41,54,39,265,192]
["2022-07-01",221,237,42,62,49,58,245,180]
["2022-08-01",208,242,40,59,47,59,310,215,null,null,null,"Source: ACCC analysis of Energy Made Easy and Victorian Energy Compare market offer data, 10 October 2022."]
["2022-09-01",150,233,31,50,30,47,170,255,null,null,null,"Note: Non-Big3 data in November and December 2020 are not available and have been replaced with modelled estimates."]
["2022-10-01",161,232,33,48,32,47,195,315]
[]
[]
["Supplementary Table D16.2",null,null,null,null,null,null,null,null,null,null,null,"Figure D16.2 (report figure 5.4): Estimated median annual bill, residential single rate market offers ($, real), June 2020 to October 2022"]
["Estimated median annual bill, residential single rate market offers ($, real), June 2020 to October 2022"]
[]
[null,"NSW",null,"SA",null,"SEQ",null,"VIC"]
["Period","Big3","Non-Big3","Big3","Non-Big3","Big3","Non-Big3","Big3","Non-Big3"]
["2020-06-01",1625,1635,1895,1922.5,1489,1521.5,1504,1512]
["2020-07-01",1592,1630,1722,1863,1451,1473,1504,1478]
["2020-08-01",1592,1619,1722,1784.5,1451,1430,1478,1472]
["2020-09-01",1610,1578,1727,1746,1397,1373,1437,1434]
["2020-10-01",1610,1557,1727,1738,1397,1365,1442,1440]
["2020-11-01","-","-","-","-","-","-","-","-"]
["2020-12-01","-","-","-","-","-","-","-","-"]
["2021-01-01",1538,1543,1702,1702,1380,1353,1311,1372]
["2021-02-01",1575,1522,1702,1702,1343,1343,1311,1317.5]
["2021-03-01",1513,1495,1692,1713,1335,1329.5,1295,1278]
["2021-04-01",1503,1503,1692,1692,1335,1319,1295,1273]
["2021-05-01",1503,1511,1692,1639,1314,1319,1271,1246.5]
["2021-06-01",1491,1491,1658,1627,1304,1306.5,1260,1244]
["2021-07-01",1439,1478.5,1679,1637,1304,1314,1240,1267]
["2021-08-01",1439,1468,1679,1627,1304,1314,1238,1278]
["2021-09-01",1428,1444,1656,1573,1294,1304,1263,1252]
["2021-10-01",1428,1439,1666,1568,1294,1304,1258,1256]
["2021-11-01",1428,1428,1666,1568,1294,1299,1258,1214]
["2021-12-01",1410,1420,1645,1547,1277,1277,1242,1207]
["2022-01-01",1410,1420,1645,1542,1277,1282,1241,1213.5]
["2022-02-01",1410,1440,1645,1529.5,1277,1318,1230,1203]
["2022-03-01",1380,1430,1610,1517.5,1250,1300,1204,1174.5]
["2022-04-01",1380,1482.5,1610,1517.5,1215,1300,1215,1183]
["2022-05-01",1380,1495,1610,1522.5,1180,1300,1222,1176]
["2022-06-01",1435,1605,1610,1570,1180,1450,1222,1279.5]
["2022-07-01",1740,1840,1730,1840,1510,1620,1257,1351]
["2022-08-01",1740,1840,1770,1840,1570,1620,1297,1394.5]
["2022-09-01",1830,1920,1830,1835,1610,1620,1311,1403.5]
["2022-10-01",1840,1855,1840,1820,1620,1620,1331,1399.5,null,null,null,"Source: ACCC analysis of Energy Made Easy and Victorian Energy Compare market offer data, 10 October 2022."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Note: Data in November and December 2020 are not available and have been replaced with modelled estimates in the Figure above."]
[]
[]
["Supplementary Table D16.3",null,null,null,null,null,null,null,null,null,null,null,"Figure D16.3 (report figure 5.2): Number of retailers with at least one residential, single rate market offer below Default Market Offer and Victorian Default Offer, by distribution zone (, as at 10 October 2022) "]
["Number of retailers with at least one residential, single rate market offer below Default Market Offer and Victorian Default Offer,"]
["by distribution zone (as at 10 October 2022) "]
[null,"NSW",null,null,"SA","SEQ","Victoria"]
[null,"Ausgrid","Endeavour","Essential Energy","SA Power Networks","Energex","AusNet Services (electricity)","Citipower","Jemena","Powercor","United Energy"]
["2021-01-01",32,33,30,24,27,20,20,20,20,20]
["2021-02-01",33,34,32,24,30,24,24,24,24,24]
["2021-03-01",32,33,31,23,29,25,25,25,25,25]
["2021-04-01",34,35,32,24,30,25,25,25,25,25]
["2021-05-01",35,35,32,25,30,26,26,26,26,26]
["2021-06-01",35,35,33,25,30,26,26,26,26,26]
["2021-07-01",36,35,33,24,33,25,23,24,24,23]
["2021-08-01",36,35,33,25,34,23,23,23,23,23]
["2021-09-01",36,34,33,25,34,23,25,23,25,25]
["2021-10-01",37,35,34,27,36,18,20,19,20,20]
["2021-11-01",37,35,34,26,35,24,28,26,27,27]
["2021-12-01",36,34,33,26,35,25,28,26,27,27]
["2022-01-01",35,33,32,25,34,26,26,26,26,26]
["2022-02-01",35,33,32,25,34,27,26,26,26,28]
["2022-03-01",35,33,32,25,35,27,26,26,26,28]
["2022-04-01",32,30,29,25,32,28,27,27,27,29]
["2022-05-01",30,28,27,25,29,26,25,25,25,27]
["2022-06-01",16,15,15,14,12,16,14,15,15,16]
["2022-07-01",25,18,25,13,11,15,16,16,16,16,null,"Source: ACCC analysis of Energy Made Easy and Victorian Energy Compare market offer data, 10 October 2022."]
["2022-08-01",24,16,24,12,9,16,17,17,17,17]
["2022-09-01",16,12,16,10,9,16,18,18,18,18]
["2022-10-01",17,14,17,11,10,17,19,19,19,19]
[]
[]
["Supplementary Table D16.4",null,null,null,null,null,null,null,null,null,null,null,"Figure D16.4 (report figure C8): Number of single rate market offers below Default Market Offer and Victorian Default Offer, residential, January to October 2022"]
["Number of single rate market offers below Default Market Offer and Victorian Default Offer, residential, January to October 2022"]
[]
[]
[null,"NSW",null,null,"SA","SEQ","VIC"]
[2022,"Ausgrid","Endeavour","Essential Energy","SA Power Networks","Energex","AusNet Services (electricity)","Citipower","Jemena","Powercor","United Energy"]
["2022-01-01",137,129,135,103,127,98,96,92,96,96]
["2022-02-01",141,131,138,102,126,105,100,100,103,106]
["2022-03-01",136,127,134,102,125,106,102,102,104,107]
["2022-04-01",135,127,134,106,122,106,102,101,104,107]
["2022-05-01",129,120,125,105,116,97,93,92,95,98]
["2022-06-01",88,81,86,73,79,71,67,68,69,73]
["2022-07-01",96,77,93,59,59,73,68,68,69,68]
["2022-08-01",94,74,93,53,55,88,88,88,89,88]
["2022-09-01",77,61,76,39,35,72,73,73,73,73]
["2022-10-01",81,61,84,42,38,80,81,81,81,81]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis of Energy Made Easy and Victorian Energy Compare market offer data, 10 October 2022."]
[]
[]
["Supplementary Table D16.5",null,null,null,null,null,null,null,null,null,null,null,"Figure D16.5: Distribution of single rate market offers relative to the DMO / VDO, residential, as at 10 October 2022 "]
["Distribution of single rate market offers relative to the DMO / VDO, residential, as at 10 October 2022 "]
[]
[null,"NSW",null,"SA",null,"SEQ",null,"VIC"]
["Pecentage vs DMO","Big3","Non-Big3","Big3","Non-Big3","Big3","Non-Big3","Big3","Non-Big3"]
["<84%","-",5,1,6,"-",2,"-",5]
["84% - 88%","-",10,"-","-","-","-","-",5]
["88% - 92%",8,14,"-",1,"-",5,"-",5]
["92% - 96%",67,28,2,1,6,3,95,36]
["96% - 100%",26,68,16,15,12,10,85,173]
["100% - 104%",10,16,12,16,12,12,5,21]
["104% - 108%",4,2,"-","-","-","-",10,28]
[">108%",2,50,2,9,2,15,"-",42]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis of Energy Made Easy and Victorian Energy Compare market offer data, 10 October 2022."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Note: Some market offers included in above Figure may not be available to all customers"]
[]
[]
["Supplementary Table D16.6",null,null,null,null,null,null,null,null,null,null,null,"Figure D16.6 (report figure 5.3): Median of minimum and median of maximum market offers compared with the Default Market Offer and Victorian Default Offer, residential single rate, June 2020 to October 2022 "]
["Median of minimum and median of maximum market offers compared with the DMO/VDO, residential single rate"]
[]
["Region","Period","Big3 Min","Big3 Max","Non-Big3 Min","Non-Big3 Max"]
["NSW","2020-06-01",0.83,0.9,0.85271301628502938,0.88082248227832272]
[null,"2020-07-01",0.83,0.91,0.84161309175920518,0.86867305061559508]
[null,"2020-08-01",0.83,0.91,0.82763337893296851,0.86183310533515733]
[null,"2020-09-01",0.82,0.88,0.81632653061224492,0.86616908598623543]
[null,"2020-10-01",0.82,1,0.81258898908400568,0.86616908598623543]
[null,"2020-11-01",0.82,1,"-","-"]
[null,"2020-12-01",0.82,1,"-","-"]
[null,"2021-01-01",0.82,1,0.81,0.86]
[null,"2021-02-01",0.81,1,0.81,0.85]
[null,"2021-03-01",0.8,1,0.8,0.85]
[null,"2021-04-01",0.8,1,0.8,0.85]
[null,"2021-05-01",0.79,1,0.8,0.85]
[null,"2021-06-01",0.79,1,0.8,0.86]
[null,"2021-07-01",0.84,0.9,0.83,0.9]
[null,"2021-08-01",0.84,0.9,0.83,0.9]
[null,"2021-09-01",0.82,0.9,0.82,0.9]
[null,"2021-10-01",0.82,0.91,0.82,0.9]
[null,"2021-11-01",0.82,0.92,0.82,0.9]
[null,"2021-12-01",0.84,0.92,0.82,0.91]
[null,"2022-01-01",0.84,0.92,0.82,0.92]
[null,"2022-02-01",0.84,0.92,0.83,0.92]
[null,"2022-03-01",0.84,0.92,0.83,0.92]
[null,"2022-04-01",0.8,1,0.84,0.94]
[null,"2022-05-01",0.8,0.92,0.85,0.95]
[null,"2022-06-01",0.8,0.97,0.91,0.99]
[null,"2022-07-01",0.92,1,1,1]
[null,"2022-08-01",0.92,1,1,1]
[null,"2022-09-01",0.92,1,1,1]
[null,"2022-10-01",0.92,1,0.97,1]
["SA","2020-06-01",0.87068521380731601,0.93766099948480197,0.89129314786192704,0.91705306543019105]
[null,"2020-07-01",0.86244541484716197,0.99344978165938902,0.92248908296943199,0.97161572052401701]
[null,"2020-08-01",0.86244541484716197,0.99344978165938902,0.88427947598253298,0.91975982532751099]
[null,"2020-09-01",0.86244541484716197,0.95524017467248901,0.88427947598253298,0.91975982532751099]
[null,"2020-10-01",0.86244541484716197,0.95524017467248901,0.86790393013100398,0.91703056768558999,null,null,null,null,null,null,"Source: ACCC analysis of Energy Made Easy and Victorian Energy Compare market offer data, 10 October 2022."]
[null,"2020-11-01",0.86244541484716197,0.95524017467248901,"-","-",null,null,null,null,null,null,"Note: Data in November and December 2020 are not available and have been replaced with modelled estimates in the Figure above."]
[null,"2020-12-01",0.86790393013100398,0.95524017467248901,"-","-"]
[null,"2021-01-01",0.86790393013100398,0.95524017467248901,0.86517467248908297,0.90611353711790399]
[null,"2021-02-01",0.86790393013100398,0.95524017467248901,0.86517467248908297,0.90611353711790399]
[null,"2021-03-01",0.86790393013100398,0.95524017467248901,0.86244541484716197,0.92248908296943199]
[null,"2021-04-01",0.86790393013100398,0.95524017467248901,0.85425764192139697,0.938864628820961]
[null,"2021-05-01",0.86790393013100398,0.95524017467248901,0.84606986899563297,0.92248908296943199]
[null,"2021-06-01",0.86244541484716197,0.95524017467248901,0.84606986899563297,0.89519650655021799]
[null,"2021-07-01",0.93822843822843804,1.0023310023309999,0.89743589743589702,0.94696969696969702]
[null,"2021-08-01",0.93822843822843804,1.0023310023309999,0.89743589743589702,0.93240093240093203]
[null,"2021-09-01",0.90909090909090895,1.0023310023309999,0.86247086247086202,0.92657342657342701]
[null,"2021-10-01",0.90909090909090895,1.0023310023309999,0.856643356643357,0.91491841491841497]
[null,"2021-11-01",0.90909090909090895,1.0023310023309999,0.856643356643357,0.91491841491841497]
[null,"2021-12-01",0.93822843822843804,1.0023310023309999,0.856643356643357,0.91491841491841497]
[null,"2022-01-01",0.92074592074592099,1.0023310023309999,0.85372960372960405,0.93240093240093203]
[null,"2022-02-01",0.92074592074592099,1.0023310023309999,0.85372960372960405,0.94988344988344997]
[null,"2022-03-01",0.92074592074592099,1.0023310023309999,0.85372960372960405,0.94988344988344997]
[null,"2022-04-01",0.92074592074592099,1.0023310023309999,0.86247086247086202,0.94988344988344997]
[null,"2022-05-01",0.92074592074592099,1.0023310023309999,0.86538461538461497,0.96445221445221396]
[null,"2022-06-01",0.92074592074592099,1.0023310023309999,0.91491841491841497,0.99067599067599099]
[null,"2022-07-01",0.940217391304348,1,1,1]
[null,"2022-08-01",0.94021739130434778,1,1,1]
[null,"2022-09-01",0.94020000000000004,1,0.99180000000000001,1]
[null,"2022-10-01",0.94020000000000004,1,0.98640000000000005,1]
["SEQ","2020-06-01",0.84076433121019112,0.9426751592356688,0.88535031847133761,0.90445859872611467]
[null,"2020-07-01",0.86206896551724133,0.98143236074270557,0.87533156498673736,0.90848806366047741]
[null,"2020-08-01",0.8687002652519894,0.98143236074270557,0.85543766578249336,0.88196286472148544]
[null,"2020-09-01",0.84217506631299732,0.98143236074270557,0.83885941644562334,0.8885941644562334]
[null,"2020-10-01",0.82891246684350128,0.98143236074270557,0.82891246684350128,0.85875331564986745]
[null,"2020-11-01",0.82891246684350128,0.98143236074270557,"-","-"]
[null,"2020-12-01",0.82891246684350128,0.98143236074270557,"-","-"]
[null,"2021-01-01",0.82891246684350128,0.98143236074270557,0.82891246684350128,0.8687002652519894]
[null,"2021-02-01",0.82891246684350128,0.98143236074270557,0.82891246684350128,0.8687002652519894]
[null,"2021-03-01",0.82228116710875332,0.98143236074270557,0.82891246684350128,0.86206896551724133]
[null,"2021-04-01",0.82228116710875332,1.0013262599469497,0.82891246684350128,0.85543766578249336]
[null,"2021-05-01",0.80238726790450932,1.0013262599469497,0.82891246684350128,0.8687002652519894]
[null,"2021-06-01",0.80238726790450932,1.0013262599469497,0.82891246684350128,0.85543766578249336]
[null,"2021-07-01",0.85223367697594499,0.91408934707903777,0.85567010309278346,0.89347079037800692]
[null,"2021-08-01",0.85910652920962194,0.91408934707903777,0.85910652920962194,0.90378006872852235]
[null,"2021-09-01",0.85910652920962194,0.91408934707903777,0.85567010309278346,0.90378006872852235]
[null,"2021-10-01",0.85910652920962194,0.92783505154639179,0.85223367697594499,0.90378006872852235]
[null,"2021-11-01",0.85910652920962194,0.92783505154639179,0.84879725085910651,0.90378006872852235]
[null,"2021-12-01",0.85910652920962194,0.92783505154639179,0.84879725085910651,0.89347079037800692]
[null,"2022-01-01",0.85910652920962194,0.92783505154639179,0.85223367697594499,0.91408934707903777]
[null,"2022-02-01",0.85910652920962194,0.92783505154639179,0.85223367697594499,0.92096219931271472]
[null,"2022-03-01",0.85910652920962194,0.92783505154639179,0.85567010309278346,0.93127147766323026]
[null,"2022-04-01",0.81099656357388317,0.99656357388316152,0.85910652920962194,0.93127147766323026]
[null,"2022-05-01",0.81099656357388317,0.92783505154639179,0.88659793814432986,0.94158075601374569]
[null,"2022-06-01",0.81099656357388317,0.98969072164948457,0.99312714776632305,0.99656357388316152]
[null,"2022-07-01",0.90123456790123457,1,1,1]
[null,"2022-08-01",0.9320987654320988,1,1,1]
[null,"2022-09-01",0.93830000000000002,1,1,1]
[null,"2022-10-01",0.93830000000000002,1,0.99690000000000001,1]
["VIC","2020-06-01",0.88991430454845089,0.94592952612393677,0.88002636783124588,0.97326852976913725]
[null,"2020-07-01",0.8894366197183099,0.94592952612393677,0.87997347480106103,0.95686512758201703]
[null,"2020-08-01",0.8894366197183099,0.94592952612393677,0.87727825030376672,0.92580213903743314]
[null,"2020-09-01",0.87997347480106103,0.92506631299734743,0.86750164798945284,0.91578249336870021]
[null,"2020-10-01",0.87957746478873244,0.92506631299734743,0.86937185557141983,0.92796369311792559]
[null,"2020-11-01",0.86074270557029176,0.92572944297082227,"-","-"]
[null,"2020-12-01",0.85962566844919786,0.92506631299734743,"-","-"]
[null,"2021-01-01",0.8915845337376801,0.96912650602409633,0.93055555555555558,0.99021084337349397]
[null,"2021-02-01",0.89081325301204817,0.96912650602409633,0.90788476118271411,0.95383917560003795]
[null,"2021-03-01",0.88855193328279003,0.96912650602409633,0.88122096881220968,0.94809941520467833]
[null,"2021-04-01",0.88031496062992121,1,0.87086614173228349,0.93828798938287994]
[null,"2021-05-01",0.87048192771084343,1,0.85411817387795996,0.91666666666666674]
[null,"2021-06-01",0.86959818043972703,0.99933642999336425,0.85600530856005308,0.91776315789473684]
[null,"2021-07-01",0.86959818043972703,0.94162244124336614,0.85559931841952608,0.92727563798501089]
[null,"2021-08-01",0.87945413191811983,0.94162244124336614,0.87650602409638556,0.92836257309941517]
[null,"2021-09-01",0.89434523809523814,0.96722560975609762,0.86244099797707352,0.9112781954887218]
[null,"2021-10-01",0.89413351314902223,0.96722560975609762,0.86694975230007076,0.93229166666666663]
[null,"2021-11-01",0.89413351314902223,0.96722560975609762,0.83722576079263977,0.89323308270676693]
[null,"2021-12-01",0.89473684210526316,0.95426829268292679,0.83599334567418715,0.90258138989852466]
[null,"2022-01-01",0.89764359351988221,0.9650190114068441,0.84203480589022761,0.92239477555341776]
[null,"2022-02-01",0.89491298527443108,0.95133079847908741,0.86002874024884413,0.91915582844143895]
[null,"2022-03-01",0.89491298527443108,0.95133079847908741,0.85631906587057993,0.9154561298704883]
[null,"2022-04-01",0.89336492890995256,1.0080321285140563,0.865979381443299,0.9125475285171103]
[null,"2022-05-01",0.89764359351988221,1.0080321285140563,0.86255924170616116,0.91706161137440756]
[null,"2022-06-01",0.88733431516936667,1.019882179675994,0.95820858714716706,0.97699719064049628]
[null,"2022-07-01",0.91926345609065152,0.99929178470254953,0.9748520710059172,0.99924471299093653]
[null,"2022-08-01",0.9197303921568627,0.99926035502958577,0.99653464924252766,0.99929178470254953]
[null,"2022-09-01",0.94969999999999999,0.99929999999999997,0.99650000000000005,0.99929999999999997]
[null,"2022-10-01",0.95930000000000004,1.0196000000000001,0.99280000000000002,0.99929999999999997]

{"sheet":"17. Retail offers, SME","index":23,"n_rows":283,"n_cols":13,"rows_kept":283,"cut":false,"hidden":false,"merged":[]}
["Retail Market Offers, Small Business (SME)"]
[{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
[]
["Supplementary Table D17.1",null,null,null,null,null,null,null,null,null,null,null,"Figure D17.1 (report figure C7): Number of single rate market offers, small business, June 2020 to October 2022"]
["Number of single rate market offers, small business, June 2020 to October 2022"]
[]
[null,"NSW",null,"SA",null,"SEQ",null,"VIC"]
["Period","Big3","Non-Big3","Big3","Non-Big3","Big3","Non-Big3","Big3","Non-Big3"]
["2020-06-01",41,150,11,29,11,33,25,227]
["2020-07-01",39,150,10,30,10,38,25,239]
["2020-08-01",39,170,10,48,11,57,25,240]
["2020-09-01",39,248,10,66,11,88,25,192]
["2020-10-01",39,535,10,62,11,82,30,254]
["2020-11-01",43,"-",11,"-",12,"-",35,"-"]
["2020-12-01",34,"-",10,"-",10,"-",40,"-"]
["2021-01-01",34,545,10,67,10,99,20,313]
["2021-02-01",31,548,9,67,9,101,20,351]
["2021-03-01",35,543,10,65,11,97,25,372]
["2021-04-01",39,549,10,65,13,104,30,368]
["2021-05-01",39,550,9,64,13,101,30,380]
["2021-06-01",39,551,9,64,13,101,30,385]
["2021-07-01",38,567,10,66,13,108,36,369]
["2021-08-01",38,574,10,68,13,110,53,383]
["2021-09-01",38,527,10,77,13,127,53,183]
["2021-10-01",38,187,10,53,13,89,53,157]
["2021-11-01",38,196,10,59,13,102,53,183]
["2021-12-01",38,191,10,58,13,108,43,193]
["2022-01-01",38,200,10,59,13,112,37,193]
["2022-02-01",38,197,10,58,13,113,42,196]
["2022-03-01",38,197,10,58,13,113,42,191]
["2022-04-01",41,183,11,59,14,106,42,198]
["2022-05-01",38,181,10,78,13,118,37,203]
["2022-06-01",38,95,10,22,13,70,37,130]
["2022-07-01",38,133,11,37,11,38,26,82]
["2022-08-01",40,131,11,35,11,40,26,100]
["2022-09-01",31,97,9,24,9,31,15,130]
["2022-10-01",34,102,9,24,9,31,32,140,null,null,null,"Source: ACCC analysis of Energy Made Easy and Victorian Energy Compare market offer data, 10 October 2022."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Note: Non-Big3 data in November and December 2020 are not available and have been replaced with modelled estimates in the Figure above."]
[]
[]
[]
["Supplementary Table D17.2",null,null,null,null,null,null,null,null,null,null,null,"Figure D17.2 (report figure C12): Estimated median annual bill, small business single rate market offers ($, real), June 2020 to October 2022"]
["Estimated median annual bill, small business single rate market offers ($, real), June 2020 to October 2022"]
[]
[null,"NSW",null,"SA",null,"SEQ",null,"VIC"]
["Period","Big3","Non-Big3","Big3","Non-Big3","Big3","Non-Big3","Big3","Non-Big3"]
["2020-06-01",6563,6682,8935,8654,5675,5702,6520,6421]
["2020-07-01",6509,6493,7733,8459,5426,5650.5,6470,6370]
["2020-08-01",6390,6336,7733,8272,5491,5637,6486,6347]
["2020-09-01",6291,6243,7613,7850.5,5406,5339.5,6386,6198]
["2020-10-01",6291,6238,7613,7997,5406,5251.5,6386,6209]
["2020-11-01","-","-","-","-","-","-","-","-"]
["2020-12-01","-","-","-","-","-","-","-","-"]
["2021-01-01",6237,6184,7548,7812,5503,5233,5376,5551]
["2021-02-01",6195,6174,7548,7812,5503,5159,5376,5432]
["2021-03-01",6227,6043,7503,7737,5533,5128,5333,5372]
["2021-04-01",6295,6043,7503,7737,5622,5128,5344,5351.5]
["2021-05-01",6295,6000.5,8202,7629.5,5622,5128,5344,5342]
["2021-06-01",6247,5955.5,8140,7571.5,5580,5089,5301,5313]
["2021-07-01",6821,5986,8291,7342,5173,4996,5301,5306]
["2021-08-01",6821,5991.5,8291,7342,5173,5048,5327,5400]
["2021-09-01",6769,5946.5,8229,7184,5134,5025,5360,5269]
["2021-10-01",6769,5946.5,8229,7160.5,5134,5025,5360,5316]
["2021-11-01",6769,5900,8229,7090,5134,4979,5360,5267]
["2021-12-01",6680,5822,8120,6997,5066,4872,5290,5178]
["2022-01-01",6680,5843,8120,6997,5066,4913,5287,5126]
["2022-02-01",6680,5843,8120,7020,5066,4944,5287,5040]
["2022-03-01",6540,5700,7950,6872.5,4960,4780,5176,4930]
["2022-04-01",6230,5735,7950,6770,4960,4880,5176,4928]
["2022-05-01",6540,5762.5,7950,6810,4960,4905,5176,4938]
["2022-06-01",6540,6217.5,7950,6810,4960,5305,5176,5022]
["2022-07-01",7900,7885,8660,8530,6200,6215,5191,5191]
["2022-08-01",7900,7990,8660,8540,6340,6310,5191,5380.5]
["2022-09-01",7660,7755,8575,8740,6155,6240,5164,5413,null,null,null,"Source: ACCC analysis of Energy Made Easy and Victorian Energy Compare market offer data, 10 October 2022."]
["2022-10-01",7660,8010,8575,8740,6155,6240,5139,5412,null,null,null,"Note: Data in November and December 2020 are not available and have been replaced with modelled estimates in the Figure above."]
[]
[]
["Supplementary Table D17.3",null,null,null,null,null,null,null,null,null,null,null,"Figure D17.3 (report figure C10): Number of retailers with at least one small business, single rate market offer below Default Market Offer and Victorian Default Offer, by distribution zone (as at 10 October 2022) "]
["Number of retailers with at least one small business, single rate market offer below Default Market Offer and Victorian Default Offer,"]
["by distribution zone (as at 10 October 2022) "]
[null,"NSW",null,null,"SA","SEQ","VIC"]
[null,"Ausgrid","Endeavour","Essential Energy","SA Power Networks","Energex","AusNet Services (electricity)","Citipower","Jemena","Powercor","United Energy"]
["2021-01-01",26,27,28,21,23,16,17,14,16,15]
["2021-02-01",28,28,29,21,26,19,20,17,19,18]
["2021-03-01",27,27,28,20,25,21,22,19,21,20]
["2021-04-01",28,28,28,20,25,22,22,20,22,21]
["2021-05-01",29,29,29,20,26,23,23,22,23,22]
["2021-06-01",29,29,29,20,26,23,21,20,24,20]
["2021-07-01",28,29,29,19,27,22,21,19,22,20]
["2021-08-01",29,31,30,20,28,20,19,16,20,19]
["2021-09-01",29,31,30,21,29,0,21,14,21,19]
["2021-10-01",29,30,30,22,28,0,18,13,18,16]
["2021-11-01",30,32,31,21,30,0,21,14,21,21]
["2021-12-01",29,31,31,21,30,0,20,14,20,21]
["2022-01-01",28,30,30,21,30,18,13,18,15,16]
["2022-02-01",28,30,30,20,30,18,14,18,15,17]
["2022-03-01",27,29,28,20,29,18,15,18,15,17]
["2022-04-01",25,27,26,21,27,18,15,18,15,17]
["2022-05-01",23,25,25,22,24,17,14,17,14,16]
["2022-06-01",13,14,14,12,11,10,9,10,8,9]
["2022-07-01",12,13,11,11,13,12,11,5,7,9,null,"Source: ACCC analysis of Energy Made Easy and Victorian Energy Compare market offer data, 10 October 2022."]
["2022-08-01",11,11,12,8,9,14,12,6,6,8]
["2022-09-01",10,10,8,6,8,13,11,7,7,8]
["2022-10-01",10,10,9,6,8,15,13,9,9,10]
[]
[]
["Supplementary Table D17.4",null,null,null,null,null,null,null,null,null,null,null,"Figure D17.4 (report figure C9): Number of single rate market offers below the Default Market Offer and Victorian Default Offer, small business, January to October 2022"]
["Number of single rate market offers below the Default Market Offer and Victorian Default Offer, small business, January to October 2022"]
[]
[null,"NSW",null,null,"SA","SEQ","VIC"]
[2022,"Ausgrid","Endeavour","Essential Energy","SA Power Networks","Energex","AusNet Services (electricity)","Citipower","Jemena","Powercor","United Energy"]
["Jan",64,64,69,68,107,29,18,29,21,23]
["Feb",63,63,68,67,107,29,23,30,23,28]
["Mar",62,63,68,67,107,29,24,30,23,28]
["Apr",57,58,63,69,101,31,26,32,25,30]
["May",54,56,62,69,89,29,24,30,23,28]
["Jun",29,29,35,31,41,16,15,19,13,16]
["Jul",16,18,16,16,23,18,16,10,15,16]
["Aug",15,16,17,9,14,19,17,10,16,17]
["Sep",16,16,16,9,16,23,21,15,20,21]
["Oct",16,16,17,9,16,28,25,19,25,28]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis of Energy Made Easy and Victorian Energy Compare market offer data, 10 October 2022."]
[]
[]
["Supplementary Table D17.5",null,null,null,null,null,null,null,null,null,null,null,"Figure D17.5: Distribution of single rate market offers relative to the Default Market Offer and Victorian Default offer, small business, as at 10 October 2022"]
["Distribution of single rate market offers relative to the DMO / VDO, small business, as at 10 October 2022"]
[null,"NSW",null,"SA",null,"SEQ",null,"VIC"]
["Pecentage vs DMO","Big3","Non-Big3","Big3","Non-Big3","Big3","Non-Big3","Big3","Non-Big3"]
["<84%","-",2,"-",1,"-","-","-","-"]
["84% - 88%",1,5,"-","-","-",1,"-","-"]
["88% - 92%",4,19,"-",2,"-",2,"-","-"]
["92% - 96%",1,6,2,2,2,6,"-",9]
["96% - 100%",5,6,2,"-",3,2,29,87]
["100% - 104%",10,15,4,13,3,10,3,15]
["104% - 108%",3,9,"-","-","-","-","-",1]
[">108%",3,29,1,6,1,10,"-",28]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis of Energy Made Easy and Victorian Energy Compare market offer data, 10 October 2022."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Note: Some market offers included in above Figure may not be available to all customers"]
[]
[]
["Supplementary Table D17.6",null,null,null,null,null,null,null,null,null,null,null,"Figure D17.6 (report figure C11): Minimum and maximum market offers compared with the Default Market Offer and Victorian Default Offer, small business single rate, June 2020 to October 2022 "]
["Median of minimum and median of maximum market offers compared with the DMO/VDO, small business single rate"]
[]
["Region","Period","Big3 Min","Big3 Max","Non-Big3 Min","Non-Big3 Max"]
["NSW","2020-06-01",0.83,0.88,0.83816892327530623,0.86962420295753629]
[null,"2020-07-01",0.83,0.88,0.83050024283632828,0.84116022099447518]
[null,"2020-08-01",0.82,0.88,0.81935884404310699,0.82393316092044844]
[null,"2020-09-01",0.82,0.88,0.81033706624602819,0.8204419889502762]
[null,"2020-10-01",0.82,0.88,0.81033706624602819,0.82393316092044844]
[null,"2020-11-01",0.82,0.88,0.81,0.82]
[null,"2020-12-01",0.82,0.88,0.81,0.82]
[null,"2021-01-01",0.82,0.88,0.80942334645454483,0.81835842642059253]
[null,"2021-02-01",0.82,0.82,0.80297879229399383,0.80960079592090539]
[null,"2021-03-01",0.82,0.84,0.79974097458313098,0.81835842642059253]
[null,"2021-04-01",0.82,0.89,0.79893152015541524,0.82980465789623759]
[null,"2021-05-01",0.82,0.89,0.79974097458313098,0.82888133398089692]
[null,"2021-06-01",0.82,0.89,0.79974097458313098,0.82888133398089692]
[null,"2021-07-01",0.82,0.89,0.83493774868437942,0.86188051442255276]
[null,"2021-08-01",0.82,0.89,0.83493774868437942,0.8636238895968904]
[null,"2021-09-01",0.82,0.89,0.83230120421106002,0.86188051442255276]
[null,"2021-10-01",0.82,0.89,0.83101767193022313,0.86188051442255276]
[null,"2021-11-01",0.82,0.89,0.82635983263598323,0.86122733612273361]
[null,"2021-12-01",0.82,0.89,0.82635983263598323,0.85251046025104604]
[null,"2022-01-01",0.82,0.89,0.82711907688788,0.86297071129707115]
[null,"2022-02-01",0.84,0.91,0.82711907688788,0.85016827360378389]
[null,"2022-03-01",0.84,0.91,0.82622339457886118,0.84683693001400728]
[null,"2022-04-01",0.84,0.91,0.8298465829846583,0.86122733612273361]
[null,"2022-05-01",0.85,0.91,0.83301245026312409,0.896094839609484]
[null,"2022-06-01",0.85,0.91,0.86063913649869628,0.91204433932726792]
[null,"2022-07-01",0.91,1.04,1.0165603670135392,1.0342377536174316]
[null,"2022-08-01",0.91,1.04,1.0225719597658738,1.0358396564409291]
[null,"2022-09-01",0.92,1.02,1,1.03]
[null,"2022-10-01",0.91,1.02,1,1.03]
["SA","2020-06-01",0.859649122807018,0.94956140350877205,0.859649122807018,0.88486842105263197]
[null,"2020-07-01",0.85009030704394895,0.95003010234798302,0.92474413004214295,0.95364238410596003]
[null,"2020-08-01",0.85009030704394895,0.97049969897652,0.88199879590608099,0.94220349187236596]
[null,"2020-09-01",0.85009030704394895,0.97049969897652,0.86574352799518395,0.92233594220349202,null,null,null,null,null,null,"Source: ACCC analysis of Energy Made Easy and Victorian Energy Compare market offer data, 10 October 2022."]
[null,"2020-10-01",0.85009030704394895,0.97049969897652,0.86935580975316096,0.94039735099337796]
[null,"2020-11-01",0.85009030704394895,0.97049969897652,0.86935580975316096,0.94039735099337796]
[null,"2020-12-01",0.856110776640578,0.97049969897652,0.86935580975316096,0.94039735099337796]
[null,"2021-01-01",0.856110776640578,0.97049969897652,0.86213124623720605,0.90427453341360597]
[null,"2021-02-01",0.856110776640578,0.97049969897652,0.86213124623720605,0.90427453341360597]
[null,"2021-03-01",0.856110776640578,0.98976520168573101,0.86213124623720605,0.92354003612281799]
[null,"2021-04-01",0.856110776640578,0.98976520168573101,0.86213124623720605,0.92354003612281799]
[null,"2021-05-01",0.85972305839855501,0.98976520168573101,0.85129440096327502,0.89644792293798903]
[null,"2021-06-01",0.85972305839855501,0.98976520168573101,0.85129440096327502,0.89644792293798903]
[null,"2021-07-01",0.85024274866176996,0.99962654052035305,0.86704842524586101,0.87638491223702197]
[null,"2021-08-01",0.85024274866176996,0.99962654052035305,0.86704842524586101,0.87638491223702197]
[null,"2021-09-01",0.85024274866176996,0.99962654052035305,0.85273247852608003,0.86393626291547398]
[null,"2021-10-01",0.85024274866176996,0.99962654052035305,0.85397734345823495,0.86393626291547398]
[null,"2021-11-01",0.85024274866176996,0.99962654052035305,0.85273247852608003,0.85273247852608003]
[null,"2021-12-01",0.91995518486244199,0.99962654052035305,0.85273247852608003,0.85273247852608003]
[null,"2022-01-01",0.91995518486244199,0.99962654052035305,0.85273247852608003,0.85273247852608003]
[null,"2022-02-01",0.91995518486244199,0.99962654052035305,0.85273247852608003,0.85833437072077701]
[null,"2022-03-01",0.91995518486244199,0.99962654052035305,0.85273247852608003,0.85833437072077701]
[null,"2022-04-01",0.91995518486244199,0.99962654052035305,0.84277355906884099,0.85273247852608003]
[null,"2022-05-01",0.91995518486244199,0.99962654052035305,0.84215112660276403,0.86393626291547398]
[null,"2022-06-01",0.91995518486244199,0.99962654052035305,0.84775301879746001,0.85833437072077701]
[null,"2022-07-01",0.93617522373999096,1.0197833254828099,1.0044747998115899,1.0174281676872401]
[null,"2022-08-01",0.93617522373999063,1.0197833254828073,1.0044747998115873,1.017428167687235]
[null,"2022-09-01",0.93620000000000003,1.0198,1.0291999999999999,1.0291999999999999]
[null,"2022-10-01",0.93620000000000003,1.0198,1.0291999999999999,1.0291999999999999]
["SEQ","2020-06-01",0.86970954356846475,0.86970954356846475,0.86970954356846475,0.88298755186721989]
[null,"2020-07-01",0.86979166666666663,0.86979166666666663,0.85763888888888884,0.92361111111111116]
[null,"2020-08-01",0.86979166666666663,0.9375,0.85590277777777779,0.91145833333333337]
[null,"2020-09-01",0.86979166666666663,0.9375,0.84722222222222221,0.86111111111111116]
[null,"2020-10-01",0.86979166666666663,0.9375,0.83680555555555558,0.859375]
[null,"2020-11-01",0.86979166666666663,0.9375,0.8359375,0.87297453703703709]
[null,"2020-12-01",0.86979166666666663,0.9375,0.83506944444444442,0.88657407407407407]
[null,"2021-01-01",0.86979166666666663,0.9375,0.83420138888888884,0.90017361111111116]
[null,"2021-02-01",0.86979166666666663,0.9375,0.83072916666666674,0.85416666666666674]
[null,"2021-03-01",0.86979166666666663,0.96006944444444442,0.82986111111111116,0.84895833333333337]
[null,"2021-04-01",0.86979166666666663,0.99131944444444442,0.81944444444444442,0.84722222222222221]
[null,"2021-05-01",0.86979166666666663,0.99131944444444442,0.81510416666666663,0.84722222222222221]
[null,"2021-06-01",0.86979166666666663,0.99131944444444442,0.81423611111111116,0.84722222222222221]
[null,"2021-07-01",0.87003806416530727,0.89903933297081751,0.84828711256117451,0.86913177451513501]
[null,"2021-08-01",0.87003806416530727,0.89903933297081751,0.84828711256117451,0.87275693311582381]
[null,"2021-09-01",0.87003806416530727,0.89903933297081751,0.85100598151169105,0.88000725031720139]
[null,"2021-10-01",0.87003806416530727,0.89903933297081751,0.8519122711618633,0.88000725031720139]
[null,"2021-11-01",0.87003806416530727,0.90991480877288378,0.8500996918615189,0.87003806416530727]
[null,"2021-12-01",0.87003806416530727,0.90991480877288378,0.84647453326083011,0.86641290556461847]
[null,"2022-01-01",0.87003806416530727,0.90991480877288378,0.84647453326083011,0.87003806416530727]
[null,"2022-02-01",0.87003806416530727,0.90991480877288378,0.84647453326083011,0.87910096066702914]
[null,"2022-03-01",0.87003806416530727,0.90991480877288378,0.84647453326083011,0.87910096066702925]
[null,"2022-04-01",0.87003806416530727,0.90991480877288378,0.8519122711618633,0.88544498821823447]
[null,"2022-05-01",0.87910096066702914,0.90991480877288378,0.85825629871306863,0.93347833967736094]
[null,"2022-06-01",0.87910096066702914,0.90991480877288378,0.94254123617908281,0.98060540148631503]
[null,"2022-07-01",0.93539054966248791,1.018964963034394,0.99324975891996148,1.01575056252009]
[null,"2022-08-01",0.93699774991964002,1.018964963034394,1.0028999999999999,1.0173577627772421]
[null,"2022-09-01",0.93700000000000006,0.99970000000000003,1.0028999999999999,1.0028999999999999]
[null,"2022-10-01",0.93700000000000006,0.99970000000000003,1.0028999999999999,1.0028999999999999]
["VIC","2020-06-01",0.94985402713377987,0.97990726429675423,0.95016025641025637,0.96015799416108538]
[null,"2020-07-01",0.94744169857292027,0.97750300532371626,0.93973245918305126,0.95727897029119113]
[null,"2020-08-01",0.94985402713377987,0.97990726429675423,0.93520189159336531,0.9520318482422554]
[null,"2020-09-01",0.94985402713377987,0.97990726429675423,0.9339985182321866,0.95010623332173105]
[null,"2020-10-01",0.94983974358974355,0.97990726429675423,0.93525931082492197,0.95016025641025637]
[null,"2020-11-01",0.95005221023320574,0.98007899708054269,0.95576672431018539,0.96599375962320544]
[null,"2020-12-01",0.94987817612252001,0.97990726429675423,0.97627413779544869,0.98182726283615462]
[null,"2021-01-01",0.96994337156962396,0.96994337156962396,0.996781551280712,0.9976607660491037]
[null,"2021-02-01",0.96994337156962396,0.96994337156962396,0.98641249239505169,0.997527577025485]
[null,"2021-03-01",0.95017116774438948,0.98025264992013939,0.96572703305617524,0.99764474975466144]
[null,"2021-04-01",0.95017116774438948,0.98025264992013939,0.95853662635843628,0.99586176854944097]
[null,"2021-05-01",0.95017116774438948,0.98025264992013939,0.94522632179535948,0.98959764474975465]
[null,"2021-06-01",0.94998098136173448,0.97988614800759011,0.94731837200456448,0.98940137389597649]
[null,"2021-07-01",0.94998098136173448,0.98010744881661105,0.93699705593719329,0.98693190068244518]
[null,"2021-08-01",0.94998098136173448,1.0095315351855607,0.96957017877519969,0.99980372914622173]
[null,"2021-09-01",0.98559135481288773,1.0187646598905395,0.96630727762803237,0.99452928207276203]
[null,"2021-10-01",0.98559135481288773,1.0187646598905395,0.97678607164298581,1.0078186082877247]
[null,"2021-11-01",0.98559135481288773,1.0187646598905395,0.97602148474966433,0.99788989065797051]
[null,"2021-12-01",1.0119233776387804,1.0164190774042221,0.97506234413965087,0.98699219531719029]
[null,"2022-01-01",0.97634842803576583,1.039719194531683,0.96961159186959145,1.0011084426380934]
[null,"2022-02-01",0.97634842803576583,1.039719194531683,0.96483562213899288,0.99437554081338331]
[null,"2022-03-01",0.97634842803576583,1.039719194531683,0.9654598418643362,1.0009237021984112]
[null,"2022-04-01",0.97634842803576583,1.039719194531683,0.9654598418643362,1.0009237021984112]
[null,"2022-05-01",0.98298240553792904,1.039719194531683,0.98026734563971996,1.0033169887510816]
[null,"2022-06-01",0.98298240553792904,1.039719194531683,1.0030440476731575,1.0057879754114807]
[null,"2022-07-01",0.99979334573258938,0.99986938349007315,0.99960023985608637,0.99961471778077438]
[null,"2022-08-01",0.99979334573258938,0.99986938349007315,1,1]
[null,"2022-09-01",0.99490000000000001,0.99490000000000001,0.99980000000000002,1]
[null,"2022-10-01",0.98980000000000001,0.99990000000000001,0.99980000000000002,1]

{"sheet":"Lists","index":24,"n_rows":54,"n_cols":3,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Glossary"]
[null,"Term","Definition"]
[null,"Novation","Agreement between 2 contracting parties to allow for substituion of a new party for an existing one"]
[null,"Custom Cap","Non-$300 caps, OTC only"]
[null,"$300 Cap","Covers all $300 caps (ASX or OTC). Also called Standard Caps or Caps"]
[null,"Load Following Swap","aka Load Following, Load Following Hedge, Load Following Contract"]
[null,"Cancel","Cancel of an existing contract"]
[null,"Novation (Cancel)","Cancelation fo an existing contract due to novation of that contract to a new party"]
[null,"Novation (Purchase)","Continuation of a contract with potential changes due to novation to a different party"]
[]
[]
[null,"Look-up tables"]
[null,"Contract","Category"]
[null,"Load_Following_Swap","Futures"]
[null,"Super_Peak_Swap","Futures"]
[null,"Peak_Swap","Futures"]
[null,"Solar_Swap","Futures"]
[null,"Base_Swap","Futures"]
[null,"Cap","Option"]
[null,"Reallocation","N/A"]
[null,"Floor","Option"]
[null,"Demand_response","Futures"]
[null,"Renewable_PPA","PPA"]
[null,"Swaption","Option"]
[null,"Option","Option"]
[null,"IRSR","Other"]
[null,"Weather","Option"]
[null,"Other","Other"]
[null,"Month","Quarter"]
[null,1,"Q1"]
[null,2,"Q1"]
[null,3,"Q1"]
[null,4,"Q2"]
[null,5,"Q2"]
[null,6,"Q2"]
[null,7,"Q3"]
[null,8,"Q3"]
[null,9,"Q3"]
[null,10,"Q4"]
[null,11,"Q4"]
[null,12,"Q4"]