Gutenberg Research
  • Home
  • Models
  • Education
    • Cooperative Education Program >
      • Enroll Today >
        • Program Enrollment (Virtual)
        • Program Enrollment (Bootcamp - Boston)
        • Program Enrollment (Bootcamp - New York)
      • Training Hub (Winter'22-'23) >
        • Meetings >
          • Kick-off Call/Orientation (Winter'22-'23)
          • Meeting 1: Building the Model (Winter'22-'23)
          • Meeting 2: Entering Your Forecast Into The Model (Winter'22-'23)
          • Meeting 3: Target Valuation (Winter'22-'23)
          • Meeting 4: Live Starbucks Release (Winter'22-'23)
          • Meeting 5: Live FOMC Policy Release & ERP Update (Winter'22-'23)
        • Classes >
          • Class 1 - Introduction to Financial Modeling (Winter'22-'23)
          • Class 2 - Building the Income Statement (Winter'22-'23)
          • Class 3 - Balance Sheet and Cash Flow Modeling (Winter'22-'23)
          • Class 4 - Model Calibration & Forecasting (Winter'22-'23)
          • Class 5 - The DCF Inputs: Beta, ERP, CAPM, & WACC (Winter'22-'23)
          • Class 6 - Discounted Cash Flow Valuation (Winter'22-'23)
          • Class 7 - Market Multiple-Based Valuation (Winter'22-'23)
          • Class 8 - How to Use Your Earnings Model (Winter'22-'23)
    • Books >
      • Procrastinator's Guide - SBUX >
        • Templates - SBUX
      • Book Registration - Third Edition >
        • Templates - Third Edition
      • Book Registration - Second Edition >
        • Templates - Second Edition
  • About
    • Contact
    • Email Distribution Sign-up
    • Terms of Use
    • Privacy Policy

Contributor Model Estimates - Anadarko Petroleum (NYSE:APC)

Author: Jonathan Jankoski, Published: November 28, 2016 at 10:00pm, View on Anadarko: Neutral
​
​Summary of Model Estimates: In my version of the Anadarko model I have adjusted the future sales price of oil and condensates downward to reflect the fact that Iraq and Iran have failed to agree with OPEC nations on output cuts. In addition, Saudi Arabia recently announced that they are considering not cutting output. With this backdrop, the probability for output cuts is likely lower than originally anticipated.

​I have updated my earnings model to reflect the price estimates from the CME Group’s price quotes for crude oil futures (as of November 28, 2016) which include the following:
  • December 2016: Current price of $46.50 per barrel.
  • March 2017: $48.38 per barrel.
  • June 2017: $50.49 per barrel. 
  • September 2017:  $50.92 per barrel.  
  • December 2017:  $51.24 per barrel.
In addition to these changes, I have also changed the United States average natural gas sales price (USD per Mcf) to reflect the CME Group’s Henry Hub natural gas futures prices:
•    December 2016: Current price of $3.287  
•    March 2017: $3.294 per Mcf
•    June 2017: $3.261 per Mcf
•    September 2017: $3.269 per Mcf
•    December 2017: $3.450 per Mcf

As a result of my estimates for Oil and Natural Gas the next-twelve month Adjusted EBITDAX increased to $6.5B and the implied share price target increased to $62 which reflects a 9x Price-to-EBITDAX multiple, plus net cash per share of $9.55. Using historic monthly average returns of just over 1% with a standard deviation of 12.4% I estimate an implied price band of $53 to $72 per share. 
Jonathan Jankoski Model.xlsx
File Size: 89 kb
File Type: xlsx
Download File


The author of this article has no financial investment or other conflict of interest related to the subject company or other companies discussed. Any views made or implied in this article represent the author’s opinions. Click here to visit Jonathan's contributor page.

Share on StockTwits
submit to reddit
Tweet
Gutenberg Research is a media and education company. The information presented on our website and within Gutenberg Research models, files, or other content does not represent investment advice. Data and information presented on this website, or on third party websites posted by us, within our models, files, and other content is for demonstration only, and is presented “as is”. Neither Gutenberg Research nor any Gutenberg Research agents or associates are liable for any errors, delays, incompleteness of data presented, or for actions taken based on reliance on any information contained on this website or within Gutenberg Research models or other content. Investors should consult a professional investment adviser prior to making investment decisions. By accessing this site and/or receiving our models or other content you are deemed to have read and agreed to our Terms of Use posted on this website. This website uses Cookies, refer to our Privacy Policy for details. The Gutenberg Research logo is among the registered and unregistered trademarks of Gutenberg Research LLC. © Gutenberg Research LLC 2023. All Rights Reserved.