Difference between revisions of "Excel to Analytica Mappings/Financial Functions"
| Line 48: | Line 48: | ||
= MIRR = | = MIRR = | ||
= NOMINAL = | = NOMINAL = | ||
| − | = NPER = | + | = NPER(rate,pmt,pv'',fv,type'') = |
| − | = NPV = | + | |
| + | 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 = | = ODDFPRICE = | ||
= ODDFYEILD = | = ODDFYEILD = | ||
= ODDLPRICE = | = ODDLPRICE = | ||
= ODDLYIELD = | = ODDLYIELD = | ||
| − | = PMT = | + | |
| − | = PPMT = | + | = 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 = | = PRICE = | ||
= PRICEDISC = | = PRICEDISC = | ||
= PRICEMAT = | = PRICEMAT = | ||
| − | = PV = | + | |
| − | = RATE = | + | = 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 = | = RECEIVED = | ||
= SLN = | = SLN = | ||
| Line 68: | Line 95: | ||
= TBILLYIELD = | = TBILLYIELD = | ||
= VDB = | = VDB = | ||
| − | = XIRR = | + | = XIRR(values,dates'',guess'') = |
| − | = XNPV = | + | |
| + | 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 = | = YIELD = | ||
= YIELDDISC = | = YIELDDISC = | ||
= YIELDMAT = | = YIELDMAT = | ||
Revision as of 22:13, 10 January 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
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
Enable comment auto-refresher