Credit Analysis Illustrated Using Financial Statements II

Credit Analysis Illustrated Using Financial Statements II

Nick Beeson

35 years: Credit & banking

In the final video of the series on credit analysis, the example from the previous videos carries over. Nick explains the working capital cycle and how its funding can cause problems.  

In the final video of the series on credit analysis, the example from the previous videos carries over. Nick explains the working capital cycle and how its funding can cause problems.  

Speak to an expert

Speak to an expert today to access this and all of the content on our platform.

Credit Analysis Illustrated Using Financial Statements II

11 mins 39 secs

Key learning objectives:

  • Discuss the impact on the accounts for days 77 and 78

  • Explain how the statements would change if tax or interest were paid

  • Identify what causes the debt, and discuss whether is it sustainable

Overview:

This analyses the impact on the company accounts if it were to increase its sales and trading frequency in the future, along with the problems from over-trading and the outstanding debt that comes with this.

Speak to an expert

Speak to an expert today to access this and all of the content on our platform.

Summary
Context: The business carries on doing the same thing every day. Day 77 is the last day before we get any money in, as we made our first sale on day 3 on 75-day terms, and thus, we get paid for our first trade on day 78.

What do the accounts look like on day 77?

  • Stock = £50,000 as we buy and sell £50k of stock each day
  • Debtors will be (75 x 65,000) = £4,875,000 – as we will have had 75 days of selling on 75-day terms.
  • Creditors will be (60 x £50,000) = £3,000,000
  • Assume fixed costs still = £20,000 (Van price)
  • Equity = £750,000 (10k each day for 75 days)

Clearly the business is perfectly profitable.

What are the impacts on accounts if tax or interest is paid?

We have assumed these both = 0. However, in reality:

Interest charged will be a reduction from P&L. If it is paid, it will be a reduction in cash, if it is not, it will be an increase in accruals.  If tax is charged, it is a deduction from P&L. If it is paid, it is a reduction in cash, if not, it is an increase in accruals.

What is causing the debt to grow?

The first 75 days of sales no one pays you – it is on the 75-day terms, and thus, these rapidly increasing debtors have to be funded.

The overdraft looks like this:

We started with £100k cash, spent £20k on the van which leaves £80k. We paid out £5k a day from day 73-77 in operating costs meaning we are £295k overdrawn + the 16 days of stock at £50k each (£800k) = a total of £1,095,000 in overdraft.

What will happen to the company accounts on day 78?

  • The client will pay up and his payment will be matched by the customer on day 78 not paying, so Debtors increase for 75 days then they will stay steady.
  • Stock remains unchanged at £50k
  • Creditors is unchanged
  • Profit = £10,000 per day

Are the assumptions drawn above correct?

No – we have ignored interest and tax both of which will reduce profits and eventually have to be paid in cash. Also, the casual assumption that the business will boringly have been able to replicate the trading pattern day in and day out is brave to say the least.

Speak to an expert

Speak to an expert today to access this and all of the content on our platform.

Nick Beeson

Nick Beeson

Nick has nearly 35 years of experience in banking. He joined his current employer, Lloyds, in 2005 as Credit Director for Loan Trading. Nick has since undertaken a number of Credit Roles for the Bank. Nick has also worked in education and has lectured for numerous institutions.

There are no available Videos from "Nick Beeson"