Working Capital – Trade Debtors and Trade Creditors

It is important to recognize the “Trade Debtors” and “Trade Creditors” in a cashflow model because it captures the cash cycle of the company, i.e. not all of the “Revenue” actually earned in a given period is received in the same period and that not all “Cost” are paid as soon as they are incurred. “Trade Debtors” represent cash amounts due to be paid by customers who have purchased goods / services from the company. Lower “Debtor days” means cash is being received faster from customers. “Trade Creditors” refers to customers / suppliers to which cash is owed. Higher “Creditor days” means cash remains in the company for longer.

Financial_modelling_training_login_or_register_download_pdf_excel

Funding of Working Capital?

Managing the day-to-day operating cash cycle is important to every business in order to ensure a profitable operation. If a business pays creditors before it receives payment from debtors then short term Working Capital constraints need to be resolved. Means of funding include:

  • Cash / Saving Account
  • Overdraft Facility
  • Working Capital Facility
  • Short Revolving Credit Facility
  • Other type of Debt Finance

Modelling Working Capital in a Model

Key Variables The key variables in modelling Trade Debtors and Trade Creditors are:

  • Trade Debtors
    • Variable 1: Revenue
    • Variable 2: Debtor days
  • Trade Creditors
    • Variable 1: Costs Payable
    • Variable 2: Creditor days

How to Model the Working Capital? The most transparent and efficient way to model Working Capital in a Cashflow Model is to calculate per period “Working Capital Adjustments”. The “Debtors Adjustment” is the difference between “Revenue Receivable” and “Revenue Received”, while the “Creditors Adjustment” the difference between “Costs Payable” and “Costs Paid”. Screenshot #1 illustrates the calculation. Model the Working Capital Image Screenshot #1: Modelling Working Capital

Linking Working Capital Calculations to the Financial Statements

Income Statement The Revenue Receivable and Costs Payable should be linked directly to the Income Statement. Cashflow Waterfall The Revenue Receivable and Costs Payable from the Income Statement are linked to the Cashflow Waterfall. Then the “Working Capital Adjustments” are added to the line before Cashflow Available for Debt Service (“CFADS”). Balance Sheet “Trade Debtors” are usually recoverable within one year, so are the “Trade Creditors” which are usually due within one year. “Trade Debtors” shall be entered into the “Current Assets” below other Assets items which are more liquid (such as Cash, Debt Service Reserve Account). “Trade Creditors” shall be entered into the “Current Liabilities”. Balance Sheet Image Screenshot #2: Linking Working Capital to Financial Statements

Common mistakes in modelling Trade Debtors and Creditors

Complexity As shown in this article, modelling “Trade Debtors” and “Trade Creditors” can be done in a transparent and efficient way. Overcomplicating these calculations with a “one line approach” can easily hide any mistakes that are potentially made and thus damage the integrity of the whole cashflow modelling exercise. Incorrect linking back to the Financial Statements. Problems with models where the timing resolution changes half way through the model – This can be solved by laying-out the number of days for each period as illustrated in Screenshot #1

Financial_modelling_training_login_or_register_download_pdf_excel

Variations in Modelling Working Capital

Next Period Receipt / Payment: In this method, it is assumed that the Revenue is received in the next period and so does the Costs are paid in the next period.
% in Period N, N+1, N+2
This method calculates the “Revenue Received” / “Costs Paid” as % of “Revenue Receivable” / “Costs Payable” in Period N, N+1, N+2. Others who downloaded this tutorial also attended Corality’s “Advanced Project Finance Modelling” course. Check it out!

Share this post

 

You must be logged in to view the Tutorial