Olá!

Este é o Trading Journal elaborado pelo Doc.

Antigamente ele era uma planilha meio sem "estilo

Eu tentei colocar uma estética didática nela. Espero

Para entendê-la:

🔶Não bloqueei as células que não podem ser m

🔶 Células que podem e devem ser modificadas t

Se encontrarem algo errado ou tiverem alguma sug

Atenciosamente,

Adriana
 pelo Doc.

io sem "estilo" , cheia de cáculos bacanas, mas "mal vestida".

a nela. Espero que gostem.

o podem ser modificadas mas elas têm estas cores:

modificadas têm a cor bege:

m alguma sugestão para melhorá-la me enviem um email por favor!

stida".

il por favor!
 Accounts
2020 Initial Balance Final Balance
Month Account 1 Account 2 Total Account 1 Account 2 Total
$0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0

ROI #DIV/0!

Trades
Nº Trades Valor Médio Ratio between profit and lo
W 75 $ 104
L 19 $ 259
Total 94

Kelly Formula (Modified to trade-in analysis and

Prob. WIN In this example:

(Realized) Prob. LOSS
(Realized) 67% POP = credit normal received w
Ex: 100-110 Bull Put Spread collecti

f* 75%

=𝒑/𝒂−𝒒
/𝒃
 f* 25%
=𝒑/𝒂−𝒒 68%

Incremental
/𝒃 Incremental f
32%
32.17%
Loss Gain f/2 16%
f/3 11%

Kelly considering the payouts in a Vertical Spread

((POP x (b+1))-1)/b ⋙ ONDE POP=Probalilidade de Lucro;
b=(Lucro Máximo/Perda Máxima)

POP 75% b Kelly

IDEAL Win 3 43% 17%
Payout
Loss 7

POP 80% b Kelly

Simul. Win 5 167% 68%
Payout
Loss 3
 PL
PL % SP500 Dow Nasdaq Russell 2000 Bovespa
Amount
$0.00 #DIV/0!
$0.00 #DIV/0!
$0.00 #DIV/0!
$0.00 #DIV/0!
$0.00 #DIV/0!
$0.00 #DIV/0!
$0.00 #DIV/0!
$0.00 #DIV/0!
$0.00 #DIV/0!
$0.00 #DIV/0!
$0.00 #DIV/0!
$0.00 #DIV/0!

Total #DIV/0!

Win Probalility - W 80% Win Prob 0.798

tio between profit and loss - R 40% P/L ($) 0.402
Kelly % - K 29% Expected 0.118
KELLY 29%
K = W/1-(1-W)/R K/2 15%
K/3 10%

-in analysis and bets)

credit normal received when we short a vertical spread

0 Bull Put Spread collecting US$ 3,33 per contract
 pb qa pb>qa
24.0% ### YES

a Vertical Spread
 % Theta Vc Net Liq
Valor 1% 0.50% 0.25% 0.10%
$ 20,000 200 100 50 200
$ 50,000 500 250 125 50
$ 100,000 1000 500 250 100
$ 200,000 2000 1000 500 200
$ 500,000 5000 2500 1250 500
$ 1,000,000 10000 5000 2500 1000
$ 2,000,000 20000 10000 5000 2000
$ 5,000,000 50000 25000 12500 5000

Consider here that we keep x% of Theta (managing

early for example)
30% 1% 0.50% 0.25% 0.10%
$ 20,000 $ 60 $ 30 $ 15 $ 60
$ 50,000 $ 150 $ 75 $ 38 $ 15
$ 100,000 $ 300 $ 150 $ 75 $ 30
$ 200,000 $ 600 $ 300 $ 150 $ 60
$ 500,000 $ 1,500 $ 750 $ 375 $ 150
$ 1,000,000 $ 3,000 $ 1,500 $ 750 $ 300
$ 2,000,000 $ 6,000 $ 3,000 $ 1,500 $ 600
$ 5,000,000 $ 15,000 $ 7,500 $ 3,750 $ 1,500
Strategy or Trade-In Trade-In
UL IVR IV Type
Event Date Price

