Home > Reference > Functions reference > Financial functions

Financial functions

Financial functions calculate financial information, such as net present value and payments. For example, you can calculate the monthly payments required to buy a car at a certain loan rate using the PMT function.

Click a function name for details.

 

This function	Returns
FV	The future value of an initial investment, based on a constant interest rate and payment amount for the number of periods in months.
NPV	The net present value of a series of unequal payments made at regular intervals, assuming a fixed rate per interval.
PMT	The payment required by the term, interest rate, and principal.
PV	The present value of a series of equal payments made at regular intervals (periods), assuming a fixed interest rate per interval.