Excel - 13132110014 - Draft Paper Individu - FNT 4A-1
Excel - 13132110014 - Draft Paper Individu - FNT 4A-1
Excel - 13132110014 - Draft Paper Individu - FNT 4A-1
Income Statement
Figures presented in mn Rupiah
2018 2019 2020 2021 2022 2023 F
Net revenue 106,741,891 106,055,176 92,245,210 98,874,784 111,211,321 118,262,301
Cost Of Goods Sold (81,251,100) (79,932,195) (73,653,975) (81,955,013) (94,053,123) (99,084,206)
Gross Profit 25,490,791 26,122,981 18,771,235 16,813,347 17,158,198 19,178,095
Selling expenses (6,296,611) (6,621,032) (6,258,339) (6,202,849) (6,739,702) (7,209,502)
General and administrative expenses (2,312,252) (2,424,862) (2,110,740) (2,113,563) (2,665,313) (2,851,102)
Operating expenses (8,608,863) (9,045,894) (8,369,079) (8,316,412) (9,405,015) (10,060,604)
Operating Profit 16,881,928 17,077,087 10,402,156 8,496,935 7,753,183 9,117,490
Other income 208,891 100,120 84,396 139,174 257,612 310,571
Other expenses (110,036) (74,773) (44,199) (5,379) (156,088) (78,095)
Finance income 1,003,937 1,198,798 765,556 483,575 463,898 553,939
Finance cost (30,495) (53,454) (49,983) (56,528) (50,049) (110,266)
Share of net results of associate 7,044 11,645 3,539 7,965 4,503 3,439
Profit before income taxes 17,961,269 18,259,423 11,161,466 9,152,166 8,273,059 9,797,079
Income tax expenses (4,422,851) (4,537,910) (2,580,088) (2,015,069) (1,949,315) (2,315,489)
Profit for the year 13,538,418 13,721,513 8,581,378 7,137,097 6,323,744 7,481,589
Other Comprehensive Income
Items that will not be reclassified to profit or loss:
Re-measurements on liabilities for employee bene 1,223,555 279,806 (130,614) 289,651 45,231
Related income tax (expense)/benefit (31,150) (69,546) 28,388 (63,665) (9,959)
Total 91,205 210,260 (102,226) 225,986 35,272
Items that will be reclassified to profit or loss:
Cash flow hedging reserve - (761) 760 1
Related income tax (expense)/benefit - 168 (168)
Cumulative translation adjustments (372) 257 (254) (7) 105
Total (372) 257 (847) 585 106
Other Comprehensive Income for the year, Net of 90,833 210,517 (103,073) 226,571 35,378
Total Comprehensive Income for the Year 13,629,251 13,932,030 8,478,305 7,363,668 6,359,122
Net Income for the year attributable to:
Owners of parent entity 13,538,418 13,721,513 8,581,378 7,137,097 6,323,744
Non-controlling interests - - - - -
Total comprehensive Income for the year attributable to:
Owners of parent entity 13,629,251 13,932,030 8,478,305 7,363,668 6,359,122
Non-controlling interests - - - - -
Total 13,629,251 13,932,030 8,478,305 7,363,668 6,359,122
Basic and diluted earnings per share 116 118 74 61 54
2023F
6.34%
16.22%
-8.51%
20.56%
-57.04%
-22.75%
19.41%
-23.63%
6.33%
PT HANJAYA MANDALA SAMPOERNA Tbk.
Income Statement
Vertical Analysis
Average 2018 2019 2020 2021 2022
1.50% Net revenue 100.00% 100.00% 100.00% 100.00% 100.00%
4.14% Cost Of Goods Sold -76.12% -75.37% -79.85% -82.89% -84.57%
-8.51% Gross Profit 23.88% 24.63% 20.35% 17.00% 15.43%
1.86% Selling expenses -5.90% -6.24% -6.78% -6.27% -6.06%
4.54% General and administrative expenses -2.17% -2.29% -2.29% -2.14% -2.40%
2.51%
-16.25% Operating Profit 15.82% 16.10% 11.28% 8.59% 6.97%
20.56% Other income 0.20% 0.09% 0.09% 0.14% 0.23%
660.26% Other expenses -0.10% -0.07% -0.05% -0.01% -0.14%
-14.41% Finance income 0.94% 1.13% 0.83% 0.49% 0.42%
17.61% Finance cost -0.03% -0.05% -0.05% -0.06% -0.05%
19.33% Share of net results of associate 0.01% 0.01% 0.00% 0.01% 0.00%
-22.16% Profit before income taxes 16.83% 17.22% 12.10% 9.26% 7.44%
-16.43% Income tax expenses -4.14% -4.28% -2.80% -2.04% -1.75%
-16.08% Profit for the year 12.68% 12.94% 9.30% 7.22% 5.69%
Other Comprehensive Income
Items that will not be reclassified to profit or loss:
-157.49% Re-measurements on liabilities for employee benefits 1.15% 0.26% -0.14% 0.29% 0.04%
-106.55% Related income tax (expense)/benefit -0.03% -0.07% 0.03% -0.06% -0.01%
-105.89% Total 0.09% 0.20% -0.11% 0.23% 0.03%
Items that will be reclassified to profit or loss:
Cash flow hedging reserve 0.00% #VALUE! 0.00% 0.00% 0.00%
Related income tax (expense)/benefit 0.00% #VALUE! 0.00% 0.00% 0.00%
-516.29% Cumulative translation adjustments 0.00% 0.00% 0.00% 0.00% 0.00%
-212.40% Total 0.00% 0.00% 0.00% 0.00% 0.00%
-105.35% Other Comprehensive Income for the year, Net of Tax 0.09% 0.20% -0.11% 0.23% 0.03%
-15.93% Total Comprehensive Income for the Year 12.77% 13.14% 9.19% 7.45% 5.72%
Net Income for the year attributable to:
-16.08% Owners of parent entity 12.68% 12.94% 9.30% 7.22% 5.69%
Non-controlling interests
Total comprehensive Income for the year attributable t 0.00% 0.00% 0.00% 0.00% 0.00%
-15.93% Owners of parent entity 12.77% 13.14% 9.19% 7.45% 5.72%
Non-controlling interests
-15.93% Total 12.77% 13.14% 9.19% 7.45% 5.72%
-16.15% Ratios
GPM 23.88% 24.63% 20.35% 17.00% 15.43%
NPM 12.68% 12.94% 9.30% 7.22% 5.69%
OPM 15.82% 16.10% 11.28% 8.59% 6.97%
Net revenue breakdown
-7.90% Export 0.38% 0.38% 0.24% 0.16% 0.20%
#DIV/0! Local
0.06% Machine-made clove cigarettes 69.60% 70.15% 66.38% 65.99% 65.26%
7.51% Hand-rolled clove cigarettes 19.31% 18.57% 23.26% 23.14% 24.46%
-3.44% White cigarettes 10.22% 10.44% 9.67% 9.53% 8.35%
#DIV/0! Hand-rolled white cigarettes 0.00% 0.00% 0.02% 0.55% 0.77%
22.91% Others 0.50% 0.46% 0.63% 0.64% 0.97%
1.49% Total 100.00% 100.00% 100.20% 100.00% 100.00%
11.75%
0.15%
-0.07%
0.76%
-0.05%
0.01%
12.57%
-3.00%
9.57%
0.32%
-0.03%
0.09%
0.00%
0.00%
0.09%
9.65%
9.57%
0.00%
9.65%
9.65%
20.26%
9.57%
11.75%
0.27%
67.47%
21.75%
9.64%
0.27%
0.64%
100.04%
61.61%
8.58%
4.73%
3.68%
2.87%
2.33%
1.18%
1.22%
0.76%
0.26%
0.12%
0.06%
0.15%
0.07%
0.08%
0.07%
0.02%
0.05%
0.04%
0.08%
0.02%
0.05%
0.04%
0.04%
0.03%
0.17%
88.31%
0.69%
0.07%
0.76%
0.02%
0.00%
0.02%
0.05%
PT HANJAYA MANDALA SAMPOERNA Tbk.
Balance Sheet
Figures presented in mn Rupiah
2018 2019 2020 2021
ASSETS
Current Assets
Cash and cash equivalents 15,516,439.0 18,820,695.0 15,804,309.0 17,843,656.0
Trade receivables 3,507,601 3,254,954 3,648,322 2,380,793
Third parties 3,370,321 3,118,541 3,507,586 2,175,531
Related parties 137,280 136,413 140,736 205,262
Other receivables 307,734 531,287 453,192 515,806
Third parties 299,975 527,407 450,703 489,408
Related parties 7,759 3,880 2,489 26,398
Loan to related party
Other short term financial asset 1,273,838 401,155 709,535 21,198
Inventories 15,183,197 16,376,231 18,093,707 17,781,747
Prepaid tax 1,009,794 56,970 70,482 131,408
Corporate income tax 47,426 53,184 53,433 99,063
Other taxes 962,368 3,786 17,049 32,345
Advances for purchase of tobacco 883,936 952,616 526,602 726,606
Prepayments 148,944 71,933 73,723 141,104
Other current asset 1,231,174 1,711,766 1,780,787
Total current assets 37,831,483 45,540,226 41091638 41,323,105
Non-current assets
Advance for acquisition of fixed assets 19,661
Investment in associate 70,426 81,651 80,356 85,194
Investment properties 465,004 443,339 422,148 400,645
Gross Fixed Asset 13,110,284 14,041,202 14,301,395 14,370,155
Acc depreciation -5,821,849 -6,743,290 -7,718,587 -8,331,512
Fixed assets 7,288,435 7,297,912 6,582,808 6,038,643
Land for development 108,449 108,956 109,367 110,702
Deffered tax assets 335,166 345,043 393,862 312,903
Goodwill 60,423 60,423 60,423 60,423
Other non-current assets 443,034 868,467 933,428 4,758,813
Total non-current assets 8770937 9,205,791 8,582,392 11,767,323
TOTAL ASSETS 46,602,420 50,902,806 49,674,030 53,090,428
LIABILITIES
Current liabilities
Trade and other payables 3,450,070 3,802,004 3,467,567 4,244,097
Third parties 2,652,273 2,655,512 2,674,932 3,337,905
Related parties 797,797 1,146,492 792,635 906,192
Derivative financial liabilities
Taxes payable 1,687,831 2,389,662 2,527,904 1,532,275
Corporate income tax 825,924 1,396,478 1,125,857 639,320
Other taxes 861,907 993,184 1,402,047 892,955
Excise tax payable 2,670,180 5,423,392 9,547,748 14,835,154
Accruals 238,625 189,849 241,167 258,028
Employee benefit liabilities
current 651,225 691,046 779,018 813,273
Deffered revenue
current 61,657 63,896 63,057 43,294
Other short term finance liability - 7,265 78,971
Lease liabilities
current 34,411 160,562 117,373 159,167
Total current liabilities 8,793,999 12,727,676 16,743,834 21,964,259
Non-current liabilities
Employee benefit liabilities 2,202,332 2,129,454 2,440,176 1,733,500
Deffered tax liabilities 537 1,108
Lease liabilities 80649 256,648 194,117 187,787
Deffered revenue 167187 109,298 53,940 12,368
Total non-current liabilities 2,450,168 2,495,400 2,688,770 1,934,763
Total liabilities 11,244,167 15,223,076 19,432,604 23,899,022
EQUITY
Share capital 465,272 465,272 465,272 465,272
Additional paid-in capital 20,546,151 20,568,076 20,586,373 20,640,641
Cumulative translation adjustment 645,882 646,139 645,885 645,878
Other reserves -29,721 -29,721 -29,721 -29,721
Retained earnings 13,730,669 14,029,964 8,573,617 7,469,336
appropriated 95,000 95,000 95,000 95,000
unappropriated 13,635,669 13,934,964 8,478,617 7,374,336
Total Equity 35,358,253 35,679,730 30,241,426 29,191,406
TOTAL LIABILITIES AND EQUITY 46,602,420 50,902,806 49,674,030 53,090,428
Balanced check 0 0 0 0
LIABILITIES
Current liabilities
5,538,570 5,834,839 Trade and other payables
4,379,497 4,613,765 Third parties 0.12%
1,159,073 1,221,074 Related parties 43.71%
Derivative financial liabilities
3,008,604 3,636,779 Taxes payable 41.58%
841,170 907,379 Corporate income tax 69.08%
2,167,434 2,729,400 Other taxes 15.23%
14,373,931 15,451,541 Excise tax payable 41.58%
245,028 250,262 Accruals -20.44%
Employee benefit liabilities
812,614 859,667 current 6.11%
Deffered revenue
36,083 31,962 current 3.63%
46,625 13,764 Other short term finance liability
Lease liabilities
147,512 212,256 current 366.60%
24,545,594 26,291,070 Total current liabilities 44.73%
Non-current liabilities
1,719,666 1,891,633 Employee benefit liabilities -3.31%
4842 5,810 Deffered tax liabilities
337,115 414,606 Lease liabilities 218.23%
9607 5,172 Deffered revenue -34.63%
2,071,230 2,317,220 Total non-current liabilities 1.85%
26,616,824 28,608,290 Total liabilities 35.39%
EQUITY
465,272 465,272 Share capital 0.00%
20,623,215 20,642,542 Additional paid-in capital 0.11%
645,983 645,983 Cumulative translation adjustment 0.04%
-29,721 -29,721 Other reserves 0.00%
6,465,419 5,967,513 Retained earnings
95,000 95,000 appropriated 0.00%
6,370,419 5,872,513 unappropriated 2.19%
28,170,168 27,691,589 Total Equity 0.91%
54,786,992 56,299,879.46 TOTAL LIABILITIES AND EQUITY 9.23%
0 0
-
2022 2023F
37.753 33.589
96.53% 95.19%
57.95% 89.81%
248.152 264.879
6.052 6.520
4.07% 3.06%
5.53% 5.95%
1,453,269 2,069,590
1.31% 1.75%
16.981 16.981
79.07% 79.07%
0.432 0.392
0.19 0.20
7,362,934 7,979,495
-116% -106.66%
116,318.10
A MANDALA SAMPOERNA Tbk.
Balance Sheet
Horizontal Analysis
2020 2021 2022 4Y CAGR AVERAGE
100
PT HANJAYA MANDALA SAMPOERNA Tbk.
Balance Sheet
Vertical Analysis
2018 2019 2020 2021
ASSETS
Current Assets
Cash and cash equivalents 33.30% 36.97% 31.82% 33.61%
Trade receivables 7.53% 6.39% 7.34% 4.48%
Third parties 7.23% 6.13% 7.06% 4.10%
Related parties 0.29% 0.27% 0.28% 0.39%
Other receivables
Third parties 0.64% 1.04% 0.91% 0.92%
Related parties 0.02% 0.01% 0.01% 0.05%
Loan to related party 0.00% 0.00% 0.00% 0.00%
Other short term financial asset 2.73% 0.79% 1.43% 0.04%
Inventories 32.58% 32.17% 36.42% 33.49%
Prepaid tax 2.17% 0.11% 0.14% 0.25%
Corporate income tax 0.10% 0.10% 0.11% 0.19%
Other taxes 2.07% 0.01% 0.03% 0.06%
Advances for purchase of tobacco 1.90% 1.87% 1.06% 1.37%
Prepayments 0.32% 0.14% 0.15% 0.27%
Other current asset 0.00% 2.42% 3.45% 3.35%
Total current assets 81.18% 89.47% 82.72% 77.84%
Non-current assets
Advance for acquisition of fixed assets 0.00% 0.00% 0.00% 0.04%
Investment in associate 0.15% 0.16% 0.16% 0.16%
Investment properties 1.00% 0.87% 0.85% 0.75%
LIABILITIES
Current liabilities
Trade and other payables
Third parties 5.69% 5.22% 5.38% 6.29%
Related parties 1.71% 2.25% 1.60% 1.71%
Derivative financial liabilities 0.00% 0.00% 0.00% 0.00%
Taxes payable
Corporate income tax 1.77% 2.74% 2.27% 1.20%
Other taxes 1.85% 1.95% 2.82% 1.68%
Excise tax payable 5.73% 10.65% 19.22% 27.94%
Accruals 0.51% 0.37% 0.49% 0.49%
Employee benefit liabilities
current 1.40% 1.36% 1.57% 1.53%
Deffered revenue
current 0.13% 0.13% 0.13% 0.08%
Other short term finance liability #VALUE! 0.01% 0.00% 0.15%
Lease liabilities 0.00% 0.00% 0.00% 0.00%
current 0.07% 0.32% 0.24% 0.30%
Total current liabilities 18.87% 25.00% 33.71% 41.37%
Non-current liabilities
Employee benefit liabilities 4.73% 4.18% 4.91% 3.27%
Deffered tax liabilities 0.00% 0.00% 0.00% 0.00%
Lease liabilities 0.17% 0.50% 0.39% 0.35%
Deffered revenue 0.36% 0.21% 0.11% 0.02%
Total non-current liabilities 5.26% 4.90% 5.41% 3.64%
Total liabilities 24.13% 29.91% 39.12% 45.02%
EQUITY
Share capital 1.00% 0.91% 0.94% 0.88%
Additional paid-in capital 44.09% 40.41% 41.44% 38.88%
Cumulative translation adjustment 1.39% 1.27% 1.30% 1.22%
Other reserves -0.06% -0.06% -0.06% -0.06%
Retained earnings 29.46% 27.56% 17.26% 14.07%
appropriated 0.20% 0.19% 0.19% 0.18%
unappropriated 29.26% 27.38% 17.07% 13.89%
Total Equity 75.87% 70.09% 60.88% 54.98%
TOTAL LIABILITIES AND EQUITY 100.00% 100.00% 100.00% 100.00%
2022
5.99%
5.38%
5.19%
0.19%
0.47%
0.34%
22.81%
0.00%
33.54%
0.20%
0.14%
0.06%
2.61%
0.05%
4.11%
75.50%
2.34%
0.16%
0.69%
12.22%
0.21%
0.81%
0.11%
7.96%
24.50%
100.00%
7.99%
2.12%
0.00%
1.54%
3.96%
26.24%
0.45%
1.48%
0.07%
0.09%
0.00%
0.27%
44.80%
3.14%
0.01%
0.62%
0.02%
3.78%
48.58%
0.85%
37.64%
1.18%
-0.05%
11.80%
0.17%
11.63%
51.42%
100.00%
0.52%
7.55%
15.10%
2.04%
0.00%
0.00%
0.36%
1.07%
0.04%
26.69%
0.00%
0.82%
1.38%
2.20%
28.88%
0.00%
-15.68%
-0.98%
-16.66%
12.22%
PT HANJAYA MANDALA SAMPOERNA Tbk. -336,627
Balance Sheet
Figures presented in mn Rupiah
2023F
Cash Flows From Operating Activities
Net Income 7,481,589
Adjustments -336,627
Depreciation and Amortization 941,051
Change in Net Working Capital
Change in Trade receivables -575,112
Change in Other receivables 1,680
Change in Inventories 235,598
Change in Prepaid tax 7,490
Change in Advances for purchase of tobacco -182,476
Change in Prepayments -66,612
Change in Other current asset -341,942
Change in Trade and other payables 296,269
Change in Taxes Payable 628,175
Change in Excise tax Payable 1,082,844
Net Cash Provided by Operating Activities 9,171,929
CASH OUTFLOW
Cash Flows From Operating Activities
Cash payment to suppliers (29,605,986) (29,410,669) (25,176,350)
Cash payments to employees (4,814,044) (4,609,160) (4,652,805)
Corporate income tax paid (4,412,498) (4,630,741) (2,948,120)
Excise tax paid (59,128,307) (61,538,037) (58,236,919)
Finance costs (30,495) (53,454) (49,983)
Other operating activites (18,483) (127,780)
Cash outflow from operating activities (97,991,330) (100,260,544) (91,191,957)
Cash Flows From Investing Activities
Loans provided/receipt of other receivables from related parties (5,443)
Decrease/ (increase) in other short-term financial asset (308,380)
Payments for:
Purchase of fixed assets (984,541) (959,537) (566,828)
Purchase of investment properties (4,676) -
Payments of advances for acquisition of fixed assets
Cash outflow from investing activities (994,660) (959,537) (875,208)
Cash Flows From Financing Activities
Proceeds (payment) from other short-term financial liability (7,265)
Repayments of finance leases (31,442)
Lease payment - (159,788) (163,526)
Dividend paid to shareholders (12,480,930) (13,632,478) (13,934,906)
Cash outflow from financing activities (12,512,372) (13,792,266) (14,105,697)
Total cash outflow (111,498,362) (115,012,347) (106,172,862)
Net increase in cash and cash equivalents 8,014,702 3,304,256 (3,016,386)
PT HANJAYA MANDALA SA
Cash Flow Statem
Horizontal Analy
2021 2022
Cash flows from operating activities
110,817,468 123,381,594 Cash receipt from customers
(24,769,324) (31,254,003) Cash payment to suppliers
(4,936,203) (4,791,601) Cash payments to employees
(6,325,778) (1,909,078) Corporate income tax paid
10,325 137,002 Cash receipt from claim for tax refunds
(64,983,313) (78,717,641) Excise tax paid
(56,528) (50,049) Finance costs
517,905 383,298 Finance income
27,854 175,814 Other operating actibites
10,302,406 7,355,336 9,171,929 Net cash flows generated from operating activities
PT HANJAYA MANDA
Cash Inflow and Cash Out
Figures presente
2021 2022 2021
CASH INFLOW
Cash Flows From Operating Activities
110,817,468 123,381,594 Cash receipt from customers
10,325 137,002 Cash receipt from claim for tax refunds
517,905 383,298 Finance income
27,854 175,814 Other operating activites
111,373,552 124,077,708 Cash inflow from operating activities
Cash Flows From Investing Activities
Loans provided/receipt of other receivables from related parties
1,063,150 Loan repayment from related party
688,337 21,198 Decrease/(increase) in other short-term financial asset
Proceed from business transfer
CASH OUTFLOW
Cash Flows From Operating Activities
(24,769,324) (31,254,003) Cash payment to suppliers
(4,936,203) (4,791,601) Cash payments to employees
(6,325,778) (1,909,078) Corporate income tax paid
(64,983,313) (78,717,641) Excise tax paid
(56,528) (50,049) Finance costs
Other operating activites
(101,071,146) (116,722,372) Cash outflow from operating activities
Cash Flows From Investing Activities
(23,910) (13,188,150) Loans provided/receipt of other receivables from related parties
Decrease/ (increase) in other short-term financial asset
Payments for:
(392,609) (898,723) Purchase of fixed assets
Purchase of investment properties
(19,661) (1,280,099) Payments of advances for acquisition of fixed assets
(436,180) (15,366,972) Cash outflow from investing activities
Cash Flows From Financing Activities
(32,346) Proceeds (payment) from other short-term financial liability
Repayments of finance leases
(208,522) (246,022) Lease payment
(8,467,956) (7,362,934) Dividend paid to shareholders
(8,676,478) (7,641,302) Cash outflow from financing activities
(110,183,804) (139,730,646) Total cash outflow
2,039,347 (14,560,538) Net increase in cash and cash equivalents
HANJAYA MANDALA SAMPOERNA Tbk.
Cash Flow Statement
Horizontal Analysis
2019 2020 2021 2022 4Y CAGR AVERAGE
-53.50% 196.16%
#DIV/0! 1050.95% -35.31% -48.64% #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
-2.54% -40.93% -30.74% 128.91% -2.25% 13.68%
-100.00% #DIV/0! #DIV/0! -100.00% -100.00% #DIV/0!
#DIV/0! #DIV/0! #DIV/0! 6410.85% #DIV/0! #DIV/0!
-117.00% 1423.06% -138.72% -4368.10% #NUM! -800.19%
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! -200.00% -1187.01% -140.96% #DIV/0! #DIV/0!
-100.00% #DIV/0! #DIV/0! #DIV/0! -100.00% #DIV/0!
#DIV/0! 2.34% 27.52% 17.98% #DIV/0! #DIV/0!
9.23% 2.22% -39.23% -13.05% -12.36% -10.21%
10.17% 2.33% -39.05% -11.12% -11.60% -9.42%
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
-58.77% -191.29% -167.61% -813.98% #NUM! -307.91%
106.84% 21.30% -16.03% 12.90% 24.19% 31.25%
21.30% -16.03% 12.90% -81.60% -32.18% -15.86%
CASH OUTFLOW
Cash Flows From Operating Activities
Cash payment to suppliers 26.55% 25.57% 23.71%
Cash payments to employees 4.32% 4.01% 4.38%
Corporate income tax paid 3.96% 4.03% 2.78%
Excise tax paid 53.03% 53.51% 54.85%
Finance costs 0.03% 0.05% 0.05%
Other operating activites 0.00% 0.02% 0.12%
Cash outflow from operating activities 87.89% 87.17% 85.89%
Cash Flows From Investing Activities
Loans provided/receipt of other receivables from related parties 0.00% 0.00% 0.00%
Decrease/ (increase) in other short-term financial asset 0.00% 0.00% 0.29%
Payments for: 0.00% 0.00% 0.00%
Purchase of fixed assets 0.88% 0.83% 0.53%
Purchase of investment properties 0.00% 0.00% 0.00%
Payments of advances for acquisition of fixed assets 0.00% 0.00% 0.00%
Cash outflow from investing activities 0.89% 0.83% 0.82%
Cash Flows From Financing Activities
Proceeds (payment) from other short-term financial liability 0.00% 0.00% 0.01%
Repayments of finance leases 0.03% 0.00% 0.00%
Lease payment 0.00% 0.14% 0.15%
Dividend paid to shareholders 11.19% 11.85% 13.12%
Cash outflow from financing activities 11.22% 11.99% 13.29%
Total cash outflow 100.00% 100.00% 100.00%
2018 2019
2021 2022 Cash receipt 116,739,187 116,293,601
10,302 7,355 Cash payment (29,605,986) (29,410,669)
334 (14,275) Cash payment (4,814,044) (4,609,160)
(8,598) (7,641) Corporate inc (4,412,498) (4,630,741)
Cash receipt f 376,689
Excise tax pa (59,128,307) (61,538,037)
Finance costs (30,495) (53,454)
34 Finance inco 1,001,440 1,112,910
Other operatin 67,497 (18,483)
302 7,355
598)
(14,275)
140,000
80,000
2021 2022
-
2018 2019
0.05% 0.01%
0.00% 0.00%
0.02% 0.00%
0.69% 0.87%
0.07% 0.00%
0.07% 0.00%
100.00% 100.00% 0
(29,606) (29,411) (25,176) (24,769) (31,254)
-20,000
(2,948)
(4,653) (4,936)
(6,326)
(4,412)
(4,814) (4,631)
(4,609) (1,909)
(4,792)
-40,000
22.48% 22.37% 25,000
4.48% 3.43% -60,000 (58,237)
5.74% 1.37% (59,128) (61,538) (64,983)
-80,000 (78,718)
58.98% 56.34% 20,000
0.05% 0.04% -100,000 25,000 0%
0.00% 0.00%
20,193 -5%
91.73% 83.53% -120,000 15,000
20,000 17,146
-140,000 -10
0.02% 9.44%
2018 2019 2020 2021 2022
0.00% 0.00% 15,000
10,000 -15
-13.81%
0.00% 0.00% Cash payment to suppliers -15.09%
Cash payments to employees 10,302
11,953 Corporate income tax paid
Excise tax paid Finance costs Other operating activites
0.36% 0.64% 10,000 -20
0.00% 0.00% 5,000 7,355
0.02% 0.92% -25
0.40% 11.00% 5,000
-28.61% -30
- -30.29%
2018 2019 2020 2021 2022
0.00% 0.02% 0 -35
0.00% 0.00% 2018 2019 2020 2021 2022
0.19% 0.18%
Net cash flows generated from operating activities
7.69% 5.27%
Row 93
7.87% 5.47%
100.00% 100.00%
2020 2021 2022
102,261,954 110,817,468 123,381,594
(25,176,350) (24,769,324) (31,254,003)
(4,652,805) (4,936,203) (4,791,601)
(2,948,120) (6,325,778) (1,909,078)
70,268 10,325 137,002
(58,236,919) (64,983,313) (78,717,641)
(49,983) (56,528) (50,049)
812,774 517,905 383,298
(127,780) 27,854 175,814
1000
383
1,001 1,113 137
377 - 518 176
67 - 10
813 28
70
-
116,739 123,382
116,294 110,817
102,262
Cash receipt from customers Cash receipt from claim for tax refunds
Finance income Other operating activites
2018 2019 2020 2021 2022
(29,606) (29,411) (25,176) (24,769) (31,254)
(4,814) (4,609) (4,653) (4,936) (4,792)
(4,412) (4,631) (2,948) (6,326) (1,909)
(59,128) (61,538) (58,237) (64,983) (78,718)
(30) (53) (50) (57) (50)
- (18) (128) - -
(24,769) (31,254)
(4,936)
(6,326) (1,909)
(4,792)
(64,983)
(78,718)
0%
-5%
-10%
2021 2022
-13.81% -15%
11,953
loyees 10,302
Corporate income tax paid
Other operating activites
-20%
7,355
-25%
-28.61% -30%
30.29%
2020 2021 2022
-35%
2020 2021 2022
1000
HMSP
Expressed in Thousand USD
2018 2019 2020
Current Asset 37,831,483 45,540,226 41,091,638
Current Liability 8,793,999 12,727,676 16,743,834
Inventory 15,183,197 16,376,231 18,093,707
Cash and Cash Equivalent 15,516,439 18,820,695 15,804,309
Fixed Asset 8,770,937 9,205,791 8,582,392
Total Asset 46,602,420 50,902,806 49,674,030
Total Liability 11,244,167 15,223,076 19,432,604
Equity 35,358,253 35,679,730 30,241,426
COGS (81,251,100) (79,932,195) (73,653,975)
Non-Current Liabilities 2,450,168 2,495,400 2,688,770
Revenue 106,741,891 106,055,176 92,245,210
Gross Profit 25,490,791 26,122,981 18,771,235
Net Income 13,538,418 13,721,513 8,581,378
Account Receivable 3,507,601 3,254,954 3,648,322
Account Payable 3,450,070 3,802,004 3,467,567
OCF #REF! #REF! #REF!
debt 115,060 424,475 311,490
Price per Share 3,810 1,490 1,505
Book Value per Share 303.80 306.56 259.84
Enterprise Value 419517571.4 142,884,751.90 149,550,905.60
EBITDA 17,855,814 18,224,003 11,509,070
LT Debt 80,649 256,648 194,117.0
Liquidity Ratio
Current Ratio 4.30x 3.58x 2.45x
Quick Ratio 2.58x 2.29x 1.37x
NWC 0.62x 0.64x 0.49x
Operating Cash to Liabilities #REF! #REF! #REF!
Cash Ratio 1.76x 1.48x 0.94x
Cash Turnover 6.88x 5.64x 5.84x
Solvency Ratio
Total Debt Ratio 0.25% 0.83% 0.63%
Debt/Equity Ratio 0.33% 1.19% 1.03%
Equity Multiplier 1.32x 1.43x 1.64x
Long-term Debt Ratio 0.17% 0.50% 0.39%
Profitability Ratio
Gross Profit Margin 23.88% 24.63% 20.35%
Net Profit Margin 12.68% 12.94% 9.30%
Return on Assets (ROA) 29.05% 26.96% 17.28%
EBITDA Margin 16.73% 17.18% 12.48%
Return on Equity (ROE) 38.29% 38.46% 28.38%
Asset Management/Turnover Ratio
Payable Turnover 46.59x 22.04x 20.26x
Days Sales in Payable 7.83 16.56 18.01
Inventory Turnover 4.89x 5.07x 4.27x
Days Sales In Inventory 74.59 72.06 85.41
Receivables Turnover 20.20x 31.37x 26.73x
Days Sales in Receivables 18.07 11.64 13.66
ccc 84.82 67.14 81.05
Fixed Asset Turnover 13.63x 11.80x 10.37x
NWC Turnover 1.66x 1.46x 1.28x
Total Asset Turnover 2.38x 2.18x 1.83x
Market Value Ratio
Earning per Share (EPS) 116 118 74
Price to Earning Ratio (PER) 32.84x 12.63x 20.34x
Price to Book Value (PBV) 12.54x 4.86x 5.79x
EV/EBITDA 23.49x 7.84x 12.99x
2021 2022
41,323,105 41,362,998
21,964,259 24,545,594
17,781,747 18,375,217
17,843,656 3,283,118
11,767,323 13,423,994
53,090,428 54,786,992
23,899,022 26,616,824
29,191,406 28,170,168
(81,955,013) (94,053,123)
1,934,763 2,071,230
98,874,784 111,211,321
16,813,347 17,158,198
7,137,097 6,323,744
2,380,793 2,945,727
4,244,097 5,538,570
#REF! #REF!
425,925 531,252
965 840
250.82 242.04
90,736,882.50 128,105,970.50
9,357,242 8,666,985
187,787.0 337,115.0
4Y CAGR 5Y Average
1.88x 1.69x -20.89% 2.78x
1.07x 0.94x -22.35% 1.65x
0.36x 0.31x -16.22% 0.49x
#REF! #REF! #REF! #REF!
0.81x 0.13x -47.53% 1.03x
5.54x 33.87x 48.96% 11.55x
61 54 -17.40% 84.60x
15.82x 15.56x -17.04% 19.44x
3.85x 3.47x -27.47% 6.10x
9.70x 14.78x -10.94% 13.76x
GGRM
Expressed in Million IDR
2017 2018 2019 2020
Current Asset 43,764,490 45,284,719 52,081,133 49,537,929
Current Liability 22,611,042 22,003,567 25,258,727 17,009,992
Inventory 38,056,863 38,695,520 43,018,974 40,016,438
Cash and Cash Equivalent 2,329,179 2,034,169 3,571,886 4,774,272
Fixed Asset 21,408,575 22,758,558 25,373,983 27,678,244
Total Asset 66,759,930 69,097,219 78,647,274 78,191,409
Total Liability 24,572,266 23,963,934 27,716,516 19,668,941
Equity 42,187,664 45,133,285 50,930,758 58,522,468
COGS 65,084,263 77,063,336 87,740,564 97,089,067
Non-Current Liabilities 1,961,224 1,960,367 2,457,789 2,658,949
Revenue 83,305,925 95,707,663 110,523,819 114,477,311
Gross Profit 18,221,662 18,644,327 22,783,255 17,388,244
Net Income 7,753,648 7,791,822 10,880,701 7,647,725
Account Receivable 2,229,097 1,725,933 1,875,909 2,556,127
Account Payable 1,213,634 1,129,544 1,297,463 1,123,703
OCF 8,204,579 11,224,700 11,174,403 17,477,714
debt 20,600,000 17,322,145 17,413,106 6,185,893
Price per Share 83,625 53,000 41,000
Book Value per Share 21,926 23,457 26,470 30,416
Enterprise Value 154,705,244 175,231,561 175,231,561 70,975,564
EBITDA 13,495,942 13,386,740 17,622,839 12,810,174
LT Debt 176,667 156,667
Liquidity Ratio
Current Ratio 2.06x 2.06x 2.91x
Quick Ratio 0.30x 0.36x 0.56x
NWC 0.3x 0.3x 0.4x
Operating Cash to Liabilities 0.51x 0.44x 1.03x
Cash Ratio 0.09x 0.141x 0.281x
Cash Turnover 47.05x 30.94x 23.98x
Solvency Ratio
Total Debt Ratio 25.07% 22.14% 7.91%
Debt/Equity Ratio 38.38% 34.19% 10.57%
Equity Multiplier 1.53x 1.54x 1.34x
Long-term Debt Ratio 0.22% 0.20%
Profitability Ratio
Gross Profit Margin 19.48% 20.61% 15.19%
Net Profit Margin 8.14% 9.84% 6.68%
Return on Assets (ROA) 11.28% 13.83% 9.78%
EBITDA Margin 13.99% 15.94% 11.19%
Return on Equity (ROE) 17.26% 21.36% 13.07%
Asset Management/Turnover Ratio
Payable Turnover 65.78x 72.30x 80.20x
Days Sales in Payable 5.55 5.05 4.55
Inventory Turnover 2.01x 2.15x 2.34x
Days Sales In Inventory 181.76 169.97 156.08
Receivables Turnover 48.40x 61.37x 51.66x
Days Sales in Receivables 7.54 5.96 7.08
ccc 183.76 170.88 158.62
Fixed Asset Turnover 3.98x 4.17x 3.98x
NWC Turnover 1.43x 1.50x 1.42x
Total Asset Turnover 1.41x 1.50x 1.46x
Market Value Ratio
Earning per Share (EPS) 4,049.59 5,654.96 3,974.70
Price to Earning Ratio (PER) 20.65x 7.25x 10.32x
Price to Book Value (PBV) 3.57x 1.55x 1.35x
EV/EBITDA 13.09x 9.94x 5.54x
2021 2022
59,312,578 55,445,127
28,369,283 29,125,010
47,606,791 47,739,541
4,169,740 4,407,033
29,823,806 32,497,502
89,964,369 88,562,617
30,676,095 30,706,651
59,288,274 57,855,966
110,608,655 113,587,089
2,306,812 1,581,641
124,881,266 124,682,692
14,272,611 11,095,603
5,605,315 2,779,739
2,773,872 2,181,496
1,002,233 1,308,958
5,325,167 9,867,984
10,103,003 10,136,469
30,600 18,000
30,814 30,069
66,659,510 55,675,793
10,241,585 6,890,706
122,667 65,385
4Y CAGR 5Y Average
2.09x 1.90x -1.93% 2.21x
0.41x 0.26x -3.05% 0.38x
0.3x 0.3x -3.09% 0.35x
0.19x 0.34x -9.72% 0.50x
0.15x 0.15x 13.11% 0.16x
29.95x 28.29x -11.94% 32.04x
Liquidity Ratio
Current Ratio 5.92x 6.02x 3.66x
Quick Ratio 1.57x 2.51x 1.76x
NWC 0.6x 0.6x 0.6x
Operating Cash to Liabilities 0.94x 1.27x 0.61x
Cash Ratio 0.58x 1.683x 1.221x
Cash Turnover 11.02x 3.65x 2.72x
Solvency Ratio
Total Debt Ratio 1.54% 4.41% 1.68%
Debt/Equity Ratio 1.92% 5.55% 2.28%
Equity Multiplier 1.25x 1.26x 1.36x
Long-term Debt Ratio 2.25% 1.13%
Profitability Ratio
Gross Profit Margin 45.47% 44.12% 53.06%
Net Profit Margin 5.32% 2.82% 14.74%
Return on Assets (ROA) 4.07% 2.10% 10.67%
EBITDA Margin 11.27% 9.32% 22.92%
Return on Equity (ROE) 5.08% 2.64% 14.53%
Asset Management/Turnover Ratio
Payable Turnover 8.81x 6.46x 3.36x
Days Sales in Payable 41.42 56.47 108.57
Inventory Turnover 0.79x 0.90x 0.90x
Days Sales In Inventory 460.60 407.44 406.47
Receivables Turnover 16.24x 15.28x 14.15x
Days Sales in Receivables 22.47 23.95 25.86
ccc 441.65 374.92 323.75
Fixed Asset Turnover 2.96x 3.08x 4.05x
NWC Turnover 0.60x 0.57x 0.59x
Total Asset Turnover 0.77x 0.76x 0.80x
Market Value Ratio
Earning per Share (EPS) 26.55 14.17 89.52
Price to Earning Ratio (PER) 5.31x 38.10x 6.03x
Price to Book Value (PBV) 0.29x 1.10x 0.96x
EV/EBITDA 1.96x 1.46x 2.74x
2021 2022
1,590,984 1,876,124
542,580 661,605
853,564 917,376
522,156 712,075
278,219 260,434
1,891,170 2,168,794
572,785 667,866
1,318,385 1,500,928
660,788 959,699
30,204 6,262
1,303,776 1,737,992
642,987 778,293
176,668 249,332
99,430 123,808
451,697 491,096 Shares outs 2099.9 2099.9 2099.9
179,922 300,474 Market cap 608971 296085.9 352783.2
10,089 7,568 Net debt 5,813.20 -85,132.45 (222,291.9)
428 630 Minority interest 1,236.8 1,259.5 1,314.9
628 724 616,021.00 212,212.98 131,806.20
388,347 602,731
261,128 354,102
7,073 3,982
4Y CAGR 5Y Average
2.93x 2.84x -16.80% 4.27x
1.36x 1.45x -2.04% 1.73x
0.6x 0.6x -1.23% 0.58x
0.33x 0.45x -16.60% 0.72x
0.96x 1.08x 16.73% 1.10x
2.50x 2.44x -31.40% 4.47x