PV (FV)

Name

PV (FV)

Syntax

PV (Real Rate, Real NPer, Real Pmt, Real FV)

Purpose

To return the present value of an annuity based on periodic, fixed payments to be paid in the future and a fixed interest rate.

Description

Returns the present value of an annuity based on periodic, fixed payments to be paid in the future and a fixed interest rate. Also considers Future Value.

Return Type

Double

Parameters

Rate [System.Double]

NPer [System.Double]

Pmt [System.Double]

FV [System.Double]

Example

In this example, we will be passing the required parameters to the function transformation object using a Variables object.

Where,

Rate = 0.25

NPer = 100

Pmt = 350000

FV = 100

Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has applied the PV function, and returned the present value, taking into account the specified Future Value.

Last updated

© Copyright 2023, Astera Software