BUDGET Financial Planning using Excel Forcasting Planning and Budgeting Techniques


Financial Planning using Excel

  • Forecasting
  • Collecting and Examining the Data
  • Smoothing Techniques
  • Regression Analysis
  • Time Series Analysis
  • Expected Values
  • Selecting and Evaluating Forecasting Techniques
  • Business Planning
  • Spreadsheet Skills for all Types of Planning
  • Developing a Financial Plan
  • Business Plans
  • What-if Analysis
  • Risk Analysis
  • Budgeting
  • A Spreadsheet Budgeting System
  • Consolidating Data

The objective of this book is to help financial planners improve

their spreadsheet skills by providing a structured approach to
developing spreadsheets for forecasting, financial planning and
The book assumes that the reader is familiar with the basic operation
of Excel and is not intended for beginners.
Readers using a different Windows spreadsheet will find that the
techniques explained in the book are equally relevant, although it is
possible that some command sequences might be slightly different.
The book has been divided into three parts covering the areas of
Forecasting, Planning and Budgeting separately. Although it is recommended
that readers follow the book from the beginning, the
text is also intended as a reference book that will be a valuable aid
during model development.


No comments:

Post a Comment

Engineering Management. Powered by Blogger.