Comments

You must log in or register to comment.

10kLines t1_iu3s07m wrote

"Values in Billions" once, drop the "B" on every single number

82

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".

10

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.

4

10kLines t1_iu4m5y7 wrote

Replacing 17 locations with 1 is not a wash. This is a very disingenuous read on the change.

2

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.

−8

sluttycupcakes t1_iu4kecw wrote

Should be obvious from context alone?

0

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.

1

restlessleg t1_iu3un51 wrote

sankey charts are super hard to make in tableau.

too much maths

71

friskytorpedo t1_iu4cbh1 wrote

Once you get the right template they're very transferable to other datasets.

10

Shigy t1_iu5nuk1 wrote

Anyone know why Tableau doesn’t have any tools for Sankey charts?

1

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.

0

Oktay_LS OP t1_iu3ogdw wrote

Source: Apple Investor Relations (apple.com), created on python.

21

ger_my_name t1_iu5akui wrote

Can you please advise as to which package in Python that you used? Thanks.

5

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?

2

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 ?

9

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.

30

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 ?

2

vikas_g t1_iu4m039 wrote

So, does the salary expense go to operating expense or cost of revenue ?

1

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.

2

app4that t1_iu41ax9 wrote

‘MacBook’ should just say Mac

Nice visual - would love to see just their AirPods broken down

Also hard to imagine 90 billion in a single quarter. Absolutely incredible. They are pulling in a billion dollars a day, every day is a billion dollar day…

9

thediesel26 t1_iu41un2 wrote

Apple might as well be a front for a money printing operation at this point

6

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).

1

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.

5

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

4

HarpoonNPuppies t1_iu4dqtx wrote

I keep seeing this and I’m confused… isn’t “Net Income” supposed to be “Net Profit”?

2

hgq567 t1_iu4mhiz wrote

Yeah it should be net profit…

2

sbenfsonw t1_iu65lb9 wrote

Net Income and Net Profit are interchangeable

Typically the final line item in a Income Statement in Net Income

2

avalonian422 t1_iu4fyox wrote

20 billion profit. Not bad kid.

2

rebootyourbrainstem t1_iu4m6zv wrote

Actually kind of surprised they "only" spend 5.8B on R&D

2

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.

1

Luder714 t1_iu5210j wrote

I you took half of their yearly profit and distributed it to each employee equally, they would each get over a million dollars. There would still be 40B profit.

2

londoncatvet t1_iu4a4lr wrote

As I understand it, "FAANG" is an acronym for Facebook Amazon Apple Netflix Google.

Shouldn't the heading read, "Apple"?

1

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.

5

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

4

tciopp t1_iu4papx wrote

MAGMA. Microsoft, Apple, Google, Meta, Amazon.

4

orrocos t1_iu4r59i wrote

Should Google be another A for Alphabet? Or is it left as G since their stock symbol is still GOOG?

2

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

1

alos t1_iu51b4q wrote

They created: Eureka, Ribbon, Hystrix, Archaious and many other OSS projects.

1

JumpingPotato1 t1_iu4nzjt wrote

Excellent Job including Profit Margin. Every time somebody makes an Operating Profit Chart like this it needs to be included.

1

9mije91 t1_iu4q557 wrote

Serious question. Where is all the money that is supposedly stashed overseas for future development ? Products cost?

1

1sttomars t1_iu4zbu9 wrote

"Apple may be the most resilient among the FAANGs this Earnings Season" says Apple investor relations slide.

1

swagaunaut t1_iu5cjlz wrote

Might be wrong here but isn't it Q3, not Q4.

1

jamck1977 t1_iu5t8xx wrote

I think it was the fiscal Q4, but could be wrong.

1

Daddywags42 t1_iu5dwsh wrote

So Apple hasn’t had a great new idea sense the iPhone?

1

Oktay_LS OP t1_iu5ux0j wrote

Still makes up almost half their revenue. Wild.

1

DeepTh0tt t1_iu6docy wrote

Let me tell you who does poorly during a recession. Companies like Apple.

Apple stands to lead the pack doing poorly.

1

WolverineLonely3209 t1_iu6drd3 wrote

Why do people include Netflix and Facebook but not Microsoft? FAANG means absolutely nothing at this point.

1

JohnnyAK907 t1_iu76u6h wrote

I hope this chart means something to someone, because to me it looks like a mess of IDE cables.

1

rashnull t1_iu7qbog wrote

Lol! More Apple devices means more what? Yes! You got it! More Googling, Amazon shopping, Prime watching, Netflix and chilling, Facegramming, Cloud Computering, Artificial Intellinting, Quantum Rebooting! Buy it all folks!

1

Jermachi t1_iu83lsp wrote

I don’t want to be that guy but you may want to change the weather icon to the iCloud icon.

1

PrestameUnSol t1_iufcegb wrote

Does anyone know if this kind of graph cam be done in ggplot2?

1

cindy6507 t1_iu491jr wrote

Because they actually build things

0

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

2

reddit_equals_censor t1_iu9831s wrote

you misspelled there

it's not called "tax"

it's called "theft"

0

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.

1

tthrivi t1_iu4577v wrote

So…why does apple need to raise the price of their services. Jeez.

−1

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.

3

londoncatvet t1_iu49rrg wrote

So...you're not a capitalist?

2

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.

7

TonyTheEvil t1_iu4j6ik wrote

Most people aren't, given hardly anyone actually owns any means of production

2

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.

1

DutchVortex t1_iu3svl2 wrote

6.8B spend on spies... How many spies do they have...

−3