ࡱ > = 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 L% P͚ > H W o r k b o o k n _ V B A _ P R O J E C T _ C U R " + V B A ] ] 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 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 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 > 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 > 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 mmm\-yyyy
#,##0.0000 0.00000
0.000000
0.000 * % #,##0.00000000;\(#,##0.00000000\);"-" 6 1 _-* #,##0.00_-;* \-#,##0.00_-;_-\ * "-"??_-;_-@_- 8 3 _-* #,##0.000_-;* \-#,##0.000_-;_-\ * "-"??_-;_-@_- : 5 _-* #,##0.0000_-;* \-#,##0.0000_-;_-\ * "-"??_-;_-@_- & ! #,##0.000000;\(#,##0.000000\);"-" 0.0000000 0.000% 0.0000%
0.00000% ? : _(* #,##0.00000_);_(* \(#,##0.00000\);_(* "-"?????_);_(@_) < 7 _(* #,##0.0000_);_(* \(#,##0.0000\);_(* "-"????_);_(@_) + & * _-"$"#,##0;* \-"$"#,##0;* _-"$""-";@ * #,##0;* \-#,##0;* "-";@ 3 . * _-"$"#,##0.00;* \-"$"#,##0.00;* _-"$""-"??;@ & ! * #,##0.00;* \-#,##0.00;* "-"??;@ " #,##0.0000;\(#,##0.0000\);"-" #,##0.00;\(#,##0.00\);"-" #,##0;\(#,##0\);"-" " #,##0.00;\ \(#,##0.00\);\ "-" #,##0.00;\(#,##0.00\);\ "-" . ) #,##0.0000000000;\(#,##0.0000000000\);"-" 0.00000000000000000 "Yes";"Yes";"No" "True";"True";"False" "On";"On";"Off" ] , [ $ - 2 ] \ # , # # 0 . 0 0 _ ) ; [ R e d ] \ ( [ $ - 2 ] \ # , # # 0 . 0 0 \ ) < 7 _-* #,##0.00000_-;* \-#,##0.00000_-;_-\ * "-"??_-;_-@_- : 5 _-* #,##0.0000_-;\-* #,##0.0000_-;_-* "-"????_-;_-@_- > 9 _-* #,##0.000000_-;* \-#,##0.000000_-;_-\ * "-"??_-;_-@_- @ ; _-* #,##0.0000000_-;* \-#,##0.0000000_-;_-\ * "-"??_-;_-@_- B = _-* #,##0.00000000_-;* \-#,##0.00000000_-;_-\ * "-"??_-;_-@_- ff ) , *
!
# P ! P " " # $ ` % & ' ( a ) * @ * @ * * @ * @ * & @ @ @ @ * @ * @ * @ @ * ! @ * ! @ * * * @ @ * @ @ * @ * @ * @ * @ @ * @ @ * ! @ * ! @ * * @ @ * @ @ @ * * @ @ * ! # @ @ Q @ @ Q @ @ @ @ @ @ @ @ !@ @ Q !@ @ !@ @
Q @ @ * / * @ @ / * @ @ / * @ / * @ / * / * @ @ / * @ @ / * @ / * @ / * * @ @ * @ @ * @ * @ Q @ @ / Q @ @ / Q @ @ * * @ @ * @ * @ Q @ @ * + * @ @ + * @ + * @ + Q @ @ + ! # Q @ @ * * @ @ / * * @ @ * * @ @ * * @ @ / * / * * + * * / * * + * * @ @ / * @ / * / * * + * * * @ @ + * * @ @ @ @ @ @ @ / @ / @ @ + * !@ @ * ! @ * ! @ * ! @ / * ! @ / * ! @ * ! @ + @ * * * * / * @ @ + * @ @ * @ @ * @ @ / * @ @ / * @ @ * @ @ + * @ @ / / Q @ @ / Q @ @ / Q !@ @ / @ @ / @ @ / !@ @ / @ * ! @ * @ @ * * * @ @ * @ @ * * @ * @ * Q @ @ + ! * * ( Q h@ @ / @ * ! @ * @ @ * x * * @ @ * @ @ * * @ * @ * | | S}A }
##0.0000 ef ?_-;_-@_}A }
##0.0000 ef ?_-;_-@_}A }
##0.0000 ef ?_-;_-@_}A }
##0.0000 ef ?_-;_-@_}A }
##0.0000 ef ?_-;_-@_}A }
##0.0000 ef ?_-;_-@_}A }
##0.0000 L ?_-;_-@_}A }
##0.0000 L ?_-;_-@_}A }
##0.0000 L ?_-;_-@_}A }
##0.0000 L ?_-;_-@_}A }
##0.0000 L ?_-;_-@_}A }
##0.0000 L ?_-;_-@_}A }
##0.0000 23 ?_-;_-@_}A }
##0.0000 23 ?_-;_-@_}A }
##0.0000 23 ?_-;_-@_}A }
##0.0000 23 ?_-;_-@_}A }
##0.0000 23 ?_-;_-@_}A } !
##0.0000 23 ?_-;_-@_}A } "
##0.0000 ?_-;_-@_}A } #
##0.0000 ?_-;_-@_}A } $
##0.0000 ?_-;_-@_}A } %
##0.0000 ?_-;_-@_}A } &
##0.0000 ?_-;_-@_}A } '
##0.0000 ?_-;_-@_}A } )
##0.0000 ?_-;_-@_} } +
##0.0000 ?_-;_-@_ ???# # 0 . ??? ???
??? }- } 0
##0.0000 }A } 4
a ##0.0000 ?_-;_-@_}A } :
##0.0000 ?_-;_-@_}A } ;
##0.0000 ? ?_-;_-@_}A } <
##0.0000 23 ?_-;_-@_}- } =
##0.0000 } } ?
??v##0.0000 ̙?_-;_-@_ # # 0 .
}A } @
} ##0.0000 ?_-;_-@_}A } A
e ##0.0000 ?_-;_-@_}x } C ##0.0000 ?_- # #
} } D
???##0.0000 ?_- ???# # ???
???
??? }- } G
##0.0000 }U } H
##0.0000 ?_- # # }- } I
##0.0000 }( } ef ##0.0000}( } ef ##0.0000}( } ef ##0.0000}( } ef ##0.0000}( } ef ##0.0000}( } ef ##0.0000}( } ef ##0.0000}( } ef ##0.0000}( } ef ##0.0000}( } ef ##0.0000}( } ef ##0.0000}( } ef ##0.0000}( } ef ##0.0000}( } ef ##0.0000}( } ef ##0.0000}( } ef ##0.0000}( } ef ##0.0000}( } ##0.0000}( } 23 ##0.0000}( } 23 ##0.0000}( } 23 ##0.0000}( } 23 ##0.0000}( } 23 ##0.0000}( } L ##0.0000}( } L ##0.0000}( } L ##0.0000}( } L ##0.0000}( } L ##0.0000}( } ef ##0.0000}- } ef 000 } } }- } ef 000 }- } ef 000 }( } ef f 000}( } 23 f 000}( } L f 000}( } ef f 000}( } ef f 000}( } 23 f 000}( } L f 000}( } ef f 000}( } ef f 000}( } ef f 000}( } ef f 000}( } 23 f 000}( } L f 000}( } ef f 000}- } L 000 }- } 23 000 }( } ef 3 000}( } ef 3 000}( } ef 3 000}( } 23 3 000}( } L 3 000}( } ef 3 000}( } ef 3 000}( } ef 3 000}( } 23 3 000}( } L 3 000}( } ef 3 000}( } ef 3 000}( } L 3 000}( } ef 3 000}( } ef 3 000}( } ef 3 000}( } 23 3 000}( } L 3 000}( } ef 3 000}( } ef 3 000}( } ef 3 000}( } ef 3 000}( } ef 3 000}( } ef 3 000}( } ef 3 000}( } ef 3 000}( } ef 3 000}( } ef 3 000}( } ef 3 000}( } ef 3 000}- } ef 000 }( } ef f 000}( } ef f 000}( } ef f 000}( } ef f 000}( } ef f 000}( } ef f 000} } } } } } }( } f 000}( } ef f 000}( } ef f 000}( } ef f 000}( } ef f 000}- } ef 000 }( } ef f 000}( } ef f 000}( } ef f 000}( } ef f 000}( } ef f 000
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 ] .& C u r r e n c y /. C u r r e n c y [ 0 ] 0 Explanatory TextG 5 E x p l a n a t o r y T e x t % 1 : F o l l o w e d H y p e r l i n k 2 Formulae - Changed 3 Formulae - Linked 4 Good; G o o d a % 5 Header - Cover 6
Header - Page 7 Header - Subtitle 8 Header - Title 9 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% @ Linked CellK L i n k e d C e l l } % A NeutralA N e u t r a l e % " N o r m a l
B Normal 2 C Noteb
N o t e D Outputw O u t p u t ???% ??? ??? ??? ??? E$ P e r c e n t F Percent 2
G Title1 T i t l e I}%
H TotalM T o t a l % O O I 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 8 3f f f f ̙ 3f 3 f ff 3f 3f 3 33 3 3f 33 333 \ Q 8 2zpWI1. R X Nick Langley - Personal View` +w %%TOBA_CACHE%% -
Quarter--> J 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 / . @ j b ( 3 A @ @
, 8 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||#NA7 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.566470 TGP0008AU7 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||#Value% 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||C0000054367 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.5700006 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.250000 *SPECIAL DISTRIBUTION* Quarterly Performance (%) Distribution (%)
Growth (%) Annual Performance (%)% RARE Infrastructure Value Fund Hedged APIR Net Distribution Amount (CPU)- RARE Infrastructure Value Fund Hedged Class AA ClearBridge RARE Infrastructure Value Fund - Hedged Class A Units ClearBridge Distribution Data Manager: ClearBridge Investments FY/FYTD (%) Return (Net) FY/FYTD Distribution/Yield (%) FY/FYTD Growth (%) 2 m 8 { L ! T
' ] b d i
@ a W c i ( . ~ e ` %
e ` % e
` %
e ` % e B 3 { b S
" t $ & 0) + . f 0 2 U F4 5 ;7 n 8 : c< !> T ? $
A IC |
D ( F uH J ? !K T L yN IP | R : S U D V X - Y Z \ @] O ^ _ a Ib X c
d !f 0 ig x h i @k O l n p q s c c B QLV[ZB<wYvI$
ZO t x | ) 9 I Ѯ Y i y ! 1 C
d MbP?_ * + % & ?' ?( ?) ? " QLV ? ?6R& U
!
"
#
$ D @ l ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?
%
! &
" '
# (
$ )
% *
& +
' ,
( -
) .
* /
+ 0
, 1
- 2
. 3
/ 4
0 5
1 6
2 7
3 8
4 9
5 :
6 ;
7 <
8 =
9 >
: ?
; @
< A
= B
> C
? D 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 [ \ ] ^ _
@ E
A F
B G
C H
D I
E J
F K
G L
H M
I N
J O
K P
L Q
M R
N S
O T
P U
Q V
R W
S X
T Y
U Z
V [
W \
X ]
Y ^
Z _
[ `
\ a
] b
^ c
_ d 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 { | } ~
` e
a f
b g
c h
d i
e j
f k
g l
h m
i n
j o
k p
l q
m r
n s
o t
p u
q v
r w
s x
t y
u z
v {
w |
x }
y ~
z
{
|
}
~
D @ l
D @ l
(
)
*
+
,
-
.
/
0
1
2
3
4
5
6
7
8
9
:
;
<
=
>
F
G
D @ l
H
I
J
D @ l
D @ l
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 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
{
|
}
~
D @ l
D @ l
D @ l
!
"
#
$
%
&
'
K
L
M
N D @ l
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 D @ l ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?
o
! p
" q
# r
$ s
% t
& u
' v
( w
) x
* y
+ z
, {
- |
. }
/ ~
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?_ * + % & ?' ?( ?) ? " ? ? & U P H 0 (
> @ 7 Sheet1b
! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; F L ? @ A B C D E G [ H I J K M l N O P Q R S T U V W X Y Z \ ^ ] _ b ` a m p d e f g h i j k n o q r ( b ( g g D
ZO $ : ` a
d MbP?_ * + % & zG?' ?( ?) ?M
\ \ r a r e s e r v e r \ C a n o n i R C 3 5 8 0 P C ߁ 4d X A 4 Canon
2C a n o n i R C 3 0 8 0 / 3 4 8 0 / 3 5 8 0 P C L 5 c iv dd d
d d
d
d d
d d@@ d d
d d d d" edd !'
) dd d
!"#$%&'()*-./089:1234567 d!! d
d !"#$%&'()*+,- dA
A d
d H8 4 < * p 1 4 < * p 1A XX d d A r i a l \CNZSRGBA.ICC \CNZSRGBA.ICC \CNZSRGBA.ICC C O N F I D E N T I A L C O N F I D E N T I A L H A r i a l D e f a u l t S e t t i n g s @ I " 8 XX ? ? & U } J } : J } ; < J } = = `J } > > @J } ? @ J } A A J } B J $ G Z ^ Q _ _
j Q d
Q Q d @ @ K @ | @ ~ @ @ | @ ~ @ @ @ @ @ @ @ @
' S S S S S S S S S S
( s V V r s s V V V t
" x
W ?
"
"
"
"
"
"
"
"
"
"
"
"
"
"
"
"
"
"
"
"
"
"
"
"
"
"
"
"
"
"
"
"
! "
" "
# "
$ "
% "
& "
' "
( "
) "
* "
+ "
, "
- "
. "
/ "
0 "
1 "
2 "
3 "
4 "
5 "
6 "
7 "
8 "
9 %
: &
; &
< &
= &
> &
? &
@ &
A & B X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X Y
[ #
!
"
#
$
%
&
'
(
)
*
+
,
-
.
/
0
1
2
3
4
5
6
7
8
9
:
;
<
=
>
?
@
A B \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ ]
@ `@ @ ,@ 7@ C@ `N@ Y@ @e@ p@ |@ `@ @ `@ @ @ @ @ @@ @ @ @ @ `@ @ `'@ 2@ >@ I@ U@ @`@ k@ w@ @! " # @ @@ @ @@ @ @ @ @ @@ @ @ @ @ @"@ -@ @9@ D@ O@ `[@ f@ @r@ }@ @ @ @ @@ @ @@ @ @ `@A B
A k @k +@k `7@k B@k @N@k Y@k e@k p@k {@k @@k @k @@k @k @k `@k @k @k @k @k @k @k @@k @k @'@k 2@k =@k `I@k T@k `@k k@ w@ @ @ @ @ @ @ @ @ `@ @ @ @ @ @ @ "@ -@ 9@ `D@ O@ @[@ f@ r@ }@ @ @ @ @ @ @ `@ @ @@ @A B 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 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 T q q q q q q q q q q q q q q q q q q q q q q q q q q q q q q A B q < B B @ L L L C q @ B B D q @ C B E q @ D B F q @ E B G q @ F B H q @ G B I q @ H B J q @ I B K q @ J B L q @ K B M q @ L B N q @ M B O q @ N B P q @ O B Q q @ P B R q @ Q B S q @ R B T q @ S B U q @ T B V q @ U B W q @ V B X q @ W B Y q @ X B Z q @ Y B [ q @ Z B \ q @ [ B ] q @ \ B ^ q @ ] B _ q @ ^ B ` q @ _ B a q @ ` B b q @ a B c q @ b B d q @ c B e q @ d B f q @ e B g q @ f B h q @ g B i q @ h B j q @ i B k q @ j B l q @ k B m q @ l B n q @ m B o q @ n B p q @ o B q q @ p B r q @ q B s q @ r B t q @ s B u q @ t B v q @ u B w q @ v B x q @ w B y q @ x B z q @ y B { q @ z B | q @ { B } q @ | B ~ q @ } B q @ ~ B q @ B q @ B q @ @ L L L q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ q @ > L L L q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q > q >
T $ ~
` Q@ ` n? ` 1%? a ?a ? a (@ 0 a a ?a ?a ?a ?a ?a ?
a ^K=? a ?a ?a @ a ʥ t@ a ?a @a ? a Ժyk? a ? ? ? U@ ? ? @ - ?
F%u!@ @ ? ?A B L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L L M
e f f f g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g g h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h h i
U B * k @k +@k `7@l B@l @N@l Y@ l 6 l p@l {@l @@l @l @@l @l @l `@ l @ D f l @l @l @l @l @l @@l @l @'@l 2@l =@l `I@l T@l `@l k@ w@ @ ! @ ! ! !& L " @ " ! # @ # ! $ @ $ ! % @ % ! & @ & ! B ' @ `@ @ @ @ @ @ @ @ "@ `-@0 1 9@ 1 D 1 f 2 D@ O@ @[@ f@ r@ }@ @ @ @ @ @ @ `@ @ @@ @A B l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l l O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O P
m C n o_? n DJ? b ?ܵ?~
b ]@ b S:? b V-? b b H}? b Fx?
a 0*? a z6>W[? a v?
` uq
? ` ea? ` _LJ? b z6>W[? b =,Ԛ ? b {/L
? b v/? b MJ? b M
O? b ^)? b H.!? b ?? b )Ǻ? b QI? b -? b Mb? b ? b >٬\? rh? ZӼ? ! n? " [٬? ; ]m{? < 1? = ?W[? > 8gDio? ? EGr? @ JY8? A &? B b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b b c
U N N O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O P
U D * N @N ,@O 7@O C@O `N@O Y@ O 6 O p@O {@O `@O @O @O @O @O @ O @ D ` O @O @O @O @O `2@O @@O @O @'@O 2@O =@O `I@O T@O `@O k@ w@ @ ! & L ! @ " " @ # # @ $ @
% @ % & @ % 6 ' @ `@ @ @ @ @ @ @ @. / "@ + D /~
0 `-@ 1 9@ / D 1 f 2 D@ O@ @[@ f@ r@ }@ @ @ @ @ @ @ `@ @ @@ @A B O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O P
m E n .!u? n y)? b ? b 6>W[? b ?5^I ? b V-? b o Zڊ? o +ݓ?
o 1 Zd? o V/? a 7[ A?
` MbX9? ` b48? ` V_? b o? b (? b ZӼ? b sA?~
b W@ b ?߾? b b48? b |a2U0*? b [B>٬? b RI&? b d`TR? b 䃞ͪ? b $(~k? b $? b Af? ^K=? 1w-! ? ! [Ӽ ? " fc]F? # :H? $ ~jt? % y):? & W2ı? ' Cl? ( @ǘ? ) V/'?~
* \@ + ^? , B? - y&1? . + h? / z6>W[? 0 ޓZ? 1 &S:? 2 N@a? 3 +e? 4 %u? 5 46 S!uq? ? (? @ [mE? { і? { ~1:? { FZ C? { {uټe? { TɁ? { r`? { bwK? { ˗!? { Bc(2[? & L d L ! { ^*
? ! " { ɝu? " # { x-? # $ { Jä? $ % { _E? % & { Gӄ? & & ' { hH
? ' D ' d D ' & ( { CwF? ( D ( d D ( & ) { *C? ) D ) d D ) & * { b^? * D * d D * & + { 65? + D + d D + , { 店? , , ,1 L d L - { x:q? - , . { U? . , / { 30]X#? / , 0 { ftd? 0 , 1 { Xk? 1 , 2 { ? 2 2 27 L d L 3 { u$c? 3 2 4 { O? 4 2 5 { Vx? 5 2 6 { **? 6 2 7 { C-Xe? 7 2 & 8 D
? 8 D 8 d D 8 & 9 ]k$7? 9 D 9 d D 9 & : gCv? : D : d D : & ; *՟MB2? ; D ; d D ;
! YZg P? D D ut? L L w=
C? [ 0}? xy⫺ ^_@n 6
! PB|? D D ! -/? D D àb? et T
<+!? ȰO!? oZ? 5n? 9U? \Mװ? p/ e hmʜ? b ? {TPИ? .O4? gB&? iWL? ! _Z? " ! !& L L " 3 # ! # p}ų ! $ R' # ! % &z $ ! & 抐k|? & ! ! ' 6e ( D 'D ' ! ( qBy%? ) D (D ( ! ) *C * D )D ) ! * "\? & D *D * ! + LW졿 ' D +D + , Iy - , ,2 L L - N . , . G / , / e>g? 0 , 0 roA 1 , 1 \^ͪ 1 , 2 :HU6? , , 3 z(? 2 3 38 L L 4 Z ? 3 3 5 Fg? 4 3 6 ջѾ? 5 3 7 *? 6 3 8 ==X? 7 3 ! 9 2? 8 D 9D 9 ! : ٜN? 9 D :D : ! ; .2? : D ;D ;
y ! z z z z z z v/ z z z
z Mbȿ z z z
z l? z z z z &1 ? z { { { Mb? z z z { bX9?~
{ 2@ # { 9v? $ { 8 ;
} { { { { { . { gS? % d D { { { .
{ zwXa?
%
d D
{ { {
. { mR&? % DD d D { { { . { fDmE? % B d D { { { . { :(p ? %
d D { { { . { ? % d D . { X76j? % d D . # 'NQY8? # % # d D # $ { 8 ;
! ft D D !
!e˿ D
D
! /sO? D D ! =? D D ! |\nDz ! D D ! Ŏ1? D D ! rqӆ? D D ! # *гwd} $ D #D # $ 8 ; 8 ;
) #
a? ' ʃ? + m>y;i? / %lh? 2 3 h @ d te reA
8 A AA 7 n l L 2 End date is the effective date of the distribution Incorrect date format L ' / ' / Z l Reinvestment price Must be greater than zero on co l L $ Cum-exit price less distribution CPU Must be greater than zero ? \ t PKD di
9 L t o
l 0 Enter CPU amount in cents only, not dollar value) CPU must be greater than or equal to zero / ' L J Ensure start date falls the day after the previous distribution's end date Incorrect date format ' XG , st at . Fund Name t r % Enter APIR Code or Morningstar Ticker# Maximum text length of 9 characters In ct e L Reinvestment date Incorrect date format im XG xt & 0 2 > ? B m L Effective distribution date Invalid date format t XG & 3 = @ A 0 Y This row is not read Must be Y or N only or Y N G > ? B APIR Code APIR Code, Please enter APIR Code or Morningstar Ticker Maximum of 9 characters allowed XG C Fund Name Please enter fund name de r T L Actual distribution date Incorrect date format XG ke
l C Either enter CPU/day amount or whole amount in cell above, not both% Must be greater than or equal to zero
Sheet3b( b ( g g D
d i r S h e e t 1
S h e e t 2 S h e e t 3 -
! " # $ % & ' ( ) * + , . / 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 b c d e f g i j k l m n o p q r s t u v w x y z { | } ~ 0* pH d
VBAProject 4 @j
=
r R> J<
r@stdoles t d o l@ e
h %^ *\G{00020430- C
0046 }#2.0#0# C:\Windo ws\System32\e2.t lb#OLE A utomation ` EOffi"cEO f i jcEE2 DF8D04C- 5BFA-101@B-BDE5EAjAC42Eg ram File s\CommonMicroso ft Share d\OFFICE 16\MSO.DLL#M 16 .0 Ob Library K TFExce lAddin> T F E "xcl Ad i n bW*\CL)Thoms)nan cial\EON@Onalytic@s for C&\ In.xlaF
¦ ySheet2GBCSeot 2T H2N A T HB1«3 B,"B
+BBThis WorkbookGD\h@Xs W@r k bo 2 $$&ModuleD4G y M d u4A2 -!4!b %!
@/A/i2 ƀ1o 1j 11WLᙧLAL
L +:&
3Zn3@
3
: - 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 % @ x Attribut e VB_Nam e = "She@et1"
Bast0{00020820- C $0046}
|Global!SpacFalse dCreatabl Pre decla Id Tru
BExpose Temp lateDeriv$Bustom izD2 - 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 i t % @ x Attribut e VB_Nam e = "She@et2"
Bast0{00020820- C $0046}
|Global!SpacFalse dCreatabl Pre decla Id Tru
BExpose Temp lateDeriv$Bustom izD2 - 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 \ M % @ x Attribut e VB_Nam e = "She@et3"
Bast0{00020820- C $0046}
|Global!SpacFalse dCreatabl Pre decla Id Tru
BExpose Temp lateDeriv$Bustom izD2 H yW x M o d u l e 1 =
M o d u l e 2
h ( M o d u l e 4 $
_ _ S R P _ 0 ME ( 6
< < < j ` X ( Macro recorded 5/02/2007 by Nick Langleyx
14 h % ( в$ * \ R f f f f * 1 0 6 4 4 9 0 8 d e " 0 ( X ` 8d h ( ( 0 X p ( (
Macro1 Macro ) 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 ( 6
< < < . ` , % ` ` X 0$ * \ R f f f f * 0 y 6 4 4 9 0 8 d e . P X " ` , h 8d > > @ t ( 8
Macro1 Macro c e ' Macro recorded 11/01/2007 by Bloomberg u " 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
؋S
Js^
A A A 0
1
Q a q
VBAProject Sheet2 ThisWorkbook Module4 Module2 Module1 Sheet1 Sheet3 F B C:\Program Files\Common Files\Microsoft Shared\VBA\VBA7.1\VBE7.DLL VBA
q A P Excel F 9 C:\Program Files\Microsoft Office\Root\Office16\EXCEL.EXE
A p 0 F C:\Windows\System32\stdole2.tlb stdole
a L-[ DR ? C:\Program Files\Common Files\Microsoft Shared\OFFICE16\MSO.DLL Office
Q Open_PTM_Files
Macro2 Macro1h rU@ @ @ _ _ S R P _ 1 , _ _ S R P _ 2 _ _ S R P _ 3 _ _ S R P _ 4
& 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 a S 4 rU@ @ @ 8 ` b _ _ S R P _ 5 _ _ S R P _ 6 _ _ S R P _ 7 T h i s W o r k b o o k rU@ @ @ @ ~x a S 4 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 i t % @ x Attribut e VB_Nam e = "Thi sWorkbook"
Bas0{00020P819- 0C $0046}
|GlobalSpacFalse dCreatabl Predecla Id Tru
BExpose Templ ateDerivBustomizD2 ID="{20E7129B-17FB-48F7-8489-D3C428093DE0}"
Document=ThisWorkbook/&H00000000
Document=Sheet2/&H00000000
Module=Module4
Modul_ V B A _ P R O J E C T c P R O J E C T w P R O J E C T w m R e v i s i o n L o g 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 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
R> y S h e e t 2 0 r 6 4 4 9 0 8 d 6 ' S h e e t 2 3 T h i s W o r k b o o k 0 s 6 4 4 9 0 8 d 6 + T h i s W o r k b o o k 3 M o d u l e 4 0 y 6 4 4 9 0 8 d e , M o d u l e 4 4 0 M o d u l e 2 0 z 6 4 4 9 0 8 d e ^ M o d u l e 2 H M o d u l e 1 1 0 6 4 4 9 0 8 d e h M o d u l e 1 W ` S h e e t 1 0 w 6 4 4 9 0 8 d 6 S h e e t 1 x 3 S h e e t 3 0 x 6 4 4 9 0 8 d 6 S h e e t 3 3 ` 0 H x Tu;D\: mKyH/
%/W \-ʵBD*C ^aQf7AK|, JsHmKW 5ǫ apC̗5a (~D0P[ P B< 2 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
Sheet1 Sheet3 Workbookk Worksheet " $ ' + - _ i ~
! e=Module1
Module=Module2
Document=Sheet1/&H00000000
Document=Sheet3/&H00000000
Name="VBAProject"
HelpContextID="0"
VersionCompatible32="393222000"
CMG="595B922296229622962296"
DPB="525099E293E393E393"
GC="4B4980ED78EE78EE87"
[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
Sheet1=0, 0, 0, 0, C
Sheet3=0, 0, 0, 0, C
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 Sheet1 S h e e t 1 Sheet3 S h e e t 3 2
Nick Langley
Oh +'0 P X
$ Stock Research & Valuation Model Nick Langley Carter, Nicole Microsoft Excel @
*\@ x{@ ݁
՜. +,D ՜. +, 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 ( C o m p O b j l l ( P X t |
RARE Infrastructure Quarter--> Dist IMD02P004 'Dist IMD02P004'!Print_Area Worksheets
Named Ranges ( c k { CachePFDLData FDSMenuDocLevelBtnStates True 8
F Microsoft Excel 2003 Worksheet Biff8 Excel.Sheet.8 9q