20% off ACCA & CIMA Books

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

Cbe

This topic has 1 reply, 2 voices, and was last updated 7 years ago by John Moffat.

Viewing 2 posts - 1 through 2 (of 2 total)

Author
Posts
March 3, 2018 at 12:56 pm #439886
noor
Member
- Topics: 1
- Replies: 12
Hello sir,
I’ve been trying to practice questions on excel. I had a doubt regarding the calculation of PV. I tried using the PV function available on excel but it’s giving me the values for annuity factor and not the present value factor. So I just multiplied the present values of each year with the cash flows. Is it alright?
March 3, 2018 at 3:59 pm #439924
John Moffat
Keymaster
- Topics: 57
- Replies: 54755
Have you been using Excel, or the spreadsheet feature in the ACCA’s specimen CBE exam (which is not Excel)?
Why not simply use the annuity factors from the tables (assuming it is an annuity) – you get provided with the tables in the exam?
Author
Posts

Viewing 2 posts - 1 through 2 (of 2 total)

The topic ‘Cbe’ is closed to new replies.