Saturday, December 29, 2012

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

41 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
  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. 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



  26. 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
  27. 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
  28. 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

  29. 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