Financial Planning Using Excel: Forecasting, Planning and Budgeting Techniques (CIMA Professional Handbook)

Excel for Financial Planning 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 and includes a useful CD-ROM containing worked examples and spreadsheet templates, for easy budgeting.

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

Financial Planning using Excel is a must for anyone who uses this product for financial planning. It will be useful to all management accountants - both qualified and still in training. The book contains a wealth of practical examples, tips and 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 organisation.

Financial Planning using Excel covers all aspects of financial management, from forecasting to preparing financial plans through to the preparation and management of budgetary control systems.

Topics include:
* financial forecasting using smoothing techniques, regression analysis, time series analysis etc
* designing and creating a series of financial plans
* different types of business plans including traditional projections as well as advanced techniques including statistical planning and optimising models
* a range of what-if tools including data tables, sensitivity analysis and goal seeking features
* managing a budgetary control system featuring the summary and aggregation of data from multiple sources.