PDURATION

Summary

Returns the number of periods required for an investment to reach a specified future value at a constant interest rate.

Remarks

• rate is the interest rate per compounding period; must be positive.
• pv and fv must be positive and fv > pv (growth scenario) or fv < pv is valid as long as both are positive.
• Formula: (ln(fv) - ln(pv)) / ln(1 + rate).
• Returns #NUM! when rate <= 0, or pv or fv are non-positive.

Examples

Related functions

• NPER
• RRI
• FV
• MIRR
• SLN
• TBILLEQ

FAQ

Does PDURATION require growth?

It requires positive present and future values plus a positive rate; the logarithmic formula then returns the compounding periods needed to move between them.

Runtime metadata