David and Goliath: Royal Dutch Shell taking over BG-group

To be honest, I was a little bit disappointed when I saw the 3D-graph I generated for Royal Dutch Shell and BG-group. As discussed in the previous post, this acquisition was completed and the 2016 Annual Report presented the consolidated numbers. Unlike some other mergers & acquisitions this one was not too recent and not too old either.

Why should I be disappointed then? Well, it turns out BG-group was much, much smaller than Royal Dutch Shell. Of course I knew, and although I saw the numbers I didn’t fully realise that the BG-group’s revenue was only about 6% of the revenue of Royal Dutch Shell. Maybe the profit was misleading me, because in 2015 the profit of the BG-group was about 77% of Shell’s profit, so almost the same in absolute values. But then equity and total assets were very different again – BG showing only 1/5th or 1/6th of Shell’s values. Last time I presented a piece of a spreadsheet, now the format of the input-file is below:

input-file Shell BG

 

 

 

 

A warning first: there is a risk whem looking at the graph. It is a 3D-graph, but it doesn’t mean the volume is meaningful. The three dimensions should be compared separately between the companies, although the relative sizes can be compared within one “building”.

E.g. the shape of the floor indicates a kind of gearing ratio (here Equity/Total Assets, but Equity could be replaced by Liabilities easily to get other ratios – of course then then those values have to be replaced for all companies and all years). A company about ten times smaller than another would be smaller in all three dimensions, but this doesn’t mean it’s 1000 times smaller as the volume would suggest.

Talking about ratios: if we havShell BG bottome a look at the shape of the bottoms for both (2015 taken), it seems to be very similar for both.

 

 

Shell BG front

Looking at the front-side, we see a huge difference between the revenue-levels.

 

 

 

However, the profit (the green roof) is more or less of the same size in 2015. This means the absolute values of the profits of both companies were not very different! profit Shell BGIn this graph (just double-click one of the pictures to see the real 3D-graph), the four values of both companies were added for the years before the year of the acquisition. This means the sum of the revenue, the sum of the profit, the sum of the equity and the sum of the total assets was taken for 2014 and 2015. Formally the same was done for 2016, but then Royal Dutch Shell published the consolidated values and the values for the BG-group became all zero, so for 2016 the combination is equal to Royal Dutch Shell.

Of course we cannot simply add the values, because mergers and acquisitions usually lead to an outflow of money to shareholders. Apart from this, it was the period in which the oil-price dropped and put a lot of pressure at the results. Still it’s interesting to show a combined set of values. And although Royal Dutch Shell is more like Goliath, with BG-group being more like David, the profit was an interesting part of the comparison.

Do you want to create this kind of graphs yourself? It’s easy with the free demo-package. It contains a generator, a manual and a couple of examples of input- and output-files (3D-graphs in 3D format). Visiting our website is a more lazy option and of course the pictures above are clickable. Double clicking will bring up the real 3D-graph in your browser (webGL and Javascript need to be enabled). Do you want a licence for the generator with full functionality? Please contact us – the current price is shown at our website. Are you a professor at a university (or a university of applied sciences)? Please contact us: we do offer some free licenses for educational purposes.

Manipulating the graphs is easy: Clicking the right mouse-button, moving the mouse up and down will zoom the graph in and out. Clicking left and moving the mouse will tilt the graph in different directions (or move the observer’s viewpoint around a fixed graph – it’s relative of course). Double clicking in the graph translates it and moves the centre at the same time. As a result the way the graph tilts will change. Just try it. If you don’t know how to get the normal position back, just refresh the graph.
Advertisements

About AnRep3D

AnRep3D is the new company, founded after the handover of Scientassist (together with VRBI) to one of my sons. From now I will focus on three-dimensional graphs for the financial markets, showing the main figures from annual reports in comparison.
This entry was posted in Visualising Financial Information and tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.