Financial modeling

Last updated

Financial modeling is the task of building an abstract representation (a model) of a real world financial situation. [1] This is a mathematical model designed to represent (a simplified version of) the performance of a financial asset or portfolio of a business, project, or any other investment.

Contents

Typically, then, financial modeling is understood to mean an exercise in either asset pricing or corporate finance, of a quantitative nature. It is about translating a set of hypotheses about the behavior of markets or agents into numerical predictions. [2] At the same time, "financial modeling" is a general term that means different things to different users; the reference usually relates either to accounting and corporate finance applications or to quantitative finance applications.

Accounting

Spreadsheet-based Cash Flow Projection (click to view at full size) Cash Flow Projection.png
Spreadsheet-based Cash Flow Projection (click to view at full size)

In corporate finance and the accounting profession, financial modeling typically entails financial statement forecasting; usually the preparation of detailed company-specific models used for decision making purposes [1] and financial analysis.

Applications include:

To generalize [ citation needed ] as to the nature of these models: firstly, as they are built around financial statements, calculations and outputs are monthly, quarterly or annual; secondly, the inputs take the form of "assumptions", where the analyst specifies the values that will apply in each period for external / global variables (exchange rates, tax percentage, etc....; may be thought of as the model parameters ), and for internal / company specific variables (wages, unit costs, etc....). Correspondingly, both characteristics are reflected (at least implicitly) in the mathematical form of these models: firstly, the models are in discrete time; secondly, they are deterministic. For discussion of the issues that may arise, see below; for discussion as to more sophisticated approaches sometimes employed, see Corporate finance § Quantifying uncertainty and Financial economics § Corporate finance theory.

Modelers are often designated "financial analyst" (and are sometimes referred to, tongue in cheek, as "number crunchers"). Typically, [6] the modeler will have completed an MBA or MSF with (optional) coursework in "financial modeling". [7] Accounting qualifications and finance certifications such as the CIIA and CFA generally do not provide direct or explicit training in modeling. [8] At the same time, numerous commercial training courses are offered, both through universities and privately. For the components and steps of business modeling here, see Outline of finance § Financial modeling; see also Valuation using discounted cash flows § Determine cash flow for each forecast period for further discussion and considerations.

Although purpose-built business software does exist, the vast proportion of the market is spreadsheet-based; this is largely since the models are almost always company-specific. Also, analysts will each have their own criteria and methods for financial modeling. [9] Microsoft Excel now has by far the dominant position, having overtaken Lotus 1-2-3 in the 1990s. Spreadsheet-based modelling can have its own problems, [10] and several standardizations and "best practices" have been proposed. [11] "Spreadsheet risk" is increasingly studied and managed; [11] see model audit.

One critique here, is that model outputs, i.e. line items, often inhere "unrealistic implicit assumptions" and "internal inconsistencies". [12] (For example, a forecast for growth in revenue but without corresponding increases in working capital, fixed assets and the associated financing, may imbed unrealistic assumptions about asset turnover, debt level and/or equity financing. See Sustainable growth rate § From a financial perspective.) What is required, but often lacking, is that all key elements are explicitly and consistently forecasted. Related to this, is that modellers often additionally "fail to identify crucial assumptions" relating to inputs, "and to explore what can go wrong". [13] Here, in general, modellers "use point values and simple arithmetic instead of probability distributions and statistical measures" [14] — i.e., as mentioned, the problems are treated as deterministic in nature — and thus calculate a single value for the asset or project, but without providing information on the range, variance and sensitivity of outcomes; [15] see Valuation using discounted cash flows § Determine equity value. A further, more general critique relates to the lack of basic computer programming concepts amongst modelers, [16] with the result that their models are often poorly structured, and difficult to maintain. Serious criticism is also directed at the nature of budgeting, and its impact on the organization. [17] [18]

Quantitative finance

Visualization of an interest rate "tree" - usually returned by commercial derivatives software OAS valuation tree (es).png
Visualization of an interest rate "tree" - usually returned by commercial derivatives software

