Present Value Calculator

  • Version
  • 3'949 Downloads
  • 21 KB File Size
  • January 4, 2022 Updated
  • 4 Number of comments
  • Rating
table of content

When somebody from financial institution come to you and offer some investment opportunities, usually they will hand you the table of the value of your money after some period of time. This table is usually calculated from present or future value calculation. Where your current money will be treated as a present value parameter.

And from the term written in wiki, present value itself is the value on a given date of a future payment, discounted to reflect the time value of money and other factors such as investment risk. As you can find in some investment opportunities offering, present value calculations are widely used in business and economics to provide a means to compare cash flows at different times on a meaningful "like to like" basis.

Present Value Calculator

This present value or pv calculator consist of three worksheets. The first worksheet is used to calculate present value based on interest rate, period and yearly payment. Say, that somebody offering you an investment where you have to invest USD 10,000 for 4 years and they will pay you USD 3500 per year. So, you have to compare whether it is worth to invest on it or just put it in a bank with 12% interest rate. The calculation show that the present value of your money is higher than your current money. So, the investment is profitable for you because it give interest more than your bank.

The second worksheet has the same example with the first one, except the investment proposal will pay you once by the end of 4 year period, with amount USD 14,000. The calculation result gives you the value of your money is less than the value of your current money. So, it is not profitable. Don't be tempted with the absolute different (14,000 - 10,000) because if you put your money in bank, the value after 4 years will be more than USD 14,000.

The third worksheet is pv comparator worksheet which compare side by side the investment calculated in the first worksheet and the second worksheet, so you can see it objectively. And still, as I always put in all my financial calculator, use this calculator as your side reference only, because the calculation method for some investment should be different than this standard calculation method.

You can play around with the calculator and download it here.

How useful was this template?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 18

No votes so far! Be the first to rate this template.

We are sorry 🙁

Help us improve!

How we can improve this template?

Grocery List Cost Estimator

38 KB / 4044 downloads
Electricity Consumption Calculator

44 KB / 15563 downloads
Grocery Price Comparison Spreadsheet

38 KB / 23492 downloads
Event Budget

29 KB / 3149 downloads
Payment Schedule Template

23 KB / 7252 downloads
Extra Payment Calculator

248 KB / 9608 downloads
Financial Ratio Calculator

302 KB / 13272 downloads
House Affordability Calculator

8 KB / 3856 downloads
Annuity Calculator

14 KB / 4663 downloads
View Comments