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.