My experience as an Oil Analyst at an oil and energy trading company

Youssef_Louraoui

In this article, Youssef LOURAOUI (Bayes Business School, MSc. Energy, Trade & Finance, 2021-2022) shares his experience as an oil market analyst during a summer internship at Petroineos Trading Ltd.

About the company

Petroineos is a joint venture between PetroChina International London (PCIL) and the INEOS Group for refining and energy trading. PetroChina is one of the world’s major oil and gas enterprises and the INEOS is a refining and petrochemical group. This joint venture is a young and ambitious firm that was founded in 2011 with a dynamic approach to business and a strong ambition for long-term success.

In Petroineos, there are three sections which handle trading in different products: crude, refined products, and power and emissions. Petroineos’s annual trading volume exceeds 70 million tonnes, with assets worth around $6 billion and trading revenue in excess of $30 billion (Figure 1).

Its strategically positioned refineries in Grangemouth (Scotland) and Lavera (France), is among the oldest crude oil refineries in Europe. It provides gasoline to both domestic (Scotland and
France) and international markets, while also sustaining local economies. Every year, the two refineries process about 360,000 barrels of crude oil per day and create over 16 million tonnes of oil products.

Figure 1. Petroineos Trading Ltd. key numbers.
 Petroineos Trading Ltd. numbers
Source: Petroineos Trading Ltd. (2022)

My internship

I was affected along with seven other interns, each with their own specific project that had to be completed throughout the 12-week internship. The first days were intense because we had to deal with jargon, practitioners’ concepts, and the dynamic nature of the trading floor. Fortunately, I had the opportunity to be supervised by a seasoned analyst during the first month of the internship, which allowed me step up my skills and be up and running for the next two months. There was a healthy mix of autonomous work and fruitful discussions with the other colleagues. This forced me to be independent in my job while also working in groups when required, allowing for some flexibility in how I performed.

The highlight of this internship was the relationships created with my fellow interns. It really helped a lot to make this experience so enjoyable. The teamwork, the feedbacks, the help that was offered among interns was really amazing; it created a strong bond inside and outside the office. It was a blessing to meet and learn from them as they are all well accomplished individuals who have a bright future in front of them.

By the end of my internship, I felt that I improved significantly in terms of notions regarding crude oil market, time management, relationships with my colleagues and good memories overall.

Missions

During this internship, I was assigned to the analysis department, which was in charge of providing reports and market updates for the major commodity markets. I did my internship in extraordinary times for the oil and commodity markets as it was a few months after the beginning of the Ukrainian-Russian conflict. At that time, the world was experiencing a global energy crisis, a shock of extraordinary scope and complexity. This crisis reminded us of the events of the 1970s (Oil shocks 73-79). This crisis had many dimensions, including coal, oil, gas, food security, and climate change. Governments around the world are seeking for an equilibrium that would deliver a good energy mix while retaining affordable and secure resources for their people, not only reducing reliance on a single commodity.

Natural gas spot prices had reached unprecedented highs, the equivalent of USD 250 for a barrel of oil. Furthermore, the crisis had fueled inflationary pressures and raised the prospect of a recession, as well as a massive USD 2 trillion windfall for fossil fuel producers above their 2021 net revenue. In response to energy shortages and high costs, governments have invested well over USD 500 billion, primarily in industrialized nations, to protect consumers from the immediate consequences of inflation (especially in gas and oil).

Keeping this in mind, I was assigned coverage on the impact of Western sanctions on the Russian crude oil market. Every market participant seeked to predict the impact of the sanctions on the number of barrels shipped from Russia.

  • Is Russia going to reduce its crude oil export since Europe represented alone more than 80% of its exports volume before the war?
  • Who are the new market players that are profiting from this situation and capitalizing on a discounted Russian crude oil in the international crude oil market?
  • Are there any patterns that can help in better understanding the crude flows?

Those three questions captured the importance of the analysis that had to be conducted in order to give sound and well detailed answers in order to capitalize with trading strategies that could leverage this information.

The main task was the redaction of the report which was shared across the whole company. The basic idea of this report was to give a micro overview on a weekly basis on the main changes that can impact the Urals market. I was in charge of analysing the vessels movement from the main ports in Russia and capture their discharging patterns in order to extract valuable information into the main discharging regions that are profiting from this market.

