Back to announcement
20231010_CSMI_Tanggapan atas Permintaan Penjelasan Bursa_31447762_lamp2.pdf
Other Text extracted CSMISource file signed link, expires in 15 minutes
Extracted text 10
Page 1
PT. CIPTA SELERA MURNI TBK BISNIS PLAN DAN PROYEKSI KEUANGAN 2023 - 2028
Page 2
PT Cipta Selera Murni Tbk -2 -1 0 0 1 2 3 4 5 Proyeksi 2023 - 2028 F F F F F F F F F BALANCE SHEET FY21 FY22 FY23 (as of 30 June) FY23 FY24 FY25 FY26 FY27 FY28 Laporan Keuangan Laporan Posisi Keuangan Konsolidasian Kas dan setara kas 3,708,544,557 613,539,234 46,912,098 6,139,541,797 13,879,068,284 24,162,411,015 46,271,829,297 45,563,649,284 53,881,695,886 Persediaan 5,250,831,064 2,822,134,143 1,239,718,683 2,130,805,090 3,657,639,153 8,574,044,836 12,026,941,899 16,541,150,480 27,826,671,932 Uang muka dan biaya dibayar dimuka 3,714,708,382 2,749,702,559 1,018,263,452 1,323,742,488 1,720,865,234 2,237,124,804 2,908,262,245 3,780,740,919 4,914,963,194 Jumlah Aset lancar 12,674,084,003 6,185,375,936 2,304,894,233 9,594,089,375 19,257,572,671 34,973,580,655 61,207,033,441 65,885,540,683 86,623,331,013 Aset tetap 252,953,635,377 252,619,409,654 252,619,409,654 261,619,409,654 270,619,409,654 293,119,409,654 315,619,409,654 338,119,409,654 360,619,409,654 Akumulasi penyusutan (185,870,215,970) (190,849,557,432) (192,398,411,171) (198,161,978,356) (203,925,545,541) (210,364,112,726) (216,802,679,911) (223,316,247,096) (229,829,814,281) Aset tak berwujud 1,271,631,715 - - - - - - - - Aset pajak tangguhan 1,942,089,345 1,562,821,774 1,368,231,034 Aset hak guna 10,713,487,082 417,992,091 - 765,490,151 792,282,306 820,012,187 848,712,613 878,417,555 909,162,169 Aset lain-lain 8,258,570,300 4,788,224,966 1,203,999,182 1,348,479,084 1,510,296,574 1,691,532,163 1,894,516,022 2,121,857,945 2,376,480,898 Jumlah Aset tidak lancar 89,269,197,849 68,538,891,053 62,793,228,699 65,571,400,533 68,996,442,993 85,266,841,278 101,559,958,379 117,803,438,058 134,075,238,441 Jumlah Aset 101,943,281,852 74,724,266,989 65,098,122,932 75,165,489,908 88,254,015,664 120,240,421,932 162,766,991,819 183,688,978,741 220,698,569,453 Utang bank jangka pendek 5,944,456,628 - - - - - - - - Bagian utang bank jangka panjang yang jatuh 1 tahun 9,769,303,830 4,656,455,613 4,364,788,932 1,963,155,054 1,963,155,054 1,963,155,054 - - Utang usaha 13,449,798,599 7,878,106,404 4,133,808,778 4,184,241,245 4,235,288,988 4,286,959,514 4,339,260,420 4,392,199,397 4,445,784,230 Utang lain-lain 14,006,616,164 26,825,758,000 28,773,540,656 51,288,907,331 60,178,300,828 55,268,872,311 68,469,994,887 58,731,632,234 53,184,712,536 Utang akrual dan utang pajak 13,761,276,306 8,796,539,833 7,871,274,275 3,935,637,138 4,412,326,230 4,946,752,478 5,545,909,074 6,217,636,237 6,970,723,799 Jumlah Liabilitas jangka pendek 56,931,451,527 48,156,859,850 45,143,412,641 61,371,940,767 70,789,071,100 66,465,739,357 78,355,164,382 69,341,467,868 64,601,220,565 Utang bank jangka panjang 14,714,574,319 8,758,776,731 6,557,142,853 3,876,659,907 1,696,176,961 - - Liabilitas sewa 4,638,008,125 370,444,624 - - - - - - - Liabilitas imbalan paska kerja 5,874,937,568 5,142,198,604 5,142,198,604 5,142,198,604 5,303,166,121 5,645,179,299 6,302,639,348 7,380,720,530 8,806,672,793 Jumlah Liabilitas jangka panjang 25,227,520,012 14,271,419,959 11,699,341,457 9,018,858,511 6,999,343,081 5,645,179,299 6,302,639,348 7,380,720,530 8,806,672,793 Jumlah Liabilitas 82,158,971,539 62,428,279,809 56,842,754,098 70,390,799,278 77,788,414,182 72,110,918,656 84,657,803,729 76,722,188,398 73,407,893,358 Modal saham 40,803,075,000 40,803,075,000 40,803,075,000 40,803,075,000 40,803,075,000 40,803,075,000 40,803,075,000 40,803,075,000 40,803,075,000 Tambahan modal disetor 23,762,736,134 23,762,736,134 23,762,736,134 23,762,736,134 23,762,736,134 48,762,736,134 48,762,736,134 48,762,736,134 48,762,736,134 Komponen Ekuitas Lainnya 7,043,495,470 8,187,467,555 8,187,467,555 8,187,467,555 8,187,467,555 8,187,467,555 8,187,467,555 8,187,467,555 8,187,467,555 Saldo laba (52,308,719,143) (60,930,542,131) (64,971,160,477) (66,300,996,006) (61,326,719,107) (45,634,243,512) (17,348,259,496) 21,422,691,533 73,171,637,825 Ekuitas kepentingan nonpengendali 483,722,852 473,250,622 473,250,622 473,250,622 473,250,622 473,250,622 473,250,622 473,250,622 473,250,622 Jumlah Ekuitas 19,784,310,313 12,295,987,180 8,255,368,834 6,925,533,305 11,899,810,204 52,592,285,799 80,878,269,815 119,649,220,844 171,398,167,136 Jumlah Liabilitas dan Ekuitas 101,943,281,852 74,724,266,989 65,098,122,932 77,316,332,583 89,688,224,386 124,703,204,454 165,536,073,545 196,371,409,242 244,806,060,494
Page 3
PT Cipta Selera Murni Tbk -2 -1 0 0 1 2 3 4 5
Proyeksi 2023 - 2028 F F F F F F F F F
INCOME STATEMENT FY21 FY22 FY23 (as of 30 FY23 (full FY24 FY25 FY26 FY27 FY28
June) year)
Laporan Keuangan
Laporan Posisi Keuangan Konsolidasian
-19% -2792% 75% 76% 43% 38% 29% 24%
Penjualan 61,504,899,366 51,673,656,616 1,786,983,771 7,130,964,613 29,522,193,498 51,562,356,081 83,015,393,291 116,606,979,218 152,448,282,305
Beban pokok penjualan (27,511,086,351) (23,976,279,161) (925,880,202) (2,893,137,685) (8,910,864,071) (15,268,340,631) (24,582,028,415) (34,528,970,627) (45,142,085,810)
Laba bruto 33,993,813,015 27,697,377,455 861,103,569 4,237,826,928 20,611,329,427 36,294,015,451 58,433,364,875 82,078,008,591 107,306,196,495
Beban Penjualan dan Distribusi
Beban amortisasi hak guna sewa (10,719,705,747) (10,295,494,991) (417,992,090) (417,992,090) (459,792,256) (551,750,707) (772,450,990) (1,081,431,387) (1,514,003,941)
Gaji dan tunjangan (10,073,697,583) (8,027,702,452) (167,250,000) (239,760,713) (2,794,924,886) (6,414,352,613) (12,721,799,348) (21,132,726,118) (27,227,849,229)
Penyusutan (Catatan 7)
(4,797,892,563) (3,410,428,712) (231,930,000) (270,000,000) (540,000,000) (1,215,000,000) (1,890,000,000) (2,565,000,000) (3,240,000,000)
Sewa dan service charge (3,160,651,548) (736,048,222) - (294,419,289) (1,828,343,783) (2,128,877,793) (3,427,493,246) (4,814,403,907) (6,294,199,634)
Kimia dan pembersih (466,279,447) (295,400,055) (6,000,000) (9,000,000) (36,000,000) (81,000,000) (126,000,000) (342,000,000) (432,000,000)
Perbaikan dan pemeliharaan (443,639,805) (221,254,708) - (8,100,000) (32,400,000) (72,900,000) (113,400,000) (307,800,000) (388,800,000)
Administrasi gerai (421,559,294) (283,204,658) (27,572,608) (33,872,608) (12,600,000) (28,350,000) (44,100,000) (59,850,000) (75,600,000)
Transportasi (236,793,400) (256,566,000) (600,000) (3,000,000) (30,000,000) (74,250,000) (127,050,000) (341,401,500) (474,368,400)
Promosi dan iklan (1,050,768,302) (179,595,554) - (71,309,646) (88,566,580) (515,623,561) (415,076,966) (583,034,896) (762,241,412)
Listrik, air dan telepon (135,008,285) (149,831,218) (1,125,000) (179,797,462) (885,799,997) (1,031,481,496) (1,660,685,208) (2,332,669,616) (3,049,658,592)
Kehilangan dan kerusakan (4,444,823) (115,328,516) (392,862,579) (394,662,579) (14,400,000) (22,500,000) (35,100,000) (52,200,000) (73,800,000)
Asuransi (26,499,083) (47,372,100) (7,795,934) (12,745,934) (9,900,000) (22,275,000) (34,650,000) (47,025,000) (59,400,000)
Perjalanan dinas (4,915,000) (9,430,000) (2,400,000) (2,400,000) (3,360,000) (4,704,000) (6,585,600) (9,219,840) (12,907,776)
Biaya profesional - (3,500,000) - - - - - - -
Lisensi (161,700) (26,954,461) - - - - - - -
Amortisasi - - - - - - - - -
Royalti (2,707,018,775) - - - - - - - -
Beban Umum dan Administrasi
Gaji dan tunjangan (6,190,247,094) (3,222,335,123) (312,000,000) (95,162,658) (424,425,453) (425,910,942) (427,401,630) (428,897,536) (1,291,196,032)
Penyusutan (Catatan 7) -
Imbalan pascakerja (Catatan 17) 363,602,584 (733,891,913) (160,967,517) (342,013,178) (657,460,049) (1,078,081,183) (1,425,952,263)
Bahan bakar dan penerangan (655,060,190) (425,735,517) (119,864,974) (269,696,192) (419,527,410) (569,358,628) (719,189,846)
Kehilangan dan kerusakan (191,817,877) (410,832,578) (1,010,467,518) (1,010,467,518) (59,044,387) (103,124,712) (166,030,787) (233,213,958) (304,896,565)
Transportasi (313,710,340) (329,292,370) (7,500,000) (52,500,000) (63,000,000) (75,600,000) (90,720,000) (108,864,000)
Administrasi kantor (394,754,692) (284,326,423) (167,394,450) (170,894,450) (4,200,000) (7,700,000) (11,200,000) (14,700,000) (18,200,000)
Jasa profesional (253,456,118) (199,207,621) (50,000,000) (100,000,000) (200,000,000) (200,000,000) (200,000,000) (200,000,000)
Sewa (2,611,590,978) (196,020,000) (9,075,000) (33,275,000) (36,602,500) (40,262,750) (44,289,025) (48,717,928)
Perbaikan dan pemeliharaan (135,073,741) (181,116,087) (58,500,000) (2,500,000) (2,500,000) (2,500,000) (2,500,000) (2,500,000) (2,500,000)
Listrik, air dan telepon (200,637,588) (164,620,924) (12,100,000) (13,310,000) (14,641,000) (16,105,100) (17,715,610) (19,487,171)
Asuransi (13,249,541) (82,117,854) (2,500,000) (2,750,000) (3,025,000) (3,327,500) (3,660,250) (4,026,275)
Amortisasi - (68,252,640)
Perjalanan dinas (25,365,228) (33,240,722) (1,000,000) (6,000,000) (7,200,000) (8,640,000) (10,368,000) (12,441,600)
Administrasi bank (21,308,717) (18,828,785) (16,706,585) - - - - - -
Kimia dan pembersih (18,598,092) (16,857,007) - - - - - -
Lisensi (8,021,597) (6,596,125) - - - - - -
EBITDA (10,924,511,549) (2,734,005,881) (1,959,493,195) 939,566,981 12,896,404,593 22,655,536,757 35,030,918,289 45,715,742,138 59,545,895,831
Penyusutan dan Amortisasi (6,937,115,062) (5,313,567,185) (1,548,853,739) (5,763,567,185) (5,763,567,185) (6,438,567,185) (6,438,567,185) (6,513,567,185) (6,513,567,185)
Laba Usaha (17,861,626,611) (8,047,573,066) (3,508,346,934) (4,824,000,204) 7,132,837,408 16,216,969,572 28,592,351,104 39,202,174,953 53,032,328,646
Pendapatan lain-lain 8,520,870,927 267,625,777 (406) - - - - - -
Beban Keuangan (3,647,564,391) (1,190,841,998) (337,680,266) (667,261,427) (755,559,332) (349,956,837) 8,239,408 - -
Laba sebelum Pajak Penghasilan (12,988,320,075) (8,970,789,287) (3,846,027,606) (5,491,261,631) 6,377,278,076 15,867,012,735 28,600,590,512 39,202,174,953 53,032,328,646
Pajak Penghasilan (568,159,230) 338,494,069 (194,590,740) 120,807,756 (1,403,001,177) (174,537,140) (314,606,496) (431,223,924) (1,283,382,353)
Penghasilan komprehensif lain 2,346,556,277 1,143,972,085 - - - - - - -
Jumlah penghasilan komprehensif periode berjalan (11,209,923,028) (7,488,323,133) (4,040,618,346) (5,370,453,875) 4,974,276,899 15,692,475,595 28,285,984,017 38,770,951,028 51,748,946,293
Saldo Laba (52,308,719,143) (60,930,542,131) (64,971,160,477) (66,300,996,006) (61,326,719,107) (45,634,243,512) (17,348,259,496) 21,422,691,533 73,171,637,825
Page 4
PT Cipta Selera Murni Tbk -2 -1 0 0 1 2 3 4 5
Proyeksi 2023 - 2028 F F F F F F F F F
Cash Flow FY21 FY22 FY23 (as of 30 FY23 FY24 FY25 FY26 FY27 FY28
June)
Laporan Keuangan
Laporan Posisi Keuangan Konsolidasian
Penerimaan kas dari pelanggan 61,504,899,366 51,673,656,616 1,786,983,771 7,130,964,613 29,522,193,498 51,562,356,081 83,015,393,291 116,606,979,218 152,448,282,305
Pembayaran kas kepada karyawan (13,942,746,814) (9,019,649,490) (479,250,000) (664,186,166) (3,220,835,828) (6,841,754,243) (13,150,696,885) (22,423,922,150) (27,227,849,229)
Pembayaran kas kepada pemasok dan untuk ke (43,469,822,039) (44,679,449,356) (620,718,114) (6,191,397,632) (16,625,788,905) (28,906,819,324) (22,066,555,770) (70,891,237,081) (92,902,386,474)
Kas bersih dari Aktivitas Operasi 4,092,330,513 (2,025,442,230) 687,015,657 275,380,815 9,675,568,765 15,813,782,514 47,798,140,636 23,291,819,988 32,318,046,601
Perolehan aset tetap (922,195,651) (9,000,000,000) (9,000,000,000) (22,500,000,000) (22,500,000,000) (24,000,000,000) (24,000,000,000)
Penerimaan dari penjualan aset tetap 15,067,100,823
Penambahan aset (4,527,540,037)
Perolehan aset takberwujud
Kas bersih dari Aktivitas Investasi 9,617,365,135 - (9,000,000,000) (9,000,000,000) (22,500,000,000) (22,500,000,000) (24,000,000,000) (24,000,000,000)
Penerimaan pinjaman bank 302,919,940
Pembayaran pinjaman bank (12,947,836,929) (12,559,974,216) (2,201,633,878) (5,082,116,824) (2,180,482,946) (2,680,482,946) (3,180,482,946) - -
Penerimaan dari pihal berelasi 1,897,500,000 12,819,141,836 1,947,782,656 20,000,000,000 10,000,000,000 - - - -
Hasil penawaran saham - 20,000,000,000
Penambahan liabilitas sewa (385,922,831)
Pembayaran liabilitas sewa 780,000,000 (137,888,715) (662,111,305)
Pembayaran beban keuangan (3,647,564,391) (1,190,841,998) (337,680,266) (667,261,427) (755,559,332) (349,956,837) (8,239,408) - -
Kas bersih dari Aktivitas Pendanaan (14,000,904,211) (1,069,563,093) (1,253,642,793) 14,250,621,748 7,063,957,722 16,969,560,217 (3,188,722,354) - -
Penurunan bersih kas dan setara kas (291,208,563) (3,095,005,323) (566,627,136) 5,526,002,563 7,739,526,487 10,283,342,730 22,109,418,282 (708,180,012) 8,318,046,601
Saldo Kas dan setara kas awal periode 3,999,753,120 3,708,544,557 613,539,234 613,539,234 6,139,541,797 13,879,068,284 24,162,411,015 46,271,829,297 45,563,649,284
Saldo Kas dan setara kas akhir periode 3,708,544,557 613,539,234 46,912,098 6,139,541,797 13,879,068,284 24,162,411,015 46,271,829,297 45,563,649,284 53,881,695,886
Page 5
PT Cipta Selera Murni Tbk -2 -1 0 0 1 2 3 4 5
Proyeksi 2023 - 2028 F F F F F F F F F
Rasio FY21 FY22 FY23 FY23 FY24 FY25 FY26 FY27 FY28
30-Jun
Rasio
Rasio Profitabilitas (%)
Laba Bruto / Penjualan Bruto 55.27 53.60 48.19 59.43 69.82 70.39 70.39 70.39 70.39
Laba Komprehensif tahun berjalan / Penjualan Bruto (18.23) (14.49) (226.11) (75.31) 16.85 30.43 34.07 33.25 33.95
Margin EBITDA (17.76) (5.29) (109.65) 13.18 43.68 43.94 42.20 39.20 39.06
Rasio Likuiditas (x)
Aset lancar / liabilitas jangka pendek 0.22 0.13 0.05 0.16 0.27 0.53 0.78 0.95 1.34
Kas / liabilitas jangka pendek 0.07 0.01 0.00 0.10 0.20 0.36 0.59 0.66 0.83
Rasio Solvabilitas (x)
Total liabilitas / total aset 0.81 0.84 0.87 0.94 0.88 0.60 0.52 0.42 0.33
Total liabilitas / total ekuitas 4.15 5.08 6.89 10.16 6.54 1.37 1.05 0.64 0.43
Total Aset / total liabilitas 1.24 1.20 1.15 1.07 1.13 1.67 1.92 2.39 3.01
Rasio total utang berbunga / ekuitas 1.04 0.71 0.79 0.56 0.14 - - - -
Pertumbuhan (%)
Penjualan neto (19.28) (19.03) (2,792) 75 76 43 38 29 24
Laba Bruto (22.98) (22.73) (3,116) 80 79 43 38 29 24
Laba Komprehensif tahun berjalan (49.95) (49.70) (85.33) 24.76 207.96 68.30 44.52 27.04 25.08
EBITDA (30.80) (30.55) (243.06) 73.13 - 10.48 - 1.15 -
Total Aset (36.68) (36.43) (14.79) 13.39 14.83 26.60 26.13 11.39 16.77
Total Liabilitas (31.86) (31.61) (9.83) 19.25 9.51 (7.87) 14.82 (10.34) (4.51)
Total Ekuitas (61.15) (60.90) (48.95) (19.20) 41.80 77.37 34.97 32.40 30.19
Page 6
Asumsi Jumlah Restoran
FY23
Outlets FY21 FY22 FY23 FY24 FY25 FY26 FY27 FY28
30-Jun
Beginning 21 15 8 - 6 12 27 42 57
New - - - 6 6 15 15 15 15
Closed (6) (7) (8) - - - - - -
Total Outlets 15 8 - 6 12 27 42 57 72
Reimage 3 3
Page 7
PT Cipta Selera Murni Tbk -2 -1 0 1 2 3 4 5
Proyeksi 2023 - 2028 F F F F F F F F
Asumsi FY21 FY22 FY23 FY24 FY25 FY26 FY27 FY28
General
Inflasi % 3.5% 3.5% 3.5% 3.5% 3.5% 3.5% 3.5% 3.5%
Working days days 365
Tax rate % 25%
Days receivable days 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3
Days payables days 80 80 45 45 45 45 45 45
Days inventory days 60 60 30 30 30 30 30 30
Assumstion
Investment
Opening
New # 3,500,000,000 3,500,000,000 1,500,000,000 1,500,000,000 1,500,000,000 1,500,000,000 1,500,000,000 1,500,000,000
Reimage # 500,000,000 500,000,000 500,000,000 500,000,000
Closed #
Revenue
Outlets
Beginning # 21 15 8 6 12 27 42 57
New # 6 6 15 15 15 15
Closed # -6 -7 -8
Total Outlets # 15 8 6 12 27 42 57 72
Reimage # 3 3
New outlets begin performance % 50% 50% 50% 50% 50% 50% 50% 50%
number of guest per outlets average
Range sd 100.000 50,000 67% 67% 67% 67% 67% 67% 67% 67%
Range 100.000 sd 200.000 100,000 15% 15% 15% 15% 15% 15% 15% 15%
Range 200.000 sd 300.000 150,000 10% 10% 10% 10% 10% 10% 10% 10%
Range 300.000 sd 400.000 200,000 5% 5% 5% 5% 5% 5% 5% 5%
Range 400.000 sd 500.000 250,000 2.5% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5%
Total number of guest 1,663,914 1,350,663 45,022 90,044 198,759 309,180 419,602 530,023
average check per guest IDR/guest 36,964 38,258 39,597 40,983 43,237 44,750 46,317 47,938
average revenue per month IDR/outlet/month 244,067,061 287,075,870 297,123,526 307,522,849 318,286,149 329,426,164 340,956,080 352,889,542
Total Sales 7,130,964,613 29,522,193,498 51,562,356,081 83,015,393,291 116,606,979,218 152,448,282,305
cogs
cogs per guest IDR/guest 16,533.96 17,751.49 16,065.10 12,370.13 12,803.08 13,251.19 13,714.98 14,195.01
% 40.57 30.18 29.61 29.61 29.61 29.61
Page 8
PT Cipta Selera Murni Tbk -2 -1 0 1 2 3 4 5
Proyeksi 2023 - 2028 F F F F F F F F
Asumsi FY21 FY22 FY23 FY24 FY25 FY26 FY27 FY28
opex
selling and distribution exp.
Salaries and allowences
avarages employee per outlet # 12 12 8 8 8 10 12 12
average salary per employee IDR/month 2,855,356 2,973,223 2,378,579 2,426,150 2,474,673 2,524,167 2,574,650 2,626,143
Rent and service charge
average rent annual per rent per outlet IDR/outlet 150,507,217 49,069,881 294,419,289 304,723,964 315,389,303 326,427,928 337,852,906 349,677,757
Fuel and light IDR/outlet 228,471,074 227,361,914 15,000,000 15,000,000 15,000,000 15,000,000 15,000,000 15,000,000
chemical cleaners IDR/outlet 22,203,783 14,066,669 500,000 500,000 500,000 500,000 500,000 500,000
outlet administration IDR/outlet 20,074,252 18,880,311 350,000 350,000 350,000 350,000 350,000 350,000
insurance IDR/outlet 1,261,861 3,158,140 275,000 275,000 275,000 275,000 275,000 275,000
repair and maintenance IDR/outlet 21,125,705 14,750,314 450,000 450,000 450,000 450,000 450,000 450,000
loss and damage IDR/outlet 234,048 628,667 100,000 100,000 100,000 100,000 100,000 100,000
transportation % of rev. (0) - - 5,000,000 5,500,000 6,050,000 6,655,000 7,320,500
electricity water and telephone IDR/outlet 6,428,966 9,988,748 9,988,748 9,988,748 9,988,748 9,988,748 9,988,748 9,988,748
opening new store
promotion IDR/outlet 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000
traveling % of rev. - - - - - - - -
G&A % of rev
Salaries and allowences IDR/outlet
avarages employee per outlet # 15 15 15 15 15 15 15 15
average salary per employee IDR/month 7,000,000 7,024,500 7,049,086 7,073,758 7,098,516 7,123,361 7,148,292 7,173,311
Rent and service charge
average rent annual per rent per outlet IDR 25,000,000 27,500,000 30,250,000 33,275,000 36,602,500 40,262,750 44,289,025 48,717,928
electricity water and telephone IDR 10,000,000 11,000,000 12,100,000 13,310,000 14,641,000 16,105,100 17,715,610 19,487,171
employee benefits accrue IDR - - - - - - - -
traveling IDR 15,000,000 15,000,000 15,000,000 15,000,000 15,000,000 15,000,000 15,000,000 15,000,000
office administration IDR 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000
repair and maintenance IDR 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000
transportation IDR 5,000,000 5,500,000 6,000,000 6,500,000 7,000,000 7,500,000 8,000,000 8,500,000
profesional fees IDR 50,000,000 50,000,000 50,000,000 50,000,000 50,000,000 50,000,000 50,000,000 50,000,000
fuel and light IDR 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000
taxes IDR - - - - - - - -
insurance IDR 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000 2,500,000
bank charges IDR 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000 1,000,000
Page 9
PT Cipta Selera Murni Tbk -2 -1 0 1 2 3 4 5
Proyeksi 2023 - 2028 F F F F F F F F
Investment Plan FY21 FY22 FY23 FY24 FY25 FY26 FY27 FY28
Investment Plan
Capital expenditure years
New Outlet IDR 20 - - 9,000,000,000 9,000,000,000 22,500,000,000 22,500,000,000 22,500,000,000 22,500,000,000
Reimage IDR 20 - - - - - - 1,500,000,000 1,500,000,000
Total IDR 9,000,000,000 9,000,000,000 22,500,000,000 22,500,000,000 24,000,000,000 24,000,000,000
Depreciation
Existing asets IDR (6,937,115,062) (5,313,567,185) (5,313,567,185) (5,313,567,185) (5,313,567,185) (5,313,567,185) (5,313,567,185) (5,313,567,185)
New Outlet IDR (450,000,000) (450,000,000) (1,125,000,000) (1,125,000,000) (1,125,000,000) (1,125,000,000)
Reimage IDR (75,000,000) (75,000,000)
Total IDR (6,937,115,062) (5,313,567,185) (5,763,567,185) (5,763,567,185) (6,438,567,185) (6,438,567,185) (6,513,567,185) (6,513,567,185)
Funding Plan
Bank Loan Long Term years
Mandiri (K1) IDR 1,579,864,645
Mandiri (K2) IDR 1,135,614,642
Mandiri (K3) IDR 1,649,309,645
BCA IDR 6,357,142,853
CIMB Niaga IDR 2,401,633,878
Total 13,123,565,663 - - - - - -
Portion long term due 13,123,565,663
Right Issue
number of shares
Nominal of shares
Price per share
Shareholding
Right Issue 20,000,000,000
Intercompnay CSWM 20,000,000,000 10,000,000,000
Retained earning 4,974,276,899 15,692,475,595 28,285,984,017 38,770,951,028 51,748,946,293
Beginning balance
Repayment
Bank Loan Long Term
Mandiri (K1) IDR (394,966,161) (394,966,161) (394,966,161) (394,966,161) -
Mandiri (K2) IDR (283,903,661) (283,903,661) (283,903,661) (283,903,661) -
Mandiri (K3) IDR (412,327,411) (412,327,411) (412,327,411) (412,327,411) -
BCA IDR (1,589,285,713) (1,089,285,713) (1,589,285,713) (2,089,285,713)
CIMB Niaga IDR (2,401,633,878)
Total Repayment (5,082,116,824) (2,180,482,946) (2,680,482,946) (3,180,482,946)
Net Funding 5,917,883,176 3,793,793,953 10,511,992,648 2,605,501,070 14,770,951,028 27,748,946,293
Interest Expenses
Bank Loan Long Term interest rate
Mandiri (K1) IDR 10.50% (165,885,788) (124,414,341) (124,414,341) (82,942,894) (41,471,447) -
Mandiri (K2) IDR 10.50% (119,239,537) (136,075,903) (136,075,903) (106,266,019) (76,456,135) -
Mandiri (K3) IDR 10.50% (173,177,513) (122,591,410) (122,591,410) (79,297,031) (36,002,653) -
BCA IDR 10.25% (493,576,589) (244,352,678) (372,477,678) (81,450,893) 162,169,643
CIMB Niaga IDR 9.95% (238,962,571) (39,827,095) - - -
Total Interest expense (1,190,841,998) (667,261,427) (755,559,332) (349,956,837) 8,239,408
Page 10
PT Cipta Selera Murni Tbk
Proyeksi 2023 - 2028
Restoran location
No. Nama Restoran Luas m2 seating area Kota Tahun buka No. Nama Restoran Luas m2 seating area
Kota Tahun buka
1 Citra Plaza 361 250 Pekanbaru 2023 1 Jabar 1 300 240 Jawa Barat 2027
2 Grand Mall Bekasi 141 80 Bekasi 2023 2 Jabar 2 200 160 Jawa Barat 2027
3 The Park 250 200 kendari 2023 3 Jabar 3 250 200 Jawa Barat 2027
4 Binjai Supermall 265 180 Binjai 2023 4 Jabar 4 250 200 Jawa Barat 2027
5 Lippo Plaza 200 140 Kendari 2023 5 Jabar 5 250 200 Jawa Barat 2027
6 Jogja Store 100 60 Cirebon 2023 6 Jabar 6 250 200 Jawa Barat 2027
7 Jabar 7 250 200 Jawa Barat 2027
1 Yuki Simpang Raya 250 200 Medan 2024 8 Jabar 8 250 200 Jawa Barat 2027
2 Marelan 250 200 Medan 2024 9 Jabar 9 250 200 Jawa Barat 2027
3 Yuki Mall 2 - Medan 2024 10 Jabar 10 250 200 Jawa Barat 2027
4 Amurang Plaza 170 130 Manado 2024 11 Jabar 11 250 200 Jawa Barat 2027
5 Pasar 45 300 240 Manado 2024 12 Jabar 12 250 200 Jawa Barat 2027
6 Kotamobagu 276 220 Manado 2024 13 Jabar 13 250 200 Jawa Barat 2027
14 Jabar 14 250 200 Jawa Barat 2027
15 Jabar 15 250 200 Jawa Barat 2027
1 Jl. Gereja 300 240 Padang 2025 1 Jatim 1 300 240 Jawa Barat 2028
2 Bukit Tingggi 200 160 Sumbar 2025 2 Jatim2 200 160 Jawa Barat 2028
3 Maju Bersama1 250 200 Medan 2025 3 Jatim3 250 200 Jawa Barat 2028
4 Maju Bersama2 250 200 Medan 2025 4 Jatim4 250 200 Jawa Barat 2028
5 Maju Bersama3 250 200 Medan 2025 5 Jatim5 250 200 Jawa Barat 2028
6 Medan 1 250 200 Medan 2025 6 Jatim6 250 200 Jawa Barat 2028
7 Medan 2 250 200 Medan 2025 7 Jatim7 250 200 Jawa Barat 2028
8 Medan 3 250 200 Medan 2025 8 Jatim8 250 200 Jawa Barat 2028
9 Medan 4 250 200 Medan 2025 9 Jatim9 250 200 Jawa Barat 2028
10 Medan 5 250 200 Medan 2025 10 Jatim10 250 200 Jawa Barat 2028
11 Medan 6 250 200 Medan 2025 11 Jatim11 250 200 Jawa Barat 2028
12 Medan 7 250 200 Medan 2025 12 Jatim12 250 200 Jawa Barat 2028
13 Medan 8 250 200 Medan 2025 13 Jatim13 250 200 Jawa Barat 2028
14 Medan 9 250 200 Medan 2025 14 Jatim14 250 200 Jawa Barat 2028
15 Medan 10 250 200 Medan 2025 15 Jatim15 250 200 Jawa Barat 2028
Names mentioned 0 people and organisations named in the text · linked when the evidence is strong
The name pass has not read this document yet.
Extraction attempts how the parser did, and what it refused
Nothing structured was extracted from this document — the attempts below say why.
No extraction attempted yet.
Other files in this announcement 2
20231010_CSMI_Tanggapan atas Permintaan Penjelasan Bursa_31447762.pdf
dead
20231010_CSMI_Tanggapan atas Permintaan Penjelasan Bursa_31447762_lamp1.pdf
dead