. , , , :
n = t / K, (4)
- ( ),
- ( ),
t - ( ) .
, , :
- (), 360 , .. 12 30 ;
- , : 365 366.
:
- - ;
- - , 30 .
, .
, :
) ( );
) ( );
) ( ).
. .
2. , 100 000 ., 21 2009 . 3 2009 . , 15% . :
1) ;
2) ;
3) .
:
= 100 000 .,
T = 21 2009 ,
T = 03 2009 ,
i = 0,15 15%.
I1 =?, I2 =?, I3 =?
.
1- . (1) (4):
I = P n i = P (t / K) i.
. 1 ( 1), : t = 62 - 21 = 41,
1) = 365, t = 41, I 1 = 100 000 * (41 / 365) * 0,15 = 1 684,93 .;
2) = 360, t = 41, I 2 = 100 000 * (41 / 360) * 0,15 = 1 708,33 .
42 ( 9 + 30 + 3 ),
3) = 360, t = 42, I 3 = 100 000 * (42 / 360) * 0,15 = 1 750,00 .
, .
2- . ( ). , ( ).
(_; _; ) :
|
|
_ ,
_ ,
. 1.
1
0 | (NASD) 30/360 |
/ | |
/360 | |
/365 | |
30/360 |
< 0 > 4, #!.
Excel . 2.
)
)
. 2. Excel
B4 B5 , , . 3.
. 3. Excel
3- . Excel. Excel .
. :
S = * (1+ n1 i 1+ n2 i2+...) = *(1+ ∑nt i t ), (5)
- (),
it - t,
nt - t it.
3. , , 16% , 1% , . .
:
n1 = 0,25, i1 = 0,16;
n2 = 0,25, i2 = 0,15;
n3 = 0,25, i3 = 0,14;
n4 = 0,25, i4 = 0,13.
(1+∑ntit ) =? .
1- . (5) :
(1+∑ntit) = 1+0,25*0,16+0,25*0,15+0,25*0,14+0,25*0,13 =1,145.
2- . Excel (5) . 4.
. 4. . 5 : =1+(B3:B6;D3:D6)
3- . Excel. Excel .