ࡱ > ? 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 S͕ > @ H W o r k b o o k s _ V B A _ P R O J E C T _ C U R " P4> > 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 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 , 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 1 S e g o e U 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 6 1 _-* #,##0.00_-;* \-#,##0.00_-;_-\ * "-"??_-;_-@_- 8 3 _-* #,##0.000_-;* \-#,##0.000_-;_-\ * "-"??_-;_-@_- : 5 _-* #,##0.0000_-;* \-#,##0.0000_-;_-\ * "-"??_-;_-@_- 0.000% + & * _-"$"#,##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.00000000;\(#,##0.00000000\);"-" 7 2 _-* #,##0.000_-;\-* #,##0.000_-;_-* "-"???_-;_-@_- "Yes";"Yes";"No" "True";"True";"False" "On";"On";"Off" ] , [ $ - 2 ] \ # , # # 0 . 0 0 _ ) ; [ R e d ] \ ( [ $ - 2 ] \ # , # # 0 . 0 0 \ ) < 7 _(* #,##0.0000_);_(* \(#,##0.0000\);_(* "-"????_);_(@_) < 7 _-* #,##0.00000_-;* \-#,##0.00000_-;_-\ * "-"??_-;_-@_- 0.0 0.0000% { ; _ - [ $ - 2 ] * # , # # 0 . 0 0 _ - ; \ - [ $ - 2 ] * # , # # 0 . 0 0 _ - ; _ - [ $ - 2 ] * " - " ? ? _ - ff + + + + + + +
!
# P P ! " ` # $ % & a > ' * @ * @ * @ @ * @ * * @ * @ * @ * @ @ * ! @ * ! @ * * @ @ @ @ @ A @ @ A @ @ @ @ !@ @ A !@ @ A
A @ @
A !@ @
A @ @ A !@ @ A @ @ A A @ @ * @ @ * * @ @ * * @ * * @ * * @ @ + * @ @ + * @ + * @ + * @ @ 3 * @ @ 3 * @ 3 * @ 3 A @ @ A @ @ + A @ @ 3 * @ @ * @ @ * @ * @ A @ @ * 3 * @ @ 3 # ! # * @ @ * * * A @ @ * @ @ * @ * @ * @ * @ 3 * @ + * @ * * @ * * @ @ * @ @ * @ @ + * @ @ * @ @ @ @ * @ @ * @ @ 3 * @ @ + * @ @ * * @ @ @ * @ * @ !@ @ @ @ * @ @ @ @ 3 @ @ + * !@ @ * !@ @ 3 * !@ @ + * !@ @ * * !@ @ * !@ @ * !@ @ @ @ @ * ! @ * @ @ * x ( * @ @ * @ @ * * @ * @ * H H A @ @ A @ @ A !@ @ h@ @ h@ @ h!@ @ A @ @ H ) ! ( ( ( A @ @ A h@ @ * @ @ 3 * @ @ . * @ . * ! @ . * x . ( * @ @ . * @ @ . * . * @ . * @ . * . A @ @ . @ / * ! @ / * @ @ / * x / ( * @ @ / * @ @ / * / * @ / * @ / * / | | <&}A }
0 . 0 0 ef - 2 ] * }A }
0 . 0 0 ef - 2 ] * }A }
0 . 0 0 ef - 2 ] * }A }
0 . 0 0 ef - 2 ] * }A }
0 . 0 0 ef - 2 ] * }A }
0 . 0 0 ef - 2 ] * }A }
0 . 0 0 L - 2 ] * }A }
0 . 0 0 L - 2 ] * }A }
0 . 0 0 L - 2 ] * }A }
0 . 0 0 L - 2 ] * }A }
0 . 0 0 L - 2 ] * }A }
0 . 0 0 L - 2 ] * }A }
0 . 0 0 23 - 2 ] * }A }
0 . 0 0 23 - 2 ] * }A }
0 . 0 0 23 - 2 ] * }A }
0 . 0 0 23 - 2 ] * }A } !
0 . 0 0 23 - 2 ] * }A } "
0 . 0 0 23 - 2 ] * }A } #
0 . 0 0 - 2 ] * }A } $
0 . 0 0 - 2 ] * }A } %
0 . 0 0 - 2 ] * }A } &
0 . 0 0 - 2 ] * }A } '
0 . 0 0 - 2 ] * }A } (
0 . 0 0 - 2 ] * }A } *
0 . 0 0 - 2 ] * } } ,
0 . 0 0 - 2 ] * ???. 0 0 _ ??? - 2 ] ???? _ -
??? }- } 9
0 . 0 0 }A } =
a 0 . 0 0 - 2 ] * }A } C
0 . 0 0 - 2 ] * }A } D
0 . 0 0 ? - 2 ] * }A } E
0 . 0 0 23 - 2 ] * }- } F
0 . 0 0 } } H
??v 0 . 0 0 ̙- 2 ] * . 0 0 _ - 2 ] ? _ -
}A } I
} 0 . 0 0 - 2 ] * }A } J
e 0 . 0 0 - 2 ] * }- } Q
0 . 0 0 }x } R 0 . 0 0 - 2 . 0 -
? _} } S
??? 0 . 0 0 - 2 ???. 0 ??? -
???? _ -
??? }- } ]
0 . 0 0 }- } _
0 . 0 0 }U } `
0 . 0 0 - 2 . 0 }- } a
0 . 0 0 }( } ef 0 . 0 0}( } ef 0 . 0 0}( } ef 0 . 0 0}( } ef 0 . 0 0}( } 0 . 0 0}( } 0 . 0 0}( } 0 . 0 0}( } 0 . 0 0}( } L 0 . 0 0}( } L 0 . 0 0}( } L 0 . 0 0}( } L 0 . 0 0}( } 0 . 0 0}( } 0 . 0 0}( } L 0 . 0 0}( } 23 0 . 0 0}( } 23 0 . 0 0}( } 23 0 . 0 0}( } 23 0 . 0 0}( } 23 0 . 0 0}( } L 0 . 0 0}( } L 0 . 0 0}( } ef 0 . 0 0}( } ef 0 . 0 0}( } ef 0 . 0 0}( } L 0 . 0 0}( } 0 . 0 0}( } ef 0 . 0 0}( } 23 0 . 0 0}( } 0 . 0 0}( } 23 0 . 0 0}( } L 0 . 0 0}( } 0 . 0 0}( } ef 0 . 0 0}( } 23 0 . 0 0}( } ef 0 . 0 0}( } L 0 . 0 0}( } 0 . 0 0}( } L 0 . 0 0}( } 0 . 0 0}( } ef 0 . 0 0}( } 23 0 . 0 0}( } 23 0 . 0 0}( } ef 0 . 0 0}( } ef 0 . 0 0}( } ef 0 . 0 0}( } ef 0 . 0 0}- } ef 0 0 }( } ef f 0 0}( } ef f 0 0}( } ef f 0 0}( } ef f 0 0}( } ef f 0 0}( } ef f 0 0}( } ef f 0 0}( } ef f 0 0}( } ef f 0 0}( } ef f 0 0}( } ef f 0 0}( } ef f 0 0}( } ef f 0 0}( } ef f 0 0} } } } } } }( } ef f 0 0}( } f 0 0}( } L f 0 0}( } ef f 0 0}( } ef f 0 0}( } ef f 0 0}( } ef f 0 0}- } ef 0 0 }( } ef f 0 0}( } ef f 0 0}( } ef f 0 0}( } ef f 0 0}( } ef f 0 0}( } ef f 0 0}( } ef f 0 0}( } ef f 0 0}( } ef f 0 0}( } ef f 0 0}- } ef 0 0 }( } ef f 0 0}( } ef f 0 0}( } ef f 0 0}( } ef f 0 0}( } ef f 0 0
bidires=100
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 0 Comma 2 2 1 Comma 2 2 2 2 Comma 2 2 3 3 Comma 2 2 4 4 Comma 3 5 Comma 4 6& C u r r e n c y 7. C u r r e n c y [ 0 ] 8 Euro 9 Explanatory TextG 5 E x p l a n a t o r y T e x t % : : F o l l o w e d H y p e r l i n k ; Formulae - Changed < Formulae - Linked = Good; G o o d a % > Header - Cover ?
Header - Page @ Header - Subtitle A Header - Title B Header - Year Row C Heading 1G H e a d i n g 1 I}% O D Heading 2G H e a d i n g 2 I}% ? E Heading 3G H e a d i n g 3 I}% 23 F Heading 49 H e a d i n g 4 I}% G( H y p e r l i n k
H Inputu I n p u t ̙ ??v% I Linked CellK L i n k e d C e l l } % J NeutralA N e u t r a l e % " N o r m a l
K Normal 2 L
Normal 2 2 M
Normal 2 3
N Normal 3 O
Normal 3 2
P Normal 4
Q Normal 57 N o r m a l 5 % R Noteb
N o t e S Outputw O u t p u t ???% ??? ??? ??? ??? T$ P e r c e n t U Percent 2 V Percent 2 2 W
Percent 2 2 2 X
Percent 2 2 3 Y
Percent 2 2 4 Z
Percent 2 2 5 [ Percent 2 3 \ Percent 3 ] Percent 4 ^ Style 1
_ Title1 T i t l e I}%
` TotalM T o t a l % O O a 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` t %%TOBA_CACHE%% x
Quarter--> A 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 f~ f h H @ Z R 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.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||#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 TGP0034AU Quarterly Performance (%) Distribution (%)
Growth (%) Annual Performance (%)' RARE Infrastructure Value Fund Unhedged APIR Net Distribution Amount (CPU)C ClearBridge RARE Infrastructure Value Fund - Unhedged Class A Units ClearBridge Distribution Data Manager: ClearBridge Investments FY/FYTD (%) Return (Net) FY/FYTD Distribution/Yield (%) FY/FYTD Growth (%) 2 N { L c ! 5
] C d J @ B W D U + 8 b < | "
b < | " b < | " b
< | " b < _ 1 y 7 Q A 8
+ " $ t h' ) I H, . 4 0 r D2 3 J5 6 6 8 r: 0< > R
? FA
C \ D pF H U I p J
L XN P h Q S q T ,V Z }W X Y + =[ k }\ ] ^ - G` u a
b d M ge f g % =i k k 3 l n o p c c B QLV[ZB<wYvI$
ZO t @v z 0 @ ȕ P ؞ ` p ( 8 H
d MbP?_ * + % & ?' ?( ?) ? " QLV ? ? ?
%
! &
" '
# (
$ )
% *
& +
' ,
( -
) .
* /
+ 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
:
;
<
=
E
F
D @ l
G
H
I
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 /
P 0
Q 1
R 2
S 3
T 4
U 5
V 6
W 7
X 8
Y 9
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
!
"
#
$
%
&
J
K
L
M D @ l
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 D @ l ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?
n
! 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
. > @ @ 2zpWI1. d @ < & ?' ?( ?) ? " ? ?< & 2zpWI1. 7 Sheet2g g D
ZO
d MbP?_ * + %
! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = H N A B C D E F G I ] J K L M O n P Q R S T U V W X Y Z [ \ ^ ` _ a d b c o r f g h i j k l m p q s t & ?' ?( ?) ? " ? ? & U > @ 7 Sheet1b( b ( g g D
ZO $ |f g
d MbP?_ * + % & zG?' ?( ?) ?M \ \ s y p r i n t 0 1 V \ K y o c e r a C o l o r O p s ' d X X " dPcK Y 0 4 * * * * 4 * * * *
E E 001 0000 L - L -
2 d d @ ? ? X X 0 J , X <
0000 Arial ? A A A A " " " " " " " " " " " " " " " " / dPcKP Y 0 dPcK' Y dPcK N Y D C o n f i d e n t i a l 1 dPcK Y 3
2 dPcKd Y dPcKc Y < z " 8 XX ? ? & U } b } % b } & & } ' * b } + , b } - - b } . / b } 0 ` b $ j k
s f n
f f n . . c . . . . . . . . . . . . .
&
'
>
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
! !
" !
# !
$ !
% !
& !
' !
( $
) $
* $
+ $
, $
- $
. $
/ $ 0
"
!
"
#
$
%
&
'
(
)
*
+
,
-
.
/ 0
? @@ @ @ @ @ `@ @ `'@ 2@ >@ I@ U@ @`@ k@ w@ @ @ @@ @ @@ @ @ @ @ @@ @ @ @ @ @"@ -@ @9@ D@ O@ `[@ f@ @r@ }@ @ @ @ @@ @ @@ @ @ `@/ 0
@ @ @ @ @ @@ @ @'@ 2@ =@ `I@ T@ `@ k@ w@ @ @ @ @ @ @ @ `@ @ @ @ @ @ @ "@ -@ 9@ `D@ O@ @[@ f@ r@ }@ @ @ @ @ @ @ `@ @ @@ @/ 0 ' D D D TGP0034AU4118341274 ' 0 D D D TGP0034AU4127541364 : '
( %
) % * / ' 0
D 0D 0D 0 1 0 1 1p @ L L L 2 @ 1 1 3 @ 2 1 4 @ 3 1 5 @ 4 1 6 @ 5 1 7 @ 6 1 8 @ 7 1 9 @ 8 1 : @ 9 1 ; @ : 1 < @ ; 1 = @ < 1 > @ = 1 ? @ > 1 @ @ ? 1 A @ @ 1 B @ A 1 C @ B 1 D @ C 1 E @ D 1 F @ E 1 G @ F 1 H @ G 1 I @ H 1 J @ I 1 K @ J 1 L @ K 1 M @ L 1 N @ M 1 O @ N 1 P @ O 1 Q @ P 1 R @ Q 1 S @ R 1 T @ S 1 U @ T 1 V @ U 1 W @ V 1 X @ W 1 Y @ X 1 Z @ Y 1 [ @ Z 1 \ @ [ 1 ] @ \ 1 ^ @ ] 1 _ @ ^ 1 ` @ _ 1 a @ ` 1 b @ a 1 c @ b 1 d @ c 1 e @ d 1 f @ e 1 g @ f 1 h @ g 1 i @ h 1 j @ i 1 k @ j 1 l @ k 1 m @ l 1 n @ m 1 o @ n 1 p @ o 1 q @ p q q @ L L L r @ q q s @ r q t @ s q u @ t q v @ u q w @ v q x @ w q y @ x q z @ y q { @ z 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
h # ǘ? ? ? ? 4r"D? ? ? ? ne@
? ? ?
K7@ ? ? @ jt @ ? ? ? jM@ ? @ @ V- @ 0 @ @ @ Ps@ ? ? @ ! `̖ @ 0 " @ @ @ ? ? @ ?( ) $%= .@ * ? @ @, - gDio@ . @ @/ 0
o p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p p 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 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 q q q r
i A ` t @t @t @t @t @@t @t @'@t 2@t =@t `I@t T@t `@t k@ w@ @ @ D @ D @ D @ D @ D @ `@ @ @ @ @ @ @ @ "@ `-@ 9@ D@ O@ @[@ f@ r@ }@ @ @ @ @ @ @ `@ @ @@ @/ 0 t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t t d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d d e
u B l uV? l B`"? l (
? l K7? l $C? l T㥛 ? l @ǘ? l Oe? l mV}b?
l >yX5? l d]K? l Cl?
l ? ]C? ? z? 1%? ,eX? =,Ԛ ? m4? ec]? F%u? 9m4?~
? 7A`? 6? + J4? , Dio? - [ A? . V/? / ׁ? 0 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 l m
g w & ) v x x x x x x & )
y z C 6z? z L7A`尿 { I +? { I +? { ~jt? { /$? { +? { L7A`? { K?
{ K? { X9v? { l?
{ ?{ @{ @ { #~j? { rh { ;On? { Q 롿 { ~jt { @{ { I +? { @{ @ { ~jt? { ;On { Mb { L7A`? { @{
{ (@ & q? ' q? ( q? ) q?
| & 3-L5? D d D { u? L d L { Y)<u? { Ct? { 繨E? { beF? { $? { G廬? { 'a ? L d L
{ }> d?
{ S? { UI5Qꋈ?
{ Qy{͠?
{ \b,C? { Bq? { սi? { "N? { D鲐^? L d L M
lv^? pFp? Sě? frޥ? 1? =)? d7R? ֗? L d L D? 7{4b? P{? #O#? Ha|P? & G}? D d D & & B[W? & D & d D & & ' bT? ' D ' d D ' & ( 4;Ԅ? ( D ( d D ( & ) hX]? ) D ) d D )
} ! ~ -0\&5x? D D ~ ;C
L L ~ jhRKw? ~ C? ~ 7`nZ? ~ x Ho? ~ Ѐɪ? ~ ܖ!? ~ ~3٩?
~ ( ? ~ Ne?
~ cY?
~ dC5] ~ NG3? L L ~ 8ޏ? ~ e
b? ~ 3S! ~ 2Y? ~ f庹"æ ~ `be L L ~ ]~ڡ}? ~ pC ~ ι~_r ~ 1;`? ~ +{y₿ ~ | L L ~ 5)1p젿 ~ p ~ V j^? ~ pX? ~ vU)7 ! ~ ^pa? D D ! & w+? D &D & ! ' bo? & D 'D ' ! ( 3{z ? ' D (D ( ! ) ̮«_? ( D )D )
y MbP ~jt?~
0@ Mb? { & )
| . k|`? % d D . LGL? % d D .
{: ?
%
d D
. d˸? % d D & )
} ! .Zf D D ! UC? D D !
jZf? D
D
! JA o? D D & ) & ) & ) & )
( ` $`? Mñ;? ౦#? Eס? ! ӿaQ? " $ % ` X & ( ) 0r`Ͼ? - xC?
) & .?? 4 *? ݿ? e?
b ! ЗK}W? " $ % ' ? & ( ) sDWخ? - O5?
* 5
? p:Rr %#Ǘa Hx ! +3FK? " $ % 6rD & ( ) Y|Ʈ? - ׀\ps? B R X
((A 2 F$x & ! " # !
! " " # # < & 4 (
Z
X P P Q Q ? z i i ] 4 @
+"zGb8D\
0 < 1 These numbers are sourced from our administrator< 0
Z
X P P Q Q ? z i ] 4 @
BL[mK-bFV
0 < 1 These numbers are sourced from our administrator< 0
Z 0
X P P Q Q ? z i Z ] 4 @
ՇLJgh
0 < 1 These numbers are sourced from our administrator< 0 Carter, Nicoled Carter, Nicoled Carter, Nicoled> @ d te reA
& . .. ` 7 APIR Code APIR Code, Please enter APIR Code or Morningstar Ticker Maximum of 9 characters allowed & C Fund Name Please enter fund name de r & L 2 End date is the effective date of the distribution Incorrect date format chL % % e L Reinvestment date Incorrect date format ib XG
, - 0 } L Effective distribution date Invalid date format XG & + . / & ? \ ve PKD on
9 L ve o
L J Ensure start date falls the day after the previous distribution's end date Incorrect date format / XG , st at l 0 Enter CPU amount in cents only, not dollar value) CPU must be greater than or equal to zero rm % . Fund Name t c % r % Enter APIR Code or Morningstar Ticker# Maximum text length of 9 characters r t % Y This row is not read Must be Y or N only mu Y N n , - 0 R l Reinvestment price Must be greater than zero Y n T L Actual distribution date Incorrect date format XG
d L $ Cum-exit price less distribution CPU Must be greater than zero s 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<
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 151WLᙧLAgL
L +:&
3ݭZ3@
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 ) M % @ 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 % @ 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 % @ 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 P 6 4 4 9 0 c c 7 " 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 ( 6
< < < . ` , % ` ` X $ * \ R f f f f * 1 N 6 4 4 9 0 c c 7 . 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 ^'In%^
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="{EDCDB698-A912-4C7D-BCAF-47A1DE21D029}"
Document=ThisWorkbook/&H00000000
Document=Sheet2/&H00000000
Module=Module4
Modul_ V B A _ P R O J E C T e P R O J E C T y 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 1 G 6 4 4 9 0 c b f ' S h e e t 2 3 T h i s W o r k b o o k 1 H 6 4 4 9 0 c b f + T h i s W o r k b o o k 3 M o d u l e 4 1 N 6 4 4 9 0 c c 7 , M o d u l e 4 4 0 M o d u l e 2 1 O 6 4 4 9 0 c c 7 ^ M o d u l e 2 H M o d u l e 1 1 P 6 4 4 9 0 c c 7 h M o d u l e 1 W ` S h e e t 1 1 L 6 4 4 9 0 c b f S h e e t 1 x 3 S h e e t 3 1 M 6 4 4 9 0 c b f S h e e t 3 3 x ` 0 H cG
N0 9y ]S3@E$h~ԃ
:SIŸ7K ZɨV9B)% ;0 6=$_N) !q_jG{L dO3z6Z 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="5F5D771499342E382E382E382E38"
DPB="F0F2D81BD91BD91B"
GC="8183A9AAAAAAAA55"
[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