master financial comparison

8/8/2019 Master Financial Comparison

1/14

2008 2008

Working Capital(in RS lakh)

Holding Period

Profitability Ratios

ROCE

NPM

Asset Turnover

Gross Profit Margin

EBIDTA Margin

Assessing Liquidity

Current Ratio

Liquid Ratio

Financial Structure Ratios

Debt/ Equity Ratio

Gearing Ratios

Interest Coverage Ratio

Investment Ratios

Return on Net Worth

EPS

Book Value

Price

P/E

Dividend paid per share

Dividend Payout Ratio

Others Advertisement Investments

Market Share

Growth in Market Share

Growth in Revenue

Growth in PAT

COGS as a percentage of Sales

2009 2009

Working Capital


ROCE

NPM

Asset Turnover

Gross Profit Margin

EBIDTA Margin

Assessing LiquidityCurrent Ratio

Liquid Ratio


Number of days in WorkingCapital(holding period)


2/14

Debt/ Equity Ratio

Gearing Ratios

Interest Coverage Ratio

Investment Ratios

Return on Net Worth

EPS

Book Value

Price

P/E

Dividend paid per share

Dividend Payout Ratio

Others Advertisement Investments(in Rs. Lakhs)

Market Share


Growth in Revenue

Growth in PAT

COGS as a percentage of Sales

2010 2010

Net Sales BS

Working Capital B/S net current asset

WC Turnover Ratio net Sales/ WC

Holding Period Money control


ROCE Money control

NPM Money control

Asset Turnover Ratio Money control

Gross Profit Margin Money control

EBIDTA Margin PBIT+dep)/net sales

Assessing Liquidity

Current Ratio MC

Liquid Ratio MC


Debt/ Equity Ratio MC

Interest Coverage Ratio MC

Return on Net Worth MC

EPS MC

Book Value MC

Price

P/E

Dividend paid per share MCDividend Payout Ratio MC

Capital Gearing Ratios(longtermliabilities/eq shldr finds)


3/14

Advertisement Investments BS= adv +sales pro

Advertisement Investments a =C93/C92

Market Share


COGS as a percentage of Sale(cost of materials/ne


4/14

Emami Dabur Marico Godrej Consume ritannia

-136545 -1247 20480

80.14 -5.8 76.11 -42.05 -8.7 28.82

33.63% 67.51% 33.60% 138.72 66.03 26.37

15.35% 15.06% 9.06% 12.58 16.5 7.31

6.61 6.54 306.65

15.20% 17.37% 12.06% 15.86 20.51 7.85

10.53

2.25 0.91 1.33 0.68 0.86 1.22

1.84 0.58 1.07 0.25 0.34 0.68

0.12 0.03 1.09 0.06 0.89 0.14

20.08 46.79 12.08 83.09 23.07 35.49

32.09% 61.58% 51.17% 122.97 100.32 26.07

14.92 3.67 2.35 8.12 6.56 76.95

46.5 6.11 4.6 6.61 6.66 316.37

4.5 1.5 0.66 9 4 18.00

35.27 47.86 32.54 131.8 73.26 26.34

9006.06 ###

Emami Dabur Marico Godrej Consume Britanni

23.4 41.32 75.32 1.58 108.29 13.43

18.20% 47.98% 38.80% 118.59 32.65 25.29

11.85% 15.44% 7.35% 12.09 14.22 5.75

16.31% 17.19% 13.13% 13.50 14.23 6.12

15.29% 85.76% 13.81% 16.04% 19.29% 9.72%

0.72 1.19 1.28 0.92 2.07 1.27

0.84 0.99 1.25 0.51 1.72 0.65

ended dec

07)

HUL(15months endedmarch 09)


5/14

1.49 0.19 0.84 0.2 0.12 0.03

4.24 38.34 10.08 116.18 26.89 18.38

29.63% 51.20% 38.64% 121.34 30.08 22.60

14.08 4.32 2.33 11.47 6.29 75.51

47.52 8.53 6.04 9.45 20.9 345.14

4.5 1.75 0.66 7.5 4 40.00

45.51 47.41 32.84 76.47 74.58 61.97

215381.99 15488.83 ###

42.75% 51.02% 60.35% 55.63% 55.44% 61.38%

Emami Dabur Marico HUL odrej Consumer ritannia

100685.42 285687 202430 1752380 126788 ###

25765.89 4579 44104 -1365.45 15790.77 3550.95

3.91 62.39 4.59 -1283.37 8.03 95.79

89 3.76 89.85 -22.62 42.83 -3.60

17.93% 61.62% 34.07% 106.78 35.73 24.67

16.09% 15.03% 11.65% 12.29 18.87 3.38

3.56 4.31 7.88 11.84 26.85 165.86

12.56% 18.06% 15.37% 14.70 20.39 4.89

24.74% 19.76% 16.60% 16.54% 24.68% 6.21%

1.33 0.93 1.17 0.84 1.90 0.94

1.93 0.68 1.23 0.46 0.95 0.43

0.41 0.14 0.66 ----------------- 0.01 1.08

3081.90/doubt

2.86 52.35 21.49 395.13 216.85 48.28

26.64% 58.04% 41.11% 85.25 29.98 29.40

21.86 4.99 3.86 10.09 8.05 48.77

82.05 8.64 9.38 11.84 26.85 165.86

0 0 0 0 0 0

6 2 0.66 6.5 4.25 25.0032.1 46.86 20.01 75.2 59.34 59.77


6/14

17,120.15 39003 22165 239143 9338.24 ###

17.00 13.65 10.95 13.65 7.37 7.90

37.94 48.09 53.60 50.79 45.53 63.77


7/14

ITC Comments

-35.85 52.39

150.33 36.6

11.73 21.5

3.11 1.59

20.05 28.44

17.24 27.5

0.66 1.36

0.23 0.56

0.01 0.02

741.2 258.92

98.9 25.99

42.92 8.28

43.4 31.85

33 3.5

89.5 49.45

Nestle (yr en ITC ** ratios are taken as it is while the absolute figures a

-35.17 62.19

163.97 34.6

12.24 21.18

17.20 29.17

20.90% 35.05%

0.66 1.42

0.29 0.61

ended Dec

2007)Industrial Standards

(wherever applicable)


8/14

not gvn 0.01

473.22 168.97

42.83 23.85

55.39 8.65

49.09 36.24

42.5 3.7

89.76 50.06

47.90% 41.89%

ITC

512937.67

-56,583

-9.07#DIV/0!

-41.86 -13.69 dbrttrs tovr ratio

160.29 42.64CE depnds- is less hul -ve wc so high ROCE

12.67 21.30 products and structure

3.24 1.58

17.58 29.74

0.60 0.92

0.24 0.39

--------------- 0.01 cash rich policy due to WC

666.25 82.46 low

112.68 28.98

67.94 10.64

60.29 36.69

0 0

48.5 1083.52 109.63

Nestle (yrended Dec

2009)


9/14

26751.19

5.22

47.90 vol incr

90 days too high for FMCG

emami with other than


10/14

re scaled downn from 15 months to 12months


11/14

tho margin is high there is no volumes and dependent on debts(int costs) ROE


12/14


13/14

Ask EMAMI

distribution structure?

dealers?

payments?

mfg outsourced?

reduce WC days?

hul

FA

WC

within itse

8

excel excluding nestle n HUL 9

product lines dealesrshiup? Oustsourcing ? 10

possible to reduce loan n wc

WC turnover ratios

indv expenses to sales COGS &ADV


14/14

Questions

1. Business Valuation

2. P/E

compar

master financial comparison

Documents