Excel XLS | Diposting 03 Aug 2022 | 3 thn lalu
Authentication
digital resources
163x Tipe XLS Ukuran file 0.88 MB Source: library.unismuh.ac.id
Sheet 1: Soal 1
| Ringkasan Laporan Keuangan | Ratio Analysis | PT Nippon Indosari Corpindo Tbk. | PT Nippon Indosari Corpindo Tbk. | PT Nippon Indosari Corpindo Tbk. | |||||||||||||||||||||
| PT Nippon Indosari Corpindo Tbk. | PT Nippon Indosari Corpindo Tbk. | LAPORAN LABA-RUGI KOMPREHENSIF | LAPORAN PERUBAHAN EKUITAS | LAPORAN POSISI KEUANGAN | |||||||||||||||||||||
| Dec-14 | Dec-13 | Jan - Des 2014 | Jan - Des 2013 | Tahun yang berakhir pada tanggal-tanggal | Tahun yang berakhir pada tanggal-tanggal 31 Desember 2014 dan 2013 | 31 Desember 2014 dan 2013 | |||||||||||||||||||
| Sales | 31 Desember 2014 dan 2013 | (Dinyatakan Dalam Rupiah) | (Dinyatakan Dalam Rupiah) | ||||||||||||||||||||||
| Gross Profit | Current Ratio | 2014 | 2013 | ||||||||||||||||||||||
| Operating Profit | Quick Ratio | 2014 | 2013 | Tambahan | Saldo Laba | ||||||||||||||||||||
| Earning Before Tax (EBT) | Cash Ratio | Modal disetor, | Belum | Sudah | Aset Lancar | ||||||||||||||||||||
| Net Profit | Receivable Turnover | Agio Saham, | Ditentukan | Ditentukan | Kas dan setara kas | 162,584,129,984 | 101,142,256,234 | ||||||||||||||||||
| Average Collection Period | Penjualan Neto | 1,880,262,901,697 | 1,505,519,937,691 | Modal Saham | bersih | Penggunaannya | Penggunaannya | Jumlah Ekuitas | Piutang usaha | ||||||||||||||||
| Current Assets | Inventory Turnover | 7) | Pihak ketiga | 111,532,931,932 | 178,120,550,160 | ||||||||||||||||||||
| Long-term Assets | Average Inventory Processing Period | Beban Pokok Penjualan | 978,850,415,303 | 806,917,558,963 | Saldo 1 Januari 2013 | 101,236,000,000 | 173,001,428,035 | 392,370,169,515 | - | 666,607,597,550 | Pihak berelasi | 101,773,188,855 | 4,586,597,955 | ||||||||||||
| Current Liabilities | Payable Turnover Ratio | Piutang lain-lain | |||||||||||||||||||||||
| Long-term Liablities | Payable Payment Period | Laba Kotor | 901,412,486,394 | 698,602,378,728 | Total laba komprehensif tahun berjalan | - | - | 158,015,270,921 | - | 158,015,270,921 | Pihak ketiga | 100,814,310 | 381,871,649 | ||||||||||||
| Equity | Cash Conversion Cycle | Persediaan | 40,795,755,774 | 36,523,703,417 | |||||||||||||||||||||
| Total Asset Turnover | Beban Usaha | Dividen kas | - | - | (37,285,218,800) | - | (37,285,218,800) | Biaya dibayar dimuka | 2,219,902,887 | 1,568,991,746 | |||||||||||||||
| Nominal per share | Fixed Asset Turnover | Penjualan | 482,517,651,526 | 376,980,976,956 | Pajak dibayar dimuka | 43,298,780 | 20,905,019,196 | ||||||||||||||||||
| Oustanding shares | Equity Turnover | Umum dan Administrasi | 156,294,226,755 | 111,694,601,827 | Saldo 31 Desember 2013 | 101,236,000,000 | 173,001,428,035 | 513,100,221,636 | - | 787,337,649,671 | Uang muka | 1,266,366,013 | 20,652,029,560 | ||||||||||||
| Total Asset Growth | 2) | Jumlah Beban Usaha | 638,811,878,281 | 488,675,578,783 | Jumlah Aset Lancar | 420,316,388,535 | 363,881,019,917 | ||||||||||||||||||
| Working Capital Turnover | Pendapatan operasi lainnya | 38,342,378,021 | 24,552,459,546 | ||||||||||||||||||||||
| Working Capital to Total Asset | Beban operasi lainnya | 2,314,293,577 | 2,087,916,150 | Total laba komprehensif tahun berjalan | - | - | 188,577,521,074 | - | 188,577,521,074 | Aset Tidak Lancar | |||||||||||||||
| Gross Profit Margin | Laba Usaha | 298,628,692,557 | 232,391,343,341 | Aset tetap - neto | 1,679,981,658,119 | 1,175,251,173,341 | |||||||||||||||||||
| Basic Earning Power | Dividen kas | - | - | (15,792,816,001) | - | (15,792,816,001) | Deposito jaminan | 15,374,050,272 | 15,501,000,787 | ||||||||||||||||
| Operating Profit Margin | Penghasilan (Beban) Lain-lain | Aset tak berwujud - neto | 6,929,513,926 | 2,563,059,592 | |||||||||||||||||||||
| Net Profit Margin | Pendapatan keuangan | 970,187,057 | 2,810,954,756 | Pembentukan cadangan umum | - | - | (2,000,000,000) | 2,000,000,000 | - | Uang jaminan | 4,799,530,022 | 4,041,777,680 | |||||||||||||
| Return on Equity | Biaya keuangan | (46,835,971,511) | (24,397,393,935) | Aset non-keuangan tidak lancar lainnya | 15,493,135,342 | 261,451,015,791 | |||||||||||||||||||
| Return on Asset | Penghasilan (Beban) Lain-lain - Bersih | -45,865,784,454 | -21,586,439,179 | Saldo 31 Desember 2014 | 101,236,000,000 | 173,001,428,035 | 683,884,926,709 | 2,000,000,000 | 960,122,354,744 | Jumlah Aset Tidak Lancar | 1,722,577,887,681 | 1,458,808,027,191 | |||||||||||||
| Net Income (Loss) Growth Ratio | 1) | Total Aset | 2,142,894,276,216 | 1,822,689,047,108 | |||||||||||||||||||||
| Net Sales Growth Ratio | 3) | Laba Sebelum Pajak Penghasilan | 252,762,908,103 | 210,804,904,162 | |||||||||||||||||||||
| Debt To Equity Ratio | Liabilitas Jangka Pendek | ||||||||||||||||||||||||
| Long-term Debt to Total Capital | Beban Pajak Penghasilan | 64,185,387,029 | 52,789,633,241 | Utang usaha | |||||||||||||||||||||
| Debt Ratio | Laba Komprehensif Tahun Berjalan | 188,577,521,074 | 158,015,270,921 | Pihak ketiga | 75,575,779,566 | 97,411,812,822 | |||||||||||||||||||
| Interest Coverage | Pihak berelasi | 50,029,102,783 | 61,903,647,117 | ||||||||||||||||||||||
| Net Worth Growth Ratio | 4) | Laba Per Saham | 37.26 | 31.22 | Utang lain-lain | ||||||||||||||||||||
| Firm Growth | 5) | Pihak ketiga | 67,921,963,066 | 118,044,464,058 | |||||||||||||||||||||
| Earning per share (EPS) | Pihak berelasi | 637,868,703 | - | ||||||||||||||||||||||
| Dividend per share (DPS) | Utang pajak | 6,270,644,015 | 5,303,215,646 | ||||||||||||||||||||||
| Book value per share (BVPS) | Beban akrual | 59,037,600,971 | 37,018,290,679 | ||||||||||||||||||||||
| Cash flow per share (CFPS) 6) | Utang bank jangka panjang yang jatuh tempo dalam | ||||||||||||||||||||||||
| Price/Earning Ratio | waktu satu tahun | 47,647,294,496 | - | ||||||||||||||||||||||
| Price/Book Value Ratio | Liabilitas imbalan kerja jangka pendek | 488,415,633 | 515,975,500 | ||||||||||||||||||||||
| Price/Cash Flow Ratio | Jumlah Liabilitas Jangka Pendek | 307,608,669,233 | 320,197,405,822 | ||||||||||||||||||||||
| Market Value Added (MVA) | |||||||||||||||||||||||||
| Common stock price, Dec. 31 | Liabilitas Jangka Panjang | ||||||||||||||||||||||||
| Jaminan pelanggan | 20,650,277,695 | 18,465,488,908 | |||||||||||||||||||||||
| Utang bank jangka panjang - setelah dikurangi bagian | |||||||||||||||||||||||||
| 1) Net Income (2012) Rp149.149.548.025,- | yang jatuh tempo dalam waktu satu tahun | 291,203,527,978 | 160,484,234,676 | ||||||||||||||||||||||
| 2) Total Asset (2012) Rp1.204.944.681.223,- | Liabilitas pajak tangguhan - neto | 30,431,313,157 | 14,596,982,924 | ||||||||||||||||||||||
| 3) Net Sales (2012) Rp1.190.825.893.340,- | Utang obligasi | 496,541,543,422 | 495,910,464,028 | ||||||||||||||||||||||
| 4) Total Equity (2012) Rp666.607.597.550,- | Liabilitas imbalan kerja jangka panjang | 36,336,589,987 | 25,696,821,079 | ||||||||||||||||||||||
| 5) Dividend Payout Ratio for 2014 & 2013 respectively: | Jumlah Liabilitas Jangka Panjang | 875,163,252,239 | 715,153,991,615 | ||||||||||||||||||||||
| Firm's Growth : g = (1 - DPR) * ROE | Jumlah Liabilitas | 1,182,771,921,472 | 1,035,351,397,437 | ||||||||||||||||||||||
| DPR 2014 | |||||||||||||||||||||||||
| DPR 2013 | Ekuitas | ||||||||||||||||||||||||
| 6) Accumulated depreciation 2014 and 2013 : Rp305.343.711.066,- and Rp212.198.825.657,- respectively. | Modal Saham - nilai nominal Rp20 per saham | ||||||||||||||||||||||||
| 7) Inventory (2012) Rp22.598.712.855,- | Modal dasar - 17.200.000.000 saham | ||||||||||||||||||||||||
| Modal ditempatkan dan disetor penuh - | |||||||||||||||||||||||||
| 5.061.800.000 saham | 101,236,000,000 | 101,236,000,000 | |||||||||||||||||||||||
| Tambahan modal disetor - neto | 173,001,428,035 | 173,001,428,035 | |||||||||||||||||||||||
| Saldo Laba | |||||||||||||||||||||||||
| Telah ditentukan penggunaannya | 2,000,000,000 | - | |||||||||||||||||||||||
| Belum ditentukan penggunaannya | 683,884,926,709 | 513,100,221,636 | |||||||||||||||||||||||
| Jumlah Ekuitas | 960,122,354,744 | 787,337,649,671 | |||||||||||||||||||||||
| Total Liabilitas dan Ekuitas | 2,142,894,276,216 | 1,822,689,047,108 | |||||||||||||||||||||||
| LAPORAN POSISI KEUANGAN PT SEPATU BATA TBK | LAPORAN LABA RUGI KOMPREHENSIF PT SEPATU BATA TBK | |||||||||||||||||||||
| Dalam Ribuan Rupiah | 2014 | Dalam Ribuan Rupiah | 2014 | METODE DUPONT PT SEPATU BATA TBK | ||||||||||||||||||
| Aset Lancar | Penjualan neto | 1,008,727,515 | ||||||||||||||||||||
| Kas dan setara kas | 4,035,526 | Beban pokok pendapatan | (558,227,929) | COGS | ||||||||||||||||||
| Piutang Usaha | Laba bruto | 450,499,586 | Net Sales | |||||||||||||||||||
| Pihak ketiga | 22,014,249 | Beban penjualan dan pemasaran | (235,948,633) | + | ||||||||||||||||||
| Pihak berelasi | 11,609,576 | Beban umum dan administrasi | (110,968,797) | Net Operating | - | Operating Expenses | ||||||||||||||||
| Piutang pegawai | 1,285,770 | Beban usaha lainnya - neto | (368,932) | Income | ||||||||||||||||||
| Piutang lain-lain | 5,801,521 | Laba Usaha | 103,213,224 | Total Expenses | + | |||||||||||||||||
| Persediaan - neto | 314,628,156 | 281,405,718 | Pendapatan bunga | 87,086 | Profit | / | for Operation | Other | ||||||||||||||
| Pajak pertambahan nilai dibayar di muka | 50,401,923 | Beban keuangan | (4,374,404) | Margin | Expenses | |||||||||||||||||
| Biaya dibayar di muka | 60,030,326 | Laba sebelum beban pajak penghasilan badan | 98,925,906 | Net Sales | ||||||||||||||||||
| Pajak penghasilan badan dibayar di muka | 14,785,305 | Beban pajak penghasilan badan | (28,144,466) | |||||||||||||||||||
| Aset lancar lainnya | 6,283,536 | Laba tahun berjalan | 70,781,440 | |||||||||||||||||||
| Total aset lancar | 490,875,888 | ROA | x | Cash | ||||||||||||||||||
| Rasio keuangan | PT Sepatu Bata Tbk. | Rata-rata Industri | Evaluasi | Net Sales | ||||||||||||||||||
| Aset Tidak Lancar | Current ratio | + | ||||||||||||||||||||
| Aset tetap - neto | 245,225,987 | Quick ratio | Investment | Inventory | ||||||||||||||||||
| Aset lain-lain | Inventory turnover | Turnover | / | Working Capital | ||||||||||||||||||
| Biaya dibayar di muka | 25,029,782 | Average collection period | + | |||||||||||||||||||
| Uang jaminan sewa | 13,759,430 | Total asset turnover | Total | + | Account Receivable | |||||||||||||||||
| Total aset tidak lancar | 284,015,199 | Interest coverage | Investment | |||||||||||||||||||
| TOTAL ASET | 774,891,087 | Net profit margin | Fixed Assets | + | ||||||||||||||||||
| Return on asset | Other Current Assets | |||||||||||||||||||||
| Liabilitas jangka pendek | Return on equity | |||||||||||||||||||||
| Pinjaman jangka pendek | 49,500,000 | |||||||||||||||||||||
| Utang usaha | ||||||||||||||||||||||
| Pihak ketiga | 138,891,923 | |||||||||||||||||||||
| Pihak -pihak berelasi | 66,577,683 | |||||||||||||||||||||
| Utang pajak | 6,782,530 | |||||||||||||||||||||
| Beban akrual | 6,125,916 | |||||||||||||||||||||
| Liabilitas imbalan kerja jangka pendek | 6,255,889 | |||||||||||||||||||||
| Uang jaminan dari penyalur | 42,099,694 | |||||||||||||||||||||
| Total liabilitas jangka pendek | 316,233,635 | |||||||||||||||||||||
| Liabilitas jangka panjang | ||||||||||||||||||||||
| Liabilitas imbalan kerja jangka panjang | 8,664,979 | |||||||||||||||||||||
| Liabilitas pajak tangguhan - neto | 20,876,868 | |||||||||||||||||||||
| Total liabilitas jangka panjang | 29,541,847 | |||||||||||||||||||||
| TOTAL LIABILITAS | 345,775,482 | |||||||||||||||||||||
| Modal saham | ||||||||||||||||||||||
| Modal dasar 2.000.000.000 saham dengan nilai nominal Rp10 per saham; ditempatkan dan disetor penuh 1.300.000.000 saham | 13,000,000 | |||||||||||||||||||||
| Saldo laba | ||||||||||||||||||||||
| Telah ditentukan penggunaannya | 16,000 | |||||||||||||||||||||
| Belum ditentukan penggunaannya | 416,099,605 | |||||||||||||||||||||
| TOTAL EKUITAS | 429,115,605 | |||||||||||||||||||||
| TOTAL LIABILITAS DAN EKUITAS | 774,891,087 | |||||||||||||||||||||
no reviews yet
Please Login to review.
