Rebalanceamento LeandroCubas

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 25

@lecubas

1. Controle 1. Controle

2. Notas

3. Valor Intrínseco - Graham Ativo Preço Num. Ações

4. Dashboard
TAEE3 R$17.71 700
BCFF11 R$89.20 300
KLBN4 R$20.96 700
ITSA3 R$10.27 1,100
EZTC3 R$39.96 50
XPLG11 R$129.83 25
HGLG11 R$170.00 19
XPML11 R$106.29 25
EGIE3 R$43.21 94
SQIA3 R$23.53 173
MDIA3 R$39.98 250
GRND3 R$7.93 217
IRBR3 R$5.10 120
IVVB11 R$138.80 16
KNRI11 R$157.49 6
VVAR3 R$26.37 96
RAIL3 R$22.64 103
WIZS3 R$9.32 262
BBRC11 R$129.80 30
MFII11 R$127.25 41
BIDI11 R$61.99 35
MXRF11 R$10.43 396
VNQ R$426.00 4
IAU R$93.00 20
DIS R$656.29 2
TSLA R$8,405.44 0.40
AMZ R$15,400.00 0.1
GOOGL R$8,024.00 0.2
AAPL R$2,122.58 0.3
FACEBOOK R$1,304.49 0.4
BRK R$1,034.62 1
NOBL R$370.00 8
NFLX R$2,779.00 0.4
KO R$240.00 1
SPY R$1,500.00 0.4
Tenho (emR$) Nota % Carteira Ideal % Carteira Tenho

R$12,397.00 8 2.76% 2.48%


R$26,760.00 12 4.15% 5.35%
R$14,672.00 8 2.76% 2.93%
R$11,297.00 10 3.46% 2.26%
R$1,998.00 7 2.42% 0.40%
R$3,245.75 10 3.46% 0.65%
R$3,230.00 10 3.46% 0.65%
R$2,657.25 8 2.76% 0.53%
R$4,061.74 10 3.46% 0.81%
R$4,070.69 8 2.76% 0.81%
R$9,995.00 8 2.76% 2.00%
R$1,720.81 7.5 2.59% 0.34%
R$612.00 2 0.69% 0.12%
R$2,220.80 5 1.73% 0.44%
R$944.94 7.5 2.59% 0.19%
R$2,531.52 10 3.46% 0.51%
R$2,331.92 8 2.76% 0.47%
R$2,441.84 8.85 3.06% 0.49%
R$3,894.00 8 2.76% 0.78%
R$5,217.25 9 3.11% 1.04%
R$2,169.65 6 2.07% 0.43%
R$4,130.28 9 3.11% 0.83%
R$1,704.00 7.5 2.59% 0.34%
R$1,860.00 8 2.76% 0.37%
R$1,312.58 9 3.11% 0.26%
R$3,362.18 8 2.76% 0.67%
R$1,540.00 10 3.46% 0.31%
R$1,604.80 10 3.46% 0.32%
R$594.32 9 3.11% 0.12%
R$1,111.60 8 2.76% 0.22%
R$1,034.62 7 2.42% 0.21%
R$2,960.00 9 3.11% 0.59%
R$1,111.60 8 2.76% 0.22%
R$240.00 7 2.42% 0.05%
R$600.00 9 3.11% 0.12%
Comece por aqui!

Valor na Corretora R$500,000.00

Quero (em R$) Quanto Falta (emR$) Compra ou Aguarda? Qto Falta (Ações ou Cotas)

R$13,824.09 R$1,427.09 Comprar 81


