PPmt

Name

PPmt

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.

Return Type

Double

Parameters

Rate [System.Double]

periods [System.Double]

numPeriods [System.Double]

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

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.

Last updated

© Copyright 2023, Astera Software