Present Value Formula Calculator and Worked Example

A present value formula calculator estimates what a future cash amount is worth today, given a discount rate and the time until payment. Enter the future value, annual discount rate, and number of years to see the present value, with the calculation shown below.

Formula

The present value of one future lump sum is:

PV = FV / (1 + r)ⁿ

• PV is present value, in the same currency as the future amount.
• FV is the future value, in currency units.
• r is the discount rate per period, expressed as a decimal in the formula. This calculator accepts an annual rate as a percentage and divides it by 100.
• n is the number of compounding periods. Here, periods are years, so the rate must also be annual.

The calculator also reports the discount, calculated as FV − PV. It is the difference between the future amount and its estimated value today. The formula assumes one payment at the end of the stated number of annual periods and a constant rate for those periods.

Worked Example

Using the calculator’s default inputs, the future value is $1,000, the annual discount rate is 5%, and the period is 3 years.

1. Convert the percentage to a decimal: 5% ÷ 100 = 0.05.
2. Substitute the values: PV = 1,000 / (1 + 0.05)³.
3. Calculate the growth factor: 1.05³ = 1.157625.
4. Divide: $1,000 / 1.157625 ≈ $863.84.

Present value: $863.84. The discount is $1,000 − $863.84 = $136.16, rounded to two decimal places.

What Present Value Means

Present value translates a future payment into a current amount using a selected rate. The core idea is the time value of money: an amount available now can potentially be used or invested before a later payment arrives. A discount rate expresses how strongly the calculation accounts for time and, depending on the analysis, uncertainty or opportunity cost.

Present value is not a prediction of the exact market price of a future payment. It is a result under stated assumptions. Change the discount rate or timing, and the calculated value changes. A higher positive rate, or a longer wait, generally makes the present value of a positive future sum smaller.

When to Use a Present Value Calculator

This calculation is useful when comparing amounts payable at different times or checking the value today of a single expected payment. It also provides a building block for more involved analyses, such as valuing a sequence of cash flows. Each cash flow in a sequence is discounted for its own timing, then the present values are added.

• Compare timing: Put a future lump sum and a current amount on a common “today” basis, using an appropriate rate.
• Test assumptions: Recalculate with different rates or dates to see how sensitive the result is.
• Understand a discount: Compare the future amount with its calculated present value.

For a real financial decision, the calculator supplies the arithmetic, not the right discount rate or a recommendation. Those depend on the purpose of the analysis and the reliability and timing of the expected cash flow.

Choosing the Rate and Period

The rate and period must use matching units. With an annual rate, enter time in years. If cash flows occur monthly and the analysis uses a monthly rate, the formula should use the monthly rate and number of months instead. Do not enter an annual percentage as though it were a monthly rate, or combine a monthly period count with an annual rate without conversion.

Also distinguish a nominal rate from an effective rate. If a stated annual rate compounds more frequently than once per year, the rate per period may not equal the annual percentage divided by the number of periods. The simple calculator uses annual compounding; use a formula that matches the compounding convention in your source data when it differs.

Common Errors and Limits

• Entering 5 instead of 5%: This calculator labels the rate as a percentage and converts 5 to 0.05. A formula or tool that expects a decimal would instead require 0.05.
• Mixing time units: A yearly rate belongs with years in this setup. Convert both consistently before calculating.
• Rounding too early: Keep the full intermediate result and round only the final displayed amount. Small rounding differences can otherwise build up, especially across multiple payments.
• Ignoring payment timing: The formula assumes payment at the end of the stated period. A payment today needs no discounting; one arriving partway through a year needs a matching fractional-period convention.
• Assuming certainty: The output does not account automatically for missed payments, changing rates, inflation, taxes, fees, or other conditions.

Currency symbols identify the unit of the example, but the mathematics works with any currency. Keep the future amount and present value in the same currency; the formula does not convert currencies or adjust for exchange-rate changes.

Frequently Asked Questions

What is the present value formula?
For one future amount, use PV = FV / (1 + r)ⁿ, where r is the rate per period and n is the number of periods. The rate and period must match.

How do I calculate present value in Excel or Google Sheets?
For a single amount with annual compounding, enter a formula equivalent to =future_value/(1+annual_rate)^years. If the rate is entered as 5%, use the percentage directly; if entered as 5, divide by 100 first. Spreadsheet functions may use different sign conventions, so check their documentation.

Can present value be greater than future value?
It can be if the chosen rate is negative for the period, because the discount factor is then below 1. With a positive rate and a positive future amount, present value is smaller than future value.

Is present value the same as net present value?
No. Present value discounts future cash flows to today. Net present value generally adds the present values of relevant cash inflows and outflows, including the initial amount, according to the analysis setup.

How do I find the present value of monthly payments?
Discount each payment using a rate and period measured in months, then add the results. For a level series of payments, an annuity formula can simplify the calculation, but payment timing and whether payments occur at the beginning or end of each period matter.

Related

• SPF Include vs Redirect: How to Choose & Avoid 5 Mistakes
• PS Remote Play: Smoother & Sharper on Any Handheld
• Roborock S8 Max Series: Top Features Explained

in fv | Future value | $ | 1000 | 0
in r | Annual discount rate | % | 5 | 0
in n | Years | years | 3 | 0
out pv | Present value | $ | fv / (1 + r / 100)^n | 2
out discount | Discount from future value | $ | fv - pv | 2