[NESTLE] QoQ TTM Result on 2011-06-30 [#2] View: Quarter
Cumulative
T4Q
Annualized
Annual (Unaudited)
Show? QoQ % Horiz. %
TTM Result 31/03/12 31/12/11 30/09/11 30/06/11 31/03/11 31/12/10 30/09/10 CAGR
Revenue 4,338,112 4,246,744 4,137,809 4,067,843 4,078,592 4,026,319 4,013,058 5.32% QoQ % 2.15% 2.63% 1.72% -0.26% 1.30% 0.33% - Horiz. % 108.10% 105.82% 103.11% 101.37% 101.63% 100.33% 100.00%
PBT 574,528 558,808 501,965 496,537 486,233 465,743 519,914 6.88% QoQ % 2.81% 11.32% 1.09% 2.12% 4.40% -10.42% - Horiz. % 110.50% 107.48% 96.55% 95.50% 93.52% 89.58% 100.00%
Tax -136,473 -131,681 -110,847 -98,553 -86,482 -74,346 -81,552 40.91% QoQ % -3.64% -18.80% -12.47% -13.96% -16.32% 8.84% - Horiz. % 167.34% 161.47% 135.92% 120.85% 106.05% 91.16% 100.00%
NP 438,055 427,127 391,118 397,984 399,751 391,397 438,362 -0.05% QoQ % 2.56% 9.21% -1.73% -0.44% 2.13% -10.71% - Horiz. % 99.93% 97.44% 89.22% 90.79% 91.19% 89.29% 100.00%
NP to SH 438,055 427,127 391,118 397,984 399,751 391,397 438,362 -0.05% QoQ % 2.56% 9.21% -1.73% -0.44% 2.13% -10.71% - Horiz. % 99.93% 97.44% 89.22% 90.79% 91.19% 89.29% 100.00%
Tax Rate 23.75 % 23.56 % 22.08 % 19.85 % 17.79 % 15.96 % 15.69 % 31.80% QoQ % 0.81% 6.70% 11.23% 11.58% 11.47% 1.72% - Horiz. % 151.37% 150.16% 140.73% 126.51% 113.38% 101.72% 100.00%
Total Cost 3,900,057 3,819,617 3,746,691 3,669,859 3,678,841 3,634,922 3,574,696 5.97% QoQ % 2.11% 1.95% 2.09% -0.24% 1.21% 1.68% - Horiz. % 109.10% 106.85% 104.81% 102.66% 102.91% 101.68% 100.00%
Net Worth 837,164 651,881 468,983 468,965 703,514 614,447 689,392 13.81% QoQ % 28.42% 39.00% 0.00% -33.34% 14.50% -10.87% - Horiz. % 121.44% 94.56% 68.03% 68.03% 102.05% 89.13% 100.00%
Dividend 31/03/12 31/12/11 30/09/11 30/06/11 31/03/11 31/12/10 30/09/10 CAGR
Div 422,077 422,077 398,665 398,665 386,948 386,948 351,743 12.91% QoQ % 0.00% 5.87% 0.00% 3.03% 0.00% 10.01% - Horiz. % 120.00% 120.00% 113.34% 113.34% 110.01% 110.01% 100.00%
Div Payout % 96.35 % 98.82 % 101.93 % 100.17 % 96.80 % 98.86 % 80.24 % 12.96% QoQ % -2.50% -3.05% 1.76% 3.48% -2.08% 23.21% - Horiz. % 120.08% 123.16% 127.03% 124.84% 120.64% 123.21% 100.00%
Equity 31/03/12 31/12/11 30/09/11 30/06/11 31/03/11 31/12/10 30/09/10 CAGR
Net Worth 837,164 651,881 468,983 468,965 703,514 614,447 689,392 13.81% QoQ % 28.42% 39.00% 0.00% -33.34% 14.50% -10.87% - Horiz. % 121.44% 94.56% 68.03% 68.03% 102.05% 89.13% 100.00%
NOSH 234,500 234,489 234,491 234,482 234,504 234,522 234,487 0.00% QoQ % 0.00% -0.00% 0.00% -0.01% -0.01% 0.01% - Horiz. % 100.01% 100.00% 100.00% 100.00% 100.01% 100.01% 100.00%
Ratio Analysis 31/03/12 31/12/11 30/09/11 30/06/11 31/03/11 31/12/10 30/09/10 CAGR
NP Margin 10.10 % 10.06 % 9.45 % 9.78 % 9.80 % 9.72 % 10.92 % -5.07% QoQ % 0.40% 6.46% -3.37% -0.20% 0.82% -10.99% - Horiz. % 92.49% 92.12% 86.54% 89.56% 89.74% 89.01% 100.00%
ROE 52.33 % 65.52 % 83.40 % 84.86 % 56.82 % 63.70 % 63.59 % -12.17% QoQ % -20.13% -21.44% -1.72% 49.35% -10.80% 0.17% - Horiz. % 82.29% 103.04% 131.15% 133.45% 89.35% 100.17% 100.00%
Per Share 31/03/12 31/12/11 30/09/11 30/06/11 31/03/11 31/12/10 30/09/10 CAGR
RPS 1,849.94 1,811.06 1,764.59 1,734.81 1,739.24 1,716.82 1,711.42 5.32% QoQ % 2.15% 2.63% 1.72% -0.25% 1.31% 0.32% - Horiz. % 108.09% 105.82% 103.11% 101.37% 101.63% 100.32% 100.00%
EPS 186.80 182.15 166.79 169.73 170.47 166.89 186.94 -0.05% QoQ % 2.55% 9.21% -1.73% -0.43% 2.15% -10.73% - Horiz. % 99.93% 97.44% 89.22% 90.79% 91.19% 89.27% 100.00%
DPS 180.00 180.00 170.00 170.00 165.00 165.00 150.00 12.91% QoQ % 0.00% 5.88% 0.00% 3.03% 0.00% 10.00% - Horiz. % 120.00% 120.00% 113.33% 113.33% 110.00% 110.00% 100.00%
NAPS 3.5700 2.7800 2.0000 2.0000 3.0000 2.6200 2.9400 13.81% QoQ % 28.42% 39.00% 0.00% -33.33% 14.50% -10.88% - Horiz. % 121.43% 94.56% 68.03% 68.03% 102.04% 89.12% 100.00%
Adjusted Per Share Value based on latest NOSH - 234,500 31/03/12 31/12/11 30/09/11 30/06/11 31/03/11 31/12/10 30/09/10 CAGR
RPS 1,849.94 1,810.98 1,764.52 1,734.69 1,739.27 1,716.98 1,711.33 5.32% QoQ % 2.15% 2.63% 1.72% -0.26% 1.30% 0.33% - Horiz. % 108.10% 105.82% 103.11% 101.37% 101.63% 100.33% 100.00%
EPS 186.80 182.14 166.79 169.72 170.47 166.91 186.93 -0.05% QoQ % 2.56% 9.20% -1.73% -0.44% 2.13% -10.71% - Horiz. % 99.93% 97.44% 89.23% 90.79% 91.19% 89.29% 100.00%
DPS 180.00 179.99 170.01 170.01 165.01 165.01 150.00 12.91% QoQ % 0.01% 5.87% 0.00% 3.03% 0.00% 10.01% - Horiz. % 120.00% 119.99% 113.34% 113.34% 110.01% 110.01% 100.00%
NAPS 3.5700 2.7799 1.9999 1.9999 3.0001 2.6202 2.9398 13.81% QoQ % 28.42% 39.00% 0.00% -33.34% 14.50% -10.87% - Horiz. % 121.44% 94.56% 68.03% 68.03% 102.05% 89.13% 100.00%
Price Multiplier on Financial Quarter End Date 31/03/12 31/12/11 30/09/11 30/06/11 31/03/11 31/12/10 30/09/10 CAGR
Date 30/03/12 30/12/11 30/09/11 30/06/11 31/03/11 30/12/10 30/09/10 -
Price 56.0000 56.2000 47.9800 47.2000 46.8000 43.3400 42.0000 -
P/RPS 3.03 3.10 2.72 2.72 2.69 2.52 2.45 15.20% QoQ % -2.26% 13.97% 0.00% 1.12% 6.75% 2.86% - Horiz. % 123.67% 126.53% 111.02% 111.02% 109.80% 102.86% 100.00%
P/EPS 29.98 30.85 28.77 27.81 27.45 25.97 22.47 21.17% QoQ % -2.82% 7.23% 3.45% 1.31% 5.70% 15.58% - Horiz. % 133.42% 137.29% 128.04% 123.77% 122.16% 115.58% 100.00%
EY 3.34 3.24 3.48 3.60 3.64 3.85 4.45 -17.40% QoQ % 3.09% -6.90% -3.33% -1.10% -5.45% -13.48% - Horiz. % 75.06% 72.81% 78.20% 80.90% 81.80% 86.52% 100.00%
DY 3.21 3.20 3.54 3.60 3.53 3.81 3.57 -6.84% QoQ % 0.31% -9.60% -1.67% 1.98% -7.35% 6.72% - Horiz. % 89.92% 89.64% 99.16% 100.84% 98.88% 106.72% 100.00%
P/NAPS 15.69 20.22 23.99 23.60 15.60 16.54 14.29 6.42% QoQ % -22.40% -15.71% 1.65% 51.28% -5.68% 15.75% - Horiz. % 109.80% 141.50% 167.88% 165.15% 109.17% 115.75% 100.00%
Price Multiplier on Announcement Date 31/03/12 31/12/11 30/09/11 30/06/11 31/03/11 31/12/10 30/09/10 CAGR
Date 25/04/12 23/02/12 04/11/11 18/08/11 20/04/11 24/02/11 28/10/10 -
Price 55.8600 55.8000 50.0000 47.9000 48.0000 45.3000 43.6000 -
P/RPS 3.02 3.08 2.83 2.76 2.76 2.64 2.55 11.93% QoQ % -1.95% 8.83% 2.54% 0.00% 4.55% 3.53% - Horiz. % 118.43% 120.78% 110.98% 108.24% 108.24% 103.53% 100.00%
P/EPS 29.90 30.63 29.98 28.22 28.16 27.14 23.32 18.00% QoQ % -2.38% 2.17% 6.24% 0.21% 3.76% 16.38% - Horiz. % 128.22% 131.35% 128.56% 121.01% 120.75% 116.38% 100.00%
EY 3.34 3.26 3.34 3.54 3.55 3.68 4.29 -15.36% QoQ % 2.45% -2.40% -5.65% -0.28% -3.53% -14.22% - Horiz. % 77.86% 75.99% 77.86% 82.52% 82.75% 85.78% 100.00%
DY 3.22 3.23 3.40 3.55 3.44 3.64 3.44 -4.31% QoQ % -0.31% -5.00% -4.23% 3.20% -5.49% 5.81% - Horiz. % 93.60% 93.90% 98.84% 103.20% 100.00% 105.81% 100.00%
P/NAPS 15.65 20.07 25.00 23.95 16.00 17.29 14.83 3.65% QoQ % -22.02% -19.72% 4.38% 49.69% -7.46% 16.59% - Horiz. % 105.53% 135.33% 168.58% 161.50% 107.89% 116.59% 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