Future value of a series of deposits formula
The present value, or the lump-sum amount that a series of future payments is worth right now. If pv is omitted, it is assumed to be 0 (zero), and you must include the pmt argument. Type Optional. The number 0 or 1 and indicates when payments are due. If type is omitted, it is assumed to be 0. Future value of annuity. To get the present value of an annuity, you can use the PV function. In the example shown, the formula in C7 is: =FV(C5,C6,-C4,0,0) Explanation An annuity is a series of equal cash flows, spaced equally in time.