Financial Modeling

Loading the player...

What is 'Financial Modeling'

Financial modelling is the process by which a firm constructs a financial representation of some, or all, aspects of the firm or given security. The model is usually characterized by performing calculations and makes recommendations based on that information. The model may also summarize particular events for the end user such as investment management returns or the Sortino ratio, or it may help estimate market direction, such as the Fed model.

BREAKING DOWN 'Financial Modeling'

It is the goal of the analyst to accurately forecast the price or future earnings performance of a company. Numerous valuation and forecast theories exist, and financial analysts are able to test these theories by recreating business events in an interactive calculator referred to as a financial model. A financial model tries to capture all the variables in a particular event. It then quantifies the variables and creates formulas around these variables. In the end, the model provides the analyst with a mathematical depiction of particular business event. The primary software tool used to do this is the spreadsheet. Spreadsheet language allows the financial modeler to reconstruct almost any cash flow or revenue stream.

Users of Financial Models

Financial models are used for many different reasons. The most common of which are business valuation, scenario preparation for strategic planning, cost of capital calculations for corporate finance projects, capital budgeting decisions and the allocation of corporate resources. Financial models are also used in the creation of projections and trends for forecasts and many other uses related to industry comparisons, ratio analysis and common size financial statements.

Financial Modeling Example

There are myriad variables at play in the determination of a forecast or valuation. Analysts can isolate the most sensitive of these variables by creating models and then testing the model with different inputs. The inputs are then used to create a set of outputs that determine the impact of a change in one variable on another. The best financial models are simple and provide users with a set of basic assumptions. As an example, one commonly forecasted line item is sales growth. Sales growth is a function of current sales and prior quarter sales. These are the only two inputs a financial model needs to calculate sales growth. The financial modeler creates one input cell for the prior year's sales, cell A, and one input cell for the current year sales, cell B. In the third cell, cell C, the analyst creates a formula that divides the difference between cell A and B by cell A. This is the growth formula. Cell C is a formula and hard coded into the model. Cells A and B are considered input cells for the user. The purpose of the model is to automate the calculation of sales growth.

RELATED TERMS
  1. Robust

    A characteristic describing a model's, test's or system's ability ...
  2. Business Model

    The plan implemented by a company to generate revenue and make ...
  3. Protected Cell Company (PCC)

    A corporate structure in which a single legal entity is comprised ...
  4. Relative Valuation Model

    A business valuation method that compares a firm's value to that ...
  5. Hull–White Model

    A single-factor interest model used to price derivatives. The ...
  6. Default Model

    A type of model used by financial institutions to determine the ...
Related Articles
  1. Investing

    Understanding Financial Models

    A financial model is a representation of some aspects of a firm or given security. It uses historical numbers to create calculations that inform financial recommendations or predict future financial ...
  2. Investing

    What is a Business Model?

    Business model is the term for a company’s plan as to how it will earn revenue.
  3. Investing

    DCF Vs. Comparables: Which One To Use

    DCF and Comparables models are widely used in equity valuation. We explain the pros and cons of each method.
  4. Investing

    The Basics Of Business Forecasting

    Discover the methods behind financial forecasts and the risks inherent when we seek to predict the future.
  5. Managing Wealth

    The Best Financial Modeling Courses for Investment Bankers

    Obtain information, both general and comparative, about the best available financial modeling courses for individuals pursuing a career in investment banking.
  6. Markets

    Simulating Stock Prices Using Excel

    We will use the average of the change in log prices, the volatility, the normal distribution and Excel to formulate the future prices of an asset.
  7. Markets

    How Do Professionals Forecast Crude Oil Prices?

    Discover how the future price of oil is predicted with a weighted combination of mathematical tools. Economists largely use five main models as their base.
  8. Trading

    Understanding the Black-Scholes Model

    The Black-Scholes model is a mathematical model of a financial market. From it, the Black-Scholes formula was derived. The introduction of the formula in 1973 by three economists led to rapid ...
  9. Investing

    Digging Into The Dividend Discount Model

    The DDM is one of the most foundational of financial theories, but it's only as good as its assumptions.
  10. Investing

    How To Choose The Best Stock Valuation Method

    There is no single valuation tactic that works in every situation. But a company’s characteristics provide clues to investors about the best method to use.
RELATED FAQS
  1. What is the difference between financial forecasting and financial modelling?

    Understand the difference between financial forecasting and financial modeling, and learn why a company should conduct both ... Read Answer >>
  2. How can I calculate the value of a stock as per the Gordon Grown Model, using Excel?

    Learn about the Gordon growth model, also known as the dividend discount model; see how to use Microsoft Excel and value ... Read Answer >>
  3. How do I calculate how long it takes an investment to double (AKA 'The Rule of 72') ...

    Find out more about the rule of 72, what the rule of 72 measures and how to calculate the rule of 72 for investments using ... Read Answer >>
  4. What is the formula for calculating the capital asset pricing model (CAPM) in Excel?

    Find out more about the capital asset pricing model (CAPM) and the formula for calculating it in Microsoft Excel. Read Answer >>
  5. How do I calculate a price to sales ratio using Excel?

    Learn what the price to sales ratio is, how to calculate the ratio using a formula, and how to calculate the price to sales ... Read Answer >>
  6. What are some examples of different types of business models in major industries?

    Learn what types of business models are currently being used in the marketplace as well as examples of models that work for ... Read Answer >>
Hot Definitions
  1. Brazil, Russia, India And China - BRIC

    An acronym for the economies of Brazil, Russia, India and China combined. It has been speculated that by 2050 these four ...
  2. Brexit

    The Brexit, an abbreviation of "British exit" that mirrors the term Grexit, refers to the possibility of Britain's withdrawal ...
  3. Underweight

    1. A situation where a portfolio does not hold a sufficient amount of a particular security when compared to the security's ...
  4. Russell 3000 Index

    A market capitalization weighted equity index maintained by the Russell Investment Group that seeks to be a benchmark of ...
  5. Enterprise Value (EV)

    A measure of a company's value, often used as an alternative to straightforward market capitalization. Enterprise value is ...
  6. Security

    A financial instrument that represents an ownership position in a publicly-traded corporation (stock), a creditor relationship ...
Trading Center