PERIOD (duration of fixed-interest investments)

<< Click to Display Table of Contents >>

PERIOD (duration of fixed-interest investments)

Syntax:

PERIOD(Rate, PV, FV)

Description:

This returns the duration (i.e., the number of periods) required to obtain a specific future value with a fixed-interest investment.

This function is applicable to investments with just one payment (made at the beginning) and a fixed interest rate.

The function expects the following arguments:

Rate is the interest rate (per payment period)

PV is the present value (initial amount)

FV is the future value

Compatibility notes:

This function does not exist in Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced with their current result as a fixed value.

Tip: You can perform calculations with the PERIOD function using Excel-compatible functions as follows:

PERIOD(Rate, PV, FV) is equivalent to NPER(Rate, 0, PV, -FV)

Note the minus sign in front of FV!

Example:

You would like to obtain a payout of €5000 with a fixed-interest investment of €3000. The annual interest rate is 6%. How many periods (years) are required in this case?

PERIOD(6%, 3000, 5000) returns 8.76669 periods (i.e., years)

See also:

RRI