Previously Excel Consulting

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. 

Why choose Nexacu?

Valued by Individuals

 

4.8/5
Over 18890 Reviews
WELL SPOKEN -Excel Advanced Perth
RENAE - Excel Advanced, .
Course was very easy to follow and well paced. Steven was excellent at explaining everything and answering questions etc. -SharePoint Site Owner Brisbane
Louise - SharePoint Site Owner, .
Thank you for a very engaging training course Steven. Much appreciate all you knowledge and sharing you experience. -SharePoint Site Owner Brisbane
Ruth - SharePoint Site Owner, .
Great course highly recommended. -SharePoint Site Owner Brisbane
Andrew - SharePoint Site Owner, .
Great Course. Need better Coffee! :) -SharePoint Site Owner Brisbane
Rod - SharePoint Site Owner, .
Michael has offered a comprehensive training session with some real life suggestions. He was easy to understand and always happy to help. -SharePoint Site Owner Sydney
Claudio - SharePoint Site Owner, .
I thought the course was very informative. So much information and such little time. Could easily be a 3 day course. Thankyou Michael! -SharePoint Site Owner Sydney
Ben - SharePoint Site Owner, .
Very informative and interactive -SharePoint Site Owner Sydney
Arlene - SharePoint Site Owner, .
Great course with real life applications in mind. Course Instructor was clear and easy to understand while working at a pace which was comfortable. -Excel Macros/VBA 2 Day Brisbane
MIchael - Excel Macros/VBA 2 Day, .
Great energy by the instructor Ken. Material is great and up to date. Learned lots of new thing, tips, tricks. I would be interested if there will be any advanced training in the near future. -Power Apps Intermediate Melbourne
Ray - Power Apps Intermediate, .
John was a great instructor, the course was easy to understand and follow. John was also a entertaining instructor. I also learnt skills that i believe i can use straight away into my day to day job and enhance my projects. -Excel Macros/VBA 2 Day Melbourne
Katie - Excel Macros/VBA 2 Day, .
John is great! -Excel Macros/VBA 2 Day Melbourne
Peter - Excel Macros/VBA 2 Day, .
Great cousre -Project Advanced Canberra
matt - Project Advanced, .
Great course -Project Advanced Canberra
VI - Project Advanced, .
Greg was very knowledgeable in the course work, and answered all questions with various options relevant to my feild. Would recommend course to others. -Project Advanced Canberra
Brendan - Project Advanced, .
Danny was excellent. He was clear and thorough in his explanation. The course was very beneficial to our group. -Excel Advanced Sydney
Tanya - Excel Advanced, .
Thank you for guiding us through difficult concepts and customizing the course to our needs. We had a great time and really found the course to be very beneficial. Danny is an excellent trainer. -Excel Advanced Sydney
Marieke - Excel Advanced, .
lot of information -Excel Intermediate Perth
Heather - Excel Intermediate, .
excellent course, easy to understand and having the book to take home is useful in practice -Excel Intermediate Perth
Julie - Excel Intermediate, .
great teaching -Excel Intermediate Perth
Lisa - Excel Intermediate, .

Trusted by Business

Procured by Government

Map of Australia