Introduction to Financial Modelling

Principles of Excel as a Modelling Tool

Chapter 2: Excel Foundations

8 Topics | 1 Quiz
Chapter 3: Sensitivity Analysis

10 Topics | 1 Quiz
Excel Operations, Structures and Short-Cuts

Chapter 4: Operations and Short-cuts (I)

6 Topics | 1 Quiz
Chapter 5: Common Structures within Financial Models (I) – Arithmetic Based

7 Topics | 2 Quizzes
Chapter 6: Operations and Short-cuts (II)

15 Topics | 1 Quiz
Introduction to Excel Functions

Chapter 10: Dynamic Arrays and Array Functions

4 Topics | 1 Quiz
Applications of Lookup and Reference Functions

Chapter 14: INDEX and XLOOKUPs

5 Topics | 1 Quiz
Planning and Building Models for Optimal Decision Making

Chapter 17: From Planning to Practice

16 Topics
The essence of modelling is the use of formulas to express the relationships between the variables.

The simple model for Sales Revenue in the previous chapter can be developed further, in order to include the cost and profit of the business. For example, the Total Cost could be made up of costs which are fixed (such as some staff costs and overheads) and those which vary with volume (such as raw materials) and Profit would be the Sales Revenue less the Total Cost.

The corresponding Excel model requires the use only of standard arithmetic operations. In words:

- “Sales Revenue is Price multiplied by the Volume in units”.
- “Variable Cost is Variable Cost per Unit multiples by the Volume in units”.
- “Total Cost is Variable Cost plus Fixed Costs Overhead”.
- “Profit is Sales Revenue less Total Cost”.

The image below shows an influence diagram for this situation:

and the corresponding Excel model is shown here:

(Here, the diagram and model each follow a common colour-coding scheme: Blue text and grey fill for inputs, black text without fill for intermediate calculations, and black text with green fill for calculations which are also considered as outputs.)

Before building models, one should therefore have a mechanism to conceive and plan for the variables to be included, the flow of their logic, and so on.

This website uses cookies to improve your experience. We'll assume you accept this policy as long as you are using this websiteAcceptView Policy

Scroll to Top
error: **Alert:** Content is protected !!

Login

Accessing this course requires a login. Please enter your credentials below!