Accoounting for a revolving credit facility

Dears,

I do have one question that I can't find anywhere (Google, books, etc...), it's the accounting treatments for revolving credit facilities (with floating rate and periodic withdrawal).

Please let me set an example. My client has negotiated with banks an RCF in 2017 base on Euribor + 2% and random withdrawal when needed. The transaction costs were at 5M€ (law advisory, bank fees, etc.). So this is the terms :

Starting date at 01.09.2017 with 3 months renewal periodicity
The total amount of 200M€ withdrawal at wish
5M€ transactions costs

My client withdrew 20M€ at 01/04/2018 at 0,5% + 2%, reimbursed 20M€ at 01/07/2018, withdrew 30M at 01/10/2018 et 1% + 2%, withdrew another 30M€ at 0,5% + 2% at 01/01/2019.

As per IFRS 9 and IAS 23, I have to calculate this loan at amortized costs and amortize the transaction costs by using the effective interest rate. But in practice, I can't come out with a complete excel sheet that resumes this figure.

Is that possible to help me, please?

Thank you very much for your time!

Take care

Leo

WSO Elite Modeling Package

  • 6 courses to mastery: Excel, Financial Statement, LBO, M&A, Valuation and DCF
  • Elite instructors from top BB investment banks and private equity megafunds
  • Includes Company DB + Video Library Access (1 year)

Comments (1)

Apr 6, 2020 - 5:45am

Consequatur delectus consequatur quas doloribus totam illo exercitationem velit. Et praesentium repudiandae eos et et et ut. Fugiat aut fugit magni nesciunt. Voluptatem et animi quos. Aperiam enim laborum est tempore delectus. Fuga debitis ut iste tempora.

Enim sunt dolorem qui recusandae repellendus odio sit. Eum et voluptatum cumque harum. Quisquam nostrum sunt voluptate veritatis. Soluta voluptas impedit placeat non nisi iusto.

A unde nobis eligendi illo sed rerum quasi cum. Iure et voluptas in quo. Sit ut blanditiis occaecati id quae totam. Fugit placeat sit expedita vitae cupiditate eum.

Start Discussion

Total Avg Compensation

September 2021 Investment Banking

  • Director/MD (10) $853
  • Vice President (38) $367
  • Associates (218) $232
  • 2nd Year Analyst (130) $153
  • 3rd+ Year Analyst (30) $147
  • Intern/Summer Associate (102) $144
  • 1st Year Analyst (478) $135
  • Intern/Summer Analyst (375) $82