Yes! But unlikely. Suppose a project required an outflow at time 0, and then another outflow at time 1 (and then no further flows). There would be no IRR 🙂
It is important to understand the logic behind the formula rather than just learn a formula (and in Section C questions you do not need to make two guesses anyway because you can use the IRR function in the spreadsheet that is provided),
One of the sample question asks “a graph showing NPV on Y axis and interest rate on X axis will have a negative slope” surely this is true – if interest rates increase doesnt NPV go down ?
I don’t really understand what you are asking, because we do neither. We discount using two interest rates (and look up the discount factors in the tables) and then approximate between the NPV’s to get the IRR.
Hi Professor, Thank you very much for your valuable lectures. These IRR calculations and NPV calculations can be done through the calculator. (BA 2 Plus) Is it okay to use the calculator method or is it mandatory to use the table method?
That calculator is not allowed in the exam – it displays letters as well as numbers and you are not allowed calculators that have letters in the display.
Anyway, appreciate that most of the questions in the exam are designed in a way to test that you understand what you are doing – not just that you can do simple calculations 🙂
Owen26 says
Hello, can there be 0 IRR’s?
John Moffat says
Yes! But unlikely. Suppose a project required an outflow at time 0, and then another outflow at time 1 (and then no further flows). There would be no IRR 🙂
Kt-lou says
Can I do 8820/5*100=176400 6660/176400=0.03775. Would that method be accepted?
John Moffat says
No it wouldn’t. You either do as in the lecture or (more sensibly if in Section C of the exam) you use the IRR function in the spreadsheet provided.
nirunari says
Hi professor,
Does the NPV values affect the formula that you share? E.g. Is the negative figure always the denominator?
Thank you.
John Moffat says
No to both 🙂
It is important to understand the logic behind the formula rather than just learn a formula (and in Section C questions you do not need to make two guesses anyway because you can use the IRR function in the spreadsheet that is provided),
chalesakunda says
Hello
when i divide 6660 by 8820 and then multiply by 5% it is giving me 0.0378 and not 3.78, kindly advise!!!!!!!!
Yuu02 says
0.0378 = 3.78%
smashcroft says
One of the sample question asks “a graph showing NPV on Y axis and interest rate on X axis will have a negative slope” surely this is true – if interest rates increase doesnt NPV go down ?
smashcroft says
Apologies, I have found the section where you explain this, now understand how this can happen.
John Moffat says
No problem 🙂
Bernard says
Thanks for the presentation knowing another way of calculating irr is a plus
John Moffat says
You are welcome 🙂
nethraram says
it was very helpful sir. to find the discounting factor in IRR, do we divide initial investmnet / cash flow or the other way round?
John Moffat says
I don’t really understand what you are asking, because we do neither. We discount using two interest rates (and look up the discount factors in the tables) and then approximate between the NPV’s to get the IRR.
sachini1995 says
Hi Professor,
Thank you very much for your valuable lectures. These IRR calculations and NPV calculations can be done through the calculator. (BA 2 Plus) Is it okay to use the calculator method or is it mandatory to use the table method?
John Moffat says
That calculator is not allowed in the exam – it displays letters as well as numbers and you are not allowed calculators that have letters in the display.
Anyway, appreciate that most of the questions in the exam are designed in a way to test that you understand what you are doing – not just that you can do simple calculations 🙂
faith20ul19 says
Thank you John for this presentation. The approach regarding the IRR was put straight.
John Moffat says
Thank you for your comment 🙂