Invaluable guide to build models for assessing business risks and
opportunities
This guide is full of practical help to creating
business models for evaluating everything from a modest business development to a major
acquisition.
Preface vi
1 Introduction 1
2 Using Excel 6
3 Essential functions and features 23
4 The business model planning and development process 40
5 Defining the outputs 46
6 Uncertainty, scenario planning and model inputs 53
7 Developing the scenarios 59
8 Managing the model-building process 65
9 Best practice in model structure and sheet design 73
10 Graphical presentation 89
11 Forecasting revenue 105
12 Operating costs 141
13 Capital expenditure and working capital 152
14 Modelling funding choices 170
15 Financial statement development 181
16 Project appraisal and company valuation 191
17 Testing and debugging 212
18 Introduction to programming and macros 222
19 From spreadsheet to application 246
20 Driving the model 256
21 Documenting the model 268
Appendix
Spreadsheet functions 275
Index 283
288 pages,Hardcover