Value Analysis: Cenovus Energy Inc. (CVE / NYSE)

In [9]:
from IPython.display import HTML

HTML('''<script>
code_show=true; 
function code_toggle() {
if (code_show){
$('div.input').hide();
} else {
$('div.input').show();
}
code_show = !code_show
} 
$( document ).ready(code_toggle);
</script>
<form action="javascript:code_toggle()"><input type="submit" value="Hide/Show code blocks"></form>''')
Out[9]:
In [10]:
import pandas as pd
import quandl
import math

I_FILE = './CVE Income Statement.csv'
BS_FILE = './CVE Balance Sheet.csv'
CF_FILE = './CVE Cash Flow.csv'
TRADING_DATE = '2018-03-19'
SHARE_CURRENCY = 'USD'
FIN_CURRENCY = 'CAD'
SHR_FIN_EXCHANGE_RATE = 1.29
PRICE_PER_SHARE = 8.45
TOTAL_SHARES = 500

FIRST_YEAR = 2013
LAST_YEAR = 2017
LAST_FIELD = '2017-12'

# In million USD
MARKET_CAP = 10494

# In million shares
SHARES_OUTSTANDING = 1229

i_df = pd.read_csv(I_FILE, index_col=0, header=1, mangle_dupe_cols=True)
bs_df = pd.read_csv(BS_FILE, index_col=0, header=1)
cf_df = pd.read_csv(CF_FILE, index_col=0, header=1)

def fnum(num):
    """ Format number 1000 to 1,000"""
    return "{0:,.0f}".format(int(num))

def fnum1(num):
    """ Format number 0.501231323 to 0.50"""
    return "{0:,.2f}".format(num)

def get_value(df, field, month=LAST_FIELD):
    if field not in df.index:
#         print(field, "not found")
        return 0.0
    else:
        value = df.loc[[field], month].iloc[0]
        if math.isnan(value):
#             print(field, "is NaN")
            value = 0.0
        return value

def get_mean(df, field):
    value = df.loc[[field]].iloc[0, :5].mean()
    return value

# Share price for calculation i.e. in Financial report's currency.
shr_price = PRICE_PER_SHARE * SHR_FIN_EXCHANGE_RATE

# This is calculated in share's currency as it is display-only.
total_purchase = PRICE_PER_SHARE * TOTAL_SHARES

# Earnings per Share - Diluted
eps_last = i_df.loc[['Diluted'], '2017-12'].iloc[0]
eps_1 = i_df.loc[['Diluted'], '2013-12'].iloc[0]
eps_2 = i_df.loc[['Diluted'], '2014-12'].iloc[0]
eps_3 = i_df.loc[['Diluted'], '2015-12'].iloc[0]
eps_4 = i_df.loc[['Diluted'], '2016-12'].iloc[0]
eps_mean = i_df.loc[['Diluted']].iloc[0, :5].mean()

# Weighted Average Shares Outstanding - Diluted
shares_last = i_df.loc[['Diluted'], '2017-12'].iloc[1]
shares_mean = i_df.loc[['Diluted']].iloc[1, :5].mean()

# Total Stockholders' Equity or Book Value
book_last = bs_df.loc[["Total Stockholders' equity"], '2017-12'].iloc[0]
book_1 = bs_df.loc[["Total Stockholders' equity"], '2013-12'].iloc[0]
book_2 = bs_df.loc[["Total Stockholders' equity"], '2014-12'].iloc[0]
book_3 = bs_df.loc[["Total Stockholders' equity"], '2015-12'].iloc[0]
book_4 = bs_df.loc[["Total Stockholders' equity"], '2016-12'].iloc[0]
book_mean = bs_df.loc[["Total Stockholders' equity"]].iloc[0, :5].mean()

# Book to Share
bs_last = book_last / SHARES_OUTSTANDING
bs_mean = book_mean / SHARES_OUTSTANDING

# Price to Book ratio
pb_last = shr_price / bs_last
pb_mean = shr_price / bs_mean

