Description
This is a spreadsheet explains on financial analysis of Shreyans Industries Ltd.
Analysis of Shreyans Industries Ltd.
Balance Sheet Sources Of Funds Total Share Capital Equity Share Capital Share Application Money Preference Share Capital Reserves Revaluation Reserves Networth Secured Loans Unsecured Loans Total Debt Total Liabilities Application Of Funds Gross Block Less: Accum. Depreciation Net Block Capital Work in Progress Investments Inventories Sundry Debtors Cash and Bank Balance Total Current Assets Loans and Advances Fixed Deposits Total CA, Loans & Advances Deffered Credit Current Liabilities Provisions Total CL & Provisions Net Current Assets Miscellaneous Expenses Total Assets Contingent Liabilities Book Value (Rs) ------------------- in Rs. Cr. ------------------Mar '05 Mar '06 Mar '07 Mar '08 11.07 11.07 0 0 -8.79 0 2.28 80.07 3.82 83.89 86.17 117.42 51.62 65.8 1.98 0.55 11.47 28.43 1.39 41.29 8.72 0.8 50.81 0 33.06 0.03 33.09 17.72 0.15 86.2 3.01 2.07 11.07 11.07 0 0 -0.84 0 10.23 69.42 2.71 72.13 82.36 119.75 56.57 63.18 2.65 0.2 9.12 26.23 2.31 37.66 10.55 0.63 48.84 0 32.2 0.32 32.52 16.32 0 82.35 9.46 9.24 11.07 11.07 0 0 5.79 0 16.86 67.63 2.62 70.25 87.11 127.48 62.18 65.3 9.63 0.01 15.28 24.51 1.35 41.14 20.28 0.67 62.09 0 49.4 1.2 50.6 11.49 0.7 87.13 10.14 15.23 11.07 11.07 1.64 0 17.84 0 30.55 71.5 2.55 74.05 104.6 124.31 62.43 61.88 21.95 0.01 18.27 28.14 3.23 49.64 14.54 1.98 66.16 0 46.61 0.45 47.06 19.1 1.68 104.62 7.17 26.11 Mar '09 11.07 11.07 8.94 0 35.96 0 55.97 61.77 3.01 64.78 120.75 169.82 67.21 102.61 4.26 2.97 21.16 20.41 1.59 43.16 22.24 0.8 66.2 0 48.97 6.33 55.3 10.9 0 120.74 1.1 42.47
Analysis of Shreyans Industries Ltd.
Profit & Loss account Income Sales Turnover Excise Duty Net Sales Other Income Stock Adjustments Total Income Expenditure Raw Materials Power & Fuel Cost Employee Cost Other Manufacturing Expenses Selling and Admin Expenses Miscellaneous Expenses Preoperative Exp Capitalised Total Expenses Operating Profit PBDIT Interest PBDT Depreciation Other Written Off Profit Before Tax Extra-ordinary items PBT (Post Extra-ord Items) Tax Reported Net Profit Total Value Addition Preference Dividend Equity Dividend Corporate Dividend Tax Per share data (annualised) Shares in issue (lakhs) Earning Per Share (Rs) Equity Dividend (%) Book Value (Rs) ------------------- in Rs. Cr. ------------------Mar '05 Mar '06 Mar '07 Mar '08 158.32 14.53 143.79 -0.11 -0.88 142.8 70.7 33.74 13.88 5.46 9.39 1.01 0 134.18 8.73 8.62 9.21 -0.59 5.21 0.15 -5.95 1.3 -4.65 0.02 -4.67 63.48 0 0 0 110.75 -4.22 0 2.07 193.31 14.49 178.82 -0.3 -0.83 177.69 85.2 40.15 13.87 5.95 7.48 1.17 0 153.82 24.17 23.87 8.33 15.54 5.65 0.15 9.74 1.02 10.76 2.83 7.95 68.63 0 0 0 110.75 7.18 0 9.24 214.44 16.08 198.36 0.4 0.82 199.58 96.72 47.6 15.19 7.21 6.75 1.18 0 174.65 24.53 24.93 7.48 17.45 5.84 0 11.61 0.26 11.87 5.26 6.63 77.92 0 0 0 110.75 5.98 0 15.23 238.69 20.11 218.58 -1.92 0.89 217.55 102.43 51.49 18.02 7.61 6.26 1.07 0 186.88 32.59 30.67 7.29 23.38 5.89 0 17.49 0.47 17.96 5.9 12.05 84.45 0 0 0 110.75 10.88 0 26.11 Mar '09 269.61 11.12 258.49 -0.65 -0.87 256.97 112.73 63.05 19.27 9.26 11.66 1.31 0 217.28 40.34 39.69 6.67 33.02 6.88 0 26.14 0.21 26.35 7.83 18.12 104.55 0 0 0 110.75 16.36 0 42.47
Analysis of Shreyans Industries Ltd.
Ratio Analysis
Liquidity Ratios
Current Ratio Quick Ratio
Solvency Ratios
Debt-Equity Ratio Liabilities To Equity Ratio Interest Coverage Ratio Debt-Asset Ratio
Efficiency Ratios
Inventory Turnover Debtor Turnover Average Collection Period Fixed Assets Turnover Total Assets Turnover
Profitability Ratios
Gross Profit Margin Net Profit Margin Return on Assets Basic Earning Power Return on Equity
dustries Ltd.
Formulae Current Assets/Current Liabilities (Current Assets - Inventories)/Current Liabilities Debt/Equity Total Liabilities/Equity PBIT/Interest Expense Debt/Assets COGS/Avg Inventory Net Sales/Avg. Sundry Debtors 365/Debtor Turnover Net Sales/Avg Net Fixed Assets Net Sales/ Avg Total Assets Gross Profit/ Net Sales Net Profit/ Net Sales PAT/Avg Total Assets PBIT/Avg Total Assets Equity Earnings/Avg Equity Mar '05 Mar '06 Mar '07 1.535509 1.501845 1.227075 1.188879 1.221402 0.925099 36.79386 51.30702 0.353963 1.651053 7.050831 10.22972 2.169268 1.476863 15.02186 6.542993 55.78487 2.676746 2.121863 4.166667 7.167853 2.552139 1.131422 14.24836 7.818683 46.68305 2.818414 2.340807
0.060714 0.135164 0.123664 -0.03248 0.044458 0.033424 0.094334 0.078239 0.214417 0.225277 1.270983 0.48948
Mar '08
Mar '09
1.405865 1.197107 1.017637 0.814467 2.423895 1.157406 3.964321 2.145435 3.399177 4.91904 1.119256 0.97855 11.08733 11.06518 8.303134 10.6484 43.95931 34.27744 2.75359 2.71096 2.279844 2.294018 0.149099 0.055129 0.125684 0.258462 0.508332 0.15606 0.070099 0.160809 0.291179 0.418863
Comments
Liquidity Ratios
1.8 1.6 1.4 1.2 1 0.8 0.6 0.4 0.2 0 Current Ratio 30 40 50 Debt-Equity Ratio Liabilities To Equity Ratio Interest Coverage Ratio Debt-Asset Ratio
Solvency Ratios
60
Quick Ratio
20
Gross Profit Margin=Gross Profit/ Net Sales Net Profit Margin=Net Profit/ Net Sales
Mar '05 Mar '06 Mar '07 Mar '08 Mar '09 10
Decreasing Current Ratio is indicating that the company's ability to meet its current liabilities with current assets is decreasing. This is a bad news for its short-term creditors. Decreasing Quick Ratio is indicating that company's ability to meet its current liabilities with more liquid assets is also decreasing which is also a bad news.
0 Mar '05 Mar '06 Mar '07 Mar '08 Mar '09
Decreasing Debt-Equity Ratio is indicating that riskiness for creditors is decreasing. This is a good news for the company. Decreasing Liability to Equity Ratio is a good indicator for the company as it supports decreasing debt to equity ratio. Increasing Interest coverageRatio is indicating that the company is becoming increasingly secure for the creditors who will receive the interest charges in time. So, the company has sufficient income to cover its interest requirements as of 2009. Decreasing Debt Asset Ratio is indicating that the support of borrowed funds for firm's asset is decreasing. This is good for the company as the company's
good for the company as the company's dependence on borrowings is decreasing.
Conclusion : Thus, after analysing the company's financial reports through various ratios , it can be safely said that the term obligations when they fall due is decreasing, firm's long-term solvency is improving, its asset management is and the performance of the company in terms of operating successis is improving steadily through the years.
Efficiency Ratios
60
Profitability Ratios
1.4
1.2 50 1 40 Inventory Turnover Debtor Turnover 0.8 Average Collection Period 30 Fixed Assets Turnover 0.6 Total Assets Turnover 20 0.4 Gross Profit Margin Net Profit Margin Return on Assets Basic Earning Power Return on Equity
10
0.2
0 0 Mar '05 Mar '06 Mar '07 Mar '08 Mar '09 -0.2 Mar '05 Mar '06 Mar '07 Mar '08 Mar '09
secure for
sset Ratio
Decreasing Inventory Turnover is indicating that the efficiency of inventory management of firm is decreasing which is bad for the company. Increasing Debtor Turnover is a good indicator of the company's ability to collect credit from the customers in a prompt manner. So, company is having a better management of receivables. Decreasing Avg Collection period is good for the company as it will now have less Days Sales Outstanding which have been reduced from 55 in 2005 to 34 in 2009. Fixed Asset Turnover has remained constant around 2.7 indicating that the firm has high degree of efficiency in asset utilization i.e. sales per Rupee of investment is around Rs. 2.7. A constant Total Asset Turnover of around 2.3 is indicating that the firm is utilizing its overall assets very efficiently.
Increased Gross Profit Margin over the years is indicating the increased efficiency of production as well as pricing of the company. This is good for the company. Increased Net Profit Margin over the years is indicating the increased efficiency of production, administration, selling, financing, pricing and tax management of the company. This is good for the company as it indicates the cushion available to the company. Return on Assets has also increased over the years which indicates that the overall profitability of the firm has increased and is good for the company. Basic Earning Power has also increased sharply over the years indicating an improvement in the operating performance of the company. Return on Equity has fallen sharply over the years due to a sharp increase in equity but a small increase in equity earnings over the years. So, this
overall assets very efficiently.
the years due to a sharp increase in equity but a small increase in equity earnings over the years. So, this decrease can't be said to be bad. ROE has been higher than ROA throughout the years so earnings per rupee of shareholder's funds has been more than that of assets which is good.
it can be safely said that the ability of the firm to meet its shortis improving, its asset management is also becoming efficient oving steadily through the years. Thus overall, the company is
Mar '09
Margin over the ncy of production as good for the
argin over the years production, ng and tax ood for the ailable to the
lso increased over all profitability of he company. as also increased provement in the
allen sharply over uity but a small ars. So, this
uity but a small ars. So, this has been higher nings per rupee of n that of assets
doc_643999739.xlsx
This is a spreadsheet explains on financial analysis of Shreyans Industries Ltd.
Analysis of Shreyans Industries Ltd.
Balance Sheet Sources Of Funds Total Share Capital Equity Share Capital Share Application Money Preference Share Capital Reserves Revaluation Reserves Networth Secured Loans Unsecured Loans Total Debt Total Liabilities Application Of Funds Gross Block Less: Accum. Depreciation Net Block Capital Work in Progress Investments Inventories Sundry Debtors Cash and Bank Balance Total Current Assets Loans and Advances Fixed Deposits Total CA, Loans & Advances Deffered Credit Current Liabilities Provisions Total CL & Provisions Net Current Assets Miscellaneous Expenses Total Assets Contingent Liabilities Book Value (Rs) ------------------- in Rs. Cr. ------------------Mar '05 Mar '06 Mar '07 Mar '08 11.07 11.07 0 0 -8.79 0 2.28 80.07 3.82 83.89 86.17 117.42 51.62 65.8 1.98 0.55 11.47 28.43 1.39 41.29 8.72 0.8 50.81 0 33.06 0.03 33.09 17.72 0.15 86.2 3.01 2.07 11.07 11.07 0 0 -0.84 0 10.23 69.42 2.71 72.13 82.36 119.75 56.57 63.18 2.65 0.2 9.12 26.23 2.31 37.66 10.55 0.63 48.84 0 32.2 0.32 32.52 16.32 0 82.35 9.46 9.24 11.07 11.07 0 0 5.79 0 16.86 67.63 2.62 70.25 87.11 127.48 62.18 65.3 9.63 0.01 15.28 24.51 1.35 41.14 20.28 0.67 62.09 0 49.4 1.2 50.6 11.49 0.7 87.13 10.14 15.23 11.07 11.07 1.64 0 17.84 0 30.55 71.5 2.55 74.05 104.6 124.31 62.43 61.88 21.95 0.01 18.27 28.14 3.23 49.64 14.54 1.98 66.16 0 46.61 0.45 47.06 19.1 1.68 104.62 7.17 26.11 Mar '09 11.07 11.07 8.94 0 35.96 0 55.97 61.77 3.01 64.78 120.75 169.82 67.21 102.61 4.26 2.97 21.16 20.41 1.59 43.16 22.24 0.8 66.2 0 48.97 6.33 55.3 10.9 0 120.74 1.1 42.47
Analysis of Shreyans Industries Ltd.
Profit & Loss account Income Sales Turnover Excise Duty Net Sales Other Income Stock Adjustments Total Income Expenditure Raw Materials Power & Fuel Cost Employee Cost Other Manufacturing Expenses Selling and Admin Expenses Miscellaneous Expenses Preoperative Exp Capitalised Total Expenses Operating Profit PBDIT Interest PBDT Depreciation Other Written Off Profit Before Tax Extra-ordinary items PBT (Post Extra-ord Items) Tax Reported Net Profit Total Value Addition Preference Dividend Equity Dividend Corporate Dividend Tax Per share data (annualised) Shares in issue (lakhs) Earning Per Share (Rs) Equity Dividend (%) Book Value (Rs) ------------------- in Rs. Cr. ------------------Mar '05 Mar '06 Mar '07 Mar '08 158.32 14.53 143.79 -0.11 -0.88 142.8 70.7 33.74 13.88 5.46 9.39 1.01 0 134.18 8.73 8.62 9.21 -0.59 5.21 0.15 -5.95 1.3 -4.65 0.02 -4.67 63.48 0 0 0 110.75 -4.22 0 2.07 193.31 14.49 178.82 -0.3 -0.83 177.69 85.2 40.15 13.87 5.95 7.48 1.17 0 153.82 24.17 23.87 8.33 15.54 5.65 0.15 9.74 1.02 10.76 2.83 7.95 68.63 0 0 0 110.75 7.18 0 9.24 214.44 16.08 198.36 0.4 0.82 199.58 96.72 47.6 15.19 7.21 6.75 1.18 0 174.65 24.53 24.93 7.48 17.45 5.84 0 11.61 0.26 11.87 5.26 6.63 77.92 0 0 0 110.75 5.98 0 15.23 238.69 20.11 218.58 -1.92 0.89 217.55 102.43 51.49 18.02 7.61 6.26 1.07 0 186.88 32.59 30.67 7.29 23.38 5.89 0 17.49 0.47 17.96 5.9 12.05 84.45 0 0 0 110.75 10.88 0 26.11 Mar '09 269.61 11.12 258.49 -0.65 -0.87 256.97 112.73 63.05 19.27 9.26 11.66 1.31 0 217.28 40.34 39.69 6.67 33.02 6.88 0 26.14 0.21 26.35 7.83 18.12 104.55 0 0 0 110.75 16.36 0 42.47
Analysis of Shreyans Industries Ltd.
Ratio Analysis
Liquidity Ratios
Current Ratio Quick Ratio
Solvency Ratios
Debt-Equity Ratio Liabilities To Equity Ratio Interest Coverage Ratio Debt-Asset Ratio
Efficiency Ratios
Inventory Turnover Debtor Turnover Average Collection Period Fixed Assets Turnover Total Assets Turnover
Profitability Ratios
Gross Profit Margin Net Profit Margin Return on Assets Basic Earning Power Return on Equity
dustries Ltd.
Formulae Current Assets/Current Liabilities (Current Assets - Inventories)/Current Liabilities Debt/Equity Total Liabilities/Equity PBIT/Interest Expense Debt/Assets COGS/Avg Inventory Net Sales/Avg. Sundry Debtors 365/Debtor Turnover Net Sales/Avg Net Fixed Assets Net Sales/ Avg Total Assets Gross Profit/ Net Sales Net Profit/ Net Sales PAT/Avg Total Assets PBIT/Avg Total Assets Equity Earnings/Avg Equity Mar '05 Mar '06 Mar '07 1.535509 1.501845 1.227075 1.188879 1.221402 0.925099 36.79386 51.30702 0.353963 1.651053 7.050831 10.22972 2.169268 1.476863 15.02186 6.542993 55.78487 2.676746 2.121863 4.166667 7.167853 2.552139 1.131422 14.24836 7.818683 46.68305 2.818414 2.340807
0.060714 0.135164 0.123664 -0.03248 0.044458 0.033424 0.094334 0.078239 0.214417 0.225277 1.270983 0.48948
Mar '08
Mar '09
1.405865 1.197107 1.017637 0.814467 2.423895 1.157406 3.964321 2.145435 3.399177 4.91904 1.119256 0.97855 11.08733 11.06518 8.303134 10.6484 43.95931 34.27744 2.75359 2.71096 2.279844 2.294018 0.149099 0.055129 0.125684 0.258462 0.508332 0.15606 0.070099 0.160809 0.291179 0.418863
Comments
Liquidity Ratios
1.8 1.6 1.4 1.2 1 0.8 0.6 0.4 0.2 0 Current Ratio 30 40 50 Debt-Equity Ratio Liabilities To Equity Ratio Interest Coverage Ratio Debt-Asset Ratio
Solvency Ratios
60
Quick Ratio
20
Gross Profit Margin=Gross Profit/ Net Sales Net Profit Margin=Net Profit/ Net Sales
Mar '05 Mar '06 Mar '07 Mar '08 Mar '09 10
Decreasing Current Ratio is indicating that the company's ability to meet its current liabilities with current assets is decreasing. This is a bad news for its short-term creditors. Decreasing Quick Ratio is indicating that company's ability to meet its current liabilities with more liquid assets is also decreasing which is also a bad news.
0 Mar '05 Mar '06 Mar '07 Mar '08 Mar '09
Decreasing Debt-Equity Ratio is indicating that riskiness for creditors is decreasing. This is a good news for the company. Decreasing Liability to Equity Ratio is a good indicator for the company as it supports decreasing debt to equity ratio. Increasing Interest coverageRatio is indicating that the company is becoming increasingly secure for the creditors who will receive the interest charges in time. So, the company has sufficient income to cover its interest requirements as of 2009. Decreasing Debt Asset Ratio is indicating that the support of borrowed funds for firm's asset is decreasing. This is good for the company as the company's
good for the company as the company's dependence on borrowings is decreasing.
Conclusion : Thus, after analysing the company's financial reports through various ratios , it can be safely said that the term obligations when they fall due is decreasing, firm's long-term solvency is improving, its asset management is and the performance of the company in terms of operating successis is improving steadily through the years.
Efficiency Ratios
60
Profitability Ratios
1.4
1.2 50 1 40 Inventory Turnover Debtor Turnover 0.8 Average Collection Period 30 Fixed Assets Turnover 0.6 Total Assets Turnover 20 0.4 Gross Profit Margin Net Profit Margin Return on Assets Basic Earning Power Return on Equity
10
0.2
0 0 Mar '05 Mar '06 Mar '07 Mar '08 Mar '09 -0.2 Mar '05 Mar '06 Mar '07 Mar '08 Mar '09
secure for
sset Ratio
Decreasing Inventory Turnover is indicating that the efficiency of inventory management of firm is decreasing which is bad for the company. Increasing Debtor Turnover is a good indicator of the company's ability to collect credit from the customers in a prompt manner. So, company is having a better management of receivables. Decreasing Avg Collection period is good for the company as it will now have less Days Sales Outstanding which have been reduced from 55 in 2005 to 34 in 2009. Fixed Asset Turnover has remained constant around 2.7 indicating that the firm has high degree of efficiency in asset utilization i.e. sales per Rupee of investment is around Rs. 2.7. A constant Total Asset Turnover of around 2.3 is indicating that the firm is utilizing its overall assets very efficiently.
Increased Gross Profit Margin over the years is indicating the increased efficiency of production as well as pricing of the company. This is good for the company. Increased Net Profit Margin over the years is indicating the increased efficiency of production, administration, selling, financing, pricing and tax management of the company. This is good for the company as it indicates the cushion available to the company. Return on Assets has also increased over the years which indicates that the overall profitability of the firm has increased and is good for the company. Basic Earning Power has also increased sharply over the years indicating an improvement in the operating performance of the company. Return on Equity has fallen sharply over the years due to a sharp increase in equity but a small increase in equity earnings over the years. So, this
overall assets very efficiently.
the years due to a sharp increase in equity but a small increase in equity earnings over the years. So, this decrease can't be said to be bad. ROE has been higher than ROA throughout the years so earnings per rupee of shareholder's funds has been more than that of assets which is good.
it can be safely said that the ability of the firm to meet its shortis improving, its asset management is also becoming efficient oving steadily through the years. Thus overall, the company is
Mar '09
Margin over the ncy of production as good for the
argin over the years production, ng and tax ood for the ailable to the
lso increased over all profitability of he company. as also increased provement in the
allen sharply over uity but a small ars. So, this
uity but a small ars. So, this has been higher nings per rupee of n that of assets
doc_643999739.xlsx