Analysis report Liquidity analysis Part A

Posted on at


Annexure

Liquidity analysis:  

  1. Days’ sales in Receivables =  Gross Receivables/Net Sales/365

Year

Calculation

Days’ sales in Receivables

2010

66679711/1387004223/365

17.54

2009

14461213/1379043093/365

3.83

2008

14594714/953846228/365

5.58

2007

19189771/747731624/365

9.37

2006

18749064/913370379/365

7.49

Receivables = trade debts+ other receivables

Gross Receivables = Net Account Receivables + Allowances for doubtful debts

Receivables:

2010       52445315+14234396 =66679711

2009       14461213+0                =14461213

2008       0+14594714              =14594714

2007       4410362+14779409 =19189771

2006       4168000+14581064 =18749064

 

  1. Account Receivables Turnover =net sales /average gross R/A

Year

Calculation

Account Receivable Turnover

2010

1387004223/40570462

34.18

2009

1379043093/14527963.5

94.92

2008

953846228/16892242.5

56.47

2007

747731624/18969417.5

39.42

2006

913370379/18130914

50.37

Working Note:-

Average Gross Receivables = (Opening Gross Receivables + closing Gross Receivables)/2

Gross Receivables = Net Account Receivables + Allowances for doubtful debts

Average gross R/A:

2010       (14461213+66679711) /2 =40570462

2009       (14594714+14461213)/2 =14527963.5

2008       (19189771+14594714)/2 =16892242.5

2007       (18749064+19189771)/2 =18969417.5

2006       (17512764+18749064)/2 =18130914



About the author

160