Cash flow Lippo Malls Indonesia Retail Trust

Equities

D5IU

SG1W27938677

Commercial REITs

Market Closed - Singapore S.E. Other stock markets 05:04:30 2025-06-20 EDT			5-day change	1st Jan Change
0.0140 ^SGD	0.00%		0.00%	-22.22%

05-29	Lippo Malls Indonesia Retail Trust Announces Change of Registered Office Address	CI
04-29	Singapore Shares Extend Losses After Fall in Export, Import Prices; Keong Hong Surges 30%	MT

6.oDiwtjeOBQGM4HgvKJpmDAUye49mYNzQVD-DQozpvkw.z27DgW7oYzjchRNFW-8IO1p9T9oRC6ySC1vINt6mzifCS_GPD_RcdMOOLQ

Published financial data: LIPPO MALLS INDONESIA RETAIL TRUST

Annual

Quarterly

Halfyear

YTD

LTM

Fiscal Period: December	2020	2021	2022	2023	2024
Rental Revenues	149M	175M	205M	197M	195M
Total Revenues	149M	175M	205M	197M	195M
Property Expenses	79.73M	80.12M	84.41M	84.45M	87.57M
Selling General & Admin Expenses, Total	436K	466K	473K	423K	405K
Amortization of Goodwill and Intangible Assets - (IS)	2.2M	7.57M	6.81M	5.41M	5.17M
Other Operating Expenses	2.49M	4.25M	4.12M	7.68M	4.32M
Total Operating Expenses	84.85M	92.41M	95.82M	97.96M	97.47M
Operating Income (REIT / Utility Template)	63.68M	82.66M	109M	99.31M	97.09M
Interest Expense, Total	-46.25M	-60.01M	-62.6M	-71.92M	-77.11M
Interest and Investment Income	2.37M	1.51M	1.64M	2.14M	1.27M
Net Interest Expenses	-43.88M	-58.5M	-60.96M	-69.78M	-75.84M
Currency Exchange Gains (Loss)	-5.4M	-9.4M	-12.37M	-26.66M	-87.2M
Other Non Operating Income (Expenses)	-10.44M	9.02M	-19.64M	3.22M	26.6M
EBT, Excl. Unusual Items	3.97M	23.77M	15.91M	6.09M	-39.34M
Gain (Loss) on Sale of Assets	-148K	-	-	-	-
Asset Writedown	-212M	-31.38M	32.31M	-133M	29.82M
Other Unusual Items	-	-	-	20.97M	-1.52M
EBT, Incl. Unusual Items	-208M	-7.61M	48.22M	-106M	-11.04M
Income Tax Expense	21.92M	24.9M	46.64M	19.58M	25.34M
Earnings From Continuing Operations	-230M	-32.51M	1.58M	-126M	-36.38M
Net Income to Company	-230M	-32.51M	1.58M	-126M	-36.38M
Net Income - (IS)	-230M	-32.51M	1.58M	-126M	-36.38M
Preferred Dividend and Other Adjustments	17.77M	17.53M	14.32M	-	-
Net Income to Common Incl Extra Items	-248M	-50.04M	-12.74M	-126M	-36.38M
Net Income to Common Excl. Extra Items	-248M	-50.04M	-12.74M	-126M	-36.38M
Per Share Items
Net EPS - Basic	-0.08	-0.01	-0	-0.02	-0
Basic EPS - Continuing Operations	-0.08	-0.01	-0	-0.02	-0
Basic Weighted Average Shares Outstanding	2.92B	7.4B	7.69B	7.7B	7.7B
Net EPS - Diluted	-0.08	-0.01	-0	-0.02	-0
Diluted EPS - Continuing Operations	-0.08	-0.01	-0	-0.02	-0
Diluted Weighted Average Shares Outstanding	2.92B	7.4B	7.69B	7.7B	7.7B
Normalized Basic EPS	0	0	0	0	-0
Normalized Diluted EPS	0	0	0	0	-0
Dividend Per Share	0	0	0	-	-
Payout Ratio	-16.33	-137.43	2.82K	-2.44	-
Supplemental Items
EBITDA	69.11M	92.98M	118M	107M	105M
EBITA	65.88M	90.23M	116M	105M	102M
EBIT	63.68M	82.66M	109M	99.31M	97.09M
EBITDAR	70.61M	94.42M	120M	109M	106M
Effective Tax Rate - (Ratio)	-10.52	-327.35	96.72	-18.4	-229.43
Current Foreign Taxes	-	-	-	-	-
Total Current Taxes	22.83M	24.57M	30.96M	25.88M	25.24M
Deferred Foreign Taxes	-	-	-	-	-
Total Deferred Taxes	-911K	338K	15.68M	-6.31M	97K
Normalized Net Income	2.48M	14.86M	9.94M	3.81M	-24.59M
Interest on Long-Term Debt	47.95M	60.31M	62.74M	71.98M	77.11M
Supplemental Operating Expense Items
General and Administrative Expenses	436K	466K	473K	423K	405K
Net Rental Expense, Total	1.5M	1.44M	1.44M	1.46M	1.57M
Imputed Operating Lease Interest Expense	779K	890K	840K	991K	1.23M
Imputed Operating Lease Depreciation	717K	552K	599K	473K	342K
Stock-Based Comp., COGS (Total)	2.63M	1.27M	-	-	-
Total Stock-Based Compensation	2.63M	1.27M	-	-	-

