Bookmarks    
nPr and nCr    
Random Number    
SD Calculator    
Sample Size    
Percent Error    
Density    
Molarity    
Molar Mass    
Ohm's Law    
Watts to Amps    
Voltage Drop    
Long Division    
Mixed Numbers    
Rounding    
Nth Root    
Exponents    
Half-Life    
Polar Form    
De Moivre    
3D Distance    
Point to Line    
Cross Product    
Determinant    
Sin Cos Tan    
Triangle Area    
Scale Factor    
Sector Area    
Ellipse Area    
Cube Volume    
Box Volume    
Sphere Volume    
Cone Volume    
Pipe Volume    
Time Duration    
Time Card    
Present Value    
Future Value    
Churn Rate    
A/B Test Calc    
SEO Traffic    
Ideal Weight    
Fat Intake    
Child Height    
Golf Handicap    
Heat Index    
Wind Chill    
Dew Point    
Download Time    
kWh to Cost    
AC Size (BTU)    
Heating Costs    
LED Savings    
Trip Gas Cost    
Tire Size    
Solar Output    
Solar Payback    
Battery Size    
Wall Area    
Gravel Needed    
Mortar Mix    
Slope Grade    
Curtain Size    
Soil Needed    
Sod Needed    
Ramp Length    
Blind Size    
Drain Slope    
Board Feet    
Heat Loss    
Furniture Fit    
Moving Boxes    
Plywood Cuts    
Shelf Sag    
   Add
