Data is the new oil XII – Microsoft: more green roofs

We are nearly at the end of the series and this time we have another runner-up. Yet in the 3D-graph Microsoft looks much smaller than the oil-majors. It grew like the other tech companies did, but not as fast as Apple or Amazon. Its revenue is smaller than Aphabet’s. The 2018 revenue is also smaller than Amazon’s but at the same time Microsoft’s revenue is larger and so is the equity. And again, all roofs are green. It means none of the companies had a loss during one of the three years shown!

Lady working in emergency call centre

Photo by Ernesto Eslava on Pixabay

In the end we might think of Microsoft and the other tech giants as incredibly large companies, but the oil-majors are still much more impressive. The question is whether the growth-rate of the the former will remain unchanged and at the same time we know fossil fules will come to an end and the oi&gas-companies have to reinvent themselves. Will solar, wind, other renewables and carriers like hydrogen be at the heart of their business? Will such a transition be enough to remain among the largest companies in the world?

Double-clicking the screenshot will open the 3D-graph in your browser. For maniputalion of this 3D-graph: Clicking the right mouse-button and moving the mouse up and down at the same time, will zoom the graph in and out.
Beware: the graph haw so many companies that zooming out first is necessary to see the whole picture! Clicking left while moving the mouse will tilt the graph in different directions. Double clicking in the graph translates it and readjusts the centre at the same time. Just try it – If you don’t know how to get the normal position back, refresh the page in your browser.

In the end the question is more like “will data be the new oil or will energy remain number one?” We know data-centres use a lot of energy, so the tech-giants might support the energy-companies at the same time. If new regulations come in for tech-companies, like we have seen for the financial sector, things might be very different.

For Microsoft it’s fun to see where it comes from.  The company has been around  for a while and I found a link showing the numbers for the nineties of the last century. The picture below shows a screenshot.

Microsoft finance nineties

For more background on the 3D-graph generator, download our white-paper  together with the 3D-graphs (html-format, available as zip). Or go to our website and download the free demo-package to try the 3D-graph generator yourself. New posts will be announced on Twitter: @AnRep3D and our Youtube-channel offers short explanatory movies on the 3D-graphs and the generator creating them.

Posted in Visualising Financial Information | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Data is the new oil XI – Alphabet: a pattern emerges

Finally another tech-giant, Alphabet. And the pattern in the tiltle? Well, the old industry is rather stable, but these new tech-companies seem to come from “nowhere” and are suddenly there – next to the oil-majors and manufacturers.

Back in 2008, when Alphabet was still called Google, the revenues were not so impressive from today’s perspective. They managed to increase it 24 times over a decade! Back in 2008, the annual report gave the amounts in thousands of dollars, but five years later it was millions already.

Then the gearing was always amazing. For some reason Google hardly has only a relatively small amount of liabilities, although the equity went down from nearly 90% of the balance-total to slighly above 75% – still impressive!

Different from other posts, we will offer you both a clickable screenshot and a movie. The screenshot shows Apple, Amazon, Samsung and Alphabet/Google and even 2008 is visible. They all have this amazing pattern of growth in all directions (revenue, equity, total assets). Largest companies visualised finances

Double-clicking the screenshot will open the 3D-graph in your browser. For maniputalion of this 3D-graph: Clicking the right mouse-button and moving the mouse up and down at the same time, will zoom the graph in and out. Clicking left while moving the mouse will tilt the graph in different directions. Double clicking in the graph translates it and readjusts the centre at the same time. Just try it – If you don’t know how to get the normal position back, refresh the page in your browser.

If you are not able to open the real 3D-graph or you just don’t want, you can have a look at the video below (actually an animated gif). Remarkable is that all roofs are green, meaning none of these huge companies suffered a loss in the selected years (2008, 2013, 2018).

Animation of 3D-graph

For more background on the 3D-graph generator, download our white-paper  together with the 3D-graphs (html-format, available as zip). Or go to our website and download the free demo-package to try the 3D-graph generator yourself. New posts will be announced on Twitter: @AnRep3D and our Youtube-channel offers short explanatory movies on the 3D-graphs and the generator creating them.

Posted in Visualising Financial Information | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Data is the new oil X – Oil again…

It will be a short update this time. After a couple of tech-related companies we are back at the oil. A “small” oil major this time as Chevron has a revenue of “only” 159 billion in 2018. It’s not little money of course, but compared to 2008 it’s only 58% of the revenue back then. It must have been a hard time for Chevron, because for Shell, BP and ExxonMobil it was 85%, 83% and 61% respectively. Looking at the equity, the picture is the other way round: 157%, 110%, 176%, 180% for Shell, BP, ExxonMobil and Chevron.

Photo by Gustavo Fring from Pexelswoman refuelling

This money can only come from either additional shares issued or profit (from operations or by e.g. selling parts of the company). Looking at the profits for 2018/2013/2008 we see Shell:6%/4%/6%, BP: 7%/7%/9%, ExxonMobil: 3%/6%/6% Chevron: 9%/10%/9% It seems they didn’t want to be the largest but the most profitable. Indeed it led to a fast growth of their equity (although dividends will eat a part of the profit and I didn’t check that part. Yet we know that e.g. Shell reduced the equity for the first time since World War II). With Chevron having the lowest 2018 revenue of the series, it was a good moment to sort the graph on this 2018 revenue as Chevron remains at the same position where an added  company will usually be: to the right.

Because the graph is broad by now, three screenshots are presented below. All three are clickable and will open the real 3D-graph in your browser (if JavaScript and WebGL are enabled that is).

Double-clicking the screenshot will open the 3D-graph in your browser. For maniputalion of this 3D-graph: Clicking the right mouse-button and moving the mouse up and down at the same time, will zoom the graph in and out. Clicking left while moving the mouse will tilt the graph in different directions. Double clicking in the graph translates it and readjusts the centre at the same time. Just try it – If you don’t know how to get the normal position back, refresh the page in your browser.

Below I present a picture of the numbers (including the parameter-line), so you can do the math yourself if you like.

12 3 10000 10 4 Revenue|Profit(loss) Equity Total Assets
R.D.Shell 2018 388379 23352 202534 399194
R.D.Shell 2013 451235 16271 181148 357512
R.D.Shell 2008 458361 26277 128866 282401
BP 2018 303738 9578 101548 282176
BP 2013 396217 23758 130407 305690
BP 2008 365700 21666 92109 228238
Exx.Mobil 2018 290212 20840 198528 346196
Exx.Mobil 2013 438255 32580 180495 346808
Exx.Mobil 2008 477359 45220 112965 228052
Apple 2018 265595 59531 107147 365725
Apple 2013 170910 37037 123549 207000
Apple 2008 32479 4834 21030 39572
VW 2018 264906 13650 133723 522115
VW 2013 256897 11925 122333 440671
VW 2008 178610 7459 51790 232601
Toyota 2018 258850 22785 175362 454046
Toyota 2013 222373 11520 135809 377281
Toyota 2008 262394 17146 118470 323968
Amazon 2018 232887 10073 43549 162648
Amazon 2013 74452 274 9746 40159
Amazon 2008 19166 645 2672 8314
Samsung 2018 221568 40306 225187 308448
Samsung 2013 216707 28878 142155 202857
Samsung 2008 96495 4686 46235 83771
Chevron 2018 158902 14860 155642 253863
Chevron 2013 220156 21597 150427 253753
Chevron 2008 273005 23931 86648 161165

No deep-dives this time as we are waiting for three tech-giants coming in: Alphabet, Microsoft and Facebook. Let’s see what they will bring us as revenue, profit (margin), equity, total assets (and gearing).

For more background on the 3D-graph generator, download our white-paper  together with the 3D-graphs (html-format, available as zip). Or go to our website and download the free demo-package to try the 3D-graph generator yourself. New posts will be announced on Twitter: @AnRep3D and our Youtube-channel offers short explanatory movies on the 3D-graphs and the generator creating them.