Fiscal Period: December	2020	2021	2022	2023	2024
Assets
Gross Property Plant And Equipment	1.48B	1.81B	1.68B	1.56B	1.59B
Accumulated Depreciation	-14.94M	-17.83M	-17.04M	-19.29M	-21.27M
Net Property Plant And Equipment	1.47B	1.8B	1.66B	1.54B	1.57B
Total Real Estate Assets	1.47B	1.8B	1.66B	1.54B	1.57B
Cash And Equivalents	109M	122M	111M	140M	19.98M
Accounts Receivable, Total	27.26M	38.8M	32.68M	24.3M	23.91M
Other Receivables	16.6M	10.22M	8.31M	4.72M	5.22M
Investment In Debt and Equity Securities	-	-	-	-	-
Other Intangibles, Total	3.33M	18.6M	10.51M	5.23M	0
Restricted Cash	-	-	-	-	13.74M
Other Current Assets, Total	13.49M	43.36M	11.74M	11.26M	13.22M
Other Long-Term Assets, Total	-	-	-	-	-
Total Assets	1.64B	2.03B	1.84B	1.72B	1.64B
Liabilities
Current Portion of Long-Term Debt	223M	67.54M	140M	284M	23.33M
Current Portion of Leases	452K	452K	125K	28K	31K
Long-Term Debt	473M	791M	716M	558M	710M
Long-Term Leases	666K	570K	692K	548K	1.88M
Accounts Payable, Total	22.84M	29.16M	32.47M	41.49M	31.48M
Accrued Expenses, Total	1.04M	-	2.5M	1M	11.75M
Current Income Taxes Payable	3.75M	3.11M	4.78M	1.93M	3.87M
Other Current Liabilities - (Brok / FS / Ins. / REIT Template)	51.35M	57.74M	55.63M	55.2M	83.82M
Unearned Revenue Non Current	79.55M	84.02M	77.96M	75.18M	35.7M
Deferred Tax Liability Non-Current	7.86M	8.2M	21.88M	15.68M	15.6M
Other Non Current Liabilities	-	-	-	-	24.21M
Total Liabilities	864M	1.04B	1.05B	1.03B	942M
Common Stock, Total	509M	728M	527M	433M	443M
Retained Earnings	-	-	-	-	-
Comprehensive Income and Other	264M	259M	257M	257M	257M
Total Common Equity	773M	987M	784M	690M	700M
Total Equity	773M	987M	784M	690M	700M
Total Liabilities And Equity	1.64B	2.03B	1.84B	1.72B	1.64B
Supplemental Items
ECS Total Shares Outstanding on Filing Date	7.61B	7.7B	7.7B	7.7B	7.7B
ECS Total Common Shares Outstanding	2.93B	7.67B	7.7B	7.7B	7.7B
Book Value / Share	0.17	0.09	0.07	0.06	0.06
Tangible Book Value	770M	969M	773M	685M	700M
Tangible Book Value Per Share	0.17	0.09	0.07	0.06	0.06
Total Debt	697M	859M	857M	843M	736M
Net Debt	588M	737M	746M	702M	716M
Debt Equivalent Oper. Leases	11.97M	11.54M	11.51M	11.71M	12.55M
Account Code - Inventory Valuation	3	3	3	3	3
Machinery, Total	22.58M	24.67M	22.62M	25.17M	25.13M
Assets on Operating Lease - Gross	1.46B	1.79B	1.66B	1.53B	1.56B
Accumulated Allowance for Doubtful Accounts (Supple)	8.29M	12.05M	10.42M	8.69M	9.58M

