Finanzmathematik Funktionen
[ ] indicates optional parameters
AMORDEGRK(Kosten; Datum; Erste_Periode; Restwert; Periode; Rate; [Basis])AMORDEGRK(Kosten; Datum; Erste_Periode; Restwert; Periode; Rate; [Basis])
Returns the depreciation for each accounting period.
| Kosten | The cost. | ||||||||||
| Datum | The purchase date. | ||||||||||
| Erste_Periode | The end date of the first period. | ||||||||||
| Restwert | The salvage value. | ||||||||||
| Periode | 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. |
AMORLINEARK(Kosten; Datum; Erste_Periode; Restwert; Periode; Rate; [Basis])
Returns the depreciation for each accounting period.
| Kosten | The cost. | ||||||||||
| Datum | The purchase date. | ||||||||||
| Erste_Periode | The end date of the first period. | ||||||||||
| Restwert | The salvage value. | ||||||||||
| Periode | 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. |
AUFGELZINS(Emission; Erster_Zinstermin; Abrechnung; Nominalzins; Nennwert; Häufigkeit; [Basis])
Returns accrued interest for a security that pays periodic interest.
| Emission | The issue date. | ||||||||||
| Erster_Zinstermin | The first interest date. | ||||||||||
| Abrechnung | The settlement date. | ||||||||||
| Nominalzins | The annual coupon rate. | ||||||||||
| Nennwert | The par value. | ||||||||||
| Häufigkeit | 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. |
AUFGELZINSF(Emission; Abrechnung; Nominalzins; [Nennwert]; [Basis])
Returns accrued interest for a security that pays interest at maturity.
| Emission | The issue date. | ||||||||||
| Abrechnung | The maturity date. | ||||||||||
| Nominalzins | The annual coupon rate. | ||||||||||
| Nennwert | 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. |
AUSZAHLUNG(Abrechnung; Fälligkeit; Anlage; Disagio; [Basis])
Returns the amount received at maturity for a fully invested security.
| Abrechnung | The settlement date. | ||||||||||
| Fälligkeit | The maturity date. | ||||||||||
| Anlage | The investment amount. | ||||||||||
| Disagio | 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 present value of an investment at a fixed rate.
| Zins | The interest rate per period. | ||||
| Zzr | The total number of periods. | ||||
| Rmz | The payment amount each period. | ||||
| Zw | The future value. If this parameter is omitted it is assumed to be zero. | ||||
| F | The timing of the payment. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 0. |
DIA(Ansch_Wert; Restwert; Nutzungsdauer; Zr)
Returns the sum of years depreciation.
| Ansch_Wert | The cost. |
| Restwert | The salvage value. |
| Nutzungsdauer | The total number of periods. |
| Zr | The period for which you want the depreciation. |
DISAGIO(Abrechnung; Fälligkeit; Kurs; Rückzahlung; [Basis])
Returns the discount rate for a security.
| Abrechnung | The settlement date. | ||||||||||
| Fälligkeit | The maturity date. | ||||||||||
| Kurs | The price per $100 value. | ||||||||||
| Rückzahlung | 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. |
DURATION(Abrechnung; Fälligkeit; coupon; Rendite; Häufigkeit; [Basis])
Returns the Macauley duration for a value of $100.
| Abrechnung | The settlement date. | ||||||||||
| Fälligkeit | The maturity date. | ||||||||||
| coupon | The interest rate. | ||||||||||
| Rendite | The annual yield rate. | ||||||||||
| Häufigkeit | 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. |
EFFEKTIV(Nominalzins; Perioden)
Returns the effective annual interest rate.
| Nominalzins | The nominal annual interest rate. |
| Perioden | The number of compound interest payments per year. |
GDA(Ansch_Wert; Restwert; Nutzungsdauer; Periode; [Faktor])
Returns the depreciation in a specified period using the double declining balance method.
| Ansch_Wert | The cost. |
| Restwert | The salvage value. |
| Nutzungsdauer | The total number of periods. |
| Periode | The period number for which to calculate depreciation. |
| Faktor | The rate at which the balance declines. If this parameter is omitted it defaults to 2. |
GDA2(Ansch_Wert; Restwert; Nutzungsdauer; Periode; [Monate])
Returns the depreciation in a specified period using the fixed declining balance method.
| Ansch_Wert | The cost. |
| Restwert | The salvage value. |
| Nutzungsdauer | The total number of periods. |
| Periode | The period number for which to calculate depreciation. |
| Monate | The number of months in the first year. If this parameter is omitted it defaults to 12. |
Returns the internal rate of return.
| Wert | The list (array or reference) of payment and income values. |
| Schätzwert | The estimated rate of return. If this parameter is omitted it defaults to 0,1. |
Returns the interest payment for a given period.
| Zins | The interest rate per period. |
| Zr | The period for which you want the interest amount. |
| Zzr | The total number of periods. |
| Bw | The present value. |
KAPZ(Zins; Zr; Zzr; Bw; [Zw]; [F])
Returns the payment on the principal for a specified period.
| Zins | The interest rate per period. | ||||
| Zr | The period for which you want the payment amount. | ||||
| Zzr | The total number of periods. | ||||
| Bw | The present value of the loan. | ||||
| Zw | The future value of the loan. If this parameter is omitted it defaults to 0. | ||||
| F | The timing of the payment. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 0. |
KUMKAPITAL(Zins; Perioden; Bw; Anfang; Ende; F)
Returns the cumulative principal paid on a loan in the specified periods.
| Zins | The interest rate. | ||||
| Perioden | The total number of periods. | ||||
| Bw | The present value. | ||||
| Anfang | The first period number for which to calculate interest. | ||||
| Ende | The last period number for which to calculate interest. | ||||
| F | The timing of the payment. The possible values are: | ||||
|
KUMZINSZ(Zins; Perioden; Bw; Anfang; Ende; F)
Returns the cumulative interest paid on a loan in the specified periods.
| Zins | The interest rate. | ||||
| Perioden | The total number of periods. | ||||
| Bw | The present value. | ||||
| Anfang | The first period number for which to calculate interest. | ||||
| Ende | The last period number for which to calculate interest. | ||||
| F | The timing of the payment. The possible values are: | ||||
|
KURS(Abrechnung; Fälligkeit; Zins; Rendite; Rückzahlung; Häufigkeit; [Basis])
Returns the price per $100 of a security.
| Abrechnung | The settlement date. | ||||||||||
| Fälligkeit | The maturity date. | ||||||||||
| Zins | The annual coupon rate. | ||||||||||
| Rendite | The annual yield rate. | ||||||||||
| Rückzahlung | The redemption value per $100. | ||||||||||
| Häufigkeit | 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. |
KURSDISAGIO(Abrechnung; Fälligkeit; Disagio; Rückzahlung; [Basis])
Returns the price per $100 of a discounted security.
| Abrechnung | The settlement date. | ||||||||||
| Fälligkeit | The maturity date. | ||||||||||
| Disagio | The discount rate. | ||||||||||
| Rückzahlung | 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. |
KURSFÄLLIG(Abrechnung; Fälligkeit; Emission; Zins; Rendite; [Basis])
Returns the price per $100 of a security that pays interest at maturity.
| Abrechnung | The settlement date. | ||||||||||
| Fälligkeit | The maturity date. | ||||||||||
| Emission | The issue date. | ||||||||||
| Zins | The interest rate. | ||||||||||
| Rendite | 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. |
LIA(Ansch_Wert; Restwert; Nutzungsdauer)
Returns the straight line depreciation.
| Ansch_Wert | The cost. |
| Restwert | The salvage value. |
| Nutzungsdauer | The total number of periods. |
MDURATION(Abrechnung; Fälligkeit; coupon; Rendite; Häufigkeit; [Basis])
Returns the modified Macauley duration for a value of $100.
| Abrechnung | The settlement date. | ||||||||||
| Fälligkeit | The maturity date. | ||||||||||
| coupon | The interest rate. | ||||||||||
| Rendite | The annual yield rate. | ||||||||||
| Häufigkeit | 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. |
NBW(Zins; Wert1; [Wert2; ...])
Returns the net present value of an investment.
| Zins | The discount rate per period. |
| Wert1; ... | The payment and income amounts. |
NOMINAL(Effektiver_Zins; Perioden)
Returns the nominal annual interest rate.
| Effektiver_Zins | The effective annual interest rate. |
| Perioden | The number of compound interest payments per year. |
Returns the fraction equivalent of a dollar price expressed as a decimal.
| Zahl | The value expressed as a decimal. |
| Teiler | The fraction denominator. |
Returns the decimal equivalent of a dollar price expressed as a fraction.
| Zahl | The value expressed as a fraction. |
| Teiler | The fraction denominator. |
QIKV(Werte; Investition; Reinvestition)
Returns the modified internal rate of return.
| Werte | The list (array or reference) of payment and income values. |
| Investition | The interest rate on the payment values. |
| Reinvestition | The interest rate on the income values. |
RENDITE(Abrechnung; Fälligkeit; Zins; Kurs; Rückzahlung; Häufigkeit; [Basis])
Returns the yield on a security.
| Abrechnung | The settlement date. | ||||||||||
| Fälligkeit | The maturity date. | ||||||||||
| Zins | The annual coupon rate. | ||||||||||
| Kurs | The price per $100. | ||||||||||
| Rückzahlung | The redemption value per $100. | ||||||||||
| Häufigkeit | 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. |
RENDITEDIS(Abrechnung; Fälligkeit; Kurs; Rückzahlung; [Basis])
Returns the annual yield for a discounted security.
| Abrechnung | The settlement date. | ||||||||||
| Fälligkeit | The maturity date. | ||||||||||
| Kurs | The price per $100. | ||||||||||
| Rückzahlung | 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. |
RENDITEFÄLL(Abrechnung; Fälligkeit; Emission; Zins; Kurs; [Basis])
Returns the annual yield of a security that pays interest at maturity.
| Abrechnung | The settlement date. | ||||||||||
| Fälligkeit | The maturity date. | ||||||||||
| Emission | The issue date. | ||||||||||
| Zins | The interest rate. | ||||||||||
| Kurs | 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. |
RMZ(Zins; Zzr; [Bw]; [Zw]; [F])
Returns the payment amount for a loan.
| Zins | The interest rate per period. | ||||
| Zzr | The total number of periods. | ||||
| Bw | The present value of the loan. If this parameter is omitted it defaults to 0. | ||||
| Zw | The future value of the loan. If this parameter is omitted it defaults to 0. | ||||
| F | The timing of the payment. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 0. |
TBILLKURS(Abrechnung; Fälligkeit; Disagio)
Returns the price per $100 for a treasury bill.
| Abrechnung | The settlement date. |
| Fälligkeit | The maturity date. |
| Disagio | The discount rate. |
TBILLRENDITE(Abrechnung; Fälligkeit; Kurs)
Returns the yield for a treasury bill.
| Abrechnung | The settlement date. |
| Fälligkeit | The maturity date. |
| Kurs | The price per $100. |
TBILLÄQUIV(Abrechnung; Fälligkeit; Disagio)
Returns the bond-equivalent yield for a treasury bill.
| Abrechnung | The settlement date. |
| Fälligkeit | The maturity date. |
| Disagio | The discount rate. |
UNREGER.KURS(Abrechnung; Fälligkeit; Emission; first_coupon_date; Zins; Rendite; Rückzahlung; Häufigkeit; [Basis])
Returns the price per $100 face value of a security having an odd (short or long) first period.
| Abrechnung | The settlement date. | ||||||||||
| Fälligkeit | The maturity date. | ||||||||||
| Emission | The issue date. | ||||||||||
| first_coupon_date | The first coupon date. | ||||||||||
| Zins | The annual coupon rate. | ||||||||||
| Rendite | The annual yield rate. | ||||||||||
| Rückzahlung | The redemption value per $100. | ||||||||||
| Häufigkeit | 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. |
UNREGER.REND(Abrechnung; Fälligkeit; Emission; first_coupon_date; Zins; Kurs; Rückzahlung; Häufigkeit; [Basis])
Returns the yield of a security having an odd (short or long) first period.
| Abrechnung | The settlement date. | ||||||||||
| Fälligkeit | The maturity date. | ||||||||||
| Emission | The issue date. | ||||||||||
| first_coupon_date | The first coupon date. | ||||||||||
| Zins | The annual coupon rate. | ||||||||||
| Kurs | The price per $100. | ||||||||||
| Rückzahlung | The redemption value per $100. | ||||||||||
| Häufigkeit | 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. |
UNREGLE.KURS(Abrechnung; Fälligkeit; last_coupon_date; Zins; Rendite; Rückzahlung; Häufigkeit; [Basis])
Returns the price per $100 face value of a security having an odd (short or long) last period.
| Abrechnung | The settlement date. | ||||||||||
| Fälligkeit | The maturity date. | ||||||||||
| last_coupon_date | The last coupon date. | ||||||||||
| Zins | The annual coupon rate. | ||||||||||
| Rendite | The annual yield rate. | ||||||||||
| Rückzahlung | The redemption value per $100. | ||||||||||
| Häufigkeit | 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. |
UNREGLE.REND(Abrechnung; Fälligkeit; last_coupon_date; Zins; Kurs; Rückzahlung; Häufigkeit; [Basis])
Returns the yield of a security having an odd (short or long) last period.
| Abrechnung | The settlement date. | ||||||||||
| Fälligkeit | The maturity date. | ||||||||||
| last_coupon_date | The last coupon date. | ||||||||||
| Zins | The annual coupon rate. | ||||||||||
| Kurs | The price per $100. | ||||||||||
| Rückzahlung | The redemption value per $100. | ||||||||||
| Häufigkeit | 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. |
VDB(Ansch_Wert; Restwert; Nutzungsdauer; Anfang; Ende; [Faktor]; [Nicht_wechseln])
Returns the depreciation in a specified range of periods using the variable declining balance method.
| Ansch_Wert | The cost. | ||||
| Restwert | The salvage value. | ||||
| Nutzungsdauer | The total number of periods. | ||||
| Anfang | The first period number for which to calculate depreciation. | ||||
| Ende | The last period number for which to calculate depreciation. | ||||
| Faktor | The rate at which the balance declines. If this parameter is omitted it defaults to 2. | ||||
| Nicht_wechseln | 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 FALSCH. |
XINTZINSFUSS(Werte; Zeitpunkte; [Schätzwert])
Returns the internal rate of return.
| Werte | The list (array or reference) of payment and income values. |
| Zeitpunkte | The list (array or reference) of the dates of the payment and income values. |
| Schätzwert | The estimated rate of return. If this parameter is omitted it defaults to 0,1. |
XKAPITALWERT(Zins; Werte; Zeitpunkte)
Returns the net present value of an investment.
| Zins | The discount rate per period. |
| Werte | The list (array or reference) of payment and income values. |
| Zeitpunkte | The list (array or reference) of the dates of the payment and income values. |
ZINS(Zzr; Rmz; Bw; [Zw]; [F]; [Schätzwert])
Returns the interest rate per period of an annuity.
| Zzr | The total number of periods. | ||||
| Rmz | The payment amount each period. | ||||
| Bw | The present value. | ||||
| Zw | The future value. If this parameter is omitted it is assumed to be zero. | ||||
| F | The timing of the payment. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 0. | |||||
| Schätzwert | The estimated rate of return. If this parameter is omitted it defaults to 0,1. |
ZINSSATZ(Abrechnung; Fälligkeit; Anlage; Rückzahlung; [Basis])
Returns the interest rate for a fully invested security.
| Abrechnung | The settlement date. | ||||||||||
| Fälligkeit | The maturity date. | ||||||||||
| Anlage | The initial value. | ||||||||||
| Rückzahlung | 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. |
ZINSTERMNZ(Abrechnung; Fälligkeit; Häufigkeit; [Basis])
Returns the next coupon date after the settlement date.
| Abrechnung | The settlement date. | ||||||||||
| Fälligkeit | The maturity date. | ||||||||||
| Häufigkeit | 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. |
ZINSTERMTAGE(Abrechnung; Fälligkeit; Häufigkeit; [Basis])
Returns the number of days in the coupon period that contains the settlement date.
| Abrechnung | The settlement date. | ||||||||||
| Fälligkeit | The maturity date. | ||||||||||
| Häufigkeit | 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. |
ZINSTERMTAGNZ(Abrechnung; Fälligkeit; Häufigkeit; [Basis])
Returns the number of days from the settlement date to the next coupon date.
| Abrechnung | The settlement date. | ||||||||||
| Fälligkeit | The maturity date. | ||||||||||
| Häufigkeit | 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. |
ZINSTERMTAGVA(Abrechnung; Fälligkeit; Häufigkeit; [Basis])
Returns the number of days from the beginning of the coupon period to the settlement date.
| Abrechnung | The settlement date. | ||||||||||
| Fälligkeit | The maturity date. | ||||||||||
| Häufigkeit | 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. |
ZINSTERMVZ(Abrechnung; Fälligkeit; Häufigkeit; [Basis])
Returns the coupon date before the settlement date.
| Abrechnung | The settlement date. | ||||||||||
| Fälligkeit | The maturity date. | ||||||||||
| Häufigkeit | 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. |
ZINSTERMZAHL(Abrechnung; Fälligkeit; Häufigkeit; [Basis])
Returns the number of coupon periods between the settlement date and the maturity date.
| Abrechnung | The settlement date. | ||||||||||
| Fälligkeit | The maturity date. | ||||||||||
| Häufigkeit | 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. |
ZINSZ(Zins; Zr; Zzr; Bw; [Zw]; [F])
Returns the interest payment for a given period.
| Zins | The interest rate per period. | ||||
| Zr | The period for which you want the interest amount. | ||||
| Zzr | The total number of periods. | ||||
| Bw | The present value. | ||||
| Zw | The future value. If this parameter is omitted it is assumed to be zero. | ||||
| F | The timing of the payment. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 0. |
Returns the future value of an investment at a fixed rate.
| Zins | The interest rate per period. | ||||
| Zzr | The total number of periods. | ||||
| Rmz | The payment amount each period. | ||||
| Bw | The present value. If this parameter is omitted it is assumed to be zero. | ||||
| F | The timing of the payment. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 0. |
Returns the future value of an investment at a variable rate.
| Kapital | The initial value of the investment. |
| Zinsen | The list (array or reference) of interest rates to be applied. |
Returns the number of periods required for an investment.
| Zins | The interest rate per period. | ||||
| Rmz | The payment amount per period. | ||||
| Bw | The present value. | ||||
| Zw | The future value. If this parameter is omitted it defaults to 0. | ||||
| F | The timing of the payment. The possible values are: | ||||
| |||||
| If this parameter is omitted it defaults to 0. |