???? ???????: 141695 - ??? ???????? ???? ????? ????? ??? ???????.
?????? ??? ???? ?? ??? ??????? ???? ??????? Microsoft Excel 98? ???? ??????? ??????? (?? ????? ??? ??????? ??? ???????? ??? ????? ?????? ?????????? (????? ?? ??? ?????? ???)): 191017.
????? ???? | ?? ????

?? ??? ??????

??????

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

??? ????? ?? Microsoft Excel ?? ????? ??? ???? ?????? ??????? ???????? ?????? ??????? ?????? ??????? ???? ??????? ????????
=PV*(1+R)^N
??? ???? PV ???? ?????? ?????? ???????? ?R ?? ???? ???????? ?N ?? ??? ???? ?????????.

??????? ????

????? ?? ???? 1,000.00 ????? ?? ???? ???????. ???? ?????? ???? 8 ??????? ?????? ??????? ??? ??????? ??????. ??? ?? ?????? ??????????? ???? ???? ????? ?????? ???? ?????? ???? ??????? ????? ??????:
  • ??????? ???? ?????
  • ????? ????? ?????? ??????? ???????

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

???? ?????? ??????? ???? ?? ??????? ?? ???? ??? ???? ???? ?????? ???? ????? ?? 1,259.71 ?????:
= 1000 * (1+.08) ^ 3
??? ?? ???? ????????? ??? ??????? ???????? ?????? ????? ?? ?????? ???? ???? ????? ?????? ?????? ?? ?? ??? ????? ??? ???????.

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

???? Microsoft ??????? ???????? ???? ??????? ???? ??? ?? ???? ???? ?? ????. ?????? ??? - ??? ???? ?????? ?? ????? - ???????? ??????? ?????? ???????? ?? ???????? ???? ????. ????? ??? ??????? ??? ????? ??? ??? ??????? ???? ??? ????? ???????? ????????? ?????? ????????? ????????. ???? ??????? ????? ??? Microsoft ??? ??????? ?????? ?????? ????? ???? ?? ?????? ?????? ??? ??????? ?????? ????? ?????? ?? ????? ??????? ???? ???????? ??????.
???? ?????? ??????? ???? ????? ??? ???????? ??????? ??????? ??? ??????? '???????? ?????? ??????' ?? ??????? ???????? ???? ???????? ????? ????? ?????? ??????? ???????? ????? ?? ??????? ???????? ???????. ?????? ?????? ??????? ???? ???? ??????? ???????:
  1. ?? ?????? Microsoft Excel.
  2. ???? ?????? ALT+F11 ???? ????? ???? Visual Basic.
  3. ?? ??????? Insert (?????)? ???? ??? Module (???? ?????).
  4. ???? ????????? ???????? ??????? ?? ?????? ??????? ???????:
    Function Yearly_Rate(PV As Double, R As Double, N As Double) As Double
     
        Yearly_Rate = PV*(1+R)^N    '????? ????
     
    End Function
    					
???????? ?????? ???????? ???? ??????? ???????:
  1. ???? ????? ??????? ?? ???? ?????:
           ??????         ??????
           --------------
           A1             1000.00
           A2             0.08
           A3             3.00
    						
    ???? ??? ????? ?? ???:

    • A1: ?????? ??????? ?????????
    • A2: ???? ???????
    • A3: ??? ????? ?????????
  2. ?? ?? ???? ?????? ???? ?????? ???????
    =Yearly_Rate(A1,A2,A3)
    ??? ???? A1? ?A2? ?A3 ?? ??????? ???? ????? ??? ?????? ???????? ????? ???????? ???? ????? ????????? ????????.
???? ?????? ???? ???? ???? ??????: $1,259.71. ??? ?? ???? ????????? ?????? ?? 1000.00 ????? ??? ???????? ??? ???? ????? ??????? ????? 8 ?? ?????? ?????? ?????.

?????

"Cost Accounting-A Managerial Approach," Charles T. Horgren, Prentice- Hall,Inc., ??????? ??????, ??????? 906-907

???????

???? ???????: 141695 - ????? ??? ??????: 13/????? ???????/1433 - ??????: 3.0
????? ???
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
????? ??????: 
kbhowto kbinfo KB141695

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

 

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