What Is a Financial Model

In this tutorial, we will show you how to structure and build a financial model. An accurate, in-depth and well thought out financial model will provide you with the tools with which to project and forecast the future performance of your business.
Full
profile
Keith FernandezUnited States
A Harvard graduate pursuing his MBA at Wharton, Keith has executed numerous debt, equity, and M&A transactions and investments for global Fortune 500 corporations while working at leading Wall Street investment banks (Merrill Lynch) and private equity firms (KKR). He's an award-winning entrepreneur who enjoys freelancing to help advise clients on complex capital raising, M&A, corporate finance, and venture capital projects and transactions.
[click to continue…]
Financial Modeling ConsultantFundraisingFinancial Planning & Analysis (FP&A)
Hire
Full
profile
Andrew AzizUnited States
On Wall Street, Andrew evaluated and recommended purchasing the bonds of a ~$14 billion oil and gas producer, generating a 30%+ return in less than one year. Overall, he has invested in 4 companies generating ROIs of 20%+ on average and has worked as a research analyst at J.P. Morgan and Moody's. He hopes to use his hedge fund experience analyzing different types of businesses and securities to help executives be more successful in their efforts.
[click to continue…]
Financial Modeling ConsultantEquity ResearchValuation
Hire
Full
profile
Jordan T. MezoffUnited States
Jordan is a driven senior finance professional with extensive experience developing dynamic financial models for M&A transactions, growth strategy evaluation, P&L forecasting, pricing, etc. He has also leveraged his leadership experience to execute several M&A and commercial deals, as well as business process optimization and cost savings initiatives. Jordan now freelances to enjoy the excitement of M&A consulting and the freedom of remote work.
[click to continue…]
Financial Modeling ConsultantMergers & Acquisitions (M&A)Financial Planning & Analysis (FP&A)
Hire
Full
profile
Alexandros SiormpasNetherlands
Alexandros is a highly motivated and committed business professional with exceptional analytical and problem-solving skills. His international MBA and analytical roles in tier 1 firms (Samsung, Philips) have equipped him with superior business and commercial acumen. Now he freelances in order to contribute his expertise in engaging projects related to pricing, profitability, and financial planning.
[click to continue…]
Financial Modeling ConsultantFinancial Planning & Analysis (FP&A)Pricing AnalysisMarket Research
Hire
Full
profile
Darek PlonkaUnited States
Darek managed the raise of $1.8 billion through public debt securities and was in charge of investor relations for the fastest growing mobile network operator in Europe. Freelancing gives him the opportunity to help young companies in a variety of industries. Darek has extensive experience executing value creation strategies, which gives him a deep understanding of implementation challenges and a robust change management toolbox.
[click to continue…]
Financial Modeling ConsultantFinancial Planning & Analysis (FP&A)ValuationPricing AnalysisMarket Research
Hire
Full
profile
Thomas BachrachUnited States
Tom is the founder of PFH Capital, a single family office and financial consultancy, as well as a CFA charterholder. He has extensive experience across the financial spectrum—from bottom-up accounting and reporting to top-down analysis and valuation. He enjoys freelancing in order to work with a wide variety of clients. After graduating Cornell, Tom spent half a decade in Cairo, Egypt reporting to the CFO of a multinational construction firm.
[click to continue…]
Financial Modeling ConsultantFinancial Planning & Analysis (FP&A)
Hire
Full
profile
Michael OlafusiNigeria
Michael is an independent financial consultant with particular expertise in dashboards and modeling. He has worked with three of the largest telecommunications companies in Africa and built a dynamic portfolio model for a Canadian investment firm. He is one of the 125 Microsoft Excel MVPs in the world, which is the highest level of recognition Microsoft gives an expert in the real-world use of Microsoft Excel for business solutions.
[click to continue…]
Financial Modeling ConsultantMarket Research
Hire
Full
profile
Mark Zubov, CFAUnited States
Mark is an investment industry professional who has worked on $1.5 billion in buy-side and sell-side deals across M&A, equity, and debt capital markets. He's worked with major MNCs and Silicon Valley startups in the consumer, energy, tech, media, and life sciences sectors. As a freelancer, Mark enjoys sharing his passion for entrepreneurship with companies across the world—helping them with financial modeling, fundraising, and strategic planning.
[click to continue…]
Financial Modeling ConsultantMergers & Acquisitions (M&A)ValuationComparable Company Analysis
Hire
Full
profile
Charlie StroutUnited States
Charlie is an entrepreneurial financial analyst and product manager who leverages excellent communication skills and financial modeling techniques to provide strategic advice to companies, analyze companies for investment, and create financial analysis tools. He holds a joint-MBA from Columbia Business School and London Business School. He is freelancing because he enjoys working with a variety of companies all over the world.
[click to continue…]
Financial Modeling ConsultantEquity Research
Hire
Full
profile
Ethan BohbotUnited States
Ethan is an investment banking and hedge fund analyst turned entrepreneur. Drawing from experiences executing $5 billion+ in M&A transactions at Lazard and Blackstone as well as sourcing and evaluating long/short equity investments at a $1.5 billion hedge fund, he’s developed a strong foundation in financial modeling, M&A analysis, and equity research—skills that he enjoys leveraging as a freelancer to help a wider variety of clients.
[click to continue…]
Financial Modeling ConsultantMergers & Acquisitions (M&A)ValuationEquity ResearchMarket ResearchFinancial Planning & Analysis (FP&A)Comparable Company Analysis
Hire

