( ) ( , NPV). , : , - ? " , " ("what if" analysis).
, . , :
1. ;
2. ;
3. . ( ), 1%.
.
1
"". , 100000 .., 4 ; () ; , .
10000 . , 25 . ., 12 . ., 70000 . . . 4 . 25%, 15%. : , , .
NPV , -50% +50% . 10%. , .
MS Excel (. _, 1).
. () , 100000/4 = 25000 . . (. " ")
:
NPV , (2):
|
|
NPV = PV I 0. (2)
I 0 , PV (3)
, (3)
r ;
n ;
CFt t.
(3) (2), :
. (4)
CFt :
Q , .;
P , . .;
FC , . .;
VC 1 , . .;
A , . .;
T , %;
, :
TR = Q ´ P,
:
TC = FC + VC = FC + VC 1 ´ Q.
:
Pr 1 = TR TC.
, :
Pr 2 = Pr 1 A,
:
S = Pr 2 ´ T.
, CFt :
CFt = Pr 3 = Pr 1 S.
. " ".
3 . , 0 (. . " ").
, , . . CF 1 = CF 2 = CFn. NPV , * (. . " NPV ").
NPV MS Excel " " ( ). :
, ( , );
, ;
" " , ;
, ( " ");
, .
3 . (. " ").
, NPV . , NPV ( ), NPV 1%.
|
|
,
;
NPV;
a y = ax + b.
.
a " ", .
" " , , y = ax + b . " ". " " " " " R^2). .
a . :
__y NPV;
__x ;
= 1 y = ax + b ( = 0 y = ax, , . . x = 0 y = 0);
= 0 a ( = 1 , , -, *).
. , NPV : () 1% NPV () 18%. , . NPV .
"-" NPV : , () 1% NPV () 3%.
, ( *) .
, , . , :
, . , ;
.
, , . MS Excel " " ( ).
|
|
, , . .