XL: ????? ???? ????? ???? ??? ?? ???????????

?????? ????????? ?????? ?????????
???? ???????: 123198 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

"???? ????? ?????" ???? ???????? ?? ??? investors ??????? ?????? ????????? ???? ??? ????? ????? ?????? ??????? ?????? ?????????? ??? ??????? ?? ????? ?????????. ??? ??????? ???????? ???? ????? ??????? ??? "???? ?????? annualized" ?? "????? ???? ???????." ???? ?? ???? annualized ?????? ??????? ?? ??? ???? ????????? ?????? ??????? ??? ???.

?? ????? Microsoft Excel ???? ???? ????? ???. ??? ???? ????? ??????? ?????? ??????? ?????? ??? ??? ??????? ????????
=((FV/PV)^(1/n)) ^ m-1
??? FV ?? ?????? ?????????? ? PV ?? ?????? ???????, n ?? ??? ????? ????????? ????? m ??????? ??????? ??? ???? ?????.

??????? ????

????? ??????? AGR ?? Microsoft Excel ???????? ?????? ?? ???? ?? ??? "??????" ?? ??? ??????? ? ???? ??????? ???????:
  1. ??? ???? ???? ?? Excel.
  2. ???? ?????? ??????? ??????? ?? ???? ?????:
       A1: FV  B1: PV  C1: N  D1: M  E1: AGR
    					
  3. ???? ?????? ??????? ?? ?????? E2:
    =((A2/B2)^(1/C2)) ^ 1 D2
  4. ?????? ??? ??????? ??????? ???? ?????? E2 ?????? ?????? "AGR" ??? ????? E3.

???? 1

????? ???????? ??? FV = $ 120,000 ? PV = $ 10,000, n = 120 ??????? ? m = ??????? 12/?????. ???? ??? ????? ?? ???? ????? ???????:
   A2: 120000  B2: 10000  C2: 120  D2: 12
				
???? ?????? ?? ?????? E2 =.282089 (AGR % 28.21 ?? ?????).

???? 2

????? ???????? ??? FV = $ 120,000 ? PV = $ 10,000, n = ??????? 8 ? m = 1 ????/?????. ???? ??? ????? ?? ???? ????? ???????:
   A3: 120000  B3: 10000  C3: 8  D3: 1
				
???? ?????? ?? ?????? E3 =.364262 (AGR % 36.43 ?? ?????).

?????

??????? handbook ?? ??????? ????? ?????, Inc. Irwin ? ???? 1991 ? 79-80.

???????

???? ???????: 123198 - ????? ??? ??????: 29/?? ?????/1427 - ??????: 2.3
????? ???
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 98 ?? Macintosh
????? ??????: 
kbmt KB123198 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????123198

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

 

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