Trending stocks

Canadian Natural Resources Ltd EBITDA dropped on 36.0% in 2016 and Revenue dropped on 20.4%

02.03.2017 • About Canadian Natural Resources Ltd ($CNQ) • By InTwits

Canadian Natural Resources Ltd reported 2016 financial results today. Overall the company's long term financial model is characterised by the following facts:
  • Canadian Natural Resources Ltd is a company in decline: 2016 revenue growth was -20.4%, 5 years revenue CAGR was -5.1%
  • Canadian Natural Resources Ltd has high CAPEX intensity: 5 year average CAPEX/Revenue was 43.3%. At the same time it's in pair with industry average of 45.3%.
  • CAPEX is quite volatile: 3,797 in 2016, 4,468 in 2015, 11,398 in 2014, 7,211 in 2013, 6,104 in 2012
  • The company has unprofitable business model: ROIC is at -2.7%
  • It operates with medium-size leverage: Net Debt/EBITDA is 4.7x while industry average is 4.3x
Below you can find a comprehensive analysis of the key data driving the company's performance and stock price.

Canadian Natural Resources Ltd ($CNQ) key annual financial indicators

mln. CAD201220132014201520162016/2015
P&L
Revenue14,52416,10119,11313,20610,515-20.4%
Gross Profit7,5238,60410,6166,1014,413-27.7%
SG&A270335367390345-11.5%
EBITDA7,3168,25210,1275,5843,571-36.0%
Net Income1,8922,2703,929-637-204
Balance Sheet
Cash3716256917-75.4%
Short Term Debt7981,4449801,7291,8124.8%
Long Term Debt7,9388,21713,02215,06514,993-0.5%
Cash flow
Capex6,1047,21111,3984,4683,797-15.0%
Ratios
Revenue growth6.2%10.9%18.7%-30.9%-20.4%
EBITDA growth-5.5%12.8%22.7%-44.9%-36.0%
Gross Margin51.8%53.4%55.5%46.2%42.0%-4.2%
EBITDA Margin50.4%51.3%53.0%42.3%34.0%-8.3%
Net Income Margin13.0%14.1%20.6%-4.8%-1.9%2.9%
SG&A, % of revenue1.9%2.1%1.9%3.0%3.3%0.3%
CAPEX, % of revenue42.0%44.8%59.6%33.8%36.1%2.3%
ROIC7.3%8.0%10.9%0.2%-2.7%-2.9%
ROE8.0%9.1%14.4%-2.3%-0.8%1.5%
Net Debt/EBITDA1.2x1.2x1.4x3.0x4.7x1.7x


Canadian Natural Resources Ltd ($CNQ) key quoterly financial indicators

mln. CAD16Q116Q216Q316Q4YoY change
P&L
Revenue2,1822,5032,3583,472-33.7%-28.3%-30.2%13.9%
EBITDA4117737281,659-65.5%-52.0%-55.1%42.8%
Net Income-105-339-326566332.1%
Balance Sheet
Cash15241917-55.9%-25.0%-36.7%-75.4%
Short Term Debt9732,4052,0981,812-41.6%93.0%25.4%4.8%
Long Term Debt15,59114,83115,19414,99311.2%0.6%2.4%-0.5%
Ratios
Gross Margin29.8%40.8%39.0%52.5%28.4%-7.2%-10.5%8.1%
EBITDA Margin 18.8% 30.9% 30.9% 47.8%-17.4%-15.2%-17.1%9.7%
Net Income Margin -4.8% -13.5% -13.8% 16.3%2.8%-1.9%-10.5%12.0%

Revenue and profitability


Canadian Natural Resources Ltd's Revenue dropped on 20.4%. Annual revenue decline showed slowdown in 16Q4 - revenue jumped on 13.9%. Revenue decline was worsened by EBITDA margin decline. EBITDA Margin decreased on 8.3 pp from 42.3% to 34.0% in 2016.

Gross Margin decreased on 4.2 pp from 46.2% to 42.0% in 2016. SG&A as a % of Revenue showed almost no change in 2016.

Net Income marign increased on 2.9 pp from -4.8% to -1.9% in 2016.

Capital expenditures (CAPEX) and working capital investments


In 2016 Canadian Natural Resources Ltd had CAPEX/Revenue of 36.1%. CAPEX/Revenue decreased on 8.7 pp from 44.8% in 2013 to 36.1% in 2016. For the last three years the average CAPEX/Revenue was 43.2%.Battling declining revenue Canadian Natural Resources Ltd made large investments to CAPEX (106% of EBITDA) but that didn't help at least in this year.

Return on investment


The company operates at negative ROIC (-2.66%) and ROE (-0.76%). ROIC decreased on 2.9 pp from 0.19% to -2.7% in 2016. ROE increased slightly on 1.5 pp from -2.3% to -0.76% in 2016.

Leverage (Debt)


