Financial Modeling in Excel For Dummies
Book image
Explore Book Buy On Amazon
Before you dive into creating financial models, you need to know what financial modeling is, who uses financial models, and why financial modeling matters.

What is financial modeling?

When asked to define financial model, many people come up with long-winded descriptions using terms like forecast and cash flow and hypothetical outcomes. But the definition needs to be that complicated. A financial model is a tool (typically built in Excel) that displays possible solutions to a real-world financial problem. And financial modeling is the task of creating a financial model.

You may have thought that a financial model was basically just an Excel spreadsheet, but as you know, not every spreadsheet is a financial model. People can and do use Excel for all kinds of purposes. So, what makes a financial model distinct from a garden-variety spreadsheet? In contrast to a basic spreadsheet, a financial model

  • Is more structured. A financial model contains a set of variable assumptions — inputs, outputs, calculations, and scenarios. It often includes a set of standard financial forecasts — such as a profit-and-loss statement, a balance sheet, and a cash flow statement — which are based on those assumptions.
  • Is dynamic. A financial model contains inputs that, when changed, impact the calculations and, therefore, the results. A financial model always has built-in flexibility to display different outcomes or final calculations based on changing a few key inputs.
  • Uses relationships between several variables. When the user changes any of the input assumptions, a chain reaction often occurs. For example, changing the growth rate will change the sales volume; when the sales volume changes, the revenue, sales commissions, and other variable expenses will change.
  • Shows forecasts. Financial models are almost always looking into the future. Financial modelers often want to know what their financial projections will look like down the road. For example, if you continue growing at the same rate, what will your cash flow be in five years?
  • Contains scenarios (hypothetical outcomes). Because a model is looking forward instead of backward, a well-built financial model can be easily used to perform scenario and sensitivity analysis. What would happen if interest rates went up? How much can we discount before we start making a loss?
More broadly, a financial model is a structure (usually in Excel) that contains inputs and outputs, and is flexible and dynamic.

Who uses financial modeling

Many types of people build and use financial models for different purposes and goals. Financial models are usually built to solve real-world problems, and there are as many different financial models as there are real-world problems to solve. Generally, anyone who uses Excel for the purpose of finance will at some point in his career build a financial model for himself or others to use; at the very least, he’ll use a model someone else created.

Bankers, particularly investment bankers, are heavy users of financial models. Due to the very nature of financial institutions, modeling is part of the culture of the company — the business’s core is built on financial models.

Banks and financial institutions must comply with current regulatory restrictions, and the tools and controls in place are forever changing and adapting. Because of the risk associated with lending and other financial activities, these institutions have very complex financial modeling systems in place to ensure that the risk is managed effectively. Anyone working in the banking industry should have at least a working knowledge of spreadsheets and financial models.

Outside the banking industry, accountants are big users of financial models. Bankers are often evaluating other companies for credit risk and other measures. An accountant’s models, however, are often more inward looking, focusing on internal operations reporting and analysis, project evaluation, pricing, and profitability.

Why financial modeling matters

A financial model is designed to depict a real-life situation in numbers in order to help people make better financial decisions.

Wherever there are financial problems or situations in the real world that need solving, analyzing, or translating into a numerical format, financial models help. Sometimes it’s just an idea or a concept that needs to be converted into a business case or feasibility proposal. A skilled financial modeler can put substance to the idea by augmenting the details enough to get a working model upon which decisions can be made, investor funds can be gained, or staff can be hired.

For example, financial models can help investors decide which project to put their money into, an executive track which marketing campaigns have the highest return on investment, or a factory production manager decide whether to purchase a new piece of machinery.

About This Article

This article is from the book:

About the book author:

Danielle Stein Fairhurstis a Sydney-based financial modeling consultant who helps her clients create meaningful financial models for business analysis. She is regularly engaged around Australia and globally as a speaker and course facilitator. She received the Microsoft MVP Award in 2021 in recognition of her technical expertise and contributions to the community.

This article can be found in the category: