Scribd Logo
Upload

Welcome to Scribd!

  • 13 views

    Tugas M. Keuangan Mega Lestari I Xva 2261101154

    Uploaded by

    Mega Lestari
    The document analyzes investment projects using various metrics like payback period, NPV, IRR, MIRR, and probability of loss. It compares Project L and Project S, finding that Project L has a shorter payback period of 3 years 8 months compared to Project S's 2 years 7 months, but Project S has a higher IRR of 17% versus Project L's 13.45%. A crossover analysis shows Project S has higher NPV when the cost of capital exceeds 5.61%.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Tugas M. Keuangan Mega Lestari I Xva 2261101154

    Uploaded by

    Mega Lestari
    13 views8 pages
    The document analyzes investment projects using various metrics like payback period, NPV, IRR, MIRR, and probability of loss. It compares Project L and Project S, finding that Project L has a shorter payback period of 3 years 8 months compared to Project S's 2 years 7 months, but Project S has a higher IRR of 17% versus Project L's 13.45%. A crossover analysis shows Project S has higher NPV when the cost of capital exceeds 5.61%.

    Original Description:

    tugas

    Original Title

    TUGAS M. KEUANGAN MEGA LESTARI I XVA 2261101154

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document analyzes investment projects using various metrics like payback period, NPV, IRR, MIRR, and probability of loss. It compares Project L and Project S, finding that Project L has a shorter payback period of 3 years 8 months compared to Project S's 2 years 7 months, but Project S has a higher IRR of 17% versus Project L's 13.45%. A crossover analysis shows Project S has higher NPV when the cost of capital exceeds 5.61%.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    13 views8 pages

    Tugas M. Keuangan Mega Lestari I Xva 2261101154

    Uploaded by

    Mega Lestari
    The document analyzes investment projects using various metrics like payback period, NPV, IRR, MIRR, and probability of loss. It compares Project L and Project S, finding that Project L has a shorter payback period of 3 years 8 months compared to Project S's 2 years 7 months, but Project S has a higher IRR of 17% versus Project L's 13.45%. A crossover analysis shows Project S has higher NPV when the cost of capital exceeds 5.61%.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 8

    WACC = Weighted Average Cost of Capital Obligasi

    Struktur Modal Dana Komposisi Cost COC Tahun


    Hutang 250 25% 9.94% 2.48% 0
    Saham Preferen 150 15% 8.50% 1.28% 1
    Saham biasa 300 30% 10.80% 3.24% 2
    Saham baru 300 30% 11.02% 3.31% 3
    ------------- ------------- -------------- 4
    Total 1000 100% WACC 10.31% 5

    Biaya Bunga
    Biaya Hutang

    Usaha L Reinvest Ra 10%


    Tahun 20% 60% 20% Cashflow PV CF Payback
    0 -1000 -1000.00
    1 150 200 250 200 181.31 800
    2 200 250 300 250 205.47 550
    3 250 300 350 300 223.53 250
    4 300 350 400 350 236.42 8.5714286
    5 350 400 450 400 244.95 17.142857
    -------------- ------------- 3 Th 8 Bln
    NPV 91.67 91.67 18 Hr
    IRR 13.45%
    MIRR 12.14%
    Tahun Tahun
    0 1000 0 1000
    1 200 1 181.31
    ------------- -------------
    800 818.69
    2 250 2 205.47
    ------------- -------------
    550 613.22
    3 300 3 223.53
    ------------- -------------
    250 389.69
    4 350 4 236.42
    ------------- -------------
    3 Th 8 Bln 153.28 7.5091203
    18 Hr 5 244.95 15.273608
    -------------
    4 Th 7 Bln
    16 Hr

    USAHA S
    Tahun 30% 40% 30% Cashflow PV CF Payback
    0 -1000 -1000.00
    1 400 500 600 500 453.29 500
    2 250 350 400 335 275.33 165
    3 200 250 300 250 186.27 7.92
    4 150 200 300 215 145.23 27.6
    5 100 125 150 125 76.55 2 Th 7 Bln
    --------------- ------------- 28 Hr
    NPV 136.66 136.66
    IRR 17.00%
    MIRR 12.99%

    Tahun Proyek L Proyek S Selisih COC NPV L


    0 -1000 -1000 0 0.00% 500.00
    1 200 500 -300 5.00% 277.74
    2 250 335 -85 5.61% 253.97
    3 300 250 50 10.00% 101.25
    4 350 215 135 15.00% -40.81
    5 400 125 275 20.00% -156.57
    ------------- 25.00% -251.97
    Crossover 5.61%

    Crossover Analysis
    600.00
    500.00
    400.00
    300.00
    200.00
    100.00
    0.00
    0.00% 5.00% 10.00% 15.00% 20.00% 25.00% 30.00%
    -100.00
    -200.00
    -300.00

    NPV L NPV S
    Kupon 12%/tahun
    CF
    -925 Biaya hutang = 12%+75
    120
    120
    120
    120
    1120
    -------------
    14.19%
    9.94%

    Pay Disc Variance Std NPV

    818.69 1000 821.8713


    613.22 1000 675.4724
    389.69 1000 555.1514
    153.28 1000 456.263
    7.51 1000 374.9895
    15.273608 -------------
    4 Th 7 Bln Variance 2883.748
    16 Hr Std Dev 53.70054
    Z -1.71
    Prob Rugi 4.39%

    Pay Disc Variance Std NPV

    546.71 6000 4931.228


    271.39 3525 2381.04
    85.12 1500 832.7271
    7.03 3525 1608.327
    0.9935559 375 140.6211
    3 Th 7 Bln -------------
    1 Hr Variance 9893.944
    Std Dev 99.4683
    Z -1.37
    Prob Rugi 8.47%

    NPV S
    425.00
    270.83
    253.97
    143.70
    37.54
    -52.10
    -128.58

    30.00%
    50% 50%
    Tahun Proyek L Proyek S Return P
    0 -1000 -1000 -1000
    1 200 500 350.00
    2 250 335 292.50
    3 300 250 275.00
    4 350 215 282.50
    5 400 125 262.50
    ------------- ------------- -------------
    Return 1500 1425 1462.50
    Variance 6250 20112.5 1153.125
    Std Dev 79.06 141.82 33.96
    CV 5.27% 9.95% 2.32%
    Korelasi -0.970
    Summary
    Kriteria Proyek L Proyek S
    3 Th 8 Bln 2 Th 7 Bln
    Payback
    18 Hr 28 Hr
    4 Th 7 Bln 3 Th 7 Bln
    Payback Disc
    16 Hr 1 Hr
    NPV 91.67 136.66
    IRR 13.45% 17.00%
    MIRR 12.14% 12.99%
    Prob Rugi 4.39% 8.47%
    CV 0.048% 0.062%
    BULAN IHSG ANTA ANTM RIHSG RANTA RANTM
    Jan 752.93 70 1500
    Feb 761.08 70 1500 0.01082 0.00000 0.00000
    Mar 735.68 80 1225 -0.03337 0.14286 -0.18333
    April 783.41 60 1200 0.06488 -0.25000 -0.02041
    Mei 732.52 60 1075 -0.06496 0.00000 -0.10417
    Jun 720.54 60 1200 -0.01635 0.00000 0.11628
    Jul 760.97 65 1200 0.05611 0.08333 0.00000
    Agust 754.70 80 1250 -0.00824 0.23077 0.04167
    Sept 820.13 95 1375 0.08670 0.18750 0.10000
    Okt 860.49 95 1500 0.04921 0.00000 0.09091
    Nov 977.77 120 1775 0.13629 0.26316 0.18333
    Des 1000.23 105 1725 0.02297 -0.12500 -0.02817
    ------------------------------------------
    Metode Markowitz
    Average 0.02764 0.04842 0.01783
    Var 0.00338 0.02374 0.01093
    Std Dev 0.05812 0.15406 0.10455
    Single Index Model
    RIHSG RANTA RANTM
    Alpha 0.03507 -0.01603
    Beta 0.48299 1.22492
    Var ei 0.02295 0.00586

    Return 0.04842 0.01783


    Var 0.02374 0.01093
    Std Dev 0.15406 0.10455

    You might also like