Financial Planning using Excel: Forecasting, Planning and Budgeting Techniques
- 1h 58m
- Sue Nugus
- Elsevier Science and Technology Books, Inc.
- 2006
Excel for Financial Planning covers all aspects of budget preparation, from designing and creating a budgetary control system, consolidating data and working with spreadsheets.
For all qualified and part qualified management accountants who use Excel on a daily basis in budget planning, this book is a must. It contains a wealth of practical examples, tips, new techniques all designed to help you quickly exploit and master Excel to its full advantage and therefore use spreadsheets for more effective management accounting in your firm.
- Provides quick, useful guidance on how to use Excel in management accounting
- Covers basic principles of budgetary control
- Explains the latest techniques for the design and creation of budgets
About the Author
Sue Nugus has been conducting seminars and workshops for accountants and other executives for nearly 20 years. She has worked with the Chartered Institute of Management Accountants and the Institute of Chartered Accountants in England and Wales, and also with the equivalent institutes in Ireland and Scotland.
These seminars and workshops have mostly involved helping accountants and financial managers get the most from their spreadsheets.
The course on which this book is based runs for Management and Chartered Accountants and other executives at least 12 times a year.
In addition to her teaching she has authored and co-authored some 20 books on a wide range of IT subjects that have been published by McGraw-Hill, NCC-Blackwell, and Butterworth-Heinemann.
Sue Nugus also offers consultancy services to those who need assistance in developing advanced spreadsheets.
In this Book
-
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
