Valuation Abc

  • May 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Valuation Abc as PDF for free.

More details

  • Words: 965
  • Pages: 9
Index Nos. in Blue colour do not contains any formula Nos. in Black colour contains formula

Income statement Balance sheet Cash flow Ratios FCFF EVA & ROIC News Analysis 1 News Analysis 2

Go home (Income statement )

(Rs mn) 2012E 2013E 227.93 271.25 93.13 135.25 134.80 136.00

2008 100.00 44.80 55.20

2009E 110.70 51.48 59.22

2010E 120.97 58.13 62.84

2011E 171.21 71.08 100.13

Operating expenses Operating income

37.84 17.36

39.32 19.90

40.80 22.05

72.01 28.12

98.84 35.96

94.06 41.95

Interest expenses

5.00

5.65

5.43

5.32

5.72

5.10

PBT Tax

12.36 4.94

14.25 5.70

16.62 6.65

22.80 9.12

30.24 12.09

36.85 14.74

PAT

7.42

8.55

9.97

13.68

18.14

22.11

Dividend payout

1.97

4.40

4.42

5.31

8.19

9.17

2009E 10.7% 53.5% 18.0%

2010E 9.3% 51.9% 18.2%

2011E 41.5% 58.5% 16.4%

2012E 33.1% 59.1% 15.8%

2013E 19.0% 50.1% 15.5%

51.5%

44.4%

38.8%

45.1%

41.5%

Revenue Cost of goods sold Gross profit

Assumptions For Income statement (Sales Growth ) (Gross Margin ) (Operating Margin ) (Tax Rate ) (Dividend Payout )

2008 55.2% 17.4% 40.0% 26.5%

Go home Balance sheet 2008 Asset Cash Other current asset Total current asset

2009E

2010E

2011E

2012E

(Rs mn) 2013E

20.00 28.29 48.29

22.33 30.61 52.94

21.97 40.51 62.48

23.35 50.83 74.18

3.98 78.52 82.50

8.81 90.39 99.21

30

5.79 7.68 28.11

6.65 6.31 28.45

9.36 6.81 31.01

11.29 6.92 35.37

12.54 8.17 39.75

Total Asset

78.29

81.05

90.94

105.19

117.87

138.96

Liabilities and equity Total current liability

12.44

11.05

15.39

21.26

24.00

32.14

Long term debt Total liabilities

50.00 62.44

50.00 61.05

50.00 65.39

50.00 71.26

50.00 74.00

50.00 82.14

Common stock Returned earning Shareholders equity

15.00 0.85 15.85

15.00 5.00 20.00

15.00 10.55 25.55

15.00 18.92 33.92

15.00 28.88 43.88

15.00 41.81 56.81

Total L & SE

78.29

81.05

90.94

105.19

117.87

138.96

PP&E Depreciation expenses Net PP&E

Go home Cash Flow Statement 2008

(Rs mn) 2012E 2013E 18.14 22.11 6.92 8.17 (27.69) (11.88) 2.73 8.15 0.10 26.55

2009E 8.55 7.68 (2.32) (1.39) 12.52

2010E 9.97 6.31 (9.90) 4.34 10.72

2011E 13.68 6.81 (10.32) 5.88 16.05

Capex

(5.79)

(6.65)

(9.36)

(11.29)

(12.54)

Change in long term debt Dividends Cash flow from financing

0.00 (4.40) (4.40)

0.00 (4.42) (4.42)

0.00 (5.31) (5.31)

0.00 (8.19) (8.19)

0.00 (9.17) (9.17)

2.33

(0.36)

1.38

(19.37)

4.83

22.33 2.33 22.33

21.97 (0.36) 21.97

23.35 1.38 23.35

3.98 (19.37) 3.98

8.81 4.83 8.81

Revenue Depreciation Change in Non-cash CA Change in CL Cash flow from operation

Total cash flow Opening cash flow Change in cash flow Ending cash flow

20.00

Go home Ratios

Current ratio

2008

2009E 2010E Liquidity ratio

3.88

4.79

4.06

2011E

2012E

2013E

3.49

3.44

3.09

5.52 1.63

6.44 1.93

6.82 1.95

Efficiancy ratio Fixed asset T/O Total asset T/O

3.33 1.28

3.94 1.37

4.25 1.33

Leverage ratio Total debt ratio Debt to Equity

### 75.32% 71.90% 67.75% 62.78% 59.11% 3.94 3.05 2.56 2.10 1.69 1.45 Coverage ratio

Interest expenses

3.47

3.52

4.06

5.28

6.28

8.23