Debt level is 4.7x Net Debt / EBITDA and 4.7x Debt / EBITDA. Net Debt / EBITDA jumped on 1.7x from 3.0x to 4.7x in 2016. Debt showed almost no change in 2016 while cash dropped on 75.4%.

Appendix 1: Peers in Energy


Below we provide Canadian Natural Resources Ltd benchmarking against other companies in Energy industry for the last 5 years. We show data for the top-5 companies by key financial metric together with the median value for all the companies in the industry.

Top companies by Revenue growth, %

Top 5 FY2012 FY2013 FY2014 FY2015 FY2016
Oryx Petroleum Corp Ltd ($OXC)-18.4%141.2%
Seven Generations Energy Ltd ($VII)115.7%340.2%39.0%94.4%
Athabasca Oil Corp ($ATH)342.7%5.5%-22.9%73.1%
Painted Pony Petroleum Ltd ($PPY)41.3%56.0%-42.5%60.7%
ONEnergy Inc ($OEG)6,002.6%231.5%57.4%
 
Median (116 companies)16.2%16.9%-27.7%-18.0%
Canadian Natural Resources Ltd ($CNQ)10.9%18.7%-30.9%-20.4%


Top companies by Gross margin, %

Top 5 FY2012 FY2013 FY2014 FY2015 FY2016
Americas Petrogas Inc ($BOE)77.1%43.3%-34.3%121.1%
TransAlta Renewables Inc ($RNW)94.4%94.5%94.5%91.1%
Serinus Energy Inc ($SEN)80.5%76.5%86.8%88.5%
Advantage Oil & Gas Ltd ($AAV)62.0%84.5%92.5%88.5%90.3%
Polaris Infrastructure Inc ($PIF)39.9%33.6%32.0%86.7%88.6%
 
Median (114 companies)32.0%32.1%32.2%33.6%31.5%
Canadian Natural Resources Ltd ($CNQ)51.8%53.4%55.5%46.2%42.0%


Top companies by EBITDA margin, %

Top 5 FY2012 FY2013 FY2014 FY2015 FY2016
Granite Oil Corp ($GXO)59.4%64.5%70.8%201.9%
Perpetual Energy Inc ($PMT)35.5%70.7%58.0%110.3%
Petro Rio SA ($PRJ)-4,809.7%-6,899.7%28.2%90.7%
Peyto Exploration & Development Corp ($PEY)86.1%83.2%86.3%84.6%80.7%
Innergex Renewable Energy Inc ($INE)111.8%110.0%82.9%83.4%83.5%
 
Median (128 companies)25.3%34.1%28.9%8.1%27.3%
Canadian Natural Resources Ltd ($CNQ)50.4%51.3%53.0%42.3%34.0%


Top companies by CAPEX/Revenue, %

Top 5 FY2012 FY2013 FY2014 FY2015 FY2016
Oryx Petroleum Corp Ltd ($OXC)1,997.8%712.8%
WesternZagros Resources Ltd ($WZR)385.6%
Athabasca Oil Corp ($ATH)2,426.4%596.6%504.7%315.2%83.7%
TORC Oil & Gas Ltd ($TOG)453.8%466.9%104.5%229.4%76.3%
Seven Generations Energy Ltd ($VII)452.8%513.1%227.4%191.2%73.5%
 
Median (129 companies)43.8%39.0%45.0%27.6%22.9%
Canadian Natural Resources Ltd ($CNQ)42.0%44.8%59.6%33.8%36.1%


Top companies by ROIC, %

Top 5 FY2012 FY2013 FY2014 FY2015 FY2016
Enerplus Corp ($ERF)-17.3%10.2%11.5%-55.5%16.3%
Whitecap Resources Inc ($WCP)7.1%8.1%9.6%-10.6%10.1%
Ecopetrol SA ($ECP)29.3%24.4%16.5%3.0%9.6%
Parkland Fuel Corp ($PKI)22.3%23.3%9.9%7.8%8.6%
Inter Pipeline Ltd ($IPL)9.5%8.0%7.5%9.6%8.5%
 
Median (128 companies)3.6%5.4%5.5%-8.5%-1.9%
Canadian Natural Resources Ltd ($CNQ)7.3%8.0%10.9%0.2%-2.7%


Top companies by Net Debt / EBITDA

Top 5 FY2012 FY2013 FY2014 FY2015 FY2016
BlackPearl Resources Inc ($PXX)-0.2x-0.1x0.2x3,726.1x-0.2x
Paramount Resources Ltd ($POU)14.6x23.9x8.9x421.5x-5.8x
Precision Drilling Corp ($PD)2.2x1.9x2.0x68.4x7.6x
Trican Well Service Ltd ($TCW)2.5x3.4x2.9x31.4x
Trilogy Energy Corp ($TET)2.6x1.8x2.3x25.5x7.3x
 
Median (78 companies)1.6x1.5x1.4x2.6x2.6x
Canadian Natural Resources Ltd ($CNQ)1.2x1.2x1.4x3.0x4.7x