UniformSeriesPV function
Syntax
UniformSeriesPV(int_rate,n_per)
Description
Use the UniformSeriesPV function to calculate the present value of a single monetary unit after a uniform series of payments at a specified interest rate.
Parameters
| Parameter | Description |
|---|---|
|
int_rate |
A Number specifying the interest rate on the basis of which to calculate the return value. |
|
n_per |
A Number specifying the number of payments in the uniform series. |
Returns
Returns a Number equal to the value of a single unit after n_per payments at an interest rate of int_rate.
Example
The example sets &NUM to 3.790786769408448256:
&NUM = UniformSeriesPV(10,5);
Related Topics