FAANG revisited – alternative financial ratios visualised III

Two weeks ago I posted a rather heavy story, discussing a lot of financial theory. This time I will focus on the companies and the numbers again.

Before we go on, I have to share something. I really like MOOCs and I already attended a lot of courses at FutureLearn Some were about e.g. modern (online) marketing methods (as my education was about classical marketing), others were not related to AnRep3D at all.

Business Woman working

(Photo by Daniela_oliiver on Pixabay)

This time I took a course from edX about finding the right markets for ones technological innovations. I think AnRep3D is very innovative after all, but it was designed for the visualisation of financial information in the first place. Yet there are other opportunities out there, I think. This means that during the next period I will show examples of alternative subjects again, as I already did with energy. Of course energy will be an important target market as well and I will blog about it, but I am also thinking of new markets.

Autonomous light bulb

(Photo by ColiN00B on Pixabay)

A bit scary, because I know about Finance and Energy and the other subjects might be less familiar to me. Well, let’s see what comes up. I hope you will like it!

Back to the FAANG companies! We already saw Amazon in the 3D-graph and now we should combine it with Alphabet. Although the name of the holding changed from Google to Alphabet, the stock exchange still refers to it as GOOG, but I put in a label Alphabet.

Google SEO (Photo by Simon on Pixabay)

Of course I had to extract some numbers from the Forms 10-Q. The format is really nice and clear, but still companies have some room for their own structure. It turns out Alphabet only mentions cumulative “Net cash provided by operating activities”, so for Q2 – Q4 calculations were needed.  There is no Q4 of course as this will be covered by form 10-K, so the values for Q3 have to be subtracted for Revenue and Cash Flow. As the balance is a snapshot one has only to be careful to pick the right rows and columns – no calculations needed.

After generating the 3D-graph with the two companies in, I decided to reverse the order again. It seems so logical to enter the values chronologically, but the most recent values are the most interesting. By turning the 3D-graph around, we can see the reversed order, so no information gets lost. The picture below (clickable, as usual) is a composite. In the real 3D-graph the legend (key) is in front of the “buildings” and below ground-level, but to keep the picture more compact I inserted another screenshot.

Amazon Alphabet 3D

Double-click the screenshot to see the live 3D-graph in your browser. For manipulation: Clicking the right mouse-button, moving the mouse up and down will zoom the graph in and out. Clicking left and moving the mouse 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, 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  On Twitter we are @AnRep3D

That’s all for now. Next time I hope I will be able to add Apple and then we will probably move on, exploring other subjects. Yet Finance will be visited on a regular basis.

Mars rover (Photo by WikiImages 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. As per 2021 a second product is available: EnRep3D. It is meant to visualise energy. Although the engine is the same, the texts, manual, website and examples (including blogposts) are focused at energy.
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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.