[LPI] QoQ TTM Result on 2019-09-30 [#3] View: Quarter
Cumulative
T4Q
Annualized
Annual (Unaudited)
Show? QoQ % Horiz. %
TTM Result 30/06/20 31/03/20 31/12/19 30/09/19 30/06/19 31/03/19 31/12/18 CAGR
Revenue 1,626,550 1,613,907 1,602,701 1,592,470 1,559,221 1,525,367 1,513,663 4.92% QoQ % 0.78% 0.70% 0.64% 2.13% 2.22% 0.77% - Horiz. % 107.46% 106.62% 105.88% 105.21% 103.01% 100.77% 100.00%
PBT 424,863 417,191 414,719 410,303 415,579 409,831 405,965 3.08% QoQ % 1.84% 0.60% 1.08% -1.27% 1.40% 0.95% - Horiz. % 104.66% 102.77% 102.16% 101.07% 102.37% 100.95% 100.00%
Tax -95,124 -94,071 -92,358 -90,542 -91,828 -91,124 -91,916 2.32% QoQ % -1.12% -1.85% -2.01% 1.40% -0.77% 0.86% - Horiz. % 103.49% 102.34% 100.48% 98.51% 99.90% 99.14% 100.00%
NP 329,739 323,120 322,361 319,761 323,751 318,707 314,049 3.31% QoQ % 2.05% 0.24% 0.81% -1.23% 1.58% 1.48% - Horiz. % 105.00% 102.89% 102.65% 101.82% 103.09% 101.48% 100.00%
NP to SH 329,739 323,120 322,361 319,761 323,751 318,707 314,049 3.31% QoQ % 2.05% 0.24% 0.81% -1.23% 1.58% 1.48% - Horiz. % 105.00% 102.89% 102.65% 101.82% 103.09% 101.48% 100.00%
Tax Rate 22.39 % 22.55 % 22.27 % 22.07 % 22.10 % 22.23 % 22.64 % -0.74% QoQ % -0.71% 1.26% 0.91% -0.14% -0.58% -1.81% - Horiz. % 98.90% 99.60% 98.37% 97.48% 97.61% 98.19% 100.00%
Total Cost 1,296,811 1,290,787 1,280,340 1,272,709 1,235,470 1,206,660 1,199,614 5.34% QoQ % 0.47% 0.82% 0.60% 3.01% 2.39% 0.59% - Horiz. % 108.10% 107.60% 106.73% 106.09% 102.99% 100.59% 100.00%
Net Worth 1,818,897 1,714,999 1,961,398 1,912,756 2,060,436 1,994,703 2,156,765 -10.75% QoQ % 6.06% -12.56% 2.54% -7.17% 3.30% -7.51% - Horiz. % 84.33% 79.52% 90.94% 88.69% 95.53% 92.49% 100.00%
Dividend 30/06/20 31/03/20 31/12/19 30/09/19 30/06/19 31/03/19 31/12/18 CAGR
Div 282,851 278,868 278,868 274,884 274,884 270,900 270,900 2.92% QoQ % 1.43% 0.00% 1.45% 0.00% 1.47% 0.00% - Horiz. % 104.41% 102.94% 102.94% 101.47% 101.47% 100.00% 100.00%
Div Payout % 85.78 % 86.30 % 86.51 % 85.97 % 84.91 % 85.00 % 86.26 % -0.37% QoQ % -0.60% -0.24% 0.63% 1.25% -0.11% -1.46% - Horiz. % 99.44% 100.05% 100.29% 99.66% 98.43% 98.54% 100.00%
Equity 30/06/20 31/03/20 31/12/19 30/09/19 30/06/19 31/03/19 31/12/18 CAGR
Net Worth 1,818,897 1,714,999 1,961,398 1,912,756 2,060,436 1,994,703 2,156,765 -10.75% QoQ % 6.06% -12.56% 2.54% -7.17% 3.30% -7.51% - Horiz. % 84.33% 79.52% 90.94% 88.69% 95.53% 92.49% 100.00%
NOSH 398,383 398,383 398,383 398,383 398,383 398,383 398,383 - 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/20 31/03/20 31/12/19 30/09/19 30/06/19 31/03/19 31/12/18 CAGR
NP Margin 20.27 % 20.02 % 20.11 % 20.08 % 20.76 % 20.89 % 20.75 % -1.55% QoQ % 1.25% -0.45% 0.15% -3.28% -0.62% 0.67% - Horiz. % 97.69% 96.48% 96.92% 96.77% 100.05% 100.67% 100.00%
ROE 18.13 % 18.84 % 16.44 % 16.72 % 15.71 % 15.98 % 14.56 % 15.76% QoQ % -3.77% 14.60% -1.67% 6.43% -1.69% 9.75% - Horiz. % 124.52% 129.40% 112.91% 114.84% 107.90% 109.75% 100.00%
Per Share 30/06/20 31/03/20 31/12/19 30/09/19 30/06/19 31/03/19 31/12/18 CAGR
RPS 408.29 405.11 402.30 399.73 391.39 382.89 379.95 4.92% QoQ % 0.78% 0.70% 0.64% 2.13% 2.22% 0.77% - Horiz. % 107.46% 106.62% 105.88% 105.21% 103.01% 100.77% 100.00%
EPS 82.77 81.11 80.92 80.26 81.27 80.00 78.83 3.31% QoQ % 2.05% 0.23% 0.82% -1.24% 1.59% 1.48% - Horiz. % 105.00% 102.89% 102.65% 101.81% 103.10% 101.48% 100.00%
DPS 71.00 70.00 70.00 69.00 69.00 68.00 68.00 2.92% QoQ % 1.43% 0.00% 1.45% 0.00% 1.47% 0.00% - Horiz. % 104.41% 102.94% 102.94% 101.47% 101.47% 100.00% 100.00%
NAPS 4.5657 4.3049 4.9234 4.8013 5.1720 5.0070 5.4138 -10.75% QoQ % 6.06% -12.56% 2.54% -7.17% 3.30% -7.51% - Horiz. % 84.33% 79.52% 90.94% 88.69% 95.53% 92.49% 100.00%
Adjusted Per Share Value based on latest NOSH - 398,383 30/06/20 31/03/20 31/12/19 30/09/19 30/06/19 31/03/19 31/12/18 CAGR
RPS 408.29 405.11 402.30 399.73 391.39 382.89 379.95 4.92% QoQ % 0.78% 0.70% 0.64% 2.13% 2.22% 0.77% - Horiz. % 107.46% 106.62% 105.88% 105.21% 103.01% 100.77% 100.00%
EPS 82.77 81.11 80.92 80.26 81.27 80.00 78.83 3.31% QoQ % 2.05% 0.23% 0.82% -1.24% 1.59% 1.48% - Horiz. % 105.00% 102.89% 102.65% 101.81% 103.10% 101.48% 100.00%
DPS 71.00 70.00 70.00 69.00 69.00 68.00 68.00 2.92% QoQ % 1.43% 0.00% 1.45% 0.00% 1.47% 0.00% - Horiz. % 104.41% 102.94% 102.94% 101.47% 101.47% 100.00% 100.00%
NAPS 4.5657 4.3049 4.9234 4.8013 5.1720 5.0070 5.4138 -10.75% QoQ % 6.06% -12.56% 2.54% -7.17% 3.30% -7.51% - Horiz. % 84.33% 79.52% 90.94% 88.69% 95.53% 92.49% 100.00%
Price Multiplier on Financial Quarter End Date 30/06/20 31/03/20 31/12/19 30/09/19 30/06/19 31/03/19 31/12/18 CAGR
Date 30/06/20 31/03/20 31/12/19 30/09/19 28/06/19 29/03/19 31/12/18 -
Price 13.4000 11.6000 15.1000 15.6400 15.7600 15.9200 15.7400 -
P/RPS 3.28 2.86 3.75 3.91 4.03 4.16 4.14 -14.39% QoQ % 14.69% -23.73% -4.09% -2.98% -3.12% 0.48% - Horiz. % 79.23% 69.08% 90.58% 94.44% 97.34% 100.48% 100.00%
P/EPS 16.19 14.30 18.66 19.49 19.39 19.90 19.97 -13.07% QoQ % 13.22% -23.37% -4.26% 0.52% -2.56% -0.35% - Horiz. % 81.07% 71.61% 93.44% 97.60% 97.10% 99.65% 100.00%
EY 6.18 6.99 5.36 5.13 5.16 5.03 5.01 15.03% QoQ % -11.59% 30.41% 4.48% -0.58% 2.58% 0.40% - Horiz. % 123.35% 139.52% 106.99% 102.40% 102.99% 100.40% 100.00%
DY 5.30 6.03 4.64 4.41 4.38 4.27 4.32 14.62% QoQ % -12.11% 29.96% 5.22% 0.68% 2.58% -1.16% - Horiz. % 122.69% 139.58% 107.41% 102.08% 101.39% 98.84% 100.00%
P/NAPS 2.93 2.69 3.07 3.26 3.05 3.18 2.91 0.46% QoQ % 8.92% -12.38% -5.83% 6.89% -4.09% 9.28% - Horiz. % 100.69% 92.44% 105.50% 112.03% 104.81% 109.28% 100.00%
Price Multiplier on Announcement Date 30/06/20 31/03/20 31/12/19 30/09/19 30/06/19 31/03/19 31/12/18 CAGR
Date 17/08/20 04/05/20 03/02/20 15/10/19 15/07/19 15/04/19 29/01/19 -
Price 13.2000 12.9800 14.8000 15.4800 16.0600 15.6800 16.3800 -
P/RPS 3.23 3.20 3.68 3.87 4.10 4.10 4.31 -17.51% QoQ % 0.94% -13.04% -4.91% -5.61% 0.00% -4.87% - Horiz. % 74.94% 74.25% 85.38% 89.79% 95.13% 95.13% 100.00%
P/EPS 15.95 16.00 18.29 19.29 19.76 19.60 20.78 -16.18% QoQ % -0.31% -12.52% -5.18% -2.38% 0.82% -5.68% - Horiz. % 76.76% 77.00% 88.02% 92.83% 95.09% 94.32% 100.00%
EY 6.27 6.25 5.47 5.19 5.06 5.10 4.81 19.35% QoQ % 0.32% 14.26% 5.39% 2.57% -0.78% 6.03% - Horiz. % 130.35% 129.94% 113.72% 107.90% 105.20% 106.03% 100.00%
DY 5.38 5.39 4.73 4.46 4.30 4.34 4.15 18.91% QoQ % -0.19% 13.95% 6.05% 3.72% -0.92% 4.58% - Horiz. % 129.64% 129.88% 113.98% 107.47% 103.61% 104.58% 100.00%
P/NAPS 2.89 3.02 3.01 3.22 3.11 3.13 3.03 -3.11% QoQ % -4.30% 0.33% -6.52% 3.54% -0.64% 3.30% - Horiz. % 95.38% 99.67% 99.34% 106.27% 102.64% 103.30% 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