|
|
Usually ships within 5 to 7 working days
|
- Product code: 23758
- ISBN: 0750663561,
ISBN13: 9780750663564,
160 pages, paperback
Published by CIMA Publishing on 2004
, New title Rate this book...
Rating: 0.0/5 (0 votes cast)
|
|
|
|
|
Description of Practical Financial Modelling |
This book is for all financial professionals whose work, to a greater or lesser degree, involves complex spreadsheets and financial models. This includes investment bankers, commercial banks, accountancy firms, property firms, public sector including local government and healthcare, PFI/PPP enterprises, financial managers and financially literate general managers. Junior/middle management, where the focus would be on cash flow forecasting and budgeting tasks, will also find this book of value. For the vast majority of people involved in this subject, financial modelling is an activity, a task requiring skills. Once people have the ability to structure the model, they have a better starting point from which to address the financial problems. This new book proposal intends to offer that starting point.Theory is limited to the absolute essentials that aid understanding; thus the focus with this new book is very practical - this is 'how-to-do-it', showing best practice, and is illustrated with many practical worked examples. "Practical Financial Modelling covers all the essentials in one book. It includes how-to approach, with numerous worked examples.
It also explains the techniques and functions of Excel most use in financial modelling and budgeting.
|
Contents of Practical Financial Modelling |
Context:
Introduction
Definitions
Descriptions
Common approaches
Structure
Inputs
Workings
Outputs
Variations
Support
Documentation
Navigation
Content:
Formulae
Range names
Corkscrews
Masks and switches
Recalculation
Circularities
Functions
Logical
Lookup
Financial
Other
Custom
Quality control:
Audit
Audit sheet
Structural checks
Arithmetical checks
Financial checks
Model Use
Grouping
Data validation and Dropdown lists
Conditional and custom formats
Sensitivity analysis
Reporting - Reports, Charting, Printing
Automation
Macros
Appendix;
Keyboard shortcuts
References
Further information
index
|
About Jonathan Swan |
Following a career in the Army the author has been teaching spreadsheet applications in the City of London since 1991. His work has encompassed a range of consultancy and development assignments working with investment banks and others in the City and throughout Europe. For the past five years he has been working at Operis Group plc, the UK's leading independent financial modelling consultancy, where he is director of the training division of the company. Operis teach the fundamentals of financial modelling to over a thousand professionals each year, from backgrounds that include banking, accountancy, financial analysis, and management. With the rest of the company working on major modelling projects in the PFI/PPP sector and elsewhere, their training is based on the latest practice in the industry.
|
 Buyers of Practical Financial Modelling also bought
Bulk buying
| If you need bulk copies of Practical Financial Modelling, or are interested in opening a corporate account, please contact us. |
|
|
Shopping basket