Ian Schnoor, Executive Director, Financial Modeling Institute
While financial models have become the most important decision-making tools in all areas of finance, the need for strong modeling skills is critical for another reason: Financial modeling is one of the most important skills to foster critical thinking and promote leadership development.
In a fast-paced, data-driven business world, leadership is defined by more than strategic vision. It is marked by the ability to analyze complex information, and guide teams with clarity and confidence.
Think about it: A 3-statement financial model, integrating the income statement, balance sheet, and cash flow statement, is not just a technical exercise. It is a framework for telling the story of a company: where it has been, where it is today, and where it could go. When you can build and understand a company’s financial model, you become the author of that story. As a result, you become the one who others look to for insight, guidance, and leadership.
Recognizing the importance of these capabilities, CFA Institute introduced Practical Skills Modules (PSM) to the CFA Program. One of the first modules to launch was the Financial Modeling PSM. This is because of the wide array of roles that rely on financial models to make business decisions. So let’s explore the power of developing financial modeling skills.
Financial Modeling: A Communication Tool for Leaders
A well-built financial model is more than rows of numbers and formulas. It tells the story of a company’s operations, financial health, and strategic potential. It connects data points into a coherent narrative that everyone from executives and board members to investors and lenders can understand and act on.
The person who builds the model gains a deep understanding of the business and can answer questions like:
By piecing together these elements, the modeler crafts the company’s financial story. And in doing so, that individual becomes the person colleagues, decision-makers, and external stakeholders rely on for understanding and insight.
Have you ever worked with a financial model that someone else built? Did you open the file and wonder what the heck was going on? This happens to all of us. And it’s not your fault. This is because the model was not designed well.
A good modeler may spend as much time planning and designing the financial model as building it. Why? The way a model is designed plays a role in how effectively it communicates the company’s story. Think of a financial model as a financial presentation. When a model looks like a PowerPoint deck that has a cover page, executive summary, assumptions and scenarios, the reader can easily follow the story. When the reader - likely your boss or your client, or a prospective lender or investor - can follow the story, they feel confident about your work. With a well-designed model in hand, you can communicate outputs and recommendations with poise, confidence, and assurance.
Building a financial model is an exercise in strategic communication. It challenges you to take complex, sometimes messy data, and present it in a way that informs and persuades. A model helps stakeholders evaluate trade-offs, explore scenarios, and make decisions with confidence.
When you learn how to model, you aren’t just developing great technical skills - you become a storyteller. You can use a model to:
In short, you can turn data into a narrative that will shape the future of a business or opportunity.
Just as strong leaders must process competing priorities, strong modelers must design frameworks that are precise, logical, and purposeful. Each formula and link is a decision that reinforces sound judgment.
Modeling demands attention to detail, thoughtfulness, and a disciplined approach—qualities that are required in leadership roles. A model that follows best practices becomes a shared tool within a team or organization to be used towards a common goal.
Leadership requires flexibility and the ability to think ahead. At its core, a financial model is simply a forecast - a tool to consider what might happen.
For example:
By engaging in this type of planning, modelers hone their critical thinking skills. They learn to challenge assumptions, identify leverage points, and build out best and worst case scenarios.
Modeling fosters research skills and management skills. When building a model, you will need to collect information from your teammates and your client. You will develop your interview skills to gather the data you need. You will coordinate the efforts of all the contributing professionals.
You probably will also want to read research reports and news articles. In short, the process of preparing to build your model is going to make you very smart about that company. Again, this means your peers and clients will look to you to understand the model and your assumptions. When you can build a good model, you develop a holistic view of the company, and understand how decisions in one area will impact others.
This article originally appeared in the CFA Society Toronto magazine, The Analyst. ‘Why Aspiring Leaders Should Learn to Build Financial Models,’ is relevant for finance professionals who want to strengthen their technical skills, communicate insights more clearly, and build the judgment needed to lead with confidence.
