Function Problems

Fix Excel PV Formula Returning Incorrect Value Compared to Calculator

Jason MillerJason Miller Oct 22, 2026 871 views

Question details

The user receives an unexpected result from the Excel PV formula compared to a standard financial calculator because of an unintended payment (PMT) argument.

Fix Excel PV Formula Returning a Different Value Than a Calculator
Product
Excel
Device & OS
not provided
Scenario
Calculating the present value of a future single sum using the PV function in a spreadsheet.
Observed behavior
The formula =PV(10%,3,1,-100) returns approximately 72.64 instead of the expected 75.13 because it mistakenly includes a periodic payment of 1.
Before you start

Verify the exact parameters of your financial calculation, clearly distinguishing between a one-time future value and recurring periodic payments.

Solution 1Recommended

Adjust the PMT Argument to Zero in the PV Formula

Correct the formula by setting the payment (PMT) argument to zero to ensure Excel only calculates the present value of a single future sum.

The PV function syntax is PV(rate, nper, pmt, [fv], [type]). When you input '1' as the third argument (pmt), Excel assumes a recurring payment of 1 is made every period alongside the final future value. If there are no recurring payments in your scenario, this argument must be explicitly set to 0.

1
Edit the cell formula

Double-click the spreadsheet cell containing your PV formula to enter edit mode.

2
Locate the PMT argument

Identify the third argument in your formula, which represents the periodic payment. In =PV(10%,3,1,-100), this is the '1'.

3
Change PMT to zero

Replace the '1' with '0' so the formula reads =PV(10%,3,0,-100), indicating zero payments are made each period.

4
Apply the calculation

Press the Enter key to apply the changes. The cell will now accurately display the expected result of approximately 75.13.

Adjust the PMT Argument to Zero in the PV Formula
Cash-Flow Direction Convention: Spreadsheet financial functions use cash-flow direction rules. Cash paid out is represented by negative numbers, while cash received is positive. Maintain consistent signs for accurate outputs.
Calculate Present Value Easily

Use WPS Spreadsheet for Accurate Financial Calculations

WPS Spreadsheet supports all standard financial functions, including PV, FV, and PMT. You can accurately evaluate investments and loans using a built-in formula builder, ensuring full compatibility with Microsoft Excel formulas.

  1. 1. Open WPS Spreadsheet: Launch WPS Office, create or open a workbook, and select the cell where you want the present value result to appear.
  2. 2. Access the Insert Function tool: Go to the Formulas tab on the top ribbon and click on 'Insert Function' (the fx icon).
  3. 3. Select the PV function: In the dialog box, select 'Financial' from the category drop-down list, search for 'PV', and click OK.
  4. 4. Enter the financial arguments: Input your Rate, Nper, Pmt (enter 0 if there are no periodic payments), and Fv into the dedicated fields.
  5. 5. Confirm and calculate: Click OK to insert the formula into the cell and instantly receive the error-free present value calculation.
100% compatibility with Microsoft Excel formulas and financial functions.Built-in function dialog box to easily input Rate, Nper, Pmt, and Fv without syntax errors.Free, lightweight, and available on multiple platforms.
microsoft office alternative - wps office

Frequently Asked Questions

Why is my Excel PV formula returning a negative number?

Financial functions in spreadsheets use standard accounting cash flow conventions. If you receive money (which is positive), the initial investment required to get it represents an outflow, which is shown as a negative number. Adjust the positive or negative signs of your PMT or FV arguments to flip the result's sign.

What does the PMT argument do in the PV function?

The PMT argument represents the fixed payment made each period for the duration of the annuity. If you are only calculating the present value of a single future amount (lump sum) without any ongoing contributions, this argument must be 0.

How do I calculate the present value of an investment with no periodic payments?

You can either explicitly enter a 0 as the third argument (e.g., =PV(10%,3,0,-100)) or completely omit the PMT argument by typing two consecutive commas in its place (e.g., =PV(10%,3,,-100)).