O'Reilly logo

Hands-On Financial Modeling with Microsoft Excel 2019 by Shmuel Oluwa

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Building a template for your model

It is always important to be systematic in the way you build and maintain your model. Even if you alone will make use of the model, whenever you have cause to revisit the model after a period of time, you would not want to have to wade through various schedules and worksheets to find what you need.

This is even more important if your model is going to be used by someone else.

A good way to ensure that your model is easy to follow, and use is to build a template (a standard format) with some simple rules guiding how data is to be input and presented. In general, you will require at least six columns of figures, three each of historical and projected years, and another three or four columns for descriptive ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required