CellSpace/Manual (draft)
by CellWorks
Home
  
Table of Contents
  
Glossary
Financial
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.