DeagolModel_F10Q3.xlsx

• Currently 0.00/5 Stars.

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

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

Apple guidance 13,200 2.34

Analysts consensus 14,604 3.05

Deagol estimates 15,750 3.57

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

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

Apple guide (est.) 16.450 3.27

Analysts consensus 16,453 3.69

Deagol estimates 18,271 4.46

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

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

Analysts consensus 71,225 16.16

Deagol estimates 83,993 20.48

Valuation (12mo beginning on) EPS($) 25x 20x

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

Trailing (Jul-2009) 13.34 334 267

Fair value (Jul-2010) 19.05 476 381

1yr target (Jul-2011) 24.23 606 485

Revenue breakdown:

Mac 4,125 ( 3,338 @ $1,236)

iPad 2,150 ( 3,258 @ $ 660)

iPhone 5,456 ( 9,042 @ $ 603)

iPod 1,655 (10,124 @ $ 163)

iTunes 1,258

Software 641

Periph 465

Income statement:

Revenue 15,750

COGS 9,497

GM 6,253

OpEx 1,850

OpInc 4,403

OI&E 62

Pre-tax 4,465

Tax 1,161

NetInc 3,304

Shrs. 925

EPS 3.57

Ratios:

GM% 39.7%

OpInc% 28.0%

Tax% 26.0%

NetInc% 21.0%