What means PV?

principal amount

(Geldsumme)

What means FV?

principal amount plus interet

(FV after the last payment is made)

What means rate?

interest rate per period

(normally per year —> /12)

What means Nper?

total number of payment periods

What means Per?

particular period, less or equal to Nper

What means Pmt?

payment made each period

(a constant value that dies not change)

What means type?

indication when payment is due

0 due at the end of period

1 due at beginning of period

How can the periodic payment for an annuity be calculated?

=PMT (rate;nper;pv)

How can the returns of payment on the principal for a given period be calculated?

= PPMT (rate; per; nper; pv)

How can the returns of the interest payment for a given period?

= IPMT (rate; per; nper; pv)

How can the interest rate per period of an annuity be calculated?

= RATE ( nper; pmt; pv)

How can the number of periods for a loan or investment be calculated?

= NPER (rate; pmt)

How can the present value of a loan or investment be calculated?

= PV (rate; nper; pmt)

How can the net present value be calculated?

= NPV (rate; value1; [value2];…)

How can the internal rate of return for a series of cashflows?

= IRR (values; [guess])

What needs to be considered calculating the net present value?

= NPV (rate; cashflows)+ Cashflow Period 0

How can the net present value be calculated manually?

= Cashflow / (1+ interest rate) ^ ausgewählte Periode

Last changed2 years ago