ࡱ > b
! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ R o o t E n t r y F < ̚ @N W o r k b o o k G _ V B A _ P R O J E C T _ C U R " I
V B A E E ZO \ p Carter, Nicole B a = ThisWorkbook = p)8 X@ " 1 6 O c e a n S a n s S t d B o o k 1 T a h o m a 1 T a h o m a 1 T a h o m a 1 A r i a l 1 V e r d a n a 1 6 x
O c e a n S a n s S t d B o o k 1 6 O c e a n S a n s S t d B o o k 1 6 $ O c e a n S a n s S t d B o o k 1 6
O c e a n S a n s S t d B o o k 1 6 O c e a n S a n s S t d B o o k 1 6 O c e a n S a n s S t d B o o k 1 6 O c e a n S a n s S t d B o o k 1 6 O c e a n S a n s S t d B o o k 1 6 O c e a n S a n s S t d B o o k 1 6 O c e a n S a n s S t d B o o k 1 6 O c e a n S a n s S t d B o o k 1 T a h o m a 1 Q T a h o m a 1 Q T a h o m a 1 C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 , 8 C a l i b r i 1 8 C a l i b r i 1 8 C a l i b r i 1 > C a l i b r i 1 4 C a l i b r i 1 < C a l i b r i 1 ? C a l i b r i 1 h 8 C a m b r i a 1 C a l i b r i 1
C a l i b r i 1 C a l i b r i 1 C a l i b r i "$"#,##0;\-"$"#,##0 "$"#,##0;[Red]\-"$"#,##0 "$"#,##0.00;\-"$"#,##0.00 # "$"#,##0.00;[Red]\-"$"#,##0.00 5 * 0 _-"$"* #,##0_-;\-"$"* #,##0_-;_-"$"* "-"_-;_-@_- , ) ' _-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_- = , 8 _-"$"* #,##0.00_-;\-"$"* #,##0.00_-;_-"$"* "-"??_-;_-@_- 4 + / _-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_- "$"#,##0_);\("$"#,##0\) ! "$"#,##0_);[Red]\("$"#,##0\) " "$"#,##0.00_);\("$"#,##0.00\) ' " "$"#,##0.00_);[Red]\("$"#,##0.00\) 7 2 _("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_) . ) _(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_) ? : _("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_) 6 1 _(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) 4 / _-* #,##0.0_-;* \-#,##0.0_-;_-\ * "-"??_-;_-@_- 0.0% 0 + _-* #,##0_-;* \-#,##0_-;_-\ * "-"??_-;_-@_-
dd/mm/yyyy 0.0000
0.00000000 0.00000
0.000000 mmm\-yyyy 6 1 _-* #,##0.00_-;* \-#,##0.00_-;_-\ * "-"??_-;_-@_- 8 3 _-* #,##0.000_-;* \-#,##0.000_-;_-\ * "-"??_-;_-@_- : 5 _-* #,##0.0000_-;* \-#,##0.0000_-;_-\ * "-"??_-;_-@_- * % #,##0.00000000;\(#,##0.00000000\);"-" 0.0000000 + & * _-"$"#,##0;* \-"$"#,##0;* _-"$""-";@ * #,##0;* \-#,##0;* "-";@ 3 . * _-"$"#,##0.00;* \-"$"#,##0.00;* _-"$""-"??;@ & ! * #,##0.00;* \-#,##0.00;* "-"??;@ & ! #,##0.000000;\(#,##0.000000\);"-" " #,##0.0000;\(#,##0.0000\);"-" #,##0.00;\(#,##0.00\);"-" " #,##0.00;\ \(#,##0.00\);\ "-" #,##0;\(#,##0\);"-" #,##0.00;\(#,##0.00\);\ "-" 0.000%
#,##0.0000 ! [$-C09]dddd\,\ d\ mmmm\ yyyy [$-409]h:mm:ss\ AM/PM 0.0000% "Yes";"Yes";"No" "True";"True";"False" "On";"On";"Off" ] , [ $ - 2 ] \ # , # # 0 . 0 0 _ ) ; [ R e d ] \ ( [ $ - 2 ] \ # , # # 0 . 0 0 \ ) ff +
!
# P P ! ` " # $ % a > & ' ( * @ @ ' * @ ' * ' * @ @ ' * ( @ ' * ' * ( @ ' * @ @ ' * ' * ! @ ' * ! @ ' * ' @ ' * ' @ @ ' @ @ ' ' @ @ '
@ @ ' * @ @ ' * @ ' * @ ' @ @ ' @ ' * @ @ ' * @ ' * @ ' * ' * ' @ @ ' * @ @ ' @ @ ' * @ @ ( ' @ @ '
@ @ ' @ @ ! X ' ( @ @ ' * @ @ ' * !@ @ ( !@ @ ( * !@ @ ' * !@ @ ' * !!@ @ ' * ' * ' @ @ ' * @ @ ' @ @ '
@ @ ( @ @ ( * !@ @ ' * @ @ ' * @ @ ' * @ @ ' * ' @ @ ' ' ( ' * x ' * x@ @ ' @ @ h@ @ * @ @ @ . * ! @ . * @ @ . * x . ' * @ @ . * @ @ . * . * @ . * @ . * . ' @ ' @ ' ' ' ' @ @ . @ / * ! @ / * @ @ / * x / ' * @ @ / * @ @ / * / * @ / * @ / * / | | \}A }
0 0 _ ) ef [ $ - }A }
0 0 _ ) ef [ $ - }A }
0 0 _ ) ef [ $ - }A }
0 0 _ ) ef [ $ - }A }
0 0 _ ) ef [ $ - }A }
0 0 _ ) ef [ $ - }A }
0 0 _ ) L [ $ - }A }
0 0 _ ) L [ $ - }A }
0 0 _ ) L [ $ - }A }
0 0 _ ) L [ $ - }A }
0 0 _ ) L [ $ - }A }
0 0 _ ) L [ $ - }A }
0 0 _ ) 23 [ $ - }A }
0 0 _ ) 23 [ $ - }A }
0 0 _ ) 23 [ $ - }A }
0 0 _ ) 23 [ $ - }A }
0 0 _ ) 23 [ $ - }A } !
0 0 _ ) 23 [ $ - }A } "
0 0 _ ) [ $ - }A } #
0 0 _ ) [ $ - }A } $
0 0 _ ) [ $ - }A } %
0 0 _ ) [ $ - }A } &
0 0 _ ) [ $ - }A } '
0 0 _ ) [ $ - }A } )
0 0 _ ) [ $ - } } +
0 0 _ ) [ $ - ???# # 0 . ??? ???
??? }- } 1
0 0 _ ) }A } 5
a 0 0 _ ) [ $ - }A } ;
0 0 _ ) [ $ - }A } <
0 0 _ ) ? [ $ - }A } =
0 0 _ ) 23 [ $ - }- } >
0 0 _ ) } } @
??v 0 0 _ ) ̙[ $ - # # 0 .
}A } A
} 0 0 _ ) [ $ - }A } B
e 0 0 _ ) [ $ - }x } F 0 0 _ ) [ $ # #
} } G
??? 0 0 _ ) [ $ ???# # ???
???
??? }- } L
0 0 _ ) }U } M
0 0 _ ) [ $ # # }- } N
0 0 _ ) } } O } } P } } Q } } R } } S } } T } } U } } V } } W } } X } } Y } } Z } } [ } } \ } } ] } } ^ } } _ } } ` } } a } } b } } c } } d } } e } } f } } g } } h } } i } } j } } k } } l } } m } } n } } o } } p } } q } } r } } s } } t } } u } } v } } x } } y } } z } } { } } | } } } } } ~ } } } } } } } } } } }- } ef _ ) }- } ef _ ) }- } ef _ ) }- } ef _ ) }- } ef _ ) }- } ef _ ) }- } ef _ ) }- } ef _ ) }- } ef _ ) } } } } }- } ef _ ) }- } ef _ ) }- } ef _ ) }( } f _ )}( } ef f _ )}( } ef f _ )}( } ef f _ )}( } ef f _ )}( } ef f _ )}- } ef _ ) }( } ef f _ )}( } ef f _ )}( } ef f _ )}( } ef f _ )}( } ef f _ )} } } } } } } } } } }- } ef _ ) }( } ef f _ )}( } ef f _ )}( } ef f _ )}( } ef f _ )}- } ef _ ) }( } ef f _ )}( } ef f _ )}( } ef f _ )}( } ef f _ )}( } ef f _ )
20% - Accent1M
2 0 % - A c c e n t 1 ef %
20% - Accent2M "
2 0 % - A c c e n t 2 ef %
20% - Accent3M &
2 0 % - A c c e n t 3 ef %
20% - Accent4M *
2 0 % - A c c e n t 4 ef %
20% - Accent5M .
2 0 % - A c c e n t 5 ef %
20% - Accent6M 2
2 0 % - A c c e n t 6 ef %
40% - Accent1M
4 0 % - A c c e n t 1 L %
40% - Accent2M #
4 0 % - A c c e n t 2 L渷 %
40% - Accent3M '
4 0 % - A c c e n t 3 L %
40% - Accent4M +
4 0 % - A c c e n t 4 L %
40% - Accent5M /
4 0 % - A c c e n t 5 L %
40% - Accent6M 3
4 0 % - A c c e n t 6 Lմ %
60% - Accent1M
6 0 % - A c c e n t 1 23 %
60% - Accent2M $
6 0 % - A c c e n t 2 23ږ %
60% - Accent3M (
6 0 % - A c c e n t 3 23כ %
60% - Accent4M ,
6 0 % - A c c e n t 4 23 %
60% - Accent5M 0
6 0 % - A c c e n t 5 23 % !
60% - Accent6M 4
6 0 % - A c c e n t 6 23 % " Accent1A A c c e n t 1 O % # Accent2A ! A c c e n t 2 PM % $ Accent3A % A c c e n t 3 Y % % Accent4A ) A c c e n t 4 d % & Accent5A - A c c e n t 5 K % ' Accent6A 1 A c c e n t 6 F % (
Assumption ) Bad9 B a d % * Calculation, C a l c u l a t i o n +
Check Cell
C h e c k C e l l % ??? ??? ??? ??? , C o m m a -( C o m m a [ 0 ] . Comma 2 /& C u r r e n c y 0. C u r r e n c y [ 0 ] 1 Explanatory TextG 5 E x p l a n a t o r y T e x t % 2 : F o l l o w e d H y p e r l i n k 3 Formulae - Changed 4 Formulae - Linked 5 Good; G o o d a % 6 Header - Cover 7
Header - Page 8 Header - Subtitle 9 Header - Title : Header - Year Row ; Heading 1G H e a d i n g 1 I}% O < Heading 2G H e a d i n g 2 I}% ? = Heading 3G H e a d i n g 3 I}% 23 > Heading 49 H e a d i n g 4 I}% ?( H y p e r l i n k
@ Inputu I n p u t ̙ ??v% A Linked CellK L i n k e d C e l l } % B NeutralA N e u t r a l e % " N o r m a l
C Normal 2
D Normal 3
E Normal 4 F Noteb
N o t e G Outputw O u t p u t ???% ??? ??? ??? ??? H$ P e r c e n t I Percent 2 J Percent 2 2 K Percent 3
L Title1 T i t l e I}%
M TotalM T o t a l % O O N Warning Text? W a r n i n g T e x t % X T a b l e S t y l e M e d i u m 9 P i v o t S t y l e L i g h t 1 6 Q 2zpWI1. R X d Nick Langley - Personal View` h %%TOBA_CACHE%%
Quarter--> Dist IMD02P004 = U R:Portfolio ManagementReporting_Templates & Month End FilesRISAST Reporting.xls RISAST - Portfolio RISAST - Hedging RISAST - Performance RISAST - Transactions
RISAST - FeesY Y Y Y Y " i R:Portfolio ManagementCompany DataResearch_TemplatesCopy of Standard Company Model (draft 5.1).xls Outputs -->
Financials Valuation Stock Report Assumptions --> Diary
Core Items Div1 Financial Inputs Assoc Versions & Links --> Current Co Dbase WindowY Z ( ConDPS Dividend per share (c)Z Z !
RAREEBITDA RARE EBITDAZ Z RAREEBIT RARE EBITZ Z 2
RARENetResult RARE Net Result After TaxZ Z 5 ConNetResult Reported Net Result After TaxZ Y Z [sedol]Z
F@Z
Y Z . , HoldcoNonOpInc Non operating incomeZ 0 9 HoldcoNonOpExp Non operating expensesZ 3 _ HoldcoOEIProfit Outside equity interestsZ 3
HoldcoPension Unfunded pension liabilityZ 0 HoldcoOEIBal Outside equity interestsZ 3
HoldcoOthOpCF Other operating cash flowsZ 4 HoldcoOthInvCF Other investing cash flowsZ 0 HoldcoOEICap Outside equity interestsZ 1 HoldcoOEIDiv OEI distribution/dividendZ 4 HoldcoOthFinCF Other financing cash flows n " AssocFCF; ! AssocFY; & & $
AssocInvmt; n n ( AssocNetResult; A A ! AssocPE; % % " AssocTax; I I AUD; 3 3 ! BBSsens; [ [ Bondsens: \ " Cashsens; Z Z Code: & Company: % ConDPS; ! ConEBIT; a a # ConEBITDA; _ _ ConNA; $
ConNetDebt; Q Q & ConNetResult; " ConTotEq; " ConYield; [ [ CorpTax: u ! CPIsens; ^ ^ Currency: ! CurrentDate: CurrSub:
CurrSubVal: CurrUnit:
Div1: 0 % Div1AdjEBIT;
# Div1Amort; < < $
Div1Asset1; $
Div1Asset2; $
Div1Asset3; " Div1Bond; & Div1BondPrem; ( Div1BSCapTrans; " Div1Cash; f f ( Div1CFCapTrans; ! Div1Dep; ; ; % Div1DistPay; ! Div1Div; $
Div1DivInv; ! Div1DTL; $
Div1EBITDA; : : % Div1EBITTax; ( Div1ElimIntExp; 33 ( Div1ElimIntInc; 44 ) Div1ElimIntLiab; :: '
Div1ElimNCRec; 77 ) Div1ElimOpCosts; 22 '
Div1ElimOpRev; // ( Div1ElimOthInc; 00 % Div1ElimPay; 88 & Div1ElimProv; 99 * Div1ElimTradeRec; 66 % Div1Equity1; % Div1Equity2; ! Div1FCF; JJ Div1Fin: 0 " Div1FITB; w w Div1FY; & & ) Div1GrowthCapex; $
Div1Intang; | | $
Div1IntExp; > > $
Div1IntInc; G G % Div1IntLiab; % Div1IntPaid; $
Div1Invent; m m & Div1IssueCap; # Div1Liab1; # Div1Liab2; ( Div1MaintCapex; Div1NA; $
Div1NCmove; '
Div1NetBorrow; '
Div1NetResult; \ \ ! Div1NRI; Z Z $
Div1NRITax; [ [ $
Div1OEIBal; ( Div1OEIContrib; % Div1OpCosts; 0 0 # Div1OpRev; ) ) # Div1OthCA; r r # Div1OthCL; $
Div1OthInc; . . ! Div1Own; -- ! Div1Pay; Div1PE; % % ! Div1PPE; x x " Div1Prov; # Div1Purch; ! Div1Rec; g g % Div1Reserve; & Div1Retained; " Div1Sale; ! Div1Tax; N N % Div1TaxPaid; # Div1TotEq; Div1WC; Div2: 2 % Div2AdjEBIT;
# Div2Amort; < < $
Div2Asset1; $
Div2Asset2; $
Div2Asset3; " Div2Bond; & Div2BondPrem; ( Div2BSCapTrans; " Div2Cash; f f ( Div2CFCapTrans; ! Div2Dep; ; ; % Div2DistPay; ! Div2Div; $
Div2DivInv; ! Div2DTL; $
Div2EBITDA; : : % Div2EBITTax; ( Div2ElimIntExp; 33 ( Div2ElimIntInc; 44 ) Div2ElimIntLiab; :: '
Div2ElimNCRec; 77 ) Div2ElimOpCosts; 22 '
Div2ElimOpRev; // ( Div2ElimOthInc; 00 % Div2ElimPay; 88 & Div2ElimProv; 99 * Div2ElimTradeRec; 66 % Div2Equity1; % Div2Equity2; ! Div2FCF; JJ Div2Fin: 2 " Div2FITB; w w Div2FY; & & ) Div2GrowthCapex; $
Div2Intang; | | $
Div2IntExp; > > $
Div2IntInc; G G % Div2IntLiab; % Div2IntPaid; $
Div2Invent; m m & Div2IssueCap; # Div2Liab1; # Div2Liab2; ( Div2MaintCapex; Div2NA; $
Div2NCmove; '
Div2NetBorrow; '
Div2NetResult; \ \ ! Div2NRI; Z Z $
Div2NRITax; [ [ $
Div2OEIBal; ( Div2OEIContrib; % Div2OpCosts; 0 0 # Div2OpRev; ) ) # Div2OthCA; r r # Div2OthCL; $
Div2OthInc; . . ! Div2Own; -- ! Div2Pay; Div2PE; % % ! Div2PPE; x x " Div2Prov; # Div2Purch; ! Div2Rec; g g % Div2Reserve; & Div2Retained; " Div2Sale; ! Div2Tax; N N % Div2TaxPaid; # Div2TotEq; Div2WC; Div3: 4 % Div3AdjEBIT;
# Div3Amort; < < $
Div3Asset1; $
Div3Asset2; $
Div3Asset3; " Div3Bond; & Div3BondPrem; ( Div3BSCapTrans; " Div3Cash; f f ( Div3CFCapTrans; ! Div3Dep; ; ; % Div3DistPay; ! Div3Div; $
Div3DivInv; ! Div3DTL; $
Div3EBITDA; : : % Div3EBITTax; ( Div3ElimIntExp; 33 ( Div3ElimIntInc; 44 ) Div3ElimIntLiab; :: '
Div3ElimNCRec; 77 ) Div3ElimOpCosts; 22 '
Div3ElimOpRev; // ( Div3ElimOthInc; 00 % Div3ElimPay; 88 & Div3ElimProv; 99 * Div3ElimTradeRec; 66 % Div3Equity1; % Div3Equity2; ! Div3FCF; JJ Div3Fin: 4 " Div3FITB; w w Div3FY; & & ) Div3GrowthCapex; $
Div3Intang; | | $
Div3IntExp; > > $
Div3IntInc; G G % Div3IntLiab; % Div3IntPaid; $
Div3Invent; m m & Div3IssueCap; # Div3Liab1; # Div3Liab2; ( Div3MaintCapex; Div3NA; $
Div3NCmove; '
Div3NetBorrow; '
Div3NetResult; \ \ ! Div3NRI; Z Z $
Div3NRITax; [ [ $
Div3OEIBal; ( Div3OEIContrib; % Div3OpCosts; 0 0 # Div3OpRev; ) ) # Div3OthCA; r r # Div3OthCL; $
Div3OthInc; . . ! Div3Own; -- ! Div3Pay; Div3PE; % % ! Div3PPE; x x " Div3Prov; # Div3Purch; ! Div3Rec; g g % Div3Reserve; & Div3Retained; " Div3Sale; ! Div3Tax; N N % Div3TaxPaid; # Div3TotEq; Div3WC; Div4: 6 % Div4AdjEBIT;
# Div4Amort; < < $
Div4Asset1; $
Div4Asset2; $
Div4Asset3; " Div4Bond; & Div4BondPrem; ( Div4BSCapTrans; " Div4Cash; f f ( Div4CFCapTrans; ! Div4Dep; ; ; % Div4DistPay; ! Div4Div; $
Div4DivInv; ! Div4DTL; $
Div4EBITDA; : : % Div4EBITTax; ( Div4ElimIntExp; 33 ( Div4ElimIntInc; 44 ) Div4ElimIntLiab; :: '
Div4ElimNCRec; 77 ) Div4ElimOpCosts; 22 '
Div4ElimOpRev; // ( Div4ElimOthInc; 00 % Div4ElimPay; 88 & Div4ElimProv; 99 * Div4ElimTradeRec; 66 % Div4Equity1; % Div4Equity2; ! Div4FCF; JJ Div4Fin: 6 " Div4FITB; w w Div4FY; & & ) Div4GrowthCapex; $
Div4Intang; | | $
Div4IntExp; > > $
Div4IntInc; G G % Div4IntLiab; % Div4IntPaid; $
Div4Invent; m m & Div4IssueCap; # Div4Liab1; # Div4Liab2; ( Div4MaintCapex; Div4NA; $
Div4NCmove; '
Div4NetBorrow; '
Div4NetResult; \ \ ! Div4NRI; Z Z $
Div4NRITax; [ [ $
Div4OEIBal; ( Div4OEIContrib; % Div4OpCosts; 0 0 # Div4OpRev; ) ) # Div4OthCA; r r # Div4OthCL; $
Div4OthInc; . . ! Div4Own; -- ! Div4Pay; Div4PE; % % ! Div4PPE; x x " Div4Prov; # Div4Purch; ! Div4Rec; g g % Div4Reserve; & Div4Retained; " Div4Sale; ! Div4Tax; N N % Div4TaxPaid; # Div4TotEq; Div4WC; Div5: 8 % Div5AdjEBIT;
# Div5Amort; < < $
Div5Asset1; $
Div5Asset2; $
Div5Asset3; " Div5Bond; & Div5BondPrem; ( Div5BSCapTrans; " Div5Cash; f f ( Div5CFCapTrans; ! Div5Dep; ; ; % Div5DistPay; ! Div5Div; $
Div5DivInv; ! Div5DTL; $
Div5EBITDA; : : % Div5EBITTax; ( Div5ElimIntExp; 33 ( Div5ElimIntInc; 44 ) Div5ElimIntLiab; :: '
Div5ElimNCRec; 77 ) Div5ElimOpCosts; 22 '
Div5ElimOpRev; // ( Div5ElimOthInc; 00 % Div5ElimPay; 88 & Div5ElimProv; 99 * Div5ElimTradeRec; 66 % Div5Equity1; % Div5Equity2; ! Div5FCF; JJ Div5Fin: 8 " Div5FITB; w w Div5FY; & & ) Div5GrowthCapex; $
Div5Intang; | | $
Div5IntExp; > > $
Div5IntInc; G G % Div5IntLiab; % Div5IntPaid; $
Div5Invent; m m & Div5IssueCap; # Div5Liab1; # Div5Liab2; ( Div5MaintCapex; Div5NA; $
Div5NCmove; '
Div5NetBorrow; '
Div5NetResult; \ \ ! Div5NRI; Z Z $
Div5NRITax; [ [ $
Div5OEIBal; ( Div5OEIContrib; % Div5OpCosts; 0 0 # Div5OpRev; ) ) # Div5OthCA; r r # Div5OthCL; $
Div5OthInc; . . ! Div5Own; -- ! Div5Pay; Div5PE; % % ! Div5PPE; x x " Div5Prov; # Div5Purch; ! Div5Rec; g g % Div5Reserve; & Div5Retained; " Div5Sale; ! Div5Tax; N N % Div5TaxPaid; # Div5TotEq; Div5WC; Div6: : % Div6AdjEBIT;
# Div6Amort; < < $
Div6Asset1; $
Div6Asset2; $
Div6Asset3; " Div6Bond; & Div6BondPrem; ( Div6BSCapTrans; " Div6Cash; f f ( Div6CFCapTrans; ! Div6Dep; ; ; % Div6DistPay; ! Div6Div; $
Div6DivInv; ! Div6DTL; $
Div6EBITDA; : : % Div6EBITTax; ( Div6ElimIntExp; 33 ( Div6ElimIntInc; 44 ) Div6ElimIntLiab; :: '
Div6ElimNCRec; 77 ) Div6ElimOpCosts; 22 '
Div6ElimOpRev; // ( Div6ElimOthInc; 00 % Div6ElimPay; 88 & Div6ElimProv; 99 * Div6ElimTradeRec; 66 % Div6Equity1; % Div6Equity2; ! Div6FCF; JJ Div6Fin: : " Div6FITB; w w Div6FY; & & ) Div6GrowthCapex; $
Div6Intang; | | $
Div6IntExp; > > $
Div6IntInc; G G % Div6IntLiab; % Div6IntPaid; $
Div6Invent; m m & Div6IssueCap; # Div6Liab1; # Div6Liab2; ( Div6MaintCapex; Div6NA; $
Div6NCmove; '
Div6NetBorrow; '
Div6NetResult; \ \ ! Div6NRI; Z Z $
Div6NRITax; [ [ $
Div6OEIBal; ( Div6OEIContrib; % Div6OpCosts; 0 0 # Div6OpRev; ) ) # Div6OthCA; r r # Div6OthCL; $
Div6OthInc; . . ! Div6Own; -- ! Div6Pay; Div6PE; % % ! Div6PPE; x x " Div6Prov; # Div6Purch; ! Div6Rec; g g % Div6Reserve; & Div6Retained; " Div6Sale; ! Div6Tax; N N % Div6TaxPaid; # Div6TotEq; Div6WC; Div7: < % Div7AdjEBIT;
# Div7Amort; < < $
Div7Asset1; $
Div7Asset2; $
Div7Asset3; " Div7Bond; & Div7BondPrem; ( Div7BSCapTrans; " Div7Cash; f f ( Div7CFCapTrans; ! Div7Dep; ; ; % Div7DistPay; ! Div7Div; $
Div7DivInv; ! Div7DTL; $
Div7EBITDA; : : % Div7EBITTax; ( Div7ElimIntExp; 33 ( Div7ElimIntInc; 44 ) Div7ElimIntLiab; :: '
Div7ElimNCRec; 77 ) Div7ElimOpCosts; 22 '
Div7ElimOpRev; // ( Div7ElimOthInc; 00 % Div7ElimPay; 88 & Div7ElimProv; 99 * Div7ElimTradeRec; 66 % Div7Equity1; % Div7Equity2; ! Div7FCF; JJ Div7Fin: < " Div7FITB; w w Div7FY; & & ) Div7GrowthCapex; $
Div7Intang; | | $
Div7IntExp; > > $
Div7IntInc; G G % Div7IntLiab; % Div7IntPaid; $
Div7Invent; m m & Div7IssueCap; # Div7Liab1; # Div7Liab2; ( Div7MaintCapex; Div7NA; $
Div7NCmove; '
Div7NetBorrow; '
Div7NetResult; \ \ ! Div7NRI; Z Z $
Div7NRITax; [ [ $
Div7OEIBal; ( Div7OEIContrib; % Div7OpCosts; 0 0 # Div7OpRev; ) ) # Div7OthCA; r r # Div7OthCL; $
Div7OthInc; . . ! Div7Own; -- ! Div7Pay; Div7PE; % % ! Div7PPE; x x " Div7Prov; # Div7Purch; ! Div7Rec; g g % Div7Reserve; & Div7Retained; " Div7Sale; ! Div7Tax; N N % Div7TaxPaid; # Div7TotEq; Div7WC; Div8: > % Div8AdjEBIT;
# Div8Amort;
< < $
Div8Asset1;
$
Div8Asset2;
$
Div8Asset3;
" Div8Bond;
& Div8BondPrem;
( Div8BSCapTrans;
" Div8Cash;
f f ( Div8CFCapTrans;
! Div8Dep;
; ; % Div8DistPay;
! Div8Div;
$
Div8DivInv;
! Div8DTL;
$
Div8EBITDA;
: : % Div8EBITTax;
( Div8ElimIntExp;
33 ( Div8ElimIntInc;
44 ) Div8ElimIntLiab;
:: '
Div8ElimNCRec;
77 ) Div8ElimOpCosts;
22 '
Div8ElimOpRev;
// ( Div8ElimOthInc;
00 % Div8ElimPay;
88 & Div8ElimProv;
99 * Div8ElimTradeRec;
66 % Div8Equity1;
% Div8Equity2;
! Div8FCF;
JJ Div8Fin: > " Div8FITB;
w w Div8FY;
& & ) Div8GrowthCapex;
$
Div8Intang;
| | $
Div8IntExp;
> > $
Div8IntInc;
G G % Div8IntLiab;
% Div8IntPaid;
$
Div8Invent;
m m & Div8IssueCap;
# Div8Liab1;
# Div8Liab2;
( Div8MaintCapex;
Div8NA;
$
Div8NCmove;
'
Div8NetBorrow;
'
Div8NetResult;
\ \ ! Div8NRI;
Z Z $
Div8NRITax;
[ [ $
Div8OEIBal;
( Div8OEIContrib;
% Div8OpCosts;
0 0 # Div8OpRev;
) ) # Div8OthCA;
r r # Div8OthCL;
$
Div8OthInc;
. . ! Div8Own;
-- ! Div8Pay;
Div8PE;
% % ! Div8PPE;
x x " Div8Prov;
# Div8Purch;
! Div8Rec;
g g % Div8Reserve;
& Div8Retained;
" Div8Sale;
! Div8Tax;
N N % Div8TaxPaid;
# Div8TotEq;
Div8WC;
! DivDate; V V FinYE; L L ! ForexPE; FY; M M ! FY_Code; P P ! GDPsens; _ _ Holdco: . '
HoldcoAdjEBIT; 55 % HoldcoAmort; < < & HoldcoAsset1; & HoldcoAsset2; & HoldcoAsset3; $
HoldcoBond; << ( HoldcoBondPrem; $
HoldcoCash; f f # HoldcoDep; ; ; '
HoldcoDistPay; # HoldcoDiv; & HoldcoDivInv; # HoldcoDTL; & HoldcoEBITDA; : : '
HoldcoEBITTax; 66 ) HoldcoElimAssoc; YY * HoldcoElimIntExp; [[ * HoldcoElimIntInc; \\ + HoldcoElimIntLiab; bb ) HoldcoElimNCRec; __ + HoldcoElimOpCosts; ZZ ) HoldcoElimOpRev; WW * HoldcoElimOthInc; XX '
HoldcoElimPay; `` ( HoldcoElimProv; aa ) HoldcoElimPurch; dd , HoldcoElimTradeRec; ^^ '
HoldcoEquity1; '
HoldcoEquity2; # HoldcoFCF; ss $
HoldcoFITB; w w " HoldcoFY; & & + HoldcoGrowthCapex; & HoldcoIntang; | | & HoldcoIntExp; > > & HoldcoIntInc; G G '
HoldcoIntLiab; '
HoldcoIntPaid; & HoldcoInvent; m m ( HoldcoIssueCap; % HoldcoLiab1; % HoldcoLiab2; * HoldcoMaintCapex; '
HoldcoManFees; 5 5 " HoldcoNA; & HoldcoNCmove; ) HoldcoNetBorrow; ) HoldcoNetResult; \ \ ( HoldcoNonOpExp; 9 9 ( HoldcoNonOpInc; , , # HoldcoNRI; Z Z & HoldcoNRITax; [ [ & HoldcoOEIBal; & HoldcoOEICap; & HoldcoOEIDiv; ) HoldcoOEIProfit; _ _ '
HoldcoOpCosts; / / % HoldcoOpRev; ) ) % HoldcoOthCA; r r % HoldcoOthCL; ( HoldcoOthFinCF; & HoldcoOthInc; , , ( HoldcoOthInvCF; '
HoldcoOthOpCF; ( HoldcoOverhead; 2 2 # HoldcoPay; " HoldcoPE; % % '
HoldcoPension; ( HoldcoPEshares; HH # HoldcoPPE; x x ) HoldcoProfAssoc; - - $
HoldcoProv; % HoldcoPurch; # HoldcoRec; g g '
HoldcoReserve; ( HoldcoRetained; $
HoldcoSale; # HoldcoTax; N N '
HoldcoTaxPaid; % HoldcoTotEq; ( HoldcoWAshares; LL " HoldcoWC; ! PerDays; O O $
Period_End; N N Price: ' ; " RAREEBIT; $
RAREEBITDA; '
RARENetResult; Sedol:
TerminalCF:
% TerminalValDate:
Today: s
TrueConsol: . ValFY; ff ValPE; gg ValueDate: s 5 ff p - , @ r j 0 ( 3 3 A @ @
* 6 S7R8C28||10.3500006 S7R9C28||55.0300007 S7R10C28||10.9500006 S7R11C28||7.1300006 S7R12C28||1.1400006 S7R13C28||5.2300006 S7R14C28||2.1500006 S7R15C28||6.8700007 S7R16C28||15.9000007 S7R18C28||20.0500006 S7R19C28||6.0300007 S7R20C28||47.5000007 S7R21C28||29.1500007 S7R22C28||22.1500007 S7R23C28||42.0000007 S7R24C28||35.6300007 S7R25C28||26.5700006 S7R26C28||2.1000008 S7R27C28||113.0000007 S7R28C28||65.2000007 S7R29C28||88.9200006 S7R30C28||3.5300007 S7R31C28||38.8800007 S7R32C28||23.3500007 S7R33C28||32.9100007 S7R34C28||16.4900007 S7R35C28||40.2500008 S7R36C28||640.9998007 S7R37C28||34.6300007 S7R38C28||45.2000007 S7R39C28||76.0300007 S7R40C28||20.3300005 S3R7C24||0.6139205 S3R7C25||7.1947705 S3R7C26||3.782031; S3R7C40||4333148.8000005 S3R8C24||4.0425507 S3R8C25||6 S3R8C26||47.6352389 S3R8C40||71194.4761905 S3R9C24||3.0701805 S3R9C25||2.1739105 S3R9C26||1.106071; S3R9C40||2375091.5714297 S3R10C24||-2.1067407 S3R10C25||-0.4285706 S3R10C26||6.914466< S3R10C40||1833736.4761906 S3R11C24||1.7307707 S3R11C25||-2.9357807 S3R11C26||12.7387209 S3R11C40||9424.7000006 S3R12C24||3.0114207 S3R12C25||16.9811407 S3R12C26||87.756211: S3R12C40||44498.3809526 S3R13C24||2.6528306 S3R13C25||4.4600906 S3R13C26||2.131619< S3R13C40||6770748.8500006 S3R14C24||7.5098807 S3R14C25||-6.2069006 S3R14C26||2.642869< S3R14C40||1055304.1904766 S3R15C24||2.7165906 S3R15C25||3.9375906 S3R15C26||6.8415749 S3R15C40||6 S3R16C24||1.0145807 S3R16C25||-5.9622207 S3R16C26||16.3719639 S3R16C40||7 S3R17C24||-2.6548707 S3R17C25||-3.5087706 S3R17C26||1.0889209 S3R17C40||6 S3R18C24||8.2500007 S3R18C25||-6.3986207 S3R18C26||20.1924229 S3R18C40||7 S3R19C24||-3.8720508 S3R19C25||-29.5061706 S3R19C26||7.1989699 S3R19C40||9 S3R20C24||9 S3R20C25||7 S3R20C26||47.4671439 S3R20C40||7 S3R21C24||-0.2753906 S3R21C25||9.6517807 S3R21C26||28.149206= S3R21C40||12039191.9055006 S3R22C24||3.5156307 S3R22C25||-2.5735306 S3R22C26||2.640956# S3R22C40||#NA7 S3R23C24||-3.1805407 S3R23C25||-3.4514907 S3R23C26||12.860440# S3R23C40||#NA6 S3R24C24||3.6007206 S3R24C25||8.8389507 S3R24C26||51.346211# S3R24C40||#NA6 S3R25C24||9.2557306 S3R25C25||9.7794807 S3R25C26||11.816693= S3R25C40||14022873.2466507 S3R26C24||-1.1331406 S3R26C25||2.0467806 S3R26C26||6.925099# S3R26C40||#NA6 S3R27C24||0.8771906 S3R27C25||0.4366806 S3R27C26||1.091528# S3R27C40||#NA7 S3R28C24||-3.7878807 S3R28C25||-4.8689106 S3R28C26||5.594080# S3R28C40||#NA7 S3R29C24||-1.8779307 S3R29C25||-7.1111106 S3R29C26||2.270400# S3R29C40||#NA6 S3R30C24||0.4325906 S3R30C25||0.0718406 S3R30C26||6.843210# S3R30C40||#NA6 S3R31C24||0.5047307 S3R31C25||-2.5688107 S3R31C26||16.358158# S3R31C40||#NA6 S3R32C24||1.8518507 S3R32C25||-2.6548706 S3R32C26||1.089200# S3R32C40||#NA6 S3R33C24||9.9086106 S3R33C25||5.2995507 S3R33C26||20.235508# S3R33C40||#NA7 S3R34C24||-3.5234908 S3R34C25||-29.7924306 S3R34C26||7.160538# S3R34C40||#NA7 S3R35C24||-2.049180# S3R35C25||#NA< 7 S3R35C26||47.475192# S3R35C40||#NA7 S3R36C24||-5.0167206 S3R36C25||4.0293007 S3R36C26||28.144563= S3R36C40||12039191.9055007 S3R37C24||-0.4955006 S3R37C25||4.9904907 S3R37C26||21.399643= S3R37C40||36910048.9112106 S3R38C24||2.4651207 S3R38C25||12.0834407 S3R38C26||41.931667> S3R38C40||353415736.134600# S3R39C25||#NA7 S3R39C26||37.050803# S3R39C40||#NA6 S3R40C24||3.0476806 S3R40C25||4.0173707 S3R40C26||27.005447# S3R40C40||#NA6 S3R41C24||1.9585306 S3R41C25||4.8578206 S3R41C26||2.127820# S3R41C40||#NA6 S3R42C24||7.8516007 S3R42C25||10.6194708 S3R42C26||103.802183# S3R42C40||#NA6 S3R43C24||3.7268906 S3R43C25||5.9794807 S3R43C26||63.629219# S3R43C40||#NA6 S3R44C24||9.6616006 S3R44C25||3.5664707 S3R44C26||40.038985# S3R44C40||#NA7 S3R45C24||-1.0309306 S3R45C25||3.4482807 S3R45C26||24.246371# S3R45C40||#NA6 S3R46C24||0.6626306 S3R46C25||7.1450507 S3R46C26||34.544048> S3R46C40||154185546.7870606 S3R47C24||1.8007206 S3R47C25||4.2409307 S3R47C26||16.1284066 S7R17C28||1.120000# S3R39C24||#NA6 S5R7C4||C0000882716 S5R7C5||C000088271$ S5R8C4||#Value$ S5R9C4||#Value% S5R10C4||#Value7 S5R10C5||C000087600% S5R13C4||#Value% S5R14C4||#Value% S5R15C4||#Value6 S5R15C5||% S5R16C4||#Value6 S5R16C5||% S5R17C4||#Value6 S5R17C5||% S5R18C4||#Value6 S5R18C5||% S5R19C4||#Value6 S5R19C5||% S5R20C4||#Value% S5R21C4||#Value% S5R22C4||#Value% S5R23C4||#Value% S5R24C4||#Value% S5R25C4||#Value6 S5R8C5||C9000155526 S5R9C5||C901699416% S5R26C4||#Value% S5R27C4||#Value% S5R27C5||#Value% S5R28C4||#Value% S5R28C5||#Value% S5R29C4||#Value% S5R29C5||#Value% S5R30C4||#Value% S5R30C5||#Value% S5R31C4||#Value% S5R31C5||#Value% S5R32C4||#Value% S5R32C5||#Value% S5R33C4||#Value% S5R33C5||#Value% S5R34C4||#Value% S5R34C5||#Value% S5R35C4||#Value% S5R35C5||#Value% S5R36C4||#Value% S5R36C5||#Value% S5R37C4||#Value% S5R37C5||#Value% S5R38C4||#Value% S5R38C5||#Value% S5R39C4||#Value% S5R39C5||#Value% S5R40C4||#Value% S5R40C5||#Value% S5R41C4||#Value% S5R41C5||#Value% S5R42C4||#Value% S5R42C5||#Value% S5R43C4||#Value% S5R43C5||#Value% S5R44C4||#Value% S5R44C5||#Value% S5R45C4||#Value% S5R45C5||#Value% S5R46C4||#Value% S5R46C5||#Value% S5R47C4||#Value% S5R47C5||#Value% S5R48C4||#Value% S5R48C5||#Value% S5R49C4||#Value% S5R49C5||#Value% S5R50C4||#Value% S5R50C5||#Value% S5R51C4||#Value% S5R51C5||#Value% S5R52C4||#Value% S5R52C5||#Value% S5R53C4||#Value% S5R53C5||#Value% S5R54C4||#Value% S5R54C5||#Value% S5R55C4||#Value% S5R55C5||#Value% S5R56C4||#Value% S5R56C5||#Value% S5R57C4||#Value% S5R57C5||#Value% S5R58C4||#Value% S5R58C5||#Value% S5R59C4||#Value% S5R59C5||#Value% S5R60C4||#Value% S5R60C5||#Value% S5R61C4||#Value% S5R61C5||#Value% S5R62C4||#Value% S5R62C5||#Value% S5R63C4||#Value% S5R63C5||#Value% S5R64C4||#Value% S5R64C5||#Value% S5R65C4||#Value% S5R65C5||#Value% S5R66C4||#Value% S5R66C5||#Value% S5R67C4||#Value% S5R67C5||#Value% S5R68C4||#Value% S5R68C5||#Value% S5R69C4||#Value% S5R69C5||#Value% S5R70C4||#Value% S5R70C5||#Value% S5R71C4||#Value% S5R71C5||#Value% S5R72C4||#Value% S5R72C5||#Value% S5R73C4||#Value% S5R73C5||#Value% S5R74C4||#Value% S5R74C5||#Value% S5R75C4||#Value% S5R75C5||#Value% S5R76C4||#Value% S5R76C5||#Value% S5R77C4||#Value% S5R77C5||#Value% S5R78C4||#Value% S5R78C5||#Value% S5R79C4||#Value% S5R79C5||#Value% S5R80C4||#Valu< e% S5R80C5||#Value% S5R81C4||#Value% S5R81C5||#Value% S5R82C4||#Value% S5R82C5||#Value% S5R83C4||#Value% S5R83C5||#Value% S5R84C4||#Value% S5R84C5||#Value% S5R85C4||#Value% S5R85C5||#Value% S5R86C4||#Value% S5R86C5||#Value% S5R87C4||#Value% S5R87C5||#Value% S5R88C4||#Value% S5R88C5||#Value% S5R89C4||#Value% S5R89C5||#Value% S5R90C4||#Value% S5R90C5||#Value% S5R91C4||#Value% S5R91C5||#Value% S5R92C4||#Value% S5R92C5||#Value% S5R93C4||#Value% S5R93C5||#Value% S5R94C4||#Value% S5R94C5||#Value% S5R95C4||#Value% S5R95C5||#Value% S5R96C4||#Value% S5R96C5||#Value% S5R97C4||#Value% S5R97C5||#Value% S5R98C4||#Value% S5R98C5||#Value% S5R99C4||#Value% S5R99C5||#Value& S5R100C4||#Value& S5R100C5||#Value& S5R101C4||#Value& S5R101C5||#Value& S5R102C4||#Value& S5R102C5||#Value& S5R103C4||#Value& S5R103C5||#Value& S5R104C4||#Value& S5R104C5||#Value& S5R105C4||#Value& S5R105C5||#Value& S5R106C4||#Value& S5R106C5||#Value& S5R107C4||#Value& S5R107C5||#Value& S5R108C4||#Value& S5R108C5||#Value& S5R109C4||#Value& S5R109C5||#Value& S5R110C4||#Value& S5R110C5||#Value& S5R111C4||#Value& S5R111C5||#Value& S5R112C4||#Value& S5R112C5||#Value& S5R113C4||#Value& S5R113C5||#Value& S5R114C4||#Value& S5R114C5||#Value& S5R115C4||#Value& S5R115C5||#Value& S5R116C4||#Value& S5R116C5||#Value& S5R117C4||#Value& S5R117C5||#Value& S5R118C4||#Value& S5R118C5||#Value& S5R119C4||#Value& S5R119C5||#Value& S5R120C4||#Value& S5R120C5||#Value& S5R121C4||#Value& S5R121C5||#Value& S5R122C4||#Value& S5R122C5||#Value% S5R11C4||#Value7 S5R11C5||C0000534447 S5R12C4||C0000083617 S5R12C5||C0000083617 S5R13C5||C9016694767 S5R14C5||C902341248% S5R23C5||#Value% S5R24C5||#Value^ S7R7C13||1043.8922231353.9282535 S7R7C23||2.760000^ S7R8C13||9469.7350287357.9914756 S7R8C23||10.750000^ S7R9C13||7140.6517725598.2718856 S7R9C23||60.890000] S7R10C13||713.367176788.2684437 S7R10C23||11.210000^ S7R11C13||4500.731015837.4482956 S7R11C23||6.950000_ S7R12C13||1057.4498981371.5125596 S7R12C23||1.175000_ S7R13C13||1102.6374018758.0413146 S7R13C23||5.050000_ S7R14C13||1420.4450452232.9477396 S7R14C23||2.200000a S7R15C13||54984.15022743107.5806756 S7R15C23||6.990000_ S7R16C13||1865.4444971462.5087197 S7R16C23||16.600000^ S7R17C13||1027.7598471615.644366 S7R17C23||1.100000] S7R18C13||1599.7030161247.76967 S7R18C23||22.500000Z S7R19C13||738.9171725869.086 S7R19C23||5.9200007 S7R20C23||48.360000] S7R21C13||842.781653842.7816537 S7R21C23||28.800000_ S7R22C13||2611.9397642611.9397647 S7R22C23||22.220000_ S7R23C13||17956.2195417956.219547 S7R23C23||43.870000X S7R24C13||1085.46447118417 S7R24C23||38.980000` S7R25C13||36543.8108528650.3522917 S7R25C23||29.000000W S7R26C13||5746.1725545056 S7R26C23||2.207500_ S7R27C13||5479.3457296783.4673228 S7R27C23||129.300000` S7R28C13||51197.49799540138.844857 S7R28C23||70.230000a S7R29C13||83882.32341365763.7520787 S7R29C23||97.900000_ S7R30C13||9188.8172217204.0338546 S7R30C23||3.640000b S7R31C13||101916.05805179902.2022977 S7R31C23||42.640000` S7R32C13||7188.18860555904.4066367 S7R32C23||23.850000a S7R33C13||15791.05309617449.0630697 S7R33C23||35.380000_ S7R34C13||1897.7531532098.9129737 S7R34C23||17.150000a S7R35C13||22843.98375517909.6861297 S7R35C23||43.010000` S7R36C13||11423.1166446019.9926458 S7R36C23||678.999800a S7R37C13||11603.30605312821.6160067 S7R37C23||36.450000b S7R38C13||15374.234601119569.4089357 S7R38C23||49.650000a S7R39C13||16156.03481216156.0348127 S7R39C23||76.930000a S7R40C13||23273.59458918246.5010777 S7R40C23||19.980000& S5R123C4||#Value& S5R123C5||#Value& S5R124C4||#Value& S5R124C5||#Value& S5R125C4||#Value& S5R125C5||#Value& S5R126C4||#Value& S5R126C5||#Value& S5R127C4||#Value& S5R127C5||#Value& S5R128C4||#Value& S5R128C5||#Value& S5R129C4||#Value& S5R129C5||#Value& S5R130C4||#Value& S5R130C5||#Value& S5R131C4||#Value& S5R131C5||#Value6 S6R7C4||C0000017046 S6R7C5||C0000017046 S6R8C4||C0000010316 S6R8C5||C0000010316 S6R9C4||C0000055186 S6R9C5||C0000055187 S6R10C4||C0000141577 S6R10C5||C0000141577 S6R11C4||C0000882357 S6R11C5||C000088235% S6R12C4||#Value7 S6R12C5||C000075896% S6R13C4||#Value7 S6R13C5||C901842957% S6R14C4||#Value7 S6R14C5||C9018861387 S6R15C4||C0000015137 S6R15C5||C0000015137 S6R16C4||C0000741817 S6R16C5||C0000741817 S6R17C4||C0000083507 S6R17C5||C0000083507 S6R18C4||C0000083517 S6R18C5||C000008351% S6R19C4||#Value7 S6R19C5||C9014289847 S6R20C4||C9014616577 S6R20C5||C9014616577 S6R21C4||C0000705157 S6R21C5||C0000705157 S6R22C4||C0000086607 S6R22C5||C0000086607 S6R23C4||C0000711777 S6R23C5||C0000711777 S6R24C4||C0000065767 S6R24C5||C000006576% S6R25C4||#Value7 S6R25C5||C9000155527 S6R26C4||C0000046247 S6R26C5||C0000046247 S6R27C4||C0000891397 S6R27C5||C0000891397 S6R28C4||C0000737147 S6R28C5||C0000737147 S6R29C4||C0000471187 S6R29C5||C0000471187 S6R30C4||C0000534447 S6R30C5||C000053444% S6R31C4||#Value7 S6R31C5||C9008694347 S6R32C4||C0000157297 S6R32C5||C000015729% S6R33C4||#Value7 S6R33C5||C000015507% S6R34C4||#Value7 S6R34C5||C0000156097 S6R35C4||C0000769027 S6R35C5||C0000769027 S6R36C4||C0000879707 S6R36C5||C000087970% S6R37C4||#Value7 S6R37C5||C000012895% S6R38C4||#Value7 S6R38C5||C000017224% S6R39C4||#Value7 S6R39C5||C0000170337 S6R40C4||C0000000487 S6R40C5||C0000000487 S6R41C4||C0000035947 S6R41C5||C000003594= S3R47C40||16440842.5522206 S3R48C24||0.0938707 S3R48C25||-4.5647807 S3R48C26||40.252840# S3R48C40||#NA6 S3R49C24||1.3564406 S3R49C25||0.3731308 S3R49C26||662.157912# S3R49C40||#NA7 S3R50C24||-0.5237007 S3R50C25||10.0976207 S3R50C26||35.171786= S3R50C40||99319797.1783506 S3R51C24||4.1125506 S3R51C25||7.2463807 S3R51C26||45.195161# S3R51C40||#NA7 S3R52C24||-0.6829007 S3R52C25||10.8108107 S3R52C26||71.431230> S3R52C40||388290451.5300606 S3R53C24||0.7988807 S3R53C25||10.681110 Product Name Accrual Period: Start Date Accrual Period: End Date Ex-distribution: Date Ex-distribution: Exit Price Re-investment: Date Re-investment: Price7 S3R53C26||18.301660# S3R53C40||#NA% S5R20C5||#Value% S5R21C5||#Value% S5R22C5||#Value% S6R42C4||#Value7 S6R42C5||C0000156017 S6R43C4||C0000087357 S6R43C5||C0000087357 S6R44C4||C0000137607 S6R44C5||C0000137607 S6R45C4||C0000743247 S6R45C5||C0000743247 S6R46C4||C0000882457 S6R46C5||C0000882457 S6R47C4||C0000486197 S6R47C5||C0000486197 S6R48C4||C0000881107 S6R48C5||C0000881107 S6R49C4||C0000853027 S6R49C5||C0000853027 S6R50C4||C0000016437 S6R50C5||C0000016437 S6R51C4||C000005436< . 7 S6R51C5||C0000054367 S6R52C4||C0000082207 S6R52C5||C0000082207 S6R53C4||C0000876607 S6R53C5||C0000876607 S6R54C4||C0000670717 S6R54C5||C0000670717 S6R55C4||C0000825997 S6R55C5||C000082599% S6R56C4||#Value7 S6R56C5||C000014686% S6R57C4||#Value7 S6R57C5||C000007346% S6R58C4||#Value6 S6R58C5||% S6R59C4||#Value6 S6R59C5||% S6R60C4||#Value6 S6R60C5||% S6R61C4||#Value6 S6R61C5||% S6R62C4||#Value6 S6R62C5||% S6R63C4||#Value6 S6R63C5||% S6R64C4||#Value6 S6R64C5||% S6R65C4||#Value6 S6R65C5||% S6R66C4||#Value6 S6R66C5||% S6R67C4||#Value6 S6R67C5||% S6R68C4||#Value6 S6R68C5||% S6R69C4||#Value6 S6R69C5||% S6R70C4||#Value6 S6R70C5||% S6R71C4||#Value6 S6R71C5||% S6R72C4||#Value6 S6R72C5||% S6R73C4||#Value6 S6R73C5||% S6R74C4||#Value% S6R74C5||#Value% S6R75C4||#Value% S6R75C5||#Value% S6R76C4||#Value% S6R76C5||#Value% S6R77C4||#Value% S6R77C5||#Value% S6R78C4||#Value% S6R78C5||#Value% S6R79C4||#Value% S6R79C5||#Value% S6R80C4||#Value% S6R80C5||#Value% S6R81C4||#Value% S6R81C5||#Value% S6R82C4||#Value% S6R82C5||#Value% S6R83C4||#Value% S6R83C5||#Value% S6R84C4||#Value% S6R84C5||#Value% S6R85C4||#Value% S6R85C5||#Value% S6R86C4||#Value% S6R86C5||#Value% S6R87C4||#Value% S6R87C5||#Value% S6R88C4||#Value% S6R88C5||#Value% S6R89C4||#Value% S6R89C5||#Value% S6R90C4||#Value% S6R90C5||#Value% S6R91C4||#Value% S6R91C5||#Value% S6R92C4||#Value% S6R92C5||#Value% S6R93C4||#Value% S6R93C5||#Value% S6R94C4||#Value% S6R94C5||#Value% S6R95C4||#Value% S6R95C5||#Value% S6R96C4||#Value% S6R96C5||#Value% S6R97C4||#Value% S6R97C5||#Value% S6R98C4||#Value% S6R98C5||#Value% S6R99C4||#Value% S6R99C5||#Value& S6R100C4||#Value& S6R100C5||#Value& S6R101C4||#Value& S6R101C5||#Value& S6R102C4||#Value& S6R102C5||#Value& S6R103C4||#Value& S6R103C5||#Value& S6R104C4||#Value& S6R104C5||#Value& S6R105C4||#Value& S6R105C5||#Value& S6R106C4||#Value& S6R106C5||#Value& S6R107C4||#Value& S6R107C5||#Value& S6R108C4||#Value& S6R108C5||#Value& S6R109C4||#Value& S6R109C5||#Value& S6R110C4||#Value& S6R110C5||#Value& S6R111C4||#Value& S6R111C5||#Value& S6R112C4||#Value& S6R112C5||#Value& S6R113C4||#Value& S6R113C5||#Value& S6R114C4||#Value& S6R114C5||#Value& S6R115C4||#Value& S6R115C5||#Value& S6R116C4||#Value& S6R116C5||#Value& S6R117C4||#Value& S6R117C5||#Value& S6R118C4||#Value& S6R118C5||#Value& S6R119C4||#Value& S6R119C5||#Value& S6R120C4||#Value& S6R120C5||#Value& S6R121C4||#Value& S6R121C5||#Value& S6R122C4||#Value& S6R122C5||#Value& S6R123C4||#Value& S6R123C5||#Value& S6R124C4||#Value& S6R124C5||#Value& S6R125C4||#Value& S6R125C5||#Value& S6R126C4||#Value& S6R126C5||#Value& S6R127C4||#Value& S6R127C5||#Value& S6R128C4||#Value& S6R128C5||#Value& S6R129C4||#Value& S6R129C5||#Value& S6R130C4||#Value& S6R130C5||#Value& S6R131C4||#Value& S6R131C5||#Value% S5R25C5||#Value% S5R26C5||#Value5 S7R7C28||2.570000 Distribution (%)
Growth (%) Net Quarterly Performance (%) FY/FYTD Growth (%) FY/FYTD Distribution/Yield (%) APIR Net Distribution Amount (CPU) FY/FYTD (%) Return (Net) ClearBridge Distribution Data Manager: ClearBridge InvestmentsD ClearBridge RARE Infrastructure Income Fund - Unhedged Class A Units SSB6649AU SSB6649AU4483544925 2 @ s x D E
[ a - 9 j \ ( p I Q { , b V X ? 0 p ! a 0 p ! a 0 p ! a 0 u B
5 u
I L ! i #
] X 1 v " e M% ' 0 @* + = - .
`0 2 u
3 3 5 X7 9 : + \< > ? F A B D y E I G I K [ L N c O
Q Z JR
S T
V Z JW X Y ! [ i a\ ] ^ A 9` a b c
d c c B QLV[ZB<wYvI$
ZO t j `n r pw { ( 8 H Э X h x
d MbP?_ * + % & ?' ?( ?) ? " QLV ? ?ng& U
!
"
#
$
%
&
'
(
)
*
+
,
-
.
/
0
1
2
3
4
5
6
7
8
9
:
;
<
=
>
? D @ l ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?
@
! A
" B
# C
$ D
% E
& F
' G
( H
) I
* J
+ K
, L
- M
. N
/ O
0 P
1 Q
2 R
3 S
4 T
5 U
6 V
7 W
8 X
9 Y
: Z
; [
< \
= ]
> ^
? _ D @ l @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _
@ `
A a
B b
C c
D d
E e
F f
G g
H h
I i
J j
K k
L l
M m
N n
O o
P p
Q q
R r
S s
T t
U u
V v
W w
X x
Y y
Z z
[ {
\ |
] }
^ ~
_ D @ l ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~
`
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z
{
|
}
~
D @ l
D @ l
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
`
a
D @ l
b
c
d
D @ l
D @ l
D @ l ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?
!
"
#
$
%
& !
' "
( #
) $
* %
+ &
, '
- (
. )
/ *
0 +
1 ,
2 -
3 .
4 /
5 0
6 1
7 2
8 3
9 4
: 5
; 6
< 7
= 8
> 9
? : D @ l @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _
@ ;
A <
B =
C >
D ?
E @
F A
G B
H C
I D
J E
K F
L G
M H
N I
O J
P K
Q L
R M
S N
T O
U P
V Q
W R
X S
Y T
Z U
[ V
\ W
] X
^ Y
_ Z D @ l ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~
` [
a \
b ]
c ^
d _
e `
f a
g b
h c
i d
j e
k f
l g
m h
n i
o j
p k
q l
r m
s n
t o
u p
v q
w r
x s
y t
z u
{ v
| w
} x
~ y
z D @ l
{
|
}
~
D @ l
D @ l
!
"
#
$
% D @ l
&
'
(
)
*
+
,
-
.
/
0
1
2
3
4
5
6
7
8
9
:
;
<
=
>
?
@
A
e
f
g
h D @ l
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z
{
|
}
~
D @ l ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?
!
"
#
$
%
&
'
(
)
*
+
,
-
.
/
0
1
2
3
4
5
6
7
8
9
:
;
<
=
>
? D @ l @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _
@
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
[
\
]
^
_ D @ l ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~
`
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z
{
|
}
~
D @ l
D @ l
D @ l
D @ l
D @ l
. P H 0 (
> @ @ 2zpWI1. d @ < & ?' ?( ?) ? " ? ?< & 2zpWI1. 7 Sheet2g g D
ZO
d MbP?_ * +
* 0 ! " # $ % & ' ( ) + , - 9 . / 1 2 3 4 5 6 7 8 : = ; < > % & ?' ?( ?) ? " ? ? & U P H 0 (
> @ 7 b( b ( g g D
ZO \
d MbP?_ * + % & ?' ?( ?) ?M \ \ R A R E - S Y 1 - F S - 0 1 \ X e r o x C o l o r - 3d X X DINU" |Dv
SMTJ D FPXF hD FPXF h 4 A4 d 9.5 d d . . . . . . . . . . . . . . . . . . . . . . . . . . . . " d XX ? ? & U } O } `O } O } O } O } O } O } ` O Q R T r W W
] T p
r r _ b b b v h h
w %
& x
y Y
'
'
'
'
'
'
' f P P P P P P P P P z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z z {
| "
(
(
(
(
(
(
( f } } } } } } } } } ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
i Z 0 @ @@ @ @@ @ @ `@ f
[ 0 @ @ @ `@ @ @@ @ f U
)
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
! V
" V
# V
$ V
% V
& V
' V
( V
) V
* V
+ V
, V
- V
. V
/ V
0 V
1 V
2 V
3 V
4 V
5 V
6 V
7 V
8 V
9 V
: V
; V
< V
= V
> V
? V
@ V
A V
B V
C V
D V
E V
F V
G V
H V
I V
J V
K V
L V
M V
N V
O V
P V
Q V
R V
S V
T V
U V
V V
W V
X V
Y V
Z V
[ V
\ V
] V
^ V
_ V
` V
a V
b V
c V
d V
e V
f V
g V
h V
i V
j V
k V
l V
m V
n V
o V
p V
q V
r V
s V
t V
u V
v V
w V
x V
y V
z V
{ V
| V
} V
~ V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
V
U # '8? ? @ @ !@ @ @ f e e e e e e e e e f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f f g v
X Z Z Z Z Z Z Z Z Z Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ \
i \ 0 @ @ @ `@ @ @@ @ f j j j j j j j j j j j j j j j j j j j j j j j j j j j j j j j j j j j j j j j j j j j j k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k k l
o ] H? xz,C ? =U? ? `TR'? h o? :pΈ? f e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e e v
q S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S
q ^ 0 @ @ @ `@ @ @@ @ f S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S S
^ _ DJ? _vO ?~
[@ MJ? ?? ?ܵ? fa? f m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m m n
s
` & a a a a a a a a a a a a a a a
c & d d d d d d d d d d d d d d d
t & u u u u u u u u u u u u u u u
$ v&# 4? n @ d te reA
` 7 R L J Ensure start date falls the day after the previous distribution's end date Incorrect date format XG U L Reinvestment date Incorrect date format re XG d ? \ tm PKD In
9 L tm o
, tm C Fund Name Please enter fund name APIR Code APIR Code, Please enter APIR Code or Morningstar Ticker Maximum of 9 characters allowed at XG Y This row is not read Must be Y or N only rn Y N i e L Effective distribution date Invalid date format N XG p L 2 End date is the effective date of the distribution Incorrect date format L R l Reinvestment price Must be greater than zero on co d L $ Cum-exit price less distribution CPU Must be greater than zero t l C Either enter CPU/day amount or whole amount in cell above, not both% Must be greater than or equal to zero
T L Actual distribution date Incorrect date format l XG ,
b( b ( g g D
d i r S h e e t 2 M o d u l e 1
M o d u l e 2 G (
! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k m n o p q r s t u v w x y z { | } ~ ղ 0* pH d
VBAProject 4 @j
=
r չP# J<
rstdole> s t d o l e
h %^ *\G{00020430- C
004 6}#2.0#0 #C:\Wind ows\Syst em32\e2. tlb#OLE Automati on ` EOffDicEO f i cEE 2DF8D04C -5BFA-101B-BDE5EAAC42E gram Fil es\CommonMicros oft Shar ed\OFFIC E16\MSO.0DLL#M 1@6.0 Ob Library K TFExc elAddin> T F ED xcl Ad i n ŀW*\CL) Thoms)na@ncial\EON@Onalytics for C&\ In.xlaF
"¦ ySheet2*GBCSeot 2 H2N A HB1«3 B,"B+BBThi sWorkbookGD\h@Xs WA@r k bo5 2 $$&Module4G y M hd u4A2 -!4!b %!
@/A/2 ƀT1o 1j 151W - y # x ME ( SL S S < N 0 { 0 0 0 2 0 8 2 0 - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 } @ 0 n % @ x Attribut e VB_Nam e = "She@et2"
Bast0{00020820- C $0046}
|Global!SpacFalse dCreatabl Pre decla Id Tru
BExpose Temp lateDeriv$Bustom izD2 H yW x ME ( 6
< < < j ` X ( Macro recorded 5/02/2007 by Nick Langleyx
14 h % ( `b$ * \ R f f f f * 0 8 6 4 4 9 0 8 1 e " 0 ( X ` 8d h ( ( 0 X p ( (
Macro1 Macro e c ) Macro recorded 5/02/2007 by Nick Langley # : k , R:\Portfolio Management\Portfolios\RIC09.TXT 4 8 6 : > < B @ D b F H J L D D D D D D D D D
D D D
D D
N P 0B@2
RARE Infrastructure.xls $ l B@n F24 $ p B@H x z r% t B@v RARE Infrastructure.xls $ l B@n F25 $ p B@H x z r% t B@v RARE Infrastructure.xls $ l B@n K24 $ p B@H x z r% t B@v Open Trades $ | B@H A@\ o IJ Attribut e VB_Nam e = "Mod ule1"
S ub Macro`1()
L. Descrip0tiontX r ecorded 5/02/200 7 by Nic k Langley ProcDataYInvoke_FuncY \n14 6'
|
' v +
Work books.Op enText Filen :=" R:\Portfolio4nag ement
s\ RIC09.TXT", _
)Origin: =xlMSDOS , StartRow:=1, oTypeDel imited, ?Qualifier:='xlD oubleQuo te, Consecutive ! Fals Ta@b:=Tru SemicoloDQCommapac#D OthA DFieldI nfo:=Array(C 21)J=2, 3 4 5 6 7 .8-9 10JD&
1#1$- Trailing MinusNumpbersEtCW indows(" RARE Cra structur e.xls").DAc@date Re("F24Select).H r ks (1).Foll@ow New:=`AddHistory%7$5?$ ?$ $$K?$n?$0$Sheet 6a{r < B @ D b F H J L D D D D D D D D D
D D D
D D
N P 0B@2
BLPLinkReset TB@b RefireBLP TB@b RefireBLP TB@b dB@f BLPLinkReset TB@b o ` X ^ Attribut e VB_Nam e = "Mod ule2"
S ub Macro`2()
L. Descrip0tiontX r ecorded 31/05/20 07 by Bloomberg ProcDataWInvoke _FuncW \n14 6'
' t )
Applica.Run " RefireBLP2Workb ooks.Ope nText Filen:="R :\Portfolio Dnagement
s\R IC09.TXT", _
) Origin:= xlMSDOS, StartRo@w:=1, TypeDelimited, ? Qualifier:='xlDo ubleQuot e, Consecutive Fals Tab :=Tru Semicolo@"A(CommaF
pac#D OthA DFieldIn fo:=Array(C 21)J=X2, 3 4U 5 6 7 8-9 10JkD&
1#1$-T railingM@inusNusEtNLinkReset^ csWindow.AateN@!#!End
y4 x ME M o d u l e 4 l $
_ _ S R P _ 0
_ _ S R P _ 1 _ _ S R P _ 2
( 6
< < < . ` , % ` ` X K$ * \ R f f f f * 0 6 6 4 4 9 0 8 1 e . P X " ` , h 8d > > @ t ( 8
Macro1 Macro F ' Macro recorded 11/01/2007 by Bloomberg o " R:\Portfolio Management\PortfoliosA@: # : k , R:\Portfolio Management\Portfolios\RIC09.TXT 4 8 6 : > < B @ D b F H J L D D D D D D D D D
D D D
D D
N P 0B@2
, R:\Portfolio Management\Portfolios\RIV99.CSV 4 0B@ , R:\Portfolio Management\Portfolios\RIT99.CSV 4 0B@ M R:\Portfolio Management\Portfolios\Portfolio & Trade Management (Current).xls 4 R 0B@ T X9 V MbP?9 Z q A@\ o ~ Attribut e VB_Nam e = "Mod ule4"
' Macro1< recor ded 11/0 1/2007 b y Bloomberg RSub Open_PT M_Files(0)
Ch Dir "R:\ Portfolio jnageme4nts 5Wo rkbooks.A[Text [n := L\RIC 09.TXT", _D.Orig in:=xlMS DOS, Sta rtRow:=1 , DataTypeDelim@ited, ?Q ualifier:='xlDou bleQuote , Consec`utive Fals Tab:=Tru SemicoloDQ CommapacGOth@ FieldInf o:=Arrayf( d1)z2, 3 4 5 6 7 8-9 10JD&5
1#1$-Tr ailingMinusNusEtCV99.CSVD<T#I!G& EdeH@ (Curr) .xls", UpdateLink '3&ith Applica0tioncAd.Calcul e an_MaxChang0.001cEnd W
e
A
K* W *\CC:\Program Files\Thomson Financial\Thomson ONE Analytics for Office\TFExcelAddIn.xlarU @ @ @ ~ ~ ~ ~ ~ ~ ~ ~T " Q :rOB䄖<7
0 Q ! a
VBAProject Sheet2 ThisWorkbook Module4 Module2 Module1 F B C:\Program Files\Common Files\Microsoft Shared\VBA\VBA7.1\VBE7.DLL VBA
1 a P F Open_PTM_Files 9 C:\Program Files\Microsoft Office\Root\Office16\EXCEL.EXE Excel
p 0 F C:\Windows\System32\stdole2.tlb stdole
Q L-[ DR ? C:\Program Files\Common Files\Microsoft Shared\OFFICE16\MSO.DLL Office
A Macro2
Macro1r rU@ @ @
& Macro recorded 31/05/2007 by Bloomberg
14 ( Macro recorded 5/02/2007 by Nick LangleyL rU@ @ @ @ ~x a S 4 rU@ @ @ 8 ` b rU@ @ @ @ ~x _ _ S R P _ 3 _ _ S R P _ 4 _ _ S R P _ 5 _ _ S R P _ 6 a S 4 rU@ @ @ 8 ` b rU@ @ @ @ ~x a S 4 _ _ S R P _ 7 T h i s W o r k b o o k _ V B A _ P R O J E C T P R O J E C T rU@ @ @ 8 ` 1 b - y # x ME ( SL S S < N 0 { 0 0 0 2 0 8 1 9 - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 } @ 0 w a % @ x Attribut e VB_Nam e = "Thi sWorkbook"
Bas0{00020P819- 0C $0046}
|GlobalSpacFalse dCreatabl Predecla Id Tru
BExpose Templ ateDerivBustomizD2 a * \ G { 0 0 0 2 0 4 E F - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 } # 4 . 2 # 9 # C : \ P r o g r a m F i l e s \ C o m m o n F i l e s \ M i c r o s o f t S h a r e d \ V B A \ V B A 7 . 1 \ V B E 7 . D L L # V i s u a l B a s i c F o r A p p l i c a t i o
! " $ % & ' ( ) + , - . 0 1 2 3 4 5 6 8 n s * \ G { 0 0 0 2 0 8 1 3 - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 } # 1 . 9 # 0 # C : \ P r o g r a m F i l e s \ M i c r o s o f t O f f i c e \ R o o t \ O f f i c e 1 6 \ E X C E L . E X E # M i c r o s o f t E x c e l 1 6 . 0 O b j e c t L i b r a r y * \ G { 0 0 0 2 0 4 3 0 - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 } # 2 . 0 # 0 # C : \ W i n d o w s \ S y s t e m 3 2 \ s t d o l e 2 . t l b # O L E A u t o m a t i o n (* \ G { 2 D F 8 D 0 4 C - 5 B F A - 1 0 1 B - B D E 5 - 0 0 A A 0 0 4 4 D E 5 2 } # 2 . 8 # 0 # C : \ P r o g r a m F i l e s \ C o m m o n F i l e s \ M i c r o s o f t S h a r e d \ O F F I C E 1 6 \ M S O . D L L # M i c r o s o f t O f f i c e 1 6 . 0 O b j e c t L i b r a r y * \ C C : \ P r o g r a m F i l e s \ T h o m s o n F i n a n c i a l \ T h o m s o n O N E A n a l y t i c s f o r O f f i c e \ T F E x c e l A d d I n . x l a * \ C C : \ P r o g r a m F i l e s \ T h o m s o n F i n a n c i a l \ T h o m s o n O N E A n a l y t i c s f o r O f f i c e \ T F E x c e l A d d I n . x l a F
չP# y S h e e t 2 0 1 6 4 4 9 0 8 1 9 ' S h e e t 2 3 T h i s W o r k b o o k 0 2 6 4 4 9 0 8 1 9 + T h i s W o r k b o o k 3 M o d u l e 4 0 6 6 4 4 9 0 8 1 e , M o d u l e 4 4 0 M o d u l e 2 0 7 6 4 4 9 0 8 1 e ^ M o d u l e 2 H M o d u l e 1 0 8 6 4 4 9 0 8 1 e h M o d u l e 1 W ` x 0 H ` QVO(BQ >gV FD>E [&AW ib' o=;ZJS ީ 7);L+E)' ?9 t2 Excel+ VBA Win16~ Win32 Win64x Mac VBA6# VBA7#
VBAProject stdole` Officeu TFExcelAddin
@ Sheet2 _Evaluate ThisWorkbook| Module4e Open_PTM_Files ( WorkbooksB OpenText« Filenamej OriginF xlMSDOS StartRow DataType%? xlDelimited
TextQualifier
xlDoubleQuote ConsecutiveDelimiterxx Semicolont Comma0K Space Other FieldInfo TrailingMinusNumbersC UpdateLinks Application* Calculationh xlManual MaxChange Calculate Module2c Macro2N Run_ ActiveWindow+ ActivateNext Module1b Macro1N Windowsd Activate| Range SelectionZ
Hyperlinks: Follow} NewWindow
AddHistory Sheets
Workbookk i " $ ' + -
_ Z ID="{8A8F9033-574E-425C-967C-C0CB1BB2DB6E}"
Document=ThisWorkbook/&H00000000
Document=Sheet2/&H00000000
Module=Module4
Module=Module1
Module=Module2
Name="VBAProject"
HelpContextID="0"
VersionCompatible32="393222000"
CMG="0103FF0503050305030503"
DPB="0200FCFFFC00FC00FC"
GC="0301FDFEFFFFFFFF00"
[Host Extender Info]
&H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000
[Workspace]
ThisWorkbook=0, 0, 0, 0, C
Sheet2=0, 0, 0, 0, C
Module4=0, 0, 0, 0, C
Module1=0, 0, 0, 0, C
Module2=0, 0, 0, 0, C
P R O J E C T w m R e v i s i o n L o g # S u m m a r y I n f o r m a t i o n ( * ( D o c u m e n t S u m m a r y I n f o r m a t i o n 8 / ThisWorkbook T h i s W o r k b o o k Sheet2 S h e e t 2 Module4 M o d u l e 4 Module1 M o d u l e 1 Module2 M o d u l e 2 2
Nick Langley
Oh +'0 P X
$ Stock Research & Valuation Model Nick Langley Carter, Nicole Microsoft Excel @ NqO۾@ x{@
՜. +,D ՜. +,0 P X t |
RARE Infrastructure Quarter--> Dist IMD02P004 Worksheets ( c k { CachePFDLData FDSMenuDocLevelBtnStates True 8
F Microsoft Excel 2003 Worksheet C o m p O b j 7 l Biff8 Excel.Sheet.8 9q