PV Function in Google Sheets: Value constant periodic cash flows today
Learn PV in Google Sheets with explicit inputs, worked scenarios, independently checked expectations and troubleshooting.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: Value constant periodic cash flows today with PV. The Google PV documentation supplies the contract summarized here.
Syntax and arguments
=PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning])
The first three inputs are the rate per period, number of payments and amount per payment. The optional future value is the remaining value after the final payment. Timing 0 means end-of-period payments and is Google’s documented default; 1 means beginning-of-period payments. The retrieved page does not state the future-value default, so every example supplies it explicitly.
Worked scenario: two repayments
For an illustrative financing model, take the borrower’s perspective: money received now is positive and future payments are negative. Use a 1% rate per period and two payments of 100 at the ends of the periods:
=PV(0.01,2,-100,0,0)
The independently derived expectation is approximately 197.0395059308. Discount the two outgoing payments separately: 100/1.01 + 100/1.01². This is the positive amount received today that balances them. The sign is part of this stated cash-flow model; the calculation is an independent expectation, not a captured Sheets result.
Advanced example: change when payments occur
With the same two payments made at the beginnings of the periods, use =PV(0.01,2,-100,0,1). The expected amount is approximately 199.0099009901. One 100 payment is immediate and the second is discounted one period: 100 + 100/1.01. Moving payments earlier increases their present magnitude.
Now retain end timing but include a final additional outflow of 50: =PV(0.01,2,-100,-50,0). The independent expectation is approximately 246.0543084011, obtained as 100/1.01 + 150/1.01². Draw the payment timeline before combining a remaining value with periodic payments.
Units and model checks
A monthly model needs a monthly rate and a number of months. If a stated annual rate is a nominal rate convertible monthly, dividing it by 12 supplies that monthly rate; do not silently apply that conversion to an effective annual rate. Google explicitly warns that rate, payment and period units must be consistent.
As a mathematical zero-interest control, two payments of 100 have present magnitude 200 when there is no discounting. Closed-form annuity expressions that divide by the rate require separate treatment at zero; direct undiscounted cash-flow addition supplies the mathematical control. This guide does not claim a native zero-rate execution or prescribe an undocumented implementation branch.
Troubleshooting and limitations
- A sign that looks unexpected may reflect opposite cash-flow perspectives. Label money received and money paid before changing a minus sign.
- Check timing before blaming a discrepancy on rounding.
- A varying payment schedule or varying rate is outside this constant-annuity model.
- The exact native error/coercion matrix, convergence behavior of other financial functions and undocumented defaults are not established here.
See PMT for the related payment problem. These examples are mathematical illustrations rather than financial advice or a lending quote.
Availability and version history
Documented in the rolling Google Sheets service. Documentation reviewed October 19, 2026; an introduction date or numbered release was not established. Examples use English function names, decimal points and comma separators; adapt separators to the sheet’s locale.
Verification scope and sources
The official reference establishes the syntax and function-specific contract. Worked values are original, independently derived expectations, not native Google Sheets observations. No account access, UI screenshot or cross-version execution was performed. Native behavior outside the documented scope remains unverified.