Brokerage charges and Effective BUY SELL price

The following sheet is useful in determining the price at which one should exit a particular scrip in order to realize the effective rate as entered. What I mean essentially is when we buy a scrip there are charges we pay because of which the effective buy price goes up and when we sell the effective sell price goes down. In order to calculate the effective sell price, you should enter the desired rate in cell C5 and press the Calculate button.

The brokerage charges that I have accounted for in the sheet are as follows

1. Brokerage at 0.3% on value of trade [Change cell C4]
2. Service tax at 10% on brokerage charged [Change cell C12]
3. Education cess +other tax at 3% on service tax [Change cell C13]
4. Exchange levy charges @.00357% of value [Change cell C14]
5. Transaction tax @ 0.125% on value rounded to nearest integer [Change cell C15]
6. Stamp duty @.01% on value [Change cell C16]
7. Demat Debit charges [Change cell C32]

The Cell E10 will give you the effective sell price in order to realize the effective desired rate of return.

Cell E13 gives the nominal price exclusive of brokerage at which you should cell to realize the desired rate of return.

You can view the excel file Here

Hope the sheet helps you!!