Description
This is a spreadsheet describes on the balance sheet analysis of Kalindee Rail Nirman.
RATIO ANALYSIS
Kalindee Rail Nirman
BALANCE SHEET------------------- in Rs. Cr. ------------------Mar '05 Mar '06 Mar '07 Mar '08 Mar '09
12 mths
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
12 mths
12 mths
12 mths
12 mths
4.95 4.95 0 0 9.52 0 14.47 11.72 0 11.72 26.19 Mar '05
4.95 4.95 0 0 12.7 0 17.65 25.88 15.58 41.46 59.11 Mar '06
10.5 10.5 0.02 0 59.04 0 69.56 23.56 30.53 54.09 123.65 Mar '07
10.73 10.73 0 0 75.08 0 85.81 48.13 28.01 76.14 161.95 Mar '08
11.22 11.22 0 0 91.73 0 102.95 56.5 25.76 82.26 185.21 Mar '09
12 mths
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
12 mths
12 mths
12 mths
12 mths
8.12 3.18 4.94 0 0 13.08 4.92 0.37 18.37 9.69 4.69 32.75 0 10.37 1.14 11.51 21.24 0 26.18
9.1 3.53 5.57 0 0 19.48 24.36 0.47 44.31 13.46 7.14 64.91 0 8.37 3 11.37 53.54 0 59.11
10.88 4.07 6.81 0 0 42.71 40.77 4.24 87.72 23.95 46.24 157.91 0 34.84 6.23 41.07 116.84 0 123.65
21.51 4.81 16.7 0 0.3 89.54 34.12 0.79 124.45 43.83 24.84 193.12 0 40.38 7.79 48.17 144.95 0 161.95
22.95 6.07 16.88 0 0.3 83.74 48.24 0.15 132.13 44.68 29.3 206.11 0 32.96 5.12 38.08 168.03 0 185.21
Contingent Liabilities Book Value (Rs)
0 29.24
0 35.68
0 66.24
0 79.99
0 91.72
LIQUIDITY RATIO current ratio quick ratio Debt equity ratio DEBT COVERAGE RATIO Interest cover MANAGEMENT EFFICIENCY RATIO Inventory turnover ratio Debtor turnover ratio Fixed asset turnover ratio Asset turnover ratio PROFITABILITY RATIO Gross profit margin(%) Net profit margin(%) Return on net worth(%) EPS (earning per share)
1.771456 5.293907 2.517796 3.081971 4.008799 0.510125 2.966547 1.291906 0.864537 1.468143 0.809952 2.349008 0.777602 0.887309 0.799029
1.757946 2.459091 3.504288 4.275542 2.268172
4.134557 10.99187 3.737388 2.06491
4.626797 3.699918 5.106516 1.524784
4.404589 4.614177 2.704428 1.521391
2.747711 7.210727 2.867148 1.519173
3.358252 5.829602 2.731617 1.518385
14.21967 3.642751 13.61437 3.983017
12.60402 4.005326 20.45326 7.298827
11.18967 11.58395 11.58168 5.018074 5.779783 3.712396 13.57102 16.5715 10.14085 8.993046 13.25627 9.300668
s. Cr. -------------------
Profit & Loss account of Kalindee Rail Nirman
------------------- in Rs. Cr. -----------------Mar '05 Mar '06 Mar '07 Mar '08
12 mths
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
12 mths
12 mths
12 mths
54.08 0 54.08 0.27 0 54.35 27.61 0.19 4.37 10.19 3.5 0.8 0 46.66 Mar '05
90.13 0 90.13 -0.29 0 89.84 46.94 0.27 4.32 19.56 6.25 1.14 0 78.48 Mar '06
188.12 0 188.12 -0.01 0 188.11 82.48 0.18 5.24 68.98 8.83 1.35 0 167.06 Mar '07
246.03 0 246.03 2 0 248.03 157.49 0.6 6.98 43.08 9.8 1.58 0 219.53 Mar '08
12 mths
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) 7.42 7.69 4.09 3.6 0.5 0 3.1 0 3.1 1.14 1.97 19.05 0 0 0
12 mths
11.65 11.36 4.4 6.96 0.54 0 6.42 -0.36 6.06 2.44 3.61 31.55 0 0.49 0.07
12 mths
21.06 21.05 5.83 15.22 0.62 0 14.6 -0.16 14.44 5 9.44 84.58 0 1.05 0.18
12 mths
26.5 28.5 6.46 22.04 0.88 0 21.16 -0.05 21.11 6.89 14.22 62.04 0 1.07 0.18
Shares in issue (lakhs) Earning Per Share (Rs) Equity Dividend (%) Book Value (Rs)
49.46 3.99 0 29.24
49.46 7.3 10 35.68
104.97 8.99 10 66.24
107.27 13.25 10 79.99
Mar '09
12 mths
281.22 0 281.22 0.17 0 281.39 106.89 0.65 9.51 113.04 16.69 2.04 0 248.82 Mar '09
12 mths
32.4 32.57 14.17 18.4 1.39 0.96 16.05 0 16.05 5.61 10.44 141.93 0 0 0
112.25 9.3 0 91.72
RATIO ANALYSIS
PROFITABILITY RATIO
Current ratio Quick ratio Debt equity ratio
DEBT COVERAGE RATIO
Interest cover
MANAGEMENT EFFICIENCY RATIO
Inventory turnover ratio Debtor turnover ratio Fixed asset turnover ratio Asset turnover ratio
PROFITABILITY RATIO
Gross profit margin(%) Net profit margin(%) Return on net worth(%) EPS (earning per share)
This ratio has beeen increasing in the past 5 years. It can be seen that the quick ratio is very smaller than the current ratio. This shows that inventory levels of Kalindee are very high. This ratio is somewhat similar for the past 5 years depicting that the % of debt and equity in the capital structure has remained sam
This ratio is increasing to a large extent.This means that amount of interest is increasing slowly.
This ratio is decreasing for the past 5 years which means that the inventory conversion period is increasing. This ratio is fluctuating but overall decreasing, it will be not so good for the cpmpany because it will increase DSO. It shows the sales on each rupee of fixed assets of a company. Its sales are somewhat constant as the ratio is constant. It shows the sales on each rupee of total assets of a company.It is constant which is moderate for the company in long term.
it shows the total profitability of a company without taking into account taxes and depriciation.It has decreased in the past 5 Years It shows the net profitability of a company .It is decreasing for the company so it is not good for the company to sustain its operati It has decreased from 13.6% to 10.14%. This means that the sales are slowly decreasing. The ratio has increased from 3.9% to 9.3% which means the company is returning dividends to its shareholders.
levels of Kalindee are very high. pital structure has remained same.
the ratio is constant. he company in long term.
as decreased in the past 5 Years depicting that the profit margin is decreasing. It is a major concern for the company. e company to sustain its operations in long term.
doc_584450368.xls
This is a spreadsheet describes on the balance sheet analysis of Kalindee Rail Nirman.
RATIO ANALYSIS
Kalindee Rail Nirman
BALANCE SHEET------------------- in Rs. Cr. ------------------Mar '05 Mar '06 Mar '07 Mar '08 Mar '09
12 mths
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
12 mths
12 mths
12 mths
12 mths
4.95 4.95 0 0 9.52 0 14.47 11.72 0 11.72 26.19 Mar '05
4.95 4.95 0 0 12.7 0 17.65 25.88 15.58 41.46 59.11 Mar '06
10.5 10.5 0.02 0 59.04 0 69.56 23.56 30.53 54.09 123.65 Mar '07
10.73 10.73 0 0 75.08 0 85.81 48.13 28.01 76.14 161.95 Mar '08
11.22 11.22 0 0 91.73 0 102.95 56.5 25.76 82.26 185.21 Mar '09
12 mths
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
12 mths
12 mths
12 mths
12 mths
8.12 3.18 4.94 0 0 13.08 4.92 0.37 18.37 9.69 4.69 32.75 0 10.37 1.14 11.51 21.24 0 26.18
9.1 3.53 5.57 0 0 19.48 24.36 0.47 44.31 13.46 7.14 64.91 0 8.37 3 11.37 53.54 0 59.11
10.88 4.07 6.81 0 0 42.71 40.77 4.24 87.72 23.95 46.24 157.91 0 34.84 6.23 41.07 116.84 0 123.65
21.51 4.81 16.7 0 0.3 89.54 34.12 0.79 124.45 43.83 24.84 193.12 0 40.38 7.79 48.17 144.95 0 161.95
22.95 6.07 16.88 0 0.3 83.74 48.24 0.15 132.13 44.68 29.3 206.11 0 32.96 5.12 38.08 168.03 0 185.21
Contingent Liabilities Book Value (Rs)
0 29.24
0 35.68
0 66.24
0 79.99
0 91.72
LIQUIDITY RATIO current ratio quick ratio Debt equity ratio DEBT COVERAGE RATIO Interest cover MANAGEMENT EFFICIENCY RATIO Inventory turnover ratio Debtor turnover ratio Fixed asset turnover ratio Asset turnover ratio PROFITABILITY RATIO Gross profit margin(%) Net profit margin(%) Return on net worth(%) EPS (earning per share)
1.771456 5.293907 2.517796 3.081971 4.008799 0.510125 2.966547 1.291906 0.864537 1.468143 0.809952 2.349008 0.777602 0.887309 0.799029
1.757946 2.459091 3.504288 4.275542 2.268172
4.134557 10.99187 3.737388 2.06491
4.626797 3.699918 5.106516 1.524784
4.404589 4.614177 2.704428 1.521391
2.747711 7.210727 2.867148 1.519173
3.358252 5.829602 2.731617 1.518385
14.21967 3.642751 13.61437 3.983017
12.60402 4.005326 20.45326 7.298827
11.18967 11.58395 11.58168 5.018074 5.779783 3.712396 13.57102 16.5715 10.14085 8.993046 13.25627 9.300668
s. Cr. -------------------
Profit & Loss account of Kalindee Rail Nirman
------------------- in Rs. Cr. -----------------Mar '05 Mar '06 Mar '07 Mar '08
12 mths
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
12 mths
12 mths
12 mths
54.08 0 54.08 0.27 0 54.35 27.61 0.19 4.37 10.19 3.5 0.8 0 46.66 Mar '05
90.13 0 90.13 -0.29 0 89.84 46.94 0.27 4.32 19.56 6.25 1.14 0 78.48 Mar '06
188.12 0 188.12 -0.01 0 188.11 82.48 0.18 5.24 68.98 8.83 1.35 0 167.06 Mar '07
246.03 0 246.03 2 0 248.03 157.49 0.6 6.98 43.08 9.8 1.58 0 219.53 Mar '08
12 mths
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) 7.42 7.69 4.09 3.6 0.5 0 3.1 0 3.1 1.14 1.97 19.05 0 0 0
12 mths
11.65 11.36 4.4 6.96 0.54 0 6.42 -0.36 6.06 2.44 3.61 31.55 0 0.49 0.07
12 mths
21.06 21.05 5.83 15.22 0.62 0 14.6 -0.16 14.44 5 9.44 84.58 0 1.05 0.18
12 mths
26.5 28.5 6.46 22.04 0.88 0 21.16 -0.05 21.11 6.89 14.22 62.04 0 1.07 0.18
Shares in issue (lakhs) Earning Per Share (Rs) Equity Dividend (%) Book Value (Rs)
49.46 3.99 0 29.24
49.46 7.3 10 35.68
104.97 8.99 10 66.24
107.27 13.25 10 79.99
Mar '09
12 mths
281.22 0 281.22 0.17 0 281.39 106.89 0.65 9.51 113.04 16.69 2.04 0 248.82 Mar '09
12 mths
32.4 32.57 14.17 18.4 1.39 0.96 16.05 0 16.05 5.61 10.44 141.93 0 0 0
112.25 9.3 0 91.72
RATIO ANALYSIS
PROFITABILITY RATIO
Current ratio Quick ratio Debt equity ratio
DEBT COVERAGE RATIO
Interest cover
MANAGEMENT EFFICIENCY RATIO
Inventory turnover ratio Debtor turnover ratio Fixed asset turnover ratio Asset turnover ratio
PROFITABILITY RATIO
Gross profit margin(%) Net profit margin(%) Return on net worth(%) EPS (earning per share)
This ratio has beeen increasing in the past 5 years. It can be seen that the quick ratio is very smaller than the current ratio. This shows that inventory levels of Kalindee are very high. This ratio is somewhat similar for the past 5 years depicting that the % of debt and equity in the capital structure has remained sam
This ratio is increasing to a large extent.This means that amount of interest is increasing slowly.
This ratio is decreasing for the past 5 years which means that the inventory conversion period is increasing. This ratio is fluctuating but overall decreasing, it will be not so good for the cpmpany because it will increase DSO. It shows the sales on each rupee of fixed assets of a company. Its sales are somewhat constant as the ratio is constant. It shows the sales on each rupee of total assets of a company.It is constant which is moderate for the company in long term.
it shows the total profitability of a company without taking into account taxes and depriciation.It has decreased in the past 5 Years It shows the net profitability of a company .It is decreasing for the company so it is not good for the company to sustain its operati It has decreased from 13.6% to 10.14%. This means that the sales are slowly decreasing. The ratio has increased from 3.9% to 9.3% which means the company is returning dividends to its shareholders.
levels of Kalindee are very high. pital structure has remained same.
the ratio is constant. he company in long term.
as decreased in the past 5 Years depicting that the profit margin is decreasing. It is a major concern for the company. e company to sustain its operations in long term.
doc_584450368.xls