PDURATION

  • Updated

Computes the number of periods needed for an investment to reach a specified value.

Sample Usage

PDURATION(2.5,2000,2200)
PDURATION(C4,C5,C6)

 

Syntax

PDURATION(rate, present_value, future_value)

  • rate - The rate at which the investment grows.
  • present_value - The present value of the investment.
  • future_value - The desired future value of the investment.

 

Examples

PDURATION(2.5,2000,2200) calculates the number of years required for an investment of 2000, earning 2.5% annually, to reach 2200.

 

Notes

  • All values must be positive and greater than 0.