SWEET-67 17-Aug-20 ADI $110.97 13.2 21.6% Naked Call

 Preço de Perda
Max Profit Max.
Strikes # Contracts Abertura por Máxima =
Contrato Estimado Loss
BPR
120 5 ($0.80) ($400) $520 ∞

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0
$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0
$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0
$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

$0 $0

#REF! $0

#REF! $0

#REF! $0

#REF! $0

#REF! $0

#REF! $0

#REF! $0

#REF! $0

#REF! $0

#REF! $0

#REF! $0

#REF! $0

#REF! $0

#REF! $0
#REF! $0

#REF! $0

#REF! $0
 Objetivo de Valor AJUST
Lucro Esperado para Manejo Manejo
(%Max Profit) Fechamento Situação
Ação (1) Valor Ação (2)
1) Lucro longe da
30% $1.04 meta
Rolagem p/ venc mensal

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00
$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00
$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00
 $0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

#REF! #REF!

#REF! #REF!

#REF! #REF!

#REF! #REF!

#REF! #REF!

#REF! #REF!

#REF! #REF!

#REF! #REF!

#REF! #REF!

#REF! #REF!

#REF! #REF!

#REF! #REF!

#REF! #REF!

#REF! #REF!
#REF! #REF!

#REF! #REF!

#REF! #REF!
 AJUSTES
Manejo Manejo Manejo Manejo
Valor Ação (3) Valor Ação (4) Valor Ação (5) Valor
$0 #DIV/0!

$0 #DIV/0!

$0 #DIV/0!

$0 #DIV/0!

$0 #DIV/0!

$0 #DIV/0!

$0 #DIV/0!

$0 #DIV/0!

$0 #DIV/0!

$0 #DIV/0!

$0 #DIV/0!

$0 #DIV/0!

$0 #DIV/0!

$0 #DIV/0!
$0 #DIV/0!

$0 #DIV/0!

$0 #DIV/0!
 Vencimento Data p/ fazer
Profit / Vencimento
Fechamento P/L % da Última a Rolagem
Loss Original
Rolagem (22 DTE)
$ 440.00 $ 40.00 10.0% 25-Sep-20 16-Oct-20 -

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!
$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!
$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!
 $ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

$ - #DIV/0!

TOTAL P/L $ 40.00

 Data do
OBSERVAÇÃO
Fechamento

10-Sep-20
Strategy or Trade-In Trade-In
UL IVR IV Type
Event Date Price

SWEET-67 17-Aug-20 NCLH $15.75 26.2 99.1% STG

EARNING 17-Aug-20 KSS $15.00 35 80.0% IC

EARNING 25-Aug-20 PSTG $98.00 46.4 76.7% IC

SWEET-67 26-Aug-20 AMD $86.40 23.1 56.3% TA-PUT

EARNING 22-Sep-20 SFIX $30.00 46.3 97.8% STG

EARNING 22-Sep-20 NKE $116.00 23.9 40.6% IC

EARNING 29-Sep-20 MU $51.00 25.1 60.3% TA-PUT

EARNING 30-Sep-20 BBBY $15.20 32.6 105.4% STG

EARNING 19-Oct-20 IBM $126.00 23.6 33.0% BWB-PUT

 Preço de Objetivo de
Financeiro Max.
Strikes # Contracts Abertura por BPR Lucro
Contrato da Posição Loss (%Max Profit)

13,5 - 20 1 $0.97 $97 ∞ $170 40%

19-21-27-29 1 $0.67 $67 $133 $133 50%

12,5-15-17,5-20 1 $0.98 $98 $152 $152 25%

82,5-85 1 $1.12 $112 $138 $138 50%

26-35 1 $1.67 $167 ∞ $953 40%

103-108-122-127 1 $1.25 $125 $375 $375 20%

