As I mention in the video posting, Trisha is coming back to trading after the Thanksgiving holiday so I made this $500 Options Trading Worksheet for the benefit of all who want to use it. All you need do is to input in the two Blue Columns as you’ll see in the video – the Amount to trade with and the Buy Price of the contracts you are looking to trade.
Everything else is calculated for you; i.e. a predetermined exit idea based on between 20% – 35%, the amount of profit in dollars, and the commissions are already calculated into the trade – both in and out. The commission structure I used was the default for TDAmeritrade: $7.95 for the trade and 0.75 per contract.
Here’s you’re link to the downloadable .xlsx file
$500 / 50Trades Explained
$500 | 50 Trades @ 20%
Trade # | Trade Amount | % Gain * | Profit | Trade + Profit |
1 | $500.00 | 20.00% | $100.00 | $600.00 |
2 | $600.00 | 20.00% | $120.00 | $720.00 |
3 | $720.00 | 20.00% | $144.00 | $864.00 |
4 | $864.00 | 20.00% | $172.80 | $1,036.80 |
5 | $1,036.80 | 20.00% | $207.36 | $1,244.16 |
6 | $1,244.16 | 20.00% | $248.83 | $1,492.99 |
7 | $1,492.99 | 20.00% | $298.60 | $1,791.59 |
8 | $1,791.59 | 20.00% | $358.32 | $2,149.91 |
9 | $2,149.91 | 20.00% | $429.98 | $2,579.89 |
10 | $2,579.89 | 20.00% | $515.98 | $3,095.87 |
11 | $3,095.87 | 20.00% | $619.17 | $3,715.04 |
12 | $3,715.04 | 20.00% | $743.01 | $4,458.05 |
13 | $4,458.05 | 20.00% | $891.61 | $5,349.66 |
14 | $5,349.66 | 20.00% | $1,069.93 | $6,419.59 |
15 | $6,419.59 | 20.00% | $1,283.92 | $7,703.51 |
16 | $7,703.51 | 20.00% | $1,540.70 | $9,244.21 |
17 | $9,244.21 | 20.00% | $1,848.84 | $11,093.06 |
18 | $11,093.06 | 20.00% | $2,218.61 | $13,311.67 |
19 | $13,311.67 | 20.00% | $2,662.33 | $15,974.00 |
20 | $15,974.00 | 20.00% | $3,194.80 | $19,168.80 |
21 | $19,168.80 | 20.00% | $3,833.76 | $23,002.56 |
22 | $23,002.56 | 20.00% | $4,600.51 | $27,603.07 |
23 | $27,603.07 | 20.00% | $5,520.61 | $33,123.69 |
24 | $33,123.69 | 20.00% | $6,624.74 | $39,748.42 |
25 | $39,748.42 | 20.00% | $7,949.68 | $47,698.11 |
26 | $47,698.11 | 20.00% | $9,539.62 | $57,237.73 |
27 | $57,237.73 | 20.00% | $11,447.55 | $68,685.28 |
28 | $68,685.28 | 20.00% | $13,737.06 | $82,422.33 |
29 | $82,422.33 | 20.00% | $16,484.47 | $98,906.80 |
30 | $98,906.80 | 20.00% | $19,781.36 | $118,688.16 |
31 | $118,688.16 | 20.00% | $23,737.63 | $142,425.79 |
32 | $142,425.79 | 20.00% | $28,485.16 | $170,910.95 |
33 | $170,910.95 | 20.00% | $34,182.19 | $205,093.14 |
34 | $205,093.14 | 20.00% | $41,018.63 | $246,111.76 |
35 | $246,111.76 | 20.00% | $49,222.35 | $295,334.11 |
36 | $295,334.11 | 20.00% | $59,066.82 | $354,400.94 |
37 | $354,400.94 | 20.00% | $70,880.19 | $425,281.12 |
38 | $425,281.12 | 20.00% | $85,056.22 | $510,337.35 |
39 | $510,337.35 | 20.00% | $102,067.47 | $612,404.82 |
40 | $612,404.82 | 20.00% | $122,480.96 | $734,885.78 |
41 | $734,885.78 | 20.00% | $146,977.16 | $881,862.94 |
42 | $881,862.94 | 20.00% | $176,372.59 | $1,058,235.53 |
43 | $1,058,235.53 | 20.00% | $211,647.11 | $1,269,882.63 |
44 | $1,269,882.63 | 20.00% | $253,976.53 | $1,523,859.16 |
45 | $1,523,859.16 | 20.00% | $304,771.83 | $1,828,630.99 |
46 | $1,828,630.99 | 20.00% | $365,726.20 | $2,194,357.19 |
47 | $2,194,357.19 | 20.00% | $438,871.44 | $2,633,228.63 |
48 | $2,633,228.63 | 20.00% | $526,645.73 | $3,159,874.36 |
49 | $3,159,874.36 | 20.00% | $631,974.87 | $3,791,849.23 |
50 | $3,791,849.23 | 20.00% | $758,369.85 | $4,550,219.08 |
* After Commissions/Fees
Capital Gains Tax: 39.6% $1,801,688.75
50 Trades | 20% Gains | Profits After Taxes: $2,748,030.32
Portfolio Balance Afterwards $2,748,530.32
Not Bad from $500 Start Huh?