Fiscal Period: December	2020	2021	2022	2023	2024
Net Income	-230M	-32.51M	1.58M	-126M	-36.38M
Depreciation, Depletion & Amortization	3.23M	2.75M	2.43M	2.72M	2.33M
Amortization of Goodwill and Intangible Assets - (CF)	2.2M	7.57M	6.81M	5.41M	5.17M
Total Depreciation, Depletion & Amortization	5.43M	10.32M	9.24M	8.13M	7.5M
Amortization of Deferred Charges, Total	3.35M	5.47M	6.28M	7.52M	11.7M
(Gain) Loss On Sale of Asset - (CF)	148K	-	-	-	-
Total Asset Writedown	212M	31.38M	-32.3M	134M	-29.82M
Stock-Based Compensation (CF)	2.63M	1.27M	-	-	-
Provision and Write-off of Bad Debts	-	-	-1.46M	-1.7M	1.05M
Change in Accounts Receivable	5.24M	-5.7M	13.82M	14.31M	-1.65M
Change in Accounts Payable	2.02M	1.11M	14.21M	8.37M	4.4M
Change in Other Net Operating Assets (Collected)	-2.31M	-24.57M	33.87M	2.9M	4.56M
Other Operating Activities	40.52M	53.32M	91.93M	55.6M	126M
Cash from Operations	38.94M	40.1M	137M	103M	86.94M
Acquisition of Real Estate Assets, Total	-12.39M	-17.8M	-11.39M	-15.38M	-23.07M
Sale of Real Estate Assets, Total	108M	-	-	-	-
Net Sale / Acquisition of Real Estate Assets	95.76M	-17.8M	-11.39M	-15.38M	-23.07M
Investment in Marketable and Equity Securities, Total	-	-349M	-	-	-
Other Investing Activities, Total	2.37M	1.51M	1.65M	2.14M	1.26M
Cash from Investing	98.13M	-365M	-9.74M	-13.24M	-21.81M
Short Term Debt Issued, Total	-	40M	-	-	-
Long-Term Debt Issued, Total	44M	384M	69.54M	179M	563M
Total Debt Issued	44M	424M	69.54M	179M	563M
Short Term Debt Repaid, Total	-81K	-40.1M	-234K	-337K	-2.58M
Long-Term Debt Repaid, Total	-96.87M	-219M	-96.11M	-153M	-632M
Total Debt Repaid	-96.95M	-259M	-96.34M	-154M	-635M
Issuance of Common Stock	-	281M	-	-	-
Common Dividends Paid	-37.59M	-44.68M	-44.67M	-3.08M	-
Common & Preferred Stock Dividends Paid	-37.59M	-44.68M	-44.67M	-3.08M	-
Other Financing Activities, Total	-43.42M	-62.93M	-60.19M	-173M	-1.71M
Cash from Financing	-134M	338M	-132M	-151M	-73.69M
Foreign Exchange Rate Adjustments	-2.74M	937K	-8.68M	-5.88M	-11.18M
Net Change in Cash	378K	13.74M	-12.91M	-67.25M	-19.74M
Supplemental Items
Cash Interest Paid	44.6M	54.84M	56.88M	67.77M	72.42M
Cash Income Tax Paid (Refund)	23.91M	25.2M	29.29M	28.8M	25.28M
Net Debt Issued / Repaid	-52.95M	165M	-26.8M	25.5M	-71.97M
Levered Free Cash Flow	135M	5.36M	87.83M	46.46M	121M
Unlevered Free Cash Flow	161M	37.39M	121M	83.88M	157M
Change In Net Working Capital	-115M	23.99M	-45.03M	-16.69M	-89.53M

