Edition:
United Kingdom

Merck Ltd (MERK.NS)

MERK.NS on National Stock Exchange of India

1,143.50INR
12 Dec 2017
Change (% chg)

-- (--)
Prev Close
Rs1,143.50
Open
--
Day's High
--
Day's Low
--
Volume
--
Avg. Vol
14,620
52-wk High
Rs1,318.00
52-wk Low
Rs933.00

Revenue & Earnings Per Share

    Revenue* Earnings Per Share**
FY 2017 Sep '17 3,127.26 19.090
Jun '17 2,656.74 12.125
Mar '17 2,369.22 8.932
FY 2016 Dec '16 2,515.41 10.965
Sep '16 2,780.08 17.170
Jun '16 2,767.22 13.723
Mar '16 2,155.43 5.061
FY 2015 Dec '15 2,374.83 8.776
Sep '15 2,559.86 7.540
Jun '15 2,472.72 10.157
Mar '15 1,987.60 5.800
 
*Note: Units in Millions ofRupee
**Note: Units in Rupee

Consensus Estimates Analysis

  # of Estimates Mean High Low 1 Year Ago
SALES (in millions)
Year Ending Dec-17 2 11,314.50 11,317.00 11,312.00 11,102.00
Year Ending Dec-18 2 12,570.50 12,710.00 12,431.00 --
Earnings (per share)
Year Ending Dec-17 2 58.80 59.40 58.20 49.99
Year Ending Dec-18 2 72.55 76.90 68.20 --
Sales and Profit Figures in India Rupee (INR);

Valuation Ratios

  Company industry sector
P/E Ratio (TTM) 21.84 31.14 32.93
P/E High - Last 5 Yrs. 30.54 40.91 45.62
P/E Low - Last 5 Yrs. 13.78 23.80 24.34
Beta 0.46 0.90 0.88
Price to Sales (TTM) 1.72 3.93 5.40
Price to Book (MRQ) 2.61 4.81 5.38
Price to Tangible Book (MRQ) 2.61 5.53 6.78
Price to Cash Flow (TTM) 16.25 23.04 23.45
% Owned Institutions -- 0.88 1.40

Dividends

  Company industry sector
Dividend Yield 1.04 1.56 1.50
Dividend Yield - 5 Year Avg 0.94 1.57 1.52
Dividend 5 Year Growth Rate -- 4.33 5.17
Payout Ratio(TTM) 22.63 45.73 43.76

Growth Rates

  Company industry sector
Sales (MRQ) vs Qtr. 1 Yr. Ago -3.99 3.57 9.00
Sales (TTM) vs TTM 1 Yr. Ago 3.78 4.66 5.38
Sales - 5 Yr. Growth Rate 11.06 10.11 10.33
EPS (MRQ) vs Qtr. 1 Yr. Ago -11.65 16.54 19.67
EPS (TTM) vs TTM 1 Yr. Ago 38.49 -- --
EPS - 5 Yr. Growth Rate 3.57 9.86 10.79
Capital Spending - 5 Yr. Growth Rate 16.01 15.30 15.25

Financial Strength

  Company industry sector
Quick Ratio (MRQ) 2.73 2.11 2.18
Current Ratio (MRQ) 3.65 2.88 2.98
LT Debt to Equity (MRQ) 0.00 9.47 11.56
Total Debt to Equity (MRQ) 5.97 13.43 15.81
Interest Coverage (TTM) -- 36.29 33.29

Profitability Ratios

  Company industry sector
Gross Margin (TTM) 59.48 55.14 54.83
Gross Margin - 5 Yr. Avg. 48.36 52.29 52.40
EBITD Margin (TTM) 12.29 -- --
EBITD - 5 Yr. Avg 10.39 18.46 15.24
Operating Margin (TTM) 9.02 14.50 7.76
Operating Margin - 5 Yr. Avg. 8.33 14.42 10.75
Pre-Tax Margin (TTM) 11.40 14.95 8.57
Pre-Tax Margin - 5 Yr. Avg. 10.85 14.74 11.17
Net Profit Margin (TTM) 7.89 11.22 4.88
Net Profit Margin - 5 Yr. Avg. 7.16 11.08 7.47
Effective Tax Rate (TTM) 30.80 23.21 23.11
Effective Tax Rate - 5 Yr. Avg. 34.01 23.44 24.00

Efficiency

  Company industry sector
Revenue/Employee (TTM) 6,462,610 953,213,833 864,673,366
Net Income/Employee (TTM) 509,757 112,151,384 101,717,513
Receivable Turnover (TTM) 8.92 5.60 5.76
Inventory Turnover (TTM) 2.47 2.58 3.34
Asset Turnover (TTM) 1.19 0.95 0.93

Management Effectiveness

  Company industry sector
Return on Assets (TTM) 9.41 11.42 11.00
Return on Assets - 5 Yr. Avg. 8.96 13.00 12.43
Return on Investment (TTM) 11.91 14.86 14.46
Return on Investment - 5 Yr. Avg. 11.07 17.00 16.28
Return on Equity (TTM) 12.44 16.28 16.05
Return on Equity - 5 Yr. Avg. 11.45 18.03 17.51
  1 Year 3 Year 5 Year
Sales % 6.05 7.69 11.06
EPS (TTM) % 41.69 10.74 3.57
Dividend % 46.67 8.97 --
Note: Units in Millions of US Dollars

Performance for Merck Ltd

Period %
Actual
% vs.
S&P 500
Rank In
Industry
Industry
Rank
4 Week -9.96 -10.32 99 25
13 Week -1.12 -2.53 99 37
26 Week -7.02 -13.18 99 30
52 Week 48.97 31.61 99 12
YTD 6.26 -11.07 99 25
Note:: Rank is a percentile that ranges from 0 to 99, with 99 = best.

Institutional Holders

% Shares Owned: 13.04%
# of Holders: 12
Total Shares Held: 2,164,787
3 Mo. Net Change: 175,853
# New Positions: 1
# Closed Positions: 0
# Increased Positions: 3
# Reduced Positions: 0
# Net Buyers: 3
NYSE and AMEX quotes delayed by at least 20 minutes. NASDAQ delayed by at least 15 minutes. For a complete list of exchanges and delays, please click here.