How to calculate the gain

prasadrmb · 1 How to calculate the gain Wed Aug 17, 2011 4:47 pm

prasadrmb

Manager - Equity Analytics

Posts : 252
Equity Stars : 5205
Reputation : 41
Join date : 2011-04-19
Location : Anuradapura

what are the methods which can be used to calculate the gain after selling a stock. (for that particular period)

Hiru · 2 Re: How to calculate the gain Wed Aug 17, 2011 5:27 pm

Hiru

Manager - Equity Analytics

Posts : 274
Equity Stars : 5126
Reputation : 31
Join date : 2011-04-24

If you are new, I would like to share my way of doing it.

Have these accounts in an Excel sheet. And have a defined performance evaluation period like 6 months or one year.

1.Cash/Margin account-debit what ever amount you introduce to the market. Credit what ever you withdraw.

2. Investment account-This contains all purchases and disposals at the transaction value.

4. Gain/Loss account- Debit cost of sales and credit net sales value, account will automatically find the gain or loss. You can track the dividends by crediting here and debiting to cash.

5. Capital account-Credit what ever amount you introduce to the market.Debit what ever you withdraw

6.Trial balance will provide you the picture of your business.

If you are not an accounting guy, let me give your email I would forward the excel sheet.

_

rukaa · 3 Re: How to calculate the gain Wed Aug 17, 2011 5:33 pm

rukaa

Senior Equity Analytic

Posts : 52
Equity Stars : 4777
Reputation : 8
Join date : 2011-07-08

hiru send me a demo pl......

pathum · 4 Re: How to calculate the gain Wed Aug 17, 2011 5:41 pm

pathum

Equity Analytic

Posts : 47
Equity Stars : 4865
Reputation : 0
Join date : 2011-03-05

It would be really great if you can share a copy with me too as I am a total novice to Financial accounting. Smile

Hiru · 5 Re: How to calculate the gain Wed Aug 17, 2011 5:43 pm

Hiru

Manager - Equity Analytics

Posts : 274
Equity Stars : 5126
Reputation : 31
Join date : 2011-04-24

[quote="rukaa"]hiru send me a demo pl......[/quo

Donot know how to upload........if found a way,i would upload.

maalinda · 6 Re: How to calculate the gain Wed Aug 17, 2011 6:26 pm

maalinda

Manager - Equity Analytics

Posts : 254
Equity Stars : 5146
Reputation : 15
Join date : 2011-01-27

upload the excel sheet ( example ) to mediafire or sendspace and post the link here.

Hiru · 7 Re: How to calculate the gain Wed Aug 17, 2011 7:40 pm

Hiru

Manager - Equity Analytics

Posts : 274
Equity Stars : 5126
Reputation : 31
Join date : 2011-04-24

maalinda wrote:upload the excel sheet ( example ) to mediafire or sendspace and post the link here.

http://www.mediafire.com/myfiles.php

yathi · 8 Re: How to calculate the gain Wed Aug 17, 2011 8:22 pm

yathi

Stock Trader

Posts : 1
Equity Stars : 4641
Reputation : 0
Join date : 2011-08-17

Hiru wrote:

maalinda wrote:upload the excel sheet ( example ) to mediafire or sendspace and post the link here.

http://www.mediafire.com/myfiles.php

Link doesn't work. says 'no files found'.

Hiru · 9 Re: How to calculate the gain Wed Aug 17, 2011 8:34 pm

Hiru

Manager - Equity Analytics

Posts : 274
Equity Stars : 5126
Reputation : 31
Join date : 2011-04-24

http://www.mediafire.com/?l5yx25hoezp4moe

invest-abc · 10 Re: How to calculate the gain Wed Aug 17, 2011 9:18 pm

invest-abc

Manager - Equity Analytics

Posts : 283
Equity Stars : 5226
Reputation : 35
Join date : 2011-01-31
Location : Colombo

prasadrmb wrote:what are the methods which can be used to calculate the gain after selling a stock. (for that particular period)

Just keep it simple;

1st Step : Profit = (Selling Price*Qty - Commission Paid) - (Buying Price*Qty + Commission Paid)
2nd Step : Per Annum return = (Profit / No: of days the investment is held)*365

In general if the p.a return is less than 9% I consider that investment as a failure since it's less risky to invest in a FD.

wmdcf · 11 Re: How to calculate the gain Thu Aug 18, 2011 9:09 am

wmdcf

Manager - Equity Analytics

Posts : 126
Equity Stars : 6044
Reputation : 17
Join date : 2011-01-29

invest-abc wrote:

prasadrmb wrote:what are the methods which can be used to calculate the gain after selling a stock. (for that particular period)

Just keep it simple;

1st Step : Profit = (Selling Price*Qty - Commission Paid) - (Buying Price*Qty + Commission Paid)
2nd Step : Per Annum return = (Profit / No: of days the investment is held)*365

In general if the p.a return is less than 9% I consider that investment as a failure since it's less risky to invest in a FD.

Lets say if I have 1000 shares taht I brought in different price levels, And I sold 500, How can I know the actual buying price??

prasadrmb · 12 Re: How to calculate the gain Thu Aug 18, 2011 4:54 pm

prasadrmb

Manager - Equity Analytics

Posts : 252
Equity Stars : 5205
Reputation : 41
Join date : 2011-04-19
Location : Anuradapura

thank you for the help

invest-abc · 13 Re: How to calculate the gain Thu Aug 18, 2011 6:00 pm

invest-abc

Manager - Equity Analytics

Posts : 283
Equity Stars : 5226
Reputation : 35
Join date : 2011-01-31
Location : Colombo

wmdcf wrote:

invest-abc wrote:

prasadrmb wrote:what are the methods which can be used to calculate the gain after selling a stock. (for that particular period)

Just keep it simple;

1st Step : Profit = (Selling Price*Qty - Commission Paid) - (Buying Price*Qty + Commission Paid)
2nd Step : Per Annum return = (Profit / No: of days the investment is held)*365

In general if the p.a return is less than 9% I consider that investment as a failure since it's less risky to invest in a FD.

Lets say if I have 1000 shares taht I brought in different price levels, And I sold 500, How can I know the actual buying price??

eg :

LGL - 100@38 = 3,800
- 100@40 = 4,000
- 800@42 = 33,600

Therefore your weight average buying price will be - (3,800 + 4,000 + 33,600) / 1000 = 41.4
So at the end of the day you have purchased LGL 1,000 @ 41.40
Total Cost = (1,000*41.40*1.0112)