banner_ad

How to calculate Please help

Others 3734 views 11 replies

how to calculate the following

debtors velocity - 3 months 

stock velocity - 6 months 

creditors velocity - 2 months

GP Ratio - 20% GP for the year 5 lakhs. stock at end is more than 20000 opening stock. bills payable and bills receivable are 36667 and 60000/- 

how to calculate - sales , Sundry debtors , Sundry creditors and Stock . 

Replies (11)

just wanted to knw if the 3 new accounting standards apply at the pcc level or not?????
 

i think they will not apply 

Pls find the solution.

Thnx

Shikha

hi answer is wrong for stock and debtors . debtors value is 5.65 lakh and answer for closing stock is 10.10 lakh

1.sales = 5,00,000/20*100=25,00,000

2. Debtors = 25,00,000*3/12 = 6,25,000-60000= 5,65,000

3. Creditors = 20,40,000*2/12 = 3,40,000-36,666 = 3,03,334

4. Average stock = 20,40,000/2 = 10,20,000

    Op.Stock = 9,80,000

   Cl.Stock = 10,20,000

Pls find the correct file. Inconvience is regretted.

sales = GP/GPR = 5 lacs/ 20% = Rs.25 lacs

Debtors = 25,00,000*3/12 = 6,25,000-60000= 5,65,000

COG = TS -GP= Rs25-5 = Rs20 lacs

Avg Stock = COG*6/12 = Rs20 lacs /2 = Rs.10 lacs

AVG stock = (OPStock + Clstock)/2 => ( OPSTock + Opstock +20000)/2 => Opstock +Rs10000

Avg stock = Rs10 lacs

optstock +Rs0.10 lacs = Rs10.lacs

optstock = Rs 10 lacs -0.10 lacs = Rs 9.90 lacs

Clstock = opstock +0.20 lacs => Rs9.9 lacs +0.20 lacs = Rs 10.10 lacs

 

stock = Rs10.10 lacs

 

 

           

 

hello,

i would like to know as per new bugdet if i want to import a construction equipment does it come under custom duty or not, if yes please let me know how to calculate the duty with a example?

THANKS FOR SHARING.....

hi guys u have been subtracting receivables it should not be the case refer formula denominator has average receivable.

Sumit

When we r unable to compute avg. receivables or payable for the want of infn., we can take closing receivables or payables.

Hope ur doubts get resolved.

Thnx


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 08 June 2026
Internal & Taxation Article

O P Bagla & Co LLP

New Delhi

CA Inter

View Details
Company
26 May 2026
Education Content Creator

Adyayam Education LLP

Bengaluru

CA Foundation

View Details
Company
22 May 2026
Audit assistant

Displayandbeyond

Mumbai

CA

View Details
Company
21 May 2026
Associate

PWC

Kolkata

CA

View Details
Company
ARTICLESHIP 09 June 2026
Article Trainee

Numbertree LLP

Mumbai

CA Inter

View Details
Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
ARTICLESHIP 27 May 2026
CA Article Trainee

Rahul Dang & Associates-Chartered Accountants

Pune

CA Inter

View Details
Company
ARTICLESHIP 31 May 2026
Article Assistant

KPRS And Associates

New Delhi

CA Inter

View Details