The 3D-graph was created last time, so now we only have to add companies to it. That’s easy, as the input-file consists of blocks. A block holds a set of lines (one for every year) for a company. Let’s add Ford, because it is in USD already and its book-year is equal to the calendar-year. An easy post this time, without complications – or so I thought.
The first step is to get Ford’s annual reports of course. Because we already took the classic set Revenue, net Profit, Equity and total Assets (RPEA) for Mitsubishi, we have to do the same for Ford as we shouldn’t compare apples and oranges.
(Photo by Luis Quintero on Pexels)
By now you know I look for the word “consolidated” to move to the financial statements as quick as possible. Doing so I noticed Ford is not only a motor company, but is also offering financial services. Not very strange and only a small part of the numbers, so I just took the totals. On copying the values from the balance-sheet, I took the liabilities as well. We don’t need them for this graph and those numbers won’t be in the input-file but it allows me to check whether the sum of equity and liabilities meets the total assets. If not, there will be a typo or I picked the wrong column. (I use copy-paste and sometimes the actual year reported is in the left column another time it’s in the right one, so a mistake is made easily. Another time I just miss a part of the number when selecting).
Unfortunately, the sum of Liabilities and Equity did not match the Assets, although the numbers were right! Then I discovered this floating number representing a “redeemable non-controlling interest”. Well, that’s fine but I don’t like it this way. Reading the note, I understood it was a temporary situation to be solved the next year. The amount was part of the total assets, but kept out of the equity.
(Photo by ID12019 on Pixabay)
Then the next year the same thing happened and the year after as well. All six annual reports showed this gap of some dozens of millions, floating between liabilities and assets. Of course it’s not a “side letter” and a note was available, so it’s transparent and let’s move on. Two solutions were available to close the gaps again: 1) add the floating value to the equity or 2) remove it from the assets – actually setting the assets equal to the sum of equity and liabilities. I preferred the latter as the impact is smaller. Please keep this in mind when looking at the graph!
(Photo by scottwebb on Pexels)
Creating the additional block for the input-file wasn’t very hard. I saved the previous one (Mitsubishi) under a new, neutral name and added the block from ford.csv (the excel-sheet saved as an MS-DOS csv). Then I generated the file and … was surprised to see Mitsubishi and nothing else. After a couple of seconds I realised that the “number of companies” in the parameter-line was still 1 (one). After changing it to 2 (as the file holds two companies now), the 3D-graph was generated again.
(Photo by Gustavo Belemmi on Pixabay)
Below the steps of the process are shown. The first screen is a kind of concise manual:
Then the input- and output-files have to be selected – first the input-file:
After clicking the button “inputfile” all files in the folder are shown. Among all the files visible are a couple of annual reports, the excel-sheets for Mitsubishi and Ford, the generator itself (a .jar – just like the free demo-package to be downloaded from our website) and the input-file, renamed to automotive.txt The output-file automotive.htm – the actual 3D-graph – is already present because of the first attempt.
The same screen appears when looking for the output-file. If there is none yet, the name of a new file can be entered. The extension will be .htm anyway. This time the output-file was already present and the generator asked me if I wanted to overwrite. I clicked “Yes”. The result is the screen below:
Again we present a screenshot only, but a clickable one. On clicking the picture below original 3D-graph will be shown in your web-browser. Suddenly Mitsubishi Motors looks small, because Ford is so much larger. The values are 5 – 15 times higher (e.g. revenue for Ford is about 150 billion USD, but for Mitsubishi Motors it is about 20 billion USD). When the other companies get in, we will resize the 3D-graph again.
(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.)
For more information, please have a look at our other posts, our website or our youtube-channel. Again, our free 3D-graph generator package (zip) can be downloaded, unpacked in a folder and the .jar file can be started immediately. The screens look the same as the pictures above (with some warnings it’s a demo). Only one company and one year will be visualised as only one data-line will be read, otherwise it’s equal to the paid version. For any questions, contact us at firstname.lastname@example.org
(Photo by hansbenn on Pixabay)