[NESTLE] QoQ Annualized Quarter Result on 2016-12-31 [#4] View: Quarter
Cumulative
T4Q
Annualized
Annual (Unaudited)
Show?
Annualized Quarter Result 30/09/17 30/06/17 31/03/17 31/12/16 30/09/16 30/06/16 31/03/16 CAGR
Revenue 5,305,020 5,311,024 5,487,528 5,063,506 5,084,832 5,101,254 5,253,848 0.65% QoQ % -0.11% -3.22% 8.37% -0.42% -0.32% -2.90% - Horiz. % 100.97% 101.09% 104.45% 96.38% 96.78% 97.10% 100.00%
PBT 864,484 1,006,564 1,163,984 766,494 913,336 999,510 1,103,432 -15.00% QoQ % -14.12% -13.52% 51.86% -16.08% -8.62% -9.42% - Horiz. % 78.35% 91.22% 105.49% 69.46% 82.77% 90.58% 100.00%
Tax -181,482 -221,562 -241,236 -129,367 -153,088 -180,562 -220,724 -12.22% QoQ % 18.09% 8.16% -86.47% 15.50% 15.22% 18.20% - Horiz. % 82.22% 100.38% 109.29% 58.61% 69.36% 81.80% 100.00%
NP 683,001 785,002 922,748 637,127 760,248 818,948 882,708 -15.70% QoQ % -12.99% -14.93% 44.83% -16.19% -7.17% -7.22% - Horiz. % 77.38% 88.93% 104.54% 72.18% 86.13% 92.78% 100.00%
NP to SH 683,001 785,002 922,748 637,127 760,248 818,948 882,708 -15.70% QoQ % -12.99% -14.93% 44.83% -16.19% -7.17% -7.22% - Horiz. % 77.38% 88.93% 104.54% 72.18% 86.13% 92.78% 100.00%
Tax Rate 20.99 % 22.01 % 20.73 % 16.88 % 16.76 % 18.07 % 20.00 % 3.27% QoQ % -4.63% 6.17% 22.81% 0.72% -7.25% -9.65% - Horiz. % 104.95% 110.05% 103.65% 84.40% 83.80% 90.35% 100.00%
Total Cost 4,622,018 4,526,022 4,564,780 4,426,379 4,324,584 4,282,306 4,371,140 3.79% QoQ % 2.12% -0.85% 3.13% 2.35% 0.99% -2.03% - Horiz. % 105.74% 103.54% 104.43% 101.26% 98.93% 97.97% 100.00%
Net Worth 673,014 712,879 862,960 647,219 745,710 722,259 844,199 -14.01% QoQ % -5.59% -17.39% 33.33% -13.21% 3.25% -14.44% - Horiz. % 79.72% 84.44% 102.22% 76.67% 88.33% 85.56% 100.00%
Dividend 30/09/17 30/06/17 31/03/17 31/12/16 30/09/16 30/06/16 31/03/16 CAGR
Div 437,733 328,300 - 633,150 437,733 328,300 - - QoQ % 33.33% 0.00% 0.00% 44.64% 33.33% 0.00% - Horiz. % 133.33% 100.00% 0.00% 192.86% 133.33% 100.00% -
Div Payout % 64.09 % 41.82 % - % 99.38 % 57.58 % 40.09 % - % - QoQ % 53.25% 0.00% 0.00% 72.59% 43.63% 0.00% - Horiz. % 159.87% 104.32% 0.00% 247.89% 143.63% 100.00% -
Equity 30/09/17 30/06/17 31/03/17 31/12/16 30/09/16 30/06/16 31/03/16 CAGR
Net Worth 673,014 712,879 862,960 647,219 745,710 722,259 844,199 -14.01% QoQ % -5.59% -17.39% 33.33% -13.21% 3.25% -14.44% - Horiz. % 79.72% 84.44% 102.22% 76.67% 88.33% 85.56% 100.00%
NOSH 234,500 234,500 234,500 234,500 234,500 234,500 234,500 - QoQ % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% - Horiz. % 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Ratio Analysis 30/09/17 30/06/17 31/03/17 31/12/16 30/09/16 30/06/16 31/03/16 CAGR
NP Margin 12.87 % 14.78 % 16.82 % 12.58 % 14.95 % 16.05 % 16.80 % -16.26% QoQ % -12.92% -12.13% 33.70% -15.85% -6.85% -4.46% - Horiz. % 76.61% 87.98% 100.12% 74.88% 88.99% 95.54% 100.00%
ROE 101.48 % 110.12 % 106.93 % 98.44 % 101.95 % 113.39 % 104.56 % -1.97% QoQ % -7.85% 2.98% 8.62% -3.44% -10.09% 8.44% - Horiz. % 97.05% 105.32% 102.27% 94.15% 97.50% 108.44% 100.00%
Per Share 30/09/17 30/06/17 31/03/17 31/12/16 30/09/16 30/06/16 31/03/16 CAGR
RPS 2,262.27 2,264.83 2,340.10 2,159.28 2,168.37 2,175.37 2,240.45 0.65% QoQ % -0.11% -3.22% 8.37% -0.42% -0.32% -2.90% - Horiz. % 100.97% 101.09% 104.45% 96.38% 96.78% 97.10% 100.00%
EPS 291.25 334.76 393.48 271.70 324.20 349.24 376.44 -15.71% QoQ % -13.00% -14.92% 44.82% -16.19% -7.17% -7.23% - Horiz. % 77.37% 88.93% 104.53% 72.18% 86.12% 92.77% 100.00%
DPS 186.67 140.00 0.00 270.00 186.67 140.00 0.00 - QoQ % 33.34% 0.00% 0.00% 44.64% 33.34% 0.00% - Horiz. % 133.34% 100.00% 0.00% 192.86% 133.34% 100.00% -
NAPS 2.8700 3.0400 3.6800 2.7600 3.1800 3.0800 3.6000 -14.01% QoQ % -5.59% -17.39% 33.33% -13.21% 3.25% -14.44% - Horiz. % 79.72% 84.44% 102.22% 76.67% 88.33% 85.56% 100.00%
Adjusted Per Share Value based on latest NOSH - 234,500 30/09/17 30/06/17 31/03/17 31/12/16 30/09/16 30/06/16 31/03/16 CAGR
RPS 2,262.27 2,264.83 2,340.10 2,159.28 2,168.37 2,175.37 2,240.45 0.65% QoQ % -0.11% -3.22% 8.37% -0.42% -0.32% -2.90% - Horiz. % 100.97% 101.09% 104.45% 96.38% 96.78% 97.10% 100.00%
EPS 291.25 334.76 393.48 271.70 324.20 349.24 376.44 -15.71% QoQ % -13.00% -14.92% 44.82% -16.19% -7.17% -7.23% - Horiz. % 77.37% 88.93% 104.53% 72.18% 86.12% 92.77% 100.00%
DPS 186.67 140.00 0.00 270.00 186.67 140.00 0.00 - QoQ % 33.34% 0.00% 0.00% 44.64% 33.34% 0.00% - Horiz. % 133.34% 100.00% 0.00% 192.86% 133.34% 100.00% -
NAPS 2.8700 3.0400 3.6800 2.7600 3.1800 3.0800 3.6000 -14.01% QoQ % -5.59% -17.39% 33.33% -13.21% 3.25% -14.44% - Horiz. % 79.72% 84.44% 102.22% 76.67% 88.33% 85.56% 100.00%
Price Multiplier on Financial Quarter End Date 30/09/17 30/06/17 31/03/17 31/12/16 30/09/16 30/06/16 31/03/16 CAGR
Date 29/09/17 30/06/17 31/03/17 30/12/16 30/09/16 30/06/16 31/03/16 -
Price 84.8000 85.0000 79.3800 78.2000 78.8600 76.5200 76.9000 -
P/RPS 3.75 3.75 3.39 3.62 3.64 3.52 3.43 6.12% QoQ % 0.00% 10.62% -6.35% -0.55% 3.41% 2.62% - Horiz. % 109.33% 109.33% 98.83% 105.54% 106.12% 102.62% 100.00%
P/EPS 29.12 25.39 20.17 28.78 24.32 21.91 20.43 26.63% QoQ % 14.69% 25.88% -29.92% 18.34% 11.00% 7.24% - Horiz. % 142.54% 124.28% 98.73% 140.87% 119.04% 107.24% 100.00%
EY 3.43 3.94 4.96 3.47 4.11 4.56 4.89 -21.04% QoQ % -12.94% -20.56% 42.94% -15.57% -9.87% -6.75% - Horiz. % 70.14% 80.57% 101.43% 70.96% 84.05% 93.25% 100.00%
DY 2.20 1.65 0.00 3.45 2.37 1.83 0.00 - QoQ % 33.33% 0.00% 0.00% 45.57% 29.51% 0.00% - Horiz. % 120.22% 90.16% 0.00% 188.52% 129.51% 100.00% -
P/NAPS 29.55 27.96 21.57 28.33 24.80 24.84 21.36 24.13% QoQ % 5.69% 29.62% -23.86% 14.23% -0.16% 16.29% - Horiz. % 138.34% 130.90% 100.98% 132.63% 116.10% 116.29% 100.00%
Price Multiplier on Announcement Date 30/09/17 30/06/17 31/03/17 31/12/16 30/09/16 30/06/16 31/03/16 CAGR
Date 07/11/17 21/08/17 25/04/17 28/02/17 25/10/16 22/08/16 26/04/16 -
Price 88.0000 84.5800 82.4800 75.7000 78.2000 78.7600 75.0000 -
P/RPS 3.89 3.73 3.52 3.51 3.61 3.62 3.35 10.47% QoQ % 4.29% 5.97% 0.28% -2.77% -0.28% 8.06% - Horiz. % 116.12% 111.34% 105.07% 104.78% 107.76% 108.06% 100.00%
P/EPS 30.21 25.27 20.96 27.86 24.12 22.55 19.92 31.97% QoQ % 19.55% 20.56% -24.77% 15.51% 6.96% 13.20% - Horiz. % 151.66% 126.86% 105.22% 139.86% 121.08% 113.20% 100.00%
EY 3.31 3.96 4.77 3.59 4.15 4.43 5.02 -24.22% QoQ % -16.41% -16.98% 32.87% -13.49% -6.32% -11.75% - Horiz. % 65.94% 78.88% 95.02% 71.51% 82.67% 88.25% 100.00%
DY 2.12 1.66 0.00 3.57 2.39 1.78 0.00 - QoQ % 27.71% 0.00% 0.00% 49.37% 34.27% 0.00% - Horiz. % 119.10% 93.26% 0.00% 200.56% 134.27% 100.00% -
P/NAPS 30.66 27.82 22.41 27.43 24.59 25.57 20.83 29.37% QoQ % 10.21% 24.14% -18.30% 11.55% -3.83% 22.76% - Horiz. % 147.19% 133.56% 107.59% 131.69% 118.05% 122.76% 100.00%
PBT = Profit before Tax, NP = Net Profit, NP to SH = Net Profit Attributable to Shareholder, Div = Dividend, NP Margin = Net Profit Margin, ROE = Return on Equity, NOSH = Number of Shares, RPS = Revenue per Share, EPS = Earning Per Share, DPS = Dividend Per Share, NAPS = Net Asset Per Share, EOQ = End of Quarter, ANN = Announcement, P/RPS = Price/Revenue per Share, P/EPS = Price/Earning per Share, P/NAPS = Price/Net Asset per Share, EY = Earning Yield, DY = Dividend Yield.
NOSH is estimated based on the NP to SH and EPS. Div is an estimated figure based on the DPS and NOSH. Net Worth is an estimated figure based on the NAPS and NOSH.
Div Payout %, NP Margin, ROE, DY, QoQ Δ & YoY Δ figures in Percentage; RPS, EPS & DPS's figures in Cent; and NAPS's figures in Dollar.
All figures in '000 unless specified.
Be the first to like this.
Comment
12KLSEreporting2016.pdf 
