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 ConsultantFinancial Planning & Analysis (FP&A)Fundraising
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 ConsultantComparable Company AnalysisEquity ResearchMarket ResearchValuationMergers & Acquisitions (M&A)Financial Planning & Analysis (FP&A)
Hire
Full
profile
Gaston DepusoirUnited States
Gaston is Travel Noire’s director of finance operations. He's responsible for budgeting, financial projections, and analytics. Prior to his current role, he's had experience in FP&A, M&A consulting, and investment banking. As a freelance consultant, Gaston enjoys working with early/mid-stage companies to develop their forecasting models, metrics, and analytics. Gaston also has an interest in clients in the travel and leisure industries.
[click to continue…]
Financial Modeling Consultant
Hire
Full
profile
William RutkoskeUnited States
William recently served as a portfolio manager at the Harvard endowment before becoming an entrepreneur-turned-freelancer. Prior to Harvard, he spent 11 years investing in public and private companies for a $2 billion family office after having advised companies on M&A and capital raising activities at Deutsche Bank. William enjoys working with interesting companies to help them maximize their value, all the while continuing his global travels.
[click to continue…]
Financial Modeling ConsultantMergers & Acquisitions (M&A)Valuation
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 ConsultantSASMarket ResearchPricing AnalysisValuationFinancial Planning & Analysis (FP&A)
Hire
Full
profile
Cory AzzalinoUnited States
Cory is a CPA with over 9 years of experience in accounting and private equity, where he invested over $1B across 20+ transactions. He left private equity to start a venture-backed marketing IOT company while continuing to freelance for family offices, private equity funds, and public companies. He has a diverse experience in business development, capital raising, technology development, and transaction execution.
[click to continue…]
Financial Modeling ConsultantVenture CapitalFinancial Planning & Analysis (FP&A)Mergers & Acquisitions (M&A)
Hire
Full
profile
David SeamansUnited States
Dave is a member of an advanced analytics team at a leading management consulting firm. He has extensive experience in building financial models (including valuation), data analytics, and financial planning and analysis. Prior to his current role, Dave raised debt and equity as an advisor for Merrill Lynch and as a partner of a hedge fund. As a freelancer, he enjoys helping a wider variety of clients solve financial problems.
[click to continue…]
Financial Modeling ConsultantFundraisingValuation
Hire
Full
profile
Kiel LaFranceUnited States
As an investment banker and now the head of a financial modeling team at S&P Global, Kiel has advised and built thousands of models for clients ranging from investment banks to small corporations. He has experience in various models and modeling techniques—with an emphasis on valuation, projections, and competitor analysis. Due to his experience in financial modeling, Kiel served as a judge in the first ever Financial Modeling Championships.
[click to continue…]
Financial Modeling ConsultantValuation
Hire
Full
profile
Martin ConcannonUnited States
With over 20 years of financial and strategic consulting experience, Marty has led projects in 8 countries. He recently analyzed sales performance for over 100 leading US food and beverage brands—presenting to executives of those brands as well as several industry conferences. He has a passion for finding the business stories hidden among the data, and joined the Toptal network to find challenging projects and to work with talented people.
[click to continue…]
Financial Modeling ConsultantFinancial Planning & Analysis (FP&A)
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