Skip to content

Refinery Margin and Crude Slate Spreadsheet Modelling Training Course

Spreadsheet models for refinery planners and analysts covering crack spreads, crude slate yields, operating costs and capital cases.

This 1-week course has 25 dates from November 2026 to November 2027 in 24 cities and live online. The next session runs 22 – 26 November 2026 in Sharm El-Sheikh. Fees per participant run from 4,000 £ (Cairo) to 9,500 £ (New York) in a classroom, and from 2,900 £ live online.

See dates and book Download brochure (PDF) Training for your team

Duration
1 Week
Next start
Sharm El-Sheikh
Scheduled dates
25
Classroom cities
24
Classroom fee from
4,000 £
Online fee from
2,900 £

What does this course cover?

Refinery Margin and Crude Slate Spreadsheet Modelling is a 1-week training course for refinery planners, economists and finance analysts who build a refinery margin decision model linking crude purchases, unit yields and product netbacks. Volatile crack spreads, shifting crude differentials and tighter capital budgets make transparent margin arithmetic essential for every refining organisation. Jupiter Prime Training delivers this course for teams that turn crude choices into defensible numbers.

Why Refinery Margin and Crude Slate Spreadsheet Modelling Matters Now

Three forces shape refinery economics today: product demand moving between gasoline, middle distillates and petrochemical feedstocks; wider price gaps between light sweet and heavy sour crudes; and investors asking for clearer returns on every unit revamp. Refineries that model these drivers well buy the right cargoes and defend capital requests; those that model them badly approve projects on optimistic assumptions. The course rests on established methods: gross and net refining margin, discounted cash flow, net present value (NPV) and internal rate of return (IRR).

Who Gains Most from Refinery Margin and Crude Slate Spreadsheet Modelling

  • Planners responsible for monthly crude selection and unit run plans
  • Economists who forecast crack spreads and product price sets
  • Finance analysts who report refinery margin and operating cost variances
  • Supply and trading staff who evaluate cargo offers and crude differentials
  • Project evaluators who prepare capital cases for unit upgrades and revamps

Refinery economics groups gain most when planners, economists and finance analysts attend together and leave sharing one model structure.

Refinery Margin and Crude Slate Spreadsheet Modelling Capabilities

Participants move from reading a crack spread to building linked worksheets that price a crude slate, cost its processing and test a capital case.

  • Calculate gross and net refining margin from yields and netbacks — monthly margin reporting
  • Build crude assay and yield worksheets for candidate cargoes — crude purchase decisions
  • Assess crack spread exposure across product groups — hedging and sales planning
  • Weigh fixed and variable operating cost drivers per barrel — cost reduction priorities
  • Test unit revamp cases with NPV, IRR and payback — capital approval boards
  • Communicate sensitivity and breakeven results in plain charts — refinery leadership

Key Refinery Margin and Crude Slate Spreadsheet Modelling Terms

  • Crack spread — the price difference between a basket of refined products and the crude oil used to make them.
  • Crude slate — the mix of crude grades a refinery processes over a given planning period.
  • Netback — the value a refinery realises for a product after deducting freight, handling and selling costs.
  • Crude assay — laboratory data describing a crude grade's density, sulphur and distillation yields by cut.
  • Gross refining margin — product revenue minus crude and feedstock cost, before operating expenses are deducted.
  • Breakeven crude differential — the discount at which a candidate crude delivers the same margin as the reference grade.

Refinery Margin and Crude Slate Spreadsheet Modelling Day by Day

Day 1: Refining Economics and Margin Drivers

  • Refinery Value Chain From Cargo To Product Sales — Margin Accountability
  • Gross Versus Net Refining Margin Definitions — Performance Reporting Choices
  • Simple 3-2-1 And Regional Crack Spread Baskets — Market Exposure Reading
  • Product Price Sets And Netback Calculation — Realised Revenue Estimates
  • Spreadsheet Model Architecture With Inputs, Calculations, Outputs — Model Audit Trail

Day 2: Crude Slate Economics and Yield Modelling

  • Crude Assay Interpretation By Distillation Cut — Cargo Screening Decisions
  • Linear Yield Vectors For Atmospheric And Vacuum Units — Product Output Forecasts
  • Sulphur And Density Penalties In Crude Valuation — Discount Negotiation
  • Breakeven Differential Worksheets For Candidate Grades — Purchase Approval
  • Blended Slate Yields And Unit Capacity Limits — Monthly Run Plans

