Скачать или смотреть Advanced XL future value of an investment based on periodic

For a more complete description of the arguments in FV and for more information on annuity functions, see PV.

The FV function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):

Rate Required. The interest rate per period.
Nper Required. The total number of payment periods in an annuity.
Pmt Required. The payment made each period; it cannot change over the life of the annuity. Typically, pmt contains principal and interest but no other fees or taxes. If pmt is omitted, you must include the pv argument.
Pv Optional. 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.