Fix Excel PV Formula Returning Incorrect Value Compared to Calculator
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.

- 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.
Verify the exact parameters of your financial calculation, clearly distinguishing between a one-time future value and recurring periodic payments.
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.
Double-click the spreadsheet cell containing your PV formula to enter edit mode.
Identify the third argument in your formula, which represents the periodic payment. In =PV(10%,3,1,-100), this is the '1'.
Replace the '1' with '0' so the formula reads =PV(10%,3,0,-100), indicating zero payments are made each period.
Press the Enter key to apply the changes. The cell will now accurately display the expected result of approximately 75.13.

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. 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. Access the Insert Function tool: Go to the Formulas tab on the top ribbon and click on 'Insert Function' (the fx icon).
- 3. Select the PV function: In the dialog box, select 'Financial' from the category drop-down list, search for 'PV', and click OK.
- 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. Confirm and calculate: Click OK to insert the formula into the cell and instantly receive the error-free present value calculation.

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)).




