[NESTLE] YoY Cumulative Quarter Result on 2006-12-31 [#4] View: Quarter
Cumulative
T4Q
Annualized
Annual (Unaudited)
Show?
Cumulative Quarter Result 31/12/09 31/12/08 31/12/07 31/12/06 31/12/05 31/12/04 31/12/03 CAGR
Revenue 3,744,233 3,877,068 3,416,028 3,275,541 3,127,441 2,901,183 2,656,989 5.88% YoY % -3.43% 13.50% 4.29% 4.74% 7.80% 9.19% - Horiz. % 140.92% 145.92% 128.57% 123.28% 117.71% 109.19% 100.00%
PBT 440,261 441,353 395,298 363,285 331,253 297,209 202,117 13.84% YoY % -0.25% 11.65% 8.81% 9.67% 11.45% 47.05% - Horiz. % 217.82% 218.37% 195.58% 179.74% 163.89% 147.05% 100.00%
Tax -88,468 -100,466 -103,256 -99,066 0 -76,801 -40,128 14.07% YoY % 11.94% 2.70% -4.23% 0.00% 0.00% -91.39% - Horiz. % 220.46% 250.36% 257.32% 246.88% -0.00% 191.39% 100.00%
NP 351,793 340,887 292,042 264,219 331,253 220,408 161,989 13.78% YoY % 3.20% 16.73% 10.53% -20.24% 50.29% 36.06% - Horiz. % 217.17% 210.44% 180.29% 163.11% 204.49% 136.06% 100.00%
NP to SH 351,793 340,887 292,042 264,219 266,819 220,408 161,989 13.78% YoY % 3.20% 16.73% 10.53% -0.97% 21.06% 36.06% - Horiz. % 217.17% 210.44% 180.29% 163.11% 164.71% 136.06% 100.00%
Tax Rate 20.09 % 22.76 % 26.12 % 27.27 % - % 25.84 % 19.85 % 0.20% YoY % -11.73% -12.86% -4.22% 0.00% 0.00% 30.18% - Horiz. % 101.21% 114.66% 131.59% 137.38% 0.00% 130.18% 100.00%
Total Cost 3,392,440 3,536,181 3,123,986 3,011,322 2,796,188 2,680,775 2,495,000 5.25% YoY % -4.06% 13.19% 3.74% 7.69% 4.31% 7.45% - Horiz. % 135.97% 141.73% 125.21% 120.69% 112.07% 107.45% 100.00%
Net Worth 567,483 515,891 637,830 558,126 537,014 368,167 304,843 10.90% YoY % 10.00% -19.12% 14.28% 3.93% 45.86% 20.77% - Horiz. % 186.16% 169.23% 209.23% 183.09% 176.16% 120.77% 100.00%
Dividend 31/12/09 31/12/08 31/12/07 31/12/06 31/12/05 31/12/04 31/12/03 CAGR
Div 351,746 448,333 266,880 234,506 199,797 188,070 176,340 12.18% YoY % -21.54% 67.99% 13.80% 17.37% 6.24% 6.65% - Horiz. % 199.47% 254.24% 151.34% 132.99% 113.30% 106.65% 100.00%
Div Payout % 99.99 % 131.52 % 91.38 % 88.75 % 74.88 % 85.33 % 108.86 % -1.41% YoY % -23.97% 43.93% 2.96% 18.52% -12.25% -21.61% - Horiz. % 91.85% 120.82% 83.94% 81.53% 68.79% 78.39% 100.00%
Equity 31/12/09 31/12/08 31/12/07 31/12/06 31/12/05 31/12/04 31/12/03 CAGR
Net Worth 567,483 515,891 637,830 558,126 537,014 368,167 304,843 10.90% YoY % 10.00% -19.12% 14.28% 3.93% 45.86% 20.77% - Horiz. % 186.16% 169.23% 209.23% 183.09% 176.16% 120.77% 100.00%
NOSH 234,497 234,496 234,496 234,506 234,504 234,501 234,494 0.00% YoY % 0.00% -0.00% -0.00% 0.00% 0.00% 0.00% - Horiz. % 100.00% 100.00% 100.00% 100.01% 100.00% 100.00% 100.00%
Ratio Analysis 31/12/09 31/12/08 31/12/07 31/12/06 31/12/05 31/12/04 31/12/03 CAGR
NP Margin 9.40 % 8.79 % 8.55 % 8.07 % 10.59 % 7.60 % 6.10 % 7.47% YoY % 6.94% 2.81% 5.95% -23.80% 39.34% 24.59% - Horiz. % 154.10% 144.10% 140.16% 132.30% 173.61% 124.59% 100.00%
ROE 61.99 % 66.08 % 45.79 % 47.34 % 49.69 % 59.87 % 53.14 % 2.60% YoY % -6.19% 44.31% -3.27% -4.73% -17.00% 12.66% - Horiz. % 116.65% 124.35% 86.17% 89.09% 93.51% 112.66% 100.00%
Per Share 31/12/09 31/12/08 31/12/07 31/12/06 31/12/05 31/12/04 31/12/03 CAGR
RPS 1,596.71 1,653.36 1,456.75 1,396.78 1,333.64 1,237.17 1,133.07 5.88% YoY % -3.43% 13.50% 4.29% 4.73% 7.80% 9.19% - Horiz. % 140.92% 145.92% 128.57% 123.27% 117.70% 109.19% 100.00%
EPS 150.02 145.37 124.54 112.67 113.78 93.99 69.08 13.78% YoY % 3.20% 16.73% 10.54% -0.98% 21.06% 36.06% - Horiz. % 217.17% 210.44% 180.28% 163.10% 164.71% 136.06% 100.00%
DPS 150.00 191.19 113.81 100.00 85.20 80.20 75.20 12.18% YoY % -21.54% 67.99% 13.81% 17.37% 6.23% 6.65% - Horiz. % 199.47% 254.24% 151.34% 132.98% 113.30% 106.65% 100.00%
NAPS 2.4200 2.2000 2.7200 2.3800 2.2900 1.5700 1.3000 10.90% YoY % 10.00% -19.12% 14.29% 3.93% 45.86% 20.77% - Horiz. % 186.15% 169.23% 209.23% 183.08% 176.15% 120.77% 100.00%
Adjusted Per Share Value based on latest NOSH - 234,500 31/12/09 31/12/08 31/12/07 31/12/06 31/12/05 31/12/04 31/12/03 CAGR
RPS 1,596.69 1,653.33 1,456.73 1,396.82 1,333.66 1,237.18 1,133.04 5.88% YoY % -3.43% 13.50% 4.29% 4.74% 7.80% 9.19% - Horiz. % 140.92% 145.92% 128.57% 123.28% 117.71% 109.19% 100.00%
EPS 150.02 145.37 124.54 112.67 113.78 93.99 69.08 13.78% YoY % 3.20% 16.73% 10.54% -0.98% 21.06% 36.06% - Horiz. % 217.17% 210.44% 180.28% 163.10% 164.71% 136.06% 100.00%
DPS 150.00 191.19 113.81 100.00 85.20 80.20 75.20 12.18% YoY % -21.54% 67.99% 13.81% 17.37% 6.23% 6.65% - Horiz. % 199.47% 254.24% 151.34% 132.98% 113.30% 106.65% 100.00%
NAPS 2.4200 2.2000 2.7200 2.3801 2.2900 1.5700 1.3000 10.90% YoY % 10.00% -19.12% 14.28% 3.93% 45.86% 20.77% - Horiz. % 186.15% 169.23% 209.23% 183.08% 176.15% 120.77% 100.00%
Price Multiplier on Financial Quarter End Date 31/12/09 31/12/08 31/12/07 31/12/06 31/12/05 31/12/04 31/12/03 CAGR
Date 31/12/09 31/12/08 31/12/07 29/12/06 30/12/05 31/12/04 31/12/03 -
Price 33.1000 27.0000 26.2500 24.8000 24.3000 23.1000 21.8000 -
P/RPS 2.07 1.63 1.80 1.78 1.82 1.87 1.92 1.26% YoY % 26.99% -9.44% 1.12% -2.20% -2.67% -2.60% - Horiz. % 107.81% 84.90% 93.75% 92.71% 94.79% 97.40% 100.00%
P/EPS 22.06 18.57 21.08 22.01 21.36 24.58 31.56 -5.79% YoY % 18.79% -11.91% -4.23% 3.04% -13.10% -22.12% - Horiz. % 69.90% 58.84% 66.79% 69.74% 67.68% 77.88% 100.00%
EY 4.53 5.38 4.74 4.54 4.68 4.07 3.17 6.12% YoY % -15.80% 13.50% 4.41% -2.99% 14.99% 28.39% - Horiz. % 142.90% 169.72% 149.53% 143.22% 147.63% 128.39% 100.00%
DY 4.53 7.08 4.34 4.03 3.51 3.47 3.45 4.64% YoY % -36.02% 63.13% 7.69% 14.81% 1.15% 0.58% - Horiz. % 131.30% 205.22% 125.80% 116.81% 101.74% 100.58% 100.00%
P/NAPS 13.68 12.27 9.65 10.42 10.61 14.71 16.77 -3.33% YoY % 11.49% 27.15% -7.39% -1.79% -27.87% -12.28% - Horiz. % 81.57% 73.17% 57.54% 62.13% 63.27% 87.72% 100.00%
Price Multiplier on Announcement Date 31/12/09 31/12/08 31/12/07 31/12/06 31/12/05 31/12/04 31/12/03 CAGR
Date 25/02/10 26/02/09 28/02/08 27/02/07 23/02/06 24/02/05 26/02/04 -
Price 33.9000 27.5000 26.2500 24.0000 24.7000 23.6000 22.1000 -
P/RPS 2.12 1.66 1.80 1.72 1.85 1.91 1.95 1.40% YoY % 27.71% -7.78% 4.65% -7.03% -3.14% -2.05% - Horiz. % 108.72% 85.13% 92.31% 88.21% 94.87% 97.95% 100.00%
P/EPS 22.60 18.92 21.08 21.30 21.71 25.11 31.99 -5.62% YoY % 19.45% -10.25% -1.03% -1.89% -13.54% -21.51% - Horiz. % 70.65% 59.14% 65.90% 66.58% 67.86% 78.49% 100.00%
EY 4.43 5.29 4.74 4.69 4.61 3.98 3.13 5.95% YoY % -16.26% 11.60% 1.07% 1.74% 15.83% 27.16% - Horiz. % 141.53% 169.01% 151.44% 149.84% 147.28% 127.16% 100.00%
DY 4.42 6.95 4.34 4.17 3.45 3.40 3.40 4.47% YoY % -36.40% 60.14% 4.08% 20.87% 1.47% 0.00% - Horiz. % 130.00% 204.41% 127.65% 122.65% 101.47% 100.00% 100.00%
P/NAPS 14.01 12.50 9.65 10.08 10.79 15.03 17.00 -3.17% YoY % 12.08% 29.53% -4.27% -6.58% -28.21% -11.59% - Horiz. % 82.41% 73.53% 56.76% 59.29% 63.47% 88.41% 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
KLSEreportingDec2006.xls 
