This article is a continuation of the “Case Study on Oil Stocks”. Rather than look at the long term growth prospects and investment potential, we will look at oil companies from a short term trading perspective. To assist in performing the relevant calculations, I have designed a spreadsheet enabling a trader to gauge how much the earnings per share and book value per share change when the price of commodities change.
My first motivation for researching this area began when I traded oil and gas exploratory companies. I could not understand why, despite the lack of significant news, different exploratory companies were affected by the price of oil and gas differently. When I was trading a long/short pair in two oil companies, I starting losing money on my position. I asked a colleague of mine why one leg of the pair was rising so much faster than the other. He explained to me that it’s very simple. Company A mainly produces natural gas whereas company B mainly produces crude oil, and natural gas prices have dropped quite considerably in the past few months.
The methods that I have employed to choose my long short pair were based on fundamental analysis of the ratios described in the article “Advanced Equity Trading”. For the long position, I chose a stock which I believed had a low P/E, low forward P/E, low price to book, and a high return on capital, as well as other variables which I described in the article. Despite the pair having performed well I should have also checked to see if both companies had the same proportion of oil and gas with each other. This has the effect of hedging the oil exposure and instead creates the return on the long/short position on other ,non oil, related factors.
After having created the relative value table for oil companies, one needs to carefully choose which companies to long and short. The second step is to see how well correlated the two companies are with oil and natural gas. For this reason I have created the oil and gas company evaluator, which holds volume of reserves constant against the variable, price. The aim of this sensitivity gauge is simply to see how much net income or earnings per share and book value per share change for any fluctuation in the price of oil and natural gas.
The spreadsheet is split into 3 components. The commodity price inputs, balance sheet and income statement inputs, and the theoretical changes in book value and earnings that these changes will produce. All the input fields are highlighted in yellow. The rest of the variables are calculated by based on changes in the yellow cells.
Click Here to Download the Spreadsheet
Begin with the annual report of the company. We need to understand the income statement and fill out the necessary fields in the spaces provided. If we look at W&T Offshore, we can go to page 52 of its 2006 annual report and read the income statement. The income statement will specify its revenues and costs. We do not need to input the revenues but we do need to put in the total costs and expenses in the costs field which is C27. In WTI’s case this will be 482,851,000 USD in operating expenses and 11,261,000 USD in net capitalized interest expenses (this is calculated by subtracting 13,238,000 USD in capitalized expenses from 30,418,000 in incurred expenses and adding back “other income” to arrive at (30,418,000-13,238,000+5919000=11,261,000).
We need to input the price of the stock in cell C11. We then need to put in the sales volume information which is on page 32 of the report. WTI produced 60,447,000 Mcf of natural gas and 6,456 MBbls of oil. We fill this data in cells C38 and C40. Now we can simply calculate the EPS for WTI using the average prices on page 32 or simply changing the prices in fields D2 to D4 and E2 to E4. This is especially useful if there has been some news that the price of oil and gas has changed. We can input the figures for yesterdays oil prices and today,s and calculate the theoretical amount that the stocks EPS will rise as a result of the price changes in commodities. I have split up the EPS effects of oil and natural gas separately as well as a total for both changes. This allows the trader to gauge how much each commodity should have an effect on the price of the stock. Furthermore it also allows us to find put how the P/E of the stock changes with varying oil and natural gas prices.
The same principal is applied when evaluating the book value per share on the company. First we need to input the proven and unproved reserves for oil and gas in fields C30 and C32. This can be extracted from the annual report on page 71.
Cell C13 contains the total current assets which can be extracted from the annual report. “Other Long term Assets” is simply the furniture and other office buildings which is contained in the balance sheet. Restricted assets in cell C15 is labeled as “Restricted deposits for asset retirement obligations”.
We excluded oil and gas properties of the company because we want the input to be from the price variations and reserve sizes in cells C30 to C32. Cell 17 is the total liabilities of the company, which is the sum of short term and long term liabilities. If anyone needs to see the behind the scenes calculations simply unhide rows 7-9 and 19-26.
This model allows us to vary the oil and gas prices to see how book value and EPS change. It is useful for a trader who wants to gauge sensitivity of an oil company’s price to changes in oil and gas commodity prices.
As a more advanced tool the spreadsheet could also be used to evaluate how much the earnings of the company will change if the company changes guidance on production.
For example on July 13th 2007 there was a press release that WTI is revising its second quarter and full year production guidance. For example for crude oil the prior guidance was 8.1-8.5 MMBbls of oil for the full year, the revised quantity is 7.7-8.0. Similarly the prior guidance for natural gas was 84.1-88.7 Bcf, the revised quantity is 74.7-78.7 Bcf.
To gauge how much theoretically the price of WTI should drop following the press release we need to change 2 main variables. Changes in the size of reserves and prices of commodities. For the sake of simplicity we will replace the updated reserves with the higher end values. For example crude oil’s prior guidance was 8.1-8.5; we will input the prior value as 8.5 MMBbls. Similarly the revised guidance is expressed as 7.7-8.0; we will input a value of 8.0. To calculate the EPS using the guidance expected the day before the press release we need to find out how much the price of oil and gas was on July 12th 07 and input these values in fields D2 and D4. The price of the front end contract for oil and natural gas was 72.5 and 6.50 USD respectively. Now we input the quantities 88,700,000 and 8,500,000 in cells C36 and C40 respectively. The EPS Values we will get is 6.47 USD per share. If we now change the reserves to 80,000,000 and 78,700,000 respectively and change the natural gas and oil price to 6.66 and 73.93 USD we will arrive at an EPS of 5.70 USD per share. This implies a 12% decrease earnings for WTI.
If one wants to simply change the prices of commodities in cells D2 to E4 without changing reserves one can arrive at a percentage change in book value and earnings in column I.
Did you like this article?
It is very nice article for
The problem is Sheva can be
Hi there I had read you post
You have given such brilliant ideas and its very nice.
In reading your article I had learned a lot.
I am able to understand the topic and I am really inspired.
Thanks so much for sharing this, you have helped me so much.
I hope to see more of your posts here.
IRVINE Ca Homes For Sale | Ca Homes For Sale 3.5% FHA Ca Homes For Sale | RIVERSIDE Ca Homes For Sale 100% VA STOCKTON Ca Homes For Sale | TEMECULA Ca Homes For Sale Zero Down USDA BEVERLY HILLS Ca Homes For Sale | PALM SPRINGS Ca Homes For Sale Half Percent Down FREMONT Ca Homes For Sale | HUNTINGTON BEACH Ca Homes For Sale 203 K FHA MODESTO Ca Homes For Sale | MORENO VALLEY Ca Homes For Sale Conventional Loans MURRIETA Ca Homes For Sale | PALMDALE Ca Homes For Sale Jumbo Loans PASADENA Ca Homes For Sale | SANTA ROSA Ca Homes For Sale City Down Payment TRACY Ca Homes For Sale | Anaheim Ca Homes For Sale 2yr BK Discharge OK BERKELEY Ca Homes For Sale | PreQualification Mortgage Calculator <620 FICO with No 12 mo lates PreQualification Mortgage Calculator | ELK GROVE Ca Homes For Sale 620+ FICO Ok SAN RAMON Ca Homes For Sale | SANTA MONICA Ca Homes For Sale 6% Seller Credit OK FONTANA Ca Homes For Sale | LAKE ELSINORE Ca Homes For Sale 30 Yr Fixed PALO ALTO Ca Homes For Sale | RANCHO CUCAMONGA Ca Homes For Sale 15 Yr Fixed SANTA ANA Ca Homes For Sale | SUNNYVALE Ca Homes For Sale 20 Yr Fixed TORRANCE Ca Homes For Sale | VICTORVILLE Ca Homes For Sale 5 Yr Adjustable WALNUT CREEK Ca Homes For Sale | ANTIOCH Ca Homes For Sale 7 Yr Adjustable BURBANK Ca Homes For Sale | GLENDALE Ca Homes For Sale 10 Yr Adjustable
Gucci Cruise Joy Medium
make money online earn
generic cialis
buy viagra
avodart
propecia
viagra
lumigan
careprost
generic cialis
generic levitra
propecia
シアリス
レビトラ
プロペシア
バイアグラ
ルミガン
ケアプロスト
アボダート
naperville dentist aurora dentist chicago movers online pharmacy web hosting provider about online trading the cost of credit cards why you should invest southwest airline credit card What is acid test ratio and ROA ratio? Free Your Mind and Check Your Credit Scores Online Seek Recommendations When Re-Financing The Importance of Diversification Credit card services Long Term Investments for the Future choosing a lender secured credit card Credit Cards For High School Students Investing for Retirement Ideal Offers For Credit Cards Credit Score Management and Information budgeting The Decision to Re-Finance Why You Should Invest Getting the Bait on Good Home Loan Terms Despite Bad Credit Score Credit Cards With Cash Rebate Personal Loan Scams How To Avoid Late Fees Revenue and receivables The Importance of Diversification Credit Score: Ways on How You Can Boost It Avoiding Impulse Spending Tips to Check and Improve Your Credit Score How to Know When to Sell Your Stocks Credit Cards And Credit Reports Is It Time to Re-Finance? Determining Where You Will Invest Small Business Credit Cards Student Credit Cards what is a corporation Does It Pay to Re-Finance? Credit card debt consolidation Finding Re-Financing Information Different Types of Bonds Parts of an Income Statement, Part 3 Bookkeeping Comparison Shopping When Re-Financing Vacation And Credit Cards Managing the Bottom Line What Is Your Investment Style? Rebates – Reward or Rip Off? Avoiding Impulse Spending Credit Score Rating Scale: How It Is Done and What It Does To You Types of Costs Options For Good Credit Cards Balance Sheet About Online Trading The Budget – The Ultimate Financial Management Tool Credit Score: Getting Your Bad Credit Rating Repaired Profit and Loss Is Re-Financing Worth the Hassle? The Range Towards a Successful Credit Application Online Personal Loans What is the FASB? High FICO Score on Credit Report Obtains Positive Responses Accept credit card Different Types of Stock What happened in corporate accounting scandals? Is business credit card helpful? Re-Financing to Consolidate Debt Credit Scores: What's It About and What Makes a Good Credit Score? Different Types of Investments Spend Wisely to Save Money Careers Making a Profit Personal Loan Research What is forensic accounting? Bank Secured Credit Cards Benefits of Re-Financing Collection Process on Personal Loans What are other ratios used in financial reporting High or Low: Keeping Track with National Average Credit Score How to analyze a financial statement Uses of Personal Loans Books on Personal Loans Credit Cards Without A Bank Account Check your Free Credit Report and Be Wary of your Score Is it ok to apply online for credit card? What Is Accounting Anyway? Spend Wisely to Save Money Credit card processing Investing and financing Online Re-Financing Different Types of Investments All about credit card rate Checking Mortgage Rates Online Online credit card Eliminate credit card debt Choosing a Fixed or ARM Option Re-Financing with an Interest Only Mortgage Basic Accounting Principles Unsecured Personal Loans Building Cash Reserves The Air Mile Credit Card Why Should I Make a Budget? Investing Basics – What Are Your Investment Goals Investment Strategy Personal Loan Insurance Determining Where You Will Invest Long Term Investments for the Future Free Credit Report: Know About Your Credit Score For Free Envision a Better Life by Increasing Your Credit Score Understanding Re-Financing Getting A Higher Limit On Your Credit Card What are partnerships and limited liability companies? Careers Is Re-Financing Always Worthwhile? Why Should I Make a Budget? Student credit cards Rebates – Reward or Rip Off? Should I apply for a credit card and how? Choosing Your Credit Card Bookkeeping Basics Personal Loan Collection Officer Credit Card Reward Cards Types of Personal Loans Parts of an Income Statement, part 1 What are independent auditors? Ways to Generate Funds without taking a Personal Loan Depreciation reporting Personal Loan Officers Quasar Software Comparing Credit Cards Choosing Your Reward Card When Is It a Mistake to Re-Finance? Understanding Bonds What is a Cash Out Re-Finance? About GAAP Accounting Principles Credit card Choosing a Broker How Much Money Should You Invest? Consolidate credit card debt Getting Your Credit Card Online Tax Considerations When Re-Financing Protecting Your Personal Information Re-Financing with an ARM Disclosure American Express Credit Cards Chase.com credit card offers Choosing A Broker How to Know When to Sell Your Stocks Need Information about Credit Scores? Try going ONLINE! Consolidate Your Credit Card Debt Your Credit Score Report is in Good Hands Things to Consider when Searching for a Personal Loan Re-Financing with Bad Credit Improving Your Credit Score: Ways to Do It Quickly Low interest credit cards What is a Personal Loan? How is accounting used in business? Getting Approved Instantly Online Inventory and expenses How Can Credit Score System Works for your Financial Needs? How To Improve Your Credit Score the Easy Way A bad credit credit card Are You Considering Re-Financing? Investing for Retirement The Budget – The Ultimate Financial Management Tool You and Your Credit Score: What's The Good Number? Credit card offer Investing Mistakes to Avoid Important Information on Credit Scoring and its Effects to You Different Types of Bonds The Importance of Average Credit Score in US Credit Card Fraud Investing Mistakes to Avoid Determine Your Risk Tolerance Credit Card Debt Being a Co-signer on a Personal Loan Assets and Liabilities Depreciation Determine Your Risk Tolerance What does an audit report contain? Educate yourself about Personal Loans on the Internet What does an audit do? Understanding Bonds Personal Loans vs. Home Equity Loans Measuring Costs Chase credit cards Gains and Losses Who uses forensic accountants? What are auditors? UK credit cards and balance transfers Personal Loans for Bad Credit Re-Financing with a Line of Credit Loan What is a sole proprietorship? Re-Financing with Shorter Loan Terms Improving your Credit Score is Just Three Steps Away Credit card deal Bad Credit Score: Effective Ways to Repair It What Is Your Investment Style? Rejection of credit card application What to do if you are Turned Down for a Personal Loan Investing Basics – What Are Your Investment Goals What is financial window dressing? Getting Your Feet Wet – Begin Investing All about college credit cards Ways to Eliminate Debt with a Personal Loan Learning about Re-Financing Online Debt Management for Personal Loans What happened at Enron? Parts of an Income Statement, Part 2 What is the Sarbanes-Oxley Act? Stabilize Your Current Situation Before You Invest Financing Information 42 What is price/earnings ratio Secured Personal Loans Questions to ask Lenders before Committing to a Personal Loan Getting Your Feet Wet – Begin Investing 43 What's the difference between private and public company reporting Personal Accounting IndexIgnore * free online psychic chat psychic hotlines psychic powers psychic counsellors psychic acadamy psychic jobs free psychic phone call different types of psychic powers free psychic readings online psychic aura colours psychic ability work at home psychic jobs pet psychics psychic chat rooms psychic predictions psychic chat rooms ab workout routine hypnosis home study course glamour affecting our daily lives article traffic conversational hypnosis buy backlinks how to view private facebook profiles Reverse Cell Phone Number Search Extreme Fat Loss Conversational Hypnosis techniques Conversation Starter Skills Making of Love Best Muscle Gain Secrets Cure Any Disease hypnosis home study courses How to build self esteem How to develop intuition Body Fat Loss NOW Fast Fat Loss Number One Wholesale and Dropshipping Source Learn Spanish Book Be a Professional Blogger The forgotten laws of attraction Top Paying Oil Pipeline Jobs Create your own professional resumes from home Best Fat Loss Program Free Money Making Opportunities Online Video Hypnosis Source Energy Money Making Adsense Website Anime Movie Downloads Renewable Energy Systems Registry Cleaner Free Search Engine Secrets Who lives on my street chinchilla wheels what do chinchillas eat? gluten allergy symptoms wheat allergy symptoms nut allergy symptoms autopsy reports of famous people testing for allergies dust allergy chakra centers heal famous tv couples franklin tn dust allergy problems meaning of each tarot card Negative Effects of Gambling Christmas Bargains Portfolio Fashion Tips Chinchilla Facts christmas craft ideasI'm a little late finding
I'm a little late finding this article, but I loved it.
Do you love sports, do you feel like to look cool, i got a very awesome website here introduced by one of my friends. Very good website where you can find the Authentic nike shoes with latest and huge style of nike air max shoes and dunk sb shoes. I have bought from them for so many times, and very satisfied with the their goods and service.Such as Air max 1, air max 2, air max 90, nike air max 2009+, air max 2010 new, nike air max TN, nike air ltd trainers, air max 95.Air max 360 running shoes, nike shox shoes. Though their price are low, don't worry about it's quality.
Christmas is coming, go there to find presents for your friends or family. They are on sale, limited time!
IT News Shopping Articles
We are MONT BLANC Movado,
This enables BVLGARI Watches
puma shoes |puma speed
Thank you for great
Thanks for sharing.great
Thanks for sharing.great article!If you know Genuine UGG Boots,welcome to our UGG SALE IN DISCOUNT ONLINE STORE.All Genuine UGG Boots in our Classic Collection feature a soft foam insole covered with genuine sheepskin and have a molded EVA light and flexible outsole designed for refreshing comfort with every step.Thank you for your understanding and support!
Thanks for sharing.great
Thanks for sharing.great
Thanks for sharing.great article!
Anyway,Welcome to herve leger online store .The Fashionable dress world!The bandage herve leger dress continues to the classic impression of the brand.
The new style and designer of the brand standing out your matchless stature.Wearing it,you will be more sexy and graceful.If so offended, please forgive me^^!
The ghd straighteners
The ghd straighteners technology also can make the hair iron heat quickly and maintain the temperature.
Thank you for your understanding and support!
AVCHD Video Converter, Sony
replica handbags replica
Find Cheap ugg cardy
Find Original Bose
Save 60% off chi hair
Save 60% off chi hair
Save 60% off chi hair
cheap timberland boots sale
thanks for all admin
with a troubled global
with a troubled global economy, many are seeking the security & safe investment for their money in Gold or Oil, since both are highly demanded & their stock is getting less by time
webdesign
Thank you very much for this
Today, more and more people
escort and massage shanghai
Thanks for the information,
We need to input the price
one day i went shopping
A fuel dispenser was not
buy cheap uggs uk authentic
Adidas 35TH
Thank you very much for this
xowii
If one wants to simply
buy prosolution pills,
Luckily for us, ed hardy
Begin with the annual report
Can we make sufficint income
Well said! free games
This model allows us to vary
Pretty good post. online
Hello. I think the
Begin with the annual report
Hello. I think the article
This article is a
Hello. I think the article
Pretty good post. ckloo