[INSAS] YoY Quarter Result on 2017-06-30 [#4] View: Quarter
Cumulative
T4Q
Annualized
Annual (Unaudited)
Show?
Quarter Result 30/06/20 30/06/19 30/06/18 30/06/17 30/06/16 30/06/15 30/06/14 CAGR
Revenue 49,583 78,221 78,108 111,552 68,500 87,333 57,391 -2.41% YoY % -36.61% 0.14% -29.98% 62.85% -21.56% 52.17% - Horiz. % 86.40% 136.29% 136.10% 194.37% 119.36% 152.17% 100.00%
PBT 20,065 23,269 9,215 36,962 39,877 33,212 34,839 -8.78% YoY % -13.77% 152.51% -75.07% -7.31% 20.07% -4.67% - Horiz. % 57.59% 66.79% 26.45% 106.09% 114.46% 95.33% 100.00%
Tax -2,881 -5,303 -2,215 -2,105 -3,715 -590 -5,675 -10.67% YoY % 45.67% -139.41% -5.23% 43.34% -529.66% 89.60% - Horiz. % 50.77% 93.44% 39.03% 37.09% 65.46% 10.40% 100.00%
NP 17,184 17,966 7,000 34,857 36,162 32,622 29,164 -8.43% YoY % -4.35% 156.66% -79.92% -3.61% 10.85% 11.86% - Horiz. % 58.92% 61.60% 24.00% 119.52% 124.00% 111.86% 100.00%
NP to SH 17,269 17,948 6,938 34,791 36,488 32,442 29,395 -8.48% YoY % -3.78% 158.69% -80.06% -4.65% 12.47% 10.37% - Horiz. % 58.75% 61.06% 23.60% 118.36% 124.13% 110.37% 100.00%
Tax Rate 14.36 % 22.79 % 24.04 % 5.70 % 9.32 % 1.78 % 16.29 % -2.08% YoY % -36.99% -5.20% 321.75% -38.84% 423.60% -89.07% - Horiz. % 88.15% 139.90% 147.58% 34.99% 57.21% 10.93% 100.00%
Total Cost 32,399 60,255 71,108 76,695 32,338 54,711 28,227 2.32% YoY % -46.23% -15.26% -7.28% 137.17% -40.89% 93.83% - Horiz. % 114.78% 213.47% 251.91% 271.71% 114.56% 193.83% 100.00%
Net Worth 1,750,354 1,737,078 1,650,887 1,551,436 1,353,672 660,295 665,123 17.48% YoY % 0.76% 5.22% 6.41% 14.61% 105.01% -0.73% - Horiz. % 263.16% 261.17% 248.21% 233.26% 203.52% 99.27% 100.00%
Dividend 30/06/20 30/06/19 30/06/18 30/06/17 30/06/16 30/06/15 30/06/14 CAGR
Div - - - - - - - - YoY % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% - Horiz. % - - - - - - -
Div Payout % - % - % - % - % - % - % - % - YoY % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% - Horiz. % - - - - - - -
Equity 30/06/20 30/06/19 30/06/18 30/06/17 30/06/16 30/06/15 30/06/14 CAGR
Net Worth 1,750,354 1,737,078 1,650,887 1,551,436 1,353,672 660,295 665,123 17.48% YoY % 0.76% 5.22% 6.41% 14.61% 105.01% -0.73% - Horiz. % 263.16% 261.17% 248.21% 233.26% 203.52% 99.27% 100.00%
NOSH 663,013 663,007 663,007 663,007 663,564 660,295 665,123 -0.05% YoY % 0.00% 0.00% 0.00% -0.08% 0.50% -0.73% - Horiz. % 99.68% 99.68% 99.68% 99.68% 99.77% 99.27% 100.00%
Ratio Analysis 30/06/20 30/06/19 30/06/18 30/06/17 30/06/16 30/06/15 30/06/14 CAGR
NP Margin 34.66 % 22.97 % 8.96 % 31.25 % 52.79 % 37.35 % 50.82 % -6.17% YoY % 50.89% 156.36% -71.33% -40.80% 41.34% -26.51% - Horiz. % 68.20% 45.20% 17.63% 61.49% 103.88% 73.49% 100.00%
ROE 0.99 % 1.03 % 0.42 % 2.24 % 2.70 % 4.91 % 4.42 % -22.05% YoY % -3.88% 145.24% -81.25% -17.04% -45.01% 11.09% - Horiz. % 22.40% 23.30% 9.50% 50.68% 61.09% 111.09% 100.00%
Per Share 30/06/20 30/06/19 30/06/18 30/06/17 30/06/16 30/06/15 30/06/14 CAGR
RPS 7.48 11.80 11.78 16.83 10.32 13.23 8.63 -2.35% YoY % -36.61% 0.17% -30.01% 63.08% -22.00% 53.30% - Horiz. % 86.67% 136.73% 136.50% 195.02% 119.58% 153.30% 100.00%
EPS 2.60 2.71 1.04 5.24 5.50 4.91 4.42 -8.46% YoY % -4.06% 160.58% -80.15% -4.73% 12.02% 11.09% - Horiz. % 58.82% 61.31% 23.53% 118.55% 124.43% 111.09% 100.00%
DPS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 - YoY % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% - Horiz. % - - - - - - -
NAPS 2.6400 2.6200 2.4900 2.3400 2.0400 1.0000 1.0000 17.54% YoY % 0.76% 5.22% 6.41% 14.71% 104.00% 0.00% - Horiz. % 264.00% 262.00% 249.00% 234.00% 204.00% 100.00% 100.00%
Adjusted Per Share Value based on latest NOSH - 693,386 30/06/20 30/06/19 30/06/18 30/06/17 30/06/16 30/06/15 30/06/14 CAGR
RPS 7.15 11.28 11.26 16.09 9.88 12.60 8.28 -2.41% YoY % -36.61% 0.18% -30.02% 62.85% -21.59% 52.17% - Horiz. % 86.35% 136.23% 135.99% 194.32% 119.32% 152.17% 100.00%
EPS 2.49 2.59 1.00 5.02 5.26 4.68 4.24 -8.48% YoY % -3.86% 159.00% -80.08% -4.56% 12.39% 10.38% - Horiz. % 58.73% 61.08% 23.58% 118.40% 124.06% 110.38% 100.00%
DPS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 - YoY % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% - Horiz. % - - - - - - -
NAPS 2.5244 2.5052 2.3809 2.2375 1.9523 0.9523 0.9592 17.48% YoY % 0.77% 5.22% 6.41% 14.61% 105.01% -0.72% - Horiz. % 263.18% 261.18% 248.22% 233.27% 203.53% 99.28% 100.00%
Price Multiplier on Financial Quarter End Date 30/06/20 30/06/19 30/06/18 30/06/17 30/06/16 30/06/15 30/06/14 CAGR
Date 30/06/20 28/06/19 29/06/18 30/06/17 30/06/16 30/06/15 30/06/14 -
Price 0.6400 0.7550 0.8750 1.0700 0.6450 0.8200 1.1900 -
P/RPS 8.56 6.40 7.43 6.36 6.25 6.20 13.79 -7.63% YoY % 33.75% -13.86% 16.82% 1.76% 0.81% -55.04% - Horiz. % 62.07% 46.41% 53.88% 46.12% 45.32% 44.96% 100.00%
P/EPS 24.57 27.89 83.62 20.39 11.73 16.69 26.93 -1.52% YoY % -11.90% -66.65% 310.10% 73.83% -29.72% -38.02% - Horiz. % 91.24% 103.56% 310.51% 75.71% 43.56% 61.98% 100.00%
EY 4.07 3.59 1.20 4.90 8.53 5.99 3.71 1.55% YoY % 13.37% 199.17% -75.51% -42.56% 42.40% 61.46% - Horiz. % 109.70% 96.77% 32.35% 132.08% 229.92% 161.46% 100.00%
DY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 - YoY % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% - Horiz. % - - - - - - -
P/NAPS 0.24 0.29 0.35 0.46 0.32 0.82 1.19 -23.40% YoY % -17.24% -17.14% -23.91% 43.75% -60.98% -31.09% - Horiz. % 20.17% 24.37% 29.41% 38.66% 26.89% 68.91% 100.00%
Price Multiplier on Announcement Date 30/06/20 30/06/19 30/06/18 30/06/17 30/06/16 30/06/15 30/06/14 CAGR
Date 27/08/20 28/08/19 28/08/18 22/08/17 25/08/16 17/08/15 26/08/14 -
Price 0.8550 0.7850 0.8750 1.0000 0.6550 0.6400 1.2700 -
P/RPS 11.43 6.65 7.43 5.94 6.35 4.84 14.72 -4.12% YoY % 71.88% -10.50% 25.08% -6.46% 31.20% -67.12% - Horiz. % 77.65% 45.18% 50.48% 40.35% 43.14% 32.88% 100.00%
P/EPS 32.83 29.00 83.62 19.06 11.91 13.03 28.74 2.24% YoY % 13.21% -65.32% 338.72% 60.03% -8.60% -54.66% - Horiz. % 114.23% 100.90% 290.95% 66.32% 41.44% 45.34% 100.00%
EY 3.05 3.45 1.20 5.25 8.40 7.68 3.48 -2.17% YoY % -11.59% 187.50% -77.14% -37.50% 9.37% 120.69% - Horiz. % 87.64% 99.14% 34.48% 150.86% 241.38% 220.69% 100.00%
DY 0.00 0.00 0.00 0.00 0.00 0.00 0.00 - YoY % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% - Horiz. % - - - - - - -
P/NAPS 0.32 0.30 0.35 0.43 0.32 0.64 1.27 -20.51% YoY % 6.67% -14.29% -18.60% 34.38% -50.00% -49.61% - Horiz. % 25.20% 23.62% 27.56% 33.86% 25.20% 50.39% 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
QRExcel June 2017 (final).pdf 
