Description
This is a spreadsheet highlights financial analysis of Arvind Mills.
BALANCE SHEETS(fig. in crore) of Arvind Mills Ltd. year SOURCES OF FUNDS share capital reserves and surplus LOAN FUNDS secured unsecured APPLICATION fixed assets gross block less deprec net block capital in prog. investments inventory sundry debtors cash other CA loans Less liabilities provisions Net CA 1999-2000 1998-99 1997-98 1996-97 1995-96 1994-95
170 829
170 992
800 73.9
800
9985 99536
9949 92639.4
1183 802
1154 781.88
966.6 17.6
872 381
47294 47948.4 24186 14047.06
2445 514
1080 370
1641 204.5
1568 133.7
63315 49164.03 18585 15152.7
77.6 241.1 200.4 198.29 27.47 25.38 580
1550.69 92.62 218.92 317.6 26.01 20 589
1436 0.16 561.8 172.2 100.26 17.6 387
1434 0.16 565 71 56.6 9 171
15224
11931.2
23058 27821.05 21269 18340 7935 1715 59574 22178.9 14848.6 1743 805 67884
386 18.39 140.63
409 17 745
733.16 85.06 421
612 0.17 260
11021 4659 93153
13798 4141 89521
PROFIT AND LOSS ACCOUNTS of Arvind Mills Ltd. year Income sales and operating income 1215.97 941.13 other income 35.23 46.01 Expense raw materials purchases emoluments others interest depreciation 4048.1 104.87 2795.06 70905.61 56905.22 37.84 6296.62 7619.69 1999-2000 1998-99 1997-98 1996-97 1995-96 1994-95
518.76 42.3 83.03 452.73 264.33 165.15
505.3 26.03 46.61 316.33 31.08 82.17 -35.08
903.59 494.34 1843.36 164.8 70.87 -17.51 693.52
903.59 494.3 1843.36 218.1 67 11.01
34112 918 4190 20686 164.2 4815.17 -662.68
27777 1053 4705.5 19203.4 945.7 4223.15 3977.76
dec/inc. in stocks 40.57
profit before ext. items and tax -315.67 extra.items profit before tax provision for tax profit -271.43 44.24 14.47
0.98 11654.93 10593.78 -215.2
693.52 67.29 626.23
0.98 0.17 0.81
11385.9 10593.78
14.47
11385.9 10593.78
RATIO ANALYSIS a)PROFITABILITY RATIOS 1-PROFIT MARGIN YEAR PROFIT MARGIN PROFIT AFTER TAX SALES 1995 18.6153924 10593.13 1996 16.05786905 11385.93 1997 0.0289797 0.81 1998 15.46972654 626.23 1999 1.537513415 14.47 2000 22.32209676 271.43
56905.22 70905.61 2795.06 4048.1 941.13 1215.97
2-RETURN ON EQUITY YEAR ROE PROFIT AFTER TAX AVG. SHAREHOLDER'S EQUITY 1995 10593.13 1996 10.73425347 11385.93 1060.71 1997 0.000854782 0.81 947.61 1998 0.748219748 626.23 836.96 1999 0.013418213 14.47 1078.385 2000 0.430192567 271.43 630.95
3-EARNINGS PER SHARE YEAR EPS PROFIT AFTER TAX AVG. NO. OF EQUITY SHARES 1995 0.021215753 10593.13 49930492 1996 0.021937493 11385.93 51901692 1997 1.56673E-06 0.81 51700163 1998 0.001225952 626.23 51081106 1999 2.83275E-05 14.47 51081106
2000
271.43
51081106
b)LIQUIDITY RATIOS 1-CURRENT RATIO YEAR CR CURRENT ASSETS CURRENT LIABILITIES 1995 16.39314175 678.84 1996 12.78686413 595.74 1997 1005.941176 171.01 1998 4.557606395 387.67 1999 33.74513173 589.19 2000 31.54214247 580.06
41.41 46.59 0.17 85.06 17.46 18.39
2-QUICK RATIO YEAR QUICK RATIO QUICK ASSETS 1995 11.03743057 1996 8.221721399 1997 -2320 1998 -2.047260757 1999 21.2067583 2000 20.64600326
CURRENT LIABILITIES 457.06 383.05 -394.4 -174.14 370.27 379.68 41.41 46.59 0.17 85.06 17.46 18.39
3-DEBTOR TURNOVER RATIO YEAR DTR SALES 1995 383.2517511 1996 386.6172846 1997 39.36704225 1998 23.53546512 1999 2.962975789 2000 6.132281003
AVG. DEBTORS 56905.22 70905.61 2795.06 4048.1 941.13 1215.97 148.48 183.4 71 172 317.63 198.29
c)SOLVENCY RATIOS 1-D/E YEAR D/E=DEBT/EQUITY DEBT 1995 0.604097416 1996 0.652666588 1997 1.5675375 1998 1.127457045 1999 1.666092943 2000 1.987987988
EQUITY 61995.6 71481.35 1254.03 984.27 1936 1986 102625.17 109522 800 873 1162 999
2-INTEREST COVER YEAR INT.COVER PBIT 1995 0.111226457 1996 0.710523107 1997 0.004495413 1998 4.208252427 1999 1.194226913 2000 0.351554908
INT.EXPENSE 105 116.54 0.98 693.52 315.67 14.47 944.02 164.02 218 164.8 264.33 41.16
d)EFFICIENCY RATIOS
1-ASSET TURNOVER YEAR ASSET TURNOVER SALES 1995 1996 38.01175644 1997 1.322651398 1998 1.624366501 1999 0.303476274 2000 0.370343749
AVG.TOTAL ASSETS 56905.22 70905.61 2795.06 4048.1 941.13 1215.97 1865.36 2113.225 2492.11 3101.165 3283.355
2-INVENTORY TURNOVER RATIO YEAR 1995 1996 1997 1998 1999 2000 ITR 1.447963801 1.836179245 1.284707965 1.737005348 2.9385 32.52380952 COGS 320 389.27 725.86 974.46 587.7 683 AVG.INVENTORIES 221 212 565 561 200 21
PROFIT MARGIN
25 20 15 10 5 0 1 2 3 4 5 6 7 8 PROFIT MARGIN
ROE
12 10 8 6 4 2 0 1 2 3 4 5 6 7 ROE
EPS
0.025 0.02 0.015 EPS
0.01 0.005 0 1 2 3 4 5 6 7 8
EPS
CR
1200 1000 800 600 400 200 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 CR
QUICK RATIO
500 0 1 -500 -1000 -1500 -2000 -2500 QUICK RATIO 2 3 4 5 6 7 8
DTR
500 400 300 200 100 0 1 2 3 4 5 6 7 8 9 DTR
2.5 2 1.5 1 0.5 0 1 2 3 4 5 6 7 8
INT.COVER
4.5 4 3.5 3 2.5 2 1.5 1 0.5 0 INT.COVER
0 1 2 3 4 5 6 7 8
ASSET TURNOVER
40 35 30 25 20 15 10 5 0 1 2 3 4 5 6 7 8 ASSET TURNOVER
ITR
35 30 25 20 15 10 5 0 1 2 3 4 5 6 7 8 ITR
ANALYSIS a)PROFITABILITY RATIOS 1-PROFIT MARGIN
The profit margin is very low for the year 2004 and 2006 , this means that even though the company was profitable in other periods,it has lost its control over the costs compared to its competitors in 2004 and 2006.
2-ROE
The ROE is high during the years 2005 and 2007 as compared to other years.This means that the company is more likely to be capable of generating cash internally during these years.
3-EPS
EPS is low in 2004 , becomes high in 2005 and again reduces in 2006 , this means that the company's profit allocated to each outstanding share fluctuates.
b)LIQUIDITY RATIOS 1-CURRENT RATIO
Current ratio is very high in 2004 and somewhat higher in 2006 as compared to other years. This means that the company is able to pay its short term liabilities from short term assets.
2-QUICK RATIOS
In year 2004 , QR is highly negative , it means the company is in dangerous zone whereas in other years it is able to pay off its short term obloigations from current assets.
3-DEBTOR TURNOVER RATIO
The ratio is very high in 2004 , which means the debtors are easily utilized to generate sales, whereas it is very low in 2006 which is not good for the business.
c)SOLVENCY RATIOS
1-D/E
The D/E ratio is continuously increasing except the year 1998 during which it reduces.A high D/E ratio in 1997 means that the comapny has been aggressive in financing its growth with debt.
2-INTEREST COVER
It is sufficiently large in years 1996,98,99, and 2000. But , in 1997 it is very low which tells us that the safety margin that the business has in terms of being able to meet its interest obligations.
d)EFFICIENCY RATIOS 1-ASSET TURNOVER RATIO
During the year 2005, the asset turnover is maximum which means that the firm is efficient in using its assets to generate revenue as compared to other years.This means that a cut throat and a competitive pricing is done by the company in this year.
2-INVENTORY TURNOVER RATIO
This ratio is increasing except during the year 2004 which is a bad sign as products tend to deteriorate as they sit in a warehouse.
This means that the
enerate sales, whereas it
it reduces.A high D/E
ry low which tells us that s interest obligations.
rm is efficient in using its assets to nd a competitive pricing is done by
d sign as products tend to deteriorate
doc_894653478.xlsx
This is a spreadsheet highlights financial analysis of Arvind Mills.
BALANCE SHEETS(fig. in crore) of Arvind Mills Ltd. year SOURCES OF FUNDS share capital reserves and surplus LOAN FUNDS secured unsecured APPLICATION fixed assets gross block less deprec net block capital in prog. investments inventory sundry debtors cash other CA loans Less liabilities provisions Net CA 1999-2000 1998-99 1997-98 1996-97 1995-96 1994-95
170 829
170 992
800 73.9
800
9985 99536
9949 92639.4
1183 802
1154 781.88
966.6 17.6
872 381
47294 47948.4 24186 14047.06
2445 514
1080 370
1641 204.5
1568 133.7
63315 49164.03 18585 15152.7
77.6 241.1 200.4 198.29 27.47 25.38 580
1550.69 92.62 218.92 317.6 26.01 20 589
1436 0.16 561.8 172.2 100.26 17.6 387
1434 0.16 565 71 56.6 9 171
15224
11931.2
23058 27821.05 21269 18340 7935 1715 59574 22178.9 14848.6 1743 805 67884
386 18.39 140.63
409 17 745
733.16 85.06 421
612 0.17 260
11021 4659 93153
13798 4141 89521
PROFIT AND LOSS ACCOUNTS of Arvind Mills Ltd. year Income sales and operating income 1215.97 941.13 other income 35.23 46.01 Expense raw materials purchases emoluments others interest depreciation 4048.1 104.87 2795.06 70905.61 56905.22 37.84 6296.62 7619.69 1999-2000 1998-99 1997-98 1996-97 1995-96 1994-95
518.76 42.3 83.03 452.73 264.33 165.15
505.3 26.03 46.61 316.33 31.08 82.17 -35.08
903.59 494.34 1843.36 164.8 70.87 -17.51 693.52
903.59 494.3 1843.36 218.1 67 11.01
34112 918 4190 20686 164.2 4815.17 -662.68
27777 1053 4705.5 19203.4 945.7 4223.15 3977.76
dec/inc. in stocks 40.57
profit before ext. items and tax -315.67 extra.items profit before tax provision for tax profit -271.43 44.24 14.47
0.98 11654.93 10593.78 -215.2
693.52 67.29 626.23
0.98 0.17 0.81
11385.9 10593.78
14.47
11385.9 10593.78
RATIO ANALYSIS a)PROFITABILITY RATIOS 1-PROFIT MARGIN YEAR PROFIT MARGIN PROFIT AFTER TAX SALES 1995 18.6153924 10593.13 1996 16.05786905 11385.93 1997 0.0289797 0.81 1998 15.46972654 626.23 1999 1.537513415 14.47 2000 22.32209676 271.43
56905.22 70905.61 2795.06 4048.1 941.13 1215.97
2-RETURN ON EQUITY YEAR ROE PROFIT AFTER TAX AVG. SHAREHOLDER'S EQUITY 1995 10593.13 1996 10.73425347 11385.93 1060.71 1997 0.000854782 0.81 947.61 1998 0.748219748 626.23 836.96 1999 0.013418213 14.47 1078.385 2000 0.430192567 271.43 630.95
3-EARNINGS PER SHARE YEAR EPS PROFIT AFTER TAX AVG. NO. OF EQUITY SHARES 1995 0.021215753 10593.13 49930492 1996 0.021937493 11385.93 51901692 1997 1.56673E-06 0.81 51700163 1998 0.001225952 626.23 51081106 1999 2.83275E-05 14.47 51081106
2000
271.43
51081106
b)LIQUIDITY RATIOS 1-CURRENT RATIO YEAR CR CURRENT ASSETS CURRENT LIABILITIES 1995 16.39314175 678.84 1996 12.78686413 595.74 1997 1005.941176 171.01 1998 4.557606395 387.67 1999 33.74513173 589.19 2000 31.54214247 580.06
41.41 46.59 0.17 85.06 17.46 18.39
2-QUICK RATIO YEAR QUICK RATIO QUICK ASSETS 1995 11.03743057 1996 8.221721399 1997 -2320 1998 -2.047260757 1999 21.2067583 2000 20.64600326
CURRENT LIABILITIES 457.06 383.05 -394.4 -174.14 370.27 379.68 41.41 46.59 0.17 85.06 17.46 18.39
3-DEBTOR TURNOVER RATIO YEAR DTR SALES 1995 383.2517511 1996 386.6172846 1997 39.36704225 1998 23.53546512 1999 2.962975789 2000 6.132281003
AVG. DEBTORS 56905.22 70905.61 2795.06 4048.1 941.13 1215.97 148.48 183.4 71 172 317.63 198.29
c)SOLVENCY RATIOS 1-D/E YEAR D/E=DEBT/EQUITY DEBT 1995 0.604097416 1996 0.652666588 1997 1.5675375 1998 1.127457045 1999 1.666092943 2000 1.987987988
EQUITY 61995.6 71481.35 1254.03 984.27 1936 1986 102625.17 109522 800 873 1162 999
2-INTEREST COVER YEAR INT.COVER PBIT 1995 0.111226457 1996 0.710523107 1997 0.004495413 1998 4.208252427 1999 1.194226913 2000 0.351554908
INT.EXPENSE 105 116.54 0.98 693.52 315.67 14.47 944.02 164.02 218 164.8 264.33 41.16
d)EFFICIENCY RATIOS
1-ASSET TURNOVER YEAR ASSET TURNOVER SALES 1995 1996 38.01175644 1997 1.322651398 1998 1.624366501 1999 0.303476274 2000 0.370343749
AVG.TOTAL ASSETS 56905.22 70905.61 2795.06 4048.1 941.13 1215.97 1865.36 2113.225 2492.11 3101.165 3283.355
2-INVENTORY TURNOVER RATIO YEAR 1995 1996 1997 1998 1999 2000 ITR 1.447963801 1.836179245 1.284707965 1.737005348 2.9385 32.52380952 COGS 320 389.27 725.86 974.46 587.7 683 AVG.INVENTORIES 221 212 565 561 200 21
PROFIT MARGIN
25 20 15 10 5 0 1 2 3 4 5 6 7 8 PROFIT MARGIN
ROE
12 10 8 6 4 2 0 1 2 3 4 5 6 7 ROE
EPS
0.025 0.02 0.015 EPS
0.01 0.005 0 1 2 3 4 5 6 7 8
EPS
CR
1200 1000 800 600 400 200 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 CR
QUICK RATIO
500 0 1 -500 -1000 -1500 -2000 -2500 QUICK RATIO 2 3 4 5 6 7 8
DTR
500 400 300 200 100 0 1 2 3 4 5 6 7 8 9 DTR
2.5 2 1.5 1 0.5 0 1 2 3 4 5 6 7 8
INT.COVER
4.5 4 3.5 3 2.5 2 1.5 1 0.5 0 INT.COVER
0 1 2 3 4 5 6 7 8
ASSET TURNOVER
40 35 30 25 20 15 10 5 0 1 2 3 4 5 6 7 8 ASSET TURNOVER
ITR
35 30 25 20 15 10 5 0 1 2 3 4 5 6 7 8 ITR
ANALYSIS a)PROFITABILITY RATIOS 1-PROFIT MARGIN
The profit margin is very low for the year 2004 and 2006 , this means that even though the company was profitable in other periods,it has lost its control over the costs compared to its competitors in 2004 and 2006.
2-ROE
The ROE is high during the years 2005 and 2007 as compared to other years.This means that the company is more likely to be capable of generating cash internally during these years.
3-EPS
EPS is low in 2004 , becomes high in 2005 and again reduces in 2006 , this means that the company's profit allocated to each outstanding share fluctuates.
b)LIQUIDITY RATIOS 1-CURRENT RATIO
Current ratio is very high in 2004 and somewhat higher in 2006 as compared to other years. This means that the company is able to pay its short term liabilities from short term assets.
2-QUICK RATIOS
In year 2004 , QR is highly negative , it means the company is in dangerous zone whereas in other years it is able to pay off its short term obloigations from current assets.
3-DEBTOR TURNOVER RATIO
The ratio is very high in 2004 , which means the debtors are easily utilized to generate sales, whereas it is very low in 2006 which is not good for the business.
c)SOLVENCY RATIOS
1-D/E
The D/E ratio is continuously increasing except the year 1998 during which it reduces.A high D/E ratio in 1997 means that the comapny has been aggressive in financing its growth with debt.
2-INTEREST COVER
It is sufficiently large in years 1996,98,99, and 2000. But , in 1997 it is very low which tells us that the safety margin that the business has in terms of being able to meet its interest obligations.
d)EFFICIENCY RATIOS 1-ASSET TURNOVER RATIO
During the year 2005, the asset turnover is maximum which means that the firm is efficient in using its assets to generate revenue as compared to other years.This means that a cut throat and a competitive pricing is done by the company in this year.
2-INVENTORY TURNOVER RATIO
This ratio is increasing except during the year 2004 which is a bad sign as products tend to deteriorate as they sit in a warehouse.
This means that the
enerate sales, whereas it
it reduces.A high D/E
ry low which tells us that s interest obligations.
rm is efficient in using its assets to nd a competitive pricing is done by
d sign as products tend to deteriorate
doc_894653478.xlsx