What Is a Financial Model?

A financial model is a mathematical representation of how a company works. It is used to forecast the business’ financial performance, provide direction, and give context to uncertainty. Imagine it as a machine: We insert fuel in the form of assumptions, such as salaries and customer acquisition costs, which produces the output regarding projections of the company’s performance (e.g., future revenues and cash flows). Deciding which assumptions to use and understanding how to project accurately can be a difficult undertaking, although it’s well worth the cost, as sophisticated models end up serving as powerful decision-making and forecasting tools for management. Why else is modeling important? What are the different types of financial models, and how do we go about building a financial model?

Why Is Financial Modeling so Important?

The possibility of a financial model’s outputs perfectly matching reality is very low. After all, financial models are based upon a narrow set of assumptions from a range of possible inputs. With so much uncertainty, why should business owners bother themselves with building a financial model? And why do investors care so much about it?

Improved finance skills can lead to significantly increased opportunities of success and thus founders should invest in improving these skills. There are several reasons why founders should devote significant resources to building their model, which can be perceived as a manifestation of finance skills. Two of these reasons include:

  • A financial model gives direction on where the company is going. In other words, it can reveal the main business drivers and, in the case of significant deviation, provides insight on where the company should focus in order to manage or hedge risks.

  • It is a strong indication to investors that the founders know what they are doing and that they understand the business.  The various assumptions and reasoning behind the financial model demonstrate whether the founders are reasonable thinkers or not, meanwhile providing a necessary tool for the company’s valuation.

For these reasons, management should not just try to find a readily available financial model template to fill out. A template can provide an idea of how a model is built and indications of missing elements, but no more than this. After all, a financial model template represents a different business with different needs and characteristics. Instead, a proper financial model should be built from scratch. Custom models show that founders understand the nuances of their business and should demonstrate sharp business acumen. Given that the financial model is the analytical tool driving many of the projections and outputs in investor presentations, a well-built, sophisticated financial model increases investor confidence and the possibility of receiving funding. Thus, it can be a great investment to cooperate with a top financial modeling expert that can help you to create a robust model and help you manage and fully understand it.

How to Build a Financial Model

Prior to building your model, it is first important to select what type of model fits your needs most closely.

Main Financial Forecast Methods

There are two main methods to build a startup financial model: top down and bottom up.

Top Down

In a top-down approach, we start with the big picture and then work backwards; we define the milestones that we need to achieve in order to reach the target. For instance, if we have a mobile nutrition startup, we begin by saying that the market in 2017 is worth $27 billion and from starting at zero, by year 2, we will capture 7% of it. In this way, we just defined the revenue and then we calculated the costs associated with this target and so on.

Bottom Up

On the other hand, in a bottom-up approach, we start with basic assumptions (e.g., sales people needed and the cost thereof, attractiveness of our business, traffic) in order to build the financial model. Subsequently, we can create scenarios in order to check how the assumptions have to change (e.g., how many more salespeople we need) in order to achieve our goals.

Which Approach Should We Take?

A top-down approach, particularly in the case of a startup, can be rather opaque and based upon subjective, overly-optimistic predictions or even desires. This can put more value on a bottom-up approach towards leading to a better understanding of the model. On the other hand, the top-down approach can ignore today’s situation and provide useful inputs regarding milestones to be achieved.  Thus, for financial modeling purposes, the bottom-up approach can give a more structured, realistic perspective, which can be complemented from a strategic perspective with some top-down analysis.

How to Build a Financial Model, and What We Should Be Aware of

One you have decided upon the type of model to build, you should make sure that you develop an understanding of all the component parts that go into constructing a fully dynamic financial model.

A financial model has two main parts; the assumptions (input) and the three financial statements (output), namely income statement, balance sheet, and cash flow statement. Based on the individual company’s needs, more parts can be added, such as sources and allocation of capital, valuation, and sensitivity analysis (outputs based on different scenarios). Let’s have a look at the main characteristics of each of them, along with some financial model examples:

