Description
This is a spreadsheet about the balance sheet analysis of India-Swift.
BALANCE SHEET
Mar' 09 Mar' 08 Mar' 07 Mar' 06
Sources of funds
Owner's fund
Equity share capital Share application money Preference share capital Reserves & surplus 25.27 1.78 244.25 24.03 3.16 211.35 22.84 1.37 188.75 21.52 1.26 3.51 168.10
Loan funds
Secured loans Unsecured loans 353.68 25.73 650.71 274.37 38.71 551.62 263.45 27.83 504.24 194.58 27.39 416.36
TOTAL
Uses of funds
Fixed assets
Gross block Less : revaluation reserve Less : accumulated depreciation Net block Capital work-in-progress Investments 570.07 94.04 77.97 398.06 48.67 23.38 469.39 97.71 48.52 323.15 45.08 23.38 392.85 101.39 31.28 260.18 21.03 22.65 211.48 22.28 189.20 47.92 17.40
Net current assets
Current assets, loans & advances Less : current liabilities & provisions Total net current assets Miscellaneous expenses not written 426.65 246.80 179.85 0.73 650.70 339.31 180.46 158.85 1.17 551.62 280.03 127.58 152.45 48.28 504.59 220.05 99.77 120.28 41.57 416.36
TOTAL
Mar' 05
18.4 1.99 3.51 88.74
120.5 24.85 257.99
103.44 14.88 88.56 59.35 3.14
154.31 66.16 88.16 18.77 257.98
PROFIT LOSS ACCOUNT
Mar '09 Mar '08 Mar '07 Mar '06 Mar '05
INCOME
Operating Income 581.88 444.5 343.75 314.09 231.8
Expenditure
Raw Materials etc Manufacturing, Selling etc. Expenses Depreciation TOTAL 396.64 21.58 26.86 445.08 309.23 17.05 15.14 341.42 229.05 15.62 12.24 256.91 207.15 14.63 8.11 229.89 155.69 10.1 4.1 169.89
PROFIT
Profit before Taxation Profit after Taxation Available for appropriation 130.81 48.14 39.79 94.81 33.4 31.02 73.22 20.64 88.89 65.96 36.05 75.95 45.94 27.18 45.96
Earnings Per Share (Face Value Re. 1.00 each) 19(iii)
Basic Rs. 2.66 Rs. 2.29 Rs. 2.19 Rs. 1.96 Rs. 1.85
S ACCOUNT
PROFITABILITY RATIOS CASH FLOWS
Mar '09 Profit before tax Net cashflow-operating activity Net cash used in investing activity Netcash used in fin. activity Net inc/dec in cash and equivlnt Cash and equivalnt begin of year Cash and equivalnt end of year 48.93 97.84 -98.91 12.19 11.11 11.76 22.88 Mar '08 38.91 57.97 -65.7 9.61 1.88 9.88 11.76 Mar '07 25.44 46.3 -84.36 37.45 -0.61 10.49 9.88 Mar '06 40.88 36.49 -137.95 100.17 -1.28 11.78 10.49 Mar '05 31.79 8.4 -104.67 102.41 6.13 5.65 11.78
PROFITABILITY RATIOS
Mar '09 Mar '08 16.62 Mar '07 16.9 Mar '06 18.09 Mar '05 17.8
Gross profit margin (%)
16.78
Mar '09 Net profit margin (%) 6.76
Mar '08 6.88
Mar '07 5.58
Mar '06 11.03
Mar '05 11.44
Mar '09 Asset Turnover Ratio 0.89
Mar '08
Mar '07
Mar '06
Mar '05
0.81 0.681246 0.754371 0.898519
Mar '09 RETURN ON ASSET(%)
Mar '08
Mar '07
Mar '06
Mar '05
6.114953 5.623436 17.61628 18.24143 17.81533
Mar '09 RETURN ON EQUITY(%)
Mar '08
Mar '07
Mar '06
Mar '05
14.76328 13.17869 42.01049 40.05379 42.89714
Mar '09 EARNINGS PER SHARE 3.43
Mar '08 4.54
Mar '07 3.57
Mar '06 3.28
Mar '05 3.45
ANALYSIS
As we see from the graphs, profit margin has been varying marginally over time, this shows that profits are in proportion to the sales , though both net profits and sales have been increasing over time which suggests that the firm is in a healthy position. Similar is the case is with the return on asset which has been almost the same for years which again shows that the assets have been increasing along with the profits as ROA is equal to Profit after tax divided by Total Asset Though the stats are very healthy and increasing yearly but from these ratio we cannot predict cearly the position of the firm as there is marginal difference in the ratios.
LITY RATIOS
20 18 16 14 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05
Gross profit margin (%)
20 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05 Net profit margin (%)
1 0.5 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05 Asset Turnover Ratio
20 10 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05 RETURN ON ASSET(%)
50 RETURN ON EQUITY(%) 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05
that profits are in which suggests that the
ch again shows x divided by Total
t margin (%)
it margin (%)
rnover Ratio
ON ASSET(%)
ON EQUITY(%)
LIQUIDITY RATIOS
Mar '09 CURRENT RATIO 1.728728 Mar '08 Mar '07 Mar '06 Mar '05
1.88025 2.194937 2.205573 2.332376
Mar '09 QUICK RATIO 0.77
Mar '08 1.1
Mar '07 1.25
Mar '06 1.19
Mar '05 1.26
Mar '09 INVENTORY TURNOVER RATIO 2.94
Mar '08 4.05
Mar '07 4.13
Mar '06 3.97
Mar '05 3.47
ANALYSIS
Current Ratio is the ratio of the current asset which are available and current liabilities and it has been increasing over years which is a positive signal for the company as we have more asset in proportion to the liabilities. Ideal Current ratio is 2 which suggests that the company has 2 times current asset in compaision to the current liabilities and Quick ratio is the ratio of the liquid assets(which can be converted into cash immediately) It has been increasing which again is a positive signal for the company Ideal Quick ratio is 1 which suggests that the co has equal quick asset as liabilities Inventory Turnover Ratio is the ratio of the cost of good solds and Average Inventories available which suggests that how easily the inventory is turned into sales . It has been increasing over times which suggests that the company is keeping more inventory and getting more conservative in its approach
Y RATIOS
3 2 1 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05 CURRENT RATIO
1.5 1 0.5 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05 CURRENT RATIO QUICK RATIO
6 4 2 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05 QUICK RATIO INVENTORY TURNOVER RATIO
t has been increasing over
ision to the current liabilities and this suggests that this company has more of assets.
SOLVENCY RATIOS
Mar '09 DEBT EQUITY RATIO Mar '08 Mar '07 Mar '06 Mar '05 1.407725 1.330105 1.376625 1.170604 1.356636
Mar '09 Fixed assets turnover ratio 1.29
Mar '08 1.08
Mar '07 0.88
Mar '06 1.53
Mar '05 2.27
Mar '09 INTEREST COVER 85.36
Mar '08
Mar '07
Mar '06
Mar '05 72.0586
89.26 76.68676 79.57346
ANALYSIS
Debt Equity Ratio is the ratio between the total debt(which is equal to the secured and unsecured loans taken) and the equity(which is equal to the share capital and the reserves and surplus) As debt equity ratio is high, this shows that most of the financing done by the company is through debt and it uses very high debt. Due to this very low DEBT EQUITY ratio, the firm exposes its creditors with greater risk. Interest Cover is the ratio of the profit before interst and tax and Interest Expense It measures the protection available to the creditors for payment of interst charges by the co. It is also the main factor for Credit Rating Agencies to mark the co. As it has decreased to a great extent from the previous year, not a good signal though it is good as a number So not much worries for the co. as there still it has a good credit rating.
Y RATIOS
1.5 1 0.5 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05 DEBT EQUITY RATIO
3 2 1 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05 Fixed assets turnover ratio
100 50 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05
Fixed assets turnover ratio INTEREST COVER
ecured loans taken)
ood as a number
UITY RATIO
sets turnover
assets turnover
CAPITAL MARKET RATIO
Mar '09 PRICE EARNINGS RATIO Mar '08 Mar '07 Mar '06 Mar '05
28.24074 22.66667 33.37969 39.59732 16.17647
Mar '09 DIVIDEND YIELD(%)
Mar '08
Mar '07
Mar '06
Mar '05
1.516393 1.458333 1.313559 1.152174 0.281818
Mar '09 PRICE-TO-MARKET-VALUE) 6.732892
Mar '08
Mar '07
Mar '06
Mar '05
7.68 8.698804 9.803922 3.492063
ANALYSIS
PRICE EARNINGS RATIO is the ratio between the stock price and earnings per share. It is the major factor for the investors to analyze the stock as it shows the confidence of the market in the stock.
The ratio has been varying over years though the increase in the PE ratio over the last 2 years indicates the greater confidence the market has shown towards the stock. Dividend yield ratio is defined as the ratio of the dividend given per share to the average stock price As the dividend yield ratio has been increasing over the times this suggests that the firm is paying more dividend and hence +ve for the investors Price to book ratio compares the market price of the company's share with the book value As the price to book ratio is more, it suggests that the stock is not underpriced, again good for the investors.
MARKET RATIOS
60 40 20 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05 PRICE EARNINGS RATIO
2 1 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05 DIVIDEND YIELD(%)
15 10 5 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05 PRICE-TO-MARKETVALUE)
or the investors.
doc_537560883.xlsx
This is a spreadsheet about the balance sheet analysis of India-Swift.
BALANCE SHEET
Mar' 09 Mar' 08 Mar' 07 Mar' 06
Sources of funds
Owner's fund
Equity share capital Share application money Preference share capital Reserves & surplus 25.27 1.78 244.25 24.03 3.16 211.35 22.84 1.37 188.75 21.52 1.26 3.51 168.10
Loan funds
Secured loans Unsecured loans 353.68 25.73 650.71 274.37 38.71 551.62 263.45 27.83 504.24 194.58 27.39 416.36
TOTAL
Uses of funds
Fixed assets
Gross block Less : revaluation reserve Less : accumulated depreciation Net block Capital work-in-progress Investments 570.07 94.04 77.97 398.06 48.67 23.38 469.39 97.71 48.52 323.15 45.08 23.38 392.85 101.39 31.28 260.18 21.03 22.65 211.48 22.28 189.20 47.92 17.40
Net current assets
Current assets, loans & advances Less : current liabilities & provisions Total net current assets Miscellaneous expenses not written 426.65 246.80 179.85 0.73 650.70 339.31 180.46 158.85 1.17 551.62 280.03 127.58 152.45 48.28 504.59 220.05 99.77 120.28 41.57 416.36
TOTAL
Mar' 05
18.4 1.99 3.51 88.74
120.5 24.85 257.99
103.44 14.88 88.56 59.35 3.14
154.31 66.16 88.16 18.77 257.98
PROFIT LOSS ACCOUNT
Mar '09 Mar '08 Mar '07 Mar '06 Mar '05
INCOME
Operating Income 581.88 444.5 343.75 314.09 231.8
Expenditure
Raw Materials etc Manufacturing, Selling etc. Expenses Depreciation TOTAL 396.64 21.58 26.86 445.08 309.23 17.05 15.14 341.42 229.05 15.62 12.24 256.91 207.15 14.63 8.11 229.89 155.69 10.1 4.1 169.89
PROFIT
Profit before Taxation Profit after Taxation Available for appropriation 130.81 48.14 39.79 94.81 33.4 31.02 73.22 20.64 88.89 65.96 36.05 75.95 45.94 27.18 45.96
Earnings Per Share (Face Value Re. 1.00 each) 19(iii)
Basic Rs. 2.66 Rs. 2.29 Rs. 2.19 Rs. 1.96 Rs. 1.85
S ACCOUNT
PROFITABILITY RATIOS CASH FLOWS
Mar '09 Profit before tax Net cashflow-operating activity Net cash used in investing activity Netcash used in fin. activity Net inc/dec in cash and equivlnt Cash and equivalnt begin of year Cash and equivalnt end of year 48.93 97.84 -98.91 12.19 11.11 11.76 22.88 Mar '08 38.91 57.97 -65.7 9.61 1.88 9.88 11.76 Mar '07 25.44 46.3 -84.36 37.45 -0.61 10.49 9.88 Mar '06 40.88 36.49 -137.95 100.17 -1.28 11.78 10.49 Mar '05 31.79 8.4 -104.67 102.41 6.13 5.65 11.78
PROFITABILITY RATIOS
Mar '09 Mar '08 16.62 Mar '07 16.9 Mar '06 18.09 Mar '05 17.8
Gross profit margin (%)
16.78
Mar '09 Net profit margin (%) 6.76
Mar '08 6.88
Mar '07 5.58
Mar '06 11.03
Mar '05 11.44
Mar '09 Asset Turnover Ratio 0.89
Mar '08
Mar '07
Mar '06
Mar '05
0.81 0.681246 0.754371 0.898519
Mar '09 RETURN ON ASSET(%)
Mar '08
Mar '07
Mar '06
Mar '05
6.114953 5.623436 17.61628 18.24143 17.81533
Mar '09 RETURN ON EQUITY(%)
Mar '08
Mar '07
Mar '06
Mar '05
14.76328 13.17869 42.01049 40.05379 42.89714
Mar '09 EARNINGS PER SHARE 3.43
Mar '08 4.54
Mar '07 3.57
Mar '06 3.28
Mar '05 3.45
ANALYSIS
As we see from the graphs, profit margin has been varying marginally over time, this shows that profits are in proportion to the sales , though both net profits and sales have been increasing over time which suggests that the firm is in a healthy position. Similar is the case is with the return on asset which has been almost the same for years which again shows that the assets have been increasing along with the profits as ROA is equal to Profit after tax divided by Total Asset Though the stats are very healthy and increasing yearly but from these ratio we cannot predict cearly the position of the firm as there is marginal difference in the ratios.
LITY RATIOS
20 18 16 14 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05
Gross profit margin (%)
20 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05 Net profit margin (%)
1 0.5 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05 Asset Turnover Ratio
20 10 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05 RETURN ON ASSET(%)
50 RETURN ON EQUITY(%) 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05
that profits are in which suggests that the
ch again shows x divided by Total
t margin (%)
it margin (%)
rnover Ratio
ON ASSET(%)
ON EQUITY(%)
LIQUIDITY RATIOS
Mar '09 CURRENT RATIO 1.728728 Mar '08 Mar '07 Mar '06 Mar '05
1.88025 2.194937 2.205573 2.332376
Mar '09 QUICK RATIO 0.77
Mar '08 1.1
Mar '07 1.25
Mar '06 1.19
Mar '05 1.26
Mar '09 INVENTORY TURNOVER RATIO 2.94
Mar '08 4.05
Mar '07 4.13
Mar '06 3.97
Mar '05 3.47
ANALYSIS
Current Ratio is the ratio of the current asset which are available and current liabilities and it has been increasing over years which is a positive signal for the company as we have more asset in proportion to the liabilities. Ideal Current ratio is 2 which suggests that the company has 2 times current asset in compaision to the current liabilities and Quick ratio is the ratio of the liquid assets(which can be converted into cash immediately) It has been increasing which again is a positive signal for the company Ideal Quick ratio is 1 which suggests that the co has equal quick asset as liabilities Inventory Turnover Ratio is the ratio of the cost of good solds and Average Inventories available which suggests that how easily the inventory is turned into sales . It has been increasing over times which suggests that the company is keeping more inventory and getting more conservative in its approach
Y RATIOS
3 2 1 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05 CURRENT RATIO
1.5 1 0.5 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05 CURRENT RATIO QUICK RATIO
6 4 2 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05 QUICK RATIO INVENTORY TURNOVER RATIO
t has been increasing over
ision to the current liabilities and this suggests that this company has more of assets.
SOLVENCY RATIOS
Mar '09 DEBT EQUITY RATIO Mar '08 Mar '07 Mar '06 Mar '05 1.407725 1.330105 1.376625 1.170604 1.356636
Mar '09 Fixed assets turnover ratio 1.29
Mar '08 1.08
Mar '07 0.88
Mar '06 1.53
Mar '05 2.27
Mar '09 INTEREST COVER 85.36
Mar '08
Mar '07
Mar '06
Mar '05 72.0586
89.26 76.68676 79.57346
ANALYSIS
Debt Equity Ratio is the ratio between the total debt(which is equal to the secured and unsecured loans taken) and the equity(which is equal to the share capital and the reserves and surplus) As debt equity ratio is high, this shows that most of the financing done by the company is through debt and it uses very high debt. Due to this very low DEBT EQUITY ratio, the firm exposes its creditors with greater risk. Interest Cover is the ratio of the profit before interst and tax and Interest Expense It measures the protection available to the creditors for payment of interst charges by the co. It is also the main factor for Credit Rating Agencies to mark the co. As it has decreased to a great extent from the previous year, not a good signal though it is good as a number So not much worries for the co. as there still it has a good credit rating.
Y RATIOS
1.5 1 0.5 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05 DEBT EQUITY RATIO
3 2 1 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05 Fixed assets turnover ratio
100 50 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05
Fixed assets turnover ratio INTEREST COVER
ecured loans taken)
ood as a number
UITY RATIO
sets turnover
assets turnover
CAPITAL MARKET RATIO
Mar '09 PRICE EARNINGS RATIO Mar '08 Mar '07 Mar '06 Mar '05
28.24074 22.66667 33.37969 39.59732 16.17647
Mar '09 DIVIDEND YIELD(%)
Mar '08
Mar '07
Mar '06
Mar '05
1.516393 1.458333 1.313559 1.152174 0.281818
Mar '09 PRICE-TO-MARKET-VALUE) 6.732892
Mar '08
Mar '07
Mar '06
Mar '05
7.68 8.698804 9.803922 3.492063
ANALYSIS
PRICE EARNINGS RATIO is the ratio between the stock price and earnings per share. It is the major factor for the investors to analyze the stock as it shows the confidence of the market in the stock.
The ratio has been varying over years though the increase in the PE ratio over the last 2 years indicates the greater confidence the market has shown towards the stock. Dividend yield ratio is defined as the ratio of the dividend given per share to the average stock price As the dividend yield ratio has been increasing over the times this suggests that the firm is paying more dividend and hence +ve for the investors Price to book ratio compares the market price of the company's share with the book value As the price to book ratio is more, it suggests that the stock is not underpriced, again good for the investors.
MARKET RATIOS
60 40 20 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05 PRICE EARNINGS RATIO
2 1 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05 DIVIDEND YIELD(%)
15 10 5 0 Mar '09 Mar '08 Mar '07 Mar '06 Mar '05 PRICE-TO-MARKETVALUE)
or the investors.
doc_537560883.xlsx