Hi, I am going through the review of IFRS9 and came accross an example for which I will need some guidance:
Company A invests in debt of 3million $ with 1% discount on 01.01.20x1 (so cash disbursement is 2.97million).
The Coupon rate of the debt is 5% per year , payable on 31 Dec and is itself repayable on 31 Dec 01.01.20x5 at a premium of 5 million.
Business Model : There is intention to hold the investment until its maturity and there are contractual rights to cash flows on specific dates.
Question : Is there a way to calculate the effective interest rate?
Effective Interest Rate Calculation
Re: Effective Interest Rate Calculation
what do you mean by 'is itself repayable on 31 Dec 01.01.20x5 at a premium of 5 million.'
as long as cash flows are clear, there should be no difficulties in EIR calculation:
https://ifrscommunity.com/knowledge-bas ... rest-rate/
as long as cash flows are clear, there should be no difficulties in EIR calculation:
https://ifrscommunity.com/knowledge-bas ... rest-rate/
Re: Effective Interest Rate Calculation
I just checked the Knowledge Base, very useful, thanks!
Re: Effective Interest Rate Calculation
Referring to the example in the Knowledge Base : What I would like to learn is how XIRR gets to 7.8% so I learn how to calculate it myself. Is there any guidance on this?
Re: Effective Interest Rate Calculation
it's very easy
Excel uses an iterative technique for calculating XIRR. Using a changing rate (starting with guess), XIRR cycles through the calculation until the result is accurate within 0.000001 percent. If XIRR can't find a result that works after 100 tries, the #NUM! error value is returned. The rate is changed until:
where:
di = the ith, or last, payment date.
d1 = the 0th payment date.
Pi = the ith, or last, payment.
https://support.microsoft.com/en-us/off ... 03ad9adc9d
Excel uses an iterative technique for calculating XIRR. Using a changing rate (starting with guess), XIRR cycles through the calculation until the result is accurate within 0.000001 percent. If XIRR can't find a result that works after 100 tries, the #NUM! error value is returned. The rate is changed until:
where:
di = the ith, or last, payment date.
d1 = the 0th payment date.
Pi = the ith, or last, payment.
https://support.microsoft.com/en-us/off ... 03ad9adc9d
Re: Effective Interest Rate Calculation
Thank You, I might stick to XIRR...
Re: Effective Interest Rate Calculation
ok, so seriously speaking, you should be able to find plenty of information on how to manually calculate IRR, just look it up in google