DeagolModel_F10Q2.xlsx

• Currently 0.00/5 Stars.

3mo ending Mar-2010 Rev($M) EPS($)

------------------- ------- ------

Apple guidance 11,200 2.12

Analysts consensus 11,960 2.44

Deagol estimates 12,594 2.77

3mo ending Jun-2010 Rev($M) EPS($)

------------------- ------- ------

Apple guidance (e) 13.200 2.40

Analysts consensus 12,913 2.63

Deagol estimates 14,675 3.21

12mo ending Sep-2010 Rev($M) EPS($)

-------------------- ------- ------

Analysts consensus 55,091 12.01

Deagol estimates 59,721 13.66

Valuation (12mo beginning on) EPS(e) PPS(25x)

----------------------------- ------ --------

Trailing (Apr-2009) 11.22 281

Fair value (Apr-2010) 15.72 393

1yr target (Apr-2011) 19.82 495

Revenue breakdown:

Mac 3,893 ( 2.95M @ $1,320)

iPhone 4,764 ( 7.50M @ $ 635)

iPod 1,681 (10.40M @ $ 162)

Music 1,238

Software 608

Periph 412

-------- ------

Total 12,594

Income statement:

Revenue 12,594

COGS 7,367

GM 5,227

OpEx 1,631

OpInc 3,595

OI&E 35

Pre-tax 3,631

Tax 1,089

NetInc 2,541

Shrs. 918

EPS 2.77

Ratios:

GM% 41.5%

OpInc% 28.5%

Tax% 30.0%

NetInc% 20.2%