Documentation/How Tos/Calc: Financial functions

Financial Functions

The Financial functions provide common business calculations.

Depreciation
AMORDEGRC	Returns depreciation for a period using degressive depreciation (French system).
AMORLINC	Returns depreciation for a period using linear depreciation (French system).
DB	Returns the depreciation of an asset for a given year using the fixed rate declining-balance method.
DDB	Returns the depreciation of an asset for a given year using the double (or other factor) declining-balance method.
SLN	Returns the depreciation of an asset in a single period using the straight-line depreciation method.
SYD	Returns the depreciation of an asset for a given year using the sum-of-years'-digits method.
VDB	Returns the depreciation of an asset for a given year using a variable declining-balance method.
Payment Streams, Annuities, Loans
CUMIPMT	Returns the total interest paid on a loan in specified periodic payments.
CUMIPMT_ADD	Returns the total interest paid on a loan in specified periodic payments.
CUMPRINC	Returns the total capital repaid on a loan in specified periodic payments.
CUMPRINC_ADD	Returns the total capital repaid on a loan in specified periodic payments.
FV	Returns the future value of an initial sum with a subsequent stream of payments.
FVSCHEDULE	Returns the future value of an initial sum, with changing future interest rates.
IPMT	Returns the portion of the periodic payment which is interest for a fixed rate loan or annuity.
IRR	Calculates the internal rate of return of a series of cash flows.
ISPMT	Returns the interest paid in a period for a fixed rate loan.
MIRR	Returns the modified internal rate of return of a series of cash flows.
NPER	Returns the number of payment periods for an annuity.
NPV	Returns the net present value of an investment with regular cash payments.
PMT	Returns the payment per period for a fixed rate loan.
PPMT	Returns the portion of the periodic payment which is repaid capital for a fixed rate loan or annuity.
PV	Returns the present value of a stream of future payments with a final lump sum.
RATE	Calculates the interest rate for an annuity.
RRI	Returns an equivalent interest rate when an investment increases in value.
XIRR	Calculates the internal rate of return of a series of irregular cash flows.
XNPV	Returns the net present value of an investment with irregular cash payments.
Securities
ACCRINT	Calculates the accrued interest for a security with periodic interest payments.
ACCRINTM	Calculates the accrued interest for a security that pays at maturity.
DISC	Returns the discount rate of a security.
DURATION	Returns the number of periods needed for an investment to reach a certain value.
DURATION_ADD	Returns the Macaulay duration of a security.
EFFECTIVE	Returns the effective compounded interest rate given a nominal interest rate.
EFFECT_ADD	Returns the effective compounded interest rate given a nominal interest rate.
INTRATE	Returns the equivalent annual interest rate for an investment bought at one price and sold at another.
MDURATION	Returns the modified Macaulay duration of a security.
NOMINAL	Returns a nominal interest rate given the effective compounded interest rate.
NOMINAL_ADD	Returns a nominal interest rate given the effective compounded interest rate.
ODDFPRICE	Returns the value of a security per 100 currency units of face value, where the time to the first interest payment is not a whole period.
ODDFYIELD	Returns the yield of a security, where the time to the first interest payment is not a whole period.
ODDLPRICE	Returns the value of a security per 100 currency units of face value, where the last interest payment is not a whole period.
ODDLYIELD	Returns the yield of a security, where the last interest payment is not a whole period.
PRICE	Calculates a quoted price for an interest paying security, per 100 currency units par value.
PRICEDISC	Calculates a price for a non-interest paying discounted bond.
PRICEMAT	Calculates a price (per 100 currency units par value) for a bond that pays interest on maturity.
RECEIVED	Calculates the amount received at maturity for a zero coupon bond.
TBILLEQ	Returns the bond-equivalent-yield (BEY) for a US Treasury bill.
TBILLPRICE	Returns the issue price for a US Treasury bill, per $100 par value, given a discount rate.
TBILLYIELD	Returns the yield for a US Treasury bill.
YIELD	Calculates the yield for an interest paying security.
YIELDDISC	Calculates the yield for a non-interest paying discounted bond.
YIELDMAT	Calculates the yield for a bond that pays interest on maturity.
Coupons
COUPDAYBS	Returns the number of days between the coupon date preceding the settlement, and the settlement date.
COUPDAYS	Returns the number of days in the coupon period that contains the settlement date.
COUPDAYSNC	Returns the number of days between the settlement date and the next coupon date.
COUPNCD	Returns the coupon date next after the settlement date.
COUPNUM	Returns the number of coupons (interest payments) between the settlement date and maturity.
COUPPCD	Returns the coupon (interest payment) date which precedes the settlement date.
Miscellaneous
DOLLARDE	Converts a fractional number representation of a number into a decimal number.
DOLLARFR	Converts a decimal number into a fractional representation of that number.

See also

Derivation of Financial Formulas

Financial date systems

Functions listed alphabetically, Functions listed by category