Visualising a mix of companies in a spatial graph (II)

We already had a look at the revenue, profit, equity and total assets of five very different companies (the well-know Zalando, Tesla and Easyjet, the probably less-known temp agency USG-People and then the Spanish technology company Elecnor). Yet we only presented a range of numbers. Although some people will understand the characteristics of a company – or even recognise the company – from those numbers, it’s better to visualise them. That’s what AnRep3D does: the numbers in the input-file are converted to spatial graphs. Once again, I started the generator and got the screen below:

Start-screen AnRep3D

Then I selected the files for input and output and got the message that the graph was generated. As I double-clicked the output-file (an .htm-file), the graph appeared in my browser. Let’s have a look!

First graph of five companies

The five companies are represented by their buildings, standing abreast. The front-view shows their equities (width) and revenues (height). If the roof is green, there is a profit but a red roof means a loss. All companies show a smaller or larger profit, except for Tesla with it’s very clear red top! So its total revenue was needed to cover all the expenses and then some (the red part).  Yet Tesla’s equity is rather low as the narrow building emphasises! On the other hand, Tesla is able to generate a lot of revenue with a small relative small amount of own money. Of course a lot of other capital (not shares, but loans and bonds) could be available. If we click in the graph, hold the mouse-button an move the mouse downwards, we will see the graph tilt.

Tilted graph of five companies

Now we have a better view at the depth of the building (total assets). If we consider the depth of the building –  from front to back that is – we see the total assets. It should be equal to the combination of equity and liabilities. Looking from this position I knew immediately something went wrong! Both Easyjet and Elecnor showed equities higher than their assets but this doesn’t make sense! Was it a typo or did I switch assets and equity? Well, both actually.

For Easyjet equity and assets were switched indeed. I only noticed when observing the graph. It is stupid, I know but at the same time it shows how powerful a visualisation can be! After correction the Easyjet building will remain the same, only rotated by 90 degrees.

For Elecnor I just put the decimal point at the wrong position. Stupid as well and I’m happy I wasn’t presenting graphs for a meeting of shareholders. After correction this building will get only 10% of the width in the graph shown above. I adjusted the input-file and then the graph had to be generated again of course, but it’s a matter of seconds. This time I used the version with billions instead of millions and as a result  the “scaling factor” cannot be 500 but is 0.5. So actually the values will be doubled. At the same time I had to increase the spacing (to 100) and reduce the font-size (to 3), because of the buildings would become narrower and the labels would overlap as a result of it. Below the corrected input-file – this time with semicolons instead of comma’s as both are allowed as a separator (I’m very sorry I presented a misleading set of values earlier):

5,1,0.5,100,3
Zalando; 2015; 2.96; 0.12; 1.27; 2.12
Tesla; 2015; 3.69; -0.81; 0.83; 5.32
Elecnor; 2015; 1.88; 0.066; 0.74; 3.49
Easyjet; 2015; 6.47; 0.76; 3.10; 6.67
USG_People; 2015; 2.55; 0.020; 0.487; 1.28

Looking at the new graph, based on the improved set of numbers, we can see Elecnor and Easyjet have changed (but the other three still being the same).

Adjusted graph

Because of the increased spacing, the buildings moved into the back as well. By right-clicking the mouse and moving it at the same time, the graph will zoom.

Zooming in

Tilting again (left-clicking the mouse, holding the button and moveing down) we can see total assets being higher than the equity for all companies shown. Easyjet only turned by 90 degrees, but Elecnor only being much smaller than previously.

Tiling zoomed graph

If we would go on, this post would be too long to read, so I keep the in depth discussion for the next time. Meanwhile have a look at www.anrep3d.com

The only advice for now: if you really messed up with tilting or zooming, don’t worry! By clicking the “refresh” button in your browser, the graph will get back to its original position!

Back to original position

Back to original position using the “refresh” button

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s