World Library  
Flag as Inappropriate
Email this Article

Financial modeling

Article Id: WHEBN0002844974
Reproduction Date:

Title: Financial modeling  
Author: World Heritage Encyclopedia
Language: English
Subject: Master of Finance, Corporate finance, Project finance, VP/MS, Management accounting
Collection: Actuarial Science, Corporate Finance, Mathematical Finance, Mathematical Science Occupations
Publisher: World Heritage Encyclopedia

Financial modeling

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. 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. While there has been some debate in the industry as to the nature of financial modeling—whether it is a tradecraft, such as welding, or a science—the task of financial modeling has been gaining acceptance and rigor over the years.[2] Typically, financial modeling is understood to mean an exercise in either asset pricing or corporate finance, of a quantitative nature. In other words, financial modelling is about translating a set of hypotheses about the behavior of markets or agents into numerical predictions; for example, a firm's decisions about investments (the firm will invest 20% of assets), or investment returns (returns on "stock A" will, on average, be 10% higher than the market's returns).


  • Accounting 1
  • Quantitative finance 2
  • See also 3
  • References 4
  • Selected bibliography 5


In corporate finance, investment banking, and the accounting profession financial modeling is largely synonymous with financial statement forecasting. This usually involves the preparation of detailed company specific models used for decision making purposes[1] and financial analysis.

Applications include:

To generalize 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.

Modelers are sometimes referred to (tongue in cheek) as "number crunchers", and are often designated "financial analyst". Typically, the modeler will have completed an MBA or MSF with (optional) coursework in "financial modeling". Accounting qualifications and finance certifications such as the CIIA and CFA generally do not provide direct or explicit training in modeling. At the same time, numerous commercial training courses are offered, both through universities and privately.

Although purpose built 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.[4] 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,[5] and several standardizations and "best practices" have been proposed.[6] "Spreadsheet risk" is increasingly studied and managed.[6]

One critique here, is that model outputs, i.e.


  • Benninga, Simon (1997). Financial Modeling. Cambridge, MA:  
  • Benninga, Simon (2006). Principles of Finance with Excel. New York:  
  • Sengupta, Chandan (2009). Financial Analysis and Modeling Using Excel and VBA, 2nd Edition. Hoboken, NJ: John Wiley & Sons.  
  • Winston, Wayne (2014). Microsoft Excel 2013 Data Analysis and Business Modeling.  

Corporate finance

  • Day, Alastair (2007). Mastering Financial Modelling in Microsoft Excel. London:  
  • Mayes, Timothy R.; Todd M. Shank (2011). Financial Analysis with Microsoft Excel, 6th Edition. Boston:  
  • Ongkrutaraksa, Worapot (2006). Financial Modeling and Analysis: A Spreadsheet Technique for Financial, Investment, and Risk Management, 2nd Edition. Frenchs Forest:  
  • Pignataro, Paul (2003). Financial Modeling and Valuation: A Practical Guide to Investment Banking and Private Equity. Hoboken, NJ: Wiley.  
  • Proctor, Scott (2009). Building Financial Models with Microsoft Excel: A Guide for Business Professionals, 2nd Edition. Hoboken, NJ:  
  • Rees, Michael (2008). Financial Modelling in Practice: A Concise Guide for Intermediate and Advanced Level. Hoboken, NJ:  
  • Soubeiga, Eric (2013). Mastering Financial Modeling: A Professional’s Guide to Building Financial Models in Excel. New York:  
  • Swan, Jonathan (2007). Financial Modelling Special Report. London:  
  • Swan, Jonathan (2008). Practical Financial Modelling, 2nd Edition. London:  
  • Tham, Joseph; Ignacio Velez-Pareja (2004). Principles of Cash Flow Valuation: An Integrated Market-Based Approach. Amsterdam:  
  • Tjia, John (2003). Building Financial Models. New York:  

Quantitative finance

  • Brooks, Robert (2000). Building Financial Derivatives Applications with C++.  
  • Clewlow, Les; Chris Strickland (1998). Implementing Derivative Models. New Jersey:  
  • Duffy, Daniel (2004). Financial Instrument Pricing Using C++. New Jersey: Wiley.  
  • Fabozzi, Frank J.; Sergio M. Focardi; Petter N. Kolm (2004). Financial Modeling of the Equity Market: From CAPM to Cointegration. Hoboken, NJ:  
  • Fusai, Gianluca; Andrea Roncoroni (2008). Implementing Models in Quantitative Finance: Methods and Cases. London:  
  • Jackson, Mary; Mike Staunton (2001). Advanced modelling in finance using Excel and VBA. New Jersey:  
  • Jondeau, Eric; Ser-Huang Poon; Michael Rockinger (2007). Financial Modeling Under Non-Gaussian Distributions. London:  
  • Kwok, Yue-Kuen (2008). Mathematical Models of Financial Derivatives, 2nd edition. London: Springer Finance.  
  • Levy, George (2004). Computational Finance: Numerical Methods for Pricing Financial Instruments.  
  • London, Justin (2004). Modeling Derivatives in C++. New Jersey: Wiley.  
  • Löeffler, G; Posch, P. (2011). Credit Risk Modeling using Excel and VBA. Hoboken, NJ: Wiley.  
  • Rouah, Fabrice Douglas; Gregory Vainberg (2007). Option Pricing Models and Volatility Using Excel-VBA. New Jersey:  
  • Vladimirou, Hercules (2007). Financial Modeling (Volume 151 of Annals of operations research). Norwell, MA:  
  • Mantegna, Rosario N.; Kertesz, Janos (2010). "Focus on Statistical Physics Modelling in Economics and Finance".  