Probability and random number calculators
Independent Events
Independent Events
Two Events Solver
Two Events Solver
Repeated Trials
Repeated Trials
Bayes' Theorem
Bayes' Theorem
Expected Value
Expected Value
Binomial Distribution
Binomial Distribution
nPr and nCr
nPr and nCr
Circular Permutation
Circular Permutation
With Repetition
With Repetition
Random Number
Random Number
Averages and statistics calculators
Average Calculator
Average Calculator
Mean Median Mode
Mean Median Mode
SD Calculator
SD Calculator
Quartiles & IQR
Quartiles & IQR
Frequency Table
Frequency Table
Correlation (r)
Correlation (r)
Normal Probability
Normal Probability
Z-Score Calculator
Z-Score Calculator
Confidence Interval
Confidence Interval
Sample Size
Sample Size
Mark & Recapture
Mark & Recapture
P-Value Calculator
P-Value Calculator
Percentage and ratio calculators
Percentage Calc
Percentage Calc
Percent Change
Percent Change
Percent Difference
Percent Difference
Percent Error
Percent Error
Ratio Calculator
Ratio Calculator
Discount Calculator
Discount Calculator
Sales Tax Calculator
Sales Tax Calculator
Margin Calculator
Margin Calculator
Speed calculators
Speed Calculator
Speed Calculator
Density and concentration calculators
Density
Density
Molarity
Molarity
Molar Mass
Molar Mass
Physics and electricity calculators
Ohm's Law
Ohm's Law
Watts to Amps
Watts to Amps
Resistor Colors
Resistor Colors
Voltage Drop
Voltage Drop
Unit conversion calculators
Weight Converter
Weight Converter
Shoe Size Converter
Shoe Size Converter
Integer and signed number calculators
Long Division
Long Division
LCM Calculator
LCM Calculator
GCF Calculator
GCF Calculator
Integer Calculator
Integer Calculator
Prime Factorization
Prime Factorization
Diophantine Solver
Diophantine Solver
Modulo Calculator
Modulo Calculator
Factor Calculator
Factor Calculator
Roman Numerals
Roman Numerals
Fraction, decimal and rounding calculators
Fraction Calculator
Fraction Calculator
Mixed Numbers
Mixed Numbers
Simplify Fractions
Simplify Fractions
Fraction to Decimal
Fraction to Decimal
Decimal to Fraction
Decimal to Fraction
Rounding
Rounding
Equation and inequality calculators
Linear Equation
Linear Equation
Linear Systems
Linear Systems
Quadratic Formula
Quadratic Formula
Absolute Value
Absolute Value
Quadratic Inequality
Quadratic Inequality
Polynomial calculators
Binomial Theorem
Binomial Theorem
Square root and nth root calculators
Simplify Radicals
Simplify Radicals
Nth Root
Nth Root
Exponent and logarithm calculators
Exponents
Exponents
Log Calculator
Log Calculator
Number of Digits
Number of Digits
Scientific Notation
Scientific Notation
Sci. Notation Math
Sci. Notation Math
Half-Life
Half-Life
Complex number calculators
Complex Numbers
Complex Numbers
Polar Form
Polar Form
De Moivre
De Moivre
Function and graph calculators
Slope Calculator
Slope Calculator
Linear Function
Linear Function
Direct & Inverse Variation
Direct & Inverse Variation
y = ax² Calculator
y = ax² Calculator
Distance Formula
Distance Formula
3D Distance
3D Distance
Section Formula
Section Formula
Point to Line
Point to Line
Lat/Long Distance
Lat/Long Distance
Complete the Square
Complete the Square
Circle Equation
Circle Equation
Conic Sections
Conic Sections
Polar Coordinates
Polar Coordinates
Sequence calculators
Arithmetic Sequence
Arithmetic Sequence
Geometric Sequence
Geometric Sequence
Fibonacci Sequence
Fibonacci Sequence
Recurrence Relation
Recurrence Relation
Vector calculators
Vector Calculator
Vector Calculator
Cross Product
Cross Product
Matrix calculators
Matrix Calculator
Matrix Calculator
Determinant
Determinant
Inverse Matrix
Inverse Matrix
Plane geometry calculators
Sin Cos Tan
Sin Cos Tan
Degrees ⇔ Radians
Degrees ⇔ Radians
a sin θ + b cos θ
a sin θ + b cos θ
Triangle Solver
Triangle Solver
Triangle Area
Triangle Area
Right Triangle
Right Triangle
Pythagorean Theorem
Pythagorean Theorem
Polygon Angles
Polygon Angles
Scale Factor
Scale Factor
Parallel Lines
Parallel Lines
Rectangle Area
Rectangle Area
Parallelogram Area
Parallelogram Area
Trapezoid Area
Trapezoid Area
Circle Calculator
Circle Calculator
Sector Area
Sector Area
Inscribed Angle
Inscribed Angle
Ellipse Area
Ellipse Area
Solid geometry calculators
Cube Volume
Cube Volume
Cube Surface Area
Cube Surface Area
Box Volume
Box Volume
Box Surface Area
Box Surface Area
Cylinder Volume
Cylinder Volume
Cylinder Surface
Cylinder Surface
Sphere Volume
Sphere Volume
Sphere Surface
Sphere Surface
Spherical Cap Volume
Spherical Cap Volume
Cap Surface Area
Cap Surface Area
Ellipsoid Volume
Ellipsoid Volume
Ellipsoid Surface
Ellipsoid Surface
Pyramid Volume
Pyramid Volume
Pyramid Surface
Pyramid Surface
Cone Volume
Cone Volume
Cone Surface Area
Cone Surface Area
Frustum Volume
Frustum Volume
Frustum Surface Area
Frustum Surface Area
Pipe Volume
Pipe Volume
Capsule Volume
Capsule Volume
Capsule Surface Area
Capsule Surface Area
Date and time calculators
Age Calculator
Age Calculator
Days Between Dates
Days Between Dates
Date Calculator
Date Calculator
Hours From Now
Hours From Now
Day of the Week
Day of the Week
Time Calculator
Time Calculator
Time Zone Converter
Time Zone Converter
Hours Calculator
Hours Calculator
Time Duration
Time Duration
Time Card
Time Card
Finance and economics calculators
Compound Interest
Compound Interest
Simple Interest
Simple Interest
Interest Calculator
Interest Calculator
TVM Calculator
TVM Calculator
Present Value
Present Value
Future Value
Future Value
ROI Calculator
ROI Calculator
IRR Calculator
IRR Calculator
Payback Period
Payback Period
Average Return
Average Return
GDP Calculator
GDP Calculator
Web marketing and ad metric calculators
CTR Calculator
CTR Calculator
Conversion Rate
Conversion Rate
CPC, CPM & CPA
CPC, CPM & CPA
ROAS Calculator
ROAS Calculator
Break-Even CPA
Break-Even CPA
LTV Calculator
LTV Calculator
CAC Calculator
CAC Calculator
Churn Rate
Churn Rate
A/B Test Calc
A/B Test Calc
A/B Sample Size
A/B Sample Size
SEO Traffic
SEO Traffic
Break-Even Point
Break-Even Point
Markup vs. Margin
Markup vs. Margin
CAGR Calculator
CAGR Calculator
Health and fitness calculators
BMI Calculator
BMI Calculator
Sleep Calculator
Sleep Calculator
Calorie Calculator
Calorie Calculator
BMR Calculator
BMR Calculator
TDEE Calculator
TDEE Calculator
Ideal Weight
Ideal Weight
Body Fat Calculator
Body Fat Calculator
Lean Body Mass
Lean Body Mass
Calories Burned
Calories Burned
Protein Intake
Protein Intake
Macro Calculator
Macro Calculator
Carb Calculator
Carb Calculator
Fat Intake
Fat Intake
Child Height
Child Height
Sports calculators
Golf Handicap
Golf Handicap
Pace Calculator
Pace Calculator
1RM Calculator
1RM Calculator
Target Heart Rate
Target Heart Rate
Weather calculators
Heat Index
Heat Index
Wind Chill
Wind Chill
Dew Point
Dew Point
Computer calculators
Base Converter
Base Converter
Subnet Calculator
Subnet Calculator
Download Time
Download Time
Household energy and budget calculators
Electricity Cost
Electricity Cost
kWh to Cost
kWh to Cost
Yearly kWh to Cost
Yearly kWh to Cost
AC Size (BTU)
AC Size (BTU)
AC Running Cost
AC Running Cost
Heating Costs
Heating Costs
Gas vs Electric
Gas vs Electric
LED Savings
LED Savings
Salary Calculator
Salary Calculator
Budget Calculator
Budget Calculator
Car calculators
Trip Gas Cost
Trip Gas Cost
EV Charging Cost
EV Charging Cost
EV vs Gas Cost
EV vs Gas Cost
MPG Calculator
MPG Calculator
Tire Size
Tire Size
Solar power and battery calculators
Solar Output
Solar Output
Solar Panel Count
Solar Panel Count
Solar Payback
Solar Payback
Battery Size
Battery Size
Home and DIY calculators
Tile Calculator
Tile Calculator
Stair Calculator
Stair Calculator
Concrete Volume
Concrete Volume
Wall Area
Wall Area
Wallpaper Rolls
Wallpaper Rolls
Paint Calculator
Paint Calculator
Flooring Needed
Flooring Needed
Exterior Walls
Exterior Walls
Gravel Needed
Gravel Needed
Mortar Mix
Mortar Mix
Slope Grade
Slope Grade
Lumber Cut List
Lumber Cut List
Lot Coverage/FAR
Lot Coverage/FAR
Sheet Vinyl Roll
Sheet Vinyl Roll
Insulation Needed
Insulation Needed
Curtain Size
Curtain Size
TV Size & Distance
TV Size & Distance
Soil Needed
Soil Needed
Sod Needed
Sod Needed
Block Calculator
Block Calculator
Brick Calculator
Brick Calculator
Deck Materials
Deck Materials
Ramp Length
Ramp Length
Pilot Hole Size
Pilot Hole Size
Room Ventilation
Room Ventilation
Paint Thinning
Paint Thinning
Baseboard & Trim
Baseboard & Trim
Blind Size
Blind Size
Picture Hanging
Picture Hanging
Drain Slope
Drain Slope
Screw Calculator
Screw Calculator
Board Feet
Board Feet
Fence Calculator
Fence Calculator
Wood Shrinkage
Wood Shrinkage
Caulk Calculator
Caulk Calculator
Heat Loss
Heat Loss
Furniture Fit
Furniture Fit
Moving Boxes
Moving Boxes
Storage Capacity
Storage Capacity
Plywood Cuts
Plywood Cuts
Shelf Sag
Shelf Sag

