IPPE.jk Cashflow turns positive
Current 122 Target 126 +3%
1/9/2023
1 minute read
Sales grew 45%
Last 5 quarters quarterly sales growth, quarterly ales
12% 0% 69% -5% 45%
8 ; 8 ; 13 ; 13 ; 18 billion rupiah
Margin up profit up
Last 5 quarters cash margin, profit
15% 15% 11% 14% 22%
1 ; 1 ; 1 ; 1 ; 4 billion rupiah
Cashflow turns positive
Last 5 quarters operating, investment cashflow
-6 ; -6 ; 3 ; -2 ; 1 billion rupiah
-19 ; -19 ; -11 ; -11 ; 0 billion rupiah
Net cash down
Last 5 quarters cash, liabilities
0 ; 21 ; 14 ; 1 ; 2 billion rupiah
0 ; 5 ; 7 ; 8 ; 10 billion rupiah
Capital flat
Last 5 quarters capital (raised) paid from liabilities, equity
0 ; 0 ; 0 ; 0 ; 0 billion rupiah
-32 ; -32 ; 0 ; 0 ; 0 billion rupiah
Current 122 Target 126 +3%
1/9/2023
1 minute read
- Last 12 months sales growth + 132%
- Last 12 months cash flow -8% of market cap
- Last 12 months Capital (debt & equity) paid (raised) -6% of market cap
- Latest cash minus liabilities -1% of market cap
Sales grew 45%
Last 5 quarters quarterly sales growth, quarterly ales
12% 0% 69% -5% 45%
8 ; 8 ; 13 ; 13 ; 18 billion rupiah
- Sales grew 45% in the third quarter to 18 billion rupiah ; our total forecasts v actual sales are + 17% now.
- This brings the average to 27% growth.
- We predict average growth of 1% in this next 12 months to bring sales to 19 billion rupiah in the third quarter 2023.
Margin up profit up
Last 5 quarters cash margin, profit
15% 15% 11% 14% 22%
1 ; 1 ; 1 ; 1 ; 4 billion rupiah
- The cash margin went from 14% to 22% profit from 1 to 4 billion rupiah in the third quarter.
- The average cash margin is at 15% now.
- We use a 4% cash margin from cashflow to predict a 0 billion rupiah profit in the third quarter 2023.
Cashflow turns positive
Last 5 quarters operating, investment cashflow
-6 ; -6 ; 3 ; -2 ; 1 billion rupiah
-19 ; -19 ; -11 ; -11 ; 0 billion rupiah
- Free cashflow went from -13 to 1 billion rupiah in the third quarter with 0 billion rupiah investment cashflow.
- Average quarterly Cashflow is at -11 billion rupiah now.
- We assume 0 billion rupiah investment spending which with higher sales gives 1 billion rupiah average Cashflow in the next 12 months.
Net cash down
Last 5 quarters cash, liabilities
0 ; 21 ; 14 ; 1 ; 2 billion rupiah
0 ; 5 ; 7 ; 8 ; 10 billion rupiah
- Cash increased 1 to 2 billion rupiah in the third quarter.
- Liabilities increased 8 to 10 billion rupiah so net cash was down -7 to -8 billion rupiah .
- With our forecast cashflow & a 0 billion rupiah equity payout -2 billion rupiah liabilities net cash will be -4 billion rupiah in 12 months time.
Capital flat
Last 5 quarters capital (raised) paid from liabilities, equity
0 ; 0 ; 0 ; 0 ; 0 billion rupiah
-32 ; -32 ; 0 ; 0 ; 0 billion rupiah
- IPPE.jk (raised) 0 billion rupiah in the third quarter 0 billion rupiah liabilities 0 billion rupiah equity, will pay 2 billion rupiah this next 12 months.
- At the current market cap of 561 billion rupiah based on our forecasts it’s at 1.90 X assets with a 60 years payback & a 0% yield.
- Our cashflow forecast is 5 billion rupiah which means a 116 X valuation. A 120 X valuation gives a 3% higher target price 126 rupiah.