Integer: MathFin;
The IFinance interface contains properties and methods that implement financial functions.
IFinance
Property name | Brief description | |
ErrorMsg | The ErrorMsg property returns the error information message. | |
Status | The Status property returns an error code. |
Method name | Brief description | |
Accrint | The Accrint method returns accumulated interest for securities with regular payment of interest. | |
AccrintM | The AccrintM method returns accumulated interest for the securities, for which the interest must be paid on settlement date. | |
AmorDegrC | The AmorDegrC method returns the size of depreciation for each period considering depreciation coefficient. | |
AmorLinC | The AmorLinC method returns the size of depreciation for each period. | |
CoupDayBs | The CoupDaybs method returns the number of days from the coupon start date until the agreement date. | |
CoupDays | The CoupDays method returns the number of days in the period of a coupon, which includes the settlement date. | |
CoupDaysNc | The CoupDaysNc method returns the number of days from the settlement date until the next coupon date. | |
CoupNcd | The CoupNcd method returns the date that is the next coupon date after the settlement date. | |
CoupNum | The CoupNum method returns the number of coupons, which can be paid from the settlement date and the maturity date, rounded to the nearest integer. | |
CoupPcd | The CoupPcd method returns the date corresponding to the previous coupon date before the settlement date. | |
CumIpmt | The CumImpt method returns cumulative sum of interest on loan paid between two settlement periods. | |
Cumprinc | The Cumprinc method returns cumulative sum paid in satisfaction of the original amount of the loan between two periods. | |
Db | The Db method returns depreciation of an asset for the specified period, calculated using the fixed reduction of the remainder method. | |
Ddb | The Ddb method returns the value of asset depreciation for this period. | |
Disc | The Disc method returns discount rate for securities. | |
DollarDe | The DollarDe method converts a ruble price expressed as a fraction into a ruble price expressed as a decimal number. | |
DollarFr | The DollarFr method is used to convert a ruble price expressed as a decimal number to a ruble price expressed as a fraction. | |
Duration | The Duration method returns Macaulay duration for supposed face value of $100. | |
Effect | The Effect method returns effective annual percentage rate. | |
Fv | The Fv method returns future value of the investment, at the condition of regular equal payments and constant interest rate. | |
FvSchedule | The FvSchedule method returns future value of the capital amount after applying a set of complex interest rates. | |
Intrate | The Intrate method returns the interest rate for fully invested securities. | |
Ipmt | The Ipmt method returns the sum of interest payments for the given period, if the sums of regular payments are equal and the interest rate is constant. | |
Irr | The Irr method returns internal rate of return for the set of cash flows, represented by their numeric values. | |
Ispmt | The Ispmt method returns interest, paid for the specified investment period. | |
MDuration | The Mduration method returns a modified Macaulay duration for securities with supposed face value of $100. | |
MIrr | The Mirr method returns modified internal rate or return for a set of periodic cash flows. | |
Nominal | The Nominal method returns annual nominal interest rate, if the effective rate and the number of periods in a year, for which compound interest is calculated, are specified. | |
NPer | The NPer method returns the number of periods of payment for investments based on periodic regular payments and constant interest rate. | |
Npv | The Npv method returns net present value of an investment, using a discount rate as well as the values of future payments (negative values) and inpayments (positive values). | |
OddfPrice | The OddfPrice method returns price for 100 rubles of face value of the securities for an irregular (short or long) first period. | |
OddfYield | The OddfYield method returns profit for securities with irregular (short or long) first period. | |
OddlPrice | The OddlPrice method returns the price for 100 rubles of the face value for an irregular (short or long) last coupon period. | |
OddlYield | The OddfYield method returns profit for securities with irregular (short or long) last period. | |
Pmt | The Pmt method returns a sum of regular annuity payments, if the payment sums are equal and the interest rate is constant. | |
Ppmt | The Ppmt method returns a sum of regular payments for the investment, if the payment sums are equal and the interest rate is constant. | |
Price | The Price method returns the price for $100 of securities face value, for which periodic interest is paid. | |
PriceDisc | The PriceDisc method returns the price for $100 of face value of securities, for which a discount is made. | |
PriceMat | The PriceMat method returns the price for $100 of principal value for securities, for which interest is paid on maturity. | |
Pv | The Pv method returns net present (at the current moment) value of investment. | |
Rate | The Rate method returns annual interest rate for one period. | |
Received | The Received method returns the sum, received by the maturity date of the fully secured securities. | |
RedemptionYield | The RedemptionYield method returns effective redemption yield. | |
Sln | The Sln method returns the depreciation of an asset for one period, calculated using a linear method. | |
Syd | The Syd method returns the size of the asset depreciation for this period, calculated using a "sum of annual numbers" method. | |
TBillEq | The TBillEq method returns yield for a treasury bill equal to a bond. | |
TBillPrice | The TBillPrice method returns price for $100 of principal value for a treasury bill. | |
TBillYield | The TBillYield method returns yield for a treasury bill. | |
Vdb | The Vdb method returns an asset's depreciation for any selected period, including partial periods, using the double remainder reduction method or another specified method. | |
XIrr | The XIrr method returns internal rate of return for the schedule of cash flows, which do not have to be regular. | |
Xnpv | The Xnpv method returns net present value for cash flows, which do not have to be regular. | |
YieldDisc | The YieldDisc method returns annual profit for discounted securities. | |
YieldF | The YieldF method returns yield for securities, for which interest is paid regularly. | |
YieldMat | The YieldMat method returns the annual yield of a security that pays interest at maturity. |
See also: