Financial Functions
Home
Lookup and Ref Functions
Math and Trig Functions
Statistical Functions
Text 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.