Scribd Logo
Upload

Welcome to Scribd!

  • 41 views

    Present Value Calculator V1.0

    Uploaded by

    EyeoSky
    The document contains a present value calculator that can calculate present value based on payment amount and period length, future value and period length, or compare the present value of two investments over the same period length. It provides an example of calculating the present value and gain/loss for two potential investments, Investment A and Investment B, over 4 years at a 12% interest rate, and recommends Investment A as it has a higher present value gain.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd

    Present Value Calculator V1.0

    Uploaded by

    EyeoSky
    41 views3 pages
    The document contains a present value calculator that can calculate present value based on payment amount and period length, future value and period length, or compare the present value of two investments over the same period length. It provides an example of calculating the present value and gain/loss for two potential investments, Investment A and Investment B, over 4 years at a 12% interest rate, and recommends Investment A as it has a higher present value gain.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains a present value calculator that can calculate present value based on payment amount and period length, future value and period length, or compare the present value of two investments over the same period length. It provides an example of calculating the present value and gain/loss for two potential investments, Investment A and Investment B, over 4 years at a 12% interest rate, and recommends Investment A as it has a higher present value gain.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    41 views3 pages

    Present Value Calculator V1.0

    Uploaded by

    EyeoSky
    The document contains a present value calculator that can calculate present value based on payment amount and period length, future value and period length, or compare the present value of two investments over the same period length. It provides an example of calculating the present value and gain/loss for two potential investments, Investment A and Investment B, over 4 years at a 12% interest rate, and recommends Investment A as it has a higher present value gain.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 3

    PRESENT VALUE CALCULATOR

    Based on payment amount and period length

    Interest Rate : 12.00% Present Value


    Period (Year) : 4
    10,630.72
    Payment : 3,500.00

    VISIT EXCELTEMPLATE.NET FOR MORE TEMPLATES AND UPDATES


    PRESENT VALUE CALCULATOR

    Based on future value and period length

    Interest Rate : 12.00% Present Value


    Period (Year) : 4
    8,897.25
    Future Value : 14,000.00

    VISIT EXCELTEMPLATE.NET FOR MORE TEMPLATES AND UPDATES


    PRESENT VALUE CALCULATOR

    Investment/Project A

    Interest Rate : 12.00% Present Value


    Period (Year) : 4 10,630.72
    Payment : 3,500.00 Present Value Gain/Loss
    Initial Investment : 10,000.00 630.72

    Investment/Project B

    Interest Rate : 12.00% Present Value


    Period (Year) : 4 8,897.25
    Future Value : 14,000.00 Present Value Gain/Loss
    Initial Investment : 10,000.00 (1,102.75)

    Recommendation : Investment A is better than Investment B

    VISIT EXCELTEMPLATE.NET FOR MORE TEMPLATES AND UPDATES

    You might also like