201131116164063
201131116164063
201131116164063
201131116164063
201131116164063
201131116164063
201131116164063
201131116164063
201131116164063
10100000
3
fMCKAYVALUATIONBYFREECASHFLOWANDABNORMALEARNINGSMETHODSFILEMCK_1XLS
154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204
AF_sub_cseeSect6RealPPErevsKMseeSectio
6HseeSectio
6NetPPEreve
uesDepreciatio
etPPERetireme
ts
etPPETaxesTaxratePPEtaxlifeqJseeSectio
8Timi
gdiffs
etPPEI
terestrateitemsRealborrowi
grateNomi
alborrowi
grateRealcostofequityNomi
alcostofequityBookvaluetargetforfi
a
cialstre
gthThisyearsshorttermlastyearslo
gtermdebtlastyears
etPPE
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
315
33914975
29214964
33116465
37915104
44313320
38414253
35514853
34915163
34215373
33615683
33015893
324161103
318164112
311166122
305169132
299172142
S87861058005100426293174152
T
293174152
390
390
390
390
390
390
390
390
390
390
390
390
390
390
390
390
390
358
374
406
401
378
347
334
371
377
383
388
394
400
405
411
417
422
39052160428
390
428
6090118148
6090118148
6090118148
6090118148
6090118148
6090118148
6090118148
6090118148
6090118148
6090118148
6090118148
6090118148
572
572
572
572
572
572
572
572
572
572
572
572
200
200
200
200
200
200
200
200
200
200
200
200
VALUECALCULATIONS11FreeCashFlowExcessmarketablesecuritiesatyearstartI
terestbeari
gdebtatyearstartFreecashflatyeare
dWACCComputedvalueofoperassetsatyearstartComputedequityvalueatyearstarti
cludi
gdeferredtaxesDesiredEDEyear12ResultEDEyear12ResultEDEallyearsDriveto0byGoalSeekvaryyear1Bookvalue23456789101112
001155591011985
001159771012128
001300031012420
001368331012662
001477671012900
0015881051013127
0016911481013339
0017831941013530
0018622421013694
0019243241013826
0019493381013891
0019742821013948
830500500418
968
1120
1294
1423r