Present Value Calculator (Discounting and Present Value of an Annuity)

Choose a mode and enter the future amount, the number of periods and the rate. The calculator finds what the future money is worth today (its present value).

Enter all amounts as positive numbers (there is no sign convention as on a financial calculator). The rate is the % per period (for yearly payments it is the annual rate itself; for 6%, enter "6"). This is a math calculation with a fixed rate and does not include fees, taxes or rate changes of real products.
Result and graph
Enter the future amount, number of periods and interest rate on the left and press "Calculate". The result and a graph will appear here.

What you can do on this page

  • Enter the amount of money you will receive after \(N\) periods, the number of periods and the rate, and you get what that future money is worth today (the present value \(PV\)) and the amount of the discount (\(FV - PV\))
  • Switch the mode to find the present value of an annuity, where you receive the same amount every period. Payments at the beginning or end of each period are supported. For reference you also get the future value, the total of payments and the total interest, plus a period-by-period table when the number of periods is a whole number up to 20
  • A graph shows how discounting winds future money back to its value today (save as PNG or SVG)
  • All amounts on this page are entered as positive numbers. There is no financial-calculator sign convention (money out is negative), so it is easy even the first time
  • A plain-language explanation of the formulas and copy-and-paste formulas for Excel (PV function), Google Sheets and Python are all on this page
