Using JMP • Formula Functions Reference • Finance Functions
Previous
 • 
Next
Finance Functions
Lets you create formulas to calculate principal payments, interest rate, rate of return, and so on.
Double Declining Balance
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.
Future Value
Returns the future value of an investment that is based on periodic, constant payments and a constant interest rate.
Interest Payment
Returns the interest payment for a given period for an investment that is based on periodic, constant payments and a constant interest rate.
Interest Rate
Returns the interest rate per period of an annuity.
Internal Rate of Return
Returns the internal rate of return for a series of cash flows in the values argument.
Modified Internal Rate of Return
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.
Net Present Value
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).
Number of Periods
Returns the number of periods for an investment that is based on periodic, constant payments and a constant interest rate.
Payment
Returns the payment for a loan that is based on constant payments and a constant interest rate.
Present Value
Returns the present value of an investment.
Principal Payment
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.
Straight Line Depreciation
Returns the straight-line depreciation of an asset for one period.
Sum Of Years Digits Depreciation
Returns the sum-of-years’ digits depreciation of an asset for a specified period.

Previous
 • 
Next
Help created on 7/12/2018