Difference between revisions of "Excel to Analytica Mappings/Financial Functions"
(3 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
+ | [[Category: Excel to Analytica mappings]] | ||
+ | |||
<div style="column-count:3;-moz-column-count:3;-webkit-column-count:3"> | <div style="column-count:3;-moz-column-count:3;-webkit-column-count:3"> | ||
__TOC__ | __TOC__ | ||
Line 26: | Line 28: | ||
== CUMIPMT(rate, nper, pv, start_period, end_period, type) == | == CUMIPMT(rate, nper, pv, start_period, end_period, type) == | ||
− | Analytica equivalent: | + | ''Analytica equivalent:'' |
− | + | :[[CumIPmt]](rate, nper, pv'', start_per, end_per, type'') | |
== CUMPRINC(rate, nper, pv, start_period, end_period, type) == | == CUMPRINC(rate, nper, pv, start_period, end_period, type) == | ||
− | Analytica equivalent: | + | ''Analytica equivalent:'' |
− | + | :[[CumPrinc]](rate, nper, pv'', start_per, end_per, type'') | |
== DB(cost, salvage, life, period'', month'') == | == DB(cost, salvage, life, period'', month'') == | ||
Line 50: | Line 52: | ||
== FV(rate, nper, pmt'', pv, type'') == | == FV(rate, nper, pmt'', pv, type'') == | ||
− | Analytica equivalent: | + | ''Analytica equivalent:'' |
− | + | :[[Fv]](rate, nper, pmt'', pv, type'') | |
== FVSCHEDULE(principal, schedule) == | == FVSCHEDULE(principal, schedule) == | ||
Line 57: | Line 59: | ||
This computes the future value of principal after compounding interest according to a time-varying array of interest rates. So when this is used, «schedule» is an array. In Analytica, since «schedule» is an array, it will have an index, say ''I''. The equivalent is then: | This computes the future value of principal after compounding interest according to a time-varying array of interest rates. So when this is used, «schedule» is an array. In Analytica, since «schedule» is an array, it will have an index, say ''I''. The equivalent is then: | ||
− | + | :principal * [[Product]](1+schedule, I) | |
== INTRATE(settlement, maturity, coupon, yld, frequency'', basis'') == | == INTRATE(settlement, maturity, coupon, yld, frequency'', basis'') == | ||
Line 63: | Line 65: | ||
== IPMT(rate, per, nper, pv'', fv, type'') == | == IPMT(rate, per, nper, pv'', fv, type'') == | ||
− | Analytica equivalent: | + | ''Analytica equivalent:'' |
− | + | :[[IPmt]](rate, per, nper, pv'', fv, type'') | |
== IRR(values'', guess'') == | == IRR(values'', guess'') == | ||
− | Analytica equivalent: | + | ''Analytica equivalent:'' |
− | + | :[[Irr]](values, I'', guess'') | |
− | where | + | where «I» is the index that the internal rate of return is computed over. This index parameter is often the [[Time]] index. |
== ISPMT(rate, per, nper, pv) == | == ISPMT(rate, per, nper, pv) == | ||
− | + | ''Analytica equivalent:'' | |
− | + | :-pv*(1-per/nper)*rate | |
== MDURATION(settlement, maturity, coupon, yld, frequency'', basis'') == | == MDURATION(settlement, maturity, coupon, yld, frequency'', basis'') == | ||
Line 81: | Line 83: | ||
== MIRR(values, finance_rate, reinvest_rate == | == MIRR(values, finance_rate, reinvest_rate == | ||
− | + | ''Analytica equivalent'': | |
− | + | :[[MIrr]](values, I, finance_rate, reinvest_rate) | |
− | where the array of cash flows, | + | where the array of cash flows, «values», is indexed by «I». |
== NOMINAL(effect_rate, npery) == | == NOMINAL(effect_rate, npery) == | ||
Line 89: | Line 91: | ||
== NPER(rate, pmt, pv'', fv, type'') == | == NPER(rate, pmt, pv'', fv, type'') == | ||
− | Analytica equivalent: | + | ''Analytica equivalent:'' |
− | + | :[[NPer]](rate, pmt, pv'', fv, type'') | |
== NPV(rate, value1, value2, ...) == | == NPV(rate, value1, value2, ...) == | ||
− | Analytica equivalent: | + | ''Analytica equivalent:'' |
− | + | :[[Npv]](rate, values, I) | |
− | where | + | where «I» is the index that the net present value is computed over. The [[Time]] index is often used for this index. |
== ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency'', basis'') == | == ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency'', basis'') == | ||
Line 108: | Line 110: | ||
== PMT(rate, nper, pv'', fv, type'') == | == PMT(rate, nper, pv'', fv, type'') == | ||
− | Analytica equivalent: | + | ''Analytica equivalent:'' |
− | + | :[[Pmt]](rate, nper, pv'', fv, type'') | |
== PPMT(rate, per, nper, pv'', fv, type'') == | == PPMT(rate, per, nper, pv'', fv, type'') == | ||
− | Analytica equivalentt: | + | ''Analytica equivalentt:'' |
− | + | :[[PPmt]](rate, per, nper, pv'', fv, type'') | |
== PRICE(settlement, maturity, discount, redemption'', basis'') == | == PRICE(settlement, maturity, discount, redemption'', basis'') == | ||
Line 124: | Line 126: | ||
== PV(rate, nper, pmt'', fv, type'') == | == PV(rate, nper, pmt'', fv, type'') == | ||
− | Analytica equivalent: | + | ''Analytica equivalent:'' |
− | + | :[[Pv]](rate, nper, pmt'', fv, type'') | |
== RATE(nper, pmt, pv'', fv, type, guess'') == | == RATE(nper, pmt, pv'', fv, type, guess'') == | ||
− | Analytica equivalent: | + | ''Analytica equivalent:'' |
− | + | :[[Rate]](nper, pmt, pv'', fv, type, guess'') | |
== RECEIVED(settlement, maturity, investment, discount'', basis'') == | == RECEIVED(settlement, maturity, investment, discount'', basis'') == | ||
Line 136: | Line 138: | ||
== SLN(cost, salvage, life) == | == SLN(cost, salvage, life) == | ||
− | Analytica equivalent: | + | ''Analytica equivalent: '' |
− | + | :(cost-salvage)/life | |
== SYD(cost, salvage, life, pr) == | == SYD(cost, salvage, life, pr) == | ||
Line 151: | Line 153: | ||
== XIRR(values, dates'', guess'') == | == XIRR(values, dates'', guess'') == | ||
− | Analytica equivalent: | + | ''Analytica equivalent:'' |
− | + | :[[XIrr]](values, dates, I'', guess'') | |
− | where the index | + | where the index «I» dimensions both «values» and «dates». |
== XNPV(rate, values, dates) == | == XNPV(rate, values, dates) == | ||
− | Analytica equivalent: | + | ''Analytica equivalent:'' |
− | + | :[[XNpv]](rate, values, dates, I) | |
− | where the index | + | where the index «I» dimensions both «values» and «dates». |
== YIELD(settlement, maturity, rate, pr, redemption, frequency'', basis'') == | == YIELD(settlement, maturity, rate, pr, redemption, frequency'', basis'') == | ||
Line 166: | Line 168: | ||
== YIELDMAT(settlement, maturity, issue, rate, pr'', basis'') == | == YIELDMAT(settlement, maturity, issue, rate, pr'', basis'') == | ||
+ | |||
+ | ==See Also== | ||
+ | * [[Excel to Analytica Mappings]] |
Latest revision as of 23:41, 16 March 2016
ACCRINT(issue, first_interest, settlement, rate, par, frequency, basis, calc_method)
ACCRINTM(issue, settlement, rate, par, basis)
AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, basis)
AMORLINC(cost, date_purchased, first_period, salvage, period, rate, basis)
COUPDAYBS(settlement, maturity, frequency, basis)
COUPDAYS(settlement, maturity, frequency, basis)
COUPDAYSNC(settlement, maturity, frequency, basis)
COUPNCD(settlement, maturity, frequency, basis)
COUPNUM(settlement, maturity, frequency, basis)
COUPPCD(settlement, maturity, frequency, basis)
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(cost, salvage, life, period, month)
DDB(cost, salvage, life, period, factor)
DISC(settlement, maturity, pr, redemption, basis)
DOLLARDE(fractional_dollar, fraction)
DOLLARFR(decimal_dollar, fraction)
DURATION(settlement, maturity, coupon, yld, frequency, basis)
EFFECT(nominal_rate, npery)
FV(rate, nper, pmt, pv, type)
Analytica equivalent:
- Fv(rate, nper, pmt, pv, type)
FVSCHEDULE(principal, schedule)
This computes the future value of principal after compounding interest according to a time-varying array of interest rates. So when this is used, «schedule» is an array. In Analytica, since «schedule» is an array, it will have an index, say I. The equivalent is then:
- principal * Product(1+schedule, I)
INTRATE(settlement, maturity, coupon, yld, frequency, basis)
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(rate, per, nper, pv)
Analytica equivalent:
- -pv*(1-per/nper)*rate
MDURATION(settlement, maturity, coupon, yld, frequency, basis)
MIRR(values, finance_rate, reinvest_rate
Analytica equivalent:
- MIrr(values, I, finance_rate, reinvest_rate)
where the array of cash flows, «values», is indexed by «I».
NOMINAL(effect_rate, npery)
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(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, basis)
ODDFYEILD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, basis)
ODDLPRICE(settlement, maturity, last_interest, rate, yld, redemption, frequency, basis)
ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency, basis)
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(settlement, maturity, discount, redemption, basis)
PRICEDISC(settlement, maturity, discount, redemption, basis)
PRICEMAT(settlement, maturity, issue, rate, yld, basis)
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(settlement, maturity, investment, discount, basis)
SLN(cost, salvage, life)
Analytica equivalent:
- (cost-salvage)/life
SYD(cost, salvage, life, pr)
TBILLEQ(settlement, maturity, discount)
TBILLPRICE(settlement, maturity, discount)
TBILLYIELD(cost, salvage, life, start_period, end_period, factor, no_switch)
VDB(cost, salvage, life, start_period, end_period, factor, no_switch)
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».
Enable comment auto-refresher