Financial Functions

The list of predefined financial functions is given in the table below:

Function	Brief description
Accrint	Returns an accrued interest for securities with periodic interest payments.
AccrintM	Returns the accrued interest for a security that pays interest at maturity.
AmorDegrC	Returns the depreciation for each period.
AmorLinC	Returns the depreciation for each period.
CoupDayBs	Returns the number of days from the beginning of the coupon period to the settlement date.
CoupDays	Returns the number of days in the coupon period that contains the settlement date.
CoupDaysNc	Returns the number of days from the settlement date to the next coupon date..
CoupNcd	Returns the number that is the next coupon date after the settlement date.
CoupNum	Returns the number of coupons payable between the settlement date and maturity date that is rounded to the nearest integer number of coupons.
CoupPcd	Returns the number that is the previous coupon date before the settlement date.
CumIpmt	Returns the cumulative interest (running total) paid on a loan between two payment periods.
Cumprinc	Returns the cumulative, running total, principal paid on a loan between two periods.
Db	Returns the depreciation of an asset for a specified period using the fixed-declining balance method.
Ddb	Returns the depreciation of an asset for a specified period using the double declining balance method or some other method you specify.
Disc	Returns the discount rate for a security.
DollarDe	Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction.
DollarFr	Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction.
Duration	Returns Macauley duration for an assumed face value of 100 dollars.
Effect	Returns the effective, actual, annual interest rate if nominal annual interest rate and the number of compounding periods per year are set.
Fv	Returns the future value of an investment based on periodic, constant payments and a constant interest rate.
FvSchedule	Returns a future value of the initial principal after a series (schedule) of compound interest rates have been applied.
Intrate	Returns the interest rate for a fully invested security.
Ipmt	Returns the interest payment for a given period for an investment, based on periodic, constant payments and a constant interest rate.
Irr	Returns the internal rate of return for a series of cash flows presented with their numeric values.
Ispmt	Returns an interest, paid over the specified investment period.
MDuration	Returns the modified Macaulay duration for securities with assumed $100 face value.
MIrr	Returns the internal rate of return for a series of periodic cash flows.
Nominal	Returns the annual nominal interest rate if effective (actual) interest rate and the number of compounding periods per year are set.
NPer	Returns the total number of periods for an investment based on periodic, constant payments and a constant interest rate.
Npv	Returns the net present value of an investment based on a discount rate and a series of future payments (negative values) and income (positive values).
OddfPrice	Returns the price per 100 dollars face value of securities for an odd, short or long, first period.
OddfYield	Returns the income on securities with an irregular (short or long) first period.
OddlPrice	Returns the price per 100 dollars of securities face value for the irregular (short or long) last period of coupon.
OddlYield	Returns the income on securities with irregular (short or long) last period.
Pmt	Calculates the payment for a loan based on constant payments and a constant interest rate.
Ppmt	Returns the payment on the principal for a given investment based on periodic, constant payments and a constant interest rate.
Price	Returns the price per $100 face value of the securities that pay periodic interest.
PriceDisc	Returns the price per $100 face value of a discounted security.
PriceMat	Returns the price per $100 face value of the securities that pay interest at maturity.
Pv	Returns the current value of an investment.
Rate	Returns the interest rate per period of a loan or an investment.
Received	Returns the amount received at maturity for a fully invested security.
RedemptionYield	Returns yield to maturity with odd payment periods.
Sln	Returns the straight-line depreciation of an asset for one period.
Syd	Returns the sum-of-years' digits depreciation of an asset for a specified period.
TBillEq	Returns the bond-equivalent yield for a treasury bill.
TBillPrice	Returns the price per $100 face value for a treasury bill.
TBillYield	It returns the income for a treasury bill.
Vdb	Returns the value of asset depreciation over any selected period, including partial periods, using the method of double balance decrease or any other specified method.
XIrr	Returns the internal rate of return for a schedule of cash flows that are optionally periodic.
Xnpv	Returns the net present value for a schedule of cash flows that are optionally periodic.
YieldDisc	Returns annual yield of the securities for which a discount is made.
YieldF	Returns the yield on securities, for which interest is paid periodically.
YieldMat	Returns the annual yield of a security that pays interest at maturity.