20.1
19.2
19.1
18.2
18.1
17.2

# Financial Functions

This document describes financial functions implemented in the XtraSpreadsheet.

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