Hi - I am calculating the cost of debt using the IRR formula. If I use the normal formula per the formula sheet provided is ok. I was wondering if in order to speed up things at the exam it would be possible to use the new spreadsheet function IRR(X1:X5,rate).
I can't make it work though, is it impossible to use in this case?
Thanks and regards,
A.
Ask the Tutor ACCA AFM
Kingtim Co (BPP mock exam 2)
actually the formula is not there but it doesn't change the question. Can the Kd be calculated with the spreadsheet function apologies for the confusion
3y ago#2You certainly can use the spreadsheet function (and should do because it obviously saves time).
The last chapter of our free lecture notes has links to the resources on the ACCA website that list all of the spreadsheet functions available.
Sign into reply to this topic.