Scribd Logo
Upload

Welcome to Scribd!

  • 8 views

    Lat Simpel Proyek

    Uploaded by

    Arman Boaz Antoni Malau

    Copyright:

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

    Lat Simpel Proyek

    Uploaded by

    Arman Boaz Antoni Malau
    8 views11 pages

    Original Title

    lat simpel proyek

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

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

    Lat Simpel Proyek

    Uploaded by

    Arman Boaz Antoni Malau

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 11

    Section 1 : Project Data

    Capital Cost 100 Product Price 10 Tax rate 0.25


    Ouput Flow 10 Wage 3 Dis. Rate 0.05
    Labaour Input 20 Shadow Wage 2 Dis. Rate 0.1

    0 1 2 3 4 5
    Section 2 : Project Cost Benefit Analisis
    Benefit 100 100 100 100 100
    Operating Cost 60 60 60 60 60
    Capital 100
    Net Benefit -100 40 40 40 40 40
    DF (5%) 1.00 0.95 0.91 0.86 0.82 0.78
    NPV5% -100 38.09524 36.281179138 34.5535 32.9081 31.34105
    DF(10%) 1.00 0.91 0.83 0.75 0.68 0.62
    NPV(10%) -100 36.36364 33.05785124 30.05259 27.32054 24.83685
    NPV@5% 73.17907
    NPV@10% 51.63
    IRR 29%

    Section 3 : Private Cost Benefit Analisis


    Benefit 0 100 100 100 100 100
    Operating Cost 0 60 60 60 60 60
    Capital 100 0 0 0 0 0
    Taxes 10 10 10 10 10
    Net Benefit 100 -30 -30 -30 -30 -30
    DF (5%) 1.00 0.95 0.91 0.86 0.82 0.78
    NPV5% 100 -28.57143 -27.210884354 -25.91513 -24.68107 -23.50578
    DF(10%) 1.00 0.91 0.83 0.75 0.68 0.62
    NPV(10%) 100 -27.27273 -24.79338843 -22.53944 -20.4904 -18.62764
    NPV@5% -29.8843
    NPV@10% -13.7236
    IRR 15%

    Section 4 : Efisiensi Cost Benefit Analisis


    Benefit 0 100 100 100 100 100
    Operating Cost 0 40 40 40 40 40
    Capital 100 0 0 0 0 0
    Net Benefit 100 -60 -60 -60 -60 -60
    DF (5%) 1.00 0.95 0.91 0.86 0.82 0.78
    NPV5% 100 -57.14286 -54.421768707 -51.83026 -49.36215 -47.01157
    DF(10%) 1.00 0.91 0.83 0.75 0.68 0.62
    NPV(10%) 100 -54.54545 -49.58677686 -45.07889 -40.98081 -37.25528
    NPV@5% -159.7686
    NPV@10% -127.4472
    IRR 53%
    Section 5 : Referent Gruop Cost-Benefit Analysis
    Referent Gruop Aggregat Net Benefit
    -30 -30 -30 -30 -30
    Referent Gruop Net Benefit Allocation
    Govt (Taxes) 10 10 10 10 10
    Labour (rent) 20 20 20 20 20
    Section 1 : Project Data
    Capital Cost 100 Product Price 10 Tax rate
    Ouput Flow 10 Wage 3 Dis. Rate
    Labour Input 20 Shadow Wage 2 Dis. Rate

    0 1 2 3 4 5
    Section 2 : Project Cost Benefit Analisis
    Benefit 100 100 100 100 100
    Operating Cost 60 60 60 60 60
    Capital 100
    Net Benefit -100 40 40 40 40 40
    NPV5% 73.18
    NPV10% 51.631471
    IRR 0.29

    Section 3 : Private Cost Benefit Analisis


    Benefit 0.00 100.00 100.00 100.00 100.00 100.00
    Operating Cost 0.00 60.00 60.00 60.00 60.00 60.00
    Capital 100.00 0.00 0.00 0.00 0.00 0.00
    Taxes 10 10 10 10 10
    Net Benefit (100.00) 30.00 30.00 30.00 30.00 30.00
    NPV5% 29.88
    NPV10% 13.72
    IRR 15%

    Section 4 : Efisiensi Cost Benefit Analisis


    Benefit 0.00 100.00 100.00 100.00 100.00 100.00
    Operating Cost 40.00 40.00 40.00 40.00 40.00
    Capital 100.00 0.00 0.00 0.00 0.00 0.00
    Net Benefit -100 60 60 60 60 60
    NPV5% Rp159.77
    NPV10% Rp127.45
    IRR 53%

    Section 5 : Referent Gruop Cost-Benefit Analysis


    Referent Gruop Aggregat Net Benefit
    30.00 30.00 30.00 30.00 30.00
    Referent Gruop Net Benefit Allocation
    Govt (Taxes) 10 10 10 10 10
    Labour (rent) 20.00 20.00 20.00 20.00 20.00
    NPV 5% 10%
    Govt (Taxes) Rp43.29
    Labour (rent) Rp86.59
    Rp129.88
    Rp159.77
    0.25
    0.05
    0.1
    Section 1 : Project Data
    Capital Cost 100 Product Price 10 Tax rate
    Output Flow 10 Wage 3 Dis. Rate
    Labour Input 20 Shadow Wage 2 Dis. Rate

    1. Benefit Cost Analysis


    0 1 2 3 4 5
    Investasi Awal 100
    Annual Cost 60 60 60 60 60
    Benefit 100 100 100 100 100
    Net B-C -100 40 40 40 40 40
    Disconto (5%) 1 0.952381 0.90702947845805 0.863838 0.822702 0.7835261665
    NVP -100 38.09524 36.281179138322 34.5535 32.9081 31.341046659
    Disconto (10%) 1 0.909091 0.82644628099174 0.751315 0.683013 0.6209213231
    NPV -100 36.36364 33.0578512396694 30.05259 27.32054 24.836852922
    IRR 22%

    2. Private Analisys
    0 1 2 3 4 5
    Investasi Awal 100 0 0 0 0 0
    Annual Cost 0 60 60 60 60 60
    Benefit 0 100 100 100 100 100
    Net B-C -100 40 40 40 40 40
    Tax 10 10 10 10 10
    Net B-C (Tax) -100 30 30 30 30 30
    Disconto (5%) 1 0.952381 0.90702947845805 0.863838 0.822702 0.7835261665
    NVP -100 28.57143 27.2108843537415 25.91513 24.68107 23.505784994
    Disconto (10%) 1 0.909091 0.82644628099174 0.751315 0.683013 0.6209213231
    NPV -100 27.27273 24.7933884297521 22.53944 20.4904 18.627639692
    IRR 14%

    3. Efisiensi Analisis
    0 1 2 3 4 5
    Investasi Awal 100 0 0 0 0 0
    Annual Cost 0 40 40 40 40 40
    Benefit 0 100 100 100 100 100
    Net B -100 60 60 60 60 60
    Disco (5%) 1 0.952381 0.90702947845805 0.863838 0.822702 0.7835261665
    -100 57.14286 54.421768707483 51.83026 49.36215 47.011569988
    Disco (10%) 1 0.909091 0.82644628099174 0.751315 0.683013 0.6209213231
    -100 54.54545 49.5867768595041 45.07889 40.98081 37.255279384
    IRR 30%

    Swasta 60 60 60 60 60
    Pemerintah 10 10 10 10 10

    Buruh 30 30 30 30 30
    0.25
    0.05
    0.1

    73.17906683

    51.63147078

    29.88430012

    13.72360308

    159.7686002
    127.4472062

    You might also like