Financial Modelling Knowledge Bank and FAQs

Essential Concepts in Excel and Financial Modelling

What is meant by “financial modelling”?

Here is some introductory reading about the meaning of modelling, financial modelling, the links to data analysis and key competences required.

[pdf-embedder url=”https://www.cinfm.co.uk/wp-content/uploads/securepdfs/2020/07/aModA.0.p.FinancialModelling.pdf”]

Was this helpful?
Like 2
What are the Essential Aspects of Excel for Beginners?

The following covers key points about structure, mapping of influence diagrams, menu items, dependency tracing, sensitivity analysis and basic Excel functions and arithmetic, and some best practices.

https://www.cinfm.co.uk/wp-content/uploads/securepdfs/2020/07/aModA.0.p.FinancialModelling.pdf

Was this helpful?
Like 2
Why do you consider data analysis to be a part of financial modelling?

Traditionally (and slightly simplistically speaking), modelling has been a topic in which a few key variables (also called inputs, independent variables or “drivers”) are used to calculate the values of dependent variables based on a knowledge (or assumed knowledge or hypotheses) about the behaviour of a system. Typically, a small number of input assumptions can result in large sets of calculations. The role of historical data would be to calibrate the model (e.g. estimate the value of the input assumptions, such as the average growth rate achieved in the past). On the other hand, traditionally, data analysis has involved using (possibly large) data sets to conduct a small set of calculations (e.g. calculate two linear regression coefficients based on thousands of data points)

In modern analysis, the boundaries between the two are disappearing: Not only are larger data sets available to be used in the traditional modelling sense, but also the evolving capabilities of Excel to work with relational databases and work with large data sets (e.g. PowerQuery and PowerPivot) mean that the tools are available to implement some types of models that could in the past only have been conceived of, but not readily implemented. Moreover, in some cases (such as some machine learning approaches), “the data is the model”; large data sets may be fed into algorithms which make predictions of the future, without any a priori definition of inputs/outputs nor directionality of logic.

Therefore, we believe that a professional financial modelling qualification needs to included data analytics, if it is to be credible and sustainable, and allow professional analysts to be versatile in their area of application, and in their approach to problem-solving and decision-support.

Was this helpful?
Like 2
Why is it hard to make good quality decisions, and what implications does this have for financial modelling?

[pdf-embedder url=”https://www.cinfm.co.uk/wp-content/uploads/securepdfs/2020/07/aModA.1.p.DecisionQualityModellingImplications.pdf”]

Was this helpful?
Like 2
What are the key properties of the IRR, and how can it be used correctly in decision making?

Please see the following pdf, which is a detailed analysis of the IRR. Happy reading!

[pdf-embedder url=”https://www.cinfm.co.uk/wp-content/uploads/securepdfs/2020/06/aModA.6a.3.w.IRR_.pdf” title=”aModA.6a.3.w.IRR”]

 

 

Was this helpful?
Like 2
No questions matching current filter