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) |