- InvestLetter by InvestKaar
- Posts
- 10% oil price increase impact + Worksheet
10% oil price increase impact + Worksheet

Arab light oil price is the benchmark we follow in Pakistan.
Mostly all the oil price benchmarks go up and come down together, but at certain times, the change may be different.
2. A 10% oil price increase doesn't necessarily mean a 10% increase in the earnings (other things constant). This is because they also explore and sell natural gas and natural gas pricing is very much different than crude oil.
They have so many different fields (old fields get less for the gas they sell while new fields get more), each field may have different pricing and cost structures, there are different pricing policies, and there are mechanisms where companies are given higher prices for natural gas if they produce more than a threshold from a field.
After all that, gas prices change after 6 months (called the well-head gas pricing mechanism) unlike oil where the change happens in real time. This means that if oil prices are higher this month, exploration companies will see the impact in the next month but the same is not the case with natural gas.
3. This is why the one thing you should about exploration companies is how much oil they sell vs. natural gas i.e. share of gas vs. share of oil.
For instance, PPL's gas share is 64% while oil's share is 28%. This means that the impact of oil price change will be delayed and less.
On the other hand, POL's oil share is 55% (the highest among all) and hence the impact will be higher.
Worksheet
As promised, you will find the Excel sheet's link below but to operate it you need to know the following:
1. Change the oil price from the top (yellow highlight) and you will see the impact on each of the companies in columns A and B. However, this impact is for the oil price change only (as explained about the gas price above).
So to solve this,
2. You will find a table on the right-hand side for sensitivity. This is not editable. This will tell you an analyst's expectation of earning on different oil prices.
After reading the email and looking at the Excel sheet, a few of my savvy subscribers will have a question. I have the answer prepared! Let's see how many can find that!
This was all general, time to go in depth. Starting tomorrow!
About InvestKaar
I am Furqan Punjani and I have been a retail investor and a financial analyst for 15 years now! My only goal right now is to help SIMPLE RETAIL INVESTORS make money from the stock market. This newsletter and this free stock market course, are to help investors become better investors.
Paid community launched. Links below.
Reply