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