Cash flow PT. Ratu Prabu Energi, Tbk

Equities

ARTI

ID1000094808

Oil Related Services and Equipment

End-of-day quote INDONESIA S.E. Other stock markets 01/07/2024			5-day change	1st Jan Change
2.000 ^IDR	-.--%		-.--%	-

01-13	Inflation test focuses Fed row	RE
01-13	MORNING BID AMERICAS-Inflation test focuses Fed row	RE

5c84530164e9df8b985ff2072.GHSQAEhOu7KjZbP-di0gFJX2QyOsKb531TEhMsX-N4s.bEzpaDwX3vbCKsSoJBV3VcyAAQ75G_tHvHkQaJGWAsRVDfF3OAbW1ckP_g

Published financial data: PT. RATU PRABU ENERGI, TBK

Annual

Quarterly

Halfyear

YTD

LTM

Fiscal Period: December	2020	2021	2022	2023	2024
Revenues	32.8B	6.01B	73.31B	115B	37.08B
Total Revenues	32.8B	6.01B	73.31B	115B	37.08B
Cost of Goods Sold, Total	62.49B	32.16B	65.05B	92.26B	24.54B
Gross Profit	-29.69B	-26.14B	8.26B	22.78B	12.54B
Selling General & Admin Expenses, Total	15.53B	7.02B	8.01B	15.52B	9.8B
Provision for Bad Debts	-	-	-	-	-
Depreciation & Amortization - (IS)	12.33B	370M	164M	136M	136M
Other Operating Expenses	44.75M	142M	1.21B	896M	1.22B
Other Operating Expenses, Total	27.91B	7.53B	9.38B	16.55B	11.16B
Operating Income	-57.59B	-33.68B	-1.12B	6.22B	1.38B
Interest Expense, Total	-24.41B	-	-26.53B	-26.52B	-
Interest And Investment Income	-	-	-	-	-
Net Interest Expenses	-24.41B	-	-26.53B	-26.52B	-
Income (Loss) On Equity Invest.	-19.38B	-	-	-	-
Currency Exchange Gains (Loss)	-7.33B	-572M	628M	-116M	-148M
Other Non Operating Income (Expenses)	-127B	-51.36B	-30.73B	511M	-5.68B
EBT, Excl. Unusual Items	-236B	-85.61B	-57.75B	-19.9B	-4.44B
Gain (Loss) On Sale Of Assets	-	-49.58B	-	-	-
Asset Writedown	-687B	-	-	-	-
EBT, Incl. Unusual Items	-923B	-135B	-57.75B	-19.9B	-4.44B
Income Tax Expense	34.6B	-4.9M	-6.39M	-8.36M	-15.13M
Earnings From Continuing Operations	-957B	-135B	-57.75B	-19.89B	-4.43B
Net Income to Company	-957B	-135B	-57.75B	-19.89B	-4.43B
Minority Interest	6.18B	507M	292M	165M	165M
Net Income - (IS)	-951B	-135B	-57.46B	-19.73B	-4.26B
Net Income to Common Incl Extra Items	-951B	-135B	-57.46B	-19.73B	-4.26B
Net Income to Common Excl. Extra Items	-951B	-135B	-57.46B	-19.73B	-4.26B
Per Share Items
Net EPS - Basic	-127.14	-17.18	-7.33	-2.52	-0.54
Basic EPS - Continuing Operations	-127.14	-17.18	-7.33	-2.52	-0.54
Basic Weighted Average Shares Outstanding	7.48B	7.84B	7.84B	7.84B	7.84B
Net EPS - Diluted	-127.14	-17.18	-7.33	-2.52	-0.54
Diluted EPS - Continuing Operations	-127.14	-17.18	-7.33	-2.52	-0.54
Diluted Weighted Average Shares Outstanding	7.48B	7.84B	7.84B	7.84B	7.84B
Normalized Basic EPS	-18.86	-6.76	-4.57	-1.57	-0.33
Normalized Diluted EPS	-18.86	-6.76	-4.57	-1.57	-0.33
American Depositary Receipts Ratio (ADR)	1	1	1	1	1
Supplemental Items
EBITDA	-18.72B	-10.1B	23.57B	23.87B	19.34B
EBITA	-57.59B	-33.68B	-1.12B	6.22B	1.38B
EBIT	-57.59B	-33.68B	-1.12B	6.22B	1.38B
EBITDAR	-17.7B	-9.09B	25.03B	37.87B	20.61B
Effective Tax Rate - (Ratio)	-3.75	0	0.01	0.04	0.34
Current Domestic Taxes	-	-	-	-	-
Total Current Taxes	-	-	-	-	-
Deferred Domestic Taxes	-	-	-	-	-
Total Deferred Taxes	35.06B	-	-	-	-
Normalized Net Income	-141B	-53B	-35.8B	-12.27B	-2.61B
Interest on Long-Term Debt	24.38B	-	-	-	-
Non-Cash Pension Expense	971M	-207M	51.67M	558M	386M
Supplemental Operating Expense Items
Advertising Expense	-	-	-	-	-
Marketing Expenses	662M	103M	4M	220M	487M
Selling and Marketing Expenses	662M	103M	4M	220M	487M
General and Administrative Expenses	8.38B	1.02B	937M	6.28B	1.34B
Net Rental Expense, Total	1.02B	1B	1.45B	14B	1.27B
Imputed Operating Lease Interest Expense	449M	-	30.44B	389B	-
Imputed Operating Lease Depreciation	574M	-	-28.99B	-375B	-
Maintenance & Repair Expenses, Total	273M	237M	1.28B	3.56B	432M

