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 23083 Reviews
The course provided a great base to continue my learning with Power BI. -Power BI Beginner Melbourne
Chris - Power BI Beginner, .
John was direct and concise with his delivery. As a Supervisor I am now more prepared to request reports of the types I require . Long day but excellent information and paced well. Thank you -Power BI Beginner Parramatta
Glenda - Power BI Beginner, .
Very interesting course. John was great but the course was a lot to take in one day, maybe it should be split into 2 sessions over 2 days. -Power BI Beginner Melbourne
kaan - Power BI Beginner, .
Very informative and easy to follow. Patient and communicated well Now have a better understanding of how to set up Power BI reports. -Power BI Beginner Melbourne
Melanie - Power BI Beginner, .
Steven has a great knowledge and great present skill for the day. the course was well designed. satisfied with everything. Thank you -Power BI Beginner Brisbane
Megan - Power BI Beginner, .
Hands on, enjoyable training. Thank you Steven -Power BI Beginner Brisbane
Catalina - Power BI Beginner, .
Good intro into the world of Power BI. Hope to be able to put it into practice straight away -Power BI Beginner Brisbane
Raelene - Power BI Beginner, .
Useful course and excellent trainer -Power BI Beginner Brisbane
Rajesh - Power BI Beginner, .
Course was well structured and paced. Steven was a knowledgeable instructor. -Power BI Beginner Brisbane
Brianna - Power BI Beginner, .
Really good fun and informative with Steven, as always. -Power BI Beginner Brisbane
James - Power BI Beginner, .
Thank you! See you again for intermediate and advanced -Excel Beginner Brisbane
JULIE - Excel Beginner, .
Jason was an awesome instructor that had my full attention for the duration of the course. I really enjoyed the hands on experience & being able to follow along with my own laptop. Thank you for an amazing course! -Excel Beginner Brisbane
Emma - Excel Beginner, .
Well delivered class! Definitely learnt a lot and had a laugh which was good. Thank you Jason, you're an excellent teacher. -Excel Beginner Brisbane
Layla - Excel Beginner, .
Very much enjoyed the course, easy to understand and follow, I feel like I have a better understanding of the program now so thank you Jason! -Excel Beginner Brisbane
Serena - Excel Beginner, .
Excellent course -Excel Beginner Brisbane
Nahan - Excel Beginner, .
AMAZING! So grateful I completed this. See you for intermediate and advanced soon :) -Excel Beginner Remote Online
JULIE - Excel Beginner, .
made sense of what i have been trying to achieve since moving into an office environment -Excel Beginner Brisbane
Joseph - Excel Beginner, .
Excellent trainer -Excel Beginner Brisbane
Peter - Excel Beginner, .
Really helpful - good teacher -Excel Beginner Brisbane
Martin - Excel Beginner, .
Great session with Jason as always -Excel Advanced Remote Online
Rebecca - Excel Advanced, .

Trusted by Business

Procured by Government

Map of Australia