- This topic has 4 replies, 3 voices, and was last updated 4 years ago by .
Viewing 5 posts - 1 through 5 (of 5 total)
Viewing 5 posts - 1 through 5 (of 5 total)
- The topic ‘Entering e^(-rt) in the excel’ is closed to new replies.
OpenTuition recommends the new interactive BPP books for December 2024 exams.
Get your discount code >>
Forums › ACCA Forums › ACCA AFM Advanced Financial Management Forums › Entering e^(-rt) in the excel
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
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.
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:
Thank you very much for your response.
D
You are welcome 🙂