Fiscal Period: December	2020	2021	2022	2023	2024
Assets
Cash And Equivalents	1.81B	859M	800M	995M	465M
Short Term Investments	-	-	-	-	-
Total Cash And Short Term Investments	1.81B	859M	800M	995M	465M
Accounts Receivable, Total	6.57B	1.65B	28.56B	30.11B	985M
Other Receivables	-	-	-	-	-
Total Receivables	6.57B	1.65B	28.56B	30.11B	985M
Inventory	8.52B	5.2B	0	0	-
Prepaid Expenses	-	-	39.09M	-	-
Other Current Assets, Total	1.57B	1.33B	715M	1.2B	-
Total Current Assets	18.47B	9.04B	30.11B	32.3B	1.45B
Gross Property Plant And Equipment	745B	745B	745B	514B	514B
Accumulated Depreciation	-357B	-381B	-405B	-416B	-433B
Net Property Plant And Equipment	388B	365B	340B	98.1B	80.98B
Long-term Investments	-	-	-	-	-
Loans Receivable Long-Term	-	-	-	-	-
Deferred Tax Assets Long-Term	-	-	-	-	-
Deferred Charges Long-Term	-	-	-	-	-
Other Long-Term Assets, Total	446B	270B	245B	467B	468B
Total Assets	853B	644B	615B	597B	551B
Liabilities
Accounts Payable, Total	11.37B	70.04B	65.87B	69.14B	63.64B
Accrued Expenses, Total	54.85B	54.43B	56.63B	64.32B	65.01B
Short-term Borrowings	5B	-	-	-	-
Current Portion of Long-Term Debt	83.32B	12.64B	7.64B	7.64B	7.45B
Current Portion of Leases	-	-	-	-	-
Current Income Taxes Payable	17.07M	13.44M	246M	244M	245M
Unearned Revenue Current, Total	912M	3.09B	3.09B	3.09B	3.09B
Other Current Liabilities	763B	575B	612B	614B	606B
Total Current Liabilities	919B	715B	746B	758B	746B
Long-Term Debt	53.33M	-	-	-	-
Long-Term Leases	-	-	-	-	-
Unearned Revenue Non Current	-	-	-	-	-
Pension & Other Post Retirement Benefits	17.79B	16.85B	17.11B	7.53B	7.96B
Other Non Current Liabilities	72.13B	10.44B	8.3B	-	-
Total Liabilities	1,009B	742B	771B	766B	754B
Common Stock, Total	1,411B	1,411B	1,411B	1,411B	1,411B
Additional Paid In Capital	351B	351B	351B	351B	351B
Retained Earnings	-1,939B	-1,883B	-1,940B	-1,952B	-1,987B
Comprehensive Income and Other	15.77B	15.77B	15.77B	15.77B	15.77B
Total Common Equity	-161B	-105B	-162B	-174B	-209B
Minority Interest	4.96B	6.64B	6.35B	5.37B	6.26B
Total Equity	-156B	-98.37B	-156B	-169B	-203B
Total Liabilities And Equity	853B	644B	615B	597B	551B
Supplemental Items
ECS Total Shares Outstanding on Filing Date	7.84B	7.84B	7.84B	7.84B	7.84B
ECS Total Common Shares Outstanding	7.84B	7.84B	7.84B	7.84B	7.84B
Book Value / Share	-20.5	-13.39	-20.71	-22.21	-26.67
Tangible Book Value	-161B	-105B	-162B	-174B	-209B
Tangible Book Value Per Share	-20.5	-13.39	-20.71	-22.21	-26.67
Total Debt	88.37B	12.64B	7.64B	7.64B	7.45B
Net Debt	86.56B	11.78B	6.84B	6.64B	6.98B
Debt Equivalent Oper. Leases	8.19B	8.03B	11.63B	112B	10.12B
Minority Interest, Total (Incl. Fin. Div)	4.96B	6.64B	6.35B	5.37B	6.26B
Equity Method Investments, Total	-	-	-	-	-
Account Code - Inventory Valuation	6	6	6	6	6
Inventories - Others	17.03B	16.98B	16.98B	16.98B	-
Land - (BS)	232B	232B	232B	-	-
Buildings, Total	17.59B	17.59B	17.59B	18.18B	18.63B
Machinery, Total	496B	496B	496B	495B	496B
Full Time Employees	118	114	98	98	53
Assets under Capital Lease - Gross	-	-	-	-	-
Assets under Capital Lease - Accumulated Depreciation	-	-	-	-	-
Accumulated Allowance for Doubtful Accounts (Supple)	121B	121B	9.73B	26.73B	20.76B

