| Sold Amount |
=if(C7=””,”0.00″,C7*C8) |
| Investment |
=if(C9=””,”0.00″,C7*C9) |
| Broker Commission |
=iferror(IF(C10=”Secondary”,IFS(F4 > 10000000,F40.24/100,F4 > 2000000,F40.27/100,F4 > 500000,F40.31/100,F4 > 50000,F40.33/100,F4 > 0,F4*0.36/100),0),0) |
| Sebon Commission |
=IF(C10=”Secondary”,F4*0.015/100,0) |
| DP Charge |
=IF(C10=”Secondary”,25,0) |
| Total Commission |
=sum(F6:F8) |
| CGT Tax |
=if(C4=”Sell”,if((F4-F5-F9)>0,((F4-F5-F9)*7.5/100),0),0) |
| Net Income Investment |
=if(C4=”Sell”,F4-F9-F10,F4+F9) |
| Profit & Loss |
=IF(C4=”Sell”,F11-F5,””) |
| % Profit & Loss |
=IFERROR(I4/F5,0) |
| Net Price Per Share |
=IfError(F11/C7,0) |
