Financial Functions

JMP Support 800.450.0135 (US)

Documentation Feedback
Your feedback is important to us. us any comments about our documentation.

JSL Syntax Reference • JSL Functions • Financial Functions

•

Financial Functions

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

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.

The initial cost.

The value at the end of the depreciation.

The number of periods in the depreciation cycle.

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

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

This function is equivalent to the Excel function DDB.

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

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

The interest rate.

The number of periods.

The constant payment.

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

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

This function is equivalent to the Excel function FV.

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

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

The interest rate.

The period for which you want the interest.

The total number of periods.

The present value.

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

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

This function is equivalent to the Excel function IPMT.

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

Returns the interest rate per period of an annuity.

The total number of periods.

The constant payment.

The present value.

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

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

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

This function is equivalent to the Excel function RATE.

Internal Rate of Return(values, <guess>)

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

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

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

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

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, ...)

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.

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

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

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

This function is equivalent to the Excel function MIRR.

Net Present Value(rate, values)

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

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

The discount rate.

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

This function is equivalent to the Excel function NPV.

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

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

The interest rate.

The constant payment.

The present value.

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

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

This function is equivalent to the Excel function NPER.

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

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

The interest rate.

The total number of periods.

The present value.

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

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

This function is equivalent to the Excel function PMT.

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

Returns the present value of an investment.

The interest rate per period.

The total number of periods.

The constant payment.

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

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

This function is equivalent to the Excel function PV.

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

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.

The interest rate per period.

The period for which you want the interest.

The total number of periods.

The present value.

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

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

This function is equivalent to the Excel function PPMT.

Straight Line Depreciation(cost, salvage, life)

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

The initial cost of the asset.

The value at the end of the depreciation.

The number of periods in the depreciation cycle.

This function is equivalent to the Excel function SLN.

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

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

The initial cost of the asset.

The value at the end of the depreciation.

The number of periods in the depreciation cycle.

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

This function is equivalent to the Excel function SYD.

•

Help created on 7/12/2018