All courses available in-class or via remote login

What is Financial Modelling

What is Financial Modelling?

May 31, 2018

Financial Modelling featured quite prominently in my previous roles. I have often been asked "What is Financial Modelling exactly?"

Financial Modelling is a general term and can mean different things to different people. It's no wonder there is confusion around the term so how should we define it?

Financial Modelling is the practice, or some may say art, of building a mathematical model to evaluate or assess a financial situation. These models are most commonly built in Excel. The purpose is as wide and varied as the business opportunities out there. However there are three core elements common to all financial models.

  1. Inputs
  2. Calculations
  3. Results

The purpose of building a financial model is often to assist in decision making. The model gives the end user the ability to play with the inputs or assumptions and view what the result will be. For example a manufacturing manager could change an assumption about the number of man hours rostered for a week. Therefore, he can view the impact it will have on the profitability of a particular function. Alternatively, a Trader could change the assumption of expected defaults and see the impact on the price of a given bond. A Designer could change her suppliers costs as see the forecasted impact on her cashflow.

The models are different but in essence take raw inputs and convert them into meaningful results. Consequently which have the ability to support judgement and guide decision making. They key to building financial models is to make sure they are dynamic so that the user can vary the assumptions and see the impact. This ability to perform scenario analysis is what makes the model so valuable.

Dashboards are often layered onto Financial Models and can be a powerful addition. Visuals can communicate key metrics quickly and clearly. Therefore, the end user can focus on the most important results allowing them to spot trends, opportunities or threats.

Is Financial Modelling only for Financial Markets?

No. Financial Models are clearly used to a great deal within financial markets. To determine the value of a range of investments but the application of financial models is much wider than the markets. Models are used in all businesses to determine value, monitor forecasts and budgets, assess performance etc. They may or may not include a full set of financial statements, that will be driven by the purpose of the model.

Excel is still the go to application for building Financial Models. Its robust and flexible but as all users proceed with caution and audit your models. If you are beginning your journey into Financial Modelling or just want to understand more about the models you deal with in your role then you may be interested in our Financial Modelling Course. You will work through several case studies on our course, learning how to design models, use formulas, functions and tools relevant for modelling. Financial functions are introduced but the course is not a financial theory or financial maths course it is an introduction to building models in Excel in accordance with our Best Practice Framework. 

What is Remote Training?

Valued by Individuals

 

4.8/5
Over 21481 Reviews
Good Overview - got what i needed -Office365 Beginner Melbourne
robert - Office365 Beginner, .
Got a lot of today thanks -Office365 Beginner Sydney
Courtney - Office365 Beginner, .
Excellent Course. Michael was very good at explaining the concepts. -Office365 Beginner Sydney
Mark - Office365 Beginner, .
easy to follow, friendly.. -Excel Beginner Adelaide
Shane - Excel Beginner, .
good course just need to apply to cement knowledge -Excel Beginner Adelaide
Mathew - Excel Beginner, .
Very good course, well presented and communicated throughout -Excel Beginner Adelaide
Brian - Excel Beginner, .
very informative and explained clearly -Excel Beginner Adelaide
Richard - Excel Beginner, .
great start to learning your way around -Excel Beginner Adelaide
Daniel - Excel Beginner, .
The course was fairly concise and easily consumed. Steven did a great job of adjusting the material and delivery for the Army environment, which can be less than accommodating at times. I personally found the material to be very simple and easily understood, but some of my classmates were not quite on the same page so I think it was appropriate for the audience receiving it. -SharePoint Site Owner Brisbane
Joel - SharePoint Site Owner, .
The training facilitated by Steven was to a very high standard. Although some of our course members were interrupted by some real time events happening in the background, Steven was able to adapt and focus on delivering some good training. He has an excellent instructor presence. -SharePoint Site Owner Brisbane
Phil - SharePoint Site Owner, .
Steven was a excellent instructor. He was able to tailor his package to our requirements and remained flexible to our demanding work requirements. His lessons were well developed and his instructional style was patient and professional. -SharePoint Site Owner Brisbane
Andrew - SharePoint Site Owner, .
Jagg was an excellent trainer - very patient, had lots of options for people who didn't have the newest versions. I feel really confident about what I learnt today and I am very happy I did this course! -Power BI Beginner Adelaide
Melissa - Power BI Beginner, .
Excellent! Very knowledgeable instructor. -Power BI Beginner Adelaide
Jason - Power BI Beginner, .
Great course, very informative. Great instructor, very helpful -Power BI Beginner Adelaide
Sarah - Power BI Beginner, .
Great session, moves at a good pace with support when needed. Thanks -Power BI Beginner Adelaide
Matthew - Power BI Beginner, .
Excellent! -Microsoft Applications - Customised Sydney
Candice - Microsoft Applications - Customised, .
Very helpful -Microsoft Applications - Customised Sydney
Janet - Microsoft Applications - Customised, .
The learning environment and facilities are great. Ken knew the course content and is a friendly trainer.. -SharePoint Site Owner Melbourne
Robbie - SharePoint Site Owner, .
Thank you Ken Great 2 day of learning lots of information, looking forward to making our New Company SharePoint Site -SharePoint Site Owner Melbourne
Natasha - SharePoint Site Owner, .
Thank you Ken, I feel a lot more empowered and up-skilled with regards to SharePoint. I am looking forward to supporting my organisation to leverage SharePoint as one of collaboration and information management tools. -SharePoint Site Owner Melbourne
Annita - SharePoint Site Owner, .

Trusted by Business

Procured by Government

Map of Australia