Financial Functions

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

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