Sensex

Wednesday, February 10, 2010

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

 

Dear Shravan
 
Will following be a correct calculation for 20008-09?
 
 
Stocks Qty Sale Purchase Gain/Loss Tax Amt
(Exchange) Price Amount Price Amount (Rs) (Rs)
Jaiprakash Asso 100 72.64 7264.00 66.33 6633.00 631.00 94.65
(NSE) 02-02-2009 22-01-2009
Jaiprakash Asso 100 72.64 7264.00 123.98 12398.00 -5,134.00 -770.10
(NSE) 02-02-2009 23-09-2008
STOCK TOTAL -4,503.00 -675.45
 
Regards
 
Pradeep

Sent: Wednesday, February 10, 2010 12:46 PM
Subject: 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
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
 
 
 

Sent: Tuesday, February 09, 2010 7:28 AM
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


__._,_.___
Please use your discretion before acting on the ideas expressed in the group.
Happy Trading,
United we grow!!!
.

__,_._,___

No comments: