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 🙂