## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

# Calculate the Present Value of an Investment

You can use the PV function in Excel to help you determine the present value of an investment. Suppose that you win a prize and you are offered \$5,000 today or equal payments of \$100 per month for five years at an interest rate of eight percent compounded annually; which should you choose? The PV function can tell you and the organization offering the prize whether \$5,000 today is less than, equal to, or greater than the value of \$100 per month for five years at an interest rate of eight percent compounded annually. You can use the PV function to calculate the value of an annuity or to determine how much you will pay overall if you make a series of loan payments. ...

## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

No credit card required