Skip to main content

PREPARING A CASH FLOW FORECAST

One of the questions we’re often asked by small business owners is, “how do I prepare a cash flow forecast?” This is no surprise. It’s an important part of financial planning for any business. But, if you’re an entrepreneur or founder, there’s a good chance you don’t have an accounting or finance background.

The good news? It’s really simple to create your own forecast. And once you know how, it will become one of the most important pieces of insight you have.


Why is a cash flow forecast important?

Cash flow planning is essential: you need cash in the bank to pay your bills. Staying on top of your cash flow will help you see if you’re going to run out of money - and when - so you can prepare ahead of time. Perhaps it will show you that you need to cut overheads, find new investment, or spend time generating sales.

On the flip side, you might be doing well, and you’re considering expanding into new markets, investing in new products, taking on bigger premises, or recruiting new staff. Having accurate cash flow projections will help you see if you can afford to take the plunge.

The tips we’ve set out below are designed to help you build a cash flow forecast that will help you make these kinds of decisions. 

Four steps to a simple cash flow forecast

You’ve got a couple of choices for your forecast. The easiest way is to find free financial forecasting software online - like PwC’s Cashflow Coach, which can help you plan ahead for the next week, 30 days, or six weeks. Or you can follow the four steps below to build a simple spreadsheet.

1. Decide how far out you want to plan for
Cash flow planning can cover anything from a few weeks to many months. Plan as far ahead as you can accurately predict. If you’re well-established, you might have a predictable sales pipeline and lots of data from previous years. If you’re a new business, you might not have a huge amount of data - so the further out you go, the less accurate your predictions will be.

Don’t worry too much if you can’t plan far ahead. Your cash flow forecast can change over time. In fact, it should. As things change, or you get more exact estimates, you can update your plan.

2. List all your income
For each week or month in your cash flow forecast, list all the cash you’ve got coming in. Have one column for each week or month, and one row for each type of income.

Start with your sales, adding them to the appropriate week or month. You might be able to predict this from previous years’ figures, if you have them. Remember though, this is about when the cash is actually in your bank account. So put the figures in for when you know clients will pay invoices, or bank payments will clear.

Also remember to include all non-sales income, for example:

  1. Tax refunds
  2. Grants
  3. Investment from shareholders or owners
  4. Royalties or licence fees

Add up the total for each column to get your net income.

3. List all your outgoings

Now you know what’s coming in, work out what you’ve got going out. For each week or month, make a list of all the money you’ll be spending, for example: 

  1. Rent
  2. Salaries
  3. Raw materials
  4. Assets
  5. Bank loans, fees and charges
  6. Marketing and advertising spend
  7. Tax bills

Once you’ve listed everything you spend, add up the total for each column to get your net outgoings.

4. Work out your running cash flow
For each week or month column, take away your net outgoings from your net income. That will give you either a positive cash flow figure (you’ve got more cash coming in than you’re spending) or a negative cash flow figure (you’re spending more than you’ve got coming in).

You can then keep a running total, from week to week, or month to month, to get a picture of your cash flow forecast over time. Too many negative weeks might spell trouble, and you’ll need to do some forward-planning to make sure you can meet your commitments - e.g. paying salaries, loan payments, and rent. On the flip side, a few positive months might signal that you’ve got money to expand or invest.

Whether you’re already a pro with cloud accounting software, or a complete novice, take a look at Cashflow Coach for a fast, easy and accurate way to plan your cash flow. Compared to a spreadsheet Cashflow Coach will automatically update for transactions in your accounting general ledger so no need to re-enter data into a spreadsheet.

Comments

Post a Comment

Popular posts from this blog

What are business activities?

What Are Business Activities? Business  activities include any activity a business engages in for the primary purpose of making a profit. This is a general term that encompasses all the economic activities carried out by a company during the course of business. Business activities, including operating, investing and financing activities, are ongoing and focused on creating value for  shareholders . KEY TAKEAWAYS Business activities are any events that are undertaken by a corporation for the purpose of earning a profit. Operating activities relate directly to the business providing its goods to the market, including manufacturing, distributing, marketing, and selling; they provide most of the company's cash flow and hugely influence its profitability. Investing activities relate to the  long-term use of cash , such as buying or selling a property or piece of equipment, or gains and losses from investments in financial markets and operating subsidiaries. Financing activitie...
Post a Comment
Read more

EXTERNAL COSTS AND EXTERNAL BENEFITS

External costs An external cost occurs when producing or consuming a good or service imposes a cost (negative effect) upon a third party. If there are external costs in consuming a good (negative externalities), the  social costs  will be greater than the private cost. The existence of external costs can lead to market failure. This is because the free market generally ignores the existence of external costs. External marginal cost (XMC)  the cost to a third party from the consumption/production of one extra unit. Example of External Cost Driving a car imposes a private cost on the driver (cost of petrol, tax and buying car). However, driving a car creates costs to other people in society. These can include: Greater congestion and slower journey times for other drivers. Cause of death for pedestrians, cyclists and other road users. Pollution, health-related problems. Noise pollution. Example of Production External Cost Producing electricity from burning coal leads to air ...
Post a Comment
Read more

Aims of a business

o    To Survive Many a times you find yourself fighting to survive. Sometimes your life is threatened by a certain sickness and you must do everything in your power to fight the disease and survive. It is the same thing with a business, it must survive. A business finds itself faced with tough competition and other things that threaten its survival. To survive means that the business is able to fight competition, gain new customers find reliable suppliers and grow. It is able to be successful and not fail. o    To make a Profit If you were to start a business today, what would be your main objective? Most people start businesses to make a profit. This means that the business is able to sell its goods and services at a price above the buying price . The difference between the selling price and buying price is the profit. For example, if you bought a product at E20 and sold it at E50, the E30 is your profit. o    To Grow or Expand Imagine a situatio...
Post a Comment
Read more