The Excel NPER function calculates the number of periods, or amount of time, needed to payoff a loan or reach an investment objective.
The Excel IRR function calculates the internal rate of return of an investment based upon a series of cashflows
The Excel NPV function calculates the net present value of an investment based upon a discount rate and a series of cashflows.
This free easy to use Excel loan payment calculator for download will calculate loan payments with different terms.
The Excel FV function calculates the future value (e.g., the remaining amount) of a loan or investment at a point in time in the future.
The Excel PV function calculates the present value (or original amount) of a loan or investment.
The Excel RATE function calculates the interest rate per period for a loan or investment.
The Excel PMT function calculates the payment for a loan with a fixed interest rate. The function also assumes constant payments will be made.