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,
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