Description
This is a spreadsheet explains about the balance sheet analysis of Raymond Ltd.
Balance sheet Raymond Ltd.
Mar ' 09 Mar ' 08 Mar ' 07 Mar ' 06 Mar ' 05
Sources of funds Owner's fund Equity share capital 61.38 61.38 61.38 Share application money 20.87 20.87 Preference share capital Reserves & surplus 1,065.60 1,336.90 1,294.78 Loan funds Secured loans 868.85 504.98 566.86 Unsecured loans 476.22 382.03 220.75 Total 2,492.92 2,306.17 2,143.77 Uses of funds Fixed assets Gross block 1,700.64 1,345.40 1,230.03 Less : revaluation reserve Less : accumulated depreciation 701.6 625.88 553.98 Net block 999.05 719.53 676.06 Capital work-in-progress 62.11 13.58 85.69 Investments 888.59 1,047.30 984.48 Net current assets Current assets, loans & advances 1,053.27 965.52 843.82 Less : current liabilities & provisions 510.09 439.77 446.27 Total net current assets 543.17 525.75 397.55 Miscellaneous expenses not written Total 2,492.92 2,306.17 2,143.77 Notes: Book value of unquoted investments 842.83 968.18 893.3 Market value of quoted investments 46.62 149.85 149.73 Contingent liabilities 446.45 428.23 297.08 Number of equity sharesoutstanding (Lacs) 613.81 613.81 613.81
61.38 1,128.56 546.68 221.2 1,957.82 -
61.38
1,042.55 393.33 179.45 1,676.71
1,366.73 677.66 689.07 156.05 736.6 789.73 413.62 376.1 1,957.82 632.35 164.15 544.05 613.81 -
1,140.69 627.98 512.71 62.92 734.27 685.56 318.75 366.81 1,676.71 630.83 137.95 488.95 613.81
Profit loss account Raymond Ltd.
Mar ' 09 Income Operating income Expenses Material consumed Manufacturing expenses Personnel expenses Selling expenses Adminstrative expenses Expenses capitalised Cost of sales Operating profit Other recurring income Adjusted PBDIT Financial expenses Depreciation Other write offs Adjusted PBT Tax charges Adjusted PAT Non recurring items Other non cash adjustments Reported net profit Earnigs before appropriation Equity dividend Preference dividend Dividend tax Retained earnings 1,400.21 507.94 172.83 261 146.14 192.95 1,280.86 119.35 73.85 193.21 85.2 88.81 19.19 -27.15 46.34 -324.28 6.38 -271.55 55.19 55.19 2.61 333.36 14.69 15.57 -0.88 57.66 15.64 72.42 351.31 15.35 5.22 333.39 1,246.02 91.52 64.55 156.07 60.3 81.07 76.67 36.98 39.69 150.47 11.96 202.12 369.29 30.69 4.3 192.02 Mar ' 08 1,337.54 522.06 166.08 233.16 134.17 190.54 Mar ' 07 1,300.36 484.98 164.5 225.58 130.28 148.14 -1.79 1,151.69 148.67 39.65 188.32 48.59 63.06 125.89 41.41 84.48 34.09 2.44 121 227.02 30.69 3.21 116.83 Mar ' 06 1,334.51 522.85 166.86 203.98 116.51 128.64 -1.5 1,137.34 197.17 37.67 234.84 36.24 72.71 79.41 15.01 64.4 3.53 15.21 83.15 144.59 24.55 Mar ' 05 1,167.18 475.17 151.32 202.88 100.71 109.88 -0.42 1,039.55 127.63 45.43 173.05 29.88 63.77
Cash flow staement Raymond Ltd.
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 Mar ' 09 Mar ' 08 Mar ' 07 Mar ' 06 Mar ' 05 -58.75 86.15 156.99 173.65 116.5 120.54 15.52 57.18 157.56 109.45 -361.13 -13.11 -194.22 -287.35 -154.86 265.57 -6.2 137.62 141.58 31.89 24.97 -3.79 0.58 11.78 -13.51 21.82 25.61 25.03 13.25 26.76 46.8 21.82 25.61 25.03 13.25
Ratios Analysis Raymond Ltd.
Mar ' 09 Mar ' 08 -0.14 13.06 10.77 23.98 2.5 14.91 227.8 227.8 217.91 215.57 Mar ' 07 6.47 16.74 32.79 43.06 5 24.22 220.94 220.94 211.85 206.35 Mar ' 06 13.76 25.61 19.92 31.77 5 32.12 193.86 193.86 217.41 179.55 Mar ' 05 10.49 20.88 12.51 22.9 4 20.79 179.85 179.85 190.15 166.39
Per share ratios
Adjusted EPS (Rs) Adjusted cash EPS (Rs) Reported EPS (Rs) Reported cash EPS (Rs) Dividend per share Operating profit per share (Rs) Book value (excl rev res) per share (Rs) Book value (incl rev res) per share (Rs.) Net operating income per share (Rs) Free reserves per share (Rs) 7.55 22.02 -44.05 -29.58 19.44 183.6 183.6 228.12 171.33
Profitability ratios
Operating margin (%) Gross profit margin (%) Net profit margin (%) Adjusted cash margin (%) Adjusted return on net worth (%) Reported return on net worth (%) Return on long term funds (%) 8.52 2.18 -18.34 9.16 4.11 -23.99 4.3 6.84 0.78 4.71 5.71 -0.06 4.72 3.6 11.43 6.58 15.01 7.66 2.92 14.83 6.4 14.77 9.32 8.91 11.45 7.09 10.27 8.71 10.93 5.47 6.33 10.56 5.83 6.95 7.04
Leverage ratios
Long term debt / Equity Total debt/equity Owners fund as % of total source Fixed assets turnover ratio 1.15 1.19 45.58 0.83 0.48 0.63 61.18 1.01 0.44 0.58 63.26 1.07 0.56 0.64 60.77 0.97 0.4 0.51 65.83 1.03
Liquidity ratios
Current ratio Current ratio (inc. st loans) Quick ratio Inventory turnover ratio 2.06 1.75 1.26 4.39 2.2 1.23 1.4 4.35 1.89 1.02 1.21 4.92 1.91 1.3 1.09 4.63 2.15 1.21 1.21 4.47
Payout ratios
Dividend payout ratio (net profit) Dividend payout ratio (cash profit) Earning retention ratio Cash earnings retention ratio 100 27.15 12.19 2,139.42 77.62 17.84 13.58 9.54 65.06 28.61 17.94 58.58 77.74 36.14 19.74 56.89 78.34
Coverage ratios
Adjusted cash flow time total debt Financial charges coverage ratio Fin. charges cov.ratio (post tax) 9.95 2.27 -1.13 11.06 2.59 3.44 7.67 3.88 6.44 4.89 6.48 6.38 4.47 5.79 5.71
CommentsHaving look at various ratios we find that Liquidity ratios, Leverage ratios, Coverage Ratios are well but if we look at the Profitability Ratios we find that Operating Profit margins have decreased over the year and are now they are at loss. This can be partly due to the recession as well as due to the stiff competition from the market. Dividends have also gone low and even this year they have not given dividend this year, so for stakeholder this is a grave concern.
doc_487637873.xls
This is a spreadsheet explains about the balance sheet analysis of Raymond Ltd.
Balance sheet Raymond Ltd.
Mar ' 09 Mar ' 08 Mar ' 07 Mar ' 06 Mar ' 05
Sources of funds Owner's fund Equity share capital 61.38 61.38 61.38 Share application money 20.87 20.87 Preference share capital Reserves & surplus 1,065.60 1,336.90 1,294.78 Loan funds Secured loans 868.85 504.98 566.86 Unsecured loans 476.22 382.03 220.75 Total 2,492.92 2,306.17 2,143.77 Uses of funds Fixed assets Gross block 1,700.64 1,345.40 1,230.03 Less : revaluation reserve Less : accumulated depreciation 701.6 625.88 553.98 Net block 999.05 719.53 676.06 Capital work-in-progress 62.11 13.58 85.69 Investments 888.59 1,047.30 984.48 Net current assets Current assets, loans & advances 1,053.27 965.52 843.82 Less : current liabilities & provisions 510.09 439.77 446.27 Total net current assets 543.17 525.75 397.55 Miscellaneous expenses not written Total 2,492.92 2,306.17 2,143.77 Notes: Book value of unquoted investments 842.83 968.18 893.3 Market value of quoted investments 46.62 149.85 149.73 Contingent liabilities 446.45 428.23 297.08 Number of equity sharesoutstanding (Lacs) 613.81 613.81 613.81
61.38 1,128.56 546.68 221.2 1,957.82 -
61.38
1,042.55 393.33 179.45 1,676.71
1,366.73 677.66 689.07 156.05 736.6 789.73 413.62 376.1 1,957.82 632.35 164.15 544.05 613.81 -
1,140.69 627.98 512.71 62.92 734.27 685.56 318.75 366.81 1,676.71 630.83 137.95 488.95 613.81
Profit loss account Raymond Ltd.
Mar ' 09 Income Operating income Expenses Material consumed Manufacturing expenses Personnel expenses Selling expenses Adminstrative expenses Expenses capitalised Cost of sales Operating profit Other recurring income Adjusted PBDIT Financial expenses Depreciation Other write offs Adjusted PBT Tax charges Adjusted PAT Non recurring items Other non cash adjustments Reported net profit Earnigs before appropriation Equity dividend Preference dividend Dividend tax Retained earnings 1,400.21 507.94 172.83 261 146.14 192.95 1,280.86 119.35 73.85 193.21 85.2 88.81 19.19 -27.15 46.34 -324.28 6.38 -271.55 55.19 55.19 2.61 333.36 14.69 15.57 -0.88 57.66 15.64 72.42 351.31 15.35 5.22 333.39 1,246.02 91.52 64.55 156.07 60.3 81.07 76.67 36.98 39.69 150.47 11.96 202.12 369.29 30.69 4.3 192.02 Mar ' 08 1,337.54 522.06 166.08 233.16 134.17 190.54 Mar ' 07 1,300.36 484.98 164.5 225.58 130.28 148.14 -1.79 1,151.69 148.67 39.65 188.32 48.59 63.06 125.89 41.41 84.48 34.09 2.44 121 227.02 30.69 3.21 116.83 Mar ' 06 1,334.51 522.85 166.86 203.98 116.51 128.64 -1.5 1,137.34 197.17 37.67 234.84 36.24 72.71 79.41 15.01 64.4 3.53 15.21 83.15 144.59 24.55 Mar ' 05 1,167.18 475.17 151.32 202.88 100.71 109.88 -0.42 1,039.55 127.63 45.43 173.05 29.88 63.77
Cash flow staement Raymond Ltd.
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 Mar ' 09 Mar ' 08 Mar ' 07 Mar ' 06 Mar ' 05 -58.75 86.15 156.99 173.65 116.5 120.54 15.52 57.18 157.56 109.45 -361.13 -13.11 -194.22 -287.35 -154.86 265.57 -6.2 137.62 141.58 31.89 24.97 -3.79 0.58 11.78 -13.51 21.82 25.61 25.03 13.25 26.76 46.8 21.82 25.61 25.03 13.25
Ratios Analysis Raymond Ltd.
Mar ' 09 Mar ' 08 -0.14 13.06 10.77 23.98 2.5 14.91 227.8 227.8 217.91 215.57 Mar ' 07 6.47 16.74 32.79 43.06 5 24.22 220.94 220.94 211.85 206.35 Mar ' 06 13.76 25.61 19.92 31.77 5 32.12 193.86 193.86 217.41 179.55 Mar ' 05 10.49 20.88 12.51 22.9 4 20.79 179.85 179.85 190.15 166.39
Per share ratios
Adjusted EPS (Rs) Adjusted cash EPS (Rs) Reported EPS (Rs) Reported cash EPS (Rs) Dividend per share Operating profit per share (Rs) Book value (excl rev res) per share (Rs) Book value (incl rev res) per share (Rs.) Net operating income per share (Rs) Free reserves per share (Rs) 7.55 22.02 -44.05 -29.58 19.44 183.6 183.6 228.12 171.33
Profitability ratios
Operating margin (%) Gross profit margin (%) Net profit margin (%) Adjusted cash margin (%) Adjusted return on net worth (%) Reported return on net worth (%) Return on long term funds (%) 8.52 2.18 -18.34 9.16 4.11 -23.99 4.3 6.84 0.78 4.71 5.71 -0.06 4.72 3.6 11.43 6.58 15.01 7.66 2.92 14.83 6.4 14.77 9.32 8.91 11.45 7.09 10.27 8.71 10.93 5.47 6.33 10.56 5.83 6.95 7.04
Leverage ratios
Long term debt / Equity Total debt/equity Owners fund as % of total source Fixed assets turnover ratio 1.15 1.19 45.58 0.83 0.48 0.63 61.18 1.01 0.44 0.58 63.26 1.07 0.56 0.64 60.77 0.97 0.4 0.51 65.83 1.03
Liquidity ratios
Current ratio Current ratio (inc. st loans) Quick ratio Inventory turnover ratio 2.06 1.75 1.26 4.39 2.2 1.23 1.4 4.35 1.89 1.02 1.21 4.92 1.91 1.3 1.09 4.63 2.15 1.21 1.21 4.47
Payout ratios
Dividend payout ratio (net profit) Dividend payout ratio (cash profit) Earning retention ratio Cash earnings retention ratio 100 27.15 12.19 2,139.42 77.62 17.84 13.58 9.54 65.06 28.61 17.94 58.58 77.74 36.14 19.74 56.89 78.34
Coverage ratios
Adjusted cash flow time total debt Financial charges coverage ratio Fin. charges cov.ratio (post tax) 9.95 2.27 -1.13 11.06 2.59 3.44 7.67 3.88 6.44 4.89 6.48 6.38 4.47 5.79 5.71
CommentsHaving look at various ratios we find that Liquidity ratios, Leverage ratios, Coverage Ratios are well but if we look at the Profitability Ratios we find that Operating Profit margins have decreased over the year and are now they are at loss. This can be partly due to the recession as well as due to the stiff competition from the market. Dividends have also gone low and even this year they have not given dividend this year, so for stakeholder this is a grave concern.
doc_487637873.xls