In quantitative finance, financial modeling entails the development of a sophisticated mathematical model. [19] Models here deal with asset prices, market movements, portfolio returns and the like. A general distinction [ citation needed ] is between: (i) "quantitative asset pricing", models of the returns of different stocks; (ii) "financial engineering", models of the price or returns of derivative securities; (iii) "quantitative portfolio management", models underpinning automated trading, high-frequency trading, algorithmic trading, and program trading.

Relatedly, applications include:

These problems are generally stochastic and continuous in nature, and models here thus require complex algorithms, entailing computer simulation, advanced numerical methods (such as numerical differential equations, numerical linear algebra, dynamic programming) and/or the development of optimization models. The general nature of these problems is discussed under Mathematical finance § History: Q versus P, while specific techniques are listed under Outline of finance § Mathematical tools. For further discussion here see also: Brownian model of financial markets; Martingale pricing; Financial models with long-tailed distributions and volatility clustering; Extreme value theory; Historical simulation (finance).

Modellers are generally referred to as "quants", i.e. quantitative analysts, and typically have advanced (Ph.D. level) backgrounds in quantitative disciplines such as statistics, physics, engineering, computer science, mathematics or operations research. Alternatively, or in addition to their quantitative background, they complete a finance masters with a quantitative orientation, [23] such as the Master of Quantitative Finance, or the more specialized Master of Computational Finance or Master of Financial Engineering; the CQF certificate is increasingly common.

Although spreadsheets are widely used here also (almost always requiring extensive VBA); custom C++, Fortran or Python, or numerical-analysis software such as MATLAB, are often preferred, [23] particularly where stability or speed is a concern. MATLAB is often used at the research or prototyping stage [ citation needed ] because of its intuitive programming, graphical and debugging tools, but C++/Fortran are preferred for conceptually simple but high computational-cost applications where MATLAB is too slow; Python is increasingly used due to its simplicity, and large standard library / available applications, including QuantLib. Additionally, for many (of the standard) derivative and portfolio applications, commercial software is available, and the choice as to whether the model is to be developed in-house, or whether existing products are to be deployed, will depend on the problem in question. [23] See Quantitative analysis (finance) § Library quantitative analysis.

The complexity of these models may result in incorrect pricing or hedging or both. This Model risk is the subject of ongoing research by finance academics, and is a topic of great, and growing, interest in the risk management arena. [24]

Criticism of the discipline (often preceding the financial crisis of 2007–08 by several years) emphasizes the differences between the mathematical and physical sciences, and finance, and the resultant caution to be applied by modelers, and by traders and risk managers using their models. Notable here are Emanuel Derman and Paul Wilmott, authors of the Financial Modelers' Manifesto . Some go further and question whether the mathematical- and statistical modeling techniques usually applied to finance are at all appropriate (see the assumptions made for options and for portfolios). In fact, these may go so far as to question the "empirical and scientific validity... of modern financial theory". [25] Notable here are Nassim Taleb and Benoit Mandelbrot. [26] See also Mathematical finance § Criticism, Financial economics § Challenges and criticism and Financial engineering § Criticisms.

Competitive modeling

Several financial modeling competitions exist, emphasizing speed and accuracy in modeling. The Microsoft-sponsored ModelOff Financial Modeling World Championships were held annually from 2012 to 2019, with competitions throughout the year and a finals championship in New York or London. After its end in 2020, several other modeling championships have been started, including the Financial Modeling World Cup and Microsoft Excel Collegiate Challenge, also sponsored by Microsoft. [6]

Philosophy of financial modeling

Philosophy of financial modeling is a branch of philosophy concerned with the foundations, methods, and implications of modeling science.

In the philosophy of financial modeling, scholars have more recently begun to question the generally-held assumption that financial modelers seek to represent any "real-world" or actually ongoing investment situation. Instead, it has been suggested that the task of the financial modeler resides in demonstrating the possibility of a transaction in a prospective investment scenario, from a limited base of possibility conditions initially assumed in the model. [27]

