SaraDaddy

Financial Planning Using Excel Forecasting, Planning and Budgeting Techniques

Author : Sue Nugus
Publisher : CIMA Publishing
2nd Edition
Date : February 16, 2009
Language : English
Included Lessons Files
PDF Format
Pages : 240
Size : 12,42 Mb

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

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

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.

https://www.filefactory.com/file/6hc4ps4nxstr/