## 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.

Next Up

## 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

A business model is a company's plan for generating revenues ...
2. ### Robust

A characteristic describing a model's, test's or system's ability ...
3. ### Fed Model

The Fed model is a tool used to determine whether the U.S. stock ...
4. ### Multistage Dividend Discount Model

The multistage dividend discount model is an equity valuation ...
5. ### Valuation Analysis

A valuation analysis is a process to estimate the approximate ...
6. ### Option Pricing Theory

An option pricing theory is any model or theory-based approach ...
Related Articles
1. Investing

### Financial Models You Can Create With Excel

The relatively modest amount of time it takes to build these models can pay for itself by leading you to better investment decisions.
2. 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.

### 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.
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. 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.

### Stock Analysis Basics: How To Forecast Revenue and Growth

Forecasted revenue and growth projections are important components of security analysis, leading to a stockâ€™s future worth.
8. 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.
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

### More Model 3 Details Emerge on Tesla Earnings Call

Tesla said the Model 3 will have fewer "bells and whistles" but a more automated production process to enable scale.
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. ### How do I calculate stock value using the Gordon Grown Model in Excel?

Learn about the Gordon Growth Model, also known as the dividend discount model. See how to use Microsoft Excel to determine ... Read Answer >>
3. ### What is the formula for calculating free cash flow in Excel?

Find out more about free cash flow, the formula for calculating free cash flow and how to calculate a company's free cash ... Read Answer >>
4. ### How do I use Excel to calculate a weighted average?

Learn about the calculation and interpretation of weighted averages, including how to compute a weighted average using Microsoft ... Read Answer >>
5. ### What is the difference between Macaulay duration and modified duration?

Find out more about the forward price to earnings ratio and how to calculate the forward price to earnings ratios of companies ... Read Answer >>
6. ### What is the formula for calculating working capital in Excel?

Find out more about working capital, what working capital measures and how to calculate a company's working capital using ... Read Answer >>
Hot Definitions
1. ### Capital Asset Pricing Model - CAPM

Capital Asset Pricing Model (CAPM) is a model that describes the relationship between risk and expected return and that is ...
2. ### Return On Equity - ROE

The profitability returned in direct relation to shareholders' investments is called the return on equity.
3. ### Working Capital

Working capital, also known as net working capital is a measure of a company's liquidity and operational efficiency.
4. ### Bond

A bond is a fixed income investment in which an investor loans money to an entity (corporate or governmental) that borrows ...
5. ### Compound Annual Growth Rate - CAGR

The Compound Annual Growth Rate (CAGR) is the mean annual growth rate of an investment over a specified period of time longer ...
6. ### Net Present Value - NPV

Net Present Value (NPV) is the difference between the present value of cash inflows and the present value of cash outflows ...