Automotive 8 – Renault

The previous post would have been the last one in the automotive series, but in the intermezzo we already promised to add Renault and Nissan, because of all the news about Carlos Ghosn. Renault has really nice annual reports, although the most recent years were a little bit comfusing as the consolidated financial information was in separate documents.

Yet it was easy to collect the data and put it in the standard format. The input-file holding the seven companies can be downloaded as a .txt file.

Renault Dauphine

Renault Dauphine (Photo by emkanicepic on Pixabay.com)

After adjusting the space between the “builings” (the graph becomes rather broad now, so the buildings have to be closer to each other) the input-file was processed and the output-file (a .htm file) could be observed in the web-browser. With all the details it is very hard to capture the real 3D-graph in a screenshot. This time we need a couple of them, from different directions. Here the overview is shown.

Overview 3D-graph Automotive 8

 

On double-clicking, the 3D-graph will appear in your web-browser. There are several options to move graph: clicking the right mouse-button, moving the mouse up and down will zoom the graph in and out. Clicking left and moving the mouse at the same time 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.

Yellow Renault 4 (Photo by emkanicepic on Pixabay.com)

If we take a closer look at the graph (the values are sorted according to the most recent revenue, to create a kind of amphitheatre in the graph), Renault is close to PSA and very similar, although it seems PSA suffered more from the crisis than Renault did. Renault shows six years of profit (green roofs), where PSA started out with losses (red roofs). Close-up of 3D graph aut.8

 

In 2012 the loss for PSA was even a heavy one as the red roof is a thick one.

close-up of 3D-graph aut.8

Neither PSA nor Renault is as large as companies like Ford, GM or VW. Combined however (adding the heights, the widths and the depths of their buildings to create a hypothetical RenaultPSA), the are as large as Ford or GM (financially speaking), but still nowhere near VW. Volkswagen is really large and despite of “dieselgate” too much pressure could make it the “Lehman of Europe”.

Renault Twizzy

Renault Twizzy (Photo by Hans on Pixabay.com)

 

 

 

 

Most automotive companies in the 3D-graph are doing rather well – even Tesla, being more of a challenger and a game-changer of course. Looking at the total liabilities (debt) to equity ratio, Renault is doing even better. To be able to see those ratios, the bottom view of the graph is taken.

Bottom view of 3D-graph Aut.8

We can see the ratio of width (equity) and depth (liabilities) easily. Only recent years are shown (for the full view double-click the screenshot and the 3D-graph will appear).

Ford (third from the right, after Volkswagen and General Motors) has a high liabilities-to-equity ratio (about 6). It is higher than GM and much higher than VW. Both Renault and PSA are more like VW.

Ratio-calculations

 

It is easy to derive all kinds of ratios from the input-file after importing it in a spreadsheet. Below an example of the exact Liability-to-Equity ratios (as already observed in the 3D-graph in a more intuitive way.

 

For more information, please have a look at our other posts, our website (https://anrep3d.com ) or our youtube-channel. Again, the free demo-package (zip) can be downloaded, unpacked in a folder and the .jar file can be started immediately. Our email-address is info@anrep3d.com

Renault Oldtimer

Renault Oldtimer (Photo by bernswaelz on Pixabay)

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.