Posted in Visualising Financial Information | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Data is the new oil IX – Samsung. Boring? Not quite!

The next company in our series is a bit of a combination between the old economy and the new tech era. Samsung is a South-Korean chaebol, nowadays well-known for its mobile phones and other consumer-electronics. Yet all these devices are produced by only one of the companies in the chaebol: Samsung Electronics presenting itself simply as Samsung.

If we look at the whole company, it has a long history in trade but holds shipbuilding and engineering companies. Sansung Electronics is a manufacturer and looks much more like Apple, which is one of its customers at the same time (and vice versa).Korean woman

Photo by ksa61011 on Pixabay

Knowing this, the 3D-graph won’t surprise us! The new information-era (rather than the period of the old “electronics” being dominated by companies like Sony, Philips and General Electric) offered great opportunities for several companies to expand and become world-wide market leaders. Although Samsung wasn’t as “small” as Apple in 2008, the increase in revenue and equity –  and even in profit shows a similar growth over a decade. The front-view presents a company with an equity more like ExxonMobil or Shell than Apple.

The side-view shows a gearing that’s also more like ExxonMobil than Apple or Amazon, although the growth is similar to Apple’s pattern. When it comes down to the profit margin, Apple is still the winner.

Double-clicking the screenshot will open the 3D-graph in your browser. For maniputalion of this 3D-graph: Clicking the right mouse-button and moving the mouse up and down at the same time, will zoom the graph in and out. Clicking left while moving the mouse will tilt the graph in different directions. Double clicking in the graph translates it and readjusts the centre at the same time. Just try it – If you don’t know how to get the normal position back, refresh the page in your browser.

Please click at the screenshots and open the real 3D-graph in your browser. Try and move the graph and zoom, tilt or pivot. It can be done as it is just standard HTML5 (with  Javascript).

For more background on the 3D-graph generator, download our white-paper  together with the 3D-graphs (html-format, available as zip). Or go to our website and download the free demo-package to try the 3D-graph generator yourself. New posts will be announced on Twitter: @AnRep3D and our Youtube-channel offers short explanatory movies on the 3D-graphs and the generator creating them.

Posted in Uncategorized, Visualising Financial Information | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Data is the new oil VIII – Amazon, even more extreme

Last time we finally saw a tech-giant entering the 3D-graph. It was Apple, behaving very differently from the others as over the last decade it came from nowhere (well in comparison to the traditional set of giants like oil-majors that is) but still entered the gallery of the largest companies on earth.

This time we add Amazon and it’s even more extreme. So extreme that I had to put a red circle in one of the screenshots to make sure the readers won’t overlook the 2008 building in the graph!

Photo by monsieur_raddar on Pixabay

But first things first: Jeff Bezos told an interesting story right at the start of the annual report of 2018 and I liked it. It started with a short sentence: “To our shareowners: Something strange and remarkable has happened over the last 20 years. Take a look at these numbers:”

Then a series of years and percentages is shown. I converted the percentages to an old fashioned flat 2D-graph. Yes, really! Even I use these old technologies as they can be handy.

 

 

After all those numbers it goes on like this: “The percentages represent the share of physical gross merchandise sales sold on Amazon by independent third-party sellers – mostly small- and medium-sized businesses – as opposed to Amazon retail’s own first party sales.Third-party sales have grown from 3% of the total to 58%.

To put it bluntly:Third-party sellers are kicking our first party butt. Badly.

And it’s a high bar too because our first-party business has grown dramatically over that period, from $1.6 billionin 1999 to $117 billion this past year. The compound annual growth rate for our first-party business in that timeperiod is 25%. But in that same time, third-party sales have grown from $0.1 billion to $160 billion – acompound annual growth rate of 52%.”

Then it goes on and compares Amazon to eBay and explains how the ongoing adaptation of Amazon and its fullfilment contributed to the success. Knowing this you won’t be surprised by the 3D-graph at all!

