[NESTLE] QoQ Cumulative Quarter Result on 2013-03-31 [#1] View: Quarter
Cumulative
T4Q
Annualized
Annual (Unaudited)
Show?
Cumulative Quarter Result 31/12/13 30/09/13 30/06/13 31/03/13 31/12/12 30/09/12 30/06/12 CAGR
Revenue 4,787,925 3,649,614 2,441,573 1,227,351 4,556,423 3,456,644 2,313,650 62.18% QoQ % 31.19% 49.48% 98.93% -73.06% 31.82% 49.40% - Horiz. % 206.94% 157.74% 105.53% 53.05% 196.94% 149.40% 100.00%
PBT 719,054 594,610 417,295 243,115 637,668 524,804 350,835 61.14% QoQ % 20.93% 42.49% 71.65% -61.87% 21.51% 49.59% - Horiz. % 204.96% 169.48% 118.94% 69.30% 181.76% 149.59% 100.00%
Tax -157,353 -133,364 -92,640 -58,698 -132,316 -118,931 -72,260 67.77% QoQ % -17.99% -43.96% -57.82% 55.64% -11.25% -64.59% - Horiz. % 217.76% 184.56% 128.20% 81.23% 183.11% 164.59% 100.00%
NP 561,701 461,246 324,655 184,417 505,352 405,873 278,575 59.40% QoQ % 21.78% 42.07% 76.04% -63.51% 24.51% 45.70% - Horiz. % 201.63% 165.57% 116.54% 66.20% 181.41% 145.70% 100.00%
NP to SH 402 461,246 324,655 184,417 -5 405,873 278,575 -98.71% QoQ % -99.91% 42.07% 76.04% 3,688,439.75% -100.00% 45.70% - Horiz. % 0.14% 165.57% 116.54% 66.20% -0.00% 145.70% 100.00%
Tax Rate 21.88 % 22.43 % 22.20 % 24.14 % 20.75 % 22.66 % 20.60 % 4.09% QoQ % -2.45% 1.04% -8.04% 16.34% -8.43% 10.00% - Horiz. % 106.21% 108.88% 107.77% 117.18% 100.73% 110.00% 100.00%
Total Cost 4,226,224 3,188,368 2,116,918 1,042,934 4,051,071 3,050,771 2,035,075 62.56% QoQ % 32.55% 50.61% 102.98% -74.26% 32.79% 49.91% - Horiz. % 207.67% 156.67% 104.02% 51.25% 199.06% 149.91% 100.00%
Net Worth 816,060 841,854 705,844 935,655 750,406 787,919 658,944 15.28% QoQ % -3.06% 19.27% -24.56% 24.69% -4.76% 19.57% - Horiz. % 123.84% 127.76% 107.12% 141.99% 113.88% 119.57% 100.00%
Dividend 31/12/13 30/09/13 30/06/13 31/03/13 31/12/12 30/09/12 30/06/12 CAGR
Div 551,075 140,700 140,700 - 492,454 128,975 128,975 162.62% QoQ % 291.67% 0.00% 0.00% 0.00% 281.82% 0.00% - Horiz. % 427.27% 109.09% 109.09% 0.00% 381.82% 100.00% 100.00%
Div Payout % 137,083.33 % 30.50 % 43.34 % - % - % 31.78 % 46.30 % 20,221.04% QoQ % 449,353.50% -29.63% 0.00% 0.00% 0.00% -31.36% - Horiz. % 296,076.31% 65.87% 93.61% 0.00% 0.00% 68.64% 100.00%
Equity 31/12/13 30/09/13 30/06/13 31/03/13 31/12/12 30/09/12 30/06/12 CAGR
Net Worth 816,060 841,854 705,844 935,655 750,406 787,919 658,944 15.28% QoQ % -3.06% 19.27% -24.56% 24.69% -4.76% 19.57% - Horiz. % 123.84% 127.76% 107.12% 141.99% 113.88% 119.57% 100.00%
NOSH 234,500 234,500 234,500 234,500 234,502 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 31/12/13 30/09/13 30/06/13 31/03/13 31/12/12 30/09/12 30/06/12 CAGR
NP Margin 11.73 % 12.64 % 13.30 % 15.03 % 11.09 % 11.74 % 12.04 % -1.72% QoQ % -7.20% -4.96% -11.51% 35.53% -5.54% -2.49% - Horiz. % 97.43% 104.98% 110.47% 124.83% 92.11% 97.51% 100.00%
ROE 0.05 % 54.79 % 46.00 % 19.71 % 0.00 % 51.51 % 42.28 % -98.87% QoQ % -99.91% 19.11% 133.38% 0.00% 0.00% 21.83% - Horiz. % 0.12% 129.59% 108.80% 46.62% 0.00% 121.83% 100.00%
Per Share 31/12/13 30/09/13 30/06/13 31/03/13 31/12/12 30/09/12 30/06/12 CAGR
RPS 2,041.76 1,556.34 1,041.18 523.39 1,943.02 1,474.05 986.63 62.18% QoQ % 31.19% 49.48% 98.93% -73.06% 31.82% 49.40% - Horiz. % 206.94% 157.74% 105.53% 53.05% 196.94% 149.40% 100.00%
EPS 239.53 196.69 138.45 78.64 215.50 173.08 118.80 59.39% QoQ % 21.78% 42.07% 76.06% -63.51% 24.51% 45.69% - Horiz. % 201.62% 165.56% 116.54% 66.20% 181.40% 145.69% 100.00%
DPS 235.00 60.00 60.00 0.00 210.00 55.00 55.00 162.62% QoQ % 291.67% 0.00% 0.00% 0.00% 281.82% 0.00% - Horiz. % 427.27% 109.09% 109.09% 0.00% 381.82% 100.00% 100.00%
NAPS 3.4800 3.5900 3.0100 3.9900 3.2000 3.3600 2.8100 15.28% QoQ % -3.06% 19.27% -24.56% 24.69% -4.76% 19.57% - Horiz. % 123.84% 127.76% 107.12% 141.99% 113.88% 119.57% 100.00%
Adjusted Per Share Value based on latest NOSH - 234,500 31/12/13 30/09/13 30/06/13 31/03/13 31/12/12 30/09/12 30/06/12 CAGR
RPS 2,041.76 1,556.34 1,041.18 523.39 1,943.04 1,474.05 986.63 62.18% QoQ % 31.19% 49.48% 98.93% -73.06% 31.82% 49.40% - Horiz. % 206.94% 157.74% 105.53% 53.05% 196.94% 149.40% 100.00%
EPS 239.53 196.69 138.45 78.64 0.00 173.08 118.80 59.39% QoQ % 21.78% 42.07% 76.06% 0.00% 0.00% 45.69% - Horiz. % 201.62% 165.56% 116.54% 66.20% 0.00% 145.69% 100.00%
DPS 235.00 60.00 60.00 0.00 210.00 55.00 55.00 162.62% QoQ % 291.67% 0.00% 0.00% 0.00% 281.82% 0.00% - Horiz. % 427.27% 109.09% 109.09% 0.00% 381.82% 100.00% 100.00%
NAPS 3.4800 3.5900 3.0100 3.9900 3.2000 3.3600 2.8100 15.28% QoQ % -3.06% 19.27% -24.56% 24.69% -4.76% 19.57% - Horiz. % 123.84% 127.76% 107.12% 141.99% 113.88% 119.57% 100.00%
Price Multiplier on Financial Quarter End Date 31/12/13 30/09/13 30/06/13 31/03/13 31/12/12 30/09/12 30/06/12 CAGR
Date 31/12/13 30/09/13 28/06/13 29/03/13 31/12/12 28/09/12 29/06/12 -
Price 68.0000 68.0000 67.0000 60.6800 62.8400 61.5000 57.5000 -
P/RPS 3.33 4.37 6.43 11.59 3.23 4.17 5.83 -31.09% QoQ % -23.80% -32.04% -44.52% 258.82% -22.54% -28.47% - Horiz. % 57.12% 74.96% 110.29% 198.80% 55.40% 71.53% 100.00%
P/EPS 39,666.67 34.57 48.39 77.16 -2,947,222.00 35.53 48.40 8,551.27% QoQ % 114,643.05% -28.56% -37.29% 100.00% -8,295,124.00% -26.59% - Horiz. % 81,955.93% 71.43% 99.98% 159.42% -6,089,301.50% 73.41% 100.00%
EY 0.00 2.89 2.07 1.30 0.00 2.81 2.07 - QoQ % 0.00% 39.61% 59.23% 0.00% 0.00% 35.75% - Horiz. % 0.00% 139.61% 100.00% 62.80% 0.00% 135.75% 100.00%
DY 3.46 0.88 0.90 0.00 3.34 0.89 0.96 134.52% QoQ % 293.18% -2.22% 0.00% 0.00% 275.28% -7.29% - Horiz. % 360.42% 91.67% 93.75% 0.00% 347.92% 92.71% 100.00%
P/NAPS 19.54 18.94 22.26 15.21 19.64 18.30 20.46 -3.01% QoQ % 3.17% -14.91% 46.35% -22.56% 7.32% -10.56% - Horiz. % 95.50% 92.57% 108.80% 74.34% 95.99% 89.44% 100.00%
Price Multiplier on Announcement Date 31/12/13 30/09/13 30/06/13 31/03/13 31/12/12 30/09/12 30/06/12 CAGR
Date 24/02/14 12/11/13 22/08/13 30/04/13 21/02/13 01/11/12 30/08/12 -
Price 66.0000 68.6000 67.5400 61.8000 58.7000 69.5000 64.0200 -
P/RPS 3.23 4.41 6.49 11.81 3.02 4.71 6.49 -37.12% QoQ % -26.76% -32.05% -45.05% 291.06% -35.88% -27.43% - Horiz. % 49.77% 67.95% 100.00% 181.97% 46.53% 72.57% 100.00%
P/EPS 38,500.00 34.88 48.78 78.58 -2,753,054.50 40.15 53.89 7,796.53% QoQ % 110,278.45% -28.50% -37.92% 100.00% -6,857,022.50% -25.50% - Horiz. % 71,441.83% 64.72% 90.52% 145.82% -5,108,655.50% 74.50% 100.00%
EY 0.00 2.87 2.05 1.27 0.00 2.49 1.86 - QoQ % 0.00% 40.00% 61.42% 0.00% 0.00% 33.87% - Horiz. % 0.00% 154.30% 110.22% 68.28% 0.00% 133.87% 100.00%
DY 3.56 0.87 0.89 0.00 3.58 0.79 0.86 157.14% QoQ % 309.20% -2.25% 0.00% 0.00% 353.16% -8.14% - Horiz. % 413.95% 101.16% 103.49% 0.00% 416.28% 91.86% 100.00%
P/NAPS 18.97 19.11 22.44 15.49 18.34 20.68 22.78 -11.46% QoQ % -0.73% -14.84% 44.87% -15.54% -11.32% -9.22% - Horiz. % 83.27% 83.89% 98.51% 68.00% 80.51% 90.78% 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
03KLSEreporting2013.pdf 
