ログイン

Excel Accounting Formulas
8問 • 1年前
  • Shan Chai Mae Amatus
  • 通報

    問題一覧

  • 1

    What is the formula of the Straight-line method?

    SLN(cost, salvage value, life)

  • 2

    What is the formula to get the Sum of Year's Digit?

    SYD(cost, salvage value, life, period)

  • 3

    What is the formula to get the Declining Balance?

    DB(cost, salvage value, life, period, [month])

  • 4

    What is the formula to get the Double Declining Balance?

    DDB(cost, salvage value, life, period, [factor])

  • 5

    What is the formula to get the Internal Rate of Return?

    IRR(values, [guess])

  • 6

    What is the formula to get the Present Value?

    PV(rate, nper, pmt, fv, type)

  • 7

    What is the formula to get the Future Value?

    FV(rate, nper, pmt, [pv], [type])

  • 8

    The type consists of the following:

    0-end of the period, 1-beginning of the period

  • Strategic Cost Management

    Strategic Cost Management

    Shan Chai Mae Amatus · 60問 · 1年前

    Strategic Cost Management

    Strategic Cost Management

    60問 • 1年前
    Shan Chai Mae Amatus

    AIS-Lecture 1

    AIS-Lecture 1

    Shan Chai Mae Amatus · 37問 · 1年前

    AIS-Lecture 1

    AIS-Lecture 1

    37問 • 1年前
    Shan Chai Mae Amatus

    AIS-Lecture 2

    AIS-Lecture 2

    Shan Chai Mae Amatus · 13問 · 1年前

    AIS-Lecture 2

    AIS-Lecture 2

    13問 • 1年前
    Shan Chai Mae Amatus

    AIS-Lecture 3

    AIS-Lecture 3

    Shan Chai Mae Amatus · 15問 · 1年前

    AIS-Lecture 3

    AIS-Lecture 3

    15問 • 1年前
    Shan Chai Mae Amatus

    AIS-Lecture 4

    AIS-Lecture 4

    Shan Chai Mae Amatus · 11問 · 1年前

    AIS-Lecture 4

    AIS-Lecture 4

    11問 • 1年前
    Shan Chai Mae Amatus

    PurComm (Lesson 2)

    PurComm (Lesson 2)

    Shan Chai Mae Amatus · 39問 · 1年前

    PurComm (Lesson 2)

    PurComm (Lesson 2)

    39問 • 1年前
    Shan Chai Mae Amatus

    PurComm (Lesson 3)

    PurComm (Lesson 3)

    Shan Chai Mae Amatus · 16問 · 1年前

    PurComm (Lesson 3)

    PurComm (Lesson 3)

    16問 • 1年前
    Shan Chai Mae Amatus

    PurComm (Lesson 4)

    PurComm (Lesson 4)

    Shan Chai Mae Amatus · 8問 · 1年前

    PurComm (Lesson 4)

    PurComm (Lesson 4)

    8問 • 1年前
    Shan Chai Mae Amatus

    STS (Lesson 1)

    STS (Lesson 1)

    Shan Chai Mae Amatus · 15問 · 1年前

    STS (Lesson 1)

    STS (Lesson 1)

    15問 • 1年前
    Shan Chai Mae Amatus

    STS (Lesson 2)

    STS (Lesson 2)

    Shan Chai Mae Amatus · 26問 · 1年前

    STS (Lesson 2)

    STS (Lesson 2)

    26問 • 1年前
    Shan Chai Mae Amatus

    STS (Lesson 2, Part 2)

    STS (Lesson 2, Part 2)

    Shan Chai Mae Amatus · 24問 · 1年前

    STS (Lesson 2, Part 2)

    STS (Lesson 2, Part 2)

    24問 • 1年前
    Shan Chai Mae Amatus

    STS (Lesson 3)

    STS (Lesson 3)

    Shan Chai Mae Amatus · 14問 · 1年前

    STS (Lesson 3)

    STS (Lesson 3)

    14問 • 1年前
    Shan Chai Mae Amatus

    Law-Reviewer

    Law-Reviewer

    Shan Chai Mae Amatus · 55問 · 1年前

    Law-Reviewer

    Law-Reviewer

    55問 • 1年前
    Shan Chai Mae Amatus

    問題一覧

  • 1

    What is the formula of the Straight-line method?

    SLN(cost, salvage value, life)

  • 2

    What is the formula to get the Sum of Year's Digit?

    SYD(cost, salvage value, life, period)

  • 3

    What is the formula to get the Declining Balance?

    DB(cost, salvage value, life, period, [month])

  • 4

    What is the formula to get the Double Declining Balance?

    DDB(cost, salvage value, life, period, [factor])

  • 5

    What is the formula to get the Internal Rate of Return?

    IRR(values, [guess])

  • 6

    What is the formula to get the Present Value?

    PV(rate, nper, pmt, fv, type)

  • 7

    What is the formula to get the Future Value?

    FV(rate, nper, pmt, [pv], [type])

  • 8

    The type consists of the following:

    0-end of the period, 1-beginning of the period