LPCK at break even
LPCK.jk Current 1,080 Target 1,111 + 3%
11/20/2022
1 minute read
Sales declined -45%
Last 5 quarters growth, sales billion rupiah
27% 26% -53% 43% -45%
526 664 314 451 246
Costs up profit down
Last 5 quarters cost ratio, profit billion rupiah
-111% -94% -95% -96% -99%
108 -231 91 132 48
Cashflow less negative
Last 5 quarters operating, investment cashflow billion rupiah
-35 133 69 -134 -43
-9 -56 -2 2 2
Net cash down
Last 5 quarters cash, liabilities billion rupiah
377 376 374 255 214
2,772 2,728 2,700 2,601 2,710
Capital (raised)
Last 5 quarters capital from liabilities, equity billion rupiah
19 19 69 52 -65
150 59 0 0 0
11/20/2022
1 minute read
- Last 12 months sales growth -53%
- Last 12 months cash flow -1% of market cap
- Last 12 months Capital + 5% of market cap
- Latest net cash -86% of market cap
Sales declined -45%
Last 5 quarters growth, sales billion rupiah
27% 26% -53% 43% -45%
526 664 314 451 246
- Sales declined -45% in the third quarter to 246 billion rupiah our forecasts v sales is 3% now.
- This brings the average to -7% growth.
- We predict average growth of 21% in this next 12 months to bring sales to 493 billion rupiah in the third quarter 2023.
Costs up profit down
Last 5 quarters cost ratio, profit billion rupiah
-111% -94% -95% -96% -99%
108 -231 91 132 48
- The cash cost ratio went from -96% to -99% profit from 132 to 48 billion rupiah in the third quarter.
- The average cost ratio is at -96% now.
- We use a -96% cost ratio to predict a 23 billion rupiah profit in the third quarter 2023.
Cashflow less negative
Last 5 quarters operating, investment cashflow billion rupiah
-35 133 69 -134 -43
-9 -56 -2 2 2
- Free cashflow went from -132 to -41 billion rupiah in the third quarter with 2 billion rupiah investment cashflow.
- Average quarterly Cashflow is at -7 billion rupiah now.
- We assume 0 billion rupiah investment spending which with higher sales gives 17 billion rupiah average Cashflow in the next 12 months.
Net cash down
Last 5 quarters cash, liabilities billion rupiah
377 376 374 255 214
2,772 2,728 2,700 2,601 2,710
- Cash declined 255 to 214 billion rupiah in the third quarter.
- Liabilities increased 2,601 to 2,710 billion rupiah so net cash was down -2,346 to -2,496 billion rupiah .
- With our forecast cashflow & a 0 billion rupiah equity payout -1 billion rupiah liabilities net cash will be -2,430 billion rupiah in 12 months time.
Capital (raised)
Last 5 quarters capital from liabilities, equity billion rupiah
19 19 69 52 -65
150 59 0 0 0
- LPCK.jk (raised) -65 billion rupiah in the third quarter -65 billion rupiah liabilities 0 billion rupiah equity & will pay 1 billion rupiah this next 12 months.
- At the current market value of 2,894 billion rupiah based on our forecasts it’s at 0.31 X assets with a 144 years payback & a 0% yield.
- Our cashflow forecast is 66 billion rupiah which means a 44 X valuation. A 45 X valuation gives a 3% higher target price 1,111 rupiah.