Submitted by Oktay_LS t3_yfjjl5 in dataisbeautiful
Comments
DutchVortex t1_iu3svl2 wrote
6.8B spend on spies... How many spies do they have...
respawn_12 t1_iu3t6qs wrote
I am new to the whole finance world. So forgive me for the stupid question but what is operating expense ? And why it is not included in cost of revenue section ?
restlessleg t1_iu3un51 wrote
sankey charts are super hard to make in tableau.
too much maths
himishim t1_iu3v34e wrote
Operating costs would be costs that are not directly associated with the products or services produced. For example, to produce an individual iPhone, the material and labour would be part of the cost of revenue since you can attribute a specific cost per item for the good. However, the rent you pay for the factory would be part of the operating cost since it is not tied directly to producing the iPhone. You would be the same rent if you produced 0 iPhones for that period or 1m.
Oktay_LS OP t1_iu3wkci wrote
Not a bad idea…
thedarkwarlord t1_iu3ytej wrote
Does MacBook include Mac desktops?
thediesel26 t1_iu41un2 wrote
Apple might as well be a front for a money printing operation at this point
respawn_12 t1_iu44yp2 wrote
Oh ok now it make sense. Thanks
respawn_12 t1_iu4521c wrote
Do you know any good resources for beginners to learn this ? Like how to read financial reports and deduce the health of the company ?
catfishman112 t1_iu45hkw wrote
what is this type of chart called?
[deleted] t1_iu46i0d wrote
[removed]
Yossarian216 t1_iu48of6 wrote
Because capitalism is at its core a cancerous philosophy that demands constant growth? Like literally if Apple were to announce that their profits were simply going to stay at current levels, which is extremely profitable as this chart shows, their stock price would tank. And since executives are not only compensated by stock price but are often contractually obligated to keep prices high for shareholders, they have to constantly be increasing profit. It’s a completely perverse set of incentives hyper focused on short term outcomes, and it’s destroying the world.
londoncatvet t1_iu49rrg wrote
So...you're not a capitalist?
londoncatvet t1_iu4a4lr wrote
As I understand it, "FAANG" is an acronym for Facebook Amazon Apple Netflix Google.
Shouldn't the heading read, "Apple"?
[deleted] t1_iu4al9b wrote
[removed]
Yossarian216 t1_iu4bub9 wrote
I’m someone who thinks capitalism needs to be regulated and restrained in order to keep it from destroying the world, and we are failing miserably at this task. The banks that created the financial crisis in 2008 but were “too big to fail” are all even bigger now. Big companies control far too much already and are getting bigger all the time. How many people can live and work in our current society without being a customer of Apple or Google or Microsoft? That growth mentality, it infects everything we are currently doing. It’s why oil companies are price gouging us to raise their profits, which are then being used on stock buybacks to bump the stock price. It’s toxic, and it hurts and kills people, and it’s the primary driver behind climate change, which will eventually destroy human society.
So no, not really a capitalist.
friskytorpedo t1_iu4cbh1 wrote
Once you get the right template they're very transferable to other datasets.
UndercoverRichard t1_iu4cwhq wrote
Sankey diagram!
[deleted] t1_iu4cy7c wrote
[removed]
HarpoonNPuppies t1_iu4dqtx wrote
I keep seeing this and I’m confused… isn’t “Net Income” supposed to be “Net Profit”?
avalonian422 t1_iu4fyox wrote
20 billion profit. Not bad kid.
modern_milkman t1_iu4go6l wrote
Even better: "Values in Billion Dollars".
Then you can drop both the $ and the B. And you don't end up with confusing information like "Profit: $38".
catfishman112 t1_iu4gw09 wrote
Thanks man
WaywardTraveller t1_iu4ihkr wrote
So replace 17 characters with 18? Bit of a wash.
I'd argue for replacing the finance formatting of negative numbers with a more traditional minus sign. If you know what numbers in brackets in the context of financial reports, then all good...but I suspect most people don't find that obvious, especially when presented on an infographic.
TonyTheEvil t1_iu4j6ik wrote
Most people aren't, given hardly anyone actually owns any means of production
nlpnt t1_iu4jpb7 wrote
Someone was suggesting dropping Netflix, since they're not so much a tech company as a Hollywood studio anymore. They'd have to change the order to avoid...unfortunate implications. GAAF would work.
sluttycupcakes t1_iu4kecw wrote
Should be obvious from context alone?
Lemoncrazedcamel t1_iu4kfri wrote
Realistically it should never have been Netflix. Not sure why they were there over Microsoft. MMAAG is what it should be these days
insightful_pancake t1_iu4kmmv wrote
> Most people aren’t given hardly anyone actually owns any means of production
This reads like you just had a stroke. Not trying to offend, I just have no idea what you are trying to convey.
TonyTheEvil t1_iu4kpt7 wrote
Good point, added helpful comma
WaywardTraveller t1_iu4l1n7 wrote
You're missing the point: That format works fine in context where parties understand formatting used in finance.
That does not include the general public.
vikas_g t1_iu4m039 wrote
So, does the salary expense go to operating expense or cost of revenue ?
10kLines t1_iu4m5y7 wrote
Replacing 17 locations with 1 is not a wash. This is a very disingenuous read on the change.
rebootyourbrainstem t1_iu4m6zv wrote
Actually kind of surprised they "only" spend 5.8B on R&D
hgq567 t1_iu4mhiz wrote
Yeah it should be net profit…
WaywardTraveller t1_iu4mkui wrote
Lol you take this way too seriously dude...
But since you have, of course we can pick and choose which measure is most important. OH, and now we're looking at a difference of opinion...fancy that.
Lighten up. Life's too short to take things like this that seriously.
JumpingPotato1 t1_iu4nzjt wrote
Excellent Job including Profit Margin. Every time somebody makes an Operating Profit Chart like this it needs to be included.
ChineseCracker t1_iu4p2yw wrote
Because Google and others rely heavily on ad revenue. And advertising is among the first thing people cut during a market down turn
tciopp t1_iu4papx wrote
MAGMA. Microsoft, Apple, Google, Meta, Amazon.
himishim t1_iu4plmv wrote
Depends on how Apple treats it. The statements provided to the public were at the level represented here which is a high level.
It probably is a mix of both though. So, the labour element of the cost can have an element that is direct to the sales - I would say if they have a factory to produce iPhones - the individuals working in the assembly line would form the cost that is within the cost of revenue value shown. However, individuals such as more senior managers/ support staff/ back office, etc which would not be directly associated with production would sit in the operating expenses value.
Obviously it all ends up being counted to get the net income but separating it properly does provide information on what adjustments can be made to manage costs and this structure of presenting things is carried out to follow required standards for those statements.
orrocos t1_iu4r59i wrote
Should Google be another A for Alphabet? Or is it left as G since their stock symbol is still GOOG?
puttyarrowbro t1_iu4rr1b wrote
especially multi-step ones
RenanGreca t1_iu4u4mb wrote
This FAANG thing confuses me, why is Netflix considered a tech giant and not Microsoft? Netflix is a much smaller company than the others.
[deleted] t1_iu4unkd wrote
[deleted]
orangehorton t1_iu4zu21 wrote
FAANG is just an acronym for well performing stocks in the early 2010s. Due to a lot of them being tech companies, people over time just use the phrase to talk about tech companies in general, and not use it for the actual purpose the acronym started as
orangehorton t1_iu4zxfd wrote
FAANG is just an acronym for well performing stocks in the early 2010s. Due to a lot of them being tech companies, people over time just use the phrase to talk about tech companies in general, and not use it for the actual purpose the acronym started as
alos t1_iu51b4q wrote
They created: Eureka, Ribbon, Hystrix, Archaious and many other OSS projects.
ger_my_name t1_iu5akui wrote
Can you please advise as to which package in Python that you used? Thanks.
swagaunaut t1_iu5cjlz wrote
Might be wrong here but isn't it Q3, not Q4.
Daddywags42 t1_iu5dwsh wrote
So Apple hasn’t had a great new idea sense the iPhone?
Shigy t1_iu5nuk1 wrote
Anyone know why Tableau doesn’t have any tools for Sankey charts?
jamck1977 t1_iu5t8xx wrote
I think it was the fiscal Q4, but could be wrong.
Oktay_LS OP t1_iu5ux0j wrote
Still makes up almost half their revenue. Wild.
Adghar t1_iu5xh0a wrote
Surprised no one has asked yet that I could see. Is that a typo in the title? Q4 2022 has hardly even started, so this is Q3 2022 data, right?
sbenfsonw t1_iu65lb9 wrote
Net Income and Net Profit are interchangeable
Typically the final line item in a Income Statement in Net Income
sbenfsonw t1_iu65vd4 wrote
Nope, it’s Apple’s fiscal Q4
sbenfsonw t1_iu65y8i wrote
It’s Apple’s fiscal Q4 results
ChocolateBunny t1_iu69pvk wrote
>every day is a billion dollar day…
that hurts my head to think about. In a few minutes, they would have made more money than I'll ever make in my life time (assuming inflation doesn't get too rough).
[deleted] t1_iu6de33 wrote
[removed]
WolverineLonely3209 t1_iu6drd3 wrote
Why do people include Netflix and Facebook but not Microsoft? FAANG means absolutely nothing at this point.
WingTzu t1_iu6ldj8 wrote
Yeah, imo it just confirms the notion that Apple doesn't really "invent" a whole lot. What they do well is taking already conceived technologies and packaging them in a way no one else does.
restlessleg t1_iu6xjjt wrote
you can build one.
its just complicated af.
you need to know how to use a graphing calculator and translate that to tableau functions/calcs.
JohnnyAK907 t1_iu76u6h wrote
I hope this chart means something to someone, because to me it looks like a mess of IDE cables.
Positive-Pianist-218 t1_iu7cktj wrote
That’s… a great way to explain it.
Positive-Pianist-218 t1_iu7cvfb wrote
Thanks! I learned a lot. 👍🏼
Jestdrum t1_iu7d65e wrote
Because it's hard to pronounce FAAMG
[deleted] t1_iu7dart wrote
[removed]
DJScrambles t1_iu7fs0y wrote
Not to mention they are useless
Jordo_14 t1_iu7gzrh wrote
Martin Shkreli has a playlist on YouTube about company valuations and does a full beginners guide to how a company finances work.
I found extremely helpful back when I wanted to learn about investing and finance lingo.
https://youtube.com/playlist?list=PLJsVF3gZDcuTxcdH5FmQRTd6MiJ29X_OQ
ImprovedPersonality t1_iu83sww wrote
*Billion US Dollars
reddit_equals_censor t1_iu9831s wrote
you misspelled there
it's not called "tax"
it's called "theft"
ArkGuardian t1_iu9r0n8 wrote
lmao 4/90 is hardly theft - especially for a company like Apple that uses the justice system as much as it does to swing its IP hammer around.
DA-ZACHYZACHY t1_iubmdvt wrote
That's a pretty good margin
PrestameUnSol t1_iufcegb wrote
Does anyone know if this kind of graph cam be done in ggplot2?
Oktay_LS OP t1_iu3ogdw wrote
Source: Apple Investor Relations (apple.com), created on python.