deepcalc
DocsPDURATION

PDURATION

View as markdown/docs/functions/pduration.md Ask Claude about this pageOpens Claude with this page's address

Returns periods to reach target value.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Number

Examples

=PDURATION(0.025, 2000, 2200)
Result 3.859866162622655

Syntax

PDURATION(rate, pv, fv)
rate
number required
pv
number required
fv
number required
ACCRINTAccrued interest for a security paying periodic interest. ACCRINTMAccrued interest for a security paying at maturity. AMORDEGRCDepreciation per period, French accounting, degressive. AMORLINCDepreciation per period, French accounting, linear. COUPDAYBSDays from coupon period start to settlement. COUPDAYSDays in the coupon period containing settlement.