, (, ) 100 000 4 50 000 . 25% . .
- 100 000 | -100 000 | ||
(= ) | 50 000 | 50 000 / (1+25%)^1 = 40 000 | |
50 000 | 50 000 / (1+25%)^2 = 32 000 | ||
50 000 | 50 000 / (1+25%)^3 = 25 600 | ||
50 000 | 50 000 / (1+25%)^4 = 20 480 |
NPV ( ). , ,
50 000 쳿 40 000 . ? , 40 000 25% ( ), 40 000 * (1+25%) = 50 000.
40 = 50 ( 25% )
, 䳿.
, NPV ( ) = -100 000 + 40 000 + 32 000 + 25 600 + 20 480 = 18 080
NPV , .
, Excel.
= - 100 000 + NPV (25%, , )
Excel
, , , 25%. , NPV, ? , . , 25% , ?
IRR. Excel. , IRR Excel
Excel
34,903% ( ). .
, , . 34,9% ? ?
, . , 100 000 34,903% , 50 000. , 4 .
|
|
ҳ () | ³ | ||||
100 000 | = 100 000 * 34,903% =34 903 | 50 000 | 34 903 | = 50 000 34 903 = 15 097 | |
= 100 000 15 097 = 84 903 | = 84 903 * 34,903% = 29 634 | 50 000 | 29 634 | = 50 000 29 630 = 20 366 | |
= 84 903 20 366 = 64 537 | = 64 537 * 34,903% = 22 525 | 50 000 | 22 525 | = 50 000 22 525 = 27 475 | |
= 64 537 27 475 = 37 062 | = 37 062 * 34,9% = 12 936 | 50 000 | 12 936 | 37 064 ( *) | |
* (37 064 37 062) . , |