Double-clicking the screenshot will open the 3D-graph in your browser. For maniputalion of this 3D-graph: Clicking the right mouse-button and moving the mouse up and down at the same time, will zoom the graph in and out. Clicking left while moving the mouse will tilt the graph in different directions. Double clicking in the graph translates it and readjusts the centre at the same time. Just try it – If you don’t know how to get the normal position back, refresh the page in your browser.

Wait, in the graph we see a little bit more than only growth. If we look at the revenue and profit (height and green roof), Amazon is similar to the others. The total assets and the equity however, are less then for the others. For 2018 both are about half of the average value in this graph. Looking back to the beginning of this post, we can understand why the total assets are rather low. Amazon is more and more a platform rather than a shop itself. For third parties less capital is needed. Only one question remains: if the (platform) software is so valueable, why is the value of the equity not much larger? It wasn’t in the annual report or, to be more precise, it was mentioned that the software-development was just expenses. I had to check why and to be honest; I was surprised to read that US-GAAP does not allow tech-companies to activate their in-house developed software, although it actually holds the real value of the company.

I didn’t realise that the only software at the balance-sheet are bought licences – and even booked as tangible assets in a lot of cases.

Photo by hamburgfinn on Pixabay

Imagine that a new company would be founded to fulfil let’s say Amazon’s Alexa–service and had to buy the necessary software from Amazon. It would have to pay a huge amount of cash or equivalents and Amazon’s equity would certainly get a boost. Yet in reality nothing would have changed because valuable assets (invisible from an accounting point of view and therefore not in the balance-sheet) would only be swapped for money. The difference would only be the way Amazon’s balance-sheet looks. After reading this, I think we have a real issue on the valuation of tech companies!

I still wasn’t fully convinced. Knowing that software is very important for Volkswagen as well, I had a look at the annual report 2019 and read:

“INTANGIBLE ASSETS Purchased intangible assets are recognized at cost and amortized over their useful life using the straight-line method. This relates in particular to software, which is normally amortized over three years. In accordance with IAS 38, research costs are recognized as expenses when incurred. Since the fourth quarter of 2019, development costs for future series products and other internally generated intangible assets are capitalized at cost, provided the cash-generating unit to which the respective intangible asset is attributable is not impaired. If the criteria for recognition as assets are not met, the expenses are recognized in the income statement in the year in which they are incurred.”

Photo by GoranH on Pixabay

Slide 14 of this presentation says that the share of in-house developed software has to go from 10% to 60%. The presentation is rather recent (end of 2019), so we can assume that currently 90% of Volkwagen’s software is bought. If so, al those costs can be recognised on Volkswagen’s balance-sheet as “assets” and until  now it is very different from companies like Amazon or Facebook, with their in-house developed software being invisible in their balance-sheets!

For more background on the 3D-graph generator, download our white-paper  together with the 3D-graphs (html-format, available as zip). Or go to our website and download the free demo-package to try the 3D-graph generator yourself. New posts will be announced on Twitter: @AnRep3D and our Youtube-channel offers short explanatory movies on the 3D-graphs and the generator creating them.

Posted in Visualising Financial Information | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Data is the new oil VII – Finally a tech-giant: Apple!

It took a while, but now the first of the tech giants took turns and the graph is extended with Apple. Hearing what is told about Apple – how rich it is and the incredible amount of cash being piled up – we would have expected it to be the first in our list. Then again, the list is not a recent one, so things might have changed and cash is not the same as total assets, of course.

Of course we could go on immediately and look into the financial status of Apple, but I won’t. Looking at the history of Apple at Wikipedia, thinking I knew a lot about how Jobs and Wozniak started their new company, there was a surprise for me. It seems Apple had a third founder who quit rather early for good reasons: Ronald Wayne.

