Financial Modeling Best Practices: 10 Tips to build a World-Class Model

In the ever-evolving world of finance, mastering financial modeling is key for many organizations to forecast and predict the future. This sentiment was palpably evident in the recent webinar led by Ian Schnoor, Executive Director of the Financial Modeling Institute (FMI). The session is geared toward demystifying the complexities of financial modeling.

The Journey Through Financial Modeling

Ian took the attendees through the workings of sound financial modeling, starting with the basics and moving towards more complex constructs. He emphasized the importance of clean, logical models that can be understood and utilized effectively across business functions.

Demonstrations and Practical Applications

The heart of the webinar was Ian's live demonstrations on Excel. These were not just about showing formulas but about showing how to structure thinking around financial models:

1. Building Assumptions: Ian showed how assumptions are the bedrock of any financial model. He demonstrated how to keep them organized and upfront, making them easy for users to find and adjust.

Focus: Ian emphasized the importance of organizing assumptions at the beginning of a financial model. This helps in making the model transparent and easy to adjust.

Tools Used: He demonstrated how to input assumptions using Excel functions, ensuring they are clearly marked and located at the forefront of the model for easy access.

2. Scenario Analysis: One of the key highlights was the creation of a scenarios page, crucial for managing uncertainty in financial forecasting. Ian explained how to set up scenarios to model different outcomes based on varying inputs.

• Objective: The scenario analysis is crucial for managing risks and uncertainties in financial modeling.
• Execution: Ian showed how to create a scenarios page, which allows modelers to prepare for various financial outcomes by adjusting key input variables.
• Excel Functionality: He utilized Excel to demonstrate how scenarios can be switched easily through simple inputs, facilitating dynamic changes across the model.

3. Best Practices: Ian discussed the importance of using specific colors for different types of data (inputs vs calculations), which helps in maintaining clarity and reducing errors.

• Excel Functions: Throughout the webinar, Ian used functions like CHOOSE, IF, and INDEX to demonstrate how to manipulate data effectively within a model.
• Effective Communication with Financial Models: He stressed that a good financial model should also serve as a powerful communication tool. He highlighted how to structure a model to present it effectively to stakeholders, including setting up an executive summary and clear, concise assumptions.

6. Tool Demonstrations

• Watch Window: One of the practical Excel tools Ian highlighted was the 'Watch Window'. This tool helps users monitor specific formulas and their impacts on the model in real-time, which is especially useful when dealing with complex models that have interconnected parts.

Ian encouraged questions and provided real-time solutions to specific problems posed by attendees. This approach not only kept the audience engaged but also ensured that they could apply the knowledge effectively. 

Ian wrapped up the session with some critical takeaways:

• The Role of Financial Modeling: Understanding that financial modeling is not just about crunching numbers, but about storytelling. It's about presenting a narrative that supports business decisions.
• Future of Financial Modeling: Emphasizing that as business becomes more complex, the demand for skilled financial modelers will only increase. He inspired attendees to continue honing their skills and stay curious.

The webinar concluded on a note of friendliness, with Ian and David reiterating their passion for teaching and sharing knowledge. For attendees, the session was more than just a learning experience—it was an invitation to be part of a global community that speaks the common language of financial modeling.

For those looking to dive deeper, Ian reminded everyone that the recording would be available(check above), ensuring no one would miss out on the valuable insights shared. 

Download all Webinar Resources

Join the Financial Modeling Academy.

The Financial Modeling Academy is an intensive 8-week online program that takes participants through the journey of becoming an Advanced Financial Modeler a designation awarded by the Financial Modeling Institute Canada. The program has been designed to accommodate your busy schedule. Therefore, you are required to go through video content and resources at your own pace during the week. On Saturday of each week, we will proceed to have a Live Virtual Session with you on Zoom.

Register Now!