Comp Spread for AAPL?
RE
Tags:
(Orangutan, 285
Points)
on 4/11/11 at 11:20pm
whats up fellas
jw if anyone would be willing to post a comp spread for Apple. Would be a huge help as i'm trying to do some research for one of my classes.. been building my own comp spread and want to make sure im doing it right/using the correct multiples
thanks





BIWS.
BIWS.
fdba Emory Blaine and BBA or otherwise trying to find the perfect pseudonym.
theyve got one posted on
theyve got one posted on their site?
No, lol, unfortunately you
No, lol, unfortunately you have to buy it, it is part of the training course. This is actually a big request, you want someone to spread comps for you? Maybe give your universe and if a user is feeling kind they may pop them into a CIQ spreadsheet for you and pass it along. Otherwise get on yahoo finance dude and do the work yourself. As to data points, some that are common are:
Latest Fiscal Year:
LTM as of:
52-Week High
52-Week High Date
52-Week Low
52-Week Low Date
Daily Volume
Closing Price ()
% of 52-Week High
% of 52-Week Low
Total Common Shares
Market Capitalization
Plus: Total Debt
Plus: Preferred Stock
Plus: Minority Interest
Less: Cash and Equivalents
Enterprise Value
LTM Financials
Revenue
Gross Profit
Operating Income
EBITDA
LTM Growth / Margins
Revenue Growth
Gross Profit Margin
Operating Income Margin
EBITDA Margin
3-Yr. Avg. FY Growth / Margins
Revenue Growth
Gross Profit Margin
Operating Income Margin
EBITDA Margin
LTM Enterprise Value
EBITDA
Revenue
Operating Income
fdba Emory Blaine and BBA or otherwise trying to find the perfect pseudonym.
Use Capital IQ or a Bloomberg
Use Capital IQ or a Bloomberg Terminal
thanks ya i noticed that they
thanks ya i noticed that they require you to pay..
i figured to just use very basic multiples (and my professor is going to be helping me along the way) like:
EBITDA
EBITDA Margin
P/E
Rev. Growth (%)
EPS or EPS % change
EV
also, ive selected google, rim, hp as my comp companies and have success computing/finding EPS figures from all of their 10-k's
basically any sort of advice is appreciated.. after all this is a very basic undergrad valuation project
thanks again
no access to Cap IQ or
no access to Cap IQ or Bloomberg terminals unfortunately