See also

Related Research Articles

The discounted cash flow (DCF) analysis, in financial analysis, is a method used to value a security, project, company, or asset, that incorporates the time value of money. Discounted cash flow analysis is widely used in investment finance, real estate development, corporate financial management, and patent valuation. Used in industry as early as the 1700s or 1800s, it was widely discussed in financial economics in the 1960s, and U.S. courts began employing the concept in the 1980s and 1990s.

Finance refers to monetary resources and to the study and discipline of money, currency, assets and liabilities. As a subject of study, it is related to but distinct from economics, which is the study of the production, distribution, and consumption of goods and services. Based on the scope of financial activities in financial systems, the discipline can be divided into personal, corporate, and public finance.

Financial economics is the branch of economics characterized by a "concentration on monetary activities", in which "money of one type or another is likely to appear on both sides of a trade". Its concern is thus the interrelation of financial variables, such as share prices, interest rates and exchange rates, as opposed to those concerning the real economy. It has two main areas of focus: asset pricing and corporate finance; the first being the perspective of providers of capital, i.e. investors, and the second of users of capital. It thus provides the theoretical underpinning for much of finance.

Financial engineering is a multidisciplinary field involving financial theory, methods of engineering, tools of mathematics and the practice of programming. It has also been defined as the application of technical methods, especially from mathematical finance and computational finance, in the practice of finance.

A financial analyst is a professional undertaking financial analysis for external or internal clients as a core feature of the job. The role may specifically be titled securities analyst, research analyst, equity analyst, investment analyst, or ratings analyst. The job title is a broad one: In banking, and industry more generally, various other analyst-roles cover financial management and (credit) risk management, as opposed to focusing on investments and valuation; these are also discussed in this article.

Monte Carlo methods are used in corporate finance and mathematical finance to value and analyze (complex) instruments, portfolios and investments by simulating the various sources of uncertainty affecting their value, and then determining the distribution of their value over the range of resultant outcomes. This is usually done by help of stochastic asset models. The advantage of Monte Carlo methods over other techniques increases as the dimensions of the problem increase.

Financial risk management is the practice of protecting economic value in a firm by managing exposure to financial risk - principally operational risk, credit risk and market risk, with more specific variants as listed aside. As for risk management more generally, financial risk management requires identifying the sources of risk, measuring these, and crafting plans to mitigate them. See Finance § Risk management for an overview.

In financial economics, asset pricing refers to a formal treatment and development of two interrelated pricing principles, outlined below, together with the resultant models. There have been many models developed for different situations, but correspondingly, these stem from either general equilibrium asset pricing or rational asset pricing, the latter corresponding to risk neutral pricing.

<span class="mw-page-title-main">Lattice model (finance)</span> Method for evaluating stock options that divides time into discrete intervals

In finance, a lattice model is a technique applied to the valuation of derivatives, where a discrete time model is required. For equity options, a typical example would be pricing an American option, where a decision as to option exercise is required at "all" times before and including maturity. A continuous model, on the other hand, such as Black–Scholes, would only allow for the valuation of European options, where exercise is on the option's maturity date. For interest rate derivatives lattices are additionally useful in that they address many of the issues encountered with continuous models, such as pull to par. The method is also used for valuing certain exotic options, where because of path dependence in the payoff, Monte Carlo methods for option pricing fail to account for optimal decisions to terminate the derivative by early exercise, though methods now exist for solving this problem.

Valuation using discounted cash flows is a method of estimating the current value of a company based on projected future cash flows adjusted for the time value of money. The cash flows are made up of those within the “explicit” forecast period, together with a continuing or terminal value that represents the cash flow stream after the forecast period. In several contexts, DCF valuation is referred to as the "income approach".

The following outline is provided as an overview of and topical guide to finance:

A master's degree in quantitative finance is a postgraduate degree focused on the application of mathematical methods to the solution of problems in financial economics. There are several like-titled degrees which may further focus on financial engineering, computational finance, mathematical finance, and/or financial risk management.

