Skip to main content

AMORTISED COST CALCULATION: THE EFFECTIVE INTEREST RATE (EIR)



IAS 39 mandates some financial assets and liabilities to be subsequently measured at ‘amortized cost’.  This measurement concept is a management theory put in accounting practice. It means that the contractual interest rate each period should be adjusted to amortize the transaction costs over the expected life of the financial instrument. The amortization is calculated on an effective interest rate (EIR) / yield-to-maturity (YTM) basis. The EIR is the rate that exactly discounts the stream of principal and interest cash flows excluding any impact of credit losses, to the initial net proceeds. It is important to note that EIR method does not take into account any future credit impairments anticipated on that instrument.
The carrying amount of the financial instrument subsequently measured at amortized cost is computed as:

Transaction costs are an integral part of the amortized cost calculation. They are defined as costs that are directly attributable to the acquisition, issue or disposal of a financial instrument. Transactions costs are those that are paid to external parties, such as fees and commissions paid to agents, brokers and dealers, levies paid to regulatory agencies, stock exchanges, taxes and duties. Transaction costs may include internal costs, but such costs must be incremental in acquisition, issue or disposal of a financial instrument. Transaction costs will neither include any internal financing, holding and administrative costs nor do they include premium or discount.

Effective Interest Rate Calculation Example
A bank gives a loan to its customer as per the following terms:
Loan Amount: 100,000/-
Maturity: 5 years
Interest: 1st year – 6%, 2nd year – 8%, 3rd year – 10%, 4th year – 12% and 5th year 18%
The loan repayments are interest only each year and principal repayment at maturity.

The effective interest rate (IRR) is calculated as the rate that exactly discounts estimated future cash flows through the expected life of the instrument.

100,000 = 6000/ (1+IRR)1+ 8000/ (1+IRR)2 + 10000/ (1+IRR)3 + 12000/ (1+IRR)4 + (18000+100000)/ (1+IRR)5

Solving this equation on excel we get an IRR = 10.2626%
(Hint: In Excel to calculate EIR use the function XIRR with estimated dates of the expected future cash flows)

The amortized cost of the loan at the end of each period will be accounted as follows:
YEAR
AMORTISED COST AT THE START OF THE YEAR
 (A)
EIR
(B) = (A) * 10.2626%
CASH FLOW
 (C)
AMORTISED COST AT THE END OF THE YEAR         
   (D) = (A)+ (B) – (C)
1
100,000
10,263
6,000
104,263
2
104,263
10,700
8,000
106,963
3
106,963
10,977
10,000
107,940
4
107,940
11,077
12,000
107,017
5
107,017
10,983
118,000
0