This page is a math calculation that assumes the interest rate stays the same for the whole period. Real savings, annuities and investments involve fees, taxes and changing rates, so check the exact amounts with your bank or provider. This page does not recommend any financial product. Use it to understand the value of money over time and for studying finance and accounting.

What is this calculation used for?

Answering "Is $10,000 today worth more than $10,000 in 10 years?" with numbers

The answer is "$10,000 today". If money can earn 2% a year, the present value of $10,000 in 10 years is \(10000 \div 1.02^{10} \approx 8203.48\) dollars, about $1,797 less than $10,000 today.
Present value turns the feeling that "getting the same amount sooner is better" into a number, based on an assumed rate of return. The return you give up by waiting is called the opportunity cost.

Comparing a lottery lump sum with annual payments

Big US lotteries such as Powerball and Mega Millions let winners choose a lump sum (the cash option, a smaller amount) or an annuity paid over many years (a larger total), and present value is exactly how to compare them. For example, $1 million a year for 20 years ($20 million in total), discounted at 3%, has a present value of about $14.88 million. If the lump sum offered were $15 million, it would be worth slightly more under this assumption.
The conclusion depends on the rate you think you could earn (the assumed discount rate). In practice, you calculate with several discount rates and look for the point where the answer flips (taxes are not included here).

Thinking about a pension lump sum versus monthly payments

Some employers with a pension plan let retirees choose a one-time lump sum instead of regular pension payments. For example, if you expect $30,000 a year for 20 years ($600,000 in total), discounting at 4% gives a present value of about $407,710. Putting the lump sum offer next to this present value is where the comparison starts.
In a real decision, taxes, how long you expect to live, and what the plan guarantees matter a lot, so this calculation isolates only the time value part. Do not treat it as a final answer; check the rules in your plan documents or with a qualified professional.

Pricing a zero-coupon bond

A zero-coupon bond pays one amount at maturity and nothing before. A bond that pays $10,000 in 15 years, discounted at 4% a year, has a present value of about $5,552.65. That is roughly the price such a bond would sell for today when similar investments earn 4%.
The same idea shows why bond prices fall when interest rates rise: a higher discount rate makes the same future payment worth less today. This helps when you compare bonds, CDs and other fixed payments in the future.

The foundation of business investment decisions (NPV)

NPV (net present value), the standard method companies use to decide on new equipment or projects, turns each future cash flow, such as sales or costs, into its present value with the formula on this page and adds them all up. If the total is positive, the investment is expected to grow faster than the discount rate.
The same calculation is used in accounting, corporate finance and the cost-benefit analysis of public projects, so discounting is a common language across money-related work.

Formulas and graphs

Present value of a future lump sum (discounting)
Graph
Standard notation (the usual math form)
\(PV\) \(=\) \(FV\) \(\div\) \((1+r)\) \(N\)
In words (symbols replaced with words)
④ \(PV\): present value \(=\) ① \(FV\): future value \(\div\) ② growth factor for one period ③ \(N\): number of periods
The formula in words
① Take the money you will receive in the future, the \(FV\): future value
② and divide it by the growth factor for one period \((1+r)\)
③ multiplied by itself once for each of the \(N\): number of periods
④ and you get the \(PV\): present value
Quick example
If money can earn 10% a year, the value today (present value) of $121 received in 2 years is
\(PV\): present value \(=\) future value ($121) \(\div\) growth factor (1.1) periods (2)
\(1.1 \times 1.1 = 1.21\)
\(121 \div 1.21 = 100\)
Key idea
This calculation is called discounting. It is the exact reverse of compound interest ($100 today → $121 in 2 years): it winds future money back to its value today. At 10% a year, $100 today can grow to $121 in 2 years, so "$121 in 2 years" and "$100 today" are worth the same. This is the idea of present value. The difference of $21 (\(FV - PV\)) is the amount of the discount, the interest you would have earned while waiting. A related term, NPV (net present value), is the sum of these present values over all the money coming in and going out (money received counted as plus, money paid as minus). The calculation on this page, the present value of one amount, is the building block of NPV.
Present value of payments each period (ordinary annuity, end of period)
Graph
Standard notation (the usual math form)
\(PV\) \(=\) \(PMT\) \(\times\) \(\dfrac{1-(1+r)^{-N}}{r}\)
In words (symbols replaced with words)
③ \(PV\): present value \(=\) ① payment each period \(\times\) ② present value annuity factor
The formula in words
① Take the \(PMT\): payment each period
② multiply it by the present value annuity factor (the value today of receiving $1 every period)
③ and you get the \(PV\): present value
Quick example
At 6% a year, the value today of receiving $100 every year for 10 years (at the end of each year) is
\(PV\): present value \(=\) payment ($100) \(\times\) annuity factor (about 7.36)
\(\dfrac{1 - 1.06^{-10}}{0.06} \approx 7.3601\)
\(100 \times 7.3601 \approx 736.01\)
Key idea
You receive $100 × 10 years = $1,000 in total, but it is worth only about $736 today, because payments further in the future are discounted more. The multiple \(\dfrac{1-(1+r)^{-N}}{r}\), the value today of receiving $1 every period, is called the present value annuity factor (the P/A factor in engineering economics). The \((1+r)^{-N}\) in the formula has a negative exponent, which says "divide by \((1+r)^{N}\)" (the same step as the discounting in formula 1). So this formula combines "the discounted payment after 1 period + after 2 periods + … + after \(N\) periods" into one. At a 0% rate there is no discount, so the present value is simply \(PMT \times N\) (the total of the payments).
Payments at the beginning of each period (annuity due)
Graph
Standard notation (the usual math form)
\(PV\) \(=\) \(PMT\) \(\times\) \(\dfrac{1-(1+r)^{-N}}{r}\) \(\times\) \((1+r)\)
In words (symbols replaced with words)
④ \(PV\): present value \(=\) ① payment each period \(\times\) ② present value annuity factor \(\times\) ③ growth factor for one period
The formula in words
① As in the end-of-period formula, take the \(PMT\): payment each period
② multiply it by the present value annuity factor
③ then multiply once more by the growth factor for one period \((1+r)\)
④ and you get the \(PV\): present value
Quick example
At 5% a year, the value today of receiving $200 every year for 5 years, at the beginning of each year, is
\(PV\): present value \(=\) payment ($200) \(\times\) annuity factor (about 4.33) \(\times\) growth factor (1.05)
\(200 \times \dfrac{1 - 1.05^{-5}}{0.05} \approx 865.895\)
\(865.895 \times 1.05 \approx 909.19\)
Key idea
With payments at the beginning, each payment arrives one period earlier than with payments at the end. Money received earlier can be invested earlier, so the present value is \((1+r)\) times larger than for payments at the end (1.05 times in this example). Rent and lease payments made in advance work this way.
Present value is future money discounted by the growth it could earn with interest, turned into its value today. For a lump sum you divide by \((1+r)^N\); for payments each period you multiply by the present value annuity factor. Both are the exact reverse of compound interest.

