Excel Financial Functions

FUNCTION
SYNTAX
CUMIPMT(rate,nper,pv,start_period,end_period,type)
CUMPRINC(rate,nper,pv,start_period,end_period,type)
FVFV(rate,nper,pmt,pv,type)
IPMT(rate,per,nper,pv,fv,type)
IRRIRR(values,guess)
MIRR(values,finance_rate,reinvest_rate)
NPERNPER(rate, pmt, pv, fv, type)
NPVNPV(rate,value1,value2, ...)
PMTPMT(rate,nper,pv,fv,type)
PPMT(rate,per,nper,pv,fv,type)
PVPV(rate,nper,pmt,fv,type)
RATERATE(nper,pmt,pv,fv,type,guess)
XIRRXIRR(values,dates,guess)
XNPV(rate,values,dates)