Financial Functions
- 4 minutes to read
This document describes financial functions implemented in the ASPxSpreadsheet.
ACCRINTM(issue, settlement, rate, par, [basis])- Returns the accrued interest for a security that pays interest at maturity.
COUPDAYBS(settlement, maturity, frequency, [basis])- Returns the number of days from the beginning of the coupon period to the settlement date.
COUPNCD(settlement, maturity, frequency, [basis])- Returns the next coupon date after the settlement date.
COUPNUM(settlement, maturity, frequency, [basis])- Returns the number of coupons payable between the settlement date and maturity date.
COUPPCD(settlement, maturity, frequency, [basis])- Returns the previous coupon date before the settlement date.
CUMIPMT(rate, nper, pv, start_period, end_period, type)- Calculates the cumulative interest paid between two specified periods.
CUMPRINC(rate, nper, pv, start_period, end_period, type)- Calculates the cumulative principal paid on a loan, between two specified periods.
DB(cost, salvage, life, period, [month])- Returns the depreciation of an asset for a specified period by using the fixed-declining balance method.
DDB(cost, salvage, life, period, [factor])- Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify.
DISC(settlement, maturity, pr, redemption, [basis])- Returns the discount rate for a security.
DOLLARDE(fractional_dollar, fraction)- Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number.
DOLLARFR(decimal_dollar, fraction)- Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction.
FVSCHEDULE(principal, schedule)- Returns the future value of an initial principal after applying a series of compound interest rates.
EFFECT(nominal_rate, npery)- Returns the effective annual interest rate.
FV(rate,nper,pmt,[pv],[type])- Calculates the future value of an investment with periodic constant payments and a constant interest rate.
INTRATE(settlement, maturity, investment, redemption, [basis])- Returns the interest rate for a fully invested security.
IPMT(rate, per, nper, pv, [fv], [type])- Calculates the interest payment for a given period of an investment, with periodic constant payments and a constant interest rate.
IRR(values, [guess])- Calculates the internal rate of return for a series of cash flows.
ISPMT(rate, per, nper, pv)- Calculates the interest paid during a specific period of an investment.
MIRR(values, finance_rate, reinvest_rate)- Calculates the internal rate of return for a series of periodic cash flows, considering the cost of the investment and the interest on the reinvestment of cash.
NOMINAL(effect_rate, npery)- Returns the annual nominal interest rate.
NPER(rate,pmt,pv,[fv],[type])- Returns the number of periods for an investment with periodic constant payments and a constant interest rate.
NPV(rate,value1,[value2],...)- Calculates the net present value of an investment, based on a supplied discount rate, and a series of future payments and income.
PDURATION(rate, pv, fv)- Returns the number of periods required by an investment to reach a specified value.
PMT(rate, nper, pv, [fv], [type])- Calculates the payments required to reduce a loan, from a supplied present value to a specified future value.
PPMT(rate, per, nper, pv, [fv], [type])- Calculates the payment on the principal for a given investment, with periodic constant payments and a constant interest rate.
PRICEDISC(settlement, maturity, discount, redemption, [basis])- Returns the price per $100 face value of a discounted security.
PV(rate, nper, pmt, [fv], [type])- Calculates the present value of an investment (i.e., the total amount that a series of future payments is worth now).
RATE(nper, pmt, pv, [fv], [type], [guess])- Calculates the interest rate required to pay off a specified amount of a loan, or reach a target amount on an investment over a given period.
RECEIVED(settlement, maturity, investment, discount, [basis])- Returns the amount received at maturity for a fully invested security.
RRI(nper, pv, fv)- Returns an equivalent interest rate for the growth of an investment.
SLN(cost, salvage, life)- Returns the straight-line depreciation of an asset for one period.
SYD(cost, salvage, life, per)- Returns the sum-of-years’ digits depreciation of an asset for a specified period.
TBILLEQ(settlement, maturity, discount)- Returns the bond-equivalent yield for a Treasury bill.
TBILLPRICE(settlement, maturity, discount)- Returns the price per $100 face value for a Treasury bill.
TBILLYIELD(settlement, maturity, pr)- Returns the yield for a Treasury bill.
VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])- Returns the depreciation of an asset for a specified or partial period by using a declining balance method.
YIELDDISC(settlement, maturity, pr, redemption, [basis])- Returns the annual yield for a discounted security; for example, a Treasury bill.
XNPV(rate, values, dates)- Returns the net present value for a schedule of cash flows that is not necessarily periodic.
XIRR(values, dates, [guess])- Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.