Selected bibliography

  1. ^ a b
  2. ^ Nick Crawley (2010). Which industry sector would benefit the most from improved financial modelling standards?,
  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.   §39 "Corporate Planning Models". See also, §294 "Simulation Model".
  4. ^ See for example, Valuing Companies by Cash Flow Discounting: Ten Methods and Nine Theories, Pablo Fernandez: University of Navarra - IESE Business School
  5. ^ Danielle Stein Fairhurst (2009). Six reasons your spreadsheet is NOT a financial model,
  6. ^ a b Best Practice, European Spreadsheet Risks Interest Group
  7. ^ Krishna G. Palepu; Paul M. Healy; Erik Peek; Victor Lewis Bernard (2007). Business analysis and valuation: text and cases. Cengage Learning EMEA. pp. 261–.  
  8. ^ Richard A. Brealey; Stewart C. Myers; Brattle Group (2003). Capital investment and valuation. McGraw-Hill Professional. pp. 223–.  
  9. ^ Peter Coffee (2004). Spreadsheets: 25 Years in a Cell, eWeek.
  10. ^
  11. ^
  12. ^ 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.
  13. ^ Loren Gary (2003). Why Budgeting Kills Your Company, Harvard Management Update, May 2003.
  14. ^ Michael Jensen (2001). Corporate Budgeting Is Broken, Let's Fix It, Harvard Business Review, pp. 94-101, November 2001.
  15. ^ ModelOff, Financial Modeling World Championships. "ModelOff 2015 Financial Modeling World Championships". 
  16. ^ a b c Mark S. Joshi, On Becoming a Quant.
  17. ^ Riccardo Rebonato (N.D.). Theory and Practice of Model Risk Management.
  18. ^
  19. ^


See also

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 mathematical- and statistical modeling may be applied to finance at all, at least with the assumptions usually made (for options; for portfolios). In fact, these may go so far as to question the "empirical and scientific validity... of modern financial theory".[18] Notable here are Nassim Taleb and Benoit Mandelbrot.[19] See also Mathematical finance #Criticism and Financial economics #Challenges and criticism.

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.[17]

Although spreadsheets are widely used here also (almost always requiring extensive VBA), custom C++ or numerical analysis software such as MATLAB is often preferred,[16] particularly where stability or speed is a concern. MATLAB is the tool of choice for doing economics research 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. 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.[16]

Modellers are generally referred to as "quants" (quantitative analysts), and typically have advanced (Ph.D. level) backgrounds in quantitative disciplines such as 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,[16] such as the Master of Quantitative Finance, or the more specialized Master of Computational Finance or Master of Financial Engineering; the CQF is increasingly common.

These problems are often 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, while specific techniques are listed under Outline of finance# Mathematical tools. For further discussion here see also: Financial models with long-tailed distributions and volatility clustering; Brownian model of financial markets; Martingale pricing; Extreme value theory; Historical simulation (finance).

Applications include:

In quantitative finance, financial modeling entails the development of a sophisticated mathematical model. Models here deal with asset prices, market movements, portfolio returns and the like. A key distinction is between models of the financial situation of a large, complex firm or "quantitative financial management", models of the returns of different stocks or "quantitative asset pricing", models of the price or returns of derivative securities or "financial engineering" and models of the firm's financial decisions or "quantitative corporate finance".

Quantitative finance

The Financial Modeling World Championships, known as ModelOff, have been held since 2012. ModelOff is a global online financial modeling competition which culminates in a Live Finals Event for top competitors. From 2012-2014 the Live Finals were held in New York City and in 2015 they will be held in London.[15]


This article was sourced from Creative Commons Attribution-ShareAlike License; additional terms may apply. World Heritage Encyclopedia content is assembled from numerous content providers, Open Access Publishing, and in compliance with The Fair Access to Science and Technology Research Act (FASTR), Wikimedia Foundation, Inc., Public Library of Science, The Encyclopedia of Life, Open Book Publishers (OBP), PubMed, U.S. National Library of Medicine, National Center for Biotechnology Information, U.S. National Library of Medicine, National Institutes of Health (NIH), U.S. Department of Health & Human Services, and, which sources content from all federal, state, local, tribal, and territorial government publication portals (.gov, .mil, .edu). Funding for and content contributors is made possible from the U.S. Congress, E-Government Act of 2002.
Crowd sourced content that is contributed to World Heritage Encyclopedia is peer reviewed and edited by our editorial staff to ensure quality scholarly research articles.
By using this site, you agree to the Terms of Use and Privacy Policy. World Heritage Encyclopedia™ is a registered trademark of the World Public Library Association, a non-profit organization.

Copyright © World Library Foundation. All rights reserved. eBooks from World Library are sponsored by the World Library Foundation,
a 501c(4) Member's Support Non-Profit Organization, and is NOT affiliated with any governmental agency or department.