Fiscal Period: December	2020	2021	2022	2023	2024
Net Income	-951B	-135B	-57.46B	-19.73B	-4.26B
Depreciation & Amortization - CF	38.87B	23.58B	24.69B	17.65B	17.96B
Depreciation & Amortization, Total	38.87B	23.58B	24.69B	17.65B	17.96B
Other Operating Activities, Total	896B	110B	-529M	-30.81B	-12.3B
Cash from Operations	-16.15B	-720M	-33.29B	-32.89B	1.4B
Capital Expenditure	-	-	-	-604M	-450M
Sale (Purchase) of Real Estate properties	-	-	-	-	-
Investment in Marketable and Equity Securities, Total	-	-	-	-	-
Other Investing Activities, Total	-94.12M	-	-	-	-
Cash from Investing	-94.12M	-	-	-604M	-450M
Short Term Debt Issued, Total	4.47B	932M	-	-	-
Long-Term Debt Issued, Total	5.64B	-	38.24B	-	-
Total Debt Issued	10.11B	932M	38.24B	-	-
Short Term Debt Repaid, Total	-	-1.04B	-	-	-
Long-Term Debt Repaid, Total	-101M	-121M	-5B	-	-102M
Total Debt Repaid	-101M	-1.16B	-5B	-	-102M
Issuance of Common Stock	-	-	-	-	-
Other Financing Activities, Total	-	-	-	33.69B	-1.38B
Cash from Financing	10.01B	-231M	33.24B	33.69B	-1.48B
Miscellaneous Cash Flow Adjustments	1	-	1	-	-
Net Change in Cash	-6.23B	-950M	-58.99M	195M	-531M
Supplemental Items
Cash Interest Paid	771M	11.95M	27.11B	26.53B	23.13M
Cash Income Tax Paid (Refund)	989M	242M	-	896M	10.07M
Levered Free Cash Flow	1,287B	-87.1B	22.27B	14.83B	36.18B
Unlevered Free Cash Flow	1,302B	-87.1B	38.86B	31.4B	36.18B
Change In Net Working Capital	-1,299B	89.63B	-14.86B	-10.47B	-17.81B
Net Debt Issued / Repaid	10.01B	-231M	33.24B	-	-102M

