????? ???? ??????? ??????? ????? intra ??? ?? Excel 2000

?????? ????????? ?????? ?????????
???? ???????: 213907 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

?????? ?????????? ????? ????? ???? ???? ??? ???? ???? ????? ??????? ??????? ??????? ??? ????? ???? ???????. ???? ??????? ????? ????? ????????. ?? ????? ????? ?? compounding ?????? ? ????? intra ? compounding ????? ??????. ?????? ??? ??????? ???????? ???????? ????? intra ?? ??????? ???????.

?????? ??? ??????? ?????? ??? compounding ?????? ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
141695XL: ????? ???? ???? ????

???? ?????? ???????? ???? ???? Intra ?????

?? ??????? ??????? ?? ????? Intra ??????? compounded ???? ??? ????? ?? ???. ?? ???????? ??????? ???? ??????? ??? ?????? ??? ????? "??" ????? ????? "??" ?????? ? ????????? ?? ??? ?????? ??????? ???????.

????? Microsoft Excel ?????? ??????? ?? ??????? ???????? Analysis ToolPak. ???? ?????? ????? ???? ??????? ???? ???????? ??? ???? ??????? ??????? ???? ??????? ??????? ?? ?????.

?????? ????? ??????? ??????? intra ????? ?? ???? ???? ????? ????? ??? ???:
=P+(P*EFFECT(EFFECT(k,m)*n,n))
???? ?????? ?????? ????? ??????? ??????? ??? ???
=P*(1+(k/m))^(m*n)
??? ???? ?????? ??????:
P = ????? ??????
k = ???? ??????? ??????? ????????
m = ??? ???? ?? ???? ????? (????? ??????) compounded ???????
n = ??? ????? (????? ???????) ?? ???? ?????

?????

?????? ??????? ???????? ?? ??? ?????? ?????? ????? ? ???????? ?????? ????? ???????? ???????:
   Intra-Year                 Number of compounding
   compounding rate          periods per year
   -----------------------------------------------
   Semiannual                  2
   Quarterly                   4
   Monthly                    12
   Weekly                     52
   Daily                     360 or 365(actual)
				
??????? 100 ?.? ????? ??????? 8.00 compounded semiannually. ??? ??? ????? ?? ?????? ???? ????? ????? 100 ?.? ???? ????? ?

?????? ???? ???? ??? ?????

????? compounding ??? ????? ??? ????? ?????? ????? ????? ????? ??????? ??????? ??? ?????. ??? ?? ?????? ??????? ??? ???? ?????? ????????? 3 ?????? (annualize) ???? ???? ??? ????? ?????????:
=100+(100*effect(effect(.08,2)*3,3))
????? ?????? $ 126.53.

???????? Equation ???

?????? ?????? ?????? ???????? ??????:
=100*(1+.08/2)^(2*3)
????? ?????? $ 126.53.

????? ?????? ???? Compounding Intra ?????

????? ????? ?? ???? ??????? ???? ????? ????? ????? ?????? ?????.

?????? ???? ???? ????? ????? ?????? ???????:
=EFFECT(EFFECT(k,m)*n,n)
???????? ???????? ?????? ????? ???? ??????? ???? ?????? ???????? ???????:
=(1+(k/m)) ^(m*n)-1

?????

?????? ???? ???? ??? ?????

???????? 100 ?.? ????? ??????? 7.50 compounded ?????. ????? ???????? ?? ?????? ??????? ????? ??? ???? ??????. ???? ?????? ??????? ?????? ???? ??????? ????:
=effect(effect(.075,4)*2,2)
????? ?????? 16.022 ???????.

??????? ???????? ???

???????? ??????? ????? ???? ???????:
=(1+(.075/4)) ^(4*2)-1

?????

????? ?? ????????? ??? ??????? ??????? ???? ??? ??????? Microsoft Excel ?? ??????? ??????? ? ???? ??????? ?? ????? Office "??" ????? ??????? ?? ???? ??? ??? ???? ???????.

???????

???? ???????: 213907 - ????? ??? ??????: 24/???/1425 - ??????: 3.2
????? ???
  • Microsoft Excel 2000 Standard Edition
????? ??????: 
kbmt kbformula kbinfo kbhowtomaster KB213907 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????213907

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com