50 , . , .
t . . S=P+I. I . , , .
I = P× r × t,
r .
( )
S = P + I = P + P× r ×t = P (1 + r × t). (1)
( , )
S=P (1+ r) t. (2)
.
1. , (1).
2. , .
Excel C ( ), Calc- FV (Futurum Value).
3. .
4. , ( ).
5. ( ), , .
6. , .
7. .
1
. 1 . 13.
1
1 5 2008 . 20 2008 . . 15 %. ?
, , , ( ), . .
3.1.1.
1:8 .
! 8 $1000000, , 8 , , : , $ (), . 8 1000000.
3.1.2. .
, . 10 =7-6. 10 .
10 258 ( ). , 11 =10/366. 0,71 .
|
|
, = ( ). : = 7 6. .
3.1.3.
12 =5*11. 11, 15 %. (1) , 11 % 15.
3.1.4.
(1)
S=P (1+ rt)= 1 106 027.
; t = 1.
13 =8*(1+B5*11) , (1).
13
Excel | |||
1. | |||
15% | |||
05.01.08 | |||
20.09.08 | |||
$1 000 000 | |||
=7-6 | |||
0,71 | =10/366 | ||
11% | =5*11 | ||
$1 106 027,4 | =8*(1+5*11) |
2
3.2.1.
1 , Excel ( ). :
=(; ; ; ; ),
;
;
( ) , ;
( ) ;
, , ( ), .
OpenOffice.org Calc , 1, FV. :
= FV(; ; ; ; ).
, :
- ;
- ;
( ).
! , ( Calc- FV) , .
3.2.2.
16, . , (FV) ().
3.2.3.
() 12;
() 1;
() ;
()( ) 8.
16 , 13, .
! Excel, , , .
Excel
2. | |||
- $1 106 027,4 | =(12;1;;8) |
|
|
Calc
2. FV | |||
- $1 106 027,4 | =FV(12;1;;8) |
3
2
5 50 000 . 12 % . 5 ?
, . ,
.
5 , .. 5*4=20.
, (2)
90 305,56 .
3.3.1. 17
Excel
A | B | C | |
3. | |||
90 305,56. | =(12%/4;5*4;;-50000) |
Calc
A | B | C | |
3. | |||
90 305,56. | =FV(12%/4;5*4;;-50000) |
3.3.2. 18 ( . 3.2.2): =(12%/4;5*4;;-50000).
OpenOffice.org Calc : =FV(12%/4;5*4;;-50000).
3.3.3. 18 ().
4
.
3
$ 20 000 10 . 22 %. 10 ?
3.4.1.
20:25 . 13.
3.4.2.
27 . :
27;
;
;
( OpenOffice.org Calc - FV);
() 25;
10;
() 2000 ( , );
;
.
3.4.3.
28;
;
;
(FV);
;
() 25;
10;
() 2000 ( , );
;
1, ;
.
, .
Excel
B | C | ||
4. | |||
$20 000 | |||
22% | |||
$57 314,83 | =(25;10;-2000) | ||
$69 924,09 | =(25;10;-2000;;1) |
Calc
B | C | ||
4. FV | |||
$20 000 | |||
22% | |||
$57 314,83 | =FV(25;10;-2000) | ||
$69 924,09 | =FV(25;10;-2000;;1) |
5
|
|
, 1. .
4
4 18 % . , .
Excel ( ).
=(; ; ; ; ).
, , , .
OpenOffice.org Calc , 1, V IPresent Value). :
= V(; ; ; ; ).
3.5.1.
30:36 . 13.
3.5.2.
, . 38 , =33/34.
3.5.3. ,
39;
;
;
;
;
() 38;
34*36;
() ( );
() 35;
;
.
Excel
5. | |||
18% | |||
-$4 000 000 | |||
9% | =33/34 | ||
$2 385 069,31 | =(38;34*36;;35) |
Calc
5. PV | |||
18% | |||
-$4 000 000 | |||
9% | =33/34 | ||
$2 385 069,31 | =PV(38;34*36;;35) |
39 2 385 069,32. , 4 $2 385 069.
6
, .
5
, 80 , 300 000 15 % ?
( ). :
=(;; ; ; ).
.
OpenOffice.org Calc , 1, NER. :
= NER(; ; ;; ).
3.6.1. 5 (. . 13).
3.6.2.
|
|
42;
;
;
(NER);
();
() 15 %;
() 0 ( );
() 80 ( );
() 300000;
;
.
59 .
Excel
6. | |||
=(15%;0;-80;300000) | |||
=(15%/4;0;-80;300000)/4 |
Calc
6. NPER | |||
=NPER(15%;0;-80;300000) | |||
=NPER(15%/4;0;-80;300000)/4 |
3.6.3.
43;
;
;
(NER);
();
() 15%/4 ( );
() 0 ( );
C () 80 ( );
C () 300000;
;
.
43 =(15%/4;0;-80;300000) ( OpenOffice.org Calc -=NER(15%/4;0;-80;300000), , .
3.6.4.
43;
/4 (. . 13);
Enter.
, 56 .
: , .
7
6
4 $ 4000 $ 6000. .
= (; ; ; ; ; ).
, . .
OpenOffice.org Calc , , RE. :
= RE(; ; ; ; ).
3.7.1. 45 (. . 13).
3.7.2. 46 :
(RE) ();
. 12.
OpenOffice.org Calc :
= RE(4; 4000; -6000).
3.7.3. 46 .
. 13.
Calc . 14.
5 000 4 28 % .
.
: [6], . 261-271.
13. Excel
Excel | |||
1. | |||
15% | |||
05.01.08 | |||
20.09.08 | |||
$1 000 000 | |||
=7-6 | |||
0,71 | =10/366 | ||
11% | =5*11 | ||
$1 106 024.4 | =8*(1+5*11) | ||
2. | |||
$1 106 024.4 | =(12;1;;8) | ||
3. | |||
90305,56. | =(12%/4;5*4;;-50000) | ||
4. | |||
$20 000 | |||
22% | |||
$57314,83 | =(25;10;-2000) | ||
$69924,09 | =(25;10;-2000;;1) | ||
5. | |||
18% | |||
-$4 000000 | |||
9% | =33/34 | ||
$2 385 069,31 | =(36;34*36;;35) | ||
. 13
|
|
6. | |||
=(15%;0;-80;300000) | |||
=(15%/4;0;-80;300000)/4 | |||
7. | |||
11% | =(4;;4000;-6000) |
14. Calc
Calc | |||
1. | |||
15% | |||
05.01.08 | |||
20.09.08 | |||
$1 000 000 | |||
=7-6 | |||
0,71 | =10/365 | ||
11% | =5*11 | ||
$1 106 024.4 | =8*(1+5*11) | ||
2. FV | |||
$1 106 024.4 | =FV(12;1;;8) | ||
3. | |||
90 305,56. | =FV(12%/4;5*4;;-50000) | ||
4. FV | |||
$20 000 | |||
22% | |||
$57 314,83 | =FV(25;10;-2000) | ||
$69 924,09 | =FV(25;10;-2000;;1) | ||
. 14 | |||
5. PV | |||
18% | |||
-$4 000 000 | |||
9% | =33/34 | ||
$2 385 069,31 | =PV(36;34*36;;35) | ||
6. NPER | |||
=NPER(15%;0;-80;300000) | |||
=NPER(15%/4;0;-80;300000)/4 | |||
7. | |||
11% | =RATE(4;;4000;-6000) |