pduration

Periods needed for a lump-sum to grow to a target value.

Syntax

v = pduration(rate, pv, fv)

Description

Returns log(fv/pv) / log(1 + rate) — the number of compounding periods required for pv to grow to fv at periodic rate rate. No payments — pure compound growth.

Example

pduration(0.025, 1000, 1500)    % periods at 2.5%/period

See also

• nper — Number of payment periods for a loan or investment.
• fv — Future value of an investment.