Symbols and terms

Symbols

\(PV\) P V Present value. What future money is worth in today's money. This is the value this page finds.
\(FV\) F V Future value. The amount of money you receive at a future time. You enter it in the "Future lump sum" mode; in the annuity mode it is shown for reference.
\(PMT\) payment The payment each period. The amount you receive (or save) every period.
\(N\) N The number of periods that earn interest. With yearly payments it equals the number of years: 10 years is \(N = 10\).
\(I/Y\) I over Y The interest rate per period in % (the name comes from the "interest per year" key on a financial calculator). With yearly payments it is the annual rate itself.
\(r\) r The interest rate per period as a decimal. For 6%, \(r = 0.06\) (\(I/Y \div 100\)).
\((1+r)^N\) one plus r to the N How many times money grows in \(N\) periods. At 6% a year for 10 years, it is \(1.06^{10} \approx 1.79\) times. Present value divides by this factor to wind future money back to today.
\((1+r)^{-N}\) one plus r to the negative N A negative exponent says "divide by \((1+r)^N\)". As in \(1.06^{-10} = 1 \div 1.06^{10}\), it lets you write discounting as a multiplication.

Terms

present value What future money is worth in today's money. For example, if money can earn 2% a year, $10,200 one year from now is worth the same as $10,000 today.
future value How much money now, or regular savings, will be worth in the future, including interest. It is the exact counterpart of present value.
discounting Turning future money into its present value. You divide the future amount by \((1+r)^N\), so the value goes down. It is exactly the reverse of growing money with interest (compounding).
discount rate The rate used for discounting; the rate I/Y on this page. It is the rate at which you think the money could grow, and the higher it is, the lower the value today of future money.
annuity In math and finance, a stream of equal payments made every period. Not only pensions and insurance annuities, but also installment payments and regular savings have this form.
present value annuity factor The multiple \(\dfrac{1-(1+r)^{-N}}{r}\): what the right to receive $1 every period is worth today. In engineering economics it is the P/A factor, one of the six standard interest factors. You multiply it by the payment each period.
NPV (net present value) The sum of the present values of all the money in and out, counting money received as plus and money paid as minus. It is used to judge business projects and investments, and the present value of one amount on this page is its building block.
opportunity cost The gain you would have had if you had used the money for something else, such as investing it. Future money is worth less than money today because while you wait, you lose the chance to invest it (you pay an opportunity cost).
ordinary annuity Payments received at the end of each period. Most annuities and savings plans work this way.
annuity due Payments received at the beginning of each period. Each payment arrives one period earlier than in an ordinary annuity, so the present value is \((1+r)\) times larger.
compound interest Interest that also earns interest. The present value calculation uses the compound growth factor \((1+r)^N\) on the dividing side.

Good to know before you start

Here is what helps you use the calculation on this page with real understanding, not just by pressing the button.

Percents (Grades 6–7)
  • Being able to write "6%" as the decimal 0.06
  • Knowing that "grows by 6%" is the same as "× 1.06"
Exponents (Grades 6–8)
  • Knowing that \(1.06^{10}\) is "1.06 multiplied together 10 times"
Basics of compound interest ("Compound Interest Calculator" on this site)
  • Understanding compound interest, where the interest you earn also earns interest
  • Picturing present value as the exact reverse of growing money with compound interest (the dividing side)
