Conheça nosso MiniCurso Gráts MiniCurso Gráts
Clique Aqui!
Evolução da Carteira HC Invesmentos em 2010 Esta planilha fnanceira irá ajudar você: 1. Saber os detalhes da evolução da alocação da Carteira HC Invesmentos em !"!# 2. Conhecer $uais operaç%es &oram reali'adas ao lon(o do ano# 3. Esta)scas comparavas entre a Carteira HC Invesmentos* +ndices e ,undos#
Cr-ditos:: .lanilha ,inanceira desenvolvida por Henrique Carvalho Cr-ditos
HC Invesmentos
Evolução da Aloação de Avos da Carteira HC Invesmentos
A
Aloação ensal da Carteira HC Invesmentos " #inal $aneiro%2010 " CA&H '# #II C()I* A+,E& !#/01 2!#""1 ""#31 "4#!/1 "#!1 CA&H !#2!1 Aloação -s"a"-s -s 'ent / 7an6"! "#401 ,eb6"! !#!21 9ar6"! #2"1 pr6"! 6!#301 9a;6"! !#41 7un6"! 6!#!41 7ul6"! /#//1 u(6"! !#!!1 Sep6"! #"81
ec6"! #/51 'entaildiade -s"a"-s -s 'ent / 7an6"! "#401 ,eb6"! !#!21 9ar6"! #2"1 pr6"! 6!#301 9a;6"! !#41 7un6"! 6!#!41 7ul6"! /#//1 u(6"! !#!!1 Sep6"! #"81 ec6"! #/51 8otal 9 1.2/
'# !#341
#II 2#51
C()I* 4#01
A+,E& 6/#351
HC "#401
CASH
RF
FII
CÂMBIO
AÇÕES
!#/01 !#841 /#51 "#431 /#051 !#/21 !#881 !#231 !#081 "#221 /#/21 0#/1
2!#""1 2!#5!1 80#821 2"#3"1 8/#81 8"#0!1 8"#"1 8!#51 /3#521 /3#2!1 /3#/"1 /0#8/1
""#31 ""#"21 "/#451 "/#221 ""#0!1 "0#0/1 "0#531 "0#/1 "4#4"1 "4#2/1 "5#81 "5#081
"4#!/1 "5#831 "2#401 "2#/21 "#201 ""#31 ""#/51 ""#01 "!#451 ""#!1 ""#/"1 3#221
"#!1 "#/!1 "0#8!1 "4#8"1 0#21 4#"!1 0#/31 3#31 /"#!81 /!#/31 3#5"1 5#321
CASH
RF
FII
CÂMBIO
AÇÕES
!#2!1 !#2!1 !#201 !#21 !#221 !#221 !#221 !#221 !#221 !#221 !#281 !#581 .45/
!#341 "#!81 "#/81 !#!31 "#!51 "#"51 "#201 "#31 !#5/1 "#"31 !#21 "#41 12.63/
2#51 6"#341 /#/1 "#!/1 6!#5/1 "#81 8#!21 !#41 !#3/1 "#/21 8#001 5#541 27.7/
4#01 6/#!01 !#4/1 6!#3"1 8#821 !#521 6/#"!1 "#4"1 6"#551 8#!21 /#441 6/#//1 10.3/
6/#351 !#221 5#!1 6/#521 64#431 62#4"1 ""#251 6/#331 5#331 !#551 6/#"1 8#841 0.13/
CA&H
A+,E&
!#2!
CS
ltere o scroll
loação ensal da Carteira HC Invesmentos " #inal $aneiro%2010
0.35/ 21.20/ #
#II
C()I*
60.11/ 14.03/
11.27/
4#01 2#51 1.45/
!#341
6/#351 ?,
,II
r para ver as mudanças no (ráfco
C@9AI<
BES
HC
Evolução da Aloação da 5!1
2!1
8!1
/!1
!1
"!1
!1 7an6"!
,eb6"!
9ar6"!
pr6"!
9a;6"!
7un6"!
Carteira HC Invesmentos
7ul6"!
u(6"!
Sep6"!
=ov6"!
>ec6"!
Mês Jan-10
Ativos
Data
Dividendos
Preço Compra
Yield
NSLU11B
1.5280
185.00
0.83%
Jan-10
EURO11
1.300
1!.00
0.83%
Jan-10
F"AB11
1.#000
23!.!0
0.#3%
F$-10
NSLU11B
1.!&&2
181.5!
0.83%
F$-10
EURO11
1.300
1!.00
0.83%
F$-10
F"AB11
1.#000
23!.!0
0.#3%
Ma'-10
NSLU11B
05(03(10
1.15!
181.5!
0.8&%
Ma'-10
EURO11
15(03(10
1.300
1!.00
0.83%
Ma'-10
F"AB11
15(03(10
1.#000
23!.!0
0.#3%
A)'-10
NSLU11B
08(0!(10
1.5##
181.5!
0.8%
A)'-10
EURO11
15(0!(10
1.300
1!.00
0.83%
A)'-10
F"AB11
15(0!(10
1.#000
23!.!0
0.#3%
A)'-10
FFCI11
15(0!(10
0.010
1.2#
0.83%
Ma*-10
NSLU11B
0#(05(10
1.538
181.5!
0.&1%
Ma*-10
EURO11
1!(05(10
1.300
1!.00
0.83%
Ma*-10
F"AB11
1!(05(10
1.8000
23!.!0
0.##%
Ma*-10
FFCI11
1#(05(10
0.010
1.2#
0.83%
J+n-10
NSLU11B
08(0(10
1.5#&
181.5!
0.8#%
J+n-10
EURO11
15(0(10
1.300
1!.00
0.83%
J+n-10
F"AB11
15(0(10
1.8000
23!.!0
0.##%
J+n-10
FFCI11
15(0(10
0.010
1.2#
0.83%
J+n-10
,"L11B
18(0(10
0.8333
&.00
0.8#%
J+-10
NSLU11B
0#(0#(10
1.5#00
181.5!
0.8%
J+-10
EURO11
15(0#(10
1.300
1!.00
0.83%
J+-10
F"AB11
15(0#(10
1.8000
23!.!0
0.##%
J+-10
FFCI11
15(0#(10
0.010
1.2#
0.83%
J+-10
,"L11B
20(0#(10
0.832#
&.00
0.8#%
A+/-10
NSLU11B
0(08(10
1.515
181.5!
0.8%
A+/-10
EURO11
13(08(10
1.300
1!.00
0.83%
A+/-10
F"AB11
13(08(10
1.8500
23!.!0
0.#&%
A+/-10
FFCI11
13(08(10
0.010
1.2#
0.83%
A+/-10
,"L11B
20(08(10
0.832#
&.00
0.8#%
S$)-10
NSLU11B
08(0&(10
1.5300
181.5!
0.8!%
S$)-10
EURO11
15(0&(10
1.300
1!.00
0.83%
S$)-10
F"AB11
15(0&(10
1.&000
23!.!0
0.81%
S$)-10
FFCI11
15(0&(10
0.010
1.2#
0.83%
S$)-10
,"L11B
20(0&(10
0.832#
&.00
0.8#%
O-10
NSLU11B
0#(10(10
1.5308
181.5!
0.8!%
O-10
EURO11
15(10(10
1.300
1!.00
0.83%
O-10
F"AB11
15(10(10
1.&000
23!.!0
0.81%
O-10
FFCI11
15(10(10
0.010
1.2#
0.83%
O-10
,"L11B
20(10(10
0.832#
&.00
0.8#%
N-10
NSLU11B
08(11(10
1.5308
181.5!
0.8!%
N-10
EURO11
12(11(10
1.300
1!.00
0.83%
N-10
FFCI11
12(11(10
0.010
1.2#
0.83%
N-10
F"AB11
1(11(10
1.&000
23!.!0
0.81%
N-10
,"L11B
1&(11(10
0.832#
&.00
0.8#%
4$-10
NSLU11B
0#(12(10
1.5315
181.5!
0.8!%
4$-10
F"AB11
1!(12(10
2.0000
23!.!0
0.85%
4$-10
FFCI11
15(12(10
0.010
1.2#
0.8!%
4$-10
FCFL11B
23(12(10
8.3000
1050.00
0.#&%
4$-10
"E6R!
30(12(11
0.1#00
2.01
0.5%
'entailidades
Ativos
Classe
C/V
Data
Preço
Taxa
L6N 010113
64
C
20(01(10
#0&.82
12.38%
"IBB11
A9 F
C
2(01(10
&0.80
R$n
4:as
An+a
"IBB11
A9 F
;
05(03(10
&5.30
!.&%
38
5&.1&%
FFCI11
FII
C
08(03(10
1.2#
10.!5%
L6N 010113
64
C
1(0!(10
#2.8
12.53%
L6N 010113
64
C
05(05(10
#23.5&
12.&%
R$n
4:as
An+a
LF6 0#0312
64
;
1&(05(10
!22#.&2
&.50%
11.58%
!5
&.1#%
"IBB11
A9 F
C
1&(05(10
83.00
"IBB11
A9 F
C
20(05(10
81.25
"E6RF30
O)<$s
C
20(05(10
0.1
"IBB11
A9 F
C
20(05(10
82.00
"E6RF30
O)<$s
C
20(05(10
0.!5
"IBB11
A9 F
C
2!(05(10
83.00
R$n
4:as
An+a
4=a'>
4=a'
;
28(05(10
3.08
5.#1%
1&
10.&1%
"E6RF30
O)<$s
;
31(05(10
0.5&
11.32%
11
3!1&.&8%
,"L11B
FII
C
08(0(10
&.00
R$n
4:as
An+a
"IBB11
A9 F
;
1#(0(10
8&.80
&.10%
2&
1&&.38%
FFCI11
FII
C
22(0(10
1.25
"IBB11
A9 F
C
2&(0(10
8!.5
"E6R!F
A9 F
C
30(08(10
25.85
R$n
4:as
An+a
"E6R!F
A9 F
;
13(0&(10
28.15
8.&0%
1!
82!.21%
"E6R!F
A9 F
C
30(0&(10
2.01
R$n
4:as
An+a
EURO11
FII
;
1(11(10
20!.00
2!.3&%
!82
1#.&&%
FLR"11B
FII
C
0&(12(10
111&.&&
R$n
4:as
An+a
,"L11B
FII
;
13(12(10
103.50
#.81%
188
15.#!%
FCFL11B
FII
C
13(12(10
1050.00
10.03%
BN4S 15
4$ên+'$s
C
13(12(10
1000.00
12.51%
BN4S 25
4$ên+'$s
C
1!(12(10
1000.00
0.30%
BN4S 35
4$ên+'$s
C
15(12(10
1000.00
.30%
R$n
4:as
An+a
F"AB11
FII
;
30(12(10
300.00
2#.&&%
!!#
22.35%
> O)$'a9 ? F+n@ Ca?:a
10.&3% 10.!5%
&.&0%
1#(02(0&
3#8&.1
13(11(0&
2.&2
22(0#(0&
1!.00
0&(10(0&
23!.!0
es 7an6"! ,eb6"!
HC "#401 !#!21
I)* 68#521 "#501
;E8' 65#041 "#31
A
=# 62#/21 !#5"1
C&H= /#4"1 6"#/!1
odal 6!#4/1 !#5/1
=a> !#"1 !#881
=?vea !#431 !#41
9ar6"! pr6"! 9a;6"! 7un6"!
#2"1 6!#301 !#41 6!#!41
2#01 68#!81 65#581 6/#/21
#21 64#/1 63#"!1 63#51
""#841 65#!31 64#081 6""#231
5#!/1 6#331 63#"81 6"#881
!#4"1 6"#551 "#1 "#381
!#"21 !#!/1 6!#251 !#0"1
!#/!1 !#281 6!#/81 !#4"1
!#4/1 !#!1 !#21 !#301
7ul6"! u(6"! Sep6"!
/#//1 !#!!1 #"81
"!#0!1 6/#2"1 5#201
/#531 62#421 8#41
"#251 6#3"1 "/#451
"!#0/1 62#"/1 5#!31
"#881 !#//1 !#8/1
!#""1 !#!!1 !#"!1
!#221 "#"!1 !#3"1
"#"1 "#81 !#001
ec6"!
"#!"1 !#401 #/51
"#431 68#!1 #/51
62#01 68#/51 ""#021
8#/81 !#21 "#!81
"#/21 6#301 !#"51
#081 #"31 "#/1
!#0!1 !#5!1 !#431
"#!81 !#851 "#821
"#4!1 !#"!1 "#"/1
&tats
HC
I)*
;E8'
A
=#
C&H=
odal
=a>
=?vea
"8#81 8#841 "#!8
"#!81 "0#31 6!#85
6/#281 #341 6"#82
"0#/51 0#/"1 !#/!
6/#5/1 "3#241 6!#50
"/#421 2#/41 !#48
#451 "#0!1 6/#03
4#2"1 "#551 6"#/2
3#541 "#0"1 6!#!2
?etorno ?isco Sharpe
'etorno I Gávea Gap .oupança I.C 9odal IA< G, >
'iso /#41 "0#/51 1.2/ "/#421 3#421 3#541 4#2"1 5#3!1 2#3"1 #451 "#!81 6/#5/1 68#/1 6/#281
.oupança C>I I.C Gap 9odal Gávea HC CSHG >
!#"51 !#/21 "#!51 "#551 "#0!1 "#0"1 .4/ 2#/41 "#!51 "/#"31 "0#31 "3#241 #341 0#/"1
C@I !#551 !#231
*'* 5#821 6"#!1
@*
;ou>ança !#2!1 !#2!1
I;CA !#421 !#401
!#451 !#551 !#421 !#431
8#01 "#841 8#/21 #31
6"#551 6#0/1 8#301 6!#081
!#201 !#2!1 !#221 !#251
!#21 !#241 !#8/1 !#!!1
!#051 !#031 !#081
6/#3"1 /#201 !#421
6#851 6!#!41 6/#21
!#51 !#231 !#241
!#!"1 !#!81 !#821
!#0"1 !#0"1 !#3/1
4#541 5#21 6/#2/1
!#81 !#051 6#3"1
!#221 !#281 !#581
!#421 !#0/1 !#5/1
C@I
*'*
@*
;ou>ança
I;CA
3#421 !#/21 !#!!
/#41 "/#"31 "#4"
68#/1 "#!51 6"#"4
5#3!1 !#"51 6"0#"8
2#3"1 "#!51 6/#5"
&har>e I Gávea IA< G, >
"#4" 1.0 !#48 !#/! !#!! 6!#!2 6!#85 6!#50 6"#"4 6"#/2 6"#82 6/#5" 6/#03 6"0#"8