Financial (ExcelFinancialFunctions)

Financial Type

Namespace: Excel.FinancialFunctions
Assembly: ExcelFinancialFunctions.dll
Base Type: obj

A wrapper class to expose the Excel financial functions API to .NET clients

Static members

Static member	Description
`Financial.AccrInt(issue, firstInterest, settlement, rate, par, frequency, basis)` Full Usage: `Financial.AccrInt(issue, firstInterest, settlement, rate, par, frequency, basis)` Parameters: issue : `DateTime` firstInterest : `DateTime` settlement : `DateTime` rate : `float` par : `float` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`	ACCRINT function The accrued interest for a security that pays periodic interest, using "FromIssueToSettlement" calculation method issue : `DateTime` firstInterest : `DateTime` settlement : `DateTime` rate : `float` par : `float` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`
`Financial.AccrInt(issue, firstInterest, settlement, rate, par, frequency, basis, calcMethod)` Full Usage: `Financial.AccrInt(issue, firstInterest, settlement, rate, par, frequency, basis, calcMethod)` Parameters: issue : `DateTime` firstInterest : `DateTime` settlement : `DateTime` rate : `float` par : `float` frequency : `Frequency` basis : `DayCountBasis` calcMethod : `AccrIntCalcMethod` Returns: `float`	ACCRINT function The accrued interest for a security that pays periodic interest issue : `DateTime` firstInterest : `DateTime` settlement : `DateTime` rate : `float` par : `float` frequency : `Frequency` basis : `DayCountBasis` calcMethod : `AccrIntCalcMethod` Returns: `float`
`Financial.AccrIntM(issue, settlement, rate, par, basis)` Full Usage: `Financial.AccrIntM(issue, settlement, rate, par, basis)` Parameters: issue : `DateTime` settlement : `DateTime` rate : `float` par : `float` basis : `DayCountBasis` Returns: `float`	ACCRINTM function The accrued interest for a security that pays interest at maturity issue : `DateTime` settlement : `DateTime` rate : `float` par : `float` basis : `DayCountBasis` Returns: `float`
`Financial.AmorDegrc(cost, datePurchased, firstPeriod, salvage, period, rate, basis, excelCompliant)` Full Usage: `Financial.AmorDegrc(cost, datePurchased, firstPeriod, salvage, period, rate, basis, excelCompliant)` Parameters: cost : `float` datePurchased : `DateTime` firstPeriod : `DateTime` salvage : `float` period : `float` rate : `float` basis : `DayCountBasis` excelCompliant : `bool` Returns: `float`	AMORDEGRC function The depreciation for each accounting period by using a depreciation coefficient ExcelCompliant is used because Excel stores 13 digits. AmorDegrc algorithm rounds numbers and returns different results unless the numbers get rounded to 13 digits before rounding them. I.E. 22.49999999999999 is considered 22.5 by Excel, but 22.4 by the .NET framework cost : `float` datePurchased : `DateTime` firstPeriod : `DateTime` salvage : `float` period : `float` rate : `float` basis : `DayCountBasis` excelCompliant : `bool` Returns: `float`
`Financial.AmorLinc(cost, datePurchased, firstPeriod, salvage, period, rate, basis)` Full Usage: `Financial.AmorLinc(cost, datePurchased, firstPeriod, salvage, period, rate, basis)` Parameters: cost : `float` datePurchased : `DateTime` firstPeriod : `DateTime` salvage : `float` period : `float` rate : `float` basis : `DayCountBasis` Returns: `float`	AMORLINC function The depreciation for each accounting period cost : `float` datePurchased : `DateTime` firstPeriod : `DateTime` salvage : `float` period : `float` rate : `float` basis : `DayCountBasis` Returns: `float`
`Financial.CoupDays(settlement, maturity, frequency, basis)` Full Usage: `Financial.CoupDays(settlement, maturity, frequency, basis)` Parameters: settlement : `DateTime` maturity : `DateTime` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`	COUPDAYS function The number of days in the coupon period that contains the settlement date The Excel algorithm seems wrong in that it doesn't respect `coupDays = coupDaysBS + coupDaysNC` This equality should stand. The differs from Excel by +/- one or two days when the date spans a leap year. settlement : `DateTime` maturity : `DateTime` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`
`Financial.CoupDaysBS(settlement, maturity, frequency, basis)` Full Usage: `Financial.CoupDaysBS(settlement, maturity, frequency, basis)` Parameters: settlement : `DateTime` maturity : `DateTime` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`	COUPDAYBS function The number of days from the beginning of the coupon period to the settlement date settlement : `DateTime` maturity : `DateTime` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`
`Financial.CoupDaysNC(settlement, maturity, frequency, basis)` Full Usage: `Financial.CoupDaysNC(settlement, maturity, frequency, basis)` Parameters: settlement : `DateTime` maturity : `DateTime` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`	COUPDAYSNC function The number of days from the settlement date to the next coupon date settlement : `DateTime` maturity : `DateTime` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`
`Financial.CoupNCD(settlement, maturity, frequency, basis)` Full Usage: `Financial.CoupNCD(settlement, maturity, frequency, basis)` Parameters: settlement : `DateTime` maturity : `DateTime` frequency : `Frequency` basis : `DayCountBasis` Returns: `DateTime`	COUPNCD function The next coupon date after the settlement date settlement : `DateTime` maturity : `DateTime` frequency : `Frequency` basis : `DayCountBasis` Returns: `DateTime`
`Financial.CoupNum(settlement, maturity, frequency, basis)` Full Usage: `Financial.CoupNum(settlement, maturity, frequency, basis)` Parameters: settlement : `DateTime` maturity : `DateTime` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`	COUPNUM function The number of coupons payable between the settlement date and maturity date settlement : `DateTime` maturity : `DateTime` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`
`Financial.CoupPCD(settlement, maturity, frequency, basis)` Full Usage: `Financial.CoupPCD(settlement, maturity, frequency, basis)` Parameters: settlement : `DateTime` maturity : `DateTime` frequency : `Frequency` basis : `DayCountBasis` Returns: `DateTime`	COUPCD function The previous coupon date before the settlement date settlement : `DateTime` maturity : `DateTime` frequency : `Frequency` basis : `DayCountBasis` Returns: `DateTime`
`Financial.CumIPmt(rate, nper, pv, startPeriod, endPeriod, typ)` Full Usage: `Financial.CumIPmt(rate, nper, pv, startPeriod, endPeriod, typ)` Parameters: rate : `float` nper : `float` pv : `float` startPeriod : `float` endPeriod : `float` typ : `PaymentDue` Returns: `float`	CUMIPMT function The cumulative interest paid between two periods rate : `float` nper : `float` pv : `float` startPeriod : `float` endPeriod : `float` typ : `PaymentDue` Returns: `float`
`Financial.CumPrinc(rate, nper, pv, startPeriod, endPeriod, typ)` Full Usage: `Financial.CumPrinc(rate, nper, pv, startPeriod, endPeriod, typ)` Parameters: rate : `float` nper : `float` pv : `float` startPeriod : `float` endPeriod : `float` typ : `PaymentDue` Returns: `float`	CUMPRINC function The cumulative principal paid on a loan between two periods rate : `float` nper : `float` pv : `float` startPeriod : `float` endPeriod : `float` typ : `PaymentDue` Returns: `float`
`Financial.Db(cost, salvage, life, period)` Full Usage: `Financial.Db(cost, salvage, life, period)` Parameters: cost : `float` salvage : `float` life : `float` period : `float` Returns: `float`	DB function The depreciation of an asset for a specified period by using the fixed-declining balance method cost : `float` salvage : `float` life : `float` period : `float` Returns: `float`
`Financial.Db(cost, salvage, life, period, month)` Full Usage: `Financial.Db(cost, salvage, life, period, month)` Parameters: cost : `float` salvage : `float` life : `float` period : `float` month : `float` Returns: `float`	DB function The depreciation of an asset for a specified period by using the fixed-declining balance method cost : `float` salvage : `float` life : `float` period : `float` month : `float` Returns: `float`
`Financial.Ddb(cost, salvage, life, period)` Full Usage: `Financial.Ddb(cost, salvage, life, period)` Parameters: cost : `float` salvage : `float` life : `float` period : `float` Returns: `float`	DDB function The depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify cost : `float` salvage : `float` life : `float` period : `float` Returns: `float`
`Financial.Ddb(cost, salvage, life, period, factor)` Full Usage: `Financial.Ddb(cost, salvage, life, period, factor)` Parameters: cost : `float` salvage : `float` life : `float` period : `float` factor : `float` Returns: `float`	DDB function The depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify Excel Ddb has two interesting characteristics: 1. It special cases ddb for fractional periods between 0 and 1 by considering them to be 1 2. It is inconsistent with VDB(..., True) for fractional periods, even if VDB(..., True) is defined to be the same as ddb. The algorithm for VDB is theoretically correct. This function makes the same 1. adjustment. cost : `float` salvage : `float` life : `float` period : `float` factor : `float` Returns: `float`
`Financial.Disc(settlement, maturity, pr, redemption, basis)` Full Usage: `Financial.Disc(settlement, maturity, pr, redemption, basis)` Parameters: settlement : `DateTime` maturity : `DateTime` pr : `float` redemption : `float` basis : `DayCountBasis` Returns: `float`	DISC function The discount rate for a security settlement : `DateTime` maturity : `DateTime` pr : `float` redemption : `float` basis : `DayCountBasis` Returns: `float`
`Financial.DollarDe(fractionalDollar, fraction)` Full Usage: `Financial.DollarDe(fractionalDollar, fraction)` Parameters: fractionalDollar : `float` fraction : `float` Returns: `float`	DOLLARDE function Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number fractionalDollar : `float` fraction : `float` Returns: `float`
`Financial.DollarFr(decimalDollar, fraction)` Full Usage: `Financial.DollarFr(decimalDollar, fraction)` Parameters: decimalDollar : `float` fraction : `float` Returns: `float`	DOLLARFR function Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction decimalDollar : `float` fraction : `float` Returns: `float`
`Financial.Duration(settlement, maturity, coupon, yld, frequency, basis)` Full Usage: `Financial.Duration(settlement, maturity, coupon, yld, frequency, basis)` Parameters: settlement : `DateTime` maturity : `DateTime` coupon : `float` yld : `float` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`	DURATION function The annual duration of a security with periodic interest payments settlement : `DateTime` maturity : `DateTime` coupon : `float` yld : `float` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`
`Financial.Effect(nominalRate, npery)` Full Usage: `Financial.Effect(nominalRate, npery)` Parameters: nominalRate : `float` npery : `float` Returns: `float`	EFFECT function The effective annual interest rate nominalRate : `float` npery : `float` Returns: `float`
`Financial.Fv(rate, nper, pmt, pv, typ)` Full Usage: `Financial.Fv(rate, nper, pmt, pv, typ)` Parameters: rate : `float` nper : `float` pmt : `float` pv : `float` typ : `PaymentDue` Returns: `float`	FV function The future value of an investment rate : `float` nper : `float` pmt : `float` pv : `float` typ : `PaymentDue` Returns: `float`
`Financial.FvSchedule(principal, schedule)` Full Usage: `Financial.FvSchedule(principal, schedule)` Parameters: principal : `float` schedule : `seq<float>` Returns: `float`	FVSCHEDULE function The future value of an initial principal after applying a series of compound interest rates principal : `float` schedule : `seq<float>` Returns: `float`
`Financial.IPmt(rate, per, nper, pv, fv, typ)` Full Usage: `Financial.IPmt(rate, per, nper, pv, fv, typ)` Parameters: rate : `float` per : `float` nper : `float` pv : `float` fv : `float` typ : `PaymentDue` Returns: `float`	IPMT function The interest payment for an investment for a given period rate : `float` per : `float` nper : `float` pv : `float` fv : `float` typ : `PaymentDue` Returns: `float`
`Financial.ISPmt(rate, per, nper, pv)` Full Usage: `Financial.ISPmt(rate, per, nper, pv)` Parameters: rate : `float` per : `float` nper : `float` pv : `float` Returns: `float`	ISPMT function Calculates the interest paid during a specific period of an investment rate : `float` per : `float` nper : `float` pv : `float` Returns: `float`
`Financial.IntRate(settlement, maturity, investment, redemption, basis)` Full Usage: `Financial.IntRate(settlement, maturity, investment, redemption, basis)` Parameters: settlement : `DateTime` maturity : `DateTime` investment : `float` redemption : `float` basis : `DayCountBasis` Returns: `float`	INTRATE function The interest rate for a fully invested security settlement : `DateTime` maturity : `DateTime` investment : `float` redemption : `float` basis : `DayCountBasis` Returns: `float`
`Financial.Irr(values)` Full Usage: `Financial.Irr(values)` Parameters: values : `seq<float>` Returns: `float`	IRR function The internal rate of return for a series of cash flows values : `seq<float>` Returns: `float`
`Financial.Irr(values, guess)` Full Usage: `Financial.Irr(values, guess)` Parameters: values : `seq<float>` guess : `float` Returns: `float`	IRR function The internal rate of return for a series of cash flows values : `seq<float>` guess : `float` Returns: `float`
`Financial.MDuration(settlement, maturity, coupon, yld, frequency, basis)` Full Usage: `Financial.MDuration(settlement, maturity, coupon, yld, frequency, basis)` Parameters: settlement : `DateTime` maturity : `DateTime` coupon : `float` yld : `float` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`	MDURATION function The Macauley modified duration for a security with an assumed par value of $100 settlement : `DateTime` maturity : `DateTime` coupon : `float` yld : `float` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`
`Financial.Mirr(values, financeRate, reinvestRate)` Full Usage: `Financial.Mirr(values, financeRate, reinvestRate)` Parameters: values : `seq<float>` financeRate : `float` reinvestRate : `float` Returns: `float`	MIRR function The internal rate of return where positive and negative cash flows are financed at different rates values : `seq<float>` financeRate : `float` reinvestRate : `float` Returns: `float`
`Financial.NPer(rate, pmt, pv, fv, typ)` Full Usage: `Financial.NPer(rate, pmt, pv, fv, typ)` Parameters: rate : `float` pmt : `float` pv : `float` fv : `float` typ : `PaymentDue` Returns: `float`	NPER function The number of periods for an investment rate : `float` pmt : `float` pv : `float` fv : `float` typ : `PaymentDue` Returns: `float`
`Financial.Nominal(effectRate, npery)` Full Usage: `Financial.Nominal(effectRate, npery)` Parameters: effectRate : `float` npery : `float` Returns: `float`	NOMINAL function The annual nominal interest rate effectRate : `float` npery : `float` Returns: `float`
`Financial.Npv(rate, values)` Full Usage: `Financial.Npv(rate, values)` Parameters: rate : `float` values : `seq<float>` Returns: `float`	NPV function The net present value of an investment based on a series of periodic cash flows and a discount rate rate : `float` values : `seq<float>` Returns: `float`
`Financial.OddFPrice(settlement, maturity, issue, firstCoupon, rate, yld, redemption, frequency, basis)` Full Usage: `Financial.OddFPrice(settlement, maturity, issue, firstCoupon, rate, yld, redemption, frequency, basis)` Parameters: settlement : `DateTime` maturity : `DateTime` issue : `DateTime` firstCoupon : `DateTime` rate : `float` yld : `float` redemption : `float` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`	ODDFPRICE function The price per $100 face value of a security with an odd first period settlement : `DateTime` maturity : `DateTime` issue : `DateTime` firstCoupon : `DateTime` rate : `float` yld : `float` redemption : `float` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`
`Financial.OddFYield(settlement, maturity, issue, firstCoupon, rate, pr, redemption, frequency, basis)` Full Usage: `Financial.OddFYield(settlement, maturity, issue, firstCoupon, rate, pr, redemption, frequency, basis)` Parameters: settlement : `DateTime` maturity : `DateTime` issue : `DateTime` firstCoupon : `DateTime` rate : `float` pr : `float` redemption : `float` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`	ODDFYIELD function The yield of a security with an odd first period settlement : `DateTime` maturity : `DateTime` issue : `DateTime` firstCoupon : `DateTime` rate : `float` pr : `float` redemption : `float` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`
`Financial.OddLPrice(settlement, maturity, lastInterest, rate, yld, redemption, frequency, basis)` Full Usage: `Financial.OddLPrice(settlement, maturity, lastInterest, rate, yld, redemption, frequency, basis)` Parameters: settlement : `DateTime` maturity : `DateTime` lastInterest : `DateTime` rate : `float` yld : `float` redemption : `float` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`	ODDLPRICE function The price per $100 face value of a security with an odd last period settlement : `DateTime` maturity : `DateTime` lastInterest : `DateTime` rate : `float` yld : `float` redemption : `float` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`
`Financial.OddLYield(settlement, maturity, lastInterest, rate, pr, redemption, frequency, basis)` Full Usage: `Financial.OddLYield(settlement, maturity, lastInterest, rate, pr, redemption, frequency, basis)` Parameters: settlement : `DateTime` maturity : `DateTime` lastInterest : `DateTime` rate : `float` pr : `float` redemption : `float` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`	ODDLYIELD function The yield of a security with an odd last period settlement : `DateTime` maturity : `DateTime` lastInterest : `DateTime` rate : `float` pr : `float` redemption : `float` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`
`Financial.PPmt(rate, per, nper, pv, fv, typ)` Full Usage: `Financial.PPmt(rate, per, nper, pv, fv, typ)` Parameters: rate : `float` per : `float` nper : `float` pv : `float` fv : `float` typ : `PaymentDue` Returns: `float`	PPMT function The payment on the principal for an investment for a given period rate : `float` per : `float` nper : `float` pv : `float` fv : `float` typ : `PaymentDue` Returns: `float`
`Financial.Pduration(rate, pv, fv)` Full Usage: `Financial.Pduration(rate, pv, fv)` Parameters: rate : `float` pv : `float` fv : `float` Returns: `float`	PDURATION function Returns the number of periods required by an investment to reach a specified value. rate : `float` pv : `float` fv : `float` Returns: `float`
`Financial.Pmt(rate, nper, pv, fv, typ)` Full Usage: `Financial.Pmt(rate, nper, pv, fv, typ)` Parameters: rate : `float` nper : `float` pv : `float` fv : `float` typ : `PaymentDue` Returns: `float`	PMT function The periodic payment for an annuity rate : `float` nper : `float` pv : `float` fv : `float` typ : `PaymentDue` Returns: `float`
`Financial.Price(settlement, maturity, rate, yld, redemption, frequency, basis)` Full Usage: `Financial.Price(settlement, maturity, rate, yld, redemption, frequency, basis)` Parameters: settlement : `DateTime` maturity : `DateTime` rate : `float` yld : `float` redemption : `float` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`	PRICE function The price per $100 face value of a security that pays periodic interest settlement : `DateTime` maturity : `DateTime` rate : `float` yld : `float` redemption : `float` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`
`Financial.PriceAllowNegativeYield(settlement, maturity, rate, yld, redemption, frequency, basis)` Full Usage: `Financial.PriceAllowNegativeYield(settlement, maturity, rate, yld, redemption, frequency, basis)` Parameters: settlement : `DateTime` maturity : `DateTime` rate : `float` yld : `float` redemption : `float` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`	The price per $100 face value of a security that pays periodic interest This is the same calculation as "Price", but allows a negative yield. Excel does not allow negative yield, so this is an addition to the Excel- compatible UI settlement : `DateTime` maturity : `DateTime` rate : `float` yld : `float` redemption : `float` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`
`Financial.PriceDisc(settlement, maturity, discount, redemption, basis)` Full Usage: `Financial.PriceDisc(settlement, maturity, discount, redemption, basis)` Parameters: settlement : `DateTime` maturity : `DateTime` discount : `float` redemption : `float` basis : `DayCountBasis` Returns: `float`	PRICEDISC function The price per $100 face value of a discounted security settlement : `DateTime` maturity : `DateTime` discount : `float` redemption : `float` basis : `DayCountBasis` Returns: `float`
`Financial.PriceMat(settlement, maturity, issue, rate, yld, basis)` Full Usage: `Financial.PriceMat(settlement, maturity, issue, rate, yld, basis)` Parameters: settlement : `DateTime` maturity : `DateTime` issue : `DateTime` rate : `float` yld : `float` basis : `DayCountBasis` Returns: `float`	PRICEMAT function The price per $100 face value of a security that pays interest at maturity settlement : `DateTime` maturity : `DateTime` issue : `DateTime` rate : `float` yld : `float` basis : `DayCountBasis` Returns: `float`
`Financial.Pv(rate, nper, pmt, fv, typ)` Full Usage: `Financial.Pv(rate, nper, pmt, fv, typ)` Parameters: rate : `float` nper : `float` pmt : `float` fv : `float` typ : `PaymentDue` Returns: `float`	PV function The present value of an investment rate : `float` nper : `float` pmt : `float` fv : `float` typ : `PaymentDue` Returns: `float`
`Financial.Rate(nper, pmt, pv, fv, typ)` Full Usage: `Financial.Rate(nper, pmt, pv, fv, typ)` Parameters: nper : `float` pmt : `float` pv : `float` fv : `float` typ : `PaymentDue` Returns: `float`	RATE function The interest rate per period of an annuity nper : `float` pmt : `float` pv : `float` fv : `float` typ : `PaymentDue` Returns: `float`
`Financial.Rate(nper, pmt, pv, fv, typ, guess)` Full Usage: `Financial.Rate(nper, pmt, pv, fv, typ, guess)` Parameters: nper : `float` pmt : `float` pv : `float` fv : `float` typ : `PaymentDue` guess : `float` Returns: `float`	RATE function The interest rate per period of an annuity nper : `float` pmt : `float` pv : `float` fv : `float` typ : `PaymentDue` guess : `float` Returns: `float`
`Financial.Received(settlement, maturity, investment, discount, basis)` Full Usage: `Financial.Received(settlement, maturity, investment, discount, basis)` Parameters: settlement : `DateTime` maturity : `DateTime` investment : `float` discount : `float` basis : `DayCountBasis` Returns: `float`	RECEIVED function The amount received at maturity for a fully invested security settlement : `DateTime` maturity : `DateTime` investment : `float` discount : `float` basis : `DayCountBasis` Returns: `float`
`Financial.Rri(nper, pv, fv)` Full Usage: `Financial.Rri(nper, pv, fv)` Parameters: nper : `float` pv : `float` fv : `float` Returns: `float`	RRI function Returns an equivalent interest rate for the growth of an investment nper : `float` pv : `float` fv : `float` Returns: `float`
`Financial.Sln(cost, salvage, life)` Full Usage: `Financial.Sln(cost, salvage, life)` Parameters: cost : `float` salvage : `float` life : `float` Returns: `float`	SLN function The straight-line depreciation of an asset for one period cost : `float` salvage : `float` life : `float` Returns: `float`
`Financial.Syd(cost, salvage, life, per)` Full Usage: `Financial.Syd(cost, salvage, life, per)` Parameters: cost : `float` salvage : `float` life : `float` per : `float` Returns: `float`	SYD function The sum-of-years' digits depreciation of an asset for a specified period cost : `float` salvage : `float` life : `float` per : `float` Returns: `float`
`Financial.TBillEq(settlement, maturity, discount)` Full Usage: `Financial.TBillEq(settlement, maturity, discount)` Parameters: settlement : `DateTime` maturity : `DateTime` discount : `float` Returns: `float`	TBILLEQ function The bond-equivalent yield for a Treasury bill settlement : `DateTime` maturity : `DateTime` discount : `float` Returns: `float`
`Financial.TBillPrice(settlement, maturity, discount)` Full Usage: `Financial.TBillPrice(settlement, maturity, discount)` Parameters: settlement : `DateTime` maturity : `DateTime` discount : `float` Returns: `float`	TBILLPRICE function The price per $100 face value for a Treasury bill settlement : `DateTime` maturity : `DateTime` discount : `float` Returns: `float`
`Financial.TBillYield(settlement, maturity, pr)` Full Usage: `Financial.TBillYield(settlement, maturity, pr)` Parameters: settlement : `DateTime` maturity : `DateTime` pr : `float` Returns: `float`	TBILLYIELD function The yield for a Treasury bill settlement : `DateTime` maturity : `DateTime` pr : `float` Returns: `float`
`Financial.Vdb(cost, salvage, life, startPeriod, endPeriod)` Full Usage: `Financial.Vdb(cost, salvage, life, startPeriod, endPeriod)` Parameters: cost : `float` salvage : `float` life : `float` startPeriod : `float` endPeriod : `float` Returns: `float`	VDB function The depreciation of an asset for a specified or partial period by using a declining balance method cost : `float` salvage : `float` life : `float` startPeriod : `float` endPeriod : `float` Returns: `float`
`Financial.Vdb(cost, salvage, life, startPeriod, endPeriod, factor)` Full Usage: `Financial.Vdb(cost, salvage, life, startPeriod, endPeriod, factor)` Parameters: cost : `float` salvage : `float` life : `float` startPeriod : `float` endPeriod : `float` factor : `float` Returns: `float`	VDB function The depreciation of an asset for a specified or partial period by using a declining balance method cost : `float` salvage : `float` life : `float` startPeriod : `float` endPeriod : `float` factor : `float` Returns: `float`
`Financial.Vdb(cost, salvage, life, startPeriod, endPeriod, factor, noSwitch)` Full Usage: `Financial.Vdb(cost, salvage, life, startPeriod, endPeriod, factor, noSwitch)` Parameters: cost : `float` salvage : `float` life : `float` startPeriod : `float` endPeriod : `float` factor : `float` noSwitch : `VdbSwitch` Returns: `float`	VDB function The depreciation of an asset for a specified or partial period by using a declining balance method. In the excel version of this algorithm the depreciation in the period (0,1) is not the same as the sum of the depreciations in periods (0,0.5) (0.5,1) `VDB(100,10,13,0,0.5,1,0) + VDB(100,10,13,0.5,1,1,0) != VDB(100,10,13,0,1,1,0)` Notice that in Excel by using '1' (no_switch) instead of '0' as the last parameter everything works as expected. In truth, the last parameter should have no influence in the calculation given that in the first period there is no switch to sln depreciation. Overall, I think my algorithm is correct, even if it disagrees with Excel when startperiod is fractional. cost : `float` salvage : `float` life : `float` startPeriod : `float` endPeriod : `float` factor : `float` noSwitch : `VdbSwitch` Returns: `float`
`Financial.XIrr(values, dates)` Full Usage: `Financial.XIrr(values, dates)` Parameters: values : `seq<float>` dates : `seq<DateTime>` Returns: `float`	XIRR function The internal rate of return for a schedule of cash flows that is not necessarily periodic values : `seq<float>` dates : `seq<DateTime>` Returns: `float`
`Financial.XIrr(values, dates, guess)` Full Usage: `Financial.XIrr(values, dates, guess)` Parameters: values : `seq<float>` dates : `seq<DateTime>` guess : `float` Returns: `float`	XIRR function The internal rate of return for a schedule of cash flows that is not necessarily periodic values : `seq<float>` dates : `seq<DateTime>` guess : `float` Returns: `float`
`Financial.XNpv(rate, values, dates)` Full Usage: `Financial.XNpv(rate, values, dates)` Parameters: rate : `float` values : `seq<float>` dates : `seq<DateTime>` Returns: `float`	XNPV function The net present value for a schedule of cash flows that is not necessarily periodic rate : `float` values : `seq<float>` dates : `seq<DateTime>` Returns: `float`
`Financial.YearFrac(startDate, endDate, basis)` Full Usage: `Financial.YearFrac(startDate, endDate, basis)` Parameters: startDate : `DateTime` endDate : `DateTime` basis : `DayCountBasis` Returns: `float`	YEARFRAC function Calculates the fraction of the year represented by the number of whole days between two dates - not a financial function startDate : `DateTime` endDate : `DateTime` basis : `DayCountBasis` Returns: `float`
`Financial.Yield(settlement, maturity, rate, pr, redemption, frequency, basis)` Full Usage: `Financial.Yield(settlement, maturity, rate, pr, redemption, frequency, basis)` Parameters: settlement : `DateTime` maturity : `DateTime` rate : `float` pr : `float` redemption : `float` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`	YIELD function The yield on a security that pays periodic interest settlement : `DateTime` maturity : `DateTime` rate : `float` pr : `float` redemption : `float` frequency : `Frequency` basis : `DayCountBasis` Returns: `float`
`Financial.YieldDisc(settlement, maturity, pr, redemption, basis)` Full Usage: `Financial.YieldDisc(settlement, maturity, pr, redemption, basis)` Parameters: settlement : `DateTime` maturity : `DateTime` pr : `float` redemption : `float` basis : `DayCountBasis` Returns: `float`	YIELDDISC function The annual yield for a discounted security; for example, a Treasury bill settlement : `DateTime` maturity : `DateTime` pr : `float` redemption : `float` basis : `DayCountBasis` Returns: `float`
`Financial.YieldMat(settlement, maturity, issue, rate, pr, basis)` Full Usage: `Financial.YieldMat(settlement, maturity, issue, rate, pr, basis)` Parameters: settlement : `DateTime` maturity : `DateTime` issue : `DateTime` rate : `float` pr : `float` basis : `DayCountBasis` Returns: `float`	YIELDMAT function The annual yield of a security that pays interest at maturity settlement : `DateTime` maturity : `DateTime` issue : `DateTime` rate : `float` pr : `float` basis : `DayCountBasis` Returns: `float`