Excel Financial Functions
FUNCTION | SYNTAX |
---|---|
CUMIPMT(rate,nper,pv,start_period,end_period,type) |
|
CUMPRINC(rate,nper,pv,start_period,end_period,type) |
|
FV | FV(rate,nper,pmt,pv,type) |
IPMT(rate,per,nper,pv,fv,type) |
|
IRR | IRR(values,guess) |
MIRR(values,finance_rate,reinvest_rate) |
|
NPER | NPER(rate, pmt, pv, fv, type) |
NPV | NPV(rate,value1,value2, ...) |
PMT | PMT(rate,nper,pv,fv,type) |
PPMT(rate,per,nper,pv,fv,type) |
|
PV | PV(rate,nper,pmt,fv,type) |
RATE | RATE(nper,pmt,pv,fv,type,guess) |
XIRR | XIRR(values,dates,guess) |
XNPV(rate,values,dates) |