In finance, model risk is the risk of loss resulting from using insufficiently accurate models to make decisions, originally and frequently in the context of valuing financial securities.

A Master of Financial Economics is a master's degree focusing on financial economics. The degree provides a rigorous understanding of theoretical finance and the economic framework upon which that theory is based. The degree is postgraduate, and usually incorporates a thesis or research component. Programs may be offered jointly by the business school and the economics department. Closely related degrees include the Master of Finance and Economics and the Master of Economics with a specialization in Finance. Since 2014 undergraduate degrees in the discipline have also been offered.

A Credit valuation adjustment (CVA), in financial mathematics, is an "adjustment" to a derivative's price, as charged by a bank to a counterparty to compensate it for taking on the credit risk of that counterparty during the life of the transaction. CVA is one of a family of related valuation adjustments, collectively xVA; for further context here see Financial economics § Derivative pricing. "CVA" can refer more generally to several related concepts, as delineated aside. The most common transactions attracting CVA involve interest rate derivatives, foreign exchange derivatives, and combinations thereof. CVA has a specific capital charge under Basel III, and may also result in earnings volatility under IFRS 13, and is therefore managed by a specialized desk.

Quantitative analysis is the use of mathematical and statistical methods in finance and investment management. Those working in the field are quantitative analysts (quants). Quants tend to specialize in specific areas which may include derivative structuring or pricing, risk management, investment management and other related finance occupations. The occupation is similar to those in industrial mathematics in other industries. The process usually consists of searching vast databases for patterns, such as correlations among liquid assets or price-movement patterns.

Mathematical finance, also known as quantitative finance and financial mathematics, is a field of applied mathematics, concerned with mathematical modeling in the financial field.

In finance, a contingent claim is a derivative whose future payoff depends on the value of another “underlying” asset, or more generally, that is dependent on the realization of some uncertain future event. These are so named, since there is only a payoff under certain contingencies. Any derivative instrument that is not a contingent claim is called a forward commitment.

<span class="mw-page-title-main">Corporate finance</span> Framework for corporate funding, capital structure, and investments

Corporate finance is the area of finance that deals with the sources of funding, and the capital structure of businesses, the actions that managers take to increase the value of the firm to the shareholders, and the tools and analysis used to allocate financial resources. The primary goal of corporate finance is to maximize or increase shareholder value.

An X-Value Adjustment is an umbrella term referring to a number of different “valuation adjustments” that banks must make when assessing the value of derivative contracts that they have entered into. The purpose of these is twofold: primarily to hedge for possible losses due to other parties' failures to pay amounts due on the derivative contracts; but also to determine the amount of capital required under the bank capital adequacy rules. XVA has led to the creation of specialized desks in many banking institutions to manage XVA exposures.