I also collaborated on other analyses with another intern from the Data Science department, which involved analyzing alternative data to identify any interesting signals that may be used as a trading strategy. In addition, I shared two further quantitative analyses involving econometric relationships to analyze Russian and global oil demand in analysis to other factors of relevance. The projects were incredibly interesting, and the insights were also helpful in understanding the complexities of collecting insights in an environment where analysts are surrounded by noisy data that must be filtered in order to communicate valuable information.

The main conclusions of the Russian coverage:

India and China as the main actors profiting from the discounted price of Urals

Russia becomes the highest exporter of crude oil to India (Urals crude). The pattern change since the war unfolded. Historically, India imported oil from Irak and Saudi Arabia. This interest is based on the decision by the Asian countries to capitalise on a devaluated Russian oil price in the international crude oil market, which reached at some point of the war 30$/bbl difference with the main international oil benchmark (Brent). According to the Indian energy minister, they want to lock in the best price available in the international crude oil market (Figure 1).

According to US treasury Janet Yellen, this trend will continue, profiting from the western price cap on russian crude oil. G7 countries agreed in September to implement the price cap, which the US government hopes will be in place by December 5 when an EU embargo on the shipment of Russian crude comes into force. Under the mechanism, European companies will be permitted to transport and insure shipments of Russian oil to third countries as long as it is sold below a fixed price — an effort to limit the impact of the sanctions on global oil flows but ensure Russia’s earns less from the trade.

Dislocation of the market between Europe and Asia

Europe decreased importantly its dependence from Russian crude oil after the war in Ukraine. There is a shifting of actors in this market, with Asia skyrocketing demand compared to previous years because of the attractivity of the Urals in the international crude oil market. Also, if we shrink oil price volatility to its components, we see that:

  • External factors, other than supply and demand, play a more important role now specifically policy issues are more important than ever, accounting for more than 25% of oil volatility
  • 20 years ago we could explain 90% of oil volatility by supply and demand, now this rate dropped to 65%.

Required skills

I would mention two main skills: market understanding and programming expertise. It is very beneficial to stay on top of market news, as it is good industry practice (especially for an analyst position) to understand the many market events that affect the specific commodity covered. As most businesses strive for automation, acquiring and mastering a programming language can only benefit future analysts. It has become a wider pre-requirement for most analyst positions.

Key learning

Key numbers

Some key numbers to have in mind to understand the crude oil market:

  • Estimation according to a reliable source: 1.43 trillion barrels left in the ground (2022)
  • Estimated part of oil consumption in most developed economies (around 30-45% of crude oil in the energy mix)
  • Estimated daily production per day in the world: around 100mb/d
  • Russia produce approximately 10% of the world daily crude oil demand. Urals production (the most traded grade of crude in the Russian oil market) was fluctuating on average around the 2mb/d threshold

Refinery margins

Refinery margin is derived from the difference between the refinery cost (buying crude) and the profit (selling refined product).

Refinery margin and crack spread

Crack spread represents the differential between the price of crude oil and the price of products refined. It is an industry specific metric to assess refining profitability. Crack refers also to the chemical process of decomposing the crude oil into different petroleum products. As different variables affect the price of crude oil and its refined products, this has an implication for refining margins.

Implementation of a crack strategy

  • Single product crack: Differential of one barrel of crude with one barrel of refined product
  • Multi product crack: Use of different refined products to secure a margin

Trading the crack spread

  • Either long or short crack: If long crack, confident view that refinery margins will strengthen (either crude oil price decreasing or products demand increasing)
  • If short crack, confident view that refinery margins are worsening, either because crude oil price increase or decrease of products demand

Reading crack spread as market signal

  • If crack widens, refined products more expensive than crude oil price, market expects that crude oil price will increase (to tighten back the spread to historical norm)
  • If crack tightens, refined products are sold cheaper than the price of crude oil, market expects that refined products (will reduce production) in order to get more expensive to widen the spread

Why should I be interested in this post?

This post will help any student looking to break into the work of oil or energy trading, but more generally for any analyst position, to have a grasp of the main concepts and skills that are required in the market and have a better understanding of the energy industry.

Related posts on the SimTrade blog

   ▶ All posts about Professional experiences

   ▶ Youssef LOURAOUI My experience as a portfolio manager in a central bank

   ▶ Aastha DAS My experience during a summer internship as an investment banking analyst at G2 Capital Advisors

   ▶ Aamey MEHTA My experience as a credit analyst at Wells Fargo

Useful resources

Business Analysis

Petroineos

Financial Times (2022) Russia becomes India’s top oil supplier as sanctions deflate price.

About the author

The article was written in December 2022 by Youssef LOURAOUI (Bayes Business School, MSc. Energy, Trade & Finance, 2021-2022).

