PPmt (FV)

Name

PPmt(FV)

Syntax

PPmt (Real Rate, Real Periods, Real numPeriods, Real PV)

Purpose

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

Description

Return the principal payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate. Also takes into account Future Value.

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 = 0.5

periods = 10

numPeriods = 100

PV = 50000

FV = 1000

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

© Copyright 2023, Astera Software