XL98: ????? ???? ??????? ??????? IntraYear

?????? ????????? ?????? ?????????
???? ???????: 186004 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ?????? ?????????? ????? ?????? ???? ???? ????? ????? ????? ??????? ??????? ????? ??????? ??????. ???????? ???? ????? ????????. ????? ????? ?? ????? ?????: ??????? ? intrayear ??????? ????? ??????. ????? ??? ??????? ??? ??????? ??? ???????? ???????? intrayear ??????? ???????.

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

??????? ????

??????? ??????? Intrayear ?? ??????? ???? ????? ???? ?? ??? ????? ?? ?????. ?? ???????? ??????? ???? ??????? ??? ???? ??????? ??????? ??? ????? ?? ??? ?????? ????? ?????? ?? ??? ?????.

????? Microsoft Excel 98 Macintosh Edition ?????? EFFECT ?? Analysis ToolPak ??????? ????????. ???? ?????? ????? ???? ???? ??????? ??? ???? ???? ??????? ??????? ???? ??????? ??????? ?? ?????.

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

?????

?????? ??????? ???????? ?? ??? ?????? ?????? ????? ???????? ??????? ????? ???????? ???? ?? ????? ?? ?????? ??????.
   IntraYear                 Number of compounding
   compounding rate          periods per year
   -----------------------------------------------
   Semiannual                  2
   Quarterly                   4
   Monthly                    12
   Weekly                     52
   Daily                     360 or 365(actual)
				
???? ??????? 100 ?. ? 8.00% ???? ??? ????. ??? ??? ????? ??? ?? ?????? ???? 3 ?????? ???? ????? 100 ????? ??????

??? ???? ?????? ??????? ???? ???? ????? ?????:

???? ????? ??? ?????? ??? ????? ?????? EFFECT ????? ????? ??????? ??????? ????? ????. ?? ?? ??? ??? ??? ??????? ????? ?????? ????????? 3 ?? ??? ??????? (?????) ???? ???? ??? ??? ?????????:
=100+(100*EFFECT(EFFECT(.08,2)*3,3))
???? ?????? ?????? $126.53.

??? ???? ?????? ??????? ???????? ???:

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

???? ?????? ??????? ?????? Intrayear

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

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

?????

??? ???? ?????? ??????? ???? ???? ????? ?????:

???? ??????? 100 ?. ? % 7.50 ????? ?? ????? ????. ???? ??? ????? ?????? ???? ????? ??? ???? ??????? ???? ?????? ??????? ???? ??????? ????:
=EFFECT(EFFECT(.075,4)*2,2)
????? ?????? 16.022%.

??? ???? ?????? ??????? ???????? ???:

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

?????

????? ?? ????????? ??? ??????? ???????? ???? ??? "????????? ???????" ?? ??????? ??????? (?? ?? ??????? "??????? ?? ?????" ??? ??? ?????? ????? ?? ???? ????? ??????? ???? ?? 8.0)? ???? ??? ???? "??????" ?? ??????? Excel MS? ???? ???? ??????
??????? ???????
??? ?? ???? ??? "????? ????????". ??? ??????? "???"? ? ???? ??? "???????? ???". ??? ??? ??? ???? ??? ?????? ??? ????????? ???? ?????? ???? ????? office.

???????

???? ???????: 186004 - ????? ??? ??????: 11/????? ???????/1434 - ??????: 3.0
????? ???
  • Microsoft Excel 98 ?? Macintosh
????? ??????: 
kbhowto kbmt KB186004 KbMtar
????? ????
???: ??? ????? ??? ??????? ???????? ????? ?????????? ??????? ?????? ??? ??????? ?? ??? ??????? ?? ??????? ??? ??? ?? ???? ????????? ???? ??????? ???????(CTF) ?? ?? ???? ????? ????. ???? ?? ???? ?????????? ??? ???????? ???????? ???? ??? ?? ???????? ??????? ?? ??? ??????? ???????? ?? ??? ??????? ??????? ??? ?????? ?? ?????? ??? ???? ???????? ???????? ?? ????? ??????? ????? ????? ??????. ??? ?? ???????? ???????? ?? ????? ??? ????? ?? ???????? ?? ???? ????? ?? ?????. ?????? ??? ???? ?????????? ???? ?????? ?? ??? ????? ?? ??? ??? ?? ??????? ?? ??? ????? ?? ???? ????? ????? ?? ????? ??????? ???? ?? ???????? ?? ??? ???????.
???? ??? ????? ??????? ?????? ??????????186004
????? ??????? ?? ????? ???? ?? ????? ???????
?? ????? ????? ?????? ???? ???? ???? ??? ??????? ??? ?? ? ?? ??? ??????? Microsoft ??? ????? ??? ??????? ????? ?????? ?????

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

 

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