Description
This is a spreadsheet explains on financial analysis of Maruti Suzuki Ltd.
RATIO ANALYSIS
Balance sheet of Bata India
------------------- 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
144.5 144.5 0 0 4,234.30 0 4,378.80 307.6 0 307.6 4,686.40 Mar '05
144.5 144.5 0 0 5,308.10 0 5,452.60 71.7 0 71.7 5,524.30 Mar '06
144.5 144.5 0 0 6,709.40 0 6,853.90 63.5 567.3 630.8 7,484.70 Mar '07
144.5 144.5 0 0 8,270.90 0 8,415.40 0.1 900.1 900.2 9,315.60 Mar '08
144.5 144.5 0 0 9,200.40 0 9,344.90 0.1 698.8 698.9 10,043.80 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
12 mths
12 mths
12 mths
12 mths
5,053.10 3,179.40 1,873.70 42.1 1,516.60 666.6 599.5 79.4 1,345.50 801.9 950 3,097.40 0 1,454.20 389.2 1,843.40 1,254.00 0
4,954.60 3,259.40 1,695.20 92 2,051.20 881.2 654.8 51.6 1,587.60 933.1 1,350.00 3,870.70 0 1,704.80 480 2,184.80 1,685.90 0
6,146.80 3,487.10 2,659.70 238.9 3,409.20 713.2 747.4 114.8 1,575.40 1,072.60 1,308.00 3,956.00 0 2,288.60 490.5 2,779.10 1,176.90 0
7,285.30 3,988.80 3,296.50 736.3 5,180.70 1,038.00 655.5 324 2,017.50 1,173.00 0 3,190.50 0 2,718.90 369.5 3,088.40 102.1 0
8,720.60 4,649.80 4,070.80 861.3 3,173.30 902.3 918.9 239 2,060.20 1,809.80 1,700.00 5,570.00 0 3,250.90 380.7 3,631.60 1,938.40 0
Total Assets Contingent Liabilities Book Value (Rs)
4,686.40 893.6 151.56
5,524.30 1,289.70 188.73
7,484.70 2,094.60 237.23
9,315.60 2,734.20 291.28
10,043.80 1,901.70 323.45
LIQUIDITY RATIO current ratio quick ratio Debt equity ratio DEBT COVERAGE RATIO Interest cover
0.925251 0.931253 0.688368 0.742028 0.633732 0.466855 0.414359 0.376737 0.360256 0.356178 0.070248 0.01315 0.092035 0.106971 0.074789
37.26111 88.07353
61.7766 42.86074
34.5451
MANAGEMENT EFFICIENCY RATIO Inventory turnover ratio 20.18932 16.9074 24.33875 20.42428 25.91322 Debtor turnover ratio 22.44904 22.75321 23.22505 32.34233 25.4451 Fixed asset turnover ratio 3.07349 2.732421 2.532631 2.519239 2.50206 Asset turnover ratio 2.871757 2.696957 2.319184 2.275795 2.327954 PROFITABILITY RATIO Gross profit margin(%) Net profit margin(%) Return on net worth(%) EPS (earning per share)
13.24026 13.97495 14.94493 14.72944 10.55664 6.342602 7.98118 8.998525 8.163997 5.21224 19.49393 21.80794 22.78994 20.56706 13.04134 29.54553 41.15815 54.06528 59.90793 42.18269
Profit and loss of maruti india
------------------ in Rs. Cr. ----------------Mar '05 Mar '06 Mar '07 Mar '08 Mar '09
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
12 mths
13,458.20 2,411.90 11,046.30 187.5 141.7 11,375.50 8,650.20 58.1 196 215.7 374.27 121.73 -22.4 9,593.60 Mar '05
14,898.80 2,700.90 12,197.90 184.4 199.7 12,582.00 9,423.40 57.2 228.7 302.4 349.51 145.39 -6.7 10,499.90 Mar '06
17,358.40 2,552.00 14,806.40 338.1 -200.7 14,943.80 10,863.00 97.4 288.4 392.4 483.26 239.44 -14.3 12,349.60 Mar '07
21,200.40 3,133.60 18,066.80 494 336.3 18,897.10 13,958.30 147.3 356.2 523.3 521.48 287.62 -19.8 15,774.40 Mar '08
23,381.50 2,652.10 20,729.40 491.7 -356.6 20,864.50 15,983.20 193.6 471.1 716.1 751.06 303.44 -22.3 18,396.20 Mar '09
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 1,594.40 1,781.90 36 1,745.90 456.8 16.3 1,272.80 51.4 1,324.20 446.5 853.6 943.4 0 57.8 8.2
12 mths
1,897.70 2,082.10 20.4 2,061.70 285.4 0 1,776.30 5.4 1,781.70 560.9 1,189.10 1,076.50 0 101.1 14.2
12 mths
2,256.10 2,594.20 37.6 2,556.60 271.4 0 2,285.20 33.4 2,318.60 705.3 1,562.00 1,486.60 0 130 21.9
12 mths
2,628.70 3,122.70 59.6 3,063.10 568.2 0 2,494.90 76.6 2,571.50 763.3 1,730.80 1,816.10 0 144.5 24.8
12 mths
1,976.60 2,468.30 51 2,417.30 706.5 0 1,710.80 37.9 1,748.70 457.1 1,218.70 2,413.00 0 101.1 17.2
Per share data (annualised) Shares in issue (lakhs) Earning Per Share (Rs) Equity Dividend (%) Book Value (Rs)
2,889.10 29.55 40 151.56
2,889.10 41.16 70 188.73
2,889.10 54.07 90 237.23
2,889.10 59.91 100 291.28
2,889.10 42.18 70 323.45
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 is fluctuating in this case, but ultimately decreases than 2005, liquidity position is getting weak but there can be tha
This ratio is falling year after year ----- current asset minus inventory / current liabilities. We can see that level of inventory is This ratio is constantly fluctuating capital structure is constanly changing as there is different proportions in it.
This ratio is increasing to a large extent and then decreasing.This means that amount of interest is increasing rapidly and then
This ratio is constantly fluctuating for the period, it will be better for the company because it will raduce the inventory conver This ratio is increased from 20 to 25 recently, it will be better for the company because it will reduce DSO. It shows the sales on each rupee of fixed assets of a company.however it decreased from 3 to 2.5 which shows that company it shows the sales on each rupee of total assets of a company.it is decreasing which is not so good for the company in long ter
it shows the total profitability of a company without taking into account taxes and depriciation.it increased from 13% to 14% it shows the net profitability of a company .it is increased from 6% to 8% recently and then decreased to 5% which is not goo it is increasing from 19% to 20%,which is a good sign.this is because of the increase sales. this ratio is increasing tremendously, it has increased from 29% to 59% then decreased to 42%, which may be due to market
ak but there can be that, the money is taken out of unproductive assets and unnecessary inventories are not kept
hat level of inventory is quiet high for maruti suzuki because quick ratio is much less then the current ratio
easing rapidly and then decreasing.
ce the inventory conversion period.
ch shows that company was not able to achieve sales targets or market condition was not good or because of inability to use the fixed as the company in long term.
ased from 13% to 14% recently in dec'07, but decreased to 10%, may be because of bad market conditions to 5% which is not good for the company to sustain its operations in long term.
may be due to market conditions.
use of inability to use the fixed assets properly.
doc_407452422.xls
This is a spreadsheet explains on financial analysis of Maruti Suzuki Ltd.
RATIO ANALYSIS
Balance sheet of Bata India
------------------- 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
144.5 144.5 0 0 4,234.30 0 4,378.80 307.6 0 307.6 4,686.40 Mar '05
144.5 144.5 0 0 5,308.10 0 5,452.60 71.7 0 71.7 5,524.30 Mar '06
144.5 144.5 0 0 6,709.40 0 6,853.90 63.5 567.3 630.8 7,484.70 Mar '07
144.5 144.5 0 0 8,270.90 0 8,415.40 0.1 900.1 900.2 9,315.60 Mar '08
144.5 144.5 0 0 9,200.40 0 9,344.90 0.1 698.8 698.9 10,043.80 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
12 mths
12 mths
12 mths
12 mths
5,053.10 3,179.40 1,873.70 42.1 1,516.60 666.6 599.5 79.4 1,345.50 801.9 950 3,097.40 0 1,454.20 389.2 1,843.40 1,254.00 0
4,954.60 3,259.40 1,695.20 92 2,051.20 881.2 654.8 51.6 1,587.60 933.1 1,350.00 3,870.70 0 1,704.80 480 2,184.80 1,685.90 0
6,146.80 3,487.10 2,659.70 238.9 3,409.20 713.2 747.4 114.8 1,575.40 1,072.60 1,308.00 3,956.00 0 2,288.60 490.5 2,779.10 1,176.90 0
7,285.30 3,988.80 3,296.50 736.3 5,180.70 1,038.00 655.5 324 2,017.50 1,173.00 0 3,190.50 0 2,718.90 369.5 3,088.40 102.1 0
8,720.60 4,649.80 4,070.80 861.3 3,173.30 902.3 918.9 239 2,060.20 1,809.80 1,700.00 5,570.00 0 3,250.90 380.7 3,631.60 1,938.40 0
Total Assets Contingent Liabilities Book Value (Rs)
4,686.40 893.6 151.56
5,524.30 1,289.70 188.73
7,484.70 2,094.60 237.23
9,315.60 2,734.20 291.28
10,043.80 1,901.70 323.45
LIQUIDITY RATIO current ratio quick ratio Debt equity ratio DEBT COVERAGE RATIO Interest cover
0.925251 0.931253 0.688368 0.742028 0.633732 0.466855 0.414359 0.376737 0.360256 0.356178 0.070248 0.01315 0.092035 0.106971 0.074789
37.26111 88.07353
61.7766 42.86074
34.5451
MANAGEMENT EFFICIENCY RATIO Inventory turnover ratio 20.18932 16.9074 24.33875 20.42428 25.91322 Debtor turnover ratio 22.44904 22.75321 23.22505 32.34233 25.4451 Fixed asset turnover ratio 3.07349 2.732421 2.532631 2.519239 2.50206 Asset turnover ratio 2.871757 2.696957 2.319184 2.275795 2.327954 PROFITABILITY RATIO Gross profit margin(%) Net profit margin(%) Return on net worth(%) EPS (earning per share)
13.24026 13.97495 14.94493 14.72944 10.55664 6.342602 7.98118 8.998525 8.163997 5.21224 19.49393 21.80794 22.78994 20.56706 13.04134 29.54553 41.15815 54.06528 59.90793 42.18269
Profit and loss of maruti india
------------------ in Rs. Cr. ----------------Mar '05 Mar '06 Mar '07 Mar '08 Mar '09
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
12 mths
13,458.20 2,411.90 11,046.30 187.5 141.7 11,375.50 8,650.20 58.1 196 215.7 374.27 121.73 -22.4 9,593.60 Mar '05
14,898.80 2,700.90 12,197.90 184.4 199.7 12,582.00 9,423.40 57.2 228.7 302.4 349.51 145.39 -6.7 10,499.90 Mar '06
17,358.40 2,552.00 14,806.40 338.1 -200.7 14,943.80 10,863.00 97.4 288.4 392.4 483.26 239.44 -14.3 12,349.60 Mar '07
21,200.40 3,133.60 18,066.80 494 336.3 18,897.10 13,958.30 147.3 356.2 523.3 521.48 287.62 -19.8 15,774.40 Mar '08
23,381.50 2,652.10 20,729.40 491.7 -356.6 20,864.50 15,983.20 193.6 471.1 716.1 751.06 303.44 -22.3 18,396.20 Mar '09
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 1,594.40 1,781.90 36 1,745.90 456.8 16.3 1,272.80 51.4 1,324.20 446.5 853.6 943.4 0 57.8 8.2
12 mths
1,897.70 2,082.10 20.4 2,061.70 285.4 0 1,776.30 5.4 1,781.70 560.9 1,189.10 1,076.50 0 101.1 14.2
12 mths
2,256.10 2,594.20 37.6 2,556.60 271.4 0 2,285.20 33.4 2,318.60 705.3 1,562.00 1,486.60 0 130 21.9
12 mths
2,628.70 3,122.70 59.6 3,063.10 568.2 0 2,494.90 76.6 2,571.50 763.3 1,730.80 1,816.10 0 144.5 24.8
12 mths
1,976.60 2,468.30 51 2,417.30 706.5 0 1,710.80 37.9 1,748.70 457.1 1,218.70 2,413.00 0 101.1 17.2
Per share data (annualised) Shares in issue (lakhs) Earning Per Share (Rs) Equity Dividend (%) Book Value (Rs)
2,889.10 29.55 40 151.56
2,889.10 41.16 70 188.73
2,889.10 54.07 90 237.23
2,889.10 59.91 100 291.28
2,889.10 42.18 70 323.45
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 is fluctuating in this case, but ultimately decreases than 2005, liquidity position is getting weak but there can be tha
This ratio is falling year after year ----- current asset minus inventory / current liabilities. We can see that level of inventory is This ratio is constantly fluctuating capital structure is constanly changing as there is different proportions in it.
This ratio is increasing to a large extent and then decreasing.This means that amount of interest is increasing rapidly and then
This ratio is constantly fluctuating for the period, it will be better for the company because it will raduce the inventory conver This ratio is increased from 20 to 25 recently, it will be better for the company because it will reduce DSO. It shows the sales on each rupee of fixed assets of a company.however it decreased from 3 to 2.5 which shows that company it shows the sales on each rupee of total assets of a company.it is decreasing which is not so good for the company in long ter
it shows the total profitability of a company without taking into account taxes and depriciation.it increased from 13% to 14% it shows the net profitability of a company .it is increased from 6% to 8% recently and then decreased to 5% which is not goo it is increasing from 19% to 20%,which is a good sign.this is because of the increase sales. this ratio is increasing tremendously, it has increased from 29% to 59% then decreased to 42%, which may be due to market
ak but there can be that, the money is taken out of unproductive assets and unnecessary inventories are not kept
hat level of inventory is quiet high for maruti suzuki because quick ratio is much less then the current ratio
easing rapidly and then decreasing.
ce the inventory conversion period.
ch shows that company was not able to achieve sales targets or market condition was not good or because of inability to use the fixed as the company in long term.
ased from 13% to 14% recently in dec'07, but decreased to 10%, may be because of bad market conditions to 5% which is not good for the company to sustain its operations in long term.
may be due to market conditions.
use of inability to use the fixed assets properly.
doc_407452422.xls