The Fundamentals in Forecasting for Beginners


A forecast is a prediction of a company's future financial performance presented in numerical format, usually in the form of spreadsheets. When a company develops its business plan, it sets goals for the short and long term, and then creates strategies and action plans to bring about the achievement of the goals. Forecasting is a process of translating each of these strategies and action plans into numbers.

Spreadsheet Skills

  • Business owners new to the forecasting process are sometimes intimidated by the practical aspects of using computer spreadsheet software such as Excel. To get started, all you really need to do is understand the keystrokes required to perform basic mathematical calculations -- adding, subtracting, multiplying and dividing. The first forecast you make will have simple formulas that combine these functions. Later on you can learn techniques such as macros that will allow you to do more-complex forecasting models.

What a Forecast Looks Like

  • Most companies do month-by-month forecasts for the upcoming year. Each month is shown in a column. Each revenue and expense line item is labeled on the rows down the left side of the spreadsheet. With a forecast profit and loss statement, the bottom line of the spreadsheet is pretax income -- the difference between total forecast revenues and expenses. This bottom line number is a prediction of how profitable the company will be. At minimum, this number should be positive, the exception being developmental stage companies that expect to lose money in the beginning.

Revenue Forecasting

  • The forecasting process starts with the creation of a revenue model -- a calculation that shows how revenues will be generated. In its simplest form, the calculation could be projected units sold for each of the company's products multiplied by the average price per unit. For a restaurant, the calculation could be number of diners each day multiplied by the average expenditure per person. To do an accurate forecast, the assumptions used must be based on real data you obtain about similar companies in the industry. Avoid the natural entrepreneurial tendency to be overly optimistic with your revenue forecast. A conservative forecast that is achievable is more useful than one in which the actual results are likely to fall well short of expectations.

Expense Forecasting

  • Care must be taken to ensure every line-item expenditure for your type of business is included in the forecast. Again, these must be based on real numbers. Rent expense for office or manufacturing facilities, for example, should be based on average cost per square foot for space in the area where you plan to locate the company. Within most metropolitan areas, rental costs can vary widely across the city. Don't overlook routine smaller expenditures such as office supplies, property insurance or janitorial services. These categories, when added up, can amount to significant dollars.

How it Is Used

  • The forecast is often revised several times until the management team is satisfied that the end result is an accurate depiction of what is likely to happen. If the first draft of the forecast shows a significant loss, then either forecast expenses need to be cut or the revenue forecast needs to be increased. When actual financial results for the year become available, the business owner will look at how the company fared in comparison to forecast. This comparison, called variance analysis, helps the management team determine whether the company is on the proper course, or whether adjustments need to be made to marketing strategies or operating expenditures.


  • "Financial Management 101: Get a Grip on Your Business Numbers"; Angie Mohr; 2007
Promoted By Zergnet


You May Also Like

Related Searches

Read Article

Are You Really Getting A Deal From Discount Stores?

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!