"". ( 1.1). ( 1.2).
1.1 - ""
| - Q | |||
| - P | |||
| - V |
1.2 - ""
| - F | |
| - A | |
| - T | 60% |
| - r | 10% |
| - n | |
| - I0 |
, NPV:
n
NPV=S (NCFt / (1 + r)t - I0)
t=1
:
NCFt - t.
, r I0 ( 1.2).
, NCF t :
NCFt = Qt(Pt Vt) F A)(1 T) + A
.
: V, Q P. 3.1. , .
EXCEL - " " " " (Analysis ToolPack). ( - - ).
, , , . [F9]. ( ).
, .
(_; _)
, . (.. ) .
|
|
|
, Q ( ).
:
=(150; 300) (: 210).
P V, NPV , , . .
. , , .
. EXCEL .
- "", (. 1.1). . . , 500, ( ). 1.3.
. 1.1 - ""
1.3 - ""
| A10:A510 | _ | |
| B10:B510 | ||
| C10:C510 | ||
| D10:D510 | NCFt | |
| E10:E510 | NPV |
, , . . 1.2. 1.4.
. 1.2
1.4 - " "
| B2 | _ | |
| B3 | _ | |
| B4 | ||
| D2 | ||
| D3 | ||
| D4 |
, , . 1.5 1.6. , .
1.5 - ""
| A10 | =($B$3;$C$3) |
| B10 | =($B$4;$C$4) |
| C10 | =($B$5;$C$5) |
| D10 | =(B10*(C10-A10)-_-)*(1-)+ |
| E10 | =(;;-D10)-_ |
: 5 510.
1.6 - " "
| B8 | =(_) |
| B9 | =(_) |
| B10 | =B9/B8 |
| B11 | =(_) |
| B12 | =(_) |
| C8 | =() |
| C9 | =() |
| C10 | =C9/C8 |
| C11 | =() |
| C12 | =() |
| D8 | =() |
| D9 | =() |
| D10 | =D9/D8 |
| D11 | =() |
| D12 | =() |
| E8 | =() |
| E9 | =() |
| E10 | =E9/E8 |
| E11 | =() |
| E12 | =() |
| F8 | =() |
| F9 | =() |
| F10 | =F9/F8 |
| F11 | =() |
| F12 | =() |
| F13 | =ר(;"<0") |
| F14 | =(;"<0") |
| F15 | =(;">0") |
| 18 | =(D18;$F$8;$F$9) |
| F18 | =(E18) |
|
|
|
" " , (Q, V, P) (NCF, NPV) . .
() () , . 3.6.
() , . :
=(; "").
, F13, NPV, .
() (). , , . :
=(; "").
( 18 F18) NPV.
(x; ; _)
Z x, p(E £ x). . :
- ;
- ;
_ - .
Z - ().
(Z)
, .. , . - Z, ().
, . () - (), ..:
=((x; ; _)).
, ( 18 F18).
SIMUL_1. . .
1. (. 1.2) 2:4 D2:D4 " ".
2. (. 1.1) 3:5 "".
3. F9 .
4. " " .
10:510 V, Q, P NCF NPV. . 1.3. 1.4.
. 1.3-
. 1.4 -
NPV ( F14) . NPV ( F15) . , .
|
|
|
(-11691,92 1692669,76 ).
. () . 1.5 V, P Q, 75 .
, , , . NCF NPV ( 1.6).
. 1.5 V, P Q
. 1.6 - NCF NPV
1
(), () /. , , ( ). MS Excel 1. , . , . 50 .
1
1. 1.
| /. | ./. | |||
| - | 26,4 | |||
| 1,5 | ||||
| 0,3 | ||||
2. 2.
| /. | ./. | |||
| - | 26,4 | |||
| 1,5 | ||||
| 0,3 | ||||
3.
| , | , | (/100 ) | (/100 ) | |
| 5,3 | ||||
4.
|
|
|
| , | , | /100 | ./ | |
| 26,8 | ||||
| 25,3 | ||||
| 37,9 | ||||
| 0,96 | ||||
| 21,5 | ||||
2