51,5-54,5 1 $1.96 $196 $104 $104 50%

13-17,5 1 $0.53 $53 ∞ $514 15%

116-121-122 1 $1.01 $101 $299 $299 30%

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0
$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0
$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0
$0

$0

$0

$0

$0

$0

$0

$0

$0

$0
 Valor AJUSTES
Esperado para Manejo Manejo
Fechamento Situação
Ação (1) Valor Ação (2) Valor
1) Lucro longe da
($0.58) meta em 22 DTE
Rolagem p/ venc mensal $ 65.00

1) Spot no meio da Rolagem Trava PUT p/

($0.34) Trava PUT do IC.
Encerrar Trava CALL $ -5.00
Set-20 (Mensal)
$-10.00

1) Spot perto da Short Aguardar 1-2 dias a volta do

($0.74) Put spot e fechar o trade c/ lucro.
1) Spot caiu e passou Rolar a trava p/ Out no Rolar a trava p/ Nov-20 no
($0.56) a Long Put. mesmo strike.
$ -8.00
mesmo strike.
$-25.00

($1.00)
1) Spot explodiu e Roll Strike Up da Trava
($1.00) passou a trava
Rolar a Trava Call (Out/20) $ -43.00
PUT (Out/20) → IF
$105.00

1) Spot Caiu não Rolagem abrindo a asa de

($0.98) alcançando a TA
Rolagem p/ venc 9DTE $ 33.00
3,5 para 5.
$ 24.00

1) Spot explodiu e Inversão do STG, rolando Rolagem de strikes (19-25)

($0.45) passou a Short Call para Nov (mensal)
$417.00 $119.00

Spot caiu e passou a

($0.71) long
Close da Asa+Fechada $ 85.00 Rolagem da Asa + Aberta $-15.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00
$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00
$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00
$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00

$0.00
AJUSTES
Manejo Manejo Manejo Fechamento
Ação (3) Valor Ação (4) Valor Ação (5) Valor
$ -109.00
Rolagem do IF p/ Out/20
Trava de baixa CALL ∴ IF $98.00
(mensal)
$ 15.00 $ -180.00

$ -78.00
Inserir uma Trava de Baixa
CALL (+cr) → IF.
$65.00 $ -130.00

$ -86.00
Rolagem do IF p/ Nov/20
(mensal)
$37.00 $ -210.00

$ -193.00
Rolagem de strikes (20-27)
$26.00 $ -600.00

Trava de baixa CALL ∴ IF $30.00 $ -170.00

TOTAL P/L
 Vencimento Data p/ fazer
Profit / P/L % P/L % Vencimento Data do
da Última a Rolagem
Loss (Cr Rec) (BPR) Original Fechamento
Rolagem (22 DTE)
$ 53.00 54.6% 31.2% 25-Sep-20 16-Oct-20 - 10-Sep-20

$ -15.00 -22.4% -11.3% 28-Aug-20 16-Oct-20 - 24-Sep-20

$ 20.00 20.4% 13.2% 18-Sep-20 - - 27-Aug-20

$ 14.00 12.5% 10.1% 18-Sep-20 20-Nov-20 29-Oct-20

$ 81.00 48.5% 8.5% 25-Sep-20 - - 23-Sep-20

$ 14.00 11.2% 3.7% 25-Sep-20 20-Nov-20 29-Oct-20

$ 60.00 30.6% 57.7% 02-Oct-20 20-Nov-20 - 22-Oct-20

$ 15.00 28.3% 2.9% 02-Oct-20 20-Nov-20 29-Oct-20

$ 31.00 30.7% 10.4% 13-Nov-20 20-Nov-20 29-Oct-20

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!
$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!
$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!
$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ - #DIV/0! #DIV/0!

$ 199.00
 OBSERVAÇÃO

Aguardar para fechar próximo ao vértice da

borboleta. 0 X 0.

Se for rolar por débito, melhor aguardar a volta do

spot! Ou cria um IF. Até 25/09.

