3.2 , .
, . r .
t0 PV, t1,t2,,tn 1,2,,n . tn 1 , 2 - ..
. (3.11)
, t0
, , t0.
1
2 ..
. (3.12)
NPV (3.12) Excel
3(; ; ), (3.13)
- ;
- , PV,1,2,,n;
- , t1,t2,,tn.
0 t0, (3.13), .
IRR, , , , , t0.
PV+NPV=0. (3.14)
IRR Excel
(; ; ). (3.15)
() - .
3.3. , 10 . . 1 2002 2750 . . 1 2002 , 2500 . . 30 2002 , 3250 . . 30 2002 , 2500 . . 15 2003 1700 . . 1 2003 . r=12%.
NPV IRR.
3.6.
3.6
A | B | C | D | E | F | G | |
12% | |||||||
(. .) | -10000 | ||||||
01.02.02 | 01.05.02 | 30.09.02 | 30.11.02 | 15.01.03 | 01.08.03 | ||
NPV-PV (. .) | 1632,776 | ||||||
IRR= | 36,92% |
4
=(1;2:G2;B3:G3)
, , , 1 2002 . , , 1,6 . . 5.
= (2:G2;B3:G3)
IRR=36.92% - .
|
|
Excel , .