When putting deposits to a saving account, paying home mortgage and the like, you usually make the same payments at regular intervals, e.g. How to calculate present value in Excel - formula examples.If you wish to find the current worth of money, then you need to calculate present value, and this tutorial shows how to quickly do this in Excel. If you are curious to know the worth of your investment after a certain period, calculate its future value as explained in the FV function tutorial. There are two main terms that measure how much the value of money changes over time: future value (FV) and present value (PV). In the financial world, this is explained by the time value of money concept. If offered a choice to receive a certain sum of money right now or defer the payment into the future, which would you choose? For most people, taking money now is a natural instinct. What is present value of annuity? What is the present value formula? What discount or interest rate to use for present value calculation? Essentially, this tutorial gives answers to three 'what' questions.