Fiscal Period: December	2020	2021	2022	2023	2024
Profitability
Return on Assets	-2.73	-2.49	-0.11	0.64	0.15
Return on Total Capital	-4.69	-109.48	0.6	-2.51	-0.49
Return On Equity %	-296.69	432.18	45.4	12.25	2.38
Return on Common Equity	-162.04	352.81	42.97	11.72	2.22
Margin Analysis
Gross Profit Margin %	-90.49	-435	11.27	19.8	33.82
SG&A Margin	47.35	116.82	10.92	13.49	26.42
EBITDA Margin %	-57.07	-167.98	32.16	20.75	52.17
EBITA Margin %	-175.57	-560.35	-1.52	5.41	3.73
EBIT Margin %	-175.57	-560.35	-1.52	5.41	3.73
Income From Continuing Operations Margin %	-2.92K	-2.25K	-78.77	-17.29	-11.94
Net Income Margin %	-2.9K	-2.24K	-78.38	-17.15	-11.49
Net Avail. For Common Margin %	-2.9K	-2.24K	-78.38	-17.15	-11.49
Normalized Net Income Margin	-430.1	-881.81	-48.84	-10.67	-7.04
Levered Free Cash Flow Margin	3.92K	-1.45K	30.38	12.89	97.57
Unlevered Free Cash Flow Margin	3.97K	-1.45K	53.01	27.3	97.57
Asset Turnover
Asset Turnover	0.02	0.01	0.12	0.19	0.06
Fixed Assets Turnover	0.08	0.02	0.21	0.53	0.41
Receivables Turnover (Average Receivables)	0.5	1.46	4.85	3.92	2.39
Inventory Turnover (Average Inventory)	4.89	4.69	25.01	-	-
Short Term Liquidity
Current Ratio	0.02	0.01	0.04	0.04	0
Quick Ratio	0.01	0	0.04	0.04	0
Operating Cash Flow to Current Liabilities	-0.02	-0	-0.04	-0.04	0
Days Sales Outstanding (Average Receivables)	724.92	249.74	75.21	93.07	153.45
Days Outstanding Inventory (Average Inventory)	74.83	77.89	14.59	0	-
Average Days Payable Outstanding	57.95	515.25	-	267.08	990.12
Cash Conversion Cycle (Average Days)	741.8	-187.61	-	-174.01	-
Long Term Solvency
Total Debt/Equity	-56.73	-12.85	-4.89	-4.53	-3.67
Total Debt / Total Capital	-131.09	-14.74	-5.15	-4.74	-3.81
LT Debt/Equity	-0.03	-	-	-	-
Long-Term Debt / Total Capital	-0.08	-	-	-	-
Total Liabilities / Total Assets	118.26	115.28	125.37	128.27	136.84
EBIT / Interest Expense	-2.36	-	-0.04	0.23	-
EBITDA / Interest Expense	-0.77	-	0.89	0.9	-
(EBITDA - Capex) / Interest Expense	-0.77	-	0.89	0.88	-
Total Debt / EBITDA	-4.72	-1.25	0.32	0.32	0.39
Net Debt / EBITDA	-4.62	-1.17	0.29	0.28	0.36
Total Debt / (EBITDA - Capex)	-4.72	-1.25	0.32	0.33	0.39
Net Debt / (EBITDA - Capex)	-4.62	-1.17	0.29	0.29	0.37
Growth Over Prior Year
Total Revenues, 1 Yr. Growth %	-80.97	-81.68	1.12K	56.92	-67.76
Gross Profit, 1 Yr. Growth %	874.98	-11.93	-131.6	175.72	-44.94
EBITDA, 1 Yr. Growth %	9.17	-46.07	-333.49	-27.84	-18.97
EBITA, 1 Yr. Growth %	-22.64	-41.52	-96.69	-657.54	-77.75
EBIT, 1 Yr. Growth %	-22.64	-41.52	-96.69	-657.54	-77.75
Earnings From Cont. Operations, 1 Yr. Growth %	-3.03	-82.34	-57.28	-65.55	-77.75
Net Income, 1 Yr. Growth %	172.51	-82.32	-57.34	-65.66	-78.4
Normalized Net Income, 1 Yr. Growth %	-144.06	-59.59	-32.44	-65.72	-78.73
Diluted EPS Before Extra, 1 Yr. Growth %	172.51	-82.32	-57.33	-65.66	-78.4
Accounts Receivable, 1 Yr. Growth %	-94.67	-74.83	1.63K	5.44	-96.73
Inventory, 1 Yr. Growth %	-49.96	-38.96	-100	-	-
Net Property, Plant and Equip., 1 Yr. Growth %	-8.54	-6.08	-6.75	-71.14	-17.45
Total Assets, 1 Yr. Growth %	-52.23	-38.37	-4.44	-2.95	-7.77
Tangible Book Value, 1 Yr. Growth %	-112.04	-466.27	54.65	7.23	20.09
Common Equity, 1 Yr. Growth %	-112.04	-466.27	54.65	7.23	20.09
Cash From Operations, 1 Yr. Growth %	41.69	-95.54	1.79K	-1.23	-104.26
Capital Expenditures, 1 Yr. Growth %	-	-	-	-	-25.51
Levered Free Cash Flow, 1 Yr. Growth %	2.49K	-106.93	-124.73	-53.34	143.99
Unlevered Free Cash Flow, 1 Yr. Growth %	2.51K	-106.85	-144.61	-35.07	15.21
Compound Annual Growth Rate Over Two Years
Total Revenues, 2 Yr. CAGR %	-67.22	-81.33	49.49	337.48	-28.88
Gross Profit, 2 Yr. CAGR %	-55.95	193.03	-47.25	-6.66	23.21
EBITDA, 2 Yr. CAGR %	-66.86	-23.27	12.22	53.77	-23.53
EBITA, 2 Yr. CAGR %	-26.86	-32.74	-86.08	-57.01	11.37
EBIT, 2 Yr. CAGR %	-26.86	-32.74	-86.08	-57.01	11.37
Earnings From Cont. Operations, 2 Yr. CAGR %	440.18	-62.99	-72.54	-61.64	-72.32
Net Income, 2 Yr. CAGR %	805.55	-37.88	-72.53	-61.73	-72.77
Normalized Net Income, 2 Yr. CAGR %	340.24	-59.32	-47.75	-51.88	-73
Diluted EPS Before Extra, 2 Yr. CAGR %	827.08	-39.32	-72.53	-61.73	-72.77
Accounts Receivable, 2 Yr. CAGR %	-78.12	-88.42	108.47	326.66	-81.43
Inventory, 2 Yr. CAGR %	-2.2	-44.73	-	-	-
Net Property, Plant and Equip., 2 Yr. CAGR %	-43.73	-7.32	-6.41	-48.12	-51.19
Total Assets, 2 Yr. CAGR %	-44.03	-39.95	-23.26	-3.69	-5.39
Tangible Book Value, 2 Yr. CAGR %	-69.12	-71.95	138	28.77	13.47
Common Equity, 2 Yr. CAGR %	-69.12	-71.95	138	28.77	13.47
Cash From Operations, 2 Yr. CAGR %	-64.99	-74.87	43.59	332.16	-79.49
Capital Expenditures, 2 Yr. CAGR %	-	-	-	-	-
Levered Free Cash Flow, 2 Yr. CAGR %	208.22	32.37	-86.69	-59.42	6.7
Unlevered Free Cash Flow, 2 Yr. CAGR %	284.83	32.19	-82.52	-39.95	-13.51
Compound Annual Growth Rate Over Three Years
Total Revenues, 3 Yr. CAGR %	-49.17	-73	-24.81	51.92	83.41
Gross Profit, 3 Yr. CAGR %	-40.41	-44.51	39.47	-8.45	-21.72
EBITDA, 3 Yr. CAGR %	-50.7	-61.02	11.19	8.44	24.2
EBITA, 3 Yr. CAGR %	-16.31	-32.12	-75.34	-52.37	-65.49
EBIT, 3 Yr. CAGR %	-16.31	-32.12	-75.34	-52.37	-65.49
Earnings From Cont. Operations, 3 Yr. CAGR %	221.2	60.32	-61.18	-70.38	-68.01
Net Income, 3 Yr. CAGR %	353.28	126.45	-45.19	-70.41	-68.37
Normalized Net Income, 3 Yr. CAGR %	322.14	93.81	-51.83	-54.6	-63.34
Diluted EPS Before Extra, 3 Yr. CAGR %	360.44	126.45	-46.04	-70.41	-68.37
Accounts Receivable, 3 Yr. CAGR %	-64.51	-77.07	-38.6	66.1	-15.86
Inventory, 3 Yr. CAGR %	-16.67	-16.42	-	-	-
Net Property, Plant and Equip., 3 Yr. CAGR %	-28.64	-33.25	-7.13	-36.77	-39.44
Total Assets, 3 Yr. CAGR %	-30.18	-38.16	-29.89	-17.01	-5.07
Tangible Book Value, 3 Yr. CAGR %	-54.2	-60.35	-50.44	82.45	25.81
Common Equity, 3 Yr. CAGR %	-54.2	-60.35	-50.44	82.45	25.81
Cash From Operations, 3 Yr. CAGR %	-57.35	-82.39	42.95	26.75	-7.34
Capital Expenditures, 3 Yr. CAGR %	-	-	-	-	-
Levered Free Cash Flow, 3 Yr. CAGR %	969.04	-13.69	-23.48	-77.24	-26.22
Unlevered Free Cash Flow, 3 Yr. CAGR %	227.58	-0.32	-7.97	-70.88	-25.39
Compound Annual Growth Rate Over Five Years
Total Revenues, 5 Yr. CAGR %	-32.01	-50.88	-21.74	-17.74	-26.46
Gross Profit, 5 Yr. CAGR %	-23.57	-22.24	-43.25	-31.68	32.73
EBITDA, 5 Yr. CAGR %	-30.38	-37.84	-31.49	-32.51	2.44
EBITA, 5 Yr. CAGR %	-2.13	-7.18	-59.16	-43.46	-54.93
EBIT, 5 Yr. CAGR %	-2.13	-7.18	-59.16	-43.46	-54.93
Earnings From Cont. Operations, 5 Yr. CAGR %	121.87	71.06	14.86	-9.52	-66.09
Net Income, 5 Yr. CAGR %	134.73	98.46	41.27	11.21	-58.57
Normalized Net Income, 5 Yr. CAGR %	124.4	71.45	80.37	11.01	-61.78
Diluted EPS Before Extra, 5 Yr. CAGR %	136.95	98.46	41.28	11.21	-58.96
Accounts Receivable, 5 Yr. CAGR %	-49.18	-62.76	-27.95	-26.17	-61.94
Inventory, 5 Yr. CAGR %	-5.6	-14.63	-	-	-
Net Property, Plant and Equip., 5 Yr. CAGR %	-14.5	-16.13	-20.47	-39.65	-28.2
Total Assets, 5 Yr. CAGR %	-19.02	-24.46	-24.49	-26.17	-20.96
Tangible Book Value, 5 Yr. CAGR %	-37.02	-42.44	-37.28	-36.49	-30.97
Common Equity, 5 Yr. CAGR %	-37.02	-42.44	-37.28	-36.49	-30.97
Cash From Operations, 5 Yr. CAGR %	-46.89	-50.97	-30.69	-24.24	-34.25
Capital Expenditures, 5 Yr. CAGR %	-	-	-	-69.69	-32.91
Levered Free Cash Flow, 5 Yr. CAGR %	19.91	13.41	84.09	-35.75	-6.16
Unlevered Free Cash Flow, 5 Yr. CAGR %	22.39	0.5	0.96	-18.61	-6.21