58.48% 16.42% 7.99% 13.00% 40.32% 40.32%

59.14% 15.78% 7.96% 15.39% 41.35% 41.35%

50.14% 15.46% 8.15% 15.91% 38.91% 38.91%

Profitability ratio Gross profit margin Operating profit margin Net profit margin Return on Total Asset Return on equity Return on common equity The Du Pont Analysis

### ### 7.42% 9.47% ### ###

53.50% 17.98% 7.72% 10.55% 42.75% 42.75%

51.95% 18.23% 8.24% 10.97% 39.04% 39.04%

### 42.75% 39.04% 40.32% 41.35% 38.91% Valuation ratio

EV/EBITDA EV/Sales PE EPS Market cap/Sales EVA ROIC EV

3.28 1.98 1.94 1.53 1.70 1.36 0.57 0.49 0.45 0.31 0.32 0.25 3.63 3.14 2.70 1.97 1.48 1.22 16.83 19.40 22.63 31.03 41.15 50.15 0.27 0.24 0.22 0.16 0.12 0.10 2.73 11.73 13.23 18.33 25.01 29.48 ### 28.43% 29.18% 33.51% 38.30% 39.27% 56.89 54.56 54.92 53.54 72.91 68.08

Go home

Go home

Free cash flow to the firm (FCFF) Other parameter

(Rs mn)

(Kd ) 12.6% (Beta ) 1.30 (Rf ) 10.0% ((Rm-Rf) ) 7.2% (Market Value of Equity )26.89 Ke Book value of equity WACC (Market) WACC (Book) WACC (Used)

CMP (Rs) No. of shares (mn)

Implied - Market Equity Debt Implied - Book Equity Debt

19.36% 15.85 11.67% 10.38% 11.67%

61 0.44

35.0% 65.0%

24.1% 75.9%

(FCFF ) 2008 EBIT Cash taxes EBIAT Depreciation Changes in non cash CA Changes in CL

2009E 19.90 7.96 11.94 7.68 ((2.32) (1.39)

2010E 22.05 8.82 13.23 6.31 ((9.90) 4.34

2011E 28.12 11.25 16.87 6.81 ((10.32) 5.88

(Rs mn) 2012E 2013E 35.96 41.95 14.38 16.78 21.58 25.17 6.92 8.17 ((27.69) ((11.88) 2.73 8.15

Capex

(5.79)

(6.65)

(9.36)

(11.29)

(12.54)

FCFF

10.12

7.32

9.88

((7.75)

17.06

Terminal value Annuity with growth (%) Market value Book value Calculations - FCFF FCFF - Market value Cash flow Enterprise value Debt Equity FCFF - Book value Cash flow Enterprise value Debt Equity

Price per share (Rs)

3% 202.76 238.19 2000

2001 10.12

144 50.00 Debt (%) 93.65 Equity (%) 2000

2001 10.12

173 50.00 Debt (%) 123 Equity (%)

212

2002 7.32

9.88

(Rs mn) 2004 2005 -7.75 219.82

9.88

2004 -7.75

2003

34.81% 65.19% 2002 7.32

28.88% 71.12%

2003

2005 255.25

EVA calculation 2008

2009E

2010E

2011E

NOPAT 10.42 19.90 22.05 28.12 Invested capital 65.85 70.00 75.55 83.92 WACC (Market) 11.67% 11.67% 11.67% 11.67% WACC (Rs mn) 7.68 8.17 8.81 9.79 Economic profit2.73 11.73 13.23 18.33

(Rs mn) 2012E 2013E

35.96 93.88 11.67% 10.95 25.01

41.95 106.81 11.67% 12.46 29.48

ROIC calculation 2008

EVA = NOPAT-(WACC (Rs) *

NOPAT = ROIC*Investe

Therefore, EVA = (ROIC - WACC (Rs)) * EVA = NOPAT-(WACC (Rs) *In ROIC = NOPAT / Invested cap Go home

2009E

2010E

2011E

2012E

2013E

NOPAT 10.42 19.90 22.05 28.12 35.96 41.95 Invested capital 65.85 70.00 75.55 83.92 93.88 106.81 ROIC 15.8% 28.4% 29.2% 33.5% 38.3% 39.3%

NOPAT-(WACC (Rs) *Invested capital) NOPAT = ROIC*Invested capital

ROIC - WACC (Rs)) * Invested capital OR NOPAT-(WACC (Rs) *Invested capital) NOPAT / Invested capital

Related Documents

Valuation Abc
May 2020 5
Abc
October 2019 50
Abc
May 2020 27
Abc
November 2019 35
Abc
May 2020 26
Abc
May 2020 26