Fiscal Period: December	2020	2021	2022	2023	2024
Profitability
Return on Assets	2.18	2.82	3.52	3.49	3.61
Return on Total Capital	2.43	3.12	3.9	3.91	4.09
Return On Equity %	-24.9	-3.69	0.18	-17.09	-5.23
Return on Common Equity	-26.82	-5.68	-1.44	-17.09	-5.23
Margin Analysis
Gross Profit Margin %	46.33	54.23	58.77	57.19	54.99
SG&A Margin	0.29	0.27	0.23	0.21	0.21
EBITDA Margin %	46.53	53.11	57.71	54.46	53.76
EBITA Margin %	44.35	51.54	56.52	53.08	52.56
EBIT Margin %	42.87	47.21	53.19	50.34	49.9
Income From Continuing Operations Margin %	-154.98	-18.57	0.77	-63.87	-18.7
Net Income Margin %	-154.98	-18.57	0.77	-63.87	-18.7
Net Avail. For Common Margin %	-166.95	-28.58	-6.22	-63.87	-18.7
Normalized Net Income Margin	1.67	8.49	4.86	1.93	-12.64
Levered Free Cash Flow Margin	91	3.06	42.9	23.55	62.1
Unlevered Free Cash Flow Margin	108.2	21.36	58.95	42.52	80.86
Asset Turnover
Asset Turnover	0.08	0.1	0.11	0.11	0.12
Fixed Assets Turnover	0.09	0.11	0.12	0.12	0.13
Receivables Turnover (Average Receivables)	5.54	5.3	5.73	6.92	8.07
Short Term Liquidity
Current Ratio	0.55	1.36	0.69	0.47	0.49
Quick Ratio	0.51	1.08	0.64	0.44	0.32
Operating Cash Flow to Current Liabilities	0.13	0.25	0.58	0.27	0.56
Days Sales Outstanding (Average Receivables)	66.06	68.87	63.73	52.71	45.34
Average Days Payable Outstanding	116.94	118.44	133.26	159.83	138.3
Long Term Solvency
Total Debt/Equity	90.21	87	109.3	122.07	105.08
Total Debt / Total Capital	47.43	46.52	52.22	54.97	51.24
LT Debt/Equity	61.29	80.12	91.39	80.94	101.74
Long-Term Debt / Total Capital	32.22	42.84	43.66	36.45	49.61
Total Liabilities / Total Assets	52.77	51.33	57.3	59.95	57.37
EBIT / Interest Expense	1.38	1.38	1.74	1.38	1.26
EBITDA / Interest Expense	1.49	1.55	1.89	1.49	1.36
(EBITDA - Capex) / Interest Expense	1.45	1.52	1.86	1.45	1.35
Total Debt / EBITDA	10.09	9.24	7.25	7.84	7.03
Net Debt / EBITDA	8.51	7.93	6.31	6.54	6.84
Total Debt / (EBITDA - Capex)	10.37	9.43	7.35	8.07	7.06
Net Debt / (EBITDA - Capex)	8.75	8.09	6.4	6.72	6.87
Growth Over Prior Year
Total Revenues, 1 Yr. Growth %	-45.59	17.86	16.93	-3.64	-1.37
Gross Profit, 1 Yr. Growth %	-58.04	37.98	26.71	-6.22	-5.17
EBITDA, 1 Yr. Growth %	-57.49	34.53	27.06	-9.06	-2.65
EBITA, 1 Yr. Growth %	-58.6	36.95	28.24	-9.5	-2.34
EBIT, 1 Yr. Growth %	-59.13	29.79	31.74	-8.8	-2.23
Earnings From Cont. Operations, 1 Yr. Growth %	-1.81K	-85.88	-104.87	-8.06K	-71.12
Net Income, 1 Yr. Growth %	-1.81K	-85.88	-104.87	-8.06K	-71.12
Diluted EPS Before Extra, 1 Yr. Growth %	5.71K	-92.04	-75.52	889	-71.13
Normalized Net Income, 1 Yr. Growth %	-96.29	499.14	-33.07	15.6	-745.92
Net Property, Plant and Equip., 1 Yr. Growth %	-14.06	22.41	-7.48	-7.46	1.85
Accounts Receivable, 1 Yr. Growth %	3.43	42.35	-15.78	-25.65	-1.61
Total Assets, 1 Yr. Growth %	-18.7	23.97	-9.52	-6.12	-4.72
Common Equity, 1 Yr. Growth %	-28.16	27.75	-20.63	-11.93	1.41
Tangible Book Value, 1 Yr. Growth %	-28.09	25.89	-20.19	-11.41	2.18
Cash From Operations, 1 Yr. Growth %	-71.53	2.97	242.11	-25.16	-15.32
Capital Expenditures, 1 Yr. Growth %	-32.1	-1.37	-11.44	81.23	-86.71
Levered Free Cash Flow, 1 Yr. Growth %	-427	-96.04	-607.16	-47.11	-537.75
Unlevered Free Cash Flow, 1 Yr. Growth %	-929.91	-76.73	719.83	-30.49	1.5K
Dividend Per Share, 1 Yr. Growth %	-84.75	2.94	-11.43	-	-
Compound Annual Growth Rate Over Two Years
Total Revenues, 2 Yr. CAGR %	-19.69	-19.92	17.4	6.15	-2.51
Gross Profit, 2 Yr. CAGR %	-33.02	-23.91	32.23	9.01	-5.7
EBITDA, 2 Yr. CAGR %	-33.03	-24.37	30.74	7.5	-5.91
EBITA, 2 Yr. CAGR %	-33.97	-24.7	32.53	7.73	-5.99
EBIT, 2 Yr. CAGR %	-34.51	-27.16	30.76	9.61	-5.57
Earnings From Cont. Operations, 2 Yr. CAGR %	94.37	55.19	-91.71	96.85	379.39
Net Income, 2 Yr. CAGR %	94.37	55.19	-91.71	96.85	379.39
Diluted EPS Before Extra, 2 Yr. CAGR %	136.37	115.1	-86.04	55.61	68.98
Normalized Net Income, 2 Yr. CAGR %	-80.19	-52.86	100.25	-49.38	173.26
Net Property, Plant and Equip., 2 Yr. CAGR %	-10.76	2.56	6.42	-7.47	-2.92
Accounts Receivable, 2 Yr. CAGR %	3.31	21.34	9.49	-20.87	-14.47
Total Assets, 2 Yr. CAGR %	-8.76	0.39	5.91	-7.84	-5.42
Common Equity, 2 Yr. CAGR %	-15.37	-4.2	0.7	-16.39	-5.5
Tangible Book Value, 2 Yr. CAGR %	-15.21	-4.85	0.24	-15.92	-4.86
Cash From Operations, 2 Yr. CAGR %	-47.55	-45.86	87.69	60.01	-20.39
Capital Expenditures, 2 Yr. CAGR %	-32.08	-18.17	-6.54	26.69	-50.93
Levered Free Cash Flow, 2 Yr. CAGR %	13.74	-64.01	-19.39	63.79	17.29
Unlevered Free Cash Flow, 2 Yr. CAGR %	14.57	38.96	-13.35	138.72	14.17
Dividend Per Share, 2 Yr. CAGR %	-59.27	-60.38	-4.51	-	-
Compound Annual Growth Rate Over Three Years
Total Revenues, 3 Yr. CAGR %	-9.04	-8.74	-9.15	9.92	3.58
Gross Profit, 3 Yr. CAGR %	-26.28	-14.77	-9.81	17.92	4.06
EBITDA, 3 Yr. CAGR %	-26.16	-15.5	-10.09	15.84	4
EBITA, 3 Yr. CAGR %	-26.98	-15.79	-10.08	16.7	4.26
EBIT, 3 Yr. CAGR %	-25.85	-17.74	-11.26	15.96	5.51
Earnings From Cont. Operations, 3 Yr. CAGR %	54.26	-18.89	-51.05	-18.2	3.82
Net Income, 3 Yr. CAGR %	54.26	-18.89	-51.05	-18.2	3.82
Diluted EPS Before Extra, 3 Yr. CAGR %	70.09	-23.67	4.24	-42.24	-11.25
Normalized Net Income, 3 Yr. CAGR %	-67.9	-38.28	-47.02	15.36	18.28
Net Property, Plant and Equip., 3 Yr. CAGR %	-8.55	-0.85	-0.9	1.58	-4.46
Accounts Receivable, 3 Yr. CAGR %	0.32	14.96	7.43	-3.76	-14.91
Total Assets, 3 Yr. CAGR %	-7.44	1.05	-3.03	1.74	-6.81
Common Equity, 3 Yr. CAGR %	-12.85	-2.92	-10.02	-3.7	-10.84
Tangible Book Value, 3 Yr. CAGR %	-12.68	-3.27	-10.27	-3.81	-10.27
Cash From Operations, 3 Yr. CAGR %	-34.87	-34.33	0.1	38.14	29.43
Capital Expenditures, 3 Yr. CAGR %	-30.41	-23.09	-15.98	16.55	-40.26
Levered Free Cash Flow, 3 Yr. CAGR %	16.31	-62.85	28.56	-29.95	91.08
Unlevered Free Cash Flow, 3 Yr. CAGR %	16.71	-32.66	84.02	-19.49	120.27
Dividend Per Share, 3 Yr. CAGR %	-53.76	-44.52	-48.2	-	-
Compound Annual Growth Rate Over Five Years
Total Revenues, 5 Yr. CAGR %	-3	-1.42	0.73	-3.05	-6.55
Gross Profit, 5 Yr. CAGR %	-14.13	-9.9	-6.87	-5.96	-8.19
EBITDA, 5 Yr. CAGR %	-13.88	-10.22	-7.2	-6.96	-8.44
EBITA, 5 Yr. CAGR %	-14.58	-10.56	-7.32	-7.07	-8.47
EBIT, 5 Yr. CAGR %	-13.75	-10.73	-6.96	-7.73	-9.03
Earnings From Cont. Operations, 5 Yr. CAGR %	54.15	2.43	-52.09	15.64	21.93
Net Income, 5 Yr. CAGR %	54.15	2.43	-52.09	15.64	21.93
Diluted EPS Before Extra, 5 Yr. CAGR %	54.55	-6.33	-37.43	1.49	26.46
Normalized Net Income, 5 Yr. CAGR %	-47.3	-25.18	-33.23	-42.98	-18.13
Net Property, Plant and Equip., 5 Yr. CAGR %	-4.12	-1.43	-2.83	-3.55	-1.71
Accounts Receivable, 5 Yr. CAGR %	30.27	34.81	3.89	-0.99	-1.93
Total Assets, 5 Yr. CAGR %	-3.81	-0.36	-2.32	-2.6	-3.99
Common Equity, 5 Yr. CAGR %	-6.39	-4.34	-7.67	-8.55	-8.24
Tangible Book Value, 5 Yr. CAGR %	-6.02	-4.4	-7.73	-8.54	-8.14
Cash From Operations, 5 Yr. CAGR %	-20.85	-21.19	-0.54	-6.23	-8.67
Capital Expenditures, 5 Yr. CAGR %	2.85	-12.41	-21.7	-6.09	-32.24
Levered Free Cash Flow, 5 Yr. CAGR %	13.96	-43.54	0.44	-14.96	23.93
Unlevered Free Cash Flow, 5 Yr. CAGR %	11.69	-19.31	3.6	-7.28	52.04
Dividend Per Share, 5 Yr. CAGR %	-35.73	-36.57	-38.2	-	-