Free ACCA & CIMA online courses from OpenTuition
Free Notes, Lectures, Tests and Forums for ACCA and CIMA exams
Congratulations to Jamil from Pakistan and Jeeva from Malaysia - Global Prize winners!see all ACCA December 2022 Genius Hunt Competition winners >>
Specially for OpenTuition students: 20% off BPP Books for ACCA & CIMA exams – Get your BPP Discount Code >>
December 4, 2022 at 12:29 pm
For Dec-22 exam we can apply the IRR formula* (in the CBE platform). For that we need the cash flows for each year separately. Please confirm my understanding below: cell A1: Year 0 = -105 cell A2: Year 1 = 7 cell A3: Year 2 = 7 cell A4: Year 3 = 7 cell A5: Year 4 = 7 cell A6: Year 5 = 7 cell A7: Year 6 = 117 IRR = (A1:A7,10%) = 7.33%
Since this value differs from the IRR calculated in the video above (7.51%), my question is: will the answer (7.33%) be considered correct?
Thank you for your time!
*Note (this is taken from the ‘Help/Formulae Sheet’ in the CBE platform): IRR formula = IRR (values, [guess]). Where: “values” is the range of cash flows for which you want the internal rate of return; and “guess” is a rate you think is close to the result of the IRR given as a decimal. E.g.: = IRR(B15:F15,0.12) >> calculates the internal rate of return of cells B15-F15 using 0.12 as an estimate, with B15 being Year 0.
December 4, 2022 at 12:34 pm
My question is related to Ex. 10 in the video above.
John Moffat says
December 4, 2022 at 3:43 pm
Yes, your answer will be marked as correct. (As I do make clear in the lecture, using two guesses only ever gives an approximation to the IRR which is perfectly acceptable.)
August 15, 2022 at 11:48 am
Hi Mr. John,
Wonderful lecture, everything was clearly explained however I do have (trivial?) a doubt.
Since my exam attempt is Computer Based (CBE) and not paper-based, Excel is provided to show the relevant calculations. The calculation of IRR in excel is quite simple and takes very little time as compared to paper based but there’s usually a difference between the IRR calculated by excel and the IRR calculated by trial and error method. Will such a difference affect my marks? In example 10, IRR calculated by excel is 6% instead of 7.51% and the resulting WACC is 13.31% instead of 13.56%. I know its a minor difference but will it affect the marking?
Thanks again for the superb lectures.
August 15, 2022 at 7:54 pm
Thank you for the comment.
The answer using the spreadsheet it more accurate than making two guesses 🙂 However do it whichever way you prefer – the fact that they answers are slightly different is irrelevant for the marking.
December 26, 2020 at 2:08 am
I have a question for calculating IRR. Do we have to use the guessing approach illustrated in the video? Since many financial calculators (e.g. Texas Instruments BA II Plus) can calculate IRR directly, can we use these calculators instead?
Thanks in advance.
December 26, 2020 at 9:21 am
You can only use calculators that do not display any text (they must only display numbers).
October 26, 2020 at 5:49 pm
Hello, I have a question on calculating the IRR. When we choose discount factor in example 10, we take 10% and 5%. Is that just random? I have taken 10% and 15% when calculating and got Kd as 6.63% and overall WACC as 13.41%, so slightly different answers. Just wondering if this is wrong. Thank you.
May 26, 2020 at 6:31 am
are we given formula sheets in the exam?
May 26, 2020 at 10:57 am
Yes. A copy of the sheet given in exam is printed in our free lecture notes.
May 22, 2020 at 3:35 pm
Can you please clarify why the cost of equity is higher than the cost of debt?
May 23, 2020 at 2:58 am
Equity capital reflects ownership while debt capital reflects an obligation. Typically, the cost of equity exceeds the cost of debt. The risk to shareholders is greater than to lenders since payment on a debt is required by law regardless of a company’s profit margins.
are there other reasons?
May 23, 2020 at 9:59 am
Equity is more risky for investors because dividends fluctuate with profits whereas the interest income from debt is constant. The more dividends fluctuate, the greater the beta and the greater the required return and therefore the greater the cost of equity to the company.
In addition the payment of interest on debt is tax allowable to the company whereas dividends are not tax allowable, which makes the cost of debt even lower.
July 28, 2022 at 6:04 am
Because the investors for equity holders bear the highest risk, so say when a company is liquidated the ordinary shareholders are the last ones to paid if any residual value remains, however, the debt holders are always paid first. Hence, the cost of equity is always higher than debt.
Hope this clarifies and John hope I am correct in my understanding.
July 28, 2022 at 8:34 am
It is a factor, but the main reasons are as I typed out in my previous reply.
January 27, 2019 at 9:32 am
When calculating IRR of a redeemable debt we assume that interest return is allowed for the income tax, whereas the redemption of the debt – is not allowed in the full sum.
But the cash flows can be changed: the debt issuer can pay less as interest and include much in the redemption (is it possible?)
So do not we need to take the exsess = redemption – market_or_nominal_value for the tax allowance also?
January 27, 2019 at 10:10 am
Your first two sentences are both correct (for the calculation of the cost of debt).
However, regardless of what coupon rate to offer on the debt and what premium to offer on redemption, the tax rules remain the same and the calculation of the cost of debt follows the same rules.
(The return required by the investors is the IRR of the pre-tax flows, and that will be the same however the interest and redemption are structured. However the cost to the company is the IRR of the post-tax flows, and that will be different.)
July 9, 2018 at 9:51 pm
Thanks for your feedback. I just want to have a final clarification.
Lets say for example 10, I will revise the original question to give cost of debt instead of market price first. The question will give me 6M 10% debenture that are redeemable in 6 years time at a premium of 10%. It gives me the risk free rate at 7% and credit spread 3.7% (which mean the cost of debt to company is 10.7% * 0.7 = 7.5% as in original question). Annuity for 6 years at 10.7% = 4.267
With this revised question, as you said, I will have to take pre-tax cash flow discounted at pre-tax cost of debt of 10.7% to find market price of debt = 10 * 4.267 + 110/1.107^6 = 102.4
The new market price is different from original market price of 105 in original question. I am not sure if it is because of rounding, or whether my understanding is incorrect here? If I have taken after-tax cash flow discounted at after tax cost of debt, then I should get 105 as in original question. Hope you can help clarify my doubt
July 10, 2018 at 6:25 am
The problem is that with redeemable debentures the cost of debt is not Kd(1-t) (which is what you have assumed). That is only the case with irredeemable debentures. I explain this in the lectures.
September 28, 2020 at 2:18 am
Hi John ,
I just have small confusion about what you said about redeemable debentures , cost of debt is Kd and Kd(1-t) for irredeemable however in qtn 9 where the debt was irredeemable , how comes we didn’t use Kd(1-t)
September 28, 2020 at 8:24 am
But we used Int(1-t)/MV, which is exactly the same as Kd(1-t).
January 20, 2021 at 7:57 pm
Can you please give a bit more clarification on the use of (1-T) for both types for debt?
As far as I understand, we use the (1-T) part of the formula with irredeemable debt as the whole debt is tax allowable – as there’s not repayment. On the other hand, we do not use the (1-T) with the redeemable debt as we have already allow for the tax when calculating the IRR and if we use it would be duplicated?
July 9, 2018 at 1:03 am
For example 10, what will happen if we are not given the ex-int price of the debenture, but we are given the risk free rate 11% and credit spread of the company at 1.5% instead?
We will have to calculate the market value of the debenture in such case. However I dont know if we have to use pre-tax cash flow discounted at pre-tax cost of debt or we have to use after-tax cash flow discounted at after-tax cost of debt. According to your previous lecture, we must use after-tax cash flow for redeemable debt.
July 9, 2018 at 6:39 am
The cost of debt is calculated using the after-tax flows.
However the market value of debt is determined by the investors and therefore is the pre-tax flows discounted at their required return, which is the pre-tax cost of debt. The investors are not affected by company tax – only the company is affected.
July 9, 2018 at 8:33 am
Thanks for your quick reply. I would like to clarify on this a bit. When we are calculating the cost of debt using after-tax cash flows, we are effectively using the market value of the debt (ex-interest price) given in the question as well? Then why does the reverse is not correct, using after-tax cash flow to calculate market value of debt?
July 9, 2018 at 4:02 pm
The market value is determined by the investors and is based therefore on the pre-tax flows.
The cost of debt is the cost to the company and is therefore based on the after-tax flows.
The market value (fixed by the investors) is the amount that the company raises and on which they have to be interest but get tax relief.
You must be logged in to post a comment.