[AXIATA] QoQ TTM Result on 30-Sep-2017 [#3]

Announcement Date
23-Nov-2017
Admission Sponsor
-
Sponsor
-
Financial Year
31-Dec-2017
Quarter
30-Sep-2017 [#3]
Profit Trend
QoQ- -3.04%
YoY- -55.09%
View:
Show?
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 24,078,177 24,269,678 24,402,401 23,930,728 23,185,992 22,437,523 21,565,392 7.64%
PBT -2,043,892 1,585,577 1,936,231 1,252,011 1,141,506 979,811 1,139,578 -
Tax -946,767 -779,484 -773,749 -463,892 -376,709 -461,823 -482,422 56.94%
NP -2,990,659 806,093 1,162,482 788,119 764,797 517,988 657,156 -
-
NP to SH -3,241,456 523,056 909,480 575,259 593,283 375,012 504,252 -
-
Tax Rate - 49.16% 39.96% 37.05% 33.00% 47.13% 42.33% -
Total Cost 27,068,836 23,463,585 23,239,919 23,142,609 22,421,195 21,919,535 20,908,236 18.84%
-
Net Worth 20,180,594 23,344,977 24,641,894 24,648,512 25,789,649 25,229,465 23,256,414 -9.04%
Dividend
30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 31/12/16 CAGR
Div 768,401 768,371 768,371 717,732 717,732 715,125 715,125 4.92%
Div Payout % 0.00% 146.90% 84.48% 124.77% 120.98% 190.69% 141.82% -
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 20,180,594 23,344,977 24,641,894 24,648,512 25,789,649 25,229,465 23,256,414 -9.04%
NOSH 9,049,739 9,048,947 9,047,951 8,834,592 9,049,000 8,852,444 8,842,742 1.55%
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 -12.42% 3.32% 4.76% 3.29% 3.30% 2.31% 3.05% -
ROE -16.06% 2.24% 3.69% 2.33% 2.30% 1.49% 2.17% -
Per Share
30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 31/12/16 CAGR
RPS 266.07 268.22 270.35 270.88 256.23 253.46 243.88 5.99%
EPS -35.82 5.78 10.08 6.51 6.56 4.24 5.70 -
DPS 8.49 8.49 8.51 8.12 7.93 8.00 8.00 4.05%
NAPS 2.23 2.58 2.73 2.79 2.85 2.85 2.63 -10.44%
Adjusted Per Share Value based on latest NOSH - 8,834,592
30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 31/12/16 CAGR
RPS 262.21 264.29 265.74 260.60 252.49 244.34 234.85 7.64%
EPS -35.30 5.70 9.90 6.26 6.46 4.08 5.49 -
DPS 8.37 8.37 8.37 7.82 7.82 7.79 7.79 4.91%
NAPS 2.1977 2.5422 2.6835 2.6842 2.8085 2.7475 2.5326 -9.04%
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 3.80 5.45 5.49 5.24 4.83 5.06 4.72 -
P/RPS 1.43 2.03 2.03 1.93 1.89 2.00 1.94 -18.44%
P/EPS -10.61 94.28 54.49 80.47 73.67 119.45 82.77 -
EY -9.43 1.06 1.84 1.24 1.36 0.84 1.21 -
DY 2.23 1.56 1.55 1.55 1.64 1.58 1.69 20.36%
P/NAPS 1.70 2.11 2.01 1.88 1.69 1.78 1.79 -3.38%
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 24/08/18 22/05/18 22/02/18 23/11/17 30/08/17 25/05/17 23/02/17 -
Price 4.72 5.07 5.67 5.30 4.93 4.98 4.53 -
P/RPS 1.77 1.89 2.10 1.96 1.92 1.96 1.86 -3.26%
P/EPS -13.18 87.71 56.27 81.40 75.19 117.56 79.44 -
EY -7.59 1.14 1.78 1.23 1.33 0.85 1.26 -
DY 1.80 1.67 1.50 1.53 1.61 1.61 1.77 1.12%
P/NAPS 2.12 1.97 2.08 1.90 1.73 1.75 1.72 15.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.

Discussions
Be the first to like this. Showing 0 of 0 comments

Post a Comment