Financial Functions


Financial functions deal with loans, investments, interest, depreciation, future values, etc. ,  Click on any of the links to view full descriptions, examples, and practice tutorials.

Financial Functions
Financial
Function
Description
FV Returns the future value of an investment based on deposits and interest that remain constant
PV Returns the value in today’s dollars of an investment
PMT Calculates the payment for a loan that uses a constant payment and interest rate.
IPMT Calculates the interest portion of the period payment for a particular period.
PPMT Calculates the principal portion of the period payment is for a particular period.