Formulas > =PV()

How To Use PV() Function in Google Sheets


Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate.

Common questions about the PV formula include:
- What is the PV formula?
- How does the PV formula work?
- What is the difference between PV and NPV?

The PV formula can be used appropriately to evaluate potential investments by measuring the present value or expected amount of cash that would be returned after making a certain investment.

The PV formula can be commonly mistyped when assigning incorrect order of operations with the formula (PV = FV (1+r)^n). When written incorrectly, the formula might result inaccurately.

Common ways that the PV formula is used inappropriately include calculating negative future values, incorrectly inputting discounts or premiums, incorrectly inputting inflation factors, and incorrectly inputting compounding periods.

Common pitfalls when using the PV formula include not considering all of the factors that need to be included in the calculation such as inflation rate or compounding period.

Common mistakes when using the PV Formula include not understanding the terms being used in the equation, such as present value, future value, periodic rate, and growth rate.

Common misconceptions people might have with the PV Formula include that it can predict future outcomes, but in reality the formula is limited to assessing the present value of a given investment. Another common misconception is that the PV formula is an incorrect way of measuring risk, when in fact it is one of the most reliable methods of assessing financial risks.

How To Actually Use PV() in Sheets

PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning])

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the PV() formula:

Google Sheets Finance Functions, Future Value & Present Value Explained,(FV, PV) Tutorial - Part 1

Learn how to use future value & presnet value financial functions in Google Sheets. This tutorial will explain step by step how to use FV & PV functions and what exactly you get when using different options of these functions.

Generate a PV() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.