TITLE: Question - Dealing with Commissions and Annual Expenses
Hi Guys/Gals,
I'm drafting my own spreadsheet for AIM use (I know I can download them, but by me doing my own I'll get to learn better). I'm pretty sure you guys have had this discussed to ad nauseum, but please bear with me because I'm a little confused and can't search the forum to find the answer. I just want to pick your brains to see if how I'm doing it is kosher with the more experienced AIM users.
My understanding is this: *Please tell me if I'm doing it wrong*
Commissions:
$10 commissions per trade and I'm buying 100 shares @ $7 per share which totals to $710 with commissions included. Now I'd be adding $350 to Portfolio Control, $700 to Stock Value and subtracting $710 from Cash.
Annual Expenses:
Say an ETF charges 0.4%. If I have $1000 that means it's a fee of $4 per year, now I'd deduct the $4 annually from the CASH without touching any other variables?
Thanks again and looking forward to your replies.
I'm writing down my ETF questions in my little notebook as I come up with them and will be posting them on this forums to ask you all (Joy, right?). Take care!