Day 3: Operating Cost and Unit Margin Models

  • Fixed And Variable Cost Per Barrel Build-Up — Cost Reduction Targets
  • Fuel, Steam And Hydrogen Cost Allocation To Units — Unit Profitability Ranking
  • Catalyst And Chemicals Consumption Modelling — Turnaround Budget Inputs
  • Conversion Unit Severity Versus Margin Trade-Off — Operating Mode Selection
  • Monthly Margin Variance Bridge — Explaining Results To Leadership

Day 4: Capital Project Models and Sensitivity Analysis

  • Discounted Cash Flow Structure For Unit Revamps — Capital Request Evidence
  • NPV, IRR And Payback Calculations — Project Ranking Boards
  • One-Way Sensitivity And Tornado Charts — Key Assumption Ranking
  • Price Scenario Sets For Crack Spread Cycles — Downside Resilience Testing
  • Monte Carlo Ranges On Margin Inputs — Probability Of Project Return

Day 5: Practising the Refinery Margin Decision Model

  • Linking Yield, Cost And Price Worksheets — Single Integrated Margin View
  • Crude Cargo Comparison Using Breakeven Differentials — Live Purchase Case
  • Revamp Case Stress Test With Sensitivity Outputs — Board-Ready Recommendation
  • Model Checking, Error Traps And Version Control — Reviewer Confidence
  • Completed Refinery Margin Decision Model — Presentation To Peer Panel

Applying Refinery Margin and Crude Slate Spreadsheet Modelling After the Course

  • Lead a breakeven differential review of the next three crude cargo offers using the yield worksheets built on Day 2.
  • Run a monthly margin variance bridge for one conversion unit for the planning meeting.

Refinery Margin and Crude Slate Spreadsheet Modelling Questions (FAQ)

What is Refinery Margin and Crude Slate Spreadsheet Modelling and why does it matter now?

It is the practice of pricing crude choices, unit yields and operating costs in linked worksheets to explain refinery margin. With volatile crack spreads and wide crude differentials, transparent models help you buy the right cargoes and defend capital cases.

Which roles gain most from Refinery Margin and Crude Slate Spreadsheet Modelling?

Refinery planners, economists and finance analysts gain most. Supply staff and project evaluators also benefit.

How does Refinery Margin and Crude Slate Spreadsheet Modelling differ from a general energy financial modelling course?

It focuses on refining arithmetic rather than generation or upstream project finance. You work with crude assays, yield vectors, crack spreads and unit operating costs.

What do you bring back from Refinery Margin and Crude Slate Spreadsheet Modelling?

You bring back a working spreadsheet model that links crude yields, operating costs and product prices. It includes breakeven checks and a sensitivity-tested capital case.

Refinery Margin and Crude Slate Spreadsheet Modelling: The Way Forward

The refinery margin decision model first informs which crude cargo to buy next month, measured against its breakeven differential. Planners use it for run plans, economists for price scenarios and finance analysts for variance reporting. After first use, revisit the price set and cost allocation against actual crude differentials.

When and where does this course run?

Showing 1–20 of 25 dates

November 2026

December 2026

January 2027

March 2027

April 2027

May 2027

July 2027

August 2027

September 2027

October 2027

Can’t find a suitable date? Tell us what you need.

Questions about dates, fees and booking

When does this course next run?

The next session runs 22 – 26 November 2026 in Sharm El-Sheikh. It is one of 25 dates scheduled up to November 2027.

Where is this course held?

In a classroom in 24 cities: Sharm El-Sheikh, Dubai, Milan, Muscat, Munich, Amman, Kuala Lumpur, Singapore, and more. It is also scheduled as live online sessions.

Can I attend this course online?

Yes. One date is scheduled as a live online session: 4 – 8 April 2027, from 2,900 £ per participant.

How long is the course?

1 Week. Each date shows its start and end dates.

How much does the course cost?

Fees per participant run from 4,000 £ (Cairo) to 9,500 £ (New York) in a classroom, and from 2,900 £ live online. Each date shows its own fee.

Is there a brochure for this course?

How do I book a place?

Choose a date above and select Register, or send us an enquiry.

Can this course be run for our team?

Yes. Tell us the number of participants and your preferred dates and city through our training request form.

More ways to train