Tag Archive for: cashflow

Cash is The Whole Royal Family!

26-08-2020 | Olivier Werlingshoff | treasuryXL

Can the treasurer be the linking pin between different departments within organizations?
For cash related topics he or she has to be the linking pin to understand the cash flows within the company and to be in control. When you understand how all departments work and how the financial information is produced by controllers, you can help them and give advice on how to lower trapped cash.

Cashflow

To me the cash flow forecast is the basic of all treasury related items. When setting up the forecast (direct/indirect), it gives you the possibility to dive deep in the risk of FX and take actions to lower them or even better, to develop a guideline on how to handle FX risks in the future. The same can be done for IR risk, debtor risk and all other cash flow related risks. When making the cash flow forecast, you can literally make visual what the effect of a change in payment behavior of your customers or a change in FX rates will be.

The Treasurer’s task

The treasurer has to be in constant contact with all different departments to receive the most actual information. As treasurer, you also have to challenge the different departments on cash related topics. The reason for this is that most of the colleagues are not always cash focused. You have to set up an internal marketing plan to reach all necessary stakeholders (organize meetings, develop reports, mailings, organize events where colleagues can come with cash optimization related idea’s etc…).

Supply chain departments are focusing on delivering on time for production or sales. It is very interesting to focus on the ins and outs of world of supply chain. All goods can be categorized based on the time they will stay in the warehouse as well as the time needed to replace them and the cost of a reorder. When you combine all variables, an optimum can be reach. The information that supply chain and purchasing department can provide you is the order book. This can help you to extent the reliable period of the direct cash flow forecast.


By sitting close to the financial department or the shared service center you can have a better understanding of the payment behavior of clients but also the payment behavior of the company. Is there enough focus on the debtor collection process and is the sales department also aware of the payment behavior of their customers? Are the invoices send on time? Do they use direct debits or are balances on bank accounts swept daily to a master account?


Financial control is a department which is also related to the cash flow forecast. Most of the time they will make budgets of balance sheets and P&L and will make (monthly/ quarterly/yearly) estimations of the working capital parts such as inventory, accounts payables and receivables. By doing so they will be able to predict an indirect cash flow forecast. Are their presumptions for the working capital parts correct? Are they based on the budget sales, or based on the previous years? Most of the time the presumptions explain the difference between the direct and indirect forecast and difficult to track down.

Conclusion

Financing activities such as project financing, supply chain and trade finance can be set up based on a reliable forecast. By increasing the cash awareness in different departments, you will be able to release trapped cash, lower costs and have better control of all cash related items.

Olivier Werlingshoff

Olivier is an operational treasury manager who likes to connect and get in touch with different departments. By doing so he gets the treasury department and the awareness of cash in the picture, gets grip on the cash flow and releases trapped cash as well as lowers costs.
He is available for a permanent/interim position and you can reach him on

+ 31683629427

[email protected].


Does your business need support in Treasury or a Treasury QuickScan?

We have treasurers available, go to Rent a Treasurer for all information.

Webinar recording: The Future of Cash Flow

| 11-08-2020 | Cashforce

Cash forecasting has been essential to treasurers over recent months both with respect to systems/behaviour/data.

In this webinar we discuss the future of cash flow, together with Caroline Stockmann (ACT), Ginny Wu (Walker Shop Footwear), Gerard Tuinenburg (Unilever), James Adams (Chalhoub) and Nicolas Christiaen (Cashforce).

Watch recording:

 

How to develop the ultimate Cash Flow Forecast

| 29-06-2020 | Cashforce

Cash flow forecasting has been called many things in literature. Ranging from the cornerstone of a finance & treasury department to the lifeblood of any organization; it’s fair to say cash forecasting is vital to get an accurate prediction of an organization’s health. Cash forecasting, at its core, is simply identifying all the various in & outflows over a given period in order to analyze and compare those estimations with your actuals. However, in reality, it’s not that simple and a lot of challenges arise in getting an acceptable end result, especially when complexity increases i.e. multiple systems, entities, currencies, etc. Additionally, it doesn’t stop at regularly getting the right information in a timely and efficient matter. Setting sensible assumptions and providing contingencies that offer flexibility in case of unexpected events are a few quintessential things to consider. Improving your forecasting results is more than relying on hard data, but bears fruit in the synergy of art and science. Don’t know where to start, or how to fill in the blanks on further optimizing your current process? Then follow this checklist.

