Route 102 – One man’s year-long journey……Day 29

  • By Jeremy Williams
  • 26/02/2015

To mark this momentous year for UK GAAP, I'm embarking on a mission to work my way through FRS 102, reading a portion on each working day of 2015 and writing a short blog entry on my thoughts and musings (be they few or many).

Day 29 (26 Feb)

I'm off to rainy Sheffield today, but there's enough time to give you an example of the amortised cost approach to a loan.

Well, I'm cheating really, because the lovely people at FRC have already provided a worked example in 11.20 within FRS 102. All I've done is changed the example to a loan received (rather than a bond), which changes the figures slightly, and added some real dates and currency.

In this example, the entity borrows £900K on 1 January 2015, although an arrangement fee of £50K is charged.

The stated interest charge is £40K per annum paid each 31 December for five years. At the end of the loan, the entity repays the £900K capital plus a redemption fee of £200K.

Currently, many accountants would record an initial creditor of £900K, debiting cash with the net amount received of £850K and debiting the arrangement fee either to the P&L immediately or treating this as a prepayment and spreading over the five years.

We're not daft enough to only show interest of £40K per annum, as there's clearly a huge final penalty to pay at the end. So we'd add up the total finance charge (5 x £40K, plus the final £200K = £400K) and spread this evenly over the five years, giving an annual interest of £80K. So our repayments table looks like this:

YearLoan b/fwdInterestRepaidLoan c/fwd
201590080-40940
201694080-40980
201798080-401020
2018102080-401060
2019106080-11400

Not any more. Firstly, the loan should be initially recognised at the transaction price including transaction costs, ie at only £850K (NB the example in FRS 102 is for a bond, so the £50K is added rather than deducted as in my example). We then calculate the effective rate of interest. How do we do this? In Excel, create a column of figures (say, B1:B6) like so: 850, -40, -40, -40, -40, -1140 (effectively the yearly cash transactions), and in a separate cell enter the formula =IRR(B1:B6). In this case, the effective rate is the memorable 9.56533%.

Out table under FRS 102 becomes the following:

YearLoan b/fwdInterest*RepaidLoan c/fwd
201585081.31-40891.31
2016891.3185.26-40936.56
2017936.5689.59-40986.15
2018986.1594.33-401040.48
20191040.4899.52-11400
* at a rate of9.56533%on the loan b/fwd

Now, you'll have to decide whether this new approach makes a material difference to your loan, and if so, this is the new approach we should take.

Right, that's it for now. Time to hit a drizzly M1...

P.S. If you missed yesterday's instalment please click here.

You might also be interested in these…