Data entry

Cell B28: 68

Formulas        

Formula for sale of 100 shares at Rs. 68 in Cell B29: =B21*B28

Formula for Commission at 1% in Cell B30: =B29*0.01

Formula for Total Sale in Cell B31: =B29-B30                  

Results

Cell B29 = 6800

Cell B30 = 68

Cell B31 = 6732

GAIN

Formulas        

Formula for Net receipts in Cell B34: =B31

Formula for Total cost in Cell B35: =B25

Formula for Net Gain in Cell B36: =B31-B25

Formula for % Gain in Cell B37: =B36/B35*100

Results

Cell B34 = 6732

Cell B35 = 5277.25

Cell B36 = 1454.75

Cell B37 = 27.57

Previous

TOC

Next