# Price to Earnings ratio
pe_last = shr_price / eps_last
pe_mean = shr_price / eps_mean

# Operational Earnings per share
oes_last = cf_df.loc[["Net cash provided by operating activities"], '2017-12'].iloc[0]
oes_mean = cf_df.loc[["Net cash provided by operating activities"]].iloc[0, :5].mean()

# Price to Operational Earnings ratio
poe_last = MARKET_CAP / oes_last
poe_mean = MARKET_CAP / oes_mean

# Dividends
dvd_last = -1*cf_df.loc[["Cash dividends paid"], '2017-12'].iloc[0]
dvd_1 = -1*cf_df.loc[["Cash dividends paid"], '2013-12'].iloc[0]
dvd_2 = -1*cf_df.loc[["Cash dividends paid"], '2013-12'].iloc[0]
dvd_3 = -1*cf_df.loc[["Cash dividends paid"], '2013-12'].iloc[0]
dvd_4 = -1*cf_df.loc[["Cash dividends paid"], '2013-12'].iloc[0]
dvd_mean = -1*cf_df.loc[["Cash dividends paid"]].iloc[0, :5].mean()

# Earnings Manipulation Detection with Scaled Net Operating Assets (SNOA)
total_assets = bs_df.loc[["Total assets"], '2017-12'].iloc[0]
cash_eq = bs_df.loc[["Cash and cash equivalents"], '2017-12'].iloc[0]
op_assets = total_assets - cash_eq

st_debt = get_value(bs_df, "Short-term debt")
lt_debt = get_value(bs_df, "Long-term debt")
minority_interest = get_value(bs_df, "Minority interest")
preferred_stock = get_value(bs_df, "Preferred stock")
total_liabilities = get_value(bs_df, "Total liabilities")
net_assets = total_assets - total_liabilities # == book common equity

op_liabilities = total_assets - st_debt - lt_debt - minority_interest - preferred_stock - net_assets

total_assets_prev = get_value(bs_df, "Total assets", month='2016-12')
snoa = (op_assets - op_liabilities) / float(total_assets_prev)

Overview

Trading date: {{TRADING_DATE}}
Price per share: {{SHARE_CURRENCY}} {{fnum1(PRICE_PER_SHARE)}}
Total shares: {{TOTAL_SHARES}}
Total purchase: {{SHARE_CURRENCY}} {{fnum(total_purchase)}}

Market Cap: {{fnum(MARKET_CAP)}} (in million USD)

Scaled Net Operating Assets: {{fnum1(snoa)}}

Website: https://www.cenovus.com/

A Canadian oil company that got bashed over its acquisition of assets from ConocoPhilips in May 17, 2017. The asset was worth almost \$18b while the entire company was worth \$15b. Shareholders were enraged over the fact that a part of the deal were purchased by issuing common stocks (thereby diluting shareholder shares in the process). They were also worried about the amount of debt they used to finance this purchase.

Relevant news:

Fundamental Data

Fundamental data were gathered from Morningstar. Screenshots are available in the Appendixes section of this article. In this section, we will get into the details of our analysis and our considerations.

All prices are in millions {{FIN_CURRENCY}}.

P/B Ratio

  • Mean Book Value ({{FIRST_YEAR}} - {{LAST_YEAR}}): {{fnum(book_mean)}} ({{fnum(book_1)}}, {{fnum(book_2)}}, {{fnum(book_3)}}, {{fnum(book_4)}}, {{fnum(book_last)}})
  • P/B Ratio (mean): {{fnum1(pb_mean)}}
  • P/B Ratio ({{LAST_YEAR}}): {{fnum1(pb_last)}}

P/B ratio of the last year was much less than 1.0 which means the assets are likely to cover all common shares. The significant increase between 2016 and 2017 shown an increase in assets as described in 2017 annual report.

