FormuladrillPV practice
PV returns the present value of a series of future payments at a constant rate. Below are the 1 Excel exercise on Formuladrill that use it, each checked instantly in your browser.
Syntax
PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning])
What people get wrong
Enter the payment as a negative to get a positive present value, or the sign flips.
Excel exercise that use PV
- Value of an annuityLevel 5Pro
Practice PV now
The free exercises work without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.
Start practicing free