Financial modeling is the use of accounting, finance, and business measurements to create abstract representations of an organization’s financial situation. However, that simple definition doesn’t really explain what financial modeling is or why it’s such a critical tool for business decision-makers. The best way to illustrate financial modeling is by citing examples of how the models drive nearly all aspects of day-to-day business operations.
- A company uses a linear regression model to determine whether an increase in its advertising budget led to an increase in revenue.
- A financial analyst uses a discounted cash flow (DCF) model to find the current value of an asset as well as its potential value in the future.
- An investment banker uses an initial public offering (IPO) pricing model to set the price of a company’s IPO based on analyses of comparable companies.
Financial analysts rely on financial models to forecast future events and the impact of those events on businesses and financial systems. The power of financial models to predict the future increases as the models become more sophisticated and the data that the models use becomes more timely and relevant. This guide describes several popular financial models, explains the corporate roles that rely on the use of financial models, and examines how to build and use financial models for a range of business applications.
How Financial Models Are Used in Business
Financial models provide business decision-makers with data-driven, quantitative assessments of where their company stands today and what its market and financial position will be in the future. Businesses and financial services use financial models to manage nearly every aspect of their operations: choosing investments; pricing securities; and planning acquisitions, mergers, and divestments.
The following are among the ways business decision-makers use financial models:
Estimating Financial Performance
Financial models use a company’s financial statements to predict its performance by building a predictive model to support business decisions. For example, as a firm’s sales increase, the costs required to generate the increase go up as well. The predictive models calculate the revenue-generating return on the increased investment in the company’s sales operation.
Determining the Value of a Company or an Asset
Various financial models are used to find an asset’s value today and in the future:
- DCF analysis
- Option pricing models
The models use objective and subjective measures to set the value of fixed assets, such as equipment, property, and other capital assets, as well as intangible assets, such as brands, intellectual property, and goodwill.
Analyzing Equity Investments
Equity valuation calculates the value of a company or its stock, typically using one of three different financial models.
- DCF model
- Cost model, or how much it would cost to build a replacement
- Comparables (comps) whether through common market multiples or similar market transactions
While comparable can highlight firms that are either undervalued or overvalued, it can be difficult to find companies that are similar enough to the asset being valued to provide a valid comparison. Also important is using trailing or forward multiples to calculate the impact of the firm’s recent performance and outlook for the future.
Price modeling entails knowing the psychology of the market and the value that your customers and potential customers place on products and services. While a price strategy is internal and based on the cost to provide the product, profit margin, and markup, a price model is external and based on how the product will be offered to consumers.
Financial models for setting prices factor in the customer’s perception of the price (luxury or inexpensive), the vendor’s costs and expected profit, and the price that other vendors set for similar products. The models must also consider the product’s change in value over time, seasonality, and other changes in market conditions.
Conducting Sensitivity Analyses
Sensitivity analysis is used in financial models to determine how changing values in a set of independent variables will affect a dependent variable, such as a company’s share price or the effect of an increase on interest rates. The technique is also referred to as what-if analysis and is used to estimate the impact of uncertainty in the model.
This approach is used in a range of modeling situations, including to identify break-even points, test specific scenarios, assess risk, and understand the relationship between specific input variables and output variables. In addition to finance, sensitivity analysis is an important tool for science and engineering disciplines.
Raising Capital via Debt Equity
The two primary ways a business raises capital are debt financing and equity financing:
- Debt financing relies on funds received from a bank or other lender, allowing the borrower to retain day-to-day control over the business. The interest paid on the loan is tax deductible as a business expense.
- Equity financing is received from investors in exchange for a share of the business’s profits. While the equity investment doesn’t have to be paid back, the investors may need to be consulted before business decisions are made.
Financial models for raising capital via debt or equity consider how accessible each type of funding is, the company’s current and future cash flow, and how important it is to the company that it retains control over decisions relating to the business. The debt-to-equity ratio lets a company know how well it can cover all outstanding debts using shareholder equity alone in the event of an economic downturn.
Acquiring or Divesting Businesses or Assets
When considering whether to acquire or divest an asset or business, firms look to several key financial measurements:
- Return on investment (ROI): The ratio of net profit over a period to the cost of the investment
- Profitability and cost: A product’s cost broken down by each area of the company and to industry averages
- Capacity planning: How change in a product’s demand will affect operations and finances
- Financial forecasting: Making assumptions about the future to find financial outcomes based on various scenarios
- Budgeting and cash flow analysis: Revenue and costs estimated over time, and how much cash will be on hand at any given time
Distributing Financial Resources
Much of a company’s success depends on how efficiently it allocates capital to meet its short- and long-term goals. Among the options for distributing a company’s financial resources are to return cash to shareholders in the form of dividends, to repurchase shares of stock, or to increase research and marketing operations.
Return on invested capital (ROIC) measures how well a firm converts capital into profit. The ROIC calculates the ratio of earnings before taxes or interest expense on debt to its total debt financing and equity financing, the sum of which is called its capital structure.
All investment decisions entail an element of risk, so managing that risk becomes part of the financial models on which those decisions are made. Risk management applies models to quantify the potential for loss related to specific investments by identifying, analyzing, accepting, or mitigating the uncertainty surrounding business decisions.
One of the most popular methods used in risk management is standard deviation, which indicates how far apart the values in a data set are from the average of the sample: the higher the deviation, the more volatile the investment will be. Some investments will have a higher tolerance for volatility than others based on their potential for high returns.
Who Uses Financial Models?
Executives in all parts of an organization rely on financial models in their day-to-day work.
- Financial analysts typically rely on complex spreadsheets designed to serve a specific purpose, such as sales forecasts, budget allocations, and asset appraisals.
- Financial planners address the long-term financial concerns of families and individuals by applying models for retirement income estimation, cash flow projections, net worth calculations, and legacy goals.
- Chief financial officers are responsible for updating the organization’s business model to ensure it will have the resources it requires to achieve its objectives. They use financial models to identify impediments to growth, emerging risks, and new opportunities.
- Business managers use financial models to prepare budgets and make strategic plans. By modifying variables in the models, managers can forecast the business’s performance under many different scenarios.
- Project managers apply financial models while planning and implementing projects to ensure sufficient cash flow, manage project resources and schedules, and simulate various project scenarios. Many project managers use the modeling features built into the Program Evaluation and Review Technique (PERT).
- Investment bankers and portfolio managers depend on financial models to determine the fair or intrinsic value of a company’s stock, to make investment decisions based on those assessments, and to identify merger and acquisition candidates.
- Risk managers have expanded their use of financial models to include risks associated with the networks that partners and other third parties in the global supply chain use. Financial models allow firms to measure risk trends and respond faster to threats and to promote accountability for risk mitigation.
- Accountants can leverage their use of financial models to broaden their role in organizations beyond bookkeeping to include data analysis and financial decision support.
Types of Financial Models
The use of financial models has grown in recent years as more relevant and timely data becomes available and as modeling tools arrive that are easy to learn and use. In addition to helping companies estimate costs for new projects and continuing operations, the models are applied to forecast the effects of market swings and other economic changes.
Financial modeling tools are effective in tracking a firm’s key performance indicators (KPIs), including gross and net margins. Their projections are used on company balance sheets and cash flow statements, and they support the scheduling of projects and employees. These are among the most commonly used types of financial models.
Three-Statement Financial Model
The three-statement financial model is widely used in business and finance because it serves as the foundation of most other forecasts and predictive formulas. The three statements that make up the model are the company’s balance sheet, cash flow statement, and income statement:
- The balance sheet provides a snapshot of the business’s finances, including assets, liabilities, and shareholders’ equity balances.
- The cash flow statement shows the inflows and outflows of cash over a specific period in categories that include operations, investments, and financing activities.
- The income statement summarizes the business’s revenue and expenses in a specific period.
The model typically begins with the income statement, followed by the cash flow statement and the balance sheet, with the results of each analysis funneling into the other. Knowing how to apply the three-statement model is a prerequisite for many financial and management positions.
Discounted Cash Flow Model
The DCF model assesses a company’s current value based on the net present value (NPV) of its future cash flow. Under this model, the business’s value is the total of all future free cash flows (cash generated minus cash outflows for operational expenses). Investors and acquiring companies use this model to set the value of potential acquisitions, and managers use it to prepare their capital budgets and operating expenditures.
Forecasting models attempt to answer the “why” that the results of other financial models pose. The two general categories of forecasting models are quantitative (straight line, moving average, linear regression, and time series, for example) and qualitative (market research and the Delphi method that relies on the opinions of experts). Since no forecasting model can be fully accurate, the goal of the models is to be generally reliable and helpful in framing business decisions.
Comparable Company Analysis Model
The comparable company analysis method attempts to establish the value of a company based on the performance of other companies of similar size in the same or related industries. After determining the peer group to represent the company’s value, an enterprise value (EV) is found based on financial figures from its competitors. Evaluation measures include enterprise value to sales (EV/S), price to earnings (P/E) ratio, price to book (P/B) ratio, and price to sales (P/S) ratio. If the company’s valuation ratio is higher than that of its peers, it’s overvalued, and if the valuation ratio is less than its peers, it’s undervalued.
The sum-of-the-parts model sets the value of a company based on what each of its divisions or constituent parts would be worth if they were sold separately. The model adjusts the total to account for the company’s net debt and other nonoperating assets and expenses. The value of each separate unit is calculated using the DCF method or other valuation approach. Usually the firm’s business is spread across several industries, and it may be considering a restructuring to become more efficient. The model also serves as a possible defense against a hostile takeover attempt.
Asset and Liability Management Model
The goal of the asset and liability management (ALM) model is to mitigate the risks involved in the firm’s use of assets and cash flows, such as ensuring bills are paid on time to avoid penalties. This technique is frequently applied when managing bank loan portfolios and pension plans. Firms may find that their assets and liabilities are out of proportion due to rising or falling interest rates or swings in the interest a bank pays on deposits versus interest earned from loans. The ALM model is particularly useful for long-range financial planning.
Capital Budgeting Model
The capital budgeting model helps companies determine whether any expenditure on a fixed or intangible asset will result in a profit. The model calculates the payback period (PB), internal rate of return (IRR), and NPV. If all three of these metrics indicate that the purchase will be profitable, the buying decision becomes simpler. When the models disagree, however, managers can place a greater or lesser emphasis on the areas to gain greater insight into the purchase’s potential outcome.
Leveraged Buyout Model
A leveraged buyout (LBO) is the acquisition of a company or part of a company that’s funded primarily with debt. The LBO model determines a “floor” valuation for the asset that balances the amount of debt the purchasing firm can afford to take on with the prospects of receiving an adequate ROI. The method is used to find the maximum purchase price for the target business based on debt (leverage) and equity (return).
Merger and Acquisition Model
The merger and acquisition model is intended to find the value of a potential merger or acquisition to each company. After establishing a forecast for both firms, the model determines a range for potential purchase prices. The model indicates the value of each entity if the deal didn’t happen and the value once the proposed acquisition or merger was completed. The result is deemed to be either accretive or dilutive to the combined company’s value.
Industry-Specific Financial Models
Financial model design for specific industry tend to be more detailed and complex than models intended to be used across industry and business segments. Among the industries that benefit from custom financial models are fossil fuels, real estate, and mineral extraction. Using these models generally requires in-depth knowledge of the target industry, so the models benefit from accurate and relevant assumptions.
Option Pricing Model
Option pricing model are use to set the price for stock options based on their value over time and various risk factors. The most popular option pricing model is the Black-Schole model, which is relate to the Black-Schole-Merton (BSM) model and was originally develope in 1973. The model is based on five input variables:
- Option’s strike price (the price at which a put or call option — the right to sell or buy stock — can be exercise)
- Current stock price
- Time to expiration
- Risk-free rate
- Option’s volatility
The standard BSM model is use to price European options only because it doesn’t consider that U.S. option can be exercise before their expiration date.
Resources on Types of Financial Models
- Indeed, 6 Types of Financial Forecasting Models (Plus Its Importance) — Financial models described include bottom-up and top-down financial forecasting, correlation forecasting, statistical forecasting, Delphi forecasting, and ALM forecasting.
- 4-D Resources Advisory, “Natural Resources Financial Modeling and How to Make It Better” — A dynamic financial model is presented for use in the natural resources industry to enhance the accuracy of financial decisions related to natural resource management.