Mon expérience de contrôleuse de gestion chez Edgar Suites

Mon expérience de contrôleuse de gestion chez Edgar Suites

Chloé POUZOL

In this article, Chloé POUZOL (ESSEC Business School, Grande Ecole Program – Master in Management, 2022-2024) partage son experience de contrôleuse de gestion chez Edgar Suites.

L’entreprise : Edgar Suites

Edgar Suites est une start-up fondée en 2016 par Xavier O’QUIN, Maxime BENOIT et Grégoire BENOIT. Elle propose à ses clients de vivre une expérience au cœur de la ville en logeant dans une suite urbaine : un mix idéal entre appartement et hôtel. Pour cela, l’entreprise loue des locaux initialement occupés par des bureaux, qu’elle transforme en T1 (studio), T2 (2 pièces) et T3 (3 pièces).

Exemple de suite
Exemple de suite
Source: Edgar Suites

En mai 2021, Edgar Suites a levé 104 millions d’euros auprès du fonds d’investissement BC Partners. Depuis cette levée de fonds, l’entreprise a triplé son activité avec presque 150 suites urbaines à Paris, Levallois Perret, Bordeaux, Lille et Cannes.

Logo de l’entreprise Edgar Suites
Logo Edgar Suites
Source: Edgar Suites

Mes missions

En tant que stagiaire, j’ai eu plusieurs missions bien différentes, certaines seulement temporairement et d’autres tout au long de mon stage.

Lorsque je suis arrivée chez Edgar Suites, il n’y avait pas encore de contrôle de gestion mis en place. L’entreprise avait juste quelques fichiers Excel avec lesquels elle faisait tant bien que mal les calculs de chiffres d’affaires (CA) et d’excédent brut d’exploitation (EBE) qui représente le bénéfice d’une société avant les intérêts, impôts, amortissement et provisions (EBITDA pour Earnings before interest, taxes, depreciation, and amortization)…

L’entreprise avait embauché un prestataire extérieur pour construire des fichiers de reporting financier et comptable grâce à un tableur (Excel) et une suite de logiciels qui permettent de transformer des données disparates en informations visuelles, immersives et interactives (Power BI). J’étais chargée de surveiller l’avancée du dossier, de superviser le respect des dates limites (deadlines) et surtout de vérifier la cohérence des fichiers envoyés (écarts, cohérences entre les grands livres, les résultats de l’entreprise (P&L pour Profit & Loss) et les budgets). Cela m’a ainsi permis d’apprendre à maîtriser un éditeur de requêtes de données (Power Query, un des logiciels de la suite Power BI) pour importer des données de l’entreprise dans le tableur Excel.

En plus de cette première responsabilité, j’ai été chargée d’améliorer les fichiers internes de suivi d’indicateurs utilisés pour l’aide à la décision et pour mesurer l’efficacité d’une mesure (KPI pour key performance indicator) notamment le coût au check-in et le coût par équivalent temps plein (ETP) qui est une unité de mesure permettant d’évaluer la charge de travail et la capacité d’un employé.

Réalisation des reportings mensuels

En plus de ces missions, j’étais responsable de la rédaction de tous les reportings mensuels pour BC Partners (le fonds d’investissement auprès duquel Edgar Suites a levé des fonds pour financer son développement) et pour les propriétaires d’immeuble à loyer variable (loyer calculé selon un certain pourcentage du chiffre d’affaires) où il s’agissait de calculer le chiffre d’affaires, les coûts fixes, les coûts variables du mois et ainsi les bénéfices du mois. Je devais aussi m’occuper des rapprochements bancaires (contrôle de la concordance entre les relevés des comptes bancaires et les comptes correspondant dans la comptabilité) et de la gestion des factures qui s’effectuaient à l’aide du logiciel Pennylane.

Réflexion sur la responsabilité sociétale des entreprises (RSE)

Enfin, j’ai également participé à la réflexion sur la responsabilité sociétale des entreprises (RSE) pour prendre en compte les enjeux environnementaux et sociaux d’Edgar Suites. Les dirigeants souhaitent, en effet, être labellisés B-Corp (Benefit Corporation). Une entreprise peut recevoir la certification B-Corp lorsque ses actions sont en adéquation avec les exigences sociales, environnementales et de gouvernance du public. Il s’agit d’une certification qui s’obtient après un long processus. J’ai donc effectué des recherches et conduit des entretiens pour trouver le cabinet de conseil adéquat pour nous accompagner tout au long de ce projet. J’ai également participé aux réunions de réflexion sur les actions d’Edgar Suites afin d’atténuer l’impact social et environnemental de l’activité.

