A worksheet with a menu of typical expenses before one opens the doors for business

An Excel Workbook for a 12 month Sales Forecast

An Excel Workbook for a 12 month Sales Forecast by Category


Excel Workbook for a 12 month Cash Flow Projection


A balance sheet shows the financial position of your company at a single moment in time; in this case, it will be as of opening day.


A long term forecast is not a necessary part of a basic business plan. However, it is an excellent tool to help you open up your thinking about the company's future. Furthermore, venture capitalists will almost always want a long term forecast to get a feel for growth prospects.

Forecasting sales of your product or service is the starting point for the financial projections. The sales forecast is the key to the whole financial plan, so it is important to use realistic estimates.

The Cash Flow Projection is the best way to forecast working capital needs. Begin with the amount of Cash on Hand you expect to have. Project all the Receipts and Paid Outs for the year. If CASH POSITION gets dangerously low or negative, you will need to pump in more cash to keep the operation afloat. Many profitable businesses have gone under because they could not pay the bills while waiting for money to flow in.

Cash is the financial lifeblood of your business. Your creditors do not care about profit; they want to be paid with cash. You must predict when you will actually collect from customers.

Throughout this guide, you’ll find casestudies, examples, and expert guidance on every aspect of small business finances. You’ll see that our goal is the same as yours—to make your business financially successful.

Syndicate content