Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Name
DDB
Syntax
DDB (Real Cost, Real Salvage, Real Life, Real Period)
Purpose
To return the double-declining balance of an asset.
Description
Returns the depreciation of an asset for a specific time period using the double-declining balance method.
Return Type
Double
Parameters
Cost [System.Double]
Salvage [System.Double]
Life [System.Double]
Period [System.Double]
To calculate the depreciation value for the aforementioned example, we will be passing the required parameters to the function transformation object using a Variables object.
Where,
Cost = 10000
Salvage = 3000
Life = 10
Period = 6
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned depreciation value using the double-declining method.
Name
IPmt
Syntax
IPmt (Real Rate, Real Periods, Real numPeriods, Real PV)
Purpose
To return a value by applying the interest payment function on specified values.
Description
Returns the interest 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]
In this example, we will be passing the required parameters to the function transformation object using a Variables object.
Where,
rate = 3
periods = 5
numPeriods = 100
PV = 5000000
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has applied the IPmt function, and returned the interest amount of an annuity, dependent on a specified period and period amount.
Name
FV
Syntax
FV (Real Rate, Real NPer, Real Pmt, Real PV)
Purpose
To return the future value of an annuity.
Description
Returns the future value of an annuity based on periodic, fixed payments and a fixed interest rate.
Return Type
Double
Parameters
Rate [System.Double] – Interest rate for period
NPer [System.Double] – Number of payment periods
Pmt [System.Double] – Payment for each period
PV [System.Double] – Present value of annuity
In this example, we will be passing the required parameters to the function transformation object using a Variables object.
Where,
Rate = 1.5
NPer = 2
Pmt = 200
PV = 1000000
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned Future Value of the specified annuity.
In this example, we will be passing the required parameters to the function transformation object using a Variables object.
Where,
numPeriods = 5
Pmt = 10
PV = 3500
FV = 5000
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has applied the Rate function, and returned the Interest rate value, while also considering the future value.
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 = 20000
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.
Name
Rate (FV)
Syntax
Rate (Real numPeriods, Real Pmt, Real PV, Real FV)
Purpose
To return the interest rate per period for an annuity.
Description
Returns the interest rate per period for an annuity. Also considers the Future Value.
Return Type
Double
Parameters
numPeriods [System.Double]
Pmt [System.Double]
PV [System.Double]
FV [System.Double]
Name
Pmt
Syntax
Pmt (Real Rate, Real Periods, Real numPeriods, Real PV)
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.
Return Type
Double
Parameters
Rate [System.Double]
periods [System.Double]
numPeriods [System.Double]
PV [System.Double]
Name
SYD
Syntax
SYD (Real Cost, Real Salvage, Real Life, Real Period)
Purpose
To return the sum-of-years depreciation of an asset for a specified period.
Description
Returnsthe sum-of-years depreciation of an asset for a specified period.
Return Type
Double
Parameters
Cost [System.Double]
Salvage [System.Double]
Life [System.Double]
Period [System.Double]
In this example, we will be passing the required parameters to the function transformation object using a Variables object.
Where,
Cost = 35000
Salvage = 3000
Life = 10
Period = 5
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has applied the SYD function, and returned the sum-of-years depreciation value.
Name
Rate
Syntax
Rate (Real numPeriods, Real Pmt, Real PV)
Purpose
To return the interest rate per period for an annuity.
Description
Returns the interest rate per period for an annuity.
Return Type
Double
Parameters
numPeriods [System.Double]
Pmt [System.Double]
PV [System.Double]
In this example, we will be passing the required parameters to the function transformation object using a Variables object.
Where,
numPeriods = 5
Pmt = 10
PV = 3500
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has applied the Rate function, and returned the Interest rate value.
In this example, we will be passing the required parameters to the function transformation object using a Variables object.
Where,
Cost = 35000
Salvage = 3000
Life = 10
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has applied the SLN function, and returned the staright-line depreciation value.
Name
SLN
Syntax
SLN (Real Cost, Real Salvage, Real Life)
Purpose
To return the straight-line depreciation of an asset for a single period.
Description
Returns the straight-line depreciation of an asset for a single period.
Return Type
Double
Parameters
Cost [System.Double]
Salvage [System.Double]
Life [System.Double]
Name
IPmt (FV)
Syntax
IPmt (Real Rate, Real Periods, Real numPeriods, Real PV, Real FV)
Purpose
To return a value by applying the interest payment function on specified values.
Description
Returns the interest payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate. Also takes into account, the specified Future Value.
Return Type
Double
Parameters
Rate [System.Double]
periods [System.Double]
numPeriods [System.Double]
PV [System.Double]
FV [System.Double]
In this example, we will be passing the required parameters to the function transformation object using a Variables object.
Where,
rate = 3
periods = 5
numPeriods = 100
PV = 5000000
FV = 1000
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has applied the IPmt function, and returned the interest amount of an annuity, dependent on a specified period and period amount and Future Value.
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]
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.
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]
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.
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]
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.
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]
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.
