Other worksheets - PowerPoint PPT Presentation

1 / 38
About This Presentation
Title:

Other worksheets

Description:

Other worksheets Other worksheets % ( percent change ... – PowerPoint PPT presentation

Number of Views:104
Avg rating:3.0/5.0
Slides: 39
Provided by: PinkF
Category:
Tags: worksheets

less

Transcript and Presenter's Notes

Title: Other worksheets


1
Other worksheets
2
Other worksheets ????????????
  • ?????????????? ( percent change )
  • ???????????????????????????????????????????????
    (nominal rate and annual effective rate )
  • Date
  • Profit margin
  • Break even
  • Memory

3
???????????????????????????? change
  • ?????? ?????? ??????????? OLD
    ????????? ?? ??????
  • ?? ??????????? NEW ??????????? ??????
  • ?? ??????????? CH ???????????
    ??????
  • ?? ??????????? PD ???????????
    ??????

2nd
ENTER
CPT
CPT
ENTER
ENTER
CPT
ENTER
CPT
4
??????? clear ???????? change
  • 1. ?? ?????? CLR WORK
  • 2. ??
  • ????????????????????????????????? clear work
    ?????????????????

2nd
ENTER
5
??????????????????????
OLD ?????????? / ?????? / present value
NEW ?????????? / ??????? / future value
CH ????????????????????????????????????????????????? ???????????????????
PD ????????????? ( ???????????set PD1 )

6
???????????????
  • ??????????????????????????????? 2004 ??????? 658
    ??????? ??????????????????????????????? 700
    ??????? ??????????????????????????????????????????
    ??????????
  • ??????
  • 1. ?? ?????? ???????????? OLD
    ??????
  • 2. ?? 658 ??????
  • 3. ?? ???????????? NEW?????? 700 ??

2nd
ENTER
ENTER
7
???????????????
  • ?????? ( ??? )
  • 4. ?? ??????????? CH ??????
  • 5. ???????????? ??? 6.38

CPT
8
???????????????
  • 2. ???????????? ??????????????????????????????????
    ?????? 7 ???????????????????????????????????
    ?????????????????????????
  • ??????
  • 1. ?? ?????? ???????????? OLD
    ??????
  • 2. ?? 658 ??????
  • 3. ?? 2 ????? ??????????? CH ?????? 7 ?? /-
  • ??
  • 4. ?? ??????????? NEW ?????
  • 5. ???????? ??? 611.64 ???????

2nd
ENTER
ENTER
CPT
9
???????????????
  • 3. ???????????????????????? A ?????? 2000
    ????????????????? 500 ??? ???????? 5
    ?????????????????????????????? 750 ???
    ???????????????????????
  • ??????
  • 1. ?? ?????? ???????????? OLD
    ??????
  • 2. ??????????????? 500 ??????
  • 3. ?? ????????????? ????????? 500 ??????

2nd
ENTER
ENTER
10
???????????????
  • ?????? ( ??? )
  • 4. ?? 2 ????? ??????? PD ?????? 5 ??
  • 5. ?? ??????? CH ?????????
  • 6. ?????????? ??? 8.45

ENTER
CPT
11
???????????????
  • 4. ?????????????????????? 1 ?????????? 100 ???
    ????????????????? 125 ??? ????????????????????????
    ?????????????
  • ??????
  • 1. ?? ?????? ???????????? OLD
    ??????
  • 2. ?? 100 ??????
  • 3. ?? ??????? NEW ?????? 125 ??
  • 4. ?? ??????? CH ??????
    ????????????????? 25

2nd
ENTER
ENTER
CPT
12
?????????????????
  • Nominal rate ???? annual percentage rate ???
    ?????????????????????????
  • Annual effective rate ??? ????????????????????????
    ?????????????????????????????????

13
?????????????????????????
  • ?????? ?????? ICONV ??????????? NOM
    ????????? ?? ???? ??
  • 2. ?? ??????????? EFF ????????? ??
    ??????
  • 3. ?? ??????????? C/Y ????????? ??
    ??????
  • ??????????? NOM ???? ??? EFF ???????????????????
    ??????

2nd
ENTER
CPT
ENTER
CPT
ENTER
CPT
14
??????? clear ????????
  • ?? ?????? CLR WORK
  • ??

2nd
ENTER
15
???????????????
  • ?????????????????????????????????????????????????
    15 ????????????????????????????
    ???????????????????????????? (effective annual
    rate)
  • ??????
  • 1. ?? ICONV ??????? NOM
  • 2. ?? 15 ??????
  • 3. ?? 2 ????? ??????? C/Y
  • 4. ?? 4 ??????
  • 5. ?? ??????? EFF ??????
    ?????????????????
  • 15.87

2nd
ENTER
ENTER
CPT
16
Date Worksheet
  • ??????????????????????????????????
  • ?????????????????????????????????????
    ??????????????????????????????????????????????
  • ??????? Date Worksheet ????????? 2 nd
    ??????????? DATE
  • ??????? ??????????????? ???????? ????
  • ??????????????????????? (ACT and 360)
    ???????????? 2 nd ??????????? SET
    ??????????????????????????

17
??????????? Date Worksheet
18
??? Reset ??????????? Date Worksheet
  • Reset ???????????????????????????? ?
    ???????????????????? ?????????? format
    ????????????????? Date Worksheet ????????? 2 nd
    ??????? RESET ??????????? ENTER

19
??? Reset ??????????? Date Worksheet
  • Clear ??????????? Date Worksheet ??? reset
    ??????????????????? ??????????????????????????????
    ??????? ????????? 2 nd ??????????? CLR WORK
    ???????????? Date worksheet

20
???????????????
  • ???????????????????? DT1 ??????????? DT2
  • ???????????? ?????? DT1 ??? DT2 ????? format
    ?????????????????? US ???? European
  • ??????????????????? DT1 ???? DT2
    ???????????????????????????????? 3 ???
    ?????????????????? (?????????????? WED)

21
?????????????????????????????????????????????
  • ?????????????? ACT ??????????????????????
    ??????????????????????????????????????????????????
    ?????????? ??????????????????????????????????????
    ????? ?? 29 ???
  • ?????????? 360 ??????????????????????
    ?????????????????????? ?? 30 ??????????? (360
    ????????) ??????????? DBD ???????????????????????
    ? ????????? DT1 ???? DT2

22
????????????????
  • 1. ????? Date Worksheet ????????? 2 nd
    ??????????? DATE
  • ??? DT1 ?????????????
  • 2. Clear worksheet ????????? 2 nd ???????????
    CLR WORK
  • 3. ????????????????? 2 ?? 3 ??? DT1 , DT2
    ??? DBD
  • Note ????????????????????????????
  • 4. ???????????? ????????? ????
    ????????????????????

23
????????????????
  • 5. Key ?????? ?????????? ENTER
  • 6. ???????????????????????????????????
    ????????? ?????? ACT ???? 360
    ?????????????
  • 7. ??????????????????????????? ?????????
    ???? ?????????????????? ????????????? CPT
    ????????????????????????????? ?????

24
???????????????????????????????????????
  • ??????????????? 4 ??????? 2003
    ??????????????????????????????????? 1 ?????????
    2003 ????????????????????????????????????????????
    ???????????????????????

25
Profit Margin Worksheet
  • Profit Margin Worksheet ???????? cost, selling
    price ??? gross profit margin
  • Note ???????????? Markup ?????? Percent
    Change / Compound Interest Worksheet
  • ??????? Profit Margin Worksheet ????????? 2 nd
    ???????????PROFIT
  • ????????????? profit margin ????? ????
  • ?????????????????????? 2 ??? ????????????????????
    ?????????????

26
??????????? Profit Margin Worksheet
  • Note ????????????????????????????????????????
    ???????

27
Gross Profit Margin and Mark up
  • ????? margin ??? markup ???????????????????????
    ???????????????????????????????????
  • Gross Profit Margin ??? ????????????? selling
    price ??? cost ???????? ?????????????? selling
    price
  • Markup ??? ????????????? selling price ???
    cost ???????? ?????????????? cost

28
??? Clear ??????????? Profit Margin Worksheet
  • Clear ??????????? Profit Margin Worksheet ???
    reset ??????????????????? ????????? 2 nd
    ??????????? CLR WORK ????????????????? Profit
    Margin Worksheet ?????????? 0
  • Reset ???????????????????????????? ?
    ???????????????????? ?????????? format
    ????????????????? Profit Margin Worksheet
    ????????? 2 nd ??????? RESET ???????????
    ENTER

29
???????? Profit Margin
  • ????? Profit Margin worksheet ?? 2nd PROFIT
    ??? CST ?????????
  • 2. ????????????????????????? 1 ????? ? ???? ?
    ?????????? ?????? ??????????? ?? ENTER
  • 3. ????????????????????? 2 ?????????????????? 2
  • 4 ???????????????????????????????????? ?? ? ????
    ? ?????????????????????????? ????? CPT

30
???????? Profit Margin
  • ???????? ?????????????? 125 ??????????????????
    20 ??????????????????

?? ??????
????? Profit Margin worksheet 2 nd PROFIT CST 0.00
?????????? ? 125 ENTER SEL 125.00
??? Profit margin ? 20 ENTER MAR 20.00
??????????? ? ? CPT CST 100.00
31
???????? Breakeven Worksheet
  • ?????????????????????? ??????????????????????????
    ????????????????????????????????????????????? ,
    ???????????????????? ,
  • ?????? , ???? ???????
  • ??????????????????????????? ??????????????????????
    ???????????????? ????????????? ?????????
    ?????????

32
???????? Breakeven Worksheet
  • ???????????? Breakeven Worksheet ????? 2nd
    BRKEVN
  • ?????????????? ?? ? ???? ?
  • ??????????????????? 4 ??? ???????????????? 5
    ???????????????

?? ??????
??????????? 2nd BRKEVN FC ENTER / COMPUTE
???????????????????? ? VC ENTER / COMPUTE
???????????? ? P ENTER / COMPUTE
???? ? PFT ENTER / COMPUTE
?????? ? Q ENTER / COMPUTE
33
???????? Breakeven Worksheet
  • ??? Reset ?????????????? Breakeven Worksheet
  • ?????? Reset ????????????????????? 2nd CLR
    WORK ??????????????????????????? 0
  • ?????????? ???????????????????????? ?? 2nd
    RESET Enter

34
???????? Breakeven Worksheet
  • ???????????????
  • ???????????? Breakeven Worksheet ????? 2nd
    BRKEVN
  • ?? ? ???? ? ??????????????????? ?????? ENTER
  • ??????????????? 2 ???????????????????????
  • ??????????????????????????????? ? ???? ? ??????
    CPT

35
???????? Breakeven Worksheet
  • ???????? ????????????????????????????????? 20
    ??????????????????????????? 15
    ????????????????????? 3,000 ?????????????????????
    ??????????

?? ??????
???????????? Breakeven Worksheet 2nd BRKEVN FC 0.00
??? ??????????? 3,000 ENTER FC 3,000.00
??????????????????????? ? 15 ENTER VC 15.00
??????? ? 20 ENTER P 20.00
????????????????? ? PFT 0.00
??????????? ? CPT Q 600.00
36
Memory Worksheet
  • Memory Worksheet ???????????????????????????????
    ??????????????????????????????????? 10 ??????
  • ???????????? Memory Worksheet 2nd MEM
  • ???????????????? ?? ? ???? ?
  • ????? Memory Worksheet ???? 10 ?????? ??
  • 2nd CLR WORK

37
Memory Worksheet
  • ?????????????
  • ???????????? Memory Worksheet 2nd MEM
  • M0 ???????
  • 2. ???????????????????? ???????????????????????
    ( M0-M9 ) ????????? ????? ENTER

38
Memory Worksheet
  • ??????????????

?? ??????
???????Memory worksheet 2nd MEM M0 0.00
????? M4 ? ? ? ? M4 0.00
???????? M4 0 ENTER M4 0.00
?????? 95 9 5 ENTER M4 95.00
??? 65 6 5 ENTER M4 160.00
?? 30 - 3 0 ENTER M4 130.00
??????? 95 9 5 ENTER M4 12,350.00
??????? 65 6 5 ENTER M4 190.00
??????? 2 y ENTER M4 36,100.00
Write a Comment
User Comments (0)
About PowerShow.com