Welcome to the MacNN Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

You are here: MacNN Forums > Community > MacNN Lounge > AAPL 10-K Released Today: I made pretty graphs

AAPL 10-K Released Today: I made pretty graphs
Thread Tools
Mac Elite
Join Date: Nov 2002
Location: Washington, DC
Status: Offline
Reply With Quote
Dec 4, 2004, 02:47 AM
 
I'm currently in a financial statements analysis class and with today's 10-K release I've updated some graphs that I thought others might like to see without digging through a financial document. Let me know if you have any questions.











(Last edited by sworthy; Dec 4, 2004 at 02:54 AM. )
     
Professional Poster
Join Date: Mar 2002
Location: Smallish town in Ohio
Status: Offline
Reply With Quote
Dec 4, 2004, 03:01 AM
 
Nice graphs!!

I have a suggestion. Make the year 2000 be on the left and the year 2004 on the right hand side. That way the progression by year looks more linear (left to right), unless of course you are Israeli or Arab
     
sworthy  (op)
Mac Elite
Join Date: Nov 2002
Location: Washington, DC
Status: Offline
Reply With Quote
Dec 4, 2004, 03:05 AM
 
oops. good find. In financial statements the current year is typically furthest left, mistake of habit I guess. I'll be sure to fix that before I turn it in next week.
     
Professional Poster
Join Date: Mar 2002
Location: Smallish town in Ohio
Status: Offline
Reply With Quote
Dec 4, 2004, 03:09 AM
 
Oh, do whatever you have to do to make it look best for turning in for class or a course or something. But for MacNN non-financial junkies like me it looks best to have the latest year on the right hand side
     
Mac Elite
Join Date: May 2003
Status: Offline
Reply With Quote
Dec 4, 2004, 03:14 AM
 
So the bars and lines, what do they all MEAN?
     
Professional Poster
Join Date: Jan 2001
Location: Between Sydney and Melbourne
Status: Offline
Reply With Quote
Dec 4, 2004, 06:14 AM
 
Originally posted by SafariX:
So the bars and lines, what do they all MEAN?
They mean everythings going to be alright.
     
Mac Elite
Join Date: Apr 2002
Location: Miami Beach
Status: Offline
Reply With Quote
Dec 4, 2004, 07:27 AM
 
Step One: Steal Underpants
Step Two: ...
Step Three: Profits!
     
Addicted to MacNN
Join Date: Aug 2004
Location: Outfield - #24
Status: Offline
Reply With Quote
Dec 4, 2004, 07:48 AM
 
Purty.
     
Addicted to MacNN
Join Date: Aug 2000
Location: Retired
Status: Offline
Reply With Quote
Dec 4, 2004, 08:23 AM
 
Whoah...grooooooovy!
Power Macintosh Dual G4
SGI Indigo2 6.5.21f
     
Professional Poster
Join Date: Mar 2002
Location: Smallish town in Ohio
Status: Offline
Reply With Quote
Dec 4, 2004, 09:02 AM
 
oops double post
(Last edited by macintologist; Dec 4, 2004 at 09:08 AM. )
     
Mac Elite
Join Date: Sep 2000
Location: Rochester, NY, USA
Status: Offline
Reply With Quote
Dec 4, 2004, 09:13 AM
 
Originally posted by SafariX:
So the bars and lines, what do they all MEAN?
One thing it means: Apple is selling a metric shitload of iPods.

Another thing it means is that if Apple never got into the iPod or music business, they wouln't be nearly as profitable. (I'll bet that the iPod line, even with its lower margins, is providing at least half of the company's profit.)

edit: got my math wrong, sorry...

Member of the the Stupid Brigade! (If you see Sponsored Links in any of my posts, please PM me!)
     
sworthy  (op)
Mac Elite
Join Date: Nov 2002
Location: Washington, DC
Status: Offline
Reply With Quote
Dec 4, 2004, 12:16 PM
 
Yea, the two things that are driving growth right now are iPods and the retail stores. However, the iPod brought in less revenues than either the powerbook or powermac last year (though the iPod will certainly bring in the most next year).

The graph that scared me the most was the net profit with the stock option expense. Basically, with current accounting rules, a company's "net profit" does not have to include stock option expenses (such as Jobs' $74 million). The red bar represents Apple's profits if they had expensed stock options, which is something all companies will have to do in the future. If you look at it that way, 2004 was the first year Apple has been profitable since 2000.
     
Mac Elite
Join Date: Sep 2004
Location: Theory - everything works in theory
Status: Offline
Reply With Quote
Dec 4, 2004, 01:04 PM
 
Originally posted by sworthy:
...
The graph that scared me the most was the net profit with the stock option expense. Basically, with current accounting rules, a company's "net profit" does not have to include stock option expenses (such as Jobs' $74 million). The red bar represents Apple's profits if they had expensed stock options, which is something all companies will have to do in the future. If you look at it that way, 2004 was the first year Apple has been profitable since 2000.
But, FASB nor the gov't know exactly how they want to treat options yet. However, in the near future (most likely 2005), options will have to be treated as an expense somehow and most tech companies like Apple will take a hit on their profits (or increase losses).

