{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["Contents","1. Retail market share","Cost Stack >>","2. NEM $customer","3. NEM ckWh","4. Regional ckWh","5. Network","6. Wholesale","7. Environmental","8. Retail costs and margins","Retail Pricing >>","9. Residential (unconditional)","10. Residential (conditional)","11. Small business","Contracts >>","12. Swap and Cap Prices ","13. Contract volumes by region","14. Delivery Periods","15. Survey responses","16. Volume by market","CPI >>","17. CPI table"],"not_rendered":{"charts":0,"images":100,"macros":0,"external_links":0,"defined_names":119,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Contents","index":0,"n_rows":107,"n_cols":4,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Inquiry into the National Electricity Market: December 2023 Report"]
[null,"Appendix C",null,"Data appendix"]
[]
[null,"Contents"]
[]
[null,"This spreadsheet contains data tables for all ACCC-authored figures in the report. "]
[null,"It also includes supplementary analysis of cost stack and retail pricing data not presented in the body of the report, including additional regional breakdowns."]
[]
[null,"Based on retail market data"]
[null,"Sheet name","Description"]
[null,"1. Retail market share","Retail market share and residential retail market offers"]
[]
[null,"Based on cost stack data"]
[null,"Sheet name","Description"]
[null,"2. NEM $ / customer","NEM-wide Cost Stacks, $/customer"]
[null,"3. NEM c / kWh","NEM-wide Cost Stacks, c/kWh"]
[null,"4. Regional c / kWh","Regional Cost Stacks, c/kWh"]
[null,"5. Network costs","Network costs category breakdown"]
[null,"6. Wholesale costs","Wholesale electricity costs"]
[null,"7. Environmental costs","Environmental cost category breakdown"]
[null,"8. Retail costs and margins","Retail costs and retail margins"]
[]
[null,"Based on retail pricing data"]
[null,"Sheet name","Description"]
[null,"9. Residential (unconditional)","Market offer prices, residential, assuming conditional discounts are not achieved"]
[null,"10. Residential (conditional)","Market offer prices, residential, assuming 100% achievement of conditional discounts"]
[null,"11. Small business","Market offer prices, small business"]
[]
[null,"Based on hedging contract data"]
[null,"Sheet name","Description"]
[null,"12. Swap and Cap Prices","Price trends in swap and cap contracts between January 2021 and June 2023"]
[null,"13. Monthly volumes by region","Total volume of sales and total volume of purchases in each region by month"]
[null,"14. Delivery Periods","Average delivery period of contracts traded each month, for small and large retailers"]
[null,"15. Survey responses","Ability to execute target hedging strategy and factors impacting contract sales"]
[null,"16. Volume by market","Proportion of volume traded on ASX and OTC each quarter for small and large retailers"]
[]
[null,"Based on Australian Bureau of Statistics data"]
[null,"Sheet name","Description"]
[null,"17. Consumer Price Index (CPI) table","CPI figures used for analysis"]
[]
[null,"Direct links to data tables and figures included in the report"]
[null,"Note. Charts and data tables which rely on publicly accessible data published by other market bodies have not been reproduced in this appendix. Please refer to the source notes in the report. "]
[]
[null,"Chapter 2","Competition and costs in retail electricity markets"]
[null,"Report figure","Description"]
[null,"Figure 2.1","National Electricity Market Volume Weighted Spot Price by Location 2021-2023."]
[null,"Figure 2.2","Daily Futures Contract Settlement Price by Location 2021-2023."]
[null,"Figure 2.3","Herfindahl-Hirschman Index by region, December 2009 – June 2023"]
[null,"Figure 2.4","Retail electricity market share by region, 2022-23"]
[null,"Figure 2.5","Retailer exits (surrender or revocation of retailer authorisation) and retailer entry (grant of authorisation) by year, National Electricity Market (excl. Victoria)"]
[null,"Figure 2.6","Number of active electricity retailers by year and region, 2018–2023"]
[null,"Figure 2.9","Retailer cost stacks increased in 2022-23."]
[null,"Figure 2.10","Change in cost components for the average residential customer across the NEM from 2021–22 to 2022–23"]
[null,"Figure 2.11","Average retailer wholesale costs (measured in effective price) for residential customers by National Electricity Market regions, 2018-19 to 2022-23, real, excluding GST"]
[null,"Figure 2.12","Average retail margins (as earnings before interest, tax, depreciation and amortisation or EBITDA) per residential customer across the NEM, 2007–08 to 2022–23"]
[null,"Figure 2.13","Average retail margins (earnings before interest, tax, depreciation and amortisation) per residential customer, by region, 2016–8-197 to 2022-23"]
[null,"Figure 2.14","Average retail margins (earnings before interest, tax, depreciation and amortisation) for small business customers, c/kWh, by region, 2016-–17 to 2022-–23"]
[null,"Figure 2.15","Retail and other costs per residential customer across the National Electricity Market, 2007-08 to 2022-23, real, excluding GST"]
[]
[null,"Chapter 3","Retail Pricing"]
[null,"Report figure","Description"]
[null,"Figure 3.1 (top)","Customer-weighted average unconditional annual price, residential customers by tariff type and year, all regions, nominal, GST inclusive"]
[null,"Figure 3.1 (bottom)","Customer-weighted average unconditional annual price, small business customers on flat rate tariffs by year, all regions, nominal, GST inclusive"]
[null,"Figure 3.2 (top)","Proportion of residential customers on flat rate plans paying more, equal to, or less than the DMO/VDO, assuming conditional discounts are not achieved"]
[null,"Figure 3.2 (bottom)","Proportion of residential customers on flat rate plans paying more, equal to, or less than the DMO/VDO assuming 100% achievement of conditional discounts"]
[null,"Figure 3.3 (top)","Proportion of small business customers on flat rate plans paying more, equal to, or less than the DMO/VDO, assuming conditional discounts are not achieved"]
[null,"Figure 3.3 (bottom)","Proportion of small business customers on flat rate plans paying more, equal to, or less than the DMO/VDO assuming 100% achievement of conditional discounts"]
[null,"Figure 3.4 (top)","Proportion of residential concession customers on flat rate and flat rate with controlled load market offer plans paying more, equal to, or less than the DMO/VDO, assuming conditional discounts are not achieved, all regions"]
[null,"Figure 3.4 (bottom)","Proportion of residential concession customers on flat rate and flat rate with controlled load market offer plans paying more, equal to, or less than the DMO/VDO, assuming 100% achievement of conditional discounts, all regions"]
[null,"Figure 3.5 (top) ","Proportion of residential customers on flat rate plans paying annual unconditional prices that are more, equal to, or less than the DMO/VDO in 2022 by state"]
[null,"Figure 3.5 (bottom)","Proportion of residential customers on flat rate plans paying annual unconditional prices that are more, equal to, or less than the DMO/VDO in 2023 by state"]
[null,"Figure 3.6 (top)","Proportion of residential customers on time-of-use only tariffs paying equal to or more than the DMO by retailer (anonymised) and year, SA Power Networks distribution region"]
[null,"Figure 3.6 (bottom)","Proportion of residential customers on time-of-use only tariffs paying equal to, or more than the DMO by retailer (anonymised) and year, Ausgrid distribution region"]
[null,"Figure 3.7 (top)","Customer-weighted average solar feed-in tariff for solar residential flat rate and flat rate with controlled load market offer plans by discount tier to the DMO/VDO, assuming conditional discounts are not achieved and excluding offers with subsidised solar feed-in tariffs, all regions"]
[null,"Figure 3.7 (bottom)","Customer-weighted average solar feed-in tariff for solar residential flat rate and flat rate with controlled load market offer plans by discount tier to the DMO/VDO, assuming 100% achievement of conditional discounts and excluding offers with subsidised solar feed-in tariffs, all regions"]
[null,"Figure 3.8","Proportion of residential customers on plans with conditional discounts and customer-weighted average conditional discount by percentage above the DMO/VDO in 2023 "]
[null,"Figure 3.9","Proportion of small business customers on plans with conditional discounts and customer-weighted average conditional discount by percentage above the DMO/VDO in 2023 "]
[null,"Figure 3.10","Estimated median annual bill, residential flat rate market offers ($, nominal), September 2020 to September 2023"]
[null,"Figure 3.11 (top)","Proportion of residential customers on flat rate and flat rate with controlled load market offer plans paying more, equal to, or less than the EME/VEC median bill, assuming conditional discounts are not achieved"]
[null,"Figure 3.11 (bottom)","Proportion of residential customers on flat rate and flat rate with controlled load market offer plans paying more, equal to, or less than the EME/VEC median bill, assuming 100% achievement of conditional discounts"]
[null,"Figure 3.12","Customer-weighted average price for residential customers on plans which existed in 2022 and 2023 (Older Plans) and on plans which only existed in 2023 (Newer Plans) by state "]
[null,"Figure 3.13","Proportion of residential customers by discount to the DMO/VDO, plans which existed in 2022 and 2023 (Older Plans) and on plans which only existed in 2023 (Newer Plans) excluding conditional discounts"]
[]
[null,"Chapter 4","Contract market outcomes"]
[null,"Report figure","Description"]
[null,"Figure 4.1","Average strike price of swap contracts purchased from January 2021 to June 2023 with delivery periods in 2024."]
[null,"Figure 4.2","Average premium price of cap contracts purchased from March 2021 to June 2023 with delivery periods in 2024."]
[null,"Figure 4.3","Total traded volumes (GWh) of ASX and OTC contracts bought and sold, excluding caps, options and weather derivatives, from January 2021 to June 2023, all delivery periods"]
[null,"Figure 4.4","Average delivery period of purchased contracts from January 2021 to July 2023."]
[]
[null,"Chapter 5","Financial risk management by small retailers"]
[null,"Report figure","Description"]
[null,"Figure 5.1","Average of retailers’ level of agreement that the Company was able to execute its target hedging strategy in that trading quarter (from quarter 3 2021 to July 2023) with respect to each delivery period (quarter 3 2023 to quarter 3 2024)."]
[null,"Figure 5.2","Proportion of total volume of contracts traded by large and small retailers OTC, on the ASX and on FEX, Q1 2021 to Q3 2023"]
[null,"Figure 5.3","The significance of different factors, relating to reduced coal and gas generation, affecting the types of contracts sold by large generators and gentailers over the next 10 years."]
[null,"Figure 5.4","The significance of different factors relating to investment in renewables affecting the types of contracts sold by large generators and gentailers over the next 10 years."]
[]
[null,"Appendix B","Methodology for data collection and analysis"]
[null,"Appendix figure","Description"]
[null,"Figure B.1 (top)","Average usage charge for residential flat rate and flat rate with controlled load market offer plans by discount tier to the DMO/VDO, all regions"]
[null,"Figure B.1 (bottom)","Average supply charge for residential flat rate and flat rate with controlled load market offer plans by discount tier to the DMO/VDO, all regions"]

{"sheet":"1. Retail market share","index":1,"n_rows":141,"n_cols":12,"rows_kept":141,"cut":false,"hidden":false,"merged":[[7,21,7,28],[99,2,99,3],[99,4,99,5],[99,6,99,7],[99,8,99,9]]}
[]
[null,"Retail market"]
[null,"1. Retail market share"]
[null,"Contents"]
[]
[null,"Supplementary Table C1.1",null,null,null,null,null,null,null,null,null,"Figure C1.1 (Figure 2.3 in report)"]
[null,"Herfindahl-Hirschman Index by region, December 2009 – June 2023",null,null,null,null,null,null,null,null,null,"Herfindahl-Hirschman Index by region, December 2009 – June 2023"]
[]
[null,"HHI","NSW","VIC","SEQ","SA","TAS","ACT"]
[null,"Dec 09",4067,2108,5163,3801,10000,8987]
[null,"Dec 10",3860,2039,4739,3792,10000,9136]
[null,"Dec 11",3484,1919,4285,3605,10000,9207]
[null,"Dec 12",3200,1813,4150,3491,10000,9238]
[null,"Dec 13",3171,1818,4079,3258,10000,9249]
[null,"Dec 14",2996,1765,3895,3120,10000,9214]
[null,"Dec 15",2868,1679,3807,3013,10000,8737]
[null,"Dec 16",2714,1596,3697,2842,10000,8315]
[null,"Dec 17",2556,1551,3246,2732,10000,8002]
[null,"Dec 18",2481,1413,2885,2656,10000,7302]
[null,"Jun 19",2336,1269,2665,2387,9935,6908]
[null,"Jun 20",2244,1254,2538,2356,9717,6541]
[null,"Jun 21",2206,1306,2524,2447,9440,6035]
[null,"Jun 22",2145,1255,2522,2386,9063,5547]
[null,"Jun 23",2060,1309,2509,2460,8890,5809]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source: AEMC, AER."]
[]
[]
[null,"Supplementary Table C1.2",null,null,null,null,null,null,null,null,null,"Figure C1.2 (Figure 2.4 in report)"]
[null,"Retail electricity market share by region, 2022-23",null,null,null,null,null,null,null,null,null,"Retail electricity market share by region, 2022-23"]
[]
[]
[null,null,"NEM","NSW","VIC","SEQ","RQ","SA","TAS","ACT"]
[null,"ActewAGL",1.7999999999999999E-2,0.01,0,0,0,0,0,0.745]
[null,"AGL",0.22600000000000001,0.23699999999999999,0.23499999999999999,0.26800000000000002,0,0.38600000000000001,0,0]
[null,"Aurora Energy",2.5999999999999999E-2,0,0,0,0,0,0.94199999999999995,0]
[null,"EnergyAustralia",0.14599999999999999,0.246,0.14899999999999999,6.5000000000000002E-2,0,6.3E-2,0,4.9000000000000002E-2]
[null,"Ergon Energy",7.1999999999999995E-2,0,0,0,1,0,0,0]
[null,"Origin Energy",0.23799999999999999,0.28100000000000003,0.17399999999999999,0.39200000000000002,0,0.28599999999999998,0,0.156]
[null,"Other Retailers",0.27400000000000002,0.22600000000000001,0.442,0.27500000000000002,0,0.26500000000000001,5.8000000000000003E-2,0.05]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source:\t Australian Energy Regulator, Retail energy market performance update for Quarter 4, 2022–23 [data set], AER website; Essential Services Commission, Energy market dashboard [data set], ESCV website. "]
[null,null,null,null,null,null,null,null,null,null,null,"Note: NEM = National Electricity Market, NSW = New South Wales, VIC = Victoria, SEQ = South East Queensland, RQ = Regional Queensland, SA = South Australia, TAS = Tasmania, ACT = Australian Capital Territory."]
[]
[]
[]
[null,"Supplementary Table C1.3",null,null,null,null,null,null,null,null,null,"Figure C1.3 (Figure 2.5 in report)"]
[null,"Number of retailer exits, NEM combined",null,null,null,null,null,null,null,null,null,"Retailer exits (surrender or revocation of retailer authorisation) and retailer entry (grant of authorisation) by year, National Electricity Market (excl. Victoria)"]
[]
[null,"Year","Revoked","Surrendered","Authorised"]
[null,2016,-1,null,3]
[null,2017,-1,null,7]
[null,2018,-1,null,8]
[null,2019,-1,-1,12]
[null,2020,0,null,10]
[null,2021,0,-1,7]
[null,2022,-6,-2,5]
[null,2023,-3,-1]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of Australian Energy Regulator, Public register of authorised retailers & authorisation applications, AER website, n.d., accessed 20 September 2023. "]
[null,null,null,null,null,null,null,null,null,null,null,"Note: Surrenders of retail licences can occur for a variety of reasons, and do not necessarily indicate an active retailer has left the market. For example, of the 4 retail surrenders between July 2022 and March 2023, 3 had no or very few customers prior to surrender and one transferred its customer base to its parent company."]
[]
[]
[null,"Supplementary Table C1.4",null,null,null,null,null,null,null,null,null,"Figure C1.4 (Figure 2.6 in report)"]
[null,"Number of active retailers, by region",null,null,null,null,null,null,null,null,null,"Number of active electricity retailers by year and region, 2018–2023"]
[]
[]
[null,null,"2018-19","2019-20","2020-21","2021-22","2022-23"]
[null,"VIC",26,26,30,32,30]
[null,"NSW",34,44,46,47,42]
[null,"SA",22,27,31,36,32]
[null,"SEQ",26,33,42,45,38]
[null,"ACT",6,7,10,12,11]
[null,"TAS",3,4,4,6,5]
[null,"NEM",47,56,59,62,59]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of the AER’s retail performance data; ESC, Energy market dashboard, ESC website, n.d., accessed 31 October 2023; ESC, Victorian Energy Market Report, ESC website, n.d., accessed 31 October 2023."]
[null,null,null,null,null,null,null,null,null,null,null,"Note: The number of active Victorian electricity retailers from 2018–-2020 were attained from the retailer profiles section of previous Victorian energy market reports. The number of active Victorian electricity retailers from 2021–2023 were attained from the energy market dashboard. An active retailer is defined as a retailer with more than 50 customers. "]
[]
[null,"Supplementary Table C1.5",null,null,null,null,null,null,null,null,null,"Figure C1.5 (Figure 3.10 in report)"]
[null,"By region, $/year",null,null,null,null,null,null,null,null,null,"Estimated median annual bill, residential flat rate market offers ($, nominal), September 2020 to September 2023"]
[null,null,"NSW",null,"VIC",null,"SA",null,"SEQ"]
[null,"Period","Annual bill ($)","Estimated standing offer price cap","Annual bill ($)","Estimated standing offer price cap","Annual bill ($)","Estimated standing offer price cap","Annual bill ($)","Estimated standing offer price cap"]
[null,"2020-06-01",1495,1720,1770,1941,1394,1508,1385,1570]
[null,"2020-07-01",1487.5,1711,1710,1832,1372,1508,1347.5,1508]
[null,"2020-08-01",1470,1711,1645,1832,1359.5,1508,1320,1508]
[null,"2020-09-01",1455,1711,1630,1832,1347,1508,1280,1508]
[null,"2020-10-01",1440,1711,1625,1832,1351,1508,1270,1508]
[null,"2020-11-01",null,1711,null,1832,null,1508,null,1508]
[null,"2020-12-01",null,1711,null,1832,null,1508,null,1508]
[null,"2021-01-01",1447.5,1711,1610,1832,1273,1328,1275,1508]
[null,"2021-02-01",1420,1711,1610,1832,1243,1328,1260,1508]
[null,"2021-03-01",1417.5,1711,1620,1832,1220,1328,1255,1508]
[null,"2021-04-01",1420,1711,1610,1832,1211.5,1328,1252.5,1508]
[null,"2021-05-01",1417.5,1711,1585,1832,1198,1328,1250,1508]
[null,"2021-06-01",1420,1711,1585,1832,1201,1328,1250,1508]
[null,"2021-07-01",1380,1609,1570,1716,1210,1328,1255,1455]
[null,"2021-08-01",1380,1609,1570,1716,1219.5,1328,1250,1455]
[null,"2021-09-01",1380,1609,1535,1716,1211.5,1344,1250,1455]
[null,"2021-10-01",1377.5,1609,1517.5,1716,1213.5,1344,1250,1455]
[null,"2021-11-01",1370,1609,1515,1716,1183,1344,1250,1455,null,"Source:\t ACCC analysis on Energy Made Easy and Victorian Energy Compare market offers dataset."]
[null,"2021-12-01",1372.5,1609,1515,1716,1188,1344,1250,1455,null,"Note: The ACCC has not obtained reliable data for November 2020 and December 2020, and as such the observations in each chart for these periods were modelled based on data before or after that period."]
[null,"2022-01-01",1380,1609,1515,1716,1193,1315,1250,1455,null,"Note: Assumed annual usage in Ausgrid is 3,900 kWh, in Endeavour is 4,900 kWh, in Essential is 4,600 kWh, in Energex is 4,600 kWh, in South Australian Power Network is 4,000 kWh, in all Victorian distribution zones is 4,000 kWh. For states containing multiple distribution regions, the median annual bill is the median of relevant offers in the state, while the standing offer displayed is the median of the default offer prices from the relevant distribution regions."]
[null,"2022-02-01",1380,1609,1515,1716,1183,1315,1270,1455]
[null,"2022-03-01",1380,1609,1520,1716,1176,1315,1290,1455]
[null,"2022-04-01",1390,1609,1520,1716,1186.5,1315,1290,1455]
[null,"2022-05-01",1390,1609,1525,1716,1183,1315,1295,1455]
[null,"2022-06-01",1500,1609,1590,1716,1262,1315,1370,1455]
[null,"2022-07-01",1830,1836,1840,1840,1333,1352,1620,1620]
[null,"2022-08-01",1840,1836,1840,1840,1359,1352,1620,1620]
[null,"2022-09-01",1840,1836,1830,1840,1372,1352,1620,1620]
[null,"2022-10-01",1840,1836,1830,1840,1390,1352,1620,1620]
[null,"2022-11-01",1840,1836,1830,1840,1351,1352,1620,1620]
[null,"2022-12-01",1840,1836,1840,1840,1351,1352,1620,1620]
[null,"2023-01-01",1805,1836,1840,1840,1351,1352,1615,1620]
[null,"2023-02-01",1790,1836,1835,1840,1326,1352,1602.5,1620]
[null,"2023-03-01",1775,1836,1830,1840,1323,1352,1602.5,1620]
[null,"2023-04-01",1762.5,1836,1820,1840,1313,1352,1610,1620]
[null,"2023-05-01",1740,1836,1815,1840,1317,1352,1610,1620]
[null,"2023-06-01",1825,1836,1835,1840,1304.5,1352,1620,1620]
[null,"2023-07-01",2010,2228,2140,2279,1563.5,1720,1820,1969]
[null,"2023-08-01",2055,2228,2180,2279,1589.5,1720,1860,1969]
[null,"2023-09-01",2080,2228,2190,2279,1562,1720,1870,1969]

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

{"sheet":"2. NEM $customer","index":3,"n_rows":199,"n_cols":13,"rows_kept":199,"cut":false,"hidden":false,"merged":[]}
[null,"Cost Stack"]
[null,"Cost stacks, $/customer"]
[null,"Contents"]
[]
[null,"Supplementary Table C2.1",null,null,null,null,null,null,null,null,"Figure C2.1: Cost components for the average residential customer across the NEM in 2022–23, real $2022–23, excluding GST"]
[null,"Residential Customers, real $2022–23, excluding GST "]
[null,"2022-23","$/customer","% of cost stack"]
[null,"Network",675,0.45]
[null,"Wholesale electricity",490,0.33]
[null,"Environmental",145,0.1]
[null,"Retail & other costs",150,0.1]
[null,"Retail margin (EBITDA)",34,0.02]
[null,"Total Cost Stack",1494]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
[null,"Supplementary Table C2.2",null,null,null,null,null,null,null,null,"Figure C2.2 (Figure 2.10 in report): Change in cost components for the average residential customer across the NEM from 2021–22 to 2022–23, real $2022–23, excluding GST"]
[null,"Residential Customers, real $2022–23, excluding GST "]
[null,"$/customer","2021–22","2022–23","Change"]
[null,"Network",717,675,-41]
[null,"Wholesale electricity",415,490,75]
[null,"Environmental",160,145,-15]
[null,"Retail & other costs",150,150,1]
[null,"Retail margin (EBITDA)",37,34,-3]
[null,"Total Cost Stack",1478,1494,16]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
[null,"Supplementary Table C2.3",null,null,null,null,null,null,null,null,"Figure C2.3: Average residential customer bills by NEM regions, 2013–14 to 2022–23, real $2022–23, excluding GST "]
[null,"Residential Customers, $/customer, real $2022–23, excluding GST "]
[null,"Variable","Year","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"Total cost stack ","2007-08",1362,1607,1596,1495,1717,1461]
[null,"Total cost stack ","2008-09","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Total cost stack ","2009-10","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Total cost stack ","2010-11",1585,1976,1705,1792,1899,1775]
[null,"Total cost stack ","2011-12","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Total cost stack ","2012-13","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Total cost stack ","2013-14",1833,2048,2027,2086,2430,2001]
[null,"Total cost stack ","2014-15",1685,1878,1937,2096,2278,1873]
[null,"Total cost stack ","2015-16",1635,1758,1796,2040,2249,1786]
[null,"Total cost stack ","2016-17",1563,1881,1839,1996,2355,1812]
[null,"Total cost stack ","2017-18",1602,1953,1931,1843,2260,1833]
[null,"Total cost stack ","2018-19",1605,1835,1854,1697,2305,1758]
[null,"Total cost stack ","2019-20",1621,1758,1867,1607,2427,1723]
[null,"Total cost stack ","2020-21",1545,1653,1642,1497,2294,1614]
[null,"Total cost stack ","2021-22",1387,1542,1517,1357,2065,1478]
[null,"Total cost stack ","2022-23",1333,1587,1522,1423,2167,1494]
[null,"Network","2007-08",584,709,731,709,810,663]
[null,"Network","2008-09","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Network","2009-10","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Network","2010-11",588,1116,767,842,959,839]
[null,"Network","2011-12","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Network","2012-13","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Network","2013-14",768,1063,950,1078,1180,970]
[null,"Network","2014-15",811,1035,973,1184,1160,988]
[null,"Network","2015-16",780,884,808,1103,1127,888]
[null,"Network","2016-17",666,886,761,998,1193,834]
[null,"Network","2017-18",634,835,758,831,955,768,null,"Source: ACCC analysis based on retailers’ data."]
[null,"Network","2018-19",609,821,795,781,996,752,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."]
[null,"Network","2019-20",657,774,879,801,1054,762]
[null,"Network","2020-21",636,754,822,716,971,725]
[null,"Network","2021-22",602,775,796,686,989,717]
[null,"Network","2022-23",590,730,749,600,971,675]
[null,"Wholesale electricity","2007-08",496,620,650,554,759,561]
[null,"Wholesale electricity","2008-09","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Wholesale electricity","2009-10","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Wholesale electricity","2010-11",487,504,633,548,728,531]
[null,"Wholesale electricity","2011-12","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Wholesale electricity","2012-13","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Wholesale electricity","2013-14",580,554,618,535,827,574]
[null,"Wholesale electricity","2014-15",381,408,549,426,645,424]
[null,"Wholesale electricity","2015-16",347,408,538,507,635,425]
[null,"Wholesale electricity","2016-17",371,468,612,576,717,478]
[null,"Wholesale electricity","2017-18",500,619,761,661,918,612]
[null,"Wholesale electricity","2018-19",549,572,651,599,810,584]
[null,"Wholesale electricity","2019-20",575,568,603,503,962,575]
[null,"Wholesale electricity","2020-21",516,510,490,453,802,509]
[null,"Wholesale electricity","2021-22",401,434,370,379,646,415]
[null,"Wholesale electricity","2022-23",362,586,403,483,790,490]
[null,"Environmental ","2007-08",10,117,14,32,15,27]
[null,"Environmental ","2008-09","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Environmental ","2009-10","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Environmental ","2010-11",75,102,61,77,35,81]
[null,"Environmental ","2011-12","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Environmental ","2012-13","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Environmental ","2013-14",97,141,213,130,157,134]
[null,"Environmental ","2014-15",99,129,223,131,166,131]
[null,"Environmental ","2015-16",106,131,203,168,201,138]
[null,"Environmental ","2016-17",109,129,200,178,187,140]
[null,"Environmental ","2017-18",132,156,201,103,202,145]
[null,"Environmental ","2018-19",136,165,205,116,194,153]
[null,"Environmental ","2019-20",148,170,218,118,208,160]
[null,"Environmental ","2020-21",151,165,194,182,205,168]
[null,"Environmental ","2021-22",165,146,178,167,202,160]
[null,"Environmental ","2022-23",149,140,156,137,166,145]
[null,"Retail & other costs","2007-08",124,161,102,151,null,130]
[null,"Retail & other costs","2008-09","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Retail & other costs","2009-10","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Retail & other costs","2010-11",171,192,129,171,"-   ",171]
[null,"Retail & other costs","2011-12","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Retail & other costs","2012-13","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Retail & other costs","2013-14",236,231,187,179,"-   ",218]
[null,"Retail & other costs","2014-15",227,190,192,191,"-   ",200]
[null,"Retail & other costs","2015-16",228,189,190,179,"-   ",198]
[null,"Retail & other costs","2016-17",223,194,181,192,"-   ",199]
[null,"Retail & other costs","2017-18",219,189,180,206,"-   ",199]
[null,"Retail & other costs","2018-19",211,185,180,185,"-   ",192]
[null,"Retail & other costs","2019-20",189,169,165,177,"-   ",176]
[null,"Retail & other costs","2020-21",170,149,150,148,"-   ",156]
[null,"Retail & other costs","2021-22",165,144,141,136,"-   ",150]
[null,"Retail & other costs","2022-23",163,142,146,142,"-   ",150]
[null,"Retail margin (EBITDA)","2007-08",149,"-   ",100,50,"-   ",80]
[null,"Retail margin (EBITDA)","2008-09","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Retail margin (EBITDA)","2009-10","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Retail margin (EBITDA)","2010-11",264,62,115,154,"-   ",152]
[null,"Retail margin (EBITDA)","2011-12","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Retail margin (EBITDA)","2012-13","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Retail margin (EBITDA)","2013-14",152,59,59,164,"-   ",105]
[null,"Retail margin (EBITDA)","2014-15",168,115,0,164,"-   ",130]
[null,"Retail margin (EBITDA)","2015-16",174,146,58,83,"-   ",136]
[null,"Retail margin (EBITDA)","2016-17",195,204,85,53,"-   ",162]
[null,"Retail margin (EBITDA)","2017-18",118,155,31,41,"-   ",109]
[null,"Retail margin (EBITDA)","2018-19",100,93,23,17,"-   ",77]
[null,"Retail margin (EBITDA)","2019-20",52,76,2,10,"-   ",49]
[null,"Retail margin (EBITDA)","2020-21",73,74,-14,-2,"-   ",55]
[null,"Retail margin (EBITDA)","2021-22",55,43,31,-10,"-   ",37]
[null,"Retail margin (EBITDA)","2022-23",69,-12,68,62,"-   ",34]
[null,"Retail component ","2007-08","-   "," -   "," -   "," -   ",133,"-   "]
[null,"Retail component ","2008-09","-   "," -   "," -   "," -   ","-   ","-   "]
[null,"Retail component ","2009-10","-   "," -   "," -   "," -   ","-   ","-   "]
[null,"Retail component ","2010-11","-   "," -   "," -   "," -   ",177,"-   "]
[null,"Retail component ","2011-12","-   "," -   "," -   "," -   ","-   ","-   "]
[null,"Retail component ","2012-13","-   "," -   "," -   "," -   ","-   ","-   "]
[null,"Retail component ","2013-14","-   "," -   "," -   "," -   ",266,"-   "]
[null,"Retail component ","2014-15","-   "," -   "," -   "," -   ",307,"-   "]
[null,"Retail component ","2015-16","-   "," -   "," -   "," -   ",286,"-   "]
[null,"Retail component ","2016-17","-   "," -   "," -   "," -   ",257,"-   "]
[null,"Retail component ","2017-18","-   "," -   "," -   "," -   ",185,"-   "]
[null,"Retail component ","2018-19","-   "," -   "," -   "," -   ",306,"-   "]
[null,"Retail component ","2019-20","-   "," -   "," -   "," -   ",202,"-   "]
[null,"Retail component ","2020-21","-   "," -   "," -   "," -   ",315,"-   "]
[null,"Retail component ","2021-22","-   "," -   "," -   "," -   ",228,"-   "]
[null,"Retail component ","2022-23","-   "," -   "," -   "," -   ",240,"-   "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Figure C2.4 (Figure 2.13 in report): Average retail margins (earnings before interest, tax, depreciation and amortisation) per residential customer, by region, 2016-17 to 2022-23, real $2022-23, excluding GST"]
[]
[null,"Supplementary Table C2.4"]
[null,"Average retail margins, $/customer, residential by region, real $2022–23, excluding GST "]
[null,"Residential","VIC","NSW","SA","SEQ"]
[null,"2016-17",195,204,85,53]
[null,"2017-18",118,155,31,41]
[null,"2018-19",100,93,23,17]
[null,"2019-20",52,76,2,10]
[null,"2020-21",73,74,-14,-2]
[null,"2021-22",55,43,31,-10]
[null,"2022-23",69,-12,68,62]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]

{"sheet":"3. NEM ckWh","index":4,"n_rows":421,"n_cols":10,"rows_kept":421,"cut":false,"hidden":false,"merged":[]}
[null,"Cost Stack"]
[null,"NEM-wide cost stacks, c/kWh"]
[null,{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
[]
[null,"Supplementary Table C3.1",null,null,null,null,null,null,null,"Figure C3.1: Average residential customer effective price across the NEM from 2013–14 to 2022–23, real $2022–23, excluding GST"]
[null,"Residential Customers, c/kWh, real $2022-23, excluding GST"]
[null,"Variable","Year","NEM"]
[null,"Total Cost Stack","2007–08",22.97]
[null,"Total Cost Stack","2008–09",0]
[null,"Total Cost Stack","2009–10",0]
[null,"Total Cost Stack","2010–11",28.06]
[null,"Total Cost Stack","2011–12",0]
[null,"Total Cost Stack","2012–13",0]
[null,"Total Cost Stack","2013–14",36.29]
[null,"Total Cost Stack","2014–15",33.82]
[null,"Total Cost Stack","2015–16",32.25]
[null,"Total Cost Stack","2016–17",33.07]
[null,"Total Cost Stack","2017–18",34.29]
[null,"Total Cost Stack","2018–19",33.39]
[null,"Total Cost Stack","2019–20",32.729999999999997]
[null,"Total Cost Stack","2020–21",30.36]
[null,"Total Cost Stack","2021–22",27.84]
[null,"Total Cost Stack","2022–23",28.57]
[null,"Network","2007–08",10.42]
[null,"Network","2008–09",0]
[null,"Network","2009–10",0,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[null,"Network","2010–11",13.27]
[null,"Network","2011–12",0]
[null,"Network","2012–13",0]
[null,"Network","2013–14",17.600000000000001]
[null,"Network","2014–15",17.850000000000001]
[null,"Network","2015–16",16.04]
[null,"Network","2016–17",15.21]
[null,"Network","2017–18",14.37]
[null,"Network","2018–19",14.28]
[null,"Network","2019–20",14.47]
[null,"Network","2020–21",13.65]
[null,"Network","2021–22",13.5]
[null,"Network","2022–23",12.91]
[null,"Wholesale electricity","2007–08",8.81]
[null,"Wholesale electricity","2008–09",0]
[null,"Wholesale electricity","2009–10",0]
[null,"Wholesale electricity","2010–11",8.4]
[null,"Wholesale electricity","2011–12",0]
[null,"Wholesale electricity","2012–13",0]
[null,"Wholesale electricity","2013–14",10.41]
[null,"Wholesale electricity","2014–15",7.66]
[null,"Wholesale electricity","2015–16",7.68]
[null,"Wholesale electricity","2016–17",8.7200000000000006]
[null,"Wholesale electricity","2017–18",11.45]
[null,"Wholesale electricity","2018–19",11.1]
[null,"Wholesale electricity","2019–20",10.92]
[null,"Wholesale electricity","2020–21",9.59]
[null,"Wholesale electricity","2021–22",7.82]
[null,"Wholesale electricity","2022–23",9.3699999999999992]
[null,"Environmental","2007–08",0.42]
[null,"Environmental","2008–09",0]
[null,"Environmental","2009–10",0]
[null,"Environmental","2010–11",1.27]
[null,"Environmental","2011–12",0]
[null,"Environmental","2012–13",0]
[null,"Environmental","2013–14",2.4300000000000002]
[null,"Environmental","2014–15",2.36]
[null,"Environmental","2015–16",2.5]
[null,"Environmental","2016–17",2.5499999999999998]
[null,"Environmental","2017–18",2.72]
[null,"Environmental","2018–19",2.9]
[null,"Environmental","2019–20",3.05]
[null,"Environmental","2020–21",3.16]
[null,"Environmental","2021–22",3.01]
[null,"Environmental","2022–23",2.76]
[null,"Retail & other costs","2007–08",2.0499999999999998]
[null,"Retail & other costs","2008–09",0]
[null,"Retail & other costs","2009–10",0]
[null,"Retail & other costs","2010–11",2.71]
[null,"Retail & other costs","2011–12",0]
[null,"Retail & other costs","2012–13",0]
[null,"Retail & other costs","2013–14",3.95]
[null,"Retail & other costs","2014–15",3.61]
[null,"Retail & other costs","2015–16",3.57]
[null,"Retail & other costs","2016–17",3.64]
[null,"Retail & other costs","2017–18",3.72]
[null,"Retail & other costs","2018–19",3.64]
[null,"Retail & other costs","2019–20",3.35]
[null,"Retail & other costs","2020–21",2.93]
[null,"Retail & other costs","2021–22",2.82]
[null,"Retail & other costs","2022–23",2.87]
[null,"Retail margin (EBITDA)","2007–08",1.26]
[null,"Retail margin (EBITDA)","2008–09",0]
[null,"Retail margin (EBITDA)","2009–10",0]
[null,"Retail margin (EBITDA)","2010–11",2.41]
[null,"Retail margin (EBITDA)","2011–12",0]
[null,"Retail margin (EBITDA)","2012–13",0]
[null,"Retail margin (EBITDA)","2013–14",1.91]
[null,"Retail margin (EBITDA)","2014–15",2.34]
[null,"Retail margin (EBITDA)","2015–16",2.46]
[null,"Retail margin (EBITDA)","2016–17",2.95]
[null,"Retail margin (EBITDA)","2017–18",2.0299999999999998]
[null,"Retail margin (EBITDA)","2018–19",1.47]
[null,"Retail margin (EBITDA)","2019–20",0.94]
[null,"Retail margin (EBITDA)","2020–21",1.04]
[null,"Retail margin (EBITDA)","2021–22",0.69]
[null,"Retail margin (EBITDA)","2022–23",0.65]
[]
[null,"Supplementary Table C3.2",null,null,null,null,null,null,null,"Figure C3.2: Change in cost components of the average residential customer effective price across the NEM from 2021–22 to 2022–23, real $2022–23, excluding GST"]
[null,"Residential Customers, real $2022-23, excluding GST"]
[null,"c/kWh","2021-22","2022-23","Change"]
[null,"Network",13.5,12.9,-0.6]
[null,"Wholesale electricity",7.8,9.4,1.6]
[null,"Environmental",3,2.8,-0.2]
[null,"Retail & other costs",2.8,2.9,0.1]
[null,"Retail margin (EBITDA)",0.7,0.6,0]
[null,"Total Cost Stack",27.8,28.6,0.7]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"Supplementary Table C3.3",null,null,null,null,null,null,null,"Figure C3.3: Change in cost components of the average residential customer effective price across the NEM from 2007–08 to 2013–14 to 2022–23, real $2022–23, excluding GST "]
[null,"Residential Customers, real $2022-23, excluding GST"]
[null,"c/kWh","2007-08","2013-14","Change (2007-08 to 2013-14)","2022-23","Change (2013-14 to 2022-23)","Total Change"]
[null,"Network",10.4,17.600000000000001,7.2,12.9,-4.7,2.5]
[null,"Wholesale electricity",8.8000000000000007,10.4,1.6,9.4,-1,0.6]
[null,"Environmental",0.4,2.4,2,2.8,0.3,2.2999999999999998]
[null,"Retail & other costs",2,4,1.9,2.9,-1.1000000000000001,0.8]
[null,"Retail margin (EBITDA)",1.3,1.9,0.6,0.6,-1.3,-0.6]
[null,"Total Cost Stack",23,36.299999999999997,13.3,28.6,-7.7,5.6]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"Supplementary Table C3.4",null,null,null,null,null,null,null,"Figure C3.4: Average small business customer effective price across the NEM from 2013–14 to 2022–23, real $2022–23, excluding GST"]
[null,"Small Business Customers, c/kWh, real $2022-23, excluding GST"]
[null,"Variable","Year","NEM"]
[null,"Total Cost Stack","2007–08",20.23]
[null,"Total Cost Stack","2008–09",0]
[null,"Total Cost Stack","2009–10",0]
[null,"Total Cost Stack","2010–11",24.59]
[null,"Total Cost Stack","2011–12",0]
[null,"Total Cost Stack","2012–13",0]
[null,"Total Cost Stack","2013–14",32.020000000000003]
[null,"Total Cost Stack","2014–15",30.32]
[null,"Total Cost Stack","2015–16",28.71]
[null,"Total Cost Stack","2016–17",30.46]
[null,"Total Cost Stack","2017–18",32.11]
[null,"Total Cost Stack","2018–19",32.619999999999997]
[null,"Total Cost Stack","2019–20",31.42]
[null,"Total Cost Stack","2020–21",29.49]
[null,"Total Cost Stack","2021–22",26.76]
[null,"Total Cost Stack","2022–23",27.11]
[null,"Network","2007–08",8.02]
[null,"Network","2008–09",0]
[null,"Network","2009–10",0,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[null,"Network","2010–11",10.36]
[null,"Network","2011–12",0]
[null,"Network","2012–13",0]
[null,"Network","2013–14",14.89]
[null,"Network","2014–15",15.55]
[null,"Network","2015–16",13.86]
[null,"Network","2016–17",13.45]
[null,"Network","2017–18",13.3]
[null,"Network","2018–19",13.65]
[null,"Network","2019–20",13.26]
[null,"Network","2020–21",12.4]
[null,"Network","2021–22",12.1]
[null,"Network","2022–23",11.55]
[null,"Wholesale electricity","2007–08",8.89]
[null,"Wholesale electricity","2008–09",0]
[null,"Wholesale electricity","2009–10",0]
[null,"Wholesale electricity","2010–11",8.76]
[null,"Wholesale electricity","2011–12",0]
[null,"Wholesale electricity","2012–13",0]
[null,"Wholesale electricity","2013–14",10.199999999999999]
[null,"Wholesale electricity","2014–15",7.72]
[null,"Wholesale electricity","2015–16",7.63]
[null,"Wholesale electricity","2016–17",9.36]
[null,"Wholesale electricity","2017–18",11.5]
[null,"Wholesale electricity","2018–19",11.18]
[null,"Wholesale electricity","2019–20",11.34]
[null,"Wholesale electricity","2020–21",9.9600000000000009]
[null,"Wholesale electricity","2021–22",8.59]
[null,"Wholesale electricity","2022–23",9.93]
[null,"Environmental","2007–08",0.41]
[null,"Environmental","2008–09",0]
[null,"Environmental","2009–10",0]
[null,"Environmental","2010–11",1.25]
[null,"Environmental","2011–12",0]
[null,"Environmental","2012–13",0]
[null,"Environmental","2013–14",2.67]
[null,"Environmental","2014–15",2.76]
[null,"Environmental","2015–16",3.14]
[null,"Environmental","2016–17",3.38]
[null,"Environmental","2017–18",3.17]
[null,"Environmental","2018–19",3.24]
[null,"Environmental","2019–20",3.64]
[null,"Environmental","2020–21",4.04]
[null,"Environmental","2021–22",3.86]
[null,"Environmental","2022–23",3.22]
[null,"Retail & other costs","2007–08",0.68]
[null,"Retail & other costs","2008–09",0]
[null,"Retail & other costs","2009–10",0]
[null,"Retail & other costs","2010–11",0.84]
[null,"Retail & other costs","2011–12",0]
[null,"Retail & other costs","2012–13",0]
[null,"Retail & other costs","2013–14",1.81]
[null,"Retail & other costs","2014–15",1.71]
[null,"Retail & other costs","2015–16",1.72]
[null,"Retail & other costs","2016–17",1.66]
[null,"Retail & other costs","2017–18",1.71]
[null,"Retail & other costs","2018–19",1.94]
[null,"Retail & other costs","2019–20",1.7]
[null,"Retail & other costs","2020–21",1.55]
[null,"Retail & other costs","2021–22",1.45]
[null,"Retail & other costs","2022–23",1.35]
[null,"Retail margin (EBITDA)","2007–08",2.2200000000000002]
[null,"Retail margin (EBITDA)","2008–09",0]
[null,"Retail margin (EBITDA)","2009–10",0]
[null,"Retail margin (EBITDA)","2010–11",3.37]
[null,"Retail margin (EBITDA)","2011–12",0]
[null,"Retail margin (EBITDA)","2012–13",0]
[null,"Retail margin (EBITDA)","2013–14",2.44]
[null,"Retail margin (EBITDA)","2014–15",2.57]
[null,"Retail margin (EBITDA)","2015–16",2.36]
[null,"Retail margin (EBITDA)","2016–17",2.61]
[null,"Retail margin (EBITDA)","2017–18",2.4300000000000002]
[null,"Retail margin (EBITDA)","2018–19",2.62]
[null,"Retail margin (EBITDA)","2019–20",1.48]
[null,"Retail margin (EBITDA)","2020–21",1.54]
[null,"Retail margin (EBITDA)","2021–22",0.78]
[null,"Retail margin (EBITDA)","2022–23",1.05]
[]
[null,"Supplementary Table C3.5",null,null,null,null,null,null,null,"Figure C3.5  (Figure C6 in report): Change in cost components of the average small business customer effective price across the NEM from 2020–21 to 2022–23, real $2022–23, excluding GST"]
[null,"Small Business Customers, real $2022-23, excluding GST"]
[null,"c/kWh","2021-22","2022-23","Change"]
[null,"Network",12.1,11.5,-0.5]
[null,"Wholesale electricity",8.6,9.9,1.3]
[null,"Environmental",3.9,3.2,-0.6]
[null,"Retail & other costs",1.4,1.4,-0.1]
[null,"Retail margin (EBITDA)",0.8,1,0.3]
[null,"Total Cost Stack",26.8,27.1,0.3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"Supplementary Table C3.6",null,null,null,null,null,null,null,"Figure C3.6: Average large business customer effective price across the NEM from 2013-14 to 2022–23, real $2022–23, excluding GST"]
[null,"Large Business Customers, c/kWh, real $2022-23, excluding GST"]
[null,"Variable","Year","NEM"]
[null,"Total Cost Stack","2007–08",12.04]
[null,"Total Cost Stack","2008–09",0]
[null,"Total Cost Stack","2009–10",0]
[null,"Total Cost Stack","2010–11",13.6]
[null,"Total Cost Stack","2011–12",0]
[null,"Total Cost Stack","2012–13",0]
[null,"Total Cost Stack","2013–14",17.63]
[null,"Total Cost Stack","2014–15",15.48]
[null,"Total Cost Stack","2015–16",15.1]
[null,"Total Cost Stack","2016–17",16.489999999999998]
[null,"Total Cost Stack","2017–18",18.670000000000002]
[null,"Total Cost Stack","2018–19",19.39]
[null,"Total Cost Stack","2019–20",18.78]
[null,"Total Cost Stack","2020–21",17]
[null,"Total Cost Stack","2021–22",15.41]
[null,"Total Cost Stack","2022–23",15.89]
[null,"Network","2007–08",4.1900000000000004]
[null,"Network","2008–09",0]
[null,"Network","2009–10",0]
[null,"Network","2010–11",4.99,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[null,"Network","2011–12",0]
[null,"Network","2012–13",0]
[null,"Network","2013–14",7.59]
[null,"Network","2014–15",7.7]
[null,"Network","2015–16",6.95]
[null,"Network","2016–17",6.81]
[null,"Network","2017–18",6.17]
[null,"Network","2018–19",6.14]
[null,"Network","2019–20",6.26]
[null,"Network","2020–21",6.01]
[null,"Network","2021–22",5.83]
[null,"Network","2022–23",5.35]
[null,"Wholesale electricity","2007–08",6.93]
[null,"Wholesale electricity","2008–09",0]
[null,"Wholesale electricity","2009–10",0]
[null,"Wholesale electricity","2010–11",7.03]
[null,"Wholesale electricity","2011–12",0]
[null,"Wholesale electricity","2012–13",0]
[null,"Wholesale electricity","2013–14",8.09]
[null,"Wholesale electricity","2014–15",5.81]
[null,"Wholesale electricity","2015–16",5.99]
[null,"Wholesale electricity","2016–17",7.22]
[null,"Wholesale electricity","2017–18",9.34]
[null,"Wholesale electricity","2018–19",10.18]
[null,"Wholesale electricity","2019–20",9.5]
[null,"Wholesale electricity","2020–21",8.26]
[null,"Wholesale electricity","2021–22",7.79]
[null,"Wholesale electricity","2022–23",8.7100000000000009]
[null,"Environmental","2007–08",0.35]
[null,"Environmental","2008–09",0]
[null,"Environmental","2009–10",0]
[null,"Environmental","2010–11",0.99]
[null,"Environmental","2011–12",0]
[null,"Environmental","2012–13",0]
[null,"Environmental","2013–14",1.63]
[null,"Environmental","2014–15",1.66]
[null,"Environmental","2015–16",1.79]
[null,"Environmental","2016–17",1.83]
[null,"Environmental","2017–18",2.23]
[null,"Environmental","2018–19",2.37]
[null,"Environmental","2019–20",2.4900000000000002]
[null,"Environmental","2020–21",2.35]
[null,"Environmental","2021–22",2.06]
[null,"Environmental","2022–23",1.85]
[null,"Retail & other costs","2007–08",0.1]
[null,"Retail & other costs","2008–09",0]
[null,"Retail & other costs","2009–10",0]
[null,"Retail & other costs","2010–11",0.1]
[null,"Retail & other costs","2011–12",0]
[null,"Retail & other costs","2012–13",0]
[null,"Retail & other costs","2013–14",0.26]
[null,"Retail & other costs","2014–15",0.27]
[null,"Retail & other costs","2015–16",0.33]
[null,"Retail & other costs","2016–17",0.31]
[null,"Retail & other costs","2017–18",0.38]
[null,"Retail & other costs","2018–19",0.24]
[null,"Retail & other costs","2019–20",0.25]
[null,"Retail & other costs","2020–21",0.25]
[null,"Retail & other costs","2021–22",0.22]
[null,"Retail & other costs","2022–23",0.24]
[null,"Retail margin (EBITDA)","2007–08",0.47]
[null,"Retail margin (EBITDA)","2008–09",0]
[null,"Retail margin (EBITDA)","2009–10",0]
[null,"Retail margin (EBITDA)","2010–11",0.48]
[null,"Retail margin (EBITDA)","2011–12",0]
[null,"Retail margin (EBITDA)","2012–13",0]
[null,"Retail margin (EBITDA)","2013–14",0.06]
[null,"Retail margin (EBITDA)","2014–15",0.04]
[null,"Retail margin (EBITDA)","2015–16",0.05]
[null,"Retail margin (EBITDA)","2016–17",0.31]
[null,"Retail margin (EBITDA)","2017–18",0.55000000000000004]
[null,"Retail margin (EBITDA)","2018–19",0.45]
[null,"Retail margin (EBITDA)","2019–20",0.28000000000000003]
[null,"Retail margin (EBITDA)","2020–21",0.12]
[null,"Retail margin (EBITDA)","2021–22",-0.49]
[null,"Retail margin (EBITDA)","2022–23",-0.25]
[]
[null,"Supplementary Table C3.7",null,null,null,null,null,null,null,"Figure C3.7: Change in cost components of the average large business customer effective price across the NEM from 2021–22 to 2022–23, real $2022–23, excluding GST"]
[null,"Large Business Customers, real $2022–23, excluding GST"]
[null,"c/kWh","2021-22","2022-23","Change"]
[null,"Network",5.8,5.4,-0.5]
[null,"Wholesale electricity",7.8,8.6999999999999993,0.9]
[null,"Environmental",2.1,1.8,-0.2]
[null,"Retail & other costs",0.2,0.2,0]
[null,"Retail margin (EBITDA)",-0.5,-0.3,0.2]
[null,"Total Cost Stack",15.4,15.9,0.5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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. Retail margin in 2021-22 was negative, shown as the yellow section below 0 in 2021-22."]
[]
[]
[null,"Supplementary Table C3.8",null,null,null,null,null,null,null,"Figure C3.8: Comparison of the average residential, small business customer and large business customer effective price across the NEM in 2021–22, real $2022–23, excluding GST "]
[null,"Residential, Small Business, Large Business, 2022-23, real $2022-23, excluding GST"]
[null,"c/kWh","Residential","Small Business","Large Business"]
[null,"Network",12.9,11.5,5.3526493656965402]
[null,"Wholesale electricity",9.4,9.9,8.705552129078276]
[null,"Environmental",2.8,3.2,1.8493711263970771]
[null,"Retail & other costs",2.9,1.4,0.23508777219686033]
[null,"Retail margin (EBITDA)",0.6,1,-0.25214215163528203]
[null,"Total Cost Stack",28.6,27.1,15.890518241733472]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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. Retail margin in 2021-22 was negative, shown as the yellow section below 0 under Large business."]

{"sheet":"4. Regional ckWh","index":5,"n_rows":265,"n_cols":11,"rows_kept":265,"cut":false,"hidden":false,"merged":[]}
[null,"Cost Stack"]
[null,"Regional cost stacks, c/kWh"]
[null,{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
[]
[null,"Supplementary Table C4.1A",null,null,null,null,null,null,null,null,"Figure C4.1: Average residential customer effective prices by NEM regions, 2022–23, real $2022–23, excluding GST "]
[null,"Residential Customers, 2022-23, real $2022–23, excluding GST "]
[null,"c/kWh","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"Network",12.7,13.1,17.3,11.3,10.7,12.9]
[null,"Wholesale electricity",7.8,10.5,9.3000000000000007,9.1,8.6999999999999993,9.4]
[null,"Environmental",3.2,2.5,3.6,2.6,1.8,2.8]
[null,"Retail & other costs",3.5,2.6,3.4,2.7,0,2.9]
[null,"Retail margin (EBITDA)",1.5,-0.2,1.6,1.2,0,0.6]
[null,"Retail component",0,0,0,0,2.6954005886936288,0]
[null,"Total Cost Stack",28.8,28.5,35.1,26.9,24,28.6]
[]
[]
[null,"Supplementary Table C4.1B"]
[null,"Residential Customers, 2022-23, real $2022–23, excluding GST "]
[null,"% of cost stack","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"Network",0.44,0.46,0.49,0.42,0.45,0.45]
[null,"Wholesale electricity",0.27,0.37,0.26,0.34,0.36,0.33]
[null,"Environmental",0.11,0.09,0.1,0.1,0.08,0.1]
[null,"Retail & other costs",0.12,0.09,0.1,0.1,0,0.1]
[null,"Retail margin (EBITDA)",0.05,0,0.04,0.04,0,0.02]
[null,"Retail component",0,0,0,0,0.11,0,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
[]
[null,"Supplementary Table C4.2",null,null,null,null,null,null,null,null,"Figure C4.2: Average residential customer effective prices by NEM regions, 2013–14 to 2022–23, real $2022–23, excluding GST "]
[null,"Residential Customers, c/kWh, real $2022-23, excluding GST"]
[null,"Variable","Year","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"Total cost stack ","2007-08",24.7,22.6,26.5,20.7,19.7,23]
[null,"Total cost stack ","2008-09",0,0,0,0,0,0]
[null,"Total cost stack ","2009-10",0,0,0,0,0,0]
[null,"Total cost stack ","2010-11",28.8,28.7,29,26.1,24.9,28.1]
[null,"Total cost stack ","2011-12",0,0,0,0,0,0]
[null,"Total cost stack ","2012-13",0,0,0,0,0,0]
[null,"Total cost stack ","2013-14",38.5,35.1,40.9,35,31.2,36.299999999999997]
[null,"Total cost stack ","2014-15",35.700000000000003,31.4,38.9,35.4,29.8,33.799999999999997]
[null,"Total cost stack ","2015-16",34.4,29.2,36,35,30.4,32.200000000000003]
[null,"Total cost stack ","2016-17",32.9,31.5,39.1,34.700000000000003,31.1,33.1]
[null,"Total cost stack ","2017-18",34.5,33.799999999999997,42.2,32.700000000000003,29.3,34.299999999999997]
[null,"Total cost stack ","2018-19",35.4,32.299999999999997,40.700000000000003,30.3,30.4,33.4]
[null,"Total cost stack ","2019-20",35.5,31,40.6,29.3,31.6,32.700000000000003]
[null,"Total cost stack ","2020-21",33.6,29.1,36.6,26.6,27.1,30.4]
[null,"Total cost stack ","2021-22",30.1,26.9,33.1,24.9,25.9,27.8]
[null,"Total cost stack ","2022-23",28.8,28.5,35.1,26.9,24,28.6]
[null,"Network","2007-08",10.6,10,12.1,9.8000000000000007,9.3000000000000007,10.4]
[null,"Network","2008-09",0,0,0,0,0,0]
[null,"Network","2009-10",0,0,0,0,0,0]
[null,"Network","2010-11",10.7,16.2,13,12.3,12.5,13.3]
[null,"Network","2011-12",0,0,0,0,0,0]
[null,"Network","2012-13",0,0,0,0,0,0]
[null,"Network","2013-14",16.100000000000001,18.2,19.2,18.100000000000001,15.1,17.600000000000001]
[null,"Network","2014-15",17.2,17.3,19.600000000000001,20,15.2,17.899999999999999,null,"Source: ACCC analysis based on retailers’ data."]
[null,"Network","2015-16",16.399999999999999,14.7,16.2,18.899999999999999,15.2,16,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."]
[null,"Network","2016-17",14,14.8,16.2,17.3,15.7,15.2]
[null,"Network","2017-18",13.7,14.4,16.600000000000001,14.8,12.4,14.4]
[null,"Network","2018-19",13.4,14.4,17.399999999999999,13.9,13.1,14.3]
[null,"Network","2019-20",14.4,13.7,19.100000000000001,14.6,13.8,14.5]
[null,"Network","2020-21",13.8,13.3,18.3,12.7,11.5,13.7]
[null,"Network","2021-22",13.1,13.5,17.399999999999999,12.6,12.4,13.5]
[null,"Network","2022-23",12.7,13.1,17.3,11.3,10.7,12.9]
[null,"Wholesale electricity","2007-08",9,8.6999999999999993,10.8,7.7,8.6999999999999993,8.8000000000000007]
[null,"Wholesale electricity","2008-09",0,0,0,0,0,0]
[null,"Wholesale electricity","2009-10",0,0,0,0,0,0]
[null,"Wholesale electricity","2010-11",8.8000000000000007,7.3,10.8,8,9.5,8.4]
[null,"Wholesale electricity","2011-12",0,0,0,0,0,0]
[null,"Wholesale electricity","2012-13",0,0,0,0,0,0]
[null,"Wholesale electricity","2013-14",12.2,9.5,12.5,9,10.6,10.4]
[null,"Wholesale electricity","2014-15",8.1,6.8,11,7.2,8.4,7.7]
[null,"Wholesale electricity","2015-16",7.3,6.8,10.8,8.6999999999999993,8.6,7.7]
[null,"Wholesale electricity","2016-17",7.8,7.8,13,10,9.5,8.6999999999999993]
[null,"Wholesale electricity","2017-18",10.8,10.7,16.600000000000001,11.7,11.9,11.4]
[null,"Wholesale electricity","2018-19",12.1,10.1,14.3,10.7,10.7,11.1]
[null,"Wholesale electricity","2019-20",12.6,10,13.1,9.1999999999999993,12.6,10.9]
[null,"Wholesale electricity","2020-21",11.2,9,10.9,8,9.5,9.6]
[null,"Wholesale electricity","2021-22",8.6999999999999993,7.6,8.1,6.9,8.1,7.8]
[null,"Wholesale electricity","2022-23",7.8,10.5,9.3000000000000007,9.1,8.6999999999999993,9.4]
[null,"Environmental ","2007-08",0.2,1.6,0.2,0.4,0.2,0.4]
[null,"Environmental ","2008-09",0,0,0,0,0,0]
[null,"Environmental ","2009-10",0,0,0,0,0,0]
[null,"Environmental ","2010-11",1.4,1.5,1,1.1000000000000001,0.5,1.3]
[null,"Environmental ","2011-12",0,0,0,0,0,0]
[null,"Environmental ","2012-13",0,0,0,0,0,0]
[null,"Environmental ","2013-14",2,2.4,4.3,2.2000000000000002,2,2.4]
[null,"Environmental ","2014-15",2.1,2.2000000000000002,4.5,2.2000000000000002,2.2000000000000002,2.4]
[null,"Environmental ","2015-16",2.2000000000000002,2.2000000000000002,4.0999999999999996,2.9,2.7,2.5]
[null,"Environmental ","2016-17",2.2999999999999998,2.2000000000000002,4.3,3.1,2.5,2.6]
[null,"Environmental ","2017-18",2.8,2.7,4.4000000000000004,1.8,2.6,2.7]
[null,"Environmental ","2018-19",3,2.9,4.5,2.1,2.6,2.9]
[null,"Environmental ","2019-20",3.2,3,4.7,2.1,2.7,3]
[null,"Environmental ","2020-21",3.3,2.9,4.3,3.2,2.4,3.2]
[null,"Environmental ","2021-22",3.6,2.6,3.9,3.1,2.5,3]
[null,"Environmental ","2022-23",3.2,2.5,3.6,2.6,1.8,2.8]
[null,"Retail & other costs","2007-08",2.2000000000000002,2.2999999999999998,1.7,2.1,0,2]
[null,"Retail & other costs","2008-09",0,0,0,0,0,0]
[null,"Retail & other costs","2009-10",0,0,0,0,0,0]
[null,"Retail & other costs","2010-11",3.1,2.8,2.2000000000000002,2.5,0,2.7]
[null,"Retail & other costs","2011-12",0,0,0,0,0,0]
[null,"Retail & other costs","2012-13",0,0,0,0,0,0]
[null,"Retail & other costs","2013-14",5,4,3.8,3,0,4]
[null,"Retail & other costs","2014-15",4.8,3.2,3.9,3.2,0,3.6]
[null,"Retail & other costs","2015-16",4.8,3.1,3.8,3.1,0,3.6]
[null,"Retail & other costs","2016-17",4.7,3.3,3.8,3.3,0,3.6]
[null,"Retail & other costs","2017-18",4.7,3.3,3.9,3.7,0,3.7]
[null,"Retail & other costs","2018-19",4.7,3.3,4,3.3,0,3.6]
[null,"Retail & other costs","2019-20",4.0999999999999996,3,3.6,3.2,0,3.4]
[null,"Retail & other costs","2020-21",3.7,2.6,3.3,2.6,0,2.9]
[null,"Retail & other costs","2021-22",3.6,2.5,3.1,2.5,0,2.8]
[null,"Retail & other costs","2022-23",3.5,2.6,3.4,2.7,0,2.9]
[null,"Retail margin (EBITDA)","2007-08",2.7,0,1.7,0.7,0,1.3]
[null,"Retail margin (EBITDA)","2008-09",0,0,0,0,0,0]
[null,"Retail margin (EBITDA)","2009-10",0,0,0,0,0,0]
[null,"Retail margin (EBITDA)","2010-11",4.8,0.9,1.9,2.2000000000000002,0,2.4]
[null,"Retail margin (EBITDA)","2011-12",0,0,0,0,0,0]
[null,"Retail margin (EBITDA)","2012-13",0,0,0,0,0,0]
[null,"Retail margin (EBITDA)","2013-14",3.2,1,1.2,2.8,0,1.9]
[null,"Retail margin (EBITDA)","2014-15",3.6,1.9,0,2.8,0,2.2999999999999998]
[null,"Retail margin (EBITDA)","2015-16",3.7,2.4,1.2,1.4,0,2.5]
[null,"Retail margin (EBITDA)","2016-17",4.0999999999999996,3.4,1.8,0.9,0,3]
[null,"Retail margin (EBITDA)","2017-18",2.5,2.7,0.7,0.7,0,2]
[null,"Retail margin (EBITDA)","2018-19",2.2000000000000002,1.6,0.5,0.3,0,1.5]
[null,"Retail margin (EBITDA)","2019-20",1.1000000000000001,1.3,0,0.2,0,0.9]
[null,"Retail margin (EBITDA)","2020-21",1.6,1.3,-0.3,0,0,1]
[null,"Retail margin (EBITDA)","2021-22",1.2,0.7,0.7,-0.2,0,0.7]
[null,"Retail margin (EBITDA)","2022-23",1.5,-0.2,1.6,1.2,0,0.6]
[null,"Retail component ","2007-08",0,0,0,0,1.5,0]
[null,"Retail component ","2008-09",0,0,0,0,0,0]
[null,"Retail component ","2009-10",0,0,0,0,0,0]
[null,"Retail component ","2010-11",0,0,0,0,2.2999999999999998,0]
[null,"Retail component ","2011-12",0,0,0,0,0,0]
[null,"Retail component ","2012-13",0,0,0,0,0,0]
[null,"Retail component ","2013-14",0,0,0,0,3.4,0]
[null,"Retail component ","2014-15",0,0,0,0,4,0]
[null,"Retail component ","2015-16",0,0,0,0,3.9,0]
[null,"Retail component ","2016-17",0,0,0,0,3.4,0]
[null,"Retail component ","2017-18",0,0,0,0,2.4,0]
[null,"Retail component ","2018-19",0,0,0,0,4,0]
[null,"Retail component ","2019-20",0,0,0,0,2.6,0]
[null,"Retail component ","2020-21",0,0,0,0,3.7,0]
[null,"Retail component ","2021-22",0,0,0,0,2.9,0]
[null,"Retail component ","2022-23",0,0,0,0,2.7,0]
[]
[]
[null,"Supplementary Table C4.3A",null,null,null,null,null,null,null,null,"Figure C4.3: Average small business customer effective prices by NEM regions, 2022–23, real $2022–23, excluding GST "]
[null,"Small Business Customers, 2022-23, real $2022–23, excluding GST "]
[null,"c/kWh","Victoria","NSW","SA","SEQ","NEM"]
[null,"Network",11.4,11.8,14.7,9.4,11.5]
[null,"Wholesale electricity",7.9,11.3,10.199999999999999,10.4,9.9]
[null,"Environmental",3.2,3.2,3.1,3.8,3.2]
[null,"Retail & other costs",1.6,1.2,1.5,1.2,1.4]
[null,"Retail margin (EBITDA)",1,1.3,2,0,1]
[null,"Retail component",0,0,0,0,0]
[null,"Total Cost Stack",25.1,28.8,31.5,24.7,27.1]
[]
[]
[null,"Supplementary Table C4.3B"]
[null,"Small Business Customers, 2022-23, real $2022–23, excluding GST "]
[null,"% of cost stack","Victoria","NSW","SA","SEQ","NEM"]
[null,"Network",0.46,0.41,0.47,0.38,0.43]
[null,"Wholesale electricity",0.31,0.39,0.32,0.42,0.37]
[null,"Environmental",0.13,0.11,0.1,0.15,0.12]
[null,"Retail & other costs",0.06,0.04,0.05,0.05,0.05]
[null,"Retail margin (EBITDA)",0.04,0.05,0.06,0,0.04]
[null,"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,null,"Note: Data labels for small cost components have been omitted for readability. "]
[]
[]
[null,"Supplementary Table C4.4",null,null,null,null,null,null,null,null,"Figure C4.4: Change in cost components of the average Victorian small business customer effective price, 2020–21 to 2022–23, real $2022–23, excluding GST "]
[null,"Small Business Customers, Victoria, 2022-23, real $2022–23, excluding GST "]
[null,"c/kWh","2020-21","2021-22","Change","2022-23","Change","Total Change"]
[null,"Network",13,11.9,-1.1000000000000001,11.4,-0.5,-1.6]
[null,"Wholesale electricity",11.3,9.1999999999999993,-2,7.9,-1.4,-3.4]
[null,"Environmental",3.2,3.6,0.4,3.2,-0.4,0]
[null,"Retail & other costs",1.9,1.8,-0.1,1.6,-0.2,-0.3]
[null,"Retail margin (EBITDA)",0.4,-0.4,-0.8,1,1.4,0.6]
[null,"Total Cost Stack",29.7,26.2,-3.5,25.1,-1.1000000000000001,-4.5999999999999996]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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. "]
[null,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."]
[]
[]
[null,"Supplementary Table C4.5",null,null,null,null,null,null,null,null,"Figure C4.5: Change in cost components of the average NSW small business customer effective price, 2020–21 to 2022–23, real $2022–23, excluding GST "]
[null,"Small Business Customers, NSW, 2022-23, real $2022–23, excluding GST "]
[null,"c/kWh","2020-21","2021-22","Change","2022-23","Change","Total Change"]
[null,"Network",12.1,12.7,0.6,11.8,-0.9,-0.3]
[null,"Wholesale electricity",9.1999999999999993,8.1,-1.1000000000000001,11.3,3.2,2.1]
[null,"Environmental",4.3,3.8,-0.5,3.2,-0.6,-1.1000000000000001]
[null,"Retail & other costs",1.4,1.2,-0.2,1.2,0,-0.3]
[null,"Retail margin (EBITDA)",2.6,1.7,-0.8,1.3,-0.4,-1.2]
[null,"Total Cost Stack",29.6,27.5,-2.1,28.8,1.3,-0.8]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
[null,"Supplementary Table C4.6",null,null,null,null,null,null,null,null,"Figure C4.6: Change in cost components of the average SA small business customer effective price, 2020–21 to 2022–23, real $2022–23, excluding GST "]
[null,"Small Business Customers, SA, 2022-23, real $2022–23, excluding GST "]
[null,"c/kWh","2020-21","2021-22","Change","2022-23","Change","Total Change"]
[null,"Network",16.8,14.8,-1.9,14.7,-0.2,-2.1]
[null,"Wholesale electricity",11.7,9.5,-2.2000000000000002,10.199999999999999,0.7,-1.5]
[null,"Environmental",3.7,3.5,-0.3,3.1,-0.3,-0.6]
[null,"Retail & other costs",1.6,1.5,0,1.5,0,0]
[null,"Retail margin (EBITDA)",0.2,1.9,1.6,2,0.1,1.7]
[null,"Total Cost Stack",34,31.2,-2.8,31.5,0.3,-2.5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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. "]
[]
[]
[]
[null,"Supplementary Table C4.7",null,null,null,null,null,null,null,null,"Figure C4.7: Change in cost components of the average SEQ small business customer effective price, 2020–21 to 2022–23, real $2022–23, excluding GST "]
[null,"Small Business Customers, SEQ, 2022-23, real $2022–23, excluding GST "]
[null,"c/kWh","2020-21","2021-22","Change","2022-23","Change","Total Change"]
[null,"Network",9.1,8.9,-0.2,9.4,0.5,0.3]
[null,"Wholesale electricity",8.6999999999999993,8.3000000000000007,-0.4,10.4,2.1,1.7]
[null,"Environmental",5.7,5.0999999999999996,-0.5,3.8,-1.4,-1.9]
[null,"Retail & other costs",1.1000000000000001,1.2,0.1,1.2,0,0.1]
[null,"Retail margin (EBITDA)",1.6,-0.2,-1.7,0,0.1,-1.6]
[null,"Total Cost Stack",26.1,23.4,-2.8,24.7,1.3,-1.4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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. "]
[null,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":"5. Network","index":6,"n_rows":98,"n_cols":10,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[null,"Cost Stack"]
[null,"Network cost component"]
[null,{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
[]
[null,"Supplementary Table C5.1a",null,null,null,null,null,null,null,"Figure C5.1: Average network costs per residential customer by NEM regions, 2013–14 to 2022-23, real $2022–23, excluding GST"]
[null,"Residential Customers - Aggregate network costs, real $2022–23, excluding GST"]
[null,"$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"2013–14",768,1063,950,1078,1180,970]
[null,"2014–15",811,1035,973,1184,1160,988]
[null,"2015–16",780,884,808,1103,1127,888]
[null,"2016–17",666,886,761,998,1193,834]
[null,"2017–18",634,835,758,831,955,768]
[null,"2018–19",609,821,795,781,996,752]
[null,"2019–20",657,774,879,801,1054,762]
[null,"2020–21",636,754,822,716,971,726]
[null,"2021–22",602,775,796,686,989,717]
[null,"2022-23",590,730,749,600,971,675]
[]
[]
[null,"Supplementary Table C5.1b"]
[null,"Residential Customers - Distribution costs, real $2022–23, excluding GST"]
[null,"$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"2017–18",477,651,570,692,657,596]
[null,"2018–19",458,645,596,649,714,586]
[null,"2019–20",486,615,663,664,767,594]
[null,"2020–21",449,592,613,565,713,551,null,"Source: ACCC analysis based on retailers’ data. "]
[null,"2021–22",424,599,584,533,758,539,null,"Note: Network proportions for distribution, transmission and metering were provided by distribution operators from 2016–17 onwards."]
[null,"2022-23",431,566,538,480,599,509]
[]
[]
[null,"Supplementary Table C5.1c"]
[null,"Residential Customers - Transmission costs, real $2022–23, excluding GST"]
[null,"$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"2017–18",114,168,170,139,259,149]
[null,"2018–19",110,159,178,131,244,144]
[null,"2019–20",124,139,196,136,249,143]
[null,"2020–21",144,143,196,151,222,152]
[null,"2021–22",146,163,199,153,198,161]
[null,"2022-23",126,160,200,120,371,153]
[]
[]
[null,"Supplementary Table C5.1d"]
[null,"Residential Customers - Metering costs, real $2022–23, excluding GST"]
[null,"$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"2017–18",43,17,18,0,39,23]
[null,"2018–19",41,17,21,0,38,22]
[null,"2019–20",46,20,21,0,38,25]
[null,"2020–21",42,19,13,0,36,23]
[null,"2021–22",31,13,12,0,33,17]
[null,"2022-23",33,5,11,0,1.5,13]
[]
[]
[null,"Supplementary Table C5.2a",null,null,null,null,null,null,null,"Figure C5.2: Average effective price for network costs per residential customer by NEM regions, 2013–14 to 2022–23, real $2022–23, excluding GST"]
[null,"Residential Customers - Aggregate network costs, real $2022–23, excluding GST"]
[null,"c/kWh","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"2013–14",16.100000000000001,18.2,19.2,18.100000000000001,15.1,17.600000000000001]
[null,"2014–15",17.2,17.3,19.600000000000001,20,15.2,17.899999999999999]
[null,"2015–16",16.399999999999999,14.7,16.2,18.899999999999999,15.2,16]
[null,"2016–17",14,14.9,16.2,17.3,15.7,15.2]
[null,"2017–18",13.7,14.4,16.600000000000001,14.8,12.4,14.4]
[null,"2018–19",13.4,14.4,17.5,14,13.1,14.3]
[null,"2019–20",14.4,13.7,19.100000000000001,14.6,13.8,14.5]
[null,"2020–21",13.9,13.3,18.399999999999999,12.7,11.5,13.7]
[null,"2021–22",13.1,13.5,17.399999999999999,12.6,12.4,13.5]
[null,"2022-23",12.7,13.1,17.3,11.3,10.8,12.9]
[]
[]
[null,"Supplementary Table C5.2b"]
[null,"Residential Customers - Distribution costs, real $2022–23, excluding GST"]
[null,"c/kWh","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"2017–18",10.3,11.3,12.4,12.3,8.5,11.2]
[null,"2018–19",10.1,11.3,13.1,11.6,9.4,11.1,null,"Source: ACCC analysis based on retailers’ data. "]
[null,"2019–20",10.7,10.9,14.4,12.1,10,11.3,null,"Note: Network proportions for distribution, transmission and metering were provided by distribution operators from 2016–17 onwards."]
[null,"2020–21",9.8000000000000007,10.4,13.7,10,8.4,10.4]
[null,"2021–22",9.1999999999999993,10.4,12.8,9.8000000000000007,9.5,10.199999999999999]
[null,"2022-23",9.3000000000000007,10.1,12.4,9,6.6,9.6999999999999993]
[]
[]
[null,"Supplementary Table C5.2c"]
[null,"Residential Customers - Transmission costs, real $2022–23, excluding GST"]
[null,"c/kWh","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"2017–18",2.5,2.9,3.7,2.5,3.4,2.8]
[null,"2018–19",2.4,2.8,3.9,2.4,3.2,2.7]
[null,"2019–20",2.7,2.5,4.3,2.5,3.2,2.7]
[null,"2020–21",3.1,2.5,4.4000000000000004,2.7,2.6,2.9]
[null,"2021–22",3.2,2.8,4.4000000000000004,2.8,2.5,3]
[null,"2022-23",2.7,2.9,4.5999999999999996,2.2999999999999998,4.0999999999999996,2.9]
[]
[]
[null,"Supplementary Table C5.2d"]
[null,"Residential Customers, Metering, real $2022–23, excluding GST"]
[null,"c/kWh","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"2017–18",0.9,0.3,0.4,0,0.5,0.4]
[null,"2018–19",0.9,0.3,0.5,0,0.5,0.4]
[null,"2019–20",1,0.4,0.5,0,0.5,0.5]
[null,"2020–21",0.9,0.3,0.3,0,0.4,0.4]
[null,"2021–22",0.7,0.2,0.3,0,0.4,0.3]
[null,"2022-23",0.7,0.1,0.3,null,0,0.3]

{"sheet":"6. Wholesale","index":7,"n_rows":787,"n_cols":11,"rows_kept":787,"cut":false,"hidden":false,"merged":[]}
[null,"Cost Stack"]
[null,"Wholesale electricity cost component"]
[null,{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
[]
[null,"Supplementary Table C6.1",null,null,null,null,null,null,null,"Figure C6.1 (Figure 2.11 in report): Average retailer wholesale costs (measured in effective price) for residential customers by National Electricity Market regions, 2018-19 to 2022-23, real, excluding GST"]
[null,"Average retailer wholesale costs for residential customers real $2022-23, excluding GST"]
[null,"c/kWh","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"2018–19",12.1,10.1,14.3,10.7,10.7,11.1]
[null,"2019–20",12.6,10,13.1,9.1999999999999993,12.6,10.9]
[null,"2020–21",11.2,9,10.9,8.1,9.5,9.6]
[null,"2021–22",8.6999999999999993,7.6,8,6.9,8.1,7.8]
[null,"2022–23",7.8,10.5,9.3000000000000007,9.1,8.6999999999999993,9.4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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: \tNSW includes ACT from 2019–20."]
[]
[]
[null,"Supplementary Table C6.2",null,null,null,null,null,null,null,"FIgure C6.2 (Figure 2.14 in report): Average retail margins (earnings before interest, tax, depreciation and amortisation) for small business customers, c/kWh, by region, 2016-–17 to 2022-–23, real, excluding GST"]
[null,"Average retail margins real $2022-23, excluding GST, SME, by region."]
[null,"SME","VIC","NSW","SA","SEQ","NEM"]
[null,"2016-17",2.6,3.5,0.8,1.3,2.5]
[null,"2017-18",1.1000000000000001,3.9,1.3,2.2000000000000002,2.4]
[null,"2018-19",1.8,3.6,1.4,2.8,2.6]
[null,"2019-20",0.2,2.7,1.2,1.6,1.5]
[null,"2020-21",0.4,2.6,0.2,1.6,1.5]
[null,"2021-22",-0.4,1.7,1.9,-0.2,0.8]
[null,"2022-23",1,1.3,2,0,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data. "]
[]
[null,"Supplementary table C6.3",null,null,null,null,null,null,null,"Figure C6.3 (Figure 2.1 in report): National Electricity Market volume weighted spot price by region, monthly, January 2021 to September 2023"]
[null,"National Electricity Market volume weighted spot price by region, $MWh"]
[null,"Period Beginning","Queensland","New South Wales","Victoria","South Australia"]
[null,"2021-01-01",41.75,40.49,25.14,39.96]
[null,"2021-02-01",43.54,35.450000000000003,23.77,31.08]
[null,"2021-03-01",48.63,39.659999999999997,31.52,86.97]
[null,"2021-04-01",57.68,59.55,53.85,57.17]
[null,"2021-05-01",138.44999999999999,133.77000000000001,83.47,82.12]
[null,"2021-06-01",224.63,181.16,92.32,87.84]
[null,"2021-07-01",151.06,135.65,99.63,98.54]
[null,"2021-08-01",58.26,64.45,52.52,52.83]
[null,"2021-09-01",56.33,52.04,32.71,29.39]
[null,"2021-10-01",74.61,59.96,22.22,26.62]
[null,"2021-11-01",104.95,65.92,38.299999999999997,46.95]
[null,"2021-12-01",149.19999999999999,70.319999999999993,37.630000000000003,105.52]
[null,"2022-01-01",153.61000000000001,79.13,73.069999999999993,110.07]
[null,"2022-02-01",191.67,85.52,58.14,63.63]
[null,"2022-03-01",170.62,102.19,58.89,80.010000000000005]
[null,"2022-04-01",233.63,192.76,149.02000000000001,165.13]
[null,"2022-05-01",364.93,333.06,243.41,334.23]
[null,"2022-06-01",430.87,410.35,311.8,319.23,null,null,null,"Source:","Australian Energy Market Operator."]
[null,"2022-07-01",429.61,383.66,360.29,396.59]
[null,"2022-08-01",144.04,155.19999999999999,130.36000000000001,187.28]
[null,"2022-09-01",165.66,160.96,121.26,165.39]
[null,"2022-10-01",161.84,157.63999999999999,107.6,112.12]
[null,"2022-11-01",130.77000000000001,118.43,64.3,73.91]
[null,"2022-12-01",92.62,86.76,37.68,54.42]
[null,"2023-01-01",107.34,98.17,55.67,75.39]
[null,"2023-02-01",94.71,93.86,68.540000000000006,146.27000000000001]
[null,"2023-03-01",138.27000000000001,127.86,67.489999999999995,77.7]
[null,"2023-04-01",118.93,116.54,90.41,97.71]
[null,"2023-05-01",183.37,210.31,133.91,207.69]
[null,"2023-06-01",112.25,112.31,62.06,95.2]
[null,"2023-07-01",84.56,90.26,62.1,82.49]
[null,"2023-08-01",77.33,102.11,73.42,189.45]
[null,"2023-09-01",59.54,72.8,36.07,62.19]
[]
[]
[null,"Supplementary table C6.4",null,null,null,null,null,null,null,"Figure C6.4 (Figure 2.2 in report): Daily base futures contract settlement price by region, quarter 2 2024, 1 January 2021 to 18 October 2023"]
[null,"Daily base futures contract settlement price by region, quarter 2 2024"]
[null,"SETTLEMENTDAY","New South Wales","Queensland","South Australia","Victoria"]
[null,"2021-01-04",52.8,36.83,49.99,36.130000000000003]
[null,"2021-01-05",52.8,36.83,49.99,36.130000000000003]
[null,"2021-01-06",52.8,36.83,49.99,36.130000000000003]
[null,"2021-01-07",52.8,36.83,49.99,36.130000000000003]
[null,"2021-01-08",53.3,37.18,49.99,36.130000000000003]
[null,"2021-01-11",52.85,37.18,45.9,36.130000000000003]
[null,"2021-01-12",52.25,36.58,43.95,36.130000000000003]
[null,"2021-01-13",51.5,36.58,42.65,36.130000000000003]
[null,"2021-01-14",51.5,36.58,41.57,36.130000000000003]
[null,"2021-01-15",51.5,36.58,41.57,36.130000000000003]
[null,"2021-01-18",51.5,36.58,40.619999999999997,36.130000000000003]
[null,"2021-01-19",52.02,36.58,38.590000000000003,36.130000000000003]
[null,"2021-01-20",52.02,36.31,37.75,36.130000000000003]
[null,"2021-01-21",52.02,36.18,37.75,36.130000000000003]
[null,"2021-01-22",52.02,36.090000000000003,37.75,36.130000000000003]
[null,"2021-01-25",50.25,36.090000000000003,34.76,35.18]
[null,"2021-01-27",50.24,35.92,34.76,34.97]
[null,"2021-01-28",50.24,35,34.76,34.97,null,null,null,"Source: ASX Energy Data Centre."]
[null,"2021-01-29",50.24,35.020000000000003,34.76,34.97]
[null,"2021-02-01",50.56,35.43,34.76,34.97]
[null,"2021-02-02",50.56,35.42,34.76,34.97]
[null,"2021-02-03",50.08,35.25,34.76,34.97]
[null,"2021-02-04",50.08,35.25,34.76,34.97]
[null,"2021-02-05",50,35.409999999999997,34.76,34.97]
[null,"2021-02-08",49.44,35.409999999999997,33.39,33.17]
[null,"2021-02-09",49,35.409999999999997,33.39,32.46]
[null,"2021-02-10",49,35.29,33.39,32.46]
[null,"2021-02-11",49,35.29,33.39,32.46]
[null,"2021-02-12",49,35,33.39,31.25]
[null,"2021-02-15",49,35,33.39,31.25]
[null,"2021-02-16",47.5,34.75,33.39,31.12]
[null,"2021-02-17",48,34.49,33.39,30.98]
[null,"2021-02-18",47.92,33.700000000000003,33.39,30.98]
[null,"2021-02-19",47.24,33.08,33.39,30.98]
[null,"2021-02-22",47,32.200000000000003,33.39,30.98]
[null,"2021-02-23",47,32.200000000000003,33.39,30.98]
[null,"2021-02-24",47.79,32.200000000000003,33.39,31]
[null,"2021-02-25",47.73,32.200000000000003,33.39,31]
[null,"2021-02-26",47.73,32.200000000000003,33.39,31]
[null,"2021-03-01",47.66,32.200000000000003,33.39,31]
[null,"2021-03-02",47.66,32.200000000000003,33.39,31]
[null,"2021-03-03",47.66,32.67,33.39,31]
[null,"2021-03-04",47.34,32.67,33.39,31]
[null,"2021-03-05",47.34,32.67,33.39,31.58]
[null,"2021-03-08",46,32.67,29.48,31.58]
[null,"2021-03-09",46,33.950000000000003,29.48,32.18]
[null,"2021-03-10",45.79,33.64,29.48,31.95]
[null,"2021-03-11",45.79,33.64,29.48,32.4]
[null,"2021-03-12",45.63,34.119999999999997,29.48,32.4]
[null,"2021-03-15",45.63,34.119999999999997,29.48,32.4]
[null,"2021-03-16",45.33,34.119999999999997,29.48,32.07]
[null,"2021-03-17",45.69,34.119999999999997,29.48,32.07]
[null,"2021-03-18",45.92,34.119999999999997,29.48,32.07]
[null,"2021-03-19",45.61,34.119999999999997,29.48,31.96]
[null,"2021-03-22",45.61,34.119999999999997,29.48,31.21]
[null,"2021-03-23",45.61,34.119999999999997,29.48,30.73]
[null,"2021-03-24",45.69,34.119999999999997,29.48,30.73]
[null,"2021-03-25",46.05,34.119999999999997,29.48,30.73]
[null,"2021-03-26",46.27,34.380000000000003,29.48,30.73]
[null,"2021-03-29",46.22,34.380000000000003,29.48,30.73]
[null,"2021-03-30",46.01,34.380000000000003,29.48,31]
[null,"2021-03-31",46.02,34.380000000000003,29.48,31]
[null,"2021-04-01",46.04,34.380000000000003,29.48,30.56]
[null,"2021-04-06",47.73,34.51,29.48,30.67]
[null,"2021-04-07",48.77,34.51,29.48,31.11]
[null,"2021-04-08",49.03,35.35,29.48,30.68]
[null,"2021-04-09",49.03,35.35,29.48,30.68]
[null,"2021-04-12",48.97,35.35,29.48,29.49]
[null,"2021-04-13",48.97,35.35,29.48,29.49]
[null,"2021-04-14",49.22,35.47,29.48,29.98]
[null,"2021-04-15",50.15,35.47,29.48,29.98]
[null,"2021-04-16",50.5,35.49,29.48,30.39]
[null,"2021-04-19",50.58,35.71,29.48,30.39]
[null,"2021-04-20",50.81,36.28,29.48,30.85]
[null,"2021-04-21",50.81,36.28,29.48,31.55]
[null,"2021-04-22",50.81,36.28,29.48,32.25]
[null,"2021-04-23",50.81,36.450000000000003,29.48,32.61]
[null,"2021-04-26",51.37,36.450000000000003,29.48,33.06]
[null,"2021-04-27",51.83,37.020000000000003,29.48,33.92]
[null,"2021-04-28",51.83,37.020000000000003,29.48,34]
[null,"2021-04-29",51.83,37.020000000000003,29.48,34]
[null,"2021-04-30",51.83,37.020000000000003,29.48,34]
[null,"2021-05-03",51.83,37.020000000000003,29.48,34]
[null,"2021-05-04",51.83,37.229999999999997,29.48,34]
[null,"2021-05-05",51.83,37.229999999999997,29.48,34]
[null,"2021-05-06",51.83,37.03,29.48,34]
[null,"2021-05-07",51.83,37.03,29.48,35]
[null,"2021-05-10",52.2,37.03,29.48,35]
[null,"2021-05-11",53.03,37.19,29.48,35]
[null,"2021-05-12",53.26,37.36,29.48,35]
[null,"2021-05-13",53.26,37.47,29.48,35]
[null,"2021-05-14",53.26,37.32,29.48,34.72]
[null,"2021-05-17",53.26,37.51,29.48,34.5]
[null,"2021-05-18",52.95,37.51,29.5,34.5]
[null,"2021-05-19",52.89,37.51,29.5,34.5]
[null,"2021-05-20",52.78,38.39,34,34.85]
[null,"2021-05-21",52.78,38.5,34,34.78]
[null,"2021-05-24",52.72,38.5,34,34.78]
[null,"2021-05-25",52.96,38.549999999999997,34,34.78]
[null,"2021-05-26",52.77,38.14,34,35.090000000000003]
[null,"2021-05-27",53.25,38,34,35.75]
[null,"2021-05-28",53.25,38,34,35.96]
[null,"2021-05-31",52.83,38,35.78,35.89]
[null,"2021-06-01",52.83,38,36,35.659999999999997]
[null,"2021-06-02",52.83,38.25,36,35.659999999999997]
[null,"2021-06-03",52.83,38.25,36,35.659999999999997]
[null,"2021-06-04",52.84,38.25,36,36]
[null,"2021-06-07",53.12,38.42,36,35.880000000000003]
[null,"2021-06-08",52.38,35.97,36.69,35.6]
[null,"2021-06-09",51.91,37.17,36.69,35.049999999999997]
[null,"2021-06-10",52,37.17,36.69,35.049999999999997]
[null,"2021-06-11",53,37.17,36.69,35.049999999999997]
[null,"2021-06-15",53,41,36.99,35.1]
[null,"2021-06-16",53,39.979999999999997,36.99,35.44]
[null,"2021-06-17",53,39.54,36.99,35.44]
[null,"2021-06-18",53,39.1,36.99,35.44]
[null,"2021-06-21",53,39.54,36.99,35.44]
[null,"2021-06-22",53,39.86,36.99,35.5]
[null,"2021-06-23",53,40.29,38.340000000000003,35.630000000000003]
[null,"2021-06-24",53,40.29,38.69,35.4]
[null,"2021-06-25",53,40.29,38.69,35.4]
[null,"2021-06-28",53,40.29,39.21,35.4]
[null,"2021-06-29",53.31,41.05,40.26,36.75]
[null,"2021-06-30",54.04,41.76,42.27,37.270000000000003]
[null,"2021-07-01",54.98,41.47,42.27,38]
[null,"2021-07-02",55.74,42.8,42.27,38]
[null,"2021-07-05",55.92,44.26,42.65,39]
[null,"2021-07-06",55.45,43.6,42.65,38.229999999999997]
[null,"2021-07-07",55.45,44.2,42.95,39.17]
[null,"2021-07-08",55.5,44.25,42.95,40.36]
[null,"2021-07-09",55.5,44.25,42.95,40.36]
[null,"2021-07-12",55.5,44.25,42.95,40.36]
[null,"2021-07-13",56.15,45,42.95,41.12]
[null,"2021-07-14",56.24,45.52,43.04,41.65]
[null,"2021-07-15",56.24,45.52,43.04,41.65]
[null,"2021-07-16",56.24,45.36,43.04,43.75]
[null,"2021-07-19",58,46.13,43.04,44.38]
[null,"2021-07-20",59.9,45.9,44.36,44.38]
[null,"2021-07-21",59.9,45.57,44.36,44.38]
[null,"2021-07-22",59.9,44.94,44.36,44.38]
[null,"2021-07-23",59.9,44.71,44.36,44.22]
[null,"2021-07-26",59.12,44,44.36,43.37]
[null,"2021-07-27",58.22,44,44.36,43.5]
[null,"2021-07-28",58.22,44,44.67,45]
[null,"2021-07-29",59.48,44,44.67,45.66]
[null,"2021-07-30",59.96,44,44.67,45.74]
[null,"2021-08-02",59.96,44,44.67,45.74]
[null,"2021-08-03",59.96,44,44.67,44.78]
[null,"2021-08-04",59.47,44,44.67,44.78]
[null,"2021-08-05",59.47,44,44.67,44.78]
[null,"2021-08-06",60.31,44,44.67,44.78]
[null,"2021-08-09",60.31,42.99,44.67,44.78]
[null,"2021-08-10",60.66,43.15,44.67,44.78]
[null,"2021-08-11",60.66,43.37,45.2,44.78]
[null,"2021-08-12",60.66,43.66,45.2,44.83]
[null,"2021-08-13",60.66,43.58,45.2,44.83]
[null,"2021-08-16",60.66,43.58,45.2,44.83]
[null,"2021-08-17",60.66,43.45,45.35,44.83]
[null,"2021-08-18",60.69,43.5,45.72,44.83]
[null,"2021-08-19",60.69,42.96,45.72,44.83]
[null,"2021-08-20",60.69,42.96,45.72,44.83]
[null,"2021-08-23",60.69,42.96,45.72,44.83]
[null,"2021-08-24",60.89,42.96,45.72,45.26]
[null,"2021-08-25",60.89,42.96,45.72,44.78]
[null,"2021-08-26",60.89,42.96,45.72,44.78]
[null,"2021-08-27",60.89,42.96,45.72,44.78]
[null,"2021-08-30",61.02,42.96,45.72,44.78]
[null,"2021-08-31",61.02,42.96,45.72,44.78]
[null,"2021-09-01",61.15,43.03,45.92,44.79]
[null,"2021-09-02",61.21,43.03,45.92,44.79]
[null,"2021-09-03",61.41,43.03,45.92,44.79]
[null,"2021-09-06",61.41,43.03,45.92,44.79]
[null,"2021-09-07",61.41,42.9,45.92,44.79]
[null,"2021-09-08",61.14,42.78,45.92,44.79]
[null,"2021-09-09",61.42,42.78,45.92,44.79]
[null,"2021-09-10",61.48,43,45.92,44.79]
[null,"2021-09-13",61.48,43,46.75,44.79]
[null,"2021-09-14",61.16,43,46.75,44.65]
[null,"2021-09-15",61.16,43,46.75,44.65]
[null,"2021-09-16",61.33,43,46.75,44.65]
[null,"2021-09-17",61.33,42.89,46.75,44.35]
[null,"2021-09-20",61.33,43.04,46.75,44.35]
[null,"2021-09-21",61.9,43.44,46.75,44.76]
[null,"2021-09-22",62.26,43.44,46.75,44.53]
[null,"2021-09-23",62.86,43.51,46.75,44.56]
[null,"2021-09-24",62.86,43.93,46.75,44.56]
[null,"2021-09-27",63.25,43.93,46.75,44.93]
[null,"2021-09-28",63,43.77,46.75,44.74]
[null,"2021-09-29",63.83,45.05,46.75,44.98]
[null,"2021-09-30",63.83,45.97,46.75,45.49]
[null,"2021-10-01",63.83,46.79,46.75,45.49]
[null,"2021-10-04",63.75,46.76,46.75,45.49]
[null,"2021-10-05",63.75,46.12,46.75,45.05]
[null,"2021-10-06",63.75,46.12,46.75,44.75]
[null,"2021-10-07",63.75,46.12,46.75,44.75]
[null,"2021-10-08",63.75,46.35,46.75,44.75]
[null,"2021-10-11",63.75,46.35,46.75,44.75]
[null,"2021-10-12",63.75,46.35,46.75,44.75]
[null,"2021-10-13",63,46.35,46.75,44.73]
[null,"2021-10-14",63,46.35,46.75,44.73]
[null,"2021-10-15",63,46.35,46.75,44.73]
[null,"2021-10-18",63,46.35,46.75,44.73]
[null,"2021-10-19",63,47.5,46.75,45.29]
[null,"2021-10-20",63,48,46.75,45.5]
[null,"2021-10-21",63.7,48.24,46.75,45.85]
[null,"2021-10-22",65,48.6,46.75,46.56]
[null,"2021-10-25",65,48.6,46.75,46.56]
[null,"2021-10-26",64.75,48.6,46.75,46.56]
[null,"2021-10-27",64.75,48.6,46.75,45.79]
[null,"2021-10-28",64.75,48.59,46.75,45.79]
[null,"2021-10-29",64.75,47.81,46.75,45.79]
[null,"2021-11-01",64.75,47.81,46.75,45.79]
[null,"2021-11-02",64.75,48.15,46.75,45.79]
[null,"2021-11-03",64.75,48.38,46.75,45.79]
[null,"2021-11-04",64.75,48.38,46.75,45.79]
[null,"2021-11-05",65.400000000000006,49.11,46.75,45.79]
[null,"2021-11-08",65.400000000000006,49.34,46.75,45.79]
[null,"2021-11-09",65.44,49.34,46.75,45.72]
[null,"2021-11-10",65.39,49.14,46.75,45.72]
[null,"2021-11-11",65.42,48.92,46.75,45.72]
[null,"2021-11-12",65.42,48.62,46.75,45.72]
[null,"2021-11-15",65.42,48.21,46.75,45.72]
[null,"2021-11-16",65.75,49.03,46.75,46.12]
[null,"2021-11-17",66,49.19,46.75,46.12]
[null,"2021-11-18",65.73,48.56,46.75,46.12]
[null,"2021-11-19",65.73,47.95,46.75,46.12]
[null,"2021-11-22",65.73,48,46.75,46.12]
[null,"2021-11-23",65.849999999999994,48.2,46.75,46.12]
[null,"2021-11-24",65.849999999999994,48.33,46.75,46.12]
[null,"2021-11-25",65.849999999999994,49.66,49.23,46.12]
[null,"2021-11-26",66.92,51,50.18,47]
[null,"2021-11-29",68.08,52.01,50.18,47.1]
[null,"2021-11-30",68.739999999999995,53,50.18,48.1]
[null,"2021-12-01",68.55,52,50.18,48.1]
[null,"2021-12-02",68.25,52,50.18,48.1]
[null,"2021-12-03",68.25,52,50.18,48.1]
[null,"2021-12-06",68.75,52,50.18,48.1]
[null,"2021-12-07",70.819999999999993,53.51,50.18,49]
[null,"2021-12-08",70.819999999999993,53.64,50.18,49.01]
[null,"2021-12-09",71.459999999999994,53.68,50.18,49.01]
[null,"2021-12-10",71.459999999999994,53.68,50.18,49.01]
[null,"2021-12-13",70.8,53.55,50.18,48.23]
[null,"2021-12-14",70.11,52.78,50.18,47.61]
[null,"2021-12-15",70.27,52.99,50.18,47.61]
[null,"2021-12-16",70.27,52.99,51.15,47.61]
[null,"2021-12-17",70.87,53.5,51.6,47.61]
[null,"2021-12-20",72.5,53.61,51.6,47.61]
[null,"2021-12-21",74.14,54.07,51.6,50]
[null,"2021-12-22",74.14,53.86,51.6,50]
[null,"2021-12-23",76,54,51.6,51]
[null,"2021-12-24",77.34,54.19,51.6,51]
[null,"2021-12-29",77,54.19,51.6,51]
[null,"2021-12-30",76.5,53.63,51.6,50.56]
[null,"2021-12-31",76.959999999999994,53.53,51.6,50.56]
[null,"2022-01-04",78.05,54.42,52.5,50.56]
[null,"2022-01-05",79.3,56.53,53,50.56]
[null,"2022-01-06",78.849999999999994,56.64,53,50.56]
[null,"2022-01-07",78.55,56.31,53,50.34]
[null,"2022-01-10",78.91,56.66,54.71,51.28]
[null,"2022-01-11",79.010000000000005,57.11,54.71,51.02]
[null,"2022-01-12",79.23,57.36,54.71,50.86]
[null,"2022-01-13",79,57.25,54.71,50.86]
[null,"2022-01-14",78.25,56.99,54.71,50.45]
[null,"2022-01-17",77.81,56.25,54.71,50.45]
[null,"2022-01-18",77.25,56,55,50]
[null,"2022-01-19",75,55.24,55,50]
[null,"2022-01-20",76.19,55.71,55,49.75]
[null,"2022-01-21",77.12,57.19,55,49.75]
[null,"2022-01-24",77.12,56.51,55,49.75]
[null,"2022-01-25",76.62,56.05,55.33,49.25]
[null,"2022-01-27",77,57,56,49.25]
[null,"2022-01-28",77.5,57.13,56.89,49.25]
[null,"2022-01-31",78.010000000000005,57.74,58.47,49.25]
[null,"2022-02-01",78.010000000000005,57.75,58.47,49.25]
[null,"2022-02-02",78.010000000000005,57.75,58.47,49.25]
[null,"2022-02-03",76.55,56.41,58.47,49.25]
[null,"2022-02-04",76.64,57,58.47,48.95]
[null,"2022-02-07",76.64,57,58.47,48.95]
[null,"2022-02-08",76.25,56,58.47,48.95]
[null,"2022-02-09",75.44,54.66,58.47,48.95]
[null,"2022-02-10",75.55,55,58.47,48.95]
[null,"2022-02-11",75.55,55,58.47,48.95]
[null,"2022-02-14",75.34,54.25,58.47,48.5]
[null,"2022-02-15",75.75,54.74,58.47,48.15]
[null,"2022-02-16",76.5,54.83,58.47,47.92]
[null,"2022-02-17",79.25,56.69,58.47,49.13]
[null,"2022-02-18",82.52,59.19,59.75,49.65]
[null,"2022-02-21",83.5,60.25,59.75,51.2]
[null,"2022-02-22",84.42,60.07,61.75,51.78]
[null,"2022-02-23",83.1,58.78,61.75,51.37]
[null,"2022-02-24",84,60,61.75,51.37]
[null,"2022-02-25",85.46,60.99,61.75,51.78]
[null,"2022-02-28",85.91,61.5,62.16,52.14]
[null,"2022-03-01",85.91,61.68,63.06,51.74]
[null,"2022-03-02",86.6,63,63.06,51.74]
[null,"2022-03-03",88.88,65.34,64.56,51.74]
[null,"2022-03-04",88.9,65.569999999999993,64.56,51.79]
[null,"2022-03-07",90.35,66.73,64.56,51.69]
[null,"2022-03-08",90.72,67.459999999999994,64.56,50.76]
[null,"2022-03-09",91.47,68,64.56,50.83]
[null,"2022-03-10",91.47,66.75,64.56,50.38]
[null,"2022-03-11",91.69,66.69,64.56,50.94]
[null,"2022-03-14",91.62,67.02,64.56,50.94]
[null,"2022-03-15",93.5,68.25,65.06,53]
[null,"2022-03-16",95.08,68.569999999999993,65.06,53.6]
[null,"2022-03-17",95.08,68.569999999999993,65.06,53.27]
[null,"2022-03-18",96.41,69.819999999999993,65.56,53.75]
[null,"2022-03-21",99.61,70.650000000000006,66.209999999999994,54.49]
[null,"2022-03-22",101.47,71.010000000000005,67.61,54.49]
[null,"2022-03-23",103.28,71.849999999999994,68.36,54.57]
[null,"2022-03-24",108.72,72.59,70.37,54.83]
[null,"2022-03-25",117.12,73.87,70.37,55.69]
[null,"2022-03-28",122.5,79.61,70.37,59.01]
[null,"2022-03-29",115,75.099999999999994,70.37,57.95]
[null,"2022-03-30",116.5,76.8,70.37,57.92]
[null,"2022-03-31",116.5,77.13,70.37,57.92]
[null,"2022-04-01",119.22,81.5,73.42,59.1]
[null,"2022-04-04",119.22,85.58,76.08,60]
[null,"2022-04-05",120,81.75,76.08,56.77]
[null,"2022-04-06",119,81.08,76.08,58.25]
[null,"2022-04-07",105.57,73,76.08,57]
[null,"2022-04-08",106.25,74,76.08,58.43]
[null,"2022-04-11",103.83,72.5,76.08,58.43]
[null,"2022-04-12",98.47,69.75,76.08,57.79]
[null,"2022-04-13",92.92,68.25,76.08,57.79]
[null,"2022-04-14",103.22,72.91,76.08,58.4]
[null,"2022-04-19",103.99,75.19,77.069999999999993,59.94]
[null,"2022-04-20",104.4,75.53,77.569999999999993,60.8]
[null,"2022-04-21",104.4,77,77.819999999999993,61]
[null,"2022-04-22",104.4,77.13,77.819999999999993,60.97]
[null,"2022-04-25",104.4,77.13,77.819999999999993,60.97]
[null,"2022-04-26",104.4,78.75,77.819999999999993,61.45]
[null,"2022-04-27",104.4,78.73,78.05,61.71]
[null,"2022-04-28",106.5,79.98,78.05,62.57]
[null,"2022-04-29",107.63,80.989999999999995,79.08,64.95]
[null,"2022-05-02",106.36,81.19,79.08,63.65]
[null,"2022-05-03",106.37,80.989999999999995,79.08,63.25]
[null,"2022-05-04",107.5,81.98,79.08,64.459999999999994]
[null,"2022-05-05",107.5,81.61,79.08,63.75]
[null,"2022-05-06",105.73,79.319999999999993,79.08,61.55]
[null,"2022-05-09",105.73,80.459999999999994,79.959999999999994,61.93]
[null,"2022-05-10",105.73,80.459999999999994,80.69,61.93]
[null,"2022-05-11",104.54,79.209999999999994,80.69,61.5]
[null,"2022-05-12",104.54,79.3,80.69,61.87]
[null,"2022-05-13",104,80.3,80.69,62.08]
[null,"2022-05-16",105.26,83.29,82.42,63.39]
[null,"2022-05-17",108.57,86.3,84.47,64.69]
[null,"2022-05-18",108.54,89.09,90.11,66.239999999999995]
[null,"2022-05-19",112.05,92.5,97.39,68.25]
[null,"2022-05-20",115.08,99.47,100.3,73.36]
[null,"2022-05-23",124.85,106.29,102,76.430000000000007]
[null,"2022-05-24",123.3,104.29,102,75.400000000000006]
[null,"2022-05-25",127.63,106.5,106.61,77.31]
[null,"2022-05-26",127.86,106.5,117.7,77.31]
[null,"2022-05-27",135.68,114.36,128.46,84.91]
[null,"2022-05-30",146.38,123.76,139.53,84.91]
[null,"2022-05-31",136.43,117,139.53,83.17]
[null,"2022-06-01",133.5,114.5,139.53,84.31]
[null,"2022-06-02",130.47999999999999,111.3,139.53,84.31]
[null,"2022-06-03",127.27,107.33,139.53,84.22]
[null,"2022-06-06",130.82,110,140.66999999999999,84]
[null,"2022-06-07",133,110,141,84]
[null,"2022-06-08",135.41,110,145.72,84.2]
[null,"2022-06-09",143.75,113.5,151.72,86]
[null,"2022-06-10",145.5,111,151.72,85.73]
[null,"2022-06-14",145.5,108.91,151.72,85.73]
[null,"2022-06-15",143.29,107.14,151.72,83.33]
[null,"2022-06-16",142.88999999999999,107.25,151.72,83.75]
[null,"2022-06-17",142.88999999999999,107.63,151.72,83.75]
[null,"2022-06-20",142.88999999999999,107.63,151.72,83.75]
[null,"2022-06-21",142.88999999999999,106.75,151.72,83.75]
[null,"2022-06-22",143.25,107.5,151.72,84.25]
[null,"2022-06-23",144.25,107.5,151.72,84.25]
[null,"2022-06-24",142.81,103.76,151.72,84.25]
[null,"2022-06-27",140.75,100.75,151.72,82.97]
[null,"2022-06-28",140.75,101.41,151.72,82.97]
[null,"2022-06-29",140.75,101.41,151.72,82.97]
[null,"2022-06-30",140.75,101.41,151.72,83.5]
[null,"2022-07-01",140.75,102.21,138.47,85.91]
[null,"2022-07-04",140.75,103.42,138.47,87.5]
[null,"2022-07-05",139.94999999999999,103.64,135,88.77]
[null,"2022-07-06",139.25,102.91,135,88.25]
[null,"2022-07-07",139.19999999999999,101.5,135,88.25]
[null,"2022-07-08",139.19999999999999,101.5,135,89]
[null,"2022-07-11",139.19999999999999,101.85,135,89]
[null,"2022-07-12",139.37,101.5,136.04,91.93]
[null,"2022-07-13",139.37,101.5,136.04,91.93]
[null,"2022-07-14",142.94,102.5,136.04,95.69]
[null,"2022-07-15",146.56,103,136,103.78]
[null,"2022-07-18",144.47,101.96,136,101.65]
[null,"2022-07-19",144.47,101.96,136,101.25]
[null,"2022-07-20",143.25,101,136,101.25]
[null,"2022-07-21",143.06,100,140.13,97.75]
[null,"2022-07-22",140.94999999999999,99,133.5,92.28]
[null,"2022-07-25",141.86000000000001,99.45,133.5,93.75]
[null,"2022-07-26",143.55000000000001,100.1,133.5,96.25]
[null,"2022-07-27",146,100.87,133.5,97]
[null,"2022-07-28",142.5,99.05,133,95]
[null,"2022-07-29",138.88,97.47,130,93.75]
[null,"2022-08-01",130.31,91.52,130,87.05]
[null,"2022-08-02",130.31,90.5,130,87.05]
[null,"2022-08-03",128,89.75,130,84.29]
[null,"2022-08-04",132.62,92.57,130,86.94]
[null,"2022-08-05",137,96.11,130,90.2]
[null,"2022-08-08",137,92.5,130,87.97]
[null,"2022-08-09",130.63999999999999,92.5,130,87.71]
[null,"2022-08-10",132,94.63,130,89.67]
[null,"2022-08-11",133.5,96.04,130,90.51]
[null,"2022-08-12",136.71,98,130,94.5]
[null,"2022-08-15",136.71,98,130,94.5]
[null,"2022-08-16",141.44,101.5,135,97.41]
[null,"2022-08-17",143.5,103.24,136.5,101.35]
[null,"2022-08-18",141.91999999999999,103.07,136.5,101.35]
[null,"2022-08-19",144.88999999999999,105,137.47,102]
[null,"2022-08-22",147,107.55,138.36000000000001,104.39]
[null,"2022-08-23",147,108,140,106.13]
[null,"2022-08-24",144,106.7,140,103.5]
[null,"2022-08-25",144,106.7,141.16,104.94]
[null,"2022-08-26",144.5,106.62,141.16,104.94]
[null,"2022-08-29",148.16999999999999,109.91,141.16,106.92]
[null,"2022-08-30",150.85,111.08,141.16,108.25]
[null,"2022-08-31",150.97,112.02,142.44,108]
[null,"2022-09-01",148.87,111.48,142.44,108]
[null,"2022-09-02",149.30000000000001,111.48,144.02000000000001,108.01]
[null,"2022-09-05",152.30000000000001,114.43,145.5,109.37]
[null,"2022-09-06",156.03,117.49,148.94999999999999,110.86]
[null,"2022-09-07",161,121.21,154.26,114]
[null,"2022-09-08",168.13,127.9,158.19,118.06]
[null,"2022-09-09",172.64,130.93,163.28,122.26]
[null,"2022-09-12",171.5,128.75,163.28,122]
[null,"2022-09-13",170,124.18,162,119.5]
[null,"2022-09-14",170.63,121.5,162,120]
[null,"2022-09-15",171,124.02,162,121.76]
[null,"2022-09-16",170.94,123.16,162,121]
[null,"2022-09-19",166.7,118.34,162,119]
[null,"2022-09-20",161.57,117,162,116.93]
[null,"2022-09-21",163,118,162,116.93]
[null,"2022-09-22",163,118,162,116.93]
[null,"2022-09-23",164,118,162,118]
[null,"2022-09-26",164.18,118.15,165.08,118]
[null,"2022-09-27",166.99,123.5,167.08,126]
[null,"2022-09-28",166.98,124.02,167.08,126]
[null,"2022-09-29",172.55,128,167.08,130.84]
[null,"2022-09-30",176.23,128,173.63,132]
[null,"2022-10-03",176,124.72,173.63,130.16999999999999]
[null,"2022-10-04",179.98,133.5,173.63,130.34]
[null,"2022-10-05",187.47,138,173.63,139.18]
[null,"2022-10-06",192.65,140.58000000000001,173.63,142.41999999999999]
[null,"2022-10-07",198.66,150,173.63,151.29]
[null,"2022-10-10",216.87,168,173.63,169.75]
[null,"2022-10-11",220.18,168.5,175,168]
[null,"2022-10-12",212.98,162,176.97,164]
[null,"2022-10-13",213,158,176.97,163.19999999999999]
[null,"2022-10-14",209,157.99,176.97,158]
[null,"2022-10-17",206,156.93,176.97,158]
[null,"2022-10-18",217,167.5,176.97,168]
[null,"2022-10-19",217,167.92,176.97,168]
[null,"2022-10-20",217,172,176.97,168.75]
[null,"2022-10-21",220.23,175.73,193,171.98]
[null,"2022-10-24",218.45,173.5,200,169.25]
[null,"2022-10-25",218.45,172,210.2,167.5]
[null,"2022-10-26",214,167,210.2,160.31]
[null,"2022-10-27",205,162.38,210.2,153.5]
[null,"2022-10-28",201.41,161,210.2,149.06]
[null,"2022-10-31",185.25,146.5,210.2,137]
[null,"2022-11-01",185.25,143.04,210.2,136]
[null,"2022-11-02",191.32,148.29,210.2,140.05000000000001]
[null,"2022-11-03",200,158.84,210.2,147]
[null,"2022-11-04",198.05,155.5,210.2,140]
[null,"2022-11-07",196,152.5,210.2,141]
[null,"2022-11-08",199,154,210.2,141.65]
[null,"2022-11-09",180,135,210.2,132.5]
[null,"2022-11-10",169.13,127.57,209.51,124.08]
[null,"2022-11-11",168,125.23,208.41,119.6]
[null,"2022-11-14",175.22,131,208.41,125]
[null,"2022-11-15",175,132.55000000000001,208.41,125.61]
[null,"2022-11-16",180,139,208.41,126]
[null,"2022-11-17",177,135.69999999999999,208.41,125]
[null,"2022-11-18",175.16,133.76,208.41,123]
[null,"2022-11-21",175,133.75,208.41,124]
[null,"2022-11-22",170,130.91999999999999,208.41,120.5]
[null,"2022-11-23",173.25,132,208.41,120.5]
[null,"2022-11-24",173.4,133.25,208.41,120.5]
[null,"2022-11-25",174.5,134.5,208.41,122]
[null,"2022-11-28",176,135.03,208.41,116]
[null,"2022-11-29",180,136,208.41,119.77]
[null,"2022-11-30",176.05,131,208.41,114.01]
[null,"2022-12-01",176.25,131.5,208.41,115.79]
[null,"2022-12-02",173,128,208.41,110.55]
[null,"2022-12-05",170.03,126,208.41,110.25]
[null,"2022-12-06",168,122.38,208.41,105]
[null,"2022-12-07",153.47999999999999,110.25,208.41,97]
[null,"2022-12-08",150.81,108,208.41,92.77]
[null,"2022-12-09",147.38999999999999,102.86,208.41,90]
[null,"2022-12-12",128.75,89,208.41,80]
[null,"2022-12-13",125,88.71,208.41,77.14]
[null,"2022-12-14",128.06,90.62,208.41,80.5]
[null,"2022-12-15",134,99,171.15,90]
[null,"2022-12-16",132,99,150,88]
[null,"2022-12-19",120.47,90.85,140,81]
[null,"2022-12-20",117.5,87.51,140,78.94]
[null,"2022-12-21",112,85,140,72]
[null,"2022-12-22",111.84,85,133.9,74]
[null,"2022-12-23",114,90.75,133.9,75]
[null,"2022-12-28",106.75,85,131.55000000000001,71]
[null,"2022-12-29",110,87,131.55000000000001,71.75]
[null,"2022-12-30",109,87.5,131.55000000000001,73.75]
[null,"2023-01-03",107.75,87,131.55000000000001,77]
[null,"2023-01-04",108.12,87.25,131.55000000000001,78]
[null,"2023-01-05",118,92.29,131.55000000000001,88]
[null,"2023-01-06",119,94.75,131.55000000000001,88]
[null,"2023-01-09",126.2,99.25,125,95]
[null,"2023-01-10",135.22999999999999,102.75,125,96]
[null,"2023-01-11",130.94,96,124.53,93]
[null,"2023-01-12",133.5,95.75,124.53,95.5]
[null,"2023-01-13",138,96.2,124.53,97]
[null,"2023-01-16",133,91.58,124.53,89.1]
[null,"2023-01-17",132.5,90.51,124.53,89]
[null,"2023-01-18",135.5,92.5,124.53,90]
[null,"2023-01-19",135,92.49,124.53,90]
[null,"2023-01-20",134.75,92.49,124.53,90]
[null,"2023-01-23",137.66999999999999,93.89,124.53,92.32]
[null,"2023-01-24",137.58000000000001,93.91,124.53,89.99]
[null,"2023-01-25",134.75,90.83,124.53,86]
[null,"2023-01-27",133.07,90.83,124.53,86.25]
[null,"2023-01-30",133.75,92.5,124.53,87.01]
[null,"2023-01-31",134.84,92.5,124.53,86.03]
[null,"2023-02-01",135,93.25,124.53,86]
[null,"2023-02-02",131,91.27,124.53,84.35]
[null,"2023-02-03",129.5,89,124.53,83]
[null,"2023-02-06",132,88.81,124.53,85.24]
[null,"2023-02-07",132.16,89.54,124.53,86.11]
[null,"2023-02-08",135.52000000000001,92.5,124.53,86.98]
[null,"2023-02-09",137.25,93.5,124.53,89]
[null,"2023-02-10",135.75,92,124.53,87.87]
[null,"2023-02-13",134.83000000000001,90.29,124.53,87]
[null,"2023-02-14",131.9,88.75,115,85.5]
[null,"2023-02-15",128,87.75,110,85.16]
[null,"2023-02-16",124.4,86.5,110,84]
[null,"2023-02-17",124.5,87.5,110,86]
[null,"2023-02-20",124.82,87.97,110,87]
[null,"2023-02-21",122,86.25,110,86.38]
[null,"2023-02-22",118,83.38,110,85.69]
[null,"2023-02-23",115.75,82.46,110,84.45]
[null,"2023-02-24",113.33,80.930000000000007,110,82.5]
[null,"2023-02-27",113.96,81.5,110,83]
[null,"2023-02-28",116.66,81.75,110,85.96]
[null,"2023-03-01",119.75,85.15,110,87.61]
[null,"2023-03-02",121.5,87.25,110,88.82]
[null,"2023-03-03",121.17,86.29,110,88.38]
[null,"2023-03-06",116.75,83,110,87]
[null,"2023-03-07",114.42,81.489999999999995,110,85.25]
[null,"2023-03-08",117.25,84.64,110,85.25]
[null,"2023-03-09",116.24,84,110,85.25]
[null,"2023-03-10",117.39,85,110,86]
[null,"2023-03-13",122,88.5,110,88.02]
[null,"2023-03-14",123.75,88.32,110,87.32]
[null,"2023-03-15",120.32,86,110,84.61]
[null,"2023-03-16",118.9,84,110,84.5]
[null,"2023-03-17",117.75,83.1,110,84.5]
[null,"2023-03-20",118.5,83.1,110,85.48]
[null,"2023-03-21",119.5,83.5,106,85.48]
[null,"2023-03-22",120,84.25,106,86.5]
[null,"2023-03-23",120.15,84.61,106,88.49]
[null,"2023-03-24",119.67,85,106,88.5]
[null,"2023-03-27",123.76,90.06,106,90]
[null,"2023-03-28",130.25,95.75,106,93]
[null,"2023-03-29",131.01,95.17,106,93.37]
[null,"2023-03-30",141.34,100.04,110,97.33]
[null,"2023-03-31",143,103.01,110,99.25]
[null,"2023-04-03",147.79,108.75,120,101]
[null,"2023-04-04",142,102.5,120,98.5]
[null,"2023-04-05",141.80000000000001,102.5,120,98.5]
[null,"2023-04-06",144.69999999999999,105.25,120,101.74]
[null,"2023-04-11",143,105.25,120,99]
[null,"2023-04-12",144.59,106.25,120,101.75]
[null,"2023-04-13",144.59,105.1,122,103]
[null,"2023-04-14",143.5,104,122,101.69]
[null,"2023-04-17",146.04,106.5,122,105.7]
[null,"2023-04-18",145.25,105.25,122,104.5]
[null,"2023-04-19",144.5,104.75,122,103.99]
[null,"2023-04-20",143,104,122,103.99]
[null,"2023-04-21",143,103.8,122,103.99]
[null,"2023-04-24",141.38,102.47,122,103.19]
[null,"2023-04-26",140.5,103.13,122,102.5]
[null,"2023-04-27",141.83000000000001,103.5,122,105]
[null,"2023-04-28",142.82,105.46,122,106]
[null,"2023-05-01",148.33000000000001,109.25,122,110]
[null,"2023-05-02",152.75,112.75,122,113]
[null,"2023-05-03",156,113,122,114]
[null,"2023-05-04",158.35,115.13,137,116.68]
[null,"2023-05-05",158.35,115,137,116.68]
[null,"2023-05-08",152,111.2,137,111.48]
[null,"2023-05-09",147.55000000000001,107.24,137,111.25]
[null,"2023-05-10",146,106.5,137,111.4]
[null,"2023-05-11",144.4,105,137,112]
[null,"2023-05-12",149.94,108.7,137,115]
[null,"2023-05-15",153.44999999999999,111.45,137,119]
[null,"2023-05-16",154,113.28,137,119.94]
[null,"2023-05-17",155.15,114.5,137,119.94]
[null,"2023-05-18",155.25,114.75,142.28,119.75]
[null,"2023-05-19",157.02000000000001,115.27,143.66,120.5]
[null,"2023-05-22",159.09,118.25,146.5,124]
[null,"2023-05-23",159,119.13,146.5,123.25]
[null,"2023-05-24",157.26,118,146.5,121]
[null,"2023-05-25",158.66999999999999,120.35,146.5,122.5]
[null,"2023-05-26",157,119.5,146.5,120]
[null,"2023-05-29",153,117.25,146.5,115]
[null,"2023-05-30",153.25,122,146.5,113.65]
[null,"2023-05-31",154,123.5,146.5,113.25]
[null,"2023-06-01",155.25,124.24,146.5,113.5]
[null,"2023-06-02",155,124.94,146.5,113.5]
[null,"2023-06-05",151,123.52,148,112.75]
[null,"2023-06-06",149.75,122.08,147,111]
[null,"2023-06-07",150,123.5,147,112.4]
[null,"2023-06-08",150.27000000000001,123.69,147,111.75]
[null,"2023-06-09",150.09,123.28,147,111.25]
[null,"2023-06-13",147.78,120.5,142.5,108.52]
[null,"2023-06-14",148,120,140,105.1]
[null,"2023-06-15",151.91,121.5,140,107.5]
[null,"2023-06-16",154.16,122.84,137.5,108.95]
[null,"2023-06-19",153.44,122.61,137.5,107]
[null,"2023-06-20",150.5,120.6,137.5,102.05]
[null,"2023-06-21",149,119.75,133,100.75]
[null,"2023-06-22",149,120.25,130,101.11]
[null,"2023-06-23",150.13,121.1,130,101.97]
[null,"2023-06-26",149.6,120.25,130,100.78]
[null,"2023-06-27",150.25,120.92,130,102.34]
[null,"2023-06-28",150.9,121,130,102.6]
[null,"2023-06-29",150.5,121.25,130,102]
[null,"2023-06-30",149.05000000000001,121.25,130,100.01]
[null,"2023-07-03",147.38,119.48,130,97.47]
[null,"2023-07-04",144.13999999999999,116.25,130,93.1]
[null,"2023-07-05",146.47999999999999,118,129.5,93.81]
[null,"2023-07-06",145.5,117,129.5,93.29]
[null,"2023-07-07",143,114.23,129.5,88]
[null,"2023-07-10",134,109.5,122,84]
[null,"2023-07-11",130,108.25,122,83.54]
[null,"2023-07-12",128,107.75,122,82.75]
[null,"2023-07-13",124,104.25,122,82.65]
[null,"2023-07-14",123,103.75,122,82]
[null,"2023-07-17",127.25,106.25,122,84]
[null,"2023-07-18",132.27000000000001,112.5,122,87]
[null,"2023-07-19",134,112.5,122,88.04]
[null,"2023-07-20",136.75,115.25,122,90.5]
[null,"2023-07-21",136,115,122,90]
[null,"2023-07-24",136.75,115,122,91]
[null,"2023-07-25",137.25,115,123.25,91]
[null,"2023-07-26",133.5,110.5,123.25,89.5]
[null,"2023-07-27",135,110,123.25,90]
[null,"2023-07-28",136.54,111,123.25,90]
[null,"2023-07-31",134.25,108.27,123.5,89.86]
[null,"2023-08-01",133.5,107.5,123.5,89.86]
[null,"2023-08-02",136.27000000000001,108.97,123.5,90.95]
[null,"2023-08-03",135.75,107.87,122,90.25]
[null,"2023-08-04",136,108.4,122,90.25]
[null,"2023-08-07",136,109,122.25,90.51]
[null,"2023-08-08",135.25,107,122,90.75]
[null,"2023-08-09",135,106.5,121,90.57]
[null,"2023-08-10",136.81,108,121,91.69]
[null,"2023-08-11",138.88999999999999,109.82,121,93.25]
[null,"2023-08-14",138.68,109.36,122,93.94]
[null,"2023-08-15",139.82,110.75,122,94.42]
[null,"2023-08-16",140,111.5,122,94.85]
[null,"2023-08-17",142.16999999999999,111.5,123,95.75]
[null,"2023-08-18",143.5,113.33,123,96]
[null,"2023-08-21",142.80000000000001,113.33,123,95.75]
[null,"2023-08-22",141.77000000000001,112.56,123,95.57]
[null,"2023-08-23",141.85,112.25,123,95.57]
[null,"2023-08-24",141.5,112,123,95.58]
[null,"2023-08-25",141.21,111,123,95.58]
[null,"2023-08-28",138.82,108.25,123,94.01]
[null,"2023-08-29",135.5,107,123,93]
[null,"2023-08-30",137.25,107.75,123,93.49]
[null,"2023-08-31",136.91999999999999,107.3,123,93.1]
[null,"2023-09-01",135,105.99,123,92.4]
[null,"2023-09-04",133,103.9,124.13,89.75]
[null,"2023-09-05",133.5,104,124.53,89.5]
[null,"2023-09-06",135,105.5,124.53,90.5]
[null,"2023-09-07",137,108,124.53,91.25]
[null,"2023-09-08",136.44999999999999,108,125,91]
[null,"2023-09-11",134.94999999999999,107.61,126,91]
[null,"2023-09-12",136.15,109,126,92.15]
[null,"2023-09-13",138.41999999999999,110.82,126,93.25]
[null,"2023-09-14",138.5,110,126,92.75]
[null,"2023-09-15",137.5,108.5,126,91.75]
[null,"2023-09-18",137.22999999999999,108.52,126,90.25]
[null,"2023-09-19",137.22999999999999,108.52,128,91.17]
[null,"2023-09-20",137.65,110,129,92.32]
[null,"2023-09-21",137.5,110,129.25,92.32]
[null,"2023-09-22",137.25,108.74,130,92.32]
[null,"2023-09-25",136.5,108,130.25,92.32]
[null,"2023-09-26",136,106.81,130.5,92.15]
[null,"2023-09-27",134.5,106,130.5,91.85]
[null,"2023-09-28",133.25,104.15,130.5,91]
[null,"2023-09-29",132.83000000000001,104.25,130.5,90.54]

{"sheet":"7. Environmental","index":8,"n_rows":111,"n_cols":10,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
[null,"Cost Stack"]
[null,"Environmental cost component"]
[null,{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
[]
[null,"Supplementary Table C7.1a",null,null,null,null,null,null,null,"Figure C7.1: Average environmental cost per residential customer by NEM regions, 2013–14 to 2022–23, real $2022–23, excluding GST"]
[null,"Residential Customers - Aggregate environmental costs real $2022–23, excluding GST"]
[null,"$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"2013–14",97,141,213,130,157,134]
[null,"2014–15",99,129,223,131,166,131]
[null,"2015–16",106,131,203,168,201,138]
[null,"2016–17",109,129,200,178,187,140]
[null,"2017–18",132,156,201,103,202,145]
[null,"2018–19",136,165,205,116,194,153]
[null,"2019–20",148,170,218,118,208,160]
[null,"2020–21",151,165,194,182,205,168]
[null,"2021–22",165,146,178,167,202,160]
[null,"2022-23",149,140,156,137,166,145]
[]
[null,"Supplementary Table C7.1b"]
[null,"Residential Customers - Residential Customers - LRET costs real $2022–23, excluding GST"]
[null,"$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"2017–18",69,80,67,74,116,76]
[null,"2018–19",58,73,59,67,94,67]
[null,"2019–20",51,61,52,59,116,59]
[null,"2020–21",43,51,42,45,99,48]
[null,"2021–22",36,43,35,41,100,42]
[null,"2022-23",46,54,40,49,81,50]
[]
[null,"Supplementary Table C7.1c"]
[null,"Residential Customers - Residential Customers - SRES costs real $2022–23, excluding GST"]
[null,"$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"2017–18",27,32,28,29,46,30]
[null,"2018–19",42,52,45,49,73,48]
[null,"2019–20",50,61,53,59,92,58]
[null,"2020–21",53,68,55,66,106,63]
[null,"2021–22",54,67,56,67,102,63]
[null,"2022-23",42,51,39,49,84,48]
[null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data. "]
[null,"Supplementary Table C7.1d",null,null,null,null,null,null,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,"Residential Customers - State scheme costs real $2022–23, excluding GST"]
[null,"$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"2017–18",16,12,35,0,0,13]
[null,"2018–19",17,13,19,0,0,12]
[null,"2019–20",31,14,20,0,0,17]
[null,"2020–21",38,15,15,0,0,19]
[null,"2021–22",59,18,18,0,0,27]
[null,"2022-23",47,19,16,0,0,23]
[]
[null,"Supplementary Table C7.1e"]
[null,"Residential Customers - FiT costs real $2022–23, excluding GST"]
[null,"$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"2017–18",19,32,71,0,40,27]
[null,"2018–19",19,26,82,0,27,25]
[null,"2019–20",16,33,93,0,0,27]
[null,"2020–21",17,31,82,72,0,37]
[null,"2021–22",16,18,69,58,0,28]
[null,"2022-23",14,16,62,39,0,23]
[]
[null,"Supplementary Table C7.2a",null,null,null,null,null,null,null,"Figure C7.2: Average effective price for environmental costs per residential customer by NEM regions, 2013–14 to 2022–23, real $2022–23, excluding GST"]
[null,"Residential Customers - Aggregate environmental costs real $2022–23, excluding GST"]
[null,"c/kWh","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"2013–14",2,2.4,4.3,2.2000000000000002,2,2.4]
[null,"2014–15",2.1,2.2000000000000002,4.5,2.2000000000000002,2.2000000000000002,2.4]
[null,"2015–16",2.2000000000000002,2.2000000000000002,4.0999999999999996,2.9,2.7,2.5]
[null,"2016–17",2.2999999999999998,2.2000000000000002,4.3,3.1,2.5,2.6]
[null,"2017–18",2.8,2.7,4.4000000000000004,1.8,2.6,2.7]
[null,"2018–19",3,2.9,4.5,2.1,2.6,2.9]
[null,"2019–20",3.2,3,4.7,2.1,2.7,3]
[null,"2020–21",3.3,2.9,4.3,3.2,2.4,3.2]
[null,"2021–22",3.6,2.6,3.9,3.1,2.5,3]
[null,"2022-23",3.2,2.5,3.6,2.6,1.8,2.8]
[]
[null,"Supplementary Table C7.2b"]
[null,"Residential Customers - LRET costs real $2022–23, excluding GST"]
[null,"c/kWh","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"2017–18",1.5,1.4,1.5,1.3,1.5,1.4]
[null,"2018–19",1.3,1.3,1.3,1.2,1.2,1.3]
[null,"2019–20",1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.5,1.1000000000000001]
[null,"2020–21",0.9,0.9,0.9,0.8,1.2,0.9]
[null,"2021–22",0.8,0.8,0.8,0.7,1.3,0.8]
[null,"2022-23",1,1,0.9,0.9,0.9,1]
[]
[null,"Supplementary Table C7.2c"]
[null,"Residential Customers - SRES costs real $2022–23, excluding GST"]
[null,"$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"2017–18",0.6,0.6,0.6,0.5,0.6,0.6]
[null,"2018–19",0.9,0.9,1,0.9,1,0.9]
[null,"2019–20",1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.2,1.1000000000000001]
[null,"2020–21",1.2,1.2,1.2,1.2,1.3,1.2,null,"Source: ACCC analysis based on retailers’ data. "]
[null,"2021–22",1.2,1.2,1.2,1.2,1.3,1.2,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,"2022-23",0.9,0.9,0.9,0.9,0.9,0.9,null,"         Breakdown in environmental costs only available from 2016–17 onwards"]
[null,null,null,null,null,null,null,null,null,"         LRET = Large-scale Renewable Energy Target, SRES = Small-scale Renewable Energy Scheme, FiT = Feed in Tariffs"]
[null,"Supplementary Table C7.2d"]
[null,"Residential Customers - State scheme costs real $2022–23, excluding GST"]
[null,"c/kWh","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"2017–18",0.4,0.2,0.8,0,0,0.2]
[null,"2018–19",0.4,0.2,0.4,0,0,0.2]
[null,"2019–20",0.7,0.2,0.4,0,0,0.3]
[null,"2020–21",0.8,0.3,0.3,0,0,0.4]
[null,"2021–22",1.3,0.3,0.4,0,0,0.5]
[null,"2022-23",1,0.3,0.4,0,0,0.4]
[]
[null,"Supplementary Table C7.2e"]
[null,"Residential Customers - FiT costs real $2022–23, excluding GST"]
[null,"c/kWh","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"2017–18",0.4,0.6,1.5,0,0.5,0.5]
[null,"2018–19",0.4,0.5,1.8,0,0.4,0.5]
[null,"2019–20",0.3,0.6,2,0,0,0.5]
[null,"2020–21",0.4,0.6,1.8,1.3,0,0.7]
[null,"2021–22",0.3,0.3,1.5,1.1000000000000001,0,0.5]
[null,"2022-23",0.3,0.3,1.4,0.7,0,0.4]

{"sheet":"8. Retail costs and margins","index":9,"n_rows":498,"n_cols":13,"rows_kept":498,"cut":false,"hidden":false,"merged":[]}
[null,"Cost Stack"]
[null,"8. Retail costs and margins"]
[null,{"$f":"HYPERLINK(\"#'Contents'!A1\", \"Contents\")","v":"Contents"}]
[]
[null,"Supplementary Table C8.1a",null,null,null,null,null,null,null,null,null,null,"Figure C8.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 2022–23, real $2022–23, excluding GST"]
[null,"Residential Customers - Aggregate retail component  real $2022–23, excluding GST"]
[null,"$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"2013–14",387,290,246,343,266,323]
[null,"2014–15",394,305,192,355,307,330]
[null,"2015–16",402,335,248,262,286,334]
[null,"2016–17",417,398,266,245,257,361]
[null,"2017–18",336,344,210,247,185,307]
[null,"2018–19",311,278,203,202,306,269]
[null,"2019–20",241,245,167,187,202,226]
[null,"2020–21",243,223,136,146,315,211]
[null,"2021–22",220,187,172,126,228,186]
[null,"2022–23",232,131,214,204,240,184]
[]
[]
[null,"Supplementary Table C8.1b"]
[null,"Residential Customers - Retail and other costs real $2022–23, excluding GST"]
[null,"$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"2013–14",236,231,187,179,0,218]
[null,"2014–15",227,190,192,191,0,200]
[null,"2015–16",228,189,190,179,0,198]
[null,"2016–17",223,194,181,192,0,199]
[null,"2017–18",219,189,180,206,0,199]
[null,"2018–19",211,185,180,185,0,192]
[null,"2019–20",189,169,165,177,0,176]
[null,"2020–21",170,149,150,148,0,156,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[null,"2021–22",165,144,141,136,0,150,null,null,null,null,"Note: Negative retail margins for SA in 2020–21, SEQ in 2021–22 and NSW in 2022-23 are shown below 0. "]
[null,"2022–23",163,142,146,142,0,150]
[]
[]
[null,"Supplementary Table C8.1c"]
[null,"Residential Customers - Retail margin (EBITDA) real $2022–23, excluding GST"]
[null,"$/customer","Victoria","NSW","SA","SEQ","Tasmania","NEM"]
[null,"2013–14",152,59,59,164,266,105]
[null,"2014–15",168,115,0,164,307,130]
[null,"2015–16",174,146,58,83,286,136]
[null,"2016–17",195,204,85,53,257,162]
[null,"2017–18",118,155,31,41,185,109]
[null,"2018–19",100,93,23,17,306,77]
[null,"2019–20",52,76,2,10,202,49]
[null,"2020–21",73,74,-14,-2,315,55]
[null,"2021–22",55,43,31,-10,228,37]
[null,"2022–23",69,-12,68,62,240,34]
[]
[]
[null,"Supplementary Table C8.2",null,null,null,null,null,null,null,null,null,null,"Figure C8.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 2022–23"]
[null,"EBITDA as percentage of avaerage residential customers bill"]
[null,"% of revenue","Victoria","NSW","SA","SEQ","NEM"]
[null,"2013–14",0.08,0.03,0.03,0.08,0.05]
[null,"2014–15",0.1,0.06,0,0.08,7.0000000000000007E-2]
[null,"2015–16",0.11,0.08,0.03,0.04,0.08]
[null,"2016–17",0.12,0.11,0.05,0.03,0.09]
[null,"2017–18",7.0000000000000007E-2,0.08,0.02,0.02,0.06]
[null,"2018–19",0.06,0.05,0.01,0.01,0.04]
[null,"2019–20",0.03,0.04,0,0.01,0.03]
[null,"2020–21",0.05,0.04,-0.01,0,0.03]
[null,"2021–22",0.04,0.03,0.02,-7.6430226102207422E-3,0.02]
[null,"2022–23",0.05,-0.01,0.04,0.04,0.02]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,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,null,null,"Note: Negative retail margins for SA in 2020-21 and SEQ in 2020-21 and 2021-22 are shown below 0. "]
[]
[null,"Supplementary Table C8.3",null,null,null,null,null,null,null,null,null,null,"Figure C8.3 (Figure 2.15 in report): Average retail and other costs over time per residential customer across the NEM, 2007–08 to 2022–23, real $2022–23, excluding GST"]
[null,"Residential Customers - Retail and other costs real $2022–23, excluding GST"]
[null,"$/customer","NEM"]
[null,"2007–08",130]
[null,"2008–09",0]
[null,"2009–10",0]
[null,"2010–11",171]
[null,"2011–12",0]
[null,"2012–13",0]
[null,"2013–14",218]
[null,"2014–15",200]
[null,"2015–16",198]
[null,"2016–17",195]
[null,"2017–18",199]
[null,"2018–19",192]
[null,"2019–20",176]
[null,"2020–21",156]
[null,"2021–22",150]
[null,"2022–23",150]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
[null,"Supplementary Table C8.4",null,null,null,null,null,null,null,null,null,null,"Figure C8.4 (Figure 2.12 in report): Average retail margins (as earnings before interest, tax, depreciation and amortisation or EBITDA) per residential customer across the NEM, 2007–08 to 2022–23, real $2022–23, excluding GST"]
[null,"Residential Customers - Retail margin (EBITDA) real $2022–23, excluding GST"]
[null,"$/customer","NEM"]
[null,"2007–08",80]
[null,"2008–09",0]
[null,"2009–10",0]
[null,"2010–11",152]
[null,"2011–12",0]
[null,"2012–13",0]
[null,"2013–14",105]
[null,"2014–15",130]
[null,"2015–16",136]
[null,"2016–17",154]
[null,"2017–18",109]
[null,"2018–19",77]
[null,"2019–20",49]
[null,"2020–21",55]
[null,"2021–22",37]
[null,"2022–23",34]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
[null,"Supplementary Table C8.5",null,null,null,null,null,null,null,null,null,null,"Figure C8.5: Average Cost to Serve over time per residential customer across the NEM, 2007–08 to 2022–23, real $2022–23, excluding GST"]
[null,"Residential Customers - Cost to Serve real $2022–23, excluding GST"]
[null,"$/customer","NEM"]
[null,"2007–08",91]
[null,"2008–09",0]
[null,"2009–10",0]
[null,"2010–11",129]
[null,"2011–12",0]
[null,"2012–13",0]
[null,"2013–14",139]
[null,"2014–15",120]
[null,"2015–16",109]
[null,"2016–17",108]
[null,"2017–18",92]
[null,"2018–19",94]
[null,"2019–20",90]
[null,"2020–21",82]
[null,"2021–22",79]
[null,"2022–23",83]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
[null,"Supplementary Table C8.6a",null,null,null,null,null,null,null,null,null,null,"Figure C8.6: Average Cost to Serve per residential customer across the NEM by retailer tier, 2019-20 to 2022–23, real $2022-23, excluding GST "]
[null,"Residential Customers - Cost to Serve real $2022–23, excluding GST"]
[null,"$/customer","Big 3","Non-Big.3"]
[null,"2019–20",75,127]
[null,"2020–21",65,123]
[null,"2021–22",64,116]
[null,"2022–23",67,122]
[]
[]
[null,"Supplementary Table C8.6b"]
[null,"Residential Customers average cost to serve by retailer tier"]
[null,null,"Big 3",null,null,null,"Non-Big 3"]
[null,"% of CTS","2019–20","2020–21","2021–22","2022-23 ","2019–20","2020–21","2021–22","2022-23 "]
[null,"Billing",0.09,0.1,0.09,0.09,0.12,0.12,0.12,0.1]
[null,"CTS Labour",0.42,0.43,0.43,0.45,0.44,0.46,0.51,0.49]
[null,"Customer service and IT",0.23,0.24,0.24,0.22,0.2,0.21,0.2,0.21]
[null,"Debt collection",0.1,0.08,0.08,0.08,0.05,0.01,0.02,0.01]
[null,"Hardship",0.03,0.02,0.01,0.01,0.01,0.01,0.01,0.01]
[null,"Other Cost(s) to Serve",0.13,0.14000000000000001,0.15,0.15,0.18,0.17,0.15,0.17]
[]
[null,null,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,null,null,"Note: Data labels for small cost components have been omitted for readability. CTS = Cost to serve."]
[]
[]
[null,"Supplementary Table C8.7",null,null,null,null,null,null,null,null,null,null,"Figure C8.7: Average Cost to Acquire and Retain over time per residential customer across the NEM, 2007–08 to 2022–23, real $2022–23, excluding GST "]
[null,"Residential Customers - Cost to Acquire and Retain real $2022–23, excluding GST"]
[null,"$/customer","NEM"]
[null,"2007–08",40]
[null,"2008–09",0]
[null,"2009–10",0]
[null,"2010–11",42]
[null,"2011–12",0]
[null,"2012–13",0]
[null,"2013–14",45]
[null,"2014–15",53]
[null,"2015–16",56]
[null,"2016–17",58]
[null,"2017–18",74]
[null,"2018–19",65]
[null,"2019–20",57]
[null,"2020–21",50]
[null,"2021–22",48]
[null,"2022–23",47]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
[null,"Supplementary Table C8.8a",null,null,null,null,null,null,null,null,null,null,"Figure C8.8: Average Cost to Acquire and Retain per residential customer across the NEM by retailer tier, 2019–20 to 2022–23, real $2022–23, excluding GST"]
[null,"Residential Customers - Cost to Acquire and Retain Big 3 vs Non-Big 3 real $2022–23, excluding GST"]
[null,"$/customer","Big 3","Non-Big 3"]
[null,"2019–20",49,77]
[null,"2020–21",43,69]
[null,"2021–22",39,68]
[null,"2022–23",38,67]
[]
[]
[null,"Supplementary Table C8.8b"]
[null,"Residential Customers - Percentage of Cost to Acquire and Retain by retailer tier, Big 3 vs Non-Big 3 "]
[null,null,"Big 3",null,null,null,"Non-Big 3"]
[null,"% of CARC","2019–20","2020–21","2021–22","2022-23 ","2019–20","2020–21","2021–22","2022-23 "]
[null,"Advertising and marketing",0.2,0.17,0.19,0.18,0.25,0.32,0.26,0.28000000000000003]
[null,"CARC Labour",0.4,0.39,0.39,0.4,0.28000000000000003,0.25,0.24,0.24]
[null,"Churn Prevention",0.02,0.02,0.01,0.01,0.01,0.02,0.02,0.01]
[null,"Customer loyalty programs",0.04,0.05,0.03,0.03,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,0.08]
[null,"Other Cost(s) to Acquire and Retain",0.16,0.13,0.15,0.14000000000000001,0.14000000000000001,0.19,0.21,0.2]
[null,"Third Party Sales",0.18,0.24,0.23,0.24,0.24,0.15,0.21,0.19]
[]
[]
[]
[]
[]
[]
[null,null,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,null,null,"Note: Data labels for small cost components have been omitted for readability. CARC = costs to acquire and retain."]
[]
[]
[null,"Supplementary Table C8.9",null,null,null,null,null,null,null,null,null,null,"Figure C8.9: 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 2022–23, real $2022–23, excluding GST"]
[null,"Small Business Customers - Average Retail margin (EBITDA) real $2022–23, excluding GST"]
[null,"c/kWh","NEM"]
[null,"2007–08",2.2000000000000002]
[null,"2008–09",0]
[null,"2009–10",0]
[null,"2010–11",3.9]
[null,"2011–12",0]
[null,"2012–13",0]
[null,"2013–14",2.7]
[null,"2014–15",2.8]
[null,"2015–16",2.4]
[null,"2016–17",2.5]
[null,"2017–18",2.4]
[null,"2018–19",2.6]
[null,"2019–20",1.5]
[null,"2020–21",1.5]
[null,"2021–22",0.8]
[null,"2022–23",1]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
[null,"Supplementary Table C8.10",null,null,null,null,null,null,null,null,null,null,"Figure C8.10: Average retail and other costs over time per electricity usage for small business across the NEM, 2007–08 to 2022–23, real $2022–23, excluding GST"]
[null,"Small Business Customers - Average Retail and Other Costs real $2022–23, excluding GST"]
[null,"c/kWh","NEM"]
[null,"2007–08",0.7]
[null,"2008–09",0]
[null,"2009–10",0]
[null,"2010–11",1]
[null,"2011–12",0]
[null,"2012–13",0]
[null,"2013–14",2]
[null,"2014–15",1.9]
[null,"2015–16",1.8]
[null,"2016–17",1.6]
[null,"2017–18",1.8]
[null,"2018–19",2]
[null,"2019–20",1.7]
[null,"2020–21",1.5]
[null,"2021–22",1.4]
[null,"2022–23",1.4]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
[null,"Supplementary Table C8.11a",null,null,null,null,null,null,null,null,null,null,"Figure C8.11: Average Cost to Serve per electricity usage for small business across the NEM by retailer tier and percentage of total, 2019–20 to 2022–23, real $2022-23, excluding GST "]
[null,"Small Business Customers - Average Cost to Serve real $2022-23, excluding GST "]
[null,"c/kWh","Big 3","Non-Big 3"]
[null,"2019–20",0.7,1.2]
[null,"2020–21",0.6,1.2]
[null,"2021–22",0.6,1.2]
[null,"2022-23",0.6,1]
[]
[]
[null,"Supplementary Table C8.11b"]
[null,"Small Business Customers - Average Cost to Serve percentage by retail tier"]
[null,null,"Big 3",null,null,null,"Non-Big 3"]
[null,"% of CTS","2019–20","2020–21","2021–22","2022-23","2019–20","2020–21","2021–22","2022-23"]
[null,"Billing",0.09,0.09,0.08,0.08,0.09,0.09,0.08,7.0000000000000007E-2]
[null,"CTS Labour",0.44,0.46,0.46,0.47,0.48,0.51,0.54,0.59]
[null,"Customer service and IT",0.21,0.22,0.21,0.2,0.23,0.22,0.21,0.2]
[null,"Debt collection",0.09,7.0000000000000007E-2,7.0000000000000007E-2,0.08,7.0000000000000007E-2,0.02,0.03,0.02]
[null,"Hardship",0.01,0,0,0,0.01,0.01,0.01,0.01]
[null,"Other Cost(s) to Serve",0.16,0.16,0.18,0.17,0.11,0.15,0.14000000000000001,0.11]
[]
[null,null,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,null,null,"Note: Data labels for small cost components have been omitted for readability. "]
[]
[null,"Supplementary Table C8.12a",null,null,null,null,null,null,null,null,null,null,"Figure C8.12: Average Cost to Acquire and Retain per electricity usage for small business across the NEM by retailer tier and percentage of residential total, 2019–20 to 2022–23, real $2022–23, excluding GST"]
[null,"Small Business Customers - Cost to Acquire and Retain real $2022-23, excluding GST "]
[null,"c/kWh","Big 3","Non-Big 3"]
[null,"2019–20",0.43,0.37]
[null,"2020–21",0.37,0.36]
[null,"2021–22",0.4,0.36]
[null,"2022-23",0.34,0.32]
[]
[]
[null,"Supplementary Table C8.12b"]
[null,"Small Business Customers Average Cost to Acquire and Retain percentage by retail tier"]
[null,null,"Big 3",null,null,null,"Non-Big 3"]
[null,"% of CARC","2019–20","2020–21","2021–22","2022-23","2019–20","2020–21","2021–22","2022-23"]
[null,"Advertising and marketing",0.19,0.14000000000000001,0.13,0.12,0.24,0.31,0.28000000000000003,0.23]
[null,"CARC Labour",0.48,0.52,0.51,0.52,0.24,0.23,0.3,0.27]
[null,"Churn Prevention",0.02,0.01,0.01,0,0,0.03,0.01,0.01]
[null,"Customer loyalty programs",0.02,0.02,0,0,0.03,0.02,0.01,0.04]
[null,"Other Cost(s) to Acquire and Retain",0.16,0.15,0.17,0.17,0.1,0.19,0.18,0.2]
[null,"Third Party Sales",0.13,0.15,0.18,0.18,0.39,0.22,0.22,0.25]
[]
[null,null,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,null,null,"Note: Data labels for small cost components have been omitted for readability. "]
[]
[]
[null,"Supplementary Table C8.13",null,null,null,null,null,null,null,null,null,null,"Figure C8.13: Small business retail operating costs expressed as real $/customer"]
[null,"Small Business Retail operating costs, real $/customer"]
[null,"Year","Small Business Customers "]
[null,"2007-08",161]
[null,"2008-09",0]
[null,"2009-10",0]
[null,"2010-11",182]
[null,"2011-12",0]
[null,"2012-13",0]
[null,"2013-14",311]
[null,"2014-15",287]
[null,"2015-16",279]
[null,"2016-17",269]
[null,"2017-18",296]
[null,"2018-19",320]
[null,"2019-20",252]
[null,"2020-21",221]
[null,"2021-22",188]
[null,"2022-23",183]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
[]
[]
[null,"Supplementary Table C8.14",null,null,null,null,null,null,null,null,null,null,"Figure C8.14: NSW bad debt costs ($/customer), residential and SME customers, real"]
[null,"NSW bad debt costs ($/customer), residential and SME customers, real"]
[null,"Year","Residential","SME"]
[null,"2017-18",34,100]
[null,"2018-19",34,86]
[null,"2019-20",39,126]
[null,"2020-21",29,62]
[null,"2021-22",19,40]
[null,"2022-23",30,65]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,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,null,null,"Figure C8.15: Victoria bad debt costs ($/customer), residential and SME customers, real"]
[]
[null,"Supplementary Table C8.15"]
[null,"Victoria bad debt costs ($/customer), residential and SME customers, real"]
[null,"Year","Residential","SME"]
[null,"2017-18",35,75]
[null,"2018-19",34,78]
[null,"2019-20",41,115]
[null,"2020-21",32,60]
[null,"2021-22",23,35]
[null,"2022-23",29,47]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,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,null,null,"Figure C8.16: SA bad debt costs ($/customer), residential and SME customers, real"]
[null,"Supplementary Table C8.16"]
[null,"SA bad debt costs ($/customer), residential and SME customers, real"]
[null,"Year","Residential","SME"]
[null,"2017-18",62,120]
[null,"2018-19",63,160]
[null,"2019-20",69,148]
[null,"2020-21",40,64]
[null,"2021-22",29,32]
[null,"2022-23",40,52]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,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,null,null,"Figure C8.17: South East Queensland bad debt costs ($/customer), residential and SME customers, real"]
[]
[null,"Supplementary Table C8.17"]
[null,"SEQ bad debt costs ($/customer), residential and SME customers, real"]
[null,"Year","Residential","SME"]
[null,"2017-18",31,71]
[null,"2018-19",33,75]
[null,"2019-20",33,84]
[null,"2020-21",28,44]
[null,"2021-22",19,29]
[null,"2022-23",24,42]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
[]
[]
[null,"Supplementary Table C8.18",null,null,null,null,null,null,null,null,null,null,"Figure C8.18 Average Retail and Other Costs per customer for small business across the NEM by retailer tier 2017–18 to 2022–23, real $2022–23, excluding GST"]
[null,"Small Business customer - Average Retail and Other Costs  real $2022–23, excluding GST"]
[null,"Year","Big 3","Non-Big 3"]
[null,"2017-18",281.02256373319096,339.88973457574838]
[null,"2018-19",297.23266702579269,394.09726714827059]
[null,"2019-20",241.6873211795926,282.04329615709133]
[null,"2020-21",197.70356635833048,285.38552015161537]
[null,"2021-22",162.02584179666243,268.24176522705301]
[null,"2022-23",157.75089470155874,244.38945992358452]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]
[]
[]
[]
[null,"Supplementary table C8.19",null,null,null,null,null,null,null,null,null,null,"Figure C8.19 (Figure 2.9 in report): Retailer cost stacks increased in 2022-23, by customer type, 2021-23 to 2022-23, nominal terms, excluding GST"]
[null,"Percentage change, 2021-22 to 2022-23, nominal terms, excluding GST"]
[null,null,"Residential","Small Business"]
[null,"Network",0.45,0.42]
[null,"Environmental",0.1,0.12]
[null,"Retail and other costs",0.1,0.05]
[null,"Retail margins",0.02,0.04]
[null,"Wholesale costs",0.33,0.37]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data."]

{"sheet":"Retail Pricing >>","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"9. Residential (unconditional)","index":11,"n_rows":449,"n_cols":12,"rows_kept":449,"cut":false,"hidden":false,"merged":[[60,1,61,1],[60,2,60,3],[60,4,60,5],[6,11,6,18]]}
[null,"Retail pricing"]
[null,"9. Residential (unconditional) "]
[null,"Contents"]
[]
[]
[null,"Supplementary Table C9.1",null,null,null,null,null,null,null,null,null,"Figure C9.1 (Figure 3.1 in report): Customer-weighted average unconditional annual price, residential customers by tariff type and year, all regions, nominal, GST inclusive"]
[null,"Customer-weighted average unconditional annual price"]
[null,"Flat rate",2022,2023]
[null,"VIC",1405.07,1720.34]
[null,"NSW",1559.39,2088.4]
[null,"SA",1768.23,2206.54]
[null,"SEQ",1492.98,1957.31]
[]
[null,"Flat rate + controlled load",2022,2023]
[null,"VIC",2070.29,2304.2800000000002]
[null,"NSW",2103.7600000000002,2853.42]
[null,"SA",2414.0300000000002,3068.18]
[null,"SEQ",1823.78,2397.79]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data. "]
[null,null,null,null,null,null,null,null,null,null,null,"Notes: 2022 prices as at 1 August 2022 and 2023 prices as at 1 August 2023.  Solar feed-in tariffs, conditional discounts and GreenPower charges are excluded. "]
[]
[null,"Supplementary Table C9.2 ",null,null,null,null,null,null,null,null,null,"Figure C9.2 (Figure 3.2 in report): Proportion of residential customers on flat rate plans paying more, equal to, or less than the DMO/VDO, assuming conditional discounts are not achieved"]
[null,"All regions"]
[null,null,"2022 Customers","2023 Customers"]
[null,">25% below",7.0000000000000007E-2,0.03]
[null,"20-25% below",0.11,0.03]
[null,"15-20% below",0.1,0.03]
[null,"10-15% below",0.12,0.06]
[null,"5-10% below",0.12,0.15]
[null,"1-5% below",0.09,0.15]
[null,"Equal to DMO/VDO",0.16,0.23]
[null,"1-5% above",0.04,0.1]
[null,"5-10% above",0.03,0.06]
[null,"10-15% above",0.02,0.03]
[null,"15-20% above",0.03,0.02]
[null,"20-25% above",0.03,0.03]
[null,">25% above",0.06,0.06]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data. "]
[]
[]
[]
[]
[null,"Table C9.3 (Table 3.1 in report)"]
[null,"Year-on-year change in Default Market Offer and Victorian Default Offer prices (1 July 2022 to 1 July 2023) and customer-weighted average unconditional prices (1 August 2022 to 1 August 2023), residential customers, nominal"]
[]
[null,"Distribution Region","Flat rate",null,"Flat rate with controlled load"]
[null,null,"DMO/VDO","Average Price Change","DMO/VDO","Average Price Change"]
[null,"New South Wales"]
[null,"Ausgrid",0.20799999999999999,0.35699999999999998,0.20699999999999999,0.39600000000000002]
[null,"Endeavour Energy",0.214,0.33400000000000002,0.249,0.38]
[null,"Essential Energy",0.20799999999999999,0.3,0.19600000000000001,0.30099999999999999]
[null,"Victoria"]
[null,"Ausnet Services",0.24099999999999999,0.23499999999999999,0.28399999999999997,0.14199999999999999]
[null,"CitiPower",0.215,0.19500000000000001,0.26100000000000001,6.6000000000000003E-2]
[null,"Jemena",0.27200000000000002,0.23400000000000001,0.31900000000000001,5.5E-2]
[null,"Powercor",0.27,0.23400000000000001,0.32200000000000001,0.15]
[null,"United Energy",0.25900000000000001,0.219,0.309,5.5E-2]
[null,"South East Queensland"]
[null,"Energex",0.215,0.311,0.20499999999999999,0.315]
[null,"South Australia"]
[null,"SA Power Networks",0.23899999999999999,0.248,0.22500000000000001,0.27100000000000002]
[]
[null,"Source:\t ACCC analysis of retailers’ data, Victorian Default Offer prices, and Default Market Offer prices. "]
[]
[]
[]
[]
[]
[]
[null,"Supplementary Table C9.4 ",null,null,null,null,null,null,null,null,null,"Figure C9.4 (Figure 3.4 in report): Proportion of residential concession customers on flat rate and flat rate with controlled load market offer plans paying more, equal to, or less than the DMO/VDO, assuming conditional discounts are not achieved, all regions"]
[null,"All regions"]
[null,null,"2022 Customers","2023 Customers"]
[null,">25% below",0.08,0.03]
[null,"20-25% below",0.13,0.03]
[null,"15-20% below",0.1,0.05]
[null,"10-15% below",0.14000000000000001,0.06]
[null,"5-10% below",0.13,0.17]
[null,"1-5% below",0.09,0.17]
[null,"Equal to DMO/VDO",0.14000000000000001,0.2]
[null,"1-5% above",0.03,0.1]
[null,"5-10% above",0.03,0.06]
[null,"10-15% above",0.02,0.03]
[null,"15-20% above",0.03,0.02]
[null,"20-25% above",0.03,0.02]
[null,">25% above",0.05,0.05]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data. "]
[]
[]
[]
[]
[null,"Supplementary Table C9.5",null,null,null,null,null,null,null,null,null,"Figure C9.5 (Figure 3.5 in report): Proportion of residential customers on flat rate plans paying annual unconditional prices that are more, equal to, or less than the DMO/VDO in 2022 by state"]
[null,"State by state, 2022"]
[null,null,"VIC","NSW","SA","SEQ"]
[null,">25% below",0.01,0.15,0.01,0.06]
[null,"20-25% below",0.04,0.14000000000000001,0.1,0.17]
[null,"15-20% below",0.05,0.14000000000000001,0.05,0.11]
[null,"10-15% below",0.17,0.08,0.12,0.12]
[null,"5-10% below",0.19,0.09,0.11,0.08]
[null,"1-5% below",0.06,0.12,0.11,0.09]
[null,"Equal to DMO/VDO",0.19,0.11,0.19,0.18]
[null,"1-5% above",0.03,0.03,0.04,7.0000000000000007E-2]
[null,"5-10% above",0.04,0.02,0.03,0.05]
[null,"10-15% above",0.02,0.02,0.08,0.01]
[null,"15-20% above",0.02,0.05,0.03,0]
[null,"20-25% above",0.02,0.03,0.03,0.04]
[null,">25% above",0.16,0.01,0.08,0.01]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data."]
[]
[]
[]
[]
[null,"Supplementary Table C9.6",null,null,null,null,null,null,null,null,null,"Figure C9.6 (Figure 3.5 in report): Proportion of residential customers on flat rate plans paying annual unconditional prices that are more, equal to, or less than the DMO/VDO in 2023 by state"]
[null,"State by state, 2023"]
[null,null,"VIC","NSW","SA","SEQ"]
[null,">25% below",7.0000000000000007E-2,0.02,0.02,0.02]
[null,"20-25% below",0.08,0.01,0.02,0]
[null,"15-20% below",0.04,0.01,0.11,0.03]
[null,"10-15% below",0.09,0.06,0.02,0.03]
[null,"5-10% below",0.14000000000000001,0.17,0.1,0.12]
[null,"1-5% below",0.17,0.12,0.13,0.21]
[null,"Equal to DMO/VDO",0.22,0.21,0.17,0.33]
[null,"1-5% above",0.03,0.15,0.1,0.12]
[null,"5-10% above",0.01,0.11,0.14000000000000001,0.03]
[null,"10-15% above",0.02,0.04,0.05,0.03]
[null,"15-20% above",0.03,0.02,0.04,0.01]
[null,"20-25% above",0.01,0.06,0.02,0.01]
[null,">25% above",0.09,0.02,0.09,0.06]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data."]
[]
[]
[]
[null,"Supplementary Table C9.7",null,null,null,null,null,null,null,null,null,"Figure C9.7 (Figure 3.6 in report): Proportion of residential customers on time-of-use only tariffs paying equal to or more than the DMO by retailer (anonymised) and year, SA Power Networks distribution region"]
[null,"Retailer","Year","Equal","Above"]
[null,"A","2022-23",0,0.18]
[null,null,"2023-24",0,0]
[null,"B","2022-23",0.37,0.56999999999999995]
[null,null,"2023-24",0.14000000000000001,0.84]
[null,"C","2022-23",0,0.15]
[null,null,"2023-24",0,0.13]
[null,"D","2022-23",0.45,7.0000000000000007E-2]
[null,null,"2023-24",0.15,0.7]
[null,"E","2022-23",0.55000000000000004,0.45]
[null,null,"2023-24",0,0.45]
[null,"F","2022-23",0.4,0.02]
[null,null,"2023-24",0.41,0]
[null,"G","2022-23",0,0.21]
[null,null,"2023-24",0.05,0.95]
[null,"H","2022-23",0,0]
[null,null,"2023-24",0,0]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source: \tACCC analysis of proportions reported by retailers. "]
[null,null,null,null,null,null,null,null,null,null,null,"Notes:\t 2022-23 proportions reported as at 30 June 2023. 2023-24 proportions reported as at 10 August 2023. The ACCC did not specify a methodology to be used in calculating the proportions."]
[]
[]
[]
[null,"Supplementary Table C9.8",null,null,null,null,null,null,null,null,null,"Figure C9.8 (Figure 3.6 in report): Proportion of residential customers on time-of-use only tariffs paying equal to, or more than the DMO by retailer (anonymised) and year, Ausgrid distribution region"]
[null,"Retailer","Year","Equal","Above"]
[null,"A","2022-23",0,0.02]
[null,null,"2023-24",0,0]
[null,"B","2022-23",7.0000000000000007E-2,0.71]
[null,null,"2023-24",0,0.56999999999999995]
[null,"C","2022-23",0,0.28000000000000003]
[null,null,"2023-24",0.02,0.17]
[null,"D","2022-23",0.18,0.09]
[null,null,"2023-24",0.03,0.72]
[null,"E","2022-23",0.44,0.56000000000000005]
[null,null,"2023-24",0.03,0.96]
[null,"F","2022-23",0.33,0.01]
[null,null,"2023-24",0.33,0]
[null,"G","2022-23",0,0]
[null,null,"2023-24",0.78,0.04]
[null,"H","2022-23",0.02,0]
[null,null,"2023-24",0.28999999999999998,0]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source: \tACCC analysis of proportions reported by retailers. "]
[null,null,null,null,null,null,null,null,null,null,null,"Notes:\t 2022-23 proportions reported as at 30 June 2023. 2023-24 proportions reported as at 10 August 2023. The ACCC did not specify a methodology to be used in calculating the proportions."]
[]
[]
[]
[null,"Supplementary Table C9.9",null,null,null,null,null,null,null,null,null,"Figure C9.9: Customer-weighted average solar feed-in tariff for solar residential flat rate and flat rate with controlled load market offer plans by discount tier to the DMO/VDO, assuming conditional discounts are not achieved, all regions"]
[null,"All regions"]
[null,null,"2022 Customers","2023 Customers"]
[null,">20% below",12.4,9.2200000000000006]
[null,"15-20% below",11.76,19.79]
[null,"10-15% below",14.38,12.06]
[null,"5-10% below",14.59,11.72]
[null,"1-5% below",15.39,14.2]
[null,"Equal to DMO/VDO",17.46,13.15]
[null,"1-5% above",14.32,8.18]
[null,"5-10% above",20.170000000000002,14.8]
[null,"10-15% above",12.7,18.03]
[null,"15-20% above",10.119999999999999,11.51]
[null,">20% above",11.06,13.52]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data."]
[]
[]
[null,"Supplementary Table C9.10",null,null,null,null,null,null,null,null,null,"Figure C9.10 (Figure 3.7 in report): Customer-weighted average solar feed-in tariff for solar residential flat rate and flat rate with controlled load market offer plans by discount tier to the DMO/VDO, assuming conditional discounts are not achieved and excluding offers with subsidised solar feed-in tariffs, all regions"]
[null,"All regions"]
[null,null,"2022 Customers","2023 Customers"]
[null,">20% below",6.77,6.25]
[null,"15-20% below",7.06,7.18]
[null,"10-15% below",6.93,6.09]
[null,"5-10% below",6.89,6.48]
[null,"1-5% below",7.24,6.11]
[null,"Equal to DMO/VDO",6.56,8.57]
[null,"1-5% above",10.54,7.2]
[null,"5-10% above",9.1,7.74]
[null,"10-15% above",8.32,8.0500000000000007]
[null,"15-20% above",7.36,6.73]
[null,">20% above",6.97,6.67]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data."]
[null,null,null,null,null,null,null,null,null,null,null,"Notes:\t To exclude government subsidised solar feed-in tariffs, we excluded all solar feed-in tariffs which were equal to or greater than 44c/kWh. See Appendix B for additional qualifications about this figure. "]
[]
[null,"Supplementary Table C9.11",null,null,null,null,null,null,null,null,null,"Figure C9.11 (Figure 3.8 in report): Proportion of residential customers on plans with conditional discounts and customer-weighted average conditional discount by percentage above the DMO/VDO in 2023"]
[null,"Average conditional discount and proportion of customers above the DMO/VDO, all regions, 2023."]
[null,null,"Average conditional discount","Proportion of customers"]
[null,"Equal to DMO/VDO",0.09,0.02]
[null,"1-5% above",0.09,0.05]
[null,"5-10% above",0.11,0.16]
[null,"10-15% above",0.12,0.49]
[null,"15-20% above",0.13,0.79]
[null,"20-25% above",0.18,0.93]
[null,">25% above",0.28999999999999998,0.96]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data."]
[]
[null,"Supplementary Table C9.12",null,null,null,null,null,null,null,null,null,"Figure C9.12 (Figure 3.11 in report): Proportion of residential customers on flat rate and flat rate with controlled load market offer plans paying more, equal to, or less than the EME/VEC median bill, assuming conditional discounts are not achieved"]
[null,"Proportion of 2022 vs 2023 residential customers on plans paying more, equal to or less than the EME/VEC median bill"]
[null,null,"2022 Customers","2023 Customers"]
[null,">25% below",0.05,0.02]
[null,"20-25% below",0.1,0.01]
[null,"15-20% below",0.1,0.02]
[null,"10-15% below",0.09,0.04]
[null,"5-10% below",0.12,0.04]
[null,"1-5% below",0.11,0.05]
[null,"Equal to median bill",0.09,0.05]
[null,"1-5% above",0.11,0.16]
[null,"5-10% above",0.06,0.28999999999999998]
[null,"10-15% above",0.02,0.12]
[null,"15-20% above",0.03,7.0000000000000007E-2]
[null,"20-25% above",0.04,0.03]
[null,">25% above",7.0000000000000007E-2,0.11]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data and Energy Made Easy and Victorian Energy Compare market offers dataset."]
[]
[]
[null,"Supplementary Table C9.13",null,null,null,null,null,null,null,null,null,"Figure C9.13: Proportion of residential customers on flat rate and flat rate with controlled load market offer plans paying more, equal to, or less than the EME/VEC 75th percentile bill, assuming conditional discounts are not achieved"]
[null,"All regions"]
[null,null,"2022 Customers","2023 Customers"]
[null,">25% below",7.0000000000000007E-2,0.03]
[null,"20-25% below",0.11,0.03]
[null,"15-20% below",0.1,0.04]
[null,"10-15% below",0.12,0.04]
[null,"5-10% below",0.13,0.11]
[null,"1-5% below",0.09,0.16]
[null,"Equal to 75th percentile bill",0.15,0.18]
[null,"1-5% above",0.04,0.17]
[null,"5-10% above",0.03,0.1]
[null,"10-15% above",0.02,0.04]
[null,"15-20% above",0.03,0.02]
[null,"20-25% above",0.03,0.02]
[null,">25% above",0.06,7.0000000000000007E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data and Energy Made Easy and Victorian Energy Compare market offers dataset."]
[]
[]
[]
[null,"Supplementary Table C9.14",null,null,null,null,null,null,null,null,null,"Figure C9.14 (Figure 3.12 in report): Customer-weighted average price for residential customers on plans which existed in 2022 and 2023 (Older Plans) and on plans which only existed in 2023 (Newer Plans), assuming conditional discounts are not met, by state"]
[null,"All regions"]
[null,null,"Older Plans","Newer Plans"]
[null,"VIC",1936.12,1666.72]
[null,"NSW",2395.91,2321.14]
[null,"SA",2713.89,2295.2600000000002]
[null,"SEQ",2192.11,2103.14]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data"]
[]
[]
[null,"Supplementary Table C9.15",null,null,null,null,null,null,null,null,null,"Figure C9.15 (Figure 3.13 in report): Proportion of residential customers by discount to the DMO/VDO, plans which existed in 2022 and 2023 (Older Plans) and on plans which only existed in 2023 (Newer Plans) assuming conditional discounts are not achieved"]
[null,"All regions"]
[null,null,"Older Plans","Newer Plans"]
[null,">25% below",0.03,0.02]
[null,"20-25% below",0.01,0.09]
[null,"15-20% below",0.02,7.0000000000000007E-2]
[null,"10-15% below",0.04,0.11]
[null,"5-10% below",0.13,0.18]
[null,"1-5% below",0.13,0.21]
[null,"Equal to DMO/VDO",0.27,0.14000000000000001]
[null,"1-5% above",0.12,0.06]
[null,"5-10% above",7.0000000000000007E-2,0.06]
[null,"10-15% above",0.03,0.04]
[null,"15-20% above",0.03,0]
[null,"20-25% above",0.04,0]
[null,">25% above",0.08,0.01]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source: \tACCC analysis of retailers’ data."]
[]
[]
[]
[null,"Table C9.16",null,null,null,null,null,null,null,null,null,"Figure C9.16 (Figure B.1 in report): Average usage charge for residential flat rate and flat rate with controlled load market offer plans by discount tier to the DMO/VDO, all regions"]
[null,"All regions"]
[null,null,"2022 Customers","2023 Customers"]
[null,">25% below",23.97,24.58]
[null,"20-25% below",23.27,28.63]
[null,"15-20% below",25.31,33.24]
[null,"10-15% below",25.27,33.24]
[null,"5-10% below",26.44,34.74]
[null,"1-5% below",29.21,34.85]
[null,"Equal to DMO/VDO",28.06,36.01]
[null,"1-5% above",30.99,38.49]
[null,"5-10% above",30.95,42.68]
[null,"10-15% above",37.119999999999997,43.13]
[null,"15-20% above",36.65,44.6]
[null,"20-25% above",36.950000000000003,47.12]
[null,">25% above",42.38,52.94]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data. "]
[null,null,null,null,null,null,null,null,null,null,null,"Note: Average usage charges have been calculated using only the first usage block rate of each electricity plan. Some electricity plans have multiple block rates, whereby different unit rate prices are charged for different amounts of electricity usage. "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Figure C9.17 (Figure B.1 in report): Average supply charge for residential flat rate and flat rate with controlled load market offer plans by discount tier to the DMO/VDO, all regions"]
[null,"Table C9.17"]
[null,"All regions"]
[null,null,"2022 Customers","2023 Customers"]
[null,">25% below",0.89,1.02]
[null,"20-25% below",0.96,1.07]
[null,"15-20% below",0.99,1.0900000000000001]
[null,"10-15% below",1.05,1.17]
[null,"5-10% below",1.1100000000000001,1.22]
[null,"1-5% below",1.1200000000000001,1.22]
[null,"Equal to DMO/VDO",1.1499999999999999,1.24]
[null,"1-5% above",1.1599999999999999,1.2]
[null,"5-10% above",1.1399999999999999,1.26]
[null,"10-15% above",1.1399999999999999,1.3]
[null,"15-20% above",1.1399999999999999,1.33]
[null,"20-25% above",1.1200000000000001,1.19]
[null,">25% above",1.28,1.35]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data. "]

{"sheet":"10. Residential (conditional)","index":12,"n_rows":317,"n_cols":12,"rows_kept":317,"cut":false,"hidden":false,"merged":[[5,11,5,18],[57,1,58,1],[57,2,57,3],[57,4,57,5]]}
[null,"Retail pricing"]
[null,"10. Residential (conditional) "]
[null,"Contents"]
[]
[null,"Supplementary Table C10.1",null,null,null,null,null,null,null,null,null,"Figure C10.1: Customer-weighted average conditional annual price, residential customers by tariff type and year, all regions, nominal, GST inclusive"]
[null,"Customer-weighted average conditional annual price"]
[null,"Flat rate",2022,2023]
[null,"VIC",1333,1650.15]
[null,"NSW",1510.21,2042.38]
[null,"SA",1712.98,2170.17]
[null,"SEQ",1444.55,1917.17]
[]
[null,"Flat rate + controlled load",2022,2023]
[null,"VIC",1813.59,2073.5]
[null,"NSW",2029.9,2776.1]
[null,"SA",2215.5100000000002,2834.21]
[null,"SEQ",1740.42,2317.09]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data. "]
[null,null,null,null,null,null,null,null,null,null,null,"Notes: 2022 prices as at 1 August 2022 and 2023 prices as at 1 August 2023. Solar feed-in tariffs and GreenPower charges are excluded. "]
[]
[]
[null,"Supplementary Table C10.2",null,null,null,null,null,null,null,null,null,"Figure C10.2 (Figure 3.2 in report): Proportion of residential customers on flat rate plans paying more, equal to, or less than the DMO/VDO assuming 100% achievement of conditional discounts"]
[null,"All regions"]
[null,null,"2022 Customers","2023 Customers"]
[null,">25% below",0.09,0.04]
[null,"20-25% below",0.12,0.04]
[null,"15-20% below",0.12,0.04]
[null,"10-15% below",0.14000000000000001,7.0000000000000007E-2]
[null,"5-10% below",0.13,0.17]
[null,"1-5% below",0.1,0.17]
[null,"Equal to DMO/VDO",0.16,0.24]
[null,"1-5% above",0.04,0.12]
[null,"5-10% above",0.04,7.0000000000000007E-2]
[null,"10-15% above",0.02,0.02]
[null,"15-20% above",0.01,0.01]
[null,"20-25% above",0.01,0]
[null,">25% above",0.01,0.01]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data. "]
[]
[]
[]
[null,"Table C10.3"]
[null,"Year-on-year change in Default Market Offer and Victorian Default Offer prices (1 July 2022 to 1 July 2023) and customer-weighted average prices (1 August 2022 to 1 August 2023) assuming 100% achievement of conditional discounts, residential customers, nominal"]
[]
[null,"Distribution Region","Flat rate",null,"Flat rate with controlled load"]
[null,null,"DMO/VDO","Average Price Change","DMO/VDO","Average Price Change"]
[null,"New South Wales"]
[null,"Ausgrid",0.20799999999999999,0.372,0.20699999999999999,0.41099999999999998]
[null,"Endeavour Energy",0.214,0.34699999999999998,0.249,0.39200000000000002]
[null,"Essential Energy",0.20799999999999999,0.309,0.19600000000000001,0.309]
[null,"Victoria"]
[null,"Ausnet Services",0.24099999999999999,0.249,0.28399999999999997,0.17100000000000001]
[null,"CitiPower",0.215,0.20399999999999999,0.26100000000000001,9.2999999999999999E-2]
[null,"Jemena",0.27200000000000002,0.248,0.31900000000000001,9.1999999999999998E-2]
[null,"Powercor",0.27,0.247,0.32200000000000001,0.17499999999999999]
[null,"United Energy",0.25900000000000001,0.23400000000000001,0.309,9.4E-2]
[null,"South East Queensland"]
[null,"Energex",0.215,0.32700000000000001,0.20499999999999999,0.33100000000000002]
[null,"South Australia"]
[null,"SA Power Networks",0.23899999999999999,0.26700000000000002,0.22500000000000001,0.27900000000000003]
[]
[null,"Source:\t ACCC analysis of retailers’ data, Victorian Default Offer prices, and Default Market Offer prices. "]
[]
[]
[]
[]
[]
[]
[]
[null,"Supplementary Table C10.4",null,null,null,null,null,null,null,null,null,"Figure C10.4 (Figure 3.4 in report): Proportion of residential concession customers on flat rate and flat rate with controlled load market offer plans paying more, equal to, or less than the DMO/VDO, assuming 100% achievement of conditional discounts, all regions"]
[null,"All regions"]
[null,null,"2022 Customers","2023 Customers"]
[null,">25% below",0.09,0.03]
[null,"20-25% below",0.15,0.04]
[null,"15-20% below",0.12,0.05]
[null,"10-15% below",0.16,7.0000000000000007E-2]
[null,"5-10% below",0.14000000000000001,0.21]
[null,"1-5% below",0.09,0.19]
[null,"Equal to DMO/VDO",0.14000000000000001,0.21]
[null,"1-5% above",0.04,0.12]
[null,"5-10% above",0.03,0.06]
[null,"10-15% above",0.02,0.02]
[null,"15-20% above",0.01,0.01]
[null,"20-25% above",0.01,0]
[null,">25% above",0.01,0.01]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data. "]
[]
[]
[]
[]
[]
[null,"Supplementary Table C10.5 ",null,null,null,null,null,null,null,null,null,"Figure C10.5: Proportion of residential customers on flat rate plans paying annual prices that are more, equal to, or less than the DMO/VDO in 2022 assuming 100% achievement of conditional discounts, by state "]
[null,"State by state, 2022"]
[null,null,"VIC","NSW","SA","SEQ"]
[null,">20% below",0.05,0.31,0.12,0.3]
[null,"15-20% below",7.0000000000000007E-2,0.16,7.0000000000000007E-2,0.12]
[null,"10-15% below",0.19,0.1,0.14000000000000001,0.13]
[null,"5-10% below",0.2,0.1,0.16,0.09]
[null,"1-5% below",7.0000000000000007E-2,0.12,0.14000000000000001,0.08]
[null,"Equal to DMO/VDO",0.2,0.12,0.21,0.18]
[null,"1-5% above",0.05,0.04,0.06,0.03]
[null,"5-10% above",7.0000000000000007E-2,0.02,0.03,0.03]
[null,"10-15% above",0.03,0.01,0.03,0.01]
[null,"15-20% above",0.02,0.01,0.02,0]
[null,">20% above",0.04,0,0.03,0.02]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data."]
[]
[]
[]
[]
[null,"Supplementary Table C10.6",null,null,null,null,null,null,null,null,null,"Figure C10.6: Proportion of residential customers on flat rate plans paying annual prices that are more, equal to, or less than the DMO/VDO in 2023 assuming 100% achievement of conditional discounts, by state"]
[null,"State by state, 2023"]
[null,null,"VIC","NSW","SA","SEQ"]
[null,">20% below",0.16,0.04,7.0000000000000007E-2,0.02]
[null,"15-20% below",0.06,0.02,0.11,0.03]
[null,"10-15% below",0.11,7.0000000000000007E-2,0.03,0.04]
[null,"5-10% below",0.16,0.2,0.1,0.17]
[null,"1-5% below",0.18,0.14000000000000001,0.16,0.22]
[null,"Equal to DMO/VDO",0.23,0.21,0.17,0.34]
[null,"1-5% above",0.06,0.16,0.13,0.12]
[null,"5-10% above",0.02,0.1,0.15,0.04]
[null,"10-15% above",0.01,0.04,0.02,0.01]
[null,"15-20% above",0,0.01,0.01,0]
[null,">20% above",0.01,0.01,0.05,0.01]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data."]
[]
[]
[null,"Supplementary Table C10.7",null,null,null,null,null,null,null,null,null,"Figure C10.7: Customer-weighted average solar feed-in tariff for solar residential flat rate and flat rate with controlled load market offer plans by discount tier to the DMO/VDO, assuming 100% achievement of conditional discounts, all regions"]
[null,"All regions"]
[null,null,"2022 Customers","2023 Customers"]
[null,">20% below",14.02,9.18]
[null,"15-20% below",12.18,17.899999999999999]
[null,"10-15% below",13.86,10.83]
[null,"5-10% below",15.89,13.63]
[null,"1-5% below",14.66,14.69]
[null,"Equal to DMO/VDO",17.37,13.24]
[null,"1-5% above",11.4,9.76]
[null,"5-10% above",10.74,13.57]
[null,"10-15% above",13.74,9.9]
[null,"15-20% above",13.08,8.27]
[null,">20% above",20.170000000000002,13.05]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data."]
[]
[]
[]
[null,"Supplementary Table C10.8",null,null,null,null,null,null,null,null,null,"Figure C10.8 (Figure 3.7 in report): Customer-weighted average solar feed-in tariff for solar residential flat rate and flat rate with controlled load market offer plans by discount tier to the DMO/VDO, assuming 100% achievement of conditional discounts and excluding offers with subsidised solar feed-in tariffs, all regions"]
[null,"All regions"]
[null,null,"2022 Customers","2023 Customers"]
[null,">20% below",7.01,6.31]
[null,"15-20% below",7.44,7.01]
[null,"10-15% below",7.48,6.09]
[null,"5-10% below",6.91,6.75]
[null,"1-5% below",6.11,6.24]
[null,"Equal to DMO/VDO",6.45,8.56]
[null,"1-5% above",10.92,6.91]
[null,"5-10% above",8.3800000000000008,7.53]
[null,"10-15% above",6.87,7.92]
[null,"15-20% above",6.8,7.39]
[null,">20% above",7.27,6.49]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data."]
[null,null,null,null,null,null,null,null,null,null,null,"Notes:\t  To exclude government subsidised solar feed-in tariffs, we excluded all solar feed-in tariffs which were equal to or greater than 44c/kWh. See Appendix B for additional qualifications about this figure. "]
[]
[]
[]
[null,"Supplementary Table C10.9",null,null,null,null,null,null,null,null,null,"Figure C10.9 (Figure 3.11 in report): Proportion of residential customers on flat rate and flat rate with controlled load market offer plans paying more, equal to, or less than the EME/VEC median bill, assuming 100% achievement of conditional discounts"]
[null,"All regions"]
[null,null,"2022 Customers","2023 Customers"]
[null,">25% below",0.06,0.02]
[null,"20-25% below",0.11,0.01]
[null,"15-20% below",0.11,0.02]
[null,"10-15% below",0.11,0.05]
[null,"5-10% below",0.13,0.05]
[null,"1-5% below",0.11,7.0000000000000007E-2]
[null,"Equal to median bill",0.1,0.06]
[null,"1-5% above",0.12,0.17]
[null,"5-10% above",7.0000000000000007E-2,0.31]
[null,"10-15% above",0.03,0.14000000000000001]
[null,"15-20% above",0.02,0.06]
[null,"20-25% above",0.01,0.02]
[null,">25% above",0.02,0.02]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data and Energy Made Easy and Victorian Energy Compare market offers dataset."]
[]
[]
[]
[null,"Supplementary Table C10.10",null,null,null,null,null,null,null,null,null,"Figure C10.10: Proportion of residential customers on flat rate and flat rate with controlled load market offer plans paying more, equal to, or less than the EME/VEC 75th percentile bill, assuming 100% achievement of conditional discounts"]
[null,"All regions"]
[null,null,"2022 Customers","2023 Customers"]
[null,">25% below",0.09,0.04]
[null,"20-25% below",0.12,0.03]
[null,"15-20% below",0.12,0.04]
[null,"10-15% below",0.14000000000000001,0.05]
[null,"5-10% below",0.14000000000000001,0.13]
[null,"1-5% below",0.1,0.18]
[null,"Equal to 75th percentile bill",0.16,0.18]
[null,"1-5% above",0.04,0.19]
[null,"5-10% above",0.04,0.1]
[null,"10-15% above",0.02,0.03]
[null,"15-20% above",0.01,0.01]
[null,"20-25% above",0.01,0]
[null,">25% above",0.01,0.01]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis based on retailers’ data and Energy Made Easy and Victorian Energy Compare market offers dataset."]
[]
[]
[]
[null,"Supplementary Table C10.11",null,null,null,null,null,null,null,null,null,"Figure C10.11: Customer-weighted average price for residential customers on plans which existed in 2022 and 2023 (Older Plans) and on plans which only existed in 2023 (Newer Plans), assuming 100% achievement of conditional discounts, by state"]
[null,"All regions"]
[null,null,"Older Plans","Newer Plans"]
[null,"VIC",1791.8,1659.96]
[null,"NSW",2316.7199999999998,2309.7800000000002]
[null,"SA",2541.0500000000002,2289.83]
[null,"SEQ",2115.5100000000002,2088.88]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data"]
[]
[]
[]
[]
[null,"Supplementary Table C10.12",null,null,null,null,null,null,null,null,null,"Figure C10.12: Proportion of residential customers by discount to the DMO/VDO, plans which existed in 2022 and 2023 (Older Plans) and on plans which only existed in 2023 (Newer Plans) assuming 100% achievement of conditional discounts"]
[null,"All regions"]
[null,null,"Older Plans","Newer Plans"]
[null,">25% below",0.04,0.02]
[null,"20-25% below",0.02,0.09]
[null,"15-20% below",0.03,7.0000000000000007E-2]
[null,"10-15% below",0.06,0.11]
[null,"5-10% below",0.17,0.18]
[null,"1-5% below",0.15,0.22]
[null,"Equal to DMO/VDO",0.28000000000000003,0.15]
[null,"1-5% above",0.15,0.06]
[null,"5-10% above",7.0000000000000007E-2,0.06]
[null,"10-15% above",0.01,0.04]
[null,"15-20% above",0.01,0]
[null,"20-25% above",0,0]
[null,">25% above",0.01,0]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data. "]

{"sheet":"11. Small business","index":13,"n_rows":206,"n_cols":13,"rows_kept":206,"cut":false,"hidden":false,"merged":[]}
[null,"Retail pricing"]
[null,"11. Small business"]
[null,"Contents"]
[]
[null,"Supplementary Table C11.1",null,null,null,null,null,null,null,null,null,null,"Figure C11.1 (Figure 3.1 in report): Customer-weighted average unconditional annual price, small business customers on flat rate tariffs by year, all regions, nominal, GST inclusive"]
[null,"State by state"]
[null,null,2022,2023]
[null,"VIC",2969.39,3604.63]
[null,"NSW",3447.73,4463.33]
[null,"SA",4173.18,5337.23]
[null,"SEQ",2959.85,3804.34]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data. "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Notes: 2022 prices as at 1 August 2022 and 2023 prices as at 1 August 2023.  Solar feed-in tariffs, conditional discounts and GreenPower charges are excluded. "]
[]
[null,"Supplementary Table C11.2",null,null,null,null,null,null,null,null,null,null,"Figure C11.2: Customer weighted average annual price with conditional discounts achieved, small business customers by year, all regions, GST inclusive"]
[null,"State by state"]
[null,null,2022,2023]
[null,"VIC",2908.37,3543.87]
[null,"NSW",3416.83,4434.33]
[null,"SA",4147.32,5318.97]
[null,"SEQ",2933.28,3777.5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data. "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Notes: 2022 prices as at 1 August 2022 and 2023 prices as at 1 August 2023. Solar feed-in tariffs and GreenPower charges are excluded. "]
[]
[]
[null,"Supplementary Table C11.3",null,null,null,null,null,null,null,null,null,null,"Figure C11.3 (Figure 3.3 in report): Proportion of small business customers on flat rate plans paying more, equal to, or less than the DMO/VDO assuming conditional discounts are not achieved"]
[null,"All regions"]
[null,null,"2022 Customers","2023 Customers"]
[null,">25% below",0.25,0.15]
[null,"20-25% below",0.1,0.06]
[null,"15-20% below",7.0000000000000007E-2,7.0000000000000007E-2]
[null,"10-15% below",0.11,0.08]
[null,"5-10% below",0.1,0.14000000000000001]
[null,"1-5% below",7.0000000000000007E-2,0.11]
[null,"Equal to DMO/VDO",0.2,0.27]
[null,"1-5% above",0.03,0.05]
[null,"5-10% above",0.01,0.03]
[null,"10-15% above",0.02,0.01]
[null,"15-20% above",0,0.01]
[null,"20-25% above",0.01,0.01]
[null,">25% above",0.02,0.01]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data. "]
[]
[]
[]
[]
[]
[null,"Supplementary Table C11.4",null,null,null,null,null,null,null,null,null,null,"Figure C11.4 (Figure 3.3 in report): Proportion of small business customers on flat rate plans paying more, equal to, or less than the DMO/VDO, assuming 100% achievement of conditional discounts"]
[null,"All regions"]
[null,null,"2022 Customers","2023 Customers"]
[null,">25% below",0.26,0.16]
[null,"20-25% below",0.11,0.06]
[null,"15-20% below",0.08,7.0000000000000007E-2]
[null,"10-15% below",0.1,0.09]
[null,"5-10% below",0.09,0.14000000000000001]
[null,"1-5% below",7.0000000000000007E-2,0.12]
[null,"Equal to DMO/VDO",0.2,0.27]
[null,"1-5% above",0.03,0.05]
[null,"5-10% above",0.02,0.03]
[null,"10-15% above",0.01,0]
[null,"15-20% above",0,0]
[null,"20-25% above",0,0]
[null,">25% above",0.01,0]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data. "]
[]
[]
[]
[]
[null,"Supplementary Table C11.5",null,null,null,null,null,null,null,null,null,null,"Figure C11.5: Proportion of small business customers on flat rate plans paying annual unconditional prices that are more, equal to, or less than the DMO/VDO in 2022 by state"]
[null,"State by state, 2022"]
[null,null,"VIC","NSW","SA","SEQ"]
[null,"Below",0.47,0.85,0.61,0.77]
[null,"At",0.3,0.13,0.27,0.19]
[null,"Above",0.23,0.02,0.13,0.04]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data."]
[]
[]
[null,"Supplementary Table C11.6",null,null,null,null,null,null,null,null,null,null,"Figure C11.6: Proportion of small business customers on flat rate plans paying annual unconditional prices that are more, equal to, or less than the DMO/VDO in 2023 by state"]
[null,"State by state, 2023"]
[null,null,"VIC","NSW","SA","SEQ"]
[null,"Below",0.42,0.68,0.72,0.67]
[null,"At",0.41,0.18,0.25,0.28999999999999998]
[null,"Above",0.17,0.14000000000000001,0.03,0.04]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data."]
[]
[]
[]
[null,"Supplementary Table C11.7",null,null,null,null,null,null,null,null,null,null,"Figure C11.7: Proportion of small business customers on flat rate plans paying annual prices that are more, equal to, or less than the DMO/VDO in 2022 assuming 100% achievement of conditional discounts, by state"]
[null,"State by state, 2022"]
[null,null,"VIC","NSW","SA","SEQ"]
[null,"Below",0.49,0.86,0.62,0.77]
[null,"At",0.31,0.13,0.27,0.19]
[null,"Above",0.2,0.02,0.11,0.04]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data."]
[]
[]
[]
[]
[null,"Supplementary Table C11.8",null,null,null,null,null,null,null,null,null,null,"Figure C11.8: Proportion of small business customers on flat rate plans paying annual prices that are more, equal to, or less than the DMO/VDO in 2023 assuming 100% achievement of conditional discounts, by state"]
[null,"State by state, 2023"]
[null,null,"VIC","NSW","SA","SEQ"]
[null,"Below",0.44,0.71,0.72,0.7]
[null,"At",0.42,0.18,0.25,0.28999999999999998]
[null,"Above",0.14000000000000001,0.11,0.02,0.01]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data."]
[]
[]
[]
[null,"Supplementary Table C11.9",null,null,null,null,null,null,null,null,null,null,"Figure C11.9 (Figure 3.9 in report): Proportion of small business customers on plans with conditional discounts and customer-weighted average conditional discount by percentage above the DMO/VDO in 2023"]
[null,"All regions, 2023"]
[null,null,"Average conditional discount","Proportion of customers"]
[null,"Equal to DMO/VDO",0.08,0.01]
[null,"1-5% above",0.14000000000000001,0.12]
[null,"5-10% above",0.1,0.04]
[null,"10-15% above",0.11,0.52]
[null,"15-20% above",0.12,0.69]
[null,"20-25% above",0.2,0.79]
[null,">25% above",0.26,0.81]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Source:\t ACCC analysis of retailers’ data."]

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

{"sheet":"12. Swap and Cap Prices ","index":15,"n_rows":89,"n_cols":10,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Contracts"]
[null,"12. Swap and cap prices"]
[null,"Contents"]
[]
[null," "]
[null,"Supplementary Table C12.1",null,null,null,null,null,null,null,"Figure C12.1 (Figure 4.1 in the report): Average strike price of swap contracts purchased from January 2021 to June 2023 with delivery periods in 2024"]
[null,"All regions, OTC and ASX markets"]
[null,"Average Strike Price ($/MWh)"]
[null,"Period","2024-Q1","2024-Q2","2024-Q3","2024-Q4"]
[null,"2021-01-01",61,40,39,39]
[null,"2021-02-01",64,37,36,42]
[null,"2021-03-01",50,36,37,40]
[null,"2021-04-01",51,36,44,54]
[null,"2021-05-01",60,45,46,40]
[null,"2021-06-01",59,41,38,50]
[null,"2021-07-01",65,47,49,47]
[null,"2021-08-01",58,51,50,58]
[null,"2021-09-01",61,49,45,42]
[null,"2021-10-01",64,50,47,45]
[null,"2021-11-01",68,50,50,52]
[null,"2021-12-01",77,54,52,58]
[null,"2022-01-01",79,62,61,59]
[null,"2022-02-01",74,61,58,57]
[null,"2022-03-01",91,70,68,75]
[null,"2022-04-01",89,79,72,82]
[null,"2022-05-01",102,91,83,90]
[null,"2022-06-01",134,96,96,88]
[null,"2022-07-01",130,116,111,119]
[null,"2022-08-01",124,105,96,92]
[null,"2022-09-01",161,130,128,114]
[null,"2022-10-01",195,168,168,129,null,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,"2022-11-01",168,147,143,118]
[null,"2022-12-01",121,105,100,78]
[null,"2023-01-01",106,101,101,76]
[null,"2023-02-01",107,102,99,83]
[null,"2023-03-01",108,104,106,76]
[null,"2023-04-01",122,123,128,92]
[null,"2023-05-01",141,132,125,88]
[null,"2023-06-01",129,127,127,89]
[]
[]
[]
[null,"Supplementary Table C12.2",null,null,null,null,null,null,null,"Figure C12.2 (Figure 4.2 in the report): Average premium price of cap contracts purchased from March 2021 to June 2023 with delivery periods in 2024."]
[null,"All regions, OTC and ASX markets"]
[null,null,"2024-Q1","2024-Q2","2024-Q3","2024-Q4"]
[null,"2021-01-01","","","",""]
[null,"2021-02-01","","","",""]
[null,"2021-03-01",19,"","",""]
[null,"2021-04-01",23,4,8,4]
[null,"2021-05-01","","","",""]
[null,"2021-06-01",23,5,"",9]
[null,"2021-07-01",21,7,5,9]
[null,"2021-08-01",27,8,6,9]
[null,"2021-09-01",25,7,"",""]
[null,"2021-10-01",29,6,8,12]
[null,"2021-11-01",28,9,8,10]
[null,"2021-12-01",31,6,9,13]
[null,"2022-01-01",23,4,4,8]
[null,"2022-02-01",25,8,8,11]
[null,"2022-03-01",29,10,9,12]
[null,"2022-04-01",29,14,10,16]
[null,"2022-05-01",30,15,17,17]
[null,"2022-06-01",38,21,23,33]
[null,"2022-07-01",36,20,20,""]
[null,"2022-08-01",35,26,21,18]
[null,"2022-09-01",50,31,30,31]
[null,"2022-10-01",52,50,46,27]
[null,"2022-11-01",91,54,54,"",null,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,"2022-12-01",42,26,27,28,null,null,null,"Note: Some months had outlier average prices, influenced by low trade volumes. Average prices for these months have not been included, as we do not consider them representative of the broader price trends."]
[null,"2023-01-01",40,20,19,16,null,null,null,"We have interpolated to provide an indicative price trend across these months."]
[null,"2023-02-01",26,20,21,17]
[null,"2023-03-01",32,17,17,18]
[null,"2023-04-01",41,19,20,20]
[null,"2023-05-01","","","",""]
[null,"2023-06-01",38,28,29,23]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," "]

{"sheet":"13. Contract volumes by region","index":16,"n_rows":204,"n_cols":10,"rows_kept":204,"cut":false,"hidden":false,"merged":[[122,3,122,4],[120,9,120,14],[6,9,6,14],[44,9,44,14],[8,3,8,4],[8,5,8,6],[82,9,82,14],[46,3,46,4],[46,5,46,6],[84,3,84,4],[84,5,84,6]]}
[]
[null,"Contracts"]
[null,"13. Contract volumes by region"]
[null,"Contents"]
[]
[null,"Supplementary Table C13.1 ",null,null,null,null,null,null,null,"Figure C13.1 (Figure 4.3 in the report)"]
[null,"All retailers",null,null,null,null,null,null,null,"Total traded volumes (GWh) of ASX and OTC contracts bought and sold, excluding caps, options and weather derivatives, from January 2021 to June 2023, all delivery periods, New South Wales"]
[null,"Volume (GWh)"]
[null,null,null,"ASX",null,"OTC"]
[null,"Year","Month","Purchase","Sale","Purchase","Sale"]
[null,2021,"2021-01-01",2010,-3105,683,-1723]
[null,null,"2021-02-01",2518,-2410,3576,-1144]
[null,null,"2021-03-01",3403,-2818,574,-446]
[null,null,"2021-04-01",3853,-4917,1846,-1542]
[null,null,"2021-05-01",5242,-5258,2755,-2345]
[null,null,"2021-06-01",4823,-5168,7650,-3076]
[null,null,"2021-07-01",4508,-2948,756,-373]
[null,null,"2021-08-01",3232,-1970,384,-1032]
[null,null,"2021-09-01",2861,-1595,553,-2013]
[null,null,"2021-10-01",1893,-2958,1141,-579]
[null,null,"2021-11-01",3902,-5992,2108,-653]
[null,null,"2021-12-01",2952,-2125,614,-1984]
[null,2022,"2022-01-01",3021,-2498,683,0]
[null,null,"2022-02-01",2618,-1632,2082,-1175]
[null,null,"2022-03-01",3686,-4298,3177,-3694]
[null,null,"2022-04-01",2096,-2157,997,-258]
[null,null,"2022-05-01",5430,-4416,1351,-1014]
[null,null,"2022-06-01",1418,-1661,2897,-5248]
[null,null,"2022-07-01",2989,-1880,364,-581]
[null,null,"2022-08-01",2210,-3129,347,-206]
[null,null,"2022-09-01",2351,-2113,240,-155]
[null,null,"2022-10-01",1684,-2122,396,-79]
[null,null,"2022-11-01",8901,-8222,437,-362]
[null,null,"2022-12-01",3810,-2191,413,-483]
[null,2023,"2023-01-01",3034,-2442,83,-482,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,null,"2023-02-01",3079,-2077,143,-149]
[null,null,"2023-03-01",2277,-4025,355,-511]
[null,null,"2023-04-01",974,-1363,480,-336]
[null,null,"2023-05-01",7844,-8043,1133,-772]
[null,null,"2023-06-01",2673,-839,1048,-385]
[]
[]
[]
[null,"Supplementary Table C13.2",null,null,null,null,null,null,null,"Figure C13.2 (Figure 4.3 in the report)"]
[null,"All retailers",null,null,null,null,null,null,null,"Total traded volumes (GWh) of ASX and OTC contracts bought and sold, excluding caps, options and weather derivatives, from January 2021 to June 2023, all delivery periods, Queensland"]
[null,"Volume (GWh)"]
[null,null,null,"ASX",null,"OTC"]
[null,"Year","Month","Purchase","Sale","Purchase","Sale"]
[null,2021,"2021-01-01",9241,-10378,2180,-1789]
[null,null,"2021-02-01",3039,-6611,465,-6040]
[null,null,"2021-03-01",2028,-2500,717,-77]
[null,null,"2021-04-01",6645,-5241,744,-284]
[null,null,"2021-05-01",6568,-5092,1070,-429]
[null,null,"2021-06-01",6335,-6000,1449,-664]
[null,null,"2021-07-01",8103,-7721,4548,-1330]
[null,null,"2021-08-01",3478,-2764,256,-581]
[null,null,"2021-09-01",2404,-3696,789,-217]
[null,null,"2021-10-01",3726,-4501,3401,-1062]
[null,null,"2021-11-01",15825,-18386,6591,-2812]
[null,null,"2021-12-01",3713,-6117,3506,-1362]
[null,2022,"2022-01-01",5026,-6618,592,-692]
[null,null,"2022-02-01",6239,-6056,1237,-831]
[null,null,"2022-03-01",12035,-10210,8902,-7736]
[null,null,"2022-04-01",5343,-5211,3684,-2958]
[null,null,"2022-05-01",13649,-18867,6102,-6725]
[null,null,"2022-06-01",4375,-5467,6542,-2678]
[null,null,"2022-07-01",2492,-2392,410,-720]
[null,null,"2022-08-01",6621,-6390,1695,-3399]
[null,null,"2022-09-01",4156,-6609,2387,-2839]
[null,null,"2022-10-01",5737,-5841,2876,-3906]
[null,null,"2022-11-01",15410,-14997,1503,-1508]
[null,null,"2022-12-01",3497,-2983,6634,-706]
[null,2023,"2023-01-01",2600,-2829,827,-1474,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,null,"2023-02-01",3147,-2534,1402,-2461]
[null,null,"2023-03-01",2990,-4453,1210,-2343]
[null,null,"2023-04-01",2621,-2572,1126,-1684]
[null,null,"2023-05-01",14809,-13518,644,-1479]
[null,null,"2023-06-01",3098,-2124,700,-756]
[]
[]
[]
[null,"Supplementary Table C13.3",null,null,null,null,null,null,null,"Figure C13.3 (Figure 4.3 in the report)"]
[null,"All retailers",null,null,null,null,null,null,null,"Total traded volumes (GWh) of ASX and OTC contracts bought and sold, excluding caps, options and weather derivatives, from January 2021 to June 2023, all delivery periods, Victoria"]
[null,"Volume (GWh)"]
[null,null,null,"ASX",null,"OTC"]
[null,"Year","Month","Purchase","Sale","Purchase","Sale"]
[null,2021,"2021-01-01",2783,-1980,143,-50]
[null,null,"2021-02-01",3045,-1531,75,-703]
[null,null,"2021-03-01",3542,-3172,178,-22380]
[null,null,"2021-04-01",2767,-2069,1383,-187]
[null,null,"2021-05-01",6719,-5498,164,-1197]
[null,null,"2021-06-01",5493,-5939,3551,-496]
[null,null,"2021-07-01",8400,-9108,474,-279]
[null,null,"2021-08-01",2202,-1454,18,-159]
[null,null,"2021-09-01",2154,-2560,1829,-1840]
[null,null,"2021-10-01",1684,-2537,2186,-2260]
[null,null,"2021-11-01",2633,-2568,2853,-35237]
[null,null,"2021-12-01",1752,-1549,174,-157]
[null,2022,"2022-01-01",1480,-1749,13,-22]
[null,null,"2022-02-01",2143,-3602,920,-578]
[null,null,"2022-03-01",4244,-5458,620,-643]
[null,null,"2022-04-01",4207,-3206,1448,-1703]
[null,null,"2022-05-01",5406,-3934,1666,-440]
[null,null,"2022-06-01",2204,-1875,5014,-4362]
[null,null,"2022-07-01",2573,-1500,304,-865]
[null,null,"2022-08-01",2270,-2371,317,-88]
[null,null,"2022-09-01",2479,-2755,166,-1498]
[null,null,"2022-10-01",3081,-2312,1232,-1959]
[null,null,"2022-11-01",5435,-6326,591,-789]
[null,null,"2022-12-01",2924,-1775,469,-447]
[null,2023,"2023-01-01",4082,-2412,79,-90,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,null,"2023-02-01",1976,-1122,308,-270]
[null,null,"2023-03-01",3839,-4010,2427,-2495]
[null,null,"2023-04-01",1060,-607,104,-137]
[null,null,"2023-05-01",3534,-5263,881,-1557]
[null,null,"2023-06-01",2844,-3231,3976,-2939]
[]
[]
[]
[null,"Supplementary Table C13.4",null,null,null,null,null,null,null,"Figure C13.4 (Figure 4.3 in the report)"]
[null,"All retailers",null,null,null,null,null,null,null,"Total traded volumes (GWh) of contracts bought and sold, excluding caps, options and weather derivatives, from January 2021 to June 2023, all delivery periods, South Australia"]
[null,"Volume (GWh)"]
[null,null,null,"Total"]
[null,"Year","Month","Purchase","Sale"]
[null,2021,"2021-01-01",292,-138]
[null,null,"2021-02-01",118,-43]
[null,null,"2021-03-01",159,-132]
[null,null,"2021-04-01",822,-676]
[null,null,"2021-05-01",830,-949]
[null,null,"2021-06-01",1258,-607]
[null,null,"2021-07-01",309,-259]
[null,null,"2021-08-01",160,-127]
[null,null,"2021-09-01",451,-287]
[null,null,"2021-10-01",2422,-650]
[null,null,"2021-11-01",467,-2281]
[null,null,"2021-12-01",112,-75]
[null,2022,"2022-01-01",52,-33]
[null,null,"2022-02-01",231,-160]
[null,null,"2022-03-01",42,-97]
[null,null,"2022-04-01",157,-69]
[null,null,"2022-05-01",236,-189]
[null,null,"2022-06-01",418,-278]
[null,null,"2022-07-01",509,-424,null,null,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,null,"2022-08-01",225,-95,null,null,null,null,"Note: In order to avoid disclosure of confidential data of suppliers, the chart for SA does not distinguish between ASX and OTC trades."]
[null,null,"2022-09-01",394,-313]
[null,null,"2022-10-01",39,-39]
[null,null,"2022-11-01",39,-7]
[null,null,"2022-12-01",309,-313]
[null,2023,"2023-01-01",28,-64]
[null,null,"2023-02-01",3164,-11]
[null,null,"2023-03-01",46,-91]
[null,null,"2023-04-01",111,-125]
[null,null,"2023-05-01",706,-717]
[null,null,"2023-06-01",37,-8]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null," "]

{"sheet":"14. Delivery Periods","index":17,"n_rows":80,"n_cols":9,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Contracts"]
[null,"14. Delivery periods"]
[null,"Contents"]
[]
[null,"Supplementary Table C14.1",null,null,null,null,null,null,"Figure C14.1  (Figure 4.4 in the report): Average delivery period of purchased contracts from January 2021 to July 2023"]
[null,"Small retailers"]
[null,"All regions, ASX and OTC markets",null,null,null,null,null,null,"Small retailers"]
[null,"Average period delivery in months"]
[null,null,"Average time to delivery start ","Average start to delivery end "]
[null,"2021-01-01",4.9400000000000004,2.96]
[null,"2021-02-01",6.67,3.68]
[null,"2021-03-01",9.07,4.79]
[null,"2021-04-01",11.14,3.4]
[null,"2021-05-01",9.5500000000000007,3.68]
[null,"2021-06-01",6.69,4.0199999999999996]
[null,"2021-07-01",10.24,3.97]
[null,"2021-08-01",6.96,3.44]
[null,"2021-09-01",4.9400000000000004,4.3600000000000003]
[null,"2021-10-01",9.15,3.82]
[null,"2021-11-01",10.38,4.5599999999999996]
[null,"2021-12-01",6.1,3.99]
[null,"2022-01-01",7.12,3.96]
[null,"2022-02-01",12.71,3.91]
[null,"2022-03-01",11.81,3.48]
[null,"2022-04-01",10.23,3.59]
[null,"2022-05-01",13.05,3.89]
[null,"2022-06-01",11.24,4.87]
[null,"2022-07-01",9.27,4.37]
[null,"2022-08-01",10.69,2.97]
[null,"2022-09-01",7.44,3.71]
[null,"2022-10-01",7.8,3.15]
[null,"2022-11-01",7.65,3.75]
[null,"2022-12-01",3.91,6.09,null,null,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,"2023-01-01",6.7,4.1900000000000004]
[null,"2023-02-01",5.98,2.92]
[null,"2023-03-01",9.0399999999999991,3.29]
[null,"2023-04-01",7.62,3.24]
[null,"2023-05-01",9.59,4.07]
[null,"2023-06-01",9.4499999999999993,3.36]
[null,"2023-07-01",9.6999999999999993,2.97]
[]
[]
[]
[null,"Supplementary Table C14.2",null,null,null,null,null,null,"Figure C14.2  (Figure 4.4 in the report): Average delivery period of purchased contracts (ASX and OTC) from January 2021 to July 2023 "]
[null,"Large retailers"]
[null,"All regions, ASX and OTC markets",null,null,null,null,null,null,"Large retailers "]
[null,"Average period delivery in months"]
[null,null,"Average time to delivery start ","Average start to delivery end "]
[null,"2021-01-01",14.15,4.43]
[null,"2021-02-01",14.5,4.3099999999999996]
[null,"2021-03-01",15.64,4.1900000000000004]
[null,"2021-04-01",11.97,3.96]
[null,"2021-05-01",12.79,3.9]
[null,"2021-06-01",12.21,3.82]
[null,"2021-07-01",15.08,3.85]
[null,"2021-08-01",11.49,3.9]
[null,"2021-09-01",10.47,3.93]
[null,"2021-10-01",11.7,4.24]
[null,"2021-11-01",12.14,4.7699999999999996]
[null,"2021-12-01",10.6,4.24]
[null,"2022-01-01",14.25,4.34]
[null,"2022-02-01",13.2,4.92]
[null,"2022-03-01",13.89,4.82]
[null,"2022-04-01",12.96,4.4800000000000004]
[null,"2022-05-01",11.15,5.26]
[null,"2022-06-01",12.19,4.9400000000000004]
[null,"2022-07-01",10.81,4.5599999999999996]
[null,"2022-08-01",12.83,4.92]
[null,"2022-09-01",13.23,3.97]
[null,"2022-10-01",13.54,3.92]
[null,"2022-11-01",9.24,3.75]
[null,"2022-12-01",9.99,4.0199999999999996]
[null,"2023-01-01",13.28,4.07]
[null,"2023-02-01",13.2,3.66]
[null,"2023-03-01",12.31,3.63]
[null,"2023-04-01",11.32,3.98]
[null,"2023-05-01",8.9,3.87,null,null,null,null,"Source: ACCC analysis of hedging contracts data."]
[null,"2023-06-01",10.210000000000001,3.81]
[null,"2023-07-01",10.199999999999999,3.39]

{"sheet":"15. Survey responses","index":18,"n_rows":177,"n_cols":16,"rows_kept":177,"cut":false,"hidden":false,"merged":[[9,1,13,1]]}
[]
[null,"Contracts"]
[null,"15. Survey responses"]
[null,"Contents"]
[null,"Supplementary table C15.1 - Small retailer target hedging strategies",null,null,null,null,null,null,null,null,null,null,null,null,"Figure C15.1 (Figure 5.1 in report): Average of retailers’ level of agreement that the Company was able to execute its target hedging strategy in that trading quarter (from quarter 3 2021 to July 2023) with respect to each delivery period (quarter 3 2023 to quarter 3 2024)."]
[null,"Level of agreement with the following statement: ‘Market conditions were such that the Company was able to execute its target hedging strategy in that quarter with respect to this delivery period.’"]
[null,"Average score where 1 = strong agreement and a score of 5 = strong disagreement."]
[null,null,null,"Quarters before delivery period"]
[null,null,null,"Q3 2021 ","Q4 2021 ","Q1 2022","Q2 2022 ","Q3 2022 ","Q4 2022 ","Q1 2023 ","Q2 2023 ","Q3 2023 "]
[null,"Delivery Period","Q3 2023 ",1.5,1.5,1.7,2.2000000000000002,2.8,3.1,2.4,2.4,2.8]
[null,null,"Q4 2023 ",1.8,1.8,1.8,2,2.5,3.1,2.4,2.4,2.4]
[null,null,"Q1 2024 ",2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2999999999999998,2.8,3.1,2.9,2.7,2.6]
[null,null,"Q2 2024 ",2.2000000000000002,2.2000000000000002,2.2000000000000002,2.7,3,3.1,2.6,2.7,2.6]
[null,null,"Q3 2024 ",2.4,2.4,2.4,2.6,3.2,3.3,2.7,2.2999999999999998,2.1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis of electricity retailer survey data."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: Retailers survey responses were collected in July 2023. Meaning that responses for Q3 2023 trading period may not be representative of the entire quarter."]
[]
[]
[]
[null,"Supplementary table C15.2",null,null,null,null,null,null,null,null,null,null,null,null,"Figure C15.2 (Figure 5.3 in report): The significance of different factors relating to reduced coal generation affecting the types of contracts sold by large generators and gentailers over the next 10 years. "]
[null,"Confirm which of the following factors the Company expects will affect the types of Hedge Contracts offered or sold by the Company over the next 10 years."]
[null,"Each option rated as either very significant, significant, somewhat significant, not significant, or not applicable."]
[null,"Percent of suppliers who responded to each option"]
[null,null,"Very significant ","Signficant","Somewhat significant","Not significant","Not applicable "]
[null,"Retire / close coal generation assets",0.17,0,0.17,0.17,0.5]
[null,"Retire/ close gas generation assets ",0,0.08,0.25,0.17,0.5]
[null,"Decrease coal generation irrespective of closure ",0.08,0,0.08,0.33,0.5]
[null,"Decrease gas generation irrespective of closure ",0,0.08,0,0.33,0.57999999999999996]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis of electricity retailer survey data."]
[]
[]
[]
[null,"Supplementary table C15.3",null,null,null,null,null,null,null,null,null,null,null,null,"Figure C15.3 (Figure 5.4 in report): The significance of different factors relating to investment in renewables affecting the types of contracts sold by large generators and gentailers over the next 10 years."]
[null,"Confirm which of the following factors the Company expects will affect the types of Hedge Contracts offered or sold by the Company over the next 10 years.  significant, or not applicable. "]
[null,"Each option rated as either very significant, significant, somewhat significant, not significant, or not"]
[null,"Percent of suppliers who responded to each option"]
[null,null,"Very significant ","Significant","Somewhat significant","Not significant","Not applicable "]
[null,"Investment in wind generation assets",0.08,0.17,0.33,0.33,0.08]
[null,"Investment in solar generation assets ",0,0.25,0.17,0.42,0.17]
[null,"Investment in battery storage ",0.08,0.17,0.33,0.33,0.08]
[null,"Investment in other forms of renewable energy assets or storage ",0,0.17,0.08,0.57999999999999996,0.17]
[null,"Increased outputs of existing renewable generation assets",0,0.08,0,0.5,0.42]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source: ACCC analysis of electricity retailer survey data."]

{"sheet":"16. Volume by market","index":19,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Contracts"]
[null,"16. Volume by market"]
[null,"Contents"]
[]
[]
[null,"Supplementary table - Proportion of total volume of contracts traded by large and small retailers",null,null,null,null,null,null,null,null,null,"Figure C16.1 (Figure 5.2 in report): Proportion of total volume of contracts traded by large and small retailers OTC, on the ASX and on FEX, Q1 2021 to Q3 2023"]
[null,"All regions"]
[null,"Large retailer"]
[null,"Trading period"]
[null,null,"ASX","FEX","OTC"]
[null,"Q1 2021 ",0.72699999999999998,0,0.27300000000000002]
[null,"Q2 2021 ",0.73199999999999998,0,0.26800000000000002]
[null,"Q3 2021",0.79100000000000004,0,0.20899999999999999]
[null,"Q4 2021 ",0.628,0,0.372]
[null,"Q1 2022 ",0.63500000000000001,0,0.36499999999999999]
[null,"Q2 2022 ",0.63200000000000001,0,0.36799999999999999]
[null,"Q3 2022 ",0.75700000000000001,0,0.24299999999999999]
[null,"Q4 2022 ",0.79400000000000004,0,0.20599999999999999]
[null,"Q1 2023 ",0.86099999999999999,0,0.13900000000000001]
[null,"Q2 2023 ",0.76200000000000001,0,0.23799999999999999]
[null,"Q3 2023 ",0.93799999999999994,0,6.2E-2]
[]
[]
[null,"Small retailer"]
[null,"Trading period"]
[null,null,"ASX","FEX","OTC"]
[null,"Q1 2021",0.40600000000000003,0,0.59399999999999997]
[null,"Q2 2021",0.128,0,0.872]
[null,"Q3 2021",0.73699999999999999,0,0.26400000000000001]
[null,"Q4 2021",0.15,0,0.85]
[null,"Q1 2022",0.44800000000000001,0,0.55200000000000005]
[null,"Q2 2022",9.9000000000000005E-2,0,0.90100000000000002]
[null,"Q3 2022 ",0.34699999999999998,0,0.65300000000000002]
[null,"Q4 2022 ",0.32300000000000001,0,0.67700000000000005]
[null,"Q1 2023 ",0.14699999999999999,0,0.85299999999999998]
[null,"Q2 2023 ",8.1000000000000003E-2,0,0.91900000000000004]
[null,"Q3 2023 ",0.128,0,0.873]
[null,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,null,"Note: Figure excludes power purchase agreements, and load following and generation following shaped contracts."]

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

{"sheet":"17. CPI table","index":21,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Consumer Price Index (CPI) Table"]
[null,"17. CPI Table"]
[null,"Contents"]
[]
[null,"Supplementary table - Consumer Pricing Index (CPI) "]
[null,"All groups CPI, Australia"]
[]
[null,"Financial year","CPI Quarter","CPI Values","Base year: 2022-23"]
[null,"2007-08","2008-06-01",91.6,0.69]
[null,"2008-09","2009-06-01",92.9,0.69]
[null,"2009-10","2010-06-01",95.8,0.72]
[null,"2010-11","2011-06-01",99.2,0.74]
[null,"2011-12","2012-06-01",100.4,0.75]
[null,"2012-13","2013-06-01",102.8,0.77]
[null,"2013-14","2014-06-01",105.9,0.79]
[null,"2014-15","2015-06-01",107.5,0.8]
[null,"2015-16","2016-06-01",108.6,0.81]
[null,"2016-17","2017-06-01",110.7,0.83]
[null,"2017-18","2018-06-01",113,0.85]
[null,"2018-19","2019-06-01",114.8,0.86]
[null,"2019-20","2020-06-01",114.4,0.86]
[null,"2020-21","2021-06-01",118.8,0.89]
[null,"2021-22","2022-06-01",126.1,0.94]
[null,"2022-23","2023-06-01",133.69999999999999,1]