Comments

  1. Dear,
    I feel proud of you...

    Attention!
    I cannot understand how you calculate Effective Interest Rate using excel. Please help me... I am in a very begining stage...

    ReplyDelete
    Replies
    1. Thanks very much..At the moment can just suggest to work on excel. But please make sure you are working on fixed interest rate examples! This does'nt work for Floating (Variable) rate loans..
      Take care
      Pooja

      Delete
  2. I love the way you write and share your niche! Very interesting and different! Keep it coming! cpa network

    ReplyDelete
  3. What if Loan is given on following terms -
    Interest will accrue at fix rate on outstanding balance of principal
    Firstly Principal will be recovered in 20 installments
    Interest will keep accruing till principal is paid on diminishing balance of principal
    Once principal is repaid Accrued Interest will be recovered in fixed installment..

    Whats your suggestion .

    ReplyDelete
    Replies
    1. Hello SECL Corporate Accounts!
      As long as cashflows can be estimated and interest rate is fixed the calculation for EIR remains the same.
      Thanks..

      Delete
    2. I have a question. If Company X has bought the debtors of Company Y which amounted to 100,000 pounds on Company Y's Balance sheet for 30,000 pounds. How would the accounting for this will be done??

      Delete
  4. Hi Pooja, Thanks for putting up this helpful blog.
    Well, I want to understand how should be take care of the upfront fees which is being charged by lenders to the customers (such as arrangement fees, management fees, etc.) while computing the EIR. Also, it would be great if you could explain in easy terms (just like above) the calculation of EIR for floating rate instruments.

    ReplyDelete
  5. Hello Vivek!
    If the upfront fees is directly incremental in getting the transaction to the books then such upfront fees is interest and becomes a part of EIR (deducted from the cashflow received from lender on transaction day) and then EIR calculated..
    For, EIR on floating rate instruments - as per Ind AS floating rates are EIR and hence no calculation is required to be done.
    Pooja

    ReplyDelete
  6. Hello Pooja

    I want to know whether we need to calculate EIR for borrowings which carries floating rate of interest?

    ReplyDelete
  7. Hello Pooja

    I want to know whether we need to calculate EIR for borrowings which carries floating rate of interest?

    ReplyDelete
    Replies
    1. Hello Preksha,
      Please read my latest article at the blog in September-2016 on EIR of Floating Rate Instruments.

      Thanks
      P

      Delete
  8. Hi Pooja,

    Would like to know whether XIRR function works same if the repayment terms for Principle and interest are monthly

    ReplyDelete
  9. Hi Pooja,

    I want to know, whether the XIRR function would hold good, even when the repayment terms for Principle and Interest are monthly.

    ReplyDelete
    Replies
    1. Hello Rajat,
      Yes XIRR holds good for monthly rest repayments!
      Thanks
      Pooja

      Delete
  10. Hi,
    I want to know the accounting entries for principal and interest in the above example. Thanks

    ReplyDelete
  11. Hi,
    Please I want to know the accounting entries for interest and amortised cost in the above example. Thanks a lot.

    ReplyDelete
  12. Hello Josephine,
    In the Bank Books:
    Txn Date: Loan given Dr..100,000
    Bank a/c Cr 100,000

    Interest receipt: Bank Dr .. 6,000
    (Year 1) Loan given Dr .. 4,263
    Interest income Cr .. 10,263

    Similar entries will be passed till year 5!!
    Thanks
    Pooja

    ReplyDelete
  13. Hello,

    Do we need to calculate effective interest in case of overdraft taken from bank?

    ReplyDelete
    Replies
    1. In the Indian scenario, the rate given by the bank is EIR for the customer!

      Delete
  14. This comment has been removed by a blog administrator.

    ReplyDelete
  15. Hi If we don't know the mature date. How we can calculate this. Do we need to calculate EIR or just interest accrual

    ReplyDelete
    Replies
    1. Hello Chank,
      EIR to be calculated like perpetual instruments..

      Best,
      Pooja

      Delete
  16. Hi,
    Whether underwriting commission will form part of transaction cost for EIR purpose. Earlier commission was capitalized in 2013-14. Thnx...

    ReplyDelete
    Replies
    1. Hi Ashish,
      Underwriting commission will form part of EIR.

      Best,
      Pooja

      Delete
  17. Hi Pooja,
    I have the following queries:

    1) How do we compute the EIR for non maturity products Ex: Overdrafts, Credit Cards? (If we have a single line cash flow after assuming the draw down and maturity in 1 year.)

    2) We have some commitments/ undrawn portion attached with loans.How do we compute the EIR for such accounts? Do we need to get the cash flows for such undrawn amount/commitment in our cash flow as per bank's assumption/policy for EIR calculation or we can use the same EIR applicable to loans for such commitments/ undrawn portion.

    3) We adjust the upfront fee with the principal amount for calculation of EIR. What if, the bank is receiving fee along with each cash flow on each cash flow date? Can we reduce the cash flow amount by fee and compute EIR?

    4) EIR for variable interest rate instruments: As per IFRS 9 guidelines, can we take current floating rate as EIR for variable rate instruments?

    Please help.

    Regards
    Shivam

    ReplyDelete
    Replies
    1. Hi Shivam,

      You have a long list of queries. I suggest let's chat one on one to discuss specific product related accounting treatment!

      Regards,
      Pooja

      Delete
  18. This comment has been removed by a blog administrator.

    ReplyDelete
  19. This comment has been removed by a blog administrator.

    ReplyDelete
  20. This comment has been removed by a blog administrator.

    ReplyDelete
  21. This comment has been removed by a blog administrator.

    ReplyDelete
  22. Hi Pooja
    Accrued Interest paid at the time of Purchase of Securities will form of transaction cost for EIR purpose

    ReplyDelete
    Replies
    1. No Rahul.. Accrued interest will not be a part of the transaction cost.

      Regards,
      Pooja

      Delete
  23. What if the interest remain same over a period of the loan? Whether the EIR will change? or it will be the interest rate itself?

    ReplyDelete
  24. Suppose Company X buys debtors of Company Y, which amounted to 100,000 pounds on Company Y's Balance sheet, for 30,000 pound. How will the transaction be recorded in the books of Company X? Also once Company X starts to recover money from these debtors, how would the accounting be recorded?

    ReplyDelete
  25. Hi Pooja,
    Having a doubt in EIR working,
    In my interst working, the difference between the interest as per EIR and actual interest should amount to the processing fees right?
    We haven't taken Discounting/PV factor in to consideration, So is the PV factor required compulsory for the EIR working?
    Kindly guide me on my above query

    Thanks

    ReplyDelete
  26. hello Ma'am,
    having a doubt in EIR working

    ReplyDelete
  27. Hello Ma'am,
    Myself having a doubt in EIR working and the difference between Interest as per EIR and Actual Interest should amount to the value of Processing Fees right?
    But in my case it is not tallying with the amount of the fees and I haven't taken PV factor in to consideration.
    So is PV/Discounting factor must for EIR working?

    thanks

    ReplyDelete
    Replies
    1. Hi Hardik,

      Can you email me the exact query with numbers!

      cheers,
      Pooja

      Delete



  28. Hello Pooja g,

    I am Rakesh Verma from himachal pradesh. i want to solve this question . please help me regarding that. Question are under given below :-

    On 1 January 2014, a company buys £50,000 of 7% loan stock for £47,865. Interest is received
    on 31 December each year and the stock will be redeemed at a premium of 10% on 31
    December 2017. The effective interest rate is 10.5% per annum. Calculate the amortised cost of
    the loan stock at 31 December 2014.

    please e-mail me at rakeshvermajinja@gmail.com or What up numaber +256717002333

    Awaiting your reply.
    Reply must, pls.


    ReplyDelete
  29. Hi Pooja

    I have sold my Flat which was under construction recently after 4 yrs .As i know Long term capital gain wud be aplicable in my scenario .Pls let me know apart from Indexed value the Home loan interest accrued under Home Loan can be claimed under cost of acqusition for 4 yrs ? Pls note i have not availed any Home Loan intrest benefits under 24(b) since the property was under construction

    ReplyDelete
  30. Hi

    1) How do we compute the EIR for non maturity products Ex: Overdrafts, Credit Cards? (If we have a single line cash flow after assuming the draw down and maturity in 1 year.)

    ReplyDelete

  31. 2) We have some commitments/ undrawn portion attached with loans.How do we compute the EIR for such accounts? Do we need to get the cash flows for such undrawn amount/commitment in our cash flow as per bank's assumption/policy for EIR calculation or we can use the same EIR applicable to loans for such commitments/ undrawn portion.

    ReplyDelete
  32. Hi Pooja. Thank you for writing this post.
    Although, I was trying to work out the amortisation for a floating rate loan with disbursements in various tranches each tranche involving a significant processing cost.

    ReplyDelete
  33. Your share a very informative article in your blog. I want to know that about Loan in UAE can you write more about it.

    ReplyDelete
  34. Thank you for sharing such great information.
    It is informative, can you help me in finding out more detail on
    current home loan interest rates.

    ReplyDelete
  35. Why XIRR and not just IRR in case of cashflows being fixedand dates being periodic..?

    ReplyDelete
  36. Can you please explain a illustration of compnay have EMI terms of loan and not exactly financial year wise.

    ReplyDelete

Post a Comment

Popular posts from this blog

Maintenance Charges Default: No Water, No Sympathy

In what can only be described as a case of forum shopping (trying to find the friendliest court), an apartment owner in Shiv Vihar CHS, Dombivali (East), took his complaints on a legal tour. The petitioner, Vilas Gopal Dongare member of the society was unhappy. Why? Because his water supply was cut off. The reason? He had not paid his maintenance bills, which had piled up to a whopping Rs. 7 Lakhs! Despite making several complaints about the alleged harassment by the society and even a water tank causing structural issues in his building, his cries were heard and promptly dismissed. The Maharashtra State Human Rights Commission looked into his case and, on 05.02.2020, decided it was not a human rights violation. They said, “Pay your bills first.” The society initiated proceedings under Section 101 of the Maharashtra Co-operative Societies Act, 1960 (MCS Act) to recover arrears and got a Recovery Certificate issued in its favour. When the petitioner’s appeal against this certificate wa...

Court Upholds Co-operative Membership Transfer with Release Deed

In the case of Bima Nagar Co-operative Housing Society Ltd. v. Divisional Joint Registrar & Ors. WP 10768 of 2024 , the Bombay High Court on 23.09.2024 dismissed the society’s petition challenging the membership transfer to Pushpa Morey, a widow, following her husband's death. Initially, Pushpa was granted provisional membership but was later denied full membership by the society. Pushpa applied for full membership after her husband's passing. When the society refused, she sought help from the Deputy Registrar, who ordered that the society admit her as a full member under Section 22(2) of the Maharashtra Co-operative Societies Act, 1960. The society’s appeal to the Divisional Joint Registrar was unsuccessful, prompting the writ petition in the Bombay High Court. The society argued that the "family arrangement" concept under Section 154B-13 of the Maharashtra Co-operative Societies Act applies only to a Hindu Undivided Family (HUF). Pushpa, however, contended tha...