In the JMP Formula Editor, you can use Finance functions to create formulas for calculating principal payments, interest rates, rates of return, and so on.
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.
Returns the future value of an investment that is based on periodic, constant payments and a constant interest rate.
Returns the interest payment for a given period for an investment that is based on periodic, constant payments and a constant interest rate.
Returns the interest rate per period of an annuity.
Returns the internal rate of return for a series of cash flows in the values argument.
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.
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).
Returns the number of periods for an investment that is based on periodic, constant payments and a constant interest rate.
Returns the payment for a loan that is based on constant payments and a constant interest rate.
Returns the present value of an investment.
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.
Returns the straight-line depreciation of an asset for one period.
Returns the sum-of-years’ digits depreciation of an asset for a specified period.