0% found this document useful (0 votes)
94 views13 pages

Akash 1

The document provides financial information for working capital and ratio analysis for a company from 2007-2008 to 2010-2011. It includes current assets, current liabilities, and net working capital for each year. It also calculates various financial ratios such as current ratio, inventory turnover ratio, creditors turnover ratio, debtors turnover ratio, and gross profit margin ratio for each year to analyze the company's financial performance and efficiency over time.

Uploaded by

Akash Gulalakai
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
94 views13 pages

Akash 1

The document provides financial information for working capital and ratio analysis for a company from 2007-2008 to 2010-2011. It includes current assets, current liabilities, and net working capital for each year. It also calculates various financial ratios such as current ratio, inventory turnover ratio, creditors turnover ratio, debtors turnover ratio, and gross profit margin ratio for each year to analyze the company's financial performance and efficiency over time.

Uploaded by

Akash Gulalakai
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 13

FORMAT OF DETERMINANT OF WORKING CAPITAL

PARTICULARS
A) CYRRENT ASSETS Inventories Sundry debtors Cash and bank balance Loan and advances TOTAL CURRENT ASSETS B) CURRENT LIABILITIES Sundry creditors Deposits from agent & others Interest accrued Overdrawn in bank Advance from customer TOTAL CURRENT LIABILITIES NET WORKING CAPITAL(A-B)

AMOUNT
XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX XXXX

WORKING CAPITAL FOR THE YEAR 2009 PARTICULARS


A) CURRENT ASSETS Inventories 2380565.45

AMOUNT

Sundry debtors Cash and bank balance Loan and advances TOTAL CURRENT ASSETS

165000.00 172500.00

2944308.55 B) CURRENT LIABILITIES Sundry creditors Other liabilities TOTAL CURRENT LIABILITIES NET WORKING CAPITAL(A-B) 5646172.45 68200.00 5714372.45 2770063.9

WORKING CAPITAL FOR THE YEAR 2010 PARTICULARS


A) CURRENT ASSETS Inventories Sundry debtors Cash and bank balance Loan and advances 6895131.4 1697230.49 647526.00 226243.10

AMOUNT

TOTAL CURRENT ASSETS B) CURRENT LIABILITIES Sundry creditors Other liabilities TOTAL CURRENT LIABILITIES NET WORKING CAPITAL(A-B) 9931812.56 142300.00 2944.90 9283.83

WORKING CAPITAL FOR THE YEAR 2009-2010 PARTICULARS


A) CURRENT ASSETS Inventories Sundry debtors Cash and bank balance Loan and advances TOTAL CURRENT ASSETS B) CURRENT LIABILITIES Sundry creditors Other liabilities Deposits from agent & others Interest accrued & not due on loans 638.73 433.96 762.61 121.81 695.51 4914.05 1864.69 5500.94 12975.19

AMOUNT

Advance from customer Out standing expenses TOTAL CURRENT LIABILITIES NET WORKING CAPITAL(A-B)

NIL 1858.07 3815.18

9160.01

WORKING CAPITAL FOR THE YEAR 2010-20011 PARTICULARS


A) CURRENT ASSETS Inventories Sundry debtors Cash and bank balance Loan and advances TOTAL CURRENT ASSETS B) CURRENT LIABILITIES Sundry creditors Other liabilities Deposits from agent & others Interest accrued & not due on loans Advance from customer 479.54 281.59 780.53 121.42 175.26 607.46 6873.78 1585.69 7470.97 16537.9

AMOUNT

Advance received to wards certified emission Out standing expenses TOTAL CURRENT LIABILITIES NET WORKING CAPITAL(A-B)

1237.54 2259.73 5335.61 11202.29

TABLE OF CONTENTS: YEAR 2007-2008 2008-2009 2009-2010 2010-2011 NET WORKING CAPITAL 6659.32 9283.83 9160.01 5335.61

N E T W O R K IN G C A P ITA L 10000 9000 8000 7000 6000 5000 4000 3000 2000 1000 0 2007-2008 008-2009 009-2010 010-2011 2 2 2 N E T W O R K IN G C A P ITA L

CHANGE IN WORKING CAPITAL


PERTICULARS A) CURRENT ASSETS Inventories Sundry debtors Cash and bank balance Loan and advance TOTAL CURRENT ASSETS B) CURRENT LIABILITIES Sundry creditors Other liabilities Deposits from agent and others Interest accrued & not due on loans Advance from customers Advance received to wards certified emission Outstanding expenses TOTAL CURRENT LIABILITY 1858.07 3815.18 2259.73 5335.61 401.66 1520.43 NIL NIL 175.26 1237.54 175.26 1237.54 638.73 433.96 762.61 121.81 479.54 281.59 780.53 121.42 (159.19) (152.37) 17.92 (0.39) 695.51 4914.05 1864.69 5500.94 607.46 6873.78 1585.69 7470.97 (88.05) 1959.73 (279) 1970.03 3562.71 2010 2011 WORKING CAPITAL

