BSEIndia: All Stock Market News: Re: [sharetrading] Average cost of shares and capital gains/loss for 2009-10 for Jaiprakash Associ

Tuesday, February 09, 2010

Re: [sharetrading] Average cost of shares and capital gains/loss for 2009-10 for Jaiprakash Associ

Dear Erfan

If you are serious about developing it in excel and have knowledge of VBA, I have added you in my Yahoo messenger

Please talk online

Shravan

From: efan

Sent: Tuesday, February 09, 2010 11:34 PM

To: sharetrading@yahoogroups.com

Subject: Re: [sharetrading] Average cost of shares and capital gains/loss for 2009-10 for Jaiprakash Associ

Hello Sharvan
Can you generalize the calculation for Average cost of any scrips year wise.
I will try to develop Excel sheet to work out such scenario.

regards.
Erfan

with Love

Efan

--- On Tue, 2/9/10, Shravan Keyal <shravank30@hotmail.com> wrote:

From: Shravan Keyal <shravank30@hotmail.com>
Subject: Re: [sharetrading] Average cost of shares and capital gains/loss for 2009-10 for Jaiprakash Associ
To: sharetrading@yahoogroups.com
Date: Tuesday, February 9, 2010, 1:05 AM

Hi

You have to follow the principle of FIFO(First in first out)

So you have sold the 100 shares you have bought on 23.09.2008 @ 123.98 on 02.02.2009 @ 72.64 and thus had a Short term loss of Rs 5134/- (FY 2008-2009)

(I think you have given the wrong sell date as this transaction should have been reflected in your annual return for the FY 2008-2009)

Anyway now you are left with 100 shares @ 66.33+100 shares @ 202.62+ 100 shares @ 0 (bonus shares are taken as 0 Value)

There is no capital gain or loss in 2009-10 as you have not sold any share in this period

However you have a short term capital loss of Rs 5134 in the FY 2008-2009

In case you have given any wrong dates please post again to rework and advise

Shravan

From: pradeepnaique

Sent: Tuesday, February 09, 2010 7:28 AM

To: sharetrading@ yahoogroups. com

Subject: [sharetrading] Average cost of shares and capital gains/loss for 2009-10 for Jaiprakash Associ

Please can someone help me to calculate average cost of shares and capital gains/loss for 2009-10 for Jaiprakash Associates

23-09-2008 Bought 100 @ 123.98
22-01-2009 Bought 100 @66.33
02-02-2009 Sold 100@ 72.64
04-11-2009 Bought 100@ 202.62

on 18-12-2009 Bonus was declared as 1:2

Now I have 300 shares

1. What is average cost of shares (I want to include it in portfolio)
2. What is capital gains for 2009-10

Regards

Suchitra