Function Problems

Excel PV and FV Formulas for Lottery Payments and Bank Balances

Steven ParkerSteven Parker Nov 14, 2026 868 views

Question details

Calculate the present value of lottery payments, a future bank balance after withdrawals, and the monthly deposit needed to reach a savings target.

Excel PV and FV Formulas for Lottery Payments and Bank Balances
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user is comparing annual and monthly cash flows using financial formulas.
Observed behavior
The user needs formulas that match the interest rate to the payment period and use consistent cash-flow signs.
Before you start

Confirm whether each interest rate is annual or monthly and whether payments occur at the beginning or end of each period. The examples below assume payments occur at the end of each period and that 0.8% is a monthly rate.

Solution 1Recommended

Use PV and FV with matching periods and cash-flow signs

Use these formulas to value annual lottery payments and project a bank balance after annual withdrawals.

1
Value the lottery payments

In an Excel cell, enter =PV(10%,20,50000) to calculate the present value of 20 annual INR 50,000 payments at 10% per year. The result is negative because the payment argument is positive; use -50000 for a positive result.

2
Project the bank balance

In another cell, enter =FV(8%,20,-15000,250000) for an initial INR 250,000 balance and INR 15,000 annual withdrawals over 20 years at 8%. Excel returns a negative result under this sign convention; reverse both cash-flow signs to display the balance as positive.

3
Check cash-flow signs

In each formula, treat money moving in opposite directions with opposite signs. For example, use a negative initial balance and positive withdrawals if you want the FV result to be positive.

Use PV and FV with matching periods and cash-flow signs
Match the rate to the period: Use an annual rate with annual payments and a monthly rate with monthly payments. The formulas omit the optional type argument, so payments are assumed to occur at the end of each period.
Calculate financial values in WPS

Calculate PV, FV, and monthly deposits in WPS Spreadsheets

Use financial functions in WPS Spreadsheets to calculate lottery values, project balances, and determine monthly deposits with consistent periods and cash-flow signs.

  1. 1. Open a spreadsheet: Open WPS Office, select Spreadsheets, and create a blank workbook or open an Excel file.
  2. 2. Enter a financial formula: Select a cell and enter =PV(10%,20,50000) for the lottery example or =FV(8%,20,-15000,250000) for the bank balance example.
  3. 3. Calculate a deposit: In another cell, enter =PMT(0.8%,10*12,0,-1000000) to calculate the required monthly deposit from a zero starting balance.
  4. 4. Review and save: Check that rates match payment periods and that cash flows use consistent signs, then select Save or Save As to save the workbook.
Calculate present values, future values, and payments with PV, FV, and PMTOpen and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet formulas and cell-based calculations
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel return a negative present value?

PV follows a cash-flow sign convention. If payments are entered as positive amounts, the present value is returned as negative. Enter the payment as a negative amount to display a positive present value.

Should I use PV or PMT to find a monthly deposit?

Use PMT when the deposit amount is unknown. For a INR 1,000,000 target over 120 months at 0.8% per month, starting from zero, enter =PMT(0.8%,120,0,-1000000).

What does the PV formula with INR 1,000 monthly deposits calculate?

The formula =PV(0.8%,120,1000,-1000000) calculates the initial balance needed alongside those deposits to reach INR 1,000,000. It does not calculate the monthly deposit.

How do I handle payments made at the beginning of a period?

Set the optional type argument to 1 in PV, FV, or PMT. For example, =PV(10%,20,50000,0,1) values annual payments made at the beginning of each year.