Financial Functions
The following topics describe the financial functions provided by the CALC object. Each CALC function returns the same result as the Excel function of the similar name.
|
Many financial functions include an optional parameter basis to indicate the day count convention:
|
-
CALC.accrint(issue, interest, settlement, rate, par, freq [, basis])
-
CALC.amordegrc(cost, date_purchased, first_period, salvage, period, rate, [basis])
-
CALC.amorlinc(cost, date_purchased, first_period, salvage, period, rate, [basis])
-
CALC.cumipmt(rate, nper, pv, start_period, end_period, type)
-
CALC.cumprinc(rate, nper, pv, start_period, end_period, type)
-
CALC.duration(settlement, maturity, rate, yld, frequency, [basis])
-
CALC.intrate(settlement, maturity, investment, redemption, [basis])
-
CALC.mduration(settlement, maturity, rate, yld, frequency, [basis])
-
CALC.price(settlement, maturity, rate, yld, redemption, frequency, [basis])
-
CALC.pricedisc(settlement, maturity, discount, redemption, [basis])
-
CALC.pricemat(settlement, maturity, issue, rate, yld, [basis])
-
CALC.received(settlement, maturity, investment, discount, [basis])
-
CALC.vdb(cost, salvage, life, start_period, end_period, [factor, no_switch])
-
CALC.yielddisc(settlement, maturity, pr, redemption, [basis])
-
CALC.yieldmat(settlement, maturity, issue, rate, pr, [basis])