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. 

Contact Us

What is Remote Training?

Valued by Individuals

4.8/5
Over 24317 Reviews
It was very educational. Steven explained all very clear. I definitely will use it in my work. cheers -Excel Advanced Brisbane
Olga - Excel Advanced, .
Found a number of things that I will be able to take back to the office and use. Steven presented and kept things flowing well. -Excel Advanced Brisbane
Amanda - Excel Advanced, .
The session was delivered in efficient way. Gained so many knowledge, new way of creating report based on data available. -Excel Advanced Brisbane
Ratih - Excel Advanced, .
Steven is a great tutor -Excel Advanced Brisbane
Donna - Excel Advanced, .
Great session. Very helpful. -Excel Advanced Brisbane
Jacinta - Excel Advanced, .
Steven was very patient, very knowledgeable and I learnt a lot while having a great time. Thanks heaps :) -Excel Advanced Brisbane
Chris - Excel Advanced, .
great course thank you -Excel Advanced Brisbane
Jodi - Excel Advanced, .
Good Course -Power BI Advanced Brisbane
Sunmeen - Power BI Advanced, .
Well done, knowledgeable presenter -Excel Advanced Brisbane
Chester - Excel Advanced, .
Great pace and content, trainer explained everything very well. -Power BI Advanced Brisbane
Ana - Power BI Advanced, .
Another very informative day with a full morning on DAX, a good look at dynamic row level security and other useful tools. A lot of information, but very helpful! -Power BI Advanced Brisbane
Karen - Power BI Advanced, .
It went a bit fast for topics that were new to me. For topics that I had a good understanding the pace was fine. -Power BI Advanced Brisbane
Robin - Power BI Advanced, .
Very informative, learnt a lot in one day! -Power BI Advanced Brisbane
Ashlee - Power BI Advanced, .
very good session -Power BI Advanced Brisbane
Lucy - Power BI Advanced, .
great session, very informative Jason is a great teacher! -Power BI Advanced Brisbane
Peter - Power BI Advanced, .
valuable session and definitely learnt some new things around our reporting presentations moving forward but also around our animations. Loved how interactive it was and that it is hands on being able to do the live training. -PowerPoint Level 2 Brisbane
Charmaine - PowerPoint Level 2, .
Stuart was a fantastic presenter. He really engaged everyone. I learnt a lot of great tips and tricks and can see them being used on a regular basis. Certainly some "ah ha!" moments too. Run really well and highly recommend Stuart as a presenter. -PowerPoint Level 2 Brisbane
Katrina - PowerPoint Level 2, .
Good presentation. Kept the day interesting and lots of learnings even though this is not my first powerpoint training session. Learnt some great useful skills I'm looking forward to trying out soon! -PowerPoint Level 2 Brisbane
Celia - PowerPoint Level 2, .
Stuart was very personable and an engaging presenter. -PowerPoint Level 2 Brisbane
John - PowerPoint Level 2, .
thank you Stuart, enjoyed the course very much, had a lot of take away. -PowerPoint Level 2 Brisbane
Susanna - PowerPoint Level 2, .

Trusted by Business

Procured by Government

Awards and Accreditations

Map of Australia

Follow us