Fv

Syntax

Fv(Rate, PeriodCount, PeriodPayment, PresentValue, Type)

Parameters

Rate. Interest rate per period.

PaymentCount. The total number of payment periods in an investment.

PeriodPayment. Amount of periodic payment.

PresentValue. The present value, or the lump-sum amount that a series of future payments is worth now.

Type. Selecting payment time. The parameter may take the following values:

0. Payment at the end of the period.
1. Payment at the beginning of the period.

NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.

Description

It returns the future value of an investment based on periodic, constant payments and a constant interest rate.

Comments

All the parameters, denoting money, which has to be paid, for example, saving accounts, are represented as negative numbers; all the money, which has to be received, for example, dividends, are represented as positive numbers.

Example

Formula

Result

Description

=Fv(0.06, 4, -200, -500, 0)

1506,16

The future value of investments based on the following terms:

The interest rate over the period is 0.06.
The total number of payment periods is 4.
Volume of payments is -200.
The current value is -500.
The payments are effected at the end of period.

=Fv(A0, B0, -200, -500, 0)

3099,91

The future value of investments based on the following terms:

The interest rate over the period is specified in the A0 cell, value 0.01.
The total number of payment periods is specified in the B0 cell, value 12.
Volume of payments is -200.
The current value is -500.
The payments are effected at the end of period.