No. 1: Assumptions and Drivers

This should be the first tab in a spreadsheet and contain variables that will be used in the other tabs. Ideally, the rest of the tabs should have no manual input and every single number will be sourced and calculated from the assumptions tab.

The assumptions are unique to each business and include relevant topics of the business such as revenues (e.g., growth rate), costs (e.g., salaries), and capital (e.g., interest rate). The assumptions should be serious and reasonable numbers and thus should be a product of proper research (e.g., industry averages, expert opinions) but also critical thinking. For instance, a new startup has increased needs in marketing and thus should not blindly use the average spending of a few big, mature companies in the sector. In order to keep the list tidy, it would be better to have assumptions based upon the actual needs of the model and not just an infinite, difficult-to-use list. When building a financial model finding evidence, defining benchmarks and creating ranges regarding certain assumptions is also a recommended approach in order to reach robust conclusions.

Lastly, we can add some supporting schedules, as part of the assumptions or as separate tabs. For instance, if the business has debt, there should be an amortization schedule showing the repayments, interest payments, and the progress of the loan.

No. 2: The Income Statement

The income statement shows the revenues and the costs of a company and indicates if it has profits or losses. It is divided into two parts: operating and non-operating. If for instance a software company sells a property, the revenues for the transaction are non-operating, because real estate does not constitute its core business.

An income statement is quite straightforward, so why it is so useful? Well, an investor (as well as the entrepreneur) can check the forecast growth, the margin evolution, and the costs and their relative weight to the revenues.

With the assumptions in place, the income statement can be completed: revenues, direct costs, gross profit, operating expenses, EBITDA, non-operating expenses, earning before tax, tax, and net income, and it is ready. Of course, depending upon the level of detail we want, we can create sub-categories relevant to our business. If for instance we have a startup with more than one revenue source, under the revenue line we can add each of them (e.g., revenue from subscription, revenue from advertisement). However, reading the numbers is one thing and interpreting them is another. One of the most used metrics, EBITDA, is a good indicator of operating capabilities, but still has its own perils. Below, there is a visual example of an income statement. It should be noted that for the first year, it is better to have a monthly breakdown:

Image 1

No. 3: The Balance Sheet

The balance sheet is a snapshot of the business’ assets, equity, and liabilities.  It is an indicator of the financial health of the company, showing what it owns and owes. The major parts are the current and non-current assets, current and non-current liabilities, and equity. Balance sheets for startups are very important, because startups in their early days usually are loss-making and operate with no cash flows. So, it is crucial to track the net working capital balance, in order to plan in advance, even with the help of an expert. After building the income statement and putting the assumptions in place, we can easily translate them to the balance sheet. For instance, the sales/revenues will be reflected to the cash and accounts receivable (sales on credit) of the balance sheet, while the net income goes to the retained earnings. Below, there is an illustration of a simple balance sheet, connected to the previous income statement with supporting comments about how each entry is generated.

Image 2

No. 4: The Cash Flow Statement

As the saying in finance goes: “profit is an opinion, but cash is the fact.” This phrase illustrates how significant the cash flow statement is. Moreover, investors want to see what a startup does with its money, but also that it can pay what it owes, invest, and grow. Thus, one of their favourite metrics is the free cash flows that equate to Net Income + Amortization/Depreciation - Changes in Working Capital - Capital Expenditures and shows that a firm can pay for its own operations.

Having completed the income statement and the balance sheet, it is easy to build the cash flow statement. We start with the net income, then add back depreciation, adjust for changes in non-cash working capital, and then we have the cash from operations. Then, the cash used in investing is a function of capital expenditures, while the cash from financing can be found in the assumptions for raising debt and equity or in the balance sheet. Below, we can see a cash flow statement and how easy it is to build, after having built the two other statements:

Image 3

No. 5: Business Valuation and Sensitivity Analysis

When all the three statements are ready, we can proceed with the discounted cash flow analysis. Here, we estimate the free cash flow, as we described before, and we bring it to today’s value by using the opportunity cost or even the required rate of return. In this way, we can get a first glimpse at the value of the company. Moreover, now we can perform sensitivity analyses by modifying assumptions and creating various operating scenarios. In this exercise, we can see how the value of the company changes in different case in order to better assess risk and plan ahead if, for example, sales decline or marketing conversion drop more than expected.

Conclusion

Financial models are tools used to inform decision-making and arrive at projections. Financial models come into play at many stages in a company’s lifecycle, such as when the company seeks to raise capital, make acquisitions, budget, or simply understand how changes to any of the business’ drivers will impact overall performance. Given the importance of models at these critical junctions, it is essential that an experienced professional who can accurately capture the specifics of your business is behind the financial model.

Hire a Top Financial Modelling Consultant Now