Pmt (FV)

Name

Pmt (FV)

Syntax

Pmt (Real Rate, Real Periods, Real numPeriods, Real PV, Real FV)

Purpose

To return the payment for an annuity based on periodic, fixed payments and a fixed interest rate.

Description

Returns the payment for an annuity based on periodic, fixed payments and a fixed interest rate. Takes into account Future Value too.

Return Type

Double

Parameters

Rate [System.Double]

periods [System.Double]

numPeriods [System.Double]

PV [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 = 1.0123

periods = 0

numPeriods = 1000

PV = 25000

FV = 10000

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

Last updated

© Copyright 2023, Astera Software