Edition:
India

Asian Paints Ltd (ASPN.NS)

ASPN.NS on National Stock Exchange of India

1,400.65INR
17 Aug 2018
Change (% chg)

Rs5.85 (+0.42%)
Prev Close
Rs1,394.80
Open
Rs1,403.00
Day's High
Rs1,405.15
Day's Low
Rs1,390.00
Volume
537,229
Avg. Vol
973,225
52-wk High
Rs1,490.60
52-wk Low
Rs1,090.10

Revenue & Earnings Per Share

    Revenue* Earnings Per Share**
FY 2019 Jun 43,985.90 5.820
FY 2018 Mar '18 44,923.00 5.015
Dec 42,674.90 5.782
Sep 42,741.80 5.300
Jun 42,282.60 4.430
FY 2017 Mar '17 43,721.90 4.782
Dec 42,740.50 4.705
Sep 41,786.10 4.905
Jun 40,317.00 5.558
FY 2016 Mar '16 40,538.30 4.365
Dec 42,451.60 4.890
Sep 38,396.60 4.210
Jun 37,030.40 4.730
 
*Note: Units in Millions ofRupee
**Note: Units in Rupee

Consensus Estimates Analysis

  # of Estimates Mean High Low 1 Year Ago
SALES (in millions)
Quarter Ending Dec-18 3 48,759.20 51,233.50 46,014.00 50,022.00
Quarter Ending Mar-18 14 44,201.60 45,300.00 42,137.00 --
Year Ending Mar-18 27 171,902.00 200,790.00 165,241.00 --
Year Ending Mar-19 31 194,917.00 203,537.00 182,980.00 207,808.00
Year Ending Mar-20 31 226,122.00 240,324.00 197,618.00 237,902.00
Earnings (per share)
Quarter Ending Dec-18 3 7.01 7.25 6.80 6.92
Quarter Ending Mar-18 8 5.80 6.30 5.40 --
Year Ending Mar-18 31 21.82 23.50 20.30 --
Year Ending Mar-19 32 25.33 29.21 23.30 26.66
Year Ending Mar-20 32 30.33 35.83 25.60 30.99
LT Growth Rate (%) 4 17.41 20.00 11.00 11.93
Sales and Profit Figures in India Rupee (INR);

Valuation Ratios

  Company industry sector
P/E Ratio (TTM) 61.49 18.45 359.91
P/E High - Last 5 Yrs. 55.68 62.66 135.86
P/E Low - Last 5 Yrs. 42.27 15.78 13.98
Beta 1.20 0.49 0.86
Price to Sales (TTM) 6.51 2.53 14.07
Price to Book (MRQ) -- 4.09 3.01
Price to Tangible Book (MRQ) -- 4.46 101.04
Price to Cash Flow (TTM) 51.09 14.43 15.64
% Owned Institutions -- 0.18 0.18

Dividends

  Company industry sector
Dividend Yield 0.72 2.12 2.56
Dividend Yield - 5 Year Avg 0.84 0.34 1.67
Dividend 5 Year Growth Rate 15.72 33.32 17.57
Payout Ratio(TTM) 54.73 30.60 56.13

Growth Rates

  Company industry sector
Sales (MRQ) vs Qtr. 1 Yr. Ago 4.88 12.92 3.90
Sales (TTM) vs TTM 1 Yr. Ago 5.46 43.34 14.61
Sales - 5 Yr. Growth Rate 11.84 -1.45 0.91
EPS (MRQ) vs Qtr. 1 Yr. Ago -20.30 10.69 -215.20
EPS (TTM) vs TTM 1 Yr. Ago -1.06 -- --
EPS - 5 Yr. Growth Rate 14.12 75.22 20.29
Capital Spending - 5 Yr. Growth Rate 4.60 -8.08 -1.02

Financial Strength

  Company industry sector
Quick Ratio (MRQ) -- 1.19 1.79
Current Ratio (MRQ) -- 1.67 2.34
LT Debt to Equity (MRQ) -- 24.64 34.99
Total Debt to Equity (MRQ) -- 32.54 44.06
Interest Coverage (TTM) 68.80 20.44 17.68

Profitability Ratios

  Company industry sector
Gross Margin (TTM) 39.15 26.15 27.80
Gross Margin - 5 Yr. Avg. 39.77 11.50 26.70
EBITD Margin (TTM) 16.63 -- --
EBITD - 5 Yr. Avg 16.65 9.61 21.24
Operating Margin (TTM) 14.63 19.68 11.03
Operating Margin - 5 Yr. Avg. 14.71 5.90 14.83
Pre-Tax Margin (TTM) 16.02 18.57 5.05
Pre-Tax Margin - 5 Yr. Avg. 15.69 4.91 14.80
Net Profit Margin (TTM) 10.74 13.94 6.10
Net Profit Margin - 5 Yr. Avg. 10.72 3.40 11.37
Effective Tax Rate (TTM) 32.95 24.85 19.67
Effective Tax Rate - 5 Yr. Avg. 31.67 30.66 26.34

Efficiency

  Company industry sector
Revenue/Employee (TTM) 27,701,610 12,841,326,594 5,935,838,006
Net Income/Employee (TTM) 2,975,747 1,963,548,550 832,106,122
Receivable Turnover (TTM) -- 12.14 8.76
Inventory Turnover (TTM) -- 7.48 5.68
Asset Turnover (TTM) -- 1.00 0.67

Management Effectiveness

  Company industry sector
Return on Assets (TTM) -- 14.14 8.49
Return on Assets - 5 Yr. Avg. 17.25 3.52 8.39
Return on Investment (TTM) -- 18.53 10.75
Return on Investment - 5 Yr. Avg. 28.34 4.85 10.12
Return on Equity (TTM) -- 25.90 13.94
Return on Equity - 5 Yr. Avg. 29.94 6.70 11.88
  1 Year 3 Year 5 Year
Sales % 6.41 9.85 11.84
EPS (TTM) % 9.65 16.23 14.12
Dividend % 10.67 16.13 15.72
Note: Units in Millions of US Dollars

Performance for Asian Paints Ltd

Period %
Actual
% vs.
S&P 500
Rank In
Industry
Industry
Rank
4 Week -3.87 -4.26 87 94
13 Week 3.75 2.27 99 11
26 Week 7.05 -0.04 99 15
52 Week -4.15 -15.32 94 97
YTD 30.11 8.89 99 69
Note:: Rank is a percentile that ranges from 0 to 99, with 99 = best.

Institutional Holders

% Shares Owned: 18.91%
# of Holders: 197
Total Shares Held: 181,387,328
3 Mo. Net Change: 2,536,326
# New Positions: 5
# Closed Positions: 2
# Increased Positions: 52
# Reduced Positions: 51
# Net Buyers: 1
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.