Future value of annuity

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

April 14, 2025 · 1 min · 49 words · Michael Wright

Table of Contents

Explanation

TheFV functionis a financial function that returns the future value of an investment.

An annuity is a series of equal cash flows, spaced equally in time.

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

Excel formula: Present value of annuity

Excel formula: Future value vs. Present value

Excel FV function

Excel PV function