, , IRR . .
_________________________________________________________________
IRR MS EXCEL, Ļ.
IRR MS EXCEL
IRR 29%
() (), .
___________________________________________________
.
1 | 2 | . | |
-26 117 315 | 33 692 902 | ||
-26 117 315 | 7 575 587 | ||
: = (1 - (- 26 117 315) / 33 692 902)*12 . = 21 | |||
2 . , , (1 ), (- 26 117 315) , (33 692 902). , 12 (12 ). | |||
MS EXCEL
MS EXCEL.
23 .
______________
:
;
.
. , , . .
6
: ; ; ; ; ; ; ; ; . .. | . : ; ; ; ; ; |
: ; ; ; . |
_______________________________________
|
|
:
, | ||
() | ||
_______________ | ___________________ ___________________ ___________________ ___________________ ___________________ ___________________ ___________________ ___________________ | _______________________________ _______________________________ _______________________________ _______________________________ _______________________________ _______________________________ _______________________________ _______________________________ |
________________________
-.
:
- ;
.
- . - , .
:
-. | ||
.. | ||
____ | ______________________________________________ | ____________________ |
____ | __________________________________________________ | ______________________ |
____ | ______________________________________________ | ____________________ |
____ | ______________________________________________ | ____________________ |
____________
:
-.
:
;
;
;
;
- ;
, , , - ;
;
;
;
, ;
;
;
.
______
, . , . , 5 .
.
:
-. | |
_____________. | |
(NPV) | _____________. |
(IRR) | ___% |
____ | |
_____ |
.
:
( ).
|
|
- , , , , .
- , (), , .
- - , .
_______________________________________
( ).
:
( , ), , .
____________________________________________________