How to Use the Excel FV Formula for Annual Investments in WPS Office
Question details
The user needs to calculate the future value of regular annual investments with the FV function in WPS Office Excel, using correct payment timing, sign convention, and display formatting.

- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- Planning long-term annual investment growth and projecting the final amount in a spreadsheet.
- Observed behavior
- Valid large future value results may display as #### when the column is too narrow, and incorrect timing or sign convention can return an unexpected value.
Confirm the annual rate is formatted as a percentage or entered as the decimal equivalent, and place the number of years in a separate cell so the FV formula can reference it.
Calculate Future Value for Year-End Annual Investments with FV
Use this method when deposits are made at the end of each year and you want a positive future value.
The FV function uses the syntax FV(rate, nper, pmt, [pv], [type]). A negative payment represents cash you pay into the investment, so the future value returns as a positive number.
Click the cell where you want the future value to appear, such as B3.
Type =FV(5.5%,A2,-5000,0,0) and press Enter, where A2 contains the number of years.
On the Home tab, choose Currency or Accounting format, and drag the column boundary to widen it if #### appears.

Calculate Future Value for Beginning-of-Year Annual Investments
Use this variation when deposits are made at the beginning of each year, such as in an annuity due.
Calculate Annual Investment Growth with the FV Function in WPS Office
Use the built-in FV function in WPS Spreadsheets to project the future value of regular annual investments. Enter the rate, number of years, and payment, then format the result as currency.
- 1. Open WPS Spreadsheets: Launch WPS Office and open a blank spreadsheet or your existing investment workbook.
- 2. Enter investment inputs: Type the annual interest rate, number of years, and annual payment into separate cells, such as B1, A2, and 5000.
- 3. Insert the FV formula: In the result cell, enter =FV(5.5%,A2,-5000,0,0) and press Enter.
- 4. Format the result: Select the cell, choose Currency on the Home tab, and widen the column if #### appears.
- 5. Save in Excel format: Click Menu > Save As and choose .xlsx to keep the file compatible with Microsoft Excel.

Frequently Asked Questions
Why does my FV formula show a negative future value?
Because the payment argument is positive. In WPS Spreadsheets, use a negative payment such as -5000 to represent money invested, which returns a positive future value.
What does the type argument do in the FV formula?
Type 0 or omitted calculates deposits made at the end of each period; type 1 calculates deposits at the beginning of each period.
Why does the formula result show #### instead of a number?
The column is too narrow to display the full formatted number. Drag the column boundary or double-click it to auto-fit the result.
Can I use a cell reference for the interest rate instead of typing 5.5%?
Yes. If the annual rate is in cell B1, use =FV(B1,A2,-5000,0,0) and format B1 as a percentage.
Does WPS Spreadsheets support the same FV function as Excel?
Yes. WPS Spreadsheets supports the FV function with the same arguments, so workbooks using FV open and calculate compatibly in .xlsx format.




