Documentation/How Tos/Calc: Financial functions

Financial Functions

The Financial functions provide common business calculations.

AMORDEGRC	Calculates the amount of depreciation for a settlement period as degressive amortization. Unlike AMORLINC, a depreciation coefficient that is independent of the depreciable life is used here.
AMORLINC	Calculates the amount of depreciation for a settlement period as linear amortization. If the capital asset is purchased during the settlement period, the proportional amount of depreciation is considered.
ACCRINT	Calculates the accrued interest of a security in the case of periodic payments.
ACCRINTM	Calculates the accrued interest of a security in the case of one-off payment at the settlement date.
RECEIVED	Calculates the amount received that is paid for a fixed-interest security at a given point in time.
PV	Returns the present value of an investment resulting from a series of regular payments.
SYD	Returns the arithmetic-declining depreciation rate.
DISC	Calculates the allowance (discount) of a security as a percentage.
DURATION_ADD	Calculates the duration of a fixed interest security in years.
EFFECTIVE	Returns the net annual interest rate for a nominal interest rate.
EFFECT_ADD	Calculates the effective annual rate of interest on the basis of the nominal interest rate and the number of interest payments per annum.
DDB	Returns the depreciation of an asset for a specified period using the arithmetic-declining method.
DB	Returns the depreciation of an asset for a specified period using the double-declining balance method.
IRR	Calculates the internal rate of return for an investment. The values represent cash flow values at regular intervals, at least one value must be negative (payments), and at least one value must be positive (income).
ISPMT	Calculates the level of interest for unchanged amortization installments.
PPMT	Returns for a given period the payment on the principal for an investment that is based on periodic and constant payments and a constant interest rate.
CUMPRINC	Returns the cumulative interest paid for an investment period with a constant interest rate.
CUMPRINC_ADD	Calculates the cumulative redemption of a loan in a period.
CUMIPMT	Calculates the cumulative interest payments, that is, the total interest, for an investment based on a constant interest rate.
CUMIPMT_ADD	Calculates the accumulated interest for a period.
PRICE	Calculates the market value of a fixed interest security with a par value of 100 currency units as a function of the forecast yield.
PRICEDISC	Calculates the price per 100 currency units of par value of a non-interest- bearing security.
PRICEMAT	Calculates the price per 100 currency units of par value of a security, that pays interest on the maturity date.
DURATION	Calculates the number of periods required by an investment to attain the desired value.
SLN	Returns the straight-line depreciation of an asset for one period.The amount of the depreciation is constant during the depreciation period.
MDURATION	Calculates the modified Macauley duration of a fixed interest security in years.
NPV	Returns the present value of an investment based on a series of periodic cash flows and a discount rate. To get the net present value, subtract the cost of the project (the initial cash flow at time zero) from the returned value.
NOMINAL	Calculates the yearly nominal interest rate, given the effective rate and the number of compounding periods per year.
NOMINAL_ADD	Calculates the annual nominal rate of interest on the basis of the effective rate and the number of interest payments per annum.
DOLLARFR	Converts a quotation that has been given as a decimal number into a mixed decimal fraction.
DOLLARDE	Converts a quotation that has been given as a decimal fraction into a decimal number.
MIRR	Calculates the modified internal rate of return of a series of investments.
YIELD	Calculates the yield of a security.
YIELDDISC	Calculates the annual yield of a non-interest-bearing security.
YIELDMAT	Calculates the annual yield of a security, the interest of which is paid on the date of maturity.
PMT	Returns the periodic payment for an annuity with constant interest rates.
TBILLEQ	Calculates the annual return on a treasury bill (). A treasury bill is purchased on the settlement date and sold at the full par value on the maturity date, that must fall within the same year. A discount is deducted from the purchase price.
TBILLPRICE	Calculates the price of a treasury bill per 100 currency units.
TBILLYIELD	Calculates the yield of a treasury bill.
ODDFPRICE	Calculates the price per 100 currency units par value of a security, if the first interest date falls irregularly.
ODDFYIELD	Calculates the yield of a security if the first interest date falls irregularly.
ODDLPRICE	Calculates the price per 100 currency units par value of a security, if the last interest date falls irregularly.
ODDLYIELD	Calculates the yield of a security if the last interest date falls irregularly.
VDB	Returns the depreciation of an asset for a specified or partial period using a variable declining balance method.
XIRR	Calculates the internal rate of return for a list of payments which take place on different dates. The calculation is based on a 365 days per year basis, ignoring leap years.
XNPV	Calculates the capital value (net present value)for a list of payments which take place on different dates. The calculation is based on a 365 days per year basis, ignoring leap years.
RRI	Calculates the interest rate resulting from the profit (return) of an investment.
RATE	Returns the constant interest rate per period of an annuity.
INTRATE	Calculates the annual interest rate that results when a security (or other item) is purchased at an investment value and sold at a redemption value. No interest is paid.
COUPNCD	Returns the date of the first interest date after the settlement date. Format the result as a date.
COUPDAYS	Returns the number of days in the current interest period in which the settlement date falls.
COUPDAYSNC	Returns the number of days from the settlement date until the next interest date.
COUPDAYBS	Returns the number of days from the first day of interest payment on a security until the settlement date.
COUPPCD	Returns the date of the interest date prior to the settlement date. Format the result as a date.
COUPNUM	Returns the number of coupons (interest payments) between the settlement date and the maturity date.
IPMT	Calculates the periodic amortizement for an investment with regular payments and a constant interest rate.
FV	Returns the future value of an investment based on periodic, constant payments and a constant interest rate (Future Value).
FVSCHEDULE	Calculates the accumulated value of the starting capital for a series of periodically varying interest rates.
NPER	Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.

See also

Functions listed by category