Mastering Financial Modelling in Microsoft Excel 3rd edn, 3rd Edition

25

Modelling checklist

Introduction

Design summary

Features

Techniques

INTRODUCTION

The directory of models includes a model called MFM3_25_Checklist, which includes three schedules to summarise the modelling process.

DESIGN SUMMARY

The process outlined in Figure 25.1 has been used throughout the book for the initial chapters on design and features and the subsequent applications files. In particular, the division into areas of activity such as inputs, calculations, workings and reports helps users to understand the model more quickly and aids rapid model development with fewer errors.

Figure 25.1 Design summary

Modelling is a development ...