Description
Cadbury Financials(07-11)
Balance Sheet of Cadbury India (Amount in Crores) Dec-07 Total Share Capital Equity Share Capital Share Application Money Preference Share Capital Reserves Revaluation Reserves Networth Secured Loans Unsecured Loans Total Debt Total Liabilities 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) Dec-08 Dec-09 33.2 33.2 0 0 372.94 0 406.14 1.28 7.48 8.76 414.9 Dec-10 32.18 32.18 0 0 432.22 0 464.4 32.02 9.68 41.7 506.1 586.94 335.55 251.39 123.86 2.92 222.81 19.67 269.59 512.07 69.82 0 581.89 0 433.56 20.4 453.96 127.93 0 506.1 113.74 144.3 Dec '11 31.07 31.07 0 0 499.73 0 530.8 2.28 9.89 12.17 542.97 724.75 372.09 352.66 152.53 18.01 199.82 31.09 271.5 502.41 74.2 0 576.61 0 534.02 22.83 556.85 19.76 0 542.96 150.97 1,708.53
Sources Of Funds 35.71 34.36 35.71 34.36 0 0 398.1 0 433.81 3.71 4.51 8.22 442.03 0 0 357.73 0 392.09 3.26 6.75 10.01 402.1
Application Of Funds 395.5 430.21 544.77 234.88 160.62 29.55 258.21 102.33 10.68 18.4 131.41 53.39 0 184.8 0 205.09 13.41 218.5 -33.7 27.35 442.03 66.54 121.48 265.13 165.08 82.18 253.42 122.08 11.37 11.2 144.65 44.27 0.62 189.54 0 275.84 25.96 301.8 -112.26 13.68 402.1 84.75 114.12 299.18 245.59 25.58 298.49 151.02 13.14 8.9 173.06 72.34 0.62 246.02 0 370.89 29.91 400.8 -154.78 0 414.88 106.12 122.32
Profit & Loss account of Cadbury India Dec-07 Sales Turnover Excise Duty Net Sales Other Income Stock Adjustments Total Income 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 1,006.02 126.24 879.78 17.87 10.44 908.09 246.22 19.62 94.38 138.85 0 292.11 0 791.18 99.04 116.91 1.7 115.21 34.07 0 81.14 0 81.14 35.19 45.95 544.96 0 7.14 1 Dec-08 Income 1,149.97 91.73 1,058.24 8.71 -2.54 1,064.41 Expenditure 441.53 20.83 93.93 57.63 266.54 35.88 0 916.34 139.36 148.07 2.22 145.85 33.41 0 112.44 0 112.44 43.62 68.81 474.8 0 6.87 0.96 Dec-09 1,441.92 148.45 1,293.47 7.68 17.29 1,318.44 563.06 25.3 107.36 76.61 323.54 43.13 0 1139 171.76 179.44 2.03 177.41 34.32 0 143.09 19.23 162.32 44.67 117.65 575.93 0 6.64 1.13 Dec-10 1,751.24 162.65 1,588.59 25.07 51.32 1,664.98 732.53 29.70 130.22 96.01 2.45 430.46 0.00 1421.37 218.54 243.61 5.20 238.41 36.52 0.00 201.89 0.00 201.89 36.11 165.78 688.83 0.00 6.44 1.09 Dec-11 2045.08 110.71 1934.37 12.67 -16.28 1,930.76 832.28 37.25 150.62 6.52 0 624.19 0 1650.86 267.23 279.9 1.72 278.18 43.83 0 234.35 0 234.35 45.73 188.63 818.58 0 6.21 1.06
Per share data (annualised) Shares in issue (lakhs) Earning Per Share (Rs) Equity Dividend (%) Book Value (Rs) 357.1 12.87 20 121.48 343.57 20.03 20 114.12 332.04 35.43 20 122.32 321.83 51.51 20 144.3 31.07 607.15 20 1708.53
Profit & Loss account of Cadbury India(crores) Dec-07 Dec-08 Dec-09 Sales Turnover Excise Duty Net Sales Other Income Stock Adjustments Total Income 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 Extraord Items) Tax Reported Net Profit Total Value Addition Preference Dividend Equity Dividend Corporate Dividend Tax 1,006.02 126.24 879.78 17.87 10.44 1,930.76 246.22 19.62 94.38 Income 1,149.97 91.73 1,058.24 8.71 -2.54 1,664.98 Expenditure 441.53 20.83 93.93 1,441.92 148.45 1,293.47 7.68 17.29 1,318.44 563.06 25.3 107.36
Dec-10 1,751.24 162.65 1,588.59 25.07 51.32 1,064.41 732.53 29.70 130.22
138.85 0 292.11 0 1650.86 267.23 116.91 1.7 115.21 34.07 0 81.14 0 81.14 35.19 188.63 544.96 0 7.14 1
57.63 266.54 35.88 0 1421.37 218.54 148.07 2.22 145.85 33.41 0 112.44 0 112.44 43.62 165.78 474.8 0 6.87 0.96
76.61 323.54 43.13 0 1139 171.76 179.44 2.03 177.41 34.32 0 143.09 19.23 162.32 44.67 117.65 575.93 0 6.64 1.13
96.01 2.45 430.46 0.00 916.34 139.36 243.61 5.20 238.41 36.52 0.00 201.89 0.00 201.89 36.11 68.81 688.83 0.00 6.44 1.09
Shares in issue (lakhs) Earning Per Share (Rs) Equity Dividend (%) Book Value (Rs)
Per share data (annualised) 357.1 607.15 20 121.48 343.57 51.51 20 114.12 332.04 35.43 20 122.32 321.83 20.03 20 144.3
Arithmatic mean
-133,273 144 -0.99250799 0.143088607 F2 F3
292 0.253876188 F4 1115.625577 60.39416923 1055.231408 6.911698349
Dec-11
Sum
2045.08 2045.08 110.71 110.71 1934.37 1934.37 12.67 12.67 -16.28 -16.28 908.09 6886.68 832.28 37.25 150.62
Average % of sales F1 100 0.002 653.7547 0.000 35.39088 0.002 618.3638 0.000 4.050244 0.000 0.006 0.001 0.000 0.000 0.000 0.000 0.001 0.000 0.005 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.001 0.000 0.000 0.000
781.236947 933.5780008 42.29210711 50.53905983 738.9448399 883.038941 4.840041524 5.783848686
-5.20426 -6.21909045 -7.43181189 -8.881014137 2201.478 2630.766942 3143.765988 3756.799904 266.0566 317.937629 379.9354052 454.0227547 20.32050225 82.16574628 3.55676979 0 340.5061557 0 3228.77779 488.7449015 152.6901632 0.938288963 151.7518742 23.91000305 0 127.8418712 0 127.8418712 24.94648504 320.1201914 446.549174 0 3.38765957 0.578247849
832.28 37.25 150.62 6.52 0 624.19
11.90778 14.22979848 17.00460644 48.14899 57.5380469 68.75795494 2.084261 2.490692244 2.976376751 0 0 0
6.52 0 624.19
199.536 238.4455816 284.9424239 0 0 0 1892.058 2261.009926 2701.906425 286.4037 342.252439 408.9915985 89.47618 106.9240428 127.7742105 0.549836 0.657053782 0.785179143 88.92634 106.266989 126.9890314 14.01122 16.74341121 20.00837316 0 0 0 74.91512 89.52357782 106.9806582 0 0 0
0 0 791.18 5918.75 99.04 279.9 1.72 278.18 43.83 0 234.35 0 234.35 45.73 45.95 818.58 0 6.21 1.06
895.93 279.9 1.72 278.18 43.83 0 234.35 0 234.35 45.73 586.82 818.58 0 6.21 1.06
74.91512 89.52357782 106.9806582 14.6186 17.46922643 20.87572221 187.5899 224.1699421 267.8830376 261.6771 312.7041192 373.6813621 0 1.985163 0 0 2.37226976 2.834861905
0.338852 0.404928494 0.483889472
31.07 12.87
31.07 726.99
2.54665E-05 0.000595878
9.932207 11.86898896 14.18343952 232.3983 277.7160053 331.8705727 0 0 0 546.1691 652.6721503 779.9430936
16.94920818 396.5852867 0 932.0318848
20 20 1708.53 1708.53
0.001400398
309 0.21451953 F5 1333.172799 72.17104494 1261.001754 8.259480981 -10.61281376 4489.376676 542.5572873 24.28300446 98.18808408 4.250340647 0 406.9049277 0 3858.390139 584.0502601 182.4647772 1.121255508 181.3435216 28.57245867 0 152.771063 0 152.771063 29.81105487 382.5436961 533.6263568 0 4.048253898 0.691006301
294 0.16778968
-0.04265
20.25430735 473.919501 0 1113.778298
Key Financial Ratios of Cadbury India Dec-07 Dec-08 Dec '09
Face Value Dividend Per Share Operating Profit Per Share (Rs) Net Operating Profit Per Share (Rs) Free Reserves Per Share (Rs) Bonus in Equity Capital Operating Profit Margin(%) Profit Before Interest And Tax Margin(%) Gross Profit Margin(%) Cash Profit Margin(%) Adjusted Cash Margin(%) Net Profit Margin(%) Adjusted Net Profit Margin(%) Return On Capital Employed(%) Return On Net Worth(%) Adjusted Return on Net Worth(%) Return on Assets Excluding Revaluations Return on Assets Including Revaluations Return on Long Term Funds(%)
Investment Valuation Ratios 10 10 2 2 27.73 40.56 246.37 308.02 -7.66 99.75 73.08 75.97 Profitability Ratios 11.25 13.16 7.23 9.88 12.83 14.11 8.91 9.53 8.91 9.97 5.11 6.42 5.11 6.85 18.74 29.68 10.59 17.55 11.3 19.42 6.96 6.96 18.74 9.78 9.78 29.92
10 2 51.73 389.56 111.56 78.61 13.27 10.44 10.62 11.18 11.18 8.94 8.94 38.44 28.96 27.77 122.32 122.32 38.56
Current Ratio Quick Ratio Debt Equity Ratio Long Term Debt Equity Ratio Interest Cover Total Debt to Owners Fund Financial Charges Coverage Ratio Financial Charges Coverage Ratio Post Tax
Liquidity And Solvency Ratios 0.85 0.61 0.38 0.2 0.02 0.03 0.02 0.02 Debt Coverage Ratios 48.73 77.6 0.02 68.77 48.07 0.03 68.67 46.95
0.61 0.22 0.02 0.02 106.72 0.02 95.43 75.82
Inventory Turnover Ratio Debtors Turnover Ratio Investments Turnover Ratio Fixed Assets Turnover Ratio Total Assets Turnover Ratio Asset Turnover Ratio
Management Efficiency Ratios 8.77 8.78 49.89 95.97 9.83 10.41 4.92 4.9 1.99 2.67 2.22 2.49
11.04 105.54 11.04 2.4 3.16 2.4
Average Raw Material Holding
--
53.76
42.87
Average Finished Goods Held Number of Days In Working Capital
--13.79
24.77 -38.19
28.1 -43.07
Material Cost Composition
Profit & Loss Account Ratios 27.98 41.72 ---23.33 20.82 0.35
43.53 24.3 20.84 0.49
Imported Composition of Raw Materials Consumed Selling Distribution Cost Composition Expenses as Composition of Total Sales
Dividend Payout Ratio Net Profit Dividend Payout Ratio Cash Profit Earning Retention Ratio Cash Earning Retention Ratio AdjustedCash Flow Times Earnings Per Share Book Value
Cash Flow Indicator Ratios 17.71 11.38 10.17 7.66 82.29 89.35 89.83 92.68 0.1 0.09 Dec-07 Dec-08 12.87 20.03 121.48 114.12
6.6 5.11 93.12 94.72 0.06 Dec-09 35.43 122.32
Dec-10
Dec-11
10 2 67.91 493.61 -81.11 13.75 11.28 11.45 12.53 12.53 10.27 10.27 40.91 35.69 35.69 144.3 144.3 43.68
10 2 860.21 6,226.39 -84.02 13.81 11.47 11.54 11.93 11.93 9.68 9.68 43.48 35.53 35.53 1,708.53 1,708.53 43.48
1.12 0.79 0.09 0.02 39.8 0.09 46.82 39.88
1.04 0.68 0.02 0.02 136.88 0.02 162.29 135.78
7.86 96.83 7.86 2.71 3.14 2.71
10.23 76.2 10.23 2.67 3.56 2.67
--
--
-28.99
-3.68
46.11 31.93 0.15 0.44
43.02 26.44 -0.98
4.54 3.72 95.46 96.28 0.21 Dec-10 51.51 144.3
3.85 3.12 96.15 96.88 0.05 Dec-11 607.15 1,708.53
1 Current ratio=Current asset/current liabilities
Current asset = Cash+Current investment+Debtors+inventories+loans and advances+prepaid expenses+Capital W CL= CL and provisions+loans (secured +unsecured)+Provisions for taxation
2 Acid test ratio=Quick asset(Current asset-(inventory+prepaid expenses))/Current liabilities 3 Debt Equity ratio= Debt/Equity Debt=Secured+Unsecured loans Equity=Shareholders fund 4 Debt asset ratio = Debt/Asset (total of application of funds) Turnover ratio: 3 Inventory turnover ratio=cost of goods sold/Average inventory
Avg inventory=last years+current yrs inventory/2 COGS= Cost of Materials, Manufacturing Expenses, Payments to and Provisions for Employees, Selling and Administrative Exp
4 Inventory holding period=12 months/inventory turnover 5 Debtors turnover ratio=Net credit sales/Average debtors+Average bills receivable Debtors turnover ratio=Total sales/debtors+bills receivable 6 Debt collection period=12 months/Debtors turnover 7 Creditors turnover ratio=Net credit purchases/Average creditors (Net credit purchases=gross credit purchases less returns to suppliers Average creditors=Average of creditors outstanding at the beginning and at the end of the year) 8 Defensive interval ratio=Liquid assets(quick asset)/projected daily cash requirement 9 projected daily cash requirement=projected cash operating expenditure/Number of days in a year
(projected cash operating expenditure=COGS+Selling and admin expenses+other ordinary cash expenses-deprecia
10 Debt equity ratio=Long term debt/Shareholders equity (debt here is exclusive of current liabilities) (Shareholders equity includes equity and preference share capital, past accumulated profits AND excludes fictituo OR
Debt equity ratio=total debt/Shareholders equity 11 Debt to total capital ratio=long term debt/permanent capital (permanent capital are shareholders equity and long term debts) Debt to total asset/capital ratio=Total debt/total asset =total debt/(permanent capital+current liabilities) 13 Proprietry ratio=properietor's fund/total asset*100 proprietor's funds = Share capital + Reserves and surplus 14 Interest coverage ratio Interest coverage=EBIT/Interest 15 Dividend coverage ratio Dividend coverage=PAT/Preference dividend 16 Total coverage ratio=
17 Total cash flow
Profit ratios: 18 Gross profit margin =Gross profits/Net Sales*100 Gross profit= Net sales-COGS 19 Operating profit ratio=Earning before interest and taxes (EBIT)/Sales 20 Net profit ratio=Earnings after interest and taxes (EAT)/Sales Expenses Ratios 21 Cost of goods sold ratio=Cost of goods sold/Net sales*100 22 Operating expenses ratio= Administrative expenses+Selling expenses/Net sales*100 23 Administrative expenses ratio=Administrative expenses/Net sales*100 24 Selling expenses ratio =Selling expenses/Net sales*100 25 Operating ratio=COGS+Operating expenses/Net sales*100 26 Financial expenses ratio=Financial expenses/Net sales*100 27 Return on asset(ROA)= Net profit after taxes/Average total asset*100
Return on asset(ROA)= (PAT+ Interest - Tax advantage on interest)/Average total asset or Average tangible asset o
Return on capital employed (ROCE)= (Net profit after taxes/EBIT Average total capital employed )*100
28
Return on capital employed (ROCE)= (Net profit after taxes+Inte rest- Tax advantage on interest Average total capital employed ) *100
29
Return on capital employed (ROCE)= (Net profit after taxes+Inte rest Average total capital employed Average intangible asset) *100
30
Return on capital employed (ROCE)= PBIT(1tax) Average total total asset Return on total shareholders equity= Net profit after taxes/Average total shareholders equity*100 Earning per share =Net profit available to equity holders/Number of ordinary shares outstanding
28 31 32 33 34 35 36
Dividend per share=Net profit after interest and preference dividend paid to preference shareholders/ Earning yield (Earning price ratio)=EPS/Market value per share*100 Dividend yield=DPS/Market value per share*100 Price earning ratio=Market price of share/EPS
37 38 39 40 41 42 43 44 45 46
Earning power= Net profit after taxes/Total assets Raw material turnover=Cost of raw materials used/Average raw material inventory WIP turnover= Cost of goods manufactured/Average WIP inventory Rate of return on investment=Margin of profit*Capital/Investment turnover Total asset turnover=COG/Avg total asset Fixed asset turnover=COGS/Avg fixed asset Capital turnover=COGS/Avg capital employed Current asset tournover=COGS/Avg current asset Working capital turnover ratio=COGS/Networking capital Cash Flow Margin = Cash flow from operating cash flows/Net sales = _____%
nces+prepaid expenses+Capital WIP
es, Selling and Administrative Expenses, Financial Expenses, Miscellaneous Expenditure Written Off,
end of the year)
er of days in a year
r ordinary cash expenses-depreciation)
ated profits AND excludes fictituous assets)
l asset or Average tangible asset or Average fixed asset
total shareholders equity*100
ordinary shares outstanding paid to preference shareholders/Number of ordinary shares outstanding
erial inventory
doc_412749399.xls
Cadbury Financials(07-11)
Balance Sheet of Cadbury India (Amount in Crores) Dec-07 Total Share Capital Equity Share Capital Share Application Money Preference Share Capital Reserves Revaluation Reserves Networth Secured Loans Unsecured Loans Total Debt Total Liabilities 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) Dec-08 Dec-09 33.2 33.2 0 0 372.94 0 406.14 1.28 7.48 8.76 414.9 Dec-10 32.18 32.18 0 0 432.22 0 464.4 32.02 9.68 41.7 506.1 586.94 335.55 251.39 123.86 2.92 222.81 19.67 269.59 512.07 69.82 0 581.89 0 433.56 20.4 453.96 127.93 0 506.1 113.74 144.3 Dec '11 31.07 31.07 0 0 499.73 0 530.8 2.28 9.89 12.17 542.97 724.75 372.09 352.66 152.53 18.01 199.82 31.09 271.5 502.41 74.2 0 576.61 0 534.02 22.83 556.85 19.76 0 542.96 150.97 1,708.53
Sources Of Funds 35.71 34.36 35.71 34.36 0 0 398.1 0 433.81 3.71 4.51 8.22 442.03 0 0 357.73 0 392.09 3.26 6.75 10.01 402.1
Application Of Funds 395.5 430.21 544.77 234.88 160.62 29.55 258.21 102.33 10.68 18.4 131.41 53.39 0 184.8 0 205.09 13.41 218.5 -33.7 27.35 442.03 66.54 121.48 265.13 165.08 82.18 253.42 122.08 11.37 11.2 144.65 44.27 0.62 189.54 0 275.84 25.96 301.8 -112.26 13.68 402.1 84.75 114.12 299.18 245.59 25.58 298.49 151.02 13.14 8.9 173.06 72.34 0.62 246.02 0 370.89 29.91 400.8 -154.78 0 414.88 106.12 122.32
Profit & Loss account of Cadbury India Dec-07 Sales Turnover Excise Duty Net Sales Other Income Stock Adjustments Total Income 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 1,006.02 126.24 879.78 17.87 10.44 908.09 246.22 19.62 94.38 138.85 0 292.11 0 791.18 99.04 116.91 1.7 115.21 34.07 0 81.14 0 81.14 35.19 45.95 544.96 0 7.14 1 Dec-08 Income 1,149.97 91.73 1,058.24 8.71 -2.54 1,064.41 Expenditure 441.53 20.83 93.93 57.63 266.54 35.88 0 916.34 139.36 148.07 2.22 145.85 33.41 0 112.44 0 112.44 43.62 68.81 474.8 0 6.87 0.96 Dec-09 1,441.92 148.45 1,293.47 7.68 17.29 1,318.44 563.06 25.3 107.36 76.61 323.54 43.13 0 1139 171.76 179.44 2.03 177.41 34.32 0 143.09 19.23 162.32 44.67 117.65 575.93 0 6.64 1.13 Dec-10 1,751.24 162.65 1,588.59 25.07 51.32 1,664.98 732.53 29.70 130.22 96.01 2.45 430.46 0.00 1421.37 218.54 243.61 5.20 238.41 36.52 0.00 201.89 0.00 201.89 36.11 165.78 688.83 0.00 6.44 1.09 Dec-11 2045.08 110.71 1934.37 12.67 -16.28 1,930.76 832.28 37.25 150.62 6.52 0 624.19 0 1650.86 267.23 279.9 1.72 278.18 43.83 0 234.35 0 234.35 45.73 188.63 818.58 0 6.21 1.06
Per share data (annualised) Shares in issue (lakhs) Earning Per Share (Rs) Equity Dividend (%) Book Value (Rs) 357.1 12.87 20 121.48 343.57 20.03 20 114.12 332.04 35.43 20 122.32 321.83 51.51 20 144.3 31.07 607.15 20 1708.53
Profit & Loss account of Cadbury India(crores) Dec-07 Dec-08 Dec-09 Sales Turnover Excise Duty Net Sales Other Income Stock Adjustments Total Income 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 Extraord Items) Tax Reported Net Profit Total Value Addition Preference Dividend Equity Dividend Corporate Dividend Tax 1,006.02 126.24 879.78 17.87 10.44 1,930.76 246.22 19.62 94.38 Income 1,149.97 91.73 1,058.24 8.71 -2.54 1,664.98 Expenditure 441.53 20.83 93.93 1,441.92 148.45 1,293.47 7.68 17.29 1,318.44 563.06 25.3 107.36
Dec-10 1,751.24 162.65 1,588.59 25.07 51.32 1,064.41 732.53 29.70 130.22
138.85 0 292.11 0 1650.86 267.23 116.91 1.7 115.21 34.07 0 81.14 0 81.14 35.19 188.63 544.96 0 7.14 1
57.63 266.54 35.88 0 1421.37 218.54 148.07 2.22 145.85 33.41 0 112.44 0 112.44 43.62 165.78 474.8 0 6.87 0.96
76.61 323.54 43.13 0 1139 171.76 179.44 2.03 177.41 34.32 0 143.09 19.23 162.32 44.67 117.65 575.93 0 6.64 1.13
96.01 2.45 430.46 0.00 916.34 139.36 243.61 5.20 238.41 36.52 0.00 201.89 0.00 201.89 36.11 68.81 688.83 0.00 6.44 1.09
Shares in issue (lakhs) Earning Per Share (Rs) Equity Dividend (%) Book Value (Rs)
Per share data (annualised) 357.1 607.15 20 121.48 343.57 51.51 20 114.12 332.04 35.43 20 122.32 321.83 20.03 20 144.3
Arithmatic mean
-133,273 144 -0.99250799 0.143088607 F2 F3
292 0.253876188 F4 1115.625577 60.39416923 1055.231408 6.911698349
Dec-11
Sum
2045.08 2045.08 110.71 110.71 1934.37 1934.37 12.67 12.67 -16.28 -16.28 908.09 6886.68 832.28 37.25 150.62
Average % of sales F1 100 0.002 653.7547 0.000 35.39088 0.002 618.3638 0.000 4.050244 0.000 0.006 0.001 0.000 0.000 0.000 0.000 0.001 0.000 0.005 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.001 0.000 0.000 0.000
781.236947 933.5780008 42.29210711 50.53905983 738.9448399 883.038941 4.840041524 5.783848686
-5.20426 -6.21909045 -7.43181189 -8.881014137 2201.478 2630.766942 3143.765988 3756.799904 266.0566 317.937629 379.9354052 454.0227547 20.32050225 82.16574628 3.55676979 0 340.5061557 0 3228.77779 488.7449015 152.6901632 0.938288963 151.7518742 23.91000305 0 127.8418712 0 127.8418712 24.94648504 320.1201914 446.549174 0 3.38765957 0.578247849
832.28 37.25 150.62 6.52 0 624.19
11.90778 14.22979848 17.00460644 48.14899 57.5380469 68.75795494 2.084261 2.490692244 2.976376751 0 0 0
6.52 0 624.19
199.536 238.4455816 284.9424239 0 0 0 1892.058 2261.009926 2701.906425 286.4037 342.252439 408.9915985 89.47618 106.9240428 127.7742105 0.549836 0.657053782 0.785179143 88.92634 106.266989 126.9890314 14.01122 16.74341121 20.00837316 0 0 0 74.91512 89.52357782 106.9806582 0 0 0
0 0 791.18 5918.75 99.04 279.9 1.72 278.18 43.83 0 234.35 0 234.35 45.73 45.95 818.58 0 6.21 1.06
895.93 279.9 1.72 278.18 43.83 0 234.35 0 234.35 45.73 586.82 818.58 0 6.21 1.06
74.91512 89.52357782 106.9806582 14.6186 17.46922643 20.87572221 187.5899 224.1699421 267.8830376 261.6771 312.7041192 373.6813621 0 1.985163 0 0 2.37226976 2.834861905
0.338852 0.404928494 0.483889472
31.07 12.87
31.07 726.99
2.54665E-05 0.000595878
9.932207 11.86898896 14.18343952 232.3983 277.7160053 331.8705727 0 0 0 546.1691 652.6721503 779.9430936
16.94920818 396.5852867 0 932.0318848
20 20 1708.53 1708.53
0.001400398
309 0.21451953 F5 1333.172799 72.17104494 1261.001754 8.259480981 -10.61281376 4489.376676 542.5572873 24.28300446 98.18808408 4.250340647 0 406.9049277 0 3858.390139 584.0502601 182.4647772 1.121255508 181.3435216 28.57245867 0 152.771063 0 152.771063 29.81105487 382.5436961 533.6263568 0 4.048253898 0.691006301
294 0.16778968
-0.04265
20.25430735 473.919501 0 1113.778298
Key Financial Ratios of Cadbury India Dec-07 Dec-08 Dec '09
Face Value Dividend Per Share Operating Profit Per Share (Rs) Net Operating Profit Per Share (Rs) Free Reserves Per Share (Rs) Bonus in Equity Capital Operating Profit Margin(%) Profit Before Interest And Tax Margin(%) Gross Profit Margin(%) Cash Profit Margin(%) Adjusted Cash Margin(%) Net Profit Margin(%) Adjusted Net Profit Margin(%) Return On Capital Employed(%) Return On Net Worth(%) Adjusted Return on Net Worth(%) Return on Assets Excluding Revaluations Return on Assets Including Revaluations Return on Long Term Funds(%)
Investment Valuation Ratios 10 10 2 2 27.73 40.56 246.37 308.02 -7.66 99.75 73.08 75.97 Profitability Ratios 11.25 13.16 7.23 9.88 12.83 14.11 8.91 9.53 8.91 9.97 5.11 6.42 5.11 6.85 18.74 29.68 10.59 17.55 11.3 19.42 6.96 6.96 18.74 9.78 9.78 29.92
10 2 51.73 389.56 111.56 78.61 13.27 10.44 10.62 11.18 11.18 8.94 8.94 38.44 28.96 27.77 122.32 122.32 38.56
Current Ratio Quick Ratio Debt Equity Ratio Long Term Debt Equity Ratio Interest Cover Total Debt to Owners Fund Financial Charges Coverage Ratio Financial Charges Coverage Ratio Post Tax
Liquidity And Solvency Ratios 0.85 0.61 0.38 0.2 0.02 0.03 0.02 0.02 Debt Coverage Ratios 48.73 77.6 0.02 68.77 48.07 0.03 68.67 46.95
0.61 0.22 0.02 0.02 106.72 0.02 95.43 75.82
Inventory Turnover Ratio Debtors Turnover Ratio Investments Turnover Ratio Fixed Assets Turnover Ratio Total Assets Turnover Ratio Asset Turnover Ratio
Management Efficiency Ratios 8.77 8.78 49.89 95.97 9.83 10.41 4.92 4.9 1.99 2.67 2.22 2.49
11.04 105.54 11.04 2.4 3.16 2.4
Average Raw Material Holding
--
53.76
42.87
Average Finished Goods Held Number of Days In Working Capital
--13.79
24.77 -38.19
28.1 -43.07
Material Cost Composition
Profit & Loss Account Ratios 27.98 41.72 ---23.33 20.82 0.35
43.53 24.3 20.84 0.49
Imported Composition of Raw Materials Consumed Selling Distribution Cost Composition Expenses as Composition of Total Sales
Dividend Payout Ratio Net Profit Dividend Payout Ratio Cash Profit Earning Retention Ratio Cash Earning Retention Ratio AdjustedCash Flow Times Earnings Per Share Book Value
Cash Flow Indicator Ratios 17.71 11.38 10.17 7.66 82.29 89.35 89.83 92.68 0.1 0.09 Dec-07 Dec-08 12.87 20.03 121.48 114.12
6.6 5.11 93.12 94.72 0.06 Dec-09 35.43 122.32
Dec-10
Dec-11
10 2 67.91 493.61 -81.11 13.75 11.28 11.45 12.53 12.53 10.27 10.27 40.91 35.69 35.69 144.3 144.3 43.68
10 2 860.21 6,226.39 -84.02 13.81 11.47 11.54 11.93 11.93 9.68 9.68 43.48 35.53 35.53 1,708.53 1,708.53 43.48
1.12 0.79 0.09 0.02 39.8 0.09 46.82 39.88
1.04 0.68 0.02 0.02 136.88 0.02 162.29 135.78
7.86 96.83 7.86 2.71 3.14 2.71
10.23 76.2 10.23 2.67 3.56 2.67
--
--
-28.99
-3.68
46.11 31.93 0.15 0.44
43.02 26.44 -0.98
4.54 3.72 95.46 96.28 0.21 Dec-10 51.51 144.3
3.85 3.12 96.15 96.88 0.05 Dec-11 607.15 1,708.53
1 Current ratio=Current asset/current liabilities
Current asset = Cash+Current investment+Debtors+inventories+loans and advances+prepaid expenses+Capital W CL= CL and provisions+loans (secured +unsecured)+Provisions for taxation
2 Acid test ratio=Quick asset(Current asset-(inventory+prepaid expenses))/Current liabilities 3 Debt Equity ratio= Debt/Equity Debt=Secured+Unsecured loans Equity=Shareholders fund 4 Debt asset ratio = Debt/Asset (total of application of funds) Turnover ratio: 3 Inventory turnover ratio=cost of goods sold/Average inventory
Avg inventory=last years+current yrs inventory/2 COGS= Cost of Materials, Manufacturing Expenses, Payments to and Provisions for Employees, Selling and Administrative Exp
4 Inventory holding period=12 months/inventory turnover 5 Debtors turnover ratio=Net credit sales/Average debtors+Average bills receivable Debtors turnover ratio=Total sales/debtors+bills receivable 6 Debt collection period=12 months/Debtors turnover 7 Creditors turnover ratio=Net credit purchases/Average creditors (Net credit purchases=gross credit purchases less returns to suppliers Average creditors=Average of creditors outstanding at the beginning and at the end of the year) 8 Defensive interval ratio=Liquid assets(quick asset)/projected daily cash requirement 9 projected daily cash requirement=projected cash operating expenditure/Number of days in a year
(projected cash operating expenditure=COGS+Selling and admin expenses+other ordinary cash expenses-deprecia
10 Debt equity ratio=Long term debt/Shareholders equity (debt here is exclusive of current liabilities) (Shareholders equity includes equity and preference share capital, past accumulated profits AND excludes fictituo OR
Debt equity ratio=total debt/Shareholders equity 11 Debt to total capital ratio=long term debt/permanent capital (permanent capital are shareholders equity and long term debts) Debt to total asset/capital ratio=Total debt/total asset =total debt/(permanent capital+current liabilities) 13 Proprietry ratio=properietor's fund/total asset*100 proprietor's funds = Share capital + Reserves and surplus 14 Interest coverage ratio Interest coverage=EBIT/Interest 15 Dividend coverage ratio Dividend coverage=PAT/Preference dividend 16 Total coverage ratio=
17 Total cash flow
Profit ratios: 18 Gross profit margin =Gross profits/Net Sales*100 Gross profit= Net sales-COGS 19 Operating profit ratio=Earning before interest and taxes (EBIT)/Sales 20 Net profit ratio=Earnings after interest and taxes (EAT)/Sales Expenses Ratios 21 Cost of goods sold ratio=Cost of goods sold/Net sales*100 22 Operating expenses ratio= Administrative expenses+Selling expenses/Net sales*100 23 Administrative expenses ratio=Administrative expenses/Net sales*100 24 Selling expenses ratio =Selling expenses/Net sales*100 25 Operating ratio=COGS+Operating expenses/Net sales*100 26 Financial expenses ratio=Financial expenses/Net sales*100 27 Return on asset(ROA)= Net profit after taxes/Average total asset*100
Return on asset(ROA)= (PAT+ Interest - Tax advantage on interest)/Average total asset or Average tangible asset o
Return on capital employed (ROCE)= (Net profit after taxes/EBIT Average total capital employed )*100
28
Return on capital employed (ROCE)= (Net profit after taxes+Inte rest- Tax advantage on interest Average total capital employed ) *100
29
Return on capital employed (ROCE)= (Net profit after taxes+Inte rest Average total capital employed Average intangible asset) *100
30
Return on capital employed (ROCE)= PBIT(1tax) Average total total asset Return on total shareholders equity= Net profit after taxes/Average total shareholders equity*100 Earning per share =Net profit available to equity holders/Number of ordinary shares outstanding
28 31 32 33 34 35 36
Dividend per share=Net profit after interest and preference dividend paid to preference shareholders/ Earning yield (Earning price ratio)=EPS/Market value per share*100 Dividend yield=DPS/Market value per share*100 Price earning ratio=Market price of share/EPS
37 38 39 40 41 42 43 44 45 46
Earning power= Net profit after taxes/Total assets Raw material turnover=Cost of raw materials used/Average raw material inventory WIP turnover= Cost of goods manufactured/Average WIP inventory Rate of return on investment=Margin of profit*Capital/Investment turnover Total asset turnover=COG/Avg total asset Fixed asset turnover=COGS/Avg fixed asset Capital turnover=COGS/Avg capital employed Current asset tournover=COGS/Avg current asset Working capital turnover ratio=COGS/Networking capital Cash Flow Margin = Cash flow from operating cash flows/Net sales = _____%
nces+prepaid expenses+Capital WIP
es, Selling and Administrative Expenses, Financial Expenses, Miscellaneous Expenditure Written Off,
end of the year)
er of days in a year
r ordinary cash expenses-depreciation)
ated profits AND excludes fictituous assets)
l asset or Average tangible asset or Average fixed asset
total shareholders equity*100
ordinary shares outstanding paid to preference shareholders/Number of ordinary shares outstanding
erial inventory
doc_412749399.xls