JSL Syntax Reference > JSL Functions > Financial Functions
Publication date: 08/13/2020

# Financial Functions

Double Declining Balance(cost, salvage, life, period, <factor>)

Description

Returns the depreciation of an asset for a specified period of time. The function uses the double-declining balance method or some other depreciation factor.

Arguments

cost

The initial cost.

salvage

The value at the end of the depreciation.

life

The number of periods in the depreciation cycle.

period

The length of the period, in the same units as life.

factor

An optional number that is the rate at which the balance declines. The default value is 2.

Note

This function is equivalent to the Excel function DDB.

Future Value(rate, nper, pmt, <pv>, <type>)

Description

Returns the future value of an investment that is based on periodic, constant payments and a constant interest rate.

Arguments

rate

The interest rate.

nper

The number of periods.

pmt

The constant payment.

pv

An optional number that is the present value. The default value is 0.

type

An optional switch. 0 specifies end-of-period payments, and 1 specifies beginning-of-period payments. The default value is 0.

Note

This function is equivalent to the Excel function FV.

Interest Payment(rate, per, nper, pv, <fv>, <type>)

Description

Returns the interest payment for a given period for an investment that is based on periodic, constant payments and a constant interest rate.

Arguments

rate

The interest rate.

per

The period for which you want the interest.

nper

The total number of periods.

pv

The present value.

fv

An optional number that is the future value. The default value is 0.

type

An optional switch. 0 specifies end-of-period payments, and 1 specifies beginning-of-period payments. The default value is 0.

Note

This function is equivalent to the Excel function IPMT.

Interest Rate(nper, pmt, pv, <fv>, <type>, <guess>)

Description

Returns the interest rate per period of an annuity.

Arguments

nper

The total number of periods.

pmt

The constant payment.

pv

The present value.

fv

An optional number that is the future value. The default value is 0.

type

An optional switch. 0 specifies end-of-period payments, and 1 specifies beginning-of-period payments. The default value is 0.

guess

An optional number that is what you think the rate will be. The default value is 0.1 (10%).

Note

This function is equivalent to the Excel function RATE.

Internal Rate of Return(values, <guess>)

Internal Rate of Return(guess, value1, value2, ...)

Description

Returns the internal rate of return for a series of cash flows in the values argument.

Arguments

values

A one-dimensional matrix of values. If the second form of the function is used, list each value separately.

guess

The number that you think is near the result. The default value is 0.1 (10%).

Note

This function is equivalent to the Excel function IRR.

Modified Internal Rate of Return(values, finance rate, reinvest rate)

Modified Internal Rate of Return(finance rate, reinvest rate, value1, value2, ...)

Description

Returns the modified internal rate of return for a series of periodic cash flows. The cost of investment and the interest received on reinvested cash is included.

Arguments

values

A one-dimensional matrix of values. If the second form of the function is used, list each value separately.

finance rate

The interest rate that you pay on the money in the cash flows.

reinvest rate

The interest rate that you receive on the cash flows when you reinvest them.

Note

This function is equivalent to the Excel function MIRR.

Net Present Value(rate, values)

Net Present Value(rate, value1, value2, ...)

Description

Returns the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positive values).

Arguments

rate

The discount rate.

values

A one-dimensional matrix of values. If the second form of the function is used, list each value separately.

Note

This function is equivalent to the Excel function NPV.

Number of Periods(rate, pmt, pv, <fv>, <rate>)

Description

Returns the number of periods for an investment that is based on periodic, constant payments and a constant interest rate.

Arguments

rate

The interest rate.

pmt

The constant payment.

pv

The present value.

fv

An optional number that is the future value. The default value is 0.

type

An optional switch. 0 specifies end-of-period payments, and 1 specifies beginning-of-period payments. The default value is 0.

Note

This function is equivalent to the Excel function NPER.

Payment(rate, nper, pv, <fv>, <type>)

Description

Returns the payment for a loan that is based on constant payments and a constant interest rate.

Arguments

rate

The interest rate.

nper

The total number of periods.

pv

The present value.

fv

An optional number that is the future value. The default value is 0.

type

An optional switch. 0 specifies end-of-period payments, and 1 specifies beginning-of-period payments. The default value is 0.

Note

This function is equivalent to the Excel function PMT.

Present Value(rate, nper, pmt, <fv>, <type>)

Description

Returns the present value of an investment.

Arguments

rate

The interest rate per period.

nper

The total number of periods.

pmt

The constant payment.

fv

An optional number that is the future value. The default value is 0.

type

An optional switch. 0 specifies end-of-period payments, and 1 specifies beginning-of-period payments. The default value is 0.

Note

This function is equivalent to the Excel function PV.

Principal Payment(rate, per, nper, pv, <fv>, <type>)

Description

Returns the payment on the principal for a given period for an investment that is based on periodic, constant payments and a constant interest rate.

Arguments

rate

The interest rate per period.

per

The period for which you want the interest.

nper

The total number of periods.

pv

The present value.

fv

An optional number that is the future value. The default value is 0.

type

An optional switch. 0 specifies end-of-period payments, and 1 specifies beginning-of-period payments. The default value is 0.

Note

This function is equivalent to the Excel function PPMT.

Straight Line Depreciation(cost, salvage, life)

Description

Returns the straight-line depreciation of an asset for one period.

Arguments

cost

The initial cost of the asset.

salvage

The value at the end of the depreciation.

life

The number of periods in the depreciation cycle.

Note

This function is equivalent to the Excel function SLN.

Sum Of Years Digits Depreciation(cost, salvage, life, per)

Description

Returns the sum-of-years’ digits depreciation of an asset for a specified period.

Arguments

cost

The initial cost of the asset.

salvage

The value at the end of the depreciation.

life

The number of periods in the depreciation cycle.

per

The length of the period, in the same units as life.

Note

This function is equivalent to the Excel function SYD.