PLANILHA DE CONTROLE DE COMPRA E VENDA DE AÇÕES v1.2 - POR CROS, ADAPT
CORRETAGEM BB = Emolumentos = R$ 20.00 0.035% TOTAL MOVIMENTADO = TOTAL CORRETAGEM = TOTAL DE DIAS POSICIONADO =
COMPRA
ATIVO QTD BMEF3 100 VALE5 200 PETR4 300 BBAS3 100 DATA 23/01/08 23/01/08 21/01/08 26/02/08 PREÇO R$ 13.76 R$ 39.95 R$ 66.03 R$ 27.80 VALOR R$ 1,376.00 R$ 7,990.00 R$ 19,809.00 R$ 2,780.00 CORR R$ 20.00 R$ 20.00 R$ 20.00 R$ 20.00 EMOL R$ 0.48 R$ 2.80 R$ 6.93 R$ 0.97 TOTAL R$ 1,396.48 R$ 8,012.80 R$ 19,835.93 R$ 2,800.97 QTD 100 200 300 100 DATA 22/02/08 07/04/08 28/02/08 06/03/08
VE
TOTAL
700
-
-
R$ 31,955.00
R$ 80.00
R$ 11.18
R$ 32,046.18
700
-
V1.2: Corrigido valor total de venda, reduzindo o valor de corretagem + emolumentos.
DE AÇÕES v1.2 - POR CROS, ADAPTADA DA DE GREEN, MOTIVADO POR RLAMARCA :D -> FÓRUM INFOMONEY
(A FAZER PARA O MÊS) (A FAZER) L/P BRUTO
CORR R$ 20.00 R$ 20.00 R$ 20.00 R$ 20.00 EMOL R$ 0.67 R$ 3.72 R$ 9.05 R$ 0.97 TOTAL R$ 1,896.33 R$ 10,596.28 R$ 25,839.95 R$ 2,749.03 R$ R$ 541.00 R$ 2,630.00 R$ 6,060.00 (R$ 10.00) % 39.32% 32.92% 30.59% -0.36%
TOTAL MOVIMENTADO = R$ 73,127.77 TOTAL CORRETAGEM = R$ 160.00 OTAL DE DIAS POSICIONADO = VENDA
PREÇO R$ 19.17 R$ 53.10 R$ 86.23 R$ 27.70 VALOR R$ 1,917.00 R$ 10,620.00 R$ 25,869.00 R$ 2,770.00
L/P LÍQUIDO
R$ R$ 499.85 R$ 2,583.49 R$ 6,004.01 (R$ 51.94)
-
R$ 41,176.00
R$ 80.00
R$ 14.41
R$ 41,081.59
R$ 9,221.00
28.86%
R$ 9,035.40
INFOMONEY
L/P LÍQUIDO
% 35.79% 32.24% 30.27% -1.85%
28.19%
ANOS 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
VALOR INVESTIDO R$ 10,000.00 R$ 11,500.00 R$ 13,225.00 R$ 15,208.75 R$ 17,490.06 R$ 20,113.57 R$ 23,130.61 R$ 26,600.20 R$ 30,590.23 R$ 35,178.76 R$ 40,455.58 R$ 46,523.91 R$ 53,502.50 R$ 61,527.88 R$ 70,757.06 R$ 81,370.62 R$ 93,576.21 R$ 107,612.64 R$ 123,754.54 R$ 142,317.72 R$ 163,665.37 R$ 188,215.18 R$ 216,447.46 R$ 248,914.58 R$ 286,251.76 R$ 329,189.53 R$ 378,567.96 R$ 435,353.15 R$ 500,656.12 R$ 575,754.54
% AO ANO 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00% 15.00%
LUCRO AO ANO R$ 1,500.00 R$ 1,725.00 R$ 1,983.75 R$ 2,281.31 R$ 2,623.51 R$ 3,017.04 R$ 3,469.59 R$ 3,990.03 R$ 4,588.53 R$ 5,276.81 R$ 6,068.34 R$ 6,978.59 R$ 8,025.38 R$ 9,229.18 R$ 10,613.56 R$ 12,205.59 R$ 14,036.43 R$ 16,141.90 R$ 18,563.18 R$ 21,347.66 R$ 24,549.81 R$ 28,232.28 R$ 32,467.12 R$ 37,337.19 R$ 42,937.76 R$ 49,378.43 R$ 56,785.19 R$ 65,302.97 R$ 75,098.42 R$ 86,363.18
MESES 1 2 3 4 5 6 7 8 9 10 11 12
VALOR INVESTIDO R$ 10,000.00 R$ 10,500.00 R$ 11,025.00 R$ 11,576.25 R$ 12,155.06 R$ 12,762.82 R$ 13,400.96 R$ 14,071.00 R$ 14,774.55 R$ 15,513.28 R$ 16,288.95 R$ 17,103.39
% AO MêS 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 60.00%
LUCRO AO MÊS R$ 500.00 R$ 525.00 R$ 551.25 R$ 578.81 R$ 607.75 R$ 638.14 R$ 670.05 R$ 703.55 R$ 738.73 R$ 775.66 R$ 814.45 R$ 855.17
R$ 10,000.00 R$ 17,874.24 R$ 27,874.24
100% 178.74%
29.79%