|
<< 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: