Scribd Logo
Upload

Welcome to Scribd!

  • 6 views

    Total 600.00 506.41 124.56 34.83 3.56 0.12: Iteration 0 Iteration 1 Iteration 2 Iteration 3

    Uploaded by

    Tahir Kasim

    Copyright:

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

    Total 600.00 506.41 124.56 34.83 3.56 0.12: Iteration 0 Iteration 1 Iteration 2 Iteration 3

    Uploaded by

    Tahir Kasim
    6 views2 pages

    Original Title

    haggessa

    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
    6 views2 pages

    Total 600.00 506.41 124.56 34.83 3.56 0.12: Iteration 0 Iteration 1 Iteration 2 Iteration 3

    Uploaded by

    Tahir Kasim

    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 2

    t Payment NPV NPV NPV NPV NPV

    1 -1,000.00 506.41 124.56 34.83 3.56 0.12


    2 100.00 1,511.48 1,132.54 1,037.68 1,003.87 1,000.13
    3 100.00 1,426.59 1,105.15 1,022.52 992.83 989.53
    4 150.00 1,340.86 1,076.00 1,006.13 980.81 977.99
    5 150.00 1,204.27 994.99 938.39 917.72 915.41
    6 200.00 1,066.31 908.78 865.11 849.04 847.24
    7 200.00 876.97 767.04 735.85 724.28 722.98
    8 200.00 685.74 616.21 596.01 588.46 587.61
    9 250.00 492.60 455.72 444.74 440.61 440.14
    10 250.00 247.52 234.94 231.10 229.65 229.49
    Total 600.00 506.41 124.56 34.83 3.56 0.12

    Iteration 0 Iteration 1 Iteration 2 Iteration 3


    Discounting Rate = 0% 1.0% 6.41111% 8.17615% 8.86140% 8.93929%
    Error = -88.81674% -28.30284% -8.56400% -0.90059% -0.02953%

    IRR = 8.94194%
    IRR (est) = 8.94194%
    NPV NPV
    0.00 0.00 www.excely.com
    1,000.00 1,000.00 More Excel Templates, Arcticles
    about Excel and VBA
    989.42 989.42 development
    977.89 977.89
    915.34 915.34
    847.18 847.18
    722.94 722.94
    587.58 587.58
    440.12 440.12
    229.48 229.48
    0.00 0.00

    Iteration 4 Iteration 5
    8.94193% 8.94194%
    -0.00010% 0.00000%

    You might also like