FV & PV practice exercises
4 graded problems with realistic data, from easy to medium.
FV projects what a series of regular contributions grows into by a future date; PV works backward, finding what a future amount (or payment stream) is worth today. The 4 exercises below come from LearnExcel's practice library. Each one gives you a realistic table, a cell to fill, and a hint if you get stuck. Read them here, then solve them in the interactive grid, where your formula is checked the moment you press Enter.
New to the function? Read the FV & PV guide first: syntax, a worked example and the mistakes people make.
In this set
- Project a savings account balance
- Project a balance that already has a head start
- Find how much you need today to fund future withdrawals
- Compare a lump sum to a stream of payments
The exercises
You deposit $150 every month into an account earning 0.5% per month, starting from $0. What will the balance be after 24 months?
| A | B | |
|---|---|---|
| 1 | Monthly deposit | 150 |
| 2 | Monthly rate | 0.005 |
| 3 | Months | 24 |
| 4 | Balance after 24 months | ? |
Enter a formula in B4.
Show a hint
FV(rate, nper, pmt) projects a future balance. The deposit is money leaving your pocket each month, so it goes in as negative: =FV(B2,B3,-B1).
FV answers "where does this end up?" for anything that compounds: a savings plan, a retirement account, an investment with regular contributions.
You already have $2,000 saved and add $100 every month at 0.4% monthly interest. What will the balance be after 36 months?
| A | B | |
|---|---|---|
| 1 | Starting balance | 2000 |
| 2 | Monthly deposit | 100 |
| 3 | Monthly rate | 0.004 |
| 4 | Months | 36 |
| 5 | Balance after 36 months | ? |
Enter a formula in B5.
Show a hint
The starting balance is already-invested money too, so it gets the same negative-sign treatment as the deposit, in the 4th argument: =FV(B3,B4,-B2,-B1).
Almost no real savings projection starts from zero: FV's 4th argument (pv) is how you fold in whatever's already in the account.
You want to withdraw $500 every month for the next 60 months from an account earning 0.25% interest per month. How much do you need in the account today?
| A | B | |
|---|---|---|
| 1 | Monthly withdrawal | 500 |
| 2 | Monthly rate | 0.0025 |
| 3 | Months | 60 |
| 4 | Needed today | ? |
Enter a formula in B4.
Show a hint
PV(rate, nper, pmt) finds the lump sum today that's equivalent to a stream of payments. The withdrawal leaves the account, so it's negative: =PV(B2,B3,-B1).
PV is the other direction from FV: instead of projecting forward, it prices out what a future stream of payments is worth right now: the question behind every pension, annuity, or "how much do I need to retire" calculation.
A settlement offers either $50,000 today, or $900 a month for 60 months. Your account could earn 0.3% a month either way. Find the present value of the monthly-payment option so you can compare it to the lump sum.
| A | B | |
|---|---|---|
| 1 | Settlement | Smith v. Acme Corp |
| 2 | Monthly payment | 900 |
| 3 | Monthly rate | 0.003 |
| 4 | Months | 60 |
| 5 | Lump sum offer | 50000 |
| 6 | PV of the monthly option | ? |
Enter a formula in B6.
Show a hint
Same PV shape as before: =PV(B3,B4,-B2). Once you have this number, compare it directly to B5.
This is the actual decision PV is for: "would I rather have money now or spread out" only has a real answer once both options are priced in today's dollars.
Solve these in a real grid
Type your formula, get graded instantly. Your first 10 exercises are free, no signup.
Start the FV & PV exercises →