P/E Ratio

  • Mean Earnings per Share ({{FIRST_YEAR}} - {{LAST_YEAR}}): {{fnum1(eps_mean)}} ({{fnum1(eps_1)}}, {{fnum1(eps_2)}}, {{fnum1(eps_3)}}, {{fnum1(eps_4)}}, {{fnum1(eps_last)}})
  • P/E Ratio (mean): {{fnum1(pe_mean)}}
  • P/E Ratio ({{LAST_YEAR}}): {{fnum1(pe_last)}}
  • Price / Operational Earning Ratio (mean): {{fnum1(poe_mean)}}
  • Price / Operational Earning Ratio ({{LAST_YEAR}}): {{fnum1(poe_last)}}

P/E Ratio was under 15 times, still considered cheap. We also tried using Operational Earnings as denominator with which we hoped to capture a more accurate view of the company's earnings.

Annual Report 2017

Interesting quotes:

2017 was a year of significant change for Cenovus, where we gained full ownership of our oil sands assets, acquired an additional core operating area in the Deep Basin and divested the majority of our legacy Conventional assets. On May 17, 2017, we acquired from ConocoPhillips Company and certain of its subsidiaries (collectively, “ConocoPhillips”) their 50 percent interest in the FCCL Partnership (“FCCL”), and the majority of ConocoPhillips’ western Canadian conventional assets in the Deep Basin in Alberta and British Columbia for total consideration of $17.9 billion (“the Acquisition”).

This paragraph describes the assets that were purchased.

In December 2017, we also commenced marketing for sale certain non-core assets located in the East and West Clearwater areas of the Deep Basin, representing approximately 15,000 BOE per day of production, to further streamline our portfolio and deleverage our balance sheet.

Over the course of 2017, Cenovus has transitioned its asset base and strategy to support focused development in the oil sands and Deep Basin, providing opportunities for disciplined growth and long-term cash flow generation.

Change of strategy, focusing on core business.

At the same time, investor concern about the Acquisition, volatile commodity prices and a number of other factors contributed to a more than 40 percent decline in our share price.

This sentence may be cross-checked with the news articles above.

Over the last few months, Cenovus has made considerable progress in reducing debt and is taking steps to right-size the Company for the current environment. Effective November 6, 2017, Alex Pourbaix was appointed Cenovus’s President and Chief Executive Officer, and he subsequently announced changes to the senior leadership team in December 2017.

Just an interesting note about the change of management.

Dividends

  • Mean dividends paid ({{FIRST_YEAR}} - {{LAST_YEAR}}): {{dvd_mean}} ({{fnum1(dvd_1)}}, {{fnum1(dvd_2)}}, {{fnum1(dvd_3)}}, {{fnum1(dvd_4)}}, {{fnum1(dvd_last)}})

Industry Outlook

One of the risks with this investment is if the world is moving away from oil usage. Some studies:

Quora answer by Berkeley professor Richard A Muller (positive. We will stick with oil for some good years ahead):

The advantages of gasoline are so great, that I predict we will stick with it for mobile transportation. We will cut its CO2 emissions in half, maybe by ⅔, by more efficient automobiles. We will attack CO2 emissions primarily in industry and electric power generation by severely reducing the use of coal. Coal will be replaced by energy conservation (“megawatts”), shale gas, and nuclear power. Solar and wind will contribute, but not as much as many people would like, because their expense will remain too high for most of the developing world. I expect that the major use of coal will eventually become the manufacture of gasoline. Yes, it will still contribute to global warming, but at a pace that is much reduced.

I am not advocating this future. I am simply trying to evaluate objectively the direction that I see an economically-driven world moving. Most of the world will use oil because of its low expense and convenience. The pace of global warming will slow as we use fossil fuels more efficiently and build nuclear capability, and most of the developing countries will decide that adaptation to increased warmth is a better option than expensive and inconvenient energy.

Oil usage and projection statistics (negative. The demand projection stagnates, while supply would be excessive):

1.png 2.png

Appendixes

CVE-income.png

CVE-balance-sheet.png

CVE-cashflow.png