Compétences et connaissances requises pour ce stage

Les principales compétences et connaissances techniques (hard skills) requises sont de maîtriser un tableur comme Excel et d’avoir de bonnes bases en comptabilité et en finance. En effet, pour réaliser les reportings, il était nécessaire de comprendre les données importantes de l’activité pour pouvoir les analyser et les synthétiser. Ces données importantes chez Edgar Suites étaient le coût par check-in, l’EBITDA, les coûts fixes et les coûts variables (notamment les loyers variables). De même, pour faire de la modélisation financière, il est essentiel d’avoir de bonnes connaissances financières afin de créer une logique et une présentation cohérente au sein du fichier.

Enfin, les compétences humaines et comportementales (soft skills) essentielles étaient principalement de savoir travailler en équipe ; cela permet de mettre à contribution les idées et les compétences de tous les membres du groupe pour améliorer le résultat du travail sur l’entreprise.

De façon générale, je suis très satisfaite de mon premier stage que j’ai effectué à la fin de ma première année à l’ESSEC. J’ai été responsabilisée et j’ai pu découvrir le fonctionnement comptable d’une entreprise ainsi que me familiariser avec la finance d’entreprise. En effet, j’ai pu manipuler les états financiers d’Edgar Suites pour me familiariser avec leur lecture et leur analyse. De plus, j’ai pu observer le fonctionnement des finances de l’entreprise : comment l’entreprise gérait ses coûts ; comment Edgar Suites essayait d’améliorer sa rentabilité ; quelles étaient les répercutions sur le plan financier des décisions de management …

Concepts clés

Je détaille ci-dessous quelques concepts clés qui m’ont été utile de maîtriser pendant mon stage :

Contrôle de gestion

Le contrôle de gestion est un service au sein d’une entreprise, chargé d’aider à la prise de décision. Il est responsable de l’élaboration des budgets, de la mise en place de procédures de gestion et de règles, du suivi des résultats, du choix des indicateurs clés dans les tableaux de bord et de la production et la diffusion d’outils de pilotage. L’objectif principal du contrôleur de gestion est d’optimiser les performances matérielles et financières de l’entreprise.

Chiffre d’Affaires

Le Chiffre d’Affaires (CA) correspond à la somme des ventes des produits ou services d’une entreprise. Il se calcule en multipliant les quantités vendues par leur prix de vente. Il s’agit donc d’un indicateur principal sur les performances de l’entreprise.

EBE ou Ebitda

L’Ebitda (Earnings before interest, taxes, depreciation, and amortization) correspond au bénéfice avant les intérêts, les impôts, les taxes, la dépréciation et l’amortissement. Il mesure donc la création de richesse avant toute charge. Il s’agit d’une notion assez proche de l’EBE (Excédent Brut d’Exploitation). Il existe deux formules pour calculer l’Ebitda :

Ebitda = Chiffres d’affaires – achats – autres charges externes – charges du personnel – autres charges

Ebitda = Résultat net + charges d’intérêts + charges d’impôts + amortissements et provisions

Lorsque l’Ebitda est positif, cela signifie que l’entreprise est rentable au niveau opérationnel mais pas forcément qu’elle est bénéficiaire (après la prise en compte d’autres éléments comme les charges financière).

Responsabilité sociétale des entreprises (RSE)

La responsabilité sociétale des entreprises (RSE) correspond à la contribution des entreprises aux enjeux du développement durable. Cela consiste à faire des efforts pour la protection de l’environnement et pour l’amélioration de la société. Ces efforts se font en collaboration avec toutes les parties prenantes (fournisseurs, clients, employés, actionnaires…). Il existe aujourd’hui de nombreuses certifications, comme la certification B-Corp, qui reconnaissent l’investissement des entreprises dans la RSE.

Articles à lire sur le blog SimTrade

   ▶ All posts about Professional experiences

   ▶ Anna BARBERO Career in finance

   ▶ Emma LAFARGUE Mon expérience en contrôle de gestion chez Chanel

   ▶ Ghali EL KOUHENE Asset valuation in the real estate sector

Ressources utiles

Edgar Suites

B-Corp France

A propos de l’auteure

Cet article a été écrit en mai 2022 par Chloé POUZOL (ESSEC Business School, Grande Ecole Program – Master in Management, 2022-2024). Vous pouvez me contacter via mon adresse mail ESSEC pour plus d’information sur mon stage.