Difference between revisions of "Excel to Analytica Mappings/Financial Functions"

Line 46: Line 46:
 
= ISPMT =
 
= ISPMT =
 
= MDURATION =
 
= MDURATION =
= MIRR =
+
= MIRR(values,finance_rate,reinvest_rate =
 +
 
 +
Analytica equivalent (''requires Analytica 4.2 or later''):
 +
[[MIrr]](values,I,finance_rate,reinvest_rate)
 +
where the array of cash flows, ''values'', is indexed by ''I''.
 +
 
 
= NOMINAL =
 
= NOMINAL =
 
= NPER(rate,pmt,pv'',fv,type'') =
 
= NPER(rate,pmt,pv'',fv,type'') =

Revision as of 23:28, 10 November 2008

ACCRINT

ACCRINTM

AMORDEGRC

AMORLINC

COUPDAYBS

COUPDAYS

COUPDAYSNC

COUPNCD

COUPNUM

COUPPCD

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)

DB

DDB

DISC

DOLLARDE

DOLLARFR

DURATION

EFFECT

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

Analytica equivalent:

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

FVSCHEDULE

INTRATE

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.

ISPMT

MDURATION

MIRR(values,finance_rate,reinvest_rate

Analytica equivalent (requires Analytica 4.2 or later):

MIrr(values,I,finance_rate,reinvest_rate)

where the array of cash flows, values, is indexed by I.

NOMINAL

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.

ODDFPRICE

ODDFYEILD

ODDLPRICE

ODDLYIELD

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)

PRICE

PRICEDISC

PRICEMAT

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)

RECEIVED

SLN

SYD

TBILLEQ

TBILLPRICE

TBILLYIELD

VDB

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.

YIELD

YIELDDISC

YIELDMAT

Comments


You are not allowed to post comments.