Working Capital Ratios

The CIMA F1, F2 and F3 papers ALL consider financial ratios and how to interpret them. It can be a broad subject when looking at all types of ratios, their audience and how to draw meaningful conclusions from them.

Let’s take a look at the interested users and what type of financial ratios they would be concerned with.

ratio

I’ve highlighted the Suppliers user group and the working capital ratio as that’s the area I will focus on next. Generally speaking, though, there are TWO main areas for financial ratios:

  • Financial Performance: ratios based on the income statement that can be split into profitability ratios and shareholder investment ratios.
  • Financial Position: ratios based on the balance sheet (or SOFP), these can split into activity (day-to-day), liquidity (ability to meet current liabilities) and solvency (ability to meet long term debt) ratios.

Up next, I will look at the working capital cycle that a company’s suppliers (and management) would be interested in. This falls under the activity ratios in Financial Position as it’s concerned with current assets and liabilities.

Financial Position – Activity Ratios

The purpose of the working capital cycle is to ensure the business has enough cash to continue operations and produce goods. It involves managing the relationship between inventories and receivables (short term assets) against the payables (short term liabilities).

Inventory Days

This ratio tells us how long (on average) a company holds on to their inventory. The higher the number, the more likely we are able to meet customer demands but this also means we are keeping capital tied up in inventory longer and this could cause obsolescence and wastage.

 It’s calculated by dividing the inventory over the operating costs and multiplying it by 365 days. In the example below, you can see that the inventory days has improved in 2015 by 5 days, this is mainly due to holding less inventory in stock (43k from 60k).

inv

Accounts Receivable Days

Much like the inventory days, this ratio will tell us (on average) how long a company takes to collect it’s receivables. The lower the number the better in terms of recycling cash back into the working capital cycle.

However, collecting the debt too quickly could cause a  strain on the customer relationship so this factor needs to be considered.

It’s calculated by dividing the receivables balances on the SOFP over the total revenue for the year and multiplying it by 365 days. 

Below, you can see the receivables balance has increased in 2015, so has the receivable days (up to 79), therefore this is a concern and should be addressed.

inv1

Accounts Payable Days

Again, the accounts accounts payable days ratio is calculated in the same manner as above. And the result is interpreted in the same manner too, but this time the higher the number, the more cash we will have on hand as we are paying our suppliers later.

Here the company should make sure they use their sensitising payment terms to the full extent without damaging the relationship with the supplier. 

Again, it’s the mirror image of the above ratio and is calculated by dividing the payables balance in current liabilities over the total operating costs and multiplying it by 365 days.

Here you can see our working capital cycle will have improved as they are now taking 61 days to pay their suppliers rather than 45 days – which has a positive affect on cash flow.

inv2.JPG

Working Capital Cycle

Finally, the working capital cycle can be calculated now we have the above three ratios. To calculate it you need to do the following:

  •  Inventory Days + Receivable Days – Payable Days = Working Capital Cycle

inv3.JPG

Conclusion

Using all of the information above, you can see the working capital cycle has improved from 51 days in 2014 to 47 days in 2015.

This is despite taking longer to collect receivables in 2015 (79 days from 62 days), it appears the positive impact of taking longer to pay suppliers (61 days from 45 days) and holding less inventory in stock (29 days from 34 days) has improved the working capital cycle to 47 days.

Which fundamentally means, in 2015, it took 47 days to turn raw materials into cash. Meanwhile, these ratios above highlight the fact that this can be further improved if better credit control procedures are put into place to reduce the accounts receivable days from 79.

Advertisements

F1: Useful Links and Resources

F1

The operational level of the CIMA qualification covers the implementation of strategy as well as reporting on the implementation of the strategy. It’s focus is purely on the short term.

The main area of the F1 syllabus revolves around Financial Accounting and Reporting. However, you shouldn’t neglect business taxation as it represents a quarter of the F1 area.

Useful Links

Astranti Operational Level Membership – Free Study Text 2015 – Astranti offer some great free study texts for the whole of the operational level. The complete study text for F1 is available for free (but only the online version), you will need to pay if you want to print the text.

CIMA Connect  F1 Group  – here you will find the F1 homepage on the official CIMA site. It contains various documents and articles related to the syllabus as well as a discussion forum that can e very useful before exam time.

F1 Study Notes: Ethics – this article on Ethics is a great insight into a real life example and will help you when preparing for the F1 paper.

F1 Study Notes: Financial Reporting and Taxation – a brilliant article from CIMA on the 2015 syllabus and how it’s affected the F1 paper. A must read for all students sitting the F1 exam next.

F1 Study Resources Homepage– here you can find all of the study resources that the official CIMA website provides.

 

*note: you may need to login into your CIMA connect account for some of the above links.