Excel PV and FV Formulas for Lottery Payments and Bank Balances
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.

- 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.
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.
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.
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.
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.
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 PMT to calculate the required monthly deposit
Use PMT when the deposit amount is unknown and the target balance is known.
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. Open a spreadsheet: Open WPS Office, select Spreadsheets, and create a blank workbook or open an Excel file.
- 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. 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. 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.

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.




