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.

 

This function

Returns

FV

The future value (FV) 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 (NPV) of a series of unequal payments made at regular intervals, assuming a fixed interest rate per interval.

PMT

The payment (PMT) required by the term, interest rate, and principal.

PV

The present value (PV) of a series of equal payments made at regular intervals, assuming a fixed interest rate per interval.

Related topics 

About functions

About formulas