Rolar IF p/ Nov
 Calendars and Diagonals P/L

Trade in
UL Type Price MaxProf
Date
EXAMPLE x IWM PMCP 02-Jan-20 ($653) $547

1
2
3
4
5
6
7
8
9
10
 Include here PMCP and PMCC

Rolls (n) Roll $ Trade out Amount Com+Fee Net Profit

0 $0.00 27-Jan-20 $705 ($2.59) $49.41

$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Net Profit %%MaxProfit

8% 9%

#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
 OBS

fechei logo pois o mercado estava muito ruim para ficar com trade de vies bearish
 Calendar Spreads
UL UL Type Trade in
Price C/P SPOT IVR IV Date
EXAMPLE UAL $89 C $89.19 45.2 30.4 16-jan-20
EXAMPLE
 Short Long # Trade-in Roll 1
Fees
Price DTE Preço DTE Contracts Cost Date Amount
$1.71 Feb ($2.90) Apr ($5) 5 -$600 ($15)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
 Roll 2 Roll 3 Roll 4 Roll 5 Tr
Date Amount Date Amount Date Amount Date Amount SPOT
$125 $351 $28 $24 xxxx
 Trade-out Trade out P/L Final
P/L (%)
IVR IV Data Valor $
xxx xxx xxx $250 $163 27%
$0 #DIV/0!
$0 $0.00
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
$0 #DIV/0!
 Poor Man Covered Put

# Date LONG ITM

Stock SPOT IVR IV
Contracts
trade-in Expiration Strike Price
EXAMPLE QQQ $202.63 0.6 14 2 107 dias $215 ($14.22)
Poor Man Covered Call

# Date LONG ITM

Stock SPOT IVR IV
Contracts
trade-in Expiration Strike Price
 SHORT OTM Custo / Total Cost Dif. 25% profit
OTM Ext Fees 75% Max Debit Max Profit
cont (financ) Strikes sale price
Expiration Strike Price
44 dias $195 $2.38 $340.00 ($4.57) ($11.84) 59.20% ($2,368) $20 $2,960 $1,632
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
 SHORT OTM Custo / Total Cost Dif. 25% profit
OTM Ext Fees 75% Max Debit Max Profit
cont (financ) Strikes sale price
Expiration Strike Price
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
$0.00 #DIV/0! $0 $0 $0 $0
 Roll 1 Roll 2 Roll 3 Trade-out
Max Loss P/L ($) Net%
Date Amount Date Amount Date Amount Date Amount
30-Dec-19 $220 30-Dec-19 $112 11-Feb-20 $300 $2,960 ($1,736) $1,229 51.88%
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
 Roll 1 Roll 2 Roll 3 Trade-out
Max Loss P/L ($) Net%
Date Amount Date Amount Date Amount Date Amount
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
$0 $0 #DIV/0!
Net %
max
Profit
75.28%
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Net %
max
Profit
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Transactionm Date Amount Fórmulas para consulta
Beginning Value 01-Jan-19 ($200,000) Juros compostos (pagamento mensal de juros)
Total Deposit 01-Mar-19 ($2,200) CAGR = Taxa de Juros Anuais (composto)
Total Withdraw 01-May-19 $1,000 PV = Valor Presente
Ending Value 31-Dec-19 ($300,000) FV = Valor Futuro
R e CAGR Taxas de Juros Anuais

Retorno Anual 3%

Deposit Withdraw Exemple

January $2,200 $1,000 Cumulative Rate
February $0 $0 PV
March $0 $0 FV
April $0 $0 Y
May $0 $0 CAGR
June $0 $0
July $0 $0 Exemple
August $0 $0
September $0 $0 Present Value
October $0 $0
November $0 $0
December $0 $0 Exemple

Future Value
Fórmulas para consulta
s (pagamento mensal de juros)
de Juros Anuais (composto)
sente
uro
as de Juros Anuais

Money to Invest $100,000

A B (best invest)
$100,000 $100,000
$124,000 $140,000
3 4
7.43% 8.78%

Promise to Pay $125,971

In Years 3
Rate 8%
PV $100,000

PV $100,000
In Years 3
Rate 8%
FV $125,971
 Loan Information
Principal $100,000 dollars Total Payment
Loan Term 10 years
Interest Rate 5% APR Total Interest
Installments 12 payments per year
Payment $1,061 monthly Total Rate

Month Loan Balance Payment Interest Principal

1 $100,000 ($1,061) ($417) ($644)
2 $99,356 ($1,061) ($414) ($647)
3 $98,709 ($1,061) ($411) ($649)
4 $98,060 ($1,061) ($409) ($652)
5 $97,408 ($1,061) ($406) ($655)
6 $96,753 ($1,061) ($403) ($658)
7 $96,096 ($1,061) ($400) ($660)
8 $95,435 ($1,061) ($398) ($663)
9 $94,772 ($1,061) ($395) ($666)
10 $94,107 ($1,061) ($392) ($669)
11 $93,438 ($1,061) ($389) ($671)
12 $92,767 ($1,061) ($387) ($674)
13 $92,093 ($1,061) ($384) ($677)
14 $91,416 ($1,061) ($381) ($680)
15 $90,736 ($1,061) ($378) ($683)
16 $90,053 ($1,061) ($375) ($685)
17 $89,368 ($1,061) ($372) ($688)
18 $88,680 ($1,061) ($369) ($691)
19 $87,988 ($1,061) ($367) ($694)
20 $87,294 ($1,061) ($364) ($697)
21 $86,597 ($1,061) ($361) ($700)
22 $85,898 ($1,061) ($358) ($703)
23 $85,195 ($1,061) ($355) ($706)
24 $84,489 ($1,061) ($352) ($709)
25 $83,781 ($1,061) ($349) ($712)
26 $83,069 ($1,061) ($346) ($715)
27 $82,354 ($1,061) ($343) ($718)
28 $81,637 ($1,061) ($340) ($721)
29 $80,916 ($1,061) ($337) ($724)
30 $80,193 ($1,061) ($334) ($727)
31 $79,466 ($1,061) ($331) ($730)
32 $78,737 ($1,061) ($328) ($733)
33 $78,004 ($1,061) ($325) ($736)
34 $77,269 ($1,061) ($322) ($739)
35 $76,530 ($1,061) ($319) ($742)
36 $75,788 ($1,061) ($316) ($745)
 $127,279

$27,279

27%

Loan Balance
$99,356
$98,709
$98,060
$97,408
$96,753
$96,096
$95,435
$94,772
$94,107
$93,438
$92,767
$92,093
$91,416
$90,736
$90,053
$89,368
$88,680
$87,988
$87,294
$86,597
$85,898
$85,195
$84,489
$83,781
$83,069
$82,354
$81,637
$80,916
$80,193
$79,466
$78,737
$78,004
$77,269
$76,530
$75,788
$75,043
 Annuities - Exemple of a tes

You’re one of the five lucky people who found a mystery message a

You can choose one of the following prizes:

a) $200,000 now
b) $360,000 five years from now
c) $22,800 a year, forever
d) 38,000 for each of ten yea$rs
e) $13,000 next year, and increasing thereafter by 5% per year.

If the discount rate is 12%, which prize offers the highest present value?
PV
a) $200,000.00 money now
b) $204,273.67 FV and PV formula
c) $190,000.00 constant perpetuity formula
d) $214,708.48 Here you have to calculate the annuity factor

Year 1 2 3 4
Discount Factor 0.8928571429 0.7971938776 0.7117802478 0.6355180784

e) 185714 Growing perpetuity formula

Answer D gives us the highest present value.

ies - Exemple of a test for students

und a mystery message at the bottom of a recently purchased can of soda.

esent value?

Annuity
5 6 7 8 9 10
factor
0.5674268557 0.5066311212 0.4523492153 0.403883228 0.36061 0.3219732366 5.6502230284
 BONDS
Annual Coupon
Par $100
Coupon 8.50%
YTM 7.00%

Time FV DF PV
1 $8.50 $0.93 $7.94
2 $8.50 $0.87 $7.42
3 $108.50 $0.82 $88.57
Traded at premium $103.94

BONDS
Semi-annual coupon
Time FV DF PV
1 $4.25 $0.97 $4.11
2 $4.25 $0.93 $3.97
3 $4.25 $0.90 $3.83
4 $4.25 $0.87 $3.70
5 $4.25 $0.84 $3.58
6 $104.25 $0.81 $84.81
Traded at premium $104.00
Bonds Corporativos Investimento Total

Bond # Buy Date Settlement Marginable CUSIP

EXAMPLE 1 19-mar-20 23-mar-20 YES 71654QAX0
EXAMPLE 2 19-mar-20 23-mar-20 YES 71647NAQ2

1
2
3
4
5
6
7
8
9
10

Bond # Settlement Maturity Coupon YTM

EXAMPLE 1 23-mar-20 21-jan-21 5.50% 14.05%
EXAMPLE 2 23-mar-20 23-mai-26 8.75% 9.13%

1 30-dez-99 30-dez-99 0.00% 0.00%

2 30-dez-99 30-dez-99 0.00% 0.00%
3 30-dez-99 30-dez-99 0.00% 0.00%
4 30-dez-99 30-dez-99 0.00% 0.00%
5 30-dez-99 30-dez-99 0.00% 0.00%
6 30-dez-99 30-dez-99 0.00% 0.00%
7 30-dez-99 30-dez-99 0.00% 0.00%
8 30-dez-99 30-dez-99 0.00% 0.00%
9 30-dez-99 30-dez-99 0.00% 0.00%
10 30-dez-99 30-dez-99 0.00% 0.00%
Investimento Total $0.00

Company Maturity Date Buy Price Shares Numb Bonds $ FINAL

PEMEX 21-jan-21 $93.51 $10,000 10 $9,445.42
Petrobras 23-mai-26 $98.22 $30,000 30 $30,340.10

Face value Frequency Price Duration

100 2 $ 93.51 0.8139
100 2 $ 98.22 4.7436

Err:502 Err:502
Err:502 Err:502
Err:502 Err:502
Err:502 Err:502
Err:502 Err:502
Err:502 Err:502
Err:502 Err:502
Err:502 Err:502
Err:502 Err:502
Err:502 Err:502
Coupon YTM Duration CoupPay Dates
5.50% 14.05% 0.8139 2x / year Jan-Jul
8.75% 9.13% 4.7436 2x / year May-Nov
0.0000
Err:502
Err:502
Err:502
Err:502
Err:502
Err:502
Err:502
Err:502
Err:502
Err:502
 OBS
PETROLEOS MEXICANOS BOND CALL MAKE WHOLE
PETROBRAS GLBL FIN B V NOTE
 YTM and Price Move in Bonds Rate Price
Point of View Bond Issuer 4% $16,952.18
Face Value (FV) $10,000 5% $14,636.30
Maturity 30 6% $12,767.56
N (number of payments/year) 2 7% $11,247.24
Coupon Rate 8% 8% $10,000.00
Coupon Rate/n 4% 9% $8,968.10
Semi-annual coupon payment $400 10% $8,107.07
Total # of Coupon Payments 60 11% $7,382.52
YTM/n 2.5% 12% $6,767.71
YTM % 5% 13% $6,241.76
Bond price (PV) 14% $5,788.25
15% $5,394.22
$18,000.00 Bond Price Vs Yield
$16,000.00

$14,000.00

$12,000.00

$10,000.00

$8,000.00

$6,000.00

$4,000.00

$2,000.00

$0.00
4% 5% 6% 7% 8% 9% 10% 11% 12% 13% 14% 15%