Loading the player...

What is 'Financial Modeling'

Financial modeling 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. Model Risk

    Model risk occurs when a financial model used to measure a firm's ...
  2. Predictive Modeling

    Predictive modeling is the process of using known results to ...
  3. What-If Calculation

    A what-if calculation is an output from a financial model using ...
  4. Sensitivity Analysis

    Sensitivity analysis is a technique used to determine how different ...
  5. Black's Model

    Black's Model is a variation of the popular Black-Scholes options ...
  6. Valuation Analysis

    A valuation analysis is a process to estimate the approximate ...
Related Articles
  1. Investing

    Style Matters In Financial Modeling

    If you're looking to get a job as an analyst, you'll need to know how to work it.
  2. Small Business

    Calculating (Small) Company Credit Risk

    Determining creditworthiness of smaller and medium-sized corporations isn't as easy as for larger companies, but these tips can help.
  3. Investing

    Business forecasting: Understanding the basics

    Discover the methods behind financial forecasts and the risks inherent when we seek to predict the future.
  4. Trading

    Improve your investing with Excel

    Find out how to use Excel, a useful tool for assisting with investment organizations and evaluations.
  5. Personal Finance

    Discounted cash flows or comparables: Which to use

    DCF and comparables models are widely used in equity valuation, and here we'll explain the pros and cons of each method.
  6. Insights

    Cell Phone Evolution

    Follow the evolution of cell phones from 20 pound bricks to the sleek smart phones of today.
  7. Insights

    The Fed Model And Stock Valuation: What It Does And Does Not Tell Us

    Learn about this popular stock market valuation model and how accurate it has been over the years.
  8. Investing

    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. Personal Finance

    How to Stress Test Your Financial Plan

    A look at four key variables and their impact on a financial plan.
  10. Trading

    How to Build A Forex Trading Model

    Forex trading markets work 24/7, providing ample opportunities to make profitable trades. How can you build a profitable forex trading model for yourself?
RELATED FAQS
  1. What is the difference between financial forecasting and financial modeling?

    Understand the difference between financial forecasting and financial modeling, and learn why a company should conduct both ... Read Answer >>
  2. What is the formula for calculating return on equity (ROE) in Excel?

    Find out more about return on equity, the formula to calculate it and how to calculate return on equity in Microsoft Excel. Read Answer >>
  3. What is the formula for calculating the price-to-earnings (P/E) ratio in Excel?

    Find out more about the price-to-earnings, or P/E, ratio, the P/E ratio formula and how to calculate the P/E ratio in Microsoft ... Read Answer >>
  4. How is the ability to perform Activities of Daily Living (ADL) measured?

    Find out how to apply sensitivity analysis to your investment decisions, why sensitivity analysis might be useful and what ... Read Answer >>
  5. How do you calculate present value in Excel?

    Learn what present value and future value are and how to use Microsoft Excel to calculate present value, given the future ... Read Answer >>
  6. How do I calculate the expected return of my portfolio in Excel?

    Find out how to calculate the total expected annual return of your portfolio in Microsoft Excel using the value and return ... Read Answer >>
Hot Definitions
  1. Current Assets

    Current assets is a balance sheet account that represents the value of all assets that can reasonably expected to be converted ...
  2. Volatility

    Volatility measures how much the price of a security, derivative, or index fluctuates.
  3. Money Market

    The money market is a segment of the financial market in which financial instruments with high liquidity and very short maturities ...
  4. Cost of Debt

    Cost of debt is the effective rate that a company pays on its current debt as part of its capital structure.
  5. Depreciation

    Depreciation is an accounting method of allocating the cost of a tangible asset over its useful life and is used to account ...
  6. Ratio Analysis

    A ratio analysis is a quantitative analysis of information contained in a company’s financial statements.
Trading Center