ࡱ > C b 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 ̚ D @N W o r k b o o k z _ V B A _ P R O J E C T _ C U R " V; i V B A @ P
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 Q T a h o m a 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 A r i a l 1 H e l v 1 C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 , 8 C a l i b r i 1 8 C a l i b r i 1 8 C a l i b r i 1 > C a l i b r i 1 4 C a l i b r i 1 < C a l i b r i 1 ? C a l i b r i 1 C a l i b r i 1 h 8 C a m b r i a 1 C a l i b r i 1
C a l i b r i 1 C a l i b r i 1 C a l i b r i "$"#,##0;\-"$"#,##0 "$"#,##0;[Red]\-"$"#,##0 "$"#,##0.00;\-"$"#,##0.00 # "$"#,##0.00;[Red]\-"$"#,##0.00 5 * 0 _-"$"* #,##0_-;\-"$"* #,##0_-;_-"$"* "-"_-;_-@_- , ) ' _-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_- = , 8 _-"$"* #,##0.00_-;\-"$"* #,##0.00_-;_-"$"* "-"??_-;_-@_- 4 + / _-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_- "$"#,##0_);\("$"#,##0\) ! "$"#,##0_);[Red]\("$"#,##0\) " "$"#,##0.00_);\("$"#,##0.00\) ' " "$"#,##0.00_);[Red]\("$"#,##0.00\) 7 2 _("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_) . ) _(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_) ? : _("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_) 6 1 _(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) 4 / _-* #,##0.0_-;* \-#,##0.0_-;_-\ * "-"??_-;_-@_- 0.0% 0 + _-* #,##0_-;* \-#,##0_-;_-\ * "-"??_-;_-@_-
dd/mm/yyyy 0.0000
0.00000000 0.00000
0.000000 mmm\-yyyy 6 1 _-* #,##0.00_-;* \-#,##0.00_-;_-\ * "-"??_-;_-@_- 8 3 _-* #,##0.000_-;* \-#,##0.000_-;_-\ * "-"??_-;_-@_- : 5 _-* #,##0.0000_-;* \-#,##0.0000_-;_-\ * "-"??_-;_-@_- * % #,##0.00000000;\(#,##0.00000000\);"-" 0.0000000 + & * _-"$"#,##0;* \-"$"#,##0;* _-"$""-";@ * #,##0;* \-#,##0;* "-";@ 3 . * _-"$"#,##0.00;* \-"$"#,##0.00;* _-"$""-"??;@ & ! * #,##0.00;* \-#,##0.00;* "-"??;@ & ! #,##0.000000;\(#,##0.000000\);"-" " #,##0.0000;\(#,##0.0000\);"-" #,##0.00;\(#,##0.00\);"-" " #,##0.00;\ \(#,##0.00\);\ "-" #,##0;\(#,##0\);"-" #,##0.00;\(#,##0.00\);\ "-" 0.000%
#,##0.0000 ! [$-C09]dddd\,\ d\ mmmm\ yyyy [$-409]h:mm:ss\ AM/PM 0.0000% < 7 _-* #,##0.00000_-;* \-#,##0.00000_-;_-\ * "-"??_-;_-@_- > 9 _-* #,##0.000000_-;* \-#,##0.000000_-;_-\ * "-"??_-;_-@_- @ ; _-* #,##0.0000000_-;* \-#,##0.0000000_-;_-\ * "-"??_-;_-@_- C > _-* #,##0.0000000_-;\-* #,##0.0000000_-;_-* "-"???????_-;_-@_- "Yes";"Yes";"No" "True";"True";"False" "On";"On";"Off" ] , [ $ - 2 ] \ # , # # 0 . 0 0 _ ) ; [ R e d ] \ ( [ $ - 2 ] \ # , # # 0 . 0 0 \ ) : 5 _-* #,##0.0000_-;\-* #,##0.0000_-;_-* "-"????_-;_-@_- { ; _ - [ $ - 2 ] * # , # # 0 . 0 0 _ - ; \ - [ $ - 2 ] * # , # # 0 . 0 0 _ - ; _ - [ $ - 2 ] * " - " ? ? _ - ff + + + + + + + + + ,
!
# ! P " P # # $ % ` & & @ ' ( ) * a > + , ! - - , @ @ , * @ @ - * @ - * @ - @ - * @ @ - * , @ - * - * - * - * - * @ - * @ - @ - * @ - * @ - * - * @ @ - * @ @ - A @ @ - A @ @ - @ @ - A - A @ @ -
A @ @ - A @ @ - @ @ + - A @ @ + - * 3 - * @ @ 3 - * 3 - * @ 3 - * @ 3 - @ @ 3 - A @ @ 3 - @ @ 3 - * @ @ - * @ - * @ - * , - * @ @ , - * , - * @ @ , - * @ , - * @ , - @ @ , - A @ @ , - @ @ , - * - - * @ @ - - * - - * @ @ - - * @ - - * @ - - @ @ - - ( @ @ - - A @ @ - - @ @ - - *
- * @ @
- *
- * @ @
- * @
- * @
- @ @
- A @ @
- @ @
- * 4 - * @ @ 4 - * 4 - * @ @ 4 - * @ 4 - * @ 4 - @ @ 4 - A @ @ 4 - * @ @ - * - * @ @ - * @ - * @ - @ @ - A @ @ - * @ @ 3 - * @ @ , - - @ @ * - A @ @ * - , -
A @ @ 3 - - A @ @ - A @ @ - A @ @ , - A @ @ 3 - A @ @ - A @ @ 4 - A @ @
- A @ @ - -
A @ @ - -
A @ @ , -
A @ @ + -
A @ @ * -
A @ @ - - - , @ - * @ @ - * @ @ , - * @ @ 3 - * @ @ - * @ - * @ - * - * , - * 3 - * - * 4 - *
- * - - * - @ @ - * @ @ 3 - * @ @ - * @ 3 - * @ @ - - * @ @ , - * @ , !@ @ , * !@ @ 4 , * !@ @
, * !@ @ - , * !@ @ , , * !@ @ 3 , * !@ @ , * ! @ , * ! @ , , * ! @ 3 , * ! @ , * ! @ , * ! @ , @ @ , @ @ , , @ @ 3 , @ @ , @ @ 4 , @ @
, @ @ - - @ - * - * , - * - @ @ - * @ @ - * @ @ - * @ @ 4 - * @ @
, @ @ , * !@ @ - * @ @ - * - @ - * - * - * - * @ - * @ , @ @ * , * !@ @ * - * @ @ * - * * - * @ @ * - * * - * * - * @ * - * @ * - @ @ * - @ @ , @ @ , * !@ @ - * @ @ - * - * @ @ - * - * - * @ - * @ - @ @ - - * x - * x@ @ - * @ @ - @ @ - A @ @ -
A @ @ - - - h@ @ - @ @ 4 - @ @ * @ @ * @ @ . * @ @ 3 * @ @ * * @ @ @ . * ! @ . * x . - * @ @ . * @ @ . * . * @ . * @ . * . - @ @ . @ / * ! @ / * @ @ / * x / - * @ @ / * @ @ / * / * @ / * @ / * / | | cVT}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 0 - 2 ] * }A } 1
0 . 0 0 - 2 ] * }A } 2
0 . 0 0 - 2 ] * }A } 4
0 . 0 0 - 2 ] * }A } 5
0 . 0 0 - 2 ] * } } 7
0 . 0 0 - 2 ] * ???. 0 0 _ ??? - 2 ] ???? _ -
??? }- } G
0 . 0 0 }A } K
a 0 . 0 0 - 2 ] * }A } L
a 0 . 0 0 - 2 ] * }A } R
0 . 0 0 - 2 ] * }A } S
0 . 0 0 ? - 2 ] * }A } T
0 . 0 0 23 - 2 ] * }- } U
0 . 0 0 } } W
??v 0 . 0 0 ̙- 2 ] * . 0 0 _ - 2 ] ? _ -
}A } X
} 0 . 0 0 - 2 ] * }A } Y
e 0 . 0 0 - 2 ] * }A } Z
e 0 . 0 0 - 2 ] * }- } d
0 . 0 0 }- } e
0 . 0 0 }- } f
0 . 0 0 }- } g
0 . 0 0 }- } h
0 . 0 0 }x } i 0 . 0 0 - 2 . 0 -
? _} } l
??? 0 . 0 0 - 2 ???. 0 ??? -
???? _ -
??? }( } u
0 . 0 0}- } w
0 . 0 0 }- } y
0 . 0 0 }U } z
0 . 0 0 - 2 . 0 }- } {
0 . 0 0 } } | } } } } } ~ } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } } }- } 4 0 0 }- } 4 0 0 }- } L 0 0 }- } L 0 0 }- } L 0 0 }- } L 0 0 }- } L 0 0 }- } L 0 0 }- } L 0 0 }- } L 0 0 } } } } } } }- } L 0 0 }- } L 0 0 }- } L 0 0 }- } L 0 0 }- } L 0 0 }- } L 0 0 }- } L 0 0 }- } L 0 0 }- } L 0 0 }- } ef 0 0 }- } ef 0 0 }- } ef 0 0 }- } ef 0 0 }- } ef 0 0 }- } ef 0 0 }- } ef 0 0 }- } ef 0 0 }- } ef 0 0 }- } ef 0 0 }- } 0 0 }- } 0 0 }- } 0 0 }- } 0 0 }- } 0 0 }- } 0 0 }- } 0 0 }- } 0 0 }- } 0 0 }- } 23 0 0 }- } 23 0 0 }- } 23 0 0 }- } 23 0 0 }- } 23 0 0 }- } 23 0 0 }- } 23 0 0 }- } 23 0 0 }- } L 0 0 }- } L 0 0 }- } L 0 0 }- } L 0 0 }- } L 0 0 }- } L 0 0 }- } L 0 0 }- } L 0 0 }- } L 0 0 } } }- } ef 0 0 }- } ef 0 0 } } } } }- } L 0 0 } } } } } } }- } L 0 0 }- } L 0 0 }- } L 0 0 }- } 23 0 0 }- } 0 0 }- } ef 0 0 }- } ef 0 0 }- } L 0 0 }- } 4 0 0 }- } ef 0 0 } } } } } } } } } } } } }- } L 0 0 }- } L 0 0 }- } L 0 0 } } } } } } }- } L 0 0 }- } L 0 0 }- } L 0 0 }- } 23 0 0 }- } 0 0 }- } ef 0 0 } } } } }- } L 0 0 } } }- } L 0 0 }- } ef 0 0 }- } L 0 0 } } } } }- } 23 0 0 }- } 0 0 }- } ef 0 0 }- } L 0 0 }- } L 0 0 } } } } }- } L 0 0 }- }
L 0 0 }- } L 0 0 } } } }
} } }- } L 0 0 }- } L 0 0 }- } L 0 0 }- } 23 0 0 }- } 0 0 }- } ef 0 0 } } } } }- } L 0 0 } } } } } } }- } L 0 0 }- } 23 0 0 }- } 0 0 }- } 23 0 0 }- } 23 0 0 }- } 23 0 0 }- } ! 23 0 0 }- } " 23 0 0 }- } # 23 0 0 }- } $ 23 0 0 }- } % 23 0 0 }- } & 23 0 0 }- } ' 23 0 0 }- } ( ef 0 0 }- } ) ef 0 0 }- } * ef 0 0 }- } + ef 0 0 }- } , ef 0 0 }- } - ef 0 0 }- } . ef 0 0 }- } / ef 0 0 }- } 0 ef 0 0 }- } 1 ef 0 0 }- } 2 23 0 0 }- } 3 ef 0 0 }- } 4 ef 0 0 }- } 5 ef 0 0 }- } 6 ef 0 0 }- } 7 ef 0 0 }- } 8 ef 0 0 }- } 9 ef 0 0 }- } : ef 0 0 }- } ; ef 0 0 }- } < ef 0 0 } } = }- } > ef 0 0 }- } ? ef 0 0 }- } @ ef 0 0 }- } A ef 0 0 }- } B ef 0 0 }- } C ef 0 0 } } D } } E } } F }( } G f 0 0}- } H 23 0 0 }- } I L 0 0 }( } J ef L 0 0}( } K ef L 0 0}( } L L L 0 0}( } M ef L 0 0}( } N 23 L 0 0}( } O ef L 0 0}( } P ef L 0 0}( } Q ef L 0 0}- } R ef 0 0 }( } S ef f 0 0}( } T ef f 0 0}( } U ef f 0 0}( } V ef f 0 0}( } W ef f 0 0}- } X ef 0 0 }( } Y ef f 0 0}( } Z 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}( } a ef f 0 0}( } b ef f 0 0
bidires=100
_ACMGCF_template- ( _MSCI_GICS_GVGIS_HEDGED_Template_Statpro) $ _Performance Summary Template_HBEPEM# _Reconciliation_template_PCPIP# _Reconciliation_template_PIACT$ _Reconciliation_Template_PICINT$ _Reconciliation_Template_PIEMSB$ _Reconciliation_template_PIMSLC$ _Reconciliation_template_PIRAEO$ _Reconciliation_template_PIVICS
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 % 0 Accent4A ) A c c e n t 4 d % 1 Accent5A - A c c e n t 5 K % 2 Accent6A 1 A c c e n t 6 F % 3
Assumption 4 Bad9 B a d %
5 Bad 2= B a d 2 % 6 Calculation, C a l c u l a t i o n 7
Check Cell
C h e c k C e l l % ??? ??? ??? ??? 8 C o m m a 9( C o m m a [ 0 ] : Comma 2 ; Comma 2 2 < Comma 2 2 2 =
Comma 2 2 2 2 > Comma 2 2 3 ? Comma 2 2 4 @ Comma 2 3 A Comma 3 B Comma 4 C& C u r r e n c y D. C u r r e n c y [ 0 ] E
Currency 2 F Euro G Explanatory TextG 5 E x p l a n a t o r y T e x t % H : F o l l o w e d H y p e r l i n k I Formulae - Changed J Formulae - Linked K Good; G o o d a % L Good 2? G o o d 2 a % M Header - Cover N
Header - Page O Header - Subtitle P Header - Title Q Header - Year Row R Heading 1G H e a d i n g 1 I}% O S Heading 2G H e a d i n g 2 I}% ? T Heading 3G H e a d i n g 3 I}% 23 U Heading 49 H e a d i n g 4 I}% V( H y p e r l i n k
W Inputu I n p u t ̙ ??v% X Linked CellK L i n k e d C e l l } % Y NeutralA N e u t r a l e % Z Neutral 2E N e u t r a l 2 e % " N o r m a l
[ Normal 2 \
Normal 2 2, ] ' Normal 2_Reconciliation_Template_PIEMSB
^ Normal 3 _
Normal 3 2 `
Normal 3 3" a Normal 3_UP vs Gross Internal
b Normal 4 c
Normal 4 2
d Normal 57 N o r m a l 5 %
e Normal 67 N o r m a l 6 %
f Normal 77 N o r m a l 7 %
g Normal 87 N o r m a l 8 %
h Normal 97 N o r m a l 9 % i Noteb
N o t e j Note 2
k Notes l Outputw O u t p u t ???% ??? ??? ??? ??? m$ P e r c e n t n Percent 2 o Percent 2 2 p
Percent 2 2 2 q
Percent 2 2 3 r
Percent 2 2 4 s
Percent 2 2 5 t Percent 3 u Percent 3 2 v Percent 3 3 w Percent 4 x Style 1
y Title1 T i t l e I}%
z TotalM T o t a l % O O { 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` %%TOBA_CACHE%%
Quarter--> Dist IMD02P004 = U R:Portfolio ManagementReporting_Templates & Month End FilesRISAST Reporting.xls RISAST - Portfolio RISAST - Hedging RISAST - Performance RISAST - Transactions
RISAST - FeesY Y Y Y Y " i R:Portfolio ManagementCompany DataResearch_TemplatesCopy of Standard Company Model (draft 5.1).xls Outputs -->
Financials Valuation Stock Report Assumptions --> Diary
Core Items Div1 Financial Inputs Assoc Versions & Links --> Current Co Dbase WindowY Z ( ConDPS Dividend per share (c)Z Z !
RAREEBITDA RARE EBITDAZ Z RAREEBIT RARE EBITZ Z 2
RARENetResult RARE Net Result After TaxZ Z 5 ConNetResult Reported Net Result After TaxZ Y Z [sedol]Z
F@Z
Y Z . , HoldcoNonOpInc Non operating incomeZ 0 9 HoldcoNonOpExp Non operating expensesZ 3 _ HoldcoOEIProfit Outside equity interestsZ 3
HoldcoPension Unfunded pension liabilityZ 0 HoldcoOEIBal Outside equity interestsZ 3
HoldcoOthOpCF Other operating cash flowsZ 4 HoldcoOthInvCF Other investing cash flowsZ 0 HoldcoOEICap Outside equity interestsZ 1 HoldcoOEIDiv OEI distribution/dividendZ 4 HoldcoOthFinCF Other financing cash flows n " AssocFCF; ! AssocFY; & & $
AssocInvmt; n n ( AssocNetResult; A A ! AssocPE; % % " AssocTax; I I AUD; 3 3 ! BBSsens; [ [ Bondsens: \ " Cashsens; Z Z Code: & Company: % ConDPS; ! ConEBIT; a a # ConEBITDA; _ _ ConNA; $
ConNetDebt; Q Q & ConNetResult; " ConTotEq; " ConYield; [ [ CorpTax: u ! CPIsens; ^ ^ Currency: ! CurrentDate: CurrSub:
CurrSubVal: CurrUnit:
Div1: 0 % Div1AdjEBIT;
# Div1Amort; < < $
Div1Asset1; $
Div1Asset2; $
Div1Asset3; " Div1Bond; & Div1BondPrem; ( Div1BSCapTrans; " Div1Cash; f f ( Div1CFCapTrans; ! Div1Dep; ; ; % Div1DistPay; ! Div1Div; $
Div1DivInv; ! Div1DTL; $
Div1EBITDA; : : % Div1EBITTax; ( Div1ElimIntExp; 33 ( Div1ElimIntInc; 44 ) Div1ElimIntLiab; :: '
Div1ElimNCRec; 77 ) Div1ElimOpCosts; 22 '
Div1ElimOpRev; // ( Div1ElimOthInc; 00 % Div1ElimPay; 88 & Div1ElimProv; 99 * Div1ElimTradeRec; 66 % Div1Equity1; % Div1Equity2; ! Div1FCF; JJ Div1Fin: 0 " Div1FITB; w w Div1FY; & & ) Div1GrowthCapex; $
Div1Intang; | | $
Div1IntExp; > > $
Div1IntInc; G G % Div1IntLiab; % Div1IntPaid; $
Div1Invent; m m & Div1IssueCap; # Div1Liab1; # Div1Liab2; ( Div1MaintCapex; Div1NA; $
Div1NCmove; '
Div1NetBorrow; '
Div1NetResult; \ \ ! Div1NRI; Z Z $
Div1NRITax; [ [ $
Div1OEIBal; ( Div1OEIContrib; % Div1OpCosts; 0 0 # Div1OpRev; ) ) # Div1OthCA; r r # Div1OthCL; $
Div1OthInc; . . ! Div1Own; -- ! Div1Pay; Div1PE; % % ! Div1PPE; x x " Div1Prov; # Div1Purch; ! Div1Rec; g g % Div1Reserve; & Div1Retained; " Div1Sale; ! Div1Tax; N N % Div1TaxPaid; # Div1TotEq; Div1WC; Div2: 2 % Div2AdjEBIT;
# Div2Amort; < < $
Div2Asset1; $
Div2Asset2; $
Div2Asset3; " Div2Bond; & Div2BondPrem; ( Div2BSCapTrans; " Div2Cash; f f ( Div2CFCapTrans; ! Div2Dep; ; ; % Div2DistPay; ! Div2Div; $
Div2DivInv; ! Div2DTL; $
Div2EBITDA; : : % Div2EBITTax; ( Div2ElimIntExp; 33 ( Div2ElimIntInc; 44 ) Div2ElimIntLiab; :: '
Div2ElimNCRec; 77 ) Div2ElimOpCosts; 22 '
Div2ElimOpRev; // ( Div2ElimOthInc; 00 % Div2ElimPay; 88 & Div2ElimProv; 99 * Div2ElimTradeRec; 66 % Div2Equity1; % Div2Equity2; ! Div2FCF; JJ Div2Fin: 2 " Div2FITB; w w Div2FY; & & ) Div2GrowthCapex; $
Div2Intang; | | $
Div2IntExp; > > $
Div2IntInc; G G % Div2IntLiab; % Div2IntPaid; $
Div2Invent; m m & Div2IssueCap; # Div2Liab1; # Div2Liab2; ( Div2MaintCapex; Div2NA; $
Div2NCmove; '
Div2NetBorrow; '
Div2NetResult; \ \ ! Div2NRI; Z Z $
Div2NRITax; [ [ $
Div2OEIBal; ( Div2OEIContrib; % Div2OpCosts; 0 0 # Div2OpRev; ) ) # Div2OthCA; r r # Div2OthCL; $
Div2OthInc; . . ! Div2Own; -- ! Div2Pay; Div2PE; % % ! Div2PPE; x x " Div2Prov; # Div2Purch; ! Div2Rec; g g % Div2Reserve; & Div2Retained; " Div2Sale; ! Div2Tax; N N % Div2TaxPaid; # Div2TotEq; Div2WC; Div3: 4 % Div3AdjEBIT;
# Div3Amort; < < $
Div3Asset1; $
Div3Asset2; $
Div3Asset3; " Div3Bond; & Div3BondPrem; ( Div3BSCapTrans; " Div3Cash; f f ( Div3CFCapTrans; ! Div3Dep; ; ; % Div3DistPay; ! Div3Div; $
Div3DivInv; ! Div3DTL; $
Div3EBITDA; : : % Div3EBITTax; ( Div3ElimIntExp; 33 ( Div3ElimIntInc; 44 ) Div3ElimIntLiab; :: '
Div3ElimNCRec; 77 ) Div3ElimOpCosts; 22 '
Div3ElimOpRev; // ( Div3ElimOthInc; 00 % Div3ElimPay; 88 & Div3ElimProv; 99 * Div3ElimTradeRec; 66 % Div3Equity1; % Div3Equity2; ! Div3FCF; JJ Div3Fin: 4 " Div3FITB; w w Div3FY; & & ) Div3GrowthCapex; $
Div3Intang; | | $
Div3IntExp; > > $
Div3IntInc; G G % Div3IntLiab; % Div3IntPaid; $
Div3Invent; m m & Div3IssueCap; # Div3Liab1; # Div3Liab2; ( Div3MaintCapex; Div3NA; $
Div3NCmove; '
Div3NetBorrow; '
Div3NetResult; \ \ ! Div3NRI; Z Z $
Div3NRITax; [ [ $
Div3OEIBal; ( Div3OEIContrib; % Div3OpCosts; 0 0 # Div3OpRev; ) ) # Div3OthCA; r r # Div3OthCL; $
Div3OthInc; . . ! Div3Own; -- ! Div3Pay; Div3PE; % % ! Div3PPE; x x " Div3Prov; # Div3Purch; ! Div3Rec; g g % Div3Reserve; & Div3Retained; " Div3Sale; ! Div3Tax; N N % Div3TaxPaid; # Div3TotEq; Div3WC; Div4: 6 % Div4AdjEBIT;
# Div4Amort; < < $
Div4Asset1; $
Div4Asset2; $
Div4Asset3; " Div4Bond; & Div4BondPrem; ( Div4BSCapTrans; " Div4Cash; f f ( Div4CFCapTrans; ! Div4Dep; ; ; % Div4DistPay; ! Div4Div; $
Div4DivInv; ! Div4DTL; $
Div4EBITDA; : : % Div4EBITTax; ( Div4ElimIntExp; 33 ( Div4ElimIntInc; 44 ) Div4ElimIntLiab; :: '
Div4ElimNCRec; 77 ) Div4ElimOpCosts; 22 '
Div4ElimOpRev; // ( Div4ElimOthInc; 00 % Div4ElimPay; 88 & Div4ElimProv; 99 * Div4ElimTradeRec; 66 % Div4Equity1; % Div4Equity2; ! Div4FCF; JJ Div4Fin: 6 " Div4FITB; w w Div4FY; & & ) Div4GrowthCapex; $
Div4Intang; | | $
Div4IntExp; > > $
Div4IntInc; G G % Div4IntLiab; % Div4IntPaid; $
Div4Invent; m m & Div4IssueCap; # Div4Liab1; # Div4Liab2; ( Div4MaintCapex; Div4NA; $
Div4NCmove; '
Div4NetBorrow; '
Div4NetResult; \ \ ! Div4NRI; Z Z $
Div4NRITax; [ [ $
Div4OEIBal; ( Div4OEIContrib; % Div4OpCosts; 0 0 # Div4OpRev; ) ) # Div4OthCA; r r # Div4OthCL; $
Div4OthInc; . . ! Div4Own; -- ! Div4Pay; Div4PE; % % ! Div4PPE; x x " Div4Prov; # Div4Purch; ! Div4Rec; g g % Div4Reserve; & Div4Retained; " Div4Sale; ! Div4Tax; N N % Div4TaxPaid; # Div4TotEq; Div4WC; Div5: 8 % Div5AdjEBIT;
# Div5Amort; < < $
Div5Asset1; $
Div5Asset2; $
Div5Asset3; " Div5Bond; & Div5BondPrem; ( Div5BSCapTrans; " Div5Cash; f f ( Div5CFCapTrans; ! Div5Dep; ; ; % Div5DistPay; ! Div5Div; $
Div5DivInv; ! Div5DTL; $
Div5EBITDA; : : % Div5EBITTax; ( Div5ElimIntExp; 33 ( Div5ElimIntInc; 44 ) Div5ElimIntLiab; :: '
Div5E limNCRec; 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 x . - @ r j 0 & / 3 A @ @
l 1 6 S7R8C28||10.3500006 S7R9C28||55.0300007 S7R10C28||10.9500006 S7R11C28||7.1300006 S7R12C28||1.1400006 S7R13C28||5.2300006 S7R14C28||2.1500006 S7R15C28||6.8700007 S7R16C28||15.9000007 S7R18C28||20.0500006 S7R19C28||6.0300007 S7R20C28||47.5000007 S7R21C28||29.1500007 S7R22C28||22.1500007 S7R23C28||42.0000007 S7R24C28||35.6300007 S7R25C28||26.5700006 S7R26C28||2.1000008 S7R27C28||113.0000007 S7R28C28||65.2000007 S7R29C28||88.9200006 S7R30C28||3.5300007 S7R31C28||38.8800007 S7R32C28||23.3500007 S7R33C28||32.9100007 S7R34C28||16.4900007 S7R35C28||40.2500008 S7R36C28||640.9998007 S7R37C28||34.6300007 S7R38C28||45.2000007 S7R39C28||76.0300007 S7R40C28||20.3300005 S3R7C24||0.6139205 S3R7C25||7.1947705 S3R7C26||3.782031; S3R7C40||4333148.8000005 S3R8C24||4.0425507 S3R8C25||6 S3R8C26||47.6352389 S3R8C40||71194.4761905 S3R9C24||3.0701805 S3R9C25||2.1739105 S3R9C26||1.106071; S3R9C40||2375091.5714297 S3R10C24||-2.1067407 S3R10C25||-0.4285706 S3R10C26||6.914466< S3R10C40||1833736.4761906 S3R11C24||1.7307707 S3R11C25||-2.9357807 S3R11C26||12.7387209 S3R11C40||9424.7000006 S3R12C24||3.0114207 S3R12C25||16.9811407 S3R12C26||87.756211: S3R12C40||44498.3809526 S3R13C24||2.6528306 S3R13C25||4.4600906 S3R13C26||2.131619< S3R13C40||6770748.8500006 S3R14C24||7.5098807 S3R14C25||-6.2069006 S3R14C26||2.642869< S3R14C40||1055304.1904766 S3R15C24||2.7165906 S3R15C25||3.9375906 S3R15C26||6.8415749 S3R15C40||6 S3R16C24||1.0145807 S3R16C25||-5.9622207 S3R16C26||16.3719639 S3R16C40||7 S3R17C24||-2.6548707 S3R17C25||-3.5087706 S3R17C26||1.0889209 S3R17C40||6 S3R18C24||8.2500007 S3R18C25||-6.3986207 S3R18C26||20.1924229 S3R18C40||7 S3R19C24||-3.8720508 S3R19C25||-29.5061706 S3R19C26||7.1989699 S3R19C40||9 S3R20C24||9 S3R20C25||7 S3R20C26||47.4671439 S3R20C40||7 S3R21C24||-0.2753906 S3R21C25||9.6517807 S3R21C26||28.149206= S3R21C40||12039191.9055006 S3R22C24||3.5156307 S3R22C25||-2.5735306 S3R22C26||2.640956# S3R22C40||#NA7 S3R23C24||-3.1805407 S3R23C25||-3.4514907 S3R23C26||12.860440# S3R23C40||#NA6 S3R24C24||3.6007206 S3R24C25||8.8389507 S3R24C26||51.346211# S3R24C40||#NA6 S3R25C24||9.2557306 S3R25C25||9.7794807 S3R25C26||11.816693= S3R25C40||14022873.2466507 S3R26C24||-1.1331406 S3R26C25||2.0467806 S3R26C26||6.925099# S3R26C40||#NA6 S3R27C24||0.8771906 S3R27C25||0.4366806 S3R27C26||1.091528# S3R27C40||#NA7 S3R28C24||-3.7878807 S3R28C25||-4.8689106 S3R28C26||5.594080# S3R28C40||#NA7 S3R29C24||-1.8779307 S3R29C25||-7.1111106 S3R29C26||2.270400# S3R29C40||#NA6 S3R30C24||0.4325906 S3R30C25||0.0718406 S3R30C26||6.843210# S3R30C40||#NA6 S3R31C24||0.5047307 S3R31C25||-2.5688107 S3R31C26||16.358158# S3R31C40||#NA6 S3R32C24||1.8518507 S3R32C25||-2.6548706 S3R32C26||1.089200# S3R32C40||#NA6 S3R33C24||9.9086106 S3R33C25||5.2995507 S3R33C26||20.235508# S3R33C40||#NA7 S3R34C24||-3.5234908 S3R34C25||-29.7924306 S3R34C26||7.160538# S3R34C40||#NA7 S3R35C24||-2.049180# S3R35C25||#NA< 7 S3R35C26||47.475192# S3R35C40||#NA7 S3R36C24||-5.0167206 S3R36C25||4.0293007 S3R36C26||28.144563= S3R36C40||12039191.9055007 S3R37C24||-0.4955006 S3R37C25||4.9904907 S3R37C26||21.399643= S3R37C40||36910048.9112106 S3R38C24||2.4651207 S3R38C25||12.0834407 S3R38C26||41.931667> S3R38C40||353415736.134600# S3R39C25||#NA7 S3R39C26||37.050803# S3R39C40||#NA6 S3R40C24||3.0476806 S3R40C25||4.0173707 S3R40C26||27.005447# S3R40C40||#NA6 S3R41C24||1.9585306 S3R41C25||4.8578206 S3R41C26||2.127820# S3R41C40||#NA6 S3R42C24||7.8516007 S3R42C25||10.6194708 S3R42C26||103.802183# S3R42C40||#NA6 S3R43C24||3.7268906 S3R43C25||5.9794807 S3R43C26||63.629219# S3R43C40||#NA6 S3R44C24||9.6616006 S3R44C25||3.5664707 S3R44C26||40.038985# S3R44C40||#NA7 S3R45C24||-1.0309306 S3R45C25||3.4482807 S3R45C26||24.246371# S3R45C40||#NA6 S3R46C24||0.6626306 S3R46C25||7.1450507 S3R46C26||34.544048> S3R46C40||154185546.7870606 S3R47C24||1.8007206 S3R47C25||4.2409307 S3R47C26||16.1284066 S7R17C28||1.120000# S3R39C24||#NA6 S5R7C4||C0000882716 S5R7C5||C000088271$ S5R8C4||#Value$ S5R9C4||#Value% S5R10C4||#Value7 S5R10C5||C000087600% S5R13C4||#Value% S5R14C4||#Value% S5R15C4||#Value6 S5R15C5||% S5R16C4||#Value6 S5R16C5||% S5R17C4||#Value6 S5R17C5||% S5R18C4||#Value6 S5R18C5||% S5R19C4||#Value6 S5R19C5||% S5R20C4||#Value% S5R21C4||#Value% S5R22C4||#Value% S5R23C4||#Value% S5R24C4||#Value% S5R25C4||#Value6 S5R8C5||C9000155526 S5R9C5||C901699416% S5R26C4||#Value% S5R27C4||#Value% S5R27C5||#Value% S5R28C4||#Value% S5R28C5||#Value% S5R29C4||#Value% S5R29C5||#Value% S5R30C4||#Value% S5R30C5||#Value% S5R31C4||#Value% S5R31C5||#Value% S5R32C4||#Value% S5R32C5||#Value% S5R33C4||#Value% S5R33C5||#Value% S5R34C4||#Value% S5R34C5||#Value% S5R35C4||#Value% S5R35C5||#Value% S5R36C4||#Value% S5R36C5||#Value% S5R37C4||#Value% S5R37C5||#Value% S5R38C4||#Value% S5R38C5||#Value% S5R39C4||#Value% S5R39C5||#Value% S5R40C4||#Value% S5R40C5||#Value% S5R41C4||#Value% S5R41C5||#Value% S5R42C4||#Value% S5R42C5||#Value% S5R43C4||#Value% S5R43C5||#Value% S5R44C4||#Value% S5R44C5||#Value% S5R45C4||#Value% S5R45C5||#Value% S5R46C4||#Value% S5R46C5||#Value% S5R47C4||#Value% S5R47C5||#Value% S5R48C4||#Value% S5R48C5||#Value% S5R49C4||#Value% S5R49C5||#Value% S5R50C4||#Value% S5R50C5||#Value% S5R51C4||#Value% S5R51C5||#Value% S5R52C4||#Value% S5R52C5||#Value% S5R53C4||#Value% S5R53C5||#Value% S5R54C4||#Value% S5R54C5||#Value% S5R55C4||#Value% S5R55C5||#Value% S5R56C4||#Value% S5R56C5||#Value% S5R57C4||#Value% S5R57C5||#Value% S5R58C4||#Value% S5R58C5||#Value% S5R59C4||#Value% S5R59C5||#Value% S5R60C4||#Value% S5R60C5||#Value% S5R61C4||#Value% S5R61C5||#Value% S5R62C4||#Value% S5R62C5||#Value% S5R63C4||#Value% S5R63C5||#Value% S5R64C4||#Value% S5R64C5||#Value% S5R65C4||#Value% S5R65C5||#Value% S5R66C4||#Value% S5R66C5||#Value% S5R67C4||#Value% S5R67C5||#Value% S5R68C4||#Value% S5R68C5||#Value% S5R69C4||#Value% S5R69C5||#Value% S5R70C4||#Value% S5R70C5||#Value% S5R71C4||#Value% S5R71C5||#Value% S5R72C4||#Value% S5R72C5||#Value% S5R73C4||#Value% S5R73C5||#Value% S5R74C4||#Value% S5R74C5||#Value% S5R75C4||#Value% S5R75C5||#Value% S5R76C4||#Value% S5R76C5||#Value% S5R77C4||#Value% S5R77C5||#Value% S5R78C4||#Value% S5R78C5||#Value% S5R79C4||#Value% S5R79C5||#Value% S5R80C4||#Valu< e% S5R80C5||#Value% S5R81C4||#Value% S5R81C5||#Value% S5R82C4||#Value% S5R82C5||#Value% S5R83C4||#Value% S5R83C5||#Value% S5R84C4||#Value% S5R84C5||#Value% S5R85C4||#Value% S5R85C5||#Value% S5R86C4||#Value% S5R86C5||#Value% S5R87C4||#Value% S5R87C5||#Value% S5R88C4||#Value% S5R88C5||#Value% S5R89C4||#Value% S5R89C5||#Value% S5R90C4||#Value% S5R90C5||#Value% S5R91C4||#Value% S5R91C5||#Value% S5R92C4||#Value% S5R92C5||#Value% S5R93C4||#Value% S5R93C5||#Value% S5R94C4||#Value% S5R94C5||#Value% S5R95C4||#Value% S5R95C5||#Value% S5R96C4||#Value% S5R96C5||#Value% S5R97C4||#Value% S5R97C5||#Value% S5R98C4||#Value% S5R98C5||#Value% S5R99C4||#Value% S5R99C5||#Value& S5R100C4||#Value& S5R100C5||#Value& S5R101C4||#Value& S5R101C5||#Value& S5R102C4||#Value& S5R102C5||#Value& S5R103C4||#Value& S5R103C5||#Value& S5R104C4||#Value& S5R104C5||#Value& S5R105C4||#Value& S5R105C5||#Value& S5R106C4||#Value& S5R106C5||#Value& S5R107C4||#Value& S5R107C5||#Value& S5R108C4||#Value& S5R108C5||#Value& S5R109C4||#Value& S5R109C5||#Value& S5R110C4||#Value& S5R110C5||#Value& S5R111C4||#Value& S5R111C5||#Value& S5R112C4||#Value& S5R112C5||#Value& S5R113C4||#Value& S5R113C5||#Value& S5R114C4||#Value& S5R114C5||#Value& S5R115C4||#Value& S5R115C5||#Value& S5R116C4||#Value& S5R116C5||#Value& S5R117C4||#Value& S5R117C5||#Value& S5R118C4||#Value& S5R118C5||#Value& S5R119C4||#Value& S5R119C5||#Value& S5R120C4||#Value& S5R120C5||#Value& S5R121C4||#Value& S5R121C5||#Value& S5R122C4||#Value& S5R122C5||#Value% S5R11C4||#Value7 S5R11C5||C0000534447 S5R12C4||C0000083617 S5R12C5||C0000083617 S5R13C5||C9016694767 S5R14C5||C902341248% S5R23C5||#Value% S5R24C5||#Value^ S7R7C13||1043.8922231353.9282535 S7R7C23||2.760000^ S7R8C13||9469.7350287357.9914756 S7R8C23||10.750000^ S7R9C13||7140.6517725598.2718856 S7R9C23||60.890000] S7R10C13||713.367176788.2684437 S7R10C23||11.210000^ S7R11C13||4500.731015837.4482956 S7R11C23||6.950000_ S7R12C13||1057.4498981371.5125596 S7R12C23||1.175000_ S7R13C13||1102.6374018758.0413146 S7R13C23||5.050000_ S7R14C13||1420.4450452232.9477396 S7R14C23||2.200000a S7R15C13||54984.15022743107.5806756 S7R15C23||6.990000_ S7R16C13||1865.4444971462.5087197 S7R16C23||16.600000^ S7R17C13||1027.7598471615.644366 S7R17C23||1.100000] S7R18C13||1599.7030161247.76967 S7R18C23||22.500000Z S7R19C13||738.9171725869.086 S7R19C23||5.9200007 S7R20C23||48.360000] S7R21C13||842.781653842.7816537 S7R21C23||28.800000_ S7R22C13||2611.9397642611.9397647 S7R22C23||22.220000_ S7R23C13||17956.2195417956.219547 S7R23C23||43.870000X S7R24C13||1085.46447118417 S7R24C23||38.980000` S7R25C13||36543.8108528650.3522917 S7R25C23||29.000000W S7R26C13||5746.1725545056 S7R26C23||2.207500_ S7R27C13||5479.3457296783.4673228 S7R27C23||129.300000` S7R28C13||51197.49799540138.844857 S7R28C23||70.230000a S7R29C13||83882.32341365763.7520787 S7R29C23||97.900000_ S7R30C13||9188.8172217204.0338546 S7R30C23||3.640000b S7R31C13||101916.05805179902.2022977 S7R31C23||42.640000` S7R32C13||7188.18860555904.4066367 S7R32C23||23.850000a S7R33C13||15791.05309617449.0630697 S7R33C23||35.380000_ S7R34C13||1897.7531532098.9129737 S7R34C23||17.150000a S7R35C13||22843.98375517909.6861297 S7R35C23||43.010000` S7R36C13||11423.1166446019.9926458 S7R36C23||678.999800a S7R37C13||11603.30605312821.6160067 S7R37C23||36.450000b S7R38C13||15374.234601119569.4089357 S7R38C23||49.650000a S7R39C13||16156.03481216156.0348127 S7R39C23||76.930000a S7R40C13||23273.59458918246.5010777 S7R40C23||19.980000& S5R123C4||#Value& S5R123C5||#Value& S5R124C4||#Value& S5R124C5||#Value& S5R125C4||#Value& S5R125C5||#Value& S5R126C4||#Value& S5R126C5||#Value& S5R127C4||#Value& S5R127C5||#Value& S5R128C4||#Value& S5R128C5||#Value& S5R129C4||#Value& S5R129C5||#Value& S5R130C4||#Value& S5R130C5||#Value& S5R131C4||#Value& S5R131C5||#Value6 S6R7C4||C0000017046 S6R7C5||C0000017046 S6R8C4||C0000010316 S6R8C5||C0000010316 S6R9C4||C0000055186 S6R9C5||C0000055187 S6R10C4||C0000141577 S6R10C5||C0000141577 S6R11C4||C0000882357 S6R11C5||C000088235% S6R12C4||#Value7 S6R12C5||C000075896% S6R13C4||#Value7 S6R13C5||C901842957% S6R14C4||#Value7 S6R14C5||C9018861387 S6R15C4||C0000015137 S6R15C5||C0000015137 S6R16C4||C0000741817 S6R16C5||C0000741817 S6R17C4||C0000083507 S6R17C5||C0000083507 S6R18C4||C0000083517 S6R18C5||C000008351% S6R19C4||#Value7 S6R19C5||C9014289847 S6R20C4||C9014616577 S6R20C5||C9014616577 S6R21C4||C0000705157 S6R21C5||C0000705157 S6R22C4||C0000086607 S6R22C5||C0000086607 S6R23C4||C0000711777 S6R23C5||C0000711777 S6R24C4||C0000065767 S6R24C5||C000006576% S6R25C4||#Value7 S6R25C5||C9000155527 S6R26C4||C0000046247 S6R26C5||C0000046247 S6R27C4||C0000891397 S6R27C5||C0000891397 S6R28C4||C0000737147 S6R28C5||C0000737147 S6R29C4||C0000471187 S6R29C5||C0000471187 S6R30C4||C0000534447 S6R30C5||C000053444% S6R31C4||#Value7 S6R31C5||C9008694347 S6R32C4||C0000157297 S6R32C5||C000015729% S6R33C4||#Value7 S6R33C5||C000015507% S6R34C4||#Value7 S6R34C5||C0000156097 S6R35C4||C0000769027 S6R35C5||C0000769027 S6R36C4||C0000879707 S6R36C5||C000087970% S6R37C4||#Value7 S6R37C5||C000012895% S6R38C4||#Value7 S6R38C5||C000017224% S6R39C4||#Value7 S6R39C5||C0000170337 S6R40C4||C0000000487 S6R40C5||C0000000487 S6R41C4||C0000035947 S6R41C5||C000003594= S3R47C40||16440842.5522206 S3R48C24||0.0938707 S3R48C25||-4.5647807 S3R48C26||40.252840# S3R48C40||#NA6 S3R49C24||1.3564406 S3R49C25||0.3731308 S3R49C26||662.157912# S3R49C40||#NA7 S3R50C24||-0.5237007 S3R50C25||10.0976207 S3R50C26||35.171786= S3R50C40||99319797.1783506 S3R51C24||4.1125506 S3R51C25||7.2463807 S3R51C26||45.195161# S3R51C40||#NA7 S3R52C24||-0.6829007 S3R52C25||10.8108107 S3R52C26||71.431230> S3R52C40||388290451.5300606 S3R53C24||0.7988807 S3R53C25||10.681110 Product Name Accrual Period: Start Date Accrual Period: End Date Ex-distribution: Date Ex-distribution: Exit Price Re-investment: Date Re-investment: Price7 S3R53C26||18.301660# S3R53C40||#NA% S5R20C5||#Value% S5R21C5||#Value% S5R22C5||#Value% S6R42C4||#Value7 S6R42C5||C0000156017 S6R43C4||C0000087357 S6R43C5||C0000087357 S6R44C4||C0000137607 S6R44C5||C0000137607 S6R45C4||C0000743247 S6R45C5||C0000743247 S6R46C4||C0000882457 S6R46C5||C0000882457 S6R47C4||C0000486197 S6R47C5||C0000486197 S6R48C4||C0000881107 S6R48C5||C0000881107 S6R49C4||C0000853027 S6R49C5||C0000853027 S6R50C4||C0000016437 S6R50C5||C0000016437 S6R51C4||C000005436< 7 S6R51C5||C0000054367 S6R52C4||C0000082207 S6R52C5||C0000082207 S6R53C4||C0000876607 S6R53C5||C0000876607 S6R54C4||C0000670717 S6R54C5||C0000670717 S6R55C4||C0000825997 S6R55C5||C000082599% S6R56C4||#Value7 S6R56C5||C000014686% S6R57C4||#Value7 S6R57C5||C000007346% S6R58C4||#Value6 S6R58C5||% S6R59C4||#Value6 S6R59C5||% S6R60C4||#Value6 S6R60C5||% S6R61C4||#Value6 S6R61C5||% S6R62C4||#Value6 S6R62C5||% S6R63C4||#Value6 S6R63C5||% S6R64C4||#Value6 S6R64C5||% S6R65C4||#Value6 S6R65C5||% S6R66C4||#Value6 S6R66C5||% S6R67C4||#Value6 S6R67C5||% S6R68C4||#Value6 S6R68C5||% S6R69C4||#Value6 S6R69C5||% S6R70C4||#Value6 S6R70C5||% S6R71C4||#Value6 S6R71C5||% S6R72C4||#Value6 S6R72C5||% S6R73C4||#Value6 S6R73C5||% S6R74C4||#Value% S6R74C5||#Value% S6R75C4||#Value% S6R75C5||#Value% S6R76C4||#Value% S6R76C5||#Value% S6R77C4||#Value% S6R77C5||#Value% S6R78C4||#Value% S6R78C5||#Value% S6R79C4||#Value% S6R79C5||#Value% S6R80C4||#Value% S6R80C5||#Value% S6R81C4||#Value% S6R81C5||#Value% S6R82C4||#Value% S6R82C5||#Value% S6R83C4||#Value% S6R83C5||#Value% S6R84C4||#Value% S6R84C5||#Value% S6R85C4||#Value% S6R85C5||#Value% S6R86C4||#Value% S6R86C5||#Value% S6R87C4||#Value% S6R87C5||#Value% S6R88C4||#Value% S6R88C5||#Value% S6R89C4||#Value% S6R89C5||#Value% S6R90C4||#Value% S6R90C5||#Value% S6R91C4||#Value% S6R91C5||#Value% S6R92C4||#Value% S6R92C5||#Value% S6R93C4||#Value% S6R93C5||#Value% S6R94C4||#Value% S6R94C5||#Value% S6R95C4||#Value% S6R95C5||#Value% S6R96C4||#Value% S6R96C5||#Value% S6R97C4||#Value% S6R97C5||#Value% S6R98C4||#Value% S6R98C5||#Value% S6R99C4||#Value% S6R99C5||#Value& S6R100C4||#Value& S6R100C5||#Value& S6R101C4||#Value& S6R101C5||#Value& S6R102C4||#Value& S6R102C5||#Value& S6R103C4||#Value& S6R103C5||#Value& S6R104C4||#Value& S6R104C5||#Value& S6R105C4||#Value& S6R105C5||#Value& S6R106C4||#Value& S6R106C5||#Value& S6R107C4||#Value& S6R107C5||#Value& S6R108C4||#Value& S6R108C5||#Value& S6R109C4||#Value& S6R109C5||#Value& S6R110C4||#Value& S6R110C5||#Value& S6R111C4||#Value& S6R111C5||#Value& S6R112C4||#Value& S6R112C5||#Value& S6R113C4||#Value& S6R113C5||#Value& S6R114C4||#Value& S6R114C5||#Value& S6R115C4||#Value& S6R115C5||#Value& S6R116C4||#Value& S6R116C5||#Value& S6R117C4||#Value& S6R117C5||#Value& S6R118C4||#Value& S6R118C5||#Value& S6R119C4||#Value& S6R119C5||#Value& S6R120C4||#Value& S6R120C5||#Value& S6R121C4||#Value& S6R121C5||#Value& S6R122C4||#Value& S6R122C5||#Value& S6R123C4||#Value& S6R123C5||#Value& S6R124C4||#Value& S6R124C5||#Value& S6R125C4||#Value& S6R125C5||#Value& S6R126C4||#Value& S6R126C5||#Value& S6R127C4||#Value& S6R127C5||#Value& S6R128C4||#Value& S6R128C5||#Value& S6R129C4||#Value& S6R129C5||#Value& S6R130C4||#Value& S6R130C5||#Value& S6R131C4||#Value& S6R131C5||#Value% S5R25C5||#Value% S5R26C5||#Value5 S7R7C28||2.570000 TGP0016AU TGP0016AU4035940451 TGP0016AU4045140543 TGP0016AU4054340633 RARE Yield Fund Distribution (%)
Growth (%) Special DIST Net Quarterly Performance (%) FY/FYTD Growth (%) FY/FYTD Distribution/Yield (%) RARE Infrastructure Income Fund APIR Net Distribution Amount (CPU) FY/FYTD (%) Return (Net)' RARE Infrastructure Income Fund Class AB ClearBridge RARE Infrastructure Income Fund - Hedged Class A Units ClearBridge Distribution Data Manager: ClearBridge Investments TGP0016AU4483544925 : N s D \
/ [ - ~ = j ( E p 4 Q , Q! " b $ Z& ' X `) * ? 5, u- . ! / a 51 u2 3 ! 4 a 56 u7 8 ! 9 a 5; u< = > B :@ zA B D I IE F G ! !I i hJ
;L N Q X vS U X e Z ] 0 _ a = ab c
e Qg u
i 3 j l [n p + q as "u F v w Uy y %{ I | ~ P [ ԁ X c ܄ O Z
ψ
O Z ύ ! ^ i 6 A ~ Ɩ
c c B QLV[ZB<wYvI$
ZO t Z j z " 2 B R b r
d MbP?_ * + % & ?' ?( ?) ? " QLV ? ?ng& U
!
"
#
$
%
&
'
(
)
*
+
,
-
.
/
0
1
2
3
4
5
6
7
8
9
:
;
<
=
>
? D @ l ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?
@
! A
" B
# C
$ D
% E
& F
' G
( H
) I
* J
+ K
, L
- M
. N
/ O
0 P
1 Q
2 R
3 S
4 T
5 U
6 V
7 W
8 X
9 Y
: Z
; [
< \
= ]
> ^
? _ D @ l @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _
@ `
A a
B b
C c
D d
E e
F f
G g
H h
I i
J j
K k
L l
M m
N n
O o
P p
Q q
R r
S s
T t
U u
V v
W w
X x
Y y
Z z
[ {
\ |
] }
^ ~
_ D @ l ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~
`
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z
{
|
}
~
D @ l
D @ l
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
`
a
D @ l
b
c
d
D @ l
! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A R S E F G H I J K L M N O P Q T ^ d U V W X Y Z [ \ ] _ ` a m b c e f g h i j k l n q o p r
D @ l
D @ l ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?
!
"
#
$
%
& !
' "
( #
) $
* %
+ &
, '
- (
. )
/ *
0 +
1 ,
2 -
3 .
4 /
5 0
6 1
7 2
8 3
9 4
: 5
; 6
< 7
= 8
> 9
? : D @ l @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _
@ ;
A <
B =
C >
D ?
E @
F A
G B
H C
I D
J E
K F
L G
M H
N I
O J
P K
Q L
R M
S N
T O
U P
V Q
W R
X S
Y T
Z U
[ V
\ W
] X
^ Y
_ Z D @ l ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~
` [
a \
b ]
c ^
d _
e `
f a
g b
h c
i d
j e
k f
l g
m h
n i
o j
p k
q l
r m
s n
t o
u p
v q
w r
x s
y t
z u
{ v
| w
} x
~ y
z D @ l
{
|
}
~
D @ l
D @ l
!
"
#
$
% D @ l
&
'
(
)
*
+
,
-
.
/
0
1
2
3
4
5
6
7
8
9
:
;
<
=
>
?
@
A
e
f
g
h D @ l
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z
{
|
}
~
D @ l ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?
!
"
#
$
%
&
'
(
)
*
+
,
-
.
/
0
1
2
3
4
5
6
7
8
9
:
;
<
=
>
? D @ l @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _
@
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
[
\
]
^
_ D @ l ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~
`
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z
{
|
}
~
D @ l
D @ l
D @ l
D @ l
D @ l
. P H 0 (
> @ @ 2zpWI1. d @ < & ?' ?( ?) ? " ? ?< & 2zpWI1. 7 Sheet2g g D
ZO
d MbP?_ * + % & ?' ?( ?) ? " ? ? & U P H 0 (
> @ 7 b( b ( g g D
ZO % Z e e
d MbP?_ * + % & ?' ?( ?) ?M \ \ R A R E - S Y 1 - F S - 0 1 \ X e r o x C o l o r - 3d X X DINU" |Dv
SMTJ D FPXF hD FPXF h 4 A4 d 9.5 d d . . . . . . . . . . . . . . . . . . . . . . . . . . . . " d XX ? ? & U } } } 0 } } 1 1 = } 2 2 `= } 3 3 `} } 4 4 @} } 5 5 } } 6 7 } } 8 8 @} } 9 K } } L } } ` } %
!
A A A A A A A A A A
| .
~ / ~
} $
Y
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
!
! (
" (
# (
$ (
% (
& (
' (
( (
) ,
* ,
+ (,
, (,
- (,
. (,
/ 3,
0 3,
1 3-
2 3-
3 O-
4 O-
5 O-
6 O-
7 Y-
8 Y- d 9
)
!
"
#
$
%
&
'
(
)
*
+ )
, )
- )
. )
/ 4
0 4
1 4
2 4
3 P
4 P
5 P
6 P
7 Z
8 Z d 9
Z V p@`@@`@@ @@ @@@ @ @ @ @`@@@`'@ 2@ >@ I@ U@@`@ k@ w@ @ @ @@ @ @@ @ @ @ @ @@N@N @N @N@L@"@L-@L@9@LD@MO@M`[@Mf@M@r@J}@J @J@J@K@@K@K@@K@[@[`@8 d 9
[ V @@@@@@@ `@ @ @ @ @ @ @ @@`@@@'@2@ =@ `I@ T@ `@ k@ w@ @ @ @ @ @ @ @ `@ @ @ @ @ @ @ "@ -@ 9@ `D@ O@*@[@*f@* r@*}@5 @5@5@5 @K@K @K`@K@[@@[@8 d 9
!
" !#
$ !
% !
& !
'
( )
*
+ +
, +
- +
. +
/ 6
0 6
1 >
2 > 3 QQQQ\7
8 \0
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
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z
{
|
}
~
* Rb$@ ? ? b@ @ ffffff? ffffff?~
@ ΅^d@
? ? @
D=? 3+?~
? W^?~
@ @ ? ? @ 5o&@ H ? @ @ @ ? ? ? ? ? ? ?! " (\@ 0 # " @" @" @"j@ ? ? @) * ɍ]$B? + ,~jt? , ,N@, @- . ,H&
@ / 7 ?7 @7 @1 2 77Q@ 3 R ?R ?R @5 6 Rڊew @ 7 ] ?] ?8 d 9
#### ----88??SSSS^^
\ @@ @@ @@ @ @ `@ @ @ @ @ @ @ @@ `@ @ @'@ 2@ =@ `I@ T@ `@ k@ w@ @ @ D @ D @ D @ D @ D B @ `@ @ @ @ @ @ @ @ "@ `-@' ( 9@ ( D ( f ) D@ O@*@[@*f@* r@*}@5 @5@5@5 @T@T @T`@T@_@@_@8 d 9
] 1*? &1 ? LJ? 46? # $h o? $ %! lV}? % % q? & %C? ' Bi? ( k g? ) %䃞? * k g? + .Ǻ? , .w/? - . ? . .U0*? / 9Fx $? 0 9|?5^? 1 7Q? 2 7R!u? 3 U/$? 4 U:M
? 5 U37? 6 Us? 7 aW[? 8 aB? d 9
&&&& ////::@@VVVV``
^ `@ `@ @ @ @ @ @ @ @ @ @ @ @@ `@ @ @'@ 2@ =@ `I@ T@ `@ k@ w@ @ @ d D @ D @ D @ D @ D 6 @ `@ @ @ @ @'@ @'@% & ' "@ & D &~
' `-@ ( 9@ ( D ( f ) D@ O@0@[@0f@0 r@0}@; @;@5@5 @K@K @K`@K@[@@[@8 d 9
_ y)? ? ё\C? Bfj? 46? }b? [ A? ( y? X2ı.? ! _)Ǻ? " 8gDio? # $ŏ1w? $ $ݓ? % $ ? & $c]K? ' S!uq? ( h o? ) ' ? * ~:p? + .Ș? , ..1? - .^K=? . .U? / 9x&? 0 946? vO jM? q? aTR'? /n? n? Af? }b٭? ?߾~
# /$? %q? ˡE? +? ~jtx ! bX9ȶ? " 9v? # Mb? $ I + % ;On & WyaX? ' .e ( Ɏ@? ) 7A`? 4 * AA @
" i6w? ) ( L d L Yz? .seqG? Nj? w˅? v? 0R? 08??
AK?
;EK? IXmx?
ʨ?
NV~7? ^9q? Q? uĔ? fz?
]yqȐ? ?cb? ? ߁L? U "Wc? 4% !? h]? " ? c>1(? ? >Y1m? GŲ? p? ] e 鏿 ! " Uæ? # % & 2
* ' F) * -? + FFF- . 1Όn / FFF1 2 <W$aT? 3 5 6 X5OQ? 7 @ ! 6 = 2 E 2 D 6 bI zf^ F
$
$ 0 . (
B
X P P ? S r ] 4 @
fz8Dt :
< Distributes Quarterly< w
B P
X P P ? r ] 4 @
漮(xI$rɔ
< Distributes Quarterly< w
B
X P P ? r ] 4 @
ahHLޯ=
< Distributes Quarterly< w
B
X P P ? r ] 4 @
v<:NxPe
< Distributes Quarterly< r
B
X P P ? w r
] 4 @
Er }LmBd
< Distributes Quarterly< w
B @
X P P ?
r a ] 4 @
ΐ FH1ؖ
< Distributes Quarterly< w
N X ? e - ] 4 @
O䔽?OICFR"9
< Lisa Georgoulas:
mid price
< c I
*
Z 0
X P P Q Q ? i i ] 4 * @
3R1C
Inn:
0 < 1 These numbers are sourced from our administrator< 0
+
Z
X P P Q Q ? i ] 4 + @
iw !C"%
0 < 1 These numbers are sourced from our administrator< 0
,
Z 0
X P P Q Q ? i Z ] 4 , @
KCvi
0 < 1 These numbers are sourced from our administrator< 0
Emma Adamsu
Emma Adamsu
Emma Adamsu
Emma Adamsu
Emma Adamsu
Emma Adamsu ! Lisa Georgoulas * Carter, Nicoles + Carter, Nicoles , Carter, Nicoles> @ d te reA
/ 7 77 ` 7 t L $ Cum-exit price less distribution CPU Must be greater than zero Q # ' L Effective distribution date Invalid date format te XG n
* 4 7 8 ' L 2 End date is the effective date of the distribution Incorrect date format L & & L J Ensure start date falls the day after the previous distribution's end date Incorrect date format XG m L Reinvestment date Incorrect date format re XG d * * ' ) 5 6 9 ? \ tm PKD In
9 L tm o
, tm 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 C Fund Name Please enter fund name do ar 3 APIR Code APIR Code, Please enter APIR Code or Morningstar Ticker Maximum of 9 characters allowed 3 l C Either enter CPU/day amount or whole amount in cell above, not both% Must be greater than or equal to zero
a This row is not read Must be Y or N only in Y N v * * 5 6 9 T L Actual distribution date Incorrect date format N XG
Z l Reinvestment price Must be greater than zero ) + b( b ( g g D
d i r S h e e t 2 M o d u l e 1
M o d u l e 2 G (
! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i j k m n o p q r s t u v w x y z { | } ~ ղ 0* pH d
VBAProject 4 @j
=
r չP# J<
rstdole> s t d o l e
h %^ *\G{00020430- C
004 6}#2.0#0 #C:\Wind ows\Syst em32\e2. tlb#OLE Automati on ` EOffDicEO f i cEE 2DF8D04C -5BFA-101B-BDE5EAAC42E gram Fil es\CommonMicros oft Shar ed\OFFIC E16\MSO.0DLL#M 1@6.0 Ob Library K TFExc elAddin> T F ED xcl Ad i n ŀW*\CL) Thoms)na@ncial\EON@Onalytics for C&\ In.xlaF
"¦ ySheet2*GBCSeot 2 H2N A HB1«3 B,"B+BBThi sWorkbookGD\h@Xs WA@r k bo5 2 $$&Module4G y M hd u4A2 -!4!b %!
@/A/2 ƀT1o 1j 151W - y # x ME ( SL S S < N 0 { 0 0 0 2 0 8 2 0 - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 } @ 0 % @ x Attribut e VB_Nam e = "She@et2"
Bast0{00020820- C $0046}
|Global!SpacFalse dCreatabl Pre decla Id Tru
BExpose Temp lateDeriv$Bustom izD2 H yW x ME ( 6
< < < j ` X ( Macro recorded 5/02/2007 by Nick Langleyx
14 h % ( O$ * \ R f f f f * 0 V 6 4 4 9 0 8 7 f " 0 ( X ` 8d h ( ( 0 X p ( (
Macro1 Macro e c ) Macro recorded 5/02/2007 by Nick Langley # : k , R:\Portfolio Management\Portfolios\RIC09.TXT 4 8 6 : > < B @ D b F H J L D D D D D D D D D
D D D
D D
N P 0B@2
RARE Infrastructure.xls $ l B@n F24 $ p B@H x z r% t B@v RARE Infrastructure.xls $ l B@n F25 $ p B@H x z r% t B@v RARE Infrastructure.xls $ l B@n K24 $ p B@H x z r% t B@v Open Trades $ | B@H A@\ o IJ Attribut e VB_Nam e = "Mod ule1"
S ub Macro`1()
L. Descrip0tiontX r ecorded 5/02/200 7 by Nic k Langley ProcDataYInvoke_FuncY \n14 6'
|
' v +
Work books.Op enText Filen :=" R:\Portfolio4nag ement
s\ RIC09.TXT", _
)Origin: =xlMSDOS , StartRow:=1, oTypeDel imited, ?Qualifier:='xlD oubleQuo te, Consecutive ! Fals Ta@b:=Tru SemicoloDQCommapac#D OthA DFieldI nfo:=Array(C 21)J=2, 3 4 5 6 7 .8-9 10JD&
1#1$- Trailing MinusNumpbersEtCW indows(" RARE Cra structur e.xls").DAc@date Re("F24Select).H r ks (1).Foll@ow New:=`AddHistory%7$5?$ ?$ $$K?$n?$0$Sheet 6a{r < B @ D b F H J L D D D D D D D D D
D D D
D D
N P 0B@2
BLPLinkReset TB@b RefireBLP TB@b RefireBLP TB@b dB@f BLPLinkReset TB@b o ` X ^ Attribut e VB_Nam e = "Mod ule2"
S ub Macro`2()
L. Descrip0tiontX r ecorded 31/05/20 07 by Bloomberg ProcDataWInvoke _FuncW \n14 6'
' t )
Applica.Run " RefireBLP2Workb ooks.Ope nText Filen:="R :\Portfolio Dnagement
s\R IC09.TXT", _
) Origin:= xlMSDOS, StartRo@w:=1, TypeDelimited, ? Qualifier:='xlDo ubleQuot e, Consecutive Fals Tab :=Tru Semicolo@"A(CommaF
pac#D OthA DFieldIn fo:=Array(C 21)J=X2, 3 4U 5 6 7 8-9 10JkD&
1#1$-T railingM@inusNusEtNLinkReset^ csWindow.AateN@!#!End
y4 x ME M o d u l e 4 l $
_ _ S R P _ 0
_ _ S R P _ 1 _ _ S R P _ 2
( 6
< < < . ` , % ` ` X `C$ * \ R f f f f * 0 T 6 4 4 9 0 8 7 f . 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 ۶FTn1j#
0 Q ! a
VBAProject Sheet2 ThisWorkbook Module4 Module2 Module1 F B C:\Program Files\Common Files\Microsoft Shared\VBA\VBA7.1\VBE7.DLL VBA
1 a P F Open_PTM_Files 9 C:\Program Files\Microsoft Office\Root\Office16\EXCEL.EXE Excel
p 0 F C:\Windows\System32\stdole2.tlb stdole
Q L-[ DR ? C:\Program Files\Common Files\Microsoft Shared\OFFICE16\MSO.DLL Office
A Macro2
Macro1r rU@ @ @
& Macro recorded 31/05/2007 by Bloomberg
14 ( Macro recorded 5/02/2007 by Nick LangleyL rU@ @ @ @ ~x a S 4 rU@ @ @ 8 ` b rU@ @ @ @ ~x _ _ S R P _ 3 _ _ S R P _ 4 _ _ S R P _ 5 _ _ S R P _ 6 a S 4 rU@ @ @ 8 ` b rU@ @ @ @ ~x a S 4 _ _ S R P _ 7 T h i s W o r k b o o k _ V B A _ P R O J E C T P R O J E C T rU@ @ @ 8 ` 1 b - y # x ME ( SL S S < N 0 { 0 0 0 2 0 8 1 9 - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 } @ 0 i t % @ x Attribut e VB_Nam e = "Thi sWorkbook"
Bas0{00020P819- 0C $0046}
|GlobalSpacFalse dCreatabl Predecla Id Tru
BExpose Templ ateDerivBustomizD2 a * \ G { 0 0 0 2 0 4 E F - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 } # 4 . 2 # 9 # C : \ P r o g r a m F i l e s \ C o m m o n F i l e s \ M i c r o s o f t S h a r e d \ V B A \ V B A 7 . 1 \ V B E 7 . D L L # V i s u a l B a s i c F o r A p p l i c a t i o
! " $ % & ' ( ) + , - . 0 1 2 3 4 5 6 8 n s * \ G { 0 0 0 2 0 8 1 3 - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 } # 1 . 9 # 0 # C : \ P r o g r a m F i l e s \ M i c r o s o f t O f f i c e \ R o o t \ O f f i c e 1 6 \ E X C E L . E X E # M i c r o s o f t E x c e l 1 6 . 0 O b j e c t L i b r a r y * \ G { 0 0 0 2 0 4 3 0 - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 } # 2 . 0 # 0 # C : \ W i n d o w s \ S y s t e m 3 2 \ s t d o l e 2 . t l b # O L E A u t o m a t i o n (* \ G { 2 D F 8 D 0 4 C - 5 B F A - 1 0 1 B - B D E 5 - 0 0 A A 0 0 4 4 D E 5 2 } # 2 . 8 # 0 # C : \ P r o g r a m F i l e s \ C o m m o n F i l e s \ M i c r o s o f t S h a r e d \ O F F I C E 1 6 \ M S O . D L L # M i c r o s o f t O f f i c e 1 6 . 0 O b j e c t L i b r a r y * \ C C : \ P r o g r a m F i l e s \ T h o m s o n F i n a n c i a l \ T h o m s o n O N E A n a l y t i c s f o r O f f i c e \ T F E x c e l A d d I n . x l a * \ C C : \ P r o g r a m F i l e s \ T h o m s o n F i n a n c i a l \ T h o m s o n O N E A n a l y t i c s f o r O f f i c e \ T F E x c e l A d d I n . x l a F
չP# y S h e e t 2 0 O 6 4 4 9 0 8 7 0 ' S h e e t 2 3 T h i s W o r k b o o k 0 P 6 4 4 9 0 8 7 0 + T h i s W o r k b o o k 3 M o d u l e 4 0 T 6 4 4 9 0 8 7 f , M o d u l e 4 4 0 M o d u l e 2 0 U 6 4 4 9 0 8 7 f ^ M o d u l e 2 H M o d u l e 1 0 V 6 4 4 9 0 8 7 f h M o d u l e 1 W ` x ` 0 BEW,8\6 EN8GF2v p.@bIRR d\O1E!/fO ҠSUwFxD5H ?9 t2 Excel+ VBA Win16~ Win32 Win64x Mac VBA6# VBA7#
VBAProject stdole` Officeu TFExcelAddin
@ Sheet2 _Evaluate ThisWorkbook| Module4e Open_PTM_Files ( WorkbooksB OpenText« Filenamej OriginF xlMSDOS StartRow DataType%? xlDelimited
TextQualifier
xlDoubleQuote ConsecutiveDelimiterxx Semicolont Comma0K Space Other FieldInfo TrailingMinusNumbersC UpdateLinks Application* Calculationh xlManual MaxChange Calculate Module2c Macro2N Run_ ActiveWindow+ ActivateNext Module1b Macro1N Windowsd Activate| Range SelectionZ
Hyperlinks: Follow} NewWindow
AddHistory Sheets
Workbookk i " $ ' + -
_ Z ID="{8A8F9033-574E-425C-967C-C0CB1BB2DB6E}"
Document=ThisWorkbook/&H00000000
Document=Sheet2/&H00000000
Module=Module4
Module=Module1
Module=Module2
Name="VBAProject"
HelpContextID="0"
VersionCompatible32="393222000"
CMG="9A9864FFC903C903C903C903"
DPB="0301FD966797679767"
GC="6C6E9205926F936F9390"
[Host Extender Info]
&H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000
[Workspace]
ThisWorkbook=0, 0, 0, 0, C
Sheet2=0, 0, 0, 0, C
Module4=0, 0, 0, 0, C
Module1=0, 0, 0, 0, C
Module2=0, 0, 0, 0, C
P R O J E C T w m R e v i s i o n L o g # S u m m a r y I n f o r m a t i o n ( * ( D o c u m e n t S u m m a r y I n f o r m a t i o n 8 / ThisWorkbook T h i s W o r k b o o k Sheet2 S h e e t 2 Module4 M o d u l e 4 Module1 M o d u l e 1 Module2 M o d u l e 2 2
Nick Langley
Oh +'0 P X
$ Stock Research & Valuation Model Nick Langley Carter, Nicole Microsoft Excel @ NqO۾@ x{@
՜. +,D ՜. +,0 P X t |
RARE Infrastructure Quarter--> Dist IMD02P004 Worksheets ( c k { CachePFDLData FDSMenuDocLevelBtnStates True 8
F Microsoft Excel 2003 Worksheet C o m p O b j 7 l Biff8 Excel.Sheet.8 9q