4

Sample model

Introduction

Aims and objectives

User needs and user interface

Key variables and rules

Breaking down the calculations into manageable groups

Setting up individual modules

Menu structure

Program sheets and macros

User assistance

Summaries

Risk and multiple answers

Testing and troubleshooting

Protecting and securing

Help and documentation

Show to peers – take their advice

Control loop – listen, learn and modify

Summary

INTRODUCTION

The first chapter reviewed a simple model and listed a number of shortcomings with the design methodology. This section reintroduces the model (MFM3_01_Simple_Model.xls) and progresses through the design using the methods in Chapters 2 and 3. As already stated, it is imperative to use a consistent ...

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.