Example

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.

Example

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.

Example

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.

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.

Example

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.

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.

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.

Example

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.

Example

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.

Example

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.

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

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.

Example

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.