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
|
Dear,
ReplyDeleteI 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...
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..
DeleteTake care
Pooja
I love the way you write and share your niche! Very interesting and different! Keep it coming! cpa network
ReplyDeleteThank you very much historypak!
DeleteWhat if Loan is given on following terms -
ReplyDeleteInterest 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 .
Hello SECL Corporate Accounts!
DeleteAs long as cashflows can be estimated and interest rate is fixed the calculation for EIR remains the same.
Thanks..
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??
DeleteHi Pooja, Thanks for putting up this helpful blog.
ReplyDeleteWell, 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.
Hello Vivek!
ReplyDeleteIf 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
Hello Pooja
ReplyDeleteI want to know whether we need to calculate EIR for borrowings which carries floating rate of interest?
Hello Pooja
ReplyDeleteI want to know whether we need to calculate EIR for borrowings which carries floating rate of interest?
Hello Preksha,
DeletePlease read my latest article at the blog in September-2016 on EIR of Floating Rate Instruments.
Thanks
P
Hi Pooja,
ReplyDeleteWould like to know whether XIRR function works same if the repayment terms for Principle and interest are monthly
Hi Pooja,
ReplyDeleteI want to know, whether the XIRR function would hold good, even when the repayment terms for Principle and Interest are monthly.
Hello Rajat,
DeleteYes XIRR holds good for monthly rest repayments!
Thanks
Pooja
Hi,
ReplyDeleteI want to know the accounting entries for principal and interest in the above example. Thanks
Hi,
ReplyDeletePlease I want to know the accounting entries for interest and amortised cost in the above example. Thanks a lot.
Hello Josephine,
ReplyDeleteIn 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
Hello,
ReplyDeleteDo we need to calculate effective interest in case of overdraft taken from bank?
In the Indian scenario, the rate given by the bank is EIR for the customer!
DeleteThis comment has been removed by a blog administrator.
ReplyDeleteHi If we don't know the mature date. How we can calculate this. Do we need to calculate EIR or just interest accrual
ReplyDeleteHello Chank,
DeleteEIR to be calculated like perpetual instruments..
Best,
Pooja
Hi,
ReplyDeleteWhether underwriting commission will form part of transaction cost for EIR purpose. Earlier commission was capitalized in 2013-14. Thnx...
Hi Ashish,
DeleteUnderwriting commission will form part of EIR.
Best,
Pooja
Hi Pooja,
ReplyDeleteI 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
Hi Shivam,
DeleteYou have a long list of queries. I suggest let's chat one on one to discuss specific product related accounting treatment!
Regards,
Pooja
This comment has been removed by a blog administrator.
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDeleteHi Pooja
ReplyDeleteAccrued Interest paid at the time of Purchase of Securities will form of transaction cost for EIR purpose
No Rahul.. Accrued interest will not be a part of the transaction cost.
DeleteRegards,
Pooja
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?
ReplyDeleteSuppose 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?
ReplyDeleteThanks for sharing this wonderful post.
ReplyDeletebusiness phone answering service
Hi Pooja,
ReplyDeleteHaving 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
hello Ma'am,
ReplyDeletehaving a doubt in EIR working
Hello Ma'am,
ReplyDeleteMyself 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
Hi Hardik,
DeleteCan you email me the exact query with numbers!
cheers,
Pooja
ReplyDeleteHello 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.
Hi Pooja
ReplyDeleteI 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
Hi
ReplyDelete1) 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.)
ReplyDelete2) 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.
Hi Pooja. Thank you for writing this post.
ReplyDeleteAlthough, 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.
Your share a very informative article in your blog. I want to know that about Loan in UAE can you write more about it.
ReplyDeleteThank you for sharing such great information.
ReplyDeleteIt is informative, can you help me in finding out more detail on
current home loan interest rates.
Why XIRR and not just IRR in case of cashflows being fixedand dates being periodic..?
ReplyDeleteCan you please explain a illustration of compnay have EMI terms of loan and not exactly financial year wise.
ReplyDelete