This second edition of Practical Financial Modelling is vital tool for all finance and management professionals whose work involves the production and development of complex spreadsheets and financial models. The author bridges the gap between the Excel manual and financial literature with a wealth of practical advise and useful tips. The book identifies good practice and highlights those areas which are prone to error and inconsistency resulting in a refreshingly simple approach to building and using financial models suitable for novice and experienced modellers. By using practical worked examples the most effective ways in which problems can be solved are explored. Key themes include: model structure, audit formulae and functions and model use. New to the second edition: Instructive information on Excel 2007 and its enhanced modelling functions and feature; Risk controls in developing and using financial models; Test-yourself modelling problems and applied examples in every chapter; Substantial information related to reporting and charting techniques and an appendix devoted to parallel comparison of how-to in Excel 2003 and 2007. ac Instructive information on Excel 2007 and its enhanced modelling functions and features ac Risk controls in developing and using financial models ac Test-yourself modelling problems and applied examples in every chapter ac Substantial information relating to reporting and charting techniques ac An appendix devoted to a parallel comparison of how-to in Excel 2003 and Excel 2007... the circular code itself (the formula which directly or indirectly refers to itself), and the a#39;non-calculating-dependent cella#39;. ... Debugging circularities We have all had occasions when we have written a trivial formula and suddenly Excel fires up the ... If you are lucky, the blue audit lines which then fill your workbook are meaningful and you can locate the source of the ... warning dialog box and closed down the so-called Help window and the circular reference toolbar, note the Circularanbsp;...
|Title||:||Practical Financial Modelling|
|Publisher||:||Butterworth-Heinemann - 2009-12-01|