Dear All,
Hope you guys are doing well and fine. Basically I am trying to make an excel ledger for stocks. It works like this
1. Suppose if I buy a security let's say "MEBL" or "IMAGE" and if I sell it same day the following commission taxes would be charged on buying only not selling, technically once sided commission and taxes as Commission, FED.
2. If I sell the security same day only one sided commission and taxes will be charged but if I make a profit (selling price is more than buying price) CGT would be charged at13% on profit only and nothing will be charged on loss.
3. If I sell the same security the next day it is known as roll over and then two sided commission will be charged. Same commission slab.
4. In case of roll over roll over charges will be applied given under the roll over charges slab on per day basis like this no. of shares x price x roll over charges
5. If I sell the same security the next day and I make a profit, commission, taxes and roll over charges will apply along with CGT on the differential amount from (Selling Price - Buying Price) but if I don't make any profit and sell it at breakeven or loss CGT will not be charged but commission and taxes will still apply along with roll over charges.
I am trying to use nested formula but couldn't succeed, the formula which doesn't fulfils all the conditions I have used and somehow it works for only one condition, the formula is =IF(J12<20,I12*0.03,K12*0.15%).
I'll be highly obliged if someone can help me out in this.
Screen shot attached and excel file for reference.
Warm regards,
Asad
Bookmarks