Financial Planning using Excel: Forecasting, Planning and Budgeting Techniques

Part 1: Financial Planning using Excel

Chapter List

Chapter 1: Forecasting
Chapter 2: Collecting and Examining the Data
Chapter 3: Smoothing Techniques
Chapter 4: Regression Analysis
Chapter 5: Time Series Analysis
Chapter 6: Expected Values
Chapter 7: Selecting and Evaluating Forecasting Techniques

I never think of the future; it comes soon enough.
Boyadjian and Warren, RISKS, Reading Corporate Signals, 1987.

Introduction

The objective of a business forecast is to predict or estimate a future activity level such as demand, sales volume, asset requirements, inventory turnover, etc. A forecast is dependent on the analysis of historic and/or current data to produce these estimates. Having accurate forecasts can play an important role in helping an organisation to operate in an efficient and effective manner.

However, before being in a position to create a forecast it is necessary to look carefully at what has happened in the past. As well as examining historic data it is also important to be aware of the organisation's position in its industry and the industry's position in the global marketplace. This is equally true for not-for-profit organisations, which are likely to be more interested in budgeting costs as opposed to profit.

Approaches to Forecasting

The process of forecasting can be broadly categorised into two approaches: objective or quantitative forecasts and subjective or qualitative forecasts.

Subjective Forecasts

Subjective or qualitative forecasts rely to a large extent on an in-depth knowledge of the activity being forecast by those responsible for producing the forecast. The forecast might be created by reading reports and by consulting experts for...

UNLIMITED FREE
ACCESS
TO THE WORLD'S BEST IDEAS

SUBMIT
Already a GlobalSpec user? Log in.

This is embarrasing...

An error occurred while processing the form. Please try again in a few minutes.

Customize Your GlobalSpec Experience

Category: Business Intelligence Software
Finish!
Privacy Policy

This is embarrasing...

An error occurred while processing the form. Please try again in a few minutes.