PDURATION function

PDURATION(Rate, PresentValue, FutureValue) PDURATION(Rate; PresentValue; FutureValue)

Rate

Number or { Number }

The interest rate per period.

Number or { Number }

The initial investment value.

Number or { Number }

The value of the investment to be attained.

Number or { Number }

The number of periods required by an investment to realize a desired value.

Returns the number of periods required by an investment to realize a desired value.

PDURATION(4%, 3000, 3500)PDURATION(4%; 3000; 3500)

Returns roughly 3.93, which is the number of years needed for an investment of $3,000 to earn 4% annually and ultimately reach $3,500.

PDURATION(4% / 12, 3000, 3500)PDURATION(4% / 12; 3000; 3500)

Returns roughly 46.3, which is the number of months needed for an investment of $3,000 to earn 4% annually and ultimately reach $3,500.

Partly derived from the OpenOffice.org documentation, licensed under the Apache License 2.0.