You know you need a cashflow forecast, but what is the best way to set it up?
Having spoken to thousands of eCommerce founders, we recognise that keeping on top of your cashflow can be a tedious task. That's why we've built a free cashflow management template and a 5-step guide to help.
1. Set your timeframe
To plan and analyze your cashflow, you should be noting how much cash is available at the start and end of a specific period. The default in our template is a twelve week cashflow forecast to align with quarterly reporting cycles, but you should also consider the year-long view that anticipates seasonal peaks and troughs.
2. Note any expected cash injections
Note down any cash injections you're expecting. The most common forms are cash raised in exchange for equity, debt taken on from external financing providers, or personal savings you are investing in the business.
3. Forecast your revenues
Start with the year-long perspective. Almost every consumer brand experiences some level of seasonality.
These fluctuations can be drastic for particular products, like swimwear, winter coats, or back-to-school supplies. It's important that this seasonality is taken into account when managing your cashflow.
Take a look at your sales data for the last year or two of operations. Look for patterns that help you predict demand, like when volume could pick up and which products are most popular.
Use this to guide your predictions, but make sure to account for your growth ambitions too.
Now move into the micro-level view. How is the next twelve-week slice impacted by sales fluctuations? How do you expect your cash inflows to adjust in response to this?
4. Estimate your cash outflows
After forecasting revenues, you'll have a good idea of what sales demand will be and which products you need in stock to meet that demand.
Then you can begin assessing the cash outflows required, which can typically be estimated as a percentage of revenue.
How much capital does your business need to achieve its growth ambitions? This is an important assessment to make, because your inventory order size is directly tied to how much cash you have available.
If a business doesn't have access to financing, it might not be able to afford enough product to meet forecasted demand. This is particularly true for growing brands, whose future sales will outpace current operations.
As we've outlined in our cash conversion cycle article, successful sales growth can bankrupt a business, because an increasing amount of cash is "tied up" in stock and can't be recouped in time to cover expenses.
You should estimate and create a budget for the expenses you'll need to pay. Some of these remain relatively constant, even in the low season, such as rent, wages, and software subscriptions. Others vary depending on seasonal fluctuations, such as inventory and marketing spend.
When planning your inventory spend, it's important to factor in lead times and payment terms. Your lead time is the period of time between when you first place an order with a supplier and when you receive the shipment.
It can vary greatly depending on the product category. An eCommerce business that specializes in home and garden supplies will need outdoor patio furniture in stock when customers begin shopping for those items in the Spring.
But manufacturing this type of furniture takes months and could translate to a six-to-eight month lead time.
That means the business would need to place the order in August to have products in stock by February, when it begins receiving orders.
The brand should also be prepared to pay a deposit when it places the order, which won't be recouped until the products sell much later.
Their cash conversion cycle is much longer than say, a chocolate brand that only needs to wait a few weeks for a supplier to fill their order. Their upfront capital requirements are likely larger too.
But if you think back to our previous articles, this might be justified by a higher contribution margin per unit and a lower break-even point in units, provided they can manage their cashflow effectively in the meantime.
Each product category has inherent features that affect cashflow requirements. Consider when your demand fluctuations are, and estimate the cash outflows that are needed to meet this demand.
5. Analyze your projected cash position
When are the most capital intensive periods? Will I have enough cash on hand to cover fixed operating expenses? Are there any periods when external financing could benefit my business?
After completing your cashflow forecast and getting a clearer picture of your projected cashflow, you need to make important decisions to unblock any cash constraints and maximize the chances of success for your business.
You should always maintain a cash buffer so that the business can continue to operate day-to-day.
Many businesses dip into personal funds to overcome cashflow constraints, but risking personal assets for a business venture is rarely the best option.
External financing providers are often a sound option to capitalize on growth opportunities while maintaining a cash buffer.