How to calculate Please help

3747 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

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 27 June 2026
CA Articled Trainee And Paid Assistant

SKAA & Associates

New Delhi

CA Inter

View Details
Company
09 June 2026
Accounts Associate

S Madan and CO

New Delhi

Graduate (Any)

View Details
Company
20 June 2026
Assistant Accounts Manager

Fintax Professionals

Gurgaon

CA Inter

View Details
Company
ARTICLESHIP 28 June 2026
Article Assistant

Sharma Chetan And Company

Gurgaon

CA Inter

View Details
Company
12 June 2026
Accounts & Taxation Executive

Winshine Financial Services

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 18 June 2026
Article Assistance

RB KESHRI & CO.

Mumbai

CA Inter

View Details
Company
24 June 2026
Senior Account (VA Client Operations)

Karbon Business

Bengaluru

CA Inter

View Details
Company
25 June 2026
AUDIT MANAGER

JDAS & ASSOCIATES

New Delhi

CA

View Details