Fix Incorrect Excel PV Results for Monthly Loan Payments
Question details
The user needs to calculate the present value of a monthly loan payment correctly with the PV function.

- Product
- Microsoft Excel PV function
- Device & OS
- not provided
- Scenario
- An annual interest rate is being used with monthly payment periods to estimate a loan value.
- Observed behavior
- The PV formula returns an unexpected loan value because the interest rate frequency, payment periods, or cash-flow signs do not match.
Confirm that the number of periods represents months and that the payment amount is the amount paid each month. Use the same cash-flow sign convention for all values in the formula.
Use a monthly interest rate and a negative monthly payment in PV
Use this method when your loan rate is quoted annually but your payment schedule and total number of periods are monthly.
The rate argument and nper argument in PV must use the same time unit. For a 30-year loan with monthly payments, divide the annual rate by 12 and use 360 as the number of periods.
Enter payments as negative cash outflows when you want the calculated loan value to display as a positive amount.
Click the cell where you want the loan present value to appear.
Type =PV(8%/12,360,-2840) and press Enter. This uses a monthly rate, 360 monthly periods, and a negative monthly payment.
Verify that the result is approximately 387045.12. Apply a currency format from Home > Number Format if you want to display it as a monetary value.
If you prefer payments to be positive, enter the loan amount or resulting cash flow as negative instead. Keep one side of the transaction positive and the other negative.

Match PV inputs to the actual payment schedule
Use this check when payments are quarterly, yearly, or made at the beginning of each period instead of monthly.
Calculate Monthly Loan Present Value with WPS Spreadsheets
WPS Spreadsheets supports the PV function for loan calculations. Enter a monthly rate, monthly periods, and a consistent payment sign to calculate the present value of a monthly payment plan accurately.
- 1. Open a spreadsheet in WPS Spreadsheets: Launch WPS Office and select Spreadsheets, then open your loan worksheet or create a blank workbook.
- 2. Choose the output cell: Click the cell that should display the calculated loan value.
- 3. Enter the monthly PV formula: Enter =PV(8%/12,360,-2840) in the formula bar and press Enter.
- 4. Format the result as currency: Select the result cell, then choose Home > Number Format > Currency to display the present value as a loan amount.

Frequently Asked Questions
Why does my PV formula return a negative loan amount?
PV follows cash-flow signs. If the payment is positive, the present value is commonly returned as negative. Enter the payment as a negative number, such as =PV(8%/12,360,-2840), to return a positive loan value.
Should I divide an annual interest rate by 12 in the PV function?
Yes, when nper is measured in months. For example, use 8%/12 for the rate when calculating 360 monthly payments.
What does 360 mean in a monthly PV formula?
It is the total number of payment periods. A 30-year loan with monthly payments has 30 × 12, or 360 periods.
How do I calculate PV when payments are due at the beginning of each month?
Use 1 for the type argument: =PV(8%/12,360,-2840,0,1). The final 1 specifies payments at the beginning of each period.
Can WPS Spreadsheets open Excel loan calculation files?
Yes. WPS Spreadsheets can open and edit Microsoft Excel .xlsx and .xls files, including worksheets that use the PV function.