References

  1. 1 2 Investopedia Staff (2020). "Financial Modeling".
  2. Low, R.K.Y.; Tan, E. (2016). "The Role of Analysts' Forecasts in the Momentum Effect" (PDF). International Review of Financial Analysis. 48: 67–84. doi:10.1016/j.irfa.2016.09.007.
  3. Joel G. Siegel; Jae K. Shim; Stephen Hartman (1 November 1997). Schaum's quick guide to business formulas: 201 decision-making tools for business, finance, and accounting students. McGraw-Hill Professional. ISBN   978-0-07-058031-2 . Retrieved 12 November 2011. §39 "Corporate Planning Models". See also, §294 "Simulation Model".
  4. See for example: "Renewable Energy Financial Model". Renewables Valuation Institute. Retrieved 2023-03-19.
  5. Confidential disclosure of a financial model is often requested by purchasing organizations undertaking public sector procurement in order that the government department can understand and if necessary challenge the pricing principles which underlie a bidder's costs. E.g. First-tier Tribunal, Department for Works and Pensions v. Information Commissioner, UKFTT EA_2010_0073, paragraph 58, decided 20 September 2010, accessed 11 January 2024
  6. 1 2 Fairhurst, Danielle Stein (2022). Financial Modeling in Excel for Dummies. John Wiley & Sons. ISBN   978-1-119-84451-8. OCLC   1264716849.
  7. Example course: Financial Modelling, University of South Australia
  8. The MiF can offer an edge over the CFA Financial Times, June 21, 2015.
  9. See for example, Valuing Companies by Cash Flow Discounting: Ten Methods and Nine Theories, Pablo Fernandez: University of Navarra - IESE Business School
  10. Danielle Stein Fairhurst (2009). Six reasons your spreadsheet is NOT a financial model Archived 2010-04-07 at the Wayback Machine , fimodo.com
  11. 1 2 Best Practice Archived 2018-03-29 at the Wayback Machine , European Spreadsheet Risks Interest Group
  12. Krishna G. Palepu; Paul M. Healy; Erik Peek; Victor Lewis Bernard (2007). Business analysis and valuation: text and cases. Cengage Learning EMEA. pp. 261–. ISBN   978-1-84480-492-4 . Retrieved 12 November 2011.
  13. Richard A. Brealey; Stewart C. Myers; Brattle Group (2003). Capital investment and valuation. McGraw-Hill Professional. pp. 223–. ISBN   978-0-07-138377-6 . Retrieved 12 November 2011.
  14. Peter Coffee (2004). Spreadsheets: 25 Years in a Cell, eWeek.
  15. Prof. Aswath Damodaran. Probabilistic Approaches: Scenario Analysis, Decision Trees and Simulations, NYU Stern Working Paper
  16. Blayney, P. (2009). Knowledge Gap? Accounting Practitioners Lacking Computer Programming Concepts as Essential Knowledge. In G. Siemens & C. Fulford (Eds.), Proceedings of World Conference on Educational Multimedia, Hypermedia and Telecommunications 2009 (pp. 151-159). Chesapeake, VA: AACE.
  17. Loren Gary (2003). Why Budgeting Kills Your Company, Harvard Management Update, May 2003.
  18. Michael Jensen (2001). Corporate Budgeting Is Broken, Let's Fix It, Harvard Business Review, pp. 94-101, November 2001.
  19. See discussion here: "Careers in Applied Mathematics" (PDF). Society for Industrial and Applied Mathematics. Archived (PDF) from the original on 2019-03-05.
  20. See for example: Low, R.K.Y.; Faff, R.; Aas, K. (2016). "Enhancing mean–variance portfolio selection by modeling distributional asymmetries" (PDF). Journal of Economics and Business. 85: 49–72. doi:10.1016/j.jeconbus.2016.01.003.; Low, R.K.Y.; Alcock, J.; Faff, R.; Brailsford, T. (2013). "Canonical vine copulas in the context of modern portfolio management: Are they worth it?" (PDF). Journal of Banking & Finance. 37 (8): 3085–3099. doi:10.1016/j.jbankfin.2013.02.036. S2CID   154138333.
  21. See David Shimko (2009). Quantifying Corporate Financial Risk. archived 2010-07-17.
  22. See for example this problem (from John Hull's Options, Futures, and Other Derivatives), discussing cash position modeled stochastically.
  23. 1 2 3 Mark S. Joshi, On Becoming a Quant Archived 2012-01-14 at the Wayback Machine .
  24. Riccardo Rebonato (N.D.). Theory and Practice of Model Risk Management.
  25. Nassim Taleb (2009)."History Written By The Losers", Foreword to Pablo Triana's Lecturing Birds How to Fly ISBN   978-0470406755
  26. Nassim Taleb and Benoit Mandelbrot. "How the Finance Gurus Get Risk All Wrong" (PDF). Archived from the original (PDF) on 2010-12-07. Retrieved 2010-06-15.
  27. Mebius, A. (2023). "On the epistemic contribution of financial models". Journal of Economic Methodology. 30 (1): 49–62. doi: 10.1080/1350178X.2023.2172447 . S2CID   256438018.

Bibliography

General

Corporate finance

Quantitative finance