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

Nugus, Sue

Softcover

ISBN 10: 1856175510 ISBN 13: 9781856175517

Publisher: CIMA Publishing, 2009

Synopsis

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.

• covers migration from Excel 2003 to Excel 2007 showing how to do it in both versions
• new edition now in full colour through out to aid quick understanding
• practical examples, tips and techniques - exploit Excel 2007 for effective management accounting
  

About this title

Book Description

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

From the Back Cover

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.

Edition details

• Publisher: CIMA Publishing
• Publication date: 2009
• Language: English
• ISBN 10: 1856175510
• ISBN 13: 9781856175517
• Binding: Paperback
• Edition number: 2
• Number of pages: 240