[OFI] QoQ TTM Result on 2017-09-30 [#2] View: Quarter
Cumulative
T4Q
Annualized
Annual (Unaudited)
Show? QoQ % Horiz. %
TTM Result 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 31/12/16 CAGR
Revenue 288,422 288,310 279,985 272,724 259,465 256,083 254,598 8.70% QoQ % 0.04% 2.97% 2.66% 5.11% 1.32% 0.58% - Horiz. % 113.29% 113.24% 109.97% 107.12% 101.91% 100.58% 100.00%
PBT 8,413 8,254 14,233 20,426 22,126 23,062 23,228 -49.28% QoQ % 1.93% -42.01% -30.32% -7.68% -4.06% -0.71% - Horiz. % 36.22% 35.53% 61.28% 87.94% 95.26% 99.29% 100.00%
Tax 2,658 2,943 -3 -4,083 -4,740 -4,829 -5,066 - QoQ % -9.68% 98,200.00% 99.93% 13.86% 1.84% 4.68% - Horiz. % -52.47% -58.09% 0.06% 80.60% 93.56% 95.32% 100.00%
NP 11,071 11,197 14,230 16,343 17,386 18,233 18,162 -28.17% QoQ % -1.13% -21.31% -12.93% -6.00% -4.65% 0.39% - Horiz. % 60.96% 61.65% 78.35% 89.98% 95.73% 100.39% 100.00%
NP to SH 11,071 11,202 14,242 16,356 17,402 18,245 18,156 -28.16% QoQ % -1.17% -21.35% -12.92% -6.01% -4.62% 0.49% - Horiz. % 60.98% 61.70% 78.44% 90.09% 95.85% 100.49% 100.00%
Tax Rate -31.59 % -35.66 % 0.02 % 19.99 % 21.42 % 20.94 % 21.81 % - QoQ % 11.41% -178,400.00% -99.90% -6.68% 2.29% -3.99% - Horiz. % -144.84% -163.50% 0.09% 91.66% 98.21% 96.01% 100.00%
Total Cost 277,351 277,113 265,755 256,381 242,079 237,850 236,436 11.26% QoQ % 0.09% 4.27% 3.66% 5.91% 1.78% 0.60% - Horiz. % 117.30% 117.20% 112.40% 108.44% 102.39% 100.60% 100.00%
Net Worth 187,199 184,799 184,799 184,799 182,399 182,399 180,000 2.66% QoQ % 1.30% 0.00% 0.00% 1.32% 0.00% 1.33% - Horiz. % 104.00% 102.67% 102.67% 102.67% 101.33% 101.33% 100.00%
Dividend 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 31/12/16 CAGR
Div 4,800 6,000 8,400 9,600 9,600 9,600 9,600 -37.08% QoQ % -20.00% -28.57% -12.50% 0.00% 0.00% 0.00% - Horiz. % 50.00% 62.50% 87.50% 100.00% 100.00% 100.00% 100.00%
Div Payout % 43.36 % 53.56 % 58.98 % 58.69 % 55.17 % 52.62 % 52.88 % -12.43% QoQ % -19.04% -9.19% 0.49% 6.38% 4.85% -0.49% - Horiz. % 82.00% 101.29% 111.54% 110.99% 104.33% 99.51% 100.00%
Equity 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 31/12/16 CAGR
Net Worth 187,199 184,799 184,799 184,799 182,399 182,399 180,000 2.66% QoQ % 1.30% 0.00% 0.00% 1.32% 0.00% 1.33% - Horiz. % 104.00% 102.67% 102.67% 102.67% 101.33% 101.33% 100.00%
NOSH 240,000 240,000 240,000 240,000 240,000 240,000 240,000 - 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/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 31/12/16 CAGR
NP Margin 3.84 % 3.88 % 5.08 % 5.99 % 6.70 % 7.12 % 7.13 % -33.88% QoQ % -1.03% -23.62% -15.19% -10.60% -5.90% -0.14% - Horiz. % 53.86% 54.42% 71.25% 84.01% 93.97% 99.86% 100.00%
ROE 5.91 % 6.06 % 7.71 % 8.85 % 9.54 % 10.00 % 10.09 % -30.06% QoQ % -2.48% -21.40% -12.88% -7.23% -4.60% -0.89% - Horiz. % 58.57% 60.06% 76.41% 87.71% 94.55% 99.11% 100.00%
Per Share 31/03/08 31/12/07 30/09/07 30/06/07 30/06/07 31/03/06 31/09/06 CAGR
RPS 120.18 120.13 116.66 113.64 108.11 106.70 106.08 8.70% QoQ % 0.04% 2.97% 2.66% 5.12% 1.32% 0.58% - Horiz. % 113.29% 113.24% 109.97% 107.13% 101.91% 100.58% 100.00%
EPS 4.61 4.67 5.93 6.82 7.25 7.60 7.57 -28.22% QoQ % -1.28% -21.25% -13.05% -5.93% -4.61% 0.40% - Horiz. % 60.90% 61.69% 78.34% 90.09% 95.77% 100.40% 100.00%
DPS 2.00 2.50 3.50 4.00 4.00 4.00 4.00 -37.08% QoQ % -20.00% -28.57% -12.50% 0.00% 0.00% 0.00% - Horiz. % 50.00% 62.50% 87.50% 100.00% 100.00% 100.00% 100.00%
NAPS 0.7800 0.7700 0.7700 0.7700 0.7600 0.7600 0.7500 2.66% QoQ % 1.30% 0.00% 0.00% 1.32% 0.00% 1.33% - Horiz. % 104.00% 102.67% 102.67% 102.67% 101.33% 101.33% 100.00%
Adjusted Per Share Value based on latest NOSH - 240,000 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 31/12/16 CAGR
RPS 120.18 120.13 116.66 113.64 108.11 106.70 106.08 8.70% QoQ % 0.04% 2.97% 2.66% 5.12% 1.32% 0.58% - Horiz. % 113.29% 113.24% 109.97% 107.13% 101.91% 100.58% 100.00%
EPS 4.61 4.67 5.93 6.82 7.25 7.60 7.57 -28.22% QoQ % -1.28% -21.25% -13.05% -5.93% -4.61% 0.40% - Horiz. % 60.90% 61.69% 78.34% 90.09% 95.77% 100.40% 100.00%
DPS 2.00 2.50 3.50 4.00 4.00 4.00 4.00 -37.08% QoQ % -20.00% -28.57% -12.50% 0.00% 0.00% 0.00% - Horiz. % 50.00% 62.50% 87.50% 100.00% 100.00% 100.00% 100.00%
NAPS 0.7800 0.7700 0.7700 0.7700 0.7600 0.7600 0.7500 2.66% QoQ % 1.30% 0.00% 0.00% 1.32% 0.00% 1.33% - Horiz. % 104.00% 102.67% 102.67% 102.67% 101.33% 101.33% 100.00%
Price Multiplier on Financial Quarter End Date 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 31/12/16 CAGR
Date 29/06/18 30/03/18 29/12/17 29/09/17 30/06/17 31/03/17 30/12/16 -
Price 0.9550 0.9550 1.3700 1.5700 1.6100 1.5600 1.3700 -
P/RPS 0.79 0.79 1.17 1.38 1.49 1.46 1.29 -27.95% QoQ % 0.00% -32.48% -15.22% -7.38% 2.05% 13.18% - Horiz. % 61.24% 61.24% 90.70% 106.98% 115.50% 113.18% 100.00%
P/EPS 20.70 20.46 23.09 23.04 22.20 20.52 18.11 9.35% QoQ % 1.17% -11.39% 0.22% 3.78% 8.19% 13.31% - Horiz. % 114.30% 112.98% 127.50% 127.22% 122.58% 113.31% 100.00%
EY 4.83 4.89 4.33 4.34 4.50 4.87 5.52 -8.54% QoQ % -1.23% 12.93% -0.23% -3.56% -7.60% -11.78% - Horiz. % 87.50% 88.59% 78.44% 78.62% 81.52% 88.22% 100.00%
DY 2.09 2.62 2.55 2.55 2.48 2.56 2.92 -20.03% QoQ % -20.23% 2.75% 0.00% 2.82% -3.12% -12.33% - Horiz. % 71.58% 89.73% 87.33% 87.33% 84.93% 87.67% 100.00%
P/NAPS 1.22 1.24 1.78 2.04 2.12 2.05 1.83 -23.74% QoQ % -1.61% -30.34% -12.75% -3.77% 3.41% 12.02% - Horiz. % 66.67% 67.76% 97.27% 111.48% 115.85% 112.02% 100.00%
Price Multiplier on Announcement Date 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 31/12/16 CAGR
Date 29/08/18 30/05/18 27/02/18 22/11/17 24/08/17 29/05/17 21/02/17 -
Price 0.8500 0.9300 1.0700 1.4600 1.6100 1.6500 1.5100 -
P/RPS 0.71 0.77 0.92 1.28 1.49 1.55 1.42 -37.08% QoQ % -7.79% -16.30% -28.12% -14.09% -3.87% 9.15% - Horiz. % 50.00% 54.23% 64.79% 90.14% 104.93% 109.15% 100.00%
P/EPS 18.43 19.93 18.03 21.42 22.20 21.70 19.96 -5.19% QoQ % -7.53% 10.54% -15.83% -3.51% 2.30% 8.72% - Horiz. % 92.33% 99.85% 90.33% 107.31% 111.22% 108.72% 100.00%
EY 5.43 5.02 5.55 4.67 4.50 4.61 5.01 5.53% QoQ % 8.17% -9.55% 18.84% 3.78% -2.39% -7.98% - Horiz. % 108.38% 100.20% 110.78% 93.21% 89.82% 92.02% 100.00%
DY 2.35 2.69 3.27 2.74 2.48 2.42 2.65 -7.72% QoQ % -12.64% -17.74% 19.34% 10.48% 2.48% -8.68% - Horiz. % 88.68% 101.51% 123.40% 103.40% 93.58% 91.32% 100.00%
P/NAPS 1.09 1.21 1.39 1.90 2.12 2.17 2.01 -33.57% QoQ % -9.92% -12.95% -26.84% -10.38% -2.30% 7.96% - Horiz. % 54.23% 60.20% 69.15% 94.53% 105.47% 107.96% 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