Financial math functions

The financial math functions allow the calculation of economic key data.

Following formulas are the base for all functions
is interest unequal 0 then

is interest equal 0, then is essential:

financial functions		Syntax
PV - BW	The PV-function returns the cash value for future payments. The cash value accords the value, which a future payment has in the present. This payment can be a credit (for example a mortgage) or an investment (for example a constant saving deposit). The interest rate and the payments are constant. Outgoing payments are displayed by negative numbers and incoming payments by positive numbers. Example: =PV(0,5; 15; 10000; 1000; 1) Results: =-29933,77 calculation formula:	PV(number Rate; number Nper; number Pmt; number [Fv]; number [Type]) Rate: Interest rate per period Nper: Total number of payment periods. Pmt: Payment per period. Fv: Final value after the last payment. The default value is 0. Type: Maturity of the payments. The Default value is 0. nper und rate have to be defined in the same time unit
PPMT - KAPZ	The PPMT-function returns the capital share of a payment for a specified period. that means, for a certain period of the annuity it returns the payoff. An annuity can be a facility (for example a mortgage) or an investment (for example a constant saving deposit). The interest rate and the payments are constant. Outgoing payments are displayed by negative numbers and incoming payments by positive numbers. Example: =PPMT(0,6;12;15;10000;500;0) Result: =-962,14 calculation formula:	PPMT(number Rate; number Per; number Nper; number Pv; number [Fv]; number [Type]) Rate: Interest rate per period. Per: Defines the payment period. Nper: Total number of payment periods. Pv: Cash value of future payments. Fv: Final value after the last payment. The default value is 0. Type: Maturity of the payments. The default value is 0. nper und rate have to be defined in the same time unit.
PMT - RMZ	The PMT-function returns the payoff for an annuity. An annuity can be a facility (for example a mortgage) or an investment (for example a constant saving deposit). The interest rate and the payments are constant. Outgoing payments are displayed by negative numbers and incoming payments by positive numbers. Example: =PMT(0,3;13;2000;0;1) Result: =-477,29 calculation formula:	PMT(number Rate; number Nper; number Pv; number [Fv]; number [Type]) Rate: Interest rate per period. Nper: Total number of periods. Pv: Cash value of future payments. Fv: Final value after the last payment. The default value is 0. Type: Maturity of the payments. The default value is 0. nper und rate have to be defined in the same time unit.
NPV - NPV	The NPV-function returns the net cash value of an investment. The net cash value represents the value of future payments-in and payments-out down to the present date, whereas the values not have to be constant during the delay Example: =NPV(0,2;values(-12000,10000,10000)) Result: =2731,48 calculation formula:	NPV(number Rate; values Values) Rate: Interest rate per period. Values: The values of the payment-ins and payment-outs. It have to be at minimum one negative and one positive value available
NPER - ZZR	The NPER-function returns the amount of the payment period of an annuity. That means it gives the total number of periods, which are necessary, to pay the annuity. This can be an annuity can be a facility (for example a mortgage) or an investment (for example a constant saving deposit). The interest rate and the payments are constant. Outgoing payments are displayed by negative numbers and incoming payments by positive numbers. Example: =NPER(0,4;10000;1000;0;1) Result: =-8,37 calculation formula:	NPER(number Rate; number Pmt; number Pv; number [Fv]; number [Type]) Rate: Interest rate per period. Pmt: Payment per period. Pv: Cash value of future payments. Fv: Final value after the last payment. The default value is 0. Type: Maturity of the payments. The default value is 0.
MIRR - MIRR	The MIRR-function returns the modified economic rate of return for a set of payments-in and payments-off. The economic rate of return is the interest rate for a investment, which is composed of payments-in and payments-off at regular intervals. At the "modified" intern rate of return the payments will be connect with diverse interest rates. The cost of the investment (financerate) as well as the interest rate, which is achieved by a new money investment (reinvestrate), are considered. Example: =MIRR(values(-5000,2000,2000,2000);0,3;0,6) Result: =0,27 Calculation formula:	MIRR(values Values; number Finance_rate; number Reinvest_rate) Values: The values of the payment-ins and payment-offs. Finance_rate: Interest rate at the finance of a investment. Reinvest_rate: Interest rate at a new investment of capital. At the minimum one positive and one negative value must be containes at the values
FV - ZW	The FV-function returns the final value of an annuity. With its help can be detected, which value one or more during a period achieved payments have at the end. This can be an annuity can be a facility (for example a mortgage) or an investment (for example a constant saving deposit). The interest rate and the payments are constant. Outgoing payments are displayed by negative numbers and incoming payments by positive numbers. Example: =FV(0,7;10;500;100;1) Result: =-263744,91 Calculation formula:	FV(number Rate; number Nper; number Pmt; number [Pv]; number [Type]) Rate: Interest rate per period. Nper: Total number of periods. Pmt: Payment per period. Pv: Cash value of future payments. The default is 0. Type: Maturity of the payments. The default value is 0. nper and rate have to be defined in the same time unit. werden.
DDB - GDA	The DDB-function returns the amortisation of an asset for a specified period. So the amount of the ammortisation for a period will be assigned. Example: =DDB(15000;1000;5;1;2) Result: =6000 Calculation formula:	DDB(number Cost; number Salvage; number Life; number Period; number [Factor]) Cost: Purchase costs of the asset. Salvage: Value at the end of the useful life. Life: The expected useful life of the asset. Period: The period for the amortisation. Factor: Factor, from which the value will be detracted. The default value is 2. life und period must be defined in the same time unit.
IPMT - ZINSZ	The IPMT-function returns the payment of interest of a annuity for a specified period. This can be an annuity can be a facility (for example a mortgage) or an investment (for example a constant saving deposit). The interest rate and the payments are constant. Outgoing payments are displayed by negative numbers and incoming payments by positive numbers. Example: =IPMT(0,5;17;18;4000;10000;0) Result: =1108,48 Calculation formula:	IPMT(number Rate; number Per; number Nper; number Pv; number [Fv]; number [Type]) Rate: Interest rate per period. Per: Defines the period. Nper: Total number of the periods. Pv: Cash value of future payments. Fv: Final value after the last payment. Der Standartwert ist 0. Type: Maturity of the payments. Standartwert ist 0. nper und rate must be defined in the same time unit.
RATE - ZINS	The RATE-function returns the interest rate of an annuity. This can be an annuity can be a facility (for example a mortgage) or an investment (for example a constant saving deposit). Outgoing payments are displayed by negative numbers and incoming payments by positive numbers Example: =RATE(48; -200; 8000) Ergebnis: =0,007701472 Calculation formula:	RATE(number Nper; number Pmt; number Pv; number [Fv]; number [Type]; number [Guess]) Nper: Total number of periods. Pmt: Payment per period. Pv: Cash value of future payments. Fv: Final value after the last payment. The default value is 0. Type: Maturity of the payments. The default value is 0. Guess: Estimated value for the interest rate. The default value is 10.
SLN - LIA	The SLN-function returns the linear amortisation of a economic good per period. Outgoing payments are displayed by negative numbers and incoming payments by positive numbers. Example: =SLN(20000; 200; 5) Ergebnis: =3960 Calculation formula:	SLN(number Cost; number Salvage; number Life) Cost: Purchase costs of the economic good. Salvage: Salvage value of the good at the end of the useful life. Life: The economic useful life of the asset.
SYD - DIA	The SYD-function returns the arithmetic-declining amortisation of a economic good per period. Outgoing payments are displayed by negative numbers and incoming payments by positive numbers. Example: =SYD(20000; 200; 5; 4) Ergebnis: =2640 Calculation formula:	SLN(number Cost; number Salvage; number Life; number Period) Cost: Purchase costs of a economic good. Salvage: Salvage value of the good at the end of the useful life. Life: Economic useful life of the asset. Period: The period from which the amortisation should be calculated.

functions