Investing tracker (template).xlsx

	A	C	D	G	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG
1	2024 Portfolio - Sample
2
3	Gain / Loss	Ticker	Type	Entry Date	Strike	Collateral - initial	Collateral - BoY	Current Price	Break even	Variance over b/e	Variance over b/e %	Expiry/close	Days to expiry	1	2	3	4	5	6	7	8	9	10	11	12	Total income	Return on cash	Basis - EoY	Notes

38		BAC	Call option	6/26/24	22.50	300	300	63.04	39.00	24.04	38.13%	Aug-2	-762							100						$ 100	33.3%	$ 200
39		BAC	100	6/25/24	45.00	4,130	4,130	63.04	45.30	17.74	28.14%	Aug-2	-762						50	30	370					$ 450	10.9%	$ 3,680
40		BAC	Sold Put	7/2/24	40.00	4,000	4,000	63.04	57.63	5.41	8.58%	Aug-9	-755					340	50	20						$ 410	10.2%	$ 3,590
51		Brokerage fees & margin interest												-10	-5	-5	-23	-44	-5	-5	0	0	0	0	0	$ (98)		$ 98
52		Interest & other income												2	7	34	0	0	51	46	0	0	0	0	0	$ 139		$ (139)
61
62
63														$ 650	$ 632	$ 997	$ 3,240	$ 2,876	$ 4,163	$ 1,445	$ 370	$ -	$ -	$ -	$ -	$ 14,374	Total cash generated
64														$ 50,000	$ 50,000	$ 50,000	$ 50,000	$ 50,000	$ 50,000	$ 52,000	$ 52,000	$ 52,000	$ 52,000	$ 52,000	$ 52,000	$ 52,000	Estimated net cash
65														1.30%	1.26%	1.99%	6.48%	5.75%	8.33%	2.78%	0.71%	0.00%	0.00%	0.00%	0.00%	27.64%	Returns (goal 2% - 5% on cash)
66														15.60%	15.18%	23.93%	77.76%	69.02%	99.92%	33.35%	8.54%	0.00%	0.00%	0.00%	0.00%		Returns (annualized)
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152