PDURATION
Returns the number of periods required by an investment to reach a specified value.
FinancialFinance & Accounting
What it does
Calculates time to reach investment goal.
Syntax
PDURATION(rate, pv, fv)
Arguments
rate(number) — Interest rate.pv(number) — Present value.fv(number) — Future value.
Examples
Periods to Double
Years to double money at 10%.
FORMULA
=PDURATION(0.1, 100, 200)
RESULT
7.27
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | PV | FV |
| 2 | 100 | 200 |