Negative exponents (Algebra 1 and 2, advanced)
  • Knowing that \((1+r)^{-N}\) says "divide by \((1+r)^{N}\)" (if not, the calculator does it for you)

How to calculate it in Excel

Copy the whole table below and paste it into cell A1 in Excel. It works as is.
Table for the present value of a future lump sum (PV function)
Rate per period (6% = 0.06) 0.06
Number of periods N 10
Future value FV 1000
Present value PV =-PV(B1,B2,0,B3)
Table for the present value of payments (end of period, PV function)
Rate per period (6% = 0.06) 0.06
Number of periods N 10
Payment each period PMT 100
Present value PV =-PV(B1,B2,B3,0,0)
Table for the present value of payments (beginning of period, PV function)
Rate per period (5% = 0.05) 0.05
Number of periods N 5
Payment each period PMT 200
Present value PV =-PV(B1,B2,B3,0,1)
Excel has a built-in present value function, PV(rate, number of periods, payment, future value, timing).
The PV function follows the financial-calculator sign convention (if you enter money you receive, the answer is negative), so put a minus sign in front, "=-PV(...)", to get the same positive amount as this page.
The first table shows 558.39 in B4, the second 736.01, and the third 909.19. The last argument is the payment timing: 0 or omitted = end of period, 1 = beginning of period.

How to calculate it in Google Sheets

Copy the whole table below and paste it into cell A1 in Google Sheets. It works as is.
Table for the present value of a future lump sum (PV function)
Rate per period (6% = 0.06) 0.06
Number of periods N 10
Future value FV 1000
Present value PV =-PV(B1,B2,0,B3)
Table for the present value of payments (end of period, PV function)
Rate per period (6% = 0.06) 0.06
Number of periods N 10
Payment each period PMT 100
Present value PV =-PV(B1,B2,B3,0,0)
Table for the present value of payments (beginning of period, PV function)
Rate per period (5% = 0.05) 0.05
Number of periods N 5
Payment each period PMT 200
Present value PV =-PV(B1,B2,B3,0,1)
Google Sheets has the same PV function with the same sign convention as Excel. Copy the whole table, paste it into cell A1, and replace the inputs in column B with your own numbers.

How to calculate it in Python

future_value = 1000       # future value FV (used for the lump sum)
payment = 100             # payment each period PMT (used for the annuity)
periods = 10              # number of periods N
rate_percent = 6          # rate per period I/Y (%)
is_beginning = False      # True = beginning of period, False = end of period (used for the annuity)

r = rate_percent / 100

# Present value of a future lump sum: PV = FV / (1+r)^N
pv_lump = future_value / (1 + r) ** periods
print(f"Present value of the lump sum = {pv_lump:,.2f}")
print(f"Amount of the discount = {future_value - pv_lump:,.2f}")

# Present value of payments each period (annuity). At a 0% rate there is no discount = PMT x N
if r == 0:
    pv_annuity = payment * periods
else:
    pv_annuity = payment * (1 - (1 + r) ** (-periods)) / r
    if is_beginning:
        pv_annuity *= (1 + r)
print(f"Present value of the payments = {pv_annuity:,.2f}")
Runs with the standard library only. "**" is a power, and the negative exponent "** (-periods)" says "divide by (1+r) to the power N". Change the inputs at the top and run it.

How to write it in LaTeX and other math languages (copy and paste)

Present value of a future lump sum (discounting)
PV = FV / (1 + r)ᴺ
PV = \dfrac{FV}{(1+r)^{N}}
<math xmlns="http://www.w3.org/1998/Math/MathML" display="block">
  <mrow>
    <mi>PV</mi>
    <mo>=</mo>
    <mfrac>
      <mi>FV</mi>
      <msup>
        <mrow><mo>(</mo><mn>1</mn><mo>+</mo><mi>r</mi><mo>)</mo></mrow>
        <mi>N</mi>
      </msup>
    </mfrac>
  </mrow>
