Mapletree Pan Asia Commercial Trust
SGX:N2IU
Income Statement
Earnings Waterfall
Mapletree Pan Asia Commercial Trust
Revenue
|
952.1m
SGD
|
Cost of Revenue
|
-281.3m
SGD
|
Gross Profit
|
670.8m
SGD
|
Operating Expenses
|
-2.9m
SGD
|
Operating Income
|
667.9m
SGD
|
Other Expenses
|
-313.6m
SGD
|
Net Income
|
354.3m
SGD
|
Income Statement
Mapletree Pan Asia Commercial Trust
Sep-2012 | Dec-2012 | Mar-2013 | Jun-2013 | Sep-2013 | 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 | Sep-2020 | Mar-2021 | Sep-2021 | Mar-2022 | Sep-2022 | Dec-2022 | Mar-2023 | Jun-2023 | Sep-2023 | Dec-2023 | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Revenue | ||||||||||||||||||||||||||||||||||||||||||
Revenue |
212
N/A
|
218
+3%
|
220
+1%
|
233
+6%
|
247
+6%
|
259
+5%
|
267
+3%
|
272
+2%
|
276
+2%
|
280
+2%
|
282
+1%
|
284
+0%
|
285
+0%
|
286
+0%
|
288
+1%
|
292
+1%
|
308
+6%
|
343
+11%
|
378
+10%
|
412
+9%
|
431
+5%
|
432
+0%
|
434
+0%
|
434
+0%
|
437
+1%
|
440
+1%
|
444
+1%
|
447
+1%
|
450
+0%
|
468
+4%
|
483
+3%
|
477
-1%
|
476
0%
|
504
+6%
|
499
-1%
|
609
+22%
|
849
+39%
|
826
-3%
|
1 063
+29%
|
950
-11%
|
952
+0%
|
|
Gross Profit | ||||||||||||||||||||||||||||||||||||||||||
Cost of Revenue |
(71)
|
(71)
|
(71)
|
(74)
|
(77)
|
(84)
|
(90)
|
(90)
|
(90)
|
(90)
|
(90)
|
(89)
|
(88)
|
(87)
|
(87)
|
(89)
|
(93)
|
(103)
|
(112)
|
(121)
|
(125)
|
(125)
|
(125)
|
(124)
|
(126)
|
(127)
|
(128)
|
(130)
|
(130)
|
(136)
|
(141)
|
(142)
|
(141)
|
(148)
|
(150)
|
(178)
|
(252)
|
(245)
|
(315)
|
(284)
|
(281)
|
|
Gross Profit |
142
N/A
|
147
+4%
|
149
+1%
|
159
+7%
|
170
+7%
|
175
+3%
|
177
+1%
|
181
+2%
|
185
+2%
|
190
+3%
|
192
+1%
|
195
+1%
|
197
+1%
|
199
+1%
|
201
+1%
|
202
+1%
|
215
+6%
|
240
+12%
|
266
+11%
|
292
+10%
|
306
+5%
|
308
+0%
|
308
+0%
|
310
+0%
|
311
+0%
|
313
+1%
|
316
+1%
|
318
+1%
|
319
+0%
|
333
+4%
|
342
+3%
|
335
-2%
|
336
+0%
|
356
+6%
|
350
-2%
|
431
+23%
|
597
+38%
|
582
-2%
|
748
+29%
|
666
-11%
|
671
+1%
|
|
Operating Income | ||||||||||||||||||||||||||||||||||||||||||
Operating Expenses |
(9)
|
(9)
|
(9)
|
(9)
|
(9)
|
(5)
|
(4)
|
(1)
|
(1)
|
(2)
|
(6)
|
(1)
|
(1)
|
(1)
|
(2)
|
(1)
|
(2)
|
(2)
|
(2)
|
(2)
|
(1)
|
(1)
|
(1)
|
(1)
|
(1)
|
(1)
|
(1)
|
(1)
|
(1)
|
(1)
|
(4)
|
(1)
|
(4)
|
(1)
|
(5)
|
(3)
|
(3)
|
(14)
|
(4)
|
(2)
|
(3)
|
|
Selling, General & Administrative |
(9)
|
(9)
|
(9)
|
(9)
|
(9)
|
(5)
|
(1)
|
(1)
|
(2)
|
(2)
|
(1)
|
(1)
|
(1)
|
(1)
|
(1)
|
(1)
|
(2)
|
(1)
|
(1)
|
(1)
|
(1)
|
(1)
|
(1)
|
(1)
|
(1)
|
(1)
|
(1)
|
(1)
|
(1)
|
(1)
|
(1)
|
(1)
|
(1)
|
(1)
|
(1)
|
(3)
|
(3)
|
(3)
|
(4)
|
(2)
|
(3)
|
|
Other Operating Expenses |
0
|
0
|
0
|
0
|
0
|
0
|
(3)
|
0
|
0
|
0
|
(4)
|
0
|
0
|
0
|
(1)
|
0
|
0
|
0
|
(1)
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
(3)
|
0
|
(3)
|
0
|
(3)
|
0
|
0
|
(11)
|
0
|
0
|
0
|
|
Operating Income |
133
N/A
|
138
+4%
|
140
+1%
|
150
+7%
|
161
+7%
|
170
+6%
|
173
+2%
|
180
+4%
|
184
+2%
|
189
+3%
|
187
-1%
|
194
+4%
|
196
+1%
|
198
+1%
|
198
+0%
|
201
+1%
|
213
+6%
|
239
+12%
|
264
+11%
|
290
+10%
|
305
+5%
|
307
+0%
|
307
+0%
|
309
+1%
|
310
+0%
|
312
+1%
|
315
+1%
|
317
+1%
|
318
+0%
|
331
+4%
|
338
+2%
|
334
-1%
|
331
-1%
|
355
+7%
|
345
-3%
|
428
+24%
|
593
+39%
|
568
-4%
|
745
+31%
|
664
-11%
|
668
+1%
|
|
Pre-Tax Income | ||||||||||||||||||||||||||||||||||||||||||
Interest Income Expense |
45
|
174
|
171
|
168
|
166
|
(29)
|
171
|
167
|
168
|
168
|
(31)
|
119
|
119
|
117
|
100
|
100
|
95
|
90
|
82
|
(54)
|
(53)
|
(65)
|
260
|
260
|
257
|
257
|
267
|
267
|
572
|
569
|
205
|
(312)
|
(265)
|
(19)
|
2
|
94
|
48
|
(83)
|
(144)
|
(299)
|
(308)
|
|
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
|
3
|
0
|
0
|
(0)
|
(0)
|
0
|
0
|
0
|
(0)
|
|
Total Other Income |
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
156
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
129
|
126
|
136
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
|
Pre-Tax Income |
178
N/A
|
312
+76%
|
311
0%
|
318
+2%
|
326
+3%
|
140
-57%
|
343
+145%
|
347
+1%
|
351
+1%
|
356
+1%
|
312
-12%
|
313
+0%
|
315
+1%
|
315
+0%
|
299
-5%
|
301
+1%
|
309
+3%
|
329
+7%
|
346
+5%
|
365
+6%
|
378
+3%
|
377
0%
|
568
+50%
|
568
+0%
|
568
0%
|
568
+0%
|
582
+2%
|
584
+0%
|
890
+52%
|
900
+1%
|
543
-40%
|
21
-96%
|
69
+222%
|
336
+390%
|
347
+3%
|
522
+50%
|
641
+23%
|
485
-24%
|
600
+24%
|
365
-39%
|
360
-2%
|
|
Net Income | ||||||||||||||||||||||||||||||||||||||||||
Tax Provision |
209
|
209
|
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)
|
(9)
|
(18)
|
2
|
(6)
|
(4)
|
0
|
|
Income from Continuing Operations |
387
|
521
|
311
|
318
|
326
|
140
|
343
|
347
|
351
|
356
|
312
|
313
|
315
|
315
|
299
|
301
|
309
|
329
|
346
|
365
|
378
|
377
|
568
|
568
|
568
|
568
|
582
|
584
|
890
|
900
|
543
|
21
|
69
|
336
|
347
|
512
|
623
|
487
|
594
|
362
|
360
|
|
Income to Minority Interest |
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)
|
(1)
|
(1)
|
(1)
|
(1)
|
|
Net Income (Common) |
387
N/A
|
521
+35%
|
311
-40%
|
318
+2%
|
326
+3%
|
140
-57%
|
343
+145%
|
347
+1%
|
351
+1%
|
356
+1%
|
312
-12%
|
313
+0%
|
315
+1%
|
315
+0%
|
299
-5%
|
301
+1%
|
309
+3%
|
329
+7%
|
346
+5%
|
365
+6%
|
378
+3%
|
377
0%
|
568
+50%
|
568
+0%
|
568
0%
|
568
+0%
|
582
+2%
|
584
+0%
|
890
+52%
|
900
+1%
|
543
-40%
|
21
-96%
|
69
+222%
|
336
+390%
|
347
+3%
|
511
+47%
|
621
+21%
|
483
-22%
|
589
+22%
|
356
-40%
|
354
0%
|
|
EPS (Diluted) |
0.2
N/A
|
0.27
+35%
|
0.16
-41%
|
0.17
+6%
|
0.15
-12%
|
0.08
-47%
|
0.16
+100%
|
0.17
+6%
|
0.17
N/A
|
0.17
N/A
|
0.15
-12%
|
0.15
N/A
|
0.15
N/A
|
0.15
N/A
|
0.14
-7%
|
0.14
N/A
|
0.14
N/A
|
0.11
-21%
|
0.13
+18%
|
0.13
N/A
|
0.13
N/A
|
0.13
N/A
|
0.2
+54%
|
0.19
-5%
|
0.19
N/A
|
0.19
N/A
|
0.2
+5%
|
0.2
N/A
|
0.31
+55%
|
0.28
-10%
|
0.18
-36%
|
0.01
-94%
|
0.02
+100%
|
0.1
+400%
|
0.1
N/A
|
0.14
+40%
|
0.11
-21%
|
0.1
-9%
|
0.11
+10%
|
0.07
-36%
|
0.07
N/A
|