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 (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.
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.
(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). 
In 2012 the loss for PSA was even a heavy one as the red roof is a thick one.
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 (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.
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.
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 or our youtube-channel. Again, the free 3D-graph generator package (zip) can be downloaded, unpacked in a folder and the .jar file can be started immediately. Our email-address is anrep3d@gmail.com
Renault Oldtimer (Photo by bernswaelz on Pixabay)
Annual reports presented as 3D graphs 