It’s an interesting story and looking at Apple’s worth today compared to the USD 800 he got for his 10% of the shares back then, we wonder why. At the same time a lot of other promising companies didn’t make it for different reasnons and of course Apple could have been one of those. Yet, dividing Apple’s total value by the number of failing companies throughout the decades this risk-weighted result could still be higher than the lousy USD 800. By the way, anybody interested in taking a 10% participation in AnRep3D for let’s say USD 1000?

Women_with_Apple_laptop

Photo by Tranmautritam on Pexels

Okay, it’s time to get back to the 3D-graph, combining all kinds of financial information of the companies we selected so far. Until now it was – let’s be honest – a rather boring collection of shoe-boxes standing vertically, with green layers to the top. The sizes vary a little bit and we were able to discover some interesting things. However, when I looked at the graph with Apple in it, I thought I had made a mistake and started to look at the annual reports a second time. Well, you can look for yourself. The front view was not so unusual. The thick green roof shows that Apple makes a lot of profit, but that’s all. The 2018 graph to the front fits very well in the row of largest companies in the world.Apple finance in 3D-graph - front

Double-clicking the screenshot will open the 3D-graph in your browser. For maniputalion of this 3D-graph: Clicking the right mouse-button and moving the mouse up and down at the same time, will zoom the graph in and out. Clicking left while moving the mouse will tilt the graph in different directions. Double clicking in the graph translates it and readjusts the centre at the same time. Just try it – If you don’t know how to get the normal position back, refresh the page in your browser.

Then, turning to the side, the surprise came up making me look twice. In 2008 we see a dwarf and it’s for real! Apple used to be a rather modest company but kept growing. In 2013 (in the middle) it was already close to Toyota and in 2018 it can be compared to the oil-majors.Apple finance in 3D-graph - oblique

LoApple finance in 3D-graph - topoking from above, we can see that Apple’s equity (width of the building) is not very different from the equity of some other companies like Volkswagen, BP and Toyota, but the total assets are. This is represented by the depth of a building and for Apple it’s half as much as for the others. Since total Assets = Total Liabilities + Equity this can only mean that Apple neither has a lot of loans nor suppliers yet to be paid. Only five years later, the situation is different and suddenly the Apple building looks very similar to the other ones when looking from above. Will this be the influence of Tim Cook, turning previous innovations into money?

Finally we can have a look from aside and see clearly how Apple’s revenue and profit has been growing, while some other companies saw their revenue go down. Actually, Apple should have been added before Toyota and even Volkswagen!Apple finance in 3D-graph - side

Please click at the screenshots and open the real 3D-graph in your browser. Try and move the graph and zoom, tilt or pivot. It can be done as it is just standard HTML5 (with  Javascript).

For more background on the 3D-graph generator, download our white-paper  together with the 3D-graphs (html-format, available as zip). Or go to our website and download the free demo-package to try the 3D-graph generator yourself. New posts will be announced on Twitter: @AnRep3D and our Youtube-channel offers short explanatory movies on the 3D-graphs and the generator creating them.

Posted in Visualising Financial Information | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Data is the new oil VI – cars again! Toyota

The world is changing quickly because of Corona. The production and sales of cars went down suddenly and the question is whether these companies will be surpassed by the tech giants – if it didn’t happen already. Our ranking is a bit outdated, but we couldn’t go with moving targets, so Toyota is still the next in line when looking at the revenue. Now the interesting part is that Toyota was not part of the Automotive-series we published earlier, so this will not repeat something already in there like we did for Volkswagen.

Woman running

Photo by sasint on Pixabay

Toyota has a broken bookyear, ending at the end of the first quarter, but we will ignore for simplicity. Most mumbers in the annual reports are avaliable in both Yen and USG, so no need for conversion except 2018 where I could only get hold of amounts in yen.

I took historical exchange-rates from a site, but became suspicious when all dates showed the same rate, so I went to another site and converted the amounts again. As usual the balance is converted using the exchange-rate at the last day of reporting year (March 31, 2019) and for income-values the mid-year rate is taken (here: September 31, 2018).

