Executive summary
This is a summary of the book by chapter presented in a tabular form.
PART A Developing financial models
| 1. | Overview | History of spreadsheets |
| Power of spreadsheets | ||
| Objectives of the book – good design method and templates for further use | ||
| Example of poor ‘flat’ spreadsheet | ||
| 2. | Design introduction | Follow design process and method for all models |
| Set aims and objectives | ||
| Examine user needs and required user interface | ||
| Set out key variables and rules | ||
| Layout | ||
| Produce the individual modules | ||
| Menu structure | ||
| Management reports and summaries | ||
| Development, e.g. sensitivity | ||
| Testing and auditing | ||
| Protection as an application | ||
| Documentation | ||
| Ask for peer group comments | ||
| 3. | Features and techniques ... |
Get Mastering Financial Modelling in Microsoft Excel 3rd edn, 3rd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
