Финансовые functions
[ ] indicates optional parameters
TTBILLEQ(settlement_date, maturity_date, discount)TTBILLEQ(settlement_date, maturity_date, discount)
Returns the bond-equivalent yield for a treasury bill.
| settlement_date | The settlement date. |
| maturity_date | The maturity date. |
| discount | The discount rate. |
АМГД(стоимость, ликвидная_стоимость, жизнь, период)
Returns the sum of years depreciation.
| стоимость | The cost. |
| ликвидная_стоимость | The salvage value. |
| жизнь | The total number of periods. |
| период | The period for which you want the depreciation. |
АМОРУВ(cost, purchase_date, first_period_date, salvage, period, rate, [basis])
Returns the depreciation for each accounting period.
| cost | The cost. | ||||||||||
| purchase_date | The purchase date. | ||||||||||
| first_period_date | The end date of the first period. | ||||||||||
| salvage | The salvage value. | ||||||||||
| period | The period for which you want to calculate the depreciation. | ||||||||||
| rate | The depreciation rate. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
АМОРУМ(cost, purchase_date, first_period_date, salvage, period, rate, [basis])
Returns the depreciation for each accounting period.
| cost | The cost. | ||||||||||
| purchase_date | The purchase date. | ||||||||||
| first_period_date | The end date of the first period. | ||||||||||
| salvage | The salvage value. | ||||||||||
| period | The period for which you want to calculate the depreciation. | ||||||||||
| rate | The depreciation rate. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
АМР(стоимость, ликвидная_стоимость, время_амортизации)
Returns the straight line depreciation.
| стоимость | The cost. |
| ликвидная_стоимость | The salvage value. |
| время_амортизации | The total number of periods. |
БЗ(норма, число_периодов, выплата, [нз], [тип])
Returns the future value of an investment at a fixed rate.
| норма | The interest rate per period. | ||||
| число_периодов | The total number of periods. | ||||
| выплата | The payment amount each period. | ||||
| нз | The present value. If this parameter is omitted it is assumed to be zero. | ||||
| тип | The timing of the payment. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 0. |
БЗРАСПИС(principal, schedule_range)
Returns the future value of an investment at a variable rate.
| principal | The initial value of the investment. |
| schedule_range | The list (array or reference) of interest rates to be applied. |
ВНДОХ(значения, [предположение])
Returns the internal rate of return.
| значения | The list (array or reference) of payment and income values. |
| предположение | The estimated rate of return. If this parameter is omitted it defaults to 0.1. |
ДАТАКУПОНДО(settlement_date, maturity_date, frequency, [basis])
Returns the coupon date before the settlement date.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ДАТАКУПОНПОСЛЕ(settlement_date, maturity_date, frequency, [basis])
Returns the next coupon date after the settlement date.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ДДОБ(стоимость, остаточная_стоимость, время_эксплуатации, период, [коэффициент])
Returns the depreciation in a specified period using the double declining balance method.
| стоимость | The cost. |
| остаточная_стоимость | The salvage value. |
| время_эксплуатации | The total number of periods. |
| период | The period number for which to calculate depreciation. |
| коэффициент | The rate at which the balance declines. If this parameter is omitted it defaults to 2. |
ДЛИТ(settlement_date, maturity_date, coupon, yield, frequency, [basis])
Returns the Macauley duration for a value of $100.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| coupon | The interest rate. | ||||||||||
| yield | The annual yield rate. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ДНЕЙКУПОН(settlement_date, maturity_date, frequency, [basis])
Returns the number of days in the coupon period that contains the settlement date.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ДНЕЙКУПОНДО(settlement_date, maturity_date, frequency, [basis])
Returns the number of days from the beginning of the coupon period to the settlement date.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ДНЕЙКУПОНПОСЛЕ(settlement_date, maturity_date, frequency, [basis])
Returns the number of days from the settlement date to the next coupon date.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ДОБ(стоимость, остаточная_стоимость, время_эксплуатации, период, [месяц])
Returns the depreciation in a specified period using the fixed declining balance method.
| стоимость | The cost. |
| остаточная_стоимость | The salvage value. |
| время_эксплуатации | The total number of periods. |
| период | The period number for which to calculate depreciation. |
| месяц | The number of months in the first year. If this parameter is omitted it defaults to 12. |
ДОХОД(settlement_date, maturity_date, rate, price, redemption, frequency, [basis])
Returns the yield on a security.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| rate | The annual coupon rate. | ||||||||||
| price | The price per $100. | ||||||||||
| redemption | The redemption value per $100. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ДОХОДКЧЕК(settlement_date, maturity_date, price)
Returns the yield for a treasury bill.
| settlement_date | The settlement date. |
| maturity_date | The maturity date. |
| price | The price per $100. |
ДОХОДПЕРВНЕРЕГ(settlement_date, maturity_date, issue_date, first_coupon_date, rate, price, redemption, frequency, [basis])
Returns the yield of a security having an odd (short or long) first period.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| issue_date | The issue date. | ||||||||||
| first_coupon_date | The first coupon date. | ||||||||||
| rate | The annual coupon rate. | ||||||||||
| price | The price per $100. | ||||||||||
| redemption | The redemption value per $100. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ДОХОДПОГАШ(settlement_date, maturity_date, issue_date, rate, price, [basis])
Returns the annual yield of a security that pays interest at maturity.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| issue_date | The issue date. | ||||||||||
| rate | The interest rate. | ||||||||||
| price | The price per $100. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ДОХОДПОСЛНЕРЕГ(settlement_date, maturity_date, last_coupon_date, rate, price, redemption, frequency, [basis])
Returns the yield of a security having an odd (short or long) last period.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| last_coupon_date | The last coupon date. | ||||||||||
| rate | The annual coupon rate. | ||||||||||
| price | The price per $100. | ||||||||||
| redemption | The redemption value per $100. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ДОХОДСКИДКА(settlement_date, maturity_date, price, redemption, [basis])
Returns the annual yield for a discounted security.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| price | The price per $100. | ||||||||||
| redemption | The redemption value per $100. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ИНОРМА(settlement_date, maturity_date, investment_amount, redemption_amount, [basis])
Returns the interest rate for a fully invested security.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| investment_amount | The initial value. | ||||||||||
| redemption_amount | The final value. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
КПЕР(норма, выплата, нз, [бс], [тип])
Returns the number of periods required for an investment.
| норма | The interest rate per period. | ||||
| выплата | The payment amount per period. | ||||
| нз | The present value. | ||||
| бс | The future value. If this parameter is omitted it defaults to 0. | ||||
| тип | The timing of the payment. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 0. |
МВСД(значения, финансовая_норма, реинвест_норма)
Returns the modified internal rate of return.
| значения | The list (array or reference) of payment and income values. |
| финансовая_норма | The interest rate on the payment values. |
| реинвест_норма | The interest rate on the income values. |
МДЛИТ(settlement_date, maturity_date, coupon, yield, frequency, [basis])
Returns the modified Macauley duration for a value of $100.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| coupon | The interest rate. | ||||||||||
| yield | The annual yield rate. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
НАКОПДОХОД(issue_date, first_interest_date, settlement_date, rate, par, frequency, [basis])
Returns accrued interest for a security that pays periodic interest.
| issue_date | The issue date. | ||||||||||
| first_interest_date | The first interest date. | ||||||||||
| settlement_date | The settlement date. | ||||||||||
| rate | The annual coupon rate. | ||||||||||
| par | The par value. | ||||||||||
| frequency | The number of interest payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
НАКОПДОХОДПОГАШ(issue_date, maturity_date, rate, [par], [basis])
Returns accrued interest for a security that pays interest at maturity.
| issue_date | The issue date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| rate | The annual coupon rate. | ||||||||||
| par | The par value. If this parameter is omitted it defaults to 1000. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
Returns the nominal annual interest rate.
| effect_rate | The effective annual interest rate. |
| npery | The number of compound interest payments per year. |
НОРМА(кпер, выплата, нз, [бс], [тип], [предположение])
Returns the interest rate per period of an annuity.
| кпер | The total number of periods. | ||||
| выплата | The payment amount each period. | ||||
| нз | The present value. | ||||
| бс | The future value. If this parameter is omitted it is assumed to be zero. | ||||
| тип | The timing of the payment. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 0. | |||||
| предположение | The estimated rate of return. If this parameter is omitted it defaults to 0.1. |
НПЗ(норма, значение1, [значение2, ...])
Returns the net present value of an investment.
| норма | The discount rate per period. |
| значение1, ... | The payment and income amounts. |
ОБЩДОХОД(норма, кпер, нз, нач_период, кон_период, тип)
Returns the cumulative principal paid on a loan in the specified periods.
| норма | The interest rate. | ||||
| кпер | The total number of periods. | ||||
| нз | The present value. | ||||
| нач_период | The first period number for which to calculate interest. | ||||
| кон_период | The last period number for which to calculate interest. | ||||
| тип | The timing of the payment. The possible values are: | ||||
|
ОБЩПЛАТ(норма, кпер, нз, нач_период, кон_период, тип)
Returns the cumulative interest paid on a loan in the specified periods.
| норма | The interest rate. | ||||
| кпер | The total number of periods. | ||||
| нз | The present value. | ||||
| нач_период | The first period number for which to calculate interest. | ||||
| кон_период | The last period number for which to calculate interest. | ||||
| тип | The timing of the payment. The possible values are: | ||||
|
ОСНПЛАТ(норма, период, кпер, тс, [бс], [тип])
Returns the payment on the principal for a specified period.
| норма | The interest rate per period. | ||||
| период | The period for which you want the payment amount. | ||||
| кпер | The total number of periods. | ||||
| тс | The present value of the loan. | ||||
| бс | The future value of the loan. If this parameter is omitted it defaults to 0. | ||||
| тип | The timing of the payment. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 0. |
ПДОБ(ликв_стоимость, ост_стоим, время_полн_аморт, нач_период, кон_период, [коэффициент], [без_переключений])
Returns the depreciation in a specified range of periods using the variable declining balance method.
| ликв_стоимость | The cost. | ||||
| ост_стоим | The salvage value. | ||||
| время_полн_аморт | The total number of periods. | ||||
| нач_период | The first period number for which to calculate depreciation. | ||||
| кон_период | The last period number for which to calculate depreciation. | ||||
| коэффициент | The rate at which the balance declines. If this parameter is omitted it defaults to 2. | ||||
| без_переключений | Specifies whether to switch to straight-line depreciation when the straight-line depreciation is greater than the declining balance depreciation. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to ЛОЖЬ. |
ПЗ(норма, кпер, выплата, [бс], [тип])
Returns the present value of an investment at a fixed rate.
| норма | The interest rate per period. | ||||
| кпер | The total number of periods. | ||||
| выплата | The payment amount each period. | ||||
| бс | The future value. If this parameter is omitted it is assumed to be zero. | ||||
| тип | The timing of the payment. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 0. |
ПЛПРОЦ(норма, период, кпер, тс, [бс], [тип])
Returns the interest payment for a given period.
| норма | The interest rate per period. | ||||
| период | The period for which you want the interest amount. | ||||
| кпер | The total number of periods. | ||||
| тс | The present value. | ||||
| бс | The future value. If this parameter is omitted it is assumed to be zero. | ||||
| тип | The timing of the payment. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 0. |
ПОЛУЧЕНО(settlement_date, maturity_date, investment, discount, [basis])
Returns the amount received at maturity for a fully invested security.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| investment | The investment amount. | ||||||||||
| discount | The discount rate. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ППЛАТ(норма, кпер, [нз], [бс], [тип])
Returns the payment amount for a loan.
| норма | The interest rate per period. | ||||
| кпер | The total number of periods. | ||||
| нз | The present value of the loan. If this parameter is omitted it defaults to 0. | ||||
| бс | The future value of the loan. If this parameter is omitted it defaults to 0. | ||||
| тип | The timing of the payment. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 0. |
ПРОЦПЛАТ(норма, период, кпер, тс)
Returns the interest payment for a given period.
| норма | The interest rate per period. |
| период | The period for which you want the interest amount. |
| кпер | The total number of periods. |
| тс | The present value. |
РУБЛЬ.ДЕС(fractional_dollar, fraction)
Returns the decimal equivalent of a dollar price expressed as a fraction.
| fractional_dollar | The value expressed as a fraction. |
| fraction | The fraction denominator. |
РУБЛЬ.ДРОБЬ(decimal_dollar, fraction)
Returns the fraction equivalent of a dollar price expressed as a decimal.
| decimal_dollar | The value expressed as a decimal. |
| fraction | The fraction denominator. |
СКИДКА(settlement_date, maturity_date, pr, redemption, [basis])
Returns the discount rate for a security.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| pr | The price per $100 value. | ||||||||||
| redemption | The redemption per $100 value. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ЦЕНА(settlement_date, maturity_date, rate, yield, redemption, frequency, [basis])
Returns the price per $100 of a security.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| rate | The annual coupon rate. | ||||||||||
| yield | The annual yield rate. | ||||||||||
| redemption | The redemption value per $100. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ЦЕНАКЧЕК(settlement_date, maturity_date, discount)
Returns the price per $100 for a treasury bill.
| settlement_date | The settlement date. |
| maturity_date | The maturity date. |
| discount | The discount rate. |
ЦЕНАПЕРВНЕРЕГ(settlement_date, maturity_date, issue_date, first_coupon_date, rate, yield, redemption, frequency, [basis])
Returns the price per $100 face value of a security having an odd (short or long) first period.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| issue_date | The issue date. | ||||||||||
| first_coupon_date | The first coupon date. | ||||||||||
| rate | The annual coupon rate. | ||||||||||
| yield | The annual yield rate. | ||||||||||
| redemption | The redemption value per $100. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ЦЕНАПОГАШ(settlement_date, maturity_date, issue_date, rate, yield, [basis])
Returns the price per $100 of a security that pays interest at maturity.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| issue_date | The issue date. | ||||||||||
| rate | The interest rate. | ||||||||||
| yield | The annual yield rate. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ЦЕНАПОСЛНЕРЕГ(settlement_date, maturity_date, last_coupon_date, rate, yield, redemption, frequency, [basis])
Returns the price per $100 face value of a security having an odd (short or long) last period.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| last_coupon_date | The last coupon date. | ||||||||||
| rate | The annual coupon rate. | ||||||||||
| yield | The annual yield rate. | ||||||||||
| redemption | The redemption value per $100. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ЦЕНАСКИДКА(settlement_date, maturity_date, discount, redemption, [basis])
Returns the price per $100 of a discounted security.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| discount | The discount rate. | ||||||||||
| redemption | The redemption value per $100. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ЧИСЛКУПОН(settlement_date, maturity_date, frequency, [basis])
Returns the number of coupon periods between the settlement date and the maturity date.
| settlement_date | The settlement date. | ||||||||||
| maturity_date | The maturity date. | ||||||||||
| frequency | The number of coupon payments per year. Should be 1, 2 or 4. | ||||||||||
| basis | The method used to represent the number of days in the period versus the number of days in a year. The possible values are: | ||||||||||
| |||||||||||
| If this parameter is omitted it defaults to 0. |
ЧИСТВНДОХ(значения, dates_range, [предположение])
Returns the internal rate of return.
| значения | The list (array or reference) of payment and income values. |
| dates_range | The list (array or reference) of the dates of the payment and income values. |
| предположение | The estimated rate of return. If this parameter is omitted it defaults to 0.1. |
ЧИСТНЗ(норма, значения, dates_range)
Returns the net present value of an investment.
| норма | The discount rate per period. |
| значения | The list (array or reference) of payment and income values. |
| dates_range | The list (array or reference) of the dates of the payment and income values. |
Returns the effective annual interest rate.
| nominal_rate | The nominal annual interest rate. |
| npery | The number of compound interest payments per year. |