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.