Would be interesting. Do you have a good source for the raw data?

>Whats the difference b/w cost of revenue and operating expenses?? Is one hard assets and the other labor/personnel related??

Cost of revenue contains costs that are directly needed to produce and distribute the product/service. If you are an internet software company, you need to run servers, you might need to compensate the creators on your platform (this is the case for YouTube) and you might need to pay moderators to moderate your social network. These things are "cost of revenue".

Costs for, say, management salaries or R&D engineers are not directly needed to keep the product/service running, so they are operating expenses.

For example payments to Apple to be the default search engine on iPhone

What do you find difficult to follow in the visualization?

I am not sure but I think sales tax is not recognized as revenue in the first place such that isn't part of any of the flows visualized here.

This one is created with sankeyart.com (I am also the developer of this website / tool)

Do you mean the data input to create the diagram?

These are the first lines of the table (numbers are from the official Alphabet income statement)
Search advertising Ad revenue 162.45 148.951
Youtube Ad revenue 29.243 28.845
AdMob, AdSense & other Ad revenue 32.78 31.701
Ad revenue Revenue 224.473 209.497
Playstore and other Revenue 29.055 28.032
Google Cloud Revenue 26.28 19.206
Other revenue Revenue 3.028 0.902
Revenue Gross profit 156.633 146.698
Revenue Cost of revenue 126.203 110.939
Gross profit Operating profit 74.842 78.714
Gross profit Operating expenses 81.791 67.984

This year they had other expenses 4B. Last year they had other income, so the sign of the „other“ flipped.

These Silicon Valey engineers need to let off steam in some way I guess

Yes, SankeyArt.com

I develop the website and used it to create this visual. Your use case is precisely what the website is for.

They make more money by serving you personalized ads.

Collecting data about you increases their revenue lines for Search, YouTube and AdSense (ads on websites other than Google and YouTube).

• Data source: Alphabet's income statement for the year 2022; data from the FORM 10-K submitted to the SEC: https://www.sec.gov/Archives/edgar/data/1652044/000165204423000016/goog-20221231.htm
• Tool to create the diagram: SankeyArt (I am the developer of this tool)

Thanks! There is no .CSV upload yet but I think many people have the data in Excel or in Google Sheets. They can just ctrl C + ctrl V them into my spreadsheet user interface.

Which software outputs a .CSV but does not allow table/spreadsheet copying?

What do you think about it?
Feedback on the UI or suggestions for improvements or new features would be most welcome.

>https://www.sec.gov/Archives/edgar/data/63908/000006390823000005/exhibit991-123122.htm

Thanks! But I think my terms are right.

I structured the visualization similarly to the structure of McDonald's income statement: https://www.sec.gov/Archives/edgar/data/63908/000006390823000005/exhibit991-123122.htm
Only difference is that I abbreviated their reported "income before provision for income taxes" as "income before taxes".

Depreciation is reported as part of their operating expenses.

Is your PC profitable?

Yes, that's on the feature list. I already played around with the official SEC API a bit but ran into issues.

In the meantime, I just create them manually :D
I currently only show links to 10 of them on the website. I need to adapt the UI to make all of them easy to discover...

Looks like a 15% margin on McDonald's Corporation-operated restaurants but an 84% margin on franchises. Astonishing. Didn't realize that when I created the diagram.

Happy to hear that - no need to download the software though. It's a web app (a link is in my profile, I don't want to post it here to self-promote too much).

It's teh freemium. Diagram creation and diagram download are free.
Saving on the server and removing the little watermark at the bottom requires a subscription.

• Data source: McDonald's SEC Filing, https://www.sec.gov/Archives/edgar/data/63908/000006390823000005/exhibit991-123122.htm
• Tool I used to create the diagram: SankeyArt (I am the developer of the tool)