2 D2 (3/12;4*12;5) (. 1), D2 -2470,17.
3 3 8%, D2 c 2506,91.
4 3 9%, D2 c 2543,98.
5 : 3 5%, 4 5 5 100000, D2 c 1887,12.
.
2 . , . Excel .
3 2 3 2.
:
1 .
2 .
3 ., 7%.
4 ( ), , 3.
5 .
6 , 3 0,07. . " - " , , , . .
. , , . +(-) () . .
3 . . () , , .
4 1. 2500. , .
1. . 6:
2. .
:
- 6,
- - -2500
- 3 ( ),
- .
: = -27716 .
.
7 (excel-7).
|
|
1 , ?
2 , , , , , ?
3 ?
4 , ?
5 , , , ?
6 , ?
1 1, 140000· n, n - . , 8,5% 5%, 5 10 .
2 - 2, 80000·n, n- .
3 .1 ( ) .2 ( ) .
4 4, n·100.
1, ,
2
3
4
6 (excel-6)
Excel
:
:
1 .
2 .
.
3 .
4 .
- , . , Visual Basic, , Visual Basic. , .
, , . , . , , .
Visual Basic , , . , , , .