ICAEW.com works better with JavaScript enabled.

Intro to Financial Modelling

This series from the Excel Community's Financial Modelling committee works through the chapters of our Financial Modelling Code and explain how each element translates into practice.

You can read the Code here or watch our free webinar about it.

Series articles

Intro to Financial Modelling - Part 1: Model definition and purpose

Alistair Hynd 23-01-2020

The development and use of financial models in Excel continues to proliferate, as does the variety of approaches and methodologies adopted. Without a universally accepted set of agreed principles, it can be difficult to know what good looks like in financial modelling terms.

Intro to Financial Modelling - Part 5: User interface and transparency

Alexander Carse 21-05-2020

In this instalment of the blog series, I will be talking about the principles covered in page 6 of the Financial Modelling Code, “User interface and transparency”. User interface and transparency sit together as a section of the financial modelling code because they are two sides of the same coin, by striving to enhance either one of these you will go a long way towards achieving the other.

Intro to Financial Modelling - Part 7: Consistency - Timeline

Jonelle Johnson-Turner 23-07-2020

In this instalment of the series, we examine the “Use consistent placement” principles, as covered in page 9 of the Financial Modelling Code. The previous article explained the importance of consistency in formula blocks. Here we consider the need for consistent structure in models, specifically timelines.

Intro to Financial Modelling - Part 8: Clarity - Use of formatting

John Yeldham 12-08-2020

The ICAEW’s Financial Modelling Code includes a sensible set of guidelines to help you prepare financial models that work for you and the model user. When preparing a model, one can use formatting to guide the user’s eye, to give context to the contents of cells, to make the model easy to read and provide the right level of detail.

Intro to Financial Modelling - Part 10: Clarity, Units and sign convention

Premium Content: This is exclusive item - please log in or subscribe to view this item.

Jo Hayes 22-10-2020

Continuing under the “clarity” chapter of the financial modelling code, we arrive at the guidance on units and sign convention. When building a model, if we aren’t clear about these, we are setting ourselves up for a world of confusion, and potential modelling catastrophe!

Showing 10 of 19 items