Evolução da Alocação de Ativos da Carteira HC Investimentos.xlsx

Conheça nosso MiniCurso Gráts MiniCurso  Gráts

Clique Aqui!

Evolução da Carteira HC Invesmentos em 2010 Esta planilha fnanceira irá ajudar você: 1. Saber os detalhes da evolução da alocação da Carteira HC Invesmentos em !"!# 2. Conhecer $uais operaç%es &oram reali'adas ao lon(o do ano# 3. Esta)scas comparavas entre a Carteira HC Invesmentos* +ndices e ,undos#

Cr-ditos:: .lanilha ,inanceira desenvolvida por Henrique Carvalho Cr-ditos

HC Invesmentos

Evolução da Aloação de Avos da Carteira HC Invesmentos

A

Aloação ensal da Carteira HC Invesmentos " #inal $aneiro%2010 " CA&H '# #II C()I* A+,E& !#/01 2!#""1 ""#31 "4#!/1 "#!1 CA&H !#2!1 Aloação -s"a"-s -s 'ent / 7an6"! "#401 ,eb6"! !#!21 9ar6"! #2"1 pr6"! 6!#301 9a;6"! !#41 7un6"! 6!#!41 7ul6"! /#//1 u(6"! !#!!1 Sep6"! #"81 ec6"! #/51 'entaildiade -s"a"-s -s 'ent / 7an6"! "#401 ,eb6"! !#!21 9ar6"! #2"1 pr6"! 6!#301 9a;6"! !#41 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 /#51 "#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!#51 /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#81 "5#081

"4#!/1 "5#831 "2#401 "2#/21 "#201 ""#31 ""#/51 ""#01 "!#451 ""#!1 ""#/"1 3#221

"#!1 "#/!1 "0#8!1 "4#8"1 0#21 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 !#21 !#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 !#41 !#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!

CS

ltere o scroll

loação ensal da Carteira HC Invesmentos " #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<

BES

HC

Evolução da Aloação da 5!1

2!1

8!1

/!1

!1

"!1

!1 7an6"!

,eb6"!

9ar6"!

pr6"!

9a;6"!

7un6"!

Carteira HC Invesmentos

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.300

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.300

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.300

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.300

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.300

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.300

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

,"L11B

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.300

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

,"L11B

20(0#(10

0.832#

&.00

0.8#%

 A+/-10

NSLU11B

0(08(10

1.515

181.5!

0.8%

 A+/-10

EURO11

13(08(10

1.300

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

,"L11B

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.300

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

,"L11B

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.300

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

,"L11B

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.300

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

,"L11B

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

1050.00

0.#&%

4$-10

"E6R!

30(12(11

0.1#00

2.01

0.5%

'entailidades

 Ativos

Classe

C/V

Data

Preço

Taxa

L6N 010113

64

C

20(01(10

#0&.82

12.38%

"IBB11

A9 F

C

2(01(10

&0.80

R$n

4:as

An+a

"IBB11

A9 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

A9 F

C

1&(05(10

83.00

"IBB11

A9 F

C

20(05(10

81.25

"E6RF30

O)<$s

C

20(05(10

0.1

"IBB11

A9 F

C

20(05(10

82.00

"E6RF30

O)<$s

C

20(05(10

0.!5

"IBB11

A9 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%

,"L11B

FII

C

08(0(10

&.00

R$n

4:as

An+a

"IBB11

A9 F

;

1#(0(10

8&.80

&.10%

2&

1&&.38%

FFCI11

FII

C

22(0(10

1.25

"IBB11

A9 F

C

2&(0(10

8!.5

"E6R!F

A9 F

C

30(08(10

25.85

R$n

4:as

An+a

"E6R!F

A9 F

;

13(0&(10

28.15

8.&0%

1!

82!.21%

"E6R!F

A9 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

,"L11B

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)$'a9 ? 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 !#41 6!#!41

2#01 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#41

"#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 !#21 "#!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#81 8#841 "#!8

"#!81 "0#31 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, >
'iso /#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#31 "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 #31

6"#551 6#0/1 8#301 6!#081

!#201 !#2!1 !#221 !#251

!#21 !#241 !#8/1 !#!!1

!#051 !#031 !#081

6/#3"1 /#201 !#421

6#851 6!#!41 6/#21

!#51 !#231 !#241

!#!"1 !#!81 !#821

!#0"1 !#0"1 !#3/1

4#541 5#21 6/#2/1

!#81 !#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