• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Free ACCA & CIMA online courses from OpenTuition

Free ACCA & CIMA online courses from OpenTuition

Free Notes, Lectures, Tests and Forums for ACCA and CIMA exams

  • ACCA
  • CIMA
  • FIA
  • OBU
  • Books
  • Forums
  • Ask AI
  • Search
  • Register
  • Login
  • ACCA Forums
  • Ask ACCA Tutor
  • CIMA Forums
  • Ask CIMA Tutor
  • FIA
  • OBU
  • Buy/Sell Books
  • All Forums
  • Latest Topics

20% off ACCA & CIMA Books

OpenTuition recommends the new interactive BPP books for September 2025 exams.
Get your discount code >>

Entering e^(-rt) in the excel

Forums › ACCA Forums › ACCA AFM Advanced Financial Management Forums › Entering e^(-rt) in the excel

  • This topic has 4 replies, 3 voices, and was last updated 4 years ago by John Moffat.
Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • August 17, 2020 at 9:31 pm #580959
    daivaa
    Member
    • Topics: 8
    • Replies: 6
    • ☆

    Hello, when multiplying of Pe by e^(-rt) in the formula is ” e ” needed to be entered manually as 2.8173. I can not work out whether there was alternative way to do it.

    Thank you,
    Dee

    August 19, 2020 at 3:04 pm #581199
    CraigLivesey
    Member
    • Topics: 6
    • Replies: 3
    • ☆

    In excel “e” is the function “=EXP()” which is read as the exponential function. In most formulas you see denoted as simply “e”. Inside the brackets is where the power number will be used.

    whether or not this is in CBE excel version, I am unaware of at this time.

    August 19, 2020 at 3:12 pm #581201
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54693
    • ☆☆☆☆☆

    The function is available.

    You can find out what functions are available if you download the “CBE Guidance Document” linked from this page on the ACCA website:

    https://www.accaglobal.com/gb/en/student/exam-support-resources/professional-exams-study-resources/p4/cbe-preparation.html

    August 23, 2020 at 6:58 am #581571
    daivaa
    Member
    • Topics: 8
    • Replies: 6
    • ☆

    Thank you very much for your response.
    D

    August 23, 2020 at 10:02 am #581596
    John Moffat
    Keymaster
    • Topics: 57
    • Replies: 54693
    • ☆☆☆☆☆

    You are welcome 🙂

  • Author
    Posts
Viewing 5 posts - 1 through 5 (of 5 total)
  • The topic ‘Entering e^(-rt) in the excel’ is closed to new replies.

Primary Sidebar

Donate
If you have benefited from our materials, please donate

ACCA News:

ACCA My Exam Performance for non-variant

Applied Skills exams is available NOW

ACCA Options:  “Read the Mind of the Marker” articles

Subscribe to ACCA’s Student Accountant Direct

ACCA CBE 2025 Exams

How was your exam, and what was the exam result?

BT CBE exam was.. | MA CBE exam was..
FA CBE exam was.. | LW CBE exam was..

Donate

If you have benefited from OpenTuition please donate.

PQ Magazine

Latest Comments

  • alexgriff10 on Objectives of organisations – ACCA (AFM) lectures
  • MidnightWolfie on Operating segments (IFRS 8) – ACCA (SBR) lectures
  • John Moffat on Investment Appraisal Under Uncertainty: Expected Values (example 2) – ACCA Financial Management (FM)
  • Dinomain on Investment Appraisal Under Uncertainty: Expected Values (example 2) – ACCA Financial Management (FM)
  • hoangacca on Cost Classification and Behaviour part 2 – ACCA Management Accounting (MA)

Copyright © 2025 · Support · Contact · Advertising · OpenLicense · About · Sitemap · Comments · Log in