Nothing spectacular comes up, apart from the lower profit in 2013. That’s the result of the crisis and quite normal.3D-graph finance of large companies

Double-clicking the screenshot will open the 3D-graph in your browser. For maniputalion of this 3D-graph: Clicking the right mouse-button and moving the mouse up and down at the same time, will zoom the graph in and out. Clicking left while moving the mouse will tilt the graph in different directions. Double clicking in the graph translates it and readjusts the centre at the same time. Just try it – If you don’t know how to get the normal position back, refresh the page in your browser.

The 2018 revenue is high and can be compared to Volkswagen’s and ExxonMobil’s. For now, Toyota will remain in the list of the world’s largest companies!

The good news is that next time it will be Apple’s turn. The largest tech-giant in the world, but what if we compare with the others, already in the 3D-graph?

For more background on the 3D-graph generator, download our white-paper  together with the 3D-graphs (html-format, available as zip). Or go to our website and download the free demo-package to try the 3D-graph generator yourself. New posts will be announced on Twitter: @AnRep3D and our Youtube-channel offers short explanatory movies on the 3D-graphs and the generator creating them.

Posted in Visualising Financial Information | Tagged , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Data is the new oil V – yet another oil major!

It must be really disappointing (for some people at least) to see that the largest companies in the world (measured by revenue) are still mainly oil-majors and (car-) manufacturers. The good news is that our list is a little bit outdated and things might have changed in between. Later we will sort our 3D-graph on 2018-revenue and see what the actual order will be. For now the next company in the queue is British Petroleum, better known as BP. Not a lot of work this time, as oil is still traded in dollars and therefore even this company from the UK publishes its annual reports in US Dollars.

Photo by Jerzy Górecki on Pixabay

The collection of the data was just routine. As always I checked the annual reports for the section of consolidated financial statements and picked Revenue, net Profit, Equity and total Assets and put the twelve numbers in the input-file (well, actually the excel which I exported as a .csv after the update).

This time I didn’t forget to increase the number of companies from 3 to 4. After starting the AnRep3D-generator I selected the .csv-file for input and again for output.

 

The generator automatically changes the extension from .csv to .htm and this way the output-file gets exactly the same name as the input-file. The output-file (the 3D-graph) was created in less than a second and the 3D-graph below was available!

 

 

Double-clicking the screenshot will open the 3D-graph in your browser. For maniputalion of this 3D-graph: Clicking the right mouse-button and moving the mouse up and down at the same time, will zoom the graph in and out. Clicking left while moving the mouse will tilt the graph in different directions. Double clicking in the graph translates it and readjusts the centre at the same time. Just try it – If you don’t know how to get the normal position back, refresh the page in your browser.

Now we have four companies – three oil (and gas) majors and one car-manufacturer. What do we see? Well, the first observation made from the front-view is that BP has less equity than the others. Actually the equity is less than half when compared to ExxonMobil or Royal Dutch Shell and it’s also less than Volkswagen AG’s equity. Yet the revenue is certainly higher than VW’s and even slightly higher than ExxonMobil’s, although not as high as the revenue for Shell (all 2018). Then, looking at the last we see the same remarkable drop we noticed for ExxonMobil from 2013 to 2018 (which was present for Shell as well, but less impressive). Comparing profit however, BP’s green roof is thinner than the others. In 2013 BP’s roof looks a lot thicker than Shell’s roof so things might go up and down a little bit in different patterns.

Then it’s time to move the graph more than the gently tilting we did so far. Using the right mouse-button and moving upwards at the same time will move the 3D-graph to the back and make it smaller. We have to do this create some space to be able to see the graph from the top. We can left-click the mouse and move down at the same time to get a top-view. If the image doesn’t appear in the centre, double-clicking (left) will recentre the graph. Try for a while until the behaviour of the environment (it’s HTML5) becomes more intuitive.

