Present value of annuity

To get the present value of an annuity, you can use the PV function. In the example shown, the formula in C9 is: =PV(C5,C6,C4,0,0)

April 14, 2025 · 1 min · 53 words · Margaret Woods

Table of Contents

Explanation

ThePV functionis a financial function that returns the present value of an investment.

Note payment is entered as a negative number, so the result is positive.

To calculate present value for an annuity due, use 1 for thetypeargument.

Excel formula: Future value of annuity

The only difference istype= 1.

Excel formula: Future value vs. Present value

Excel formula: Bond valuation example

Excel PV function

Excel FV function