12975.19 16537.9

NET WORKING CAPITAL (A- 9161.01 B)

11202.29

2041.28

RATIO ANALYSIS

RATIO ANALYSIS
MEANING:
Ratio analysis is a Widely used tool of FInancial analysis. It is deFIned as the systematic use of ratio to interpret the FInancial statements so that the A strength and Weaknesses of a firm as Well as its historical performance ' and current financial condition can be determined. The term ratio refers to the numerical or quantitative relationship between two variables.

OBJECTIVE OFRATIO
T 0 make inter business comparisons T 0 make comparisons across financial periods It helps in the financial forecasting and planning activities To indicate with trends in the financial solvency of the firm

TYPES OF RATIO

Current ratio Inventory turnover ratio Creditors turnover ratio Debtors turnover ratio Gross profit margin ratio

CURRENT RATIO
The current ratio one of the best known measures of Financial Strength. It is Figured as shown below.Formula for current ratio Current ratio =total current assets/total current liabitity
Year Current assets Current liability Current ratio 2007-08 10015.28 2008-09 12228.71 2009-10 12975.19 2010-2011 16537.9

3355.96

2944.90

3815.18

5335.61

2.98

4.15

3.58

3.11

Interpretation; the current ratio is decreased in 2010-2011 comparing the


past year it show the ability to manage the current liability which in turn shows the efficiency of the management is not good

INVENTORY TURNOVER RATIO


It indicates the efficiency of the firm in producing the selling of its 0product. This ratio indicates how fast inventory is sold. A high ratio is good from viewpoint of liquidity and vice versa. A low ratio would signify that inventory does not sell and stay on the self or in warehouse for along time.

Formula for Inventory turnover ratio

I T R=net sales/inventory Year Net sales ITR 2007-08 54694.52 86.4 2008-09 65066.20 686.35 94.8 2009-10 71467.47 695.51 102.75 2010-11 89291.54 607.46 146.99

Inventories 633.06

Interpretation; we can see the inventory turnover ratio has increased on the
year 2011 compare to all years. That is good trend has the company is now turning the inventory into finished goods more frequently has compare to previous years.

CREDITORS TURNOVER RATIO


it is the ratio between the sales and creditors or net credit purchase and average amount of creditors. It is an important tool of analysis as a firm can maintain minimum amount of current assets, as credit from suppliers is easily available. Formula for creditor turnover ratio

C T R=net sales/creditors Year 2007-08 2008-09 65066.20 1612.56 40.3 2009-10 71467.47 638.73 111.8 2010-11 89291.54 479.54 182.2

Purchases 54694.52 Creditors 2222.75 CTR 24.6

Interpretation; low ratio reflect liberal credit terms granted by suppliers, while low ratio shows that account are settled equally, and it shows the minimum ratio in the year 2011. the ideal ratio should be more.

DEBTORS TURNOVER RATIO


It indicates how many times debtors turnover each year. Generally, the higher the ratio of debtor turnover ratio, the more Efficient is the management of credit. The ratio measured how will reveal the days of debts to be collected. Formula for debtors turnover ratio

DTR=net sales/debtors Year Net sales Debtors DTR 2007-08 54694.52 2922.32 18.7 2008-09 65066.20 4459.29 14.6 2009-10 71467.47 4914.05 14.5 2010-11 89291.54 6873.78 12.9

Interpretation: in that low ratio indicates of shorter time gap between credit
sales and cash collection. A low ratio shows that debts are not being collected rapidly. So the standard norm of law ratio reveals that company has not efficient in management of debtors.

GROSS PROFIT MARGIN RA TIO


Gross profit margin ratio is the result of relationship between price, Sales, volume and cost. A change in gross profit margin can be due to Changes in any of these

factors. It represents the limit of beyond which fall in sales price are out side and tolerance limit Formula for GPMR GPMP=gr0ss profit/net sales *100 Year 2007-08 2008-09 534.67 65066.20 0.82 2009-10 67020.17 71467.47 0.93 2010-11 82177.62 89291.54 0.92

Gross profit 1253.48 Net sales GPMR 54694.52 2.29

s Interpretation: the GPMR is decrease in the year 2011 compare to last year. It
depicts a bad trend for the company. In this case both sales and the gross profit have decreased but have increased competitively more.

You might also like