Financial Planning Using Excel
Forecasting, Planning and Budgeting Techniques

Quick reference guide on how to use and gain benefit from Excel spreadsheets in management accounting

Sue Nugus (Author)

9781856175517, Elsevier Science

Paperback / softback, published 10 December 2008

240 pages
22.9 x 15.2 x 1.6 cm, 0.4 kg

This book covers all aspects of budget preparation, from designing and creating a budgetary control system, consolidating data and working with spreadsheets.

Now fully updated to include the latest version of Excel, Excel 2007 and for easy budgeting. The book shows how things are done in Excel 2003 and Excel 2007 to ease transition from the previous version to the new version. Now in full colour throughout to aid quick understanding through numerous color screen shots.

For those 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 quickly exploit and master Excel to its full advantage and therefore use spreadsheets for more effective management accounting in your firm.

Preface
Excel 2003 to Excel 2007
Part One: Forecasting
Collecting Data
Smoothing Techniques
Regression Analysis
Time Series Analysis
Expected Values
Selecting and Evaluating Forecasting Techniques
Part Two: Business Planning
Spreadsheet Skills for all Types of Planning
Developing a Financial Plan
Business Plans
What if Analysis
Pivot Tables
Risk Analysis
Part Three: Budgeting
A Spreadsheet Budgeting System
Consolidating Data.

Subject Areas: Accounting [KFC]