Financial - PDURATION Function

Description

The PDURATION function returns the number of periods required by an investment to reach a specified value.

PDURATION uses the following equation −

$$PDURATION = \frac{log\left ( specifiedValue \right ) - log\left ( currentValue \right )}{log\left ( 1+rate \right )}$$

Where

  • specifiedValue is equal to fv
  • currentValue is equal to pv

Syntax

PDURATION (rate, pv, fv)

Arguments

Argument Description Required/ Optional
Rate Rate is the interest rate per period. Required
Pv Pv is the present value of the investment. Required
Fv Fv is the desired future value of the investment. Required

Notes

  • PDURATION requires that all arguments are positive values.

  • If any of the argument values are zero or negative, PDURATION returns the #NUM! error value.

  • If any of the arguments is not recognized as numeric value, PDURATION returns the #VALUE! error value.

Applicability

Excel 2013, Excel 2016

Example

PDURATION Function
advanced_excel_financial_functions.htm
Advertisements