.., .., .., ..
,
2012
681.3.06:664
65.26.73
ã .., .., .., ..
, ( ).
.
. ..-.., .., ... .., .. ‑ .: , 2012. 28 .
, ( ) ( , ) ( ), () Windows Microsoft Office ( Microsoft Excel) Microsoft.
: .., ..-., ;
.., ..., .
..
ã , 2012. 109004, , , 73.
.............................................................................................................. 4
1. .....................................................
2. .......................................................
3. ........................................
.................................................................
, ( ) ( , ) ( ), () Windows Microsoft Office ( Microsoft Excel) Microsoft.
, , , , .
, . , . , .
|
|
3- .
1 Microsoft Excel.
2 .
3 , , , .
. .
Microsoft Excel. :
( ) .
(; ; ; ; )
4 : 30% 45% . 250 . . , .
(. 1), .
1
. ;.
() . .
(; )
, 2000 . . 4- 3900 . . 17%, 20%, 26%. .
1) , 0%. ( 2), .
2
, 0%, 3538,08 . .
2) ( ) ( 1).
. 1.
, , 3900 3- .
3) 2.
. 2.
: 3- 10%.
(; ; ; ; ) = PV - ( ) . () , . , , () .
|
|
(; 1; 2;...) = NPV - , , . ( ). , , , . , .
50000 . NPV, 6 2000, 4000, 5000, 8000, 10000, 12000 . 15% .
3.
3
, NPV = -11157,69 .
, NPV .
= XNPV , .
(; ; )
(; ; ; ; ) .
3 , :
1 ‑ 240 . ., 79 . .;
2 ‑ 290 . . 87 . .;
3 ‑ 340 . ., 112 . .
.
4 .
4
( $ 5 ( ) .)
, 1- 3- .
() , . , . , , . ‑ , , ( ) ( ), .
(; )
, , .
Microsoft Excel . , , 0,00001 . 20 , #!
, 20000, 50000, 60000, 80000 100000 . 10%.
5, 6 3.
. 3.
, . , ().
|
|
(; ; )
, , , #!;
. , , ‑ , = 0;
Microsoft Excel . ( ), , 0,000001 . 100 , #!. , .
. , , , .
(; _; _)
, , . #/0!
3 1 . 15% , 95, 180, 320 . . 11% . .
7.
7
(. 4) ( )
. 4.