R$20,736.13 -R$6,023.87 Aguardar -68
R$13,824.09 -R$847.91 Aguardar -40
R$17,280.11 R$5,983.11 Comprar 583
R$12,096.08 R$10,098.08 Comprar 253
R$17,280.11 R$14,034.36 Comprar 108
R$17,280.11 R$14,050.11 Comprar 83
R$13,824.09 R$11,166.84 Comprar 105
R$17,280.11 R$13,218.37 Comprar 306
R$13,824.09 R$9,753.40 Comprar 415
R$13,824.09 R$3,829.09 Comprar 96
R$12,960.08 R$11,239.27 Comprar 1,417
R$3,456.02 R$2,844.02 Comprar 558
R$8,640.06 R$6,419.26 Comprar 46
R$12,960.08 R$12,015.14 Comprar 76
R$17,280.11 R$14,748.59 Comprar 559
R$13,824.09 R$11,492.17 Comprar 508
R$15,292.90 R$12,851.06 Comprar 1,379
R$13,824.09 R$9,930.09 Comprar 77
R$15,552.10 R$10,334.85 Comprar 81
R$10,368.07 R$8,198.42 Comprar 132
R$15,552.10 R$11,421.82 Comprar 1,095
R$12,960.08 R$11,256.08 Comprar 26
R$13,824.09 R$11,964.09 Comprar 129
R$15,552.10 R$14,239.52 Comprar 22
R$13,824.09 R$10,461.91 Comprar 1
R$17,280.11 R$15,740.11 Comprar 1.0
R$17,280.11 R$15,675.31 Comprar 15
R$15,552.10 R$14,957.78 Comprar 7
R$13,824.09 R$12,712.49 Comprar 10
R$12,096.08 R$11,061.46 Comprar 11
R$15,552.10 R$12,592.10 Comprar 34
R$13,824.09 R$12,712.49 Comprar 5
R$12,096.08 R$11,856.08 Comprar 49
R$15,552.10 R$14,952.10 Comprar 10
@lecubas

2. Notas
1. Controle Atributos Nível de Importância Indicador

2. Notas Setor e Qualidade 8

3. Valor Intrínseco - Graham Lucro Últimos 5 anos 7

4. Dashboard Margem Líquida 8

ROE 5

Dividendo 7

Endividamento 7

NOTA FINAL 7.87


% do Atributo Nota do Atributo (de 0 a 10)

19% 9

17% 8

19% 7

12% 9

17% 5

17% 9.5

Div bruta/P.Liquido

EBIT/Desp.Finan

Divl.Liq/EBITIDA
Pontos de Atenção

1° Se a maior parte das empresas do setor é lucrativa | 2° Se o setor é perene, ou seja, existe há bastante tempo | 3° Se há difere

1° Se a empresa teve lucro líquido positivo em todos os trimestres | 2° Se o lucro líquido cresceu

Se a Margem líquida é maior que 15%

Ideal que o ROE historicamente maior que 15%

Ideal que seja maior que a Renda Fixa, mas acima de 5% já está bom.

Ideal que a Dívida Líquida/EBITDA menor que 1,5… mas até 3 dá pra passar (se a empresa estiver em expansão)

para cada 1 real, quanto ela tem de dívida. Ex. 1,6 significa que para cada 1 real a empresa tem 1,6 de dívida.

Quanto de geraçao operacional ela gera em relacao a dívida. Ex resultado = 5, o que a empresa gera de operacional é 5x maior do

Divida em relacao ao resultado operacional. Ideal que seja menor que 1,5, em alguns casos se a empresa estiver investindo em p
@lecubas

1. Controle

2. Notas Valor Intrínseco pela fórmula de Grah

3. Valor Intrínseco - Graham

4. Dashboard TICKER

Pre Definido

LPA

VPA

Resultado

Preco atual

VI

Margem de Segurança
33%
Oportunidade de Compra
co pela fórmula de Graham

TAEE3

22.5

R$ 1.29

R$ 5.24

R$ 152.09

R$ 9.30

R$ 12.33

gem de Segurança
33%
unidade de Compra
@lecubas

1. Controle

2. Notas
Carteira Ide
3. Valor Intrínseco - Graham

4. Dashboard

