how to calculate brokerage in execl

A

anees_a

hi i am trying to calculate brokerage for trading stocks intra day and
delivery
Intra day
1) for every 100Rs i am charged 0.05% for intraday brokerage
2) and Service tax of 10.3% on brokrage
3)jobbing charges on turnover 0.0052%
4)Service transation charge of 0.025% on turnover on selling in intraday

Delivery
1) for every 100Rs i am charged 0.5% for intraday brokerage
2) and Service tax of 10.3% on brokerage
3)jobbing charges on turnover 0.0132%
4)Service transaction charge of 0.125% on turnover on selling in intraday

for ex

i purchase XYZ stock for 1000 qty for 55rs how do i calculate these in excel
on 2 separate sheets or a single wher if i give I(intraday or D( Delivery)
charges are calculated and i know my break even
 
Top