In [11]:
i_df
Out[11]:
2013-12 2014-12 2015-12 2016-12 2017-12 TTM
Fiscal year ends in December. CAD in millions except per share data.
Revenue 18993.00 20107.00 13207.00 12282.00 17314.00 17314.00
Cost of revenue 14642.00 16009.00 11417.00 10722.00 14002.00 14002.00
Gross profit 4351.00 4098.00 1790.00 1560.00 3312.00 3312.00
Costs and expenses NaN NaN NaN NaN NaN NaN
Research and development NaN NaN NaN 36.00 36.00 36.00
Sales, General and administrative 349.00 358.00 335.00 326.00 308.00 308.00
Depreciation and amortization 1833.00 1946.00 2114.00 1498.00 1838.00 1838.00
Interest expense 369.00 307.00 328.00 341.00 571.00 571.00
Other operating expenses 706.00 292.00 -1524.00 286.00 -1657.00 -1657.00
Total costs and expenses 3257.00 2903.00 1253.00 2487.00 1096.00 1096.00
Income before income taxes 1094.00 1195.00 537.00 -927.00 2216.00 2216.00
Provision for income taxes 432.00 451.00 -81.00 -382.00 -52.00 -52.00
Net income from continuing operations 662.00 744.00 618.00 -545.00 2268.00 2268.00
Net income from discontinuing ops NaN NaN NaN NaN 1098.00 1098.00
Net income 662.00 744.00 618.00 -545.00 3366.00 3366.00
Net income available to common shareholders 662.00 744.00 618.00 -545.00 3366.00 3366.00
Earnings per share NaN NaN NaN NaN NaN NaN
Basic 0.88 0.98 0.75 -0.65 3.05 3.05
Diluted 0.87 0.98 0.75 -0.65 3.05 3.05
Weighted average shares outstanding NaN NaN NaN NaN NaN NaN
Basic 756.00 757.00 819.00 833.00 1102.00 1102.00
Diluted 758.00 758.00 819.00 833.00 1102.00 1102.00
EBITDA 3296.00 3448.00 2979.00 912.00 4817.00 4817.00
In [12]:
bs_df
Out[12]:
2013-12 2014-12 2015-12 2016-12 2017-12
Fiscal year ends in December. CAD in millions except per share data.
Assets NaN NaN NaN NaN NaN
Current assets NaN NaN NaN NaN NaN
Cash NaN NaN NaN NaN NaN
Cash and cash equivalents 2452.0 883.0 4105.0 3720.0 610.0
Total cash 2452.0 883.0 4105.0 3720.0 610.0
Receivables 1834.0 1610.0 149.0 111.0 361.0
Inventories 1259.0 1224.0 810.0 1237.0 1389.0
Prepaid expenses 55.0 NaN 71.0 127.0 158.0
Other current assets 10.0 478.0 1338.0 1627.0 2490.0
Total current assets 5610.0 4195.0 6473.0 6822.0 5008.0
Non-current assets NaN NaN NaN NaN NaN
Property, plant and equipment NaN NaN NaN NaN NaN
Gross property, plant and equipment 35652.0 38716.0 39630.0 40192.0 37675.0
Accumulated Depreciation -16845.0 -18528.0 -20720.0 -22181.0 -4406.0
Net property, plant and equipment 18807.0 20188.0 18910.0 18011.0 33269.0
Equity and other investments NaN NaN 46.0 35.0 37.0
Goodwill 739.0 242.0 242.0 242.0 2272.0
Other long-term assets 68.0 70.0 120.0 148.0 347.0
Total non-current assets 19614.0 20500.0 19318.0 18436.0 35925.0
Total assets 25224.0 24695.0 25791.0 25258.0 40933.0
Liabilities and stockholders' equity NaN NaN NaN NaN NaN
Liabilities NaN NaN NaN NaN NaN
Current liabilities NaN NaN NaN NaN NaN
Accounts payable 102.0 51.0 68.0 105.0 337.0
Short-term debt NaN NaN NaN 50.0 NaN
Income taxes payable 268.0 357.0 133.0 112.0 129.0
Accrued liabilities 2515.0 2427.0 1486.0 2041.0 2144.0
Deferred revenues 233.0 NaN NaN NaN 94.0
Other current liabilities 661.0 122.0 171.0 363.0 1732.0
Total current liabilities 3779.0 2957.0 1858.0 2671.0 4436.0
Non-current liabilities NaN NaN NaN NaN NaN
Long-term debt 4997.0 5458.0 6525.0 6332.0 9513.0
Deferred taxes liabilities 2862.0 3302.0 2816.0 2585.0 5613.0
Pensions and other postretirement benefits NaN NaN 66.0 71.0 62.0
Other long-term liabilities 3640.0 2792.0 2135.0 2009.0 1328.0
Total non-current liabilities 11499.0 11552.0 11542.0 10997.0 16516.0
Total liabilities 15278.0 14509.0 13400.0 13668.0 20952.0
Stockholders' equity NaN NaN NaN NaN NaN
Additional paid-in capital 8076.0 8180.0 9864.0 9884.0 15401.0
Retained earnings 1660.0 1599.0 1507.0 796.0 3937.0
Accumulated other comprehensive income 210.0 407.0 1020.0 910.0 643.0
Total Stockholders' equity 9946.0 10186.0 12391.0 11590.0 19981.0
Total liabilities and stockholders' equity 25224.0 24695.0 25791.0 25258.0 40933.0
In [13]:
cf_df
Out[13]:
2013-12 2014-12 2015-12 2016-12 2017-12 TTM
Fiscal year ends in December. CAD in millions except per share data.
Cash Flows From Operating Activities NaN NaN NaN NaN NaN NaN
Net income 662.0 744.0 618.0 -545.0 3366.0 3366.0
Depreciation & amortization 1833.0 1946.0 2114.0 1498.0 2030.0 2030.0
Investment/asset impairment charges NaN 497.0 NaN 30.0 NaN NaN
Deferred income taxes 244.0 359.0 -655.0 -209.0 583.0 583.0
Other working capital -70.0 47.0 -217.0 -562.0 145.0 145.0
Other non-cash items 870.0 -67.0 -386.0 649.0 -3065.0 -3065.0
Net cash provided by operating activities 3539.0 3526.0 1474.0 861.0 3059.0 3059.0
Cash Flows From Investing Activities NaN NaN NaN NaN NaN NaN
Investments in property, plant, and equipment -3269.0 -3058.0 -1714.0 -1034.0 -1670.0 -1670.0
Acquisitions, net 258.0 276.0 3260.0 8.0 -11355.0 -11355.0
Other investing activities 1492.0 -1568.0 -658.0 -53.0 159.0 159.0
Net cash used for investing activities -1519.0 -4350.0 888.0 -1079.0 -12866.0 -12866.0
Cash Flows From Financing Activities NaN NaN NaN NaN NaN NaN
Debt issued 814.0 NaN NaN NaN 3842.0 3842.0
Debt repayment -825.0 NaN NaN NaN -3600.0 -3600.0
Common stock issued 28.0 28.0 1449.0 NaN 2899.0 2899.0
Cash dividends paid -732.0 -805.0 -528.0 -166.0 -225.0 -225.0
Other financing activities -11.0 -20.0 -27.0 -2.0 3599.0 3599.0
Net cash provided by (used for) financing activities -726.0 -797.0 894.0 -168.0 6515.0 6515.0
Effect of exchange rate changes -2.0 52.0 -34.0 1.0 182.0 182.0
Net change in cash 1292.0 -1569.0 3222.0 -385.0 -3110.0 -3110.0
Cash at beginning of period 1160.0 2452.0 883.0 4105.0 3720.0 3720.0
Cash at end of period 2452.0 883.0 4105.0 3720.0 610.0 610.0
Free Cash Flow NaN NaN NaN NaN NaN NaN
Operating cash flow 3539.0 3526.0 1474.0 861.0 3059.0 3059.0
Capital expenditure -3269.0 -3058.0 -1714.0 -1034.0 -1670.0 -1670.0
Free cash flow 270.0 468.0 -240.0 -173.0 1389.0 1389.0