. . S = P( 1 + i)n :
P = S/( 1 + i) n = Sν n , (17)
ν n = 1 /( 1 + i) n (18)
, .
11. 5 1 000 000 . , 14% .
:
n = 5 ,
S = 1 000 000 .,
i = 0,14 14%.
P =?
.
1- . (17):
P = S/( 1 + i) n = 1 000 000/(1+0,14) 5 = 519 368,66 .
2- . Excel . . 19 .
)
)
. 19. Excel. H3 : ) =B3/(1+B4;B2); ) =B3*(1+B4;-B2)
3- . Excel , . 20. .
)
)
. 20. (. ) (. ). H3 =(B4; B2; 0; -B3; 1)
(;;;;). :
,
,
( , ),
, ;
( 0, , 1- ).
, :
P = S / (1 + j / m) nm = Sν nm , (19)
ν nm = 1/(1 + j / m) nm (20)
( ).
, S, , , S.
S , S , . D = S - P .
. . :
= S (1- d ) n (21)
dc1 - .
:
D = S P = S S (1- d) n = S [1 (1 - d) n ] (22)
, , .
|
|
12. 5 1 000 000 . 10% . , , .
:
n = 5 ,
S = 1 000 000 .,
i = 0,14 14%.
P =?, D =?
.
1- . (21 22) .
, (21)
= S (1- d ) n = 1 000 000 * (1 - 0,10) 5 = 590 490,00 .;
, , (22)
D = S - = 1 000 000 - 590 490 = 409 510 .
2- . Excel (21 22) , . 21.
. 21. P D Excel. H3 =B3*(1-B4; B2)
3- . Excel. Excel .