Format Biaya Hutang Dan Modal Tugas1.xls
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Format Biaya Hutang Dan Modal Tugas1.xls as PDF for free.
More details
- Words: 723
- Pages: 13
HUTANG BANK JANGKA PENDEK Mata Uang
Bank Mandiri
Baki Debet 987,000
Tertimbang 17.32%
433,000 77,000
7.60% 1.35%
8.20% 8.20%
0.62% 0.11%
900,000 157,600 70,000 408,000 700,000 325,000 4,057,600
15.80% 2.77% 1.23% 7.16% 12.29% 5.70%
8.20% 8.20% 8.20% 8.20% 8.20% 8.20%
1.30% 0.23% 0.10% 0.59% 1.01% 0.47%
Mizuho SCB
1,596,167 43,978 -
28.01% 0.77% 0.00%
1.50% 1.50% 1.50%
0.42% 0.01% 0.00%
Sub Total Total
1,640,145 5,697,745
BTMU BCA Mandiri,entitas anak
IDR
Rabobank BTMU BCA DBS BCA Sub Total
USD
Mata Uang Rupiah Dolar AS
Rata2 Rate Rate Tertimbang 8.20% 1.42%
6.27%
Suku Bunga Pinjaman Bank jangka pendek Terendah Tertinggi 5.65% 10.75% 0.86% 2.13%
Rata2 8.20% 1.50%
Sumber Data : Laporan Keuangan
Mata Uang
Bank
IDR
PT Bank ANZ Indonesia (ANZ) /IDR
USD
Mata Uang Rupiah Dolar AS
Obligasi Rupiah VI Obligasi Rupiah VII Total Nilai Nominal
Bank Mizuho BTMU (**) Citibank SCB Total
HUTANG TRUST RECIEPT JANGKA PENDEK Baki Debet Tertimbang
Rata2 Rate
Rate Tertimbang
157,667
12.94%
8.5%
1.10%
536,262 279,643 214,976 30,316 1,218,864
44.00% 22.94% 17.64% 2.49%
1.5% 1.5% 1.5% 1.5%
0.67% 0.35% 0.27% 0.04% 2.43%
Suku Bunga Trust Receive Terendah Tertinggi 7% 10% 0.80% 2.25%
Rata2 8.5% 1.5%
Nilai Nominal 2,000,000 2,000,000 4,000,000
Dikurangi diskonto dan beban transaksi yang ditangguhkan - setelah dikurangi akumulasi amortisasi 7 Neto Dikurangi bagian jatuh tempo dalam waktu satu tahun
3.993.242 1.999.082
11
3.989.156 -
3.985.409 Net Less current maturities
15
3.993.242 1.999.082
Bagian jangka panjang
3.989.156 -
3.985.409 Net Less current maturities 1.994.160
3.989.156
3.985.409 Long-term portion
3.993.242 1.999.082
3.989.156 -
Less discounts
3.985.409 Net Less current maturities 1.994.160
Seri VI,jangka waktu 5 tahun Nilai nominal 2,000,000.00 Kupon rate 7.25% Per Kwartal Mei 2012 s/d Mei 2017 Asumsi Kd 3%
3.989.156
3.985.409 Long-term portion
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
kd=
Bunga Kupon 48,333.33 48,333.33 48,333.33 48,333.33 48,333.33 48,333.33 48,333.33 48,333.33 48,333.33 48,333.33 48,333.33 48,333.33 48,333.33 48,333.33 48,333.33
C+((F-P)/n))/(F+P)/2
0.968 0.937 0.906 0.877 0.849 0.821 0.795 0.769 0.744 0.720 0.697 0.675 0.653 0.632 0.611
46,774.19 45,265.35 43,805.18 42,392.11 41,024.62 39,701.24 38,420.56 37,181.19 35,981.79 34,821.09 33,697.83 32,610.80 31,558.84 30,540.81 29,555.63 563,331.22 1,222,991.42 1,786,322.64
HUTANG JANGKA PANJANG Mata Uang IDR
Bank BCA
Baki Debet 5,070,332
IDR IDR
BSMI BTMU
700,000 132,000
6.09% 1.15%
9.33% 9.33%
0.57% 0.11%
50,000 9,746 7,201 130,000 6,099,279 628,133 628,133 571,030 2,351,300 362,772 361,487 568,965 5,471,820 11,571,099
0.43% 0.08% 0.06% 1.13%
9.33% 9.33% 9.33% 9.33%
0.04% 0.01% 0.01% 0.11%
5.46% 5.46% 4.97% 20.45% 3.16% 3.14% 4.95%
2.93% 2.93% 2.93% 2.93% 2.93% 2.93% 2.00%
0.16% 0.16% 0.15% 0.60% 0.09% 0.09% 0.10% 6.30%
IDR IDR IDR IDR
Rabobank BRI Permata Mandiri Sub Total USD Citibank USD BTMU USD BSMI USD SMBC USD UOB, Ind USD UOB, Sing JPY BSMI Sub Total Total, termasuk jt tempo biaya transaksi tangguhan
Tertimbang Rata2 Rate Rate Tertimbang 44.10% 9.33% 4.11%
(73,930) 11,497,169
Suku Bunga Pinjaman Bank jangka pendek Mata Uang Terendah Tertinggi Rata2 Rupiah 7.86% 10.80% Dollar AS 1.57% 4.28% Dollar SGD 2.77% 3.13% Yen Jepang 2% Sumber Data : Laporan Keuangan
9.33% 2.93% 2.95% 2.00%
Seri VII,jangka waktu 5 tahun Nilai nom 2,000,000.00 Kupon rat 10.125% Juni 2014 s/d Juni 2019
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
P
Bunga Kupon 67,500.000 67,500.000 67,500.000 67,500.000 67,500.000 67,500.000 67,500.000 67,500.000 67,500.000 67,500.000 67,500.000 67,500.000 67,500.000 67,500.000 67,500.000
C*((1-(1/1+i)^n))/i)+M/((1+i)^n
No.
Nama Perusahaan
Kode Saham Nilai
1 Indofood Sukses Makmur Tbk PT
INDF
5,697,745
Bank Rate 6.27%
Bobot 82.38%
Nilai 1,218,864
Short Term Debt Other Rate Bobot 2.43%
17.62%
Total Rate
Nilai 6,916,609
Bank Bobot 4.19%
c
Nilai
33.89%
=
11,497,169
r
Bank Rate
Bobot 6.30%
100.00%
Nilai
Long Term Debt Leasing Rate Bobot -
0%
0.00%
Nilai
Other Rate
Bobot 0.00%
Nilai 11,497,169
Total Rate
Obligasi Bobot 4.72%
Total
56.34%
Rate 1,994,160
Obligasi
8.69%
Investasi SUKUK Total Rate -
C+ (Pp-P)/n (Pp+P)/2 Pp P
Nilai yang akan dibayarkan, nilai pada kupon oblig Harga Obligasi di pasar
c
Coupun tingkat suku bunga dalam rupah
estasi Nilai
Total Rate
1,994,160
bayarkan, nilai pada kupon obligasi
ku bunga dalam rupah
8.69%
Total Debt
Kd
Bobot 0.0977149186
20,407,938
4.93%
No.
Nama Perusahaan Kode Saham Risk Free Risk Market Risk Premium 1 Indofood Sukses INDF 7.940% 9.960% 2.010%
Cost Of Equity BETA (ks) 1.05 10.051%
No.
Nama PeruKode Saham Total Hutang 1 Indofood S INDF 38,233,092
Kd 4.93%
Bobot Total Ekuitas 46.53% 43,941,423
Ke 10.05%
Bobot 53.47%
WACC 7.67%
Bank Mandiri
Baki Debet 987,000
Tertimbang 17.32%
433,000 77,000
7.60% 1.35%
8.20% 8.20%
0.62% 0.11%
900,000 157,600 70,000 408,000 700,000 325,000 4,057,600
15.80% 2.77% 1.23% 7.16% 12.29% 5.70%
8.20% 8.20% 8.20% 8.20% 8.20% 8.20%
1.30% 0.23% 0.10% 0.59% 1.01% 0.47%
Mizuho SCB
1,596,167 43,978 -
28.01% 0.77% 0.00%
1.50% 1.50% 1.50%
0.42% 0.01% 0.00%
Sub Total Total
1,640,145 5,697,745
BTMU BCA Mandiri,entitas anak
IDR
Rabobank BTMU BCA DBS BCA Sub Total
USD
Mata Uang Rupiah Dolar AS
Rata2 Rate Rate Tertimbang 8.20% 1.42%
6.27%
Suku Bunga Pinjaman Bank jangka pendek Terendah Tertinggi 5.65% 10.75% 0.86% 2.13%
Rata2 8.20% 1.50%
Sumber Data : Laporan Keuangan
Mata Uang
Bank
IDR
PT Bank ANZ Indonesia (ANZ) /IDR
USD
Mata Uang Rupiah Dolar AS
Obligasi Rupiah VI Obligasi Rupiah VII Total Nilai Nominal
Bank Mizuho BTMU (**) Citibank SCB Total
HUTANG TRUST RECIEPT JANGKA PENDEK Baki Debet Tertimbang
Rata2 Rate
Rate Tertimbang
157,667
12.94%
8.5%
1.10%
536,262 279,643 214,976 30,316 1,218,864
44.00% 22.94% 17.64% 2.49%
1.5% 1.5% 1.5% 1.5%
0.67% 0.35% 0.27% 0.04% 2.43%
Suku Bunga Trust Receive Terendah Tertinggi 7% 10% 0.80% 2.25%
Rata2 8.5% 1.5%
Nilai Nominal 2,000,000 2,000,000 4,000,000
Dikurangi diskonto dan beban transaksi yang ditangguhkan - setelah dikurangi akumulasi amortisasi 7 Neto Dikurangi bagian jatuh tempo dalam waktu satu tahun
3.993.242 1.999.082
11
3.989.156 -
3.985.409 Net Less current maturities
15
3.993.242 1.999.082
Bagian jangka panjang
3.989.156 -
3.985.409 Net Less current maturities 1.994.160
3.989.156
3.985.409 Long-term portion
3.993.242 1.999.082
3.989.156 -
Less discounts
3.985.409 Net Less current maturities 1.994.160
Seri VI,jangka waktu 5 tahun Nilai nominal 2,000,000.00 Kupon rate 7.25% Per Kwartal Mei 2012 s/d Mei 2017 Asumsi Kd 3%
3.989.156
3.985.409 Long-term portion
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
kd=
Bunga Kupon 48,333.33 48,333.33 48,333.33 48,333.33 48,333.33 48,333.33 48,333.33 48,333.33 48,333.33 48,333.33 48,333.33 48,333.33 48,333.33 48,333.33 48,333.33
C+((F-P)/n))/(F+P)/2
0.968 0.937 0.906 0.877 0.849 0.821 0.795 0.769 0.744 0.720 0.697 0.675 0.653 0.632 0.611
46,774.19 45,265.35 43,805.18 42,392.11 41,024.62 39,701.24 38,420.56 37,181.19 35,981.79 34,821.09 33,697.83 32,610.80 31,558.84 30,540.81 29,555.63 563,331.22 1,222,991.42 1,786,322.64
HUTANG JANGKA PANJANG Mata Uang IDR
Bank BCA
Baki Debet 5,070,332
IDR IDR
BSMI BTMU
700,000 132,000
6.09% 1.15%
9.33% 9.33%
0.57% 0.11%
50,000 9,746 7,201 130,000 6,099,279 628,133 628,133 571,030 2,351,300 362,772 361,487 568,965 5,471,820 11,571,099
0.43% 0.08% 0.06% 1.13%
9.33% 9.33% 9.33% 9.33%
0.04% 0.01% 0.01% 0.11%
5.46% 5.46% 4.97% 20.45% 3.16% 3.14% 4.95%
2.93% 2.93% 2.93% 2.93% 2.93% 2.93% 2.00%
0.16% 0.16% 0.15% 0.60% 0.09% 0.09% 0.10% 6.30%
IDR IDR IDR IDR
Rabobank BRI Permata Mandiri Sub Total USD Citibank USD BTMU USD BSMI USD SMBC USD UOB, Ind USD UOB, Sing JPY BSMI Sub Total Total, termasuk jt tempo biaya transaksi tangguhan
Tertimbang Rata2 Rate Rate Tertimbang 44.10% 9.33% 4.11%
(73,930) 11,497,169
Suku Bunga Pinjaman Bank jangka pendek Mata Uang Terendah Tertinggi Rata2 Rupiah 7.86% 10.80% Dollar AS 1.57% 4.28% Dollar SGD 2.77% 3.13% Yen Jepang 2% Sumber Data : Laporan Keuangan
9.33% 2.93% 2.95% 2.00%
Seri VII,jangka waktu 5 tahun Nilai nom 2,000,000.00 Kupon rat 10.125% Juni 2014 s/d Juni 2019
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
P
Bunga Kupon 67,500.000 67,500.000 67,500.000 67,500.000 67,500.000 67,500.000 67,500.000 67,500.000 67,500.000 67,500.000 67,500.000 67,500.000 67,500.000 67,500.000 67,500.000
C*((1-(1/1+i)^n))/i)+M/((1+i)^n
No.
Nama Perusahaan
Kode Saham Nilai
1 Indofood Sukses Makmur Tbk PT
INDF
5,697,745
Bank Rate 6.27%
Bobot 82.38%
Nilai 1,218,864
Short Term Debt Other Rate Bobot 2.43%
17.62%
Total Rate
Nilai 6,916,609
Bank Bobot 4.19%
c
Nilai
33.89%
=
11,497,169
r
Bank Rate
Bobot 6.30%
100.00%
Nilai
Long Term Debt Leasing Rate Bobot -
0%
0.00%
Nilai
Other Rate
Bobot 0.00%
Nilai 11,497,169
Total Rate
Obligasi Bobot 4.72%
Total
56.34%
Rate 1,994,160
Obligasi
8.69%
Investasi SUKUK Total Rate -
C+ (Pp-P)/n (Pp+P)/2 Pp P
Nilai yang akan dibayarkan, nilai pada kupon oblig Harga Obligasi di pasar
c
Coupun tingkat suku bunga dalam rupah
estasi Nilai
Total Rate
1,994,160
bayarkan, nilai pada kupon obligasi
ku bunga dalam rupah
8.69%
Total Debt
Kd
Bobot 0.0977149186
20,407,938
4.93%
No.
Nama Perusahaan Kode Saham Risk Free Risk Market Risk Premium 1 Indofood Sukses INDF 7.940% 9.960% 2.010%
Cost Of Equity BETA (ks) 1.05 10.051%
No.
Nama PeruKode Saham Total Hutang 1 Indofood S INDF 38,233,092
Kd 4.93%
Bobot Total Ekuitas 46.53% 43,941,423
Ke 10.05%
Bobot 53.47%
WACC 7.67%
Related Documents
Format Biaya Hutang Dan Modal Tugas1.xls
November 2019 32
Biaya Modal (coc)
June 2020 13
Format Blnj Modal (1).xls
December 2019 8
Biaya Dan Laba.docx
June 2020 5
Biaya Dan Pendapatan Usahatani.docx
June 2020 9More Documents from "Heru Yulian"
Bahan_sosialisasi_peraturan_presiden_nomor_16_tahun_2018.pptx
November 2019 32
Format Biaya Hutang Dan Modal Tugas1.xls
November 2019 32
Brosur Lansia.docx
November 2019 31
Negarakretagama_pancaksara
December 2019 22
07 Impuls Dan Momentum
June 2020 25