[MBG] QoQ Cumulative Quarter Result on 2013-07-31 [#2] View: Quarter
Cumulative
T4Q
Annualized
Annual (Unaudited)
Show?
Cumulative Quarter Result 30/04/14 31/01/14 31/10/13 31/07/13 30/04/13 31/01/13 31/10/12 CAGR
Revenue 14,387 47,392 35,740 23,436 11,994 50,814 40,452 -49.90% QoQ % -69.64% 32.60% 52.50% 95.40% -76.40% 25.62% - Horiz. % 35.57% 117.16% 88.35% 57.94% 29.65% 125.62% 100.00%
PBT 1,539 5,199 3,745 2,530 925 5,548 5,457 -57.09% QoQ % -70.40% 38.83% 48.02% 173.51% -83.33% 1.67% - Horiz. % 28.20% 95.27% 68.63% 46.36% 16.95% 101.67% 100.00%
Tax -356 -1,042 -1,015 -668 -268 -1,354 -1,000 -49.86% QoQ % 65.83% -2.66% -51.95% -149.25% 80.21% -35.40% - Horiz. % 35.60% 104.20% 101.50% 66.80% 26.80% 135.40% 100.00%
NP 1,183 4,157 2,730 1,862 657 4,194 4,457 -58.80% QoQ % -71.54% 52.27% 46.62% 183.41% -84.33% -5.90% - Horiz. % 26.54% 93.27% 61.25% 41.78% 14.74% 94.10% 100.00%
NP to SH 1,191 4,150 2,736 1,863 658 4,179 4,432 -58.46% QoQ % -71.30% 51.68% 46.86% 183.13% -84.25% -5.71% - Horiz. % 26.87% 93.64% 61.73% 42.04% 14.85% 94.29% 100.00%
Tax Rate 23.13 % 20.04 % 27.10 % 26.40 % 28.97 % 24.41 % 18.33 % 16.82% QoQ % 15.42% -26.05% 2.65% -8.87% 18.68% 33.17% - Horiz. % 126.19% 109.33% 147.85% 144.03% 158.05% 133.17% 100.00%
Total Cost 13,204 43,235 33,010 21,574 11,337 46,620 35,995 -48.85% QoQ % -69.46% 30.98% 53.01% 90.30% -75.68% 29.52% - Horiz. % 36.68% 120.11% 91.71% 59.94% 31.50% 129.52% 100.00%
Net Worth 107,007 106,381 105,184 104,576 105,792 105,109 105,184 1.16% QoQ % 0.59% 1.14% 0.58% -1.15% 0.65% -0.07% - Horiz. % 101.73% 101.14% 100.00% 99.42% 100.58% 99.93% 100.00%
Dividend 30/04/14 31/01/14 31/10/13 31/07/13 30/04/13 31/01/13 31/10/12 CAGR
Div - 3,647 3,648 3,648 - 7,594 7,600 - QoQ % 0.00% -0.02% 0.00% 0.00% 0.00% -0.07% - Horiz. % 0.00% 47.99% 48.00% 48.00% 0.00% 99.93% 100.00%
Div Payout % - % 87.89 % 133.33 % 195.81 % - % 181.73 % 171.48 % - QoQ % 0.00% -34.08% -31.91% 0.00% 0.00% 5.98% - Horiz. % 0.00% 51.25% 77.75% 114.19% 0.00% 105.98% 100.00%
Equity 30/04/14 31/01/14 31/10/13 31/07/13 30/04/13 31/01/13 31/10/12 CAGR
Net Worth 107,007 106,381 105,184 104,576 105,792 105,109 105,184 1.16% QoQ % 0.59% 1.14% 0.58% -1.15% 0.65% -0.07% - Horiz. % 101.73% 101.14% 100.00% 99.42% 100.58% 99.93% 100.00%
NOSH 60,800 60,789 60,800 60,800 60,800 60,756 60,800 - QoQ % 0.02% -0.02% 0.00% 0.00% 0.07% -0.07% - Horiz. % 100.00% 99.98% 100.00% 100.00% 100.00% 99.93% 100.00%
Ratio Analysis 30/04/14 31/01/14 31/10/13 31/07/13 30/04/13 31/01/13 31/10/12 CAGR
NP Margin 8.22 % 8.77 % 7.64 % 7.95 % 5.48 % 8.25 % 11.02 % -17.80% QoQ % -6.27% 14.79% -3.90% 45.07% -33.58% -25.14% - Horiz. % 74.59% 79.58% 69.33% 72.14% 49.73% 74.86% 100.00%
ROE 1.11 % 3.90 % 2.60 % 1.78 % 0.62 % 3.98 % 4.21 % -58.98% QoQ % -71.54% 50.00% 46.07% 187.10% -84.42% -5.46% - Horiz. % 26.37% 92.64% 61.76% 42.28% 14.73% 94.54% 100.00%
Per Share 30/04/14 31/01/14 31/10/13 31/07/13 30/04/13 31/01/13 31/10/12 CAGR
RPS 23.66 77.96 58.78 38.55 19.73 83.63 66.53 -49.90% QoQ % -69.65% 32.63% 52.48% 95.39% -76.41% 25.70% - Horiz. % 35.56% 117.18% 88.35% 57.94% 29.66% 125.70% 100.00%
EPS 1.96 6.83 4.50 3.06 1.08 6.87 7.29 -58.44% QoQ % -71.30% 51.78% 47.06% 183.33% -84.28% -5.76% - Horiz. % 26.89% 93.69% 61.73% 41.98% 14.81% 94.24% 100.00%
DPS 0.00 6.00 6.00 6.00 0.00 12.50 12.50 - QoQ % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% - Horiz. % 0.00% 48.00% 48.00% 48.00% 0.00% 100.00% 100.00%
NAPS 1.7600 1.7500 1.7300 1.7200 1.7400 1.7300 1.7300 1.16% QoQ % 0.57% 1.16% 0.58% -1.15% 0.58% 0.00% - Horiz. % 101.73% 101.16% 100.00% 99.42% 100.58% 100.00% 100.00%
Adjusted Per Share Value based on latest NOSH - 60,800 30/04/14 31/01/14 31/10/13 31/07/13 30/04/13 31/01/13 31/10/12 CAGR
RPS 23.66 77.95 58.78 38.55 19.73 83.58 66.53 -49.90% QoQ % -69.65% 32.61% 52.48% 95.39% -76.39% 25.63% - Horiz. % 35.56% 117.17% 88.35% 57.94% 29.66% 125.63% 100.00%
EPS 1.96 6.83 4.50 3.06 1.08 6.87 7.29 -58.44% QoQ % -71.30% 51.78% 47.06% 183.33% -84.28% -5.76% - Horiz. % 26.89% 93.69% 61.73% 41.98% 14.81% 94.24% 100.00%
DPS 0.00 6.00 6.00 6.00 0.00 12.49 12.50 - QoQ % 0.00% 0.00% 0.00% 0.00% 0.00% -0.08% - Horiz. % 0.00% 48.00% 48.00% 48.00% 0.00% 99.92% 100.00%
NAPS 1.7600 1.7497 1.7300 1.7200 1.7400 1.7288 1.7300 1.16% QoQ % 0.59% 1.14% 0.58% -1.15% 0.65% -0.07% - Horiz. % 101.73% 101.14% 100.00% 99.42% 100.58% 99.93% 100.00%
Price Multiplier on Financial Quarter End Date 30/04/14 31/01/14 31/10/13 31/07/13 30/04/13 31/01/13 31/10/12 CAGR
Date 30/04/14 30/01/14 31/10/13 31/07/13 30/04/13 31/01/13 31/10/12 -
Price 1.3000 1.4000 1.3300 1.4000 1.3900 1.4600 1.4500 -
P/RPS 5.49 1.80 2.26 3.63 7.05 1.75 2.18 85.42% QoQ % 205.00% -20.35% -37.74% -48.51% 302.86% -19.72% - Horiz. % 251.83% 82.57% 103.67% 166.51% 323.39% 80.28% 100.00%
P/EPS 66.36 20.51 29.56 45.69 128.44 21.23 19.89 123.77% QoQ % 223.55% -30.62% -35.30% -64.43% 504.99% 6.74% - Horiz. % 333.64% 103.12% 148.62% 229.71% 645.75% 106.74% 100.00%
EY 1.51 4.88 3.38 2.19 0.78 4.71 5.03 -55.26% QoQ % -69.06% 44.38% 54.34% 180.77% -83.44% -6.36% - Horiz. % 30.02% 97.02% 67.20% 43.54% 15.51% 93.64% 100.00%
DY 0.00 4.29 4.51 4.29 0.00 8.56 8.62 - QoQ % 0.00% -4.88% 5.13% 0.00% 0.00% -0.70% - Horiz. % 0.00% 49.77% 52.32% 49.77% 0.00% 99.30% 100.00%
P/NAPS 0.74 0.80 0.77 0.81 0.80 0.84 0.84 -8.12% QoQ % -7.50% 3.90% -4.94% 1.25% -4.76% 0.00% - Horiz. % 88.10% 95.24% 91.67% 96.43% 95.24% 100.00% 100.00%
Price Multiplier on Announcement Date 30/04/14 31/01/14 31/10/13 31/07/13 30/04/13 31/01/13 31/10/12 CAGR
Date 27/06/14 28/03/14 20/12/13 27/09/13 28/06/13 28/03/13 21/12/12 -
Price 1.3000 1.3500 1.3800 1.4200 1.4200 1.4800 1.4000 -
P/RPS 5.49 1.73 2.35 3.68 7.20 1.77 2.10 90.11% QoQ % 217.34% -26.38% -36.14% -48.89% 306.78% -15.71% - Horiz. % 261.43% 82.38% 111.90% 175.24% 342.86% 84.29% 100.00%
P/EPS 66.36 19.77 30.67 46.34 131.21 21.52 19.21 129.04% QoQ % 235.66% -35.54% -33.82% -64.68% 509.71% 12.02% - Horiz. % 345.45% 102.92% 159.66% 241.23% 683.03% 112.03% 100.00%
EY 1.51 5.06 3.26 2.16 0.76 4.65 5.21 -56.30% QoQ % -70.16% 55.21% 50.93% 184.21% -83.66% -10.75% - Horiz. % 28.98% 97.12% 62.57% 41.46% 14.59% 89.25% 100.00%
DY 0.00 4.44 4.35 4.23 0.00 8.45 8.93 - QoQ % 0.00% 2.07% 2.84% 0.00% 0.00% -5.38% - Horiz. % 0.00% 49.72% 48.71% 47.37% 0.00% 94.62% 100.00%
P/NAPS 0.74 0.77 0.80 0.83 0.82 0.86 0.81 -5.86% QoQ % -3.90% -3.75% -3.61% 1.22% -4.65% 6.17% - Horiz. % 91.36% 95.06% 98.77% 102.47% 101.23% 106.17% 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
Copy of MIB (report) 2ND Quarter 2014 (final).xls 
