JMP
^{®}
Statistical Discovery™. From SAS.
US
China
France
DACH
Italy
Japan
UK
JMP Software
JMP
JMP Graph Builder for the iPad
JMP Pro
JMP Clinical
JMP Genomics
JMP and SAS
Try JMP
Buy JMP
Using JMP
Customer Stories
Application Areas
White Papers
Capabilities
Feature Index
Academic
Life Sciences
Government
News and Events
Seminars
Live Webcasts
On-Demand Webcasts
Users Groups
Conferences
JMP in the News
JMP Blog
JMP in Social Media
Resources for Users
JMP User Community
Support
Training
Online Documentation
Learning Library
JMP Blog
File Exchange
Discussion Forum
Users Groups
Newsletters
About Us
About JMP
Careers at SAS
Contact Us
JMP 11 Online Documentation
Discovering JMP
Using JMP
Basic Analysis
Essential Graphing
Profilers
Design of Experiments Guide
Fitting Linear Models
Specialized Models
Multivariate Methods
Quality and Process Methods
Reliability and Survival Methods
Consumer Research
Scripting Guide
JSL Syntax Reference
JMP iPad Help
Capabilities Index
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.