1. Excel . 1 , 2 . , 3 , 4 . , 5 . . 0 1 2 3 4 5 3:G3 40 50 60 70 80 4:G4. (3.2), : 5 = 1, 5 : =5 + ($$1 + ($$4:4))*$B$2 + 4. D5:G5.
.
A | B | C | D | F | G | ||
. | |||||||
. | |||||||
. | " | " | " | " |
2. . 1 0 = 1000, 2 = 10%.
.
A | B | C | D | F | G | ||
. | 10% | ||||||
. | |||||||
. |
1. Excel . N = 4, P0 = 1000 : 30 40 50 60. 1:G1 , 2 . , 3 , 9 . . 3:G3 4:8 : 0 1 2 3 4, 4:8 : 1000 30 40 50 60.
4 (3.1) Excel : =$B4*(1+($3-$4)*$B$2) D5, E6, F7 G8.
, 4, D5, E6, F7 G8, : D4:G4; E5:G5; F6:G6, G7:G7.
C9 4:8 : = (4:8), D9:G9.
.
A | B | C | D | F | G | ||
. | |||||||
<> | " | " | " | " | |||
" | " | " | " | ||||
" | " | " | |||||
" | " | ||||||
" | |||||||
9 | . | <> | " | " | " | " |
|
|
2. . 2 = 10%.
.
A | B | C | D | F | G | ||
. | 10% | ||||||
. |
2. , , N : 1) P0, N , , 2) pi% i- , 3) .
. , :
,
,
,
.....................
.
:
.
A1 = A2 =...= An = :
.
Excel , :
(3.2)