Excel to Analytica Mappings/Financial Functions

CUMIPMT(rate,nper,pv,start_period,end_period,type)

Analytica equivalent:

CumIPmt(rate, nper, pv,start_per,end_per,type)

CUMPRINC(rate,nper,pv,start_period,end_period,type)

Analytica equivalent:

CumPrinc(rate,nper,pv,start_per,end_per,type)

FV(rate,nper,pmt,pv,type)

Analytica equivalent:

Fv(rate,nper,pmt,pv,type)

IPMT(rate,per,nper,pv,fv,type)

Analytica equivalent:

IPmt(rate,per,nper,pv,fv,type)

IRR(values,guess)

Analytica equivalent:

Irr(values,I,guess)

where I is the index that the internal rate of return is computed over. This index parameter is often the Time index.

NPER(rate,pmt,pv,fv,type)

Analytica equivalent:

NPer(rate,pmt,pv,fv,type) 

NPV(rate,value1,value2,...)

Analytica equivalent:

Npv(rate,values,I)

where I is the index that the net present value is computed over. The Time index is often used for this index.

PMT(rate,nper,pv,fv,type)

Analytica equivalent:

Pmt(rate,nper,pv,fv,type)

PPMT(rate,per,nper,pv,fv,type)

Analytica equivalentt:

PPmt(rate,per,nper,pv,fv,type)

PV(rate,nper,pmt,fv,type)

Analytica equivalent:

Pv(rate,nper,pmt,fv,type)

RATE(nper,pmt,pv,fv,type,guess)

Analytica equivalent:

Rate(nper,pmt,pv,fv,type,guess)

XIRR(values,dates,guess)

Analytica equivalent:

XIrr(values,dates,I,guess)

where the index I dimensions both values and dates.

XNPV(rate,values,dates)

Analytica equivalent:

XNpv(rate,values,dates,I)

where the index I dimensions both values and dates.