Pmt | ----- |
The Pmt function returns the periodic payment for an annuity based on constant payments and a constant interest rate.
|
IPmt | ----- |
The IPmt function returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.
|
PPmt | ----- |
The PPmt function returns the payment on the principal for a given period for an investment based on periodic,
constant payments and a constant interest rate
|
Pv | ----- |
The Pv function returns the present value of an investment.
|
Fv | ----- |
The Fv function returns the future value of an investment based on periodic, constant payments and a constant interest rate.
|
Nper | ----- |
The Nper function returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.
|
Rate | ----- |
The Rate function returns the interest rate per period for an annunity.
|
Npv | ----- |
The Npv function returns the net present value based on a series of periodic cash flows and a discount rate.
|
Irr | ----- |
The Irr function returns the internal rate of return for a series of periodic cash flows.
|