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