3D-graph of large companies - topThe top-view shows that BP’s total assets hardly increased and since the equity went up from 2008 to 2013 and then down again to 2018, the total liabilities certainly did not increase a lot – similar to the other oil majors, although they managed to keep their equity stable after 2013. The pattern doesn’t look like a divestment and neither does it look like an acquisition.

Somehow between 2013 and 2018 BP must have lost money – more money than the others and therefore probably not related to the market in general. We know the Gulf of Mexico oil spill (Deepwater Horizon) was in 2010, but the real impact was maily after 2013 because of all the legal procedures which took time. A series of low profit and even losses can be observed in this period (the annual reports for 2014-2017 are not visualised in this graph but if they would have been in, a couple of red roofs would have been visible). The year 2017 was still a year with a low profit and after this period 2018 is back again with a reasonable profit, but a reduced equity.

Then we can see some similarities between the Gulf of Mexico oil spill and the Volkswagen emission scandal, although the latter was not an accident. Why didn’t we see a similar impact in the Volkswagen “buildings”in this 3D-graph? I don’t know, but one of the reasons might be the timing. The discovery of the emissions scandal was at the end of 2015 – about five years later than BP’s accident. The impact for Volkswagen might still be waiting to happen and not have had its full size yet. The alternative is that the impact is very different from what happened to BP – for whatever reason. A small dip in the profit was observed for 2016, but for now we just cannot tell.

For more background on the 3D-graph generator, download our white-paper  together with the 3D-graphs (html-format, available as zip). Or go to our website and download the free demo-package to try the 3D-graph generator yourself. New posts will be announced on Twitter: @AnRep3D and our Youtube-channel offers short explanatory movies on the 3D-graphs and the generator creating them.

Posted in Visualising Financial Information | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Data is the new oil IV – from producer to consumer: Volkswagen

We are leaving the old-fashioned oil for now, but stay close at the same time. The subject of this post is Volkswagen. We’ve showed 3D-graphs for this company before, but that was in the automotive-series. This time it is because VW or Volkwagen Aktiengesellschaft (AG) is one of the largest companies in the world. Instead of producing oil, the company produces oil-consumers: cars with old-fashioned combustion engines, although something is moving. Nevertheless it is still a perfect fit!

Classic Volkswagen Van

Photo by Pexels on Pixabay

I have to admit that I was a little bit lazy and reused the old template from the automotive-series. Although only one year – 2013 – could be reused, it’s still 1/3 of the data-preparation. Then the EUR-values from the annual report have to be converted to USD, because that’s what we were using already and we cannot have different currencies in the graph. That structure was also in place in the template, although other exhange-rates apply.

3D-graph_3_large_companies

Double-clicking the screenshot will open the 3D-graph in your browser. For maniputalion of this 3D-graph: Clicking the right mouse-button and moving the mouse up and down at the same time, will zoom the graph in and out. Clicking left while moving the mouse will tilt the graph in different directions. Double clicking in the graph translates it and readjusts the centre at the same time. Just try it – If you don’t know how to get the normal position back, refresh the page in your browser.

After creating the graph (which as as always only took a couple of seconds), something struck me as odd. I remembered from the Automotive-blog how large and impressive the building of VW was and now it was suddenly not extremely impressive. Below I repeat the old Automotive-graph, to show how relative these comparisons are. Here in the new graph VW is among giants, but in the old one was the absolute “king of the graph”!Front-view 3D-graph

Apart from this the contrast with ExxonMobil and Shell is interesting, as those companies saw their revenues decrease (for seveal reasons), but for Volkswagen it has grown during the last decade. This is mainly drived by acquisitions.

For more background on the 3D-graph generator, download our white-paper  together with the 3D-graphs (html-format, available as zip). Or go to our website and download the free demo-package to try the 3D-graph generator yourself. New posts will be announced on Twitter: @AnRep3D and our Youtube-channel offers short explanatory movies on the 3D-graphs and the generator creating them.

Posted in Visualising Financial Information | Tagged , , , , , , , , , , , , , , , , , , , , | Leave a comment