PDURATION
How many periods a value takes to grow to a target at a fixed rate.
Group: Financial. Compatible with DAX.
Syntax
PDURATION ( <rate>, <pv>, <fv> )| Parameter | Type | Description |
|---|---|---|
rate | Number | How much the value grows each period, as a decimal. |
pv | Number | The value now. |
fv | Number | The value to reach. |
Returns
Number. How many periods it takes; seldom a whole number.
Remarks
- It is (ln fv − ln pv) / ln (1 + rate): growth compounded every period, with nothing added along the way.
- All of rate, pv and fv must be above 0; a target below pv gives a negative number of periods.
Examples
How long until a value doubles
EVALUATE
ROW (
"At 5 %", PDURATION ( 0.05, 1, 2 ),
"At 10 %", PDURATION ( 0.1, 1, 2 )
)| At 5 % | At 10 % |
|---|---|
| 14.2066990828905 | 7.27254089734171 |