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: