IncomeStatementGuy
IncomeStatementGuy OP t1_j8ifulw wrote
Reply to comment by jeffinRTP in [OC] How Coca-Cola makes money (they just released their earnings for 2022) by IncomeStatementGuy
Makes sense, thanks!
IncomeStatementGuy OP t1_j8icayg wrote
Reply to comment by jeffinRTP in [OC] How Coca-Cola makes money (they just released their earnings for 2022) by IncomeStatementGuy
Thanks! Our tool has a free tier for creating and downloading Sankeys and a paid tier for online saving. With the paid tier users can decide to make the Sankey they create public. Then a link is generated such as this one.
But maybe there could be a better way to share them - do you have something in mind?
IncomeStatementGuy OP t1_j8i6eyv wrote
Reply to [OC] How Coca-Cola makes money (they just released their earnings for 2022) by IncomeStatementGuy
Info about the visualization:
- Data source: Coca-Cola's reported earnings
- Tool used to create the visualization: SankeyArt (I am also the developer of the tool)
Submitted by IncomeStatementGuy t3_1126fjq in dataisbeautiful
IncomeStatementGuy OP t1_j7jmlbk wrote
Reply to comment by zooomenhance in [OC] How Google makes money (its 2022 income statement visualized as a Sankey diagram) by IncomeStatementGuy
Will take a look
IncomeStatementGuy OP t1_j7gnw4c wrote
Reply to comment by zooomenhance in [OC] How Google makes money (its 2022 income statement visualized as a Sankey diagram) by IncomeStatementGuy
Would be interesting. Do you have a good source for the raw data?
IncomeStatementGuy OP t1_j7g127b wrote
Reply to comment by Sweaty-Curve-9918 in [OC] How Google makes money (its 2022 income statement visualized as a Sankey diagram) by IncomeStatementGuy
>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.
IncomeStatementGuy OP t1_j7fw7bd wrote
Reply to comment by tilman2015 in [OC] How Google makes money (its 2022 income statement visualized as a Sankey diagram) by IncomeStatementGuy
For example payments to Apple to be the default search engine on iPhone
IncomeStatementGuy OP t1_j7fvjkd wrote
Reply to comment by beatsnstuffz in [OC] How Google makes money (its 2022 income statement visualized as a Sankey diagram) by IncomeStatementGuy
What do you find difficult to follow in the visualization?
IncomeStatementGuy OP t1_j7facia wrote
Reply to comment by dinosaur-in_leather in [OC] How Google makes money (its 2022 income statement visualized as a Sankey diagram) by IncomeStatementGuy
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.
IncomeStatementGuy OP t1_j7f43vz wrote
Reply to comment by OfficialZygorg in [OC] How Google makes money (its 2022 income statement visualized as a Sankey diagram) by IncomeStatementGuy
This one is created with sankeyart.com (I am also the developer of this website / tool)
IncomeStatementGuy OP t1_j7eyqir wrote
Reply to comment by OfficialZygorg in [OC] How Google makes money (its 2022 income statement visualized as a Sankey diagram) by IncomeStatementGuy
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
IncomeStatementGuy OP t1_j7eskxm wrote
Reply to comment by Fox-noir in [OC] How Google makes money (its 2022 income statement visualized as a Sankey diagram) by IncomeStatementGuy
This year they had other expenses 4B. Last year they had other income, so the sign of the „other“ flipped.
IncomeStatementGuy OP t1_j7era3t wrote
Reply to comment by egonzo61 in [OC] How Google makes money (its 2022 income statement visualized as a Sankey diagram) by IncomeStatementGuy
These Silicon Valey engineers need to let off steam in some way I guess
IncomeStatementGuy OP t1_j7er4db wrote
Reply to comment by Separate-Ad-6224 in [OC] How Google makes money (its 2022 income statement visualized as a Sankey diagram) by IncomeStatementGuy
Yes, SankeyArt.com
I develop the website and used it to create this visual. Your use case is precisely what the website is for.
IncomeStatementGuy OP t1_j7djylr wrote
Reply to comment by jsveiga in [OC] How Google makes money (its 2022 income statement visualized as a Sankey diagram) by IncomeStatementGuy
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).
IncomeStatementGuy OP t1_j7ddfju wrote
Reply to [OC] How Google makes money (its 2022 income statement visualized as a Sankey diagram) by IncomeStatementGuy
- 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)
IncomeStatementGuy OP t1_j6pd5my wrote
Reply to comment by here_we_go_beep_boop in I built a site to visualize income statements as Sankey flow diagrams by IncomeStatementGuy
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?
IncomeStatementGuy OP t1_j6p1ak0 wrote
Reply to I built a site to visualize income statements as Sankey flow diagrams by IncomeStatementGuy
What do you think about it?
Feedback on the UI or suggestions for improvements or new features would be most welcome.
IncomeStatementGuy OP t1_j6otsjf wrote
Reply to comment by debunk_this_12 in [OC] McDonald's 2022 income statement (they just released their earnings) by IncomeStatementGuy
>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.
IncomeStatementGuy OP t1_j6op587 wrote
Reply to comment by kchro005 in [OC] McDonald's 2022 income statement (they just released their earnings) by IncomeStatementGuy
Is your PC profitable?
Submitted by IncomeStatementGuy t3_10q9471 in InternetIsBeautiful
IncomeStatementGuy OP t1_j6ognho wrote
Reply to comment by Salty_Employee_8944 in [OC] McDonald's 2022 income statement (they just released their earnings) by IncomeStatementGuy
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...
IncomeStatementGuy OP t1_j8k6zrr wrote
Reply to comment by ialghamdi1 in [OC] How Coca-Cola makes money (they just released their earnings for 2022) by IncomeStatementGuy
That's their cocaine expenses.
Special accounting rule because the substance is illegal when consumed in its pure form instead of dispersed in coke.