Lippo Malls Indonesia Retail Trust
SGX:D5IU
Income Statement
Earnings Waterfall
Lippo Malls Indonesia Retail Trust
Revenue
|
197.3m
SGD
|
Cost of Revenue
|
-74.9m
SGD
|
Gross Profit
|
122.4m
SGD
|
Operating Expenses
|
-2.1m
SGD
|
Operating Income
|
120.2m
SGD
|
Other Expenses
|
-246.2m
SGD
|
Net Income
|
-126m
SGD
|
Income Statement
Lippo Malls Indonesia Retail Trust
Dec-2013 | Mar-2014 | Jun-2014 | Sep-2014 | Dec-2014 | Mar-2015 | Jun-2015 | Sep-2015 | Dec-2015 | Mar-2016 | Jun-2016 | Sep-2016 | Dec-2016 | Mar-2017 | Jun-2017 | Sep-2017 | Dec-2017 | Mar-2018 | Jun-2018 | Sep-2018 | Dec-2018 | Mar-2019 | Jun-2019 | Sep-2019 | Dec-2019 | Mar-2020 | Jun-2020 | Sep-2020 | Dec-2020 | Mar-2021 | Jun-2021 | Sep-2021 | Dec-2021 | Mar-2022 | Jun-2022 | Sep-2022 | Dec-2022 | Mar-2023 | Jun-2023 | Sep-2023 | Dec-2023 | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Revenue | ||||||||||||||||||||||||||||||||||||||||||
Revenue |
153
N/A
|
147
-4%
|
141
-4%
|
135
-4%
|
137
+2%
|
145
+6%
|
154
+6%
|
164
+7%
|
173
+5%
|
177
+2%
|
181
+3%
|
184
+2%
|
188
+2%
|
191
+2%
|
194
+2%
|
197
+1%
|
197
+0%
|
198
+0%
|
201
+1%
|
216
+8%
|
230
+7%
|
247
+7%
|
263
+6%
|
267
+2%
|
273
+2%
|
272
0%
|
231
-15%
|
191
-17%
|
149
-22%
|
127
-14%
|
149
+18%
|
152
+1%
|
175
+16%
|
182
+4%
|
184
+1%
|
205
+11%
|
205
0%
|
203
-1%
|
202
0%
|
200
-1%
|
197
-1%
|
|
Gross Profit | ||||||||||||||||||||||||||||||||||||||||||
Cost of Revenue |
(9)
|
(9)
|
(10)
|
(11)
|
(11)
|
(11)
|
(12)
|
(13)
|
(14)
|
(16)
|
(17)
|
(17)
|
(16)
|
(14)
|
(13)
|
(13)
|
(13)
|
(16)
|
(22)
|
(44)
|
(65)
|
(86)
|
(100)
|
(100)
|
(97)
|
(97)
|
(87)
|
(77)
|
(73)
|
(65)
|
(68)
|
(66)
|
(71)
|
(73)
|
(72)
|
(77)
|
(74)
|
(73)
|
(74)
|
(74)
|
(75)
|
|
Gross Profit |
143
N/A
|
137
-4%
|
130
-5%
|
124
-5%
|
126
+1%
|
134
+6%
|
142
+6%
|
151
+7%
|
159
+5%
|
160
+1%
|
164
+3%
|
167
+2%
|
172
+3%
|
177
+3%
|
181
+2%
|
184
+2%
|
184
+0%
|
182
-1%
|
178
-2%
|
171
-4%
|
165
-4%
|
162
-2%
|
162
+1%
|
167
+3%
|
176
+6%
|
175
0%
|
144
-18%
|
113
-21%
|
76
-33%
|
63
-17%
|
82
+30%
|
86
+5%
|
104
+21%
|
110
+5%
|
113
+3%
|
128
+14%
|
130
+2%
|
130
0%
|
128
-2%
|
126
-2%
|
122
-3%
|
|
Operating Income | ||||||||||||||||||||||||||||||||||||||||||
Operating Expenses |
(12)
|
(12)
|
(11)
|
(11)
|
(11)
|
(15)
|
(18)
|
(22)
|
(25)
|
(25)
|
(25)
|
(26)
|
(26)
|
(27)
|
(28)
|
(29)
|
(29)
|
(27)
|
(24)
|
(21)
|
(16)
|
(16)
|
(16)
|
(17)
|
(22)
|
(22)
|
(20)
|
(19)
|
(16)
|
(17)
|
(20)
|
(24)
|
(22)
|
5
|
6
|
9
|
(11)
|
(10)
|
(11)
|
(14)
|
(2)
|
|
Selling, General & Administrative |
(11)
|
(10)
|
(10)
|
(10)
|
(10)
|
(10)
|
(11)
|
(11)
|
(12)
|
(12)
|
(12)
|
(12)
|
(12)
|
(13)
|
(13)
|
(13)
|
(13)
|
(13)
|
(13)
|
(12)
|
(12)
|
(12)
|
(12)
|
(12)
|
(13)
|
(13)
|
(11)
|
(10)
|
(8)
|
(8)
|
(9)
|
(9)
|
(10)
|
(10)
|
(10)
|
(11)
|
(11)
|
(11)
|
(10)
|
(10)
|
(10)
|
|
Depreciation & Amortization |
0
|
0
|
0
|
0
|
0
|
(3)
|
(6)
|
(8)
|
(11)
|
(12)
|
(12)
|
(12)
|
(12)
|
(12)
|
(13)
|
(13)
|
(13)
|
(10)
|
(8)
|
(5)
|
(3)
|
(2)
|
(2)
|
(2)
|
(3)
|
(3)
|
(3)
|
(3)
|
(2)
|
(3)
|
(5)
|
(6)
|
(8)
|
(8)
|
(8)
|
(7)
|
(7)
|
(6)
|
(6)
|
(6)
|
(5)
|
|
Other Operating Expenses |
(1)
|
(1)
|
(1)
|
(1)
|
(1)
|
(2)
|
(2)
|
(2)
|
(2)
|
(2)
|
(2)
|
(2)
|
(2)
|
(2)
|
(2)
|
(3)
|
(4)
|
(4)
|
(4)
|
(3)
|
(2)
|
(2)
|
(2)
|
(2)
|
(6)
|
(7)
|
(6)
|
(6)
|
(6)
|
(6)
|
(7)
|
(9)
|
(5)
|
22
|
23
|
27
|
6
|
6
|
5
|
2
|
13
|
|
Operating Income |
131
N/A
|
125
-4%
|
119
-5%
|
113
-5%
|
115
+2%
|
119
+4%
|
124
+4%
|
130
+5%
|
133
+3%
|
135
+1%
|
139
+3%
|
142
+2%
|
146
+3%
|
150
+3%
|
153
+2%
|
155
+1%
|
155
0%
|
155
+0%
|
154
-1%
|
151
-2%
|
148
-2%
|
145
-2%
|
146
+1%
|
150
+3%
|
154
+2%
|
153
0%
|
124
-19%
|
95
-24%
|
60
-37%
|
46
-23%
|
62
+35%
|
62
+1%
|
82
+32%
|
114
+39%
|
118
+3%
|
137
+16%
|
119
-13%
|
120
+0%
|
117
-2%
|
112
-4%
|
120
+8%
|
|
Pre-Tax Income | ||||||||||||||||||||||||||||||||||||||||||
Interest Income Expense |
(60)
|
(56)
|
(53)
|
(47)
|
(26)
|
(21)
|
(26)
|
(31)
|
(89)
|
(89)
|
(89)
|
(93)
|
(92)
|
(89)
|
(89)
|
(86)
|
(67)
|
(68)
|
(70)
|
(72)
|
(49)
|
(47)
|
(54)
|
(48)
|
(115)
|
(135)
|
(132)
|
(321)
|
(268)
|
(257)
|
(285)
|
(99)
|
(90)
|
(128)
|
(111)
|
(143)
|
(71)
|
(53)
|
(46)
|
(38)
|
(227)
|
|
Non-Reccuring Items |
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
|
Total Other Income |
9
|
2
|
0
|
(10)
|
1
|
(4)
|
(3)
|
1
|
0
|
0
|
(0)
|
(0)
|
0
|
(0)
|
(0)
|
(0)
|
0
|
0
|
(0)
|
(0)
|
0
|
0
|
1
|
1
|
1
|
0
|
(0)
|
(2)
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
2
|
2
|
2
|
0
|
|
Pre-Tax Income |
81
N/A
|
72
-11%
|
67
-7%
|
57
-15%
|
90
+59%
|
94
+4%
|
94
+1%
|
100
+6%
|
44
-56%
|
46
+4%
|
50
+8%
|
48
-3%
|
53
+11%
|
61
+15%
|
64
+5%
|
69
+7%
|
88
+28%
|
87
-1%
|
84
-4%
|
79
-6%
|
100
+26%
|
98
-1%
|
93
-6%
|
104
+12%
|
39
-62%
|
18
-53%
|
(8)
N/A
|
(228)
-2 612%
|
(208)
+9%
|
(211)
-1%
|
(223)
-6%
|
(35)
+84%
|
(8)
+78%
|
(14)
-78%
|
7
N/A
|
(6)
N/A
|
48
N/A
|
69
+42%
|
73
+7%
|
76
+4%
|
(106)
N/A
|
|
Net Income | ||||||||||||||||||||||||||||||||||||||||||
Tax Provision |
(11)
|
(10)
|
(8)
|
(7)
|
(26)
|
(27)
|
(28)
|
(31)
|
(18)
|
(19)
|
(19)
|
(19)
|
(25)
|
(25)
|
(26)
|
(26)
|
(25)
|
(27)
|
(29)
|
(30)
|
(39)
|
(38)
|
(37)
|
(37)
|
(26)
|
(25)
|
(19)
|
(16)
|
(22)
|
(20)
|
(21)
|
(19)
|
(25)
|
(26)
|
(27)
|
(31)
|
(47)
|
(47)
|
(47)
|
(45)
|
(20)
|
|
Income from Continuing Operations |
70
|
63
|
59
|
50
|
64
|
66
|
66
|
69
|
26
|
27
|
30
|
29
|
29
|
37
|
39
|
43
|
63
|
60
|
55
|
48
|
61
|
60
|
56
|
67
|
14
|
(6)
|
(27)
|
(244)
|
(230)
|
(231)
|
(244)
|
(54)
|
(33)
|
(39)
|
(20)
|
(37)
|
2
|
22
|
26
|
31
|
(126)
|
|
Net Income (Common) |
70
N/A
|
63
-11%
|
59
-6%
|
50
-16%
|
64
+29%
|
66
+4%
|
66
-1%
|
69
+5%
|
26
-62%
|
27
+4%
|
30
+11%
|
29
-6%
|
26
-8%
|
32
+20%
|
31
-1%
|
31
0%
|
49
+57%
|
44
-9%
|
38
-15%
|
31
-19%
|
43
+41%
|
43
-1%
|
38
-11%
|
49
+30%
|
(4)
N/A
|
(24)
-470%
|
(45)
-87%
|
(260)
-476%
|
(248)
+4%
|
(249)
0%
|
(262)
-6%
|
(74)
+72%
|
(50)
+32%
|
(57)
-13%
|
(37)
+34%
|
(54)
-45%
|
(13)
+76%
|
12
N/A
|
20
+68%
|
29
+45%
|
(126)
N/A
|
|
EPS (Diluted) |
0.03
N/A
|
0.02
-33%
|
0.02
N/A
|
0.02
N/A
|
0.03
+50%
|
0.04
+33%
|
0.04
N/A
|
0.04
N/A
|
0.01
-75%
|
0.02
+100%
|
0.02
N/A
|
0.02
N/A
|
0.01
-50%
|
0.02
+100%
|
0.02
N/A
|
0.02
N/A
|
0.02
N/A
|
0.03
+50%
|
0.02
-33%
|
0.01
-50%
|
0.01
N/A
|
0.01
N/A
|
0.01
N/A
|
0.02
+100%
|
0
N/A
|
-0.01
N/A
|
-0.01
N/A
|
-0.08
-700%
|
-0.03
+63%
|
-0.03
N/A
|
-0.03
N/A
|
-0.01
+67%
|
-0.01
N/A
|
-0.01
N/A
|
0
N/A
|
-0.01
N/A
|
0
N/A
|
0
N/A
|
0
N/A
|
0
N/A
|
-0.02
N/A
|