1. Set your goals & requirements – getting to the why – decide:
  • Why are you creating a cash forecast?
  • Do you want to perform an indirect or a direct cash forecast e.g. focus on short term (direct) or longer-term (indirect), or a combination of both
  • What does successful (output look like? (formats, visuals…)
  • If you would like to combine both, choose how the reconciliation would work?
  • What level of granularity do you need?
  • What KPI’s will you be measuring?
  • Who will be the main users of the reports and analyses? (operational vs strategic or both)
  • Who will be contributing to generate the forecast?
  • How will the different contributors and users consume the outputs?
  • What other stakeholders will use the forecast? (e.g. shareholders)
  • Will you recognize forecasting performance? (e.g. remuneration)
  • What are your main cash flow drivers? (how do you define your business model?)
  • What will be the main process-steps?
  • To what extent your staff will be involved in the process? (vs. technology doing the work)
  • In case of exceptions, can the process be sidestepped? If so, what happens then?
  • What controls will be put in place?
  • Who will be in charge of setting up the process? (internal/external)
  • Who will be the main owner of the process?
  • How often does the data need to be updated?
  • How will data quality be ensured for new inputs?
  • What process will be put in place to clean the current data?
  • How will you flag and treat mis-allocated cash flows?
  • What will you use as a reporting currency?
  • How do you treat currency differences?
  • What data sources are most relevant for the forecast and what data you want to take into account:
    • Systems holding your (actual & future) payables and receivables?
    • What formats are your bank statements in? (MT940, BAI, EBICS, CODA…)?
    • Financial planning data. e.g. FP&A / budget / planning tools?
    • Do you have any Treasury & financing data, e.g. interest & FX payments on ongoing deals, residing in, e.g. a Treasury Management System or spreadsheets?
    • Do you need to take any other data into account, e.g. in data warehouses, other specialized systems for leasing, salaries, projects, etc.?
    • What manual input do you require? To what level?
  • How will you get the above data into the forecast? Is it possible to automate these processes?
  • How many forecast horizons do you want to define?
  • What cutoffs would you put in place to split the horizons?

How would you divide the short-mid- & long-term components of the forecast, see (e.g. different per data source below:)

An example of Cash forecasting horizons & their sources

  • What cash flow categories do you want to use?
  • Is there a template you can use as a basis of cash allocation categories, e.g. your current ERP, etc.?
  • How will you treat the unallocated transactions/cash flows?
  • Setting up accuracy feedback loops, e.g. regularly comparing actuals vs forecast & reviewing for improvement
  • Choosing which algorithms / logic – based on business drivers – can be integrated into your model to improve the forecast
  • Decide which contingencies to build in, e.g. revenue/cost/currency/… assumptions

Evaluate how you will you compare with and integrate industry best practices, e.g. staying up to date with the latest technology/peers/…

While creating an accurate cash forecast is not rocket science, getting an effective reporting process in place certainly requires a well thought out and reproduceable plan. Defining the who, the what, the when and the how is both a quantitative and qualitative exercise in building out a forecast. This checklist shows you how to combine the art and science of cash flow forecasting to get it done.

Why is cash flow forecasting still an issue?

| 09-07-2019 | by treasuryXL | Kendra Keydeniers

Cash forecasting is a vital part of the treasury role – and for all too many treasurers it’s a time consuming, difficult job where insufficient system support makes data management, analysis and reporting a time-consuming nightmare.

However, the good news is that it doesn’t have to be that way! In this insightful webinar hosted by The Global Treasurer and Analyste, they will:

  • Discuss why cash forecasting is still an issue
  • Delve into the barriers preventing corporate treasurers from making cash forecasting a simple task
  • Investigate the technology solutions making it easier than ever before
  • Work out a roadmap that will help treasurers ease their cash forecasting worries

The first step towards simplified cash forecasting: Register now for the Webinar on 17 September 2019 from 11:00AM to Midday BST

Boek release: Discounted Cashflowmethode – Achtergronden en aandachtspunten

| 6-6-2017 | Peter Schuitmaker | treasuryXL |

 

Medio juni verschijnt een nieuw boek van onze expert Peter Schuitmaker met de titel ‘Discounted Cashflowmethode’. Dit is zijn tweede boek. Eerder publiceerde hij ‘Mijn bedrijf verkopen ‘. Wij hebben hem verzocht om ons alvast meer te vertellen over dit nieuwe boek en de daarin beschreven methode, die van belang is bij het verkoop of de overdracht van een bedrijf. 

DFC methode

Bedrijfswaardering is een veel voorkomend vraagstuk. Denk aan situaties van bedrijfsoverdracht, uitkoop van een aandeelhouder, management buyout, bedrijfsopvolging binnen de familie, boedelscheiding, enzovoorts. In de literatuur vinden we een grote verscheidenheid aan methoden. De DCF methode geldt echter als de meest zuivere benadering.
Hierbij worden toekomstige kasstromen op een of andere manier bepaald en deze worden op een of andere manier contant gemaakt. Maar: hoe zit dat nu met die ‘op een of andere manier’?

Het boek

In de praktijk van bedrijfswaardering worden veel fouten gemaakt. Vaak worden de technieken onjuist of onvolledig toegepast. Of verkeerde uitgangspunten gehanteerd. Dat roept onnodig vragen op over de juistheid van de waarderingsuitkomst.
Dit boek behandelt de achtergronden en aandachtspunten van de DCF methode. Hierbij komen diverse varianten aan bod, zoals de WACC methode, de Adjusted Present Value APV methode en de Cash To Equity methode. De theorie wordt behandeld aan de hand van een praktische casuspositie.
Mijn  boek biedt grip op de reken technische aspecten. Maar belangrijker, de keuzes en overwegingen bij het toepassen dan de DCF methode. Het helpt de lezer om een DCF waardeanalyse te doen. Maar ook kunnen zo waarderingsrapporten van derden kritisch tegen het licht worden gehouden. Om zo de juiste kanttekeningen te kunnen plaatsen.

Bestelinformatie

Auteur: Peter Schuitmaker
Uitgever: BBO&F Breda
ISBN:  978-90-826156-2-3
Prijs: €19,50 incl. BTW
Paginas: 92

Verschijnt: medio juni 2017
Te bestellen via www.bboenf.nl/boeken

 

Peter Schuitmaker

Registered Advisor for Business Transfer and Succession

 

 

 

Meer artikelen van deze auteur:

Pre exit strategie wint aan populariteit

Het belang van cash management in de aanloop naar bedrijfsoverdracht