In This Topic

PDURATION

In This Topic

This function returns the number of periods required by an investment to reach specified value.

PDURATION(*rate,pv,fv*)

This function has the following arguments:

Argument | Description |
---|---|

rate |
Value of interest rate per period |

pv |
Present value of the investment |

fv |
Desired future value of the investment |

All the arguments of this function has positive values.

All the passed arguments should be positive values.

Accepts numeric data. Returns numeric data.

PDURATION(0.025/12,1000,1200) gives the result 87.6

This function is available in Spread for Windows Forms 11.0 or later.