[LPI] QoQ TTM Result on 2017-12-31 [#4] View: Quarter
Cumulative
T4Q
Annualized
Annual (Unaudited)
Show? QoQ % Horiz. %
TTM Result 30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 CAGR
Revenue 1,488,131 1,504,327 1,503,989 1,470,631 1,462,690 1,419,431 1,405,971 3.86% QoQ % -1.08% 0.02% 2.27% 0.54% 3.05% 0.96% - Horiz. % 105.84% 107.00% 106.97% 104.60% 104.03% 100.96% 100.00%
PBT 405,795 404,194 406,533 403,749 399,910 382,280 525,538 -15.82% QoQ % 0.40% -0.58% 0.69% 0.96% 4.61% -27.26% - Horiz. % 77.22% 76.91% 77.36% 76.83% 76.10% 72.74% 100.00%
Tax -92,752 -90,789 -90,802 -89,955 -87,663 -84,435 -83,138 7.56% QoQ % -2.16% 0.01% -0.94% -2.61% -3.82% -1.56% - Horiz. % 111.56% 109.20% 109.22% 108.20% 105.44% 101.56% 100.00%
NP 313,043 313,405 315,731 313,794 312,247 297,845 442,400 -20.58% QoQ % -0.12% -0.74% 0.62% 0.50% 4.84% -32.68% - Horiz. % 70.76% 70.84% 71.37% 70.93% 70.58% 67.32% 100.00%
NP to SH 313,043 313,405 315,731 313,794 312,247 297,845 442,400 -20.58% QoQ % -0.12% -0.74% 0.62% 0.50% 4.84% -32.68% - Horiz. % 70.76% 70.84% 71.37% 70.93% 70.58% 67.32% 100.00%
Tax Rate 22.86 % 22.46 % 22.34 % 22.28 % 21.92 % 22.09 % 15.82 % 27.79% QoQ % 1.78% 0.54% 0.27% 1.64% -0.77% 39.63% - Horiz. % 144.50% 141.97% 141.21% 140.83% 138.56% 139.63% 100.00%
Total Cost 1,175,088 1,190,922 1,188,258 1,156,837 1,150,443 1,121,586 963,571 14.13% QoQ % -1.33% 0.22% 2.72% 0.56% 2.57% 16.40% - Horiz. % 121.95% 123.59% 123.32% 120.06% 119.39% 116.40% 100.00%
Net Worth 2,086,451 2,022,670 1,985,342 1,920,904 1,825,823 1,817,922 1,735,855 13.04% QoQ % 3.15% 1.88% 3.35% 5.21% 0.43% 4.73% - Horiz. % 120.20% 116.52% 114.37% 110.66% 105.18% 104.73% 100.00%
Dividend 30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 CAGR
Div 252,973 252,973 239,029 239,029 272,228 272,228 265,588 -3.19% QoQ % 0.00% 5.83% 0.00% -12.20% 0.00% 2.50% - Horiz. % 95.25% 95.25% 90.00% 90.00% 102.50% 102.50% 100.00%
Div Payout % 80.81 % 80.72 % 75.71 % 76.17 % 87.18 % 91.40 % 60.03 % 21.90% QoQ % 0.11% 6.62% -0.60% -12.63% -4.62% 52.26% - Horiz. % 134.62% 134.47% 126.12% 126.89% 145.23% 152.26% 100.00%
Equity 30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 CAGR
Net Worth 2,086,451 2,022,670 1,985,342 1,920,904 1,825,823 1,817,922 1,735,855 13.04% QoQ % 3.15% 1.88% 3.35% 5.21% 0.43% 4.73% - Horiz. % 120.20% 116.52% 114.37% 110.66% 105.18% 104.73% 100.00%
NOSH 398,383 398,383 331,986 331,986 331,986 331,986 331,986 12.91% QoQ % 0.00% 20.00% 0.00% 0.00% 0.00% 0.00% - Horiz. % 120.00% 120.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Ratio Analysis 30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 CAGR
NP Margin 21.04 % 20.83 % 20.99 % 21.34 % 21.35 % 20.98 % 31.47 % -23.52% QoQ % 1.01% -0.76% -1.64% -0.05% 1.76% -33.33% - Horiz. % 66.86% 66.19% 66.70% 67.81% 67.84% 66.67% 100.00%
ROE 15.00 % 15.49 % 15.90 % 16.34 % 17.10 % 16.38 % 25.49 % -29.75% QoQ % -3.16% -2.58% -2.69% -4.44% 4.40% -35.74% - Horiz. % 58.85% 60.77% 62.38% 64.10% 67.09% 64.26% 100.00%
Per Share 30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 CAGR
RPS 373.54 377.61 453.03 442.98 440.59 427.56 423.50 -8.02% QoQ % -1.08% -16.65% 2.27% 0.54% 3.05% 0.96% - Horiz. % 88.20% 89.16% 106.97% 104.60% 104.04% 100.96% 100.00%
EPS 78.58 78.67 95.10 94.52 94.05 89.72 133.26 -29.66% QoQ % -0.11% -17.28% 0.61% 0.50% 4.83% -32.67% - Horiz. % 58.97% 59.03% 71.36% 70.93% 70.58% 67.33% 100.00%
DPS 63.50 63.50 72.00 72.00 82.00 82.00 80.00 -14.26% QoQ % 0.00% -11.81% 0.00% -12.20% 0.00% 2.50% - Horiz. % 79.38% 79.38% 90.00% 90.00% 102.50% 102.50% 100.00%
NAPS 5.2373 5.0772 5.9802 5.7861 5.4997 5.4759 5.2287 0.11% QoQ % 3.15% -15.10% 3.35% 5.21% 0.43% 4.73% - Horiz. % 100.16% 97.10% 114.37% 110.66% 105.18% 104.73% 100.00%
Adjusted Per Share Value based on latest NOSH - 398,383 30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 CAGR
RPS 373.54 377.61 377.52 369.15 367.16 356.30 352.92 3.85% QoQ % -1.08% 0.02% 2.27% 0.54% 3.05% 0.96% - Horiz. % 105.84% 107.00% 106.97% 104.60% 104.03% 100.96% 100.00%
EPS 78.58 78.67 79.25 78.77 78.38 74.76 111.05 -20.58% QoQ % -0.11% -0.73% 0.61% 0.50% 4.84% -32.68% - Horiz. % 70.76% 70.84% 71.36% 70.93% 70.58% 67.32% 100.00%
DPS 63.50 63.50 60.00 60.00 68.33 68.33 66.67 -3.19% QoQ % 0.00% 5.83% 0.00% -12.19% 0.00% 2.49% - Horiz. % 95.25% 95.25% 90.00% 90.00% 102.49% 102.49% 100.00%
NAPS 5.2373 5.0772 4.9835 4.8218 4.5831 4.5633 4.3573 13.03% QoQ % 3.15% 1.88% 3.35% 5.21% 0.43% 4.73% - Horiz. % 120.20% 116.52% 114.37% 110.66% 105.18% 104.73% 100.00%
Price Multiplier on Financial Quarter End Date 30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 CAGR
Date 28/09/18 29/06/18 30/03/18 29/12/17 29/09/17 30/06/17 31/03/17 -
Price 17.0000 17.0800 19.8200 18.1600 17.5400 18.8800 17.0000 -
P/RPS 4.55 4.52 4.38 4.10 3.98 4.42 4.01 8.78% QoQ % 0.66% 3.20% 6.83% 3.02% -9.95% 10.22% - Horiz. % 113.47% 112.72% 109.23% 102.24% 99.25% 110.22% 100.00%
P/EPS 21.63 21.71 20.84 19.21 18.65 21.04 12.76 42.12% QoQ % -0.37% 4.17% 8.49% 3.00% -11.36% 64.89% - Horiz. % 169.51% 170.14% 163.32% 150.55% 146.16% 164.89% 100.00%
EY 4.62 4.61 4.80 5.20 5.36 4.75 7.84 -29.69% QoQ % 0.22% -3.96% -7.69% -2.99% 12.84% -39.41% - Horiz. % 58.93% 58.80% 61.22% 66.33% 68.37% 60.59% 100.00%
DY 3.74 3.72 3.63 3.96 4.68 4.34 4.71 -14.24% QoQ % 0.54% 2.48% -8.33% -15.38% 7.83% -7.86% - Horiz. % 79.41% 78.98% 77.07% 84.08% 99.36% 92.14% 100.00%
P/NAPS 3.25 3.36 3.31 3.14 3.19 3.45 3.25 - QoQ % -3.27% 1.51% 5.41% -1.57% -7.54% 6.15% - Horiz. % 100.00% 103.38% 101.85% 96.62% 98.15% 106.15% 100.00%
Price Multiplier on Announcement Date 30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 CAGR
Date 10/10/18 09/07/18 26/04/18 10/01/18 09/10/17 10/07/17 10/04/17 -
Price 16.8000 17.0000 16.1400 19.4200 18.0600 18.6000 17.1800 -
P/RPS 4.50 4.50 3.56 4.38 4.10 4.35 4.06 7.09% QoQ % 0.00% 26.40% -18.72% 6.83% -5.75% 7.14% - Horiz. % 110.84% 110.84% 87.68% 107.88% 100.99% 107.14% 100.00%
P/EPS 21.38 21.61 16.97 20.55 19.20 20.73 12.89 40.08% QoQ % -1.06% 27.34% -17.42% 7.03% -7.38% 60.82% - Horiz. % 165.87% 167.65% 131.65% 159.43% 148.95% 160.82% 100.00%
EY 4.68 4.63 5.89 4.87 5.21 4.82 7.76 -28.60% QoQ % 1.08% -21.39% 20.94% -6.53% 8.09% -37.89% - Horiz. % 60.31% 59.66% 75.90% 62.76% 67.14% 62.11% 100.00%
DY 3.78 3.74 4.46 3.71 4.54 4.41 4.66 -13.01% QoQ % 1.07% -16.14% 20.22% -18.28% 2.95% -5.36% - Horiz. % 81.12% 80.26% 95.71% 79.61% 97.42% 94.64% 100.00%
P/NAPS 3.21 3.35 2.70 3.36 3.28 3.40 3.29 -1.63% QoQ % -4.18% 24.07% -19.64% 2.44% -3.53% 3.34% - Horiz. % 97.57% 101.82% 82.07% 102.13% 99.70% 103.34% 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