Now, if you're a company like Microsoft and have a Gizillion dollars and thus can afford to give your employees (essentially outright) stock, you don't have to worry about these upcoming rules as much. Ah, so nice to be rich.

BTW, nifty graphs.
     
Clinically Insane
Join Date: Dec 1999
Status: Offline
Reply With Quote
Dec 4, 2004, 01:19 PM
 
You can tell from the graphs that the iPod is a sure loser. Who the hell would pay $400 for a MP3 player?
"…I contend that we are both atheists. I just believe in one fewer god than
you do. When you understand why you dismiss all the other possible gods,
you will understand why I dismiss yours." - Stephen F. Roberts
     
Mac Elite
Join Date: May 2003
Status: Offline
Reply With Quote
Dec 4, 2004, 02:36 PM
 
Originally posted by olePigeon:
You can tell from the graphs that the iPod is a sure loser. Who the hell would pay $400 for a MP3 player?
     
Mac Elite
Join Date: Dec 1999
Location: Plainview, NY
Status: Offline
Reply With Quote
Dec 4, 2004, 04:33 PM
 
nice graphs. before you turn it in fix "segement" vs. "segment" in the last one tho.
     
sworthy  (op)
Mac Elite
Join Date: Nov 2002
Location: Washington, DC
Status: Offline
Reply With Quote
Dec 4, 2004, 06:50 PM
 
Originally posted by spiky_dog:
nice graphs. before you turn it in fix "segement" vs. "segment" in the last one tho.
Damn excel and it not spell checking

Thanks though
     
Professional Poster
Join Date: Oct 2000
Location: Toronto, ON
Status: Offline
Reply With Quote
Dec 4, 2004, 06:56 PM
 
Originally posted by olePigeon:
You can tell from the graphs that the iPod is a sure loser. Who the hell would pay $400 for a MP3 player?
Not me, brother! Zen Xtra all the way!
     
Mac Elite
Join Date: Oct 2003
Location: New York City, NY
Status: Offline
Reply With Quote
Dec 4, 2004, 07:46 PM
 
no i'd rather have the super 100 dollar pencil shaped 64mb mp3 player with buttons i cannot accurataely program and an LCD screen that shows only how loud the speakers are going.
iamwhor3hay
     
Addicted to MacNN
Join Date: Mar 2001
Location: Seattle, WA
Status: Offline
Reply With Quote
Dec 4, 2004, 07:52 PM
 
Don't you have a weeding to plan?

...some people and free time...seesh...
The spirit of resistance to government is so valuable on certain occasions, that I wish it always to be kept alive.
- Thomas Jefferson, 1787
     
sworthy  (op)
Mac Elite
Join Date: Nov 2002
Location: Washington, DC
Status: Offline
Reply With Quote
Dec 4, 2004, 08:59 PM
 
Originally posted by juanvaldes:
Don't you have a weeding to plan?

...some people and free time...seesh...
This way I have excel templates in place to calculate the wedding expenses!

Though I wouldn't have had to worry at all if I got in early on this:

     
Clinically Insane
Join Date: Jun 2001
Location: planning a comeback !
Status: Offline
Reply With Quote
Dec 4, 2004, 09:15 PM
 
Originally posted by sworthy:
Damn excel and it not spell checking
Rrrright. Blame it on M$ and Steve B.

For the rest of us: Excel spell-check is just one button away !

-t
     
sworthy  (op)
Mac Elite
Join Date: Nov 2002
Location: Washington, DC
Status: Offline
Reply With Quote
Dec 4, 2004, 10:22 PM
 
true, but it doesn't (or I at least don't think) underline misspellings as you type. See, they're not consistent! It's not my fault
     
Addicted to MacNN
Join Date: Oct 2001
Location: Yokohama, Japan
Status: Offline
Reply With Quote
Dec 4, 2004, 10:39 PM
 
Two things that jumped out at me were:
1. iPod sales boom, as others have pointed out, and
2. iMac sales seem to have suffered the most. I suppose the iMac G5 hasn't had much time to affect these numbers though.
     
Professional Poster
Join Date: Mar 2002
Location: Smallish town in Ohio
Status: Offline
Reply With Quote
Dec 5, 2004, 05:53 AM
 
They really need to cut the price on iMacs and make it priced as a consumer and not a prosumer machine which is what it is now.
     
   
Thread Tools
Forum Links
Forum Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Top
Privacy Policy
All times are GMT -5. The time now is 02:02 AM.
All contents of these forums © 1995-2011 MacNN. All rights reserved.
Branding + Design: www.gesamtbild.com
vBulletin v.3.8.7 © 2000-2011, Jelsoft Enterprises Ltd., Content Relevant URLs by vBSEO 3.3.2