KO SPY TAEE3 B
NFLX 2% 3% 3%
NOBL 3%
3%
BRK
2%
FACEBOOK
3%
AAPL
3%
GOOGL
3%
AMZ
3%
TSLA
3%
DIS
3%
IAU
3%
VNQ
3%
MXRF11
3%BIDI11
2%MFII11 RAIL
3% BBRC11WIZS3 3%
DIS
3%
IAU
3%
VNQ
3%
MXRF11
3%BIDI11
2%MFII11 RAIL
3% BBRC11WIZS3 3%
3% 3%
Carteira Ideal
TAEE3
BCFF11
KLBN4
ITSA3
KO SPY TAEE3 BCFF11
EZTC3
NFLX 2% 3% 3% 4% KLBN4
XPLG11
HGLG11
BL 3% 3% XPML11
% ITSA3
EGIE3
3%
EZTC3 SQIA3
2% MDIA3
XPLG11 GRND3
3% IRBR3
IVVB11
HGLG11 KNRI11
3% VVAR3
RAIL3
XPML11 WIZS3
3% BBRC11
MFII11
EGIE3
BIDI11
3%
MXRF11
SQIA3 VNQ
3% IAU
MDIA3 DIS
3% TSLA
GRND3 AMZ
3%
IRBR3 GOOGL
IVVB11
1% AAPL
F11 2%
KNRI11 FACEBOOK
BIDI11
2%MFII11 VVAR3 3% BRK
RAIL3 NOBL
3% BBRC11WIZS3 3% 3% NFLX
SQIA3 VNQ
3% IAU
MDIA3 DIS
3% TSLA
GRND3 AMZ
3%
IRBR3 GOOGL
IVVB11
1% AAPL
F11 2%
KNRI11 FACEBOOK
BIDI11
2%MFII11 VVAR3 3% BRK
RAIL3 NOBL
3% BBRC11WIZS3 3% 3% NFLX
3% 3%
KO
SPY
Carteira que tenho
TAEE3
BCFF11
KLBN4
ITSA3
EZTC3 NOBL
BRK SPY
KO
NFLX
FACEBOOK
AAPL
GOOGL TAEE3
1%2% 0%
0%
1%
XPLG11
AMZ0%1% 9%
HGLG11 TSLA1%1%
XPML11 DIS2%
EGIE3 IAU
1%
SQIA3
VNQ1%
MDIA3
1%
MXRF11
GRND3 3%
IRBR3
BIDI11
2% BC
IVVB11
MFII11 1
KNRI11
VVAR3 4%
RAIL3
BBRC11
WIZS3
3%
BBRC11
WIZS3
MFII11
2%
RAIL3
BIDI11
MXRF11 2%
VVAR3
VNQ
2%
KNRI11
IAU IVVB11
1%
DIS IRBR3
2%
TSLA GRND3
0% KL
AMZ 1% 1
GOOGL
AAPL MDIA3
FACEBOOK 7%
BRK
NOBL
SQIA3 ITSA3
3% EGIE3 EZTC3 8%
NFLX XPML11
VNQ
2%
KNRI11
IAU IVVB11
1%
DIS IRBR3
2%
TSLA GRND3
0% KL
AMZ 1% 1
GOOGL
AAPL MDIA3
FACEBOOK 7%
BRK
NOBL
SQIA3 ITSA3
3% EGIE3 EZTC3 8%
3%XPML11
NFLX XPLG11
HGLG11
KO 2% 2% 2% 1%
SPY
TAEE3
BCFF11
KLBN4
ITSA3
EZTC3
XPLG11
HGLG11
XPML11
EGIE3
SQIA3
MDIA3
GRND3
IRBR3
IVVB11
KNRI11
VVAR3
RAIL3
WIZS3
BBRC11
MFII11
BIDI11
MXRF11
VNQ
IAU
DIS
TSLA
AMZ
GOOGL
AAPL
FACEBOOK
BRK
NOBL
MXRF11
VNQ
IAU
DIS
TSLA
AMZ
GOOGL
AAPL
FACEBOOK
BRK
NOBL
NFLX
KO
SPY

You might also like