</math>
PV = FV / (1+r)^N
pv = fv/(1 + r)^n
pv := fv/(1 + r)^n;
pv = fv/(1 + r)^n;
PV = FV/(1+r)^N
Present value of payments each period (ordinary annuity, end of period)
PV = PMT × (1 − (1 + r)⁻ᴺ) / r
PV = PMT \cdot \dfrac{1-(1+r)^{-N}}{r}
<math xmlns="http://www.w3.org/1998/Math/MathML" display="block">
  <mrow>
    <mi>PV</mi>
    <mo>=</mo>
    <mi>PMT</mi>
    <mo>&#x22C5;</mo>
    <mfrac>
      <mrow>
        <mn>1</mn>
        <mo>&#x2212;</mo>
        <msup>
          <mrow><mo>(</mo><mn>1</mn><mo>+</mo><mi>r</mi><mo>)</mo></mrow>
          <mrow><mo>&#x2212;</mo><mi>N</mi></mrow>
        </msup>
      </mrow>
      <mi>r</mi>
    </mfrac>
  </mrow>
</math>
PV = PMT (1 - (1+r)^(-N)) / r
pv = pmt (1 - (1 + r)^(-n))/r
pv := pmt*(1 - (1 + r)^(-n))/r;
pv = pmt*(1 - (1 + r)^(-n))/r;
PV = PMT(1-(1+r)^(-N))/r
Payments at the beginning of each period (annuity due)
PV = PMT × (1 − (1 + r)⁻ᴺ) / r × (1 + r)
PV = PMT \cdot \dfrac{1-(1+r)^{-N}}{r} \cdot (1+r)
<math xmlns="http://www.w3.org/1998/Math/MathML" display="block">
  <mrow>
    <mi>PV</mi>
    <mo>=</mo>
    <mi>PMT</mi>
    <mo>&#x22C5;</mo>
    <mfrac>
      <mrow>
        <mn>1</mn>
        <mo>&#x2212;</mo>
        <msup>
          <mrow><mo>(</mo><mn>1</mn><mo>+</mo><mi>r</mi><mo>)</mo></mrow>
          <mrow><mo>&#x2212;</mo><mi>N</mi></mrow>
        </msup>
      </mrow>
      <mi>r</mi>
    </mfrac>
    <mo>&#x22C5;</mo>
    <mrow><mo>(</mo><mn>1</mn><mo>+</mo><mi>r</mi><mo>)</mo></mrow>
  </mrow>
</math>
PV = PMT (1 - (1+r)^(-N)) / r * (1+r)
pv = pmt (1 - (1 + r)^(-n))/r (1 + r)
pv := pmt*(1 - (1 + r)^(-n))/r*(1 + r);
pv = pmt*(1 - (1 + r)^(-n))/r*(1 + r);
PV = PMT(1-(1+r)^(-N))/r (1+r)

How to have ChatGPT  do the calculation

You are a present value calculation assistant. Do the following calculation by actually running Python code, and base your answer only on the numbers from the execution result (do not answer by mental math or guessing).

The rate is a constant 6% per period (r = 0.06).
Find each of the following:
1. The present value of $1,000 received in 10 years: PV = FV / (1+r)^N
2. The amount of the discount (FV − PV)
3. The present value of receiving $100 every year for 10 years, at the end of each year: PV = PMT × (1 − (1+r)^(−N)) / r

Show the formulas you used and the numbers from the execution result.

How to Use
  1. 1
    Enter your numbers
    Type the numbers you want to calculate with into the input fields
  2. 2
    Calculate
    Press the "Calculate" button
  3. 3
    Check the result
    The result appears on the spot. The same page also explains the idea behind the calculation and the formula
  DataChef Features
Easy and Free
Unlimited conversions for free.
No technical knowledge required.
Intuitive and user-friendly operation.
No Registration Required
Available immediately after access.
Can be used without registering personal information.
Safe and Secure
Fully SSL encrypted communication.
Automatic file deletion by clicking "download".
Fast
High-speed site access
and rapid file conversion.
No Watermark
No watermark.
No attribution required.
Commercial Use Available
Free for commercial use.
No need to contact us for commercial use permission.