If you’ve been working or studying in finance you have probably heard of working capital before. If not then you might be wondering what the flip we are talking about. Well working capital is usually defined as current assets less current liabilities. If working capital is positive, the company has enough current assets to meet its current liabilities. If not then the company may have short term liquidity problems.
In this blog tutorial we are going to look at two components of working capital, debtors or accounts receivable and creditors or accounts payable.
Ok, let’s first start with Debtors. Debtors are current assets which arise when revenues are accrued but not paid. For example you book a sale of $100 on account, however you receive the cash 30 days from that date. The two entries you would make are:
Creditors are very similar to the above.
Ok, so you should have a good feeling of how this works now, so let’s look at modelling this. In 99% of the cases we can calculate debtor and creditor balances using the following formulae:
Debtor Balance = Revenue Accrual x Debtor Days/Days in Period
Creditor Balance = Expense Accrual x Creditor Days/Days in Period
For a yearly timescale the Days in Period would be equal to 365 days (we’ll ignore leap years). From here you can find the total cash received or paid from revenue and expenses respectively. Let’s look at this from a debtor perspective and utilising a corkscrew account (if you don’t know what this is see our Corkscrew Account. What the? blog).
Opening Balance 50
Add: Revenue Accrual 50
Less: Cash Received [x]
Closing Balance [y]
Firstly let’s find y. If we are looking at a year timescale and 30 day debtor days, then our closing balance (y) would be 50 x 30/365 = 4.1.
Now we need to find x. Rearranging the formula we get:
Cash Received (x) = Opening Balance + Revenue Accrual – Closing Balance (y)
= 50 +50 – 4.1
Ok, that might be a bit of brain dump…. so let’s look at some examples.
You forecast $2,000,000 of sales on credit each year from 2011-2015. Your credit terms are 30 days. What is the size of your debtor/accounts receivable in each of 2011-2015?
Ok, firstly and as always you need to put in a timescale as below:
Next let’s put in the Revenue – Accrual.
Now using the formula Revenue Accrual x 30/365 calculate the debtor balance.
Now you could calculate the cash received, but we will put in one more step. We will find the movements in debtors (i.e. debtor opening balance – debtor closing balance).
Now if we add the above debtor balance with the revenue – accruals we should get the cash received.
You’ll notice that the cash in the periods after 2011 are equal to 2,000,000. Why? Well this is because the debtor balance from the previous period is paid off in the next period. i.e. in the 2012, the debtor balance from the end of 2011 is paid off.
Example 2 – Homework
Question: You buy services worth $1,000 every year from 2008 to 2011. You have credit terms of 90 days and you start with a credit balance of $250 at the start of 2008. What is your creditor/account payable balance at the end of 2011?
Take your Excel and financial modelling skills to the next level. Try our Excel and Financial Modelling training courses today.